Familial Type - Households with Children (ACS 2019)

This data layer depicts, by census tract, households with children 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 B11005 to create a feature set representing households with children that are headed by married couples, single-parents, and other for the region.

The resulting attribute table had all margin of error and non-child household fields deleted and the remaining 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=B11005%3A%20HOUSEHOLDS%20BY%20PRESENCE%20OF%20PEOPLE%20UNDER%2018%20YEARS%20BY%20HOUSEHOLD%20TYPE&g=0400000US06%241500000&tid=ACSDT5Y2019.B11005

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/familial-type-households-with-children-acs-2019-sw8g-na7z\".\"familial_type_households_with_children_acs_2019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.