The Quarterly Census of Employment and Wages (QCEW) program is a cooperative program involving the Bureau of Labor Statistics (BLS) of the United States Department of Labor and the State Employment Security Agencies (SESAs). The QCEW program produces a comprehensive tabulation of employment and wage information for workers covered by State unemployment insurance (UI) laws and Federal workers covered by the Unemployment Compensation for Federal Employees (UCFE) program. Publicly available data files include information on the number of establishments, monthly employment, and quarterly wages, by NAICS industry, by county, by ownership sector, for the entire United States. These data are aggregated to annual levels, to higher industry levels (NAICS industry groups, sectors, and supersectors), and to higher geographic levels (national, State, and Metropolitan Statistical Area (MSA)). To download and analyze QCEW data, users can begin on the QCEW Databases page. Downloadable data are available in formats such as text and CSV. Data for the QCEW program that are classified using the North American Industry Classification System (NAICS) are available from 1990 forward, and on a more limited basis from 1975 to 1989. These data provide employment and wage information for arts-related NAICS industries, such as: Arts, entertainment, and recreation (NAICS Code 71) Performing arts and spectator sports Museums, historical sites, zoos, and parks Amusements, gambling, and recreation Professional, scientific, and technical services (NAICS Code 54) Architectural services Graphic design services Photographic services Retail trade (NAICS Code 44-45) Sporting goods, hobby, book and music stores Book, periodical, and music stores Art dealers For years 1975-2000, data for the QCEW program provide employment and wage information for arts-related industries are based on the Standard Industrial Classification (SIC) system. These arts-related SIC industries include the following: Book stores (SIC 5942) Commercial photography (SIC Code 7335) Commercial art and graphic design (SIC Code 7336) Museums, Botanical, Zoological Gardens (SIC Code 84) Dance studios, schools, and halls (SIC Code 7911) Theatrical producers and services (SIC Code 7922) Sports clubs, managers, & promoters (SIC Code 7941) Motion Picture Services (SIC Code 78) The QCEW program serves as a near census of monthly employment and quarterly wage information by 6-digit NAICS industry at the national, state, and county levels. At the national level, the QCEW program provides employment and wage data for almost every NAICS industry. At the State and area level, the QCEW program provides employment and wage data down to the 6-digit NAICS industry level, if disclosure restrictions are met. Employment data under the QCEW program represent the number of covered workers who worked during, or received pay for, the pay period including the 12th of the month. Excluded are members of the armed forces, the self-employed, proprietors, domestic workers, unpaid family workers, and railroad workers covered by the railroad unemployment insurance system. Wages represent total compensation paid during the calendar quarter, regardless of when services were performed. Included in wages are pay for vacation and other paid leave, bonuses, stock options, tips, the cash value of meals and lodging, and in some States, contributions to deferred compensation plans (such as 401(k) plans). The QCEW program does provide partial information on agricultural industries and employees in private households. Data from the QCEW program serve as an important source for many BLS programs. The QCEW data are used as the benchmark source for employment by the Current Employment Statistics program and the Occupational Employment Statistics program. The UI administrative records collected under the QCEW program serve as a sampling frame for BLS establishment surveys. In addition, data from the QCEW program serve as a source to other Federal and State programs. The Bureau of Economic Analysis (BEA) of the Department of Commerce uses QCEW data as the base for developing the wage and salary component of personal income. The Employment and Training Administration (ETA) of the Department of Labor and the SESAs use QCEW data to administer the employment security program. The QCEW data accurately reflect the ex

The Quarterly Census of Employment and Wages (QCEW) Program is a Federal-State cooperative program between the U.S. Department of Labor’s Bureau of Labor Statistics (BLS) and the California EDD’s Labor Market Information Division (LMID). The QCEW program produces a comprehensive tabulation of employment and wage information for workers covered by California Unemployment Insurance (UI) laws and Federal workers covered by the Unemployment Compensation for Federal Employees (UCFE) program.

The QCEW program serves as a near census of monthly employment and quarterly wage information by 6-digit industry codes from the North American Industry Classification System (NAICS) at the national, state, and county levels. At the national level, the QCEW program publishes employment and wage data for nearly every NAICS industry. At the state and local area level, the QCEW program publishes employment and wage data down to the 6-digit NAICS industry level, if disclosure restrictions are met. In accordance with the BLS policy, data provided to the Bureau in confidence are used only for specified statistical purposes and are not published. The BLS withholds publication of Unemployment Insurance law-covered employment and wage data for any industry level when necessary to protect the identity of cooperating employers.

