Cost-Burdened Households - Mortgage as a Percent of Household Income (ACS 2019)

This data layer depicts, by census tract, mortgage payments as a percentage of household income in the past 12 months for the San Francisco Bay Region. The source data, from the United States Census Bureau, has been reprocessed by the Metropolitan Transportation Commission.

To produce this feature set, the Metropolitan Transportation Commission downloaded American Community Survey (ACS) table B25091 to create a feature set representing housing unit mortgage payments as a percentage of household income by the following categories:

● Mortgage less than 30% of household income

● Mortgage is 30.0% to 49.9% of household income

● Mortgage is greater than or equal to 50% of household income

The resulting attribute table had all margin of error fields deleted, housing units without a mortgage fields deleted, percentage fields added, county code field added, jurisdiction name added, and the source field names were changed.

The source table used to develop this feature service is from the United States Census Bureau, 2015-2019 American Community Survey 5-Year Estimates and can be downloaded from https://data.census.gov/cedsci/table?q=B25091%3A%20MORTGAGE%20STATUS%20BY%20SELECTED%20MONTHLY%20OWNER%20COSTS%20AS%20A%20PERCENTAGE%20OF%20HOUSEHOLD%20INCOME%20IN%20THE%20PAST%2012%20MONTHS&g=0400000US06%241500000&tid=ACSDT5Y2019.B25091

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/costburdened-households-mortgage-as-a-percent-of-fzm5-c59h\".\"costburdened_households_mortgage_as_a_percent_of\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.