Preview: Gas Ledger — Well Months — Texas RRC data

First 100 rows

Out of roughly 2M rows in texas.gas_ledger_well_month. Version obs-84bb53514a20.

First 100 rows of `texas.gas_ledger_well_month`, 47 columns wide
`district`	`field_no`	`operator_no`	`gas_rrc_id`	`month_ordinal`	`cycle_yyyymm`	`bal_code`	`lack`	`old_operator_no`	`well_type_mo`	`al_code`	`word_allow`	`on_shut_list`	`no_lmt_allow_sw`	`acres`	`lmt_allow`	`highest_daily_prod_lmt`	`swr38_acres_code`
01	2001	36043	273598	1	202506	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	2	202507	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	3	202508	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	4	202509	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	5	202510	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	6	202511	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	7	202512	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	8	202601	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	9	202602	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	10	202603	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	11	202604	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	12	202605	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	13	202606	0	1	0	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	36043	273598	14	202607	0	1	36043	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	1	202506	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	2	202507	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	3	202508	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	4	202509	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	5	202510	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	6	202511	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	7	202512	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	8	202601	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	9	202602	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	10	202603	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	11	202604	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	12	202605	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	13	202606	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	61799	232716	14	202607	0	1	61799	K	K	14B DENY	null	1	0.000	null	null	null
01	2001	85408	272110	1	202506	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	2	202507	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	3	202508	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	4	202509	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	5	202510	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	6	202511	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	7	202512	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	8	202601	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	9	202602	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	10	202603	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	11	202604	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	12	202605	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	13	202606	8	0	68596	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	85408	272110	14	202607	8	0	85408	R	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	100104	299834	1	202506	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	2	202507	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	3	202508	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	4	202509	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	5	202510	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	6	202511	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	7	202512	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	8	202601	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	9	202602	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	10	202603	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	11	202604	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	12	202605	0	1	0	H	H	SHUT IN	null	1	0.000	null	null	null
01	2001	100104	299834	13	202606	0	1	0	K	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	100104	299834	14	202607	0	1	100104	K	K	14B2 EXT	null	1	0.000	null	null	null
01	2001	100351	229750	1	202506	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	2	202507	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	3	202508	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	4	202509	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	5	202510	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	6	202511	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	7	202512	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	8	202601	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	9	202602	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	10	202603	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	11	202604	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	12	202605	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	13	202606	0	1	797102	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	229750	14	202607	0	1	100351	K	K	PRTL PLG	null	1	0.000	null	null	null
01	2001	100351	264125	1	202506	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	2	202507	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	3	202508	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	4	202509	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	5	202510	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	6	202511	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	7	202512	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	8	202601	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	9	202602	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	10	202603	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	11	202604	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	12	202605	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	13	202606	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	264125	14	202607	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	1	202506	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	2	202507	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	3	202508	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	4	202509	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	5	202510	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	6	202511	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	7	202512	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	8	202601	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	9	202602	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	10	202603	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	11	202604	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	12	202605	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	13	202606	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	266690	14	202607	0	0	100351	(	(	SWR 10	null	1	0.000	null	null	null
01	2001	100351	271554	1	202506	0	0	797102	(	(	SWR 10	null	1	80.000	null	null	null
01	2001	100351	271554	2	202507	0	0	797102	(	(	SWR 10	null	1	80.000	null	null	null

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: 1

01 50K

`field_no`

int4

Sampled: 50K
Distinct: 46

12018200 38.4K
256500 7.7K
4300500 868
2396500 546
7856250 518
2001 364
621666 238
6262200 210
8072500 168
5438500 154
6457375 84
10440770 70

`operator_no`

int4

Sampled: 50K
Distinct: 77

100351 22.4K
101300 7K
102824 6.9K
103575 5.3K
424176 2K
499978 1.7K
103834 518
263696 406
103593 364
253162 364
945936 308
386310 252

`gas_rrc_id`

int4

Sampled: 50K
Distinct: 3.6K

268681 14
271520 14
270951 14
165572 14
270271 14
287279 14
271364 14
280039 14
271851 14
271401 14
296018 14
300427 14

`month_ordinal`

int2

Sampled: 50K
Distinct: 14

4 3.6K
3 3.6K
1 3.6K
5 3.6K
2 3.6K
6 3.6K
7 3.6K
8 3.6K
12 3.6K
14 3.6K
11 3.6K
13 3.6K

`cycle_yyyymm`

int4

Sampled: 50K
Distinct: 14

202511 3.6K
202508 3.6K
202509 3.6K
202506 3.6K
202507 3.6K
202510 3.6K
202512 3.6K
202602 3.6K
202603 3.6K
202606 3.6K
202604 3.6K
202601 3.6K

`name_change_code`

int2

Sampled: 50K
Distinct: 3

0 49.5K
2 448
6 38

`form_rec_code`

int2

Sampled: 50K
Distinct: 4

1 39.8K
0 9.6K
2 507
5 66

Take it away

Back to everything we know about Gas Ledger — Well Months