Vital Signs: Jobs by Industry (Location Quotient) by County (2022)
VITAL SIGNS INDICATOR
Jobs by Industry (EC1)
FULL MEASURE NAME
Employment by place of work by industry sector
LAST UPDATED
December 2022
DESCRIPTION
Jobs by industry refers to both the change in employment levels by industry and the proportional mix of jobs by economic sector. This measure reflects the changing industry trends that affect our region’s workers.
DATA SOURCE
Bureau of Labor Statistics, Quarterly Census of Employment and Wages (QCEW) - https://www.bls.gov/cew/downloadable-data-files.htm
1990-2021
CONTACT INFORMATION
vitalsigns.info@bayareametro.gov
METHODOLOGY NOTES (across all datasets for this indicator)
Quarterly Census of Employment and Wages (QCEW) employment data is reported by the place of work and 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.
The location quotient (LQ) is used to evaluate level of concentration or clustering of an industry within the Bay Area and within each county of the region. A location quotient greater than 1 means there is a strong concentration for of jobs in an industry sector. For the Bay Area, the LQ is calculated as the share of the region’s employment in a particular sector divided by the share of California's employment in that same sector. For each county, the LQ is calculated as the share of the county’s employment in a particular sector divided by the share of the region’s employment in that same sector.
Data is mainly pulled from aggregation level 73, which is county-level summarized at the North American Industry Classification System (NAICS) supersector level (12 sectors). This aggregation level exhibits the least loss due to data suppression, in the magnitude of 1-2 percent for regional employment, and is therefore preferred. However, the supersectors group together NAICS 11 Agriculture, Forestry, Fishing and Hunting; NAICS 21 Mining and NAICS 23 Construction. To provide a separate tally of Agriculture, Forestry, Fishing and Hunting, the aggregation level 74 data was used for NAICS codes 11, 21 and 23.
QCEW reports on employment in Public Administration as NAICS 92. However, many government activities are reported with an industry specific code - such as transportation or utilities even if those may be public governmental entities. In 2021 for the Bay Area, the largest industry groupings under public ownership are Education and health services (58%); Public administration (29%) and Trade, transportation, and utilities (29%). With the exception of Education and health services, all other public activities were coded as government/public administration, regardless of industry group.
For the county data there were some industries that reported 0 jobs or did not report jobs at the desired aggregation/NAICS level for the following counties/years:
Farm:
(aggregation level: 74, NAICS code: 11)
Contra Costa: 2008-2010
Marin: 1990-2006, 2008-2010, 2014-2020
Napa: 1990-2004, 2013-2021
San Francisco: 2019-2020
San Mateo: 2013
Information:
(aggregation level: 73, NAICS code: 51)
Financial Activities:
(aggregatio
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-industry-location-quotient-by-uijm-ykyx\".\"vital_signs_jobs_by_industry_location_quotient_by\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
