EZRRC
Cart Sign in

Oil Detail Well — W-10 Tests — 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 171.9K rows in texas.oil_detail_well_test. Version obs-3ce30f759978.

districtfield_nooperator_nolease_norec_nowell_notest_ordinaltest_dateoil_bblprd_methodwater_bblgor
016469001102014311 21May 13, 20241.0100
016469001102014311 22March 8, 20251.0100
016469001102014311 31May 20, 20241.0100
016469001102014311 32March 9, 20251.0100
016469001102014311 41May 28, 20241.0100
016469001102014311 42March 10, 20251.0100
01785000153421933801 11Dec. 11, 19900.0000
01785000153421933801 12Dec. 11, 19900.0000
01785000153421933801 21March 1, 20230.0000
01785000153421933801 22March 1, 20230.0000
01785000153421933801 31Jan. 1, 19950.0000
01785000153421933801 32Jan. 1, 19950.0000
01785000153421933801 41March 1, 20230.0000
01785000153421933801 42March 1, 20230.0000
01785000153421933801 51Jan. 1, 19950.0000
01785000153421933801 52Jan. 1, 19950.0000
01785000153421933801 61Jan. 1, 19950.0000
01785000153421933801 62Jan. 1, 19950.0000
01785000153421933801 91March 1, 20230.0000
01785000153421933801 92March 1, 20230.0000
01785000153421933801 111March 1, 20230.0000
01785000153421933801 112March 1, 20230.0000
01785000153421933801 121March 1, 20230.0000
01785000153421933801 122March 1, 20230.0000
01785000153421933801 131March 1, 20230.0000
01785000153421933801 132March 1, 20230.0000
01785000153421933801 141March 1, 20230.0000
01785000153421933801 142March 1, 20230.0000
01785000153421933801 151March 1, 20230.0000
01785000153421933801 152March 1, 20230.0000
01785000153421933801 161Jan. 1, 19950.0000
01785000153421933801 162Jan. 1, 19950.0000
01785000153421933801 171Jan. 1, 19950.0000
01785000153421933801 172Jan. 1, 19950.0000
01785000153421933801 17A1March 1, 20230.0000
01785000153421933801 17A2March 1, 20230.0000
01785000153421933801 181March 1, 20230.0000
01785000153421933801 182March 1, 20230.0000
01785000153421933801 231March 1, 20230.0000
01785000153421933801 232March 1, 20230.0000
01785000153421933801 23A1March 1, 20230.0000
01785000153421933801 23A2March 1, 20230.0000
01785000153421933801 241March 1, 20230.0000
01785000153421933801 242March 1, 20230.0000
01785000153421933801 251March 1, 20230.0000
01785000153421933801 252March 1, 20230.0000
01785000153421933801 271March 1, 20230.0000
01785000153421933801 272March 1, 20230.0000
01785000153421933801 311Jan. 1, 19950.0000
01785000153421933801 312Jan. 1, 19950.0000
01785000153421933801 321Jan. 1, 19950.0000
01785000153421933801 322Jan. 1, 19950.0000
01785000153421933801 331March 1, 20230.0000
01785000153421933801 332March 1, 20230.0000
01785000153421933801 341Jan. 1, 19950.0000
01785000153421933801 342Jan. 1, 19950.0000
01785000153421933801 401March 1, 20230.0000
01785000153421933801 402March 1, 20230.0000
01785000153421933801 411Jan. 1, 19950.0000
01785000153421933801 412Jan. 1, 19950.0000
01785000153421933801 421March 1, 20230.0000
01785000153421933801 422March 1, 20230.0000
01785000153421933801 431Jan. 1, 19950.0000
01785000153421933801 432Jan. 1, 19950.0000
01785000153421933801 441March 1, 20230.0000
01785000153421933801 442March 1, 20230.0000
01785000153421933801 461March 1, 20230.0000
01785000153421933801 462March 1, 20230.0000
01785000153421933801 471Jan. 1, 19950.0000
01785000153421933801 472Jan. 1, 19950.0000
01785000153421933801 481March 1, 20230.0000
01785000153421933801 482March 1, 20230.0000
01785000153421933801 491Jan. 1, 19950.0000
01785000153421933801 492Jan. 1, 19950.0000
01785000153421933801 511Jan. 1, 19950.0000
01785000153421933801 512Jan. 1, 19950.0000
01785000153421933801 521March 1, 20230.0000
01785000153421933801 522March 1, 20230.0000
01785000153421933801 531Jan. 1, 19950.0000
01785000153421933801 532Jan. 1, 19950.0000
01785000153421933801 541March 1, 20230.0000
01785000153421933801 542March 1, 20230.0000
01785000153421933801 551Jan. 1, 19950.0000
01785000153421933801 552Jan. 1, 19950.0000
01785000153421933801 561March 1, 20230.0000
01785000153421933801 562March 1, 20230.0000
01785000153421933801 581March 1, 20230.0000
01785000153421933801 582March 1, 20230.0000
01785000153421933801 591Jan. 1, 19950.0000
01785000153421933801 592Jan. 1, 19950.0000
01785000153421933801 59A1March 1, 20230.0000
01785000153421933801 59A2March 1, 20230.0000
01785000153421933801 611March 1, 20230.0000
01785000153421933801 612March 1, 20230.0000
01785000153421933801 621Jan. 1, 19950.0000
01785000153421933801 622Jan. 1, 19950.0000
01785000153421933801 631March 1, 20230.0000
01785000153421933801 632March 1, 20230.0000
01785000153421933801 641Jan. 1, 19950.0000
01785000153421933801 642Jan. 1, 19950.0000

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.

