2015-2019 American Community Survey Basic Census Tract Data

BASIC CHARACTERISTICS OF PEOPLE AND HOUSING FOR INDIVIDUAL 2010 CENSUS TRACT PORTIONS INSIDE OR OUTSIDE KCMO - Some demographic data are from the 2010 Census while other data are from the 2015-2019 American Community Survey - ACS. The ACS replaces what until 2000 was the Long Form of the census; both have been based on surveys of a partial sample of people. The ACS sample is so small that surveys from five years must be combined to be reliable. The 2015-2019 ACS is the most recent grouping of 5 years of data. ACS data have been proportioned to conform with 2010 Census total population and total households.

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 \"kcmo/20152019-american-community-survey-basic-census-dm2c-w4ys\".\"20152019_american_community_survey_basic_census\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.