Economic Data Of The Top Countries

This datasets provide different information about Countries from 1999 to 2022

@kaggle.damerajee_economic_data_of_the_top_countries

Table List

1 table(2.07 MB)

Economic Data

@kaggle.damerajee_economic_data_of_the_top_countries.economic_data

2.07 MB
16247 rows
29 columns

country_name Country Name	country_code Country Code	indicator_name Indicator Name	indicator_code Indicator Code	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022
Brazil	BRA	Intentional homicides, female (per 100,000 female)	VC.IHR.PSRC.FE.P5	4.04091836680936	4.21749377657694	4.27990353513086	4.244672812229	4.26602898235877	4.10411378799988	4.11148917614237	4.20784725326153	3.90823780558906	4.12549324269665	4.32636158676194	4.48633802834233	4.49311720557401	4.65545780348197	4.65680238305195	4.68073109843755	4.4336931092754	4.42011296834114	4.65461156254125	4.22704746113442	3.46544050446337	3.52896635491686
Brazil	BRA	Battle-related deaths (number of people)	VC.BTL.DETH
Brazil	BRA	Voice and Accountability: Percentile Rank	VA.PER.RNK		58.2089538574219		62.6865653991699	62.1890563964844	60.5769233703613	63.9423065185547	61.0576934814453	63.9423065185547	63.9423065185547	62.5592422485352	65.8767776489258	63.3802833557129	62.9107971191406	60.5633811950684	62.0689659118652	62.0689659118652	62.0689659118652	61.0837440490723	58.937198638916	56.5217399597168	57.0048294067383	56.038646697998
Brazil	BRA	Transport services (% of commercial service exports)	TX.VAL.TRAN.ZS.WT	16.6181590610289	13.5933687015055	14.7121153805454	14.8587325739796	16.4665219522902	18.2474945574629	19.2001202796819	17.2557325767583	15.6968441200059	17.1224314898173	13.2952020518658	13.1264425483205	12.7385374461085	11.3642359104485	11.5458408251575	11.973617852423	12.0927583993062	12.4681445410908	14.0781015052253	13.4600540172911	13.2374847353157	14.8589792124337	16.9989548344377	16.6997197526925
Brazil	BRA	Computer, communications and other services (% of commercial service exports)	TX.VAL.OTHR.ZS.WT	48.2978858360198	54.6210978238337	57.2801421950611	52.5168875015774	49.4570307720909	46.3470749062953	47.6203139407807	49.492487556724	52.1527530545076	53.0914903565502	56.1399453006989	61.0219917069634	61.0750886565259	62.9075925961969	61.5108275553749	65.5088111180885	64.8766368959397	64.1832947518027	63.811405534979	64.7886127129175	62.1100840820631	68.5823362673182	67.4818790431005	64.5230362545903
Brazil	BRA	Merchandise exports by the reporting economy, residual (% of total merchandise exports)	TX.VAL.MRCH.RS.ZS	6.87306224123344	12.6759956549292	8.6119081953952	6.44221171296984	5.76832470176728	6.33498636740639	5.71086702090842	5.12102810119263	3.53658563105312	5.50272106627194	4.75853868589871	4.41272100586881	4.28540184699146	4.70413958899471	4.13667720882122	4.2888709111506	3.15716446053554	1.82664203556606	1.43443462198997	1.14757852188659	0.216231628262826	0.420840747700711
Brazil	BRA	Merchandise exports to low- and middle-income economies in Latin America & the Caribbean (% of total merchandise exports)	TX.VAL.MRCH.R3.ZS	18.4738797221383	18.0869909046941	16.6707703141015	13.564691510365	14.8884083106752	16.7561636236491	17.3233260566055	17.9109554289845	18.5316304889619	18.7895815946085	17.2109181455951	17.7616854691331	16.4717267936791	14.6903467460704	14.8246700467541	13.6392083922701	14.4518940811159	15.1551455667053	15.7903554708594	13.3784889582981	11.9362323487849	10.3503160569154
Brazil	BRA	Merchandise exports to high-income economies (% of total merchandise exports)	TX.VAL.MRCH.HI.ZS	63.9340773805343	60.8310035801599	62.3058921716358	64.7057456463932	62.2623890825654	59.8096671992756	58.1291381686348	57.3409218532707	57.9241916916592	54.4759537657496	50.1479646225977	48.2407248030112	48.6853184675712	48.9033929655816	49.1897303574827	49.5180634660151	48.4575826346961	48.8622353737037	45.2512995936117	45.3057919236847	46.6006265085509	41.8588007852846
Brazil	BRA	Manufactures exports (% of merchandise exports)	TX.VAL.MANF.ZS.UN	53.2631913302008	57.5531410445161	53.5716112142027	52.0301064054833	51.0705626367766	52.6079034526395	52.2046909338931	49.7402105731925	47.3230920855875	43.221716694584	37.7685815908127	34.958895233338	32.3583556455642	33.2036805014074	32.5715331907528	32.1790576689769	34.8651659700771	36.1209000742178	34.8248260736675	32.3576397610223	30.1943927380285	25.0396470697203	25.1214886663242	25.2910278666909
Brazil	BRA	Food exports (% of merchandise exports)	TX.VAL.FOOD.ZS.UN	28.7338632317001	23.2364728342679	27.4725847081467	27.7626401163879	28.5324118669803	27.8816714191857	25.6748714047216	24.919964870428	26.3199672946763	27.7025022922255	34.1353062695048	30.3357630570466	30.4908707615954	32.3415443302793	35.2969912547616	35.6522920747707	37.9778956806647	37.8781906668221	36.1004202021097	34.6388149937206	34.5257195124328	38.9094713157649	34.7771632382264	39.5273943444507


CREATE TABLE economic_data (
  "country_name" VARCHAR,
  "country_code" VARCHAR,
  "indicator_name" VARCHAR,
  "indicator_code" VARCHAR,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "unnamed_67" VARCHAR
);