30th Round Provisional Awards (WGS84)

North Sea Transition Authority

@ukgov.n_30th_round_provisional_awards_wgs844

Table List

1 table(23.1 KB)

Table 1

@ukgov.n_30th_round_provisional_awards_wgs844.table_1

23.1 KB
267 rows
15 columns

objectid OBJECTID	quadno QUADNO	blockno BLOCKNO	blocksuff BLOCKSUFF	blockref BLOCKREF	roundtype ROUNDTYPE	roundref ROUNDREF	licadmin LICADMIN	sourcesrs SOURCESRS	areasqkm AREASQKM	admconname ADMCONNAME	admconmail ADMCONMAIL	shapestarea ShapeSTArea	shapestlength ShapeSTLength
1	14	28		14/28	F	30	CHEVRON NORTH SEA LIMITED	ED 50	219	Mr David Lewis	dave.lewis@chevron.com	0.0333354209506269	0.733355958366714
2	16	3	d	16/3d	F	30	EQUINOR UK LIMITED	ED 50	18	Dr Jenny Morris	jemor@statoil.com	0.002777958735003	0.233341089147759
3	14	29	b	14/29b	F	30	CHEVRON NORTH SEA LIMITED	ED 50	201	Mr David Lewis	dave.lewis@chevron.com	0.0305574735742115	0.733356002364398
4	21	15		21/15	F	30	APACHE NORTH SEA LIMITED	ED 50	222	Mr Jeff Towart	jeffrey.towart@apachecorp.com	0.0333354230159071	0.733355999329014
5	21	9	c	21/9c	F	30	APACHE NORTH SEA LIMITED	ED 50	116	Mr Jeff Towart	jeffrey.towart@apachecorp.com	0.0175010988510529	0.666686304219127
6	22	12	d	22/12d	F	30	SHELL U.K. LIMITED	ED 50	93	Dr Ben Hillier	ben.hillier@shell.com	0.0138897633691625	0.583351303246437
7	22	19	f	22/19f	F	30	CLUFF NATURAL RESOURCES PLC	ED 50	45	Mr Andrew Nunn	andrew@cluffnaturalresources.com	0.0066670866264661	0.4666798120864
8	22	24	g	22/24g	F	30	ENI UK LIMITED	ED 50	11	Ms Mieke Verkeyn	mie.verkeyn@eni.com	0.0016667712607577	0.166672051088724
9	23	11	c	23/11c	F	30	EQUINOR UK LIMITED	ED 50	23	Dr Jenny Morris	jemor@statoil.com	0.0034634553406993	0.295104446209274
10	23	16	e	23/16e	F	30	EQUINOR UK LIMITED	ED 50	10	Dr Jenny Morris	jemor@statoil.com	0.0015208508344191	0.195205311718255


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "quadno" BIGINT,
  "blockno" BIGINT,
  "blocksuff" VARCHAR,
  "blockref" VARCHAR,
  "roundtype" VARCHAR,
  "roundref" BIGINT,
  "licadmin" VARCHAR,
  "sourcesrs" VARCHAR,
  "areasqkm" BIGINT,
  "admconname" VARCHAR,
  "admconmail" VARCHAR,
  "tranche" VARCHAR,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);