EZRRC
Cart Sign in

Wellbore Well Identifiers — preview

A live sample straight out of our copy of the data. Nothing here is edited: this is exactly what an export gives you.

First 100 rows

Out of roughly 663.9K rows in texas.wb_well_ids. Version 20260518T030644Z.

api_countyapi_uniquerow_nooil_codeoil_districtoil_lse_numberoil_well_numberingested_at
001001671O6105642May 17, 2026, 10 p.m.
001003051O6106314May 17, 2026, 10 p.m.
001004581O6119272May 17, 2026, 10 p.m.
001004582O6123906May 17, 2026, 10 p.m.
001005451O6113571May 17, 2026, 10 p.m.
001005601O6125892May 17, 2026, 10 p.m.
001005641O6125891May 17, 2026, 10 p.m.
001005671O6123907May 17, 2026, 10 p.m.
001005731O6119271May 17, 2026, 10 p.m.
001005732O6123905May 17, 2026, 10 p.m.
001006191O6132732May 17, 2026, 10 p.m.
001006861O6101111May 17, 2026, 10 p.m.
001007081O6113272AMay 17, 2026, 10 p.m.
001007511O6130381May 17, 2026, 10 p.m.
001007512O6132061May 17, 2026, 10 p.m.
001007531O655511May 17, 2026, 10 p.m.
001007571O6100072May 17, 2026, 10 p.m.
001007572O6137912May 17, 2026, 10 p.m.
001007661G178718nullMay 17, 2026, 10 p.m.
001007662G182428nullMay 17, 2026, 10 p.m.
001007841G106840nullMay 17, 2026, 10 p.m.
001007842G114377nullMay 17, 2026, 10 p.m.
001007843O6131211May 17, 2026, 10 p.m.
001008151G145848nullMay 17, 2026, 10 p.m.
001008191O6144628May 17, 2026, 10 p.m.
001008401G144081nullMay 17, 2026, 10 p.m.
001008871G154973nullMay 17, 2026, 10 p.m.
001009031O6148821May 17, 2026, 10 p.m.
001009511G15909nullMay 17, 2026, 10 p.m.
001010151O6134424May 17, 2026, 10 p.m.
001011001O6105462May 17, 2026, 10 p.m.
001011711O67976May 17, 2026, 10 p.m.
001012021O68029May 17, 2026, 10 p.m.
001012721O67767May 17, 2026, 10 p.m.
001014711O611614C 1May 17, 2026, 10 p.m.
001014771O6114511May 17, 2026, 10 p.m.
001014871O6116101May 17, 2026, 10 p.m.
001014891O6116112May 17, 2026, 10 p.m.
001014901O6116151May 17, 2026, 10 p.m.
001015211O640481May 17, 2026, 10 p.m.
001016921O613622A 7May 17, 2026, 10 p.m.
001017581O624608May 17, 2026, 10 p.m.
001017641O6114531May 17, 2026, 10 p.m.
001017691O611617A 1May 17, 2026, 10 p.m.
001017991O646911DMay 17, 2026, 10 p.m.
001018211O6108233 AMay 17, 2026, 10 p.m.
001018281O630112WMay 17, 2026, 10 p.m.
001018941O6121352May 17, 2026, 10 p.m.
001019041O615921312May 17, 2026, 10 p.m.
001019211O627074May 17, 2026, 10 p.m.
001019212O626814May 17, 2026, 10 p.m.
001019321O6117872AMay 17, 2026, 10 p.m.
001019571G118764nullMay 17, 2026, 10 p.m.
001019572O625972May 17, 2026, 10 p.m.
001019573O6119612May 17, 2026, 10 p.m.
001019631O6113157May 17, 2026, 10 p.m.
001019731O630227May 17, 2026, 10 p.m.
001019791O656843WMay 17, 2026, 10 p.m.
001019801O623201May 17, 2026, 10 p.m.
001019802O623551May 17, 2026, 10 p.m.
001020141O637334IMay 17, 2026, 10 p.m.
001020341O6205823IMay 17, 2026, 10 p.m.
001020901G113884nullMay 17, 2026, 10 p.m.
001020902O6122901May 17, 2026, 10 p.m.
001021461O615921211May 17, 2026, 10 p.m.
001024161O6116121May 17, 2026, 10 p.m.
001202401O63438103IMay 17, 2026, 10 p.m.
001300041O653451May 17, 2026, 10 p.m.
001300151G85858nullMay 17, 2026, 10 p.m.
001300941G96529nullMay 17, 2026, 10 p.m.
001303451O6150691May 17, 2026, 10 p.m.
001305481O658705May 17, 2026, 10 p.m.
001305681O615921711May 17, 2026, 10 p.m.
001305691O615921213May 17, 2026, 10 p.m.
001305692O615921213IMay 17, 2026, 10 p.m.
001305693O615921213IRMay 17, 2026, 10 p.m.
001305801O615921108May 17, 2026, 10 p.m.
001305981G101602nullMay 17, 2026, 10 p.m.
001306121G77709nullMay 17, 2026, 10 p.m.
001306361O6100013May 17, 2026, 10 p.m.
001306411O658709May 17, 2026, 10 p.m.
001308651G123384nullMay 17, 2026, 10 p.m.
001308652O617320May 17, 2026, 10 p.m.
001308671O624183May 17, 2026, 10 p.m.
001308711G77080nullMay 17, 2026, 10 p.m.
001308712G144366nullMay 17, 2026, 10 p.m.
001308791O6100491May 17, 2026, 10 p.m.
001308792O6121401May 17, 2026, 10 p.m.
001308811O6341223IMay 17, 2026, 10 p.m.
001308821O6341221May 17, 2026, 10 p.m.
001308831O6341220May 17, 2026, 10 p.m.
001308841O6341219May 17, 2026, 10 p.m.
001308851G82624nullMay 17, 2026, 10 p.m.
001308861O6341224May 17, 2026, 10 p.m.
001308871O6341222IMay 17, 2026, 10 p.m.
001308911O616017May 17, 2026, 10 p.m.
001308931O6101261May 17, 2026, 10 p.m.
001308941O6101411May 17, 2026, 10 p.m.
001308942O6105431May 17, 2026, 10 p.m.
001308943O6113101May 17, 2026, 10 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 20K
  • 029 6.9K
  • 009 6K
  • 013 5.1K
  • 039 2.4K
  • 025 2.3K
  • 033 2.1K
  • 001 1.5K
  • 021 866
  • 015 841
  • 023 604
  • 041 459

