First 100 rows

Out of roughly 2.9M rows in texas.oil_ledger_well_month. Version obs-4b2c90a09528.

First 100 rows of texas.oil_ledger_well_month, 37 columns wide
districtfield_nooperator_nolease_nowell_nomonth_ordinalcycle_yyyymmchangeno_suppoil_allowacodetcodegas_allowoil_allow_2acode_2tcode_2gas_allow_2date_2oil_allow_3acode_3tcode_3gas_allow_3date_3form_lackingprorated_gas_transfertransferred_sw_allowexempt_gas_transferearned_sw_allowacrespotentialbhp_or_acftgoroil_transfer_codeprorated_oil_transferexempt_oil_transferchange_status_codeooip
01200189319016 112025060008200000000000100000.000.00000000
01200189319016 122025070008200000000000100000.000.00000000
01200189319016 132025080008200000000000100000.000.00000000
01200189319016 142025090008200000000000100000.000.00000000
01200189319016 152025100008200000000000100000.000.00000000
01200189319016 162025110008200000000000100000.000.00000000
01200189319016 172025120008200000000000100000.000.00000000
01200189319016 182026010008200000000000100000.000.00000000
01200189319016 192026020008200000000000100000.000.00000000
01200189319016 1102026030008200000000000100000.000.00000000
01200189319016 1112026040008200000000000100000.000.00000000
01200189319016 1122026050008200000000000100000.000.00000000
01200189319016 1132026060008200000000000100000.000.00000000
01200189319016 1142026070008200000000000100000.000.00000000
0120012544313564 212025060008200000000000100000.000.00000000
0120012544313564 222025070008200000000000100000.000.00000000
0120012544313564 232025080008200000000000100000.000.00000000
0120012544313564 242025090008200000000000100000.000.00000000
0120012544313564 252025100008200000000000100000.000.00000000
0120012544313564 262025110008200000000000100000.000.00000000
0120012544313564 272025120008200000000000100000.000.00000000
0120012544313564 282026010008200000000000100000.000.00000000
0120012544313564 292026020008200000000000100000.000.00000000
0120012544313564 2102026030008200000000000100000.000.00000000
0120012544313564 2112026040008200000000000100000.000.00000000
0120012544313564 2122026050008200000000000100000.000.00000000
0120012544313564 2132026060008200000000000100000.000.00000000
0120012544313564 2142026070008200000000000100000.000.00000000
0120012544313564 312025060008200000000000100000.000.00000000
0120012544313564 322025070008200000000000100000.000.00000000
0120012544313564 332025080008200000000000100000.000.00000000
0120012544313564 342025090008200000000000100000.000.00000000
0120012544313564 352025100008200000000000100000.000.00000000
0120012544313564 362025110008200000000000100000.000.00000000
0120012544313564 372025120008200000000000100000.000.00000000
0120012544313564 382026010008200000000000100000.000.00000000
0120012544313564 392026020008200000000000100000.000.00000000
0120012544313564 3102026030008200000000000100000.000.00000000
0120012544313564 3112026040008200000000000100000.000.00000000
0120012544313564 3122026050008200000000000100000.000.00000000
0120012544313564 3132026060008200000000000100000.000.00000000
0120012544313564 3142026070008200000000000100000.000.00000000
0120013604317553 212025060008200000000000100000.000.00000000
0120013604317553 222025070008200000000000100000.000.00000000
0120013604317553 232025080008200000000000100000.000.00000000
0120013604317553 242025090008200000000000100000.000.00000000
0120013604317553 252025100008200000000000100000.000.00000000
0120013604317553 262025110008200000000000100000.000.00000000
0120013604317553 272025120008200000000000100000.000.00000000
0120013604317553 282026010008200000000000100000.000.00000000
0120013604317553 292026020008200000000000100000.000.00000000
0120013604317553 2102026030008200000000000100000.000.00000000
0120013604317553 2112026040008200000000000100000.000.00000000
0120013604317553 2122026050008200000000000100000.000.00000000
0120013604317553 2132026060008200000000000100000.000.00000000
0120013604317553 2142026070008200000000000100000.000.00000000
0120014661521236 112025060000900000000000000000.000.00000000
0120014661521236 122025070008200000000000000000.000.00000000
0120014661521236 132025080008200000000000000000.000.00000000
0120014661521236 142025090008200000000000000000.000.00000000
0120014661521236 152025100008200000000000000000.000.00000000
0120014661521236 162025110008200000000000000000.000.00000000
0120014661521236 172025120008200000000000000000.000.00000000
0120014661521236 182026010008200000000000100000.000.00000000
0120014661521236 192026020008200000000000100000.000.00000000
0120014661521236 1102026030008200000000000100000.000.00000000
0120014661521236 1112026040008200000000000100000.000.00000000
0120014661521236 1122026050008200000000000100000.000.00000000
0120014661521236 1132026060008200000000000100000.000.00000000
0120014661521236 1142026070000900000000000100000.000.00000000
0120016410417133 612025060008200000000000100000.000.00000000
0120016410417133 622025070008200000000000100000.000.00000000
0120016410417133 632025080008200000000000100000.000.00000000
0120016410417133 642025090008200000000000100000.000.00000000
0120016410417133 652025100008200000000000100000.000.00000000
0120016410417133 662025110008200000000000100000.000.00000000
0120016410417133 672025120008200000000000100000.000.00000000
0120016410417133 682026010008200000000000100000.000.00000000
0120016410417133 692026020008200000000000100000.000.00000000
0120016410417133 6102026030008200000000000100000.000.00000000
0120016410417133 6112026040008200000000000100000.000.00000000
0120016410417133 6122026050008200000000000100000.000.00000000
0120016410417133 6132026060008200000000000100000.000.00000000
0120016410417133 6142026070008200000000000100000.000.00000000
0120017037616114 1120250600082000000000001000040.000.00000000
0120017037616114 1220250700082000000000001000040.000.00000000
0120017037616114 1320250800082000000000001000040.000.00000000
0120017037616114 1420250900082000000000001000040.000.00000000
0120017037616114 1520251000082000000000001000040.000.00000000
0120017037616114 1620251100082000000000001000040.000.00000000
0120017037616114 1720251200082000000000001000040.000.00000000
0120017037616114 1820260100082000000000001000040.000.00000000
0120017037616114 1920260200082000000000001000040.000.00000000
0120017037616114 11020260300082000000000001000040.000.00000000
0120017037616114 11120260400082000000000001000040.000.00000000
0120017037616114 11220260500082000000000001000040.000.00000000
0120017037616114 11320260600082000000000001000040.000.00000000
0120017037616114 11420260700082000000000001000040.000.00000000
0120017037617406 112025060008200000000000100000.000.00000000
0120017037617406 122025070008200000000000100000.000.00000000

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
42
  • 12018200 33.3K
  • 256500 7.6K
  • 7850001 1.8K
  • 8072500 1.3K
  • 2001 938
  • 6053500 826
  • 621200 686
  • 7850666 644
  • 467505 504
  • 467510 434
  • 8072750 294
  • 467515 238

