LMI For All

Documentation & Development

User Tools

Site Tools


Sidebar

Start Pages

Team Pages

Upcoming Events

Apr 24 Modding Day
data:format_working_futures

Working Futures Format

  • Submitted by:
  • Submitted on: 01/04/2016
  • Revision: 1
  • Status: To be revised by datateam
  • Revised by:
  • Revised on: ../../….

Filename

WFDataOcc4Digit-20160303.csv

with:

%createdate%creation date of the file yyyymmdd
%sequence%2 digit number

example: WFDataOcc4Digit-20160303.csv

  1. The combination of HOUR, createdate and sequence number has to be unique for WF
  2. File size and MD5 checksum have to be unique

Columns & Rules

Working Futures data

column DB column description rules
year year range 2014-2024 value: valid year
null: no
gender genderId 2 (male & female) value: 1, 2
null: no
status statusId 3 (FT, PT, X) value: 1, 2, 3
null: no
industry industryId 75 standard industries value: 1-75
null: no
occupation socId369 converted to soc2010 1-369 converted to 1115-9279
null: no
geography geographyId 12 UK countries and English regions *to be renamed to [regionId] value: 1-12
null: no
qualification qualificationId 9 (National Qualifications Framework) value: 1-9
null: no
weight weight number of people employed value: double-precision floating-point
null: no

Sample

year,gender,status,industry,occupation,geography,qualification,weight 2000,1,1,1,1,1,1,0.18982328028794535
2000,1,1,1,2,1,1,2.2357798603524572E-002
2000,1,1,1,3,1,1,0.73564069842147395
2000,1,1,1,4,1,1,0.43703301449267901
2000,1,1,1,5,1,1,4.6960525967539642E-002
2000,1,1,1,6,1,1,0.66088327724215745
2000,1,1,1,7,1,1,0.50167530690067874
2000,1,1,1,8,1,1,0.13264397155916996
2000,1,1,1,9,1,1,5.4473560730987095E-002
2000,1,1,1,10,1,1,0.35901590915872195
2000,1,1,1,11,1,1,0.15553032559528773
2000,1,1,1,12,1,1,0.29524048317839069
2000,1,1,1,13,1,1,0.26955508663385730
2000,1,1,1,14,1,1,0.20763510259125334
2000,1,1,1,15,1,1,0.23903660822023476

data/format_working_futures.txt · Last modified: 2016-04-08 14:37 by Luke Bosworth