LMI For All

Documentation & Development

User Tools

Site Tools


Sidebar

Start Pages

Team Pages

Upcoming Events

Apr 24 Modding Day
data:format_lfs

Labour Force Survey (Unemployment rates) Format

  • Submitted by: Raymond Elferink, raymond@raycom.com
  • Submitted on: 16/07/2013
  • Revision: 1
  • Status: To be revised by datateam
  • Revised by:
  • Revised on: ../../….

Filename

LFS_%createdate%_%sequence%.csv

with:

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

example: LFS_20130716_01.cvs

  1. Ordered List ItemThe combination createdate and sequence number has to be unique for LFS
  2. Filesize has to be unique

Columns & Rules

This file has data for 75 industries

column description rules
age Ages (0-74) value: > 0
null: no
AgeBands Ages Bands (8) value: LFSAgeBand
null: no
estat Employment Status (5) value: LFSEstat
null: no
Gender Gender (2) value: 1, 2
null: no
Ind75 Industry in main job (75) value: LFSIndustry
null: no
Ind75L Industry in last main job (75) value: LFSIndustry
null: yes
NQF5 Qualifications (0-5) value: LFSnqf5
null: no
NQF8 Qualifications (0-8) value: LFSnqf8
null: no
Occ2Dig10 Occupations SOC2010 (2 digit level) value: soc2010
null: no
Occ2Dig10L Last job Occupations SOC2010 (2 digit level) value: soc2010
null: yes
Occ3Dig10 Last job Occupations SOC2010 (3 digit level) value: soc2010
null: yes
Occ4Dig10 Occupations SOC2010 (4 digit level) value: soc2010
null: no
Region UK Regions (12) value: LFSRegion
null: no
WeightP Number of people value: >= 0
null: no
year Year (yyyy) value: valid year
null: no

Sample

data/format_lfs.txt · Last modified: 2013-07-16 14:17 by Raymond Elferink