api_unique

varchar

Sampled
50K
Distinct
19.5K
  • 00333 16
  • 32763 16
  • 33330 14
  • 32224 14
  • 31910 14
  • 31395 14
  • 32105 14
  • 31674 14
  • 31061 13
  • 33192 13
  • 32533 13
  • 32758 13

row_no

int2

Sampled
50K
Distinct
11
  • 1 39K
  • 2 8.2K
  • 3 2K
  • 4 543
  • 5 214
  • 6 85
  • 7 32
  • 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 267
  • 4010 240
  • 7329 228
  • 17583 217
  • 18729 185
  • 13869 181

oil_code

varchar

Sampled
50K
Distinct
2
  • O 45.2K
  • G 4.8K

oil_district

varchar

Sampled
50K
Distinct
30
Empty
0.0002
  • 10 20K
  • 1 12.1K
  • 13 6.9K
  • 3 2.6K
  • 11 2.1K
  • 6 1.3K
  • 2 711
  • 9 314
  • 8 279
  • 12 276
  • 16 268
  • 14 259

oil_well_number

varchar

Sampled
50K
Distinct
8.3K
Empty
0.0967
  • 1 6.4K
  • 2 3.1K
  • 3 2.3K
  • 4 1.8K
  • 5 1.5K
  • 6 1.2K
  • 7 977
  • 8 825
  • 1H 759
  • 9 724
  • 10 649
  • 11 562

ingested_at

timestamptz

Sampled
50K
Distinct
1
  • May 17, 2026, 10 p.m. 50K

Take it away

Back to everything we know about Wellbore Well Identifiers