Start Pages
Team Pages
Upcoming Events
| Apr 24 | Modding Day |
User Tools
Sidebar
data:format_lfs
Table of Contents
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
- Ordered List ItemThe combination createdate and sequence number has to be unique for LFS
- 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
