Bronze level automatically awarded GB final

This data has achieved Bronze level on 03 August 2015 which means this data makes a great start at the basics of publishing open data.

Social Housing Aggregated

Summary

Type of release
a one-off release of a single dataset

Licence
UK Open Government Licence

Verification
automatically awarded

Release Date
10 February 2015
Modified Date
10 February 2015
Publishers
Birmingham City Council
Keywords
Mid Year Estimates, ONS, birmingham, census, local, population
Maintainers
Contributors

Community verification

Other people can verify whether the answers on this certificate are correct.

This certificate is automatically awarded.

Sign in to verify or report this certificate

Description

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) 1. Average Rent per month (BASIC_RENT_VAL_avg) 1. Number of Properties (BASIC_RENT_VAL_count) 1. Max Rent (BASIC_RENT_VAL_max) 1. Min Rent (BASIC_RENT_VAL_min) 1. Sum of Rent (BASIC_RENT_VAL_tot) 1. Number of bedrooms not recorded (BEDROOMS_0) 1. Total of 1 Bedroom properties (BEDROOMS_1) 1. Total of 2 Bedroom properties (BEDROOMS_2) 1. Total of 3 Bedroom properties (BEDROOMS_3) 1. Total of 4 Bedroom properties (BEDROOMS_4) 1. Total of 5 Bedroom properties (BEDROOMS_5) 1. Total of 6 Bedroom properties (BEDROOMS_6) 1. Average number of bedrooms per area (BEDROOMS_avg) 1. Count of properties with bedrooms (BEDROOMS_count) 1. Max number of bedrooms (BEDROOMS_max) 1. Min number of bedrooms (BEDROOMS_min) 1. Bedrooms info not collected (BEDROOMS_null) 1. Total bedrooms (BEDROOMS_tot) 1. Constructed - Airey (BUILDER_AIREY) 1. Constructed - Bimingham Low Rise (BUILDER_BHAM_LRISE) 1. Constructed - BISF (BUILDER_BISF) 1. Constructed - Bison (BUILDER_BISON) 1. Constructed - Bryant (BUILDER_BRYANT) 1. Constructed - Bryant LR (BUILDER_BRYANT_LR) 1. Constructed - Con Block (BUILDER_CON_BLOCK) 1. Constructed - Cornish (BUILDER_CORNISH) 1. Constructed - Dorlonco (BUILDER_DORLONCO) 1. Constructed - Frame Grid (BUILDER_FRAM_GRD) 1. Constructed - Frame Form (BUILDER_FRAME_FORM) 1. Constructed - HDC (BUILDER_HDC) 1. Constructed - HSD (BUILDER_HSD) 1. Constructed - ISEC (BUILDER_ISEC) 1. Constructed - LAING (BUILDER_LAING_EASI) 1. Constructed - Metratrim (BUILDER_METRATRIM) 1. Constructed - Modulow (BUILDER_MODULOW) 1. Constructed - Mowlem (BUILDER_MOWLEM) 1. Constructed - No Fines (BUILDER_NO_FINES) 1. Constructed - Not recorded (BUILDER_null) 1. Constructed - Orlit (BUILDER_ORLIT) 1. Constructed - Permanent (BUILDER_PERMANENT) 1. Constructed - Phoenix (BUILDER_PHOENIX) 1. Constructed - Phorium (BUILDER_PHORIUM) 1. Constructed - Purpose (BUILDER_PURPOSE) 1. Constructed - Quickbuild (BUILDER_QUICKBUILD) 1. Constructed - Rational (BUILDER_RATIONAL) 1. Constructed - Rigidframe (BUILDER_RIGIDFRAME) 1. Constructed - Rigidsteel (BUILDER_RIGIDSTEEL) 1. Constructed - Rileyform (BUILDER_RILEYFORM) 1. Constructed - Smiths (BUILDER_SMITHS) 1. Constructed - Spooner (BUILDER_SPOONER) 1. Constructed - Wates (BUILDER_WATES) 1. Count of Properties with Cavity Insulation (CAVITY_INS_count) 1. Count of properties without Cavity Insulation data recorded (CAVITY_INS_null) 1. Count of properties with construction data recorded (CONSTRUCTION_DATE_count) 1. Count of properties with no construction date recorded (CONSTRUCTION_DATE_null) 1. Count of Council Tax Band A (CTBAND_VAL_A) 1. Count of Council Tax Band B (CTBAND_VAL_B) 1. Count of Council Tax Band C (CTBAND_VAL_C) 1. Count of Council Tax Band D (CTBAND_VAL_D) 1. Count of Council Tax Band E (CTBAND_VAL_E) 1. Count of Council Tax Band F (CTBAND_VAL_F) 1. Count of Council Tax Band G (CTBAND_VAL_G) 1. Count of Council Tax Band data not recorded (CTBAND_VAL_null) 1. Count of properties with data taken under management recorded (DATE_UNDER_MANAGEMENT_count) 1. Number of Residences on 10th Floor (FLOOR_10TH) 1. Number of Residences on 11th Floor (FLOOR_11TH) 1. Number of Residences on 12th Floor (FLOOR_12TH) 1. Number of Residences on 13th Floor (FLOOR_13TH) 1. Number of Residences on 14th Floor (FLOOR_14TH) 1. Number of Residences on 15th Floor (FLOOR_15TH) 1. Number of Residences on 16th Floor (FLOOR_16TH) 1. Number of Residences on 17th Floor (FLOOR_17TH) 1. Number of Residences on 18th Floor (FLOOR_18TH) 1. Number of Residences on 19th Floor (FLOOR_19TH) 1. Number of Residences on 1st Floor (FLOOR_1ST) 1. Number of Residences on 2nd Floor (FLOOR_2ND) 1. Number of Residences on 3rd Floor (FLOOR_3RD) 1. Number of Residences on 4th Floor (FLOOR_4TH) 1. Number of Residences on 5th Floor (FLOOR_5TH) 1. Number of Residences on 6th Floor (FLOOR_6TH) 1. Number of Residences on 7th Floor (FLOOR_7TH) 1. Number of Residences on 8th Floor (FLOOR_8TH) 1. Number of Residences on 9th Floor (FLOOR_9TH) 1. Number of Residences on Ground Floor (FLOOR_GROUND) 1. Number of Residences on Floor - not recorded (FLOOR_NULL) 1. Heating No. of residencies with - CHP (HEATING_CHP) 1. Heating No. of residencies with - Electricity (HEATING_ELECTRICITY) 1. Heating No. of residencies with - Gasl (HEATING_GAS) 1. Heating No. of residencies with - No data recorded (HEATING_null) 1. Heating No. of residencies with - Other Heating (HEATING_OTHER) 1. Number of properties with Loft Insulation (LOFT_INS_count) 1. Number of properties with no loft insulation data recorded (LOFT_INS_null) 1. aggregated reference - ignore (PROP_REF_avg) 1. aggregated count of references - ignore (PROP_REF_count) 1. max property reference number - ignore (PROP_REF_max) 1. min property reference number - ignore (PROP_REF_min) 1. total of the property reference numbers - ignore (PROP_REF_tot) 1. Number of detached bungalows (PROP_TYPE_Bungalow (Detached)) 1. Number of bungalow properties with dormer (PROP_TYPE_Bungalow (Dormer Bungalow)) 1. Number of bungalow properties end terrace (PROP_TYPE_Bungalow (End Terrace)) 1. Number of bungalow properties inner terrace (PROP_TYPE_Bungalow (Inner Terrace)) 1. Number of properties bungalow semi detached (PROP_TYPE_Bungalow (Semi-Detached)) 1. Number of bungalow properties single (PROP_TYPE_Bungalow (Single Bungalow)) 1. Number of bungalow properties not known type (PROP_TYPE_Bungalow (Unknown Sub-Type)) 1. Number of flats high rise (PROP_TYPE_Flat (High Rise)) 1. Number of flats form converted house (PROP_TYPE_Flat (In Converted House)) 1. Number of low rise flats (PROP_TYPE_Flat (Low Rise)) 1. Number of flats medium rise (PROP_TYPE_Flat (Medium Rise)) 1. Number of flats over garage (PROP_TYPE_Flat (Over Garage)) 1. Number of flats over shop (PROP_TYPE_Flat (Over Shop)) 1. Number of hostels (PROP_TYPE_Hostel (BCC Hostel)) 1. Number of detached houses (PROP_TYPE_House (Detached)) 1. Number of end terrace houses (PROP_TYPE_House (End Terrace)) 1. Number of inner terrace houses (PROP_TYPE_House (Inner Terrace)) 1. Number of semi-detached houses (PROP_TYPE_House (Semi-Detached)) 1. Number of houses of unknown description (PROP_TYPE_House (Unknown Sub-Type)) 1. Number of properties in conversion (PROP_TYPE_Interim Prop - Conversion in Progress (Semi-Detached)) 1. Number of maisonettes from a converted house (PROP_TYPE_Maisonette (In Converted House)) 1. Number of low rise maisonettes (PROP_TYPE_Maisonette (Low Rise)) 1. Number of medium rise maisonettes (PROP_TYPE_Maisonette (Medium Rise)) 1. Number of maisonettes over a garage (PROP_TYPE_Maisonette (Over Garage)) 1. Number of maisonettes over a shop (PROP_TYPE_Maisonette (Over Shop)) 1. Number of properties with type not recorded (PROP_TYPE_null) 1. Number of pre-fabricated house (PROP_TYPE_Prefab (Detached)) 1. Number of properties with smoke alarms (SMOKE_ALARM_count) 1. Number of properties with no smoke alarm data recorded (SMOKE_ALARM_null)

General Information

Legal Information

  • This data is available under

    UK Open Government Licence Do you think this data is incorrect? Let us know

  • The content is available under

    UK Open Government Licence Do you think this data is incorrect? Let us know

  • This data was

    originally created or generated by its curator Do you think this data is incorrect? Let us know

  • This data contains

    no data about individuals Do you think this data is incorrect? Let us know

  • There are

    yes, and the rights are all held by the same person or organisation Do you think this data is incorrect? Let us know

Technical Information

Social Information

  • The documentation includes machine-readable data for

    title Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    description Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    publisher Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    keyword(s) or tag(s) Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    distribution(s) Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    release date Do you think this data is incorrect? Let us know

  • The documentation includes machine-readable data for

    modification date Do you think this data is incorrect? Let us know

Create a certificate

Don't have an account?

Don't worry, you can register later to save your work.

Create an account