US Economic Indicators (1991-2023)

Data sourced from the IMF, Yahoo Finance, and the Federal Housing Finance Agency

@kaggle.niranjankrishnan_us_economic_indicators_1991_2023

Table List

2 tables(522.5 KB)

Usdataset

@kaggle.niranjankrishnan_us_economic_indicators_1991_2023.usdataset

111.81 KB
6570 rows
21 columns

hpi_type Hpi Type	hpi_flavor Hpi Flavor	frequency Frequency	level Level	place_name Place Name	place_id Place Id	yr Yr	period Period	index_nsa Index Nsa	index_sa Index Sa	gross_domestic_product_constant_prices Gross Domestic Product, Constant Prices	gross_domestic_product_per_capita_constant_prices Gross Domestic Product Per Capita, Constant Prices	gross_domestic_product_per_capita_current_prices Gross Domestic Product Per Capita, Current Prices	gross_domestic_product_based_on_purchasing_power_parit_2775ca00 Gross Domestic Product Based On Purchasing-power-parity (PPP) Share Of World Total	inflation_average_consumer_prices Inflation, Average Consumer Prices	volume_of_imports_of_goods_and_services Volume Of Imports Of Goods And Services	volume_of_exports_of_goods_and_services Volume Of Exports Of Goods And Services	unemployment_rate Unemployment Rate	current_account_balance Current Account Balance	date Date	gspc_close GSPC.Close
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	1	100	100	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-01-1991	343.9299927
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	2	100.89	100.95	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-02-1991	367.0700073
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	3	101.3	100.92	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-03-1991	375.2200012
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	4	101.69	100.98	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-04-1991	375.3399963
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	5	102.31	101.36	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-05-1991	389.8299866
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	6	102.77	101.5	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-06-1991	371.1600037
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	7	102.96	101.84	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-07-1991	387.8099976
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	8	103.12	102.03	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-08-1991	395.4299927
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	9	102.85	101.99	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-09-1991	387.8599854
traditional	purchase-only	monthly	USA or Census Division	East North Central Division	DV_ENC	1991	10	103.06	102.33	-0.108	36944.07	24302.78	20.985	4.216	-0.151	6.612	6.85	0.047	01-10-1991	392.4500122


CREATE TABLE usdataset (
  "hpi_type" VARCHAR,
  "hpi_flavor" VARCHAR,
  "frequency" VARCHAR,
  "level" VARCHAR,
  "place_name" VARCHAR,
  "place_id" VARCHAR,
  "yr" BIGINT,
  "period" BIGINT,
  "index_nsa" DOUBLE,
  "index_sa" DOUBLE,
  "gross_domestic_product_constant_prices" DOUBLE,
  "gross_domestic_product_per_capita_constant_prices" DOUBLE,
  "gross_domestic_product_per_capita_current_prices" DOUBLE,
  "gross_domestic_product_based_on_purchasing_power_parit_2775ca00" DOUBLE,
  "inflation_average_consumer_prices" DOUBLE,
  "volume_of_imports_of_goods_and_services" DOUBLE,
  "volume_of_exports_of_goods_and_services" DOUBLE,
  "unemployment_rate" DOUBLE,
  "current_account_balance" DOUBLE,
  "date" VARCHAR,
  "gspc_close" DOUBLE
);