First 100 rows

Out of roughly 1M rows in texas.wb_perforations. Version obs-5f4a874b9c16.

api_countyapi_uniqueperf_countfrom_perfto_perfopen_hole_codeingested_at
00100001140214023nullMay 17, 2026, 10 p.m.
00100008173927420nullMay 17, 2026, 10 p.m.
00100037159115920nullMay 17, 2026, 10 p.m.
00100043174847506nullMay 17, 2026, 10 p.m.
00100045140144026nullMay 17, 2026, 10 p.m.
00100045240364046nullMay 17, 2026, 10 p.m.
00100046140524063nullMay 17, 2026, 10 p.m.
00100049175047522nullMay 17, 2026, 10 p.m.
00100055175527574nullMay 17, 2026, 10 p.m.
0010006411017010176nullMay 17, 2026, 10 p.m.
001000661null10248nullMay 17, 2026, 10 p.m.
0010006811009410104nullMay 17, 2026, 10 p.m.
0010006911014910159nullMay 17, 2026, 10 p.m.
00100070199589972nullMay 17, 2026, 10 p.m.
00100070298869892nullMay 17, 2026, 10 p.m.
00100070398979925nullMay 17, 2026, 10 p.m.
00100070499339947nullMay 17, 2026, 10 p.m.
00100071199549974nullMay 17, 2026, 10 p.m.
001000712999810010nullMay 17, 2026, 10 p.m.
0010007211000510020nullMay 17, 2026, 10 p.m.
0010007221008510090nullMay 17, 2026, 10 p.m.
00100072399869998nullMay 17, 2026, 10 p.m.
0010007241002810044nullMay 17, 2026, 10 p.m.
0010007811000610018nullMay 17, 2026, 10 p.m.
0010007821002310033nullMay 17, 2026, 10 p.m.
00100084199449952nullMay 17, 2026, 10 p.m.
00100084299589963nullMay 17, 2026, 10 p.m.
0010008431000210048nullMay 17, 2026, 10 p.m.
00100084499699989nullMay 17, 2026, 10 p.m.
001000861992210003nullMay 17, 2026, 10 p.m.
0010008911008710108nullMay 17, 2026, 10 p.m.
0010008921007010086nullMay 17, 2026, 10 p.m.
00100090199049940nullMay 17, 2026, 10 p.m.
00100091198929896nullMay 17, 2026, 10 p.m.
00100091299149924nullMay 17, 2026, 10 p.m.
00100091399389980nullMay 17, 2026, 10 p.m.
00100092198789882nullMay 17, 2026, 10 p.m.
00100092298989915nullMay 17, 2026, 10 p.m.
00100092399289934nullMay 17, 2026, 10 p.m.
00100094151455260nullMay 17, 2026, 10 p.m.
00100094256805700nullMay 17, 2026, 10 p.m.
00100094354705750nullMay 17, 2026, 10 p.m.
00100094455505595nullMay 17, 2026, 10 p.m.
00100094557705780nullMay 17, 2026, 10 p.m.
00100094656305900nullMay 17, 2026, 10 p.m.
00100094756305635nullMay 17, 2026, 10 p.m.
00100094858605900nullMay 17, 2026, 10 p.m.
00100096193629380nullMay 17, 2026, 10 p.m.
00100101154245950nullMay 17, 2026, 10 p.m.
00100101299549958nullMay 17, 2026, 10 p.m.
00100101399709973nullMay 17, 2026, 10 p.m.
001001014997610000nullMay 17, 2026, 10 p.m.
0010010411005010056nullMay 17, 2026, 10 p.m.
0010010611003710131nullMay 17, 2026, 10 p.m.
001001091null9656nullMay 17, 2026, 10 p.m.
001001101994210044nullMay 17, 2026, 10 p.m.
001001111null9515nullMay 17, 2026, 10 p.m.
0010011121003610040nullMay 17, 2026, 10 p.m.
0010011131004510050nullMay 17, 2026, 10 p.m.
00100112198789902nullMay 17, 2026, 10 p.m.
00100112299109944nullMay 17, 2026, 10 p.m.
001001131null10310nullMay 17, 2026, 10 p.m.
00100117198489916nullMay 17, 2026, 10 p.m.
00100120198829936nullMay 17, 2026, 10 p.m.
00100120298959900nullMay 17, 2026, 10 p.m.
00100120399079912nullMay 17, 2026, 10 p.m.
00100120499169926nullMay 17, 2026, 10 p.m.
00100120599289936nullMay 17, 2026, 10 p.m.
00100128199799990nullMay 17, 2026, 10 p.m.
001001282999710017nullMay 17, 2026, 10 p.m.
0010012831002110040nullMay 17, 2026, 10 p.m.
001001301null10177nullMay 17, 2026, 10 p.m.
001001331null10180nullMay 17, 2026, 10 p.m.
001001351null9215nullMay 17, 2026, 10 p.m.
00100135298979900nullMay 17, 2026, 10 p.m.
00100135399049910nullMay 17, 2026, 10 p.m.
00100135499169920nullMay 17, 2026, 10 p.m.
00100135599249934nullMay 17, 2026, 10 p.m.
00100137198809886nullMay 17, 2026, 10 p.m.
001001391null10206nullMay 17, 2026, 10 p.m.
001001641null4680nullMay 17, 2026, 10 p.m.
00100167134933559nullMay 17, 2026, 10 p.m.
001001891null5440nullMay 17, 2026, 10 p.m.
001002091null3567nullMay 17, 2026, 10 p.m.
00100240137543774nullMay 17, 2026, 10 p.m.
00100240237353747nullMay 17, 2026, 10 p.m.
001002591null4706nullMay 17, 2026, 10 p.m.
00100260146864690nullMay 17, 2026, 10 p.m.
00100260246924701nullMay 17, 2026, 10 p.m.
00100261146644668nullMay 17, 2026, 10 p.m.
00100262146444676nullMay 17, 2026, 10 p.m.
00100263146264662nullMay 17, 2026, 10 p.m.
00100264146504654nullMay 17, 2026, 10 p.m.
00100264246794686nullMay 17, 2026, 10 p.m.
00100265146704678nullMay 17, 2026, 10 p.m.
00100266146434684nullMay 17, 2026, 10 p.m.
00100267146404648nullMay 17, 2026, 10 p.m.
00100267246404648nullMay 17, 2026, 10 p.m.
00100267346304637nullMay 17, 2026, 10 p.m.
00100270146064634nullMay 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
6
  • 003 32.1K
  • 009 8.6K
  • 013 5.2K
  • 001 2.7K
  • 007 870
  • 005 603

