Employment Data by City

Employment and unemployment data by city for places in San Mateo County. CDP is "Census Designated Place" - a recognized community that was unincorporated at the time of the 2000 Census.

1) Data may not add due to rounding. All unemployment rates shown are calculated on unrounded data.

2) These data are not seasonally adjusted.

Methodology: Monthly city and CDP labor force data are derived by multiplying current estimates of county employment and unemployment by the employment and unemployment shares (ratios) of each city and CDP at the time of the 2000 Census. Ratios for cities of 25,000 or more persons were developed from special tabulations based on household population only from the Bureau of Labor Statistics. For smaller cities and CDP, ratios were calculated from published census data.

City and CDP unrounded employment and unemployment are summed to get the labor force. The unemployment rate is calculated by dividing unemployment by the labor force. Then the labor force, employment, and unemployment are rounded.

This method assumes that the rates of change in employment and unemployment, since 2000, are exactly the same in each city and CDP as at the county level (i.e., that the shares are still accurate). If this assumption is not true for a specific city or CDP, then the estimates for that area may not represent the current economic conditions. Since this assumption is untested, caution should be employed when using these data.

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 \"datahub-smcgov/employment-data-by-city-dfpx-psxi\".\"employment_data_by_city\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.