Integrated Care Boards (April 2023) EN BFC

Office for National Statistics

@ukgov.integrated_care_boards_april_2023_en_bfc

Table List

1 table(12.43 KB)

Table 1

@ukgov.integrated_care_boards_april_2023_en_bfc.table_1

12.43 KB
42 rows
10 columns

fid FID	icb23cd ICB23CD	icb23nm ICB23NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E54000008	NHS Cheshire and Merseyside Integrated Care Board	374405	380936	-2.38572	53.32473	2998260772.9258	719554.776541044	b121a196-42db-406a-b8bf-445fa66c6349
2	E54000010	NHS Staffordshire and Stoke-on-Trent Integrated Care Board	398243	334651	-2.02756	52.9093	2716765448.08205	437331.190345488	5ee0ea54-10b2-4648-bbe4-6537971a2727
3	E54000011	NHS Shropshire, Telford and Wrekin Integrated Care Board	350226	302960	-2.73668	52.62212	3487617568.51864	497019.936081611	6d309cef-470b-454d-8765-a12aeebe194a
4	E54000013	NHS Lincolnshire Integrated Care Board	517984	358538	-0.23884	53.11101	5937314244.10548	1306711.8640761	142399ea-c5ae-4471-a0d0-03b88ea723cb
5	E54000015	NHS Leicester, Leicestershire and Rutland Integrated Care Board	466552	310188	-1.0169	52.68532	2550866043.25587	342555.078331497	17aae889-c590-452f-83af-09638bf398bd
6	E54000018	NHS Coventry and Warwickshire Integrated Care Board	429584	266724	-1.5676	52.29786	2076176506.79146	366625.359258702	a8883ed6-3cc5-4475-9551-9c24383ffcb2
7	E54000019	NHS Herefordshire and Worcestershire Integrated Care Board	364519	249269	-2.51986	52.14057	3920249941.65146	538053.77551836	ae1fb92e-3af8-4392-949d-9c41e77e4f52
8	E54000022	NHS Norfolk and Waveney Integrated Care Board	600616	310723	0.964749	52.65712	5755202494.243	1596081.45525295	51dca962-cf11-4dd3-b652-040e1cd2f356
9	E54000023	NHS Suffolk and North East Essex Integrated Care Board	596764	250276	0.872415	52.11579	4099966133.54163	1432462.89869426	35a78278-18f8-4123-a4dd-80fa8bbf29a1
10	E54000024	NHS Bedfordshire, Luton and Milton Keynes Integrated Care Board	501732	241559	-0.51742	52.06308	1603920973.48568	270683.381206951	4fcc6556-7f72-4c8b-b7f9-f37266c9b7c2


CREATE TABLE table_1 (
  "fid" BIGINT,
  "icb23cd" VARCHAR,
  "icb23nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);