Labor Force Commuting Mode Split: 1990, 2000, 2006 - 2010, and 2012 - 2016

This data set compares 1990, 2000, 2006 - 2010, and 2012-16 Journey to Work data, outlining the modes of commuting for the Labor Force of the City of Cambridge, regardless of workplace location. The data set originates from three sources: 1990 Journey to Work data supplied to the Massachusetts Central Transportation Planning Staff by the Census Bureau, a special tabulation of 2000 Decennial Census data - the 2000 Census Transportation Planning Products (CTPP), and the two most recent versions of the CTPP compiled from the American Community Survey. The Cambridge Labor Force consist of all Cambridge residents who work or who are currently seeking work, regardless of workplace location.

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-commuting-mode-split-1990-2000-2006-8acn-zxjt\".\"labor_force_commuting_mode_split_1990_2000_2006\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.