About this Dataset

Historical Public Debt (HPD)

The Historical Public Debt Database contains unbalanced panel data on Gross Domestic Product, Gross Government Debt, and Debt to GDP Ratio for 187 countries. The series spans the years 1800 through 2015 although each country’s data depends on its date of independence and data availability.

Last updated: 2025-03-31T19:17:04.799278900Z.

Tables

CodeList CL COUNTRY

@imf.hpd.codes_cl_country

5.86 kB
191 rows
2 columns

CREATE TABLE codes_cl_country (
  "code" VARCHAR,
  "description" VARCHAR
);

CodeList CL FREQ

@imf.hpd.codes_cl_freq

2.16 kB
1 row
2 columns

CREATE TABLE codes_cl_freq (
  "code" VARCHAR,
  "description" VARCHAR
);

Indicators

@imf.hpd.indicators

6.61 kB
1 row
8 columns

CREATE TABLE indicators (
  "indicator" VARCHAR,
  "series_name" VARCHAR,
  "unit" VARCHAR,
  "transformation" VARCHAR,
  "http_www_w3_org_2001_xmlschema_instance_type" VARCHAR,
  "gfs_sto" VARCHAR,
  "sector" VARCHAR,
  "keywords" BIGINT
);

Observations

@imf.hpd.observations

51.11 kB
4,524 rows
5 columns

CREATE TABLE observations (
  "country" VARCHAR,
  "indicator" VARCHAR,
  "frequency" VARCHAR,
  "time_period" BIGINT,
  "value" DOUBLE
);