---
title: "readme"
output: html_document
date: "2026-05-11"
---

## Folders
1. Raw data are in the "raw data" folder.
2. Data processed and generated by the Stata file (data.do) are in the "processed data" folder.
3. Data ready for graphic can be found in the "data for graphic design.xlsx" Excel file.


## Data sources
[location in th replication package: raw data/]

# 1. Wage data
(1)
Source: Current Employment Statistics - CES, Bureau of Labor Statistics
Link: https://www.bls.gov/ces/data/
Textfile download: https://download.bls.gov/pub/time.series/ce/

Notes: We use the 2025 average of the monthly wage data of the selected series.
Series name and ID can be found in [raw data/ce.series.txt]
Raw data can be found in [raw data/ce.data.0.AllCESSeries.txt]
Data are accessed on May 5, 2026.
Selected series can be found below.

(2)
For Figure 1, several sectors (11, 52, 53, 61, 81) do not have monthly hourly earnings data. 
Thus we refer to 2024 Occupational Employment and Wage Statistics (OEWS) Tables and adjust 
them for inflation using total private-sector hourly wages.

Link: https://www.bls.gov/oes/tables.htm
Raw data files in the folder: 
- 2024 OEWS data: [raw data/Copy of natsector_M2024_dl.xlsx]
- Inflator: [raw data/CES0500000003.xlsx]


# 2. AI adoption
Source: Business Trends and Outlook Survey
Link: https://www.census.gov/hfp/btos/data_downloads

- 2-digit sectors (AI Supplement Table 2026.xlsx):
  a. Data are as reported by the survey. We use the estimates for respondents who answered "Yes" to question 1.
  
- Manufacturing subsector (Subsector.xlsx)
  b. The subsector document reports results from multiple survey samples. We use 
  the simple average of the six surveys(202525, 202526, 202601, 202602, 202603, 202604) 
  as a proxy for AI adoption in detail manufacturing subsectors. This covers the same 
  period as the "AI Supplement Table 2026.xlsx" file.

* Raw data above are processed in Stata [see data.do] and saved to folder [processed data/]


## Hourly wage data and respective wage data series ID
# 2-digit sectors
21	Mining, Quarrying, and Oil and Gas Extraction	CES1021000003    
22	Utilities	CES4422000003    
23	Construction	CES2000000003    
31	Manufacturing	CES3000000003    
42	Wholesale Trade	CES4142000003    
44	Retail Trade	CES4200000003    
48	Transportation and Warehousing	CES4300000003    
51	Information	CES5000000003    
54	Professional, Scientific, and Technical Services	CES6054000003    
55	Management of Companies and Enterprises	CES6055000003    
56	Administrative and Support and Waste Management and Remediation Services	CES6056000003    
62	Health Care and Social Assistance	CES6562000003    
71	Arts, Entertainment, and Recreation	CES7071000003    
72	Accommodation and Food Services	CES7072000003    

# Manufacturing subsectors
311	Food Manufacturing	CES3231100003    
313	Textile Mills	CES3231300003    
314	Textile Product Mills	CES3231400003    
315	Apparel Manufacturing	CES3231500003    
321	Wood Product Manufacturing	CES3132100003    
322	Paper Manufacturing	CES3232200003    
323	Printing And Related Support Activities	CES3232300003    
325	Chemical Manufacturing	CES3232500003    
326	Plastics And Rubber Products Manufacturing	CES3232600003    
327	Nonmetallic Mineral Product Manufacturing	CES3132700003    
331	Primary Metal Manufacturing	CES3133100003    
332	Fabricated Metal Product Manufacturing	CES3133200003    
333	Machinery Manufacturing	CES3133300003    
334	Computer And Electronic Product Manufacturing	CES3133400003    
335	Electrical Equipment, Appliance, And Component Manufacturing	CES3133500003    
336	Transportation Equipment Manufacturing	CES3133600003    
337	Furniture And Related Product Manufacturing	CES3133700003    
339	Miscellaneous Manufacturing	CES3133900003    

	