About this Dataset

Ward Profiles And Atlas

The ward profiles and ward atlas provide a range of demographic and related data for each ward in Greater London. They are designed to provide an overview of the population in these small areas by presenting a range of data on the population, diversity, households, life expectancy, housing, crime, benefits, land use, deprivation, and employment. Indicators included here are population by age and sex, land area, projections, population density, household composition, religion, ethnicity, birth rates (general fertility rate), death rates (standardised mortality ratio), life expectancy, average house prices, properties sold, housing by council tax band, tenure, property size (bedrooms), dwelling build period and type, mortgage and landlord home repossession, employment and economic activity, Incapacity Benefit, Housing Benefit, Household income, Income Support and JobSeekers Allowance claimant rates, dependent children receiving child-tax credits by lone parents and out-of-work families, child poverty, National Insurance Number registration rates for overseas nationals (NINo), GCSE results, A-level / Level 3 results (average point scores), pupil absence, child obesity, crime rates (by type of crime), fires, ambulance call outs, road casualties, happiness and well-being, land use, public transport accessibility (PTALs), access to public greenspace, access to nature, air emissions / quality, car use, bicycle travel, Indices of Deprivation, and election turnout. The Ward Profiles present key summary measures for the most recent year, using both Excel and InstantAtlas mapping software. This is a useful tool for displaying a large amount of data for numerous geographies, in one place. The Ward Atlas presents a more detailed version of the data including trend data and generally includes the raw numbers as opposed to percentages or rates. The Instant Atlas reports use HTML5 technology, which can be used in modern browsers, including on Apple machines, but will not function on older browsers. WARD ATLAS FOR 2014 BOUNDARIES In May 2014, ward boundaries changed in Hackney, Kensington and Chelsea, and Tower Hamlets. This version of the ward atlas gives data for these new wards, as well as retaining data on the unchanged wards in the rest of London for comparison purposes. Data for boroughs has also been included. Very few datasets have been published for the new ward boundaries, so the majority of data contained in this atlas have been modelled using a method of proportion of households from the old boundaries that are located in the new boundaries. Therefore, the data contained in this atlas are indicative only. Instant Atlas for 2014 Ward Atlas Tips: 1. \- Select a new indicator from the Data box on the left. Select the theme, then indicator and then year to show the data. 2. \- To view data just for one borough*, use the filter tool. 3. \- Some legend settings can be altered by clicking on the cog icon next to the Wards tick box within the map legend. 4. \- The wards can be ranked in order by clicking at the top of the indicator column of the data table. Note: Additional indicator information and sources are included within the spreadsheet and Instant Atlas report. ### OTHER SMALL AREA PROFILES Other profiles available include Borough, LSOA and MSOA atlases. Data from these profiles were used to create the Well-being scores tool. * *The London boroughs are: City of London, Barking and Dagenham, Barnet, Bexley, Brent, Bromley, Camden, Croydon, Ealing, Enfield, Greenwich, Hackney, Hammersmith and Fulham, Haringey, Harrow, Havering, Hillingdon, Hounslow, Islington, Kensington and Chelsea, Kingston upon Thames, Lambeth, Lewisham, Merton, Newham, Redbridge, Richmond upon Thames, Southwark, Sutton, Tower Hamlets, Waltham Forest, Wandsworth, Westminster. These profiles were created using the most up to date information available at the time of collection (September 2015).
Publisher name: Greater London Authority
Last updated: 2024-10-13T04:00:03Z

Tables

Ward-atlas-data

@ukgov.ward_profiles_and_atlas.ward_atlas_data

4.18 MB
629 rows
1,887 columns

