Preview High Cost Gas (Tight Sands Only)

First 100 rows

Out of roughly 90.7K rows in texas.high_cost_gas. Version obs-ea1c84c8fece.

First 100 rows of `texas.high_cost_gas`, 13 columns wide
`oil_gas_code`	`district`	`lease_number`	`well_number`	`operator_number`	`docket_number`	`c107x_code`	`approval_date`	`first_prod_date`	`spud_date`	`received_date`	`ingested_at`
GAS	14	027587	null	663680	002834	T	20090710	20080601	20080322	20090630	Sept. 14, 2026, 1:40 a.m.
GAS	06	235247	1	248855	010864	T	20080630	20080101	20071203	20080410	Sept. 14, 2026, 1:40 a.m.
GAS	04	000000	null	842915	061880	T	20050620	20031101	20031005	20050428	Sept. 14, 2026, 1:40 a.m.
GAS	06	130874	null	029340	120491	T	19920701	19890501	19890226	19920611	Sept. 14, 2026, 1:40 a.m.
GAS	04	131232	null	864424	120815	T	19891012	19890701	19890318	19890908	Sept. 14, 2026, 1:40 a.m.
GAS	04	131351	null	864424	120816	T	19891012	19890701	19890421	19890908	Sept. 14, 2026, 1:40 a.m.
GAS	04	131352	null	864424	120817	T	19891012	19890701	19890424	19890908	Sept. 14, 2026, 1:40 a.m.
GAS	06	131413	null	876645	120834	T	19900222	19890701	19890318	19900205	Sept. 14, 2026, 1:40 a.m.
GAS	06	131555	null	876645	120841	T	19900227	19890701	19890305	19900205	Sept. 14, 2026, 1:40 a.m.
GAS	04	131588	null	864424	120851	T	19900629	19890701	19890302	19890921	Sept. 14, 2026, 1:40 a.m.
GAS	04	131346	null	864424	120852	T	19900629	19890701	19890417	19890921	Sept. 14, 2026, 1:40 a.m.
GAS	06	131933	null	876645	120858	T	19900222	19890901	19890528	19900205	Sept. 14, 2026, 1:40 a.m.
GAS	06	131753	null	876645	120859	T	19900222	19890901	19890420	19900205	Sept. 14, 2026, 1:40 a.m.
GAS	04	132249	null	864424	120898	T	19891129	19890801	19890507	19890908	Sept. 14, 2026, 1:40 a.m.
GAS	04	131668	null	864424	120939	T	19891012	19890801	19890608	19890908	Sept. 14, 2026, 1:40 a.m.
GAS	04	131587	null	864424	120941	T	19891012	19890801	19890527	19890908	Sept. 14, 2026, 1:40 a.m.
GAS	04	131211	null	864424	120942	T	19891012	19890701	19890327	19890908	Sept. 14, 2026, 1:40 a.m.
GAS	09	131405	null	016859	120982	T	19891012	19890801	19890309	19890823	Sept. 14, 2026, 1:40 a.m.
GAS	09	131407	null	016859	120983	T	19891012	19890801	19890407	19890823	Sept. 14, 2026, 1:40 a.m.
GAS	06	132211	null	931352	121039	T	19891205	19891001	19890722	19890830	Sept. 14, 2026, 1:40 a.m.
GAS	09	131406	null	016859	121048	T	19891012	19890801	19890321	19890901	Sept. 14, 2026, 1:40 a.m.
GAS	06	132221	null	876645	121061	T	19900222	19891001	19890529	19900205	Sept. 14, 2026, 1:40 a.m.
GAS	06	132214	null	876645	121062	T	19900222	19891001	19890708	19900205	Sept. 14, 2026, 1:40 a.m.
GAS	06	132034	null	876645	121063	T	19900222	19890901	19890517	19900205	Sept. 14, 2026, 1:40 a.m.
GAS	06	131557	null	876645	121064	T	19900228	19890801	19890407	19900205	Sept. 14, 2026, 1:40 a.m.
GAS	09	131723	null	016859	121067	T	19891019	19890901	19890504	19890907	Sept. 14, 2026, 1:40 a.m.
GAS	04	131584	null	864424	121072	T	19891110	19890801	19890524	19890921	Sept. 14, 2026, 1:40 a.m.
GAS	04	131662	null	253196	121084	T	19891130	19890901	19890629	19890915	Sept. 14, 2026, 1:40 a.m.
GAS	04	131435	null	253196	121085	T	19891121	19890701	19890519	19890915	Sept. 14, 2026, 1:40 a.m.
GAS	04	131670	null	253196	121086	T	19891121	19890801	19890612	19890915	Sept. 14, 2026, 1:40 a.m.
GAS	04	131589	null	253196	121087	T	19891101	19890701	19890517	19890915	Sept. 14, 2026, 1:40 a.m.
GAS	05	132317	null	570655	121091	T	19900124	19891001	19890423	19891114	Sept. 14, 2026, 1:40 a.m.
GAS	05	132316	null	570655	121093	T	19900216	19891001	19890701	19891114	Sept. 14, 2026, 1:40 a.m.
GAS	09	131869	null	018023	121094	T	19891026	19890801	19890627	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	06	131554	null	652352	121098	T	19891012	19890801	19890427	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131629	null	652352	121099	T	19891012	19890801	19890406	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131652	null	652352	121100	T	19891012	19890901	19890409	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131415	null	652352	121101	T	19891012	19890701	19890326	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131552	null	652352	121102	T	19891012	19890801	19890316	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131331	null	652352	121103	T	19891012	19890701	19890217	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131416	null	652352	121104	T	19891012	19890801	19890210	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131631	null	652352	121105	T	19891012	19890801	19890507	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131553	null	652352	121106	T	19891012	19890801	19890503	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	06	131438	null	652352	121107	T	19891012	19890801	19890129	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	09	131579	null	884572	121109	T	19891229	19890801	19890522	19890918	Sept. 14, 2026, 1:40 a.m.
GAS	04	131641	null	864424	121119	T	19891025	19890901	19890606	19890921	Sept. 14, 2026, 1:40 a.m.
GAS	09	131726	null	018023	121124	T	19891026	19890901	19890705	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	09	131501	null	018023	121125	T	19891026	19890801	19890619	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	04	131220	null	864424	121128	T	19900612	19890701	19890302	19890921	Sept. 14, 2026, 1:40 a.m.
GAS	09	131410	null	018023	121130	T	19891026	19890801	19890606	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	04	132026	null	864424	121132	T	19891110	19891001	19890716	19890922	Sept. 14, 2026, 1:40 a.m.
GAS	04	130981	null	864424	121134	T	19900620	19890701	19890221	19890927	Sept. 14, 2026, 1:40 a.m.
GAS	09	132064	3	671860	121152	T	19900222	19890801	19890531	19890925	Sept. 14, 2026, 1:40 a.m.
GAS	09	131836	null	018023	121154	T	19891102	19890901	19890714	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	09	131411	null	018023	121155	T	19891026	19890801	19890613	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	09	131837	null	018023	121162	T	19891026	19890901	19890723	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	06	132437	null	876645	121170	T	19900313	19891101	19890708	19890929	Sept. 14, 2026, 1:40 a.m.
GAS	06	132425	null	876645	121171	T	19900227	19890901	19890621	19890929	Sept. 14, 2026, 1:40 a.m.
GAS	06	132438	null	876645	121172	T	19900131	19891101	19890624	19890929	Sept. 14, 2026, 1:40 a.m.
GAS	06	132840	null	876645	121173	T	19900222	19891201	19890713	19890929	Sept. 14, 2026, 1:40 a.m.
GAS	06	132441	null	876645	121174	T	19901127	19891001	19890710	19890929	Sept. 14, 2026, 1:40 a.m.
GAS	06	133322	null	876645	121175	T	19900309	19900101	19890725	19890929	Sept. 14, 2026, 1:40 a.m.
GAS	04	131961	null	864424	121176	T	19891026	19891001	19890708	19890929	Sept. 14, 2026, 1:40 a.m.
GAS	04	131333	null	253196	121183	T	19900628	19890701	19890416	19891016	Sept. 14, 2026, 1:40 a.m.
GAS	04	131195	null	253196	121184	T	19900628	19890701	19890503	19891016	Sept. 14, 2026, 1:40 a.m.
GAS	04	131677	null	253196	121186	T	19891120	19890801	19890601	19891016	Sept. 14, 2026, 1:40 a.m.
GAS	04	131877	null	253196	121187	T	19891103	19890901	19890714	19891003	Sept. 14, 2026, 1:40 a.m.
GAS	06	132783	null	931352	121193	T	19900213	19891101	19890829	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	04	132057	null	864424	121200	T	19891116	19891001	19890723	19891010	Sept. 14, 2026, 1:40 a.m.
GAS	05	132538	null	570655	121212	T	19900103	19891101	19890825	19891116	Sept. 14, 2026, 1:40 a.m.
GAS	04	132025	null	253196	121229	T	19900411	19891001	19890825	19891016	Sept. 14, 2026, 1:40 a.m.
GAS	06	132314	null	875230	121233	T	19900320	19891001	19890815	19891017	Sept. 14, 2026, 1:40 a.m.
GAS	09	131047	null	561132	121245	T	19900628	19890601	19890419	19891106	Sept. 14, 2026, 1:40 a.m.
GAS	09	131048	null	561132	121246	T	19900628	19890601	19890427	19891106	Sept. 14, 2026, 1:40 a.m.
GAS	09	131235	null	561132	121247	T	19900628	19890701	19890514	19891106	Sept. 14, 2026, 1:40 a.m.
GAS	09	131286	null	561132	121248	T	19900226	19890801	19890523	19891018	Sept. 14, 2026, 1:40 a.m.
GAS	09	131502	null	561132	121249	T	19900226	19890801	19890607	19891018	Sept. 14, 2026, 1:40 a.m.
GAS	09	131341	null	561132	121250	T	19900223	19890801	19890530	19891018	Sept. 14, 2026, 1:40 a.m.
GAS	09	131503	null	561132	121251	T	19900223	19890801	19890616	19891018	Sept. 14, 2026, 1:40 a.m.
GAS	09	132062	null	018023	121252	T	19891116	19891001	19890806	19891018	Sept. 14, 2026, 1:40 a.m.
GAS	06	132000	null	480930	121259	T	19891216	19891001	19890421	19891020	Sept. 14, 2026, 1:40 a.m.
GAS	04	132235	null	864424	121265	T	19891128	19891101	19890703	19891023	Sept. 14, 2026, 1:40 a.m.
GAS	06	131812	null	652352	121269	T	19891127	19890901	19890524	19891023	Sept. 14, 2026, 1:40 a.m.
GAS	06	132029	null	652352	121270	T	19891110	19891001	19890607	19891023	Sept. 14, 2026, 1:40 a.m.
GAS	06	131811	null	652352	121271	T	19891110	19890901	19890422	19891023	Sept. 14, 2026, 1:40 a.m.
GAS	06	131931	null	652352	121272	T	19891110	19890901	19890520	19891023	Sept. 14, 2026, 1:40 a.m.
GAS	06	133077	null	016859	121295	T	19900227	19891001	19890821	19891027	Sept. 14, 2026, 1:40 a.m.
GAS	06	132780	null	016859	121296	T	19900206	19891101	19890829	19891027	Sept. 14, 2026, 1:40 a.m.
GAS	06	132032	null	652352	121310	T	19891120	19891001	19890529	19891030	Sept. 14, 2026, 1:40 a.m.
GAS	06	132031	null	652352	121311	T	19891120	19891001	19890422	19891030	Sept. 14, 2026, 1:40 a.m.
GAS	06	132030	null	652352	121312	T	19891120	19890901	19890531	19891030	Sept. 14, 2026, 1:40 a.m.
GAS	06	131654	null	257097	121317	T	19891229	19890801	19890319	19891214	Sept. 14, 2026, 1:40 a.m.
GAS	09	132188	6	018023	121318	T	19900314	19891001	19890729	19891101	Sept. 14, 2026, 1:40 a.m.
GAS	04	132295	null	864424	121320	T	19891212	19891101	19890807	19891102	Sept. 14, 2026, 1:40 a.m.
GAS	06	132429	4	636222	121321	T	19900313	19891101	19890818	19891102	Sept. 14, 2026, 1:40 a.m.
GAS	09	132187	8	018023	121324	T	19891205	19891001	19890810	19891103	Sept. 14, 2026, 1:40 a.m.
GAS	04	131962	null	864424	121325	T	19891227	19891001	19890704	19891106	Sept. 14, 2026, 1:40 a.m.
GAS	09	131929	null	016859	121342	T	19891129	19891001	19890802	19891107	Sept. 14, 2026, 1:40 a.m.
GAS	09	132008	null	016859	121343	T	19891129	19891001	19890823	19891107	Sept. 14, 2026, 1:40 a.m.
GAS	09	132009	null	016859	121344	T	19891128	19891001	19890817	19891107	Sept. 14, 2026, 1:40 a.m.

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.

`district`

varchar

Sampled: 50K
Distinct: 12

06 10.5K
09 9.9K
04 9.8K
13 7.5K
05 4.3K
14 2.9K
03 1.6K
01 1.5K
10 1.1K
02 674
08 124
11 54

`lease_number`

varchar

Sampled: 50K
Distinct: 48K

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_code`

varchar

Sampled: 50K
Distinct: 1

GAS 50K

`well_number`

varchar

Sampled: 50K
Distinct: 69
Empty: 0.997

6 13
4 12
2 11
8 11
1 8
5 8
3 7
000000 5
9 3
15 3
7 3
050107 2

`operator_number`

varchar

Sampled: 50K
Distinct: 513

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_number`

varchar

Sampled: 50K
Distinct: 50K

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_code`

varchar

Sampled: 50K
Distinct: 4

T 48.5K
F 837
A 675
D 7

`post_approval_date`

varchar

Sampled: 50K
Distinct: 1

00000000 50K

Take it away

Back to everything we know about High Cost Gas (Tight Sands Only)