The World Bank's international debt data

SELECT * FROM 'international_debt.csv'

country_nameobject

Albania1.1%

Cameroon1.1%

122 others97.9%

country_codeobject

ALB1.1%

CMR1.1%

122 others97.9%

Afghanistan

AFG

Afghanistan

AFG

Afghanistan

AFG

Afghanistan

AFG

Afghanistan

AFG

Afghanistan

AFG

Afghanistan

AFG

Afghanistan

AFG

Afghanistan

AFG

Afghanistan

AFG

SELECT COUNT(DISTINCT country_name) AS total_distinct_countries FROM df_1;

total_distinct_countriesint64

124

SELECT DISTINCT indicator_code as distinct_debt_indicators FROM df_1 ORDER BY distinct_debt_indicators;

distinct_debt_indicatorsobject

DT.AMT.BLAT.CD4%

DT.AMT.DLXF.CD4%

23 others92%

DT.AMT.BLAT.CD

DT.AMT.DLXF.CD

DT.AMT.DPNG.CD

DT.AMT.MLAT.CD

DT.AMT.OFFT.CD

DT.AMT.PBND.CD

DT.AMT.PCBK.CD

DT.AMT.PROP.CD

DT.AMT.PRVT.CD

DT.DIS.BLAT.CD

SELECT ROUND(SUM(debt)/1000000, 2) AS total_debt FROM df_1;

total_debtfloat64

3079734.49

SELECT country_name, SUM(debt) AS total_debt FROM df_1 GROUP BY country_name ORDER BY total_debt DESC LIMIT 1;

country_nameobject

total_debtfloat64

China

285793494734

SELECT indicator_code AS debt_indicator, indicator_name, AVG(debt) AS average_debt FROM df_1 GROUP BY debt_indicator, indicator_name ORDER BY average_debt DESC LIMIT 10;

debt_indicatorobject

DT.AMT.DLXF.CD10%

DT.AMT.DPNG.CD10%

8 others80%

indicator_nameobject

Principal repayments on external debt, long-term (AMT, current US$)10%

Principal repayments on external debt, private nonguaranteed (PNG) (AMT, current US$)10%

8 others80%

DT.AMT.DLXF.CD

Principal repayments on external debt, long-term (AMT, current US$)

DT.AMT.DPNG.CD

Principal repayments on external debt, private nonguaranteed (PNG) (AMT, current US$)

DT.DIS.DLXF.CD

Disbursements on external debt, long-term (DIS, current US$)

DT.DIS.OFFT.CD

PPG, official creditors (DIS, current US$)

DT.AMT.PRVT.CD

PPG, private creditors (AMT, current US$)

DT.INT.DLXF.CD

Interest payments on external debt, long-term (INT, current US$)

DT.DIS.BLAT.CD

PPG, bilateral (DIS, current US$)

DT.INT.DPNG.CD

Interest payments on external debt, private nonguaranteed (PNG) (INT, current US$)

DT.AMT.OFFT.CD

PPG, official creditors (AMT, current US$)

DT.AMT.PBND.CD

PPG, bonds (AMT, current US$)

SELECT country_name, indicator_name FROM df_1 WHERE debt = (SELECT MAX(debt) FROM df_1 WHERE indicator_code='DT.AMT.DLXF.CD');

country_nameobject

indicator_nameobject

China

Principal repayments on external debt, long-term (AMT, current US$)

SELECT indicator_code, COUNT(indicator_code) AS indicator_count FROM df_1 GROUP BY indicator_code ORDER BY indicator_count DESC, indicator_code DESC LIMIT 20;

indicator_codeobject

DT.INT.OFFT.CD5%

DT.INT.MLAT.CD5%

18 others90%

indicator_countint64

69 - 124

DT.INT.OFFT.CD

124

DT.INT.MLAT.CD

124

DT.INT.DLXF.CD

124

DT.AMT.OFFT.CD

124

DT.AMT.MLAT.CD

124

DT.AMT.DLXF.CD

124

DT.DIS.DLXF.CD

123

DT.INT.BLAT.CD

122

DT.DIS.OFFT.CD

122

DT.AMT.BLAT.CD

122

SELECT country_name, MAX(debt) AS maximun_debt FROM df_1 GROUP BY country_name ORDER BY maximun_debt DESC LIMIT 10;

country_nameobject

China10%

Brazil10%

8 others80%

maximun_debtfloat64

27482093686.4 - 96218620835.7

China

96218620836

Brazil

90041840304

Russian Federation

66589761834

Turkey

51555031006

South Asia

48756295898

Least developed countries: UN classification

40160766262

IDA only

34531188113

India

31923507001

Indonesia

30916112654

Kazakhstan

27482093686