Countries (December 2021) Boundaries UK BFE

Office for National Statistics

@ukgov.countries_december_2021_boundaries_uk_bfe

Table List

1 table(8.34 KB)

Table 1

@ukgov.countries_december_2021_boundaries_uk_bfe.table_1

8.34 KB
4 rows
11 columns

objectid OBJECTID	ctry21cd CTRY21CD	ctry21nm CTRY21NM	ctry21nmw CTRY21NMW	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	E92000001	England	Lloegr	394883	370883	-2.07811	53.23497	df54c160-4d61-4bb8-8e80-a5fc9b5f47b2	132928785677.504	4939257.52091813
2	N92000002	Northern Ireland	Gogledd Iwerddon	86544	535337	-6.8557	54.61501	691f2a27-95b3-401c-8a5e-4bd7a9135376	14329763570.575	1131044.59311699
3	S92000003	Scotland	Yr Alban	277744	700060	-3.97094	56.17743	3e234e90-12fb-4e33-9cb6-72d2f9908e91	80227828103.8194	17523723.601571
4	W92000004	Wales	Cymru	263405	242881	-3.99417	52.06741	c620b129-8fab-45e2-98cb-60f00ca163f6	21217536865.5317	2071849.50835243


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ctry21cd" VARCHAR,
  "ctry21nm" VARCHAR,
  "ctry21nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);