Takeaways - FOR SHARING - Google Sheets

	A	B	C	D	E	F	G	H	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT
1	Local Authority	Original dataset order	Code	Fast food outlets 2010	2010 All food outlets	2010 % of Fast food outlets	Population 2010	2010 Fast food outlet - rate per 100,000 of population	Fast food outlets 2018	2018 All food outlets	2018 % of fast food outlets	Population 2017	2018 Fast food outlet - rate per 100,000 of population	Is 2018 % of takeaways higher than 2010?	Is 2018 rate per 100,000 people higher than 2010?	How many extra takeaways opened from 2010 to 2018?	What was the increase/decrease in rate of fast food outlets per 100,000 of population from 2010 to 2018?	Ranking on fast food outlet rate per 100,000 people - where 1 is the place with the most proportionately
2	Westminster	98	E09000033	340	1,905	18	217,187	157	310	2150	14	244796	127	FALSE	FALSE	-30	-30	1
3	Blackpool	14	E06000009	70	200	35	142,753	49	135	285	47	139870	97	TRUE	TRUE	65	47	2
4	Glasgow City	190	S12000046	400	970	41	586,500	68	565	1390	41	621020	91	FALSE	TRUE	165	23	3
5	South Tyneside	11	E08000023	80	125	64	148,468	54	135	245	55	149555	90	FALSE	TRUE	55	36	4
6	Manchester	22	E08000003	280	710	39	492,598	57	490	1220	40	545501	90	TRUE	TRUE	210	33	5
7	Newcastle upon Tyne	9	E08000021	205	450	46	276,681	74	265	625	42	295842	90	FALSE	TRUE	60	15	6
8	Camden	85	E09000007	225	915	25	214,725	105	225	1240	18	253361	89	FALSE	FALSE	0	-16	7
9	Sunderland	12	E08000024	140	260	54	275,980	51	245	430	57	277249	88	TRUE	TRUE	105	38	8
10	Kingston upon Hull, City of	37	E06000010	140	255	55	256,174	55	230	425	54	260673	88	FALSE	TRUE	90	34	9
11	Belfast	210	N09000003	255	555	46	333,489	76	300	765	39	340220	88	FALSE	TRUE	45	12	10
12	Blackburn with Darwen	13	E06000008	50	105	48	146,966	34	130	220	59	148772	87	TRUE	TRUE	80	53	11
13	Portsmouth	123	E06000044	135	300	45	202,700	67	185	465	40	214718	86	FALSE	TRUE	50	20	12
14	Gateshead	8	E08000037	110	205	54	198,731	55	170	310	55	202419	84	TRUE	TRUE	60	29	13
15	Leicester	52	E06000016	165	360	46	324,912	51	295	615	48	353540	83	TRUE	TRUE	130	33	14
16	Islington	90	E09000019	135	545	25	200,129	67	195	795	25	235000	83	FALSE	TRUE	60	16	15
17	North East Lincolnshire	38	E06000012	85	170	50	158,951	53	130	225	58	159826	81	TRUE	TRUE	45	28	16
18	Conwy	155	W06000003	55	180	31	114,682	48	95	250	38	116863	81	TRUE	TRUE	40	33	17
19	Rochdale	24	E08000005	80	160	50	210,758	38	175	285	61	218459	80	TRUE	TRUE	95	42	18
20	North Lanarkshire	196	S12000044	220	320	69	336,280	65	270	420	64	339960	79	FALSE	TRUE	50	14	19
21	Blaenau Gwent	171	W06000019	40	55	73	69,798	57	55	75	73	69609	79	TRUE	TRUE	15	22	20
22	Calderdale	47	E08000033	95	215	44	203,049	47	165	355	46	209454	79	TRUE	TRUE	70	32	21
23	Bradford	46	E08000032	180	410	44	518,002	35	420	775	54	534800	79	TRUE	TRUE	240	44	22
24	Middlesbrough	4	E06000002	75	130	58	137,667	54	110	205	54	140639	78	FALSE	TRUE	35	24	23
25	Southend-on-Sea	78	E06000033	95	290	33	172,122	55	140	385	36	181808	77	TRUE	TRUE	45	22	24
26	City of Edinburgh	186	S12000036	295	855	35	469,940	63	395	1270	31	513210	77	FALSE	TRUE	100	14	25
27	Kirklees	48	E08000034	155	335	46	418,339	37	335	640	52	437145	77	TRUE	TRUE	180	40	26
28	Derry City and Strabane	212	N09000005	90	170	53	148,148	61	115	210	55	150497	76	TRUE	TRUE	25	16	27
29	Wakefield	50	E08000036	175	300	58	325,595	54	260	490	53	340790	76	FALSE	TRUE	85	23	28
30	North Tyneside	10	E08000022	110	190	58	200,164	55	155	300	52	204473	76	FALSE	TRUE	45	21	29
31	Darlington	1	E06000005	50	115	43	105,028	48	80	160	50	106347	75	TRUE	TRUE	30	28	30
32	Tower Hamlets	96	E09000030	145	460	32	248,520	58	230	810	28	307964	75	FALSE	TRUE	85	16	31
33	Trafford	28	E08000009	130	280	46	225,234	58	175	405	43	235493	74	FALSE	TRUE	45	17	32
34	Neath Port Talbot	164	W06000012	50	110	45	139,638	36	105	200	53	142090	74	TRUE	TRUE	55	38	33
35	Swansea	163	W06000011	110	285	39	237,311	46	180	420	43	245480	73	TRUE	TRUE	70	27	34
36	Mid and East Antrim	215	N09000008	80	175	46	135,157	59	100	220	45	138152	72	FALSE	TRUE	20	13	35
37	Stockport	26	E08000007	135	285	47	282,614	48	210	430	49	291045	72	TRUE	TRUE	75	24	36
38	Leeds	49	E08000035	360	740	49	747,571	48	565	1265	45	784846	72	FALSE	TRUE	205	24	37
39	Bolton	20	E08000001	120	230	52	275,168	44	205	390	53	284813	72	TRUE	TRUE	85	28	38
40	Bury	21	E08000002	90	175	51	184,755	49	135	280	48	189628	71	FALSE	TRUE	45	22	39
41	Rhondda Cynon Taff	168	W06000016	125	190	66	234,459	53	170	270	63	239127	71	FALSE	TRUE	45	18	40
42	Bristol, City of	139	E06000023	225	600	38	423,044	53	325	950	34	459252	71	FALSE	TRUE	100	18	41
43	Dundee City	181	S12000042	85	180	47	146,060	58	105	235	45	148710	71	FALSE	TRUE	20	12	42
44	Oldham	23	E08000004	80	170	47	223,807	36	165	305	54	233759	71	TRUE	TRUE	85	35	43
45	Antrim and Newtownabbey	207	N09000001	90	160	56	138,044	65	100	205	49	141697	71	FALSE	TRUE	10	5	44
46	Reading	124	E06000038	120	255	47	154,296	78	115	290	40	163075	71	FALSE	FALSE	-5	-7	45
47	Torfaen	172	W06000020	40	70	57	91,060	44	65	110	59	92264	70	TRUE	TRUE	25	27	46
48	Hartlepool	3	E06000001	40	90	44	91,773	44	65	130	50	93019	70	TRUE	TRUE	25	26	47
49	East Ayrshire	182	S12000008	60	115	52	122,410	49	85	160	53	121940	70	TRUE	TRUE	25	21	48
50	York	40	E06000014	105	310	34	195,070	54	145	430	34	208163	70	FALSE	TRUE	40	16	49
51	Salford	25	E08000006	90	155	58	231,837	39	175	325	54	251332	70	FALSE	TRUE	85	31	50
52	East Riding of Yorkshire	36	E06000011	160	350	46	333,599	48	235	500	47	338061	70	TRUE	TRUE	75	22	51
53	Newport	174	W06000022	60	135	44	144,803	41	105	220	48	151485	69	TRUE	TRUE	45	28	52
54	Tameside	27	E08000008	85	145	59	218,774	39	155	270	57	224119	69	FALSE	TRUE	70	30	53
55	South Lanarkshire	203	S12000029	165	320	52	313,180	53	220	450	49	318170	69	FALSE	TRUE	55	16	54
56	Caerphilly	170	W06000018	80	115	70	178,101	45	125	190	66	180795	69	FALSE	TRUE	45	24	55
57	Cardiff	167	W06000015	160	445	36	341,402	47	250	730	34	362756	69	FALSE	TRUE	90	22	56
58	Barking and Dagenham	99	E09000002	95	155	61	182,838	52	145	245	59	210711	69	FALSE	TRUE	50	17	57
59	County Durham	2	E06000047	210	390	54	510,628	41	360	650	55	523662	69	TRUE	TRUE	150	28	58
60	Stockton-on-Tees	7	E06000004	85	155	55	190,902	45	135	245	55	196487	69	TRUE	TRUE	50	24	59
61	Gwynedd	154	W06000002	65	225	29	121,155	54	85	295	29	123742	69	FALSE	TRUE	20	15	60
62	Stoke-on-Trent	62	E06000021	120	205	59	247,381	49	175	315	56	255378	69	FALSE	TRUE	55	20	61
63	Ceredigion	160	W06000008	35	105	33	75,217	47	50	160	31	73076	68	FALSE	TRUE	15	22	62
64	Southwark	95	E09000028	165	470	35	283,777	58	215	740	29	314232	68	FALSE	TRUE	50	10	63
65	Pembrokeshire	161	W06000009	65	205	32	121,974	53	85	250	34	124711	68	TRUE	TRUE	20	15	64
66	Clackmannanshire	179	S12000005	25	40	63	51,330	49	35	65	54	51450	68	FALSE	TRUE	10	19	65
67	Moray	194	S12000020	40	105	38	93,690	43	65	145	45	95780	68	TRUE	TRUE	25	25	66
68	Sandwell	69	E08000028	140	235	60	306,181	46	220	380	58	325460	68	FALSE	TRUE	80	22	67
69	West Dunbartonshire	205	S12000039	45	80	56	90,800	50	60	120	50	89610	67	FALSE	TRUE	15	17	68
70	Bournemouth	138	E06000028	105	300	35	179,308	59	130	420	31	194752	67	FALSE	TRUE	25	8	69
71	Merthyr Tydfil	169	W06000024	20	45	44	58,493	34	40	75	53	59953	67	TRUE	TRUE	20	33	70
72	North Ayrshire	195	S12000021	65	145	45	137,790	47	90	195	46	135790	66	TRUE	TRUE	25	19	71
73	Wigan	29	E08000010	130	240	54	316,296	41	215	395	54	324650	66	TRUE	TRUE	85	25	72
74	Cumbria	19	E10000006	225	685	33	500,165	45	330	910	36	498375	66	TRUE	TRUE	105	21	73
75	Brighton and Hove	119	E06000043	165	530	31	269,495	61	190	745	26	288155	66	FALSE	TRUE	25	5	74
76	Bridgend	165	W06000013	90	165	55	138,471	65	95	195	49	144288	66	FALSE	TRUE	5	1	75
77	Lancashire	30	E10000017	525	1,150	46	1,167,579	45	790	1625	49	1201855	66	TRUE	TRUE	265	21	76
78	Ards and North Down	208	N09000011	90	235	38	156,518	58	105	270	39	160098	66	TRUE	TRUE	15	8	77
79	Hammersmith and Fulham	88	E09000013	105	410	26	180,842	58	120	565	21	182998	66	FALSE	TRUE	15	8	78
80	Aberdeen City	175	S12000033	140	305	46	219,730	64	150	380	39	228800	66	FALSE	TRUE	10	2	79
81	Hackney	87	E09000012	105	335	31	241,739	43	180	710	25	275929	65	FALSE	TRUE	75	22	80
82	Vale of Glamorgan	166	W06000014	50	115	43	126,435	40	85	200	43	130690	65	FALSE	TRUE	35	25	81
83	Renfrewshire	199	S12000038	90	180	50	173,700	52	115	235	49	176830	65	FALSE	TRUE	25	13	82
84	Doncaster	43	E08000017	120	255	47	301,299	40	200	395	51	308940	65	TRUE	TRUE	80	25	83
85	Birmingham	66	E08000025	515	1,070	48	1,061,074	49	735	1675	44	1137123	65	FALSE	TRUE	220	16	84
86	Rotherham	44	E08000018	95	165	58	256,893	37	170	295	58	263375	65	TRUE	TRUE	75	28	85
87	Sheffield	45	E08000019	210	515	41	544,613	39	370	875	42	577789	64	TRUE	TRUE	160	25	86
88	Nottingham	53	E06000018	120	325	37	299,753	40	210	530	40	329209	64	TRUE	TRUE	90	24	87
89	Croydon	104	E09000008	180	430	42	357,951	50	245	645	38	384837	64	FALSE	TRUE	65	13	88
90	Liverpool	32	E08000012	210	545	39	461,403	46	310	880	35	491549	63	FALSE	TRUE	100	18	89
91	Peterborough	77	E06000031	95	180	53	181,762	52	125	270	46	198914	63	FALSE	TRUE	30	11	90
92	Plymouth	143	E06000026	135	300	45	254,227	53	165	405	41	263070	63	FALSE	TRUE	30	10	91
93	Northumberland	5	E06000057	145	325	45	315,463	46	200	510	39	319030	63	FALSE	TRUE	55	17	92
94	Causeway Coast and Glens	211	N09000004	70	205	34	140,107	50	90	230	39	143920	63	TRUE	TRUE	20	13	93
95	Havering	109	E09000016	120	290	41	236,234	51	160	405	40	256039	62	FALSE	TRUE	40	12	94
96	Derby	51	E06000015	120	235	51	247,035	49	160	355	45	257034	62	FALSE	TRUE	40	14	95
97	Walsall	71	E08000030	115	200	58	266,834	43	175	330	53	281293	62	FALSE	TRUE	60	19	96
98	South Ayrshire	202	S12000028	55	150	37	112,600	49	70	190	37	112680	62	TRUE	TRUE	15	13	97
99	Carmarthenshire	162	W06000010	70	170	41	183,004	38	115	300	38	186452	62	FALSE	TRUE	45	23	98
100	Wolverhampton	72	E08000031	120	240	50	247,640	48	160	320	50	259926	62	FALSE	TRUE	40	13	99