Wards (Dec 2020) UK BSC V2

Office for National Statistics

@ukgov.wards_dec_2020_uk_bsc_v2

Table List

1 table(1001.88 KB)

Table 1

@ukgov.wards_dec_2020_uk_bsc_v2.table_1

1001.88 KB
8887 rows
11 columns

objectid OBJECTID	wd20cd WD20CD	wd20nm WD20NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E05000026	Abbey	544433	184376	0.081276	51.53981	1174978.20336151	5761.9973611257	39a5f846-e1ef-4cf2-82d2-8adcd92b7e52
2	E05000027	Alibon	549247	185196	0.150987	51.54592	1344130.36203766	5778.85640711931	98117b88-08ad-49c5-b61d-8c033768a996
3	E05000028	Becontree	546860	185870	0.116869	51.55261	1371715.28947449	5651.95517011197	785479b4-d6bc-42cf-b0af-17e191f6e0f5
4	E05000029	Chadwell Heath	548266	189340	0.138596	51.58342	3363244.51974487	8371.5976315982	3e616ad1-8e8e-48fa-b9d3-6093dd4d370b
5	E05000030	Eastbrook	550775	186271	0.173467	51.55518	3417662.29881287	8247.90631130207	c0881520-0202-4aaa-9d3e-d1e767fea246
6	E05000031	Eastbury	546074	183978	0.104756	51.53581	1403338.35105896	6404.20756159232	81c3a2d9-7019-4fe2-bcab-c47e983d477e
7	E05000032	Gascoigne	544767	183577	0.08576	51.53254	1268996.66611481	5600.19788315249	c6d13abc-9758-4981-905d-38b1971e6436
8	E05000033	Goresbrook	548007	184060	0.132641	51.53604	1182516.00096893	4952.80922062777	69f4facb-c83f-44ab-90c4-b43d2d38b522
9	E05000034	Heath	549340	186620	0.152931	51.55869	2006511.06867981	6788.15099560481	4fd9121e-779a-4646-9d33-a4c9c1e0af2d
10	E05000035	Longbridge	545274	184913	0.093615	51.54442	1763292.07372284	6039.06929621178	0924b3b7-9c05-4d29-a348-793931edfc86


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "wd20cd" VARCHAR,
  "wd20nm" VARCHAR,
  "wd20nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);