About this Dataset

MSOA Atlas

This MSOA atlas provides a summary of demographic and related data for each Middle Super Output Area in Greater London. The average population of an MSOA in London in 2010 was 8,346, compared with 1,722 for an LSOA and 13,078 for a ward. The profiles are designed to provide an overview of the population in these small areas by combining a range of data on the population, births, deaths, health, housing, crime, commercial property/floorspace, income, poverty, benefits, land use, environment, deprivation, schools, and employment. If you need to find an MSOA and you know the postcode of the area, the ONS NESS search page has a tool for this. The MSOA Atlas is available as an XLS as well as being presented using InstantAtlas mapping software. This is a useful tool for displaying a large amount of data for numerous geographies, in one place (requires HTML 5). NB. It is currently not possible to export the map as a picture due to a software issue with the Google Maps background. We advise you to print screen to copy an image to the clipboard. 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. \- The legend settings can be altered by clicking on the pencil icon next to the MSOA tick box within the map legend. 4. \- The areas can be ranked in order by clicking at the top of the indicator column of the data table. Themes included here are Census 2011 Population, Mid-year Estimates, Population by Broad Age, Households, Household composition, Ethnic Group, Country of Birth, Language, Religion, Tenure, Dwelling type, Land Area, Population Density, Births, General Fertility Rate, Deaths, Standardised Mortality Ratio (SMR), Population Turnover Rates (per 1000), Crime (numbers), Crime (rates), House Prices, Commercial property (number), Rateable Value (£ per m2), Floorspace; ('000s m2), Household Income, Household Poverty, County Court Judgements (2005), Qualifications, Economic Activity, Employees, Employment, Claimant Count, Pupil Absence, Early Years Foundation Stage, Key Stage 1, GCSE and Equivalent, Health, Air Emissions, Car or Van availability, Income Deprivation, Central Heating, Incidence of Cancer, Life Expectancy, and Road Casualties. * 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 (Spring 2014). You may also be interested in LSOA Atlas and Ward Atlas.
Publisher name: Greater London Authority
Last updated: 2024-10-13T04:00:03Z

Tables

Current MSOA Boundaries Post 2011

@ukgov.msoa_atlas.current_msoa_boundaries_post_2011

784.39 KB
984 rows
207 columns


CREATE TABLE current_msoa_boundaries_post_2011 (
  "middle_super_output_area" VARCHAR,
  "msoa_name" VARCHAR,
  "age_structure_2011_census_all_ages" BIGINT,
  "age_structure_2011_census_0_15" BIGINT,
  "age_structure_2011_census_16_29" BIGINT,
  "age_structure_2011_census_30_44" BIGINT,
  "age_structure_2011_census_45_64" BIGINT,
  "age_structure_2011_census_65" BIGINT,
  "age_structure_2011_census_working_age" BIGINT,
  "mid_year_estimate_totals_all_ages_2002" BIGINT,
  "mid_year_estimate_totals_all_ages_2003" BIGINT,
  "mid_year_estimate_totals_all_ages_2004" BIGINT,
  "mid_year_estimate_totals_all_ages_2005" BIGINT,
  "mid_year_estimate_totals_all_ages_2006" BIGINT,
  "mid_year_estimate_totals_all_ages_2007" BIGINT,
  "mid_year_estimate_totals_all_ages_2008" BIGINT,
  "mid_year_estimate_totals_all_ages_2009" BIGINT,
  "mid_year_estimate_totals_all_ages_2010" BIGINT,
  "mid_year_estimate_totals_all_ages_2011" BIGINT,
  "mid_year_estimate_totals_all_ages_2012" BIGINT,
  "mid_year_estimates_2012_by_age_0_to_14" DOUBLE,
  "mid_year_estimates_2012_by_age_15_64" DOUBLE,
  "mid_year_estimates_2012_by_age_65" DOUBLE,
  "mid_year_estimates_2012_by_age_0_4" BIGINT,
  "mid_year_estimates_2012_by_age_5_9" DOUBLE,
  "mid_year_estimates_2012_by_age_10_14" DOUBLE,
  "mid_year_estimates_2012_by_age_15_19" DOUBLE,
  "mid_year_estimates_2012_by_age_20_24" BIGINT,
  "mid_year_estimates_2012_by_age_25_29" DOUBLE,
  "mid_year_estimates_2012_by_age_30_34" DOUBLE,
  "mid_year_estimates_2012_by_age_35_39" DOUBLE,
  "mid_year_estimates_2012_by_age_40_44" BIGINT,
  "mid_year_estimates_2012_by_age_45_49" DOUBLE,
  "mid_year_estimates_2012_by_age_50_54" DOUBLE,
  "mid_year_estimates_2012_by_age_55_59" DOUBLE,
  "mid_year_estimates_2012_by_age_60_64" BIGINT,
  "mid_year_estimates_2012_by_age_65_69" DOUBLE,
  "mid_year_estimates_2012_by_age_70_74" DOUBLE,
  "mid_year_estimates_2012_by_age_75_79" DOUBLE,
  "mid_year_estimates_2012_by_age_80_84" BIGINT,
  "mid_year_estimates_2012_by_age_85_89" DOUBLE,
  "mid_year_estimates_2012_by_age_90" DOUBLE,
  "households_2011_all_households" BIGINT,
  "household_composition_2011_numbers_couple_household_wi_1375d6c2" BIGINT,
  "household_composition_2011_numbers_couple_household_wi_abf90883" BIGINT,
  "household_composition_2011_numbers_lone_parent_household" BIGINT,
  "household_composition_2011_numbers_one_person_household" BIGINT,
  "household_composition_2011_numbers_other_household_types" BIGINT,
  "household_composition_2011_percentages_couple_househol_ff09642d" DOUBLE,
  "household_composition_2011_percentages_couple_househol_8ea8b707" DOUBLE,
  "household_composition_2011_percentages_lone_parent_household" DOUBLE,
  "household_composition_2011_percentages_one_person_household" DOUBLE,
  "household_composition_2011_percentages_other_household_types" DOUBLE,
  "ethnic_group_2011_census_white" BIGINT,
  "ethnic_group_2011_census_mixed_multiple_ethnic_groups" BIGINT,
  "ethnic_group_2011_census_asian_asian_british" BIGINT,
  "ethnic_group_2011_census_black_african_caribbean_black_british" BIGINT,
  "ethnic_group_2011_census_other_ethnic_group" BIGINT,
  "ethnic_group_2011_census_bame" BIGINT,
  "ethnic_group_2011_census_white_daa90b" DOUBLE,
  "ethnic_group_2011_census_mixed_multiple_ethnic_groups_733f32" DOUBLE,
  "ethnic_group_2011_census_asian_asian_british_a173bb" DOUBLE,
  "ethnic_group_2011_census_black_african_caribbean_black_b_91dae5" DOUBLE,
  "ethnic_group_2011_census_other_ethnic_group_72e147" DOUBLE,
  "ethnic_group_2011_census_bame_97dbc6" DOUBLE,
  "country_of_birth_2011_united_kingdom" BIGINT,
  "country_of_birth_2011_not_united_kingdom" BIGINT,
  "country_of_birth_2011_united_kingdom_8d7ac5" DOUBLE,
  "country_of_birth_2011_not_united_kingdom_e06316" DOUBLE,
  "household_language_2011_at_least_one_person_aged_16_an_3bc8b17b" BIGINT,
  "household_language_2011_no_people_in_household_have_en_9353ff69" BIGINT,
  "household_language_2011_of_people_aged_16_and_over_in__6fad1aa2" DOUBLE,
  "household_language_2011_of_households_where_no_people__826e8425" DOUBLE,
  "religion_2011_christian" BIGINT,
  "religion_2011_buddhist" BIGINT,
  "religion_2011_hindu" BIGINT,
  "religion_2011_jewish" BIGINT,
  "religion_2011_muslim" BIGINT,
  "religion_2011_sikh" BIGINT,
  "religion_2011_other_religion" BIGINT,
  "religion_2011_no_religion" BIGINT,
  "religion_2011_religion_not_stated" BIGINT,
  "religion_2011_christian_6f9c25" DOUBLE,
  "religion_2011_buddhist_82c695" DOUBLE,
  "religion_2011_hindu_26fd5d" DOUBLE,
  "religion_2011_jewish_f8d8bd" DOUBLE,
  "religion_2011_muslim_1bec6f" DOUBLE,
  "religion_2011_sikh_014c16" DOUBLE,
  "religion_2011_other_religion_e97ca8" DOUBLE,
  "religion_2011_no_religion_a13d94" DOUBLE,
  "religion_2011_religion_not_stated_2ba52b" DOUBLE,
  "tenure_2011_owned_owned_outright" BIGINT,
  "tenure_2011_owned_owned_with_a_mortgage_or_loan" BIGINT,
  "tenure_2011_social_rented" BIGINT,
  "tenure_2011_private_rented" BIGINT,
  "tenure_2011_owned_owned_outright_32dea6" DOUBLE,
  "tenure_2011_owned_owned_with_a_mortgage_or_loan_6fdf37" DOUBLE,
  "tenure_2011_social_rented_255e59" DOUBLE,
  "tenure_2011_private_rented_284a1e" DOUBLE,
  "dwelling_type_2011_household_spaces_with_at_least_one__e127504e" BIGINT
);

Previous MSOA Boundaries 2001-2011

@ukgov.msoa_atlas.previous_msoa_boundaries_2001_2011

2.22 MB
984 rows
1060 columns


CREATE TABLE previous_msoa_boundaries_2001_2011 (
  "middle_super_output_area_msoa_name_age_structure_2011_census" VARCHAR,
  "all_ages" VARCHAR,
  "n__age_structure_2011_census" VARCHAR,
  "n_0_15" VARCHAR,
  "n__age_structure_2011_census_1" VARCHAR,
  "n_16_29" VARCHAR,
  "n__age_structure_2011_census_2" VARCHAR,
  "n_30_44" VARCHAR,
  "n__age_structure_2011_census_3" VARCHAR,
  "n_45_64" VARCHAR,
  "n__age_structure_2011_census_4" VARCHAR,
  "n_65" VARCHAR,
  "n__age_structure_2011_census_5" VARCHAR,
  "working_age" VARCHAR,
  "n__mid_year_estimate_totals" VARCHAR,
  "all_ages_1" VARCHAR,
  "n_2002_mid_year_estimate_totals" VARCHAR,
  "all_ages_2" VARCHAR,
  "n_2003_mid_year_estimate_totals" VARCHAR,
  "all_ages_3" VARCHAR,
  "n_2004_mid_year_estimate_totals" VARCHAR,
  "all_ages_4" VARCHAR,
  "n_2005_mid_year_estimate_totals" VARCHAR,
  "all_ages_5" VARCHAR,
  "n_2006_mid_year_estimate_totals" VARCHAR,
  "all_ages_6" VARCHAR,
  "n_2007_mid_year_estimate_totals" VARCHAR,
  "all_ages_7" VARCHAR,
  "n_2008_mid_year_estimate_totals" VARCHAR,
  "all_ages_8" VARCHAR,
  "n_2009_mid_year_estimate_totals" VARCHAR,
  "all_ages_9" VARCHAR,
  "n_2010_mid_year_estimate_totals" VARCHAR,
  "all_ages_10" VARCHAR,
  "n_2011_mid_year_estimate_totals" VARCHAR,
  "all_ages_11" VARCHAR,
  "n_2012_mid_year_estimates_2012_by_age" VARCHAR,
  "n__0_to_14" VARCHAR,
  "n__mid_year_estimates_2012_by_age" VARCHAR,
  "n__15_64" VARCHAR,
  "n__mid_year_estimates_2012_by_age_1" VARCHAR,
  "n__65" VARCHAR,
  "n__mid_year_estimates_2012_by_age_2" VARCHAR,
  "n_0_4" VARCHAR,
  "n__mid_year_estimates_2012_by_age_3" VARCHAR,
  "n_5_9" VARCHAR,
  "n__mid_year_estimates_2012_by_age_4" VARCHAR,
  "n_10_14" VARCHAR,
  "n__mid_year_estimates_2012_by_age_5" VARCHAR,
  "n_15_19" VARCHAR,
  "n__mid_year_estimates_2012_by_age_6" VARCHAR,
  "n_20_24" VARCHAR,
  "n__mid_year_estimates_2012_by_age_7" VARCHAR,
  "n_25_29" VARCHAR,
  "n__mid_year_estimates_2012_by_age_8" VARCHAR,
  "n_30_34" VARCHAR,
  "n__mid_year_estimates_2012_by_age_9" VARCHAR,
  "n_35_39" VARCHAR,
  "n__mid_year_estimates_2012_by_age_10" VARCHAR,
  "n_40_44" VARCHAR,
  "n__mid_year_estimates_2012_by_age_11" VARCHAR,
  "n_45_49" VARCHAR,
  "n__mid_year_estimates_2012_by_age_12" VARCHAR,
  "n_50_54" VARCHAR,
  "n__mid_year_estimates_2012_by_age_13" VARCHAR,
  "n_55_59" VARCHAR,
  "n__mid_year_estimates_2012_by_age_14" VARCHAR,
  "n_60_64" VARCHAR,
  "n__mid_year_estimates_2012_by_age_15" VARCHAR,
  "n_65_69" VARCHAR,
  "n__mid_year_estimates_2012_by_age_16" VARCHAR,
  "n_70_74" VARCHAR,
  "n__mid_year_estimates_2012_by_age_17" VARCHAR,
  "n_75_79" VARCHAR,
  "n__mid_year_estimates_2012_by_age_18" VARCHAR,
  "n_80_84" VARCHAR,
  "n__mid_year_estimates_2012_by_age_19" VARCHAR,
  "n_85" VARCHAR,
  "n__households_2011_all_households_household_compositio_8dff652e" VARCHAR,
  "flat_maisonette_or_apartment" VARCHAR,
  "n__land_area_square_metres_m2_thousands_2005_land_area_999ef9ef" VARCHAR,
  "gfr_births_per_1_000_15_44_females" VARCHAR,
  "n_2004_general_fertility_rate" VARCHAR,
  "gfr_births_per_1_000_15_44_females_1" VARCHAR,
  "n_2005_general_fertility_rate" VARCHAR,
  "gfr_births_per_1_000_15_44_females_2" VARCHAR,
  "n_2006_general_fertility_rate" VARCHAR,
  "gfr_births_per_1_000_15_44_females_3" VARCHAR,
  "n_2007_general_fertility_rate" VARCHAR,
  "gfr_births_per_1_000_15_44_females_4" VARCHAR,
  "n_2008_general_fertility_rate" VARCHAR,
  "gfr_births_per_1_000_15_44_females_5" VARCHAR,
  "n_2009_general_fertility_rate" VARCHAR,
  "gfr_births_per_1_000_15_44_females_6" VARCHAR,
  "n_2010_deaths" VARCHAR,
  "all_deaths" VARCHAR,
  "n_2004_deaths" VARCHAR,
  "all_deaths_1" VARCHAR,
  "n_2005_deaths" VARCHAR,
  "all_deaths_2" VARCHAR
);