LMI For All

Documentation & Development

User Tools

Site Tools


Sidebar

Start Pages

Team Pages

Upcoming Events

Apr 24 Modding Day
data:specsheet_changeinpay

ASHE Change in Average Weekly Pay 2014-2015 %

  • Submitted by: Luke Bosworth, l.p.bosworth@warwick.ac.uk
  • Submitted on: 13/09/2016
  • Revision; 3

Data File(s)

This data load contains 1 file, which is as follows:

File Content Size (bytes)
'Change in Weekly pay 2014-15.csv' ASHE Change in Pay 2014-2015 % 331,940

Source Dataset

These data come from ASHE (Annual Survey of hours and earnings).

Processing

The data provided are for all workers by region, for 4 digit SOC categories (where available). Sub totals are also provided for SOC 1, 2 and 3 digit categories.

Fields and Columns

'Change in Weekly pay 2014-15.csv'

  • Region ID - 0-12 (UK=0,NI=12)
  • Region - UK and Regions
  • Occ Digit Level - 1-4 (determins the SOC digit level)
  • SOC Code - All (0), 1 Digit (1-9) - 9, 2 Digit (11-92) - 25, 3 Digit (111-927) - 90, 4 Digit (1115-9279) - 369
  • SOC Description - SOC Description, including SOC code.
  • Annual % change - Annual % change for each Occupation within the region

Output

When queried the dataset output provides information on the annual change in weekly pay between 2014 and 2015.

Queries and calculations

'Change in Weekly pay 2014-15.csv'

The first column contains the Region ID, the second column contains the Region name, the third column contains the Occupation Digit level, the fourth column contains the SOC2010 code, the fifth column contains the SOC2010 description, the sixth column contains the annual change in pay percentage between 2014 and 2015.

  1. Region ID
  2. Region
  3. Occ Digit Level
  4. SOC Code
  5. SOC Description
  6. Annual % change

Description of the data

The annual percent change between 2014 and 2015 are taken from published ASHE data.

