Preview PDQ County Production by Cycle

First 100 rows

Out of roughly 146.5K rows in texas.pdq_og_county_cycle. Version obs-c2bc9e0f5689.

First 100 rows of `texas.pdq_og_county_cycle`, 25 columns wide
`county_no`	`district_no`	`cycle_year`	`cycle_month`	`cycle_year_month`	`cnty_oil_prod_vol`	`cnty_oil_allow`	`cnty_oil_ending_bal`	`cnty_gas_allow`	`cnty_gas_lift_inj_vol`	`cnty_cond_limit`	`cnty_cond_ending_bal`	`cnty_csgd_prod_vol`	`cnty_csgd_limit`	`cnty_csgd_gas_lift`	`cnty_oil_tot_disp`	`cnty_gas_tot_disp`	`cnty_cond_tot_disp`	`cnty_csgd_tot_disp`	`county_name`	`district_name`	`oil_gas_code`	`ingested_at`
001	05	1993	01	199301	7355	null	null	null	null	null	null	6347	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	02	199302	6312	null	null	null	null	null	null	4919	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	03	199303	6222	null	null	null	null	null	null	4973	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	04	199304	6139	null	null	null	null	null	null	4410	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	05	199305	5785	null	null	null	null	null	null	5961	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	06	199306	4836	null	null	null	null	null	null	5585	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	07	199307	4779	null	null	null	null	null	null	6179	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	08	199308	4401	null	null	null	null	null	null	5019	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	09	199309	4547	null	null	null	null	null	null	5473	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	10	199310	4832	null	null	null	null	null	null	6050	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	11	199311	4370	null	null	null	null	null	null	6125	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1993	12	199312	4354	null	null	null	null	null	null	6510	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	01	199401	2740	null	null	null	null	null	null	4396	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	02	199402	2193	null	null	null	null	null	null	3928	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	03	199403	2326	null	null	null	null	null	null	3748	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	04	199404	2393	null	null	null	null	null	null	4092	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	05	199405	2334	null	null	null	null	null	null	3937	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	06	199406	2150	null	null	null	null	null	null	3793	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	07	199407	2519	null	null	null	null	null	null	3978	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	08	199408	1946	null	null	null	null	null	null	4112	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	09	199409	1994	null	null	null	null	null	null	4163	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	10	199410	2139	null	null	null	null	null	null	4228	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	11	199411	2104	null	null	null	null	null	null	4302	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1994	12	199412	1922	null	null	null	null	null	null	4498	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	01	199501	2104	null	null	null	null	null	null	5161	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	02	199502	2144	null	null	null	null	null	null	4798	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	03	199503	1920	null	null	null	null	null	null	5105	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	04	199504	2729	null	null	null	null	null	null	4941	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	05	199505	1490	null	null	null	null	null	null	3752	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	06	199506	1914	null	null	null	null	null	null	4348	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	07	199507	1518	null	null	null	null	null	null	5227	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	08	199508	1933	null	null	null	null	null	null	5417	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	09	199509	1503	null	null	null	null	null	null	5392	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	10	199510	1541	null	null	null	null	null	null	4761	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	11	199511	840	null	null	null	null	null	null	2466	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1995	12	199512	1082	null	null	null	null	null	null	2965	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	01	199601	892	null	null	null	null	null	null	2413	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	02	199602	765	null	null	null	null	null	null	2721	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	03	199603	757	null	null	null	null	null	null	2838	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	04	199604	924	null	null	null	null	null	null	3070	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	05	199605	820	null	null	null	null	null	null	2932	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	06	199606	657	null	null	null	null	null	null	2905	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	07	199607	844	null	null	null	null	null	null	2950	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	08	199608	685	null	null	null	null	null	null	2532	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	09	199609	691	null	null	null	null	null	null	1735	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	10	199610	787	null	null	null	null	null	null	2436	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	11	199611	727	null	null	null	null	null	null	2025	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1996	12	199612	744	null	null	null	null	null	null	1897	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	01	199701	1257	null	null	null	null	null	null	3291	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	02	199702	1221	null	null	null	null	null	null	3061	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	03	199703	1242	null	null	null	null	null	null	2597	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	04	199704	1169	null	null	null	null	null	null	2273	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	05	199705	1076	null	null	null	null	null	null	2238	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	06	199706	1540	null	null	null	null	null	null	2783	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	07	199707	1488	null	null	null	null	null	null	2952	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	08	199708	1532	null	null	null	null	null	null	3007	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	09	199709	1433	null	null	null	null	null	null	2685	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	10	199710	1170	null	null	null	null	null	null	2240	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	11	199711	1255	null	null	null	null	null	null	2114	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1997	12	199712	1297	null	null	null	null	null	null	1913	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	01	199801	1040	null	null	null	null	null	null	1426	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	02	199802	731	null	null	null	null	null	null	1474	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	03	199803	417	null	null	null	null	null	null	1360	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	04	199804	672	null	null	null	null	null	null	1254	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	05	199805	887	null	null	null	null	null	null	1671	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	06	199806	623	null	null	null	null	null	null	1346	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	07	199807	661	null	null	null	null	null	null	1609	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	08	199808	732	null	null	null	null	null	null	1692	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	09	199809	654	null	null	null	null	null	null	1023	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	10	199810	691	null	null	null	null	null	null	1051	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	11	199811	657	null	null	null	null	null	null	724	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1998	12	199812	584	null	null	null	null	null	null	536	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	01	199901	769	null	null	null	null	null	null	1230	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	02	199902	582	null	null	null	null	null	null	1106	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	03	199903	864	null	null	null	null	null	null	814	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	04	199904	734	null	null	null	null	null	null	642	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	05	199905	759	null	null	null	null	null	null	638	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	06	199906	1015	null	null	null	null	null	null	963	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	07	199907	1038	null	null	null	null	null	null	724	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	08	199908	1237	null	null	null	null	null	null	810	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	09	199909	1262	null	null	null	null	null	null	710	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	10	199910	933	null	null	null	null	null	null	446	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	11	199911	912	null	null	null	null	null	null	251	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	1999	12	199912	1213	null	null	null	null	null	null	58	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	01	200001	2193	null	null	null	null	null	null	1016	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	02	200002	1762	null	null	null	null	null	null	1016	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	03	200003	1953	null	null	null	null	null	null	1173	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	04	200004	1818	null	null	null	null	null	null	1247	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	05	200005	2331	null	null	null	null	null	null	1572	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	06	200006	1534	null	null	null	null	null	null	1180	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	07	200007	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	08	200008	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	09	200009	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	10	200010	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	11	200011	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2000	12	200012	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	O	Sept. 6, 2026, 11:14 p.m.
001	05	2001	01	200101	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	G	Sept. 6, 2026, 11:14 p.m.
001	05	2001	02	200102	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	G	Sept. 6, 2026, 11:14 p.m.
001	05	2001	03	200103	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	G	Sept. 6, 2026, 11:14 p.m.
001	05	2001	04	200104	0	null	null	null	null	null	null	0	null	null	null	null	null	null	ANDERSON	05	G	Sept. 6, 2026, 11:14 p.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.

