Preview Statewide Gas Well Database

First 100 rows

Out of roughly 139K rows in texas.wl_gas_well. Version obs-8d19039f7bda.

First 100 rows of `texas.wl_gas_well`, 23 columns wide
`wlroot_key`	`on_off_sched_ind`	`oil_gas_code`	`district_no`	`gas_rrc_id`	`well_no`	`removed_date`	`prob_prevent_allow_flag`	`last_utilized_date`	`exc_to_svy_test_flag`	`reclassed_well_key`	`survey_eff_yyyymm`	`subject_14b2_flag`	`uic_violation_flag`	`legal_violation_flag`	`ext_state_plug_flag`	`cert_hb1975_flag`	`cert_effective_yyyymm`	`cert_letter_date`	`shut_in_yyyymm`	`pend_removal_14b2_flag`
306005	N	G	1	2	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
306108	N	G	1	17	5	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306110	N	G	1	20	8	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306111	N	G	1	21	9	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306112	N	G	1	22	10	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306114	N	G	1	24	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306115	N	G	1	25	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306116	N	G	1	26	2	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202410	0
306117	N	G	1	27	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202412	0
306118	N	G	1	29	3	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306122	N	G	1	33	2	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201901	0
306123	N	G	1	34	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306127	N	G	1	38	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306135	N	G	1	46	4	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306137	N	G	1	48	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201812	0
306138	N	G	1	49	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202410	0
306139	N	G	1	50	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306140	N	G	1	51	2	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306144	N	G	1	55	2	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306146	N	G	1	57	4	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306149	N	G	1	60	7	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306150	N	G	1	61	8	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306245	N	G	1	81	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
306266	N	G	1	87	3	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
306269	N	G	1	91	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
306280	N	G	1	99	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
306594	N	G	1	124	R 1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306595	N	G	1	125	X 1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306597	N	G	1	127	R 17	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306589	N	G	1	128	3	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	0
306590	N	G	1	129	5	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201703	N
306591	N	G	1	130	6	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201301	Y
306619	N	G	1	132	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	0
306620	N	G	1	133	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201710	N
306692	N	G	1	159	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	0
306739	N	G	1	174	1	null	N	null	N	null	202701	N	N	N	N	0	null	null	202512	0
306837	N	G	1	187	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
306842	N	G	1	193	1	null	N	null	N	null	202701	Y	N	N	N	0	null	null	201602	0
306848	N	G	1	199	1	null	N	null	N	null	202701	Y	N	N	N	0	null	null	201801	N
306851	N	G	1	205	1	null	N	null	N	null	202701	Y	N	N	N	0	null	null	202204	0
306852	N	G	1	206	1	null	N	null	N	null	202701	Y	N	N	N	0	null	null	202108	0
306853	N	G	1	207	1	null	N	null	N	null	202701	N	N	N	N	0	null	null	null	0
306854	N	G	1	208	1	null	N	null	N	null	202701	Y	N	N	N	0	null	null	202408	0
306856	N	G	1	210	1	null	N	null	N	null	202701	Y	N	N	N	0	null	null	199801	null
306857	N	G	1	213	4	null	N	null	N	null	202701	N	N	N	N	0	null	null	null	0
306858	N	G	1	214	5	null	N	null	N	null	202701	N	N	N	N	0	null	null	null	N
306882	N	G	1	222	1 U	null	N	null	N	null	202701	N	N	N	N	0	null	null	null	0
306927	N	G	1	252	1 L	null	N	null	N	null	202701	N	N	N	N	0	null	null	201606	0
307017	N	G	1	267	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
307158	N	G	1	329	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
307162	N	G	1	330	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
307167	N	G	1	332	3	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
307292	N	G	1	347	6	null	N	null	N	null	202701	Y	N	N	N	0	null	null	201909	0
307854	N	G	1	376	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202602	0
307513	N	G	1	384	2	null	N	null	N	null	201701	Y	N	N	N	N	null	null	199801	null
307549	N	G	1	406	1 C	null	N	null	N	null	null	N	N	N	N	0	null	null	null	N
307550	N	G	1	407	2 F	null	N	null	N	null	202701	Y	N	N	N	0	null	null	200305	0
307551	N	G	1	408	1	null	N	null	N	null	202701	Y	N	N	N	0	null	null	201011	0
307553	N	G	1	412	4 C	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
307557	N	G	1	420	4 T	null	N	null	N	null	201701	N	N	N	N	0	null	null	199801	null
307619	N	G	1	437	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	null
307625	N	G	1	438	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
307620	N	G	1	439	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	null
307621	N	G	1	440	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201504	Y
307622	N	G	1	442	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
307624	N	G	1	445	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
307725	N	G	1	480	1	null	N	null	N	null	202701	N	N	N	N	0	null	null	202606	0
307726	N	G	1	481	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202407	Y
307727	N	G	1	482	2	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202407	Y
307728	N	G	1	483	4	null	N	null	N	null	202701	Y	N	N	N	0	null	null	202408	Y
307730	N	G	1	487	1	null	N	null	N	null	202701	N	N	N	N	0	null	null	null	N
307731	N	G	1	488	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202009	0
307813	N	G	1	497	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	0
307814	N	G	1	498	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202004	0
307805	N	G	1	499	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202004	0
307806	N	G	1	500	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	0
307815	N	G	1	501	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
307816	N	G	1	502	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	0
307811	N	G	1	505	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202603	0
307823	N	G	1	507	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	199801	null
307846	N	G	1	517	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	N
306599	N	G	1	30574	5 L	null	N	null	N	null	201701	N	N	N	N	0	null	null	199801	N
306582	N	G	1	30575	5 U	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	N
306155	N	G	1	30769	7	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306158	N	G	1	30772	12	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202502	N
306159	N	G	1	30776	5	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202411	0
306161	N	G	1	31152	2	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306162	N	G	1	33699	11	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
306163	N	G	1	33700	1	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201811	0
306572	N	G	1	34408	6	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0
307320	N	G	1	35242	1 U	null	N	null	N	null	201701	N	N	N	N	0	null	null	199801	N
306696	N	G	1	39498	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	0
306039	N	G	1	39933	14	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202409	0
307627	N	G	1	40834	2 F	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201809	Y
306040	N	G	1	40835	15	null	N	null	N	null	201701	Y	N	N	N	0	null	null	200704	0
307613	N	G	1	43377	1	null	N	null	N	null	null	N	N	N	N	0	null	null	null	0
306697	N	G	1	43436	2	null	N	null	N	null	201701	N	N	N	N	0	null	null	null	0
306041	N	G	1	43741	18	null	N	null	N	null	201701	Y	N	N	N	0	null	null	202409	N
306698	N	G	1	43951	6	null	N	null	N	null	201701	Y	N	N	N	0	null	null	201409	Y
306791	N	G	1	44414	1	null	N	null	N	null	201701	N	N	N	N	0	null	null	202606	0

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.

