Global Economy Indicators

World finance indicators data from 1970-2021

@kaggle.prasad22_global_economy_indicators

Table List

1 table(1.75 MB)

Global Economy Indicators

@kaggle.prasad22_global_economy_indicators.global_economy_indicators

1.75 MB
10512 rows
26 columns

n__countryid CountryID	n__country Country	n__year Year	n__ama_exchange_rate AMA Exchange Rate	n__imf_based_exchange_rate IMF Based Exchange Rate	n__population Population	n__currency Currency	n__per_capita_gni Per Capita GNI	n__agriculture_hunting_forestry_fishing_isic_a_b Agriculture, Hunting, Forestry, Fishing (ISIC A-B)	n__construction_isic_f Construction (ISIC F)	n__exports_of_goods_and_services Exports Of Goods And Services	n__final_consumption_expenditure Final Consumption Expenditure	n__general_government_final_consumption_expenditure General Government Final Consumption Expenditure	n__gross_capital_formation Gross Capital Formation	n__gross_fixed_capital_formation_including_acquisition_360a2222 Gross Fixed Capital Formation (including Acquisitions Less Disposals Of Valuables)	n__household_consumption_expenditure_including_non_pro_98126264 Household Consumption Expenditure (including Non-profit Institutions Serving Households)	n__imports_of_goods_and_services Imports Of Goods And Services	n__manufacturing_isic_d Manufacturing (ISIC D)	n__mining_manufacturing_utilities_isic_c_e Mining, Manufacturing, Utilities (ISIC C-E)	n__other_activities_isic_j_p Other Activities (ISIC J-P)	n__total_value_added Total Value Added	n__transport_storage_and_communication_isic_i Transport, Storage And Communication (ISIC I)	n__wholesale_retail_trade_restaurants_and_hotels_isic_g_h Wholesale, Retail Trade, Restaurants And Hotels (ISIC G-H)	n__gross_national_income_gni_in_usd Gross National Income(GNI) In USD	n__gross_domestic_product_gdp Gross Domestic Product (GDP)
4	Afghanistan	1970	0.044998427	0.044998427	10752971	Afghani	164	869917407	46793902	165618722	1663221269	112126986	94611818	94611818	1551094283	195277226	370146827	376690811	127747843	1731454254	83917200	226387091	1766527525	1731435587
4	Afghanistan	1971	0.044998427	0.044998427	11015857	Afghani	168	910828104	48994113	193580300	1796541240	121114833	99012350	99012350	1675426407	276296480	387549502	394401164	133754097	1812857077	87860382	237019196	1850121913	1812837521
4	Afghanistan	1972	0.044998427	0.044998427	11286753	Afghani	149	827945340	44535223	227654380	1607159399	108347543	103456794	103456794	1498811856	290370350	352284669	358512865	121582672	1647917912	79864525	215477287	1683947905	1647900178
4	Afghanistan	1973	0.044998427	0.044998427	11575305	Afghani	150	855486925	46018542	226913554	1617037233	109013455	121728433	121728433	1508023800	262962880	364010279	370445793	125630236	1702734673	82528885	222624293	1739998153	1702716294
4	Afghanistan	1974	0.044998427	0.044998427	11869879	Afghani	177	1035913365	55721659	284938449	1907408182	128588961	175061875	175061875	1778819221	305679151	440760406	448552790	152119162	2061751510	99918604	269525910	2106420227	2061729287
4	Afghanistan	1975	0.044998427	0.044998427	12157386	Afghani	195	1165441381	62686658	300493815	2131358499	143686711	221728484	221728484	1987671788	333827202	495891889	504659018	171142804	2319778374	112416374	303432162	2369877014	2319753506
4	Afghanistan	1976	0.044998427	0.044998427	12425267	Afghani	207	1262891632	67941997	329382802	2232098998	150478171	322716302	322716302	2081620805	370617399	537391228	546891983	185472327	2513608060	121865126	328544951	2568148611	2513580659
4	Afghanistan	1977	0.044998427	0.044998427	12687301	Afghani	231	1439687056	77430595	342962988	2584198550	174215156	362716078	362716078	2409983394	424938409	612470141	623298276	211382277	2864969897	138798518	374373152	2927408257	2864939207
4	Afghanistan	1978	0.044998427	0.044998427	12938862	Afghani	254	1618731870	87058287	354814847	2883951161	194423174	437531071	437531071	2689527987	453333379	688846878	701025415	237719665	3222997856	156155903	422306672	3292593311	3222963833
4	Afghanistan	1979	0.043730753	0.043730753	12986369	Afghani	285	1824507919	98215848	424287344	3241236374	218509730	487588175	487588175	3022726644	522344151	776522761	790251109	268036272	3630809406	176271742	473526514	3707542111	3630767856


CREATE TABLE global_economy_indicators (
  "n__countryid" BIGINT,
  "n__country" VARCHAR,
  "n__year" BIGINT,
  "n__ama_exchange_rate" DOUBLE,
  "n__imf_based_exchange_rate" DOUBLE,
  "n__population" BIGINT,
  "n__currency" VARCHAR,
  "n__per_capita_gni" BIGINT,
  "n__agriculture_hunting_forestry_fishing_isic_a_b" DOUBLE,
  "n__changes_in_inventories" DOUBLE,
  "n__construction_isic_f" DOUBLE,
  "n__exports_of_goods_and_services" DOUBLE,
  "n__final_consumption_expenditure" DOUBLE,
  "n__general_government_final_consumption_expenditure" DOUBLE,
  "n__gross_capital_formation" DOUBLE,
  "n__gross_fixed_capital_formation_including_acquisition_360a2222" DOUBLE,
  "n__household_consumption_expenditure_including_non_pro_98126264" DOUBLE,
  "n__imports_of_goods_and_services" DOUBLE,
  "n__manufacturing_isic_d" DOUBLE,
  "n__mining_manufacturing_utilities_isic_c_e" DOUBLE,
  "n__other_activities_isic_j_p" DOUBLE,
  "n__total_value_added" DOUBLE,
  "n__transport_storage_and_communication_isic_i" DOUBLE,
  "n__wholesale_retail_trade_restaurants_and_hotels_isic_g_h" DOUBLE,
  "n__gross_national_income_gni_in_usd" DOUBLE,
  "n__gross_domestic_product_gdp" DOUBLE
);