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
  • 979.95 KB
  • 5528 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,
  "n_1998" VARCHAR,
  "n_1999" VARCHAR,
  "n_2000" VARCHAR,
  "n_2001" VARCHAR,
  "n_2002" VARCHAR,
  "n_2003" VARCHAR,
  "n_2004" VARCHAR,
  "n_2005" VARCHAR,
  "n_2006" VARCHAR,
  "n_2007" VARCHAR,
  "n_2008" VARCHAR,
  "n_2009" VARCHAR,
  "n_2010" VARCHAR,
  "n_2011" VARCHAR,
  "n_2012" VARCHAR,
  "n_2013" VARCHAR,
  "n_2014" VARCHAR,
  "n_2015" VARCHAR,
  "n_2016" VARCHAR,
  "n_2017" VARCHAR,
  "n_2018" DOUBLE,
  "n_2019" VARCHAR,
  "n_2020" VARCHAR
);

Share link

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