Data from the QCEW program serve as an important input to many BLS programs. The Current Employment Statistics and the Occupational Employment Statistics programs use the QCEW data as the benchmark source for employment. The UI administrative records collected under the QCEW program serve as a sampling frame for the BLS establishment surveys.

In addition, the data serve as an input to other federal and state programs. The Bureau of Economic Analysis (BEA) of the Department of Commerce uses the QCEW data as the base for developing the wage and salary component of personal income.

The U.S. Department of Labor’s Employment and Training Administration (ETA) and California's EDD use the QCEW data to administer the Unemployment Insurance program. The QCEW data accurately reflect the extent of coverage of California’s UI laws and are used to measure UI revenues; national, state and local area employment; and total and UI taxable wage trends.

The U.S. Department of Labor’s Bureau of Labor Statistics publishes new QCEW data in its County Employment and Wages news release on a quarterly basis. The BLS also publishes a subset of its quarterly data through the Create Customized Tables system, and full quarterly industry detail data at all geographic levels.

Reason for Unemployment Data

  Current population Survey results showing unemployment data detailing the reason for unemployment. Presented in thousands; seasonally adjusted, quarterly from 2017 to present. About the BLS Unemployment Data including Current Population Survey Demographic Breakdowns: Links to several different datasets, including Current Population Survey results showing seasonally adjusted unemployment data broken out by ethnicity and age, reason for unemployment, and duration of employment prior to unemployment for years including 2017-2019.  Other datasets show over-the-year percent change in the third month's employment level and taxable wages by industry for a given quarter at the County, State, and MSA level yearly from 1990 - present.
  Geography Level: NationalItem Vintage: Not Available
  Update Frequency: N/AAgency: BLSAvailable File Type: Excel 

  Return to Other Federal Agency Datasets Page

VITAL SIGNS INDICATOR Jobs by Industry (EC1)

FULL MEASURE NAME Employment by place of work by industry sector

LAST UPDATED July 2019

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: Current Employment Statistics 1990-2017 http://data.bls.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.

This dataset contains the Local Area Unemployment Statistics (LAUS), annual averages from 1990 to 2023. The Local Area Unemployment Statistics (LAUS) program is a Federal-State cooperative effort in which monthly estimates of total employment and unemployment are prepared for approximately 7,600 areas, including counties, cities and metropolitan statistical areas. These estimates are key indicators of local economic conditions. The Bureau of Labor Statistics (BLS) of the U.S. Department of Labor is responsible for the concepts, definitions, technical procedures, validation, and publication of the estimates that State workforce agencies prepare under agreement with BLS. Estimates for counties are produced through a building-block approach known as the "Handbook method." This procedure also uses data from several sources, including the CPS, the CES program, state UI systems, and the Census Bureau's American Community Survey (ACS), to create estimates that are adjusted to the statewide measures of employment and unemployment. Estimates for cities are prepared using disaggregation techniques based on inputs from the ACS, annual population estimates, and current UI data.

Unemployment Data by Age (Thousands) 2017 to Present

  Current population Survey results showing unemployment data broken out by age. Presented in thousands; seasonally adjusted, quarterly for 2017 to present. About the BLS Unemployment Data including Current Population Survey Demographic Breakdowns: Links to several different datasets, including Current Population Survey results showing seasonally adjusted unemployment data broken out by ethnicity and age, reason for unemployment, and duration of employment prior to unemployment for years including 2017-2019.  Other datasets show over-the-year percent change in the third month's employment level and taxable wages by industry for a given quarter at the County, State, and MSA level yearly from 1990 - present.
  Geography Level: NationalItem Vintage: 2017-Present
  Update Frequency: N/AAgency: BLSAvailable File Type: Excel 

  Return to Other Federal Agency Datasets Page

VITAL SIGNS INDICATOR Jobs (LU2)

FULL MEASURE NAME Employment estimates by place of work

LAST UPDATED March 2020

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 California Employment Development Department: Current Employment Statistics 1990-2018 http://www.labormarketinfo.edd.ca.gov/

U.S. Census Bureau: LODES Data Longitudinal Employer-Household Dynamics Program (2005-2010) http://lehd.ces.census.gov/

U.S. Census Bureau: American Community Survey 5-Year Estimates, Tables S0804 (2010) and B08604 (2010-2017) https://factfinder.census.gov/

Bureau of Labor Statistics: Current Employment Statistics Table D-3: Employees on nonfarm payrolls (1990-2018) http://www.bls.gov/data/

