Clinical Commissioning Groups (April 2019) Boundaries EN BFC
Office for National Statistics
@ukgov.clinical_commissioning_groups_april_2019_boundaries_en_bfc1
Table 1
@ukgov.clinical_commissioning_groups_april_2019_boundaries_en_bfc1.table_1
- 28.46 KB
- 191 rows
- 10 columns
objectidOBJECTID | ccg19cdCCG19CD | ccg19nmCCG19NM | bng_eBNG E | bng_nBNG N | longLONG | latLAT | shape_areaShape, Area | shape_lengthShape, Length | globalidGlobalID |
|---|---|---|---|---|---|---|---|---|---|
| 1 | E38000001 | NHS Airedale, Wharfedale and Craven CCG | 393990 | 462191 | -2.0933 | 54.0556 | 1220633012.18794 | 222000.154543113 | ba3cd6e5-0f6e-4490-942f-76d9ecfd51fe |
| 2 | E38000002 | NHS Ashford CCG | 597640 | 140644 | 0.823374 | 51.131 | 580617224.961464 | 149426.082726826 | 7873eac9-c8a3-4ef6-965a-8b444a2deaa4 |
| 3 | E38000004 | NHS Barking and Dagenham CCG | 547758 | 185109 | 0.129493 | 51.5455 | 36091043.3812866 | 40665.3109918931 | 3befeb8a-c45a-4675-81f8-f7eda7acaebb |
| 4 | E38000005 | NHS Barnet CCG | 523471 | 191753 | -0.21822 | 51.6111 | 86736441.8524399 | 50842.3131014223 | 8a30551c-60ab-45c2-b1b3-5f5cf82e3297 |
| 5 | E38000006 | NHS Barnsley CCG | 429979 | 403330 | -1.54925 | 53.5258 | 329052050.34642 | 125518.601736419 | f25bb103-3b1f-478a-a022-f6f556f36a92 |
| 6 | E38000007 | NHS Basildon and Brentwood CCG | 564014 | 194421 | 0.368068 | 51.6247 | 263142525.624634 | 120224.066757968 | 20cc3313-8936-4d09-9818-e546c25fb110 |
| 7 | E38000008 | NHS Bassetlaw CCG | 468073 | 384833 | -0.9787 | 53.356 | 637870612.77887 | 159653.435254423 | d93b5249-a5a4-42dd-8668-29ee857d0989 |
| 8 | E38000009 | NHS Bath and North East Somerset CCG | 366218 | 161999 | -2.48653 | 51.356 | 351122903.006668 | 141623.045866674 | c6de158a-c869-4cfd-8d2e-55ba36ebb31f |
| 9 | E38000010 | NHS Bedfordshire CCG | 508276 | 246439 | -0.42045 | 52.1057 | 1192076343.84472 | 268850.214710607 | 31b31c8d-5fe3-4cc3-ba94-9310e9dfc0ee |
| 10 | E38000011 | NHS Bexley CCG | 549201 | 175434 | 0.146198 | 51.4582 | 60556319.3008957 | 45069.8949418635 | 0e3fafca-3f45-4bae-9424-c8814af49cf7 |
CREATE TABLE table_1 (
"objectid" BIGINT,
"ccg19cd" VARCHAR,
"ccg19nm" VARCHAR,
"bng_e" BIGINT,
"bng_n" BIGINT,
"long" DOUBLE,
"lat" DOUBLE,
"shape_area" DOUBLE,
"shape_length" DOUBLE,
"globalid" VARCHAR
);