Download Excel Spreadsheets and Zipped files

The Annual Labor Market and Economic Report now resides on the new Workforce Explorer website. Bookmark the new location for future reference.

Resident Civilian Labor Force Employment/Unemployment

Two benchmark tables of the Resident Civilian Labor Force for Washington State and Counties are available on Download Data of the Workforce Explorer website for download in Excel 5.0 file format. Laus8002.xls contains 44 spreadsheets of the Monthly Labor Force, Employment, Unemployment and Unemployment Rate - two sheets for the State and one sheet each for the PMSAs, the MSAs and counties. Whereas, 9002aa.xls contains the Annual Averages of the Labor Force, Employment, Unemployment and Unemployment Rate for the State, the PMSAs, the MSAs and counties - all on a single spreadsheet, one spreadsheet for each year.

The Dictionary of Occupational Titles (DOT) codes are crosswalked to the Occupational Employment Statistics (OES) codes. Downloadable Oesxdot.zip contains files, "oesxdot.dbf" and "oesxdot.txt" and Dotxoes.zip contains files, "dotxoes.dbf" and "dotxoes.txt". Two file formats make it easy to import data into different software. Both files, sorted by OES and DOT codes, contain DOT codes and titles and OES codes and titles.

Oesxdot.zip
(309 kb)

Dotxoes.zip
(329 kb)

	Download from the new Workforce Explorer bench02.xls - a Nonagricultural Industry Employment file in Excel 5.0/97 format of the 2002 Preliminary and 2001 Revised data for Washington State, the PMSAs, the MSAs, and counties.

These files are the Covered Employment and Payrolls in Washington State by County and Industry - Annual Averages from 1987 to present. These files are in two different Excel file formats. The State files contain one spreadsheet of the statewide data at the 4-digit SIC Code level. The County files contain individual spreadsheets (one for each county) of the county data at the 2-digit SIC Code level. Both sets of files contain data for the number of firms, all twelve months, the annual average employment, and the total wages paid. These are Excel 5.0/97 format files.

State01.xls		County01.xls
State00.xls	State93.xls	County00.xls	County93.xls
State99.xls	State92.xls	County99.xls	County92.xls
State98.xls	State91.xls	County98.xls	County91.xls
State97.xls	State90.xls	County97.xls	County90.xls
State96.xls	State89.xls	County96.xls	County89.xls
State95.xls	State88.xls	County95.xls	County88.xls
State94.xls	State87.xls	County94.xls	County87.xls

	This is a link to a state map that has a time-series of Selected Economic Data at the county, state and national level. The data includes Population, Labor-Force, NonAg Employment and Income. One file for each county, the state and the nation. Each file has 30+ data fields for each year from 1970 to 2000 and downloads as an Excel 5.0 file.

	The size of firm files are now located on the Workforce Explorer on the Download Data page at Size of firm as a single Excel file with three spreadsheets, one for County data, one for State data at the NAICS Industry level, and one for State data at the 3 digit NAICS code level.

1994-99 Summary Employment and Wages by ZIP Code

Two summary table representing the number of businesses, average monthly employed, and total wages paid of PRIVATE employers for calendar years 1994-96 and 1997-99. This data excludes government employment and wages and INDUSTRY distribution. The sample below is an extract from the "1997-1999 Private Covered Employment and Wages by ZIP Code" file.

ZIP Code	1997 Total Firms	1997 Average Monthly Employed	1997 Total Wages Paid	1998 Total Firms	1998 Average Monthly Employed	1998 Total Wages Paid	1999 Total Firms	1999 Average Monthly Employed	1999 Total Wages Paid
98001	915	14,819	523,177,308	891	15,949	567,578,692	922	16,050	613,402,372
98002	1,083	10,983	274,026,084	1,058	11,815	302,092,158	1,056	12,192	316,026,843
98003	1,723	17,513	400,646,222	1,713	18,899	447,339,281	1,682	21,644	514,023,896
98004	3,323	49,382	1,885,218,093	3,077	49,296	2,147,737,025	3,007	50,810	2,371,995,241
98005	1,731	26,822	922,139,763	1,652	28,000	1,077,250,943	1,683	28,186	1,163,574,074

Data has been assigned and aggregated to one of 511 Washington State ZIP codes and is displayed in .XLS, .EXE, and .ZIP extension files. All formats contain identical data. The zipped (.ZIP) file requires PKUNZIP.EXE to unzip. The EXCEL (.XLS) and executable (.EXE) files do not.

