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 90.7K rows in
texas.high_cost_gas.
Version obs-bce4e6ff267a.
oil_gas_code | district | lease_number | well_number | operator_number | docket_number | c107x_code | post_approval_date | approval_date | first_prod_date | spud_date | received_date | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GAS | 14 | 027587 | null | 663680 | 002834 | T | 00000000 | 20090710 | 20080601 | 20080322 | 20090630 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 235247 | 1 | 248855 | 010864 | T | 00000000 | 20080630 | 20080101 | 20071203 | 20080410 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 000000 | null | 842915 | 061880 | T | 00000000 | 20050620 | 20031101 | 20031005 | 20050428 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 130874 | null | 029340 | 120491 | T | 00000000 | 19920701 | 19890501 | 19890226 | 19920611 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131232 | null | 864424 | 120815 | T | 00000000 | 19891012 | 19890701 | 19890318 | 19890908 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131351 | null | 864424 | 120816 | T | 00000000 | 19891012 | 19890701 | 19890421 | 19890908 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131352 | null | 864424 | 120817 | T | 00000000 | 19891012 | 19890701 | 19890424 | 19890908 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131413 | null | 876645 | 120834 | T | 00000000 | 19900222 | 19890701 | 19890318 | 19900205 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131555 | null | 876645 | 120841 | T | 00000000 | 19900227 | 19890701 | 19890305 | 19900205 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131588 | null | 864424 | 120851 | T | 00000000 | 19900629 | 19890701 | 19890302 | 19890921 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131346 | null | 864424 | 120852 | T | 00000000 | 19900629 | 19890701 | 19890417 | 19890921 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131933 | null | 876645 | 120858 | T | 00000000 | 19900222 | 19890901 | 19890528 | 19900205 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131753 | null | 876645 | 120859 | T | 00000000 | 19900222 | 19890901 | 19890420 | 19900205 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 132249 | null | 864424 | 120898 | T | 00000000 | 19891129 | 19890801 | 19890507 | 19890908 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131668 | null | 864424 | 120939 | T | 00000000 | 19891012 | 19890801 | 19890608 | 19890908 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131587 | null | 864424 | 120941 | T | 00000000 | 19891012 | 19890801 | 19890527 | 19890908 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131211 | null | 864424 | 120942 | T | 00000000 | 19891012 | 19890701 | 19890327 | 19890908 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131405 | null | 016859 | 120982 | T | 00000000 | 19891012 | 19890801 | 19890309 | 19890823 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131407 | null | 016859 | 120983 | T | 00000000 | 19891012 | 19890801 | 19890407 | 19890823 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132211 | null | 931352 | 121039 | T | 00000000 | 19891205 | 19891001 | 19890722 | 19890830 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131406 | null | 016859 | 121048 | T | 00000000 | 19891012 | 19890801 | 19890321 | 19890901 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132221 | null | 876645 | 121061 | T | 00000000 | 19900222 | 19891001 | 19890529 | 19900205 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132214 | null | 876645 | 121062 | T | 00000000 | 19900222 | 19891001 | 19890708 | 19900205 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132034 | null | 876645 | 121063 | T | 00000000 | 19900222 | 19890901 | 19890517 | 19900205 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131557 | null | 876645 | 121064 | T | 00000000 | 19900228 | 19890801 | 19890407 | 19900205 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131723 | null | 016859 | 121067 | T | 00000000 | 19891019 | 19890901 | 19890504 | 19890907 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131584 | null | 864424 | 121072 | T | 00000000 | 19891110 | 19890801 | 19890524 | 19890921 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131662 | null | 253196 | 121084 | T | 00000000 | 19891130 | 19890901 | 19890629 | 19890915 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131435 | null | 253196 | 121085 | T | 00000000 | 19891121 | 19890701 | 19890519 | 19890915 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131670 | null | 253196 | 121086 | T | 00000000 | 19891121 | 19890801 | 19890612 | 19890915 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131589 | null | 253196 | 121087 | T | 00000000 | 19891101 | 19890701 | 19890517 | 19890915 | May 18, 2026, 1:30 a.m. |
| GAS | 05 | 132317 | null | 570655 | 121091 | T | 00000000 | 19900124 | 19891001 | 19890423 | 19891114 | May 18, 2026, 1:30 a.m. |
| GAS | 05 | 132316 | null | 570655 | 121093 | T | 00000000 | 19900216 | 19891001 | 19890701 | 19891114 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131869 | null | 018023 | 121094 | T | 00000000 | 19891026 | 19890801 | 19890627 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131554 | null | 652352 | 121098 | T | 00000000 | 19891012 | 19890801 | 19890427 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131629 | null | 652352 | 121099 | T | 00000000 | 19891012 | 19890801 | 19890406 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131652 | null | 652352 | 121100 | T | 00000000 | 19891012 | 19890901 | 19890409 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131415 | null | 652352 | 121101 | T | 00000000 | 19891012 | 19890701 | 19890326 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131552 | null | 652352 | 121102 | T | 00000000 | 19891012 | 19890801 | 19890316 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131331 | null | 652352 | 121103 | T | 00000000 | 19891012 | 19890701 | 19890217 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131416 | null | 652352 | 121104 | T | 00000000 | 19891012 | 19890801 | 19890210 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131631 | null | 652352 | 121105 | T | 00000000 | 19891012 | 19890801 | 19890507 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131553 | null | 652352 | 121106 | T | 00000000 | 19891012 | 19890801 | 19890503 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131438 | null | 652352 | 121107 | T | 00000000 | 19891012 | 19890801 | 19890129 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131579 | null | 884572 | 121109 | T | 00000000 | 19891229 | 19890801 | 19890522 | 19890918 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131641 | null | 864424 | 121119 | T | 00000000 | 19891025 | 19890901 | 19890606 | 19890921 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131726 | null | 018023 | 121124 | T | 00000000 | 19891026 | 19890901 | 19890705 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131501 | null | 018023 | 121125 | T | 00000000 | 19891026 | 19890801 | 19890619 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131220 | null | 864424 | 121128 | T | 00000000 | 19900612 | 19890701 | 19890302 | 19890921 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131410 | null | 018023 | 121130 | T | 00000000 | 19891026 | 19890801 | 19890606 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 132026 | null | 864424 | 121132 | T | 00000000 | 19891110 | 19891001 | 19890716 | 19890922 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 130981 | null | 864424 | 121134 | T | 00000000 | 19900620 | 19890701 | 19890221 | 19890927 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 132064 | 3 | 671860 | 121152 | T | 00000000 | 19900222 | 19890801 | 19890531 | 19890925 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131836 | null | 018023 | 121154 | T | 00000000 | 19891102 | 19890901 | 19890714 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131411 | null | 018023 | 121155 | T | 00000000 | 19891026 | 19890801 | 19890613 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131837 | null | 018023 | 121162 | T | 00000000 | 19891026 | 19890901 | 19890723 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132437 | null | 876645 | 121170 | T | 00000000 | 19900313 | 19891101 | 19890708 | 19890929 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132425 | null | 876645 | 121171 | T | 00000000 | 19900227 | 19890901 | 19890621 | 19890929 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132438 | null | 876645 | 121172 | T | 00000000 | 19900131 | 19891101 | 19890624 | 19890929 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132840 | null | 876645 | 121173 | T | 00000000 | 19900222 | 19891201 | 19890713 | 19890929 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132441 | null | 876645 | 121174 | T | 00000000 | 19901127 | 19891001 | 19890710 | 19890929 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 133322 | null | 876645 | 121175 | T | 00000000 | 19900309 | 19900101 | 19890725 | 19890929 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131961 | null | 864424 | 121176 | T | 00000000 | 19891026 | 19891001 | 19890708 | 19890929 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131333 | null | 253196 | 121183 | T | 00000000 | 19900628 | 19890701 | 19890416 | 19891016 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131195 | null | 253196 | 121184 | T | 00000000 | 19900628 | 19890701 | 19890503 | 19891016 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131677 | null | 253196 | 121186 | T | 00000000 | 19891120 | 19890801 | 19890601 | 19891016 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131877 | null | 253196 | 121187 | T | 00000000 | 19891103 | 19890901 | 19890714 | 19891003 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132783 | null | 931352 | 121193 | T | 00000000 | 19900213 | 19891101 | 19890829 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 132057 | null | 864424 | 121200 | T | 00000000 | 19891116 | 19891001 | 19890723 | 19891010 | May 18, 2026, 1:30 a.m. |
| GAS | 05 | 132538 | null | 570655 | 121212 | T | 00000000 | 19900103 | 19891101 | 19890825 | 19891116 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 132025 | null | 253196 | 121229 | T | 00000000 | 19900411 | 19891001 | 19890825 | 19891016 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132314 | null | 875230 | 121233 | T | 00000000 | 19900320 | 19891001 | 19890815 | 19891017 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131047 | null | 561132 | 121245 | T | 00000000 | 19900628 | 19890601 | 19890419 | 19891106 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131048 | null | 561132 | 121246 | T | 00000000 | 19900628 | 19890601 | 19890427 | 19891106 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131235 | null | 561132 | 121247 | T | 00000000 | 19900628 | 19890701 | 19890514 | 19891106 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131286 | null | 561132 | 121248 | T | 00000000 | 19900226 | 19890801 | 19890523 | 19891018 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131502 | null | 561132 | 121249 | T | 00000000 | 19900226 | 19890801 | 19890607 | 19891018 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131341 | null | 561132 | 121250 | T | 00000000 | 19900223 | 19890801 | 19890530 | 19891018 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131503 | null | 561132 | 121251 | T | 00000000 | 19900223 | 19890801 | 19890616 | 19891018 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 132062 | null | 018023 | 121252 | T | 00000000 | 19891116 | 19891001 | 19890806 | 19891018 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132000 | null | 480930 | 121259 | T | 00000000 | 19891216 | 19891001 | 19890421 | 19891020 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 132235 | null | 864424 | 121265 | T | 00000000 | 19891128 | 19891101 | 19890703 | 19891023 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131812 | null | 652352 | 121269 | T | 00000000 | 19891127 | 19890901 | 19890524 | 19891023 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132029 | null | 652352 | 121270 | T | 00000000 | 19891110 | 19891001 | 19890607 | 19891023 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131811 | null | 652352 | 121271 | T | 00000000 | 19891110 | 19890901 | 19890422 | 19891023 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131931 | null | 652352 | 121272 | T | 00000000 | 19891110 | 19890901 | 19890520 | 19891023 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 133077 | null | 016859 | 121295 | T | 00000000 | 19900227 | 19891001 | 19890821 | 19891027 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132780 | null | 016859 | 121296 | T | 00000000 | 19900206 | 19891101 | 19890829 | 19891027 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132032 | null | 652352 | 121310 | T | 00000000 | 19891120 | 19891001 | 19890529 | 19891030 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132031 | null | 652352 | 121311 | T | 00000000 | 19891120 | 19891001 | 19890422 | 19891030 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132030 | null | 652352 | 121312 | T | 00000000 | 19891120 | 19890901 | 19890531 | 19891030 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 131654 | null | 257097 | 121317 | T | 00000000 | 19891229 | 19890801 | 19890319 | 19891214 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 132188 | 6 | 018023 | 121318 | T | 00000000 | 19900314 | 19891001 | 19890729 | 19891101 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 132295 | null | 864424 | 121320 | T | 00000000 | 19891212 | 19891101 | 19890807 | 19891102 | May 18, 2026, 1:30 a.m. |
| GAS | 06 | 132429 | 4 | 636222 | 121321 | T | 00000000 | 19900313 | 19891101 | 19890818 | 19891102 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 132187 | 8 | 018023 | 121324 | T | 00000000 | 19891205 | 19891001 | 19890810 | 19891103 | May 18, 2026, 1:30 a.m. |
| GAS | 04 | 131962 | null | 864424 | 121325 | T | 00000000 | 19891227 | 19891001 | 19890704 | 19891106 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 131929 | null | 016859 | 121342 | T | 00000000 | 19891129 | 19891001 | 19890802 | 19891107 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 132008 | null | 016859 | 121343 | T | 00000000 | 19891129 | 19891001 | 19890823 | 19891107 | May 18, 2026, 1:30 a.m. |
| GAS | 09 | 132009 | null | 016859 | 121344 | T | 00000000 | 19891128 | 19891001 | 19890817 | 19891107 | May 18, 2026, 1:30 a.m. |
Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.
districtvarchar
06
10.5K
09
9.9K
04
9.8K
13
7.5K
05
4.3K
14
2.9K
03
1.7K
01
1.5K
10
1.1K
02
667
08
124
11
54
lease_numbervarchar
000000
352
171510
6
172811
5
176821
5
166625
5
156398
5
160884
5
168764
5
224025
4
143481
4
173039
4
154304
4
oil_gas_codevarchar
GAS
50K
well_numbervarchar
6
13
4
12
8
11
2
11
1
8
5
8
3
7
000000
5
9
3
15
3
7
3
0
2
operator_numbervarchar
216378
5K
147715
4.5K
253162
3.8K
222282
3K
385842
1.7K
020528
1.5K
109333
1.2K
253196
1.2K
020572
1.2K
172230
1.2K
020542
1.2K
216730
1.1K
docket_numbervarchar
148146
1
145098
1
160535
1
136526
1
125370
1
164666
1
162138
1
132634
1
168499
1
164232
1
138579
1
157417
1
c107x_codevarchar
T
48.5K
F
837
A
675
D
7
post_approval_datevarchar
00000000
50K