Preview Gas Well Status (26 Month G-10)

First 100 rows

Out of roughly 163.8K rows in texas.gas_well_status_g10. Version obs-621cffd841d1.

First 100 rows of `texas.gas_well_status_g10`, 23 columns wide
`record_id`	`district`	`rrc_id`	`test_date`	`daily_gas_mcf`	`daily_cond_bbl`	`daily_water_bbl`	`siwh_pressure`	`shut_in_code`	`gas_gravity`	`cond_gravity`	`gas_oil_ratio`	`flowing_pressure`	`bottom_hole_pressure`	`late_test_flag`	`correction_code`	`shut_in_date`	`commingle_code`	`operator_no`	`wh_pressure_test_date`	`effective_date`
GT	01	193	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	681493	null	Jan. 1, 2020
GT	01	199	Sept. 25, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	01	210	Sept. 25, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	01	222	Sept. 26, 2019	36	0.0	0	0	null	0.720	0.0	9999	35	0	null	null	null	null	130426	null	Jan. 1, 2020
GT	01	252	Nov. 4, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	130426	null	Jan. 1, 2020
GT	01	407	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	891175	null	Jan. 1, 2020
GT	01	408	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	891175	null	Jan. 1, 2020
GT	01	455	Oct. 3, 2019	11	0.0	0	900	null	0.780	0.0	9999	40	0	null	null	null	null	252058	null	Jan. 1, 2020
GT	06	15943	Oct. 16, 2019	100	1.0	2	100	null	0.610	55.0	100	25	100	null	null	null	null	090870	null	Jan. 1, 2020
GT	06	16848	Sept. 19, 2019	74	0.0	0	130	null	0.637	0.0	9999	80	0	null	null	null	null	020467	null	Jan. 1, 2020
GT	7C	18636	Sept. 2, 2019	172	1.0	1	0	null	0.780	45.0	172	80	0	null	null	null	null	884498	null	Jan. 1, 2020
GT	7C	18639	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	884498	null	Jan. 1, 2020
GT	7C	18640	Sept. 11, 2019	201	1.0	1	0	null	0.690	49.8	201	80	0	null	null	null	null	884498	null	Jan. 1, 2020
GT	7C	18641	Oct. 17, 2019	14	0.0	0	0	null	0.690	0.0	9999	250	0	null	null	null	null	884498	null	Jan. 1, 2020
GT	7C	18642	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	884498	null	Jan. 1, 2020
GT	7C	18643	Sept. 6, 2019	72	0.0	0	0	null	0.780	0.0	9999	50	0	null	null	null	null	884498	null	Jan. 1, 2020
GT	7C	18647	Sept. 4, 2019	425	0.0	0	120	null	0.779	0.0	0	120	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	7C	18648	Sept. 15, 2019	108	0.0	0	0	null	0.691	0.0	9999	41	0	null	null	null	null	806470	null	Jan. 1, 2020
GT	7C	18734	Nov. 5, 2019	50	0.0	0	1	null	0.800	0.0	9999	1	0	null	null	null	null	027200	null	Jan. 1, 2020
GT	7C	18804	Nov. 30, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	875310	null	Jan. 1, 2020
GT	7C	18961	Nov. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	450175	null	Jan. 1, 2020
GT	7C	18988	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	044365	null	Jan. 1, 2020
GT	7C	19005	Oct. 20, 2019	17	0.0	0	100	null	0.692	0.0	0	37	0	null	null	null	null	875310	null	Jan. 1, 2020
GT	7C	19111	Oct. 23, 2019	7	0.1	0	50	null	0.799	59.0	70	50	0	null	null	null	null	253404	null	Jan. 1, 2020
GT	7C	19113	Oct. 23, 2019	3	0.0	0	54	null	0.856	0.0	9999	54	0	null	null	null	null	253404	null	Jan. 1, 2020
GT	7C	19125	Nov. 25, 2019	18	0.0	1	90	null	0.740	0.0	9999	50	0	null	null	null	null	877921	null	Jan. 1, 2020
GT	7C	19127	Nov. 25, 2019	75	0.4	1	70	null	0.780	51.0	188	40	0	null	null	null	null	877921	null	Jan. 1, 2020
GT	7C	19199	Oct. 17, 2019	10	0.0	0	38	null	0.693	0.0	0	32	0	null	null	null	null	875310	null	Jan. 1, 2020
GT	7C	19224	Oct. 20, 2019	8	0.0	0	100	null	0.688	0.0	0	23	0	null	null	null	null	875310	null	Jan. 1, 2020
GT	7C	19236	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	730462	null	Jan. 1, 2020
GT	7C	19237	Oct. 26, 2019	1	0.0	0	0	null	0.691	0.0	0	15	0	null	null	null	null	730462	null	Jan. 1, 2020
GT	7C	19240	Oct. 23, 2019	1	0.0	0	100	null	0.675	0.0	0	26	0	null	null	null	null	875310	null	Jan. 1, 2020
GT	7C	19361	Nov. 20, 2019	22	0.0	0	250	null	0.728	0.0	9999	36	0	null	null	null	null	925440	null	Jan. 1, 2020
GT	08	19438	Oct. 8, 2019	1	0.0	0	102	null	0.699	0.0	9999	50	0	null	null	null	null	170480	null	Jan. 1, 2020
GT	08	19439	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	170480	null	Jan. 1, 2020
GT	08	20991	Oct. 10, 2019	195	0.0	0	625	null	0.750	0.0	0	1	0	null	null	null	null	630555	null	Jan. 1, 2020
GT	09	21228	Nov. 18, 2019	23	0.0	1	120	null	0.710	0.0	0	110	135	null	null	null	null	878925	null	Jan. 1, 2020
GT	09	21229	Nov. 18, 2019	25	0.0	0	140	null	0.720	0.0	9999	125	155	null	null	null	null	878925	null	Jan. 1, 2020
GT	09	21539	Oct. 14, 2019	25	0.0	0	45	null	0.830	0.0	9999	20	0	null	null	null	null	760218	null	Jan. 1, 2020
GT	09	21588	Oct. 2, 2019	5	0.0	2	100	null	0.610	0.0	9999	30	200	null	null	null	null	090870	null	Jan. 1, 2020
GT	10	21771	Sept. 13, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	073056	null	Jan. 1, 2020
GT	10	22135	Sept. 13, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	073056	null	Jan. 1, 2020
GT	10	22136	Sept. 13, 2019	45	0.0	0	72	null	0.626	0.0	0	48	0	null	null	null	null	073056	null	Jan. 1, 2020
GT	10	22185	Sept. 25, 2019	43	0.0	1	72	null	0.817	0.0	9999	24	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	22189	Sept. 25, 2019	61	0.0	1	82	null	0.743	0.0	9999	24	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	22190	Sept. 25, 2019	44	0.0	1	63	null	0.760	0.0	9999	24	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	22776	Oct. 25, 1990	87	0.0	0	600	null	0.609	0.0	0	150	513	null	null	null	null	875461	null	Jan. 1, 2020
GT	10	22779	Sept. 25, 2013	13	0.0	0	26	null	0.698	0.0	0	23	0	null	null	null	null	488260	null	Jan. 1, 2020
GT	10	22854	Sept. 15, 2015	26	0.0	0	123	null	0.655	0.0	0	120	0	null	null	null	null	488260	null	Jan. 1, 2020
GT	10	22983	Sept. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	488260	null	Jan. 1, 2020
GT	7C	22994	Oct. 29, 2019	9	0.0	0	0	null	0.690	0.0	9999	200	0	null	null	null	null	884498	null	Jan. 1, 2020
GT	10	28213	Sept. 6, 1991	98	0.0	0	786	null	0.630	0.0	0	397	959	null	null	null	null	182785	null	Jan. 1, 2020
GT	10	28218	Aug. 31, 2014	62	0.0	0	123	null	0.804	0.0	0	41	151	null	null	null	null	190317	null	Jan. 1, 2020
GT	10	28219	Oct. 2, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	879035	null	Jan. 1, 2020
GT	10	28221	Oct. 2, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	Oct. 1, 2019	null	879035	null	Jan. 1, 2020
GT	10	28223	Dec. 14, 2013	50	0.0	0	70	null	0.612	0.0	0	50	0	null	null	null	null	073056	null	Jan. 1, 2020
GT	10	28224	Oct. 14, 2019	16	0.0	0	135	null	0.070	0.0	0	28	0	null	null	null	null	620573	null	Jan. 1, 2020
GT	10	28226	Oct. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	875461	null	Jan. 1, 2020
GT	10	28227	Oct. 11, 2009	29	0.0	0	300	null	0.615	0.0	0	90	0	null	null	null	null	875461	null	Jan. 1, 2020
GT	10	28228	Nov. 29, 1990	100	0.0	0	165	null	0.710	0.0	0	65	638	null	null	null	null	140261	null	Jan. 1, 2020
GT	10	28232	Sept. 1, 2016	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	875461	null	Jan. 1, 2020
GT	10	28233	Oct. 15, 2002	48	0.0	0	153	null	0.696	0.0	0	63	0	null	null	null	null	875461	null	Jan. 1, 2020
GT	10	28235	Oct. 1, 2013	42	0.0	0	155	null	0.638	0.0	0	25	0	null	null	null	null	510414	null	Jan. 1, 2020
GT	10	28236	Nov. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	263701	null	Jan. 1, 2020
GT	10	28240	May 14, 2018	52	0.0	0	120	null	0.600	0.0	9999	80	0	null	null	null	null	676084	null	Jan. 1, 2020
GT	10	28241	Nov. 15, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28244	Nov. 16, 2008	61	0.1	0	129	null	0.706	61.0	610	66	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28245	Nov. 16, 2008	67	0.1	0	117	null	0.997	57.0	670	59	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28246	March 25, 2019	46	1.2	1	83	null	0.712	59.0	38	83	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28248	Nov. 6, 2008	39	0.1	0	139	null	0.723	61.0	390	79	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28249	Nov. 5, 2008	61	0.1	0	142	null	0.662	58.0	610	54	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28250	Nov. 15, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28251	Oct. 24, 2012	97	0.1	0	113	null	0.659	56.0	970	51	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28252	Nov. 6, 2008	72	0.1	0	104	null	0.667	59.0	720	54	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28253	Nov. 4, 1996	72	0.0	0	140	null	0.650	0.0	0	60	0	null	null	null	null	085851	null	Jan. 1, 2020
GT	10	28255	Nov. 15, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28258	Nov. 8, 2008	47	0.1	0	142	null	0.678	61.0	470	54	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28259	Nov. 22, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28261	June 3, 2012	80	0.1	0	209	null	0.670	61.0	800	47	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28262	Nov. 6, 2008	18	0.1	0	157	null	0.710	66.0	180	51	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28265	April 27, 2000	78	0.6	0	74	null	0.694	60.0	130	61	129	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28267	Nov. 21, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	945936	null	Jan. 1, 2020
GT	10	28273	June 16, 2011	100	0.0	1	116	null	0.630	0.0	0	11	0	null	null	null	null	263701	null	Jan. 1, 2020
GT	10	28275	Oct. 29, 2009	82	1.0	0	65	null	0.660	58.0	82	28	0	null	null	null	null	263701	null	Jan. 1, 2020
GT	10	28278	Oct. 1, 2002	82	0.0	0	135	null	0.674	0.0	0	60	0	null	null	null	null	263701	null	Jan. 1, 2020
GT	10	28279	Sept. 27, 2017	100	0.2	0	197	null	0.725	55.5	500	37	0	null	null	null	null	263701	null	Jan. 1, 2020
GT	10	28281	Oct. 1, 2002	100	1.0	1	95	null	0.670	52.4	100	37	0	null	null	null	null	263701	null	Jan. 1, 2020
GT	10	28282	Nov. 1, 2019	0	0.0	0	0	Y	0.000	0.0	0	0	0	null	null	null	null	263701	null	Jan. 1, 2020
GT	10	28284	Sept. 9, 2013	95	0.0	0	59	null	0.741	0.0	0	49	0	null	null	null	null	488260	null	Jan. 1, 2020
GT	10	28290	Sept. 17, 2013	57	0.0	0	79	null	0.687	0.0	0	77	0	null	null	null	null	488260	null	Jan. 1, 2020
GT	10	28291	Sept. 22, 2013	24	0.0	0	52	null	0.737	0.0	0	45	0	null	null	null	null	488260	null	Jan. 1, 2020
GT	10	28292	Sept. 9, 2013	48	0.0	0	61	null	0.769	0.0	0	50	0	null	null	null	null	488260	null	Jan. 1, 2020
GT	10	28293	Oct. 18, 2013	48	0.0	0	59	null	0.737	0.0	0	52	0	null	null	null	null	488260	null	Jan. 1, 2020
GT	10	28296	Nov. 26, 2007	51	0.0	0	158	null	0.720	0.0	0	74	0	null	null	null	null	085851	null	Jan. 1, 2020
GT	10	28299	Oct. 24, 2004	96	0.0	1	93	null	0.677	0.0	0	37	0	null	null	null	null	172232	null	Jan. 1, 2020
GT	10	28300	Sept. 16, 2010	58	0.0	0	116	null	0.671	0.0	0	40	0	null	null	null	null	172232	null	Jan. 1, 2020
GT	10	28301	Sept. 11, 2003	89	1.0	0	176	null	0.606	40.0	89	39	0	null	null	null	null	172232	null	Jan. 1, 2020
GT	10	28307	Oct. 31, 2003	36	0.0	0	140	null	0.656	0.0	0	29	0	null	null	null	null	172232	null	Jan. 1, 2020
GT	10	28308	Oct. 9, 2003	44	0.0	0	163	null	0.667	0.0	0	56	0	null	null	null	null	172232	null	Jan. 1, 2020
GT	10	28309	Oct. 24, 2004	86	0.0	1	124	null	0.627	0.0	0	28	0	null	null	null	null	172232	null	Jan. 1, 2020

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.

