district
varchar
- Sampled
- 50K
- Distinct
- 2
-
0230.6K -
0119.4K
Oil Ledger — Field Months — 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 475.1K rows in
texas.oil_ledger_field_month.
Version obs-836daf878661.
district | field_no | month_ordinal | cycle_yyyymm | per_well | acreage_factor | other_factor_code | month_exempt_code | prod_factor | split_prod_factor | split_prod_factor_date | change_status_code | other_factor |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01 | 2001 | 1 | 202506 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 2 | 202507 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 3 | 202508 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 4 | 202509 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 5 | 202510 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 6 | 202511 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 7 | 202512 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 8 | 202601 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 9 | 202602 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 10 | 202603 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 11 | 202604 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 12 | 202605 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 13 | 202606 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2001 | 14 | 202607 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 1 | 202506 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 2 | 202507 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 3 | 202508 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 4 | 202509 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 5 | 202510 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 6 | 202511 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 7 | 202512 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 8 | 202601 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 9 | 202602 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 10 | 202603 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 11 | 202604 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 12 | 202605 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 13 | 202606 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 2999 | 14 | 202607 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 1 | 202506 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 2 | 202507 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 3 | 202508 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 4 | 202509 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 5 | 202510 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 6 | 202511 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 7 | 202512 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 8 | 202601 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 9 | 202602 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 10 | 202603 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 11 | 202604 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 12 | 202605 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 13 | 202606 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256500 | 14 | 202607 | 0 | 3.4000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 1 | 202506 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 2 | 202507 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 3 | 202508 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 4 | 202509 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 5 | 202510 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 6 | 202511 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 7 | 202512 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 8 | 202601 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 9 | 202602 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 10 | 202603 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 11 | 202604 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 12 | 202605 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 13 | 202606 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256600 | 14 | 202607 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 1 | 202506 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 2 | 202507 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 3 | 202508 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 4 | 202509 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 5 | 202510 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 6 | 202511 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 7 | 202512 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 8 | 202601 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 9 | 202602 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 10 | 202603 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 11 | 202604 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 12 | 202605 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 13 | 202606 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256700 | 14 | 202607 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 1 | 202506 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 2 | 202507 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 3 | 202508 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 4 | 202509 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 5 | 202510 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 6 | 202511 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 7 | 202512 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 8 | 202601 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 9 | 202602 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 10 | 202603 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 11 | 202604 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 12 | 202605 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 13 | 202606 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 256750 | 14 | 202607 | 0 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 1 | 202506 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 2 | 202507 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 3 | 202508 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 4 | 202509 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 5 | 202510 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 6 | 202511 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 7 | 202512 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 8 | 202601 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 9 | 202602 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 10 | 202603 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 11 | 202604 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 12 | 202605 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 13 | 202606 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434333 | 14 | 202607 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434666 | 1 | 202506 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
| 01 | 434666 | 2 | 202507 | 73 | 0.0000 | 0 | 0 | 1.000 | 0.000 | 0 | 0 | 0.0000000 |
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.
field_no
int4
- Sampled
- 50K
- Distinct
- 3.6K
-
5097514814 -
2865891214 -
8466060014 -
4845295014 -
7262311514 -
5111077714 -
62133314 -
2820920014 -
5846930014 -
1842250014 -
5445845114 -
790566614
month_ordinal
int2
- Sampled
- 50K
- Distinct
- 14
-
43.6K -
33.6K -
13.6K -
53.6K -
23.6K -
63.6K -
73.6K -
83.6K -
123.6K -
143.6K -
113.6K -
133.6K
cycle_yyyymm
int4
- Sampled
- 50K
- Distinct
- 2
-
20250633.9K -
20250716.1K
per_well
int2
- Sampled
- 50K
- Distinct
- 90
-
026.1K -
1022.9K -
1112.2K -
821.6K -
731.2K -
931.1K -
551.1K -
91938 -
64910 -
84896 -
121882 -
101700
acreage_factor
numeric
- Sampled
- 50K
- Distinct
- 157
-
0.000042K -
2.5500434 -
1.7500308 -
3.0500266 -
4.1000253 -
2.7750252 -
1.5000210 -
2.7500182 -
2.1000168 -
2.7000140 -
2.2000140 -
2.1375140
other_factor_code
int2
- Sampled
- 50K
- Distinct
- 3
-
050K -
114 -
314
month_exempt_code
int2
- Sampled
- 50K
- Distinct
- 2
-
049K -
1980