Vital Signs: Jobs by Metro Area (2022)

VITAL SIGNS INDICATOR

Jobs (LU2)

FULL MEASURE NAME

Employment estimates by place of work

LAST UPDATED

October 2022

DESCRIPTION

Jobs refers to the number of employees in a given area by place of work. These estimates do not include self-employed and private household employees.

DATA SOURCE

Bureau of Labor Statistics, Quarterly Census of Employment and Wages - https://www.bls.gov/cew/downloadable-data-files.htm

1990-2021

U.S. Census Bureau: LODES Data - http://lehd.ces.census.gov/

Longitudinal Employer-Household Dynamics Program

2002-2018

METHODOLOGY NOTES (across all datasets for this indicator)

Quarterly Census of Employment and Wages (QCEW) monthly employment data represent the number of covered workers who worked during, or received pay for, the pay period that included the 12th day of the month. Covered employees in the private-sector and in the state and local government include most corporate officials, all executives, all supervisory personnel, all professionals, all clerical workers, many farmworkers, all wage earners, all piece workers and all part-time workers. Workers on paid sick leave, paid holiday, paid vacation and the like are also covered.

Besides excluding the aforementioned national security agencies, QCEW excludes proprietors, the unincorporated self-employed, unpaid family members, certain farm and domestic workers exempted from having to report employment data and railroad workers covered by the railroad unemployment insurance system. Excluded as well are workers who earned no wages during the entire applicable pay period because of work stoppages, temporary layoffs, illness or unpaid vacations.

For measuring jobs below the county level, Vital Signs assigns collections of incorporated cities and towns to sub-county areas. For example, the cities of East Palo Alto, Menlo Park, Portola Valley, Redwood City and Woodside are considered South San Mateo County. Because Bay Area counties differ in footprint, the number of cities included in a sub-county is one for San Francisco and San Jose and more than one for all other sub-counties. Estimates for sub-county areas are the sums of Census block-level estimates from the U.S. Census Bureau: LEHD data.

The following incorporated cities and towns are included in each sub-county area:

• North Alameda County: Alameda, Albany, Berkeley, Emeryville, Oakland, Piedmont

• East Alameda County: Dublin, Livermore, Pleasanton

• South Alameda County: Fremont, Hayward, Newark, San Leandro, Union City

• Central Contra Costa County: Clayton, Concord, Danville, Lafayette, Martinez, Moraga, Orinda, Pleasant Hill, San Ramon, Walnut Creek

• East Contra Costa County: Antioch, Brentwood, Oakley, Pittsburg

• West Contra Costa County: El Cerrito, Hercules, Pinole, Richmond, San Pablo

• Marin County: Belvedere, Corte Madera, Fairfax, Larkspur, Mill Valley, Novato, Ross, San Anselmo, San Rafael, Sausalito, Tiburon

• Napa County: American Canyon, Calistoga, Napa, St. Helena, Yountville

• San Francisco County: San Francisco

• North San Mateo County: Brisbane, Colma, Daly City, Millbrae, Pacifica, San Bruno, South San Francisco

• Central San Mateo County: Belmont, Burlingame, Foster City, Half Moon Bay, Hillsborough, San Carlos, San Mateo

• South San Mateo County: East Palo Alto, Menlo Park, Portola Valley, Redwood City, Woodside, Atherton

• North Santa Clara County: Los Altos, Los Altos Hills, Milpitas, Mountain View, Palo Alto, Santa Clara, Sunnyvale

• San Jose: San Jose

• Southwest Santa Clara County: Campbell, Cupertino, Los Gatos, Monte Sereno, Saratoga

• South Santa Clara County: Gilroy, Morgan Hill

• East Solano County: Dixon, Fairfield, Rio Vista, Suisun City, Vacaville

• South Solano County: Benicia, Vallejo

• North Sonoma County: Cloverdale, Healdsburg, Windsor

• South Sonoma County: Cotati, Petaluma, Rohnert Park, Santa Rosa, Sebastopol, Sonoma

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-jobs-by-metro-area-2022-ru82-hdft\".\"vital_signs_jobs_by_metro_area_2022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.