A live sample straight out of our copy of the data. Nothing here is edited: this is exactly what an export gives you.
Out of roughly 158.6K rows in
texas.hist_oil_lease.
Version obs-8a73ce197a99.
district | lease_no | og_code | movable_balance | beginning_oil_status | beginning_csghd_status | oil_oldest_eom_balance |
|---|---|---|---|---|---|---|
| 01 | 1 | O | 0 | 0 | 0 | 0 |
| 01 | 2 | O | 121 | 0 | 0 | 82 |
| 01 | 3 | O | 54 | 0 | 0 | 51 |
| 01 | 5 | O | 112 | 0 | 0 | 84 |
| 01 | 6 | O | 57 | 0 | 0 | 57 |
| 01 | 13 | O | 57 | 0 | 0 | 51 |
| 01 | 18 | O | 79 | 0 | 0 | 36 |
| 01 | 22 | O | 18 | 0 | 0 | 288 |
| 01 | 26 | O | 109 | 0 | 0 | 156 |
| 01 | 29 | O | 0 | 0 | 0 | 44 |
| 01 | 30 | O | 117 | 0 | 0 | 117 |
| 01 | 31 | O | 100 | 0 | 0 | 62 |
| 01 | 37 | O | 53 | 0 | 0 | 60 |
| 01 | 38 | O | 187 | 0 | 0 | 68 |
| 01 | 40 | O | 287 | 0 | 0 | 149 |
| 01 | 41 | O | 170 | 0 | 0 | 86 |
| 01 | 44 | O | 196 | 0 | 0 | 55 |
| 01 | 45 | O | 106 | 0 | 0 | 0 |
| 01 | 51 | O | 170 | 0 | 0 | 170 |
| 01 | 58 | O | 157 | 0 | 0 | 87 |
| 01 | 61 | O | 0 | 0 | 0 | 22 |
| 01 | 63 | O | 36 | 0 | 0 | 52 |
| 01 | 64 | O | 48 | 0 | 0 | 19 |
| 01 | 65 | O | 63 | 0 | 0 | 109 |
| 01 | 71 | O | 0 | 0 | 0 | 90 |
| 01 | 82 | O | 64 | 3 | 0 | 82 |
| 01 | 83 | O | 57 | 0 | 0 | 76 |
| 01 | 88 | O | 0 | 0 | 0 | 47 |
| 01 | 89 | O | 25 | 0 | 0 | 51 |
| 01 | 91 | O | 183 | 0 | 0 | 130 |
| 01 | 96 | O | 62 | 0 | 0 | 120 |
| 01 | 102 | O | 50 | 0 | 0 | 43 |
| 01 | 107 | O | 98 | 0 | 0 | 68 |
| 01 | 108 | O | 163 | 0 | 0 | 119 |
| 01 | 111 | O | 17 | 0 | 0 | 0 |
| 01 | 112 | O | 203 | 0 | 0 | 203 |
| 01 | 113 | O | 20 | 0 | 0 | 47 |
| 01 | 115 | O | 588 | 0 | 0 | 129 |
| 01 | 118 | O | 408 | 0 | 0 | 46 |
| 01 | 122 | O | 53 | 0 | 0 | 64 |
| 01 | 123 | O | 116 | 0 | 0 | 81 |
| 01 | 132 | O | 84 | 0 | 0 | 99 |
| 01 | 136 | O | 59 | 0 | 0 | 59 |
| 01 | 137 | O | 104 | 0 | 0 | 104 |
| 01 | 138 | O | 159 | 0 | 0 | 154 |
| 01 | 139 | O | 305 | 0 | 0 | 120 |
| 01 | 140 | O | 142 | 0 | 0 | 226 |
| 01 | 141 | O | 139 | 0 | 0 | 149 |
| 01 | 142 | O | 203 | 0 | 0 | 116 |
| 01 | 143 | O | 183 | 0 | 0 | 108 |
| 01 | 144 | O | 160 | 0 | 0 | 28 |
| 01 | 145 | O | 54 | 0 | 0 | 49 |
| 01 | 146 | O | 6 | 0 | 0 | 149 |
| 01 | 150 | O | 155 | 0 | 0 | 154 |
| 01 | 151 | O | -131 | 0 | 0 | 232 |
| 01 | 154 | O | 0 | 0 | 0 | 140 |
| 01 | 155 | O | 0 | 0 | 0 | 164 |
| 01 | 156 | O | 123 | 0 | 0 | 55 |
| 01 | 157 | O | 160 | 0 | 0 | 83 |
| 01 | 162 | O | 198 | 0 | 0 | 100 |
| 01 | 175 | O | 120 | 0 | 0 | 230 |
| 01 | 176 | O | 31 | 0 | 0 | 31 |
| 01 | 177 | O | 664 | 0 | 0 | 246 |
| 01 | 178 | O | 0 | 0 | 0 | 205 |
| 01 | 180 | O | 175 | 0 | 0 | 229 |
| 01 | 182 | O | 0 | 0 | 0 | 38 |
| 01 | 183 | O | 0 | 0 | 0 | 254 |
| 01 | 184 | O | 0 | 0 | 0 | 71 |
| 01 | 186 | O | 0 | 0 | 0 | 0 |
| 01 | 188 | O | 0 | 0 | 0 | 0 |
| 01 | 189 | O | 0 | 0 | 0 | 155 |
| 01 | 194 | O | 59 | 0 | 0 | 239 |
| 01 | 196 | O | 0 | 0 | 0 | 0 |
| 01 | 294 | O | 38 | 0 | 0 | 125 |
| 01 | 295 | O | -905 | 905 | 0 | 67 |
| 01 | 296 | O | 97 | 0 | 0 | 162 |
| 01 | 298 | O | 133 | 0 | 0 | 175 |
| 01 | 299 | O | 0 | 0 | 0 | 0 |
| 01 | 300 | O | 142 | 0 | 0 | 170 |
| 01 | 301 | O | 49 | 0 | 0 | 66 |
| 01 | 302 | O | 118 | 0 | 0 | 9 |
| 01 | 304 | O | 132 | 0 | 0 | 139 |
| 01 | 307 | O | 198 | 0 | 0 | 122 |
| 01 | 311 | O | 21 | 0 | 0 | 26 |
| 01 | 314 | O | 0 | 0 | 0 | 0 |
| 01 | 316 | O | 0 | 0 | 0 | 0 |
| 01 | 328 | O | 0 | 0 | 0 | 0 |
| 01 | 331 | O | 40 | 0 | 0 | 40 |
| 01 | 332 | O | -1834 | 0 | 0 | 279 |
| 01 | 333 | O | 0 | 0 | 0 | 0 |
| 01 | 334 | O | 365 | 0 | 0 | 63 |
| 01 | 335 | O | 342 | 0 | 0 | 342 |
| 01 | 336 | O | 0 | 0 | 0 | 0 |
| 01 | 337 | O | 0 | 0 | 0 | 77 |
| 01 | 340 | O | 0 | 0 | 0 | 0 |
| 01 | 343 | O | 733 | 0 | 0 | 679 |
| 01 | 357 | O | 0 | 0 | 0 | 0 |
| 01 | 358 | O | -19 | 0 | 0 | 0 |
| 01 | 364 | O | 60 | 0 | 0 | 132 |
| 01 | 367 | O | 185 | 0 | 0 | 78 |
Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.
districtvarchar
01
15K
03
14.8K
02
7.3K
04
5.3K
06
5.2K
05
2.3K
lease_noint4
3284
6
1112
6
1090
6
4103
6
3867
6
3199
6
1714
6
12760
5
11090
5
11115
5
12773
5
12350
5
og_codevarchar
O
50K
movable_balanceint4
0
17.5K
20
198
27
182
60
165
28
161
35
161
30
160
50
154
45
153
26
150
70
149
52
146
beginning_oil_statusint4
0
49.4K
1
60
2
55
3
48
5
7
6
7
22
7
26
6
14
6
7
6
4
6
10
6
beginning_csghd_statusint4
0
49.6K
1
149
2
44
3
16
5
7
4
6
6
5
9
4
10
3
12
3
11
3
7
3
oil_oldest_eom_balanceint4
0
30.3K
27
123
40
119
50
118
18
117
19
114
77
112
30
106
28
106
47
104
37
103
60
103
Back to everything we know about Historical Ledger — Statewide Oil