First 100 rows

Out of roughly 52K rows in texas.oil_ledger_multiwell_month. Version obs-919e88df6a40.

First 100 rows of texas.oil_ledger_multiwell_month, 28 columns wide
districtfield_nooperator_nolease_nom_recordmonth_ordinalcycle_yyyymmchangeno_suppoil_allowacodetcodegas_allowoil_allow_2acode_2tcode_2gas_allow_2date_2oil_allow_3acode_3tcode_3gas_allow_3date_3form_lackingpotentialkode_2gorchange_status_code
01646900110201431 1120250602310330000000000003000
01646900110201431 1220250700310330000000000003000
01646900110201431 1320250800310330000000000003000
01646900110201431 1420250900310330000000000003000
01646900110201431 1520251000310330000000000003000
01646900110201431 1620251100310330000000000003000
01646900110201431 1720251200310330000000000003000
01646900110201431 1820260100310330000000000003000
01646900110201431 1920260200310330000000000003000
01646900110201431 11020260300310330000000000003000
01646900110201431 11120260400310330000000000003000
01646900110201431 11220260500310330000000000003000
01646900110201431 11320260600310330000000000003000
01646900110201431 11420260700310330000000000003000
0178500015342193380 11202506020100000000000000000
0178500015342193380 12202507000100000000000000000
0178500015342193380 13202508000100000000000000000
0178500015342193380 14202509000100000000000000000
0178500015342193380 15202510000100000000000000000
0178500015342193380 16202511000100000000000000000
0178500015342193380 17202512000100000000000000000
0178500015342193380 18202601000100000000000000000
0178500015342193380 19202602000100000000000000000
0178500015342193380 110202603000100000000000000000
0178500015342193380 111202604000100000000000000000
0178500015342193380 112202605000100000000000000000
0178500015342193380 113202606000100000000000000000
0178500015342193380 114202607000100000000000000000
011514600136587177 11202506020100000000000000000
011514600136587177 12202507000100000000000000000
011514600136587177 132025080001000000000000041000
011514600136587177 142025090001000000000000041000
011514600136587177 15202510000103100000000000041000
011514600136587177 16202511000103100000000000041000
011514600136587177 17202512000103100000000000041000
011514600136587177 18202601000103100000000000041000
011514600136587177 19202602000103100000000000041000
011514600136587177 1102026030002500000000000041000
011514600136587177 1112026040002500000000000041000
011514600136587177 1122026050001000000000000041000
011514600136587177 1132026060001000000000000041000
011514600136587177 1142026070001000000000000041000
01172485684278583269 A120250602371016160000000000032000
01172485684278583269 A220250700371016160000000000032000
01172485684278583269 A320250800371016160000000000032000
01172485684278583269 A420250900252016160000000000032001
01172485684278583269 A520251000251016160000000000032001
01172485684278583269 A620251100251016160000000000032001
01172485684278583269 A720251200251016160000000000025001
01172485684278583269 A820260100251016160000000000025001
01172485684278583269 A920260200251016160000000000025001
01172485684278583269 A1020260300251016160000000000025001
01172485684278583269 A1120260400251016160000000000025001
01172485684278583269 A1220260500251016160000000000025001
01172485684278583269 A1320260600251016160000000000025001
01172485684278583269 A1420260700251016160000000000025000
01172487108913284 112025060231080000000000003000
01172487108913284 122025070031080000000000003000
01172487108913284 132025080081080000000000003001
01172487108913284 142025090081080000000000003001
01172487108913284 152025100081080000000000003001
01172487108913284 162025110081080000000000003001
01172487108913284 172025120081080000000000004001
01172487108913284 182026010081080000000000004001
01172487108913284 192026020081080000000000004001
01172487108913284 1102026030081080000000000004001
01172487108913284 1112026040081080000000000004001
01172487108913284 1122026050081080000000000004000
01172487108913284 1132026060081080000000000004000
01172487108913284 1142026070081080000000000004000
01172487108913308 112025060231080000000000002000
01172487108913308 122025070031080000000000002000
01172487108913308 132025080031080000000000002000
01172487108913308 142025090031080000000000002000
01172487108913308 152025100031080000000000002000
01172487108913308 162025110031080000000000002000
01172487108913308 172025120031080000000000002000
01172487108913308 182026010031080000000000002000
01172487108913308 192026020031080000000000002000
01172487108913308 1102026030021080000000000002000
01172487108913308 1112026040021080000000000002000
01172487108913308 1122026050021080000000000002000
01172487108913308 1132026060021080000000000002000
01172487108913308 1142026070021080000000000002000
01172487104801783316 11202506025104000000000000020000
01172487104801783316 12202507005104000000000000020000
01172487104801783316 13202508005104000000000000020000
01172487104801783316 142025090020104000000000000020000
01172487104801783316 152025100020104000000000000020000
01172487104801783316 162025110020104000000000000020000
01172487104801783316 172025120020104000000000000020000
01172487104801783316 182026010020104000000000000020000
01172487104801783316 19202602005204000000000000012000
01172487104801783316 1102026030001000000000000012000
01172487104801783316 1112026040001000000000000012000
01172487104801783316 1122026050001000000000000012000
01172487104801783316 1132026060001000000000000012000
01172487104801783316 1142026070001000000000000012000
01172487104801783317 1120250602210160000000000002000
01172487104801783317 1220250700210160000000000002000

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
12
  • 09 14.5K
  • 08 11.6K
  • 07B 5.9K
  • 08A 5.5K
  • 01 5.3K
  • 07C 3K
  • 06 1.2K
  • 04 784
  • 05 742
  • 06E 616
  • 03 490
  • 02 322

field_no

int4

Sampled
50K
Distinct
705
  • 97155001 4.3K
  • 3446001 2.7K
  • 20350001 1.9K
  • 42971200 1.8K
  • 62528001 1.5K
  • 85948001 1.3K
  • 82522001 1.1K
  • 97331001 868
  • 84560001 854
  • 95138001 840
  • 49038001 756
  • 25544001 728

operator_no

int4

Sampled
50K
Distinct
917
  • 386310 1.4K
  • 53974 1.1K
  • 847710 1K
  • 687719 812
  • 877921 812
  • 880393 770
  • 617544 728
  • 102117 644
  • 154235 574
  • 684588 560
  • 101718 560
  • 108799 560

lease_no

int4

Sampled
50K
Distinct
3.3K
  • 3137 56
  • 1218 42
  • 948 42
  • 14053 42
  • 835 42
  • 465 42
  • 843 42
  • 4157 42
  • 5657 42
  • 573 42
  • 17491 42
  • 19136 42

m_record

varchar

Sampled
50K
Distinct
11
  • 1 29.4K
  • A 17.3K
  • B 2.4K
  • C 588
  • 2 126
  • 3 70
  • H 14
  • D 14
  • 4 14
  • 6 14
  • I 14

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
14
  • 202603 3.7K
  • 202606 3.7K
  • 202604 3.7K
  • 202510 3.7K
  • 202509 3.7K
  • 202506 3.7K
  • 202507 3.7K
  • 202601 3.7K
  • 202511 3.7K
  • 202508 3.7K
  • 202605 3.7K
  • 202602 3.7K

change

int2

Sampled
50K
Distinct
1
  • 0 50K

Take it away

Back to everything we know about Oil Ledger — Multi-Well Group Months