Ward Profiles And Atlas

Greater London Authority

@ukgov.ward_profiles_and_atlas

Table List

2 tables(3.82 MB)

Ward-atlas-data

@ukgov.ward_profiles_and_atlas.ward_atlas_data

3.64 MB
629 rows
946 columns
Only the first 100 columns are shown

unnamed_0 Unnamed: 0	unnamed_1 Unnamed: 1	unnamed_2 Unnamed: 2	unnamed_3 Unnamed: 3	population_and_age_population_estimates_and_projections_2001 Population And Age; Population Estimates And Projections; 2001	population_and_age_population_estimates_and_projections_2006 Population And Age; Population Estimates And Projections; 2006	population_and_age_population_estimates_and_projections_2011 Population And Age; Population Estimates And Projections; 2011	population_and_age_population_estimates_and_projections_2013 Population And Age; Population Estimates And Projections; 2013	population_and_age_population_estimates_and_projections_2014 Population And Age; Population Estimates And Projections; 2014	population_and_age_population_estimates_and_projections_2015 Population And Age; Population Estimates And Projections; 2015	population_and_age_population_estimates_and_projections_2016 Population And Age; Population Estimates And Projections; 2016	population_and_age_population_estimates_and_projections_2018 Population And Age; Population Estimates And Projections; 2018	population_and_age_population_estimates_and_projections_2023 Population And Age; Population Estimates And Projections; 2023	population_and_age_population_estimates_and_projections_2028 Population And Age; Population Estimates And Projections; 2028	population_and_age_age_structure_percentage_2013_aged_0_15 Population And Age; Age Structure (percentage) - 2013; Aged 0-15	population_and_age_age_structure_percentage_2013_aged_16_64 Population And Age; Age Structure (percentage) - 2013; Aged 16-64	population_and_age_age_structure_percentage_2013_aged_65 Population And Age; Age Structure (percentage) - 2013; Aged 65+	population_and_age_aged_0_15_2002 Population And Age; Aged 0-15; 2002	population_and_age_aged_0_15_2004 Population And Age; Aged 0-15; 2004	population_and_age_aged_0_15_2006 Population And Age; Aged 0-15; 2006	population_and_age_aged_0_15_2008 Population And Age; Aged 0-15; 2008	population_and_age_aged_0_15_2010 Population And Age; Aged 0-15; 2010	population_and_age_aged_0_15_2011 Population And Age; Aged 0-15; 2011	population_and_age_aged_0_15_2012 Population And Age; Aged 0-15; 2012	population_and_age_aged_0_15_2013 Population And Age; Aged 0-15; 2013	population_and_age_aged_16_64_2002 Population And Age; Aged 16-64; 2002	population_and_age_aged_16_64_2004 Population And Age; Aged 16-64; 2004	population_and_age_aged_16_64_2006 Population And Age; Aged 16-64; 2006	population_and_age_aged_16_64_2008 Population And Age; Aged 16-64; 2008	population_and_age_aged_16_64_2010 Population And Age; Aged 16-64; 2010	population_and_age_aged_16_64_2011 Population And Age; Aged 16-64; 2011	population_and_age_aged_16_64_2012 Population And Age; Aged 16-64; 2012	population_and_age_aged_16_64_2013 Population And Age; Aged 16-64; 2013	population_and_age_aged_65_2002 Population And Age; Aged 65+; 2002	population_and_age_aged_65_2004 Population And Age; Aged 65+; 2004	population_and_age_aged_65_2006 Population And Age; Aged 65+; 2006	population_and_age_aged_65_2008 Population And Age; Aged 65+; 2008	population_and_age_aged_65_2010 Population And Age; Aged 65+; 2010	population_and_age_aged_65_2011 Population And Age; Aged 65+; 2011	population_and_age_aged_65_2012 Population And Age; Aged 65+; 2012	population_and_age_aged_65_2013 Population And Age; Aged 65+; 2013	population_and_age_all_ages_2002 Population And Age; All Ages; 2002	population_and_age_all_ages_2004 Population And Age; All Ages; 2004	population_and_age_all_ages_2006 Population And Age; All Ages; 2006	population_and_age_all_ages_2008 Population And Age; All Ages; 2008	population_and_age_all_ages_2010 Population And Age; All Ages; 2010	population_and_age_all_ages_2011 Population And Age; All Ages; 2011	population_and_age_all_ages_2012 Population And Age; All Ages; 2012	population_and_age_all_ages_2013 Population And Age; All Ages; 2013	population_and_age_mean_age_2002 Population And Age; Mean Age; 2002	population_and_age_mean_age_2004 Population And Age; Mean Age; 2004	population_and_age_mean_age_2006 Population And Age; Mean Age; 2006	population_and_age_mean_age_2008 Population And Age; Mean Age; 2008	population_and_age_mean_age_2010 Population And Age; Mean Age; 2010	population_and_age_mean_age_2011 Population And Age; Mean Age; 2011	population_and_age_mean_age_2012 Population And Age; Mean Age; 2012	population_and_age_mean_age_2013 Population And Age; Mean Age; 2013	population_and_age_median_age_2002 Population And Age; Median Age; 2002	population_and_age_median_age_2004 Population And Age; Median Age; 2004	population_and_age_median_age_2006 Population And Age; Median Age; 2006	population_and_age_median_age_2008 Population And Age; Median Age; 2008	population_and_age_median_age_2010 Population And Age; Median Age; 2010	population_and_age_median_age_2011 Population And Age; Median Age; 2011	population_and_age_median_age_2012 Population And Age; Median Age; 2012	population_and_age_median_age_2013 Population And Age; Median Age; 2013	area_and_density_area_hectares Area And Density; Area; Hectares	area_and_density_area_square_kilometres Area And Density; Area; Square Kilometres	area_and_density_population_density_persons_per_sq_km__c1a83919 Area And Density; Population Density (persons Per Sq Km); 2001 (Census)	area_and_density_population_density_persons_per_sq_km_2006 Area And Density; Population Density (persons Per Sq Km); 2006	area_and_density_population_density_persons_per_sq_km__9a4526cb Area And Density; Population Density (persons Per Sq Km); 2011 (Census)	area_and_density_population_density_persons_per_sq_km_2013 Area And Density; Population Density (persons Per Sq Km); 2013	area_and_density_population_density_persons_per_sq_km_2018 Area And Density; Population Density (persons Per Sq Km); 2018	area_and_density_population_density_persons_per_sq_km_2023 Area And Density; Population Density (persons Per Sq Km); 2023	area_and_density_population_density_persons_per_sq_km_2028 Area And Density; Population Density (persons Per Sq Km); 2028	diversity_ethnic_group_5_groups_2011_census_white Diversity; Ethnic Group 5 Groups - 2011 Census; White	diversity_ethnic_group_5_groups_2011_census_mixed Diversity; Ethnic Group 5 Groups - 2011 Census; Mixed	diversity_ethnic_group_5_groups_2011_census_asian_or_a_e8b77d9a Diversity; Ethnic Group 5 Groups - 2011 Census; Asian Or Asian British	diversity_ethnic_group_5_groups_2011_census_black_or_b_b104b278 Diversity; Ethnic Group 5 Groups - 2011 Census; Black Or Black British	diversity_ethnic_group_5_groups_2011_census_other Diversity; Ethnic Group 5 Groups - 2011 Census; Other	diversity_ethnic_group_18_groups_2011_census_white_british Diversity; Ethnic Group 18 Groups - 2011 Census; White British	diversity_ethnic_group_18_groups_2011_census_white_irish Diversity; Ethnic Group 18 Groups - 2011 Census; White Irish	diversity_ethnic_group_18_groups_2011_census_white_gyp_f523dc69 Diversity; Ethnic Group 18 Groups - 2011 Census; White Gypsy Or Irish Traveller	diversity_ethnic_group_18_groups_2011_census_other_white Diversity; Ethnic Group 18 Groups - 2011 Census; Other White	diversity_ethnic_group_18_groups_2011_census_mixed_whi_7a0bb14a Diversity; Ethnic Group 18 Groups - 2011 Census; Mixed White And Black Caribbean	diversity_ethnic_group_18_groups_2011_census_mixed_whi_a7e43bd8 Diversity; Ethnic Group 18 Groups - 2011 Census; Mixed White And Black African	diversity_ethnic_group_18_groups_2011_census_mixed_whi_5479e1e5 Diversity; Ethnic Group 18 Groups - 2011 Census; Mixed White And Asian	diversity_ethnic_group_18_groups_2011_census_other_mixed Diversity; Ethnic Group 18 Groups - 2011 Census; Other Mixed	diversity_ethnic_group_18_groups_2011_census_indian Diversity; Ethnic Group 18 Groups - 2011 Census; Indian	diversity_ethnic_group_18_groups_2011_census_pakistani Diversity; Ethnic Group 18 Groups - 2011 Census; Pakistani	diversity_ethnic_group_18_groups_2011_census_bangladeshi Diversity; Ethnic Group 18 Groups - 2011 Census; Bangladeshi	diversity_ethnic_group_18_groups_2011_census_chinese Diversity; Ethnic Group 18 Groups - 2011 Census; Chinese	diversity_ethnic_group_18_groups_2011_census_other_asian Diversity; Ethnic Group 18 Groups - 2011 Census; Other Asian	diversity_ethnic_group_18_groups_2011_census_black_caribbean Diversity; Ethnic Group 18 Groups - 2011 Census; Black Caribbean	diversity_ethnic_group_18_groups_2011_census_black_african Diversity; Ethnic Group 18 Groups - 2011 Census; Black African	diversity_ethnic_group_18_groups_2011_census_other_black Diversity; Ethnic Group 18 Groups - 2011 Census; Other Black	diversity_ethnic_group_18_groups_2011_census_arab Diversity; Ethnic Group 18 Groups - 2011 Census; Arab	diversity_ethnic_group_18_groups_2011_census_other_ethnic_group Diversity; Ethnic Group 18 Groups - 2011 Census; Other Ethnic Group	diversity_religion_2011_census_christian Diversity; Religion - 2011 Census; Christian	diversity_religion_2011_census_buddhist Diversity; Religion - 2011 Census; Buddhist	diversity_religion_2011_census_hindu Diversity; Religion - 2011 Census; Hindu
Codes	New Code	Borough	Names	2001	2006	2011	2013	2014	2015	2016	2018	2023	2028	Aged 0-15	Aged 16-64	Aged 65+	2002	2004	2006	2008	2010	2011	2012	2013	2002	2004	2006	2008	2010	2011	2012	2013	2002	2004	2006	2008	2010	2011	2012	2013	2002	2004	2006	2008	2010	2011	2012	2013	2002	2004	2006	2008	2010	2011	2012	2013	2002	2004	2006	2008	2010	2011	2012	2013	Hectares	Square Kilometres	2001 (Census)	2006	2011 (Census)	2013	2018	2023	2028	White	Mixed	Asian or Asian British	Black or Black British	Other	White British	White Irish	White Gypsy or Irish Traveller	Other White	Mixed White and Black Caribbean	Mixed White and Black African	Mixed White and Asian	Other Mixed	Indian	Pakistani	Bangladeshi	Chinese	Other Asian	Black Caribbean	Black African	Other Black	Arab	Other Ethnic Group	Christian	Buddhist	Hindu
00AA	E09000001	City of London	City of London	7350	7254	7400	7993	8043	8102	8285	8850	9950	10550	7.5	77.5	15	640	608	600	594	608	613	700	650	5682	5566	5696	5825	5691	5748	5798	6200	958	944	958	1010	1039	1051	1106	1150	7280	7118	7254	7429	7338	7412	7604	8000	40.92651099	41.37805563	41.64695341	41.88046843	41.87067321	41.57231516	41.42911625	41.3	38	38	39	40	40	39	40	39	315.1	3.2	2296.875	2265.625	2312.5	2406.25	2546.875	2640.625	2734.375	5799	289	940	193	154	4243	180	3	1373	38	37	111	103	216	16	232	263	213	98	46	49	69	85	3344	92	145
00ABFX	E05000026	Barking and Dagenham	Abbey	10350	10239	12900	13806	14283	14739	14986	15500	17350	18400	25.27472527	69.96336996	5.128205128	2503	2418	2402	2547	2963	3189	3405	3500	7417	7211	7100	7510	8428	9165	9444	9600	778	783	737	717	681	648	683	700	10698	10412	10239	10774	12072	13002	13532	13800	31.63871752	31.83595851	31.69127845	31.17969185	29.96611995	29.43277957	29.37991428	29.51057291	30	30	30	29	29	29	29	29	127.9	1.3	7961.538462	7884.615385	9884.615385	10500	12038.46154	13076.92308	13423.07692	3596	585	5619	2621	365	2025	75	31	1465	110	193	116	166	1699	2222	858	161	679	1965	385	271	115	250	4703	67	1186
00ABFY	E05000027	Barking and Dagenham	Alibon	9350	9236	10450	10527	10563	10587	10578	10550	10550	10600	25.96153846	63.46153846	10.57692308	2156	2143	2308	2540	2749	2760	2850	2750	5735	5655	5704	6092	6592	6620	6741	6700	1436	1349	1224	1154	1079	1082	1083	1100	9327	9147	9236	9786	10420	10462	10674	10550	36.84464458	36.65343829	35.59625379	34.28459023	33.39213052	33.49149302	33.38832678	33.82596154	36	36	35	33	32	32	32	33	136.1	1.4	6678.571429	6607.142857	7464.285714	7428.571429	7357.142857	7357.142857	7500	7275	362	743	1900	105	6362	101	3	809	127	114	58	63	119	114	246	62	202	1579	206	115	35	70	6389	54	64
00ABFZ	E05000028	Barking and Dagenham	Becontree	11550	11238	11650	12155	12428	12688	12962	13500	14100	14100	24.89626556	66.39004149	9.128630705	2797	2695	2732	2767	2882	2944	3144	3100	7432	7319	7293	7437	7350	7565	7812	7950	1259	1237	1213	1135	1107	1089	1080	1100	11488	11251	11238	11339	11339	11598	12036	12150	33.29178273	33.77646431	33.90701192	33.56504101	33.2334421	33.16709778	32.77592223	33.01416971	31	32	32	31	32	32	31	32	128.4	1.3	8884.615385	8653.846154	8923.076923	9269.230769	10076.92308	10576.92308	10692.30769	6789	524	2009	2048	175	5846	102	8	833	199	139	82	104	501	627	408	81	392	1505	383	160	43	132	6345	89	272
00ABGA	E05000029	Barking and Dagenham	Chadwell Heath	9400	9387	10100	10261	10337	10400	10483	10700	10950	11100	24.13793103	60.591133	15.27093596	2016	2092	2129	2241	2411	2462	2532	2500	5544	5566	5567	5664	5940	6023	6015	6250	1834	1743	1691	1615	1573	1556	1574	1550	9394	9401	9387	9520	9924	10041	10121	10250	38.78954652	38.31741304	38.11228294	37.42909664	36.6748287	36.55990439	36.40806244	36.24556912	37	36	36	35	34	34	34	34	338	3.4	2764.705882	2764.705882	2970.588235	2985.294118	3029.411765	3058.823529	3102.941176	6224	473	1560	1593	171	5521	120	2	581	158	149	65	101	529	370	307	64	290	939	477	177	49	122	5715	40	328
00ABGB	E05000030	Barking and Dagenham	Eastbrook	10200	10082	10600	10701	10741	10768	10755	10750	10850	11000	20.28301887	65.09433962	14.62264151	2189	2148	2214	2256	2257	2218	2358	2200	6402	6380	6232	6363	6724	6755	6839	6950	1633	1649	1636	1600	1558	1545	1570	1550	10224	10177	10082	10219	10539	10518	10767	10700	37.88487872	38.24624153	38.06070224	37.72609844	37.54018408	37.54097737	37.21890963	37.68606403	37	37	37	37	37	37	36	36	345.4	3.5	2914.285714	2885.714286	3014.285714	3028.571429	3014.285714	3014.285714	3100	7904	331	766	1451	54	7246	128	29	501	97	61	71	102	169	94	192	79	232	1142	222	87	15	39	6721	41	86
00ABGC	E05000031	Barking and Dagenham	Eastbury	10200	10452	11700	11816	11861	11901	11899	11900	12000	12050	25.64102564	64.52991453	9.829059829	2115	2329	2508	2824	3084	3129	3182	3050	6396	6513	6616	6743	7256	7447	7418	7600	1497	1407	1328	1197	1115	1119	1117	1150	10008	10249	10452	10764	11455	11695	11717	11800	37.28617106	36.33974046	35.5105243	33.87597547	33.0602357	32.98597691	32.84356064	33.3872097	35	34	34	32	31	32	31	32	144.5	1.4	7285.714286	7464.285714	8357.142857	8357.142857	8357.142857	8357.142857	8464.285714	6776	545	1826	2270	207	5535	69	8	1164	191	139	95	120	328	526	564	64	344	1744	310	216	84	123	6534	33	243
00ABGD	E05000032	Barking and Dagenham	Gascoigne	9500	10745	12550	14174	15018	15845	16265	17150	19450	20450	31.67259786	62.63345196	5.693950178	2562	2788	3130	3409	3805	3953	4110	4550	6296	6412	6795	7033	7558	7881	7943	8800	1011	893	820	790	762	756	751	800	9869	10093	10745	11232	12125	12590	12804	14150	32.19687912	31.28019419	30.33196836	29.97596154	29.17764948	29.07037331	28.91549516	28.97782989	30	30	29	29	29	28	28	29	113.4	1.1	8636.363636	9772.727273	11409.09091	12772.72727	16272.72727	18909.09091	20636.36364	4931	682	2574	3882	383	3241	62	11	1617	161	270	88	163	649	826	498	178	423	3212	311	359	180	203	5875	83	443
00ABGE	E05000033	Barking and Dagenham	Goresbrook	10400	10087	11350	11408	11437	11472	11445	11450	11450	11650	25.66371681	63.27433628	10.61946903	2574	2516	2580	2788	2941	3003	3011	3000	6438	6304	6334	6605	7106	7183	7211	7200	1325	1261	1173	1190	1134	1146	1199	1200	10337	10081	10087	10583	11181	11332	11421	11400	35.09732031	35.2586053	34.95518985	34.43239157	33.80860388	33.70049418	33.91270467	34.12867257	34	34	34	33	33	33	33	33	128	1.3	8000	7769.230769	8730.769231	8692.307692	8615.384615	8615.384615	8730.769231	7517	467	829	2344	110	6461	113	5	938	199	117	67	84	166	168	227	53	215	1905	252	187	46	64	6900	30	64


