Global Economy Indicators
World finance indicators data from 1970-2021
@kaggle.prasad22_global_economy_indicators
World finance indicators data from 1970-2021
@kaggle.prasad22_global_economy_indicators
The dataset is compiled from the National Accounts Main Aggregates Database that presents a series of analytical national accounts tables from 1970 onwards for more than 200 countries and areas of the world. It is the product of a global cooperation effort between the Economic Statistics Branch of the United Nations Statistics Division, international statistical agencies, and the national statistical services of these countries and is developed in accordance with the recommendation of the Statistical Commission at its first session in 1947 that the Statistics Division should publish regularly the most recent available data on national accounts for as many countries and areas as possible.
This dataset can be used to perform clustering, regression, and time series tasks.
CREATE TABLE global_economy_indicators (
"n__countryid" BIGINT -- CountryID,
"n__country" VARCHAR -- Country,
"n__year" BIGINT -- Year,
"n__ama_exchange_rate" DOUBLE -- AMA Exchange Rate,
"n__imf_based_exchange_rate" DOUBLE -- IMF Based Exchange Rate,
"n__population" BIGINT -- Population,
"n__currency" VARCHAR -- Currency,
"n__per_capita_gni" BIGINT -- Per Capita GNI,
"n__agriculture_hunting_forestry_fishing_isic_a_b" DOUBLE -- Agriculture, Hunting, Forestry, Fishing (ISIC A-B),
"n__changes_in_inventories" DOUBLE -- Changes In Inventories,
"n__construction_isic_f" DOUBLE -- Construction (ISIC F),
"n__exports_of_goods_and_services" DOUBLE -- Exports Of Goods And Services,
"n__final_consumption_expenditure" DOUBLE -- Final Consumption Expenditure,
"n__general_government_final_consumption_expenditure" DOUBLE -- General Government Final Consumption Expenditure,
"n__gross_capital_formation" DOUBLE -- Gross Capital Formation,
"n__gross_fixed_capital_formation_including_acquisition_360a2222" DOUBLE -- Gross Fixed Capital Formation (including Acquisitions Less Disposals Of Valuables),
"n__household_consumption_expenditure_including_non_pro_98126264" DOUBLE -- Household Consumption Expenditure (including Non-profit Institutions Serving Households),
"n__imports_of_goods_and_services" DOUBLE -- Imports Of Goods And Services,
"n__manufacturing_isic_d" DOUBLE -- Manufacturing (ISIC D),
"n__mining_manufacturing_utilities_isic_c_e" DOUBLE -- Mining, Manufacturing, Utilities (ISIC C-E),
"n__other_activities_isic_j_p" DOUBLE -- Other Activities (ISIC J-P),
"n__total_value_added" DOUBLE -- Total Value Added,
"n__transport_storage_and_communication_isic_i" DOUBLE -- Transport, Storage And Communication (ISIC I),
"n__wholesale_retail_trade_restaurants_and_hotels_isic_g_h" DOUBLE -- Wholesale, Retail Trade, Restaurants And Hotels (ISIC G-H),
"n__gross_national_income_gni_in_usd" DOUBLE -- Gross National Income(GNI) In USD,
"n__gross_domestic_product_gdp" DOUBLE -- Gross Domestic Product (GDP)
);Anyone who has the link will be able to view this.