First 100 rows

Out of roughly 705.1K rows in texas.wb_drilling_permits. Version obs-73ce8e7350f4.

First 100 rows of texas.wb_drilling_permits, 4 columns wide
api_countyapi_uniquepermit_numberingested_at
00100167335053Sept. 13, 2026, 10:01 p.m.
00100305400270Sept. 13, 2026, 10:01 p.m.
00100458295940Sept. 13, 2026, 10:01 p.m.
00100545201453Sept. 13, 2026, 10:01 p.m.
00100560382399Sept. 13, 2026, 10:01 p.m.
00100564359122Sept. 13, 2026, 10:01 p.m.
00100567344482Sept. 13, 2026, 10:01 p.m.
00100573295945Sept. 13, 2026, 10:01 p.m.
00100619413148Sept. 13, 2026, 10:01 p.m.
0010068640013Sept. 13, 2026, 10:01 p.m.
00100708212347Sept. 13, 2026, 10:01 p.m.
00100751400205Sept. 13, 2026, 10:01 p.m.
00100751414563Sept. 13, 2026, 10:01 p.m.
0010075312068Sept. 13, 2026, 10:01 p.m.
00100757183927Sept. 13, 2026, 10:01 p.m.
00100757472025Sept. 13, 2026, 10:01 p.m.
00100766495079Sept. 13, 2026, 10:01 p.m.
00100766506231Sept. 13, 2026, 10:01 p.m.
00100784195717Sept. 13, 2026, 10:01 p.m.
00100784236909Sept. 13, 2026, 10:01 p.m.
00100784406509Sept. 13, 2026, 10:01 p.m.
00100815412952Sept. 13, 2026, 10:01 p.m.
00100819610914Sept. 13, 2026, 10:01 p.m.
00100840408446Sept. 13, 2026, 10:01 p.m.
00100882711020Sept. 13, 2026, 10:01 p.m.
00100887436701Sept. 13, 2026, 10:01 p.m.
00100903627257Sept. 13, 2026, 10:01 p.m.
00100951505033Sept. 13, 2026, 10:01 p.m.
00101015409250Sept. 13, 2026, 10:01 p.m.
00101100128717Sept. 13, 2026, 10:01 p.m.
00101171301645Sept. 13, 2026, 10:01 p.m.
00101202334935Sept. 13, 2026, 10:01 p.m.
00101272416527Sept. 13, 2026, 10:01 p.m.
00101310114736Sept. 13, 2026, 10:01 p.m.
00101356210460Sept. 13, 2026, 10:01 p.m.
00101471177521Sept. 13, 2026, 10:01 p.m.
00101477177731Sept. 13, 2026, 10:01 p.m.
00101478177749Sept. 13, 2026, 10:01 p.m.
00101483186044Sept. 13, 2026, 10:01 p.m.
00101487176294Sept. 13, 2026, 10:01 p.m.
00101489181288Sept. 13, 2026, 10:01 p.m.
00101490176291Sept. 13, 2026, 10:01 p.m.
00101521449102Sept. 13, 2026, 10:01 p.m.
00101692527389Sept. 13, 2026, 10:01 p.m.
00101751101002Sept. 13, 2026, 10:01 p.m.
0010175885128Sept. 13, 2026, 10:01 p.m.
00101764177519Sept. 13, 2026, 10:01 p.m.
00101769210229Sept. 13, 2026, 10:01 p.m.
00101771177523Sept. 13, 2026, 10:01 p.m.
00101775180164Sept. 13, 2026, 10:01 p.m.
0010179953426Sept. 13, 2026, 10:01 p.m.
0010179961881Sept. 13, 2026, 10:01 p.m.
00101821133607Sept. 13, 2026, 10:01 p.m.
0010182867678Sept. 13, 2026, 10:01 p.m.
00101890322800Sept. 13, 2026, 10:01 p.m.
00101893286414Sept. 13, 2026, 10:01 p.m.
00101894212607Sept. 13, 2026, 10:01 p.m.
00101904392411Sept. 13, 2026, 10:01 p.m.
00101921180729Sept. 13, 2026, 10:01 p.m.
00101921294801Sept. 13, 2026, 10:01 p.m.
00101923119431Sept. 13, 2026, 10:01 p.m.
00101932265192Sept. 13, 2026, 10:01 p.m.
00101957274565Sept. 13, 2026, 10:01 p.m.
00101963142822Sept. 13, 2026, 10:01 p.m.
00101973233450Sept. 13, 2026, 10:01 p.m.
0010197962667Sept. 13, 2026, 10:01 p.m.
00101980143639Sept. 13, 2026, 10:01 p.m.
00101980271875Sept. 13, 2026, 10:01 p.m.
0010201417814Sept. 13, 2026, 10:01 p.m.
0010203426870Sept. 13, 2026, 10:01 p.m.
0010203427716Sept. 13, 2026, 10:01 p.m.
00102090217092Sept. 13, 2026, 10:01 p.m.
00102090260343Sept. 13, 2026, 10:01 p.m.
00102090330642Sept. 13, 2026, 10:01 p.m.
00102146392478Sept. 13, 2026, 10:01 p.m.
0010233518821Sept. 13, 2026, 10:01 p.m.
00102398186042Sept. 13, 2026, 10:01 p.m.
00102398215198Sept. 13, 2026, 10:01 p.m.
00102416176290Sept. 13, 2026, 10:01 p.m.
00120213148383Sept. 13, 2026, 10:01 p.m.
0012024018419Sept. 13, 2026, 10:01 p.m.
00130004102593Sept. 13, 2026, 10:01 p.m.
0013001551788Sept. 13, 2026, 10:01 p.m.
00130094104452Sept. 13, 2026, 10:01 p.m.
00130345711276Sept. 13, 2026, 10:01 p.m.
0013036847723Sept. 13, 2026, 10:01 p.m.
00130548816983Sept. 13, 2026, 10:01 p.m.
00130568392381Sept. 13, 2026, 10:01 p.m.
00130569391758Sept. 13, 2026, 10:01 p.m.
00130580398037Sept. 13, 2026, 10:01 p.m.
00130598134445Sept. 13, 2026, 10:01 p.m.
00130598178084Sept. 13, 2026, 10:01 p.m.
0013061233804Sept. 13, 2026, 10:01 p.m.
001306196754Sept. 13, 2026, 10:01 p.m.
001306367112Sept. 13, 2026, 10:01 p.m.
00130641814143Sept. 13, 2026, 10:01 p.m.
00130864968Sept. 13, 2026, 10:01 p.m.
001308651934Sept. 13, 2026, 10:01 p.m.
001308663541Sept. 13, 2026, 10:01 p.m.
001308674353Sept. 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
17
  • 003 18.4K
  • 009 8.9K
  • 029 7.2K
  • 013 4.8K
  • 025 3.2K
  • 001 1.8K
  • 033 1.5K
  • 021 1.2K
  • 023 1K
  • 015 953
  • 007 555
  • 005 373

api_unique

varchar

Sampled
50K
Distinct
19.9K
  • 30739 15
  • 31010 13
  • 30890 13
  • 30656 13
  • 32224 13
  • 31046 13
  • 30894 12
  • 30950 12
  • 31395 12
  • 30641 12
  • 30923 12
  • 30872 12

permit_number

varchar

Sampled
50K
Distinct
50K
  • 702486 1
  • 209126 1
  • 157417 1
  • 29365 1
  • 875576 1
  • 229521 1
  • 88574 1
  • 518425 1
  • 655825 1
  • 217147 1
  • 209563 1
  • 405567 1

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 Drilling Permit Numbers