NSTA Sub Areas By Equity Group Holder (BNG)

North Sea Transition Authority

@ukgov.nsta_sub_areas_by_equity_group_holder_bng2

Table List

1 table(47.51 KB)

Table 1

@ukgov.nsta_sub_areas_by_equity_group_holder_bng2.table_1

47.51 KB
410 rows
33 columns

objectid OBJECTID	subareaid SUBAREAID	subshortnm SUBSHORTNM	subareanam SUBAREANAM	blockref BLOCKREF	licno LICNO	licref LICREF	eqgrphold EQGRPHOLD	equity EQUITY	licstartdt LICSTARTDT	licstatus LICSTATUS	rndtype RNDTYPE	rndno RNDNO	location LOCATION	lictype LICTYPE	licsubtype LICSUBTYPE	admorg ADMORG	admorggrp ADMORGGRP	licorg LICORG	licorggrp LICORGGRP	oporg OPORG	oporggrp OPORGGRP	eqorg EQORG	origidatum ORIGIDATUM	blckstrtdt BLCKSTRTDT	initenddt INITENDDT	secenddt SECENDDT	eqorggrp EQORGGRP	licenddt LICENDDT	rndstartdt RNDSTARTDT	rndenddt RNDENDDT	shapestarea SHAPESTArea	shapestlength SHAPESTLength
81052	50518896	ABOVE SMB	Above the base of the Subcrenatum Marine Band	SE42d	37	PEDL37	INFINIS ENERGY	100%	Wed Mar 18 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	8	ONSHORE	PEDL	Landward	ALKANE ENERGY UK LIMITED (03128509)	INFINIS ENERGY	ALKANE ENERGY UK LIMITED (03128509), EGDON RESOURCES U.K. LIMITED (03424561)	INFINIS ENERGY, HEYCO ENERGY GROUP	ALKANE ENERGY UK LIMITED	INFINIS ENERGY	ALKANE ENERGY UK LIMITED (100%)	OSGB NATIONAL GRID	Wed Mar 18 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 18 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 18 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	INFINIS ENERGY (100%)	Sun Mar 18 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	750000	3500
81053	29221636	ABOVE SMB	Above the base of the Subcrenatum Marine Band	SK56d	1	PEDL1	INFINIS ENERGY	100%	Thu Apr 04 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	7	ONSHORE	PEDL	Landward	ALKANE ENERGY UK LIMITED (03128509)	INFINIS ENERGY	ALKANE ENERGY UK LIMITED (03128509), EGDON RESOURCES U.K. LIMITED (03424561)	INFINIS ENERGY, HEYCO ENERGY GROUP	ALKANE ENERGY UK LIMITED	INFINIS ENERGY	ALKANE ENERGY UK LIMITED (100%)	OSGB NATIONAL GRID	Thu Apr 04 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 04 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Apr 04 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	INFINIS ENERGY (100%)	Sun Apr 04 2027 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	1000000	4000
81054	35520720	ALL	ALL	SD31	165	PEDL165	CUADRILLA RESOURCES	51.25%	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	13	ONSHORE	PEDL	Landward	CUADRILLA BOWLAND LIMITED (08340918)	CUADRILLA RESOURCES	BOWLAND RESOURCES (NO.2) LIMITED (06576443), BOWLAND RESOURCES LIMITED (06811566), CUADRILLA BOWLAND LIMITED (08340918), LUCAS BOWLAND (NO.2) LIMITED (08347365), LUCAS BOWLAND (UK) LIMITED (08341601)	SPIRIT ENERGY, SPIRIT ENERGY, CUADRILLA RESOURCES, A J LUCAS GROUP, A J LUCAS GROUP	CUADRILLA BOWLAND LIMITED	CUADRILLA RESOURCES	CUADRILLA BOWLAND LIMITED (51.25%), BOWLAND RESOURCES LIMITED (18.75%), LUCAS BOWLAND (NO.2) LIMITED (13.75%), LUCAS BOWLAND (UK) LIMITED (10%), BOWLAND RESOURCES (NO.2) LIMITED (6.25%)	OSGB NATIONAL GRID	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUADRILLA RESOURCES (51.25%), SPIRIT ENERGY (25.0%), A J LUCAS GROUP (23.75%)	Fri Jul 01 2039 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	100000000	40000
81055	35520720	ALL	ALL	SD31	165	PEDL165	SPIRIT ENERGY	25.0%	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	13	ONSHORE	PEDL	Landward	CUADRILLA BOWLAND LIMITED (08340918)	CUADRILLA RESOURCES	BOWLAND RESOURCES (NO.2) LIMITED (06576443), BOWLAND RESOURCES LIMITED (06811566), CUADRILLA BOWLAND LIMITED (08340918), LUCAS BOWLAND (NO.2) LIMITED (08347365), LUCAS BOWLAND (UK) LIMITED (08341601)	SPIRIT ENERGY, SPIRIT ENERGY, CUADRILLA RESOURCES, A J LUCAS GROUP, A J LUCAS GROUP	CUADRILLA BOWLAND LIMITED	CUADRILLA RESOURCES	CUADRILLA BOWLAND LIMITED (51.25%), BOWLAND RESOURCES LIMITED (18.75%), LUCAS BOWLAND (NO.2) LIMITED (13.75%), LUCAS BOWLAND (UK) LIMITED (10%), BOWLAND RESOURCES (NO.2) LIMITED (6.25%)	OSGB NATIONAL GRID	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUADRILLA RESOURCES (51.25%), SPIRIT ENERGY (25.0%), A J LUCAS GROUP (23.75%)	Fri Jul 01 2039 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	100000000	40000
81056	35520720	ALL	ALL	SD31	165	PEDL165	A J LUCAS GROUP	23.75%	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	13	ONSHORE	PEDL	Landward	CUADRILLA BOWLAND LIMITED (08340918)	CUADRILLA RESOURCES	BOWLAND RESOURCES (NO.2) LIMITED (06576443), BOWLAND RESOURCES LIMITED (06811566), CUADRILLA BOWLAND LIMITED (08340918), LUCAS BOWLAND (NO.2) LIMITED (08347365), LUCAS BOWLAND (UK) LIMITED (08341601)	SPIRIT ENERGY, SPIRIT ENERGY, CUADRILLA RESOURCES, A J LUCAS GROUP, A J LUCAS GROUP	CUADRILLA BOWLAND LIMITED	CUADRILLA RESOURCES	CUADRILLA BOWLAND LIMITED (51.25%), BOWLAND RESOURCES LIMITED (18.75%), LUCAS BOWLAND (NO.2) LIMITED (13.75%), LUCAS BOWLAND (UK) LIMITED (10%), BOWLAND RESOURCES (NO.2) LIMITED (6.25%)	OSGB NATIONAL GRID	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUADRILLA RESOURCES (51.25%), SPIRIT ENERGY (25.0%), A J LUCAS GROUP (23.75%)	Fri Jul 01 2039 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	100000000	40000
81057	29112991	ABOVE SMB	Above the base of the Subcrenatum Marine Band	SE40d	11	PEDL11	INFINIS ENERGY	100%	Thu Apr 04 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	7	ONSHORE	PEDL	Landward	REGENT PARK ENERGY LIMITED (04557422)	INFINIS ENERGY	REGENT PARK ENERGY LIMITED (04557422), EGDON RESOURCES U.K. LIMITED (03424561)	INFINIS ENERGY, HEYCO ENERGY GROUP	REGENT PARK ENERGY LIMITED	INFINIS ENERGY	REGENT PARK ENERGY LIMITED (100%)	OSGB NATIONAL GRID	Wed Mar 18 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 04 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Apr 04 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	INFINIS ENERGY (100%)	Sun Apr 04 2027 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	1000000	4000
81058	28722578	ALL	ALL	SE91d	1	DL1	EUROPA OIL AND GAS	100%	Mon Oct 19 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	2	ONSHORE	DL	Landward	EUROPA OIL & GAS LIMITED (03093716)	EUROPA OIL AND GAS	EUROPA OIL & GAS LIMITED (03093716)	EUROPA OIL AND GAS	EUROPA OIL & GAS LIMITED	EUROPA OIL AND GAS	EUROPA OIL & GAS LIMITED (100%)	OSGB NATIONAL GRID	Mon Oct 19 1987 00:00:00 GMT+0000 (Coordinated Universal Time)			EUROPA OIL AND GAS (100%)	Tue Oct 19 2027 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 19 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	9000000	12000
81059	35520726	ALL	ALL	SD43c	165	PEDL165	CUADRILLA RESOURCES	51.25%	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	13	ONSHORE	PEDL	Landward	CUADRILLA BOWLAND LIMITED (08340918)	CUADRILLA RESOURCES	BOWLAND RESOURCES (NO.2) LIMITED (06576443), BOWLAND RESOURCES LIMITED (06811566), CUADRILLA BOWLAND LIMITED (08340918), LUCAS BOWLAND (NO.2) LIMITED (08347365), LUCAS BOWLAND (UK) LIMITED (08341601)	SPIRIT ENERGY, SPIRIT ENERGY, CUADRILLA RESOURCES, A J LUCAS GROUP, A J LUCAS GROUP	CUADRILLA BOWLAND LIMITED	CUADRILLA RESOURCES	CUADRILLA BOWLAND LIMITED (51.25%), BOWLAND RESOURCES LIMITED (18.75%), LUCAS BOWLAND (NO.2) LIMITED (13.75%), LUCAS BOWLAND (UK) LIMITED (10%), BOWLAND RESOURCES (NO.2) LIMITED (6.25%)	OSGB NATIONAL GRID	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUADRILLA RESOURCES (51.25%), SPIRIT ENERGY (25.0%), A J LUCAS GROUP (23.75%)	Fri Jul 01 2039 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	59000000	40000
81060	35520726	ALL	ALL	SD43c	165	PEDL165	SPIRIT ENERGY	25.0%	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	13	ONSHORE	PEDL	Landward	CUADRILLA BOWLAND LIMITED (08340918)	CUADRILLA RESOURCES	BOWLAND RESOURCES (NO.2) LIMITED (06576443), BOWLAND RESOURCES LIMITED (06811566), CUADRILLA BOWLAND LIMITED (08340918), LUCAS BOWLAND (NO.2) LIMITED (08347365), LUCAS BOWLAND (UK) LIMITED (08341601)	SPIRIT ENERGY, SPIRIT ENERGY, CUADRILLA RESOURCES, A J LUCAS GROUP, A J LUCAS GROUP	CUADRILLA BOWLAND LIMITED	CUADRILLA RESOURCES	CUADRILLA BOWLAND LIMITED (51.25%), BOWLAND RESOURCES LIMITED (18.75%), LUCAS BOWLAND (NO.2) LIMITED (13.75%), LUCAS BOWLAND (UK) LIMITED (10%), BOWLAND RESOURCES (NO.2) LIMITED (6.25%)	OSGB NATIONAL GRID	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUADRILLA RESOURCES (51.25%), SPIRIT ENERGY (25.0%), A J LUCAS GROUP (23.75%)	Fri Jul 01 2039 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	59000000	40000
81061	35520726	ALL	ALL	SD43c	165	PEDL165	A J LUCAS GROUP	23.75%	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	13	ONSHORE	PEDL	Landward	CUADRILLA BOWLAND LIMITED (08340918)	CUADRILLA RESOURCES	BOWLAND RESOURCES (NO.2) LIMITED (06576443), BOWLAND RESOURCES LIMITED (06811566), CUADRILLA BOWLAND LIMITED (08340918), LUCAS BOWLAND (NO.2) LIMITED (08347365), LUCAS BOWLAND (UK) LIMITED (08341601)	SPIRIT ENERGY, SPIRIT ENERGY, CUADRILLA RESOURCES, A J LUCAS GROUP, A J LUCAS GROUP	CUADRILLA BOWLAND LIMITED	CUADRILLA RESOURCES	CUADRILLA BOWLAND LIMITED (51.25%), BOWLAND RESOURCES LIMITED (18.75%), LUCAS BOWLAND (NO.2) LIMITED (13.75%), LUCAS BOWLAND (UK) LIMITED (10%), BOWLAND RESOURCES (NO.2) LIMITED (6.25%)	OSGB NATIONAL GRID	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUADRILLA RESOURCES (51.25%), SPIRIT ENERGY (25.0%), A J LUCAS GROUP (23.75%)	Fri Jul 01 2039 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 24 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	9999/12/31 00:00:00+00	59000000	40000


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "subareaid" BIGINT,
  "subshortnm" VARCHAR,
  "subareanam" VARCHAR,
  "blockref" VARCHAR,
  "licno" BIGINT,
  "licref" VARCHAR,
  "eqgrphold" VARCHAR,
  "equity" VARCHAR,
  "licstartdt" TIMESTAMP,
  "licstatus" VARCHAR,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "location" VARCHAR,
  "lictype" VARCHAR,
  "licsubtype" VARCHAR,
  "admorg" VARCHAR,
  "admorggrp" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "oporg" VARCHAR,
  "oporggrp" VARCHAR,
  "eqorg" VARCHAR,
  "origidatum" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "initenddt" TIMESTAMP,
  "secenddt" TIMESTAMP,
  "eqorggrp" VARCHAR,
  "licenddt" TIMESTAMP,
  "rndstartdt" TIMESTAMP,
  "rndenddt" VARCHAR,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);