Em9799zp.xls (75 kb)	Em9799zp.exe (45 kb)	Em9799zp.zip (31 kb)
Em9496zp.xls (72 kb)	Em9496zp.exe (44 kb)	Em9496zp.zip (29 kb)

Individual data tables representing the number of businesses, average monthly employed, average annual wages, and total wages paid by INDUSTRY of PRIVATE employers for calendar years 1995-1999. This data excludes government employment and wages. The sample below is an extract from the "1999 Private Covered Employment and Wages by ZIP Code and Industry" file.

ZIP Code	Industry	1999 Total Firms	1999 Avg Annual Employed	1999 Avg Annual Wage	1999 Total Wages Paid
98002	Total	1,056	12,192	25,921	316,026,843
	Agriculture-Forestry-Fishing	18	63	12,306	778,359
	Construction	110	1,099	34,547	37,978,180
	Finance-Insurance-Real Estate	71	299	26,258	7,844,703
	Manufacturing	74	1,296	31,643	41,004,293
	Retail Trade	224	3,850	22,146	85,257,654
	Services	486	4,544	23,022	104,614,859
	Trans-Comm-Public Utilities	21	382	47,588	18,182,650
	Wholesale Trade	52	659	30,905	20,366,145

Data has been assigned and aggregated to one of 511 Washington State ZIP codes and is displayed in .XLS, .EXE, and .ZIP extension files. All formats contain identical data. The zipped (.ZIP) files require PKUNZIP.EXE to unzip. The EXCEL (.XLS) and executable (.EXE) files do not.

Empi99zp.xls (489kb)	Empi98zp.xls (478kb)	Empi97zp.xls (796 kb)	Empi96zp.xls (473 kb)	Empi95zp.xls (459 kb)
Empi99zp.exe (150 kb)	Empi98zp.exe (155 kb)	Empi97zp.exe (253 kb)	Empi96zp.exe (169 kb)	Empi95zp.exe (164 kb)
Empi99zp.zip (135 kb)	Empi98zp.zip (140 kb)	Empi97zp.zip (238 kb)	Empi96zp.zip (154 kb)	Empi95zp.zip (149 kb)

1995-2000 Summary Unemployment Insurance Claimants by ZIP Code

Summary tables representing counts of all Unemployment Insurance claimants residing in Washington who had active claims under any program or entitlement during program years 1995 through 2000. (Example: Program Year 2000 is for the time period July 1, 1999 - June 30, 2000). Information includes total number of claimants, total weeks claimed, average weeks per claimant, total benefits paid, and number of claimants who have exhausted their benefits. The sample below is an extract from the "1998- 2000 Unemployment Insurance Claimant Activity by ZIP Code" report.

ZIP Code	1998 Total Clmts	1998 Total Wks Claim	1998 Avg Wks/ Clmt	1998 Benefits Paid Out	1998 Total Exhaust	1999 Total Clmts	1999 Total Wks Claim	1999 Avg Wks/ Clmt	1999 Benefits Paid Out	1999 Total Exhaust	2000 Total Clmts	2000 Total Wks Claim	2000 Avg Wks/ Clmt	2000 Benefits Paid Out	2000 Total Exhaust
98001	1,132	12,798	11.3	2,840,032	200	1,446	14,332	9.9	3,456,120	231	1,421	14,393	10.1	3,825,714	250
98002	1,728	18,885	10.9	3,752,556	274	2,154	20,590	9.6	4,342,415	314	2,131	21,129	9.9	5,169,577	363
98003	1,885	20,764	11.0	4,308,554	306	2,334	22,132	9.5	4,875,565	333	2,368	22,299	9.4	5,524,259	375

Data has been assigned and aggregated up to one of 517 Washington State ZIP codes (depending upon year) and is displayed in .XLS, .EXE, and .ZIP extension files. All formats contain identical data. The zipped (.ZIP) file requires PKUNZIP.EXE to unzip. The EXCEL (.XLS) and executable (.EXE) files do not.

Ui9500zp.xls (275 kb)

Ui9500zp.exe (104 kb)

Ui9500zp.zip (89 kb)

1995-2000 Annual Detailed Unemployment Insurance
Claimants by ZIP Code

Individual detailed tables representing counts of all Unemployment Insurance claimants residing in Washington who had active claims under any program or entitlement during program years 1995 through 2000. (Example: Program Year 2000 is for the time period July 1, 1999 - June 30, 2000). Information includes total number of claimants, total weeks claimed, average weeks per claimant, number of claimants who have exhausted their benefits, total benefits paid, and number of claimants who have claimed 1-5 weeks, 6-10 weeks, 11-15 weeks, 16-20 weeks, 21-25 weeks, and 26+ weeks. The sample below is an extract from the "2000 Unemployment Insurance Claimant Activity by ZIP Code" file.

