About this Dataset

London Parliamentary Constituency Profiles 2010

This report provides a summary of demographic and related data for each Westminster Parliamentary constituency in Greater London. The profiles are designed to provide an overview of the population in each area by combining a range of data on the population, diversity, households, life expectancy, council tax, crime, household income (paycheck), benefits, land use, education, business and deprivation. All data, relate to people who live in the area, i.e. they are residence-based. The vast majority of data used in these profiles was aggregated from either Lower Super Output Area or Ward level data. Lookup tables are available to download from this page so that users can construct their own constituency data from ward or LSOA datasets. In the PDF version of the report are maps for each area that show both the location of the constituency within London, the wards that make up the constituency, and also borough boundaries. Data in these profiles are available in the following formats: ● Full Briefing as PDF ● Interactive Excel spreadsheet \- for the Excel spreadsheet to function as it should, save it to your computer, and when prompted to do so, enable the macros. ● An interactive Excel version that includes maps is also available. ● Instant Atlas interactive maps (requires Flash) The GLA Data Management and Analysis Group (DMAG) has produced these profiles, using the most up to date information available at the time of collection (February 2010). The raw data that was used to create the profiles are also available in both Excel and CSV formats.
Publisher name: Greater London Authority
Last updated: 2024-09-14T08:00:56Z

Tables

Parliamentary-constituency-profiles-data

@ukgov.london_parliamentary_constituency_profiles_2010.parliamentary_constituency_profiles_data

234.26 kB
77 rows
211 columns

