district
varchar
- Sampled
- 50K
- Distinct
- 2
-
0232.1K -
0117.9K
Gas 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 589.9K rows in
texas.gas_ledger_field_month.
Version obs-a3836d7d51f0.
district | field_no | month_ordinal | cycle_yyyymm | change | per_well_code | per_well | acres_code | acreage_factor | other_code | other_factor | sw_split | split_date | special_lmt_allow | sw_exc_206_code | sw_exc_8609_limit |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01 | 2001 | 1 | 202506 | 0 | 0 | 0 | 0 | 30.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 2 | 202507 | 0 | 0 | 0 | 0 | 31.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 3 | 202508 | 0 | 0 | 0 | 0 | 31.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 4 | 202509 | 0 | 0 | 0 | 0 | 30.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 5 | 202510 | 0 | 0 | 0 | 0 | 31.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 6 | 202511 | 0 | 0 | 0 | 0 | 30.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 7 | 202512 | 0 | 0 | 0 | 0 | 31.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 8 | 202601 | 0 | 0 | 0 | 0 | 31.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 9 | 202602 | 0 | 0 | 0 | 0 | 28.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 10 | 202603 | 0 | 0 | 0 | 0 | 31.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 11 | 202604 | 0 | 0 | 0 | 0 | 30.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 12 | 202605 | 0 | 0 | 0 | 0 | 31.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 13 | 202606 | 0 | 0 | 0 | 0 | 30.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 2001 | 14 | 202607 | 0 | 0 | 0 | 0 | 31.0000000 | 17 | 1.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 1 | 202506 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 2 | 202507 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 3 | 202508 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 4 | 202509 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 5 | 202510 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 6 | 202511 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 7 | 202512 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 8 | 202601 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 9 | 202602 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 10 | 202603 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 11 | 202604 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 12 | 202605 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 13 | 202606 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256500 | 14 | 202607 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256600 | 1 | 202506 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 2 | 202507 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 3 | 202508 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 4 | 202509 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 5 | 202510 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 6 | 202511 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 7 | 202512 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 8 | 202601 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 9 | 202602 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 10 | 202603 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 11 | 202604 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 12 | 202605 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 13 | 202606 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256600 | 14 | 202607 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 256700 | 1 | 202506 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 2 | 202507 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 3 | 202508 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 4 | 202509 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 5 | 202510 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 6 | 202511 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 7 | 202512 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 8 | 202601 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 9 | 202602 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 10 | 202603 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 11 | 202604 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 12 | 202605 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 13 | 202606 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256700 | 14 | 202607 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 1 | 202506 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 2 | 202507 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 3 | 202508 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 4 | 202509 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 5 | 202510 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 6 | 202511 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 7 | 202512 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 8 | 202601 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 9 | 202602 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 10 | 202603 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 11 | 202604 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 12 | 202605 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 13 | 202606 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 256750 | 14 | 202607 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 1 | 202506 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 2 | 202507 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 3 | 202508 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 4 | 202509 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 5 | 202510 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 6 | 202511 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 7 | 202512 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 8 | 202601 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 9 | 202602 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 10 | 202603 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 11 | 202604 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 12 | 202605 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 13 | 202606 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 464100 | 14 | 202607 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 1 | 202506 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 2 | 202507 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 3 | 202508 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 4 | 202509 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 5 | 202510 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 6 | 202511 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 7 | 202512 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 8 | 202601 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 9 | 202602 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 10 | 202603 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 11 | 202604 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 12 | 202605 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 13 | 202606 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 467500 | 14 | 202607 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 1 | 0 | 0 |
| 01 | 517500 | 1 | 202506 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
| 01 | 517500 | 2 | 202507 | 0 | 0 | 0 | 0 | 0.0000000 | 0 | 0.0000000 | 0.000 | 0 | 0 | 0 | 0 |
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
-
7755260014 -
1966912514 -
93005014 -
5511650014 -
1525530014 -
2865891214 -
8466060014 -
3076960014 -
8120550014 -
1102520014 -
7813914214 -
1902807614
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
- 14
-
2025113.6K -
2025083.6K -
2025093.6K -
2025063.6K -
2025073.6K -
2025103.6K -
2025123.6K -
2026023.6K -
2026033.6K -
2026063.6K -
2026043.6K -
2026013.6K
change
int2
- Sampled
- 50K
- Distinct
- 1
-
050K
per_well_code
int2
- Sampled
- 50K
- Distinct
- 2
-
050K -
126
per_well
int4
- Sampled
- 50K
- Distinct
- 18
-
050K -
2652 -
21662 -
2992 -
22231 -
19051 -
24151 -
25621 -
2891 -
21011 -
24741 -
17081
acres_code
int2
- Sampled
- 50K
- Distinct
- 3
-
049.9K -
1969 -
211