A live sample straight out of our copy of the data. Nothing here is edited: this is exactly what an export gives you.
Out of roughly 3.7M rows in
texas.pdq_og_operator_cycle.
Version obs-44086e35b334.
operator_no | cycle_year | cycle_month | cycle_year_month | operator_name | oper_oil_prod_vol | oper_gas_prod_vol | oper_cond_prod_vol | oper_csgd_prod_vol | ingested_at |
|---|---|---|---|---|---|---|---|---|---|
| 000000 | 1996 | 01 | 199601 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1996 | 02 | 199602 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1996 | 03 | 199603 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1996 | 09 | 199609 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1996 | 10 | 199610 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 01 | 199901 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 02 | 199902 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 03 | 199903 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 04 | 199904 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 05 | 199905 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 06 | 199906 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 07 | 199907 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 08 | 199908 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 09 | 199909 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 10 | 199910 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 11 | 199911 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 1999 | 12 | 199912 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 01 | 200001 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 02 | 200002 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 03 | 200003 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 04 | 200004 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 05 | 200005 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 06 | 200006 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 07 | 200007 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 08 | 200008 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 09 | 200009 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 10 | 200010 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 11 | 200011 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2000 | 12 | 200012 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 01 | 200101 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 02 | 200102 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 03 | 200103 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 04 | 200104 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 05 | 200105 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 06 | 200106 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 07 | 200107 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 08 | 200108 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 10 | 200110 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2001 | 12 | 200112 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2002 | 02 | 200202 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2002 | 04 | 200204 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2002 | 05 | 200205 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2002 | 06 | 200206 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2002 | 08 | 200208 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 01 | 200301 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 02 | 200302 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 03 | 200303 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 04 | 200304 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 05 | 200305 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 06 | 200306 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 07 | 200307 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 08 | 200308 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 09 | 200309 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 10 | 200310 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 11 | 200311 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2003 | 12 | 200312 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2004 | 01 | 200401 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2004 | 02 | 200402 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2004 | 03 | 200403 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2004 | 04 | 200404 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2004 | 05 | 200405 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2004 | 06 | 200406 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 01 | 200501 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 02 | 200502 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 03 | 200503 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 04 | 200504 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 05 | 200505 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 06 | 200506 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 07 | 200507 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 08 | 200508 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 09 | 200509 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 10 | 200510 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 11 | 200511 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2005 | 12 | 200512 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 01 | 200601 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 02 | 200602 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 03 | 200603 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 04 | 200604 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 05 | 200605 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 06 | 200606 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 07 | 200607 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 08 | 200608 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 09 | 200609 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 10 | 200610 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 11 | 200611 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2006 | 12 | 200612 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 01 | 200701 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 02 | 200702 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 03 | 200703 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 04 | 200704 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 05 | 200705 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 06 | 200706 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 07 | 200707 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 08 | 200708 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 09 | 200709 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 10 | 200710 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 11 | 200711 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2007 | 12 | 200712 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2008 | 01 | 200801 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
| 000000 | 2008 | 02 | 200802 | null | 0 | 0 | 0 | 0 | Sept. 6, 2026, 11:05 p.m. |
Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.
operator_novarchar
009583
405
000253
405
003605
405
006550
405
000201
405
008484
405
002620
405
007861
405
008391
405
008511
405
009430
405
003968
405
cycle_year_monthvarchar
199301
151
199302
150
199303
149
199305
147
199304
147
199306
146
199506
145
199608
145
199505
145
199610
144
199609
144
199607
144
cycle_yearvarchar
1993
1.7K
1996
1.7K
1995
1.7K
1994
1.7K
1997
1.6K
1998
1.6K
2001
1.6K
2002
1.6K
1999
1.6K
2000
1.6K
2003
1.5K
2015
1.5K
cycle_monthvarchar
03
4.2K
05
4.2K
02
4.2K
01
4.2K
06
4.2K
04
4.2K
07
4.2K
08
4.2K
09
4.2K
12
4.1K
11
4.1K
10
4.1K
operator_namevarchar
AA DELTA EXPLORATION, INC.
405
ADJ COMPANY
405
ABB OIL CO., INC.
405
AGROIL, INC.
405
A.J.& M. OIL COMPANY
405
ABOVE ENERGY, INC.
405
ADAMS, LYNN V.
405
AERO, INC.
405
AKINS OIL COMPANY
405
ABERNATHY, CHARLES G.
405
AAA OIL COMPANY
405
ADVANCE EXPLORATION
405
oper_oil_prod_volint8
0
27.8K
10
307
2
302
1
277
5
192
20
188
30
177
3
172
15
154
4
145
11
125
25
120
oper_gas_prod_volint8
0
39.8K
352
17
2
15
129
12
241
11
3
11
370
11
10
11
108
11
152
11
150
11
160
10
oper_cond_prod_volint8
0
45.5K
2
84
10
82
5
81
3
70
1
66
8
66
7
64
6
63
15
62
12
61
4
54
Back to everything we know about PDQ Operator Production by Cycle