district_no
varchar
- Sampled
- 50K
- Distinct
- 3
-
0232.4K -
019.7K -
037.9K
PDQ Field Production by Cycle — preview
A live sample straight out of our copy of the data. Nothing here is edited: this is exactly what an export gives you.
First 100 rows
Out of roughly 131.8K rows in
texas.pdq_og_field_cycle.
Version obs-fc3a3847c3dd.
district_no | field_no | cycle_year | cycle_month | cycle_year_month | district_name | field_name | field_oil_prod_vol | field_gas_prod_vol | field_cond_prod_vol | field_csgd_prod_vol | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 02 | 02621200 | 2007 | 01 | 200701 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 02 | 200702 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 03 | 200703 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 04 | 200704 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 05 | 200705 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 06 | 200706 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 07 | 200707 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 08 | 200708 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 09 | 200709 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 10 | 200710 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 11 | 200711 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2007 | 12 | 200712 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 01 | 200801 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 02 | 200802 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 03 | 200803 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 04 | 200804 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 05 | 200805 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 06 | 200806 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 07 | 200807 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 08 | 200808 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 09 | 200809 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 10 | 200810 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 11 | 200811 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2008 | 12 | 200812 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 01 | 200901 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 02 | 200902 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 03 | 200903 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 04 | 200904 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 05 | 200905 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 06 | 200906 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 07 | 200907 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 08 | 200908 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 09 | 200909 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 10 | 200910 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 11 | 200911 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2009 | 12 | 200912 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 01 | 201001 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 02 | 201002 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 03 | 201003 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 04 | 201004 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 05 | 201005 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 06 | 201006 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 07 | 201007 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 08 | 201008 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 09 | 201009 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 10 | 201010 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 11 | 201011 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2010 | 12 | 201012 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 01 | 201101 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 02 | 201102 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 03 | 201103 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 04 | 201104 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 05 | 201105 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 06 | 201106 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 07 | 201107 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 08 | 201108 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 09 | 201109 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 10 | 201110 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 11 | 201111 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2011 | 12 | 201112 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 01 | 201201 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 02 | 201202 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 03 | 201203 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 04 | 201204 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 05 | 201205 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 06 | 201206 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 07 | 201207 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 08 | 201208 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 09 | 201209 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 10 | 201210 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 11 | 201211 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2012 | 12 | 201212 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 01 | 201301 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 02 | 201302 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 03 | 201303 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 04 | 201304 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 05 | 201305 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 06 | 201306 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 07 | 201307 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 08 | 201308 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 09 | 201309 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 10 | 201310 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 11 | 201311 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2013 | 12 | 201312 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 01 | 201401 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 02 | 201402 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 03 | 201403 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 04 | 201404 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 05 | 201405 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 06 | 201406 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 07 | 201407 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 08 | 201408 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 09 | 201409 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 10 | 201410 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 11 | 201411 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2014 | 12 | 201412 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2015 | 01 | 201501 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2015 | 02 | 201502 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2015 | 03 | 201503 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.m. |
| 02 | 02621200 | 2015 | 04 | 201504 | 02 | ANDER, SOUTH (2300) | 0 | 0 | 0 | 0 | July 13, 2026, 12:58 a.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.
field_no
varchar
- Sampled
- 50K
- Distinct
- 335
-
03776512403 -
05017001403 -
12199500403 -
10730852403 -
00450900403 -
12004500403 -
07148500403 -
14683001403 -
14611832403 -
04923400403 -
10730012403 -
00980500403
cycle_year_month
varchar
- Sampled
- 50K
- Distinct
- 403
-
199812155 -
199907155 -
200101155 -
199809155 -
200102154 -
199710154 -
199801154 -
199709154 -
199711154 -
200103154 -
199806154 -
200012154
cycle_year
varchar
- Sampled
- 50K
- Distinct
- 34
-
19981.8K -
19991.8K -
20001.8K -
20011.8K -
19971.8K -
20021.8K -
19941.8K -
19931.7K -
19951.7K -
19961.7K -
20061.7K -
20031.7K
cycle_month
varchar
- Sampled
- 50K
- Distinct
- 12
-
014.2K -
024.2K -
034.2K -
054.2K -
044.2K -
064.2K -
074.2K -
084.1K -
094.1K -
104.1K -
114.1K -
124.1K
district_name
varchar
- Sampled
- 50K
- Distinct
- 3
-
0232.4K -
019.7K -
037.9K
field_name
varchar
- Sampled
- 50K
- Distinct
- 277
-
SAN CAJA (BLK 86 SD.)403 -
BROOKING (8650)403 -
CAGE (ESCONDIDO)403 -
C.J.P. (REEF)403 -
FANT (WILCOX 9500)403 -
HAMMAN (10,900)403 -
FALLS CITY (4400)403 -
SAN CAJA (BLOCK 85 SD)403 -
SAN JOSE403 -
MAXINE, EAST (MACKHANK)403 -
CACHE (OLMOS SHALLOW)403 -
COOK, S. (WILCOX, LO. 10,850)403
field_oil_prod_vol
int8
- Sampled
- 50K
- Distinct
- 1.8K
-
042.3K -
1391 -
5117 -
293 -
1055 -
450 -
346 -
12029 -
628 -
30027 -
2027 -
12427
Take it away
Back to everything we know about PDQ Field Production by Cycle