api_unique

varchar

Sampled
50K
Distinct
25.7K
  • 30273 34
  • 35325 29
  • 35323 28
  • 35338 27
  • 35312 27
  • 35342 27
  • 35311 27
  • 34753 27
  • 30288 27
  • 34752 27
  • 35309 27
  • 34785 27

perf_count

int2

Sampled
50K
Distinct
33
  • 1 36.5K
  • 2 6.4K
  • 3 3K
  • 4 1.5K
  • 5 688
  • 6 421
  • 7 268
  • 8 200
  • 9 158
  • 10 128
  • 11 105
  • 12 85

open_hole_code

varchar

Sampled
50K
Distinct
1
Empty
0.9617
  • OH 1.9K

from_perf

int4

Sampled
50K
Distinct
10.1K
Empty
0.105
  • 4510 81
  • 4500 69
  • 4480 69
  • 4550 68
  • 4470 67
  • 4460 66
  • 4430 66
  • 4600 65
  • 4530 63
  • 4420 62
  • 4450 62
  • 4464 60

to_perf

int4

Sampled
50K
Distinct
12.1K
Empty
0.0026
  • 4700 531
  • 540 154
  • 4704 145
  • 4400 140
  • 7300 93
  • 4500 92
  • 4540 84
  • 4600 81
  • 4610 80
  • 4590 79
  • 4570 79
  • 490 69

ingested_at

timestamptz

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

Take it away

Back to everything we know about Wellbore Perforation Records