district
varchar
- Sampled
- 50K
- Distinct
- 1
-
0150K
Historical Ledger — Oil Lease 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 29.5M rows in
texas.hist_oil_lease_cycle.
Version obs-8c45791447a5.
district | lease_no | cycle_yyyymm | operator_no | field_no | field_reservoir_no | oil_type_field_code | p1_filed | corrected_p1 | flow_wells | other_wells | commingled | allowable | oil_production | oil_ending_balance | oil_present_status | oil_movable_balance | csghd_limit | csghd_production | csghd_lift | csghd_status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01 | 1 | 199312 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199311 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199310 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199309 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199308 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199307 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199306 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199305 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199304 | 416670 | 467 | 500 | R | null | null | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199303 | 416670 | 467 | 500 | null | null | null | 0 | 0 | null | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199302 | 416670 | 467 | 500 | null | null | null | 0 | 0 | null | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 1 | 199301 | 416670 | 467 | 500 | null | null | null | 0 | 0 | null | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 01 | 2 | 199312 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 155 | 101 | 151 | 0 | 151 | 11904 | 1 | 0 | 0 |
| 01 | 2 | 199311 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 150 | 80 | 211 | 0 | 211 | 11520 | 1 | 0 | 0 |
| 01 | 2 | 199310 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 155 | 48 | 131 | 0 | 131 | 11904 | 1 | 0 | 0 |
| 01 | 2 | 199309 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 150 | 148 | 83 | 0 | 83 | 11520 | 1 | 0 | 0 |
| 01 | 2 | 199308 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 124 | 51 | 99 | 0 | 99 | 11904 | 1 | 0 | 0 |
| 01 | 2 | 199307 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 124 | 65 | 215 | 0 | 215 | 11904 | 1 | 0 | 0 |
| 01 | 2 | 199306 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 120 | 50 | 150 | 0 | 150 | 11520 | 1 | 0 | 0 |
| 01 | 2 | 199305 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 124 | 74 | 100 | 0 | 100 | 11904 | 1 | 0 | 0 |
| 01 | 2 | 199304 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 120 | 74 | 190 | 0 | 190 | 11520 | 1 | 0 | 0 |
| 01 | 2 | 199303 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 124 | 109 | 116 | 0 | 116 | 11904 | 1 | 0 | 0 |
| 01 | 2 | 199302 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 84 | 70 | 170 | 0 | 170 | 10752 | 1 | 0 | 0 |
| 01 | 2 | 199301 | 509115 | 467 | 500 | R | Y | 0 | 0 | 3 | N | 124 | 18 | 100 | 0 | 100 | 11904 | 1 | 0 | 0 |
| 01 | 3 | 199312 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 62 | 29 | 61 | 0 | 61 | 3968 | 1 | 0 | 0 |
| 01 | 3 | 199311 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 60 | 27 | 32 | 0 | 32 | 3840 | 1 | 0 | 0 |
| 01 | 3 | 199310 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 62 | 29 | 183 | 0 | 183 | 3968 | 1 | 0 | 0 |
| 01 | 3 | 199309 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 60 | 39 | 154 | 0 | 154 | 3840 | 1 | 0 | 0 |
| 01 | 3 | 199308 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 62 | 5 | 115 | 0 | 115 | 3968 | 1 | 0 | 0 |
| 01 | 3 | 199307 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 62 | 33 | 110 | 0 | 110 | 3968 | 1 | 0 | 0 |
| 01 | 3 | 199306 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 60 | 49 | 77 | 0 | 77 | 3840 | 1 | 0 | 0 |
| 01 | 3 | 199305 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 62 | 51 | 28 | 0 | 28 | 3968 | 1 | 0 | 0 |
| 01 | 3 | 199304 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 60 | 22 | 144 | 0 | 144 | 3840 | 1 | 0 | 0 |
| 01 | 3 | 199303 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 62 | 15 | 122 | 0 | 122 | 3968 | 1 | 0 | 0 |
| 01 | 3 | 199302 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 56 | 20 | 107 | 0 | 107 | 3584 | 1 | 0 | 0 |
| 01 | 3 | 199301 | 509115 | 467 | 500 | R | Y | 0 | 0 | 1 | N | 62 | 36 | 87 | 0 | 87 | 3968 | 1 | 0 | 0 |
| 01 | 5 | 199312 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 93 | 41 | 111 | 0 | 111 | 7936 | 1 | 0 | 0 |
| 01 | 5 | 199311 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 90 | 88 | 70 | 0 | 70 | 7680 | 1 | 0 | 0 |
| 01 | 5 | 199310 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 93 | 72 | 144 | 0 | 144 | 7936 | 1 | 0 | 0 |
| 01 | 5 | 199309 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 90 | 24 | 72 | 0 | 72 | 7680 | 1 | 0 | 0 |
| 01 | 5 | 199308 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 93 | 57 | 48 | 0 | 48 | 7936 | 1 | 0 | 0 |
| 01 | 5 | 199307 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 93 | 80 | 155 | 0 | 155 | 7936 | 1 | 0 | 0 |
| 01 | 5 | 199306 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 90 | 38 | 75 | 0 | 75 | 7680 | 1 | 0 | 0 |
| 01 | 5 | 199305 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 93 | 56 | 37 | 0 | 37 | 7936 | 1 | 0 | 0 |
| 01 | 5 | 199304 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 90 | 60 | 144 | 0 | 144 | 7680 | 1 | 0 | 0 |
| 01 | 5 | 199303 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 93 | 77 | 84 | 0 | 84 | 7936 | 1 | 0 | 0 |
| 01 | 5 | 199302 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 84 | 56 | 173 | 0 | 173 | 7168 | 1 | 0 | 0 |
| 01 | 5 | 199301 | 508935 | 467 | 500 | R | Y | 0 | 0 | 2 | N | 155 | 33 | 117 | 0 | 117 | 7936 | 1 | 0 | 0 |
| 01 | 6 | 199312 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199311 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199310 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199309 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199308 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199307 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199306 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199305 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199304 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199303 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199302 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 6 | 199301 | 508935 | 467 | 500 | R | Y | 0 | 0 | 0 | N | 0 | 0 | 57 | 0 | 57 | 0 | 0 | 0 | 0 |
| 01 | 13 | 199312 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 155 | 40 | 71 | 0 | 71 | 3410 | 0 | 0 | 0 |
| 01 | 13 | 199311 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 150 | 0 | 31 | 0 | 31 | 3300 | 0 | 0 | 0 |
| 01 | 13 | 199310 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 155 | 38 | 167 | 0 | 167 | 3410 | 0 | 0 | 0 |
| 01 | 13 | 199309 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 150 | 36 | 129 | 0 | 129 | 3300 | 1 | 0 | 0 |
| 01 | 13 | 199308 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 155 | 38 | 93 | 0 | 93 | 3410 | 1 | 0 | 0 |
| 01 | 13 | 199307 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 155 | 35 | 55 | 0 | 55 | 3410 | 1 | 0 | 0 |
| 01 | 13 | 199306 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 150 | 0 | 138 | 0 | 138 | 3300 | 0 | 0 | 0 |
| 01 | 13 | 199305 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 155 | 34 | 145 | 0 | 145 | 3410 | 1 | 0 | 0 |
| 01 | 13 | 199304 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 150 | 36 | 111 | 0 | 111 | 3300 | 1 | 0 | 0 |
| 01 | 13 | 199303 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 155 | 37 | 75 | 0 | 75 | 3410 | 1 | 0 | 0 |
| 01 | 13 | 199302 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 140 | 0 | 38 | 0 | 38 | 3080 | 0 | 0 | 0 |
| 01 | 13 | 199301 | 254359 | 2564 | 1 | R | Y | 0 | 0 | 1 | N | 155 | 119 | 170 | 0 | 170 | 3410 | 1 | 0 | 0 |
| 01 | 18 | 199312 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 62 | 1 | 191 | 0 | 191 | 310 | 1 | 0 | 0 |
| 01 | 18 | 199311 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 60 | 1 | 190 | 0 | 190 | 300 | 1 | 0 | 0 |
| 01 | 18 | 199310 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 62 | 41 | 189 | 0 | 189 | 310 | 1 | 0 | 0 |
| 01 | 18 | 199309 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 60 | 50 | 148 | 0 | 148 | 300 | 1 | 0 | 0 |
| 01 | 18 | 199308 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 31 | 17 | 98 | 0 | 98 | 310 | 1 | 0 | 0 |
| 01 | 18 | 199307 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 31 | 16 | 81 | 0 | 81 | 310 | 1 | 0 | 0 |
| 01 | 18 | 199306 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 30 | 16 | 65 | 0 | 65 | 300 | 1 | 0 | 0 |
| 01 | 18 | 199305 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 31 | 14 | 49 | 0 | 49 | 310 | 1 | 0 | 0 |
| 01 | 18 | 199304 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 90 | 15 | 35 | 0 | 35 | 300 | 1 | 0 | 0 |
| 01 | 18 | 199303 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 93 | 61 | 182 | 0 | 182 | 310 | 1 | 0 | 0 |
| 01 | 18 | 199302 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 84 | 65 | 121 | 0 | 121 | 280 | 1 | 0 | 0 |
| 01 | 18 | 199301 | 779240 | 6053 | 1 | R | Y | 0 | 0 | 1 | Y | 31 | 20 | 56 | 0 | 56 | 310 | 1 | 0 | 0 |
| 01 | 22 | 199312 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 186 | 30 | 263 | 0 | 263 | 930 | 1 | 0 | 0 |
| 01 | 22 | 199311 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 180 | 21 | 235 | 0 | 235 | 900 | 1 | 0 | 0 |
| 01 | 22 | 199310 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 186 | 27 | 214 | 0 | 214 | 930 | 1 | 0 | 0 |
| 01 | 22 | 199309 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 180 | 30 | 355 | 0 | 355 | 900 | 1 | 0 | 0 |
| 01 | 22 | 199308 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 186 | 1 | 325 | 0 | 325 | 930 | 1 | 0 | 0 |
| 01 | 22 | 199307 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 186 | 10 | 327 | 0 | 327 | 930 | 1 | 0 | 0 |
| 01 | 22 | 199306 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 180 | 25 | 317 | 0 | 317 | 900 | 1 | 0 | 0 |
| 01 | 22 | 199305 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 186 | 33 | 292 | 0 | 292 | 930 | 1 | 0 | 0 |
| 01 | 22 | 199304 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 180 | 31 | 262 | 0 | 262 | 900 | 1 | 0 | 0 |
| 01 | 22 | 199303 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 186 | 44 | 233 | 0 | 233 | 930 | 1 | 0 | 0 |
| 01 | 22 | 199302 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 168 | 41 | 365 | 0 | 365 | 840 | 1 | 0 | 0 |
| 01 | 22 | 199301 | 773400 | 6053 | 1 | R | Y | 0 | 0 | 3 | N | 186 | 39 | 327 | 0 | 327 | 930 | 1 | 0 | 0 |
| 01 | 26 | 199312 | 569260 | 6469 | 1 | R | Y | 0 | 1 | 0 | N | 62 | 25 | 181 | 0 | 181 | 3410 | 1 | 0 | 0 |
| 01 | 26 | 199311 | 569260 | 6469 | 1 | R | Y | 0 | 1 | 0 | N | 60 | 22 | 156 | 0 | 156 | 3300 | 1 | 0 | 0 |
| 01 | 26 | 199310 | 569260 | 6469 | 1 | R | Y | 0 | 1 | 0 | N | 62 | 28 | 134 | 0 | 134 | 3410 | 1 | 0 | 0 |
| 01 | 26 | 199309 | 569260 | 6469 | 1 | R | Y | 0 | 1 | 0 | N | 60 | 42 | 106 | 0 | 106 | 3300 | 1 | 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.
lease_no
int4
- Sampled
- 50K
- Distinct
- 4.2K
-
903812 -
569712 -
432112 -
17612 -
220412 -
126812 -
805712 -
886912 -
887312 -
866012 -
445212 -
546812
cycle_yyyymm
int4
- Sampled
- 50K
- Distinct
- 12
-
1993014.2K -
1993024.2K -
1993034.2K -
1993044.2K -
1993054.2K -
1993064.2K -
1993074.2K -
1993084.2K -
1993094.1K -
1993104.1K -
1993114.1K -
1993124.1K
operator_no
int4
- Sampled
- 50K
- Distinct
- 1.4K
-
5611331.1K -
160065969 -
652875733 -
761710638 -
849740510 -
200980456 -
213275420 -
72706414 -
631524396 -
340176384 -
216735372 -
627127363
field_no
int4
- Sampled
- 50K
- Distinct
- 388
-
699813.9K -
556793.7K -
799053.5K -
510933.3K -
300072.7K -
618582.3K -
845602.2K -
231911.7K -
885341.5K -
266201.4K -
799121K -
48380828
field_reservoir_no
int4
- Sampled
- 50K
- Distinct
- 80
-
127.6K -
5006.1K -
1253.8K -
3333.5K -
1001.8K -
6661.5K -
700600 -
750566 -
600529 -
200527 -
710420 -
250359
oil_type_field_code
varchar
- Sampled
- 50K
- Distinct
- 2
- Empty
- 0.0459
-
R47.7K -
I9
p1_filed
varchar
- Sampled
- 50K
- Distinct
- 2
- Empty
- 0.0453
-
Y40.3K -
07.4K
Take it away
Back to everything we know about Historical Ledger — Oil Lease Months