First 100 rows

Out of roughly 1.2M rows in texas.oil_ledger_lease_month. Version obs-b9a2154dc1cc.

First 100 rows of texas.oil_ledger_lease_month, 25 columns wide
districtfield_nooperator_nolease_nomonth_ordinalcycle_yyyymmseveranceretrorecname_changeoil_allowoil_prodflowing_wellsother_wellsdisp_amt_1disp_code_1disp_amt_2disp_code_2oil_in_storagegas_limitgas_prodgas_liftcasinghead_letterchange_status_codeletter_code
0120018931901612025061000000000000000000
0120018931901622025071000000000000000000
0120018931901632025081000000000000000000
0120018931901642025091000000000000000000
0120018931901652025101000000000000000000
0120018931901662025111000000000000000000
0120018931901672025121000000000000000000
0120018931901682026011000000000000000000
0120018931901692026021000000000000000000
01200189319016102026031000000000000000000
01200189319016112026041000000000000000000
01200189319016122026051000000000000000000
012001254431356412025061000000000000000000
012001254431356422025071000000000000000000
012001254431356432025081000000000000000000
012001254431356442025091000000000000000000
012001254431356452025101000000000000000000
012001254431356462025111000000000000000000
012001254431356472025121000000000000000000
012001254431356482026011000000000000000000
012001254431356492026021000000000000000000
0120012544313564102026031000000000000000000
0120012544313564112026041000000000000000000
0120012544313564122026051000000000000000000
012001360431755312025061000000000000000000
012001360431755322025071000000000000000000
012001360431755332025081000000000000000000
012001360431755342025091000000000000000000
012001360431755352025101000000000000000000
012001360431755362025111000000000000000000
012001360431755372025121000000000000000000
012001360431755382026011000000000000000000
012001360431755392026021000000000000000000
0120013604317553102026031000000000000000000
0120013604317553112026041000000000000000000
0120013604317553122026051000000000000000000
012001466152123612025060000000000000000000
012001466152123622025071000000000000000000
012001466152123632025081000000000000000000
012001466152123642025091000000000000000000
012001466152123652025101000000000000000000
012001466152123662025111000000000000000000
012001466152123672025121000000000000000000
012001466152123682026011000000000000000000
012001466152123692026021000000000000000000
0120014661521236102026031000000000000000000
0120014661521236112026041000000000000000000
0120014661521236122026051000000000000000000
012001641041713312025061000000000000000000
012001641041713322025071000000000000000000
012001641041713332025081000000000000000000
012001641041713342025091000000000000000000
012001641041713352025101000000000000000000
012001641041713362025111000000000000000000
012001641041713372025121000000000000000000
012001641041713382026011000000000000000000
012001641041713392026021000000000000000000
0120016410417133102026031000000000000000000
0120016410417133112026041000000000000000000
0120016410417133122026051000000000000000000
012001703761611412025061000000000000000000
012001703761611422025071000000000000000000
012001703761611432025081000000000000000000
012001703761611442025091000000000000000000
012001703761611452025101000000000000000000
012001703761611462025111000000000000000000
012001703761611472025121000000000000000000
012001703761611482026011000000000000000000
012001703761611492026021000000000000000000
0120017037616114102026031000000000000000000
0120017037616114112026041000000000000000000
0120017037616114122026051000000000000000000
012001703761740612025061000000000000000000
012001703761740622025071000000000000000000
012001703761740632025081000000000000000000
012001703761740642025091000000000000000000
012001703761740652025101000000000000000000
012001703761740662025111000000000000000000
012001703761740672025121000000000000000000
012001703761740682026011000000000000000000
012001703761740692026021000000000000000000
0120017037617406102026031000000000000000000
0120017037617406112026041000000000000000000
0120017037617406122026051000000000000000000
012001727041375712025061000000000000000000
012001727041375722025071005000000000000000
012001727041375732025081000000000000000000
012001727041375742025091000000000000000000
012001727041375752025101000000000000000000
012001727041375762025111000000000000000000
012001727041375772025121000000000000000000
012001727041375782026011000000000000000000
012001727041375792026021000000000000000000
0120017270413757102026031000000000000000000
0120017270413757112026041000000000000000000
0120017270413757122026051000000000000000000
012001730571621112025061000000000000000000
012001730571621122025071000000000000000000
012001730571621132025081000000000000000000
012001730571621142025091000000000000000000

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
1
  • 01 50K

field_no

int4

Sampled
50K
Distinct
190
  • 27135700 22.1K
  • 12018200 12.6K
  • 256500 1.6K
  • 26620001 1.2K
  • 23191333 1.1K
  • 2001 1.1K
  • 17668001 840
  • 12849001 768
  • 22820001 636
  • 7850001 576
  • 23191666 480
  • 6053500 456

operator_no

int4

Sampled
50K
Distinct
507
  • 253162 9.8K
  • 100351 5.4K
  • 424176 4.4K
  • 103575 2.5K
  • 103899 2.4K
  • 102886 2.2K
  • 256915 1.7K
  • 37775 1.1K
  • 100797 816
  • 847710 648
  • 594675 564
  • 870209 516

lease_no

int4

Sampled
50K
Distinct
4.2K
  • 5468 12
  • 5697 12
  • 4321 12
  • 1268 12
  • 8057 12
  • 6861 12
  • 5644 12
  • 5436 12
  • 7064 12
  • 12870 12
  • 4754 12
  • 11233 12

month_ordinal

int2

Sampled
50K
Distinct
12
  • 6 4.2K
  • 3 4.2K
  • 1 4.2K
  • 5 4.2K
  • 4 4.2K
  • 2 4.2K
  • 8 4.2K
  • 7 4.2K
  • 11 4.2K
  • 12 4.2K
  • 10 4.2K
  • 9 4.2K

cycle_yyyymm

int4

Sampled
50K
Distinct
1
  • 202506 50K

severance

int2

Sampled
50K
Distinct
2
  • 0 42.5K
  • 1 7.5K

retro

int2

Sampled
50K
Distinct
2
  • 0 35.6K
  • 1 14.4K

Take it away

Back to everything we know about Oil Ledger — Lease Months