Name: US Quarterly Income 1948 - 2020
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.53 MB
1,204 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  -- 1948:Q1,
  "n_1948_q2" VARCHAR  -- 1948:Q2,
  "n_1948_q3" VARCHAR  -- 1948:Q3,
  "n_1948_q4" VARCHAR  -- 1948:Q4,
  "n_1949_q1" VARCHAR  -- 1949:Q1,
  "n_1949_q2" VARCHAR  -- 1949:Q2,
  "n_1949_q3" VARCHAR  -- 1949:Q3,
  "n_1949_q4" VARCHAR  -- 1949:Q4,
  "n_1950_q1" VARCHAR  -- 1950:Q1,
  "n_1950_q2" VARCHAR  -- 1950:Q2,
  "n_1950_q3" VARCHAR  -- 1950:Q3,
  "n_1950_q4" VARCHAR  -- 1950:Q4,
  "n_1951_q1" VARCHAR  -- 1951:Q1,
  "n_1951_q2" VARCHAR  -- 1951:Q2,
  "n_1951_q3" VARCHAR  -- 1951:Q3,
  "n_1951_q4" VARCHAR  -- 1951:Q4,
  "n_1952_q1" VARCHAR  -- 1952:Q1,
  "n_1952_q2" VARCHAR  -- 1952:Q2,
  "n_1952_q3" VARCHAR  -- 1952:Q3,
  "n_1952_q4" VARCHAR  -- 1952:Q4,
  "n_1953_q1" VARCHAR  -- 1953:Q1,
  "n_1953_q2" VARCHAR  -- 1953:Q2,
  "n_1953_q3" VARCHAR  -- 1953:Q3,
  "n_1953_q4" VARCHAR  -- 1953:Q4,
  "n_1954_q1" VARCHAR  -- 1954:Q1,
  "n_1954_q2" VARCHAR  -- 1954:Q2,
  "n_1954_q3" VARCHAR  -- 1954:Q3,
  "n_1954_q4" VARCHAR  -- 1954:Q4,
  "n_1955_q1" VARCHAR  -- 1955:Q1,
  "n_1955_q2" VARCHAR  -- 1955:Q2,
  "n_1955_q3" VARCHAR  -- 1955:Q3,
  "n_1955_q4" VARCHAR  -- 1955:Q4,
  "n_1956_q1" VARCHAR  -- 1956:Q1,
  "n_1956_q2" VARCHAR  -- 1956:Q2,
  "n_1956_q3" VARCHAR  -- 1956:Q3,
  "n_1956_q4" VARCHAR  -- 1956:Q4,
  "n_1957_q1" VARCHAR  -- 1957:Q1,
  "n_1957_q2" VARCHAR  -- 1957:Q2,
  "n_1957_q3" VARCHAR  -- 1957:Q3,
  "n_1957_q4" VARCHAR  -- 1957:Q4,
  "n_1958_q1" VARCHAR  -- 1958:Q1,
  "n_1958_q2" VARCHAR  -- 1958:Q2,
  "n_1958_q3" VARCHAR  -- 1958:Q3,
  "n_1958_q4" VARCHAR  -- 1958:Q4,
  "n_1959_q1" VARCHAR  -- 1959:Q1,
  "n_1959_q2" VARCHAR  -- 1959:Q2,
  "n_1959_q3" VARCHAR  -- 1959:Q3,
  "n_1959_q4" VARCHAR  -- 1959:Q4,
  "n_1960_q1" VARCHAR  -- 1960:Q1,
  "n_1960_q2" VARCHAR  -- 1960:Q2,
  "n_1960_q3" VARCHAR  -- 1960:Q3,
  "n_1960_q4" VARCHAR  -- 1960:Q4,
  "n_1961_q1" VARCHAR  -- 1961:Q1,
  "n_1961_q2" VARCHAR  -- 1961:Q2,
  "n_1961_q3" VARCHAR  -- 1961:Q3,
  "n_1961_q4" VARCHAR  -- 1961:Q4,
  "n_1962_q1" VARCHAR  -- 1962:Q1,
  "n_1962_q2" VARCHAR  -- 1962:Q2,
  "n_1962_q3" VARCHAR  -- 1962:Q3,
  "n_1962_q4" VARCHAR  -- 1962:Q4,
  "n_1963_q1" VARCHAR  -- 1963:Q1,
  "n_1963_q2" VARCHAR  -- 1963:Q2,
  "n_1963_q3" VARCHAR  -- 1963:Q3,
  "n_1963_q4" VARCHAR  -- 1963:Q4,
  "n_1964_q1" VARCHAR  -- 1964:Q1,
  "n_1964_q2" VARCHAR  -- 1964:Q2,
  "n_1964_q3" VARCHAR  -- 1964:Q3,
  "n_1964_q4" VARCHAR  -- 1964:Q4,
  "n_1965_q1" VARCHAR  -- 1965:Q1,
  "n_1965_q2" VARCHAR  -- 1965:Q2,
  "n_1965_q3" VARCHAR  -- 1965:Q3,
  "n_1965_q4" VARCHAR  -- 1965:Q4,
  "n_1966_q1" VARCHAR  -- 1966:Q1,
  "n_1966_q2" VARCHAR  -- 1966:Q2,
  "n_1966_q3" VARCHAR  -- 1966:Q3,
  "n_1966_q4" VARCHAR  -- 1966:Q4,
  "n_1967_q1" VARCHAR  -- 1967:Q1,
  "n_1967_q2" VARCHAR  -- 1967:Q2,
  "n_1967_q3" VARCHAR  -- 1967:Q3,
  "n_1967_q4" VARCHAR  -- 1967:Q4,
  "n_1968_q1" VARCHAR  -- 1968:Q1,
  "n_1968_q2" VARCHAR  -- 1968:Q2,
  "n_1968_q3" VARCHAR  -- 1968:Q3,
  "n_1968_q4" VARCHAR  -- 1968:Q4,
  "n_1969_q1" VARCHAR  -- 1969:Q1,
  "n_1969_q2" VARCHAR  -- 1969:Q2,
  "n_1969_q3" VARCHAR  -- 1969:Q3,
  "n_1969_q4" VARCHAR  -- 1969:Q4,
  "n_1970_q1" VARCHAR  -- 1970:Q1,
  "n_1970_q2" VARCHAR  -- 1970:Q2,
  "n_1970_q3" VARCHAR  -- 1970:Q3,
  "n_1970_q4" VARCHAR  -- 1970:Q4
);