Data Sharing Between The Bureau Of Labor Statistics And The

Data Sharing Between the Bureau ofLabor Statistics and the Census BureauBLS Data Synchronization ProjectSharon StangEconomistDivision of Administrative Statistics/Office of Employment and Unemployment StatisticsFedCASIC 2016May 4,20161— U.S. B UREAUOF L ABORSTATISTICS bls.gov

A long time ago, in a galaxy far,far away .2— U.S. B UREAUOF L ABORSTATISTICS bls.gov

3— U.S. B UREAUOF L ABORSTATISTICS bls.gov

HistoryCIPSEA 2002 Data sharing between BEA, BLS, and theCensus Bureau (2005) Protect confidentiality and improve thequality of data and statistics Benefits agencies and data users 4— U.S. B UREAUOF L ABORSTATISTICS bls.gov

5— U.S. B UREAUOF L ABORSTATISTICS bls.gov

2012 - MOU Between BLS and CensusShare certain business data of multi-locationcompanies. Research and fix industry coding discrepancies 6— U.S. B UREAUOF L ABORSTATISTICS bls.gov

Data Sources Census BusinessRegister (BR) 2007/2012 EconomicCensuses Annual CompanyOrganization Survey (COS) Annual Survey ofManufacturers (ASM) Service Annual Surveys(SAS)7— U.S. B UREAUOF L ABORSTATISTICS bls.gov BLS Quarterly Censusof Employment andWages (QCEW) 2007 Annual data and2011/2012 Q1-Q2 data Quarterly StateUnemployment Insurance(UI) filings Annual Refiling Survey(ARS)

Shared Data Census Data free of Title 26Restrictions For multi-locationcompanies– Business name and address– State, county, and place geocodes– EIN– NAICS code– NAICS Source Code 2007 March Employment 2007 Annual Payroll 82012 Economic Census data available mid-2014.— U.S. B UREAUOF L ABORSTATISTICS bls.govBLS Multi-unit companyname and address Affiliated establishmentinformation–––––––Name and addressEINNAICS codeARS yearOperational StatusQuarterly EmploymentQuarterly and annual payroll

BLS Data Synchronization Project9— U.S. B UREAUOF L ABORSTATISTICS bls.gov

What are Multis?10 Census – Multiple establishments with thesame federal Employer IdentificationNumber (EIN). BLS – Multiple establishments with thesame Unemployment Insurance AccountNumber (UIN) within a STATE.— U.S. B UREAUOFLABOR STATISTICS bls.gov10

QCEW/Census 2012* file matchingMatching Criteria: EIN, State FIPS, Company Name, Physical Location Address(PLA), and County/ Township Code - after standardization. Worksites on the 2012 BR file: Number of matched worksites:1,915,448905,853Worksites on the 2012-Q1 QCEW file: Number of matched QCEW worksites:9,247,203884,597 Total Matches:One to One matches:QCEW NAICS Census NAICSQCEW NAICS Census NAICS857,743817,209611,944 (75%)205,265 (25%)2012 Economic Census data made available in May 2014. 11— U.S. B UREAUOFLABOR STATISTICS bls.gov11

Exclusion Criteria Establishments with less than 50 in QCEW employment inMarch 2012Establishments with an absolute employment differencegreater than 30% between the March 2012 Censusemployment and the March 2012 QCEW employmentEstablishments with no sector mismatch between Censusand QCEW 7,790 in-scope establishments– 100 employment, sector mismatch, and Census/QCEW Employmentdifference 30% --- 3,820 establishments– Employment between 50-99 --- 3,970 establishments (lower prioritybut in-scope)12— U.S. B UREAUOFLABOR STATISTICS bls.gov12

Census 2007/2012 File Comparison 5,972 originally identified 2007 in-scope establishments 7,990 in-scope establishments in 2012 3,256 (42%) were also in the original 2007 matchedestablishments. 4,534 (58%) were newly identified as sector mismatches.13— U.S. B UREAUOFLABOR STATISTICS bls.gov13

14— U.S. B UREAUOFLABOR STATISTICS bls.gov

NAICS Adjudication StepsBLS regional office staff were provided with theQCEW establishment information only and asked toresearch, and contact the establishments asnecessary, to either verify or update the QCEWNAICS codes. A second identical blind review of the establishmentswas conducted by a different regional office. Results of the two independent reviews were thenevaluated. 15— U.S. B UREAUOFLABOR STATISTICS bls.gov15