CREATE TABLE parliamentary_constituency_profiles_data (
  "area_code" VARCHAR,
  "parliamentary_constituency" VARCHAR,
  "persons_2008" DOUBLE,
  "males_2008" DOUBLE,
  "females_2008" DOUBLE,
  "n__aged_0_14_2008" DOUBLE  -- % Aged 0-14-2008,
  "n__aged_15_34_2008" DOUBLE  -- % Aged 15-34-2008,
  "n__aged_35_54_2008" DOUBLE  -- % Aged 35-54-2008,
  "n__aged_55_74_2008" DOUBLE  -- % Aged 55-74-2008,
  "n__aged_75_2008" DOUBLE  -- % Aged 75+-2008,
  "area_sqkm_2008" DOUBLE,
  "pop_density_sqkm_2008" DOUBLE  -- Pop Density (sqkm)-2008,
  "n__of_london_population_2008" DOUBLE  -- % Of London Population-2008,
  "n__all_people_2001" DOUBLE  -- % All People-2001,
  "n__white_british_2001" DOUBLE  -- % White British-2001,
  "n__white_irish_2001" DOUBLE  -- % White Irish-2001,
  "n__white_other_white_2001" DOUBLE  -- % White Other White-2001,
  "n__mixed_white_and_black_caribbean_2001" DOUBLE  -- % Mixed White And Black Caribbean-2001,
  "n__mixed_white_and_black_african_2001" DOUBLE  -- % Mixed White And Black African-2001,
  "n__mixed_white_and_asian_2001" DOUBLE  -- % Mixed White And Asian-2001,
  "n__mixed_other_mixed_2001" DOUBLE  -- % Mixed Other Mixed-2001,
  "n__asian_or_asian_british_indian_2001" DOUBLE  -- % Asian Or Asian British Indian-2001,
  "n__asian_or_asian_british_pakistani_2001" DOUBLE  -- % Asian Or Asian British Pakistani-2001,
  "n__asian_or_asian_british_bangladeshi_2001" DOUBLE  -- % Asian Or Asian British Bangladeshi-2001,
  "n__asian_or_asian_british_other_asian_2001" DOUBLE  -- % Asian Or Asian British Other Asian-2001,
  "n__black_or_black_british_black_caribbean_2001" DOUBLE  -- % Black Or Black British Black Caribbean-2001,
  "n__black_or_black_british_black_african_2001" DOUBLE  -- % Black Or Black British Black African-2001,
  "n__black_or_black_british_other_black_2001" DOUBLE  -- % Black Or Black British Other Black-2001,
  "n__chinese_or_other_ethnic_group_chinese_2001" DOUBLE  -- % Chinese Or Other Ethnic Group Chinese-2001,
  "n__chinese_or_other_ethnic_group_other_ethnic_group_2001" DOUBLE  -- % Chinese Or Other Ethnic Group Other Ethnic Group-2001,
  "white_2001" DOUBLE,
  "mixed_2001" DOUBLE,
  "asian_2001" DOUBLE,
  "black_2001" DOUBLE,
  "chinese_other_2001" DOUBLE,
  "actual_deaths_2008" DOUBLE,
  "births_2008" DOUBLE,
  "general_fertility_rate_2008" DOUBLE,
  "smr_2008" DOUBLE,
  "infant_mortality_rate_2008" DOUBLE,
  "dwelling_stock_total_2008" DOUBLE  -- Dwelling Stock; Total-2008,
  "n__dwellings_in_bands_a_or_b_2008" DOUBLE  -- % Dwellings In Bands A Or B-2008,
  "n__dwellings_in_bands_c_d_and_e_2008" DOUBLE  -- % Dwellings In Bands C, D, And E-2008,
  "n__dwellings_in_bands_f_g_and_h_2008" DOUBLE  -- % Dwellings In Bands F, G And H-2008,
  "dwellings_in_band_a_2008" DOUBLE,
  "dwellings_in_band_b_2008" DOUBLE,
  "dwellings_in_band_c_2008" DOUBLE,
  "dwellings_in_band_d_2008" DOUBLE,
  "dwellings_in_band_e_2008" DOUBLE,
  "dwellings_in_band_f_2008" DOUBLE,
  "dwellings_in_band_g_2008" DOUBLE,
  "dwellings_in_band_h_2008" DOUBLE,
  "unequivalised_mean_income_2009" DOUBLE  -- Unequivalised Mean Income-Ł-2009,
  "n__under_20k_2009" DOUBLE  -- % Under Ł20k-2009,
  "n__over_50k_2009" DOUBLE  -- % Over Ł50k-2009,
  "equivalised_mean_income_2009" DOUBLE  -- Equivalised Mean Income-Ł-2009,
  "n__under_20k_2009_1" DOUBLE  -- % Under Ł20k-2009.1,
  "n__over_50k_2009_1" DOUBLE  -- % Over Ł50k-2009.1,
  "disability_living_allowance_claimants_total_2008" DOUBLE  -- Disability Living Allowance Claimants; Total-2008,
  "n_16_to_59_2008" DOUBLE  -- 16 To 59-2008,
  "disability_living_allowance_2008" DOUBLE,
  "incapacity_benefit_severe_disablement_allowance_claima_da6b5e9d" DOUBLE  -- Incapacity Benefit/Severe Disablement Allowance Claimants; Total-2008,
  "n_16_to_64_2008" DOUBLE  -- 16 To 64-2008,
  "incapacity_benefit_severe_disablement_allowance_2008" DOUBLE,
  "income_support_claimants_total_2008" DOUBLE  -- Income Support Claimants; Total-2008,
  "n_16_to_59_2008_1" DOUBLE  -- 16 To 59-2008.1,
  "income_support_2008" DOUBLE,
  "n__of_london_total_2008" DOUBLE  -- % Of London Total-2008,
  "jobseekers_allowance_claimants_total_2008" DOUBLE  -- Jobseekers Allowance Claimants; Total-2008,
  "working_age_2008" DOUBLE,
  "jobseekers_allowance_2008" DOUBLE,
  "jobseekers_allowance_claimants_male_2008" DOUBLE  -- Jobseekers Allowance Claimants; Male-2008,
  "male_16_64_2008" DOUBLE,
  "jobseekers_allowance_males_2008" DOUBLE  -- Jobseekers Allowance (Males)-2008,
  "jobseekers_allowance_claimants_female_2008" DOUBLE  -- Jobseekers Allowance Claimants; Female-2008,
  "female_16_59_2008" DOUBLE,
  "jobseekers_allowance_females_2008" DOUBLE  -- Jobseekers Allowance (Females)-2008,
  "jobseekers_allowance_claimants_aged_16_24_2008" DOUBLE  -- Jobseekers Allowance Claimants; Aged 16-24-2008,
  "n_16_to_24_2008" DOUBLE  -- 16 To 24-2008,
  "jobseekers_allowance_16_24_2008" DOUBLE  -- Jobseekers Allowance (16-24)-2008,
  "jobseekers_allowance_claimants_aged_25_49_2008" DOUBLE  -- Jobseekers Allowance Claimants; Aged 25-49-2008,
  "n_25_to_49_2008" DOUBLE  -- 25 To 49-2008,
  "jobseekers_allowance_25_49_2008" DOUBLE  -- Jobseekers Allowance (25-49)-2008,
  "jobseekers_allowance_claimants_aged_50_and_over_2008" DOUBLE  -- Jobseekers Allowance Claimants; Aged 50 And Over-2008,
  "n_50_to_pension_age_2008" DOUBLE  -- 50 To Pension Age-2008,
  "jobseekers_allowance_50_to_pension_age_2008" DOUBLE  -- Jobseekers Allowance (50 To Pension Age)-2008,
  "pension_credit_claimants_total_2008" DOUBLE  -- Pension Credit Claimants; Total-2008,
  "n_60_and_over_2008" DOUBLE  -- 60 And Over-2008,
  "pension_credit_2008" DOUBLE,
  "claimants_persons_jan_10" DOUBLE,
  "claimants_males_jan_10" DOUBLE,
  "claimants_females_jan_10" DOUBLE,
  "claimants_16_24_jan_10" DOUBLE,
  "labour_force_persons_jan_10" DOUBLE,
  "labour_force_males_jan_10" DOUBLE,
  "labour_force_females_jan_10" DOUBLE,
  "labour_force_16_24_jan_10" DOUBLE,
  "rates_persons_jan_10" DOUBLE,
  "rates_males_jan_10" DOUBLE,
  "rates_females_jan_10" DOUBLE
);