Region
Region ID Region SN Region LN
0 UK United Kingdom
1 LO London
2 SE South East
3 EE East of England
4 SW South West
5 WM West Midlands
6 EM East Midlands
7 YH Yorkshire and the Humber
8 NW North West
9 NE North East
10 WA Wales
11 SC Scotland
12 NI Northern Ireland
SOC 1 Digit - 9
Soc Code Soc Description
1 1. Managers, directors and senior officials
2 2. Professional occupations
3 3. Associate professional and technical occupations
4 4. Administrative and secretarial occupations
5 5. Skilled trades occupations
6 6. Caring, leisure and other service occupations
7 7. Sales and customer service occupations
8 8. Process, plant and machine operatives
9 9. Elementary occupations
SOC 2 Digit - 25
Soc Code Soc Description
11 11. Corporate managers and directors
12 12. Other managers and proprietors
21 21. Science, research, engineering and technology professionals
22 22. Health professionals
23 23. Teaching and educational professionals
24 24. Business, media and public service professionals
31 31. Science, engineering and technology associate professionals
32 32. Health and social care associate professionals
33 33. Protective service occupations
34 34. Culture, media and sports occupations
35 35. Business and public service associate professionals
41 41. Administrative occupations
42 42. Secretarial and related occupations
51 51. Skilled agricultural and related trades
52 52. Skilled metal, electrical and electronic trades
53 53. Skilled construction and building trades
54 54. Textiles, printing and other skilled trades
61 61. Caring personal service occupations
62 62. Leisure, travel and related personal service occupations
71 71. Sales occupations
72 72. Customer service occupations
81 81. Process, plant and machine operatives
82 82. Transport and mobile machine drivers and operatives
91 91. Elementary trades and related occupations
92 92. Elementary administration and service occupations
SOC 3 Digit - 90
Soc Code Soc Description
111 111. Chief executives and senior officials
112 112. Production managers and directors
113 113. Functional managers and directors
115 115. Financial institution managers and directors
116 116. Managers and directors in transport and logistics
117 117. Senior officers in protective services
118 118. Health and social services managers and directors
119 119. Managers and directors in retail and wholesale
121 121. Managers and proprietors in agriculture related services
122 122. Managers and proprietors in hospitality and leisure services
124 124. Managers and proprietors in health and care services
125 125. Managers and proprietors in other services
211 211. Natural and social science professionals
212 212. Engineering professionals
213 213. Information technology and telecommunications professionals
214 214. Conservation and environment professionals
215 215. Research and development managers
221 221. Health professionals
222 222. Therapy professionals
223 223. Nursing and midwifery professionals
231 231. Teaching and educational professionals
241 241. Legal professionals
242 242. Business, research and administrative professionals
243 243. Architects, town planners and surveyors
244 244. Welfare professionals
245 245. Librarians and related professionals
246 246. Quality and regulatory professionals
247 247. Media professionals
311 311. Science, engineering and production technicians
312 312. Draughtspersons and related architectural technicians
313 313. Information technology technicians
321 321. Health associate professionals
323 323. Welfare and housing associate professionals
331 331. Protective service occupations
341 341. Artistic, literary and media occupations
342 342. Design occupations
344 344. Sports and fitness occupations
351 351. Transport associate professionals
352 352. Legal associate professionals
353 353. Business, finance and related associate professionals
354 354. Sales, marketing and related associate professionals
355 355. Conservation and environmental associate professionals
356 356. Public services and other associate professionals
411 411. Administrative occupations: Government and related organisations
412 412. Administrative occupations: Finance
413 413. Administrative occupations: Records
415 415. Other administrative occupations
416 416. Administrative occupations: Office managers and supervisors
421 421. Secretarial and related occupations
511 511. Agricultural and related trades
521 521. Metal forming, welding and related trades
522 522. Metal machining, fitting and instrument making trades
523 523. Vehicle trades
524 524. Electrical and electronic trades
525 525. Skilled metal, electrical and electronic trades supervisors
531 531. Construction and building trades
532 532. Building finishing trades
533 533. Construction and building trades supervisors
541 541. Textiles and garments trades
542 542. Printing trades
543 543. Food preparation and hospitality trades
544 544. Other skilled trades
612 612. Childcare and related personal services
613 613. Animal care and control services
614 614. Caring personal services
621 621. Leisure and travel services
622 622. Hairdressers and related services
623 623. Housekeeping and related services
624 624. Cleaning and housekeeping managers and supervisors
711 711. Sales assistants and retail cashiers
712 712. Sales related occupations
713 713. Sales supervisors
721 721. Customer service occupations
722 722. Customer service managers and supervisors
811 811. Process operatives
812 812. Plant and machine operatives
813 813. Assemblers and routine operatives
814 814. Construction operatives
821 821. Road transport drivers
822 822. Mobile machine drivers and operatives
823 823. Other drivers and transport operatives
911 911. Elementary agricultural occupations
912 912. Elementary construction occupations
913 913. Elementary process plant occupations
921 921. Elementary administration occupations
923 923. Elementary cleaning occupations
924 924. Elementary security occupations
925 925. Elementary sales occupations
926 926. Elementary storage occupations
927 927. Other elementary services occupations
SOC 4 Digit - 369
Soc Code Soc Description
1115 1115. Chief executives and senior officials
1116 1116. Elected officers and representatives
1121 1121. Production managers and directors in manufacturing
1122 1122. Production managers and directors in construction
1123 1123. Production managers and directors in mining and energy
1131 1131. Financial managers and directors
1132 1132. Marketing and sales directors
1133 1133. Purchasing managers and directors
1134 1134. Advertising and public relations directors
1135 1135. Human resource managers and directors
1136 1136. Information technology and telecommunications directors
1139 1139. Functional managers and directors n.e.c.
1150 1150. Financial institution managers and directors
1161 1161. Managers and directors in transport and distribution
1162 1162. Managers and directors in storage and warehousing
1171 1171. Officers in armed forces
1172 1172. Senior police officers
1173 1173. Senior officers in fire, ambulance, prison and related services
1181 1181. Health services and public health managers and directors
1184 1184. Social services managers and directors
1190 1190. Managers and directors in retail and wholesale
1211 1211. Managers and proprietors in agriculture and horticulture
1213 1213. Managers and proprietors in forestry, fishing and related services
1221 1221. Hotel and accommodation managers and proprietors
1223 1223. Restaurant and catering establishment managers and proprietors
1224 1224. Publicans and managers of licensed premises
1225 1225. Leisure and sports managers
1226 1226. Travel agency managers and proprietors
1241 1241. Health care practice managers
1242 1242. Residential, day and domiciliarycare managers and proprietors
1251 1251. Property, housing and estate managers
1252 1252. Garage managers and proprietors
1253 1253. Hairdressing and beauty salon managers and proprietors
1254 1254. Shopkeepers and proprietors – wholesale and retail
1255 1255. Waste disposal and environmental services managers
1259 1259. Managers and proprietors in other services n.e.c.
2111 2111. Chemical scientists
2112 2112. Biological scientists and biochemists
2113 2113. Physical scientists
2114 2114. Social and humanities scientists
2119 2119. Natural and social science professionals n.e.c.
2121 2121. Civil engineers
2122 2122. Mechanical engineers
2123 2123. Electrical engineers
2124 2124. Electronics engineers
2126 2126. Design and development engineers
2127 2127. Production and process engineers
2129 2129. Engineering professionals n.e.c.
2133 2133. IT specialist managers
2134 2134. IT project and programme managers
2135 2135. IT business analysts, architects and systems designers
2136 2136. Programmers and software development professionals
2137 2137. Web design and development professionals
2139 2139. Information technology and telecommunications professionals n.e.c.
2141 2141. Conservation professionals
2142 2142. Environment professionals
2150 2150. Research and development managers
2211 2211. Medical practitioners
2212 2212. Psychologists
2213 2213. Pharmacists
2214 2214. Ophthalmic opticians
2215 2215. Dental practitioners
2216 2216. Veterinarians
2217 2217. Medical radiographers
2218 2218. Podiatrists
2219 2219. Health professionals n.e.c.
2221 2221. Physiotherapists
2222 2222. Occupational therapists
2223 2223. Speech and language therapists
2229 2229. Therapy professionals n.e.c.
2231 2231. Nurses
2232 2232. Midwives
2311 2311. Higher education teaching professionals
2312 2312. Further education teaching professionals
2314 2314. Secondary education teaching professionals
2315 2315. Primary and nursery education teaching professionals
2316 2316. Special needs education teaching professionals
2317 2317. Senior professionals of educational establishments
2318 2318. Education advisers and school inspectors
2319 2319. Teaching and other educational professionals n.e.c.
2412 2412. Barristers and judges
2413 2413. Solicitors
2419 2419. Legal professionals n.e.c.
2421 2421. Chartered and certified accountants
2423 2423. Management consultants and business analysts
2424 2424. Business and financial project management professionals
2425 2425. Actuaries, economists and statisticians
2426 2426. Business and related research professionals
2429 2429. Business, research and administrative professionals n.e.c.
2431 2431. Architects
2432 2432. Town planning officers
2433 2433. Quantity surveyors
2434 2434. Chartered surveyors
2435 2435. Chartered architectural technologists
2436 2436. Construction project managers and related professionals
2442 2442. Social workers
2443 2443. Probation officers
2444 2444. Clergy
2449 2449. Welfare professionals n.e.c.
2451 2451. Librarians
2452 2452. Archivists and curators
2461 2461. Quality control and planning engineers
2462 2462. Quality assurance and regulatory professionals
2463 2463. Environmental health professionals
2471 2471. Journalists, newspaper and periodical editors
2472 2472. Public relations professionals
2473 2473. Advertising accounts managers and creative directors
3111 3111. Laboratory technicians
3112 3112. Electrical and electronics technicians
3113 3113. Engineering technicians
3114 3114. Building and civil engineering technicians
3115 3115. Quality assurance technicians
3116 3116. Planning, process and production technicians
3119 3119. Science, engineering and production technicians n.e.c.
3121 3121. Architectural and town planning technicians
3122 3122. Draughtspersons
3131 3131. IT operations technicians
3132 3132. IT user support technicians
3213 3213. Paramedics
3216 3216. Dispensing opticians
3217 3217. Pharmaceutical technicians
3218 3218. Medical and dental technicians
3219 3219. Health associate professionals n.e.c.
3231 3231. Youth and community workers
3233 3233. Child and early years officers
3234 3234. Housing officers
3235 3235. Counsellors
3239 3239. Welfare and housing associate professionals n.e.c.
3311 3311. NCOs and other ranks
3312 3312. Police officers (sergeant and below)
3313 3313. Fire service officers (watch manager and below)
3314 3314. Prison service officers (below principal officer)
3315 3315. Police community support officers
3319 3319. Protective service associate professionals n.e.c.
3411 3411. Artists
3412 3412. Authors, writers and translators
3413 3413. Actors, entertainers and presenters
3414 3414. Dancers and choreographers
3415 3415. Musicians
3416 3416. Arts officers, producers and directors
3417 3417. Photographers, audio-visual and broadcasting equipment operators
3421 3421. Graphic designers
3422 3422. Product, clothing and related designers
3441 3441. Sports players
3442 3442. Sports coaches, instructors and officials
3443 3443. Fitness instructors
3511 3511. Air traffic controllers
3512 3512. Aircraft pilots and flight engineers
3513 3513. Ship and hovercraft officers
3520 3520. Legal associate professionals
3531 3531. Estimators, valuers and assessors
3532 3532. Brokers
3533 3533. Insurance underwriters
3534 3534. Finance and investment analysts and advisers
3535 3535. Taxation experts
3536 3536. Importers and exporters
3537 3537. Financial and accounting technicians
3538 3538. Financial accounts managers
3539 3539. Business and related associate professionals n.e.c.
3541 3541. Buyers and procurement officers
3542 3542. Business sales executives
3543 3543. Marketing associate professionals
3544 3544. Estate agents and auctioneers
3545 3545. Sales accounts and business development managers
3546 3546. Conference and exhibition managers and organisers
3550 3550. Conservation and environmental associate professionals
3561 3561. Public services associate professionals
3562 3562. Human resources and industrial relations officers
3563 3563. Vocational and industrial trainers and instructors
3564 3564. Careers advisers and vocational guidance specialists
3565 3565. Inspectors of standards and regulations
3567 3567. Health and safety officers
4112 4112. National government administrative occupations
4113 4113. Local government administrative occupations
4114 4114. Officers of non-governmental organisations
4121 4121. Credit controllers
4122 4122. Book-keepers, payroll managers and wages clerks
4123 4123. Bank and post office clerks
4124 4124. Finance officers
4129 4129. Financial administrative occupations n.e.c.
4131 4131. Records clerks and assistants
4132 4132. Pensions and insurance clerks and assistants
4133 4133. Stock control clerks and assistants
4134 4134. Transport and distribution clerks and assistants
4135 4135. Library clerks and assistants
4138 4138. Human resources administrative occupations
4151 4151. Sales administrators
4159 4159. Other administrative occupations n.e.c.
4161 4161. Office managers
4162 4162. Office supervisors
4211 4211. Medical secretaries
4212 4212. Legal secretaries
4213 4213. School secretaries
4214 4214. Company secretaries
4215 4215. Personal assistants and other secretaries
4216 4216. Receptionists
4217 4217. Typists and related keyboard occupations
5111 5111. Farmers
5112 5112. Horticultural trades
5113 5113. Gardeners and landscape gardeners
5114 5114. Groundsmen and greenkeepers
5119 5119. Agricultural and fishing trades n.e.c.
5211 5211. Smiths and forge workers
5212 5212. Moulders, core makers and die casters
5213 5213. Sheet metal workers
5214 5214. Metal plate workers, and riveters
5215 5215. Welding trades
5216 5216. Pipe fitters
5221 5221. Metal machining setters and setter-operators
5222 5222. Tool makers, tool fitters and markers-out
5223 5223. Metal working production and maintenance fitters
5224 5224. Precision instrument makers and repairers
5225 5225. Air-conditioning and refrigeration engineers
5231 5231. Vehicle technicians, mechanics and electricians
5232 5232. Vehicle body builders and repairers
5234 5234. Vehicle paint technicians
5235 5235. Aircraft maintenance and related trades
5236 5236. Boat and ship builders and repairers
5237 5237. Rail and rolling stock builders and repairers
5241 5241. Electricians and electrical fitters
5242 5242. Telecommunications engineers
5244 5244. TV, video and audio engineers
5245 5245. IT engineers
5249 5249. Electrical and electronic trades n.e.c.
5250 5250. Skilled metal, electrical and electronic trades supervisors
5311 5311. Steel erectors
5312 5312. Bricklayers and masons
5313 5313. Roofers, roof tilers and slaters
5314 5314. Plumbers and heating and ventilating engineers
5315 5315. Carpenters and joiners
5316 5316. Glaziers, window fabricators and fitters
5319 5319. Construction and building trades n.e.c.
5321 5321. Plasterers
5322 5322. Floorers and wall tilers
5323 5323. Painters and decorators
5330 5330. Construction and building trades supervisors
5411 5411. Weavers and knitters
5412 5412. Upholsterers
5413 5413. Footwear and leather working trades
5414 5414. Tailors and dressmakers
5419 5419. Textiles, garments and related trades n.e.c.
5421 5421. Pre-press technicians
5422 5422. Printers
5423 5423. Print finishing and binding workers
5431 5431. Butchers
5432 5432. Bakers and flour confectioners
5433 5433. Fishmongers and poultry dressers
5434 5434. Chefs
5435 5435. Cooks
5436 5436. Catering and bar managers
5441 5441. Glass and ceramics makers, decorators and finishers
5442 5442. Furniture makers and other craft woodworkers
5443 5443. Florists
5449 5449. Other skilled trades n.e.c.
6121 6121. Nursery nurses and assistants
6122 6122. Childminders and related occupations
6123 6123. Playworkers
6125 6125. Teaching assistants
6126 6126. Educational support assistants
6131 6131. Veterinary nurses
6132 6132. Pest control officers
6139 6139. Animal care services occupations n.e.c.
6141 6141. Nursing auxiliaries and assistants
6142 6142. Ambulance staff (excluding paramedics)
6143 6143. Dental nurses
6144 6144. Houseparents and residential wardens
6145 6145. Care workers and home carers
6146 6146. Senior care workers
6147 6147. Care escorts
6148 6148. Undertakers, mortuary and crematorium assistants
6211 6211. Sports and leisure assistants
6212 6212. Travel agents
6214 6214. Air travel assistants
6215 6215. Rail travel assistants
6219 6219. Leisure and travel service occupations n.e.c.
6221 6221. Hairdressers and barbers
6222 6222. Beauticians and related occupations
6231 6231. Housekeepers and related occupations
6232 6232. Caretakers
6240 6240. Cleaning and housekeeping managers and supervisors
7111 7111. Sales and retail assistants
7112 7112. Retail cashiers and check-out operators
7113 7113. Telephone salespersons
7114 7114. Pharmacy and other dispensing assistants
7115 7115. Vehicle and parts salespersons and advisers
7121 7121. Collector salespersons and credit agents
7122 7122. Debt, rent and other cash collectors
7123 7123. Roundspersons and van salespersons
7124 7124. Market and street traders and assistants
7125 7125. Merchandisers and window dressers
7129 7129. Sales related occupations n.e.c.
7130 7130. Sales supervisors
7211 7211. Call and contact centre occupations
7213 7213. Telephonists
7214 7214. Communication operators
7215 7215. Market research interviewers
7219 7219. Customer service occupations n.e.c.
7220 7220. Customer service managers and supervisors
8111 8111. Food, drink and tobacco process operatives
8112 8112. Glass and ceramics process operatives
8113 8113. Textile process operatives
8114 8114. Chemical and related process operatives
8115 8115. Rubber process operatives
8116 8116. Plastics process operatives
8117 8117. Metal making and treating process operatives
8118 8118. Electroplaters
8119 8119. Process operatives n.e.c.
8121 8121. Paper and wood machine operatives
8122 8122. Coal mine operatives
8123 8123. Quarry workers and related operatives
8124 8124. Energy plant operatives
8125 8125. Metal working machine operatives
8126 8126. Water and sewerage plant operatives
8127 8127. Printing machine assistants
8129 8129. Plant and machine operatives n.e.c.
8131 8131. Assemblers (electrical and electronic products)
8132 8132. Assemblers (vehicles and metal goods)
8133 8133. Routine inspectors and testers
8134 8134. Weighers, graders and sorters
8135 8135. Tyre, exhaust and windscreen fitters
8137 8137. Sewing machinists
8139 8139. Assemblers and routine operatives n.e.c.
8141 8141. Scaffolders, stagers and riggers
8142 8142. Road construction operatives
8143 8143. Rail construction and maintenance operatives
8149 8149. Construction operatives n.e.c.
8211 8211. Large goods vehicle drivers
8212 8212. Van drivers
8213 8213. Bus and coach drivers
8214 8214. Taxi and cab drivers and chauffeurs
8215 8215. Driving instructors
8221 8221. Crane drivers
8222 8222. Fork-lift truck drivers
8223 8223. Agricultural machinery drivers
8229 8229. Mobile machine drivers and operatives n.e.c.
8231 8231. Train and tram drivers
8232 8232. Marine and waterways transport operatives
8233 8233. Air transport operatives
8234 8234. Rail transport operatives
8239 8239. Other drivers and transport operatives n.e.c.
9111 9111. Farm workers
9112 9112. Forestry workers
9119 9119. Fishing and other elementary agriculture occupations n.e.c.
9120 9120. Elementary construction occupations
9132 9132. Industrial cleaning process occupations
9134 9134. Packers, bottlers, canners and fillers
9139 9139. Elementary process plant occupations n.e.c.
9211 9211. Postal workers, mail sorters, messengers and couriers
9219 9219. Elementary administration occupations n.e.c.
9231 9231. Window cleaners
9232 9232. Street cleaners
9233 9233. Cleaners and domestics
9234 9234. Launderers, dry cleaners and pressers
9235 9235. Refuse and salvage occupations
9236 9236. Vehicle valeters and cleaners
9239 9239. Elementary cleaning occupations n.e.c.
9241 9241. Security guards and related occupations
9242 9242. Parking and civil enforcement occupations
9244 9244. School midday and crossing patrol occupations
9249 9249. Elementary security occupations n.e.c.
9251 9251. Shelf fillers
9259 9259. Elementary sales occupations n.e.c.
9260 9260. Elementary storage occupations
9271 9271. Hospital porters
9272 9272. Kitchen and catering assistants
9273 9273. Waiters and waitresses
9274 9274. Bar staff
9275 9275. Leisure and theme park attendants
9279 9279. Other elementary services occupations n.e.c.

Classifications and aggregations

Closing Notes

data/specsheet_changeinpay.txt · Last modified: 2017-02-08 10:42 by Luke Bosworth