bayareametro-gov/vital-signs-change-in-jobs-by-industry-bay-area-tm3u-9jvc
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 4 years ago
Indexed 1 month ago

Vital Signs: Change in Jobs by Industry – Bay Area

VITAL SIGNS INDICATOR

Change in Jobs by Industry (EC2)

FULL MEASURE NAME

Employment by place of work by industry sector

LAST UPDATED

May 2019

DESCRIPTION

Change in jobs by industry is the percent change and absolute difference in the number of people who have jobs within a certain industry type in a given geographical area

DATA SOURCE

California Employment Development Department: Current Employment Statistics

1990-2017

http://www.labormarketinfo.edd.ca.gov/

CONTACT INFORMATION

vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)

The California Employment Development Department (EDD) provides estimates of employment by place of work and by industry. Industries are classified by their North American Industry Classification System (NAICS) code. Vital Signs aggregates employment into 11 industry sectors: Farm, Mining, Logging and Construction, Manufacturing, Trade, Transportation and Utilities, Information, Financial Activities, Professional and Business Services, Educational and Health Services, Leisure and Hospitality, Government, and Other. EDD counts all public-sector jobs under Government, including public transportation, public schools, and public hospitals. The Other category includes service jobs such as auto repair and hair salons and organizations such as churches and social advocacy groups. Employment in the technology sector are classified under three categories: Professional and Business Services, Information, and Manufacturing. The latter category includes electronic and computer manufacturing. For further details of typical firms found in each sector, refer to the 2012 NAICS Manual (http://www.census.gov/cgi-bin/sssd/naics/naicsrch?chart=2012).

The Bureau of Labor Statistics (BLS) provides industry estimates for non-Bay Area metro areas. Their main industry employment estimates, the Current Employment Survey and Quarterly Census of Employment and Wages, do not provide annual estimates of farm employment. To be consistent, the metro comparison evaluates nonfarm employment for all metro areas, including the Bay Area. Industry shares are thus slightly different for the Bay Area between the historical trend and metro comparison sections.

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 the nation’s employment in that same sector. Because BLS does not provide national farm estimates, note that there is no LQ for regional farm employment. 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.

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-change-in-jobs-by-industry-bay-area-tm3u-9jvc\".\"vital_signs_change_in_jobs_by_industry_bay_area\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • vital_signs_change_in_jobs_by_industry_bay_area