CREATE TABLE ward_atlas_data (
  "n__population_and_age" VARCHAR  -- ,,,,Population And Age,
  "n__population_estimates_and_projections" VARCHAR  -- Population Estimates And Projections,
  "n__2001_population_and_age" VARCHAR  -- 2001,Population And Age,
  "n__population_estimates_and_projections_1" VARCHAR  -- Population Estimates And Projections.1,
  "n__2006_population_and_age" VARCHAR  -- 2006,Population And Age,
  "n__population_estimates_and_projections_2" VARCHAR  -- Population Estimates And Projections.2,
  "n__2011_population_and_age" VARCHAR  -- 2011,Population And Age,
  "n__population_estimates_and_projections_3" VARCHAR  -- Population Estimates And Projections.3,
  "n__2013_population_and_age" VARCHAR  -- 2013,Population And Age,
  "n__population_estimates_and_projections_4" VARCHAR  -- Population Estimates And Projections.4,
  "n__2014_population_and_age" VARCHAR  -- 2014,Population And Age,
  "n__population_estimates_and_projections_5" VARCHAR  -- Population Estimates And Projections.5,
  "n__2015_population_and_age" VARCHAR  -- 2015,Population And Age,
  "n__population_estimates_and_projections_6" VARCHAR  -- Population Estimates And Projections.6,
  "n__2016_population_and_age" VARCHAR  -- 2016,Population And Age,
  "n__population_estimates_and_projections_7" VARCHAR  -- Population Estimates And Projections.7,
  "n__2018_population_and_age" VARCHAR  -- 2018,Population And Age,
  "n__population_estimates_and_projections_8" VARCHAR  -- Population Estimates And Projections.8,
  "n__2023_population_and_age" VARCHAR  -- 2023,Population And Age,
  "n__population_estimates_and_projections_9" VARCHAR  -- Population Estimates And Projections.9,
  "n__2028_population_and_age" VARCHAR  -- 2028,Population And Age,
  "n__age_structure_percentage_2013" VARCHAR  -- Age Structure (percentage) - 2013,
  "n__aged_0_15_population_and_age" VARCHAR  -- Aged 0-15,Population And Age,
  "n__age_structure_percentage_2013_1" VARCHAR  -- Age Structure (percentage) - 2013.1,
  "n__aged_16_64_population_and_age" VARCHAR  -- Aged 16-64,Population And Age,
  "n__age_structure_percentage_2013_2" VARCHAR  -- Age Structure (percentage) - 2013.2,
  "n__aged_65_population_and_age" VARCHAR  -- Aged 65+,Population And Age,
  "n__aged_0_15" VARCHAR  -- Aged 0-15,
  "n__2002_population_and_age" VARCHAR  -- 2002,Population And Age,
  "n__aged_0_15_1" VARCHAR  -- Aged 0-15.1,
  "n__2004_population_and_age" VARCHAR  -- 2004,Population And Age,
  "n__aged_0_15_2" VARCHAR  -- Aged 0-15.2,
  "n__2006_population_and_age_1" VARCHAR  -- 2006,Population And Age.1,
  "n__aged_0_15_3" VARCHAR  -- Aged 0-15.3,
  "n__2008_population_and_age" VARCHAR  -- 2008,Population And Age,
  "n__aged_0_15_4" VARCHAR  -- Aged 0-15.4,
  "n__2010_population_and_age" VARCHAR  -- 2010,Population And Age,
  "n__aged_0_15_5" VARCHAR  -- Aged 0-15.5,
  "n__2011_population_and_age_1" VARCHAR  -- 2011,Population And Age.1,
  "n__aged_0_15_6" VARCHAR  -- Aged 0-15.6,
  "n__2012_population_and_age" VARCHAR  -- 2012,Population And Age,
  "n__aged_0_15_7" VARCHAR  -- Aged 0-15.7,
  "n__2013_population_and_age_1" VARCHAR  -- 2013,Population And Age.1,
  "n__aged_16_64" VARCHAR  -- Aged 16-64,
  "n__2002_population_and_age_1" VARCHAR  -- 2002,Population And Age.1,
  "n__aged_16_64_1" VARCHAR  -- Aged 16-64.1,
  "n__2004_population_and_age_1" VARCHAR  -- 2004,Population And Age.1,
  "n__aged_16_64_2" VARCHAR  -- Aged 16-64.2,
  "n__2006_population_and_age_2" VARCHAR  -- 2006,Population And Age.2,
  "n__aged_16_64_3" VARCHAR  -- Aged 16-64.3,
  "n__2008_population_and_age_1" VARCHAR  -- 2008,Population And Age.1,
  "n__aged_16_64_4" VARCHAR  -- Aged 16-64.4,
  "n__2010_population_and_age_1" VARCHAR  -- 2010,Population And Age.1,
  "n__aged_16_64_5" VARCHAR  -- Aged 16-64.5,
  "n__2011_population_and_age_2" VARCHAR  -- 2011,Population And Age.2,
  "n__aged_16_64_6" VARCHAR  -- Aged 16-64.6,
  "n__2012_population_and_age_1" VARCHAR  -- 2012,Population And Age.1,
  "n__aged_16_64_7" VARCHAR  -- Aged 16-64.7,
  "n__2013_population_and_age_2" VARCHAR  -- 2013,Population And Age.2,
  "n__aged_65" VARCHAR  -- Aged 65+,
  "n__2002_population_and_age_2" VARCHAR  -- 2002,Population And Age.2,
  "n__aged_65_1" VARCHAR  -- Aged 65+.1,
  "n__2004_population_and_age_2" VARCHAR  -- 2004,Population And Age.2,
  "n__aged_65_2" VARCHAR  -- Aged 65+.2,
  "n__2006_population_and_age_3" VARCHAR  -- 2006,Population And Age.3,
  "n__aged_65_3" VARCHAR  -- Aged 65+.3,
  "n__2008_population_and_age_2" VARCHAR  -- 2008,Population And Age.2,
  "n__aged_65_4" VARCHAR  -- Aged 65+.4,
  "n__2010_population_and_age_2" VARCHAR  -- 2010,Population And Age.2,
  "n__aged_65_5" VARCHAR  -- Aged 65+.5,
  "n__2011_population_and_age_3" VARCHAR  -- 2011,Population And Age.3,
  "n__aged_65_6" VARCHAR  -- Aged 65+.6,
  "n__2012_population_and_age_2" VARCHAR  -- 2012,Population And Age.2,
  "n__aged_65_7" VARCHAR  -- Aged 65+.7,
  "n__2013_population_and_age_3" VARCHAR  -- 2013,Population And Age.3,
  "n__all_ages" VARCHAR  -- All Ages,
  "n__2002_population_and_age_3" VARCHAR  -- 2002,Population And Age.3,
  "n__all_ages_1" VARCHAR  -- All Ages.1,
  "n__2004_population_and_age_3" VARCHAR  -- 2004,Population And Age.3,
  "n__all_ages_2" VARCHAR  -- All Ages.2,
  "n__2006_population_and_age_4" VARCHAR  -- 2006,Population And Age.4,
  "n__all_ages_3" VARCHAR  -- All Ages.3,
  "n__2008_population_and_age_3" VARCHAR  -- 2008,Population And Age.3,
  "n__all_ages_4" VARCHAR  -- All Ages.4,
  "n__2010_population_and_age_3" VARCHAR  -- 2010,Population And Age.3,
  "n__all_ages_5" VARCHAR  -- All Ages.5,
  "n__2011_population_and_age_4" VARCHAR  -- 2011,Population And Age.4,
  "n__all_ages_6" VARCHAR  -- All Ages.6,
  "n__2012_population_and_age_3" VARCHAR  -- 2012,Population And Age.3,
  "n__all_ages_7" VARCHAR  -- All Ages.7,
  "n__2013_population_and_age_4" VARCHAR  -- 2013,Population And Age.4,
  "n__mean_age" VARCHAR  -- Mean Age,
  "n__2002_population_and_age_4" VARCHAR  -- 2002,Population And Age.4,
  "n__mean_age_1" VARCHAR  -- Mean Age.1,
  "n__2004_population_and_age_4" VARCHAR  -- 2004,Population And Age.4,
  "n__mean_age_2" VARCHAR  -- Mean Age.2,
  "n__2006_population_and_age_5" VARCHAR  -- 2006,Population And Age.5,
  "n__mean_age_3" VARCHAR  -- Mean Age.3,
  "n__2008_population_and_age_4" VARCHAR  -- 2008,Population And Age.4,
  "n__mean_age_4" VARCHAR  -- Mean Age.4
);

