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

228.77 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,
  "n__aged_15_34_2008" DOUBLE,
  "n__aged_35_54_2008" DOUBLE,
  "n__aged_55_74_2008" DOUBLE,
  "n__aged_75_2008" DOUBLE,
  "area_sqkm_2008" DOUBLE,
  "pop_density_sqkm_2008" DOUBLE,
  "n__of_london_population_2008" DOUBLE,
  "n__all_people_2001" DOUBLE,
  "n__white_british_2001" DOUBLE,
  "n__white_irish_2001" DOUBLE,
  "n__white_other_white_2001" DOUBLE,
  "n__mixed_white_and_black_caribbean_2001" DOUBLE,
  "n__mixed_white_and_black_african_2001" DOUBLE,
  "n__mixed_white_and_asian_2001" DOUBLE,
  "n__mixed_other_mixed_2001" DOUBLE,
  "n__asian_or_asian_british_indian_2001" DOUBLE,
  "n__asian_or_asian_british_pakistani_2001" DOUBLE,
  "n__asian_or_asian_british_bangladeshi_2001" DOUBLE,
  "n__asian_or_asian_british_other_asian_2001" DOUBLE,
  "n__black_or_black_british_black_caribbean_2001" DOUBLE,
  "n__black_or_black_british_black_african_2001" DOUBLE,
  "n__black_or_black_british_other_black_2001" DOUBLE,
  "n__chinese_or_other_ethnic_group_chinese_2001" DOUBLE,
  "n__chinese_or_other_ethnic_group_other_ethnic_group_2001" DOUBLE,
  "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,
  "n__dwellings_in_bands_a_or_b_2008" DOUBLE,
  "n__dwellings_in_bands_c_d_and_e_2008" DOUBLE,
  "n__dwellings_in_bands_f_g_and_h_2008" DOUBLE,
  "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,
  "n__under_20k_2009" DOUBLE,
  "n__over_50k_2009" DOUBLE,
  "equivalised_mean_income_2009" DOUBLE,
  "n__under_20k_2009_1" DOUBLE,
  "n__over_50k_2009_1" DOUBLE,
  "disability_living_allowance_claimants_total_2008" DOUBLE,
  "n_16_to_59_2008" DOUBLE,
  "disability_living_allowance_2008" DOUBLE,
  "incapacity_benefit_severe_disablement_allowance_claima_da6b5e9d" DOUBLE,
  "n_16_to_64_2008" DOUBLE,
  "incapacity_benefit_severe_disablement_allowance_2008" DOUBLE,
  "income_support_claimants_total_2008" DOUBLE,
  "n_16_to_59_2008_1" DOUBLE,
  "income_support_2008" DOUBLE,
  "n__of_london_total_2008" DOUBLE,
  "jobseekers_allowance_claimants_total_2008" DOUBLE,
  "working_age_2008" DOUBLE,
  "jobseekers_allowance_2008" DOUBLE,
  "jobseekers_allowance_claimants_male_2008" DOUBLE,
  "male_16_64_2008" DOUBLE,
  "jobseekers_allowance_males_2008" DOUBLE,
  "jobseekers_allowance_claimants_female_2008" DOUBLE,
  "female_16_59_2008" DOUBLE,
  "jobseekers_allowance_females_2008" DOUBLE,
  "jobseekers_allowance_claimants_aged_16_24_2008" DOUBLE,
  "n_16_to_24_2008" DOUBLE,
  "jobseekers_allowance_16_24_2008" DOUBLE,
  "jobseekers_allowance_claimants_aged_25_49_2008" DOUBLE,
  "n_25_to_49_2008" DOUBLE,
  "jobseekers_allowance_25_49_2008" DOUBLE,
  "jobseekers_allowance_claimants_aged_50_and_over_2008" DOUBLE,
  "n_50_to_pension_age_2008" DOUBLE,
  "jobseekers_allowance_50_to_pension_age_2008" DOUBLE,
  "pension_credit_claimants_total_2008" DOUBLE,
  "n_60_and_over_2008" DOUBLE,
  "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
);