Exploration And Appraisal Wells

North Sea Transition Authority

@ukgov.exploration_and_appraisal_wells8

Table List

1 table(48.17 KB)

Table 1

@ukgov.exploration_and_appraisal_wells8.table_1

48.17 KB
103 rows
54 columns

x X	y Y	objectid OBJECTID	well_no Well No	well_class Well Class	lic_no Lic No	lic_op Lic Op	spud_date Spud Date	water_dep_m Water Dep M	rig_datum Rig Datum	datum_elev_m Datum Elev M	td_md_m TD MD M	td_tvdss_m TD TVDSS M	td_date TD Date	mech_stat Mech Stat	t1_age T1 Age	t1_name T1 Name	r1_age R1 Age	r1_name R1 Name	r1_thick_m R1 Thick M	r1_rock R1 Rock	r1_fluid R1 Fluid	r1_flow_hrs R1 Flow Hrs	r1_rate_bblsd R1 Rate Bblsd	r1_choke R1 Choke	r1_oil_ton R1 Oil Ton	r1_gas_m3 R1 Gas M3	r1_whp_bar R1 WHP Bar	r1_wht_oc R1 WHT OC	r1_waterpc R1 WaterPC	t2_age T2 Age	t2_name T2 Name	r2_age R2 Age	r2_name R2 Name	r2_thick_m R2 Thick M	r2_rock R2 Rock	t3_age T3 Age	t3_name T3 Name	r3_age R3 Age	r3_name R3 Name	r3_thick_m R3 Thick M	r3_rock R3 Rock	r3_fluid R3 Fluid	comments Comments
1.31058000000007	54.546217778	1	43/12a- 3	Exploration	P2128	SPIRIT ENERGY RESOURCES LIMITED	Mon Jul 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	31.1	Mean Sea Level	56.7	3871	3739.9	Tue Oct 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Westphalian	Westphalian A	Westphalian	Westphalian A	21.6	Sandstone	Gas
1.35710416700005	58.9140072220001	2	16/02a- 6	Exploration	P2319	EQUINOR UK LIMITED	Fri Jun 18 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	116	Rotary Table	31	2456	2425	Thu Jul 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Upper Jurassic	Piper Formation														Lower Permian	Rotliegendes Group												Targets not encountered.
0.699822828000038	54.938151292	3	42/04- 1Z	Exploration	P2133	ONE-DYAS NORTH SEA LIMITED	Mon Jul 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	71	Rotary Table	45	2278	2265	Sat Jul 13 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Permian	Zechstein Fm	Permian	Zechstein Fm	3.7	Limestone	Oil	81	3500	32/64	62	15000	84	44.1	79														Test did not progress further than the cleanup phase
0.699822828000038	54.938151292	4	42/04- 1	Exploration	P2133	ONE-DYAS NORTH SEA LIMITED	Thu May 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	71	Rotary Table	45	3300	3255.3	Tue Jul 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Carboniferous	Yoredale Formation	Carboniferous	Yoredale	286.3	Sandstone and Shale										Carboniferous	Fell Sandstone	Carboniferous	Fell Sandstone	407	Sandstone and Shale	Permian	Zechstein Fm	Permian	Zechstein Fm	44.1	Limestone	Oil	Well mechanically sidetracked
2.47643527800005	56.583400833	5	30/13e- 12Z	Appraisal	P2456	CHRYSAOR PETROLEUM COMPANY U.K. LIMITED	Wed Sep 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	72.8	Rotary Table	43.9	5170.6	2991.3	Thu Sep 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Palaeocene	L2 Sandstone Unit	Palaeocene	L2 Sandstone Unit	7.4	Sandstone	Oil
1.07335466700005	57.942349972	6	22/01b- 12Y	Appraisal	P2373	ITHACA OIL AND GAS LIMITED	Mon Sep 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	131.4	Rotary Table	23.2	3291.8	2216	Sat Sep 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Eocene	Caran Sandstone Member	Eocene	Caran Sandstone Member	28.1	Sandstone	Oil, Gas & Water
1.07335466700005	57.942349972	7	22/01b- 12Z	Appraisal	P2373	ITHACA OIL AND GAS LIMITED	Tue Aug 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	131.4	Rotary Table	23.2	2263.7	2232.5	Tue Sep 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Eocene	Caran Sandstone Member	Eocene	Caran Sandstone Member	31	Sandstone	Oil, Gas & Water
1.07335466700005	57.942349972	8	22/01b- 12	Exploration	P2373	ITHACA OIL AND GAS LIMITED	Thu Aug 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	131.4	Rotary Table	23.2	2578.6	2362.7	Thu Aug 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Eocene	Caran Sandstone Member	Eocene	Caran Sandstone Member	19.6	Sandstone	Oil & Gas
1.14686111100002	57.1340555560001	9	22/26d- 3	Appraisal	P2215	CNOOC PETROLEUM EUROPE LIMITED	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	82	Rotary Table	48.5	4904.8	4791.5	Fri Apr 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AB3	Upper Jurassic	Freshney Sandstone Member	Upper Jurassic	Freshney Sandstone Member	186.5	Sandstone	Water
2.47643527800005	56.583400833	10	30/13e- 12	Appraisal	P2456	CHRYSAOR PETROLEUM COMPANY U.K. LIMITED	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	72.8	Rotary Table	49.1	3377.2	3029.7	Thu Aug 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	AB1	Palaeocene	L2 Sandstone Unit	Palaeocene	L2 Sandstone Unit	4.9	Sandstone	Oil


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "well_no" VARCHAR,
  "well_class" VARCHAR,
  "lic_no" VARCHAR,
  "lic_op" VARCHAR,
  "spud_date" TIMESTAMP,
  "water_dep_m" DOUBLE,
  "rig_datum" VARCHAR,
  "datum_elev_m" DOUBLE,
  "td_md_m" DOUBLE,
  "td_tvdss_m" DOUBLE,
  "td_date" TIMESTAMP,
  "mech_stat" VARCHAR,
  "t1_age" VARCHAR,
  "t1_name" VARCHAR,
  "r1_age" VARCHAR,
  "r1_name" VARCHAR,
  "r1_thick_m" VARCHAR,
  "r1_rock" VARCHAR,
  "r1_fluid" VARCHAR,
  "r1_flow_hrs" DOUBLE,
  "r1_rate_bblsd" DOUBLE,
  "r1_rate_mmcfd" DOUBLE,
  "r1_choke" VARCHAR,
  "r1_oil_ton" DOUBLE,
  "r1_gas_m3" DOUBLE,
  "r1_cond_m3" DOUBLE,
  "r1_whp_bar" DOUBLE,
  "r1_wht_oc" DOUBLE,
  "r1_waterpc" DOUBLE,
  "t2_age" VARCHAR,
  "t2_name" VARCHAR,
  "r2_age" VARCHAR,
  "r2_name" VARCHAR,
  "r2_thick_m" VARCHAR,
  "r2_rock" VARCHAR,
  "r2_fluid" VARCHAR,
  "t3_age" VARCHAR,
  "t3_name" VARCHAR,
  "r3_age" VARCHAR,
  "r3_name" VARCHAR,
  "r3_thick_m" VARCHAR,
  "r3_rock" VARCHAR,
  "r3_fluid" VARCHAR,
  "t4_age" VARCHAR,
  "t4_name" VARCHAR,
  "r4_age" VARCHAR,
  "r4_name" VARCHAR,
  "r4_thick_m" DOUBLE,
  "r4_rock" VARCHAR,
  "r4_fluid" VARCHAR,
  "comments" VARCHAR
);