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 5.3K rows in
texas.pdq_og_district_cycle.
Version obs-352991ba4ac4.
district_no | cycle_year | cycle_month | cycle_year_month | district_name | dist_oil_prod_vol | dist_gas_prod_vol | dist_cond_prod_vol | dist_csgd_prod_vol | ingested_at |
|---|---|---|---|---|---|---|---|---|---|
| 01 | 1993 | 01 | 199301 | 01 | 1947484 | 8120967 | 43651 | 2059947 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 02 | 199302 | 01 | 1747372 | 7298169 | 41133 | 1882366 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 03 | 199303 | 01 | 1888892 | 8041840 | 45487 | 2039469 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 04 | 199304 | 01 | 1823936 | 7804435 | 42059 | 1979881 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 05 | 199305 | 01 | 1804179 | 7971839 | 40765 | 2005336 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 06 | 199306 | 01 | 1772901 | 7433205 | 36117 | 1936614 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 07 | 199307 | 01 | 1809962 | 7840059 | 39149 | 1994869 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 08 | 199308 | 01 | 1813086 | 7822196 | 40080 | 2041558 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 09 | 199309 | 01 | 1675599 | 7556682 | 36599 | 1871241 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 10 | 199310 | 01 | 1689383 | 7810724 | 41036 | 1981397 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 11 | 199311 | 01 | 1523103 | 7389647 | 42426 | 1774658 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1993 | 12 | 199312 | 01 | 1466249 | 7639928 | 42753 | 1706924 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 01 | 199401 | 01 | 1408917 | 7463624 | 44602 | 1607986 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 02 | 199402 | 01 | 1262093 | 6659625 | 39849 | 1488495 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 03 | 199403 | 01 | 1393027 | 7508556 | 38290 | 1677489 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 04 | 199404 | 01 | 1319676 | 7427933 | 35347 | 1590910 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 05 | 199405 | 01 | 1366842 | 7875279 | 37525 | 1541704 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 06 | 199406 | 01 | 1270020 | 7568008 | 38421 | 1461121 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 07 | 199407 | 01 | 1285353 | 7639895 | 35978 | 1521800 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 08 | 199408 | 01 | 1255971 | 7800745 | 36984 | 1488052 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 09 | 199409 | 01 | 1206178 | 7308657 | 34030 | 1396560 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 10 | 199410 | 01 | 1198483 | 8006843 | 36541 | 1400541 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 11 | 199411 | 01 | 1138421 | 7747513 | 37708 | 1266320 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1994 | 12 | 199412 | 01 | 1144410 | 7961476 | 39690 | 1316519 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 01 | 199501 | 01 | 1137278 | 7756486 | 43599 | 1258400 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 02 | 199502 | 01 | 1043011 | 7127848 | 38158 | 1173271 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 03 | 199503 | 01 | 1112377 | 7581157 | 41250 | 1257868 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 04 | 199504 | 01 | 1077915 | 7171632 | 34721 | 1202205 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 05 | 199505 | 01 | 1109515 | 7388274 | 33309 | 1283279 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 06 | 199506 | 01 | 1048995 | 7252524 | 31872 | 1213324 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 07 | 199507 | 01 | 1057923 | 7477307 | 30892 | 1206404 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 08 | 199508 | 01 | 1051710 | 7430622 | 31259 | 1186331 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 09 | 199509 | 01 | 1008674 | 7087814 | 31607 | 1153279 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 10 | 199510 | 01 | 1034061 | 7460646 | 39204 | 1170577 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 11 | 199511 | 01 | 1011266 | 7271618 | 47641 | 1109754 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1995 | 12 | 199512 | 01 | 1016273 | 7709437 | 58816 | 1111855 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 01 | 199601 | 01 | 1010996 | 7833171 | 55798 | 1068849 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 02 | 199602 | 01 | 935418 | 7601117 | 52274 | 964072 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 03 | 199603 | 01 | 1018027 | 8400455 | 55897 | 1041209 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 04 | 199604 | 01 | 966987 | 8204119 | 54673 | 997377 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 05 | 199605 | 01 | 1029388 | 8467033 | 50829 | 1011857 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 06 | 199606 | 01 | 963276 | 8411451 | 50245 | 971015 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 07 | 199607 | 01 | 955638 | 8817622 | 52946 | 987542 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 08 | 199608 | 01 | 970101 | 8020124 | 50834 | 986303 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 09 | 199609 | 01 | 910314 | 8328624 | 49408 | 949658 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 10 | 199610 | 01 | 948022 | 9387747 | 57333 | 990862 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 11 | 199611 | 01 | 894133 | 9269152 | 58524 | 959669 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1996 | 12 | 199612 | 01 | 889028 | 9787484 | 69225 | 968747 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 01 | 199701 | 01 | 871343 | 9557083 | 71574 | 927523 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 02 | 199702 | 01 | 823534 | 8868818 | 66089 | 845511 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 03 | 199703 | 01 | 884181 | 9852849 | 71349 | 948057 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 04 | 199704 | 01 | 873275 | 9344629 | 68245 | 913077 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 05 | 199705 | 01 | 897433 | 9661447 | 64200 | 981140 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 06 | 199706 | 01 | 846976 | 9193597 | 61613 | 956625 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 07 | 199707 | 01 | 854011 | 9761330 | 65665 | 977278 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 08 | 199708 | 01 | 843179 | 9904668 | 64064 | 951759 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 09 | 199709 | 01 | 807726 | 9680668 | 60211 | 906908 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 10 | 199710 | 01 | 824058 | 9989887 | 63799 | 934329 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 11 | 199711 | 01 | 807732 | 9503870 | 63460 | 884546 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1997 | 12 | 199712 | 01 | 858121 | 9874933 | 72517 | 894807 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 01 | 199801 | 01 | 884942 | 10052731 | 70939 | 927166 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 02 | 199802 | 01 | 804247 | 9020787 | 62834 | 856596 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 03 | 199803 | 01 | 860759 | 10277676 | 68509 | 997961 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 04 | 199804 | 01 | 852522 | 10213120 | 67097 | 955783 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 05 | 199805 | 01 | 858240 | 10095873 | 63934 | 957069 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 06 | 199806 | 01 | 802656 | 10174598 | 63248 | 897681 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 07 | 199807 | 01 | 802012 | 10641615 | 60777 | 852239 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 08 | 199808 | 01 | 765951 | 10418555 | 58040 | 805206 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 09 | 199809 | 01 | 729055 | 9884836 | 52245 | 773649 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 10 | 199810 | 01 | 720686 | 9970807 | 54893 | 753307 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 11 | 199811 | 01 | 700340 | 9830568 | 57421 | 736231 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1998 | 12 | 199812 | 01 | 686001 | 10331261 | 59611 | 780115 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 01 | 199901 | 01 | 653562 | 10585968 | 61262 | 777379 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 02 | 199902 | 01 | 606339 | 9493900 | 54642 | 697607 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 03 | 199903 | 01 | 682998 | 10399232 | 60552 | 796476 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 04 | 199904 | 01 | 676609 | 9754850 | 52746 | 775983 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 05 | 199905 | 01 | 707951 | 10012138 | 49513 | 805774 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 06 | 199906 | 01 | 697003 | 9751611 | 46727 | 781609 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 07 | 199907 | 01 | 695224 | 10114218 | 44643 | 788859 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 08 | 199908 | 01 | 682786 | 10394546 | 41686 | 744522 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 09 | 199909 | 01 | 680842 | 10071587 | 39867 | 735664 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 10 | 199910 | 01 | 708670 | 10305099 | 44098 | 763761 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 11 | 199911 | 01 | 692442 | 9567130 | 41307 | 744727 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 1999 | 12 | 199912 | 01 | 721045 | 9432954 | 45978 | 659472 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 01 | 200001 | 01 | 712749 | 9527573 | 50924 | 731258 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 02 | 200002 | 01 | 668925 | 8868766 | 47753 | 708994 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 03 | 200003 | 01 | 719701 | 9267917 | 52947 | 770400 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 04 | 200004 | 01 | 686710 | 8890456 | 48301 | 747525 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 05 | 200005 | 01 | 699967 | 9175536 | 51664 | 762203 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 06 | 200006 | 01 | 667476 | 8856579 | 41594 | 712712 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 07 | 200007 | 01 | 680779 | 9208989 | 46033 | 742028 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 08 | 200008 | 01 | 681385 | 9088447 | 41712 | 742874 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 09 | 200009 | 01 | 662918 | 8633465 | 41576 | 711144 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 10 | 200010 | 01 | 691968 | 8845365 | 41928 | 710720 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 11 | 200011 | 01 | 649927 | 8664487 | 41729 | 656884 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2000 | 12 | 200012 | 01 | 683994 | 8797500 | 47772 | 676253 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2001 | 01 | 200101 | 01 | 683624 | 8839699 | 49400 | 667581 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2001 | 02 | 200102 | 01 | 628676 | 7966319 | 44120 | 641250 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2001 | 03 | 200103 | 01 | 685711 | 8771920 | 45959 | 726565 | Sept. 6, 2026, 11:05 p.m. |
| 01 | 2001 | 04 | 200104 | 01 | 660512 | 8387452 | 41526 | 704069 | 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.
district_novarchar
07
405
10
405
06
405
11
405
13
405
03
405
09
405
01
405
05
405
04
405
08
405
14
405
cycle_year_monthvarchar
199505
13
200304
13
201903
13
199607
13
202012
13
200510
13
199507
13
201006
13
201501
13
199604
13
200512
13
200508
13
cycle_yearvarchar
1994
156
2024
156
2011
156
2008
156
2002
156
2019
156
2012
156
2023
156
1996
156
2022
156
2004
156
2013
156
cycle_monthvarchar
08
442
05
442
04
442
02
442
07
442
06
442
03
442
09
442
01
442
12
429
11
429
10
429
district_namevarchar
7B
405
10
405
06
405
8A
405
03
405
09
405
01
405
05
405
04
405
08
405
7C
405
6E
405
dist_oil_prod_volint8
0
39
653647
2
155107
2
885243
2
178867
2
403595
2
809531
2
660400
2
695330
2
490979
2
694312
2
4313630
1
dist_gas_prod_volint8
0
441
18664237
1
77401047
1
1675039
1
16852446
1
168553077
1
25898307
1
46429721
1
67627203
1
53570201
1
20526156
1
36913572
1
dist_cond_prod_volint8
0
441
5631
2
1167
2
2215
2
12713
2
5761
2
6743
2
6616
2
4826
2
6193
2
5535
2
11635
2
Back to everything we know about PDQ District Production by Cycle