UC Claimants By Ward By Month

Leicester City Council

@ukgov.uc_claimants_by_ward_by_month

Table List

1 table(199.96 KB)

Table 1

@ukgov.uc_claimants_by_ward_by_month.table_1

UC Claimants By Ward By Month (csv)

199.96 KB
21 rows
79 columns

ward_name Ward Name	jan_16 Jan 16	feb_16 Feb 16	mar_16 Mar 16	apr_16 Apr 16	may_16 May 16	jun_16 Jun 16	jul_16 Jul 16	aug_16 Aug 16	sep_16 Sep 16	oct_16 Oct 16	nov_16 Nov 16	dec_16 Dec 16	jan_17 Jan 17	feb_17 Feb 17	mar_17 Mar 17	apr_17 Apr 17	may_17 May 17	jun_17 Jun 17	jul_17 Jul 17	aug_17 Aug 17	sep_17 Sep 17	oct_17 Oct 17	nov_17 Nov 17	dec_17 Dec 17	jan_18 Jan 18	feb_18 Feb 18	mar_18 Mar 18	apr_18 Apr 18	may_18 May 18	jun_18 Jun 18	jul_18 Jul 18	aug_18 Aug 18	sep_18 Sep 18	oct_18 Oct 18	nov_18 Nov 18	dec_18 Dec 18	jan_19 Jan 19	feb_19 Feb 19	mar_19 Mar 19	apr_19 Apr 19	may_19 May 19	jun_19 Jun 19	jul_19 Jul 19	aug_19 Aug 19	sep_19 Sep 19	oct_19 Oct 19	nov_19 Nov 19	dec_19 Dec 19	jan_20 Jan 20	feb_20 Feb 20	mar_20 Mar 20	apr_20 Apr 20	may_20 May 20	jun_20 Jun 20	jul_20 Jul 20	aug_20 Aug 20	sep_20 Sep 20	oct_20 Oct 20	nov_20 Nov 20	dec_20 Dec 20	jan_21 Jan 21	feb_21 Feb 21	mar_21 Mar 21	apr_21 Apr 21	may_21 May 21	jun_21 Jun 21	jul_21 Jul 21	aug_21 Aug 21	sep_21 Sep 21	oct_21 Oct 21	nov_21 Nov 21	dec_21 Dec 21	jan_22 Jan 22	geo_shape Geo Shape	geo_point_2d Geo Point 2d
Aylestone Ward		5	11	16	21	23	26	30	38	40	42	41	43	55	59	55	58	60	68	65	68	66	63	65	67	67	63	65	59	63	87	120	151	202	237	267	289	314	316	364	362	401	443	469	481	491	509	532	542	557	595	851	1073	1099	1113	1116	1115	1133	1135	1156	1179	1197	1218	1210	1207	1221	1238	1240	1241	1260	1254	1212	1213	{"coordinates": [[[-1.1490092893, 52.6167756012], [-1.1495012844, 52.6167701418], [-1.1494984473, 52.6167656264], [-1.1494111472, 52.6166202161], [-1.1492606276, 52.616538253], [-1.1491851796, 52.6164658095], [-1.1491600696, 52.6163918393], [-1.1491572012, 52.6163828377], [-1.1491475412, 52.61635310…	52.6027924019236, -1.1545147264775726
Belgrave Ward		6	22	27	37	43	57	62	72	77	77	83	84	83	84	83	90	86	91	94	97	96	92	90	93	88	82	79	72	67	109	170	227	286	360	424	475	515	513	570	607	655	693	743	777	854	916	936	964	1025	1053	1379	1770	1905	2006	2125	2215	2241	2268	2341	2363	2408	2451	2489	2481	2507	2512	2490	2517	2508	2489	2473	2505	{"coordinates": [[[-1.1268507766, 52.6629817732], [-1.1269516171, 52.6628890453], [-1.1273483934, 52.6624937212], [-1.1275777151, 52.6622661423], [-1.127839416, 52.6619686869], [-1.1279957005, 52.6617666321], [-1.1281016169, 52.6616451811], [-1.1281514119, 52.6615197209], [-1.1282936063, 52.66113681…	52.65021238248996, -1.1196976874090476
Braunstone Park & Rowley Fields Ward		10	31	43	62	72	86	102	111	119	121	129	134	132	137	136	136	142	150	156	165	168	169	180	177	173	171	159	148	143	216	282	397	444	534	640	674	745	831	888	976	1052	1093	1158	1220	1251	1287	1321	1328	1429	1501	2019	2470	2633	2716	2748	2816	2868	2927	2999	2997	3055	3113	3148	3142	3152	3124	3102	3074	3080	3043	3009	3053	{"coordinates": [[[-1.1640476642, 52.6094532243], [-1.1639736048, 52.6094670771], [-1.1635385787, 52.6088895265], [-1.1630382771, 52.6082486129], [-1.1626589133, 52.6077802973], [-1.1622896409, 52.6080923384], [-1.162135426, 52.6082044866], [-1.1620305954, 52.6082801336], [-1.1619455689, 52.60832087…	52.622449420512815, -1.1711065463981896
Castle Ward	6	8	21	33	47	53	70	76	86	96	106	113	117	135	131	146	147	146	151	154	165	164	174	164	165	160	149	136	143	137	193	250	317	386	458	539	579	620	612	655	686	715	763	796	806	818	871	883	885	965	1026	1382	1662	1723	1785	1852	1893	1893	1944	2009	2025	2018	2051	2036	2075	2056	2052	2025	1993	2019	2006	1965	1992	{"coordinates": [[[-1.1425721799, 52.628750672], [-1.1422665693, 52.6287367825], [-1.1421291338, 52.6287375857], [-1.141697926, 52.6288045592], [-1.1412457743, 52.6288839744], [-1.1412069697, 52.6288252757], [-1.1412150849, 52.6287902823], [-1.1412275903, 52.6287544216], [-1.1411995334, 52.628750622…	52.625836577742824, -1.127020065054764
Wycliffe Ward		5	16	19	24	40	46	55	66	74	78	79	77	86	89	97	97	96	97	100	100	102	99	99	91	92	80	76	67	59	119	180	254	312	370	440	477	533	558	648	661	735	774	841	857	906	941	998	1014	1057	1106	1348	1613	1701	1788	1874	1921	1970	2016	2083	2112	2132	2172	2201	2220	2276	2265	2260	2253	2245	2241	2245	2266	{"coordinates": [[[-1.1295661421, 52.6412734228], [-1.1295147848, 52.6412577714], [-1.129328544, 52.6411800055], [-1.1291602457, 52.6411014812], [-1.1290180322, 52.6410401306], [-1.1288703192, 52.6409617481], [-1.1284660696, 52.6407808262], [-1.1279096472, 52.6405186995], [-1.1277297375, 52.64042381…	52.63720171418088, -1.11883627454216
Beaumont Leys Ward		12	19	37	49	56	78	85	98	104	100	103	105	116	126	130	133	137	151	148	155	161	161	163	166	159	143	139	132	129	178	240	305	376	440	505	535	599	629	727	774	848	882	938	999	1059	1139	1148	1165	1254	1314	1741	2054	2145	2204	2264	2307	2354	2387	2404	2411	2454	2487	2482	2489	2490	2492	2487	2459	2457	2436	2444	2447	{"coordinates": [[[-1.156722128, 52.6442917913], [-1.1567111813, 52.644322271], [-1.1566125355, 52.6445346632], [-1.1564432852, 52.6448822685], [-1.1563633156, 52.6450425785], [-1.1565178008, 52.6450824079], [-1.1567456559, 52.6451406588], [-1.1569965818, 52.6452359151], [-1.1572032453, 52.645331755…	52.669273626214995, -1.1623898121881806
Rushey Mead Ward		6	19	35	39	45	60	72	75	78	92	92	93	88	92	92	87	94	90	94	104	108	106	103	105	101	95	89	80	72	106	149	198	235	278	325	348	386	412	457	481	516	537	573	604	644	657	664	671	744	775	1084	1407	1522	1599	1662	1711	1748	1777	1827	1818	1863	1886	1909	1918	1919	1905	1883	1890	1902	1895	1848	1868	{"coordinates": [[[-1.1268507766, 52.6629817732], [-1.125904611, 52.6620829547], [-1.124534801, 52.6607836608], [-1.1244648498, 52.6608074085], [-1.1244410349, 52.6608153237], [-1.1244454794, 52.6608126595], [-1.124436526, 52.6608152904], [-1.124373978, 52.6608399917], [-1.1242457952, 52.6608921674]…	52.66219053638568, -1.1103929405898738
Saffron Ward		6	23	31	38	44	57	67	79	91	97	97	99	104	102	103	96	95	107	103	98	96	101	99	98	89	82	79	75	74	113	150	227	281	327	400	439	474	518	563	611	638	686	730	782	829	880	907	928	980	1009	1358	1620	1679	1697	1755	1791	1825	1854	1881	1898	1912	1936	1944	1972	1992	1997	2015	1979	1971	1946	1933	1941	{"coordinates": [[[-1.1268186321, 52.5971320407], [-1.1272798312, 52.5990404169], [-1.127797561, 52.6006965607], [-1.1283460804, 52.6023736055], [-1.1284311029, 52.6026295643], [-1.129320717, 52.6050544349], [-1.1297403389, 52.6063790258], [-1.1300329389, 52.6074904835], [-1.1303031168, 52.608831146…	52.61244734694372, -1.1367634142585432
Troon Ward		6	15	24	23	26	34	43	45	61	66	59	65	68	65	68	72	72	73	80	77	78	78	76	66	65	66	63	61	58	89	139	191	239	260	319	337	354	388	407	440	459	485	499	533	566	598	613	616	670	689	999	1269	1354	1411	1451	1485	1549	1590	1602	1609	1614	1646	1643	1650	1633	1642	1632	1609	1615	1604	1588	1598	{"coordinates": [[[-1.10557665, 52.648615939], [-1.1048573651, 52.6483704531], [-1.1043187277, 52.6481830382], [-1.1036362461, 52.6479441073], [-1.1034144288, 52.6481654111], [-1.1031589287, 52.6481562854], [-1.1027930637, 52.6480491674], [-1.1026461076, 52.648005819], [-1.1024580985, 52.6479504633]…	52.65827464757919, -1.087521627703207
Western Ward		13	32	52	60	72	87	90	111	125	141	141	139	145	154	158	154	153	160	155	161	158	166	169	162	159	146	137	128	120	186	259	343	424	510	593	633	729	822	886	933	1022	1067	1136	1188	1244	1310	1369	1347	1439	1495	1980	2361	2453	2527	2541	2607	2679	2729	2764	2763	2807	2818	2824	2827	2816	2800	2782	2803	2816	2827	2820	2858	{"coordinates": [[[-1.1605575149, 52.626969054], [-1.1603761437, 52.6271789727], [-1.1603373733, 52.6272758537], [-1.1603296553, 52.6273674708], [-1.1603665734, 52.627450423], [-1.1604286441, 52.6275237453], [-1.1605115823, 52.6275944374], [-1.1609341494, 52.6278249059], [-1.1608200146, 52.627920264…	52.63855846923718, -1.1841856673355236


CREATE TABLE table_1 (
  "ward_name" VARCHAR,
  "oct_15" VARCHAR,
  "nov_15" DOUBLE,
  "dec_15" VARCHAR,
  "jan_16" DOUBLE,
  "feb_16" DOUBLE,
  "mar_16" BIGINT,
  "apr_16" BIGINT,
  "may_16" BIGINT,
  "jun_16" BIGINT,
  "jul_16" BIGINT,
  "aug_16" BIGINT,
  "sep_16" BIGINT,
  "oct_16" BIGINT,
  "nov_16" BIGINT,
  "dec_16" BIGINT,
  "jan_17" BIGINT,
  "feb_17" BIGINT,
  "mar_17" BIGINT,
  "apr_17" BIGINT,
  "may_17" BIGINT,
  "jun_17" BIGINT,
  "jul_17" BIGINT,
  "aug_17" BIGINT,
  "sep_17" BIGINT,
  "oct_17" BIGINT,
  "nov_17" BIGINT,
  "dec_17" BIGINT,
  "jan_18" BIGINT,
  "feb_18" BIGINT,
  "mar_18" BIGINT,
  "apr_18" BIGINT,
  "may_18" BIGINT,
  "jun_18" BIGINT,
  "jul_18" BIGINT,
  "aug_18" BIGINT,
  "sep_18" BIGINT,
  "oct_18" BIGINT,
  "nov_18" BIGINT,
  "dec_18" BIGINT,
  "jan_19" BIGINT,
  "feb_19" BIGINT,
  "mar_19" BIGINT,
  "apr_19" BIGINT,
  "may_19" BIGINT,
  "jun_19" BIGINT,
  "jul_19" BIGINT,
  "aug_19" BIGINT,
  "sep_19" BIGINT,
  "oct_19" BIGINT,
  "nov_19" BIGINT,
  "dec_19" BIGINT,
  "jan_20" BIGINT,
  "feb_20" BIGINT,
  "mar_20" BIGINT,
  "apr_20" BIGINT,
  "may_20" BIGINT,
  "jun_20" BIGINT,
  "jul_20" BIGINT,
  "aug_20" BIGINT,
  "sep_20" BIGINT,
  "oct_20" BIGINT,
  "nov_20" BIGINT,
  "dec_20" BIGINT,
  "jan_21" BIGINT,
  "feb_21" BIGINT,
  "mar_21" BIGINT,
  "apr_21" BIGINT,
  "may_21" BIGINT,
  "jun_21" BIGINT,
  "jul_21" BIGINT,
  "aug_21" BIGINT,
  "sep_21" BIGINT,
  "oct_21" BIGINT,
  "nov_21" BIGINT,
  "dec_21" BIGINT,
  "jan_22" BIGINT,
  "geo_shape" VARCHAR,
  "geo_point_2d" VARCHAR
);