METHODOLOGY NOTES (across all datasets for this indicator) The California Employment Development Department (EDD) provides estimates of employment, by place of employment, for California counties. The Bureau of Labor Statistics (BLS) provides estimates of employment for metropolitan areas outside of the Bay Area. Annual employment data are derived from monthly estimates and thus reflect “annual average employment.” Employment estimates outside of the Bay Area do not include farm employment. For the metropolitan area comparison, farm employment was removed from Bay Area employment totals. Both EDD and BLS data report only wage and salary jobs, not the self-employed.

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 sub-county city groupings varies from one (San Francisco and San Jose counties) to four (Santa Clara County). Estimates for sub-county areas are the sums of city-level estimates from the U.S. Census Bureau: American Community Survey (ACS) 2010-2017.

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 – all incorporated cities and towns Napa – all incorporated cities and towns San Francisco – San Francisco North San Mateo - Brisbane, Colma, Daly City, Millbrae, Pacifica, San Bruno, South San Francisco Central San Mateo - Belmont, Burlingame, Foster City, Half Moon Bay, Hillsborough, San Carlos, San Mateo South San Mateo - East Palo Alto, Menlo Park, Portola Valley, Redwood City, Woodside North Santa Clara - Los Altos, Los Altos Hills, Milpitas, Mountain View, Palo Alto, Santa Clara, Sunnyvale San Jose – San Jose Southwest Santa Clara - Campbell, Cupertino, Los Gatos, Monte Sereno, Saratoga South Santa Clara - Gilroy, Morgan Hill East Solano - Dixon, Fairfield, Rio Vista, Suisun City, Vacaville South Solano - Benicia, Vallejo North Sonoma - Cloverdale, Healdsburg, Windsor South Sonoma - Cotati, Petaluma, Rohnert Park, Santa Rosa, Sebastopol, Sonoma

Context

This is a dataset that I built by scraping the United States Department of Labor's Bureau of Labor Statistics. I was looking for county-level unemployment data and realized that there was a data source for this, but the data set itself hadn't existed yet, so I decided to write a scraper and build it out myself.

Content

This data represents the Local Area Unemployment Statistics from 1990-2016, broken down by state and month. The data itself is pulled from this mapping site:

https://data.bls.gov/map/MapToolServlet?survey=la&map=county&seasonal=u

Further, the ever-evolving and ever-improving codebase that pulled this data is available here:

https://github.com/jayrav13/bls_local_area_unemployment

Acknowledgements

Of course, a huge shoutout to bls.gov and their open and transparent data. I've certainly been inspired to dive into US-related data recently and having this data open further enables my curiosities.

Inspiration

I was excited about building this data set out because I was pretty sure something similar didn't exist - curious to see what folks can do with it once they run with it! A curious question I had was surrounding Unemployment vs 2016 Presidential Election outcome down to the county level. A comparison can probably lead to interesting questions and discoveries such as trends in local elections that led to their most recent election outcome, etc.

Next Steps

Version 1 of this is as a massive JSON blob, normalized by year / month / state. I intend to transform this into a CSV in the future as well.

The Local Area Unemployment Statistics (LAUS) program is a Federal-State cooperative effort in which monthly estimates of total employment and unemployment are prepared for approximately 7,600 areas, including counties, cities and metropolitan statistical areas. These estimates are key indicators of local economic conditions. The Bureau of Labor Statistics (BLS) of the U.S. Department of Labor is responsible for the concepts, definitions, technical procedures, validation, and publication of the estimates that State workforce agencies prepare under agreement with BLS. Estimates for counties are produced through a building-block approach known as the "Handbook method." This procedure also uses data from several sources, including the CPS, the CES program, state UI systems, and the Census Bureau's American Community Survey (ACS), to create estimates that are adjusted to the statewide measures of employment and unemployment. Estimates for cities are prepared using disaggregation techniques based on inputs from the ACS, annual population estimates, and current UI data.

VITAL SIGNS INDICATOR Income (EC5)

FULL MEASURE NAME Worker income by workplace (earnings)

LAST UPDATED October 2016

DESCRIPTION Income reflects the median earnings of individuals and households from employment, as well as the income distribution by quintile. Income data highlight how employees are being compensated for their work on an inflation-adjusted basis.

DATA SOURCE U.S. Census Bureau: Decennial Census Count 4Pb (1970) Form STF3 (1980-1990) Form SF3a (2000) https://nhgis.org

U.S. Census Bureau: American Community Survey Form B08521 (2006-2015; place of employment) http://api.census.gov

Bureau of Labor Statistics: Consumer Price Index All Urban Consumers Data Table (1970-2015; specific to each metro area) http://data.bls.gov

CONTACT INFORMATION vitalsigns.info@mtc.ca.gov

