Ego’s relationship to alter (i.e., _PNO’s relationship to _APNO). A copy of the variable RELATIONSHIP except it replaces a number of coding errors. Households with one of the following (potential) relationship inconsistencies have been inspected and the relationship codes of all household members to each other have been amended as appropriate (also if the inconsistency did not relate to the originally identified inconsistency): HH including a respondent with too many natural parent, HH including child that is partner of somebody, HH including child that is parent of somebody, HH including child that is older than parent, HH including person who is partner to >1 person, HH including child that is older than grandparent, HH including niece/nephew that is older than aunt/uncle, HH including any pair of siblings >20 years apart in age, and HH including a pair of minors who are each other’s brother/sister in law. Some cross-wave inconsistencies have also been corrected. Note that given the complex relationships there are no rules that generally apply to fix such coding errors. There are a considerable number of relationships which continue to be inconsistent over time, or are highly implausible even in the current wave. The majority of these relate to sibling and parent status. For example, there are a large number of children who are biological siblings in one wave, then become half-, step- or adopted siblings later on. Code to identify the errors is available upon request. In the course of harmonisation with the BHPS, with effect of the 2019 data release, we have additionally checked for cases where minors were coded as son/daughter in law. This was a common error in the BHPS relationship grid.
Ego's relationship to alter (i.e., _PNO's relationship to _APNO). A copy of the variable RELATIONSHIP except it replaces a number of coding errors. Households with one of the following (potential) relationship inconsistencies have been inspected and the relationship codes of all household members to each other have been amended as appropriate (also if the inconsistency did not relate to the originally identified inconsistency): HH including a respondent with too many natural parent, HH including child that is partner of somebody, HH including child that is parent of somebody, HH including child that is older than parent, HH including person who is partner to >1 person, HH including child that is older than grandparent, HH including niece/nephew that is older than aunt/uncle, HH including any pair of siblings >20 years apart in age, and HH including a pair of minors who are each other's brother/sister in law. Some cross-wave inconsistencies have also been corrected. Note that given the complex relationships there are no rules that generally apply to fix such coding errors. There are a considerable number of relationships which continue to be inconsistent over time, or are highly implausible even in the current wave. The majority of these relate to sibling and parent status. For example, there are a large number of children who are biological siblings in one wave, then become half-, step- or adopted siblings later on. Code to identify the errors is available upon request. In the course of harmonisation with the BHPS, with effect of the 2019 data release, we have additionally checked for cases where minors were coded as son/daughter in law. This was a common error in the BHPS relationship grid.
Derived variable note:
Uses RELATIONSHIP PNO APNO HIDP Uses AGE_DV SEX on data file INDALL/
Value label
Value
Absolute frequency
Relative frequency
missing
-9
464
0.44%
husband/wife
1
19892
18.95%
partner/cohabitee
2
4714
4.49%
civil partner
3
210
0.2%
natural son/daughter
4
25732
24.51%
adopted son/daughter
5
224
0.21%
foster child
6
68
0.06%
stepson/stepdaughter
7
916
0.87%
son-in-law/daughter-in-law
8
409
0.39%
natural parent
9
25730
24.51%
adoptive parent
10
224
0.21%
foster parent
11
68
0.06%
step-parent
12
916
0.87%
parent-in-law
13
409
0.39%
natural brother/sister
14
17464
16.64%
half-brother/sister
15
1476
1.41%
step-brother/sister
16
236
0.22%
adopted brother/sister
17
82
0.08%
foster brother/sister
18
54
0.05%
brother/sister-in-law
19
332
0.32%
grand-child
20
1077
1.03%
grand-parent
21
1077
1.03%
cousin
22
164
0.16%
aunt/uncle
23
444
0.42%
niece/nephew
24
444
0.42%
other relative
25
216
0.21%
employee
26
1
0.0%
employer
27
1
0.0%
lodger/boarder/tenant
28
104
0.1%
landlord/landlady
29
104
0.1%
other non-relative
30
1680
1.6%
legal child
32
19
0.02%
legal parent
33
19
0.02%
Total
104970
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
1026
0.87%
husband/wife
1
22138
18.84%
partner/cohabitee
2
5320
4.53%
civil partner
3
256
0.22%
natural son/daughter
4
28686
24.41%
adopted son/daughter
5
281
0.24%
foster child
6
83
0.07%
stepson/stepdaughter
7
1018
0.87%
son-in-law/daughter-in-law
8
402
0.34%
natural parent
9
28686
24.41%
adoptive parent
10
281
0.24%
foster parent
11
83
0.07%
step-parent
12
1018
0.87%
parent-in-law
13
402
0.34%
natural brother/sister
14
19407
16.52%
half-brother/sister
15
1775
1.51%
step-brother/sister
16
206
0.18%
adopted brother/sister
17
82
0.07%
foster brother/sister
18
70
0.06%
brother/sister-in-law
19
348
0.3%
grand-child
20
1078
0.92%
grand-parent
21
1078
0.92%
cousin
22
194
0.17%
aunt/uncle
23
495
0.42%
niece/nephew
24
495
0.42%
other relative
25
318
0.27%
employee
26
1
0.0%
employer
27
1
0.0%
lodger/boarder/tenant
28
146
0.12%
landlord/landlady
29
146
0.12%
other non-relative
30
1988
1.69%
Total
117508
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
390
0.42%
husband/wife
1
17104
18.56%
partner/cohabitee
2
3780
4.1%
civil partner
3
186
0.2%
natural son/daughter
4
22609
24.53%
adopted son/daughter
5
201
0.22%
foster child
6
77
0.08%
stepson/stepdaughter
7
824
0.89%
son-in-law/daughter-in-law
8
365
0.4%
natural parent
9
22609
24.53%
adoptive parent
10
201
0.22%
foster parent
11
77
0.08%
step-parent
12
828
0.9%
parent-in-law
13
365
0.4%
natural brother/sister
14
15801
17.15%
half-brother/sister
15
1360
1.48%
step-brother/sister
16
202
0.22%
adopted brother/sister
17
72
0.08%
foster brother/sister
18
52
0.06%
brother/sister-in-law
19
346
0.38%
grand-child
20
941
1.02%
grand-parent
21
941
1.02%
cousin
22
182
0.2%
aunt/uncle
23
466
0.51%
niece/nephew
24
468
0.51%
other relative
25
251
0.27%
employee
26
1
0.0%
employer
27
1
0.0%
lodger/boarder/tenant
28
101
0.11%
landlord/landlady
29
101
0.11%
other non-relative
30
1248
1.35%
Total
92150
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
1148
1.18%
husband/wife
1
17987
18.41%
partner/cohabitee
2
3730
3.82%
civil partner
3
194
0.2%
natural son/daughter
4
23681
24.24%
adopted son/daughter
5
233
0.24%
foster child
6
82
0.08%
stepson/stepdaughter
7
867
0.89%
son-in-law/daughter-in-law
8
366
0.37%
natural parent
9
23691
24.25%
adoptive parent
10
233
0.24%
foster parent
11
80
0.08%
step-parent
12
866
0.89%
parent-in-law
13
366
0.37%
natural brother/sister
14
16666
17.06%
half-brother/sister
15
1469
1.5%
step-brother/sister
16
234
0.24%
adopted brother/sister
17
82
0.08%
foster brother/sister
18
94
0.1%
brother/sister-in-law
19
354
0.36%
grand-child
20
963
0.99%
grand-parent
21
963
0.99%
cousin
22
220
0.23%
aunt/uncle
23
507
0.52%
niece/nephew
24
509
0.52%
other relative
25
330
0.34%
employee
26
1
0.0%
employer
27
1
0.0%
lodger/boarder/tenant
28
129
0.13%
landlord/landlady
29
129
0.13%
other non-relative
30
1513
1.55%
Total
97688
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
160
0.15%
husband/wife
1
18882
17.6%
partner/cohabitee
2
4440
4.14%
civil partner
3
118
0.11%
natural son/daughter
4
26336
24.55%
adopted son/daughter
5
225
0.21%
foster child
6
70
0.07%
stepson/stepdaughter
7
889
0.83%
son-in-law/daughter-in-law
8
416
0.39%
natural parent
9
26336
24.55%
adoptive parent
10
225
0.21%
foster parent
11
70
0.07%
step-parent
12
889
0.83%
parent-in-law
13
416
0.39%
natural brother/sister
14
19528
18.2%
half-brother/sister
15
1595
1.49%
step-brother/sister
16
283
0.26%
adopted brother/sister
17
108
0.1%
foster brother/sister
18
50
0.05%
brother/sister-in-law
19
434
0.4%
grand-child
20
1097
1.02%
grand-parent
21
1097
1.02%
cousin
22
258
0.24%
aunt/uncle
23
581
0.54%
niece/nephew
24
581
0.54%
other relative
25
164
0.15%
employee
26
2
0.0%
employer
27
2
0.0%
lodger/boarder/tenant
28
111
0.1%
landlord/landlady
29
111
0.1%
other non-relative
30
1804
1.68%
Total
107278
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
160
0.14%
husband/wife
1
19930
17.2%
partner/cohabitee
2
4632
4.0%
civil partner
3
116
0.1%
natural son/daughter
4
28451
24.55%
adopted son/daughter
5
246
0.21%
foster child
6
70
0.06%
stepson/stepdaughter
7
999
0.86%
son-in-law/daughter-in-law
8
453
0.39%
natural parent
9
28451
24.55%
adoptive parent
10
246
0.21%
foster parent
11
70
0.06%
step-parent
12
998
0.86%
parent-in-law
13
453
0.39%
natural brother/sister
14
21433
18.49%
half-brother/sister
15
1760
1.52%
step-brother/sister
16
314
0.27%
adopted brother/sister
17
96
0.08%
foster brother/sister
18
46
0.04%
brother/sister-in-law
19
538
0.46%
grand-child
20
1191
1.03%
grand-parent
21
1191
1.03%
cousin
22
306
0.26%
aunt/uncle
23
654
0.56%
niece/nephew
24
654
0.56%
other relative
25
188
0.16%
employee
26
9
0.01%
employer
27
9
0.01%
lodger/boarder/tenant
28
139
0.12%
landlord/landlady
29
139
0.12%
other non-relative
30
1946
1.68%
Total
115888
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
32
0.03%
husband/wife
1
20818
16.98%
partner/cohabitee
2
4804
3.92%
civil partner
3
98
0.08%
natural son/daughter
4
30162
24.6%
adopted son/daughter
5
260
0.21%
foster child
6
77
0.06%
stepson/stepdaughter
7
1066
0.87%
son-in-law/daughter-in-law
8
488
0.4%
natural parent
9
30162
24.6%
adoptive parent
10
260
0.21%
foster parent
11
77
0.06%
step-parent
12
1066
0.87%
parent-in-law
13
488
0.4%
natural brother/sister
14
22778
18.58%
half-brother/sister
15
2088
1.7%
step-brother/sister
16
348
0.28%
adopted brother/sister
17
106
0.09%
foster brother/sister
18
48
0.04%
brother/sister-in-law
19
598
0.49%
grand-child
20
1239
1.01%
grand-parent
21
1239
1.01%
cousin
22
320
0.26%
aunt/uncle
23
671
0.55%
niece/nephew
24
671
0.55%
other relative
25
182
0.15%
employee
26
3
0.0%
employer
27
3
0.0%
lodger/boarder/tenant
28
145
0.12%
landlord/landlady
29
145
0.12%
other non-relative
30
2182
1.78%
Total
122624
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
52
0.04%
husband/wife
1
22270
16.77%
partner/cohabitee
2
5160
3.88%
civil partner
3
106
0.08%
natural son/daughter
4
32623
24.56%
adopted son/daughter
5
255
0.19%
foster child
6
91
0.07%
stepson/stepdaughter
7
1194
0.9%
son-in-law/daughter-in-law
8
513
0.39%
natural parent
9
32623
24.56%
adoptive parent
10
255
0.19%
foster parent
11
91
0.07%
step-parent
12
1194
0.9%
parent-in-law
13
513
0.39%
natural brother/sister
14
25018
18.84%
half-brother/sister
15
2158
1.62%
step-brother/sister
16
424
0.32%
adopted brother/sister
17
112
0.08%
foster brother/sister
18
46
0.03%
brother/sister-in-law
19
684
0.51%
grand-child
20
1266
0.95%
grand-parent
21
1266
0.95%
cousin
22
350
0.26%
aunt/uncle
23
715
0.54%
niece/nephew
24
715
0.54%
other relative
25
178
0.13%
employee
26
6
0.0%
employer
27
6
0.0%
lodger/boarder/tenant
28
164
0.12%
landlord/landlady
29
164
0.12%
other non-relative
30
2612
1.97%
Total
132824
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
330
0.23%
husband/wife
1
23248
16.41%
partner/cohabitee
2
5428
3.83%
civil partner
3
118
0.08%
natural son/daughter
4
34652
24.45%
adopted son/daughter
5
235
0.17%
foster child
6
97
0.07%
stepson/stepdaughter
7
1264
0.89%
son-in-law/daughter-in-law
8
523
0.37%
natural parent
9
34652
24.45%
adoptive parent
10
235
0.17%
foster parent
11
97
0.07%
step-parent
12
1264
0.89%
parent-in-law
13
523
0.37%
natural brother/sister
14
26870
18.96%
half-brother/sister
15
2348
1.66%
step-brother/sister
16
452
0.32%
adopted brother/sister
17
80
0.06%
foster brother/sister
18
76
0.05%
brother/sister-in-law
19
744
0.53%
grand-child
20
1346
0.95%
grand-parent
21
1346
0.95%
cousin
22
346
0.24%
aunt/uncle
23
825
0.58%
niece/nephew
24
825
0.58%
other relative
25
224
0.16%
employee
26
3
0.0%
employer
27
3
0.0%
lodger/boarder/tenant
28
158
0.11%
landlord/landlady
29
158
0.11%
other non-relative
30
3232
2.28%
Total
141702
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
182
0.12%
husband/wife
1
24920
16.18%
partner/cohabitee
2
5756
3.74%
civil partner
3
144
0.09%
natural son/daughter
4
37305
24.22%
adopted son/daughter
5
250
0.16%
foster child
6
86
0.06%
stepson/stepdaughter
7
1338
0.87%
son-in-law/daughter-in-law
8
617
0.4%
natural parent
9
37305
24.22%
adoptive parent
10
250
0.16%
foster parent
11
86
0.06%
step-parent
12
1338
0.87%
parent-in-law
13
617
0.4%
natural brother/sister
14
29104
18.89%
half-brother/sister
15
2400
1.56%
step-brother/sister
16
460
0.3%
adopted brother/sister
17
100
0.06%
foster brother/sister
18
72
0.05%
brother/sister-in-law
19
922
0.6%
grand-child
20
1454
0.94%
grand-parent
21
1454
0.94%
cousin
22
492
0.32%
aunt/uncle
23
998
0.65%
niece/nephew
24
998
0.65%
other relative
25
318
0.21%
employee
26
5
0.0%
employer
27
5
0.0%
lodger/boarder/tenant
28
254
0.16%
landlord/landlady
29
254
0.16%
other non-relative
30
4564
2.96%
Total
154048
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
2
0.0%
husband/wife
1
24192
17.01%
partner/cohabitee
2
5580
3.92%
civil partner
3
126
0.09%
natural son/daughter
4
34941
24.57%
adopted son/daughter
5
260
0.18%
foster child
6
98
0.07%
stepson/stepdaughter
7
1399
0.98%
son-in-law/daughter-in-law
8
488
0.34%
natural parent
9
34941
24.57%
adoptive parent
10
260
0.18%
foster parent
11
98
0.07%
step-parent
12
1399
0.98%
parent-in-law
13
488
0.34%
natural brother/sister
14
25908
18.22%
half-brother/sister
15
2510
1.77%
step-brother/sister
16
450
0.32%
adopted brother/sister
17
90
0.06%
foster brother/sister
18
76
0.05%
brother/sister-in-law
19
562
0.4%
grand-child
20
1342
0.94%
grand-parent
21
1342
0.94%
cousin
22
298
0.21%
aunt/uncle
23
722
0.51%
niece/nephew
24
722
0.51%
other relative
25
272
0.19%
employee
26
1
0.0%
employer
27
1
0.0%
lodger/boarder/tenant
28
190
0.13%
landlord/landlady
29
190
0.13%
other non-relative
30
3254
2.29%
Total
142202
100.0%
Value label
Value
Absolute frequency
Relative frequency
husband/wife
1
25740
16.86%
partner/cohabitee
2
5946
3.9%
civil partner
3
118
0.08%
natural son/daughter
4
37454
24.54%
adopted son/daughter
5
250
0.16%
foster child
6
121
0.08%
stepson/stepdaughter
7
1504
0.99%
son-in-law/daughter-in-law
8
532
0.35%
natural parent
9
37454
24.54%
adoptive parent
10
250
0.16%
foster parent
11
121
0.08%
step-parent
12
1504
0.99%
parent-in-law
13
532
0.35%
natural brother/sister
14
28028
18.36%
half-brother/sister
15
2592
1.7%
step-brother/sister
16
472
0.31%
adopted brother/sister
17
100
0.07%
foster brother/sister
18
140
0.09%
brother/sister-in-law
19
682
0.45%
grand-child
20
1382
0.91%
grand-parent
21
1382
0.91%
cousin
22
432
0.28%
aunt/uncle
23
858
0.56%
niece/nephew
24
858
0.56%
other relative
25
298
0.2%
employee
26
3
0.0%
employer
27
3
0.0%
lodger/boarder/tenant
28
216
0.14%
landlord/landlady
29
216
0.14%
other non-relative
30
3450
2.26%
Total
152638
100.0%
Value label
Value
Absolute frequency
Relative frequency
husband/wife
1
27932
16.98%
partner/cohabitee
2
6122
3.72%
civil partner
3
120
0.07%
natural son/daughter
4
40434
24.59%
adopted son/daughter
5
287
0.17%
foster child
6
114
0.07%
stepson/stepdaughter
7
1632
0.99%
son-in-law/daughter-in-law
8
563
0.34%
natural parent
9
40434
24.59%
adoptive parent
10
287
0.17%
foster parent
11
114
0.07%
step-parent
12
1632
0.99%
parent-in-law
13
563
0.34%
natural brother/sister
14
30634
18.63%
half-brother/sister
15
2448
1.49%
step-brother/sister
16
502
0.31%
adopted brother/sister
17
90
0.05%
foster brother/sister
18
124
0.08%
brother/sister-in-law
19
728
0.44%
grand-child
20
1466
0.89%
grand-parent
21
1466
0.89%
cousin
22
498
0.3%
aunt/uncle
23
898
0.55%
niece/nephew
24
898
0.55%
other relative
25
316
0.19%
employee
26
3
0.0%
employer
27
3
0.0%
lodger/boarder/tenant
28
194
0.12%
landlord/landlady
29
194
0.12%
other non-relative
30
3770
2.29%
Total
164466
100.0%
Value label
Value
Absolute frequency
Relative frequency
husband/wife
1
30476
17.03%
partner/cohabitee
2
6722
3.76%
civil partner
3
112
0.06%
natural son/daughter
4
43964
24.56%
adopted son/daughter
5
345
0.19%
foster child
6
128
0.07%
stepson/stepdaughter
7
1856
1.04%
son-in-law/daughter-in-law
8
548
0.31%
natural parent
9
43964
24.56%
adoptive parent
10
345
0.19%
foster parent
11
128
0.07%
step-parent
12
1856
1.04%
parent-in-law
13
548
0.31%
natural brother/sister
14
33522
18.73%
half-brother/sister
15
2568
1.43%
step-brother/sister
16
578
0.32%
adopted brother/sister
17
152
0.08%
foster brother/sister
18
164
0.09%
brother/sister-in-law
19
684
0.38%
grand-child
20
1464
0.82%
grand-parent
21
1464
0.82%
cousin
22
450
0.25%
aunt/uncle
23
906
0.51%
niece/nephew
24
906
0.51%
other relative
25
302
0.17%
employee
26
7
0.0%
employer
27
7
0.0%
lodger/boarder/tenant
28
260
0.15%
landlord/landlady
29
260
0.15%
other non-relative
30
4302
2.4%
Total
178988
100.0%
Value label
Value
Absolute frequency
Relative frequency
missing
-9
256
0.14%
husband/wife
1
29372
16.07%
partner/cohabitee
2
6568
3.59%
civil partner
3
92
0.05%
natural son/daughter
4
43871
24.0%
adopted son/daughter
5
315
0.17%
foster child
6
122
0.07%
stepson/stepdaughter
7
1844
1.01%
son-in-law/daughter-in-law
8
631
0.35%
natural parent
9
43871
24.0%
adoptive parent
10
315
0.17%
foster parent
11
122
0.07%
step-parent
12
1844
1.01%
parent-in-law
13
631
0.35%
natural brother/sister
14
35016
19.16%
half-brother/sister
15
2670
1.46%
step-brother/sister
16
676
0.37%
adopted brother/sister
17
172
0.09%
foster brother/sister
18
178
0.1%
brother/sister-in-law
19
1002
0.55%
grand-child
20
1547
0.85%
grand-parent
21
1547
0.85%
cousin
22
890
0.49%
aunt/uncle
23
1126
0.62%
niece/nephew
24
1126
0.62%
other relative
25
348
0.19%
employee
26
6
0.0%
employer
27
6
0.0%
lodger/boarder/tenant
28
239
0.13%
landlord/landlady
29
239
0.13%
other non-relative
30
6148
3.36%
Total
182790
100.0%
Code creator
0
Create your own Stata code to extract data from the main end user licence Understanding Society dataset. Find out more
Saved variables
Code creator
Create your own Stata code to extract data from the main end user licence Understanding Society dataset.
Save your variables
Click Build data file to generate your code.
The code will allow you to create your own data file containing just your variable selection, plus a handy set of commonly used sociodemographic variables and cross-sectional and longitudinal weight variables.
The Economic and Social Research Council is the primary funder of the study
The Study is led by a team at the Institute for Social and Economic Research (ISER) at the University of Essex.