About this Dataset

Debt Transparency Individual Transactions

The data shows the individual transactions’ level data that is also used for the aggregate measures. The amount shown is in US dollars. More information on the transaction can be seen on the asterisk on the right and the download of all data is possible by downloading the unfiltered data (CSV). The DD ID is an internal measure to identify the transactions.

Tables

Observations

@oecd.oecd_daf_dsd_debt_trans_coll_df_micro_v1_0.observations

33.77 kB
54 rows
36 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "dd_id" BIGINT,
  "ref_area" VARCHAR,
  "recipient_type" VARCHAR,
  "fin_type" VARCHAR,
  "currency" VARCHAR,
  "interest_rate" VARCHAR,
  "interest_rate_type" VARCHAR,
  "claim_rank" VARCHAR,
  "time_period" TIMESTAMP,
  "obs_value" BIGINT,
  "recipient" VARCHAR,
  "credit_prov" VARCHAR,
  "lead_prov" VARCHAR,
  "currency_multi" VARCHAR,
  "ref_rate_benchmark" VARCHAR,
  "orig_curr_value" BIGINT,
  "grace_period" DOUBLE,
  "trans_repay" VARCHAR,
  "freq" VARCHAR,
  "repay_profile_time" TIMESTAMP,
  "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
);