Debt Transparency Aggregates
OECD dataset from agency OECD.DAF: DSD_DEBT_TRANS_DDOWN@DF_DDOWN (2019 - 2070)
@oecd.oecd_daf_dsd_debt_trans_ddown_df_ddown_v1_0
OECD dataset from agency OECD.DAF: DSD_DEBT_TRANS_DDOWN@DF_DDOWN (2019 - 2070)
@oecd.oecd_daf_dsd_debt_trans_ddown_df_ddown_v1_0
The aggregates include two measures of debt data. Gross debt outstanding (USD) comprises the internally calculated outstanding debt by country in US Dollars, while Gross amount of new financing includes the countries’ new financing amount for each year. The aggregates reflect the data available to the OECD and do not intend to reflect exactly the debt situation of the countries included. By clicking on the chosen datapoint, users will be able to see the underlying transactions constituting the aggregates.
CREATE TABLE observations (
"dataflow" VARCHAR,
"dd_id" VARCHAR,
"ref_area" VARCHAR,
"recipient_type" VARCHAR,
"fin_type" VARCHAR,
"currency" VARCHAR,
"interest_rate" VARCHAR,
"interest_rate_type" VARCHAR,
"measure" VARCHAR,
"dd_dim" VARCHAR,
"claim_rank" VARCHAR,
"time_period" BIGINT,
"obs_value" DOUBLE,
"recipient" VARCHAR,
"credit_prov" VARCHAR,
"lead_prov" VARCHAR,
"currency_multi" VARCHAR,
"ref_rate_benchmark" VARCHAR,
"orig_curr_value" DOUBLE,
"grace_period" DOUBLE,
"trans_repay" VARCHAR,
"freq" VARCHAR,
"repay_profile_time" VARCHAR,
"repo_coll" VARCHAR,
"fin_purpose" VARCHAR,
"guarantor_name" VARCHAR,
"guarantor_benef" VARCHAR,
"fin_doc_law" VARCHAR,
"waiver_immun" VARCHAR,
"dispute_res_mech" VARCHAR,
"embargo_time" VARCHAR,
"data_avail" VARCHAR,
"isin" VARCHAR,
"yield_maturity" DOUBLE,
"price_issuance" DOUBLE,
"def_event_cond" VARCHAR,
"trans_insur" VARCHAR,
"sustainability" VARCHAR
);Anyone who has the link will be able to view this.