ENG Licensed Blocks BNG

North Sea Transition Authority

@ukgov.eng_licensed_blocks_bng3

Table List

1 table(42.59 KB)

Table 1

@ukgov.eng_licensed_blocks_bng3.table_1

42.59 KB
231 rows
34 columns

objectid OBJECTID	licblockid LICBLOCKID	quadno QUADNO	blockno BLOCKNO	blocksuffi BLOCKSUFFI	blockref BLOCKREF	blckstrtdt BLCKSTRTDT	agreed_km2 AGREED KM2	calc_km2 CALC KM2	lictype LICTYPE	licno LICNO	licref LICREF	licstartdt LICSTARTDT	initenddt INITENDDT	secenddt SECENDDT	licenddt LICENDDT	licstatus LICSTATUS	rndtype RNDTYPE	rndno RNDNO	location LOCATION	licsubtype LICSUBTYPE	origidatum ORIGIDATUM	admorg ADMORG	admorggrp ADMORGGRP	licorg LICORG	licorggrp LICORGGRP	oporg OPORG	oporggrp OPORGGRP	team_lead TEAM LEAD	region REGION	rndstartdt RNDSTARTDT	rndenddt RNDENDDT	shapestarea SHAPESTArea	shapestlength SHAPESTLength
47232	10905658	SJ	84	c	SJ84c	Fri Sep 16 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	25	25	PEDL	297	PEDL297	Thu Jul 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 20 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 20 2028 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 20 2046 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	14	ONSHORE	Landward	OSGB NATIONAL GRID	RIGON OPERATIONS LIMITED (13099494)	RIGON ENERGY	RIGON EXPLORATION LIMITED (11931578), RIGON OPERATIONS LIMITED (13099494)	RIGON ENERGY	RIGON OPERATIONS LIMITED (13099494)	RIGON ENERGY	Toni Harvey	Onshore	Mon Jul 28 2014 08:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 28 2014 14:00:00 GMT+0000 (Coordinated Universal Time)	25000000	20000
47233	12128687	SE	98	b	SE98b	Sun Jun 12 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	40	40	PEDL	120	PEDL120	Fri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 31 2033 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	10	ONSHORE	Landward	OSGB NATIONAL GRID	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	Toni Harvey	Onshore			40000000	36000
47234	12128688	SE	88	b	SE88b	Sun Jun 12 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	82	82	PEDL	120	PEDL120	Fri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 31 2033 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	10	ONSHORE	Landward	OSGB NATIONAL GRID	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	Toni Harvey	Onshore			82000000	44000
47235	12128689	SE	78	e	SE78e	Sun Jun 12 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2	2	PEDL	120	PEDL120	Fri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 31 2033 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	10	ONSHORE	Landward	OSGB NATIONAL GRID	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	Toni Harvey	Onshore			2000000	6000
47236	12128693	SE	78	a	SE78a	Sun Jun 12 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	58	58	PEDL	120	PEDL120	Fri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 31 2033 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	10	ONSHORE	Landward	OSGB NATIONAL GRID	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	Toni Harvey	Onshore			58000000	38000
47237	12128694	SE	68	a	SE68a	Sun Jun 12 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	52	52	PEDL	120	PEDL120	Fri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 31 2033 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	10	ONSHORE	Landward	OSGB NATIONAL GRID	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	Toni Harvey	Onshore			52000000	32000
47238	14403143	SJ	69	a	SJ69a	Sun Jul 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.9	0.9	EXL	253	EXL253	Sun Jul 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jul 04 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 04 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 30 2026 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	6	ONSHORE	Landward	OSGB NATIONAL GRID	ALKANE ENERGY UK LIMITED (03128509)	INFINIS ENERGY	ALKANE ENERGY UK LIMITED (03128509), EGDON RESOURCES U.K. LIMITED (03424561)	HEYCO ENERGY GROUP, INFINIS ENERGY	ALKANE ENERGY UK LIMITED (03128509), EGDON RESOURCES U.K. LIMITED (03424561)	HEYCO ENERGY GROUP, INFINIS ENERGY	Toni Harvey	Onshore			900000	3800
47239	8884684	SE	80	b	SE80b	Wed Jun 02 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	46	46	PL	162	PL162	Wed Jun 02 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)		Tue Jun 01 2027 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore		ONSHORE	Landward	OSGB NATIONAL GRID	SCOTTISHPOWER ENERGY MANAGEMENT LIMITED (SC215843)	SCOTTISH POWER UK PLC	SCOTTISHPOWER ENERGY MANAGEMENT LIMITED (SC215843)	SCOTTISH POWER UK PLC	SCOTTISHPOWER ENERGY MANAGEMENT LIMITED (SC215843)	SCOTTISH POWER UK PLC	Toni Harvey	Onshore			46000000	32000
47240	10228126	SK	67	k	SK67k	Thu Sep 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	PEDL	90	PEDL90	Fri Sep 08 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Sep 07 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Sep 07 2031 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	9	ONSHORE	Landward	OSGB NATIONAL GRID	COURAGE ENERGY (U.K.) LIMITED (03446506)	BRITNRG LIMITED	ALKANE ENERGY UK LIMITED (03128509), COURAGE ENERGY (U.K.) LIMITED (03446506)	BRITNRG LIMITED, INFINIS ENERGY	ALKANE ENERGY UK LIMITED (03128509)	INFINIS ENERGY	Toni Harvey	Onshore			1000000	4000
47241	15075652	SJ	59	a	SJ59a	Fri Jan 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	48	48	EXL	273	EXL273	Fri Jan 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 31 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	6	ONSHORE	Landward	OSGB NATIONAL GRID	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	DART ENERGY (EAST ENGLAND) LIMITED (06760546), INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES, STAR ENERGY GROUP PLC	INEOS UPSTREAM LIMITED (09121775)	INEOS INDUSTRIES	Toni Harvey	Onshore			48000000	36000


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "licblockid" BIGINT,
  "quadno" VARCHAR,
  "blockno" BIGINT,
  "blocksuffi" VARCHAR,
  "blockref" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "agreed_km2" DOUBLE,
  "calc_km2" DOUBLE,
  "lictype" VARCHAR,
  "licno" BIGINT,
  "licref" VARCHAR,
  "licstartdt" TIMESTAMP,
  "initenddt" TIMESTAMP,
  "secenddt" TIMESTAMP,
  "licenddt" TIMESTAMP,
  "licstatus" VARCHAR,
  "rndtype" VARCHAR,
  "rndno" BIGINT,
  "location" VARCHAR,
  "licsubtype" VARCHAR,
  "origidatum" VARCHAR,
  "admorg" VARCHAR,
  "admorggrp" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "oporg" VARCHAR,
  "oporggrp" VARCHAR,
  "team_lead" VARCHAR,
  "region" VARCHAR,
  "rndstartdt" TIMESTAMP,
  "rndenddt" TIMESTAMP,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);