LSOA Atlas
Greater London Authority
@ukgov.lsoa_atlas
Greater London Authority
@ukgov.lsoa_atlas
CREATE TABLE current_lsoa_boundaries_post_2011 (
"lower_super_output_area_names_mid_year_population_estimates" VARCHAR,
"all_ages" VARCHAR,
"n_2001_mid_year_population_estimates" VARCHAR,
"all_ages_1" VARCHAR,
"n_2002_mid_year_population_estimates" VARCHAR,
"all_ages_2" VARCHAR,
"n_2003_mid_year_population_estimates" VARCHAR,
"all_ages_3" VARCHAR,
"n_2004_mid_year_population_estimates" VARCHAR,
"all_ages_4" VARCHAR,
"n_2005_mid_year_population_estimates" VARCHAR,
"all_ages_5" VARCHAR,
"n_2006_mid_year_population_estimates" VARCHAR,
"all_ages_6" VARCHAR,
"n_2007_mid_year_population_estimates" VARCHAR,
"all_ages_7" VARCHAR,
"n_2008_mid_year_population_estimates" VARCHAR,
"all_ages_8" VARCHAR,
"n_2009_mid_year_population_estimates" VARCHAR,
"all_ages_9" VARCHAR,
"n_2010_mid_year_population_estimates" VARCHAR,
"all_ages_10" VARCHAR,
"n_2011_mid_year_population_estimates" VARCHAR,
"all_ages_11" VARCHAR,
"n_2012_mid_year_population_estimates" VARCHAR,
"all_ages_12" VARCHAR,
"n_2013_mid_year_population_estimates" VARCHAR,
"aged_0_15" VARCHAR,
"n_2001_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_1" VARCHAR,
"n_2002_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_2" VARCHAR,
"n_2003_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_3" VARCHAR,
"n_2004_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_4" VARCHAR,
"n_2005_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_5" VARCHAR,
"n_2006_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_6" VARCHAR,
"n_2007_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_7" VARCHAR,
"n_2008_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_8" VARCHAR,
"n_2009_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_9" VARCHAR,
"n_2010_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_10" VARCHAR,
"n_2011_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_11" VARCHAR,
"n_2012_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_12" VARCHAR,
"n_2013_mid_year_population_estimates_1" VARCHAR,
"aged_16_29" VARCHAR,
"n_2001_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_1" VARCHAR,
"n_2002_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_2" VARCHAR,
"n_2003_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_3" VARCHAR,
"n_2004_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_4" VARCHAR,
"n_2005_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_5" VARCHAR,
"n_2006_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_6" VARCHAR,
"n_2007_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_7" VARCHAR,
"n_2008_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_8" VARCHAR,
"n_2009_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_9" VARCHAR,
"n_2010_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_10" VARCHAR,
"n_2011_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_11" VARCHAR,
"n_2012_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_12" VARCHAR,
"n_2013_mid_year_population_estimates_2" VARCHAR,
"aged_30_44" VARCHAR,
"n_2001_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_1" VARCHAR,
"n_2002_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_2" VARCHAR,
"n_2003_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_3" VARCHAR,
"n_2004_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_4" VARCHAR,
"n_2005_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_5" VARCHAR,
"n_2006_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_6" VARCHAR,
"n_2007_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_7" VARCHAR,
"n_2008_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_8" VARCHAR,
"n_2009_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_9" VARCHAR,
"n_2010_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_10" VARCHAR
);
CREATE TABLE previous_lsoa_boundaries_2001_2011 (
"lower_super_output_area_names_mid_year_population_estimates" VARCHAR,
"all_ages" VARCHAR,
"n_2001_mid_year_population_estimates" VARCHAR,
"all_ages_1" VARCHAR,
"n_2002_mid_year_population_estimates" VARCHAR,
"all_ages_2" VARCHAR,
"n_2003_mid_year_population_estimates" VARCHAR,
"all_ages_3" VARCHAR,
"n_2004_mid_year_population_estimates" VARCHAR,
"all_ages_4" VARCHAR,
"n_2005_mid_year_population_estimates" VARCHAR,
"all_ages_5" VARCHAR,
"n_2006_mid_year_population_estimates" VARCHAR,
"all_ages_6" VARCHAR,
"n_2007_mid_year_population_estimates" VARCHAR,
"all_ages_7" VARCHAR,
"n_2008_mid_year_population_estimates" VARCHAR,
"all_ages_8" VARCHAR,
"n_2009_mid_year_population_estimates" VARCHAR,
"all_ages_9" VARCHAR,
"n_2010_mid_year_population_estimates" VARCHAR,
"all_ages_10" VARCHAR,
"n_2011_mid_year_population_estimates" VARCHAR,
"all_ages_11" VARCHAR,
"n_2012_mid_year_population_estimates" VARCHAR,
"aged_0_15" VARCHAR,
"n_2001_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_1" VARCHAR,
"n_2002_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_2" VARCHAR,
"n_2003_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_3" VARCHAR,
"n_2004_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_4" VARCHAR,
"n_2005_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_5" VARCHAR,
"n_2006_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_6" VARCHAR,
"n_2007_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_7" VARCHAR,
"n_2008_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_8" VARCHAR,
"n_2009_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_9" VARCHAR,
"n_2010_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_10" VARCHAR,
"n_2011_mid_year_population_estimates_1" VARCHAR,
"aged_0_15_11" VARCHAR,
"n_2012_mid_year_population_estimates_1" VARCHAR,
"aged_16_29" VARCHAR,
"n_2001_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_1" VARCHAR,
"n_2002_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_2" VARCHAR,
"n_2003_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_3" VARCHAR,
"n_2004_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_4" VARCHAR,
"n_2005_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_5" VARCHAR,
"n_2006_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_6" VARCHAR,
"n_2007_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_7" VARCHAR,
"n_2008_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_8" VARCHAR,
"n_2009_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_9" VARCHAR,
"n_2010_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_10" VARCHAR,
"n_2011_mid_year_population_estimates_2" VARCHAR,
"aged_16_29_11" VARCHAR,
"n_2012_mid_year_population_estimates_2" VARCHAR,
"aged_30_44" VARCHAR,
"n_2001_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_1" VARCHAR,
"n_2002_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_2" VARCHAR,
"n_2003_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_3" VARCHAR,
"n_2004_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_4" VARCHAR,
"n_2005_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_5" VARCHAR,
"n_2006_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_6" VARCHAR,
"n_2007_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_7" VARCHAR,
"n_2008_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_8" VARCHAR,
"n_2009_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_9" VARCHAR,
"n_2010_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_10" VARCHAR,
"n_2011_mid_year_population_estimates_3" VARCHAR,
"aged_30_44_11" VARCHAR,
"n_2012_mid_year_population_estimates_3" VARCHAR,
"aged_45_64" VARCHAR,
"n_2001_mid_year_population_estimates_4" VARCHAR,
"aged_45_64_1" VARCHAR
);
Anyone who has the link will be able to view this.