district

varchar

Sampled
50K
Distinct
10
  • 08 14.7K
  • 01 10K
  • 07B 9.3K
  • 07C 5.8K
  • 06 3.3K
  • 03 2.2K
  • 02 1.5K
  • 05 1.2K
  • 06E 1.1K
  • 04 948

field_no

int4

Sampled
50K
Distinct
364
  • 21289001 2.8K
  • 85948001 2.7K
  • 33230001 2.4K
  • 32309001 1.9K
  • 79451750 1.7K
  • 61858001 1.6K
  • 82522001 1.3K
  • 58840001 1.3K
  • 33176001 1.3K
  • 88534001 1.2K
  • 39724001 1.1K
  • 27302001 1.1K

operator_no

int4

Sampled
50K
Distinct
524
  • 386310 4.3K
  • 617544 3.4K
  • 53974 2.5K
  • 149477 1.7K
  • 847710 1.5K
  • 8716 1.1K
  • 102229 1.1K
  • 154235 1.1K
  • 40209 916
  • 103746 860
  • 40810 804
  • 760218 710

lease_no

int4

Sampled
50K
Distinct
1.4K
  • 1770 2.3K
  • 20164 2K
  • 2082 1.7K
  • 5743 1.1K
  • 21220 916
  • 14495 804
  • 3380 588
  • 11659 470
  • 11296 468
  • 5280 446
  • 1214 432
  • 442 356

rec_no

varchar

Sampled
50K
Distinct
10
  • 1 38.4K
  • A 9.8K
  • B 1.2K
  • C 280
  • I 214
  • 2 64
  • 6 6
  • D 2
  • H 2
  • 3 2

well_no

varchar

Sampled
50K
Distinct
8.2K
  • 1 1.1K
  • 2 1K
  • 3 944
  • 4 850
  • 5 774
  • 6 728
  • 7 712
  • 8 654
  • 10 554
  • 9 532
  • 11 494
  • 12 486

test_ordinal

int2

Sampled
50K
Distinct
2
  • 1 25K
  • 2 25K

test_date

date

Sampled
50K
Distinct
5.2K
  • Jan. 1, 1995 3.2K
  • Nov. 1, 1994 2.4K
  • April 1, 1995 2.3K
  • Sept. 1, 1994 2.2K
  • Aug. 1, 1994 2.2K
  • Oct. 1, 1994 2.1K
  • May 1, 1995 2K
  • July 1, 1994 1.5K
  • Feb. 1, 1995 1.4K
  • June 1, 1994 898
  • March 1, 1995 512
  • Dec. 1, 1994 506

Take it away

Back to everything we know about Oil Detail Well — W-10 Tests