NSTA Licensed Blocks History (BNG)

North Sea Transition Authority

@ukgov.nsta_licensed_blocks_history_bng3

Table List

1 table(97.29 KB)

Table 1

@ukgov.nsta_licensed_blocks_history_bng3.table_1

97.29 KB
932 rows
31 columns

objectid OBJECTID	licblockid LICBLOCKID	quadno QUADNO	blockno BLOCKNO	suffix SUFFIX	blockref BLOCKREF	blckstrtdt BLCKSTRTDT	blckenddt BLCKENDDT	agreed_km2 AGREED KM2	calc_km2 CALC KM2	lictype LICTYPE	licno LICNO	licref LICREF	licstartdt LICSTARTDT	licstatus LICSTATUS	rndtype RNDTYPE	rndno RNDNO	location LOCATION	licsubtype LICSUBTYPE	origidatum ORIGIDATUM	admorg ADMORG	admorggrp ADMORGGRP	licorg LICORG	licorggrp LICORGGRP	oporg OPORG	oporggrp OPORGGRP	admhisname ADMHISNAME	lichisname LICHISNAME	ophisnames OPHISNAMES	shapestarea SHAPESTArea	shapestlength SHAPESTLength
158255	26495	NS	97	a	NS97a	Wed Jun 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Feb 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20	20	PEDL	133	PEDL133	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Revoked	Onshore		ONSHORE	Landward	OSGB NATIONAL GRID	IGAS ENERGY PRODUCTION LIMITED (SC298739)	STAR ENERGY GROUP PLC	BG INTERNATIONAL LIMITED (00902239), IGAS ENERGY PRODUCTION LIMITED (SC298739)	SHELL PLC, STAR ENERGY GROUP PLC	IGAS ENERGY PRODUCTION LIMITED (SC298739)	STAR ENERGY GROUP PLC	COMPOSITE ENERGY (FORTH VALLEY) LIMITED (SC298739)	BG INTERNATIONAL LIMITED (00902239), COMPOSITE ENERGY (FORTH VALLEY) LIMITED (SC298739)	COMPOSITE ENERGY (FORTH VALLEY) LIMITED (SC298739)	20000000	24000
158256	26496	NS	99	a	NS99a	Wed Jun 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Feb 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	77	77	PEDL	133	PEDL133	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Revoked	Onshore		ONSHORE	Landward	OSGB NATIONAL GRID	IGAS ENERGY PRODUCTION LIMITED (SC298739)	STAR ENERGY GROUP PLC	BG INTERNATIONAL LIMITED (00902239), IGAS ENERGY PRODUCTION LIMITED (SC298739)	SHELL PLC, STAR ENERGY GROUP PLC	IGAS ENERGY PRODUCTION LIMITED (SC298739)	STAR ENERGY GROUP PLC	COMPOSITE ENERGY (FORTH VALLEY) LIMITED (SC298739)	BG INTERNATIONAL LIMITED (00902239), COMPOSITE ENERGY (FORTH VALLEY) LIMITED (SC298739)	COMPOSITE ENERGY (FORTH VALLEY) LIMITED (SC298739)	77000000	36000
158257	3409305	ND	2	a	ND2a	Fri Oct 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	25.732	25.731625	PEDL	158	PEDL158	Fri Oct 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Revoked	Onshore	12	ONSHORE	Landward	OSGB NATIONAL GRID	IGAS ENERGY ENTERPRISE LIMITED (05457589)	STAR ENERGY GROUP PLC	IGAS ENERGY ENTERPRISE LIMITED (05457589), JERSEY EXPLORATION LTD (SC319459)	JERSEY OIL AND GAS PLC, STAR ENERGY GROUP PLC	IGAS ENERGY ENTERPRISE LIMITED (05457589)	STAR ENERGY GROUP PLC	CAITHNESS OIL LIMITED (05457589)	CAITHNESS OIL LIMITED (05457589), REACH EXPLORATION (UK) LIMITED (SC319459)	CAITHNESS OIL LIMITED (05457589)	25731625	26590.3166966983
158258	3346141	SE	63		SE63	Fri Sep 08 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 30 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	100	100	PEDL	65	PEDL65	Fri Sep 08 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Surrendered	Onshore	9	ONSHORE	Landward	OSGB NATIONAL GRID	REGENT PARK ENERGY LIMITED (04557422)	INFINIS ENERGY	REGENT PARK ENERGY LIMITED (04557422)	INFINIS ENERGY	REGENT PARK ENERGY LIMITED (04557422)	INFINIS ENERGY	GREENPARK ENERGY LIMITED (04557422)	GREENPARK ENERGY LIMITED (04557422)	GREENPARK ENERGY LIMITED (04557422)	100000000	40000
158259	669442	SK	31		SK31	Fri Sep 08 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 08 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	100	100	PEDL	61	PEDL61	Fri Sep 08 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Surrendered	Onshore	9	ONSHORE	Landward	OSGB NATIONAL GRID	ALKANE ENERGY UK LIMITED (03128509)	INFINIS ENERGY	ALKANE ENERGY UK LIMITED (03128509)	INFINIS ENERGY	ALKANE ENERGY UK LIMITED (03128509)	INFINIS ENERGY	COALGAS (UK) LIMITED (03128509)	COALGAS (UK) LIMITED (03128509)	COALGAS (UK) LIMITED (03128509)	100000000	40000
158260	8997796	SE	50	a	SE50a	Fri Jan 04 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 18 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	4	4	PEDL	11	PEDL11	Thu Apr 04 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	7	ONSHORE	Landward	OSGB NATIONAL GRID	REGENT PARK ENERGY LIMITED (04557422)	INFINIS ENERGY	REGENT PARK ENERGY LIMITED (04557422)	INFINIS ENERGY	REGENT PARK ENERGY LIMITED (04557422)	INFINIS ENERGY	GREENPARK ENERGY LIMITED (04557422)	GREENPARK ENERGY LIMITED (04557422)	GREENPARK ENERGY LIMITED (04557422)	4000000	8000
158261	8884588	SE	70	a	SE70a	Wed Jun 02 1971 00:00:00 GMT+0000 (Coordinated Universal Time)		68	68	PL	162	PL162	Wed Jun 02 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore		ONSHORE	Landward	OSGB NATIONAL GRID	SALTFLEETBY ENERGY LIMITED (00953066)	ANGUS ENERGY	SALTFLEETBY ENERGY LIMITED (00953066)	ANGUS ENERGY	SALTFLEETBY ENERGY LIMITED (00953066)	ANGUS ENERGY	ANCO EXPLORATION (U.K.) LIMITED (00953066)	ANCO EXPLORATION (U.K.) LIMITED (00953066)	ANCO EXPLORATION (U.K.) LIMITED (00953066)	68000000	36000
158262	8884589	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)	Extant	Onshore		ONSHORE	Landward	OSGB NATIONAL GRID	SALTFLEETBY ENERGY LIMITED (00953066)	ANGUS ENERGY	SALTFLEETBY ENERGY LIMITED (00953066)	ANGUS ENERGY	SALTFLEETBY ENERGY LIMITED (00953066)	ANGUS ENERGY	ANCO EXPLORATION (U.K.) LIMITED (00953066)	ANCO EXPLORATION (U.K.) LIMITED (00953066)	ANCO EXPLORATION (U.K.) LIMITED (00953066)	46000000	32000
158263	15169129	TF	9	a	TF9a	Sun Jun 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		5	5	PEDL	241	PEDL241	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Extant	Onshore	13	ONSHORE	Landward	OSGB NATIONAL GRID	EGDON RESOURCES U.K. LIMITED (03424561)	HEYCO ENERGY GROUP	EGDON RESOURCES U.K. LIMITED (03424561), UNION JACK OIL PLC (07497220)	HEYCO ENERGY GROUP, UNION JACK OIL PLC	EGDON RESOURCES U.K. LIMITED (03424561)	HEYCO ENERGY GROUP	EGDON RESOURCES U.K. LIMITED (03424561)	EGDON RESOURCES U.K. LIMITED (03424561), UNION JACK OIL PLC (07497220)	EGDON RESOURCES U.K. LIMITED (03424561)	5000000	12000
158264	3349207	NO	30	b	NO30b	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	12	12	PEDL	161	PEDL161	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Surrendered	Onshore	13	ONSHORE	Landward	OSGB NATIONAL GRID	DART ENERGY (EUROPE) LIMITED (SC259898)	STAR ENERGY GROUP PLC	BG INTERNATIONAL LIMITED (00902239), DART ENERGY (EUROPE) LIMITED (SC259898)	SHELL PLC, STAR ENERGY GROUP PLC	DART ENERGY (EUROPE) LIMITED (SC259898)	STAR ENERGY GROUP PLC	COMPOSITE ENERGY LIMITED (SC259898)	BG INTERNATIONAL LIMITED (00902239), COMPOSITE ENERGY LIMITED (SC259898)	COMPOSITE ENERGY LIMITED (SC259898)	12000000	14000


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "licblockid" BIGINT,
  "quadno" VARCHAR,
  "blockno" BIGINT,
  "suffix" VARCHAR,
  "blockref" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "blckenddt" TIMESTAMP,
  "agreed_km2" DOUBLE,
  "calc_km2" DOUBLE,
  "lictype" VARCHAR,
  "licno" BIGINT,
  "licref" VARCHAR,
  "licstartdt" TIMESTAMP,
  "licstatus" VARCHAR,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "location" VARCHAR,
  "licsubtype" VARCHAR,
  "origidatum" VARCHAR,
  "admorg" VARCHAR,
  "admorggrp" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "oporg" VARCHAR,
  "oporggrp" VARCHAR,
  "admhisname" VARCHAR,
  "lichisname" VARCHAR,
  "ophisnames" VARCHAR,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);