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 176K rows in
texas.pd_oil_lease.
Version obs-2017cd2abcad.
district | lease_no | oil_code | movable_balance | beginning_oil_status | beginning_csghd_status | oldest_eom_balance | undoc_packed_32 |
|---|---|---|---|---|---|---|---|
| 01 | 1 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 2 | O | 43 | 0 | 0 | 121 | 0 |
| 01 | 3 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 5 | O | 110 | 0 | 0 | 138 | 0 |
| 01 | 6 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 13 | O | 16 | 0 | 0 | 16 | 0 |
| 01 | 18 | O | 15 | 0 | 0 | 35 | 0 |
| 01 | 22 | O | -20 | 0 | 0 | 40 | 0 |
| 01 | 23 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 24 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 26 | O | 4 | 0 | 0 | 4 | 0 |
| 01 | 29 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 30 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 31 | O | 54 | 0 | 0 | 41 | 0 |
| 01 | 37 | O | -383 | 383 | 0 | 0 | 0 |
| 01 | 38 | O | 203 | 0 | 0 | 203 | 0 |
| 01 | 40 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 41 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 44 | O | 85 | 0 | 0 | 125 | 0 |
| 01 | 45 | O | 60 | 0 | 0 | 117 | 0 |
| 01 | 48 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 51 | O | 0 | 0 | 1 | 0 | 0 |
| 01 | 58 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 61 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 63 | O | 126 | 0 | 0 | 126 | 0 |
| 01 | 64 | O | 61 | 0 | 0 | 61 | 0 |
| 01 | 65 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 71 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 81 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 82 | O | 44 | 0 | 0 | 44 | 0 |
| 01 | 83 | O | 27 | 0 | 0 | 27 | 0 |
| 01 | 88 | O | 223 | 0 | 0 | 223 | 0 |
| 01 | 89 | O | 59 | 23 | 0 | 82 | 0 |
| 01 | 91 | O | 36 | 0 | 0 | 36 | 0 |
| 01 | 92 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 96 | O | 75 | 4 | 0 | 79 | 0 |
| 01 | 102 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 107 | O | 77 | 0 | 0 | 77 | 0 |
| 01 | 108 | O | 66 | 0 | 0 | 66 | 0 |
| 01 | 111 | O | 50 | 0 | 0 | 50 | 0 |
| 01 | 112 | O | 203 | 0 | 0 | 203 | 0 |
| 01 | 113 | O | 177 | 0 | 0 | 47 | 0 |
| 01 | 115 | O | 79 | 204 | 0 | 170 | 0 |
| 01 | 118 | O | 256 | 0 | 0 | 256 | 0 |
| 01 | 122 | O | 70 | 0 | 0 | 70 | 0 |
| 01 | 123 | O | 61 | 0 | 0 | 61 | 0 |
| 01 | 132 | O | 31 | 0 | 0 | 32 | 0 |
| 01 | 136 | O | 38 | 0 | 0 | 211 | 0 |
| 01 | 137 | O | 26 | 0 | 0 | 118 | 0 |
| 01 | 138 | O | 403 | 0 | 0 | 162 | 0 |
| 01 | 139 | O | 88 | 0 | 0 | 88 | 0 |
| 01 | 140 | O | 182 | 0 | 0 | 161 | 0 |
| 01 | 141 | O | 53 | 0 | 0 | 58 | 0 |
| 01 | 142 | O | 65 | 0 | 0 | 42 | 0 |
| 01 | 143 | O | 38 | 0 | 0 | 40 | 0 |
| 01 | 144 | O | 20 | 0 | 0 | 50 | 0 |
| 01 | 145 | O | 23 | 2 | 0 | 25 | 0 |
| 01 | 146 | O | 50 | 0 | 0 | 257 | 0 |
| 01 | 150 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 151 | O | 640 | 0 | 0 | 382 | 0 |
| 01 | 153 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 154 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 155 | O | 0 | 0 | 1 | 0 | 0 |
| 01 | 156 | O | 247 | 0 | 0 | 192 | 0 |
| 01 | 157 | O | 370 | 0 | 0 | 321 | 0 |
| 01 | 162 | O | 115 | 0 | 0 | 178 | 0 |
| 01 | 165 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 169 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 171 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 175 | O | 157 | 0 | 0 | 95 | 0 |
| 01 | 176 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 177 | O | 203 | 39 | 0 | 289 | 0 |
| 01 | 178 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 180 | O | 46 | 0 | 0 | 46 | 0 |
| 01 | 182 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 183 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 184 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 186 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 188 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 189 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 194 | O | 912 | 0 | 0 | 1129 | 0 |
| 01 | 196 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 294 | O | 180 | 0 | 0 | 180 | 0 |
| 01 | 295 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 296 | O | 34 | 0 | 0 | 155 | 0 |
| 01 | 298 | O | 102 | 0 | 0 | 38 | 0 |
| 01 | 299 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 300 | O | 104 | 0 | 0 | 208 | 0 |
| 01 | 301 | O | 13 | 0 | 0 | 53 | 0 |
| 01 | 302 | O | 157 | 0 | 0 | 96 | 0 |
| 01 | 304 | O | 126 | 0 | 0 | 112 | 0 |
| 01 | 305 | O | 0 | 0 | 7 | 0 | 0 |
| 01 | 307 | O | 193 | 2 | 0 | 195 | 0 |
| 01 | 311 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 314 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 316 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 328 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 329 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 331 | O | 0 | 0 | 0 | 0 | 0 |
| 01 | 332 | O | 0 | 0 | 0 | 0 | 0 |
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
16.4K
03
16.3K
02
8.1K
04
6.3K
05
2.6K
06
248
lease_noint4
1112
6
4508
5
1081
5
1126
5
3900
5
1090
5
1135
5
1175
5
1714
5
3704
5
176
5
1095
5
oil_codevarchar
O
50K
movable_balanceint4
0
29.9K
18
135
20
132
19
127
30
126
5
123
28
123
27
122
1
117
15
116
50
116
10
115
beginning_oil_statusint4
0
48.8K
1
76
2
68
5
28
6
28
4
23
8
23
10
22
3
22
7
19
20
17
11
14
beginning_csghd_statusint4
0
49.1K
1
245
2
31
3
18
4
11
6
10
5
10
8
10
17
9
7
9
12
5
16
5
oldest_eom_balanceint4
0
31.1K
20
161
18
125
28
124
10
124
25
124
15
123
23
120
30
119
14
118
21
114
27
113
undoc_packed_32int4
0
47.5K
32000
103
64000
54
36000
34
70400
20
48000
18
8000
17
40000
17
4000
17
520180
10
16000
9
28000
9
Back to everything we know about Statewide Production Data — Oil