Preview PDQ Field Production by Cycle

First 100 rows

Out of roughly 10.2M rows in texas.pdq_og_field_cycle. Version obs-48a78733477f.

First 100 rows of `texas.pdq_og_field_cycle`, 12 columns wide
`district_no`	`field_no`	`cycle_year`	`cycle_month`	`cycle_year_month`	`district_name`	`field_name`	`field_gas_prod_vol`	`field_cond_prod_vol`	`ingested_at`
14	28506760	1996	05	199605	10	ELLIS RANCH (MORROW,UPPER, W.)	9992	20	Sept. 6, 2026, 11:11 p.m.
14	28506760	1996	06	199606	10	ELLIS RANCH (MORROW,UPPER, W.)	9333	9	Sept. 6, 2026, 11:11 p.m.
14	28506760	1996	07	199607	10	ELLIS RANCH (MORROW,UPPER, W.)	8420	10	Sept. 6, 2026, 11:11 p.m.
14	28506760	1996	08	199608	10	ELLIS RANCH (MORROW,UPPER, W.)	7938	15	Sept. 6, 2026, 11:11 p.m.
14	28506760	1996	09	199609	10	ELLIS RANCH (MORROW,UPPER, W.)	5979	319	Sept. 6, 2026, 11:11 p.m.
14	28506760	1996	10	199610	10	ELLIS RANCH (MORROW,UPPER, W.)	9404	91	Sept. 6, 2026, 11:11 p.m.
14	28506760	1996	11	199611	10	ELLIS RANCH (MORROW,UPPER, W.)	7107	5	Sept. 6, 2026, 11:11 p.m.
14	28506760	1996	12	199612	10	ELLIS RANCH (MORROW,UPPER, W.)	7929	2	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	01	199701	10	ELLIS RANCH (MORROW,UPPER, W.)	8073	3	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	02	199702	10	ELLIS RANCH (MORROW,UPPER, W.)	6835	24	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	03	199703	10	ELLIS RANCH (MORROW,UPPER, W.)	7829	12	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	04	199704	10	ELLIS RANCH (MORROW,UPPER, W.)	5415	14	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	05	199705	10	ELLIS RANCH (MORROW,UPPER, W.)	5848	4	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	06	199706	10	ELLIS RANCH (MORROW,UPPER, W.)	4654	15	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	07	199707	10	ELLIS RANCH (MORROW,UPPER, W.)	6256	8	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	08	199708	10	ELLIS RANCH (MORROW,UPPER, W.)	4178	3	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	09	199709	10	ELLIS RANCH (MORROW,UPPER, W.)	4684	2	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	10	199710	10	ELLIS RANCH (MORROW,UPPER, W.)	5920	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	11	199711	10	ELLIS RANCH (MORROW,UPPER, W.)	5893	1	Sept. 6, 2026, 11:11 p.m.
14	28506760	1997	12	199712	10	ELLIS RANCH (MORROW,UPPER, W.)	4194	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	01	199801	10	ELLIS RANCH (MORROW,UPPER, W.)	5359	3	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	02	199802	10	ELLIS RANCH (MORROW,UPPER, W.)	5212	19	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	03	199803	10	ELLIS RANCH (MORROW,UPPER, W.)	4413	5	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	04	199804	10	ELLIS RANCH (MORROW,UPPER, W.)	4847	6	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	05	199805	10	ELLIS RANCH (MORROW,UPPER, W.)	5262	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	06	199806	10	ELLIS RANCH (MORROW,UPPER, W.)	3593	13	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	07	199807	10	ELLIS RANCH (MORROW,UPPER, W.)	3239	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	08	199808	10	ELLIS RANCH (MORROW,UPPER, W.)	4746	90	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	09	199809	10	ELLIS RANCH (MORROW,UPPER, W.)	3332	47	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	10	199810	10	ELLIS RANCH (MORROW,UPPER, W.)	5027	8	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	11	199811	10	ELLIS RANCH (MORROW,UPPER, W.)	3936	36	Sept. 6, 2026, 11:11 p.m.
14	28506760	1998	12	199812	10	ELLIS RANCH (MORROW,UPPER, W.)	3353	20	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	01	199901	10	ELLIS RANCH (MORROW,UPPER, W.)	4831	14	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	02	199902	10	ELLIS RANCH (MORROW,UPPER, W.)	4604	6	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	03	199903	10	ELLIS RANCH (MORROW,UPPER, W.)	4396	8	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	04	199904	10	ELLIS RANCH (MORROW,UPPER, W.)	4471	3	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	05	199905	10	ELLIS RANCH (MORROW,UPPER, W.)	4522	1	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	06	199906	10	ELLIS RANCH (MORROW,UPPER, W.)	4441	3	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	07	199907	10	ELLIS RANCH (MORROW,UPPER, W.)	4615	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	08	199908	10	ELLIS RANCH (MORROW,UPPER, W.)	3964	2	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	09	199909	10	ELLIS RANCH (MORROW,UPPER, W.)	2859	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	10	199910	10	ELLIS RANCH (MORROW,UPPER, W.)	2504	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	11	199911	10	ELLIS RANCH (MORROW,UPPER, W.)	4004	30	Sept. 6, 2026, 11:11 p.m.
14	28506760	1999	12	199912	10	ELLIS RANCH (MORROW,UPPER, W.)	3740	13	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	01	200001	10	ELLIS RANCH (MORROW,UPPER, W.)	2590	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	02	200002	10	ELLIS RANCH (MORROW,UPPER, W.)	2301	7	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	03	200003	10	ELLIS RANCH (MORROW,UPPER, W.)	4069	23	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	04	200004	10	ELLIS RANCH (MORROW,UPPER, W.)	2218	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	05	200005	10	ELLIS RANCH (MORROW,UPPER, W.)	1860	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	06	200006	10	ELLIS RANCH (MORROW,UPPER, W.)	5472	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	07	200007	10	ELLIS RANCH (MORROW,UPPER, W.)	5847	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	08	200008	10	ELLIS RANCH (MORROW,UPPER, W.)	10303	7	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	09	200009	10	ELLIS RANCH (MORROW,UPPER, W.)	6780	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	10	200010	10	ELLIS RANCH (MORROW,UPPER, W.)	6513	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	11	200011	10	ELLIS RANCH (MORROW,UPPER, W.)	4747	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2000	12	200012	10	ELLIS RANCH (MORROW,UPPER, W.)	7640	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	01	200101	10	ELLIS RANCH (MORROW,UPPER, W.)	6223	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	02	200102	10	ELLIS RANCH (MORROW,UPPER, W.)	5116	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	03	200103	10	ELLIS RANCH (MORROW,UPPER, W.)	4095	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	04	200104	10	ELLIS RANCH (MORROW,UPPER, W.)	3525	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	05	200105	10	ELLIS RANCH (MORROW,UPPER, W.)	3647	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	06	200106	10	ELLIS RANCH (MORROW,UPPER, W.)	3187	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	07	200107	10	ELLIS RANCH (MORROW,UPPER, W.)	4200	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	08	200108	10	ELLIS RANCH (MORROW,UPPER, W.)	3758	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	09	200109	10	ELLIS RANCH (MORROW,UPPER, W.)	3416	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	10	200110	10	ELLIS RANCH (MORROW,UPPER, W.)	3658	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	11	200111	10	ELLIS RANCH (MORROW,UPPER, W.)	3296	4	Sept. 6, 2026, 11:11 p.m.
14	28506760	2001	12	200112	10	ELLIS RANCH (MORROW,UPPER, W.)	3177	11	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	01	200201	10	ELLIS RANCH (MORROW,UPPER, W.)	2449	25	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	02	200202	10	ELLIS RANCH (MORROW,UPPER, W.)	3001	16	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	03	200203	10	ELLIS RANCH (MORROW,UPPER, W.)	3120	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	04	200204	10	ELLIS RANCH (MORROW,UPPER, W.)	3178	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	05	200205	10	ELLIS RANCH (MORROW,UPPER, W.)	3002	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	06	200206	10	ELLIS RANCH (MORROW,UPPER, W.)	2943	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	07	200207	10	ELLIS RANCH (MORROW,UPPER, W.)	2929	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	08	200208	10	ELLIS RANCH (MORROW,UPPER, W.)	2895	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	09	200209	10	ELLIS RANCH (MORROW,UPPER, W.)	2808	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	10	200210	10	ELLIS RANCH (MORROW,UPPER, W.)	2511	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	11	200211	10	ELLIS RANCH (MORROW,UPPER, W.)	1855	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2002	12	200212	10	ELLIS RANCH (MORROW,UPPER, W.)	2505	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	01	200301	10	ELLIS RANCH (MORROW,UPPER, W.)	2577	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	02	200302	10	ELLIS RANCH (MORROW,UPPER, W.)	1666	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	03	200303	10	ELLIS RANCH (MORROW,UPPER, W.)	1835	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	04	200304	10	ELLIS RANCH (MORROW,UPPER, W.)	1676	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	05	200305	10	ELLIS RANCH (MORROW,UPPER, W.)	1810	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	06	200306	10	ELLIS RANCH (MORROW,UPPER, W.)	1629	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	07	200307	10	ELLIS RANCH (MORROW,UPPER, W.)	1779	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	08	200308	10	ELLIS RANCH (MORROW,UPPER, W.)	3095	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	09	200309	10	ELLIS RANCH (MORROW,UPPER, W.)	2549	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	10	200310	10	ELLIS RANCH (MORROW,UPPER, W.)	2292	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	11	200311	10	ELLIS RANCH (MORROW,UPPER, W.)	1802	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2003	12	200312	10	ELLIS RANCH (MORROW,UPPER, W.)	2179	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2004	01	200401	10	ELLIS RANCH (MORROW,UPPER, W.)	2244	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2004	02	200402	10	ELLIS RANCH (MORROW,UPPER, W.)	1788	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2004	03	200403	10	ELLIS RANCH (MORROW,UPPER, W.)	2111	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2004	04	200404	10	ELLIS RANCH (MORROW,UPPER, W.)	1907	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2004	05	200405	10	ELLIS RANCH (MORROW,UPPER, W.)	1923	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2004	06	200406	10	ELLIS RANCH (MORROW,UPPER, W.)	2019	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2004	07	200407	10	ELLIS RANCH (MORROW,UPPER, W.)	2065	0	Sept. 6, 2026, 11:11 p.m.
14	28506760	2004	08	200408	10	ELLIS RANCH (MORROW,UPPER, W.)	2025	0	Sept. 6, 2026, 11:11 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.

