Baselight
Sign In

ENG Licences BNG

North Sea Transition Authority

@ukgov.eng_licences_bng3

Table 1
@ukgov.eng_licences_bng3.table_1

  • 52.29 KB
  • 91 rows
  • 51 columns
objectid

OBJECTID

datapid

DATAPID

location

LOCATION

licno

LICNO

licprefix

LICPREFIX

lictype

LICTYPE

licref

LICREF

licstatus

LICSTATUS

blockref

BLOCKREF

fields

FIELDS

licorg

LICORG

licorggrp

LICORGGRP

suboporg

SUBOPORG

subopgrps

SUBOPGRPS

regions

REGIONS

licstartdt

LICSTARTDT

licenddt

LICENDDT

licexpdt

LICEXPDT

licschsttd

LICSCHSTTD

schevents

SCHEVENTS

agreed_km2

AGREED KM2

calc_km2

CALC KM2

ph_a_start

PH A START

ph_a_end

PH A END

ph_b_start

PH B START

ph_b_end

PH B END

ph_c_start

PH C START

ph_c_end

PH C END

cur_phase

CUR PHASE

tm_1_start

TM 1 START

tm_1_end

TM 1 END

tm_2_start

TM 2 START

tm_2_end

TM 2 END

tm_3_start

TM 3 START

tm_3_end

TM 3 END

cur_term

CUR TERM

no_extns

NO EXTNS

hastm1

HASTM1

rndtype

RNDTYPE

rndno

RNDNO

rndstartdt

RNDSTARTDT

rndenddt

RNDENDDT

admorg

ADMORG

admhistnme

ADMHISTNME

admprvnams

ADMPRVNAMS

admorgno

ADMORGNO

admorggrp

ADMORGGRP

url

URL

pdfdateadd

PDFDATEADD

shapestarea

SHAPESTArea

shapestlength

SHAPESTLength

