Preview: Historical Ledger — Gas Well Months

First 100 rows

Out of roughly 42.9M rows in texas.hist_gas_well_cycle. Version obs-6aeac850cd02.

First 100 rows of `texas.hist_gas_well_cycle`, 40 columns wide
`district`	`gas_rrc_id`	`cycle_yyyymm`	`operator_no`	`field_no`	`field_reservoir_no`	`field_type`	`type_field_code`	`balancing_field_flag`	`balancing_rule_code`	`well_no`	`wlroot_key`	`p2_filed`	`word_allowable`	`allowable`	`allowable_code`	`top_sched_allowable`	`revised_allow_code`	`commingled`	`production`	`monthly_status`	`rein_underage_date`	`cancel_underage_flag`	`cumulative_overage`	`undoc_packed_145`	`undoc_packed_150`
01	2	199312	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199311	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199310	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199309	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199308	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199307	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199306	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199305	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199304	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199303	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199302	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	2	199301	342800	2568	1	N	EX	null	null	1	306005	null	14B2 EXT	0	K	0	null	N	0	0	null	N	0	null	null
01	11	199302	880285	6096	500	N	ON	null	null	1	306057	Y	null	0	A	0	00	N	0	0	null	N	0	null	null
01	11	199301	880285	6096	500	N	ON	null	null	1	306057	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	13	199312	16859	7856	250	N	PR	Y	B	1	306106	Y	null	1116	N	3100	00	N	1027	-89	null	N	999999999	null	null
01	13	199311	16859	7856	250	N	PR	Y	B	1	306106	Y	null	1140	N	3000	00	N	1062	-78	null	N	999999999	null	null
01	13	199310	16859	7856	250	N	PR	Y	B	1	306106	Y	null	1116	N	3100	00	N	1104	-12	null	N	999999999	null	null
01	13	199309	16859	7856	250	N	PR	Y	B	1	306106	Y	null	1084	N	3000	00	N	1084	0	null	N	999999999	null	null
01	13	199308	16859	7856	250	N	PR	Y	B	1	306106	Y	null	1234	N	3100	00	N	1234	0	null	N	999999999	null	null
01	13	199307	16859	7856	250	N	PR	Y	B	1	306106	Y	null	1106	N	3100	00	N	1106	0	null	N	999999999	null	null
01	13	199306	16859	7856	250	N	PR	Y	B	1	306106	Y	null	1020	N	3000	00	N	782	-238	null	N	999999999	null	null
01	13	199305	16859	7856	250	N	CA	null	null	1	306106	Y	null	1117	N	3100	00	N	1117	0	null	N	999999999	null	null
01	13	199304	16859	7856	250	N	CA	null	null	1	306106	Y	null	1080	N	3000	00	N	1037	-43	null	N	999999999	null	null
01	13	199303	16859	7856	250	N	CA	null	null	1	306106	Y	null	1147	N	3100	00	N	1064	-83	null	N	999999999	null	null
01	13	199302	16859	7856	250	N	CA	null	null	1	306106	Y	null	1008	N	2800	00	N	995	-13	null	N	999999999	null	null
01	13	199301	16859	7856	250	N	CA	null	null	1	306106	Y	null	1126	N	3100	00	N	1126	0	null	N	999999999	null	null
01	14	199312	16859	7856	250	N	PR	Y	B	1	306107	Y	null	961	N	3100	00	N	947	-14	null	N	999999999	null	null
01	14	199311	16859	7856	250	N	PR	Y	B	1	306107	Y	null	936	N	3000	00	N	936	0	null	N	999999999	null	null
01	14	199310	16859	7856	250	N	PR	Y	B	1	306107	Y	null	992	N	3100	00	N	964	-28	null	N	999999999	null	null
01	14	199309	16859	7856	250	N	PR	Y	B	1	306107	Y	null	917	N	3000	00	N	917	0	null	N	999999999	null	null
01	14	199308	16859	7856	250	N	PR	Y	B	1	306107	Y	null	992	N	3100	00	N	972	-20	null	N	999999999	null	null
01	14	199307	16859	7856	250	N	PR	Y	B	1	306107	Y	null	1023	N	3100	00	N	991	-32	null	N	999999999	null	null
01	14	199306	16859	7856	250	N	PR	Y	B	1	306107	Y	null	990	N	3000	00	N	869	-121	null	N	999999999	null	null
01	14	199305	16859	7856	250	N	CA	null	null	1	306107	Y	null	1023	N	3100	00	N	1000	-23	null	N	999999999	null	null
01	14	199304	16859	7856	250	N	CA	null	null	1	306107	Y	null	1020	N	3000	00	N	992	-28	null	N	999999999	null	null
01	14	199303	16859	7856	250	N	CA	null	null	1	306107	Y	null	1054	N	3100	00	N	1027	-27	null	N	999999999	null	null
01	14	199302	16859	7856	250	N	CA	null	null	1	306107	Y	null	1008	N	2800	00	N	934	-74	null	N	999999999	null	null
01	14	199301	16859	7856	250	N	CA	null	null	1	306107	Y	null	1209	N	3100	00	N	1047	-162	null	N	999999999	null	null
01	17	199312	16859	7856	250	N	PR	Y	B	5	306108	Y	null	1147	N	3100	00	N	1032	-115	null	N	999999999	null	null
01	17	199311	16859	7856	250	N	PR	Y	B	5	306108	Y	null	1110	N	3000	00	N	1053	-57	null	N	999999999	null	null
01	17	199310	16859	7856	250	N	PR	Y	B	5	306108	Y	null	1116	N	3100	00	N	947	-169	null	N	999999999	null	null
01	17	199309	16859	7856	250	N	PR	Y	B	5	306108	Y	null	1100	N	3000	00	N	1100	0	null	N	999999999	null	null
01	17	199308	16859	7856	250	N	PR	Y	B	5	306108	Y	null	1138	N	3100	00	N	1138	0	null	N	999999999	null	null
01	17	199307	16859	7856	250	N	PR	Y	B	5	306108	Y	null	1126	N	3100	00	N	1126	0	null	N	999999999	null	null
01	17	199306	16859	7856	250	N	PR	Y	B	5	306108	Y	null	1093	N	3000	00	N	1093	0	null	N	999999999	null	null
01	17	199305	16859	7856	250	N	CA	null	null	5	306108	Y	null	1113	N	3100	00	N	1113	0	null	N	999999999	null	null
01	17	199304	16859	7856	250	N	CA	null	null	5	306108	Y	null	1057	N	3000	00	N	1057	0	null	N	999999999	null	null
01	17	199303	16859	7856	250	N	CA	null	null	5	306108	Y	null	1069	N	3100	00	N	1069	0	null	N	999999999	null	null
01	17	199302	16859	7856	250	N	CA	null	null	5	306108	Y	null	1036	N	2800	00	N	975	-61	null	N	999999999	null	null
01	17	199301	16859	7856	250	N	CA	null	null	5	306108	Y	null	1178	N	3100	00	N	1044	-134	null	N	999999999	null	null
01	19	199312	16859	7856	250	N	PR	Y	B	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199311	16859	7856	250	N	PR	Y	B	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199310	16859	7856	250	N	PR	Y	B	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199309	16859	7856	250	N	PR	Y	B	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199308	16859	7856	250	N	PR	Y	B	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199307	16859	7856	250	N	PR	Y	B	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199306	16859	7856	250	N	PR	Y	B	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199305	16859	7856	250	N	CA	null	null	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199304	16859	7856	250	N	CA	null	null	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199303	16859	7856	250	N	CA	null	null	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199302	16859	7856	250	N	CA	null	null	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	19	199301	16859	7856	250	N	CA	null	null	7	306109	Y	14B2 EXT	0	K	0	00	N	0	0	null	N	0	null	null
01	20	199312	16859	7856	250	N	PR	Y	B	8	306110	Y	null	1240	N	3100	00	N	1079	-161	null	N	999999999	null	null
01	20	199311	16859	7856	250	N	PR	Y	B	8	306110	Y	null	1200	N	3000	00	N	1075	-125	null	N	999999999	null	null
01	20	199310	16859	7856	250	N	PR	Y	B	8	306110	Y	null	1271	N	3100	00	N	1168	-103	null	N	999999999	null	null
01	20	199309	16859	7856	250	N	PR	Y	B	8	306110	Y	null	1192	N	3000	00	N	1192	0	null	N	999999999	null	null
01	20	199308	16859	7856	250	N	PR	Y	B	8	306110	Y	null	1302	N	3100	00	N	1230	-72	null	N	999999999	null	null
01	20	199307	16859	7856	250	N	PR	Y	B	8	306110	Y	null	1271	N	3100	00	N	1266	-5	null	N	999999999	null	null
01	20	199306	16859	7856	250	N	PR	Y	B	8	306110	Y	null	1290	N	3000	00	N	1086	-204	null	N	999999999	null	null
01	20	199305	16859	7856	250	N	CA	null	null	8	306110	Y	null	1333	N	3100	00	N	1306	-27	null	N	999999999	null	null
01	20	199304	16859	7856	250	N	CA	null	null	8	306110	Y	null	1260	N	3000	00	N	1242	-18	null	N	999999999	null	null
01	20	199303	16859	7856	250	N	CA	null	null	8	306110	Y	null	1395	N	3100	00	N	1332	-63	null	N	999999999	null	null
01	20	199302	16859	7856	250	N	CA	null	null	8	306110	Y	null	1344	N	2800	00	N	1194	-150	null	N	999999999	null	null
01	20	199301	16859	7856	250	N	CA	null	null	8	306110	Y	null	1581	N	3100	00	N	1296	-285	null	N	999999999	null	null
01	21	199312	16859	7856	250	N	PR	Y	B	9	306111	Y	null	775	N	3100	00	N	713	-62	null	N	999999999	null	null
01	21	199311	16859	7856	250	N	PR	Y	B	9	306111	Y	null	717	N	3000	00	N	717	0	null	N	999999999	null	null
01	21	199310	16859	7856	250	N	PR	Y	B	9	306111	Y	null	751	N	3100	00	N	751	0	null	N	999999999	null	null
01	21	199309	16859	7856	250	N	PR	Y	B	9	306111	Y	null	742	N	3000	00	N	742	0	null	N	999999999	null	null
01	21	199308	16859	7856	250	N	PR	Y	B	9	306111	Y	null	727	N	3100	00	N	727	0	null	N	999999999	null	null
01	21	199307	16859	7856	250	N	PR	Y	B	9	306111	Y	null	680	N	3100	00	N	680	0	null	N	999999999	null	null
01	21	199306	16859	7856	250	N	PR	Y	B	9	306111	Y	null	605	N	3000	00	N	605	0	null	N	999999999	null	null
01	21	199305	16859	7856	250	N	CA	null	null	9	306111	Y	null	619	N	3100	00	N	619	0	null	N	999999999	null	null
01	21	199304	16859	7856	250	N	CA	null	null	9	306111	Y	null	600	N	3000	00	N	587	-13	null	N	999999999	null	null
01	21	199303	16859	7856	250	N	CA	null	null	9	306111	Y	null	620	N	3100	00	N	581	-39	null	N	999999999	null	null
01	21	199302	16859	7856	250	N	CA	null	null	9	306111	Y	null	588	N	2800	00	N	526	-62	null	N	999999999	null	null
01	21	199301	16859	7856	250	N	CA	null	null	9	306111	Y	null	620	N	3100	00	N	605	-15	null	N	999999999	null	null
01	22	199312	16859	7856	250	N	PR	Y	B	10	306112	Y	null	709	N	3100	00	N	709	0	null	N	999999999	null	null
01	22	199311	16859	7856	250	N	PR	Y	B	10	306112	Y	null	690	N	3000	00	N	690	0	null	N	999999999	null	null
01	22	199310	16859	7856	250	N	PR	Y	B	10	306112	Y	null	714	N	3100	00	N	714	0	null	N	999999999	null	null
01	22	199309	16859	7856	250	N	PR	Y	B	10	306112	Y	null	696	N	3000	00	N	696	0	null	N	999999999	null	null
01	22	199308	16859	7856	250	N	PR	Y	B	10	306112	Y	null	734	N	3100	00	N	734	0	null	N	999999999	null	null
01	22	199307	16859	7856	250	N	PR	Y	B	10	306112	Y	null	728	N	3100	00	N	728	0	null	N	999999999	null	null
01	22	199306	16859	7856	250	N	PR	Y	B	10	306112	Y	null	683	N	3000	00	N	683	0	null	N	999999999	null	null
01	22	199305	16859	7856	250	N	CA	null	null	10	306112	Y	null	766	N	3100	00	N	766	0	null	N	999999999	null	null
01	22	199304	16859	7856	250	N	CA	null	null	10	306112	Y	null	741	N	3000	00	N	741	0	null	N	999999999	null	null
01	22	199303	16859	7856	250	N	CA	null	null	10	306112	Y	null	794	N	3100	00	N	794	0	null	N	999999999	null	null
01	22	199302	16859	7856	250	N	CA	null	null	10	306112	Y	null	720	N	2800	00	N	720	0	null	N	999999999	null	null
01	22	199301	16859	7856	250	N	CA	null	null	10	306112	Y	null	793	N	3100	00	N	793	0	null	N	999999999	null	null
01	23	199312	16859	7856	250	N	PR	Y	B	1	306113	Y	null	682	N	3100	00	N	617	-65	null	N	999999999	null	null
01	23	199311	16859	7856	250	N	PR	Y	B	1	306113	Y	null	660	N	3000	00	N	617	-43	null	N	999999999	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: 2

