Community Support Grants By Ward 2019-21

Leicester City Council

@ukgov.community_support_grants_by_ward_2019_21

Table List

1 table(215.34 KB)

Table 1

@ukgov.community_support_grants_by_ward_2019_21.table_1

Community Support Grants by Ward 2019-21 (csv)

215.34 KB
21 rows
25 columns

ward Ward	n_2019_20 2019–20	n_2020_21 2020–21	change_num Change Num	n_2019_200 2019–200	n_2020_210 2020–210	change_value Change Value	n_2019_201 2019–201	n_18_pop_2019 18 Pop 2019	rate_per_1_000_1920 Rate Per 1–000 1920	lcl Lcl	ucl Ucl	lclfg Lclfg	uclfg Uclfg	sig_lei Sig Lei	n_2020_211 2020–211	n_18_pop_20190 18 Pop 20190	rate_per_1_000_2021 Rate Per 1–000 2021	lcl0 Lcl0	ucl0 Ucl0	lclfg0 Lclfg0	uclfg0 Uclfg0	sig_lei0 Sig Lei0	geo_shape Geo Shape	geo_point_2d Geo Point 2d
Aylestone	39	37	-5.128205128	4605.75	4748.92	3.1	39	8852	4.405784004	3.218988058	6.030135041	1.186795946	1.624351038		37	8852	4.179846362	3.028454657	5.768987021	1.151391705	1.589140659	L	{"coordinates": [[[-1.1640657318, 52.6094464804], [-1.1639945022, 52.6094591033], [-1.1638791759, 52.6093134964], [-1.1637213934, 52.6091073838], [-1.163566442, 52.6089062263], [-1.1634115562, 52.6087024711], [-1.1631665637, 52.6083838432], [-1.1631192609, 52.6083227546], [-1.1631153046, 52.60831958…	52.602779316492224, -1.1545145546789126
Braunstone Park & Rowley Fields	80	216	170	9215.88	29843.1	223.8	80	14949	5.35152853	4.298420222	6.662647236	1.053108309	1.311118706		216	14949	14.44912703	12.64513924	16.51047632	1.803987792	2.061349289	H	{"coordinates": [[[-1.1605652338, 52.6269512605], [-1.1601997666, 52.6267625426], [-1.1597792946, 52.6265455737], [-1.1594990746, 52.6264017606], [-1.1592600454, 52.6262772079], [-1.1589322884, 52.6261102306], [-1.1583346427, 52.6258020361], [-1.1575619343, 52.6254064971], [-1.1568758607, 52.6250483…	52.62243826065705, -1.171117309927036
Beaumont Leys	128	180	40.625	17115.59	26572.9	55.3	128	13040	9.81595092	8.25457462	11.672666	1.561376301	1.856715075	H	180	13040	13.80368098	11.92748642	15.9750011	1.876194562	2.171320115	H	{"coordinates": [[[-1.1567290627, 52.6442733121], [-1.1574559827, 52.6445949281], [-1.1580947499, 52.6448812212], [-1.1580947499, 52.6448812212], [-1.158359445, 52.6450011931], [-1.1589930167, 52.6452861858], [-1.1594743799, 52.6454962164], [-1.1597912584, 52.6456338158], [-1.1599276018, 52.64569877…	52.66925487115697, -1.1623965631110584
Humberstone & Hamilton	27	49	81.48148148	2592.98	4477.37	72.7	27	14543	1.856563295	1.273189172	2.707238912	0.583374123	0.850675616	L	49	14543	3.369318573	2.546476197	4.458045851	0.822842376	1.088727278	L	{"coordinates": [[[-1.0852842143, 52.6452664908], [-1.0850767175, 52.6452650691], [-1.0849613618, 52.6452741575], [-1.0848675328, 52.6453034507], [-1.0847337995, 52.6453992135], [-1.0845491903, 52.6455680046], [-1.0843260626, 52.6457431594], [-1.0841590634, 52.6458619397], [-1.0840145701, 52.6459476…	52.65227406073648, -1.0664162693684518
Spinney Hills	9	19	111.1111111	488.02	1416.94	190.3	9	9026	0.997119433	0.518809738	1.916400351	0.478309695	0.919280918	L	19	9026	2.105029914	1.342689698	3.300204764	0.762340216	1.19517485	L	{"coordinates": [[[-1.1078519135, 52.6357337912], [-1.1078214782, 52.6357088486], [-1.1077923452, 52.6356852642], [-1.1077610131, 52.6356630029], [-1.1077421633, 52.6356489354], [-1.1077217145, 52.635635746], [-1.1076851831, 52.6356112069], [-1.1076713415, 52.6356030117], [-1.1076575088, 52.63559437…	52.629461009247066, -1.0994946331915114
Thurncourt	34	62	82.35294118	3740.11	10245.05	173.9	34	8511	3.99483022	2.854406251	5.590888992	1.140423969	1.596058772		62	8511	7.284690401	5.679451673	9.34363338	1.605238728	2.05894298		{"coordinates": [[[-1.084472441, 52.6419247141], [-1.0844165265, 52.6419703021], [-1.0844053127, 52.6419765085], [-1.0843933789, 52.6419818103], [-1.0843800105, 52.6419857435], [-1.0843732886, 52.6419870401], [-1.084298501, 52.6419972503], [-1.0840910551, 52.6420231479], [-1.0838584397, 52.642051907…	52.638917027995525, -1.0625848218854592
Western	144	235	63.19444444	25763.22	39420.74	53	144	14248	10.10668164	8.583685959	11.89990107	1.52299568	1.793219434	H	235	14248	16.49354295	14.51398498	18.74309224	1.979557976	2.249549283	H	{"coordinates": [[[-1.1837602707, 52.6506301141], [-1.1836243546, 52.6506117466], [-1.1835122577, 52.6505970402], [-1.1833493382, 52.650576149], [-1.1832372432, 52.6505613524], [-1.1831156597, 52.6505456902], [-1.1826356612, 52.6504826164], [-1.1825190118, 52.6504703049], [-1.1822966459, 52.65110148…	52.63854476627905, -1.1841988300858692
Abbey	79	143	81.01265823	7685.32	22758.9	196.1	79	15536	5.084963955	4.078669011	6.3395334	1.006294944	1.254569445		143	15536	9.204428424	7.812939619	10.84374214	1.391488805	1.63931372		{"coordinates": [[[-1.1563891294, 52.6500033131], [-1.1565996767, 52.6502462096], [-1.1565996767, 52.6502462096], [-1.1566543566, 52.6503060132], [-1.1567425236, 52.6504046849], [-1.1567770813, 52.6504516695], [-1.157086208, 52.6507532335], [-1.1572532514, 52.6509081134], [-1.1572940775, 52.65093356…	52.65690942079076, -1.1404000664907492
Eyres Monsell	58	124	113.7931034	8829.55	26992.13	205.7	58	8188	7.083536883	5.476207144	9.162636375	1.607329739	2.079099492	H	124	8188	15.14411334	12.6999582	18.05865541	2.44415514	2.914542071	H	{"coordinates": [[[-1.1592461131, 52.591181515], [-1.1592442627, 52.59122113], [-1.1592445134, 52.5912844037], [-1.1592435669, 52.5913716722], [-1.1592455046, 52.5914301033], [-1.1592378236, 52.591481274], [-1.1592297288, 52.5915162687], [-1.1592002605, 52.5915172283], [-1.1591466044, 52.5915417409]…	52.59065596909628, -1.145109294352698
Evington	40	114	185	2712.16	9792.08	261	40	12961	3.086181622	2.263769615	4.207370282	0.822412007	1.12118866	L	114	12961	8.795617622	7.320530375	10.56793503	1.475087248	1.772317404		{"coordinates": [[[-1.0932262658, 52.6161458939], [-1.0930793849, 52.6164414503], [-1.0929498776, 52.6166974125], [-1.092899968, 52.6167960737], [-1.0920433444, 52.6185098027], [-1.0917437736, 52.6191030162], [-1.0915849951, 52.6193836459], [-1.0909511915, 52.6204953844], [-1.0906896492, 52.62096216…	52.627169373428764, -1.0758455482423877


CREATE TABLE table_1 (
  "ward" VARCHAR,
  "n_2019_20" BIGINT,
  "n_2020_21" BIGINT,
  "change_num" DOUBLE,
  "n_2019_200" DOUBLE,
  "n_2020_210" DOUBLE,
  "change_value" DOUBLE,
  "n_2019_201" BIGINT,
  "n_18_pop_2019" BIGINT,
  "rate_per_1_000_1920" DOUBLE,
  "lcl" DOUBLE,
  "ucl" DOUBLE,
  "lclfg" DOUBLE,
  "uclfg" DOUBLE,
  "sig_lei" VARCHAR,
  "n_2020_211" BIGINT,
  "n_18_pop_20190" BIGINT,
  "rate_per_1_000_2021" DOUBLE,
  "lcl0" DOUBLE,
  "ucl0" DOUBLE,
  "lclfg0" DOUBLE,
  "uclfg0" DOUBLE,
  "sig_lei0" VARCHAR,
  "geo_shape" VARCHAR,
  "geo_point_2d" VARCHAR
);