Preview Wellbore Well Identifiers

First 100 rows

Out of roughly 667.7K rows in texas.wb_well_ids. Version 20260914T032223Z.

First 100 rows of `texas.wb_well_ids`, 8 columns wide
`api_county`	`api_unique`	`row_no`	`oil_code`	`oil_district`	`oil_lse_number`	`oil_well_number`	`ingested_at`
001	00167	1	O	6	10564	2	Sept. 13, 2026, 10:01 p.m.
001	00305	1	O	6	1063	14	Sept. 13, 2026, 10:01 p.m.
001	00458	1	O	6	11927	2	Sept. 13, 2026, 10:01 p.m.
001	00458	2	O	6	12390	6	Sept. 13, 2026, 10:01 p.m.
001	00545	1	O	6	11357	1	Sept. 13, 2026, 10:01 p.m.
001	00560	1	O	6	12589	2	Sept. 13, 2026, 10:01 p.m.
001	00564	1	O	6	12589	1	Sept. 13, 2026, 10:01 p.m.
001	00567	1	O	6	12390	7	Sept. 13, 2026, 10:01 p.m.
001	00573	1	O	6	11927	1	Sept. 13, 2026, 10:01 p.m.
001	00573	2	O	6	12390	5	Sept. 13, 2026, 10:01 p.m.
001	00619	1	O	6	13273	2	Sept. 13, 2026, 10:01 p.m.
001	00686	1	O	6	10111	1	Sept. 13, 2026, 10:01 p.m.
001	00708	1	O	6	11327	2A	Sept. 13, 2026, 10:01 p.m.
001	00751	1	O	6	13038	1	Sept. 13, 2026, 10:01 p.m.
001	00751	2	O	6	13206	1	Sept. 13, 2026, 10:01 p.m.
001	00753	1	O	6	5551	1	Sept. 13, 2026, 10:01 p.m.
001	00757	1	O	6	10007	2	Sept. 13, 2026, 10:01 p.m.
001	00757	2	O	6	13791	2	Sept. 13, 2026, 10:01 p.m.
001	00766	1	G	17	8718	null	Sept. 13, 2026, 10:01 p.m.
001	00766	2	G	18	2428	null	Sept. 13, 2026, 10:01 p.m.
001	00784	1	G	10	6840	null	Sept. 13, 2026, 10:01 p.m.
001	00784	2	G	11	4377	null	Sept. 13, 2026, 10:01 p.m.
001	00784	3	O	6	13121	1	Sept. 13, 2026, 10:01 p.m.
001	00815	1	G	14	5848	null	Sept. 13, 2026, 10:01 p.m.
001	00819	1	O	6	14462	8	Sept. 13, 2026, 10:01 p.m.
001	00840	1	G	14	4081	null	Sept. 13, 2026, 10:01 p.m.
001	00887	1	G	15	4973	null	Sept. 13, 2026, 10:01 p.m.
001	00903	1	O	6	14882	1	Sept. 13, 2026, 10:01 p.m.
001	00951	1	G	1	5909	null	Sept. 13, 2026, 10:01 p.m.
001	01015	1	O	6	13442	4	Sept. 13, 2026, 10:01 p.m.
001	01100	1	O	6	10546	2	Sept. 13, 2026, 10:01 p.m.
001	01171	1	O	6	797	6	Sept. 13, 2026, 10:01 p.m.
001	01202	1	O	6	802	9	Sept. 13, 2026, 10:01 p.m.
001	01272	1	O	6	776	7	Sept. 13, 2026, 10:01 p.m.
001	01471	1	O	6	11614	C 1	Sept. 13, 2026, 10:01 p.m.
001	01477	1	O	6	11451	1	Sept. 13, 2026, 10:01 p.m.
001	01487	1	O	6	11610	1	Sept. 13, 2026, 10:01 p.m.
001	01489	1	O	6	11611	2	Sept. 13, 2026, 10:01 p.m.
001	01490	1	O	6	11615	1	Sept. 13, 2026, 10:01 p.m.
001	01521	1	O	6	4048	1	Sept. 13, 2026, 10:01 p.m.
001	01692	1	O	6	13622	A 7	Sept. 13, 2026, 10:01 p.m.
001	01758	1	O	6	2460	8	Sept. 13, 2026, 10:01 p.m.
001	01764	1	O	6	11453	1	Sept. 13, 2026, 10:01 p.m.
001	01769	1	O	6	11617	A 1	Sept. 13, 2026, 10:01 p.m.
001	01799	1	O	6	4691	1D	Sept. 13, 2026, 10:01 p.m.
001	01821	1	O	6	10823	3 A	Sept. 13, 2026, 10:01 p.m.
001	01828	1	O	6	3011	2W	Sept. 13, 2026, 10:01 p.m.
001	01894	1	O	6	12135	2	Sept. 13, 2026, 10:01 p.m.
001	01904	1	O	6	1592	1312	Sept. 13, 2026, 10:01 p.m.
001	01921	1	O	6	2707	4	Sept. 13, 2026, 10:01 p.m.
001	01921	2	O	6	2681	4	Sept. 13, 2026, 10:01 p.m.
001	01932	1	O	6	11787	2A	Sept. 13, 2026, 10:01 p.m.
001	01957	1	G	11	8764	null	Sept. 13, 2026, 10:01 p.m.
001	01957	2	O	6	2597	2	Sept. 13, 2026, 10:01 p.m.
001	01957	3	O	6	11961	2	Sept. 13, 2026, 10:01 p.m.
001	01963	1	O	6	11315	7	Sept. 13, 2026, 10:01 p.m.
001	01973	1	O	6	3022	7	Sept. 13, 2026, 10:01 p.m.
001	01979	1	O	6	5684	3W	Sept. 13, 2026, 10:01 p.m.
001	01980	1	O	6	2320	1	Sept. 13, 2026, 10:01 p.m.
001	01980	2	O	6	2355	1	Sept. 13, 2026, 10:01 p.m.
001	02014	1	O	6	3733	4I	Sept. 13, 2026, 10:01 p.m.
001	02034	1	O	6	2058	23I	Sept. 13, 2026, 10:01 p.m.
001	02090	1	G	11	3884	null	Sept. 13, 2026, 10:01 p.m.
001	02090	2	O	6	12290	1	Sept. 13, 2026, 10:01 p.m.
001	02146	1	O	6	1592	1211	Sept. 13, 2026, 10:01 p.m.
001	02416	1	O	6	11612	1	Sept. 13, 2026, 10:01 p.m.
001	20240	1	O	6	3438	103I	Sept. 13, 2026, 10:01 p.m.
001	30004	1	O	6	5345	1	Sept. 13, 2026, 10:01 p.m.
001	30015	1	G	8	5858	null	Sept. 13, 2026, 10:01 p.m.
001	30094	1	G	9	6529	null	Sept. 13, 2026, 10:01 p.m.
001	30345	1	O	6	15069	1	Sept. 13, 2026, 10:01 p.m.
001	30548	1	O	6	5870	5	Sept. 13, 2026, 10:01 p.m.
001	30568	1	O	6	1592	1711	Sept. 13, 2026, 10:01 p.m.
001	30569	1	O	6	1592	1213	Sept. 13, 2026, 10:01 p.m.
001	30569	2	O	6	1592	1213I	Sept. 13, 2026, 10:01 p.m.
001	30569	3	O	6	1592	1213IR	Sept. 13, 2026, 10:01 p.m.
001	30580	1	O	6	1592	1108	Sept. 13, 2026, 10:01 p.m.
001	30598	1	G	10	1602	null	Sept. 13, 2026, 10:01 p.m.
001	30612	1	G	7	7709	null	Sept. 13, 2026, 10:01 p.m.
001	30636	1	O	6	10001	3	Sept. 13, 2026, 10:01 p.m.
001	30641	1	O	6	5870	9	Sept. 13, 2026, 10:01 p.m.
001	30865	1	G	12	3384	null	Sept. 13, 2026, 10:01 p.m.
001	30865	2	O	6	173	20	Sept. 13, 2026, 10:01 p.m.
001	30867	1	O	6	2418	3	Sept. 13, 2026, 10:01 p.m.
001	30871	1	G	7	7080	null	Sept. 13, 2026, 10:01 p.m.
001	30871	2	G	14	4366	null	Sept. 13, 2026, 10:01 p.m.
001	30879	1	O	6	10049	1	Sept. 13, 2026, 10:01 p.m.
001	30879	2	O	6	12140	1	Sept. 13, 2026, 10:01 p.m.
001	30881	1	O	6	3412	23I	Sept. 13, 2026, 10:01 p.m.
001	30882	1	O	6	3412	21	Sept. 13, 2026, 10:01 p.m.
001	30883	1	O	6	3412	20	Sept. 13, 2026, 10:01 p.m.
001	30884	1	O	6	3412	19	Sept. 13, 2026, 10:01 p.m.
001	30885	1	G	8	2624	null	Sept. 13, 2026, 10:01 p.m.
001	30886	1	O	6	3412	24	Sept. 13, 2026, 10:01 p.m.
001	30887	1	O	6	3412	22I	Sept. 13, 2026, 10:01 p.m.
001	30891	1	O	6	160	17	Sept. 13, 2026, 10:01 p.m.
001	30893	1	O	6	10126	1	Sept. 13, 2026, 10:01 p.m.
001	30894	1	O	6	10141	1	Sept. 13, 2026, 10:01 p.m.
001	30894	2	O	6	10543	1	Sept. 13, 2026, 10:01 p.m.
001	30894	3	O	6	11310	1	Sept. 13, 2026, 10:01 p.m.

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: 20