NAICS Adjudication Results1,466 establishments were adjudicated in 2014. Results: 464 matched the QCEW NAICS Sector. Candidates forCensus NAICS change. 247 matched the Census NAICS Sector. Candidates forQCEW NAICS change. 53 did not match the QCEW or Census NAICSSectors. Candidates for Census and QCEW NAICS Change. 702 had different suggested NAICS sectors in both reviews.16— U.S. B UREAUOFLABOR STATISTICS bls.gov16

What We learnedMatching microdata records is hard Some discrepancies fix themselves over time Discrepancies exist because someestablishments are just hard to code This work is time-consuming and resourceintensive There will likely always be discrepancies givenhow the programs are structured 17— U.S. B UREAUOFLABOR STATISTICS bls.gov

18— U.S. B UREAUOFLABOR STATISTICS bls.gov

BLS Data Synchronization Project:Phase -2Take a macro-level approach Identify significant sub-sector level differencesbetween the BR and QCEW Research why discrepancies exist Develop strategies to address discrepanciesbased on their root causes 19— U.S. B UREAUOFLABOR STATISTICS bls.gov

NAICS sub-sectors of interest2012 CBP and QCEW Published DataNAICS Sub-SectorEstablishmentsQCEWNAICS 561 Administrative and support servicesCBPAbsoluteValueDifferenceEmployment% DiffQCEWCBPAbsoluteValueDifferenceWages (millions)% DiffQCEWCBPAbsoluteValueDifference% Diff449,229361,73387,49619.48% 7,221,478 9,839,247 2,617,76936.25% 248,773 327,316 78,54331.57%NAICS 611 Educational services99,70468,27631,42831.52% 2,633,156653,409 1,979,74775.19% 112,888 17,659 95,22984.36%NAICS 551 Management of companies and enterprises55,83552,3803,4556.19% 1,983,979 3,065,905 1,081,92654.53% 258,206 307,489 49,28319.09%8,2146,5461,66820.31% 4,707,397 5,771,797 1,064,40022.61% 260,651 317,177 56,52621.69%NAICS 423 Merchant wholesalers, durable goods248,211244,9633,248595,62421.37% 191,296 218,209 26,91314.07%NAICS 425 Electronic markets and agents and brokers230,70744,247186,460NAICS 813 Membership associations and organizations140,214106,911NAICS 448 Clothing and clothing accessories stores129,378NAICS 517 TelecommunicationsNAICS 622 Hospitals1.31% 2,787,660 3,383,284852,594295,007557,58765.40% 77,975 14,346 63,62981.60%33,30323.75% 1,292,934885,840407,09431.49% 48,560 38,049 10,51121.64%147,50218,12414.01% 1,341,516 1,656,842315,32623.51% 26,690 27,864 1,1744.40%43,50750,5767,06916.25%864,686 1,141,922277,23632.06% 76,799 76,033 7661.00%NAICS 713 Amusements, gambling, and recreation71,69271,5621300.18% 1,264,517 1,518,405253,88820.08% 26,872 28,403 1,5315.70%NAICS 334 Computer and electronic product manufacturing18,65413,2185,436850,613244,66122.34% 116,448 61,802 54,64646.93%NAICS 518 Data processing, hosting and related 3.81% 23,188 40,705 17,51775.55%NAICS 454 Nonstore ,46538.31% 22,900 27,012 4,11217.96%NAICS 511 Publishing industries, except 1517.62% 64,661 79,884 15,22323.54%NAICS 213 Support activities for 31.25% 32,736 32,236 5001.53%NAICS 523 Securities, commodity contracts, ,86712.44% 229,080 169,880 59,20025.84%20— U.S. B UREAUOFLABOR STATISTICS bls.gov80.82%29.14% 1,095,274

Contact InformationSharon 9stang.sharon@bls.gov21— U.S. B UREAUOFLABOR STATISTICS bls.gov

8 —U.S. BUREAU OF LABOR STATISTICS bls.gov Shared Data Census Data free of Title 26 Restrictions For multi-location companies –Business name and address –State, county, and place geocodes –EIN –NAICS code –NAICS Source Code 2007 March Employment 2007 Annual Payroll 2012 Economic Cens