ZIP Code	Total Number of Claimants	Total Weeks Claimed	Average Weeks/ Claimant	Total Benefits Paid Out	Total Number of Exhaustions	1 - 5 Weeks Claimed	6 - 10 Weeks Claimed	11-15 Weeks Claimed	16-20 Weeks Claimed	21-25 Weeks Claimed	26+ Weeks Claimed
98001	1,421	14,393	10.1	3,825,714	250	604	298	170	129	96	124
98002	2,131	21,129	9.9	5,169,577	363	913	423	292	203	141	159
98003	2,368	22,299	9.4	5,524,259	375	1,093	486	286	184	146	173

Ui00zip.xls (145 kb)	Ui00zip.exe (58 kb)	Ui00zip.zip (43 kb)
Ui99zip.xls (179 kb)	Ui99zip.exe (64 kb)	Ui99zip.zip (49 kb)
Ui98zip.xls (189 kb)	Ui98zip.exe (64 kb)	Ui98zip.zip (49 kb)
Ui97zip.xls (112 kb)	Ui97zip.exe (49 kb)	Ui97zip.zip (34 kb)
Ui96zip.xls (112 kb)	Ui96zip.exe (49 kb)	Ui96zip.zip (34 kb)
Ui95zip.xls (112 kb)	Ui95zip.exe (49 kb)	Ui95zip.zip (34 kb)

1997-2000 Unemployment Insurance Claimants In Industry Division By ZIP Code

Detailed tables representing counts of all Unemployment Insurance claimants in MAJOR INDUSTRY DIVISIONS residing in Washington who had active claims under any program or entitlement during program years 1997-2000. (Program Year 2000 is for the time period July 1, 1999 - June 30, 2000). The sample below is an extract from the "2000 Number of UI Claimants in Industry Divisions by ZIP Code" file.

ZIP Code	Total Claimants	Ag/ Forestry/ Fishing	Mining/ Construction	Manf	Trans/ Comm/ Pub Utility	Whole Trade	Retail Trade	Finance/ Insurance/ Real Estate	Services	Public Admin	Not Classified/ UNCODED
98001	1,421	10	263	370	87	110	167	46	259	27	82
98002	2,131	16	387	554	104	149	233	77	463	44	104
98003	2,368	18	369	498	171	153	252	132	603	53	119

Clin00zp.xls (164 kb)	Clin00zp.exe (60 kb)	Clin00zp.zip (45 kb)
Clin99zp.xls (179 kb)	Clin99zp.exe (61 kb)	Clin99zp.zip (46 kb)
Clin98zp.xls (168 kb)	Clin98zp.exe (60 kb)	Clin98zp.zip (45 kb)
Clin97zp.xls (105 kb)	Clin97zp.exe (44 kb)	Clin97zp.zip (29 kb)

1997-2000 Annual Unemployment Insurance Claimants In Occupational Groups By ZIP Code

Detailed tables representing counts of all Unemployment Insurance claimants in MAJOR OCCUPATIONAL GROUPS residing in Washington who had active claims under any program or entitlement during program years 1997-2000. (Program Year 2000 is for the time period July 1, 1999 - June 30, 2000). The sample below is an extract from the "2000 Number of UI Claimants in Major Occupational Groups by ZIP Code" file.

ZIP Code	Total Clmts	Ag/Fish/ Forestry	Bench- work	Clerical	Machine Trades	Motor Freight/ Trans	Packaging/ Materials Handling	Process- ing	Prof/ Tech/ Manag	Sales	Services	Structural Work	Misc	Not Classified/ UNCODED
98001	1,421	13	73	158	145	81	104	18	334	89	101	293	12	0
98002	2,131	41	133	289	207	79	171	50	388	108	205	437	23	0
98003	2,368	35	86	341	170	82	177	58	591	182	227	401	18	0

Cloc00zp.xls (201 kb)	Cloc00zp.exe (69 kb)	Cloc00zp.zip (54 kb)
Cloc99zp.xls (214 kb)	Cloc99zp.exe (69 kb)	Cloc99zp.zip (54 kb)
Cloc98zp.xls (226 kb)	Cloc98zp.exe (69 kb)	Cloc98zp.zip (54 kb)
Cloc97zp.xls (133 kb)	Cloc97zp.exe (51 kb)	Cloc97zp.zip (36 kb)

	Privacy Notice