01 25.6K
02 24.4K

`gas_rrc_id`

int4

Sampled: 50K
Distinct: 4.3K

84198 12
52542 12
69215 12
92846 12
61608 12
53735 12
67528 12
60493 12
2773 12
86908 12
1006 12
129976 12

`cycle_yyyymm`

int4

Sampled: 50K
Distinct: 12

199301 4.2K
199302 4.2K
199303 4.2K
199304 4.2K
199305 4.2K
199306 4.2K
199307 4.2K
199308 4.2K
199309 4.1K
199310 4.1K
199311 4.1K
199312 4.1K

`operator_no`

int4

Sampled: 50K
Distinct: 866

932465 1.3K
652352 1.3K
685610 1.3K
457700 1K
875431 936
16859 918
253229 848
257097 848
833850 824
91093 723
828329 668
833347 639

`field_no`

int4

Sampled: 50K
Distinct: 760

16340 2.4K
30379 1.3K
51512 1.2K
36867 1.2K
256 1.2K
98075 1.1K
7856 876
40957 859
59371 666
90534 568
77755 558
33889 550

`wlroot_key`

int4

Sampled: 50K
Distinct: 4.3K

0 128
306380 12
306048 12
312908 12
311014 12
306714 12
309903 12
313221 12
310847 12
310506 12
309544 12
309842 12

`field_reservoir_no`

int4

Sampled: 50K
Distinct: 422

500 11K
250 1.9K
200 1.8K
1 1.7K
600 1.6K
300 1.5K
666 1.4K
333 1.4K
400 1.1K
750 1K
900 996
100 801

`field_type`

varchar

Sampled: 50K
Distinct: 2

N 38.6K
A 11.4K

Take it away

Back to everything we know about Historical Ledger — Gas Well Months