Ward-profiles-excel-version

@ukgov.ward_profiles_and_atlas.ward_profiles_excel_version

192.5 kB
660 rows
67 columns

CREATE TABLE ward_profiles_excel_version (
  "ward_name" VARCHAR,
  "old_code" VARCHAR,
  "new_code" VARCHAR,
  "population_2015" DOUBLE  -- Population - 2015,
  "children_aged_0_15_2015" DOUBLE  -- Children Aged 0-15 - 2015,
  "working_age_16_64_2015" DOUBLE  -- Working-age (16-64) - 2015,
  "older_people_aged_65_2015" DOUBLE  -- Older People Aged 65+ - 2015,
  "n__all_children_aged_0_15_2015" DOUBLE  -- % All Children Aged 0-15 - 2015,
  "n__all_working_age_16_64_2015" DOUBLE  -- % All Working-age (16-64) - 2015,
  "n__all_older_people_aged_65_2015" DOUBLE  -- % All Older People Aged 65+ - 2015,
  "mean_age_2013" DOUBLE  -- Mean Age - 2013,
  "median_age_2013" DOUBLE  -- Median Age - 2013,
  "area_square_kilometres" DOUBLE  -- Area - Square Kilometres,
  "population_density_persons_per_sq_km_2013" DOUBLE  -- Population Density (persons Per Sq Km) - 2013,
  "n__bame_2011" DOUBLE  -- % BAME - 2011,
  "n__not_born_in_uk_2011" DOUBLE  -- % Not Born In UK - 2011,
  "n__english_is_first_language_of_no_one_in_household_2011" DOUBLE  -- % English Is First Language Of No One In Household - 2011,
  "general_fertility_rate_2013" DOUBLE  -- General Fertility Rate - 2013,
  "male_life_expectancy_2009_13" DOUBLE  -- Male Life Expectancy -2009-13,
  "female_life_expectancy_2009_13" DOUBLE  -- Female Life Expectancy -2009-13,
  "n__children_in_reception_year_who_are_obese_2011_12_to_2013_14" VARCHAR  -- % Children In Reception Year Who Are Obese - 2011/12 To 2013/14,
  "n__children_in_year_6_who_are_obese_2011_12_to_2013_14" VARCHAR  -- % Children In Year 6 Who Are Obese- 2011/12 To 2013/14,
  "rate_of_all_ambulance_incidents_per_1_000_population_2014" VARCHAR  -- Rate Of All Ambulance Incidents Per 1,000 Population - 2014,
  "rates_of_ambulance_call_outs_for_alcohol_related_illness_2014" VARCHAR  -- Rates Of Ambulance Call Outs For Alcohol Related Illness - 2014,
  "number_killed_or_seriously_injured_on_the_roads_2014" DOUBLE  -- Number Killed Or Seriously Injured On The Roads - 2014,
  "in_employment_16_64_2011" DOUBLE  -- In Employment (16-64) - 2011,
  "employment_rate_16_64_2011" DOUBLE  -- Employment Rate (16-64) - 2011,
  "number_of_jobs_in_area_2013" VARCHAR  -- Number Of Jobs In Area - 2013,
  "employment_per_head_of_resident_wa_population_2013" VARCHAR  -- Employment Per Head Of Resident WA Population - 2013,
  "rate_of_new_registrations_of_migrant_workers_2011_12" DOUBLE  -- Rate Of New Registrations Of Migrant Workers - 2011/12,
  "median_house_price_2014" DOUBLE  -- Median House Price (Ł) - 2014,
  "number_of_properties_sold_2014" DOUBLE  -- Number Of Properties Sold - 2014,
  "median_household_income_estimate_2012_13" DOUBLE  -- Median Household Income Estimate (2012/13),
  "number_of_household_spaces_2011" DOUBLE  -- Number Of Household Spaces - 2011,
  "n__detached_houses_2011" DOUBLE  -- % Detached Houses - 2011,
  "n__semi_detached_houses_2011" DOUBLE  -- % Semi-detached Houses - 2011,
  "n__terraced_houses_2011" DOUBLE  -- % Terraced Houses - 2011,
  "n__flat_maisonette_or_apartment_2011" DOUBLE  -- % Flat, Maisonette Or Apartment - 2011,
  "n__households_owned_2011" DOUBLE  -- % Households Owned - 2011,
  "n__households_social_rented_2011" DOUBLE  -- % Households Social Rented - 2011,
  "n__households_private_rented_2011" DOUBLE  -- % Households Private Rented - 2011,
  "n__dwellings_in_council_tax_bands_a_or_b_2015" DOUBLE  -- % Dwellings In Council Tax Bands A Or B - 2015,
  "n__dwellings_in_council_tax_bands_c_d_or_e_2015" DOUBLE  -- % Dwellings In Council Tax Bands C, D Or E - 2015,
  "n__dwellings_in_council_tax_bands_f_g_or_h_2015" DOUBLE  -- % Dwellings In Council Tax Bands F, G Or H - 2015,
  "claimant_rate_of_key_out_of_work_benefits_working_age__20a1d201" DOUBLE  -- Claimant Rate Of Key Out-of-work Benefits (working Age Client Group) (2014),
  "claimant_rate_of_housing_benefit_2015" DOUBLE  -- Claimant Rate Of Housing Benefit (2015),
  "claimant_rate_of_employment_support_allowance_2014" DOUBLE  -- Claimant Rate Of Employment Support Allowance - 2014,
  "rate_of_jobseekers_allowance_jsa_claimants_2015" DOUBLE  -- Rate Of JobSeekers Allowance (JSA) Claimants - 2015,
  "n__dependent_children_0_18_in_out_of_work_households_2014" DOUBLE  -- % Dependent Children (0-18) In Out-of-work Households - 2014,
  "n__of_households_with_no_adults_in_employment_with_dep_ce8a2e19" DOUBLE  -- % Of Households With No Adults In Employment With Dependent Children - 2011,
  "n__of_lone_parents_not_in_employment_2011" DOUBLE  -- % Of Lone Parents Not In Employment - 2011,
  "n__id2010_rank_of_average_score_within_london_2010" VARCHAR  -- (ID2010) - Rank Of Average Score (within London) - 2010,
  "n__id2010_of_lsoas_in_worst_50_nationally_2010" VARCHAR  -- (ID2010) % Of LSOAs In Worst 50% Nationally - 2010,
  "average_gcse_capped_point_scores_2014" DOUBLE  -- Average GCSE Capped Point Scores - 2014,
  "unauthorised_absence_in_all_schools_2013" DOUBLE  -- Unauthorised Absence In All Schools (%) - 2013,
  "n__with_no_qualifications_2011" DOUBLE  -- % With No Qualifications - 2011,
  "n__with_level_4_qualifications_and_above_2011" DOUBLE  -- % With Level 4 Qualifications And Above - 2011,
  "a_level_average_point_score_per_student_2013_14" DOUBLE  -- A-Level Average Point Score Per Student - 2013/14,
  "a_level_average_point_score_per_entry_2013_14" DOUBLE  -- A-Level Average Point Score Per Entry; 2013/14,
  "crime_rate_2014_15" DOUBLE  -- Crime Rate - 2014/15,
  "violence_against_the_person_rate_2014_15" DOUBLE  -- Violence Against The Person Rate - 2014/15,
  "deliberate_fires_per_1_000_population_2014" VARCHAR  -- Deliberate Fires Per 1,000 Population - 2014,
  "n__area_that_is_open_space_2014" VARCHAR  -- % Area That Is Open Space - 2014,
  "cars_per_household_2011" DOUBLE  -- Cars Per Household - 2011,
  "average_public_transport_accessibility_score_2014" VARCHAR  -- Average Public Transport Accessibility Score - 2014,
  "n__travel_by_bicycle_to_work_2011" DOUBLE  -- % Travel By Bicycle To Work - 2011,
  "turnout_at_mayoral_election_2012" VARCHAR  -- Turnout At Mayoral Election - 2012
);