Labor Force Demographic Characteristics by Commuting Mode Split: 2012 - 2016

This data set provides demographic and journey to work characteristics of the Cambridge Labor Force by primary mode of their journey to work. Attributes include age, presence of children, racial and ethnic minority status, vehicles available, time leaving home, time spent traveling, and annual household income. The data set originates from a special tabulation of the American Community Survey - the 2012 - 2016 version of the Census Transportation Planning Products (CTPP). The Cambridge Labor Force consist of all persons who live in Cambridge who work or are actively seeking employment.

For more information on Journey to Work data in Cambridge, please see the report Moving Forward: 2020 - https://www.cambridgema.gov/-/media/Files/CDD/FactsandMaps/profiles/demo_moving_forward_2020.pdf

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 \"cambridgema-gov/labor-force-demographic-characteristics-by-wfre-hbsk\".\"labor_force_demographic_characteristics_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.