Social Housing Aggregated

Birmingham City Council owned and managed social housing aggregated to Lower Super Output Areas ( http://en.wikipedia.org/wiki/ONS_coding_system ) to release more information that is captured in the Housing IT system.

The aggregation of data is an automatic process that is intended to be used on many datasets. Therefore some of the data in this file results in a lot of columns in the CSV often counting by data attribute types.

The whole of the data per property is aggregated to a Lower Super Output Area. Date fields are counted, number fields are totaled, averaged and have a minimum and maximum number. All textual fields are counted based on the number of attribute types.

This file covers:

  • rents
  • insulation
  • smoke alarms
  • heating types
  • property types
  • construction types
  • number of floors
  • council tax bands
  • number of bedrooms

The full list of columns in the file are as follows:

  1. Lower Super Output Area (KeyField)
  2. Average Rent per month (BASIC_RENT_VAL_avg)
  3. Number of Properties (BASIC_RENT_VAL_count)
  4. Max Rent (BASIC_RENT_VAL_max)
  5. Min Rent (BASIC_RENT_VAL_min)
  6. Sum of Rent (BASIC_RENT_VAL_tot)
  7. Number of bedrooms not recorded (BEDROOMS_0)
  8. Total of 1 Bedroom properties (BEDROOMS_1)
  9. Total of 2 Bedroom properties (BEDROOMS_2)
  10. Total of 3 Bedroom properties (BEDROOMS_3)
  11. Total of 4 Bedroom properties (BEDROOMS_4)
  12. Total of 5 Bedroom properties (BEDROOMS_5)
  13. Total of 6 Bedroom properties (BEDROOMS_6)
  14. Average number of bedrooms per area (BEDROOMS_avg)
  15. Count of properties with bedrooms (BEDROOMS_count)
  16. Max number of bedrooms (BEDROOMS_max)
  17. Min number of bedrooms (BEDROOMS_min)
  18. Bedrooms info not collected (BEDROOMS_null)
  19. Total bedrooms (BEDROOMS_tot)
  20. Constructed - Airey (BUILDER_AIREY)
  21. Constructed - Bimingham Low Rise (BUILDER_BHAM_LRISE)
  22. Constructed - BISF (BUILDER_BISF)
  23. Constructed - Bison (BUILDER_BISON)
  24. Constructed - Bryant (BUILDER_BRYANT)
  25. Constructed - Bryant LR (BUILDER_BRYANT_LR)
  26. Constructed - Con Block (BUILDER_CON_BLOCK)
  27. Constructed - Cornish (BUILDER_CORNISH)
  28. Constructed - Dorlonco (BUILDER_DORLONCO)
  29. Constructed - Frame Grid (BUILDER_FRAM_GRD)
  30. Constructed - Frame Form (BUILDER_FRAME_FORM)
  31. Constructed - HDC (BUILDER_HDC)
  32. Constructed - HSD (BUILDER_HSD)
  33. Constructed - ISEC (BUILDER_ISEC)
  34. Constructed - LAING (BUILDER_LAING_EASI)
  35. Constructed - Metratrim (BUILDER_METRATRIM)
  36. Constructed - Modulow (BUILDER_MODULOW)
  37. Constructed - Mowlem (BUILDER_MOWLEM)
  38. Constructed - No Fines (BUILDER_NO_FINES)
  39. Constructed - Not recorded (BUILDER_null)
  40. Constructed - Orlit (BUILDER_ORLIT)
  41. Constructed - Permanent (BUILDER_PERMANENT)
  42. Constructed - Phoenix (BUILDER_PHOENIX)
  43. Constructed - Phorium (BUILDER_PHORIUM)
  44. Constructed - Purpose (BUILDER_PURPOSE)
  45. Constructed - Quickbuild (BUILDER_QUICKBUILD)
  46. Constructed - Rational (BUILDER_RATIONAL)
  47. Constructed - Rigidframe (BUILDER_RIGIDFRAME)
  48. Constructed - Rigidsteel (BUILDER_RIGIDSTEEL)
  49. Constructed - Rileyform (BUILDER_RILEYFORM)
  50. Constructed - Smiths (BUILDER_SMITHS)
  51. Constructed - Spooner (BUILDER_SPOONER)
  52. Constructed - Wates (BUILDER_WATES)
  53. Count of Properties with Cavity Insulation (CAVITY_INS_count)
  54. Count of properties without Cavity Insulation data recorded (CAVITY_INS_null)
  55. Count of properties with construction data recorded (CONSTRUCTION_DATE_count)
  56. Count of properties with no construction date recorded (CONSTRUCTION_DATE_null)
  57. Count of Council Tax Band A (CTBAND_VAL_A)
  58. Count of Council Tax Band B (CTBAND_VAL_B)
  59. Count of Council Tax Band C (CTBAND_VAL_C)
  60. Count of Council Tax Band D (CTBAND_VAL_D)
  61. Count of Council Tax Band E (CTBAND_VAL_E)
  62. Count of Council Tax Band F (CTBAND_VAL_F)
  63. Count of Council Tax Band G (CTBAND_VAL_G)
  64. Count of Council Tax Band data not recorded (CTBAND_VAL_null)
  65. Count of properties with data taken under management recorded (DATE_UNDER_MANAGEMENT_count)
  66. Number of Residences on 10th Floor (FLOOR_10TH)
  67. Number of Residences on 11th Floor (FLOOR_11TH)
  68. Number of Residences on 12th Floor (FLOOR_12TH)
  69. Number of Residences on 13th Floor (FLOOR_13TH)
  70. Number of Residences on 14th Floor (FLOOR_14TH)
  71. Number of Residences on 15th Floor (FLOOR_15TH)
  72. Number of Residences on 16th Floor (FLOOR_16TH)
  73. Number of Residences on 17th Floor (FLOOR_17TH)
  74. Number of Residences on 18th Floor (FLOOR_18TH)
  75. Number of Residences on 19th Floor (FLOOR_19TH)
  76. Number of Residences on 1st Floor (FLOOR_1ST)
  77. Number of Residences on 2nd Floor (FLOOR_2ND)
  78. Number of Residences on 3rd Floor (FLOOR_3RD)
  79. Number of Residences on 4th Floor (FLOOR_4TH)
  80. Number of Residences on 5th Floor (FLOOR_5TH)
  81. Number of Residences on 6th Floor (FLOOR_6TH)
  82. Number of Residences on 7th Floor (FLOOR_7TH)
  83. Number of Residences on 8th Floor (FLOOR_8TH)
  84. Number of Residences on 9th Floor (FLOOR_9TH)
  85. Number of Residences on Ground Floor (FLOOR_GROUND)
  86. Number of Residences on Floor - not recorded (FLOOR_NULL)
  87. Heating No. of residencies with - CHP (HEATING_CHP)
  88. Heating No. of residencies with - Electricity (HEATING_ELECTRICITY)
  89. Heating No. of residencies with - Gasl (HEATING_GAS)
  90. Heating No. of residencies with - No data recorded (HEATING_null)
  91. Heating No. of residencies with - Other Heating (HEATING_OTHER)
  92. Number of properties with Loft Insulation (LOFT_INS_count)
  93. Number of properties with no loft insulation data recorded (LOFT_INS_null)
  94. aggregated reference - ignore (PROP_REF_avg)
  95. aggregated count of references - ignore (PROP_REF_count)
  96. max property reference number - ignore (PROP_REF_max)
  97. min property reference number - ignore (PROP_REF_min)
  98. total of the property reference numbers - ignore (PROP_REF_tot)
  99. Number of detached bungalows (PROP_TYPE_Bungalow (Detached))
  100. Number of bungalow properties with dormer (PROP_TYPE_Bungalow (Dormer Bungalow))
  101. Number of bungalow properties end terrace (PROP_TYPE_Bungalow (End Terrace))
  102. Number of bungalow properties inner terrace (PROP_TYPE_Bungalow (Inner Terrace))
  103. Number of properties bungalow semi detached (PROP_TYPE_Bungalow (Semi-Detached))
  104. Number of bungalow properties single (PROP_TYPE_Bungalow (Single Bungalow))
  105. Number of bungalow properties not known type (PROP_TYPE_Bungalow (Unknown Sub-Type))
  106. Number of flats high rise (PROP_TYPE_Flat (High Rise))
  107. Number of flats form converted house (PROP_TYPE_Flat (In Converted House))
  108. Number of low rise flats (PROP_TYPE_Flat (Low Rise))
  109. Number of flats medium rise (PROP_TYPE_Flat (Medium Rise))
  110. Number of flats over garage (PROP_TYPE_Flat (Over Garage))
  111. Number of flats over shop (PROP_TYPE_Flat (Over Shop))
  112. Number of hostels (PROP_TYPE_Hostel (BCC Hostel))
  113. Number of detached houses (PROP_TYPE_House (Detached))
  114. Number of end terrace houses (PROP_TYPE_House (End Terrace))
  115. Number of inner terrace houses (PROP_TYPE_House (Inner Terrace))
  116. Number of semi-detached houses (PROP_TYPE_House (Semi-Detached))
  117. Number of houses of unknown description (PROP_TYPE_House (Unknown Sub-Type))
  118. Number of properties in conversion (PROP_TYPE_Interim Prop - Conversion in Progress (Semi-Detached))
  119. Number of maisonettes from a converted house (PROP_TYPE_Maisonette (In Converted House))
  120. Number of low rise maisonettes (PROP_TYPE_Maisonette (Low Rise))
  121. Number of medium rise maisonettes (PROP_TYPE_Maisonette (Medium Rise))
  122. Number of maisonettes over a garage (PROP_TYPE_Maisonette (Over Garage))
  123. Number of maisonettes over a shop (PROP_TYPE_Maisonette (Over Shop))
  124. Number of properties with type not recorded (PROP_TYPE_null)
  125. Number of pre-fabricated house (PROP_TYPE_Prefab (Detached))
  126. Number of properties with smoke alarms (SMOKE_ALARM_count)
  127. Number of properties with no smoke alarm data recorded (SMOKE_ALARM_null)

Data and Resources

Additional Info

Field Value
Source BCC Housing system
Author Matthew Cloke
Maintainer Automated - Annually
Version 1.0
Last Updated June 10, 2015, 22:13 (UTC)
Created May 17, 2015, 16:30 (UTC)