Disability Status (ACS 2019)
This data layer depicts, by census tract, the number of people that have a disability 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 B18101 and joined the table to a Census 2010 tract polygon feature set. The joined feature set was then exported to create a feature set representing the disability status of persons, by tract, for the region.
The resulting attribute table had all margin of error and non-disability fields deleted and the remaining field names were changed. In addition, a percent of population field was added for each disability field and percent fields for total disabled, total male disabled, and total female disabled fields were added.
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=B18101&g=0400000US06%241400000&tid=ACSDT5Y2019.B18101
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/disability-status-acs-2019-bxi4-cbn7\".\"disability_status_acs_2019\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
