CS Licences ED50
North Sea Transition Authority
@ukgov.cs_licences_ed502
Table 1
@ukgov.cs_licences_ed502.table_1
- 15.06 KB
- 29 rows
- 15 columns
objectidOBJECTID | licrefLICREF | shape_areaShape, Area | shape_lengthShape, Length | round_noROUND NO | exploration_operatorEXPLORATION OPERATOR | partner_org_1PARTNER ORG 1 | partner_org_2PARTNER ORG 2 | partner_org_3PARTNER ORG 3 | partner_org_4PARTNER ORG 4 | award_processAWARD PROCESS | licstartdtLICSTARTDT | licence_doc_linkLICENCE DOC LINK | pub_reg_linkPUB REG LINK | doc_add_dateDOC ADD DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CS001 | 0.049892070142905 | 1.10962160551291 | BP EXPLORATION OPERATING COMPANY LIMITED | EQUINOR NEW ENERGY LIMITED | OUT OF ROUND | Fri Nov 02 2012 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/f1vfr40j/carbon-dioxide-appraisal-and-storage-licence-cs001-deed-of-variation-dated-2-april-2024.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | Fri Sep 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 4 | CS005 | 0.109166666416667 | 1.6 | CHRYSAOR PRODUCTION (UK) LIMITED | OUT OF ROUND | Fri Oct 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/8097/cs005-signed-copy-_redacted.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | Tue Mar 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||
| 5 | CS006 | 0.103055555527778 | 1.666666666 | BP EXPLORATION OPERATING COMPANY LIMITED | EQUINOR NEW ENERGY LIMITED | OUT OF ROUND | Sun May 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/8156/cs006_licence_redacted-accessabile-1.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 6 | CS007 | 0.0958333334 | 1.466666669 | BP EXPLORATION OPERATING COMPANY LIMITED | EQUINOR NEW ENERGY LIMITED | OUT OF ROUND | Sun May 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/8157/cs007_licence_redacted-1.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 7 | CS025 | 0.0633333333 | 1.133333332 | 1 | BP EXPLORATION OPERATING COMPANY LIMITED | EQUINOR NEW ENERGY LIMITED | LICENSING ROUND | Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/jqufgg0j/carbon-dioxide-appraisal-and-storage-licence-cs025-deed-of-variation-dated-13-march-2024redacted-1.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | ||||
| 8 | CS023 | 0.0502777776888889 | 1.033333332 | 1 | CHRYSAOR PRODUCTION (UK) LIMITED | BP EXPLORATION OPERATING COMPANY LIMITED | LICENSING ROUND | Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/mi4pwbak/cs023-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accessability-copy.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | ||||
| 9 | CS024 | 0.0258333334666667 | 0.766666668 | 1 | CHRYSAOR PRODUCTION (UK) LIMITED | BP EXPLORATION OPERATING COMPANY LIMITED | LICENSING ROUND | Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/ybrbxpqg/cs024-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accessability-copy.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | ||||
| 10 | CS008 | 0.0844444443722222 | 1.433333332 | 1 | ENI UK LIMITED | LICENSING ROUND | Sat Jul 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/44oavkxu/cs008-eni-uk-limited-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accesability-copy.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | |||||
| 11 | CS013 | 0.04 | 0.8 | 1 | ENQUEST CCS LIMITED | LICENSING ROUND | Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/y4dg2wtb/cs013-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accesible-version.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | |||||
| 12 | CS014 | 0.0166666666 | 0.533333332 | 1 | ENQUEST CCS LIMITED | LICENSING ROUND | Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/wfwdjf0h/cs014-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accessible-version.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ |
CREATE TABLE table_1 (
"objectid" BIGINT,
"licref" VARCHAR,
"shape_area" DOUBLE,
"shape_length" DOUBLE,
"round_no" BIGINT,
"exploration_operator" VARCHAR,
"partner_org_1" VARCHAR,
"partner_org_2" VARCHAR,
"partner_org_3" VARCHAR,
"partner_org_4" VARCHAR,
"award_process" VARCHAR,
"licstartdt" TIMESTAMP,
"licence_doc_link" VARCHAR,
"pub_reg_link" VARCHAR,
"doc_add_date" TIMESTAMP
);