003 20.1K
029 6.9K
009 6.1K
013 5.1K
039 2.4K
025 2.3K
033 2.1K
001 1.5K
021 866
015 842
023 620
007 440

`api_unique`

varchar

Sampled: 50K
Distinct: 19.6K

32763 16
00333 16
32105 14
31395 14
33330 14
31674 14
32224 14
31910 14
31061 13
32758 13
33192 13
32116 13

`row_no`

int2

Sampled: 50K
Distinct: 11

1 39.1K
2 8.1K
3 1.9K
4 531
5 216
6 86
7 33
8 13
9 6
10 3
11 2

`oil_lse_number`

varchar

Sampled: 50K
Distinct: 15.4K

17503 1K
1770 815
21220 475
15874 352
8545 291
60465 287
19054 268
4010 240
7329 228
18729 185
13869 181
1270 168

`oil_code`

varchar

Sampled: 50K
Distinct: 2

O 45.2K
G 4.8K

`oil_district`

varchar

Sampled: 50K
Distinct: 30
Empty: 0.0002

10 20.1K
1 12.1K
13 6.9K
3 2.4K
11 2.1K
6 1.3K
2 713
9 312
8 278
12 276
16 268
14 259

`oil_well_number`

varchar

Sampled: 50K
Distinct: 8.3K
Empty: 0.0969

1 6.3K
2 3.1K
3 2.3K
4 1.8K
5 1.5K
6 1.2K
7 978
8 828
1H 766
9 729
10 650
11 562

`ingested_at`

timestamptz

Sampled: 50K
Distinct: 1

Sept. 13, 2026, 10:01 p.m. 50K

Take it away

Back to everything we know about Wellbore Well Identifiers