Preview Wellbore Completion Records

First 100 rows

Out of roughly 1.1M rows in texas.wb_completions. Version obs-12db987150e5.

First 100 rows of `texas.wb_completions`, 19 columns wide
`api_county`	`api_unique`	`row_no`	`oil_code`	`oil_district`	`oil_lse_nbr`	`oil_well_nbr`	`gas_dist`	`gas_well_no`	`multi_well_rec_nbr`	`api_suffix`	`active_inactive_code`	`created_from_pi_flag`	`rule_37_nbr`	`p15_flag`	`p12_flag`	`ingested_at`	`dwn_hole_commingle_code`	`plug_date_pointer`
001	00001	1	O	6	4411	1	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00008	1	G	1	5885	null	6	1A	null	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19770623
001	00037	1	O	6	5312	201	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20091111
001	00039	1	O	6	154	1	null	null	null	null	null	null	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19750505
001	00040	1	O	6	154	2	null	null	null	null	null	null	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19760319
001	00041	1	O	6	154	3	null	null	null	null	null	null	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19760319
001	00043	1	G	1	5896	null	6	1	null	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00045	1	O	6	155	2	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00046	1	O	6	180	2	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00049	1	G	1	5893	null	6	1	null	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20191122
001	00052	1	G	1	6391	null	6	1	null	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00055	1	G	1	5906	null	6	D 1	null	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19941201
001	00064	1	G	3	6665	null	6	1	null	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00066	1	O	6	4123	1 T	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20121001
001	00068	1	G	1	6289	null	6	1	null	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00069	1	G	1	6290	null	6	1	null	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00070	1	G	2	835	null	6	1	null	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00070	2	G	18	1540	null	6	817G	null	null	null	null	null	Y	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00070	3	O	6	4853	817G	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00071	1	G	20	9044	null	6	823	null	null	null	null	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00071	2	O	6	4853	823	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00072	1	G	18	1538	null	6	824	null	null	null	null	null	Y	N	Sept. 13, 2026, 10:01 p.m.	null	20250829
001	00072	2	O	6	4853	824W	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20250829
001	00074	1	O	6	4853	814	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20250314
001	00078	1	O	6	4853	839	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19940422
001	00084	1	O	6	4853	842G	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20030811
001	00085	1	O	6	4853	843	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19990211
001	00086	1	O	6	4853	747	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19951012
001	00086	2	O	6	4853	747W	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19951012
001	00087	1	O	6	4853	749	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19911227
001	00089	1	O	6	4853	846G	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19940401
001	00090	1	G	20	8429	null	6	751	null	null	null	null	null	Y	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00090	2	O	6	4853	751	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00091	1	O	6	4853	849G	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20250821
001	00092	1	O	6	4853	850	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00093	1	O	6	4853	851	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00094	1	O	6	4853	752WG	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00095	1	O	6	4853	770	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00096	1	O	6	4853	753	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00097	1	O	6	4853	853	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00098	1	O	6	4853	852	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19880718
001	00100	1	O	6	4853	854	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19991117
001	00101	1	O	6	4853	951	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00101	2	O	6	4853	951WG	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00104	1	O	6	4853	964	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19930407
001	00105	1	O	6	4853	972	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19910910
001	00106	1	O	6	4853	967W	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19891103
001	00108	1	O	6	4853	970	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19950301
001	00109	1	O	6	3729	1	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20180611
001	00110	1	O	6	4853	952WG	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20020104
001	00111	1	O	6	3639	1 U	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00111	2	O	6	4853	954G	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00112	1	O	6	4853	957WG	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20011207
001	00113	1	O	6	4291	1 L	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20110531
001	00113	2	O	6	4853	956	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20110531
001	00113	3	O	6	4853	956D	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20110531
001	00114	1	O	6	4853	857	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19910910
001	00115	1	O	6	4853	855	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00115	2	O	6	4853	855G	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00117	1	G	28	481	null	6	861	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00117	2	O	6	4039	1 L	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00117	3	O	6	4853	861	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00118	1	O	6	4853	858	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19960913
001	00120	1	G	19	8177	null	6	755G	null	null	null	null	null	Y	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00120	2	O	6	4853	755G	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00122	1	O	6	4853	756	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20080424
001	00122	2	O	6	4853	756WI	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20080424
001	00125	1	O	6	4853	660WG	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20000817
001	00126	1	O	6	4853	661	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20200508
001	00127	1	O	6	4853	759	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19960607
001	00128	1	O	6	4853	760WG	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20020909
001	00129	1	O	6	4853	761	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19940816
001	00130	1	O	6	4088	1 T	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20250819
001	00130	2	O	6	4853	860	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20250819
001	00132	1	O	6	4853	862	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19920918
001	00133	1	O	6	4058	1 L	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00134	1	O	6	4853	958	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20020104
001	00135	1	O	6	4107	1 C	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19891027
001	00135	2	O	6	4108	1 L	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19891027
001	00135	3	O	6	4853	959W	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19891027
001	00136	1	O	6	4853	960	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19910913
001	00137	1	O	6	4853	961WG	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19900828
001	00138	1	O	6	4853	962	null	null	1	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19900917
001	00139	1	O	6	4318	1 T	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20161222
001	00164	1	O	6	1101	1	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00167	1	O	6	10564	2	null	null	null	null	A	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19941021
001	00189	1	O	6	5080	1	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00209	1	O	6	4983	1	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00215	1	O	6	4983	3	null	null	0	null	null	Y	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00240	1	O	6	4984	1	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	20140303
001	00259	1	O	6	2273	1	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19890104
001	00260	1	O	6	2048	1	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19930806
001	00261	1	O	6	1078	1	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19930806
001	00262	1	O	6	1078	2	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19840802
001	00263	1	O	6	1098	1	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19931103
001	00264	1	O	6	1079	1	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19921202
001	00265	1	O	6	1079	2	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	19930825
001	00266	1	O	6	1079	3	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00267	1	O	6	1079	4	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null
001	00268	1	O	6	1079	5	null	null	0	null	null	N	null	N	N	Sept. 13, 2026, 10:01 p.m.	null	null

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.