20748952458ONSHORE250EXLEXLEXL250ExtantSE64bSTILLINGFLEET COAL MINE VENTHARWORTH POWER (GENERATION) LIMITED (07896679)VELOX POWERHARWORTH POWER (GENERATION) LIMITED (07896679)VELOX POWEROnshoreSun Jul 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Jul 05 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Jul 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)11Sun Jul 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Jul 05 1998 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Jul 05 1998 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Jul 05 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Jul 05 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Jul 05 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Term 31YOnshore6HARWORTH POWER (GENERATION) LIMITEDHARWORTH POWER (GENERATION) LIMITED07896679VELOX POWERhttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/EXL250_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)10000004000
20749963103ONSHORE161PLPLPL161ExtantSE51c, SE60bASKERN COAL MINE VENT, HATFIELDEGDON RESOURCES U.K. LIMITED (03424561), REGENT PARK ENERGY LIMITED (04557422), SCOTTISHPOWER ENERGY MANAGEMENT LIMITED (SC215843)HEYCO ENERGY GROUP, INFINIS ENERGY, SCOTTISH POWER UK PLCEGDON RESOURCES U.K. LIMITED (03424561), REGENT PARK ENERGY LIMITED (04557422), SCOTTISHPOWER ENERGY MANAGEMENT LIMITED (SC215843)HEYCO ENERGY GROUP, INFINIS ENERGY, SCOTTISH POWER UK PLCOnshoreWed Jun 02 1971 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Jun 02 2027 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Jun 02 1971 00:00:00 GMT+0000 (Coordinated Universal Time)55.62555.625Wed Jun 02 1971 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jun 02 1977 00:00:00 GMT+0000 (Coordinated Universal Time)1YRestricted OnshoreREGENT PARK ENERGY LIMITEDREGENT PARK ENERGY LIMITEDGREENPARK ENERGY LIMITED04557422INFINIS ENERGYhttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PL161_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)5562500048721.3203435596
20750964734ONSHORE327PEDLPEDLPEDL327ExtantSY79a, SY88d, SY89bSOUTH WESTERN ENERGY LIMITED (08019159)SOUTH WESTERN ENERGY LIMITEDSOUTH WESTERN ENERGY LIMITED (08019159)SOUTH WESTERN ENERGY LIMITEDIrish Sea, OnshoreThu Jul 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Jul 21 2046 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jul 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)161.662161.66163544Thu Jul 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Jul 21 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Jul 21 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Jul 21 2026 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Jul 21 2026 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Jul 21 2046 00:00:00 GMT+0000 (Coordinated Universal Time)Term 12YOnshore14Mon Jul 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)SOUTH WESTERN ENERGY LIMITEDSOUTH WESTERN ENERGY LIMITEDMANDACO 726 LIMITED08019159SOUTH WESTERN ENERGY LIMITEDhttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PEDL327_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)161661635.44035283634.4202044732
20751965341ONSHORE277PEDLPEDLPEDL277ExtantSE50cALKANE ENERGY UK LIMITED (03128509)INFINIS ENERGYALKANE ENERGY UK LIMITED (03128509)INFINIS ENERGYOnshoreThu Jul 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Jul 21 2046 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jul 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1.651.65Thu Jul 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Jul 21 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Jul 21 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Jul 21 2026 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Jul 21 2026 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Jul 21 2046 00:00:00 GMT+0000 (Coordinated Universal Time)Term 12YOnshore14Mon Jul 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)ALKANE ENERGY UK LIMITEDALKANE ENERGY UK LIMITEDCOALGAS (UK) LIMITED03128509INFINIS ENERGYhttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PEDL277_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)16500005200
207521113243ONSHORE235PLPLPL235ExtantTQ14a, TQ24aBROCKHAMANGUS ENERGY WEALD BASIN NO.3 LIMITED (SC055329), BROCKHAM CAPITAL LIMITED (02196647), TERRAIN ENERGY LIMITED (07004014)ANGUS ENERGY, BROCKHAM CAPITAL LIMITED, TERRAIN ENERGYANGUS ENERGY WEALD BASIN NO.3 LIMITED (SC055329)ANGUS ENERGYOnshoreFri Oct 28 1983 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Oct 28 2026 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Oct 28 1983 00:00:00 GMT+0000 (Coordinated Universal Time)8.968.96Fri Oct 28 1983 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Oct 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Oct 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Oct 28 2026 00:00:00 GMT+0000 (Coordinated Universal Time)Term 3YRestricted OnshoreANGUS ENERGY WEALD BASIN NO.3 LIMITEDANGUS ENERGY WEALD BASIN NO.3 LIMITEDKEY PETROLEUM WEALD BASIN LIMITED, MIDMAR ENERGY ONSHORE LIMITED, SAGA PETROLEUM ONSHORE UK LIMITED, SANTA FE MINERALS ONSHORE (U.K.) LIMITED, DENHOLM EXPLORATION LIMITEDSC055329ANGUS ENERGYhttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PL235_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)896000015800
207531182025ONSHORE120PEDLPEDLPEDL120ExtantSE68a, SE78a, SE78e, SE88b, SE98bINEOS UPSTREAM LIMITED (09121775)INEOS INDUSTRIESINEOS UPSTREAM LIMITED (09121775)INEOS INDUSTRIESOnshoreFri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 01 2033 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)234234Fri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Dec 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Oct 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Oct 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 01 2033 00:00:00 GMT+0000 (Coordinated Universal Time)Term 31YOnshore10INEOS UPSTREAM LIMITEDINEOS UPSTREAM LIMITED09121775INEOS INDUSTRIEShttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PEDL120_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)234000000124000
207541285245ONSHORE213PLPLPL213ExtantSK36c, SK37c, SK46b, SK47dSEVEN STAR NATURAL GAS LIMITED (05330862)INFINIS ENERGYSEVEN STAR NATURAL GAS LIMITED (05330862)INFINIS ENERGYOnshoreMon Aug 09 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Aug 09 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Aug 09 1982 00:00:00 GMT+0000 (Coordinated Universal Time)55Mon Aug 09 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Aug 09 1986 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Aug 09 1986 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Aug 09 2006 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Aug 09 2006 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Aug 09 2025 00:00:00 GMT+0000 (Coordinated Universal Time)Term 31YRestricted OnshoreSEVEN STAR NATURAL GAS LIMITEDSEVEN STAR NATURAL GAS LIMITED05330862INFINIS ENERGYhttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PL213_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)50000009000
207551198422ONSHORE215PLPLPL215ExtantSK67b, SK77g, SK86a, SK87jFARLEYS WOODBLACKLAND PARK EXPLORATION LIMITED (01881647), ONSHORE PRODUCTION SERVICES LIMITED (04252529)BRITNRG LIMITED, ONSHORE OILFIELD SERVICES LIMITEDONSHORE OILFIELD SERVICES LIMITED (03192463), BLACKLAND PARK EXPLORATION LIMITED (01881647)ONSHORE OILFIELD SERVICES LIMITED, BRITNRG LIMITEDOnshoreMon Aug 09 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Aug 09 2026 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Aug 09 1982 00:00:00 GMT+0000 (Coordinated Universal Time)9.1319.1312Mon Aug 09 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Aug 09 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1YRestricted OnshoreONSHORE OILFIELD SERVICES LIMITEDONSHORE OILFIELD SERVICES LIMITED03192463ONSHORE OILFIELD SERVICES LIMITEDhttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PL215_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)913120018265.0623095019
207561315565ONSHORE164PEDLPEDLPEDL164ExtantSD30AURORA ENERGY RESOURCES LIMITED (SC335749)AURORA PETROLEUMAURORA ENERGY RESOURCES LIMITED (SC335749)AURORA PETROLEUMOnshoreTue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Jul 01 2039 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)100100Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Jul 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Jul 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Jul 01 2039 00:00:00 GMT+0000 (Coordinated Universal Time)Term 33YOnshore13Wed Nov 07 2007 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Feb 06 2008 00:00:00 GMT+0000 (Coordinated Universal Time)AURORA ENERGY RESOURCES LIMITEDAURORA ENERGY RESOURCES LIMITEDAURORA EXPLORATION (UK) LIMITED, EDP ONSHORE LIMITED, PACIFIC SHELF 1485 LIMITEDSC335749AURORA PETROLEUMhttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PEDL164_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)10000000040000
207571108932ONSHORE211PLPLPL211ExtantSU61c, SU71cHORNDEANISLAND GAS LIMITED (04962079), UKOG (GB) LIMITED (04050227)STAR ENERGY GROUP PLC, UK OIL & GAS PLCISLAND GAS LIMITED (04962079)STAR ENERGY GROUP PLCOnshoreMon Apr 05 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Apr 05 2026 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Apr 05 1982 00:00:00 GMT+0000 (Coordinated Universal Time)27.2527.25Mon Apr 05 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Sat Apr 05 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1YRestricted OnshoreISLAND GAS LIMITEDISLAND GAS LIMITEDCOTWOGAS LIMITED, BDO STOY HAYWARD (2003) LIMITED04962079STAR ENERGY GROUP PLChttps://datanstauthority.blob.core.windows.net/external/Redacted_Licence_Docs/PL211_LICENCE_Redacted.pdfMon Aug 05 2019 15:19:19 GMT+0000 (Coordinated Universal Time)2725000026000

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "datapid" BIGINT,
  "location" VARCHAR,
  "licno" BIGINT,
  "licprefix" VARCHAR,
  "lictype" VARCHAR,
  "licref" VARCHAR,
  "licstatus" VARCHAR,
  "blockref" VARCHAR,
  "fields" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "suboporg" VARCHAR,
  "subopgrps" VARCHAR,
  "regions" VARCHAR,
  "licstartdt" TIMESTAMP,
  "licenddt" VARCHAR,
  "licexpdt" TIMESTAMP,
  "licschsttd" TIMESTAMP,
  "schevents" VARCHAR,
  "agreed_km2" DOUBLE,
  "calc_km2" DOUBLE,
  "ph_a_start" VARCHAR,
  "ph_a_end" VARCHAR,
  "ph_b_start" VARCHAR,
  "ph_b_end" VARCHAR,
  "ph_c_start" VARCHAR,
  "ph_c_end" VARCHAR,
  "cur_phase" VARCHAR,
  "tm_1_start" TIMESTAMP,
  "tm_1_end" TIMESTAMP,
  "tm_2_start" TIMESTAMP,
  "tm_2_end" TIMESTAMP,
  "tm_3_start" TIMESTAMP,
  "tm_3_end" TIMESTAMP,
  "cur_term" VARCHAR,
  "no_extns" BIGINT,
  "hastm1" VARCHAR,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "rndstartdt" TIMESTAMP,
  "rndenddt" TIMESTAMP,
  "admorg" VARCHAR,
  "admhistnme" VARCHAR,
  "admprvnams" VARCHAR,
  "admorgno" VARCHAR,
  "admorggrp" VARCHAR,
  "url" VARCHAR,
  "pdfdateadd" TIMESTAMP,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);

Share link

Anyone who has the link will be able to view this.