METHODOLOGY NOTES (across all datasets for this indicator) Income data reported in a given year reflects the income earned in the prior year (decennial Census) or in the prior 12 months (American Community Survey); note that this inconsistency has a minor effect on historical comparisons (for more information, go to: http://www.census.gov/acs/www/Downloads/methodology/ASA_nelson.pdf). American Community Survey 1-year data is used for larger geographies – metropolitan areas and counties – while smaller geographies rely upon 5-year rolling average data due to their smaller sample sizes. Quintile income for 1970-2000 is imputed from Decennial Census data using methodology from the California Department of Finance (for more information, go to: http://www.dof.ca.gov/Forecasting/Demographics/Census_Data_Center_Network/documents/How_to_Recalculate_a_Median.pdf). Bay Area income is the population weighted average of county-level income.

Income has been inflated using the Consumer Price Index specific to each metro area; however, some metro areas lack metro-specific CPI data back to 1970 and therefore adjusted data is unavailable for some historical data points. Note that current MSA boundaries were used for historical comparison by identifying counties included in today’s metro areas.

VITAL SIGNS INDICATOR
Income (EC4)

FULL MEASURE NAME
Household income by place of residence

LAST UPDATED
January 2023

DESCRIPTION
Income reflects the median earnings of individuals and households from employment, as well as the income distribution by quintile. Income data highlight how employees are being compensated for their work on an inflation-adjusted basis.

DATA SOURCE
U.S. Census Bureau: Decennial Census - https://nhgis.org
Count 4Pb (1970)
Form STF3 (1980-1990)
Form SF3a (2000)

U.S. Census Bureau: American Community Survey - https://data.census.gov/
Form B19001 (2005-2021; household income by place of residence)
Form B19013 (2005-2021; median household income by place of residence)
Form B08521 (2005-2021; median worker earnings by place of employment)

Bureau of Labor Statistics: Consumer Price Index - https://www.bls.gov/data/
1970-2021

CONTACT INFORMATION
vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)
Income derived from the decennial Census data reflects the income earned in the prior calendar year, whereas income derived from the American Community Survey (ACS) data reflects the prior 12 month period; note that this inconsistency has a minor effect on historical comparisons (see Income and Earnings Data section of the ACS General Handbook - https://www.census.gov/content/dam/Census/library/publications/2020/acs/acs_general_handbook_2020_ch09.pdf). ACS 1-year data is used for larger geographies – Bay counties and most metropolitan area counties – while smaller geographies rely upon 5-year rolling average data due to their smaller sample sizes. Note that 2020 data uses the 5-year estimates because the ACS did not collect 1-year data for 2020.

Quintile income for 1970-2000 is imputed from decennial Census data using methodology from the California Department of Finance. Bay Area income is the population weighted average of county-level income.

Income has been inflated using the Consumer Price Index (CPI) for 2021 specific to each metro area; however, some metro areas lack metro-specific CPI data back to 1970 and therefore adjusted data uses national CPI for 1970. Note that current MSA boundaries were used for historical comparison by identifying counties included in today’s metro areas.

1990 to present (approximate 2 month lag) Virginia Labor Force and Unemployment estimates by Month by County.

Special data considerations: Period values of "M01-M12" represent Months of Year; "M13" is the Annual Average.

U.S. Bureau of Labor Statistics; Local Area Unemployment Statistics, table la.data.54.Virginia Data accessed from the Bureau of Labor Statistics public database LABSTAT (https://download.bls.gov/pub/time.series/la/)

Supporting documentation can be found on the U.S. Bureau of Labor Statistics website under Local Area Unemployment Statistics, Handbook of Methods (https://www.bls.gov/opub/hom/lau/home.htm)

Survey Description: Labor force and unemployment estimates for States and local areas are developed by State workforce agencies to measure local labor market conditions under a Federal-State cooperative program. The Department of Labor develops the concepts, definitions, and technical procedures which are used by State agencies for preparation of labor force and unemployment estimates.

These estimates are derived from a variety of sources, including the Current Population Survey, the Current Employment Statistics survey, the Quarterly Census of Employment and Wages, various programs at the Census Bureau, and unemployment insurance claims data from the State workforce agencies.

To establish uniform labor force concepts and definitions in all States and areas consistent with those used for the U.S. as a whole, monthly national estimates of employment and unemployment from the Current Population Survey are used as controls (benchmarks) for the State labor force statistics.

Summary Data Available: Monthly labor force and unemployment series are available for approximately 7,500 geographic areas, including cities over 25,000 population, counties, metropolitan areas, States, and other areas.

For each area, the following measures are presented by place of residence:

• Total civilian labor force,
• Total number of people employed,
• Total number of people unemployed, and
• Unemployment rate

Data Characteristics: Rates are expressed as percents with one decimal place. Levels are measured as individual persons (not thousands) and are stored with no decimal places.

Reason for Unemployment Data by Ethnicity and Race 2019-2020

  Current Population Survey Results showing unemployment data broken out by ethnicity detailing the reason for unemployment. Presented in thousands; non seasonally adjusted, for the second quarter in 2019 and 2020. About the BLS Unemployment Data including Current Population Survey Demographic Breakdowns: Links to several different datasets, including Current Population Survey results showing seasonally adjusted unemployment data broken out by ethnicity and age, reason for unemployment, and duration of employment prior to unemployment for years including 2017-2019.  Other datasets show over-the-year percent change in the third month's employment level and taxable wages by industry for a given quarter at the County, State, and MSA level yearly from 1990 - present.
  Geography Level: NationalItem Vintage: 2019-2020
  Update Frequency: N/AAgency: BLSAvailable File Type: Excel 

  Return to Other Federal Agency Datasets Page

VITAL SIGNS INDICATOR Income (EC4)

FULL MEASURE NAME Household income by place of residence

LAST UPDATED May 2019

DESCRIPTION Income reflects the median earnings of individuals and households from employment, as well as the income distribution by quintile. Income data highlight how employees are being compensated for their work on an inflation-adjusted basis.

DATA SOURCE U.S. Census Bureau: Decennial Census Count 4Pb (1970) Form STF3 (1980-1990) Form SF3a (2000) https://nhgis.org

U.S. Census Bureau: American Community Survey Form B19013 (2006-2017; place of residence) http://api.census.gov

Bureau of Labor Statistics: Consumer Price Index All Urban Consumers Data Table (1970-2017; specific to each metro area) http://data.bls.gov

CONTACT INFORMATION vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator) Income data reported in a given year reflects the income earned in the prior year (decennial Census) or in the prior 12 months (American Community Survey); note that this inconsistency has a minor effect on historical comparisons (for more information, go to: http://www.census.gov/acs/www/Downloads/methodology/ASA_nelson.pdf). American Community Survey 1-year data is used for larger geographies – metropolitan areas and counties – while smaller geographies rely upon 5-year rolling average data due to their smaller sample sizes. Quintile income for 1970-2000 is imputed from Decennial Census data using methodology from the California Department of Finance (for more information, go to: http://www.dof.ca.gov/Forecasting/Demographics/Census_Data_Center_Network/documents/How_to_Recalculate_a_Median.pdf). Bay Area income is the population weighted average of county-level income.

Income has been inflated using the Consumer Price Index specific to each metro area; however, some metro areas lack metro-specific CPI data back to 1970 and therefore adjusted data is unavailable for some historical data points. Note that current MSA boundaries were used for historical comparison by identifying counties included in today’s metro areas.

analyze the current population survey (cps) annual social and economic supplement (asec) with r the annual march cps-asec has been supplying the statistics for the census bureau's report on income, poverty, and health insurance coverage since 1948. wow. the us census bureau and the bureau of labor statistics ( bls) tag-team on this one. until the american community survey (acs) hit the scene in the early aughts (2000s), the current population survey had the largest sample size of all the annual general demographic data sets outside of the decennial census - about two hundred thousand respondents. this provides enough sample to conduct state- and a few large metro area-level analyses. your sample size will vanish if you start investigating subgroups b y state - consider pooling multiple years. county-level is a no-no. despite the american community survey's larger size, the cps-asec contains many more variables related to employment, sources of income, and insurance - and can be trended back to harry truman's presidency. aside from questions specifically asked about an annual experience (like income), many of the questions in this march data set should be t reated as point-in-time statistics. cps-asec generalizes to the united states non-institutional, non-active duty military population. the national bureau of economic research (nber) provides sas, spss, and stata importation scripts to create a rectangular file (rectangular data means only person-level records; household- and family-level information gets attached to each person). to import these files into r, the parse.SAScii function uses nber's sas code to determine how to import the fixed-width file, then RSQLite to put everything into a schnazzy database. you can try reading through the nber march 2012 sas importation code yourself, but it's a bit of a proc freak show. this new github repository contains three scripts: 2005-2012 asec - download all microdata.R down load the fixed-width file containing household, family, and person records import by separating this file into three tables, then merge 'em together at the person-level download the fixed-width file containing the person-level replicate weights merge the rectangular person-level file with the replicate weights, then store it in a sql database create a new variable - one - in the data table 2012 asec - analysis examples.R connect to the sql database created by the 'download all microdata' progr am create the complex sample survey object, using the replicate weights perform a boatload of analysis examples replicate census estimates - 2011.R connect to the sql database created by the 'download all microdata' program create the complex sample survey object, using the replicate weights match the sas output shown in the png file below 2011 asec replicate weight sas output.png statistic and standard error generated from the replicate-weighted example sas script contained in this census-provided person replicate weights usage instructions document. click here to view these three scripts for more detail about the current population survey - annual social and economic supplement (cps-asec), visit: the census bureau's current population survey page the bureau of labor statistics' current population survey page the current population survey's wikipedia article notes: interviews are conducted in march about experiences during the previous year. the file labeled 2012 includes information (income, work experience, health insurance) pertaining to 2011. when you use the current populat ion survey to talk about america, subract a year from the data file name. as of the 2010 file (the interview focusing on america during 2009), the cps-asec contains exciting new medical out-of-pocket spending variables most useful for supplemental (medical spending-adjusted) poverty research. confidential to sas, spss, stata, sudaan users: why are you still rubbing two sticks together after we've invented the butane lighter? time to transition to r. :D

VITAL SIGNS INDICATOR Jobs (LU2)

FULL MEASURE NAME Employment estimates by place of work

LAST UPDATED October 2019

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 California Employment Development Department: Current Employment Statistics 1990-2018 http://www.labormarketinfo.edd.ca.gov/

U.S. Census Bureau: LODES Data Longitudinal Employer-Household Dynamics Program (2005-2010) http://lehd.ces.census.gov/

U.S. Census Bureau: American Community Survey 5-Year Estimates, Tables S0804 (2010) and B08604 (2010-2017) https://factfinder.census.gov/

Bureau of Labor Statistics: Current Employment Statistics Table D-3: Employees on nonfarm payrolls (1990-2018) http://www.bls.gov/data/

METHODOLOGY NOTES (across all datasets for this indicator) The California Employment Development Department (EDD) provides estimates of employment, by place of employment, for California counties. The Bureau of Labor Statistics (BLS) provides estimates of employment for metropolitan areas outside of the Bay Area. Annual employment data are derived from monthly estimates and thus reflect “annual average employment.” Employment estimates outside of the Bay Area do not include farm employment. For the metropolitan area comparison, farm employment was removed from Bay Area employment totals. Both EDD and BLS data report only wage and salary jobs, not the self-employed.

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 sub-county city groupings varies from one (San Francisco and San Jose counties) to four (Santa Clara County). Estimates for sub-county areas are the sums of city-level estimates from the U.S. Census Bureau: American Community Survey (ACS) 2010-2017.

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 – all incorporated cities and towns Napa – all incorporated cities and towns San Francisco – San Francisco North San Mateo - Brisbane, Colma, Daly City, Millbrae, Pacifica, San Bruno, South San Francisco Central San Mateo - Belmont, Burlingame, Foster City, Half Moon Bay, Hillsborough, San Carlos, San Mateo South San Mateo - East Palo Alto, Menlo Park, Portola Valley, Redwood City, Woodside North Santa Clara - Los Altos, Los Altos Hills, Milpitas, Mountain View, Palo Alto, Santa Clara, Sunnyvale San Jose – San Jose Southwest Santa Clara - Campbell, Cupertino, Los Gatos, Monte Sereno, Saratoga South Santa Clara - Gilroy, Morgan Hill East Solano - Dixon, Fairfield, Rio Vista, Suisun City, Vacaville South Solano - Benicia, Vallejo North Sonoma - Cloverdale, Healdsburg, Windsor South Sonoma - Cotati, Petaluma, Rohnert Park, Santa Rosa, Sebastopol, Sonoma

This is a set of csv files including a number of variables including fatal police shootings and other crime and socioeconomic covariates at different levels of geographical aggregation from 2013-2016. Five of the files use only the Washington Post data covering years 2015 and 2016, whereas the other five files utilize fatal police shootings of civilians for years 2013-2016, combining the Lott & Moody (2016) data for years 2013-2015 and Washington Post data for 2016. Other variables are included from the American Community Survey (ACS), the FBI's Uniform Crime Reports (UCR), the Law Enforcement Management and Administrative Statistics (LEMAS), Stanford Education Data Archive (SEDA), the US Census, and the Local Area Unemployment Statistics (LAUS) provided by the Bureau of Labor Statistics (BLS). The base file is the county-level data. The two files labelled "tenk" consist of regions with at least 10,000 residents. Counties with fewer than 10,000 residents are combined with adjacent counties, ranked by population in ascending order, so that counties with fewer than 10,000 residents are iteratively combined with adjacent neighbors with the fewest residents until they reach the threshold of 10,000 residents. The same algorithm is used to produce regions with 100,000 and 1 million residents. The final two files are state-level aggregations.

This layer shows median earnings by occupational group. This is shown by tract, county, and state boundaries. This service is updated annually to contain the most currently released American Community Survey (ACS) 5-year data, and contains estimates and margins of error. There are also additional calculated attributes related to this topic, which can be mapped or used within analysis. Only full-time year-round workers included. Median earnings is based on earnings in past 12 months of survey. Occupation Groups based on Bureau of Labor Statistics (BLS)' Standard Occupation Classification (SOC). This layer is symbolized to show median earnings of the full-time, year-round civilian employed population. To see the full list of attributes available in this service, go to the "Data" tab, and choose "Fields" at the top right. Current Vintage: 2019-2023ACS Table(s): B24021Data downloaded from: Census Bureau's API for American Community Survey Date of API call: December 12, 2024National Figures: data.census.govThe United States Census Bureau's American Community Survey (ACS):About the SurveyGeography & ACSTechnical DocumentationNews & UpdatesThis ready-to-use layer can be used within ArcGIS Pro, ArcGIS Online, its configurable apps, dashboards, Story Maps, custom apps, and mobile apps. Data can also be exported for offline workflows. For more information about ACS layers, visit the FAQ. Please cite the Census and ACS when using this data.Data Note from the Census:Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see Accuracy of the Data). The effect of nonsampling error is not represented in these tables.Data Processing Notes:This layer is updated automatically when the most current vintage of ACS data is released each year, usually in December. The layer always contains the latest available ACS 5-year estimates. It is updated annually within days of the Census Bureau's release schedule. Click here to learn more about ACS data releases.Boundaries come from the US Census TIGER geodatabases, specifically, the National Sub-State Geography Database (named tlgdb_(year)_a_us_substategeo.gdb). Boundaries are updated at the same time as the data updates (annually), and the boundary vintage appropriately matches the data vintage as specified by the Census. These are Census boundaries with water and/or coastlines erased for cartographic and mapping purposes. For census tracts, the water cutouts are derived from a subset of the 2020 Areal Hydrography boundaries offered by TIGER. Water bodies and rivers which are 50 million square meters or larger (mid to large sized water bodies) are erased from the tract level boundaries, as well as additional important features. For state and county boundaries, the water and coastlines are derived from the coastlines of the 2023 500k TIGER Cartographic Boundary Shapefiles. These are erased to more accurately portray the coastlines and Great Lakes. The original AWATER and ALAND fields are still available as attributes within the data table (units are square meters).The States layer contains 52 records - all US states, Washington D.C., and Puerto RicoCensus tracts with no population that occur in areas of water, such as oceans, are removed from this data service (Census Tracts beginning with 99).Percentages and derived counts, and associated margins of error, are calculated values (that can be identified by the "_calc_" stub in the field name), and abide by the specifications defined by the American Community Survey.Field alias names were created based on the Table Shells file available from the American Community Survey Summary File Documentation page.Negative values (e.g., -4444...) have been set to null, with the exception of -5555... which has been set to zero. These negative values exist in the raw API data to indicate the following situations:The margin of error column indicates that either no sample observations or too few sample observations were available to compute a standard error and thus the margin of error. A statistical test is not appropriate.Either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution.The median falls in the lowest interval of an open-ended distribution, or in the upper interval of an open-ended distribution. A statistical test is not appropriate.The estimate is controlled. A statistical test for sampling variability is not appropriate.The data for this geographic area cannot be displayed because the number of sample cases is too small.

VITAL SIGNS INDICATOR
Rent Payments (EC8)

FULL MEASURE NAME
Median rent payment

LAST UPDATED
January 2023

DESCRIPTION
Rent payments refer to the cost of leasing an apartment or home and serves as a measure of housing costs for individuals who do not own a home. The data reflect the median monthly rent paid by Bay Area households across apartments and homes of various sizes and various levels of quality. This differs from advertised rents for available apartments, which usually are higher. Note that rent can be presented using nominal or real (inflation-adjusted) dollar values; data are presented inflation-adjusted to reflect changes in household purchasing power over time.

DATA SOURCE
U.S. Census Bureau: Decennial Census - https://nhgis.org
Count 2 (1970)
Form STF1 (1980-1990)
Form SF3a (2000)

U.S. Census Bureau: American Community Survey - https://data.census.gov/
Form B25058 (2005-2021; median contract rent)

Bureau of Labor Statistics: Consumer Price Index - https://www.bls.gov/data/
1970-2021

CONTACT INFORMATION
vitalsigns.info@mtc.ca.gov

METHODOLOGY NOTES (across all datasets for this indicator)
Rent data reflects median rent payments rather than list rents (refer to measure definition above). American Community Survey 1-year data is used for larger geographies – Bay counties and most metropolitan area counties – while smaller geographies rely upon 5-year rolling average data due to their smaller sample sizes. Note that 2020 data uses the 5-year estimates because the ACS did not collect 1-year data for 2020.

1970 Census data for median rent payments has been imputed from quintiles using methodology from California Department of Finance as the source data only provided the mean, rather than the median, monthly rent. Metro area boundaries reflects today’s metro area definitions by county for consistency, rather than historical metro area boundaries.

Inflation-adjusted data are presented to illustrate how rent payments have grown relative to overall price increases; that said, the use of the Consumer Price Index (CPI) does create some challenges given the fact that housing represents a major chunk of consumer goods bundle used to calculate CPI. This reflects a methodological tradeoff between precision and accuracy and is a common concern when working with any commodity that is a major component of CPI itself.

This layer shows median earnings by occupational group broken down by sex. This is shown by tract, county, and state centroids. This service is updated annually to contain the most currently released American Community Survey (ACS) 5-year data, and contains estimates and margins of error. There are also additional calculated attributes related to this topic, which can be mapped or used within analysis. Only full-time year-round workers included. Median earnings is based on earnings in past 12 months of survey. Occupation Groups based on Bureau of Labor Statistics (BLS)' Standard Occupation Classification (SOC). This layer is symbolized to show median earnings of the full-time, year-round civilian employed population. To see the full list of attributes available in this service, go to the "Data" tab, and choose "Fields" at the top right. Current Vintage: 2019-2023ACS Table(s): B24022 (Not all lines of this ACS table are available in this feature layer.)Data downloaded from: Census Bureau's API for American Community Survey Date of API call: December 12, 2024National Figures: data.census.govThe United States Census Bureau's American Community Survey (ACS):About the SurveyGeography & ACSTechnical DocumentationNews & UpdatesThis ready-to-use layer can be used within ArcGIS Pro, ArcGIS Online, its configurable apps, dashboards, Story Maps, custom apps, and mobile apps. Data can also be exported for offline workflows. For more information about ACS layers, visit the FAQ. Please cite the Census and ACS when using this data.Data Note from the Census:Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see Accuracy of the Data). The effect of nonsampling error is not represented in these tables.Data Processing Notes:This layer is updated automatically when the most current vintage of ACS data is released each year, usually in December. The layer always contains the latest available ACS 5-year estimates. It is updated annually within days of the Census Bureau's release schedule. Click here to learn more about ACS data releases.Boundaries come from the US Census TIGER geodatabases, specifically, the National Sub-State Geography Database (named tlgdb_(year)_a_us_substategeo.gdb). Boundaries are updated at the same time as the data updates (annually), and the boundary vintage appropriately matches the data vintage as specified by the Census. These are Census boundaries with water and/or coastlines erased for cartographic and mapping purposes. For census tracts, the water cutouts are derived from a subset of the 2020 Areal Hydrography boundaries offered by TIGER. Water bodies and rivers which are 50 million square meters or larger (mid to large sized water bodies) are erased from the tract level boundaries, as well as additional important features. For state and county boundaries, the water and coastlines are derived from the coastlines of the 2023 500k TIGER Cartographic Boundary Shapefiles. These are erased to more accurately portray the coastlines and Great Lakes. The original AWATER and ALAND fields are still available as attributes within the data table (units are square meters).The States layer contains 52 records - all US states, Washington D.C., and Puerto RicoCensus tracts with no population that occur in areas of water, such as oceans, are removed from this data service (Census Tracts beginning with 99).Percentages and derived counts, and associated margins of error, are calculated values (that can be identified by the "_calc_" stub in the field name), and abide by the specifications defined by the American Community Survey.Field alias names were created based on the Table Shells file available from the American Community Survey Summary File Documentation page.Negative values (e.g., -4444...) have been set to null, with the exception of -5555... which has been set to zero. These negative values exist in the raw API data to indicate the following situations:The margin of error column indicates that either no sample observations or too few sample observations were available to compute a standard error and thus the margin of error. A statistical test is not appropriate.Either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution.The median falls in the lowest interval of an open-ended distribution, or in the upper interval of an open-ended distribution. A statistical test is not appropriate.The estimate is controlled. A statistical test for sampling variability is not appropriate.The data for this geographic area cannot be displayed because the number of sample cases is too small.