MSOA Atlas
Greater London Authority
@ukgov.msoa_atlas
Greater London Authority
@ukgov.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
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);All Ages;,
"age_structure_2011_census_0_15" BIGINT -- Age Structure (2011 Census);0-15;,
"age_structure_2011_census_16_29" BIGINT -- Age Structure (2011 Census);16-29;,
"age_structure_2011_census_30_44" BIGINT -- Age Structure (2011 Census);30-44;,
"age_structure_2011_census_45_64" BIGINT -- Age Structure (2011 Census);45-64;,
"age_structure_2011_census_65" BIGINT -- Age Structure (2011 Census);65+;,
"age_structure_2011_census_working_age" BIGINT -- Age Structure (2011 Census);Working-age;,
"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;% 0 To 14;,
"mid_year_estimates_2012_by_age_15_64" DOUBLE -- Mid-year Estimates 2012, By Age;% 15-64;,
"mid_year_estimates_2012_by_age_65" DOUBLE -- Mid-year Estimates 2012, By Age;% 65+;,
"mid_year_estimates_2012_by_age_0_4" BIGINT -- Mid-year Estimates 2012, By Age;0-4;,
"mid_year_estimates_2012_by_age_5_9" DOUBLE -- Mid-year Estimates 2012, By Age;5-9;,
"mid_year_estimates_2012_by_age_10_14" DOUBLE -- Mid-year Estimates 2012, By Age;10-14;,
"mid_year_estimates_2012_by_age_15_19" DOUBLE -- Mid-year Estimates 2012, By Age;15-19;,
"mid_year_estimates_2012_by_age_20_24" BIGINT -- Mid-year Estimates 2012, By Age;20-24;,
"mid_year_estimates_2012_by_age_25_29" DOUBLE -- Mid-year Estimates 2012, By Age;25-29;,
"mid_year_estimates_2012_by_age_30_34" DOUBLE -- Mid-year Estimates 2012, By Age;30-34;,
"mid_year_estimates_2012_by_age_35_39" DOUBLE -- Mid-year Estimates 2012, By Age;35-39;,
"mid_year_estimates_2012_by_age_40_44" BIGINT -- Mid-year Estimates 2012, By Age;40-44;,
"mid_year_estimates_2012_by_age_45_49" DOUBLE -- Mid-year Estimates 2012, By Age;45-49;,
"mid_year_estimates_2012_by_age_50_54" DOUBLE -- Mid-year Estimates 2012, By Age;50-54;,
"mid_year_estimates_2012_by_age_55_59" DOUBLE -- Mid-year Estimates 2012, By Age;55-59;,
"mid_year_estimates_2012_by_age_60_64" BIGINT -- Mid-year Estimates 2012, By Age;60-64;,
"mid_year_estimates_2012_by_age_65_69" DOUBLE -- Mid-year Estimates 2012, By Age;65-69;,
"mid_year_estimates_2012_by_age_70_74" DOUBLE -- Mid-year Estimates 2012, By Age;70-74;,
"mid_year_estimates_2012_by_age_75_79" DOUBLE -- Mid-year Estimates 2012, By Age;75-79;,
"mid_year_estimates_2012_by_age_80_84" BIGINT -- Mid-year Estimates 2012, By Age;80-84;,
"mid_year_estimates_2012_by_age_85_89" DOUBLE -- Mid-year Estimates 2012, By Age;85-89;,
"mid_year_estimates_2012_by_age_90" DOUBLE -- Mid-year Estimates 2012, By Age;90+;,
"households_2011_all_households" BIGINT -- Households (2011);All Households;,
"household_composition_2011_numbers_couple_household_wi_1375d6c2" BIGINT -- Household Composition (2011);Numbers;Couple Household With Dependent Children,
"household_composition_2011_numbers_couple_household_wi_abf90883" BIGINT -- Household Composition (2011);Numbers;Couple Household Without Dependent Children,
"household_composition_2011_numbers_lone_parent_household" BIGINT -- Household Composition (2011);Numbers;Lone Parent Household,
"household_composition_2011_numbers_one_person_household" BIGINT -- Household Composition (2011);Numbers;One Person Household,
"household_composition_2011_numbers_other_household_types" BIGINT -- Household Composition (2011);Numbers;Other Household Types,
"household_composition_2011_percentages_couple_househol_ff09642d" DOUBLE -- Household Composition (2011);Percentages;Couple Household With Dependent Children,
"household_composition_2011_percentages_couple_househol_8ea8b707" DOUBLE -- Household Composition (2011);Percentages;Couple Household Without Dependent Children,
"household_composition_2011_percentages_lone_parent_household" DOUBLE -- Household Composition (2011);Percentages;Lone Parent Household,
"household_composition_2011_percentages_one_person_household" DOUBLE -- Household Composition (2011);Percentages;One Person Household,
"household_composition_2011_percentages_other_household_types" DOUBLE -- Household Composition (2011);Percentages;Other Household Types,
"ethnic_group_2011_census_white" BIGINT -- Ethnic Group (2011 Census);White;,
"ethnic_group_2011_census_mixed_multiple_ethnic_groups" BIGINT -- Ethnic Group (2011 Census);Mixed/multiple Ethnic Groups;,
"ethnic_group_2011_census_asian_asian_british" BIGINT -- Ethnic Group (2011 Census);Asian/Asian British;,
"ethnic_group_2011_census_black_african_caribbean_black_british" BIGINT -- Ethnic Group (2011 Census);Black/African/Caribbean/Black British;,
"ethnic_group_2011_census_other_ethnic_group" BIGINT -- Ethnic Group (2011 Census);Other Ethnic Group;,
"ethnic_group_2011_census_bame" BIGINT -- Ethnic Group (2011 Census);BAME;,
"ethnic_group_2011_census_white_daa90b" DOUBLE -- Ethnic Group (2011 Census);White (%);,
"ethnic_group_2011_census_mixed_multiple_ethnic_groups_733f32" DOUBLE -- Ethnic Group (2011 Census);Mixed/multiple Ethnic Groups (%);,
"ethnic_group_2011_census_asian_asian_british_a173bb" DOUBLE -- Ethnic Group (2011 Census);Asian/Asian British (%);,
"ethnic_group_2011_census_black_african_caribbean_black_b_91dae5" DOUBLE -- Ethnic Group (2011 Census);Black/African/Caribbean/Black British (%);,
"ethnic_group_2011_census_other_ethnic_group_72e147" DOUBLE -- Ethnic Group (2011 Census);Other Ethnic Group (%);,
"ethnic_group_2011_census_bame_97dbc6" DOUBLE -- Ethnic Group (2011 Census);BAME (%);,
"country_of_birth_2011_united_kingdom" BIGINT -- Country Of Birth (2011);United Kingdom;,
"country_of_birth_2011_not_united_kingdom" BIGINT -- Country Of Birth (2011);Not United Kingdom;,
"country_of_birth_2011_united_kingdom_8d7ac5" DOUBLE -- Country Of Birth (2011);United Kingdom (%);,
"country_of_birth_2011_not_united_kingdom_e06316" DOUBLE -- Country Of Birth (2011);Not United Kingdom (%);,
"household_language_2011_at_least_one_person_aged_16_an_3bc8b17b" BIGINT -- Household Language (2011);At Least One Person Aged 16 And Over In Household Has English As A Main Language;,
"household_language_2011_no_people_in_household_have_en_9353ff69" BIGINT -- Household Language (2011);No People In Household Have English As A Main Language;,
"household_language_2011_of_people_aged_16_and_over_in__6fad1aa2" DOUBLE -- Household Language (2011);% Of People Aged 16 And Over In Household Have English As A Main Language;,
"household_language_2011_of_households_where_no_people__826e8425" DOUBLE -- Household Language (2011);% Of Households Where No People In Household Have English As A Main Language;,
"religion_2011_christian" BIGINT -- Religion (2011);Christian;,
"religion_2011_buddhist" BIGINT -- Religion (2011);Buddhist;,
"religion_2011_hindu" BIGINT -- Religion (2011);Hindu;,
"religion_2011_jewish" BIGINT -- Religion (2011);Jewish;,
"religion_2011_muslim" BIGINT -- Religion (2011);Muslim;,
"religion_2011_sikh" BIGINT -- Religion (2011);Sikh;,
"religion_2011_other_religion" BIGINT -- Religion (2011);Other Religion;,
"religion_2011_no_religion" BIGINT -- Religion (2011);No Religion;,
"religion_2011_religion_not_stated" BIGINT -- Religion (2011);Religion Not Stated;,
"religion_2011_christian_6f9c25" DOUBLE -- Religion (2011);Christian (%);,
"religion_2011_buddhist_82c695" DOUBLE -- Religion (2011);Buddhist (%);,
"religion_2011_hindu_26fd5d" DOUBLE -- Religion (2011);Hindu (%);,
"religion_2011_jewish_f8d8bd" DOUBLE -- Religion (2011);Jewish (%);,
"religion_2011_muslim_1bec6f" DOUBLE -- Religion (2011);Muslim (%);,
"religion_2011_sikh_014c16" DOUBLE -- Religion (2011);Sikh (%);,
"religion_2011_other_religion_e97ca8" DOUBLE -- Religion (2011);Other Religion (%);,
"religion_2011_no_religion_a13d94" DOUBLE -- Religion (2011);No Religion (%);,
"religion_2011_religion_not_stated_2ba52b" DOUBLE -- Religion (2011);Religion Not Stated (%);,
"tenure_2011_owned_owned_outright" BIGINT -- Tenure (2011);Owned: Owned Outright;,
"tenure_2011_owned_owned_with_a_mortgage_or_loan" BIGINT -- Tenure (2011);Owned: Owned With A Mortgage Or Loan;,
"tenure_2011_social_rented" BIGINT -- Tenure (2011);Social Rented;,
"tenure_2011_private_rented" BIGINT -- Tenure (2011);Private Rented;,
"tenure_2011_owned_owned_outright_32dea6" DOUBLE -- Tenure (2011);Owned: Owned Outright (%);,
"tenure_2011_owned_owned_with_a_mortgage_or_loan_6fdf37" DOUBLE -- Tenure (2011);Owned: Owned With A Mortgage Or Loan (%);,
"tenure_2011_social_rented_255e59" DOUBLE -- Tenure (2011);Social Rented (%);,
"tenure_2011_private_rented_284a1e" DOUBLE -- Tenure (2011);Private Rented (%);,
"dwelling_type_2011_household_spaces_with_at_least_one__e127504e" BIGINT -- Dwelling Type (2011);Household Spaces With At Least One Usual Resident;
);CREATE TABLE previous_msoa_boundaries_2001_2011 (
"middle_super_output_area_msoa_name_age_structure_2011_census" VARCHAR -- Middle Super Output Area,MSOA Name,Age Structure (2011 Census),
"all_ages" VARCHAR,
"n__age_structure_2011_census" VARCHAR -- ,Age Structure (2011 Census),
"n_0_15" VARCHAR -- 0-15,
"n__age_structure_2011_census_1" VARCHAR -- ,Age Structure (2011 Census).1,
"n_16_29" VARCHAR -- 16-29,
"n__age_structure_2011_census_2" VARCHAR -- ,Age Structure (2011 Census).2,
"n_30_44" VARCHAR -- 30-44,
"n__age_structure_2011_census_3" VARCHAR -- ,Age Structure (2011 Census).3,
"n_45_64" VARCHAR -- 45-64,
"n__age_structure_2011_census_4" VARCHAR -- ,Age Structure (2011 Census).4,
"n_65" VARCHAR -- 65+,
"n__age_structure_2011_census_5" VARCHAR -- ,Age Structure (2011 Census).5,
"working_age" VARCHAR,
"n__mid_year_estimate_totals" VARCHAR -- ,Mid-year Estimate Totals,
"all_ages_1" VARCHAR,
"n_2002_mid_year_estimate_totals" VARCHAR -- 2002,Mid-year Estimate Totals,
"all_ages_2" VARCHAR,
"n_2003_mid_year_estimate_totals" VARCHAR -- 2003,Mid-year Estimate Totals,
"all_ages_3" VARCHAR,
"n_2004_mid_year_estimate_totals" VARCHAR -- 2004,Mid-year Estimate Totals,
"all_ages_4" VARCHAR,
"n_2005_mid_year_estimate_totals" VARCHAR -- 2005,Mid-year Estimate Totals,
"all_ages_5" VARCHAR,
"n_2006_mid_year_estimate_totals" VARCHAR -- 2006,Mid-year Estimate Totals,
"all_ages_6" VARCHAR,
"n_2007_mid_year_estimate_totals" VARCHAR -- 2007,Mid-year Estimate Totals,
"all_ages_7" VARCHAR,
"n_2008_mid_year_estimate_totals" VARCHAR -- 2008,Mid-year Estimate Totals,
"all_ages_8" VARCHAR,
"n_2009_mid_year_estimate_totals" VARCHAR -- 2009,Mid-year Estimate Totals,
"all_ages_9" VARCHAR,
"n_2010_mid_year_estimate_totals" VARCHAR -- 2010,Mid-year Estimate Totals,
"all_ages_10" VARCHAR,
"n_2011_mid_year_estimate_totals" VARCHAR -- 2011,Mid-year Estimate Totals,
"all_ages_11" VARCHAR,
"n_2012_mid_year_estimates_2012_by_age" VARCHAR -- 2012,"Mid-year Estimates 2012, By Age,
"n__0_to_14" VARCHAR -- % 0 To 14,
"n__mid_year_estimates_2012_by_age" VARCHAR -- ,Mid-year Estimates 2012, By Age,
"n__15_64" VARCHAR -- % 15-64,
"n__mid_year_estimates_2012_by_age_1" VARCHAR -- ,Mid-year Estimates 2012, By Age.1,
"n__65" VARCHAR -- % 65+,
"n__mid_year_estimates_2012_by_age_2" VARCHAR -- ,Mid-year Estimates 2012, By Age.2,
"n_0_4" VARCHAR -- 0-4,
"n__mid_year_estimates_2012_by_age_3" VARCHAR -- ,Mid-year Estimates 2012, By Age.3,
"n_5_9" VARCHAR -- 5-9,
"n__mid_year_estimates_2012_by_age_4" VARCHAR -- ,Mid-year Estimates 2012, By Age.4,
"n_10_14" VARCHAR -- 10-14,
"n__mid_year_estimates_2012_by_age_5" VARCHAR -- ,Mid-year Estimates 2012, By Age.5,
"n_15_19" VARCHAR -- 15-19,
"n__mid_year_estimates_2012_by_age_6" VARCHAR -- ,Mid-year Estimates 2012, By Age.6,
"n_20_24" VARCHAR -- 20-24,
"n__mid_year_estimates_2012_by_age_7" VARCHAR -- ,Mid-year Estimates 2012, By Age.7,
"n_25_29" VARCHAR -- 25-29,
"n__mid_year_estimates_2012_by_age_8" VARCHAR -- ,Mid-year Estimates 2012, By Age.8,
"n_30_34" VARCHAR -- 30-34,
"n__mid_year_estimates_2012_by_age_9" VARCHAR -- ,Mid-year Estimates 2012, By Age.9,
"n_35_39" VARCHAR -- 35-39,
"n__mid_year_estimates_2012_by_age_10" VARCHAR -- ,Mid-year Estimates 2012, By Age.10,
"n_40_44" VARCHAR -- 40-44,
"n__mid_year_estimates_2012_by_age_11" VARCHAR -- ,Mid-year Estimates 2012, By Age.11,
"n_45_49" VARCHAR -- 45-49,
"n__mid_year_estimates_2012_by_age_12" VARCHAR -- ,Mid-year Estimates 2012, By Age.12,
"n_50_54" VARCHAR -- 50-54,
"n__mid_year_estimates_2012_by_age_13" VARCHAR -- ,Mid-year Estimates 2012, By Age.13,
"n_55_59" VARCHAR -- 55-59,
"n__mid_year_estimates_2012_by_age_14" VARCHAR -- ,Mid-year Estimates 2012, By Age.14,
"n_60_64" VARCHAR -- 60-64,
"n__mid_year_estimates_2012_by_age_15" VARCHAR -- ,Mid-year Estimates 2012, By Age.15,
"n_65_69" VARCHAR -- 65-69,
"n__mid_year_estimates_2012_by_age_16" VARCHAR -- ,Mid-year Estimates 2012, By Age.16,
"n_70_74" VARCHAR -- 70-74,
"n__mid_year_estimates_2012_by_age_17" VARCHAR -- ,Mid-year Estimates 2012, By Age.17,
"n_75_79" VARCHAR -- 75-79,
"n__mid_year_estimates_2012_by_age_18" VARCHAR -- ,Mid-year Estimates 2012, By Age.18,
"n_80_84" VARCHAR -- 80-84,
"n__mid_year_estimates_2012_by_age_19" VARCHAR -- ,Mid-year Estimates 2012, By Age.19,
"n_85" VARCHAR -- 85+,
"n__households_2011_all_households_household_compositio_8dff652e" VARCHAR -- ,Households (2011);All Households;,Household Composition (2011);Numbers;Couple Household With Dependent Children,Household Composition (2011);Numbers;Couple Household Without Dependent Children,Household Composition (2011);Numbers;Lone Parent Household,Household Composition (2011);Numbers;One Person Household,Household Composition (2011);Numbers;Other Household Types,Household Composition (2011);Percentages;Couple Household With Dependent Children,Household Composition (2011);Percentages;Couple Household Without Dependent Children,Household Composition (2011);Percentages;Lone Parent Household,Household Composition (2011);Percentages;One Person Household,Household Composition (2011);Percentages;Other Household Types,Ethnic Group (2011 Census);White;,Ethnic Group (2011 Census);Mixed/multiple Ethnic Groups;,Ethnic Group (2011 Census);Asian/Asian British;,Ethnic Group (2011 Census);Black/African/Caribbean/Black British;,Ethnic Group (2011 Census);Other Ethnic Group;,Ethnic Group (2011 Census);BAME (%);,Country Of Birth (2011);United Kingdom;,Country Of Birth (2011);% United Kingdom;,Country Of Birth (2011);% Not United Kingdom;,Household Language (2011);% Of People Aged 16 And Over In Household Have English As A Main Language;,Household Language (2011);% Of Households Where No People In Household Have English As A Main Language;,Religion (2011);Christian (%);,Religion (2011);Buddhist (%);,Religion (2011);Hindu (%);,Religion (2011);Jewish (%);,Religion (2011);Muslim (%);,Religion (2011);Sikh (%);,Religion (2011);Other Religion (%);,Religion (2011);No Religion (%);,Religion (2011);Religion Not Stated (%);,Tenure (2011);Owned: Owned Outright (%);,Tenure (2011);Owned: Owned With A Mortgage Or Loan (%);,Tenure (2011);Social Rented (%);,Tenure (2011);Private Rented (%);,Dwelling Type (2011);All Households;,Dwelling Type (2011);Household Spaces With At Least One Usual Resident (%);,Dwelling Type (2011);Household Spaces With No Usual Residents (%);,Dwelling Type (2011);Whole House Or Bungalow: Detached (%);,Dwelling Type (2011);Whole House Or Bungalow: Semi-detached (%);,Dwelling Type (2011);Whole House Or Bungalow: Terraced (including End-terrace) (%);,Dwelling Type (2011),
"flat_maisonette_or_apartment" VARCHAR -- Flat, Maisonette Or Apartment (%),
"n__land_area_square_metres_m2_thousands_2005_land_area_999ef9ef" VARCHAR -- ,Land Area;Square Metres (m2)(thousands);2005,Land Area;Hectares;2005,Population Density;Persons Per Hectare (2011);,Births;All Live Births;2004,Births;All Live Births;2005,Births;All Live Births;2006,Births;All Live Births;2007,Births;All Live Births;2008,Births;All Live Births;2009,Births;All Live Births;2010,General Fertility Rate,
"gfr_births_per_1_000_15_44_females" VARCHAR -- GFR (births Per 1,000–15-44 Females),
"n_2004_general_fertility_rate" VARCHAR -- 2004","General Fertility Rate,
"gfr_births_per_1_000_15_44_females_1" VARCHAR -- GFR (births Per 1,000–15-44 Females).1,
"n_2005_general_fertility_rate" VARCHAR -- 2005","General Fertility Rate,
"gfr_births_per_1_000_15_44_females_2" VARCHAR -- GFR (births Per 1,000–15-44 Females).2,
"n_2006_general_fertility_rate" VARCHAR -- 2006","General Fertility Rate,
"gfr_births_per_1_000_15_44_females_3" VARCHAR -- GFR (births Per 1,000–15-44 Females).3,
"n_2007_general_fertility_rate" VARCHAR -- 2007","General Fertility Rate,
"gfr_births_per_1_000_15_44_females_4" VARCHAR -- GFR (births Per 1,000–15-44 Females).4,
"n_2008_general_fertility_rate" VARCHAR -- 2008","General Fertility Rate,
"gfr_births_per_1_000_15_44_females_5" VARCHAR -- GFR (births Per 1,000–15-44 Females).5,
"n_2009_general_fertility_rate" VARCHAR -- 2009","General Fertility Rate,
"gfr_births_per_1_000_15_44_females_6" VARCHAR -- GFR (births Per 1,000–15-44 Females).6,
"n_2010_deaths" VARCHAR -- 2010",Deaths,
"all_deaths" VARCHAR,
"n_2004_deaths" VARCHAR -- 2004,Deaths,
"all_deaths_1" VARCHAR,
"n_2005_deaths" VARCHAR -- 2005,Deaths,
"all_deaths_2" VARCHAR
);Anyone who has the link will be able to view this.