Clinical Commissioning Groups (April 2018) Generalised Clipped Boundaries In England

Office for National Statistics

@ukgov.clinical_commissioning_groups_april_2018_generalised_c_09885285

Table List

1 table(20.86 KB)

Table 1

@ukgov.clinical_commissioning_groups_april_2018_generalised_c_09885285.table_1

20.86 KB
195 rows
9 columns

objectid OBJECTID	ccg18cd CCG18CD	ccg18nm CCG18NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length
1	E38000001	NHS Airedale, Wharfedale and Craven CCG	393990	462191	-2.0933001	54.0556488	1220675400.5089	218926.396164153
2	E38000002	NHS Ashford CCG	597640	140644	0.82337397	51.13095856	580556873.468666	146583.999498625
3	E38000004	NHS Barking and Dagenham CCG	547758	185109	0.129493	51.54552841	36095813.7556	39627.0517881505
4	E38000005	NHS Barnet CCG	523471	191753	-0.21822	51.61108017	86750788.1267014	49750.7604623242
5	E38000006	NHS Barnsley CCG	429979	403330	-1.54925001	53.5257988	329081135.911667	123187.363991982
6	E38000007	NHS Basildon and Brentwood CCG	564014	194421	0.36806801	51.62469864	263154300.477409	116976.43547503
7	E38000008	NHS Bassetlaw CCG	468073	384833	-0.97869998	53.35602188	637938225.418427	157030.630707859
8	E38000009	NHS Bath and North East Somerset CCG	366218	161999	-2.48653007	51.35604095	351150631.062687	137358.144598088
9	E38000010	NHS Bedfordshire CCG	508276	246439	-0.42045	52.10570145	1191994699.46851	264928.593161092
10	E38000011	NHS Bexley CCG	549201	175434	0.146198	51.45822144	60559782.6116562	43608.4282795663


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ccg18cd" VARCHAR,
  "ccg18nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);