Baselight

US GDP By State 1997-2020

How much does each state produce?

@kaggle.davidbroberts_us_gdp_by_state_19972020

Loading...
Loading...

About this Dataset

US GDP By State 1997-2020

Bureau Of Economic Analysis data on the Gross Domestic Product of each US state from 1997 to 2020

This dataset contains a file with 5528 rows and 32 columns of GDP data representing various industries.

Here's a notebook that explains the basics of the data -> https://www.kaggle.com/davidbroberts/us-gdp-by-state-1997-2020

Take a look at some of my other economic datasets:

US Quarterly Income 1948 - 2020 -> https://www.kaggle.com/davidbroberts/us-quarterly-personal-income-1948-2020
US Economic Profile by County 1969 - 2020 -> https://www.kaggle.com/davidbroberts/us-economic-profile-by-county
US Personal Expenditures by State 1997-2019 -> https://www.kaggle.com/davidbroberts/us-personal-expenditures-by-state-19972019
US Employment by Industry 2001-2019 ->https://www.kaggle.com/davidbroberts/us-employment-by-industry-2001-2019

I've always wondered which states produce stuff ..

Tables

Sagdp2n All Areas 1997–2020

@kaggle.davidbroberts_us_gdp_by_state_19972020.sagdp2n_all_areas_1997_2020
  • 1 MB
  • 5,528 rows
  • 32 columns
Loading...
CREATE TABLE sagdp2n_all_areas_1997_2020 (
  "geofips" VARCHAR,
  "geoname" VARCHAR,
  "region" VARCHAR,
  "tablename" VARCHAR,
  "linecode" DOUBLE,
  "industryclassification" VARCHAR,
  "description" VARCHAR,
  "unit" VARCHAR,
  "n_1997" VARCHAR  -- 1997,
  "n_1998" VARCHAR  -- 1998,
  "n_1999" VARCHAR  -- 1999,
  "n_2000" VARCHAR  -- 2000,
  "n_2001" VARCHAR  -- 2001,
  "n_2002" VARCHAR  -- 2002,
  "n_2003" VARCHAR  -- 2003,
  "n_2004" VARCHAR  -- 2004,
  "n_2005" VARCHAR  -- 2005,
  "n_2006" VARCHAR  -- 2006,
  "n_2007" VARCHAR  -- 2007,
  "n_2008" VARCHAR  -- 2008,
  "n_2009" VARCHAR  -- 2009,
  "n_2010" VARCHAR  -- 2010,
  "n_2011" VARCHAR  -- 2011,
  "n_2012" VARCHAR  -- 2012,
  "n_2013" VARCHAR  -- 2013,
  "n_2014" VARCHAR  -- 2014,
  "n_2015" VARCHAR  -- 2015,
  "n_2016" VARCHAR  -- 2016,
  "n_2017" VARCHAR  -- 2017,
  "n_2018" DOUBLE  -- 2018,
  "n_2019" VARCHAR  -- 2019,
  "n_2020" VARCHAR  -- 2020
);

Share link

Anyone who has the link will be able to view this.