Unemployment Rate by Metro Area (2022) DRAFT

VITAL SIGNS INDICATOR

Unemployment (EC3)

FULL MEASURE NAME

Unemployment rate by residential location

LAST UPDATED

December 2022

DESCRIPTION

Unemployment refers to the share of the labor force – by place of residence – that is not currently employed full-time or part-time. The unemployment rate reflects the strength of the overall employment market.

DATA SOURCE

California Employment Development Department: Historical Unemployment Rates

1990-2010

Spreadsheet provided by CAEDD

California Employment Development Department: Labor Force and Unemployment Rate for California Sub-County Areas - https://data.edd.ca.gov/Labor-Force-and-Unemployment-Rates/Labor-Force-and-Unemployment-Rate-for-California-S/8z4h-2ak6

2010-2022

California Employment Development Department: Local Area Unemployment Statistics (LAUS) - https://data.edd.ca.gov/Labor-Force-and-Unemployment-Rates/Local-Area-Unemployment-Statistics-LAUS-/e6gw-gvii

1990-2022

U.S. Bureau of Labor Statistics: Local Area Unemployment Statistics (LAUS) - https://download.bls.gov/pub/time.series/la

1990-2021

CONTACT INFORMATION

vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)

Unemployment rates produced by the CA Employment Development Department (EDD) for the region and county levels are not adjusted for seasonality (as they reflect annual data) and are final data (i.e., not preliminary). Unemployment rates produced by U.S. Bureau of Labor Statistics (BLS) for the metro regions are annual and not adjusted for seasonality; they reflect the primary metropolitan statistical area (MSA) for the named region, except for the San Francisco Bay Area which uses the nine-county region. The unemployment rate is calculated based on the number of unemployed persons divided by the total labor force. Note that the unemployment rate can decline or increase as a result of changes in either variable.

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/unemployment-rate-by-metro-area-2022-draft-2ywy-pwxn\".\"unemployment_rate_by_metro_area_2022_draft\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.