`rrc_id`

int4

Sampled: 50K
Distinct: 14.5K

167434 8
97616 8
133777 8
139333 8
157202 8
128497 8
141720 8
171075 7
169992 7
113460 7
165564 7
126687 7

`effective_date`

date

Sampled: 50K
Distinct: 136

Feb. 1, 2021 11.1K
Feb. 1, 2020 10.9K
Jan. 1, 2020 10K
Jan. 1, 2021 8.8K
March 1, 2021 1K
Jan. 2, 2020 863
March 1, 2020 674
Feb. 2, 2021 644
Feb. 22, 2021 502
March 2, 2021 497
March 2, 2020 452
Jan. 2, 2021 346

`district`

varchar

Sampled: 50K
Distinct: 4

04 22.2K
01 15.8K
02 7K
03 5K

`operator_no`

varchar

Sampled: 50K
Distinct: 303

072504 7.9K
073056 4K
220903 2.8K
020467 2.6K
027200 2.3K
061620 2.2K
090732 2K
189405 1.9K
246973 1.7K
170038 1.7K
148113 1.6K
147699 1.1K

`record_id`

varchar

Sampled: 50K
Distinct: 1

GT 50K

`test_date`

date

Sampled: 50K
Distinct: 700

Dec. 1, 2019 2.6K
Oct. 1, 2019 2.3K
March 1, 2020 1.3K
Sept. 1, 2019 1.2K
Feb. 1, 2020 840
Nov. 1, 2019 761
Nov. 30, 2019 655
Aug. 1, 2019 647
Jan. 1, 2020 572
March 24, 2020 474
Oct. 15, 2019 413
Sept. 2, 2019 386

`daily_gas_mcf`

int4

Sampled: 50K
Distinct: 2.7K

0 10.8K
1 851
5 702
10 681
2 657
3 619
4 582
6 566
15 525
20 510
8 510
12 504

`daily_cond_bbl`

numeric

Sampled: 50K
Distinct: 1.6K

0.0 30.4K
1.0 2.6K
0.1 2.6K
0.2 871
2.0 800
0.5 589
0.3 487
3.0 461
5.0 376
0.4 364
4.0 283
7.0 252

Take it away

Back to everything we know about Gas Well Status (26 Month G-10)