CREATE TABLE ward_atlas_data (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "population_and_age_population_estimates_and_projections_2001" BIGINT,
  "population_and_age_population_estimates_and_projections_2006" BIGINT,
  "population_and_age_population_estimates_and_projections_2011" BIGINT,
  "population_and_age_population_estimates_and_projections_2013" BIGINT,
  "population_and_age_population_estimates_and_projections_2014" BIGINT,
  "population_and_age_population_estimates_and_projections_2015" BIGINT,
  "population_and_age_population_estimates_and_projections_2016" BIGINT,
  "population_and_age_population_estimates_and_projections_2018" BIGINT,
  "population_and_age_population_estimates_and_projections_2023" BIGINT,
  "population_and_age_population_estimates_and_projections_2028" BIGINT,
  "population_and_age_age_structure_percentage_2013_aged_0_15" VARCHAR,
  "population_and_age_age_structure_percentage_2013_aged_16_64" VARCHAR,
  "population_and_age_age_structure_percentage_2013_aged_65" VARCHAR,
  "population_and_age_aged_0_15_2002" BIGINT,
  "population_and_age_aged_0_15_2004" BIGINT,
  "population_and_age_aged_0_15_2006" BIGINT,
  "population_and_age_aged_0_15_2008" BIGINT,
  "population_and_age_aged_0_15_2010" BIGINT,
  "population_and_age_aged_0_15_2011" BIGINT,
  "population_and_age_aged_0_15_2012" BIGINT,
  "population_and_age_aged_0_15_2013" BIGINT,
  "population_and_age_aged_16_64_2002" BIGINT,
  "population_and_age_aged_16_64_2004" BIGINT,
  "population_and_age_aged_16_64_2006" BIGINT,
  "population_and_age_aged_16_64_2008" BIGINT,
  "population_and_age_aged_16_64_2010" BIGINT,
  "population_and_age_aged_16_64_2011" BIGINT,
  "population_and_age_aged_16_64_2012" BIGINT,
  "population_and_age_aged_16_64_2013" BIGINT,
  "population_and_age_aged_65_2002" BIGINT,
  "population_and_age_aged_65_2004" BIGINT,
  "population_and_age_aged_65_2006" BIGINT,
  "population_and_age_aged_65_2008" BIGINT,
  "population_and_age_aged_65_2010" BIGINT,
  "population_and_age_aged_65_2011" BIGINT,
  "population_and_age_aged_65_2012" BIGINT,
  "population_and_age_aged_65_2013" BIGINT,
  "population_and_age_all_ages_2002" BIGINT,
  "population_and_age_all_ages_2004" BIGINT,
  "population_and_age_all_ages_2006" BIGINT,
  "population_and_age_all_ages_2008" BIGINT,
  "population_and_age_all_ages_2010" BIGINT,
  "population_and_age_all_ages_2011" BIGINT,
  "population_and_age_all_ages_2012" BIGINT,
  "population_and_age_all_ages_2013" BIGINT,
  "population_and_age_mean_age_2002" DOUBLE,
  "population_and_age_mean_age_2004" DOUBLE,
  "population_and_age_mean_age_2006" DOUBLE,
  "population_and_age_mean_age_2008" DOUBLE,
  "population_and_age_mean_age_2010" DOUBLE,
  "population_and_age_mean_age_2011" DOUBLE,
  "population_and_age_mean_age_2012" DOUBLE,
  "population_and_age_mean_age_2013" DOUBLE,
  "population_and_age_median_age_2002" BIGINT,
  "population_and_age_median_age_2004" BIGINT,
  "population_and_age_median_age_2006" BIGINT,
  "population_and_age_median_age_2008" BIGINT,
  "population_and_age_median_age_2010" BIGINT,
  "population_and_age_median_age_2011" BIGINT,
  "population_and_age_median_age_2012" BIGINT,
  "population_and_age_median_age_2013" BIGINT,
  "area_and_density_area_hectares" VARCHAR,
  "area_and_density_area_square_kilometres" VARCHAR,
  "area_and_density_population_density_persons_per_sq_km__c1a83919" VARCHAR,
  "area_and_density_population_density_persons_per_sq_km_2006" DOUBLE,
  "area_and_density_population_density_persons_per_sq_km__9a4526cb" VARCHAR,
  "area_and_density_population_density_persons_per_sq_km_2013" DOUBLE,
  "area_and_density_population_density_persons_per_sq_km_2018" DOUBLE,
  "area_and_density_population_density_persons_per_sq_km_2023" DOUBLE,
  "area_and_density_population_density_persons_per_sq_km_2028" DOUBLE,
  "diversity_ethnic_group_5_groups_2011_census_white" VARCHAR,
  "diversity_ethnic_group_5_groups_2011_census_mixed" VARCHAR,
  "diversity_ethnic_group_5_groups_2011_census_asian_or_a_e8b77d9a" VARCHAR,
  "diversity_ethnic_group_5_groups_2011_census_black_or_b_b104b278" VARCHAR,
  "diversity_ethnic_group_5_groups_2011_census_other" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_white_british" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_white_irish" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_white_gyp_f523dc69" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_other_white" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_mixed_whi_7a0bb14a" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_mixed_whi_a7e43bd8" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_mixed_whi_5479e1e5" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_other_mixed" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_indian" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_pakistani" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_bangladeshi" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_chinese" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_other_asian" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_black_caribbean" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_black_african" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_other_black" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_arab" VARCHAR,
  "diversity_ethnic_group_18_groups_2011_census_other_ethnic_group" VARCHAR,
  "diversity_religion_2011_census_christian" VARCHAR,
  "diversity_religion_2011_census_buddhist" VARCHAR,
  "diversity_religion_2011_census_hindu" VARCHAR
);