International Debt Statistics Jan 2022
International Debt Statistics, successor to Global Development Finance
@kaggle.meetnagadia_international_debt_statistics_jan_2022
International Debt Statistics, successor to Global Development Finance
@kaggle.meetnagadia_international_debt_statistics_jan_2022
country_nameCountry Name | country_codeCountry Code | counterpart_area_nameCounterpart-Area Name | counterpart_area_codeCounterpart-Area Code | series_nameSeries Name | series_codeSeries Code | n_19701970 | n_19711971 | n_19721972 | n_19731973 | n_19741974 | n_19751975 | n_19761976 | n_19771977 | n_19781978 | n_19791979 | n_19801980 | n_19811981 | n_19821982 | n_19831983 | n_19841984 | n_19851985 | n_19861986 | n_19871987 | n_19881988 | n_19891989 | n_19901990 | n_19911991 | n_19921992 | n_19931993 | n_19941994 | n_19951995 | n_19961996 | n_19971997 | n_19981998 | n_19991999 | n_20002000 | n_20012001 | n_20022002 | n_20032003 | n_20042004 | n_20052005 | n_20062006 | n_20072007 | n_20082008 | n_20092009 | n_20102010 | n_20112011 | n_20122012 | n_20132013 | n_20142014 | n_20152015 | n_20162016 | n_20172017 | n_20182018 | n_20192019 | n_20202020 | n_20212021 | n_20222022 | n_20232023 | n_20242024 | n_20252025 | n_20262026 | n_20272027 | n_20282028 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Afghanistan | AFG | World | WLD | Average grace period on new external debt commitments (years) | DT.GPA.DPPG | 10.25 | 8.0833 | 9.9575 | 7.8333 | 29.8333 | 19.8356 | 17.9041 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average grace period on new external debt commitments, official (years) | DT.GPA.OFFT | 10.25 | 8.0833 | 9.9575 | 7.8333 | 29.8333 | 19.8356 | 17.9041 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average grace period on new external debt commitments, private (years) | DT.GPA.PRVT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average grant element on new external debt commitments (%) | DT.GRE.DPPG | 50.6176 | 43.0248 | 58.0061 | 21.2119 | 81.9289 | 64.2646 | 73.079 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average grant element on new external debt commitments, official (%) | DT.GRE.OFFT | 50.6176 | 43.0248 | 58.0061 | 21.2119 | 81.9289 | 64.2646 | 73.079 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average grant element on new external debt commitments, private (%) | DT.GRE.PRVT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average interest on new external debt commitments (%) | DT.INR.DPPG | 1.2496 | 1.3852 | 0.4823 | 2.9999 | 0.5705 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average interest on new external debt commitments, official (%) | DT.INR.OFFT | 1.2496 | 1.3852 | 0.4823 | 2.9999 | 0.5705 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average interest on new external debt commitments, private (%) | DT.INR.PRVT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Afghanistan | AFG | World | WLD | Average maturity on new external debt commitments (years) | DT.MAT.DPPG | 39.75 | 31.5833 | 34.6338 | 25.3333 | 39.9999 | 35.6347 | 39.8333 |
CREATE TABLE ids_allcountries_data (
"country_name" VARCHAR,
"country_code" VARCHAR,
"counterpart_area_name" VARCHAR,
"counterpart_area_code" VARCHAR,
"series_name" VARCHAR,
"series_code" VARCHAR,
"n_1970" DOUBLE,
"n_1971" DOUBLE,
"n_1972" DOUBLE,
"n_1973" DOUBLE,
"n_1974" DOUBLE,
"n_1975" DOUBLE,
"n_1976" DOUBLE,
"n_1977" DOUBLE,
"n_1978" DOUBLE,
"n_1979" DOUBLE,
"n_1980" DOUBLE,
"n_1981" DOUBLE,
"n_1982" DOUBLE,
"n_1983" DOUBLE,
"n_1984" DOUBLE,
"n_1985" DOUBLE,
"n_1986" DOUBLE,
"n_1987" DOUBLE,
"n_1988" DOUBLE,
"n_1989" DOUBLE,
"n_1990" DOUBLE,
"n_1991" DOUBLE,
"n_1992" DOUBLE,
"n_1993" DOUBLE,
"n_1994" DOUBLE,
"n_1995" DOUBLE,
"n_1996" DOUBLE,
"n_1997" DOUBLE,
"n_1998" DOUBLE,
"n_1999" DOUBLE,
"n_2000" DOUBLE,
"n_2001" DOUBLE,
"n_2002" DOUBLE,
"n_2003" DOUBLE,
"n_2004" DOUBLE,
"n_2005" DOUBLE,
"n_2006" DOUBLE,
"n_2007" DOUBLE,
"n_2008" DOUBLE,
"n_2009" DOUBLE,
"n_2010" DOUBLE,
"n_2011" DOUBLE,
"n_2012" DOUBLE,
"n_2013" DOUBLE,
"n_2014" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE
);
Anyone who has the link will be able to view this.