AB617 CERP Mean Household Income "Path to Clean Air"

Dataset Name: 2016-2020 American Community Survey 5-Year Estimates, Table S1902 - MEAN INCOME IN THE PAST 12 MONTHS (IN 2020 INFLATION-ADJUSTED DOLLARS)

URL: https://data.census.gov/, https://data.census.gov/cedsci/table?q=United%20States&t=Income%20and%20Earnings&g=0500000US06001,06013,06041_1600000US0604470,0621061,0622454,0648718,0652162,0660620,0662700,0668294,0677924&tid=ACSST5Y2020.S1902

Where dataset is from: U.S. Census Bureau

When obtained: 5/10/2022

For what purpose it was obtained: General AB 617 Planning

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/ab617-cerp-mean-household-income-path-to-clean-air-gedi-2uzt\".\"ab617_cerp_mean_household_income_path_to_clean_air\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.