Chapter 3 Data transformation
3.1 EIA Data
3.1.1 Corrections
There were several issues with the EIA data. The clean version of the data can be found here. First, the state name read in as “USA-
## [1] "USA-AL" "USA-AK" "USA-AZ" "USA-AR" "USA-CA"We updated this column by splitting on the “-” delimiter and only keeping the actual state name.
## [1] "AL" "AK" "AZ" "AR" "CA"Other formatting issues existed with the fuel type. There was white space at the start and end of each fuel and some fuels had a space in the middle of it (i.e. natural gas ) which is shown below.
## [1] " coal " " petroleum liquids " " petroleum coke "
## [4] " natural gas " " other gases "To make these variables easier to work with, we trimmed the white space at the beginning and end of the fuels and added an underscore if there was a space in the middle of the fuel type. A sample of the updated fuels is shown below:
## [1] "coal" "petroleum_liquids" "petroleum_coke"
## [4] "natural_gas" "other_gases"The “date” column of the data was imported as a character column, so we updated it to be a date datatype.
Lastly, there was an issue where the solar generation total was not aggregated correctly on the EIA website. This is detailed more in the missing values chapter. To fix this, we performed a pivot on the data and recalculated the aggregation, ignoring N/a’s in the data. We also imputed zero for other values of the power generation so that aggregations were not affected in later code.
3.1.2 Create interactive data
The data needed to be transformed for the interactive component of this project. The data is wrangled to create dataframes (listed as d2001.csv - d2021.csv) that contain the renewable percent of total generation for each state for each year as shown below. As mentioned in the data introduction, the total power generation is the aggregate of coal, petroleum_liquids, petroleum_coke, natural_gas, other_gases, nuclear, conventional_hydroelectric, other, and other_renewables_(total) fuel types. Additionally, the renewables value is the sum of the conventional_hydroelectric and other_renewables_(total) fuels. After performing these aggregations, the percent of renewables was found by dividing the aggregate renewables by the total power generation for each state on each date.
## # A tibble: 5 × 3
## # Groups: state, year [5]
## state year renewables
## <chr> <dbl> <dbl>
## 1 AK 2001 20.0
## 2 AK 2002 21.4
## 3 AK 2003 25.1
## 4 AK 2004 23.1
## 5 AK 2005 22.33.2 WB Data
3.2.1 Cleaning Data
The worldbank dataset contains extra columns that are of not any use for the purpose of this project such as the ‘country name’, ‘country code’, and ‘series code’. This is because we are looking at only one country and the ‘Series Name’ represents the same information series code would represent. It should also be noted that the column names for the years are redundantly long and it repeats the same things. The missing cells in the dataframe are filling with a string and they need to be replaced by NA so that they appear as missing data. The table below shows the raw data before any processing.| Country Name | Country Code | Series Name | Series Code | 1960 [YR1960] | 1961 [YR1961] | 1962 [YR1962] | 1963 [YR1963] | 1964 [YR1964] | 1965 [YR1965] | 1966 [YR1966] | 1967 [YR1967] | 1968 [YR1968] | 1969 [YR1969] | 1970 [YR1970] | 1971 [YR1971] | 1972 [YR1972] | 1974 [YR1974] | 1975 [YR1975] | 1976 [YR1976] | 1977 [YR1977] | 1978 [YR1978] | 1979 [YR1979] | 1980 [YR1980] | 1981 [YR1981] | 1982 [YR1982] | 1983 [YR1983] | 1984 [YR1984] | 1985 [YR1985] | 1986 [YR1986] | 1987 [YR1987] | 1988 [YR1988] | 1990 [YR1990] | 1991 [YR1991] | 1992 [YR1992] | 1993 [YR1993] | 1994 [YR1994] | 1995 [YR1995] | 1996 [YR1996] | 1997 [YR1997] | 1998 [YR1998] | 1999 [YR1999] | 2000 [YR2000] | 2001 [YR2001] | 2002 [YR2002] | 2003 [YR2003] | 2004 [YR2004] | 2005 [YR2005] | 2006 [YR2006] | 2007 [YR2007] | 2008 [YR2008] | 2009 [YR2009] | 2010 [YR2010] | 2011 [YR2011] | 2012 [YR2012] | 2013 [YR2013] | 2014 [YR2014] | 2015 [YR2015] | 2016 [YR2016] | 2017 [YR2017] | 2018 [YR2018] | 2019 [YR2019] | 2020 [YR2020] |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| United States | USA | Population, total | SP.POP.TOTL | 180671000 | 183691000 | 186538000 | 189242000 | 191889000 | 194303000 | 196560000 | 198712000 | 200706000 | 202677000 | 205052000 | 207661000 | 209896000 | 213854000 | 215973000 | 218035000 | 220239000 | 222585000 | 225055000 | 227225000 | 229466000 | 231664000 | 233792000 | 235825000 | 237924000 | 240133000 | 242289000 | 244499000 | 249623000 | 252981000 | 256514000 | 259919000 | 263126000 | 266278000 | 269394000 | 272657000 | 275854000 | 279040000 | 282162411 | 284968955 | 287625193 | 290107933 | 292805298 | 295516599 | 298379912 | 301231207 | 304093966 | 306771529 | 309327143 | 311583481 | 313877662 | 316059947 | 318386329 | 320738994 | 323071755 | 325122128 | 326838199 | 328329953 | 329484123 |
| United States | USA | Population growth (annual %) | SP.POP.GROW | .. | 1.65773003738953 | 1.53799735825387 | 1.43916476170683 | 1.38904605518369 | 1.25017164562845 | 1.1548931907552 | 1.08888120728762 | 0.998461043585335 | 0.977242811872469 | 1.16500266687286 | 1.26433369185094 | 1.07052275237269 | 0.913660196067714 | 0.985986067347125 | 0.950220048994522 | 1.00577199618134 | 1.0595730803427 | 1.10357656509899 | 0.959589922764484 | 0.981415437259678 | 0.953317566163514 | 0.914378513375149 | 0.865817336309961 | 0.886129040850881 | 0.924164157058979 | 0.893829201032046 | 0.907999040167679 | 1.12965052045579 | 1.33626074073779 | 1.38688569247935 | 1.31867999977741 | 1.2262960888682 | 1.19078709090209 | 1.16341161998189 | 1.20396029701272 | 1.16571452642589 | 1.14834004729055 | 1.11276899679534 | 0.989741382223669 | 0.927797485710314 | 0.859481712840946 | 0.925483968943482 | 0.921713167161207 | 0.964253917136075 | 0.951055242772428 | 0.945865287282592 | 0.876651298802912 | 0.829616674709795 | 0.726786704810745 | 0.733599941250847 | 0.692860276624581 | 0.733361519937424 | 0.73621730882542 | 0.724676067451429 | 0.63264399508256 | 0.526435395564053 | 0.455381285963537 | 0.350911063312921 |
| United States | USA | Surface area (sq. km) | AG.SRF.TOTL.K2 | .. | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9632030 | 9632030 | 9632030 | 9632030 | 9632030 | 9632030 | 9632030 | 9632030 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | .. | .. |
| United States | USA | Poverty headcount ratio at national poverty lines (% of population) | SI.POV.NAHC | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. |
| United States | USA | GNI, Atlas method (current US\() </td> <td style="text-align:left;"> NY.GNP.ATLS.CD </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 612178550047.646 </td> <td style="text-align:left;"> 646233886826.649 </td> <td style="text-align:left;"> 692328219512.945 </td> <td style="text-align:left;"> 753294530375.941 </td> <td style="text-align:left;"> 824183577234.192 </td> <td style="text-align:left;"> 868295290971.962 </td> <td style="text-align:left;"> 952033980993.25 </td> <td style="text-align:left;"> 1027990251284.03 </td> <td style="text-align:left;"> 1072448453507.45 </td> <td style="text-align:left;"> 1167480039466.91 </td> <td style="text-align:left;"> 1317546984924.22 </td> <td style="text-align:left;"> 1707501119349 </td> <td style="text-align:left;"> 1837615687390.46 </td> <td style="text-align:left;"> 1954015548092.42 </td> <td style="text-align:left;"> 2112844663408.78 </td> <td style="text-align:left;"> 2395599972497.01 </td> <td style="text-align:left;"> 2745654917682.8 </td> <td style="text-align:left;"> 3041381894522.09 </td> <td style="text-align:left;"> 3295801022048.11 </td> <td style="text-align:left;"> 3293708060750.23 </td> <td style="text-align:left;"> 3405705063552.51 </td> <td style="text-align:left;"> 3821673418720.91 </td> <td style="text-align:left;"> 4154713915158.9 </td> <td style="text-align:left;"> 4588118207264.57 </td> <td style="text-align:left;"> 5183358426016.12 </td> <td style="text-align:left;"> 5744106447459.67 </td> <td style="text-align:left;"> 6006223931957.56 </td> <td style="text-align:left;"> 6140655897369.37 </td> <td style="text-align:left;"> 6587044223797.61 </td> <td style="text-align:left;"> 6858427053464.97 </td> <td style="text-align:left;"> 7276716882339.8 </td> <td style="text-align:left;"> 7731970449419.26 </td> <td style="text-align:left;"> 8154321495043.69 </td> <td style="text-align:left;"> 8523424738060.54 </td> <td style="text-align:left;"> 8833879985673.72 </td> <td style="text-align:left;"> 9394486467207.9 </td> <td style="text-align:left;"> 10147418121466.8 </td> <td style="text-align:left;"> 10462196419348.3 </td> <td style="text-align:left;"> 10732734658356.8 </td> <td style="text-align:left;"> 11536230254896.2 </td> <td style="text-align:left;"> 12740785534277.4 </td> <td style="text-align:left;"> 13648863758032.1 </td> <td style="text-align:left;"> 14284922398497.8 </td> <td style="text-align:left;"> 14608595029795.9 </td> <td style="text-align:left;"> 14895016620356.4 </td> <td style="text-align:left;"> 14645979981358.2 </td> <td style="text-align:left;"> 15155236576389.4 </td> <td style="text-align:left;"> 15760432948941.8 </td> <td style="text-align:left;"> 16558980098151.8 </td> <td style="text-align:left;"> 17045588721150.3 </td> <td style="text-align:left;"> 17778918029582.5 </td> <td style="text-align:left;"> 18200095600169.3 </td> <td style="text-align:left;"> 18503587290169 </td> <td style="text-align:left;"> 19332396438379.9 </td> <td style="text-align:left;"> 20758598149749.8 </td> <td style="text-align:left;"> 21640511015447.7 </td> <td style="text-align:left;"> 21261603638417.8 </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> GNI per capita, Atlas method (current US\)) | NY.GNP.PCAP.CD | .. | .. | 3280 | 3410 | 3610 | 3880 | 4190 | 4370 | 4740 | 5070 | 5230 | 5620 | 6280 | 7980 | 8510 | 8960 | 9590 | 10760 | 12200 | 13380 | 14360 | 14220 | 14570 | 16210 | 17460 | 19110 | 21390 | 23490 | 24060 | 24270 | 25680 | 26390 | 27650 | 29040 | 30270 | 31260 | 32020 | 33670 | 35960 | 36710 | 37320 | 39770 | 43510 | 46190 | 47870 | 48500 | 48980 | 47740 | 48990 | 50580 | 52760 | 53930 | 55840 | 56740 | 57270 | 59460 | 63510 | 65910 | 64530 |
| United States | USA | GNI, PPP (current international \() </td> <td style="text-align:left;"> NY.GNP.MKTP.PP.CD </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 5902290000000 </td> <td style="text-align:left;"> 6096750000000 </td> <td style="text-align:left;"> 6435469000000 </td> <td style="text-align:left;"> 6733768000000 </td> <td style="text-align:left;"> 7170251000000 </td> <td style="text-align:left;"> 7574691000000 </td> <td style="text-align:left;"> 8045907000000 </td> <td style="text-align:left;"> 8589268000000 </td> <td style="text-align:left;"> 9135464000000 </td> <td style="text-align:left;"> 9689354000000 </td> <td style="text-align:left;"> 10383859000000 </td> <td style="text-align:left;"> 10743709000000 </td> <td style="text-align:left;"> 11054325000000 </td> <td style="text-align:left;"> 11530268000000 </td> <td style="text-align:left;"> 12313988000000 </td> <td style="text-align:left;"> 13169702000000 </td> <td style="text-align:left;"> 14072966000000 </td> <td style="text-align:left;"> 14543216000000 </td> <td style="text-align:left;"> 14684602000000 </td> <td style="text-align:left;"> 14398708000000 </td> <td style="text-align:left;"> 15126736000000 </td> <td style="text-align:left;"> 15832207000000 </td> <td style="text-align:left;"> 16670651000000 </td> <td style="text-align:left;"> 17175898000000 </td> <td style="text-align:left;"> 18057489000000 </td> <td style="text-align:left;"> 18704317000000 </td> <td style="text-align:left;"> 19045164000000 </td> <td style="text-align:left;"> 19830277000000.1 </td> <td style="text-align:left;"> 20837347000000.1 </td> <td style="text-align:left;"> 21690012900000 </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> GNI per capita, PPP (current international latexacc3c1702ab3fea5fb2480ffe94675fb GDP per cubic meter of total freshwater withdrawal) </td> <td style="text-align:left;"> ER.GDP.FWTL.M3.KD </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 14.0505742476829 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 18.5302069231569 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 21.720697062982 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 25.5912468506528 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 29.6825805172414 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 35.9563579176564 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 39.4976703159136 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 42.7167507028788 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> Energy use (kg of oil equivalent per capita) </td> <td style="text-align:left;"> EG.USE.PCAP.KG.OE </td> <td style="text-align:left;"> 5641.74075529554 </td> <td style="text-align:left;"> 5612.07950307854 </td> <td style="text-align:left;"> 5774.58631485274 </td> <td style="text-align:left;"> 5986.78395387916 </td> <td style="text-align:left;"> 6136.93822991417 </td> <td style="text-align:left;"> 6307.89020241581 </td> <td style="text-align:left;"> 6591.34055759056 </td> <td style="text-align:left;"> 6809.82048391642 </td> <td style="text-align:left;"> 7073.47894930894 </td> <td style="text-align:left;"> 7332.36854699843 </td> <td style="text-align:left;"> 7569.07659520512 </td> <td style="text-align:left;"> 7644.52480244244 </td> <td style="text-align:left;"> 7940.99783225979 </td> <td style="text-align:left;"> 7909.58647956082 </td> <td style="text-align:left;"> 7656.2635792437 </td> <td style="text-align:left;"> 8100.56222166166 </td> <td style="text-align:left;"> 8285.57089797901 </td> <td style="text-align:left;"> 8438.40307747602 </td> <td style="text-align:left;"> 8327.04170536091 </td> <td style="text-align:left;"> 7942.25301793377 </td> <td style="text-align:left;"> 7647.53805356785 </td> <td style="text-align:left;"> 7259.07889874991 </td> <td style="text-align:left;"> 7199.11853271284 </td> <td style="text-align:left;"> 7443.32001696173 </td> <td style="text-align:left;"> 7456.26290328004 </td> <td style="text-align:left;"> 7376.09623833459 </td> <td style="text-align:left;"> 7622.17301652159 </td> <td style="text-align:left;"> 7849.75397036389 </td> <td style="text-align:left;"> 7671.7730657832 </td> <td style="text-align:left;"> 7631.46780588265 </td> <td style="text-align:left;"> 7677.40140109312 </td> <td style="text-align:left;"> 7709.49658932206 </td> <td style="text-align:left;"> 7757.83082249569 </td> <td style="text-align:left;"> 7763.75510556636 </td> <td style="text-align:left;"> 7844.46826581141 </td> <td style="text-align:left;"> 7828.58109639584 </td> <td style="text-align:left;"> 7803.69760452993 </td> <td style="text-align:left;"> 7923.22389263188 </td> <td style="text-align:left;"> 8056.86384994775 </td> <td style="text-align:left;"> 7827.88632537183 </td> <td style="text-align:left;"> 7843.34484914192 </td> <td style="text-align:left;"> 7794.23553026383 </td> <td style="text-align:left;"> 7881.57864206405 </td> <td style="text-align:left;"> 7846.49968849973 </td> <td style="text-align:left;"> 7697.65253500041 </td> <td style="text-align:left;"> 7758.16598577052 </td> <td style="text-align:left;"> 7488.08192070473 </td> <td style="text-align:left;"> 7056.78365282718 </td> <td style="text-align:left;"> 7161.42655156518 </td> <td style="text-align:left;"> 7029.95460147645 </td> <td style="text-align:left;"> 6872.02728367462 </td> <td style="text-align:left;"> 6905.59863316056 </td> <td style="text-align:left;"> 6960.68399657951 </td> <td style="text-align:left;"> 6803.99660728499 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> CO2 emissions (metric tons per capita) </td> <td style="text-align:left;"> EN.ATM.CO2E.PC </td> <td style="text-align:left;"> 15.9997791565885 </td> <td style="text-align:left;"> 15.6812555160569 </td> <td style="text-align:left;"> 16.0139374979897 </td> <td style="text-align:left;"> 16.4827621458239 </td> <td style="text-align:left;"> 16.9681185789701 </td> <td style="text-align:left;"> 17.4517252487095 </td> <td style="text-align:left;"> 18.1210730107855 </td> <td style="text-align:left;"> 18.5983178821611 </td> <td style="text-align:left;"> 19.0893891562783 </td> <td style="text-align:left;"> 19.85794566231 </td> <td style="text-align:left;"> 21.1112522725943 </td> <td style="text-align:left;"> 20.9802034758573 </td> <td style="text-align:left;"> 21.7486419846019 </td> <td style="text-align:left;"> 21.5029303777343 </td> <td style="text-align:left;"> 20.4022240696754 </td> <td style="text-align:left;"> 21.1576153736785 </td> <td style="text-align:left;"> 21.5324840060117 </td> <td style="text-align:left;"> 21.9730046948357 </td> <td style="text-align:left;"> 21.7804369776277 </td> <td style="text-align:left;"> 20.7864877412257 </td> <td style="text-align:left;"> 19.7667641742132 </td> <td style="text-align:left;"> 18.5904952301609 </td> <td style="text-align:left;"> 18.5715437097933 </td> <td style="text-align:left;"> 18.9767502682074 </td> <td style="text-align:left;"> 18.8823127427246 </td> <td style="text-align:left;"> 18.7207227161615 </td> <td style="text-align:left;"> 19.3503344229412 </td> <td style="text-align:left;"> 20.0104134086438 </td> <td style="text-align:left;"> 19.4092291175092 </td> <td style="text-align:left;"> 19.005735608603 </td> <td style="text-align:left;"> 19.0250824516401 </td> <td style="text-align:left;"> 19.2381087954324 </td> <td style="text-align:left;"> 19.2806108100302 </td> <td style="text-align:left;"> 19.2539376140725 </td> <td style="text-align:left;"> 19.6110900762452 </td> <td style="text-align:left;"> 20.3478729686016 </td> <td style="text-align:left;"> 20.266880306249 </td> <td style="text-align:left;"> 20.1057196100917 </td> <td style="text-align:left;"> 20.4719330952981 </td> <td style="text-align:left;"> 20.1750046772639 </td> <td style="text-align:left;"> 19.4494784745785 </td> <td style="text-align:left;"> 19.5087047137039 </td> <td style="text-align:left;"> 19.6035728834387 </td> <td style="text-align:left;"> 19.4780260042178 </td> <td style="text-align:left;"> 18.9576435024889 </td> <td style="text-align:left;"> 19.0560269540732 </td> <td style="text-align:left;"> 18.2948056259689 </td> <td style="text-align:left;"> 16.8188684811099 </td> <td style="text-align:left;"> 17.4341958733314 </td> <td style="text-align:left;"> 16.599403740534 </td> <td style="text-align:left;"> 15.7711446187591 </td> <td style="text-align:left;"> 16.1029578354008 </td> <td style="text-align:left;"> 16.0263790723251 </td> <td style="text-align:left;"> 15.535342110601 </td> <td style="text-align:left;"> 15.1317468158119 </td> <td style="text-align:left;"> 14.8058824221278 </td> <td style="text-align:left;"> 15.2408745833286 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> Electric power consumption (kWh per capita) </td> <td style="text-align:left;"> EG.USE.ELEC.KH.PC </td> <td style="text-align:left;"> 4049.786628734 </td> <td style="text-align:left;"> 4182.17550124938 </td> <td style="text-align:left;"> 4433.60602129325 </td> <td style="text-align:left;"> 4690.48625569377 </td> <td style="text-align:left;"> 4970.44645602406 </td> <td style="text-align:left;"> 5234.68500229024 </td> <td style="text-align:left;"> 5590.33374033374 </td> <td style="text-align:left;"> 5888.34091549579 </td> <td style="text-align:left;"> 6385.45932857015 </td> <td style="text-align:left;"> 6904.83379959245 </td> <td style="text-align:left;"> 7236.65704309151 </td> <td style="text-align:left;"> 7517.30464555213 </td> <td style="text-align:left;"> 8076.40926935244 </td> <td style="text-align:left;"> 8449.92845586241 </td> <td style="text-align:left;"> 8522.39400295407 </td> <td style="text-align:left;"> 8968.7756552847 </td> <td style="text-align:left;"> 9337.72401799863 </td> <td style="text-align:left;"> 9560.5454096188 </td> <td style="text-align:left;"> 9700.69538557242 </td> <td style="text-align:left;"> 9862.36549675432 </td> <td style="text-align:left;"> 9976.69371497302 </td> <td style="text-align:left;"> 9544.46094343532 </td> <td style="text-align:left;"> 9742.00571448125 </td> <td style="text-align:left;"> 10282.3746422135 </td> <td style="text-align:left;"> 10414.2078983205 </td> <td style="text-align:left;"> 10424.4272965398 </td> <td style="text-align:left;"> 10886.8582560496 </td> <td style="text-align:left;"> 11298.3325085174 </td> <td style="text-align:left;"> 11713.3317042099 </td> <td style="text-align:left;"> 12134.1721315039 </td> <td style="text-align:left;"> 12014.9582478929 </td> <td style="text-align:left;"> 12261.5237824091 </td> <td style="text-align:left;"> 12455.1621656545 </td> <td style="text-align:left;"> 12659.607628118 </td> <td style="text-align:left;"> 12854.2989079193 </td> <td style="text-align:left;"> 12889.8322801175 </td> <td style="text-align:left;"> 13154.7630268185 </td> <td style="text-align:left;"> 13281.8699827982 </td> <td style="text-align:left;"> 13671.0520240061 </td> <td style="text-align:left;"> 13046.6141478464 </td> <td style="text-align:left;"> 13296.1822993023 </td> <td style="text-align:left;"> 13307.4920085002 </td> <td style="text-align:left;"> 13388.5897105591 </td> <td style="text-align:left;"> 13704.5770481407 </td> <td style="text-align:left;"> 13583.2669593387 </td> <td style="text-align:left;"> 13657.4528282523 </td> <td style="text-align:left;"> 13663.4279681827 </td> <td style="text-align:left;"> 12913.7146883015 </td> <td style="text-align:left;"> 13394.9027551068 </td> <td style="text-align:left;"> 13245.8819278677 </td> <td style="text-align:left;"> 12964.1879389302 </td> <td style="text-align:left;"> 13004.0235689845 </td> <td style="text-align:left;"> 12993.9655794706 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> GDP (current US\)) | NY.GDP.MKTP.CD | 543300000000 | 563300000000 | 605100000000 | 638600000000 | 685800000000 | 743700000000 | 815000000000 | 861700000000 | 942500000000 | 1019900000000 | 1073303000000 | 1164850000000 | 1279110000000 | 1545243000000 | 1684904000000 | 1873412000000 | 2081826000000 | 2351599000000 | 2627333000000 | 2857307000000 | 3207041000000 | 3343789000000 | 3634038000000 | 4037613000000 | 4338979000000 | 4579631000000 | 4855215000000 | 5236438000000 | 5963144000000 | 6158129000000 | 6520327000000 | 6858559000000 | 7287236000000 | 7639749000000 | 8073122000000 | 8577554457000 | 9062818202000 | 9630664202000 | 10252345464000 | 10581821399000 | 10936419054000 | 11458243878000 | 12213729147000 | 13036640230000 | 13814611414000 | 14451858656000 | 14712844084000 | 14448933025000 | 14992052727000 | 15542581104000 | 16197007349000 | 16784849196000 | 17527163695000 | 18238300569000 | 18745075687000 | 19542979183000 | 20611860934000 | 21433224697000 | 20936600000000 |
| United States | USA | GDP growth (annual %) | NY.GDP.MKTP.KD.ZG | .. | 2.29999999999968 | 6.10000000000012 | 4.39999999999992 | 5.8000000000003 | 6.39999999999976 | 6.50000000000028 | 2.50000000000003 | 4.79999999999959 | 3.09999999999999 | -0.346648733838819 | 3.29335165324265 | 5.2589073310028 | -0.54055166261962 | -0.205456064255458 | 5.38813929310284 | 4.62415306432004 | 5.53530495989784 | 3.16614531077464 | -0.256749676940515 | 2.53771929783902 | -1.80288740691098 | 4.58391336401664 | 7.23663315778187 | 4.16965621486705 | 3.46264597689752 | 3.45925198493917 | 4.17706128382223 | 1.88596495768836 | -0.108264786843066 | 3.52244052251753 | 2.75178104210936 | 4.02879326333235 | 2.68421727485742 | 3.7725655016348 | 4.38177517389286 | 4.48140756104172 | 4.75323598286796 | 4.12748401690885 | 0.998340791805987 | 1.74169525130476 | 2.8612107683238 | 3.79889112471299 | 3.5132137994521 | 2.85497229363445 | 1.87617145415626 | -0.136579803249504 | -2.53675706714202 | 2.5637665603995 | 1.55083550470843 | 2.24954585238848 | 1.84208107064158 | 2.52597344637341 | 3.0755146497898 | 1.71142677366849 | 2.33267939548638 | 2.99646435222829 | 2.16117651518969 | -3.48614040819797 |
| United States | USA | Inflation, GDP deflator (annual %) | NY.GDP.DEFL.KD.ZG | .. | 1.35015389642166 | 1.24463471200144 | 1.08838601136836 | 1.50393967901161 | 1.91982581124751 | 2.89877853468326 | 3.15127936555434 | 4.36718824053682 | 4.9584884495751 | 5.60217016436724 | 5.06916748805631 | 4.32275145745318 | 8.99869462646564 | 9.26261205760063 | 5.50338639985235 | 6.21336667727508 | 7.03383077555833 | 8.29655708788701 | 9.03307690564108 | 9.46214483934116 | 6.17826749673415 | 3.91678718743533 | 3.60770540480202 | 3.1624451696169 | 2.01390148483323 | 2.47281001382842 | 3.52742146520499 | 3.74332973847665 | 3.38176155337062 | 2.27891032683829 | 2.37033960111148 | 2.13542370696524 | 2.09690072576767 | 1.83096786671982 | 1.78816614253974 | 1.12552039639621 | 1.44380352524929 | 2.23547440584899 | 2.1934253449969 | 1.58176300591224 | 1.85709520165997 | 2.6922121263311 | 3.11494234781323 | 3.02620464133297 | 2.68627890903008 | 1.94513170334587 | 0.762349988423779 | 1.16525054364868 | 2.08890377766842 | 1.91784900670304 | 1.75491578501162 | 1.84982747081428 | 0.952531532798019 | 1.04924737000228 | 1.88006787244998 | 2.40098111411591 | 1.78515153743628 | 1.21128887945865 |
| United States | USA | Agriculture, forestry, and fishing, value added (% of GDP) | NV.AGR.TOTL.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 1.33691171038169 | 1.21399691075917 | 1.15118252152304 | 1.15045636546451 | 1.12932550544931 | 0.970430947058331 | 1.11525741955411 | 1.25866007956923 | 1.14225527722491 | 1.00067777411318 | 1.06682214149659 | 1.06578313550216 | 0.968572535825703 | 1.04248133891985 | 1.21648753662505 | 1.15882894880324 | 1.3335136788321 | 1.18557101774133 | 1.04386645169999 | 0.943988879824681 | 0.949806072359055 | 0.920560058150837 | 0.916865221067299 | .. |
| United States | USA | Industry (including construction), value added (% of GDP) | NV.IND.TOTL.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 23.1321011361316 | 22.6705577802122 | 22.5499937953293 | 22.4543862190713 | 21.4739916723102 | 20.6412607714986 | 20.7393072909074 | 20.96034469234 | 21.223491223091 | 21.5938538450445 | 21.4461294271878 | 20.860737478607 | 19.324003503712 | 19.3552915457272 | 19.4169009561953 | 19.1559852455803 | 19.2582012817269 | 19.328829963324 | 18.5445077473325 | 17.9650951867613 | 18.2514054668939 | 18.5278233111914 | 18.1563709661696 | .. |
| United States | USA | Exports of goods and services (% of GDP) | NE.EXP.GNFS.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 5.56310752881526 | 5.40524531055501 | 5.53846033570217 | 8.19612190445127 | 8.23227910907684 | 7.9808926173207 | 7.6542900319239 | 7.947060702101 | 8.75903435156488 | 9.82645547013324 | 9.51777666702733 | 8.46973298853486 | 7.62226481946529 | 7.48907832424752 | 6.98807253964585 | 7.00925467575881 | 7.49591933621889 | 8.49052351999585 | 9.25473206751338 | 9.66090512231881 | 9.70891490564814 | 9.54718039168286 | 9.89314741556332 | 10.639223880261 | 10.7466355642836 | 11.1197545265553 | 10.5152611335588 | 10.3098808054568 | 10.6913194044121 | 9.70354687801701 | 9.12528127417529 | 9.03423780312036 | 9.6314809821122 | 9.98401410974582 | 10.6421379215205 | 11.4815335487045 | 12.4739988374908 | 10.9542621400586 | 12.388210165878 | 13.6133373591048 | 13.6920355236915 | 13.6252698686445 | 13.5641341712248 | 12.4389385481237 | 11.9077139899094 | 12.1975159348969 | 12.2915199559729 | 11.7561731173036 | 10.1420956602314 |
| United States | USA | Imports of goods and services (% of GDP) | NE.IMP.GNFS.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 5.19517787614495 | 5.35193372537237 | 5.80215931389794 | 8.24886441808829 | 7.28409452407971 | 8.067953018343 | 8.76360464323147 | 9.02577352686406 | 9.61712885271871 | 10.2833892192894 | 9.90813650339986 | 9.06707929238358 | 9.04332866084504 | 10.0333290981577 | 9.61583358665714 | 9.88872247567544 | 10.4776616483513 | 10.5795771858657 | 10.5603185165409 | 10.1255430017786 | 10.2416795967442 | 10.4974383102923 | 11.162311746182 | 11.8141577687958 | 11.9404364259576 | 12.3085665651286 | 12.3106298188105 | 13.0049181835236 | 14.4082542398417 | 13.2638696787364 | 13.1462043736716 | 13.5895170025984 | 14.8235152279 | 15.6595715152293 | 16.3350450647717 | 16.5738404797197 | 17.5095378248555 | 13.855189144667 | 15.9388113390004 | 17.342550648208 | 17.097707868676 | 16.4813813201209 | 16.4741144103293 | 15.3240702960585 | 14.6084179425271 | 14.9603137404109 | 15.1839613609922 | 14.5381296750747 | 13.252376221545 |
| United States | USA | Gross capital formation (% of GDP) | NE.GDI.TOTL.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 21.4147356338331 | 21.9198180023179 | 22.580622464057 | 22.6949418311554 | 20.2774757493602 | 22.038398387541 | 23.5262697266726 | 24.8317846707708 | 25.1111298034927 | 23.3102708249411 | 24.2768645614446 | 22.070082771371 | 22.2529868977705 | 25.0958177517261 | 24.1883401602082 | 23.7406245175648 | 23.6202310299338 | 22.827807757869 | 21.5292134484762 | 20.1106050230516 | 20.0775819985715 | 20.39362787431 | 21.2790967659069 | 21.2726491406982 | 21.7018149855781 | 22.4097090800901 | 22.9583331986162 | 23.420368031642 | 23.6751483699321 | 22.1769477249141 | 21.7081385440482 | 21.7422235599583 | 22.6585751713657 | 23.3803031012999 | 23.5391854504464 | 22.592491925905 | 21.1190167058118 | 17.8045811102374 | 18.7431037708356 | 19.1035258566922 | 20.0208898479027 | 20.4137431322085 | 20.806247168447 | 21.1629531238262 | 20.5119577226704 | 20.7222960331595 | 21.0577638472243 | 21.3045496632111 | 21.1083795840776 |
| United States | USA | Revenue, excluding grants (% of GDP) | GC.REV.XGRT.GD.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 16.721783114822 | 17.9661063017273 | 17.3084045144412 | 16.6033953022613 | 17.8357845468353 | 17.7143296965171 | 18.5975664295314 | 19.1047024348451 | 19.9495422727679 | 19.7264241254457 | 17.9777977005194 | 17.7907095107926 | 18.2404662479353 | 17.9724086940629 | 18.7390259751628 | 18.3821521423533 | 18.2058323595741 | 18.1313187820521 | 17.6483480046323 | 18.0456273686645 | 18.2572651688514 | 18.7804599339586 | 18.9521476326011 | 19.4159070437715 | 19.8287106719566 | 19.7831630304827 | 20.573341070162 | 19.5150553211487 | 17.3832978657184 | 16.782446075285 | 16.8515903310788 | 17.9353212081392 | 18.6329026771712 | 18.6888805397959 | 17.7874235943681 | 15.7041408945143 | 16.4716516474936 | 16.6950134127478 | 16.8104189948898 | 18.8714206664118 | 18.9428464169998 | 19.0709736734573 | 18.6504005551952 | 19.4945195628826 | 17.4854304108706 | 17.4547243958285 | 17.640417259727 |
| United States | USA | Start-up procedures to register a business (number) | IC.REG.PROC | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 6 | 6 | 6 | 6 | 6 | 6 | 6 | .. |
| United States | USA | Market capitalization of listed domestic companies (% of GDP) | CM.MKT.LCAP.GD.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 41.7709258212931 | 47.1385899097476 | 40.0724171952891 | 36.6542510011273 | 37.8174711770453 | 47.5901889436452 | 39.3995804855629 | 43.5692922011526 | 49.7802829799798 | 39.6808634210361 | 53.0276339203301 | 55.4180500568714 | 52.1453262110947 | 53.0883913836085 | 51.8761327916951 | 67.5464122300783 | 69.7180371475234 | 76.562432866729 | 70.5032725713837 | 90.9980943091193 | 105.046065202533 | 125.561930897573 | 142.588979630511 | 153.440999395776 | 147.358973154477 | 132.148006214899 | 101.07906386375 | 124.50656315137 | 133.650633099306 | 130.408327376232 | 141.654165387297 | 137.852717039471 | 78.7765962435791 | 104.348782805712 | 115.284090809481 | 100.63133616832 | 115.257916525873 | 143.193741208755 | 150.227325129116 | 137.444492183706 | 145.916725953628 | 164.359294195744 | 147.664071417221 | 158.122859621509 | 194.49032507666 |
| United States | USA | Military expenditure (% of GDP) | MS.MIL.XPND.GD.ZS | 8.99312458715278 | 9.15603150017123 | 9.33167294545842 | 8.83189118618018 | 8.0512811057284 | 7.58724717722602 | 8.43530028594507 | 9.41779593255137 | 9.26845427468793 | 8.63326379509104 | 8.03274358404085 | 6.94306960936061 | 6.51975692434716 | 5.95411119676015 | 5.62267909613336 | 5.19107142902555 | 5.15561735127125 | 4.94308724791688 | 4.95199153527265 | 5.15353746651636 | 5.64654125624258 | 6.81405709441284 | 6.32114425976717 | 6.23641652963897 | 6.4532192046686 | 6.62652265789842 | 6.42027402288488 | 6.0712777020948 | 5.60517529438794 | 4.88342939776313 | 4.97046680768284 | 4.60435029507644 | 4.2152646751779 | 3.8602457917389 | 3.55498220635218 | 3.40556224418855 | 3.20155849896996 | 3.08567678324746 | 3.11224214697679 | 3.12380980266703 | 3.44761809928778 | 3.82716104473623 | 4.01631273640692 | 4.09003487632585 | 4.04162723678969 | 4.0796550810522 | 4.46382735629989 | 4.88559968011478 | 4.92264167706996 | 4.84017399490275 | 4.47740121867267 | 4.04667887867098 | 3.69589465026568 | 3.47784516633609 | 3.41894233677988 | 3.31338129427849 | 3.31624880838269 | 3.42708018052996 | 3.74116009078512 |
| United States | USA | Mobile cellular subscriptions (per 100 people) | IT.CEL.SETS.P2 | 0 | .. | .. | .. | .. | 0 | .. | .. | .. | .. | 0 | .. | .. | .. | 0 | 0 | 0 | 0 | 0 | 0 | .. | .. | .. | 0.038445905 | 0.14146081 | 0.280860174 | 0.502281572 | 0.836569536 | 2.095449994 | 2.96895054 | 4.293056805 | 6.168585393 | 9.203138701 | 12.74143303 | 16.41343526 | 20.35683377 | 25.15099311 | 30.89124914 | 38.86183584 | 45.14982121 | 49.35962707 | 55.42732036 | 63.21739536 | 69.05236638 | 77.10934813 | 82.93180628 | 86.09952013 | 89.5449638 | 92.26777096 | 95.44904589 | 97.06859919 | 98.19768385 | 111.5562164 | 119.1439209 | 122.5945483 | 123.0448345 | 129.0140075 | 134.4588794 | .. |
| United States | USA | High-technology exports (% of manufactured exports) | TX.VAL.TECH.MF.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 30.3732292339219 | 28.8578498098283 | 24.8677741839767 | 23.0014609957313 | 20.9845794757797 | 20.5594043226112 | 20.526846085317 | 20.8607973528068 | 21.7598671248231 | 22.7237471373984 | 19.5199016960383 | 18.7417405398469 | 18.9335479863635 | 19.7523940308825 |
| United States | USA | Merchandise trade (% of GDP) | TG.VAL.TOTL.GD.ZS | 6.62562120375483 | 6.41363394283685 | 6.40456122954883 | 6.4278108362042 | 6.70691163604549 | 6.70794675272287 | 7.00907975460123 | 6.92665660902866 | 7.36477453580902 | 7.41680556917345 | 7.98031869844769 | 7.88865519165558 | 8.44813972215056 | 13.5845947854156 | 12.7447617193621 | 13.3067899639802 | 13.6223200209816 | 14.11350319506 | 15.5514356193143 | 16.8883147663167 | 15.9669614451452 | 14.0955664367578 | 13.085086066794 | 14.1256480004399 | 13.166184948118 | 13.3078844125214 | 13.9760031224158 | 14.9332427883229 | 15.2701158985931 | 15.103499780534 | 15.3686463884403 | 15.5748605501535 | 16.4924259348812 | 17.7439730022544 | 17.9248870511309 | 18.5157903451594 | 17.9468567475078 | 18.2255030721089 | 19.9097660839416 | 18.03356840043 | 17.3121840947336 | 17.6974850735499 | 19.1633118094395 | 20.2029660520899 | 21.3110880340539 | 21.9252213533412 | 23.4959942500808 | 18.4189309715483 | 21.6626706104834 | 24.1178217113198 | 23.968791989464 | 23.2867924778941 | 23.0104486395053 | 20.9332716365543 | 19.7447322262178 | 20.2361623730334 | 20.7560249591193 | 19.6452286556272 | 18.3371846431608 |
| United States | USA | Net barter terms of trade index (2000 = 100) | TT.PRI.MRCH.XD.WD | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 96.7032967 | 94.50549451 | 95.40229885 | 92.04545455 | 91.86046512 | 91.76470588 | 102.2988506 | 103.125 | 103.960396 | 102.7027027 | 103.6697248 | 103.6036036 | 103.8461538 | 104.6728972 | 105.1282051 | 103.4482759 | 103.7037037 | 104.8543689 | 104.950495 | 100 | 102.7979275 | 104.357067 | 102.8895769 | 101.2707722 | 97.18181818 | 95.92720971 | 96.5890183 | 91.79716629 | 98.98819562 | 97.08201893 | 94.59459459 | 94.68085106 | 95.34050179 | 95.86956522 | 100 | 100.0834725 | 99.594485 | 99.84264359 | 100.3187251 | .. |
| United States | USA | External debt stocks, total (DOD, current US\() </td> <td style="text-align:left;"> DT.DOD.DECT.CD </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> Total debt service (% of GNI) </td> <td style="text-align:left;"> DT.TDS.DECT.GN.ZS </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> Net migration </td> <td style="text-align:left;"> SM.POP.NETM </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 1835728 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 1556054 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 2889346 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 3770881 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 3382460 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 3366853 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 4463754 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 8859954 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 5334893 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 5428756 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 4961716 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 4774029 </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> Personal remittances, paid (current US\)) | BM.TRF.PWKR.CD.DT | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | 650000000 | 700000000 | 670000000 | 680000000 | 590000000 | 650000000 | 1060000000 | 1170000000 | 1220000000 | 1360000000 | 4720000000 | 5140000000 | 5450000000 | 5990000000 | 6330000000 | 8660000000 | 8806000000 | 9005000000 | 11850000000 | 13919000000 | 16156300000 | 18041200000 | 20365700000 | 22181400000 | 23723200000 | 25593600000 | 27426700000 | 33346000000 | 34397000000 | 38219000000 | 40109000000 | 40943000000 | 44357000000 | 47751000000 | 50974000000 | 53039000000 | 55679000000 | 50555000000 | 50527000000 | 50854000000 | 52371000000 | 55003000000 | 57239000000 | 60719000000 | 62870000000 | 64114000000 | 66836000000 | 71372000000 | 69918000000 |
| United States | USA | Foreign direct investment, net inflows (BoP, current US\() </td> <td style="text-align:left;"> BX.KLT.DINV.CD.WD </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> .. </td> <td style="text-align:left;"> 1220000000 </td> <td style="text-align:left;"> 770000000 </td> <td style="text-align:left;"> 1270000000 </td> <td style="text-align:left;"> 3540000000 </td> <td style="text-align:left;"> 2310000000 </td> <td style="text-align:left;"> 2910000000 </td> <td style="text-align:left;"> 2920000000 </td> <td style="text-align:left;"> 5500000000 </td> <td style="text-align:left;"> 8050000000 </td> <td style="text-align:left;"> 16740000000 </td> <td style="text-align:left;"> 25680000000 </td> <td style="text-align:left;"> 21230000000 </td> <td style="text-align:left;"> 11500000000 </td> <td style="text-align:left;"> 25230000000 </td> <td style="text-align:left;"> 9630000000 </td> <td style="text-align:left;"> 30946000000 </td> <td style="text-align:left;"> 63235000000 </td> <td style="text-align:left;"> 56910000000 </td> <td style="text-align:left;"> 71230000000 </td> <td style="text-align:left;"> 34550000000 </td> <td style="text-align:left;"> 30310000000 </td> <td style="text-align:left;"> 50230000000 </td> <td style="text-align:left;"> 55940000000 </td> <td style="text-align:left;"> 69080000000 </td> <td style="text-align:left;"> 97660000000 </td> <td style="text-align:left;"> 122150000000 </td> <td style="text-align:left;"> 211150000000 </td> <td style="text-align:left;"> 312449000000 </td> <td style="text-align:left;"> 349125000000 </td> <td style="text-align:left;"> 172496000000 </td> <td style="text-align:left;"> 111055000000 </td> <td style="text-align:left;"> 117106000000 </td> <td style="text-align:left;"> 213641000000 </td> <td style="text-align:left;"> 142344000000 </td> <td style="text-align:left;"> 298463000000 </td> <td style="text-align:left;"> 346613000000 </td> <td style="text-align:left;"> 341092000000 </td> <td style="text-align:left;"> 161083000000 </td> <td style="text-align:left;"> 264039000000 </td> <td style="text-align:left;"> 263497000000 </td> <td style="text-align:left;"> 250345000000 </td> <td style="text-align:left;"> 288131000000 </td> <td style="text-align:left;"> 251856000000 </td> <td style="text-align:left;"> 511434000000 </td> <td style="text-align:left;"> 474388000000 </td> <td style="text-align:left;"> 380823000000 </td> <td style="text-align:left;"> 214315000000 </td> <td style="text-align:left;"> 302199000000 </td> <td style="text-align:left;"> .. </td> </tr> <tr> <td style="text-align:left;"> United States </td> <td style="text-align:left;"> USA </td> <td style="text-align:left;"> Net ODA received per capita (current US\)) | DT.ODA.ODAT.PC.ZS | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. | .. |
| NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| Data from database: World Development Indicators | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| Last Updated: 10/28/2021 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
After the above mentioned things have been corrected (changing column names and adding NAs to the data) and reduendent columns have been dropped the dataset looks like the following,
| Series | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Population, total | 180671000 | 183691000 | 186538000 | 189242000 | 191889000 | 194303000 | 196560000 | 198712000 | 200706000 | 202677000 | 205052000 | 207661000 | 209896000 | 213854000 | 215973000 | 218035000 | 220239000 | 222585000 | 225055000 | 227225000 | 229466000 | 231664000 | 233792000 | 235825000 | 237924000 | 240133000 | 242289000 | 244499000 | 249623000 | 252981000 | 256514000 | 259919000 | 263126000 | 266278000 | 269394000 | 272657000 | 275854000 | 279040000 | 282162411 | 284968955 | 287625193 | 290107933 | 292805298 | 295516599 | 298379912 | 301231207 | 304093966 | 306771529 | 309327143 | 311583481 | 313877662 | 316059947 | 318386329 | 320738994 | 323071755 | 325122128 | 326838199 | 328329953 | 329484123 |
| Population growth (annual %) | NA | 1.65773003738953 | 1.53799735825387 | 1.43916476170683 | 1.38904605518369 | 1.25017164562845 | 1.1548931907552 | 1.08888120728762 | 0.998461043585335 | 0.977242811872469 | 1.16500266687286 | 1.26433369185094 | 1.07052275237269 | 0.913660196067714 | 0.985986067347125 | 0.950220048994522 | 1.00577199618134 | 1.0595730803427 | 1.10357656509899 | 0.959589922764484 | 0.981415437259678 | 0.953317566163514 | 0.914378513375149 | 0.865817336309961 | 0.886129040850881 | 0.924164157058979 | 0.893829201032046 | 0.907999040167679 | 1.12965052045579 | 1.33626074073779 | 1.38688569247935 | 1.31867999977741 | 1.2262960888682 | 1.19078709090209 | 1.16341161998189 | 1.20396029701272 | 1.16571452642589 | 1.14834004729055 | 1.11276899679534 | 0.989741382223669 | 0.927797485710314 | 0.859481712840946 | 0.925483968943482 | 0.921713167161207 | 0.964253917136075 | 0.951055242772428 | 0.945865287282592 | 0.876651298802912 | 0.829616674709795 | 0.726786704810745 | 0.733599941250847 | 0.692860276624581 | 0.733361519937424 | 0.73621730882542 | 0.724676067451429 | 0.63264399508256 | 0.526435395564053 | 0.455381285963537 | 0.350911063312921 |
| Surface area (sq. km) | NA | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9629090 | 9632030 | 9632030 | 9632030 | 9632030 | 9632030 | 9632030 | 9632030 | 9632030 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | 9831510 | NA | NA |
| Poverty headcount ratio at national poverty lines (% of population) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| GNI, Atlas method (current US\() </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 612178550047.646 </td> <td style="text-align:left;"> 646233886826.649 </td> <td style="text-align:left;"> 692328219512.945 </td> <td style="text-align:left;"> 753294530375.941 </td> <td style="text-align:left;"> 824183577234.192 </td> <td style="text-align:left;"> 868295290971.962 </td> <td style="text-align:left;"> 952033980993.25 </td> <td style="text-align:left;"> 1027990251284.03 </td> <td style="text-align:left;"> 1072448453507.45 </td> <td style="text-align:left;"> 1167480039466.91 </td> <td style="text-align:left;"> 1317546984924.22 </td> <td style="text-align:left;"> 1707501119349 </td> <td style="text-align:left;"> 1837615687390.46 </td> <td style="text-align:left;"> 1954015548092.42 </td> <td style="text-align:left;"> 2112844663408.78 </td> <td style="text-align:left;"> 2395599972497.01 </td> <td style="text-align:left;"> 2745654917682.8 </td> <td style="text-align:left;"> 3041381894522.09 </td> <td style="text-align:left;"> 3295801022048.11 </td> <td style="text-align:left;"> 3293708060750.23 </td> <td style="text-align:left;"> 3405705063552.51 </td> <td style="text-align:left;"> 3821673418720.91 </td> <td style="text-align:left;"> 4154713915158.9 </td> <td style="text-align:left;"> 4588118207264.57 </td> <td style="text-align:left;"> 5183358426016.12 </td> <td style="text-align:left;"> 5744106447459.67 </td> <td style="text-align:left;"> 6006223931957.56 </td> <td style="text-align:left;"> 6140655897369.37 </td> <td style="text-align:left;"> 6587044223797.61 </td> <td style="text-align:left;"> 6858427053464.97 </td> <td style="text-align:left;"> 7276716882339.8 </td> <td style="text-align:left;"> 7731970449419.26 </td> <td style="text-align:left;"> 8154321495043.69 </td> <td style="text-align:left;"> 8523424738060.54 </td> <td style="text-align:left;"> 8833879985673.72 </td> <td style="text-align:left;"> 9394486467207.9 </td> <td style="text-align:left;"> 10147418121466.8 </td> <td style="text-align:left;"> 10462196419348.3 </td> <td style="text-align:left;"> 10732734658356.8 </td> <td style="text-align:left;"> 11536230254896.2 </td> <td style="text-align:left;"> 12740785534277.4 </td> <td style="text-align:left;"> 13648863758032.1 </td> <td style="text-align:left;"> 14284922398497.8 </td> <td style="text-align:left;"> 14608595029795.9 </td> <td style="text-align:left;"> 14895016620356.4 </td> <td style="text-align:left;"> 14645979981358.2 </td> <td style="text-align:left;"> 15155236576389.4 </td> <td style="text-align:left;"> 15760432948941.8 </td> <td style="text-align:left;"> 16558980098151.8 </td> <td style="text-align:left;"> 17045588721150.3 </td> <td style="text-align:left;"> 17778918029582.5 </td> <td style="text-align:left;"> 18200095600169.3 </td> <td style="text-align:left;"> 18503587290169 </td> <td style="text-align:left;"> 19332396438379.9 </td> <td style="text-align:left;"> 20758598149749.8 </td> <td style="text-align:left;"> 21640511015447.7 </td> <td style="text-align:left;"> 21261603638417.8 </td> </tr> <tr> <td style="text-align:left;"> GNI per capita, Atlas method (current US\)) | NA | NA | 3280 | 3410 | 3610 | 3880 | 4190 | 4370 | 4740 | 5070 | 5230 | 5620 | 6280 | 7980 | 8510 | 8960 | 9590 | 10760 | 12200 | 13380 | 14360 | 14220 | 14570 | 16210 | 17460 | 19110 | 21390 | 23490 | 24060 | 24270 | 25680 | 26390 | 27650 | 29040 | 30270 | 31260 | 32020 | 33670 | 35960 | 36710 | 37320 | 39770 | 43510 | 46190 | 47870 | 48500 | 48980 | 47740 | 48990 | 50580 | 52760 | 53930 | 55840 | 56740 | 57270 | 59460 | 63510 | 65910 | 64530 |
| GNI, PPP (current international \() </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 5902290000000 </td> <td style="text-align:left;"> 6096750000000 </td> <td style="text-align:left;"> 6435469000000 </td> <td style="text-align:left;"> 6733768000000 </td> <td style="text-align:left;"> 7170251000000 </td> <td style="text-align:left;"> 7574691000000 </td> <td style="text-align:left;"> 8045907000000 </td> <td style="text-align:left;"> 8589268000000 </td> <td style="text-align:left;"> 9135464000000 </td> <td style="text-align:left;"> 9689354000000 </td> <td style="text-align:left;"> 10383859000000 </td> <td style="text-align:left;"> 10743709000000 </td> <td style="text-align:left;"> 11054325000000 </td> <td style="text-align:left;"> 11530268000000 </td> <td style="text-align:left;"> 12313988000000 </td> <td style="text-align:left;"> 13169702000000 </td> <td style="text-align:left;"> 14072966000000 </td> <td style="text-align:left;"> 14543216000000 </td> <td style="text-align:left;"> 14684602000000 </td> <td style="text-align:left;"> 14398708000000 </td> <td style="text-align:left;"> 15126736000000 </td> <td style="text-align:left;"> 15832207000000 </td> <td style="text-align:left;"> 16670651000000 </td> <td style="text-align:left;"> 17175898000000 </td> <td style="text-align:left;"> 18057489000000 </td> <td style="text-align:left;"> 18704317000000 </td> <td style="text-align:left;"> 19045164000000 </td> <td style="text-align:left;"> 19830277000000.1 </td> <td style="text-align:left;"> 20837347000000.1 </td> <td style="text-align:left;"> 21690012900000 </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> GNI per capita, PPP (current international latexa3731ffcb2932c08615d58c687e1a432 GDP per cubic meter of total freshwater withdrawal) </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 14.0505742476829 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 18.5302069231569 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 21.720697062982 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 25.5912468506528 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 29.6825805172414 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 35.9563579176564 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 39.4976703159136 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 42.7167507028788 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> Energy use (kg of oil equivalent per capita) </td> <td style="text-align:left;"> 5641.74075529554 </td> <td style="text-align:left;"> 5612.07950307854 </td> <td style="text-align:left;"> 5774.58631485274 </td> <td style="text-align:left;"> 5986.78395387916 </td> <td style="text-align:left;"> 6136.93822991417 </td> <td style="text-align:left;"> 6307.89020241581 </td> <td style="text-align:left;"> 6591.34055759056 </td> <td style="text-align:left;"> 6809.82048391642 </td> <td style="text-align:left;"> 7073.47894930894 </td> <td style="text-align:left;"> 7332.36854699843 </td> <td style="text-align:left;"> 7569.07659520512 </td> <td style="text-align:left;"> 7644.52480244244 </td> <td style="text-align:left;"> 7940.99783225979 </td> <td style="text-align:left;"> 7909.58647956082 </td> <td style="text-align:left;"> 7656.2635792437 </td> <td style="text-align:left;"> 8100.56222166166 </td> <td style="text-align:left;"> 8285.57089797901 </td> <td style="text-align:left;"> 8438.40307747602 </td> <td style="text-align:left;"> 8327.04170536091 </td> <td style="text-align:left;"> 7942.25301793377 </td> <td style="text-align:left;"> 7647.53805356785 </td> <td style="text-align:left;"> 7259.07889874991 </td> <td style="text-align:left;"> 7199.11853271284 </td> <td style="text-align:left;"> 7443.32001696173 </td> <td style="text-align:left;"> 7456.26290328004 </td> <td style="text-align:left;"> 7376.09623833459 </td> <td style="text-align:left;"> 7622.17301652159 </td> <td style="text-align:left;"> 7849.75397036389 </td> <td style="text-align:left;"> 7671.7730657832 </td> <td style="text-align:left;"> 7631.46780588265 </td> <td style="text-align:left;"> 7677.40140109312 </td> <td style="text-align:left;"> 7709.49658932206 </td> <td style="text-align:left;"> 7757.83082249569 </td> <td style="text-align:left;"> 7763.75510556636 </td> <td style="text-align:left;"> 7844.46826581141 </td> <td style="text-align:left;"> 7828.58109639584 </td> <td style="text-align:left;"> 7803.69760452993 </td> <td style="text-align:left;"> 7923.22389263188 </td> <td style="text-align:left;"> 8056.86384994775 </td> <td style="text-align:left;"> 7827.88632537183 </td> <td style="text-align:left;"> 7843.34484914192 </td> <td style="text-align:left;"> 7794.23553026383 </td> <td style="text-align:left;"> 7881.57864206405 </td> <td style="text-align:left;"> 7846.49968849973 </td> <td style="text-align:left;"> 7697.65253500041 </td> <td style="text-align:left;"> 7758.16598577052 </td> <td style="text-align:left;"> 7488.08192070473 </td> <td style="text-align:left;"> 7056.78365282718 </td> <td style="text-align:left;"> 7161.42655156518 </td> <td style="text-align:left;"> 7029.95460147645 </td> <td style="text-align:left;"> 6872.02728367462 </td> <td style="text-align:left;"> 6905.59863316056 </td> <td style="text-align:left;"> 6960.68399657951 </td> <td style="text-align:left;"> 6803.99660728499 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> CO2 emissions (metric tons per capita) </td> <td style="text-align:left;"> 15.9997791565885 </td> <td style="text-align:left;"> 15.6812555160569 </td> <td style="text-align:left;"> 16.0139374979897 </td> <td style="text-align:left;"> 16.4827621458239 </td> <td style="text-align:left;"> 16.9681185789701 </td> <td style="text-align:left;"> 17.4517252487095 </td> <td style="text-align:left;"> 18.1210730107855 </td> <td style="text-align:left;"> 18.5983178821611 </td> <td style="text-align:left;"> 19.0893891562783 </td> <td style="text-align:left;"> 19.85794566231 </td> <td style="text-align:left;"> 21.1112522725943 </td> <td style="text-align:left;"> 20.9802034758573 </td> <td style="text-align:left;"> 21.7486419846019 </td> <td style="text-align:left;"> 21.5029303777343 </td> <td style="text-align:left;"> 20.4022240696754 </td> <td style="text-align:left;"> 21.1576153736785 </td> <td style="text-align:left;"> 21.5324840060117 </td> <td style="text-align:left;"> 21.9730046948357 </td> <td style="text-align:left;"> 21.7804369776277 </td> <td style="text-align:left;"> 20.7864877412257 </td> <td style="text-align:left;"> 19.7667641742132 </td> <td style="text-align:left;"> 18.5904952301609 </td> <td style="text-align:left;"> 18.5715437097933 </td> <td style="text-align:left;"> 18.9767502682074 </td> <td style="text-align:left;"> 18.8823127427246 </td> <td style="text-align:left;"> 18.7207227161615 </td> <td style="text-align:left;"> 19.3503344229412 </td> <td style="text-align:left;"> 20.0104134086438 </td> <td style="text-align:left;"> 19.4092291175092 </td> <td style="text-align:left;"> 19.005735608603 </td> <td style="text-align:left;"> 19.0250824516401 </td> <td style="text-align:left;"> 19.2381087954324 </td> <td style="text-align:left;"> 19.2806108100302 </td> <td style="text-align:left;"> 19.2539376140725 </td> <td style="text-align:left;"> 19.6110900762452 </td> <td style="text-align:left;"> 20.3478729686016 </td> <td style="text-align:left;"> 20.266880306249 </td> <td style="text-align:left;"> 20.1057196100917 </td> <td style="text-align:left;"> 20.4719330952981 </td> <td style="text-align:left;"> 20.1750046772639 </td> <td style="text-align:left;"> 19.4494784745785 </td> <td style="text-align:left;"> 19.5087047137039 </td> <td style="text-align:left;"> 19.6035728834387 </td> <td style="text-align:left;"> 19.4780260042178 </td> <td style="text-align:left;"> 18.9576435024889 </td> <td style="text-align:left;"> 19.0560269540732 </td> <td style="text-align:left;"> 18.2948056259689 </td> <td style="text-align:left;"> 16.8188684811099 </td> <td style="text-align:left;"> 17.4341958733314 </td> <td style="text-align:left;"> 16.599403740534 </td> <td style="text-align:left;"> 15.7711446187591 </td> <td style="text-align:left;"> 16.1029578354008 </td> <td style="text-align:left;"> 16.0263790723251 </td> <td style="text-align:left;"> 15.535342110601 </td> <td style="text-align:left;"> 15.1317468158119 </td> <td style="text-align:left;"> 14.8058824221278 </td> <td style="text-align:left;"> 15.2408745833286 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> Electric power consumption (kWh per capita) </td> <td style="text-align:left;"> 4049.786628734 </td> <td style="text-align:left;"> 4182.17550124938 </td> <td style="text-align:left;"> 4433.60602129325 </td> <td style="text-align:left;"> 4690.48625569377 </td> <td style="text-align:left;"> 4970.44645602406 </td> <td style="text-align:left;"> 5234.68500229024 </td> <td style="text-align:left;"> 5590.33374033374 </td> <td style="text-align:left;"> 5888.34091549579 </td> <td style="text-align:left;"> 6385.45932857015 </td> <td style="text-align:left;"> 6904.83379959245 </td> <td style="text-align:left;"> 7236.65704309151 </td> <td style="text-align:left;"> 7517.30464555213 </td> <td style="text-align:left;"> 8076.40926935244 </td> <td style="text-align:left;"> 8449.92845586241 </td> <td style="text-align:left;"> 8522.39400295407 </td> <td style="text-align:left;"> 8968.7756552847 </td> <td style="text-align:left;"> 9337.72401799863 </td> <td style="text-align:left;"> 9560.5454096188 </td> <td style="text-align:left;"> 9700.69538557242 </td> <td style="text-align:left;"> 9862.36549675432 </td> <td style="text-align:left;"> 9976.69371497302 </td> <td style="text-align:left;"> 9544.46094343532 </td> <td style="text-align:left;"> 9742.00571448125 </td> <td style="text-align:left;"> 10282.3746422135 </td> <td style="text-align:left;"> 10414.2078983205 </td> <td style="text-align:left;"> 10424.4272965398 </td> <td style="text-align:left;"> 10886.8582560496 </td> <td style="text-align:left;"> 11298.3325085174 </td> <td style="text-align:left;"> 11713.3317042099 </td> <td style="text-align:left;"> 12134.1721315039 </td> <td style="text-align:left;"> 12014.9582478929 </td> <td style="text-align:left;"> 12261.5237824091 </td> <td style="text-align:left;"> 12455.1621656545 </td> <td style="text-align:left;"> 12659.607628118 </td> <td style="text-align:left;"> 12854.2989079193 </td> <td style="text-align:left;"> 12889.8322801175 </td> <td style="text-align:left;"> 13154.7630268185 </td> <td style="text-align:left;"> 13281.8699827982 </td> <td style="text-align:left;"> 13671.0520240061 </td> <td style="text-align:left;"> 13046.6141478464 </td> <td style="text-align:left;"> 13296.1822993023 </td> <td style="text-align:left;"> 13307.4920085002 </td> <td style="text-align:left;"> 13388.5897105591 </td> <td style="text-align:left;"> 13704.5770481407 </td> <td style="text-align:left;"> 13583.2669593387 </td> <td style="text-align:left;"> 13657.4528282523 </td> <td style="text-align:left;"> 13663.4279681827 </td> <td style="text-align:left;"> 12913.7146883015 </td> <td style="text-align:left;"> 13394.9027551068 </td> <td style="text-align:left;"> 13245.8819278677 </td> <td style="text-align:left;"> 12964.1879389302 </td> <td style="text-align:left;"> 13004.0235689845 </td> <td style="text-align:left;"> 12993.9655794706 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> GDP (current US\)) | 543300000000 | 563300000000 | 605100000000 | 638600000000 | 685800000000 | 743700000000 | 815000000000 | 861700000000 | 942500000000 | 1019900000000 | 1073303000000 | 1164850000000 | 1279110000000 | 1545243000000 | 1684904000000 | 1873412000000 | 2081826000000 | 2351599000000 | 2627333000000 | 2857307000000 | 3207041000000 | 3343789000000 | 3634038000000 | 4037613000000 | 4338979000000 | 4579631000000 | 4855215000000 | 5236438000000 | 5963144000000 | 6158129000000 | 6520327000000 | 6858559000000 | 7287236000000 | 7639749000000 | 8073122000000 | 8577554457000 | 9062818202000 | 9630664202000 | 10252345464000 | 10581821399000 | 10936419054000 | 11458243878000 | 12213729147000 | 13036640230000 | 13814611414000 | 14451858656000 | 14712844084000 | 14448933025000 | 14992052727000 | 15542581104000 | 16197007349000 | 16784849196000 | 17527163695000 | 18238300569000 | 18745075687000 | 19542979183000 | 20611860934000 | 21433224697000 | 20936600000000 |
| GDP growth (annual %) | NA | 2.29999999999968 | 6.10000000000012 | 4.39999999999992 | 5.8000000000003 | 6.39999999999976 | 6.50000000000028 | 2.50000000000003 | 4.79999999999959 | 3.09999999999999 | -0.346648733838819 | 3.29335165324265 | 5.2589073310028 | -0.54055166261962 | -0.205456064255458 | 5.38813929310284 | 4.62415306432004 | 5.53530495989784 | 3.16614531077464 | -0.256749676940515 | 2.53771929783902 | -1.80288740691098 | 4.58391336401664 | 7.23663315778187 | 4.16965621486705 | 3.46264597689752 | 3.45925198493917 | 4.17706128382223 | 1.88596495768836 | -0.108264786843066 | 3.52244052251753 | 2.75178104210936 | 4.02879326333235 | 2.68421727485742 | 3.7725655016348 | 4.38177517389286 | 4.48140756104172 | 4.75323598286796 | 4.12748401690885 | 0.998340791805987 | 1.74169525130476 | 2.8612107683238 | 3.79889112471299 | 3.5132137994521 | 2.85497229363445 | 1.87617145415626 | -0.136579803249504 | -2.53675706714202 | 2.5637665603995 | 1.55083550470843 | 2.24954585238848 | 1.84208107064158 | 2.52597344637341 | 3.0755146497898 | 1.71142677366849 | 2.33267939548638 | 2.99646435222829 | 2.16117651518969 | -3.48614040819797 |
| Inflation, GDP deflator (annual %) | NA | 1.35015389642166 | 1.24463471200144 | 1.08838601136836 | 1.50393967901161 | 1.91982581124751 | 2.89877853468326 | 3.15127936555434 | 4.36718824053682 | 4.9584884495751 | 5.60217016436724 | 5.06916748805631 | 4.32275145745318 | 8.99869462646564 | 9.26261205760063 | 5.50338639985235 | 6.21336667727508 | 7.03383077555833 | 8.29655708788701 | 9.03307690564108 | 9.46214483934116 | 6.17826749673415 | 3.91678718743533 | 3.60770540480202 | 3.1624451696169 | 2.01390148483323 | 2.47281001382842 | 3.52742146520499 | 3.74332973847665 | 3.38176155337062 | 2.27891032683829 | 2.37033960111148 | 2.13542370696524 | 2.09690072576767 | 1.83096786671982 | 1.78816614253974 | 1.12552039639621 | 1.44380352524929 | 2.23547440584899 | 2.1934253449969 | 1.58176300591224 | 1.85709520165997 | 2.6922121263311 | 3.11494234781323 | 3.02620464133297 | 2.68627890903008 | 1.94513170334587 | 0.762349988423779 | 1.16525054364868 | 2.08890377766842 | 1.91784900670304 | 1.75491578501162 | 1.84982747081428 | 0.952531532798019 | 1.04924737000228 | 1.88006787244998 | 2.40098111411591 | 1.78515153743628 | 1.21128887945865 |
| Agriculture, forestry, and fishing, value added (% of GDP) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 1.33691171038169 | 1.21399691075917 | 1.15118252152304 | 1.15045636546451 | 1.12932550544931 | 0.970430947058331 | 1.11525741955411 | 1.25866007956923 | 1.14225527722491 | 1.00067777411318 | 1.06682214149659 | 1.06578313550216 | 0.968572535825703 | 1.04248133891985 | 1.21648753662505 | 1.15882894880324 | 1.3335136788321 | 1.18557101774133 | 1.04386645169999 | 0.943988879824681 | 0.949806072359055 | 0.920560058150837 | 0.916865221067299 | NA |
| Industry (including construction), value added (% of GDP) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 23.1321011361316 | 22.6705577802122 | 22.5499937953293 | 22.4543862190713 | 21.4739916723102 | 20.6412607714986 | 20.7393072909074 | 20.96034469234 | 21.223491223091 | 21.5938538450445 | 21.4461294271878 | 20.860737478607 | 19.324003503712 | 19.3552915457272 | 19.4169009561953 | 19.1559852455803 | 19.2582012817269 | 19.328829963324 | 18.5445077473325 | 17.9650951867613 | 18.2514054668939 | 18.5278233111914 | 18.1563709661696 | NA |
| Exports of goods and services (% of GDP) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 5.56310752881526 | 5.40524531055501 | 5.53846033570217 | 8.19612190445127 | 8.23227910907684 | 7.9808926173207 | 7.6542900319239 | 7.947060702101 | 8.75903435156488 | 9.82645547013324 | 9.51777666702733 | 8.46973298853486 | 7.62226481946529 | 7.48907832424752 | 6.98807253964585 | 7.00925467575881 | 7.49591933621889 | 8.49052351999585 | 9.25473206751338 | 9.66090512231881 | 9.70891490564814 | 9.54718039168286 | 9.89314741556332 | 10.639223880261 | 10.7466355642836 | 11.1197545265553 | 10.5152611335588 | 10.3098808054568 | 10.6913194044121 | 9.70354687801701 | 9.12528127417529 | 9.03423780312036 | 9.6314809821122 | 9.98401410974582 | 10.6421379215205 | 11.4815335487045 | 12.4739988374908 | 10.9542621400586 | 12.388210165878 | 13.6133373591048 | 13.6920355236915 | 13.6252698686445 | 13.5641341712248 | 12.4389385481237 | 11.9077139899094 | 12.1975159348969 | 12.2915199559729 | 11.7561731173036 | 10.1420956602314 |
| Imports of goods and services (% of GDP) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 5.19517787614495 | 5.35193372537237 | 5.80215931389794 | 8.24886441808829 | 7.28409452407971 | 8.067953018343 | 8.76360464323147 | 9.02577352686406 | 9.61712885271871 | 10.2833892192894 | 9.90813650339986 | 9.06707929238358 | 9.04332866084504 | 10.0333290981577 | 9.61583358665714 | 9.88872247567544 | 10.4776616483513 | 10.5795771858657 | 10.5603185165409 | 10.1255430017786 | 10.2416795967442 | 10.4974383102923 | 11.162311746182 | 11.8141577687958 | 11.9404364259576 | 12.3085665651286 | 12.3106298188105 | 13.0049181835236 | 14.4082542398417 | 13.2638696787364 | 13.1462043736716 | 13.5895170025984 | 14.8235152279 | 15.6595715152293 | 16.3350450647717 | 16.5738404797197 | 17.5095378248555 | 13.855189144667 | 15.9388113390004 | 17.342550648208 | 17.097707868676 | 16.4813813201209 | 16.4741144103293 | 15.3240702960585 | 14.6084179425271 | 14.9603137404109 | 15.1839613609922 | 14.5381296750747 | 13.252376221545 |
| Gross capital formation (% of GDP) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 21.4147356338331 | 21.9198180023179 | 22.580622464057 | 22.6949418311554 | 20.2774757493602 | 22.038398387541 | 23.5262697266726 | 24.8317846707708 | 25.1111298034927 | 23.3102708249411 | 24.2768645614446 | 22.070082771371 | 22.2529868977705 | 25.0958177517261 | 24.1883401602082 | 23.7406245175648 | 23.6202310299338 | 22.827807757869 | 21.5292134484762 | 20.1106050230516 | 20.0775819985715 | 20.39362787431 | 21.2790967659069 | 21.2726491406982 | 21.7018149855781 | 22.4097090800901 | 22.9583331986162 | 23.420368031642 | 23.6751483699321 | 22.1769477249141 | 21.7081385440482 | 21.7422235599583 | 22.6585751713657 | 23.3803031012999 | 23.5391854504464 | 22.592491925905 | 21.1190167058118 | 17.8045811102374 | 18.7431037708356 | 19.1035258566922 | 20.0208898479027 | 20.4137431322085 | 20.806247168447 | 21.1629531238262 | 20.5119577226704 | 20.7222960331595 | 21.0577638472243 | 21.3045496632111 | 21.1083795840776 |
| Revenue, excluding grants (% of GDP) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 16.721783114822 | 17.9661063017273 | 17.3084045144412 | 16.6033953022613 | 17.8357845468353 | 17.7143296965171 | 18.5975664295314 | 19.1047024348451 | 19.9495422727679 | 19.7264241254457 | 17.9777977005194 | 17.7907095107926 | 18.2404662479353 | 17.9724086940629 | 18.7390259751628 | 18.3821521423533 | 18.2058323595741 | 18.1313187820521 | 17.6483480046323 | 18.0456273686645 | 18.2572651688514 | 18.7804599339586 | 18.9521476326011 | 19.4159070437715 | 19.8287106719566 | 19.7831630304827 | 20.573341070162 | 19.5150553211487 | 17.3832978657184 | 16.782446075285 | 16.8515903310788 | 17.9353212081392 | 18.6329026771712 | 18.6888805397959 | 17.7874235943681 | 15.7041408945143 | 16.4716516474936 | 16.6950134127478 | 16.8104189948898 | 18.8714206664118 | 18.9428464169998 | 19.0709736734573 | 18.6504005551952 | 19.4945195628826 | 17.4854304108706 | 17.4547243958285 | 17.640417259727 |
| Start-up procedures to register a business (number) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 6 | 6 | 6 | 6 | 6 | 6 | 6 | NA |
| Market capitalization of listed domestic companies (% of GDP) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 41.7709258212931 | 47.1385899097476 | 40.0724171952891 | 36.6542510011273 | 37.8174711770453 | 47.5901889436452 | 39.3995804855629 | 43.5692922011526 | 49.7802829799798 | 39.6808634210361 | 53.0276339203301 | 55.4180500568714 | 52.1453262110947 | 53.0883913836085 | 51.8761327916951 | 67.5464122300783 | 69.7180371475234 | 76.562432866729 | 70.5032725713837 | 90.9980943091193 | 105.046065202533 | 125.561930897573 | 142.588979630511 | 153.440999395776 | 147.358973154477 | 132.148006214899 | 101.07906386375 | 124.50656315137 | 133.650633099306 | 130.408327376232 | 141.654165387297 | 137.852717039471 | 78.7765962435791 | 104.348782805712 | 115.284090809481 | 100.63133616832 | 115.257916525873 | 143.193741208755 | 150.227325129116 | 137.444492183706 | 145.916725953628 | 164.359294195744 | 147.664071417221 | 158.122859621509 | 194.49032507666 |
| Military expenditure (% of GDP) | 8.99312458715278 | 9.15603150017123 | 9.33167294545842 | 8.83189118618018 | 8.0512811057284 | 7.58724717722602 | 8.43530028594507 | 9.41779593255137 | 9.26845427468793 | 8.63326379509104 | 8.03274358404085 | 6.94306960936061 | 6.51975692434716 | 5.95411119676015 | 5.62267909613336 | 5.19107142902555 | 5.15561735127125 | 4.94308724791688 | 4.95199153527265 | 5.15353746651636 | 5.64654125624258 | 6.81405709441284 | 6.32114425976717 | 6.23641652963897 | 6.4532192046686 | 6.62652265789842 | 6.42027402288488 | 6.0712777020948 | 5.60517529438794 | 4.88342939776313 | 4.97046680768284 | 4.60435029507644 | 4.2152646751779 | 3.8602457917389 | 3.55498220635218 | 3.40556224418855 | 3.20155849896996 | 3.08567678324746 | 3.11224214697679 | 3.12380980266703 | 3.44761809928778 | 3.82716104473623 | 4.01631273640692 | 4.09003487632585 | 4.04162723678969 | 4.0796550810522 | 4.46382735629989 | 4.88559968011478 | 4.92264167706996 | 4.84017399490275 | 4.47740121867267 | 4.04667887867098 | 3.69589465026568 | 3.47784516633609 | 3.41894233677988 | 3.31338129427849 | 3.31624880838269 | 3.42708018052996 | 3.74116009078512 |
| Mobile cellular subscriptions (per 100 people) | 0 | NA | NA | NA | NA | 0 | NA | NA | NA | NA | 0 | NA | NA | NA | 0 | 0 | 0 | 0 | 0 | 0 | NA | NA | NA | 0.038445905 | 0.14146081 | 0.280860174 | 0.502281572 | 0.836569536 | 2.095449994 | 2.96895054 | 4.293056805 | 6.168585393 | 9.203138701 | 12.74143303 | 16.41343526 | 20.35683377 | 25.15099311 | 30.89124914 | 38.86183584 | 45.14982121 | 49.35962707 | 55.42732036 | 63.21739536 | 69.05236638 | 77.10934813 | 82.93180628 | 86.09952013 | 89.5449638 | 92.26777096 | 95.44904589 | 97.06859919 | 98.19768385 | 111.5562164 | 119.1439209 | 122.5945483 | 123.0448345 | 129.0140075 | 134.4588794 | NA |
| High-technology exports (% of manufactured exports) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 30.3732292339219 | 28.8578498098283 | 24.8677741839767 | 23.0014609957313 | 20.9845794757797 | 20.5594043226112 | 20.526846085317 | 20.8607973528068 | 21.7598671248231 | 22.7237471373984 | 19.5199016960383 | 18.7417405398469 | 18.9335479863635 | 19.7523940308825 |
| Merchandise trade (% of GDP) | 6.62562120375483 | 6.41363394283685 | 6.40456122954883 | 6.4278108362042 | 6.70691163604549 | 6.70794675272287 | 7.00907975460123 | 6.92665660902866 | 7.36477453580902 | 7.41680556917345 | 7.98031869844769 | 7.88865519165558 | 8.44813972215056 | 13.5845947854156 | 12.7447617193621 | 13.3067899639802 | 13.6223200209816 | 14.11350319506 | 15.5514356193143 | 16.8883147663167 | 15.9669614451452 | 14.0955664367578 | 13.085086066794 | 14.1256480004399 | 13.166184948118 | 13.3078844125214 | 13.9760031224158 | 14.9332427883229 | 15.2701158985931 | 15.103499780534 | 15.3686463884403 | 15.5748605501535 | 16.4924259348812 | 17.7439730022544 | 17.9248870511309 | 18.5157903451594 | 17.9468567475078 | 18.2255030721089 | 19.9097660839416 | 18.03356840043 | 17.3121840947336 | 17.6974850735499 | 19.1633118094395 | 20.2029660520899 | 21.3110880340539 | 21.9252213533412 | 23.4959942500808 | 18.4189309715483 | 21.6626706104834 | 24.1178217113198 | 23.968791989464 | 23.2867924778941 | 23.0104486395053 | 20.9332716365543 | 19.7447322262178 | 20.2361623730334 | 20.7560249591193 | 19.6452286556272 | 18.3371846431608 |
| Net barter terms of trade index (2000 = 100) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 96.7032967 | 94.50549451 | 95.40229885 | 92.04545455 | 91.86046512 | 91.76470588 | 102.2988506 | 103.125 | 103.960396 | 102.7027027 | 103.6697248 | 103.6036036 | 103.8461538 | 104.6728972 | 105.1282051 | 103.4482759 | 103.7037037 | 104.8543689 | 104.950495 | 100 | 102.7979275 | 104.357067 | 102.8895769 | 101.2707722 | 97.18181818 | 95.92720971 | 96.5890183 | 91.79716629 | 98.98819562 | 97.08201893 | 94.59459459 | 94.68085106 | 95.34050179 | 95.86956522 | 100 | 100.0834725 | 99.594485 | 99.84264359 | 100.3187251 | NA |
| External debt stocks, total (DOD, current US\() </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> Total debt service (% of GNI) </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> Net migration </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 1835728 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 1556054 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 2889346 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 3770881 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 3382460 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 3366853 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 4463754 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 8859954 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 5334893 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 5428756 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 4961716 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 4774029 </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> Personal remittances, paid (current US\)) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | 650000000 | 700000000 | 670000000 | 680000000 | 590000000 | 650000000 | 1060000000 | 1170000000 | 1220000000 | 1360000000 | 4720000000 | 5140000000 | 5450000000 | 5990000000 | 6330000000 | 8660000000 | 8806000000 | 9005000000 | 11850000000 | 13919000000 | 16156300000 | 18041200000 | 20365700000 | 22181400000 | 23723200000 | 25593600000 | 27426700000 | 33346000000 | 34397000000 | 38219000000 | 40109000000 | 40943000000 | 44357000000 | 47751000000 | 50974000000 | 53039000000 | 55679000000 | 50555000000 | 50527000000 | 50854000000 | 52371000000 | 55003000000 | 57239000000 | 60719000000 | 62870000000 | 64114000000 | 66836000000 | 71372000000 | 69918000000 |
| Foreign direct investment, net inflows (BoP, current US\() </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> NA </td> <td style="text-align:left;"> 1220000000 </td> <td style="text-align:left;"> 770000000 </td> <td style="text-align:left;"> 1270000000 </td> <td style="text-align:left;"> 3540000000 </td> <td style="text-align:left;"> 2310000000 </td> <td style="text-align:left;"> 2910000000 </td> <td style="text-align:left;"> 2920000000 </td> <td style="text-align:left;"> 5500000000 </td> <td style="text-align:left;"> 8050000000 </td> <td style="text-align:left;"> 16740000000 </td> <td style="text-align:left;"> 25680000000 </td> <td style="text-align:left;"> 21230000000 </td> <td style="text-align:left;"> 11500000000 </td> <td style="text-align:left;"> 25230000000 </td> <td style="text-align:left;"> 9630000000 </td> <td style="text-align:left;"> 30946000000 </td> <td style="text-align:left;"> 63235000000 </td> <td style="text-align:left;"> 56910000000 </td> <td style="text-align:left;"> 71230000000 </td> <td style="text-align:left;"> 34550000000 </td> <td style="text-align:left;"> 30310000000 </td> <td style="text-align:left;"> 50230000000 </td> <td style="text-align:left;"> 55940000000 </td> <td style="text-align:left;"> 69080000000 </td> <td style="text-align:left;"> 97660000000 </td> <td style="text-align:left;"> 122150000000 </td> <td style="text-align:left;"> 211150000000 </td> <td style="text-align:left;"> 312449000000 </td> <td style="text-align:left;"> 349125000000 </td> <td style="text-align:left;"> 172496000000 </td> <td style="text-align:left;"> 111055000000 </td> <td style="text-align:left;"> 117106000000 </td> <td style="text-align:left;"> 213641000000 </td> <td style="text-align:left;"> 142344000000 </td> <td style="text-align:left;"> 298463000000 </td> <td style="text-align:left;"> 346613000000 </td> <td style="text-align:left;"> 341092000000 </td> <td style="text-align:left;"> 161083000000 </td> <td style="text-align:left;"> 264039000000 </td> <td style="text-align:left;"> 263497000000 </td> <td style="text-align:left;"> 250345000000 </td> <td style="text-align:left;"> 288131000000 </td> <td style="text-align:left;"> 251856000000 </td> <td style="text-align:left;"> 511434000000 </td> <td style="text-align:left;"> 474388000000 </td> <td style="text-align:left;"> 380823000000 </td> <td style="text-align:left;"> 214315000000 </td> <td style="text-align:left;"> 302199000000 </td> <td style="text-align:left;"> NA </td> </tr> <tr> <td style="text-align:left;"> Net ODA received per capita (current US\)) | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA |
3.3 Financial Data
3.3.1 Correcting Date format
In the dataset for oil data there were different types of date formats such as ‘MM/DD/YY’ and ‘MM/DD/YYYY’ as shown below.
## # A tibble: 10 × 2
## Day `Cost per barrel`
## <chr> <dbl>
## 1 11/08/21 82.0
## 2 11/05/21 81.2
## 3 11/04/21 78.9
## 4 11/03/21 80.8
## 5 11/02/21 83.9
## 6 11/01/21 84.1
## 7 10/29/2021 83.5
## 8 10/28/2021 82.8
## 9 10/27/2021 82.7
## 10 10/26/2021 85.6We updated the dataset to contain dates in only one format (“MM/DD/YYYY”). This was done by splitting the date based on “/” as the delimiter.
## [,1] [,2] [,3]
## [1,] "11" "08" "21"We then checked if the date was already in the correct format by checking the number of characters in the year component of the split. If it was not correct then we added the missing components to the year format and joined the string again while updating that in the dataframe. If the year component in the was an integer less than 22 then we added “20” before the date making the year “20xx” but if the integer was greater than 22, it is obvious that it cannot be a date from the 21th century therefore we added “19” before the date making it “19xx”.
## # A tibble: 10 × 2
## Day `Cost per barrel`
## <chr> <dbl>
## 1 11/08/2021 82.0
## 2 11/05/2021 81.2
## 3 11/04/2021 78.9
## 4 11/03/2021 80.8
## 5 11/02/2021 83.9
## 6 11/01/2021 84.1
## 7 10/29/2021 83.5
## 8 10/28/2021 82.8
## 9 10/27/2021 82.7
## 10 10/26/2021 85.6