operator_no

int4

Sampled
50K
Distinct
168
  • 424176 9.1K
  • 100351 9K
  • 256915 4.5K
  • 594675 3.1K
  • 103575 2.3K
  • 337080 1.7K
  • 102824 1.6K
  • 945936 1.4K
  • 273933 1.2K
  • 36587 1.2K
  • 276959 882
  • 102686 714

lease_no

int4

Sampled
50K
Distinct
667
  • 4530 1.8K
  • 1253 1.3K
  • 1141 1.2K
  • 4421 1K
  • 4731 868
  • 5883 686
  • 4317 672
  • 1499 546
  • 151 546
  • 1683 434
  • 3231 420
  • 4970 406

well_no

varchar

Sampled
50K
Distinct
613
  • 1 5.4K
  • 2 3.7K
  • 3 2.9K
  • 4 2.4K
  • 5 2.3K
  • 6 1.9K
  • 7 1.8K
  • 8 1.6K
  • 9 1.3K
  • 10 1.3K
  • 11 1.1K
  • 12 1K

month_ordinal

int2

Sampled
50K
Distinct
14
  • 4 3.6K
  • 3 3.6K
  • 1 3.6K
  • 5 3.6K
  • 2 3.6K
  • 6 3.6K
  • 7 3.6K
  • 8 3.6K
  • 12 3.6K
  • 14 3.6K
  • 11 3.6K
  • 13 3.6K

cycle_yyyymm

int4

Sampled
50K
Distinct
1
  • 202506 50K

change

int2

Sampled
50K
Distinct
1
  • 0 50K

Take it away

Back to everything we know about Oil Ledger — Well Months