Resident Workforce Demographic Characteristics by Commuting Mode Split : 2012 - 2016 (Historical)

This data set provides demographic and journey to work characteristics of the Cambridge Resident Workforce by primary mode of their journey to work. Attributes include age, 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 Resident Workforce consist of all persons who both live and work in Cambridge.

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/resident-workforce-demographic-characteristics-by-itk2-u4aa\".\"resident_workforce_demographic_characteristics_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.