`district_no`

varchar

Sampled: 50K
Distinct: 1

01 50K

`field_no`

varchar

Sampled: 50K
Distinct: 185

00000000 1K
00292841 405
00285300 405
00293125 405
00293625 405
00296500 405
00220060 405
00395500 405
00292203 405
00292957 405
00236500 405
00014001 405

`cycle_year_month`

varchar

Sampled: 50K
Distinct: 405

200710 134
200709 134
200708 134
200711 133
200707 133
200801 133
200706 133
200712 133
200703 132
200705 132
200612 132
200704 132

`cycle_year`

varchar

Sampled: 50K
Distinct: 34

2008 1.6K
2002 1.6K
2001 1.6K
2007 1.6K
1999 1.6K
2000 1.6K
2006 1.6K
2003 1.6K
1993 1.6K
1998 1.6K
2009 1.6K
2010 1.6K

`cycle_month`

varchar

Sampled: 50K
Distinct: 12

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

`district_name`

varchar

Sampled: 50K
Distinct: 1

01 37.7K
10 12.3K

`field_name`

varchar

Sampled: 50K
Distinct: 179

HOSTETTER (ARGO) 405
JUDGE MILLS (BRACERO - OIL) 405
INDEPENDENCE, WEST (OLMOS) 405
HIGGINS 405
IMOGENE (ESCONDIDO A) 405
HOLSTEIN (POTH B, LO.) 405
JOURDANTON (BUDA) 405
JUDGE MILLS (ANACACHO) 405
JOHN DEERING (AUSTIN CHALK) 405
J.Y.F. (BUDA) 405
HIGGINS (ESCONDIDO) 405
JOURDANTON (NIXON SAND) 405

`field_oil_prod_vol`

int8

Sampled: 50K
Distinct: 3.3K

0 34.7K
1 403
2 367
5 352
10 260
3 228
30 165
4 160
60 147
15 143
6 137
7 137

Take it away

Back to everything we know about PDQ Field Production by Cycle