资源简介:
This dataset contains tables used to create some of the royalty free charts hosted on https://dealcharts.org. These tables are the result of transformations on larger datasets and contain only the data necessary to re-create the specific chart visualizations.
Tables will be added to this dataset over time.
Table: EDGAR_ABS_CMBS_DELINQUENCIES
Sourced from Schedule AL data from Edgar Form ABS-EE filings for 260+ CMBS deals across 9,500+ filings (monthly). The earliest reported period is 2016-11-07. The dataset is updated daily to capture all future ABS-EE filings as they are published in Edgar.
This table powers the 30/60/90 day delinquence charts for cmbs deals.
Sample - https://dealcharts.org/capitalmarkets/abs/cmbs/cd2017-cd4/delinquencies/
Schema:
DEAL_NAME_SHORT VARCHAR
REPORTINGPERIODENDINGDATE DATE
DQ_STATUS VARCHAR
NUMLOANS NUMBER
TOTALOUTSTANDING NUMBER
Table: EDGAR_ABS_AUTOLOAN_DELINQUENCIES
Sourced from Schedule AL data from Edgar Form ABS-EE filings for 280+ ABS AutoLoan deals across 9,000+ filings (monthly). The earliest reported period is 2017-01-13. The dataset is updated daily to capture all future ABS-EE filings as they are published in Edgar.
This table powers the 30/60/90 day delinquence charts for abs auto deals.
Sample - https://dealcharts.org/capitalmarkets/abs/autoloan/drive2019-4/delinquencies/
Schema:
DEAL_NAME VARCHAR
DEAL_NAME_SHORT VARCHAR
REPORTINGPERIODBEGINNINGDATE DATE
REPORTINGPERIODENDINGDATE DATE
OUTSTANDING NUMBER
DQ_STATUS VARCHAR
Table: EDGAR_CMBS_COLLATERAL_DISTRIBUTION
Sourced from Schedule AL data from Edgar Form ABS-EE filings for 260+ CMBS deals across 9,500+ filings (monthly). The earliest reported period is 2016-11-07. The dataset is updated daily to capture all future ABS-EE filings as they are published in Edgar.
This table powers the collateral distribution charts.
Sample - https://dealcharts.org/capitalmarkets/abs/cmbs/bank2021-bnk35/collateral/multifamily
Schema:
DEAL_NAME VARCHAR
DEAL_SHORT_NAME VARCHAR
VINTAGE VARCHAR
FILING_DATE DATE
TOTAL_LOANS NUMBER(18,0)
TOTAL_OUTSTANDING FLOAT
MF_CNT NUMBER(13,0)
MF_VALUE NUMBER(30,5)
MF_PCT FLOAT
OF_CNT NUMBER(13,0)
OF_VALUE NUMBER(30,5)
OF_PCT FLOAT
RT_CNT NUMBER(13,0)
RT_VALUE NUMBER(30,5)
RT_PCT FLOAT
MU_CNT NUMBER(13,0)
MU_VALUE NUMBER(30,5)
MU_PCT FLOAT
SS_CNT NUMBER(13,0)
SS_VALUE NUMBER(30,5)
SS_PCT FLOAT
LO_CNT NUMBER(13,0)
LO_VALUE NUMBER(30,5)
LO_PCT FLOAT
IN_CNT NUMBER(13,0)
IN_VALUE NUMBER(30,5)
IN_PCT FLOAT