# Join log

## 1. DfE AI occupational exposure (SOC 2010)
- 365 SOC 2010 unit groups with a score (SOC 2010 has 369).

## 2. ONS SOC 2010 to SOC 2020 relationship table (unit groups)
- 369 SOC 2010 groups flow into 412 SOC 2020 groups through 714 weighted links (weight = people in the dual-coded Census sample, men plus women; LFS where Census is empty).
- SOC 2010 groups in the crosswalk with no DfE score: 4 (1116, 1171, 1255, 3311).
- 408 SOC 2020 groups get a score; 8 of them have part of their inflow unscored (coverage below 100%).
- 363 SOC 2020 groups take 90% or more of their workers from a single SOC 2010 group; 4 take less than half from any one group (blended scores).

## 3. ONS ASHE Table 14.7a, 2026 provisional
- Full-time sheet: 412 four-digit codes; median annual pay published for 362, suppressed for 50.
- All-employees sheet: 412 codes; jobs and mean pay both published for 337.

## 4. ONS Annual Population Survey, Nomis NM_218_1
- Employees only (etype=1): UK 412 of 412 codes published.
- Period Jul 2025-Jun 2026. UK: 412 of 412 codes published.
  - East: 384 published, 28 suppressed as unreliable or disclosive
  - East Midlands: 378 published, 34 suppressed as unreliable or disclosive
  - London: 367 published, 45 suppressed as unreliable or disclosive
  - North East: 346 published, 66 suppressed as unreliable or disclosive
  - North West: 384 published, 28 suppressed as unreliable or disclosive
  - Northern Ireland: 301 published, 111 suppressed as unreliable or disclosive
  - Scotland: 377 published, 35 suppressed as unreliable or disclosive
  - South East: 394 published, 18 suppressed as unreliable or disclosive
  - South West: 388 published, 24 suppressed as unreliable or disclosive
  - Wales: 365 published, 47 suppressed as unreliable or disclosive
  - West Midlands: 381 published, 31 suppressed as unreliable or disclosive
  - Yorkshire and The Humber: 380 published, 32 suppressed as unreliable or disclosive

## 5. ONS labour demand volumes (Textkernel online job adverts), Table 3
- 117 months (Jan-17 to Sep-26), regions: 13, UK codes: 413.
- Cells withheld by ONS (kept as missing, not zero): Jun-25 98, Jul-25 98, Dec-25 3, Feb-26 9, Mar-26 413, Jun-26 149, Jul-26 21, Aug-26 29.
- Headline advert window: October 2024 to September 2025, the latest 12 months before ONS's partly imputed period (October 2025 to September 2026). Compared with calendar 2019 (pre-pandemic), with November 2021 to October 2022 (the year before ChatGPT launched) and with October 2023 to September 2024 (the year before).

## 6. Master table
- Mean pay: 391 from the four-digit row, 20 filled from three-digit, 1 from two-digit.
- Wage bill total £1,212bn across 412 jobs.

## 7. Additional measures
- Census 2021 (England and Wales), people aged 16 to 24 as a share of each job: 412 jobs; 118 small cells suppressed by ONS counted as zero.
- APS Apr 2025 to Mar 2026 (ONS ad hoc 3501), share with a degree or equivalent: 402 jobs (jobs with fewer than 5,000 people with a known qualification left blank).
- ILO 2025 generative AI exposure (Working Paper 140), mapped from ISCO-08 through the ONS SOC 2020 coding index (average over each job's index titles): 408 jobs. Rank correlation with the DfE score: 0.80.
- All jobs: 10.3% aged 16 to 24 (Census 2021); 46.8% with a degree (APS).

## 8. Cross-checks on the advert series
- Latest 12 months against 2019: Textkernel adverts -28%, ONS X06 vacancies -8%.
- Jan to Sep 2024 against 2019: Textkernel -23%, Adzuna -14%, X06 +6%; rank correlation of the two advert sources across 10 matched categories 0.14.
- 412 SOC 2020 codes. Exposure 408, employment 412, full-time median pay 362, wage bill 412, advert change vs 2019 412.
- Complete for the hero chart (exposure, employment and pay): 361.
- "Highly exposed" = the most exposed fifth of scored jobs: 82 jobs.
- No exposure score: 1112 Elected officers and representatives, 1161 Officers in armed forces, 1254 Waste disposal and environmental services managers, 3311 Non-commissioned officers and other ranks
