Vital Signs: Commute Patterns - Bay Area (2022) DRAFT

VITAL SIGNS INDICATOR

Vital Signs: Commute Patterns - Bay Area (2022) DRAFT

FULL MEASURE NAME

Commute flows between Bay Area counties

LAST UPDATED

July 2022

DESCRIPTION

Commute patterns, more commonly referred to as county-to-county commute flows, reflect the number of individuals traveling within and between various counties for commuting purposes.

DATA SOURCE

U.S. Census Bureau, American Community Survey, 2016-2020 Public Use Microdata Sample

CONTACT INFORMATION

vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)

Data is summarized from the national PUMS person file, including records where either origin or destination is in the Bay Area.

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/vital-signs-commute-patterns-bay-area-2022-draft-j7ht-u3pq\".\"vital_signs_commute_patterns_bay_area_2022_draft\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.