Dataset: US Quarterly Income 1948 - 2020

About this Dataset

US Quarterly Income 1948 - 2020

Context

This data is from the US Bureau of Economic Analysis -> https://bea.gov

Content

It covers 20 categories of income by state, by quarter in the US from 1948 - 2020

Here's a notebook that shows how the data is organized -> https://www.kaggle.com/davidbroberts/working-with-bea-data

Take a look at some of my other economics datasets:

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 Gross Domestic Product by State 1997-2020 -> https://www.kaggle.com/davidbroberts/us-gdp-by-state-19972020

Inspiration

I'm always interested to see how income varies, especially when compared to other events and data.

Thanks to https://unsplash.com/@mariapaganc for the splash pic.

Tables

Us Quarterly Personal Income 1948–2020

@kaggle.davidbroberts_us_quarterly_personal_income_1948_2020.us_quarterly_personal_income_1948_2020

2.42 MB
1204 rows
300 columns


CREATE TABLE us_quarterly_personal_income_1948_2020 (
  "geofips" VARCHAR,
  "geoname" VARCHAR,
  "region" VARCHAR,
  "tablename" VARCHAR,
  "linecode" DOUBLE,
  "industryclassification" VARCHAR,
  "description" VARCHAR,
  "unit" VARCHAR,
  "n_1948_q1" VARCHAR,
  "n_1948_q2" VARCHAR,
  "n_1948_q3" VARCHAR,
  "n_1948_q4" VARCHAR,
  "n_1949_q1" VARCHAR,
  "n_1949_q2" VARCHAR,
  "n_1949_q3" VARCHAR,
  "n_1949_q4" VARCHAR,
  "n_1950_q1" VARCHAR,
  "n_1950_q2" VARCHAR,
  "n_1950_q3" VARCHAR,
  "n_1950_q4" VARCHAR,
  "n_1951_q1" VARCHAR,
  "n_1951_q2" VARCHAR,
  "n_1951_q3" VARCHAR,
  "n_1951_q4" VARCHAR,
  "n_1952_q1" VARCHAR,
  "n_1952_q2" VARCHAR,
  "n_1952_q3" VARCHAR,
  "n_1952_q4" VARCHAR,
  "n_1953_q1" VARCHAR,
  "n_1953_q2" VARCHAR,
  "n_1953_q3" VARCHAR,
  "n_1953_q4" VARCHAR,
  "n_1954_q1" VARCHAR,
  "n_1954_q2" VARCHAR,
  "n_1954_q3" VARCHAR,
  "n_1954_q4" VARCHAR,
  "n_1955_q1" VARCHAR,
  "n_1955_q2" VARCHAR,
  "n_1955_q3" VARCHAR,
  "n_1955_q4" VARCHAR,
  "n_1956_q1" VARCHAR,
  "n_1956_q2" VARCHAR,
  "n_1956_q3" VARCHAR,
  "n_1956_q4" VARCHAR,
  "n_1957_q1" VARCHAR,
  "n_1957_q2" VARCHAR,
  "n_1957_q3" VARCHAR,
  "n_1957_q4" VARCHAR,
  "n_1958_q1" VARCHAR,
  "n_1958_q2" VARCHAR,
  "n_1958_q3" VARCHAR,
  "n_1958_q4" VARCHAR,
  "n_1959_q1" VARCHAR,
  "n_1959_q2" VARCHAR,
  "n_1959_q3" VARCHAR,
  "n_1959_q4" VARCHAR,
  "n_1960_q1" VARCHAR,
  "n_1960_q2" VARCHAR,
  "n_1960_q3" VARCHAR,
  "n_1960_q4" VARCHAR,
  "n_1961_q1" VARCHAR,
  "n_1961_q2" VARCHAR,
  "n_1961_q3" VARCHAR,
  "n_1961_q4" VARCHAR,
  "n_1962_q1" VARCHAR,
  "n_1962_q2" VARCHAR,
  "n_1962_q3" VARCHAR,
  "n_1962_q4" VARCHAR,
  "n_1963_q1" VARCHAR,
  "n_1963_q2" VARCHAR,
  "n_1963_q3" VARCHAR,
  "n_1963_q4" VARCHAR,
  "n_1964_q1" VARCHAR,
  "n_1964_q2" VARCHAR,
  "n_1964_q3" VARCHAR,
  "n_1964_q4" VARCHAR,
  "n_1965_q1" VARCHAR,
  "n_1965_q2" VARCHAR,
  "n_1965_q3" VARCHAR,
  "n_1965_q4" VARCHAR,
  "n_1966_q1" VARCHAR,
  "n_1966_q2" VARCHAR,
  "n_1966_q3" VARCHAR,
  "n_1966_q4" VARCHAR,
  "n_1967_q1" VARCHAR,
  "n_1967_q2" VARCHAR,
  "n_1967_q3" VARCHAR,
  "n_1967_q4" VARCHAR,
  "n_1968_q1" VARCHAR,
  "n_1968_q2" VARCHAR,
  "n_1968_q3" VARCHAR,
  "n_1968_q4" VARCHAR,
  "n_1969_q1" VARCHAR,
  "n_1969_q2" VARCHAR,
  "n_1969_q3" VARCHAR,
  "n_1969_q4" VARCHAR,
  "n_1970_q1" VARCHAR,
  "n_1970_q2" VARCHAR,
  "n_1970_q3" VARCHAR,
  "n_1970_q4" VARCHAR
);