FINANCIAL CAPABILITY AND CHILD POVERTY DATA Technical Details Data is provided at two different geographic levels - unit postcode and Lower Super Output Area (LSOA). The detailed unit postcode data is available to download individually for each London Borough or for the whole of Greater London in a single file. LSOA summary data is only available for the whole of London at present. All datasets are supplied in CSV format, although GIS versions may be made available in the future. Field Names The postcode data files all contain the following fields: * EXPERIAN_POSTCODE - original postcode supplied by Experian * EXPERIAN_GOR - Government Office Region supplied by Experian * EXPERIAN_LANAME - Local Authority name supplied by Experian * EXPERIAN_HH_COUNT - count of households in postcode supplied by Experian * EXPERIAN_GROUP - Generic Finance Advice Group (0 to 11) supplied by Experian * POSTCODE - cleaned postcode with standard spacing * EASTING - x coordinate for postcode centroid (derived from OS Code-Point data) * NORTHING - y coordinate for postcode centroid (derived from OS Code-Point data) * POSTCODE_SOURCE - version of CodePoint data from which coordinates are derived * LSOACODE - Code for Lower Super Output Area in which postcode centroid is located * WARDCODE - Code for ward in which postcode centroid is located (from 2008 OS Boundary Line) * WARDNAME - Name of ward in which postcode centroid is located (from 2008 OS Boundary Line) * LACODE - Code for local authority in which postcode centroid is located (from 2008 OS Boundary Line) * LANAME - Name of local authority in which postcode centroid is located (from 2008 OS Boundary Line) The LSOA summary data contains the following fields: * LSOACODE - Code for Lower Super Output Area * GFA_PT0_RECS - Number of postcode records in LSOA assigned to GFA Point 0 (least vulnerable) * GFA_PT0_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 0 * GFA_PT1_RECS - Number of postcode records in LSOA assigned to GFA Point 1 * GFA_PT1_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 1 * GFA_PT2_RECS - Number of postcode records in LSOA assigned to GFA Point 2 * GFA_PT2_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 2 * GFA_PT3_RECS - Number of postcode records in LSOA assigned to GFA Point 3 * GFA_PT3_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 3 * GFA_PT4_RECS - Number of postcode records in LSOA assigned to GFA Point 4 * GFA_PT4_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 4 * GFA_PT5_RECS - Number of postcode records in LSOA assigned to GFA Point 5 * GFA_PT5_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 5 * GFA_PT6_RECS - Number of postcode records in LSOA assigned to GFA Point 6 * GFA_PT6_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 6 * GFA_PT7_RECS - Number of postcode records in LSOA assigned to GFA Point 7 * GFA_PT7_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 7 * GFA_PT8_RECS - Number of postcode records in LSOA assigned to GFA Point 8 * GFA_PT8_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 8 * GFA_PT9_RECS - Number of postcode records in LSOA assigned to GFA Point 9 * GFA_PT9_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 9 * GFA_PT10_RECS - Number of postcode records in LSOA assigned to GFA Point 10 * GFA_PT10_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 10 * GFA_PT11_RECS - Number of postcode records in LSOA assigned to GFA Point 11 (most vulnerable) * GFA_PT11_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA assigned to GFA Point 11 * GFA_PT99_RECS - Number of postcode records in LSOA not assigned to a GFA group * GFA_PT99_HHCOUNT - Sum of EXPERIAN_HHCOUNT field for postcode records in LSOA not assigned to a GFA Group Known Data Issues Geocoding - The complete postcode dataset for Greater London contains a total of 163,705 records. These have been geocoded against OS Code-Point data covering the last two years. Data was geocoded against the most up to date Code-Point data and any records which were not matched were then geocoded against the next oldest Code-Point dataset. The process was repeated for each quarterly update of Code-Point data in the last two years and the specific version of Code-Point used to geocode a particular record is flagged in the POSTCODE_SOURCE field. A total of 1,105 records were not geocoded as no matching postcode was found. Of the unmatched records 833 have been assigned a value of 99 in the EXPERIAN_GROUP field. Inconsistent Boroughs - Of the 163,075 records for Greater London approximately 50 records have different Borough Name values assigned to them by Experian and from Boundary-Line. This may be due to inconsistencies in the versions of different datasets used by Experian and the GLA in geocoding the datasets. Individual postcode datafiles for Boroughs have been created using the Experian assigned Borough name. It may be that in a small number of cases the data for a Borough contains a few records that fall outside the Borough boundary when plotted using the supplied coordinates. Acknowledgements Geocoding and administrative data are taken from Ordnance Survey OpenData Contains Ordnance Survey data © Crown copyright and database right 2010 More information is available at http://www.ordnancesurvey.co.uk/oswebsite/opendata/