NSTA Onshore Licence Relinquishments (BNG)

North Sea Transition Authority

@ukgov.nsta_onshore_licence_relinquishments_bng4

Table List

1 table(43.97 KB)

Table 1

@ukgov.nsta_onshore_licence_relinquishments_bng4.table_1

43.97 KB
557 rows
24 columns

objectid OBJECTID	blockref BLOCKREF	quadno QUADNO	blockno BLOCKNO	blocksuffi BLOCKSUFFI	licref LICREF	lictype LICTYPE	licno LICNO	rndtype RNDTYPE	rndno RNDNO	admorg ADMORG	admorggrp ADMORGGRP	licorg LICORG	licorggrp LICORGGRP	subareaorg SUBAREAORG	sareaorgrp SAREAORGRP	reldate RELDATE	location LOCATION	origdatum ORIGDATUM	relreport RELREPORT	blckstrtdt BLCKSTRTDT	rel_check REL CHECK	link LINK	reportadd REPORTADD
1	SY68	SY	68		PEDL237	PEDL	237	N	13	EGDON RESOURCES PLC	EGDON RESOURCES	AURORA PRODUCTION (UK) LIMITED, CORFE ENERGY LIMITED, DORSET EXPLORATION LIMITED, EGDON RESOURCES U.K. LIMITED, FIRST OIL EXPRO LIMITED	AURORA PETROLEUM, CORFE ENERGY, EGDON RESOURCES, EGDON RESOURCES, FIRST OIL EXPRO	EGDON RESOURCES U.K. LIMITED	EGDON RESOURCES	Thu Jun 11 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL237_SY6080_SY7080_EGDON_RelReport_OCT2016.pdf	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL237_SY6080_SY7080_EGDON_RelReport_OCT2016.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
2	SK63	SK	63		PEDL254	PEDL	254	N	13	HUTTON ENERGY UK LIMITED	HUTTON ENERGY LIMITED	HUTTON ENERGY UK LIMITED	HUTTON ENERGY LIMITED	HUTTON ENERGY UK LIMITED	HUTTON ENERGY LIMITED	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL254_SK6030_HUTTON_RelReport_SEP2017.pdf	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL254_SK6030_HUTTON_RelReport_SEP2017.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
3	SU91a	SU	91	a	PEDL233	PEDL	233	N	13					IGAS ENERGY ENTERPRISE LIMITED	IGAS PLC	Sat Jun 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL233_SU9010_IGAS_RelReport_OCT2018.pdf	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL233_SU9010_IGAS_RelReport_OCT2018.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
4	SZ8c	SZ	8	c	PEDL330	PEDL	330	N	14					CORALLIAN ENERGY LIMITED	SHELL PLC	Sun Jan 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL330_CORALLIAN_RelReport_MAR2021.pdf	Thu Sep 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL330_CORALLIAN_RelReport_MAR2021.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
5	SZ38b	SZ	38	b	PEDL240	PEDL	240	N	13					NORTHERN PETROLEUM (GB) LIMITED	UK OIL & GAS PLC	Mon Mar 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL240_SZ3080_SZ4080_NORTHERN_RelReport_OCT2014.pdf	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL240_SZ3080_SZ4080_NORTHERN_RelReport_OCT2014.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
6	SZ48d	SZ	48	d	PEDL240	PEDL	240	N	13					NORTHERN PETROLEUM (GB) LIMITED	UK OIL & GAS PLC	Mon Mar 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL240_SZ3080_SZ4080_NORTHERN_RelReport_OCT2014.pdf	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL240_SZ3080_SZ4080_NORTHERN_RelReport_OCT2014.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
7	SU60a	SU	60	a	PEDL256	PEDL	256	D						NP WEALD LIMITED	UK OIL & GAS PLC	Mon Mar 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL256_SU6000_NORTHERN_RelReport_OCT2014.pdf	Fri May 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL256_SU6000_NORTHERN_RelReport_OCT2014.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
8	SK64a	SK	64	a	PEDL255	PEDL	255	N	13	ALKANE ENERGY UK LIMITED	INFINIS ENERGY	ALKANE ENERGY UK LIMITED, HUTTON ENERGY UK LIMITED	HUTTON ENERGY LIMITED, INFINIS ENERGY	ALKANE ENERGY UK LIMITED, HUTTON ENERGY UK LIMITED	HUTTON ENERGY LIMITED, INFINIS ENERGY	Fri Jun 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL255_SK6040_HUTTON_RelReport_AUG2017.pdf	Thu Jun 05 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Partial	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL255_SK6040_HUTTON_RelReport_AUG2017.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
9	SK72a	SK	72	a	PEDL312	PEDL	312	N	14					HUTTON ENERGY LIMITED	HUTTON ENERGY LIMITED	Fri Jul 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL312_SK7020_HUTTON_RelReport_AUG2020.pdf	Thu Sep 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL312_SK7020_HUTTON_RelReport_AUG2020.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)
10	NZ90	NZ	90		PEDL258	PEDL	258	N	14					EGDON RESOURCES U.K. LIMITED	EGDON RESOURCES	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ONSHORE	OSGB NATIONAL GRID	https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL258_NZ9000_EGDON_RelReport_OCT2021.pdf	Fri Jul 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/onshore/Relinquishments/PEDL258_NZ9000_EGDON_RelReport_OCT2021.pdf" target="_blank">Click Here</a>	Wed Jun 28 2023 23:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "blockref" VARCHAR,
  "quadno" VARCHAR,
  "blockno" BIGINT,
  "blocksuffi" VARCHAR,
  "licref" VARCHAR,
  "lictype" VARCHAR,
  "licno" BIGINT,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "admorg" VARCHAR,
  "admorggrp" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "subareaorg" VARCHAR,
  "sareaorgrp" VARCHAR,
  "reldate" TIMESTAMP,
  "location" VARCHAR,
  "origdatum" VARCHAR,
  "relreport" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "rel_check" VARCHAR,
  "link" VARCHAR,
  "reportadd" TIMESTAMP
);