Name: US Economic Indicators (1991-2023)
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

US Economic Indicators (1991-2023)

The dataset contains 41265 observations and 21 variables.
Each row represents a specific observation or data point.
The variables in the dataset include:
    hpi_type: Type of housing price index data (e.g., traditional, developmental, distress-free, non-metro).
    hpi_flavor: Flavor of the housing price index data (e.g., purchase-only, all-transactions, expanded-data).
    frequency: Frequency of the data (e.g., monthly, quarterly).
    level: Level of geography (e.g., USA or Census Division, State, MSA, Puerto Rico).
    place_name: Name of the place (e.g., region, state, metropolitan area).
    place_id: Identifier for the place (e.g., abbreviation, CBSA code).
    yr: Year of the data.
    period: Period of the data (e.g., month, quarter).
    index_nsa: Index, non seasonally adjusted.
    index_sa: Index, seasonally adjusted.
    Gross domestic product, constant prices: GDP at constant prices in national currency.
    Gross domestic product per capita, constant prices: GDP per capita at constant prices.
    Gross domestic product per capita, current prices: GDP per capita at current prices.
    Gross domestic product based on purchasing-power-parity (PPP) share of world total: GDP based on PPP as a share of world total GDP.
    Inflation, average consumer prices: Average consumer price inflation index.
    Volume of imports of goods and services: Volume change in imports of goods and services.
    Volume of exports of goods and services: Volume change in exports of goods and services.
    Unemployment rate: Percentage of total labor force unemployed.
    Current account balance: Balance of payments current account balance.
    Date: Date of the data.
    GSPC.Close: Closing price of the S&P 500 index.

Tables

Usdataset

@kaggle.niranjankrishnan_us_economic_indicators_1991_2023.usdataset

114.49 kB
6,570 rows
21 columns

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, Constant Prices,
  "gross_domestic_product_per_capita_constant_prices" DOUBLE  -- Gross Domestic Product Per Capita, Constant Prices,
  "gross_domestic_product_per_capita_current_prices" DOUBLE  -- Gross Domestic Product Per Capita, Current Prices,
  "gross_domestic_product_based_on_purchasing_power_parit_2775ca00" DOUBLE  -- Gross Domestic Product Based On Purchasing-power-parity (PPP) Share Of World Total,
  "inflation_average_consumer_prices" DOUBLE  -- Inflation, Average Consumer Prices,
  "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
);

Usdatasetv2

@kaggle.niranjankrishnan_us_economic_indicators_1991_2023.usdatasetv2

420.55 kB
41,265 rows
21 columns

CREATE TABLE usdatasetv2 (
  "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, Constant Prices,
  "gross_domestic_product_per_capita_constant_prices" DOUBLE  -- Gross Domestic Product Per Capita, Constant Prices,
  "gross_domestic_product_per_capita_current_prices" DOUBLE  -- Gross Domestic Product Per Capita, Current Prices,
  "gross_domestic_product_based_on_purchasing_power_parit_2775ca00" DOUBLE  -- Gross Domestic Product Based On Purchasing-power-parity (PPP) Share Of World Total,
  "inflation_average_consumer_prices" DOUBLE  -- Inflation, Average Consumer Prices,
  "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
);