ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Housing Investigation
2
A database looking at the affordability of two-bed homes per Broad Rental Market Area in Great Britain
3
LINK TO REPORTING RECIPE
4
5
Data tables
6
Broad rental market area lookup
A lookup sheet to help find the Broad Rental Market area that matches your local authority
7
Affordability analysis - April 2019 LHA
An analysis of the properties collected in September 2019 against the LHA at the time
8
Affordability analysis - April 2020 LHA
An analysis of the properties collected in September 2019 against the increased LHA announced by the government in January 2020 and taking place in April 2020
9
Affordable properties - September 2019 snapshot
A full list of all the affordable properties we collected on 15 September 2020
10
11
Broad rental market area lookup - Data fields
12
Local authority
The name of the local authority
13
Intersecting Broad Rental Market Area(s)
The % each Broad Rental Market Area intersects with the local authority
14
15
Affordability analysis - Data fields
16
Broad Rental Market Area
The name of the the Broad Rental Market Area (BRMA)
17
Two-bed listings
The number of two-bed listings in the BRMA
18
Affordable two-bed listings
The number of affordable two-bed listings in the BRMA
19
Affordable two-bed listings (%)
The percentage of affordable two-bed listings - for BRMAs with at least 100 two-bed listings
20
April 2019 LHA
The Local Housing Allowance rate per week for that BRMA for the year starting April 2019
21
April 2020 LHA
The Local Housing Allowance rate per week for that BRMA for the year starting April 2020
22
30th percentile rent
The rent necessary to afford the bottom 30% of the properties in this sample
23
LHA/week increase required for 30% affordability
The amount by which the weekly allowance would need to increased by for 30% to become affordable two-bed listings in the BRMA
24
LHA/month increase required for 30% affordability
The amount by which the monthly allowance would need to be increased by for 30% to become affordable two-bed listings in the BRMA
25
26
Affordable properties - Data fields
27
Listed date
The date the property appeared on Nestoria
28
Title
The title given to the property on Nestoria - this is typically the address of the property
29
Property summary
The first 150 words of the property description
30
Postcode district
The postcode used to find the property when we searched Nestoria - the property might be in a neighbouring postcode
31
Broad Rental Market Area
The Broad Rental Market Area where the property is located
32
Latitute
The latitude where the property is located
33
Longitude
The longitude where the property is located
34
Weekly rent
The weekly rent to pay for the property (if the rent was given as a weekly figure by Nestoria)
35
Monthly rent
The monthly rent to pay for the property (if the rent was listed as a monthly figure by Nestoria)
36
April 2019 LHA Affordable
Would the property be affordable at the LHA rate for the year starting April 2019
37
April 2020 LHA affordable
Would the property be affordable at the LHA rate for the year starting April 2020 - as calculated by TBIJ after the government's announcement
38
Link
A link to the webpage where the property is listed
39
Image URL
A link to an image of the property
40
Listing Source
The website where Nestoria found this property
41
Scraped Date
The date and time of when we found the property on Nestoria
42
43
Note about this data: This consists of a day’s “snapshot” of all available two-bedroom properties for rent in the UK advertised by Nestoria (a property search engine that pulls in property ads from multiple sites). The government set the Local Housing Allowance in 2016 and this was to allow for recipients to afford the cheapest 30% of all properties in the rental market. However, when we looked at the cheapest 30th percentile of two-bed properties available for rent (on this one-day search of Britain), we found that for the majority of areas, the LHA would not be sufficient. We captured 62,695 two-bed properties advertised on 15/09/2019. The dataset contains the details of the 3,492 properties that would be affordable on housing benefit.
44
45
If you want to get in touch about this data email bureaulocal@tbij.com
46
This dataset was put together by the Bureau Local. Please credit the Bureau of Investigative Journalism when reporting on it.
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100