Preview Completion Stimulation Materials

First 100 rows

Out of roughly 516.7K rows in texas.cmpl_akm_data. Version obs-6af89954445a.

`tracking_no`	`packet_id`	`parent_id`	`row_no`	`from_depth`	`to_depth`	`material_used`
3568	5479	4951	1	3770.0	3773.0	CIBP AT 3750 WITH 20 CEMENT
3568	5479	4951	2	3806.0	3807.0	CIBP AT 3784
3568	5479	4951	3	3809.0	3814.0	SQUEEZE WITH 125 SKS CEMENT
7007	9943	7721	2	13400.0	13400.0	CBP + 20 CEMENT
7007	9943	7721	3	14324.0	15288.0	NO FRAC
1860	3229	5314	1	9590.0	9610.0	CIBP + 20FT OF CEMENT
1860	3229	5314	2	9115.0	9135.0	CIBP + 20FT OF CEMENT
1860	3229	5314	3	9040.0	9060.0	FRAC 20/25# LINEAR GEL - 133,134 GAL, 5,000 LB - 100 MESH, 197,560 LB - 20/40 SAND PREM WHITE
3568	5479	4951	4	3825.0	3828.0	SQUEEZE WITH 123 SKS CEMENT AND RETAINER
5363	7903	6489	1	11484.0	16125.0	PUMPED 135,362 BARRELS OF SLICKWATER AND GEL WITH 6,068,956# OF 30/70 AND 40/70 SAND
4055	12103	9542	1	11638.0	15270.0	SEE ATTACHMENT STAGE SUMMARY FOR AMOUNT OF ACID, WATER AND 100 MESH SAND
4102	6202	6425	1	13550.0	18506.0	70,000 GAL 15%HCL,46,997BBLS SLICK WATER, 676,973 # 100 MESH, 2,330,824# 40/80 HYDROPROP, 1,720,400# 30/50 CARBOLITE, 59,094BBLS X-LINKED GEL
4177	6304	8957	1	13490.0	16922.0	50,000GAL 15% HCL, 32,216BBLS SLICK WATER, 502,380# 100 MESH, 2,423,479# 40/80 HYDROPROP, 400,000# CARBOLITE, 41,142BBLS X-LINKED GEL
6082	11089	7169	1	2560.0	2588.0	CIBP @ 2506 WITH 20 CMNT
3724	5688	5886	1	12863.0	12867.0	187,873 BBLS FLUIDS; 0# SAND
3724	5688	5886	2	12582.0	12586.0	233,525 BBLS FLUIDS; 7,000# SAND
5963	12707	7020	1	7300.0	11398.0	FRAC IN 10 STAGES WITH TOTAL OF 138,788 BBL. WATER + 1,590,000 LBS. 40/70 SAND
6082	11089	7169	2	1200.0	1279.0	411 BBLS WATER, 20,000# 16/30 SAND
6201	9016	9414	1	7610.0	9455.0	SEE ATTACHED WELLBORE SCHEMATIC IN ADDITIONAL FORMS
6421	9266	7355	1	7470.0	10874.0	SEE ATTACHED WELLBORE DIAGRAM.
6474	12940	7405	1	7900.0	10702.0	SEE ATTACHED WELLBORE DIAGRAM
6478	12942	7407	1	9650.0	11652.0	SEE ATTACHED WELLBORE DIAGRAM.
6532	9404	7457	1	7926.0	9276.0	FRACD W/119B HCL,15686 B SWF,138380# 20/40 OS, 240240# 40/70 OS,180720# 100M OS, 41980# 20/40 VALUBOND
6532	9404	7457	2	8657.0	9276.0	FRACD W/119BHCL,16113BSWF, 1379803 20/40 OS, 239820# 40/70 OS, 180020# 100M OS, 42080# 20/40 SLC
4623	6878	5606	1	7645.0	9981.0	28,186 BBL FRAC FLUID & 554,055 #S OF PROPPANT IN 10 STAGES
4644	6909	5626	1	8095.0	9044.0	204,456 15# XLINK GEL; 410,147 #20/40 MSD; 15% HCL ACID
4644	6909	5626	2	9093.0	10490.0	690,792 10# LINEAR GEL; 344,425 #20/40 MSD; 15% HCL ACID
5534	8120	9358	1	7356.0	12370.0	4,481,607 LBS PROPPANT WITH 126,987 BBLS WATER IN 15 STAGES
5607	8204	9361	1	7129.0	12115.0	4,922,802 LBS PROPPANT WITH 157,680 BBLS WATER IN 15 STAGES
5608	8206	9356	1	7452.0	12480.0	4,387,062 LBS PROPPANT WITH 124,756 BBLS OF WATER IN 15 STAGES
5561	8148	6704	1	7304.0	7353.0	ACIDIZE W/5500 GALS 15% HCL DI, PLUGGED BACK W/CIBP @ 7285 W/DUMP BAIL 19 CEMENT
5561	8148	6704	2	7220.0	7229.0	15 GALS HCL ACID, FRAC W/12500 GALS YF-125ST+ (25# X-LINKED BORATE GEL) 21140# 20/40 J-U SAND, 3940 GALS 15% HCL DI
5561	8148	6704	3	6960.0	7039.0	FRAC W/18150 GALS YF-125ST+ (25# X-LINKED BORATE GEL) 26195# 20/40 J-U SAND, 4000 GALS 15% HCL DI
5561	8148	6704	4	6710.0	6819.0	ACIDIZE W/2000 GALS 15% HCL NRU DI, 150 J-122 BALL SEALERS, FRAC W/20000 GALS YF-125ST (25# X-LINKED BORATE GEL) 25150# 20/40 J-U SAND, 4340 GALS 15% HCL DI
5561	8148	6704	5	6440.0	6479.0	FRAC W/19500 GALS YF-125ST+ (25# X-LINKED BORATE GEL) 28313# 20/40 J-U SAND, 3230 GALS 15% HCL DI
7007	9943	7721	1	13204.0	13224.0	NO FRAC
3984	6029	4878	1	7657.0	9852.0	24248BBL TOTAL LOAD FLUID CONSISTITING OF: 383BBL (16086GAL) 20% HCI + 397BBL ASTGEL 1012 + 1665 BBL ASTGEL 1017 + 7106 BBL ASTBORMAX 1012 + 10223 BBL ASTBORMAX 1017 + 4474 BBL ASTBORMAX 1020 + 326240 LBS 20/40 TLC + 197440 LBS 30/70 OTTAWA + 425670 LBS 20/40 TEXAS GOLD + 48440 LBS 16/30 TEXAS GOLD.
4635	11674	9041	1	6500.0	10602.0	49,172 SLICKWATER WITH 2,534,620 # SAND
6023	8783	7778	1	8560.0	8728.0	487800 # PROPPANT & 15229 BBLS SLICKWATER
6023	8783	7778	2	8266.0	8436.0	485700 # PROPPANTS & 14658 BBLS SLICKWATER
6023	8783	7778	3	7972.0	8142.0	485800 # PROPPANT & 14616 BBLS SLICKWATER
6023	8783	7778	4	7678.0	7848.0	485800 # PROPPANT & 14766 BBLS SLICKWATER
6023	8783	7778	5	7384.0	7554.0	485800 # PROPPANT & 14880 BBLS SLICKWATER
6023	8783	7778	6	7090.0	7260.0	485800 # PROPPANT & 14653 BBLS SLICKWATER
6023	8783	7778	7	6796.0	6966.0	483700 # PROPPANT & 14704 BBLS SLICKWATER
6087	8870	9336	1	8628.0	11116.0	SEE ATTACHED WELLBORE DIAGRAM
6090	8877	7334	1	7352.0	12599.0	132735 BBLS FLUID, 7256710# SD
5493	8067	6613	18	14334.0	14558.0	100,032#S 100 MESH, 250,000#S 40/70 POWERPROP, 44,388#S 30/50 CRC
3984	6029	4878	2	9893.0	10623.0	INCLUDED IN ABOVE
7821	11452	9206	1	3454.0	3458.0	ACIDIZED W/ 200 GAL 10% MCA
7821	11452	9206	2	3454.0	3458.0	FRACD W/ 63600# 20/40, 26400# 20/40 SUPER LC RESIN SAND & 34700 BBLS OF X-LINKED GEL
7885	11574	8703	1	3416.0	3420.0	ACIDIZED W/ 1000 GAL 10% MCA
7885	11574	8703	2	3416.0	3420.0	FRACD W/ 63600# 20/40, 26400# 20/40 SUPER LC RESIN SAND & 34700 BBLS OF X-LINKED GEL
8108	11218	8886	1	4374.0	4420.0	2000 GAL 10% NEFE HCL
8191	11316	8948	1	3293.0	3322.0	ACIDIZED WITH 1500 GAL 15% NEFE
11389	14984	12267	1	0.0	135.0	CEMENT SQUEEZE W/150 SX
11389	14984	12267	2	2142.0	2256.0	ACIDIZED W/4547 GAL HV-60 ACID
11393	14989	12273	1	2155.0	2298.0	ACIDIZED W/3300 GAL HV-60 ACID AND 660 GAL XYLENE
11396	14992	12276	1	2238.0	2322.0	ACIDIZED W/3600 GAL HV-60 ACID & 720 GAL XYLENE
11399	14997	12282	1	2348.0	2376.0	ACIDIZED W/1500 GAL 15% VCA ACID & 1000# SALT
7479	10494	8074	1	8760.0	15724.0	SEE ATTACHED WELLBORE DIAGRAM
12814	18981	12739	1	8866.0	13827.0	FRACD IN 15 STAGES
6397	11583	17694	1	8638.0	14562.0	536200# WHITE SAND
6397	11583	17694	2	8638.0	14562.0	131857# WATER
12424	16260	19150	1	3641.0	4664.0	47500 GALS 15% HCL ACID
25134	110540	101931	1	1831.0	2899.0	NATURAL
122497	171836	194414	2
4525	6757	5500	1	4304.0	4360.0	CIBP @ 4302
4786	14956	5771	1	7234.0	8203.0	202,212 GALS 15# XLINK; 495,294 #20/40 MSD; 15% HCL
4786	14956	5771	2	9294.0	9667.0	474,222 GALS 10# LINEAR GEL; 357,257 #20/40 MSD; 15% HCL
5889	8619	12135	1	5405.0	5655.0	AZD W/70000G OF 15% HCL, 6000# ROCK SALT FLUSHED W/ 90G BBLS OF FRESH WATER
6086	12724	7108	1	9540.0	12293.0	FRAC W/26K GAL ACID + 82K BBLS WATER + 2.225MM # 100 MESH + 782 40/70 + 154K 20/40 SAND
6249	9070	7508	1	7060.0	9903.0	FRAC IN 9 STAGES WITH TOTAL OF 102,262 BBL. WATER + 393,550 LBS. 100 MESH SAND + 1,487,650 LBS. 40/70 SAND + 397,800 LBS. 20/40 SAND
5889	8619	12135	2	5350.0	5452.0	SQD LEAK W/14 SX 17 SLURRY PUMPED @ 15.6#
3574	5886	4756	1	7190.0	9710.0	21739BBL TOTAL LOAD FLUID CONSISTING OF: 228BBLS (9500GAL) 20% HCI+949BBL. ASTGEL1012+13204BBL. ASTMAX1012+750BBL. ASTGEL1017+6686BBL. ASTMAX1017+350520LBS 20/40 OTTAWA+230880LBS 20/40 BRADY + 50060LBS. 16/30 BRADY+9600 LBS 20/40SLC.
4849	12891	10295	1	4952.0	5257.0	ACDZ W/3234GLS 15% HCL ACID. FRAC W/2100GLS 30# LINEAR GEL PREPAD &
4849	12891	10295	2	4952.0	5257.0	97356GLS BFRAC 30X-LINK BORATE FRAC FLUI, 106529# 20/40 100% OTTOWA WHITE
4849	12891	10295	3	4952.0	5257.0	SD & 61000# SUPER LC RC SD, FLUSH W/1848 GLS SLICK FW
5010	12898	10302	1	7412.0	7715.0	ACIDIZE W/200 GALS 15% NEFE FRAC W/980 SXS 20/40 OTTAWA & 304 SXS 20/40 SUPER LC SAND
5272	7839	6366	1	6740.0	6988.0	PERFS ISOLATED BY CIBP & CMT
5298	7817	6376	1	6907.0	6917.0	200 GALLONS OF 15% ACID
10912	24716	15255	1	11002.0	15557.0	187,173# 100 MESH AND 2,471,968# 30/50 CERAMIC
8794	12025	11106	1	14777.0	15050.0	238BBLS 15% HCL W/6000# 100 MESH + 208340# 30/60 SIERRA TAN + 89420# 30/60 SINTERBALL BAUXITE SAND
8794	12025	11106	2	14379.0	14652.0	238BBLS 15%HCL W/ 7420# 100 MESH+ 209066# 30/70 SIERRA TAN & 91120# 30/60 SINTERBALL BAUXITE SAND.
8794	12025	11106	3	13981.0	14254.0	238BBLS 15%HCL W/ 5000# 100 MESH + 207740# 30/70 SIERRA TAN & 61260# 30/60 SINTERBALL BAUXITE SAND.
8794	12025	11106	4	13583.0	13856.0	119BBLS 15%HCL W/ 5000# 100 MESH + 210460# 30/70 SIERRA TAN & 89020# 30/60 SINTERBALL BAUXITE SAND.
8794	12025	11106	5	13185.0	13458.0	238BBLS 15%HCL W/ 5000# 100 MESH + 209700# 30/70 SIERRA TAN & 99780# 30/60 SINTERBALL BAUXITE SAND.
3724	5688	5886	3	12250.0	12253.0	437,938 BBLS FLUIDS; 238,620# SAND
3724	5688	5886	4	11973.0	11976.0	422,914 BBLS FLUIDS; 298,500# SAND
3724	5688	5886	5	11658.0	11662.0	487,747 BBLS FLUIDS; 295,300# SAND
3724	5688	5886	6	11313.0	11317.0	422,263 BBLS FLUIDS; 298,500# SAND
3724	5688	5886	7	10959.0	10963.0	416,266 BBLS FLUIDS; 295,081# SAND
3724	5688	5886	8	10604.0	10608.0	535,482 BBLS FLUIDS; 317,020# SAND
3724	5688	5886	9	10258.0	10262.0	436,453 BBLS FLUIDS; 311,760# SAND
8794	12025	11106	6	12787.0	13060.0	238BBLS 15%HCL W/ 5000# 100 MESH + 218940# 30/70 SIERRA TAN & 91100# 30/60 SINTERBALL BAUXITE SAND.
8794	12025	11106	7	12389.0	12662.0	238BBLS 15%HCL W/ 5000# 100 MESH + 205680# 30/70 SIERRA TAN & 90000# 30/60 SINTERBALL BAUXITE SANDS.
8794	12025	11106	8	11991.0	12264.0	238BBLS 15%HCL W/ 5000# 100 MESH + 195560# 30/70 SIERRA TAN & 88060# 30/60 SINTERBALL BAUXITE SANDS.
8794	12025	11106	9	11593.0	11866.0	238BBLS 15%HCL W/ 5000# 100 MESH + 207280# 30/70 SIERRA TAN & 77040# 30/60 SINTERBALL BAUXITE SANDS.
8794	12025	11106	10	11195.0	11468.0	238BBLS 15%HCL W/ 5000# 100 MESH + 212800# 30/70 SIERRA TAN & 90120# 30/60 SINTERBALL BAUXITE SANDS.
8794	12025	11106	11	11070.0	11797.0	119BBLS 15%HCL W/ 5000# 100 MESH + 209940# 30/70 SIERRA TAN & 82040# 30/60 SINTERBALL BAUXITE SANDS.

What is in each column

Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.

`tracking_no`

varchar

Sampled: 50K
Distinct: 23.1K

104236 118
111741 78
113777 56
116319 56
118732 54
123641 48
120082 48
119502 46
124510 46
106508 40
116910 40
126229 40

`packet_id`

varchar

Sampled: 50K
Distinct: 25.7K

144702 118
158938 56
162672 56
174662 46
176989 40
148156 40
155963 39
198628 39
146337 34
168126 33
28010 32
161149 31

`parent_id`

varchar

Sampled: 50K
Distinct: 26.8K

171585 59
188302 59
168155 40
69301 40
164658 39
208719 39
166485 38
72588 36
195518 34
179633 32
25862 32
180385 31

`row_no`

varchar

Sampled: 50K
Distinct: 59

1 27.9K
2 8K
3 4.3K
4 2.3K
5 1.5K
6 1.2K
7 945
8 780
9 607
10 476
11 313
12 255

`from_depth`

varchar

Sampled: 50K
Distinct: 14.4K

0.0 306
64
7950.0 32
8010.0 29
7600.0 27
7400.0 26
7700.0 25
8100.0 25
8050.0 25
7800.0 24
8300.0 24
7200.0 24

`to_depth`

varchar

Sampled: 50K
Distinct: 15.5K

64
0.0 59
10450.0 33
4590.0 26
10030.0 22
10500.0 22
10000.0 21
4550.0 21
10700.0 20
10550.0 20
3100.0 20
4620.0 19

`material_used`

text

Sampled: 50K
Distinct: 43.1K

HCL AND PROPPANT 441
SEE ATTACHED WELLBORE SCHEMATIC IN ADDITIONAL FORMS 338
FRACD IN 15 STAGES 220
SEE ATTACHED WBD 136
NATURAL 124
4 SPF 96
PERF W/6 SPF. 84
INCLUDED IN ABOVE. 77
65
CIBP 62
ACIDIZE W/2000 GAL 15% HCL & 75 BALL SEALERS 61
ACIDIZE W/2000 GAL 15% HCL & 100 BALL SEALERS 59

`amt_material_process_code`

varchar

Sampled: 50K
Distinct: 7

49.6K
Fracture 224
Added with SWR 13. Acid 45
Other 42
Cast Iron Bridge Plug 32
Cement Squeeze 23
Retainer 2

Take it away

Back to everything we know about Completion Stimulation Materials