`api_county`

varchar

Sampled: 50K
Distinct: 5

003 31.7K
009 13.2K
001 3.5K
007 1.2K
005 356

`api_unique`

varchar

Sampled: 50K
Distinct: 29.6K

00333 21
30641 12
00549 11
30814 11
30162 10
30739 10
30188 9
00293 9
00320 9
36650 9
00259 9
30792 9

`row_no`

int2

Sampled: 50K
Distinct: 13

1 39.2K
2 7.7K
3 2.1K
4 681
5 255
6 97
7 36
8 10
9 2
12 1
13 1
10 1

`oil_lse_nbr`

varchar

Sampled: 50K
Distinct: 11K

1770 1.7K
17503 1.5K
4010 821
15874 777
21220 605
20587 443
18729 324
1592 294
13869 269
21930 261
1270 247
13867 239

`gas_well_no`

varchar

Sampled: 50K
Distinct: 343
Empty: 0.9565

1 646
2 210
3 119
4 78
1H 46
5 41
6 34
1 C 33
1 L 32
1 U 29
9 28
8 24

`oil_code`

varchar

Sampled: 50K
Distinct: 2

O 47.7K
G 2.3K

`oil_district`

varchar

Sampled: 50K
Distinct: 33
Empty: 0.0003

10 31K
13 13.2K
6 3K
4 548
1 312
11 186
3 171
96 138
29 136
16 106
5 103
28 86

`oil_well_nbr`

varchar

Sampled: 50K
Distinct: 9.2K
Empty: 0.0464

1 5.2K
2 3K
3 2.1K
4 1.7K
5 1.4K
6 1.1K
7 984
8 849
9 728
10 658
11 559
12 501

Take it away

Back to everything we know about Wellbore Completion Records