Data Discovery
All variables here are from Understanding Society unless otherwise stated
Although at first glance lots of variables are only asked intermittently, I think we will be able to derive lots of useful information from those that are asked more often. E.g. MRS social class in psychosocial is only included on two non-consecutive waves, however RG Social Class: present job was asked at every wave with good detail, which can be used to derive MRS.
Wage/Income
Individual income variables - this page details the six components of individual net income, and which variables in BHPS or US that relate to these components.
Only going to list labour income variables, as there are lots of others that are unrelated to this work. A living wage will only affect labour income.
N.B. The top variable here (fimnlabnet_dv) is a derived variable, which is the sum of three earnings components:
paynu_dv
: net usual payseearnnet_dv
: net self-employment incomej2paynet_dv
: net pay in second job
Variable |
Label |
Datafile |
Waves |
Notes |
---|---|---|---|---|
LABOUR |
INCOME |
|||
amount income component 1: net labour income |
indresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
Derived variable, sum of the next three variables in this table. |
|
Total monthly labour gross income |
indresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, bh01, bh02, bh03, bh04, bh05, bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Gross monthly pay rather than net. |
|
Total gross household labour income: month before interview |
hhresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
Gross monthly household income. |
|
Usual net pay per month: current job |
indresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, bh01, bh02, bh03, bh04, bh05, bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Component of labour income. |
|
Self employment earnings - net |
indresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
Component of labour income |
|
Pay in second job |
indresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, bh01, bh02, bh03, bh04, bh05, bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Component of labour income. |
|
Basic pay hourly rate |
indresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
||
No. of hours normally worked per week |
indresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Behaviour - Nutrition
(food security, hunger, better quality food)
Variables related to food and nutrition are somewhat lacking in US. Some variables included here are not very strongly related or at best incomplete in capturing the topic.
Variable |
Label |
Datafile |
Waves |
Notes |
---|---|---|---|---|
Food |
Security |
|||
Food banks usage |
hhresp |
11 |
Only in wave 11, might be useful as a component of a constructed/aggregated variable |
|
Eat meat on alternate days |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Think this can fit in both hunger or food security. As the last time this was asked was in BHPS wave 18 (2008), I don’t think the answers would be related to health or environmental reasons. Comes under index terms for financial management: problems and financial management: material wellbeing so we can be confident this is a financial decision. |
|
How often: eat out |
indresp |
bh06, bh08, bh10, bh12, bh14, bh16, bh18 |
Comes under index terms for time use and leisure activities, however we could investigate how income/wealth is related to those who answered never/almost never.Clutching at straws a little here as theres not much to go on. |
|
Hunger |
||||
Days eats breakfast |
indresp |
7, 9, 11 |
Could be for many reasons other than lack of access to food, however included this as there are not many variables that can relate to hunger. |
|
filling meal a day: no, no money for this |
hhresp |
4, 6, 8, 10 |
Household question, only asked if there is a pensioner in the house. |
|
Food |
Quality |
|||
Days each week eat fruit |
indresp |
2, 5, 7, 9, 11 |
Including tinned, frozen, dried and fresh.Question asks for usual week.Categories: Never, 1-3d, 4-6d, everyday |
|
Days each week eat vegetables |
indresp |
2, 5, 7, 9, 11 |
Including tinned, frozen and fresh.Does not include potatoes, crisps, or chips.Same categories as above. |
|
Eat fruit and veg every day |
hhresp |
4, 6, 8, 10 |
Only asked if there is at least one child (age 0-15) living in the household. |
Behaviour - Alcohol and Tobacco Consumption
(increase/decrease?)
Variable |
Label |
Datafile |
Waves |
Notes |
---|---|---|---|---|
Alcohol |
||||
Drank alcohol last 7 days |
indresp |
2, 5 |
Binary, only asked if answered previous question stating that respondent has had an alcoholic drink in last 12 months. Also only asked in self-completion or telephone interviews. |
|
Past 12 months alcoholic drink |
indresp |
7, 9, 11 |
Binary |
|
Alcohol frequency past 12 months |
indresp |
7, 9, 11 |
Ordinal, 5 categories ranging from Never, monthly or less, …, up to 4+ times per week. |
|
Ever had an alcoholic drink |
indresp |
3, 4, 6, 8, 10 |
Only asked for young adults aged 16-21. |
|
Frequency of 5 plus alcoholic drinks |
indresp |
3, 4, 6, 8, 10 |
Again only asked for young adults aged 16-21. One drink is defined as one pint/bottle/can of beer or cider, 2 alcopops, one small glass of wine, a single measure of spirits. |
|
Health problems: Alcohol or drugs |
indresp |
bh01, bh02, bh03, bh04, bh05, bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary, positive response indicates problem with either alcohol or drugs.Very low relative frequency of positive response but could still be useful. |
|
Total amount spent on alcohol |
hhresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
Household spending in past 4 weeks. Includes all alcohol (supermarkets/shops, pubs, restaurants, other venues). |
|
Past month: how many alcoholic drinks? |
indresp |
3, 4, 6, 8, 10 |
Ordinal, question specifies how many times in the past month, not how many drinks. |
|
How often have you had an alcoholic drink during the last 12 months? |
indresp |
2, 5 |
Ordinal variable with 8 categories. Almost every day, …, once or twice a week, …, once or twice a year, not at all in last 12 months. |
|
Tobacco |
||||
Smoker |
indresp |
6, 7, 8, 9, 10, 11, bh01, bh02, bh03, bh04, bh05, bh06, bh07, bh08, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Simple binary, ‘do you smoke cigarettes?’ |
|
Ever smoked cigarettes? |
indresp |
2, 5, bh09 |
Cigarette, cigar, or pipe. |
|
Smoke nowadays |
indresp |
2, 5, bh09 |
Asked if smever == 1 |
|
Smoking history |
indresp |
2, 5, bh09, bh12 |
Text: _Have you ever smoked cigarettes regularly, that is at least one cigarette a day, or did you smoke them only occasionally?_If smever == 1 (yes) && smnow == 2 (does no smoke nowadays). |
|
Usual no. of cigarettes smoked per day |
indresp |
2, 5, 6, 7, 8, 9, 10, 11, bh01, bh02, bh03, bh04, bh05, bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Asked if smoker == 1 |
|
Number of cigarettes smoked in past |
indresp |
2, 5, bh09 |
If smever == 1 (ever smoked)&& smnow == 2 (does not smoke now)&& smcigs == 1 (used to smoke regularly) |
|
Uses electronic cigarettes |
indresp |
9, 10, 11 |
Ordinal. |
Housing Quality
(decent homes = less damp, warmer, housing security)
Still to do: Look for more vars related to housing security.
Variable |
Label |
Datafile |
Waves |
Notes |
---|---|---|---|---|
Satisfaction with: house/flat |
indresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Ordinal, 7 categories from:Not satisfied at all -> Completely satisfied |
|
Material deprivation: house |
hhresp |
1, 2, 4, 6, 8, 10 |
Question Text:Enough money to keep your house in a decent state of repair? |
|
Problems paying for housing |
hhresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, bh01, bh02, bh03, bh04, bh05, bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Many people find it hard to keep up with their housing payments. In the last twelve months, have you ever found yourself behind with your rent/mortgage? |
|
Accom: not enough light |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
Accom: lack of adequate heating |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
Accom: condensation |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
Accom: leaky roof |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
Accom: damp walls, floors etc. |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
Accom: rot in windows, floors |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
home good state of repair: no, no money for this |
hhresp |
4, 6, 8, 10 |
Specifically about pensioners and only asked if pensioner in the house. |
|
damp-free home: no, no money for this |
hhresp |
4, 6, 8, 10 |
Again pensioners only |
|
home kept warm: no, no money for this |
hhresp |
4, 6, 8, 10 |
Pensioner |
|
keep accommodation warm enough |
hhresp |
1, 2, 4, 6, 8, 9, 10, 11 |
Asked of everyone, specifically about keeping the house warm enough in winter. |
Moving Home
(could mean less overcrowding, better neighbourhood with more green space, different cultural norms, better recreational and health care facilities, better food outlets, less tobacco and alcohol outlets, less crime and anti-social behaviours)
Variable |
Label |
Datafile |
Waves |
Notes |
---|---|---|---|---|
Accom: shortage of space |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
Accom: noise from neighbours |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
Accom: street noise |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Binary |
|
Number of bedrooms |
hhresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, bh01 |
||
Accom: has terrace/garden |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Should be used alongside hsgdns, which is Accom: is terrace/garden shared? |
|
Accom: pollution/environmental problems |
hhresp |
bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
||
Number of rooms in accomodation |
hhresp |
bh01, bh02, bh03, bh04, bh05, bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
||
Neighbourhood |
||||
conditions of residential properties |
hhsamp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
Ordinal, 4 levels |
|
Boarded houses: abandoned buildings: demolished houses or demolished buildings |
hhsamp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
Thought this would relate to the neighbourhood quality. |
|
trash: litter or junk in street/road |
hhsamp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
||
heavy traffic on street/road |
hhsamp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
||
Neighbourhood Social Cohesion,(α= .8) |
indresp |
3, 6 |
Summary of 4 variables on neighbourhood social cohesion. Ordinal var with range from 4 (no cohesion) to 20 (strong cohesion). |
|
Am similar to others in neighbourhood |
indresp |
1, 3, 6, 9 |
I think of myself as similar to the people that live in this neighbourhood. |
|
people in this neighbourhood can be trusted |
indresp |
3, 6 |
||
Buckner’s Neighbourhood Cohesion Instrument, short (alpha ±= .88) |
indresp |
1, 3, 6, 9 |
||
extent of: homes broken into |
hhresp, indresp |
3, 6, 9, bh07, bh12, bh17 |
This and the following 8 vars (labels all start with ‘extent of: ‘ are more objective measures of the quality of a neighbourhood (still measured subjectively, but asking about specific things). |
|
extent of: cars stolen/broken into |
indresp, hhresp |
3, 6, 9, bh07, bh12, bh17 |
||
extent of: drunks/tramps on street |
hhresp, indresp |
3, 6, 9, bh07, bh12, bh17 |
||
extent of: graffiti on walls |
indresp, hhresp |
3, 6, 9, bh07, bh12, bh17 |
||
extent of: people attacked on street |
indresp, hhresp |
3, 6, 9, bh07, bh12, bh17 |
||
extent of: racial insults/attacks |
hhresp, indresp |
3, 6, 9, bh07, bh12, bh17 |
||
extent of: teenagers hanging about |
indresp, hhresp |
3, 6, 9, bh07, bh12, bh17 |
||
extent of: vandalism |
hhresp, indresp |
3, 6, 9, bh07, bh12, bh17 |
||
extent of: rubbish on street |
hhresp |
3, 6, 9 |
||
worry about being affected by crime |
indresp |
3, 6, bh07, bh12, bh17 |
Binary |
|
extent of worry about crime |
indresp |
3, 6, bh07, bh12, bh17 |
Ordinal, 3 levels |
|
Suitability of area for raising children |
indresp |
bh08, bh13, bh18 |
||
Council tax band of accommodation |
hhresp |
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, bh06, bh07, bh08, bh09, bh10, bh11, bh12, bh13, bh14, bh15, bh16, bh17, bh18 |
Don’t know if this is important or not but must have some relationship to neighbourhood? |
|
At school |
indresp |
3, 5, 7, 9, 11 |
This and the following 12 variables all relate to feeling safe in specific places. |
|
At college/university |
indresp |
3, 5, 7, 9, 11 |
||
At work |
indresp |
3, 5, 7, 9, 11 |
||
On public transport |
indresp |
3, 5, 7, 9, 11 |
||
At/near Bus/train stn |
indresp |
3, 5, 7, 9, 11 |
||
In Shopping centres, etc |
indresp |
3, 5, 7, 9, 11 |
||
In cinema, cafes |
indresp |
3, 5, 7, 9, 11 |
||
At pub/disco/club |
indresp |
3, 5, 7, 9, 11 |
||
In car parks |
indresp |
3, 5, 7, 9, 11 |
||
Outside, street/park |
indresp |
3, 5, 7, 9, 11 |
||
At home |
indresp |
3, 5, 7, 9, 11 |
||
Not, in last 12 months |
indresp |
3, 5, 7, 9, 11 |
||
Other places |
indresp |
3, 5, 7, 9, 11 |
||
extent of worry about crime |
indresp |
3, 6, bh07, bh12, bh17 |
Think this var is part of the pathway between the quality of the neighbourhood and mental health. If a person is very worried about crime and in a high crime area then it will likely affect mental health. |
|
worry about being affected by crime |
indresp |
3, 6, bh07, bh12, bh17 |
See above, in the same vein. |
|
Access To |
Services |
|||
able to access services when need to |
indresp |
3, 6 |
Bit crap that it only runs for 2 waves, might be able to find a better var for this. |
|
Suitability of area for raising children |
indresp |
bh08, bh13, bh18 |
||
Standard of local services: Schools |
indresp |
bh08, bh13, bh18 |
This and the following are much better variables related to services but still don’t run for very long. Could use them to create a summary variable that relates to the quality of services and access to them in the neighbourhood. This maybe wouldn’t be too useful in longitudinal models but could be interesting to see what relationship it has with mental health. OR on the other hand, we could investigate the relationship between all of these things individually and mental health and try to determine which if any are important. |
|
standard of local services: primary schools |
indresp |
3, 6 |
||
standard of local services: secondary schools |
indresp |
3, 6 |
||
standard of local services: medical |
indresp |
3, 6, bh08, bh13, bh18 |
||
standard of public transport |
indresp |
3, 6, bh08, bh13, bh18 |
||
standard of local services: shopping |
indresp |
3, 6, bh08, bh13, bh18 |
||
standard of local services: leisure |
indresp |
3, 6, bh08, bh13, bh18 |
||
financial reasons |
indresp |
3, 6 |
Text: What stops you from accessing services such as healthcare, food shops and learning facilities when you need to? |
Physical Well-Being
(e.g. do you have certain physical ailments? Does your physical well-being effect your ability to be social or work?)
Variable Name |
Description |
Source |
Waves |
Notes |
---|---|---|---|---|
Able to do X? |
indresp |
7, 9, 11 |
Many variables of this form. Not listing them here.. |
|
Ease of doing X? |
indresp |
7, 9, 11 |
See above |
|
Do you have disease X type Y? (e.g. cancer, arthritis) |
indresp |
9, 10, 11 |
Many variables for every having a disease as well as history and severity. E.g. have you had a heart attack ever/ between interviews. |
|
Do you require assistance from X/ todo X? |
indresp |
7, 9, 11 |
Does a person get help from medical/professionals/volunteers to do essential tasks such as getting groceries. |
|
Does your physical well-being affect X? |
indresp |
2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
SF1 survey values. Usually 5 tier likert scales. Vague/subjective questions but greater coverage. |
|
What is your Short form 12 (SF-12 ) physical component score? |
indresp |
1,2,3,4,5,6,7,8,9,10,11 |
Continuous variable. Normalised to N(50,10) but still right skewed. See: A 12-Item Short-Form Health Survey |
Mental Well-Being
(e.g. do you have certain mental ailments? Does your mental well-being effect your ability to be social or work?)
Variable |
Label |
Datafile |
Waves |
Notes |
---|---|---|---|---|
Do you have disease X type Y? (e.g. depression, anxiety.) |
indresp |
9, 10, 11 |
Many variables for every having a disease as well as history and severity. E.g. have you had panic attacks ever/ between interviews. |
|
Does your mental well-being affect X? |
indresp |
2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
SF1 survey values. Usually 5 tier likert scales. Vague/subjective questions but greater coverage. |
|
What is your Short form 12 (SF-12 ) mental component score? |
indresp |
1,2,3,4,5,6,7,8,9,10,11 |
Continuous variable. Normalised to N(50,10) but still right skewed. |
|
What is your Short Warwick Edinburgh Mental Well-Being Scale? |
indresp |
1, 4, 7, 10 |
Warwick Edinburgh mental wellbeing scale. 7-35 likert scale. Pseudo-continuous. |
|
Do you have trouble with X? |
indresp |
1,2,3,4,5,6,7,8,9,10,11 |
General Health Questions. Subjective 4 tier likert scales. Not reliable but provide a good relative measure of health between interviews. |