`wlroot_key`

int4

Sampled: 50K
Distinct: 50K

490024 1
352579 1
329217 1
309842 1
469034 1
329035 1
487685 1
425198 1
313953 1
471863 1
439741 1
366067 1

`district_no`

int2

Sampled: 50K
Distinct: 6

4 17.9K
1 10K
5 7.7K
2 7.2K
3 5.7K
6 1.5K

`gas_rrc_id`

int4

Sampled: 50K
Distinct: 50K

256120 1
233316 1
257211 1
296863 1
183089 1
210699 1
155703 1
297073 1
73152 1
44342 1
292890 1
158829 1

`well_no`

varchar

Sampled: 50K
Distinct: 5.3K

1 7.6K
2 3.7K
3 2.5K
4 1.9K
1H 1.5K
5 1.5K
6 1.2K
7 1K
8 888
9 799
2H 770
10 663

`reclassed_well_key`

int4

Sampled: 50K
Distinct: 2.9K
Empty: 0.9424

699310 1
660266 1
788689 1
771081 1
654509 1
491670 1
773403 1
634388 1
600372 1
695182 1
735784 1
694988 1

`oil_gas_code`

varchar

Sampled: 50K
Distinct: 1

G 50K

`on_off_sched_ind`

varchar

Sampled: 50K
Distinct: 1

N 50K

`removed_reason`

varchar

Sampled: 50K
Distinct: 5

00 50K
06 12
01 6
07 2
08 2

Take it away

Back to everything we know about Statewide Gas Well Database