Administrative Counties (1971) Boundaries EW

Office for National Statistics

@ukgov.administrative_counties_1971_boundaries_ew

Table List

1 table(15.7 KB)

Table 1

@ukgov.administrative_counties_1971_boundaries_ew.table_1

15.7 KB
59 rows
13 columns

fid FID	cty71cd CTY71CD	cty71cdo CTY71CDO	cty71nm CTY71NM	ctry71cd CTRY71CD	ctry71nm CTRY71NM	bng_e BNG E	bng_n BNG N	lat LAT	long LONG	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	H1971F03000001	e01	Bedfordshire	e	England	508275	242159	52.06724	-0.42183	1232354229.26947	244721.645148976	e7c45f05-47c4-4c02-bb32-7981ac993517
2	H1971F03000002	e02	Berkshire	e	England	442264	184697	51.55958	-1.39172	1875661053.99318	339480.474933957	823887b5-9d75-489a-97de-236d350cc9d1
3	H1971F03000003	e03	Buckinghamshire	e	England	482523	217822	51.85291	-0.80325	1932664663.34461	400966.369912259	a54ec413-1ffd-464a-ae24-e23813f72cae
4	H1971F03000004	e04	Cambridgeshire and Isle of Ely	e	England	546335	262212	52.23867	0.141678	2150362697.5901	471829.274610772	6f498f98-3c66-421a-b0f9-496f5da33d90
5	H1971F03000005	e05	Cheshire	e	England	366514	371950	53.24352	-2.50324	2643766663.08519	489025.733154861	3d201f34-24eb-476e-9a0a-aabbef41794b
6	H1971F03000006	e06	Cornwall	e	England	212501	64494	50.45024	-4.64249	3572290660.02952	1368822.46780001	358495a1-d925-49df-8589-e27fccad542b
7	H1971F03000007	e07	Cumberland	e	England	335424	533121	54.68898	-3.00327	3949027180.2226	686978.620708773	8032bc3f-7586-44d6-8bac-e263b9502426
8	H1971F03000008	e08	Derbyshire	e	England	426425	353544	53.07849	-1.60699	2578500735.53063	397387.925433729	7d240fa0-da75-45e4-8602-ac411655c6ba
9	H1971F03000009	e09	Devon	e	England	283134	93082	50.72556	-3.65711	6709893003.91769	1098569.29629749	c69140f1-19bd-406b-844d-4f4dc1f90bea
10	H1971F03000010	e10	Dorset	e	England	373593	99796	50.79711	-2.37605	2532268760.52818	533077.894127877	4994d926-c756-4e6e-a1fb-fd9dc708afae


CREATE TABLE table_1 (
  "fid" BIGINT,
  "cty71cd" VARCHAR,
  "cty71cdo" VARCHAR,
  "cty71nm" VARCHAR,
  "ctry71cd" VARCHAR,
  "ctry71nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "lat" DOUBLE,
  "long" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);