`county_no`

varchar

Sampled: 50K
Distinct: 92

081 1.2K
105 1.2K
051 962
149 959
001 894
009 821
161 813
057 812
003 811
183 810
165 810
101 810

`cycle_year_month`

varchar

Sampled: 50K
Distinct: 405

201510 137
201505 137
201506 137
201508 137
201509 137
201507 137
201406 136
201410 136
201408 136
201501 136
201511 136
201502 136

`district_no`

varchar

Sampled: 50K
Distinct: 13

01 6.3K
03 5.5K
13 5.5K
08 4.9K
10 4.7K
11 4.5K
06 3.6K
14 3.5K
05 3.5K
02 3K
09 2.5K
04 2K

`oil_gas_code`

varchar

Sampled: 50K
Distinct: 2

G 37.5K
O 12.5K

`cycle_year`

varchar

Sampled: 50K
Distinct: 13

2004 4.2K
2003 4.2K
1997 4.1K
2002 4.1K
1996 4.1K
1999 4.1K
1998 4.1K
1995 4.1K
2001 4.1K
2000 4.1K
1993 4K
1994 4K

`cycle_month`

varchar

Sampled: 50K
Distinct: 12

02 4.4K
01 4.4K
03 4.3K
11 4.1K
10 4.1K
08 4.1K
09 4.1K
12 4.1K
07 4.1K
06 4.1K
05 4.1K
04 4.1K

`cnty_oil_prod_vol`

int8

Sampled: 50K
Distinct: 6.8K

0 40.4K
1 59
2 29
10 28
6 27
5 23
12 21
4 21
11 20
24 18
8 16
16 16

`cnty_oil_allow`

int8

Sampled: 50K
Distinct: 0
Empty: 1.0

Take it away

Back to everything we know about PDQ County Production by Cycle