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 65.8K rows in
texas.field_names.
Version obs-063739be9b96.
field_no | field_no_text | district | county_code | multi_county | field_class | field_name | field_prefix | reservoir_no | line_no | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|
| 2001 | 00002001 | 01 | 000 | True | O & G | WILDCAT | 00002 | 001 | 1 | Sept. 6, 2026, 10:50 p.m. |
| 2999 | 00002999 | 01 | 137 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00002 | 999 | 2 | Sept. 6, 2026, 10:50 p.m. |
| 4001 | 00004001 | 02 | 000 | True | O & G | WILDCAT | 00004 | 001 | 3 | Sept. 6, 2026, 10:50 p.m. |
| 4666 | 00004666 | 02 | 297 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00004 | 666 | 4 | Sept. 6, 2026, 10:50 p.m. |
| 4999 | 00004999 | 02 | 285 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00004 | 999 | 5 | Sept. 6, 2026, 10:50 p.m. |
| 6000 | 00006000 | 03 | 039 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00006 | 000 | 6 | Sept. 6, 2026, 10:50 p.m. |
| 6001 | 00006001 | 03 | 015 | True | O & G | WILDCAT | 00006 | 001 | 7 | Sept. 6, 2026, 10:50 p.m. |
| 6004 | 00006004 | 03 | 407 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00006 | 004 | 8 | Sept. 6, 2026, 10:50 p.m. |
| 6999 | 00006999 | 03 | 361 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00006 | 999 | 9 | Sept. 6, 2026, 10:50 p.m. |
| 8000 | 00008000 | 04 | 047 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00008 | 000 | 10 | Sept. 6, 2026, 10:50 p.m. |
| 8001 | 00008001 | 04 | 000 | True | O & G | WILDCAT | 00008 | 001 | 11 | Sept. 6, 2026, 10:50 p.m. |
| 8666 | 00008666 | 04 | 047 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00008 | 666 | 12 | Sept. 6, 2026, 10:50 p.m. |
| 8997 | 00008997 | 04 | 355 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00008 | 997 | 13 | Sept. 6, 2026, 10:50 p.m. |
| 8998 | 00008998 | 04 | 215 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00008 | 998 | 14 | Sept. 6, 2026, 10:50 p.m. |
| 8999 | 00008999 | 04 | 489 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00008 | 999 | 15 | Sept. 6, 2026, 10:50 p.m. |
| 10001 | 00010001 | 05 | 000 | True | O & G | WILDCAT | 00010 | 001 | 16 | Sept. 6, 2026, 10:50 p.m. |
| 10999 | 00010999 | 05 | 467 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00010 | 999 | 17 | Sept. 6, 2026, 10:50 p.m. |
| 12000 | 00012000 | 06 | 401 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00012 | 000 | 18 | Sept. 6, 2026, 10:50 p.m. |
| 12001 | 00012001 | 06 | 000 | True | O & G | WILDCAT | 00012 | 001 | 19 | Sept. 6, 2026, 10:50 p.m. |
| 12999 | 00012999 | 06 | 365 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00012 | 999 | 20 | Sept. 6, 2026, 10:50 p.m. |
| 14001 | 00014001 | 7B | 000 | True | O & G | WILDCAT | 00014 | 001 | 21 | Sept. 6, 2026, 10:50 p.m. |
| 14999 | 00014999 | 7B | 353 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00014 | 999 | 22 | Sept. 6, 2026, 10:50 p.m. |
| 16001 | 00016001 | 7C | 000 | True | O & G | WILDCAT | 00016 | 001 | 23 | Sept. 6, 2026, 10:50 p.m. |
| 18000 | 00018000 | 08 | 135 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00018 | 000 | 24 | Sept. 6, 2026, 10:50 p.m. |
| 18001 | 00018001 | 08 | 000 | True | O & G | WILDCAT | 00018 | 001 | 25 | Sept. 6, 2026, 10:50 p.m. |
| 18801 | 00018801 | 08 | 475 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00018 | 801 | 26 | Sept. 6, 2026, 10:50 p.m. |
| 18999 | 00018999 | 08 | 371 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00018 | 999 | 27 | Sept. 6, 2026, 10:50 p.m. |
| 20001 | 00020001 | 8A | 000 | True | O & G | WILDCAT | 00020 | 001 | 28 | Sept. 6, 2026, 10:50 p.m. |
| 20999 | 00020999 | 8A | 125 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00020 | 999 | 29 | Sept. 6, 2026, 10:50 p.m. |
| 22001 | 00022001 | 09 | 000 | True | O & G | WILDCAT | 00022 | 001 | 30 | Sept. 6, 2026, 10:50 p.m. |
| 22999 | 00022999 | 09 | 503 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00022 | 999 | 31 | Sept. 6, 2026, 10:50 p.m. |
| 24001 | 00024001 | 10 | 000 | True | O & G | WILDCAT | 00024 | 001 | 32 | Sept. 6, 2026, 10:50 p.m. |
| 24999 | 00024999 | 10 | 295 | False | OIL | WILDCAT-COMMISSION USE ONLY | 00024 | 999 | 33 | Sept. 6, 2026, 10:50 p.m. |
| 38500 | 00038500 | 04 | 427 | False | O & G | A & A (4100) | 00038 | 500 | 34 | Sept. 6, 2026, 10:50 p.m. |
| 39500 | 00039500 | 09 | 197 | False | OIL | AAA (CHAPEL) | 00039 | 500 | 35 | Sept. 6, 2026, 10:50 p.m. |
| 40500 | 00040500 | 7B | 133 | False | OIL | AB (RANGER) | 00040 | 500 | 36 | Sept. 6, 2026, 10:50 p.m. |
| 41100 | 00041100 | 7B | 353 | False | OIL | ABB-FAN (CANYON SAND) | 00041 | 100 | 37 | Sept. 6, 2026, 10:50 p.m. |
| 42500 | 00042500 | 09 | 155 | False | OIL | ABW (STRAWN 5200) | 00042 | 500 | 38 | Sept. 6, 2026, 10:50 p.m. |
| 43300 | 00043300 | 02 | 469 | False | GAS | A.B. ALLEN (MIOCENE 2100) | 00043 | 300 | 39 | Sept. 6, 2026, 10:50 p.m. |
| 43500 | 00043500 | 02 | 469 | False | GAS | A. B. ALLEN (MIOCENE 2200) | 00043 | 500 | 40 | Sept. 6, 2026, 10:50 p.m. |
| 52500 | 00052500 | 7B | 441 | False | OIL | A-B-C (KING) | 00052 | 500 | 41 | Sept. 6, 2026, 10:50 p.m. |
| 52700 | 00052700 | 7B | 441 | False | OIL | A-B-C (NOODLE CREEK) | 00052 | 700 | 42 | Sept. 6, 2026, 10:50 p.m. |
| 55800 | 00055800 | 7C | 413 | False | OIL | A.B.H. (WOLFCAMP) | 00055 | 800 | 43 | Sept. 6, 2026, 10:50 p.m. |
| 56800 | 00056800 | 7C | 413 | False | OIL | A.B.H., WEST (WOLFCAMP) | 00056 | 800 | 44 | Sept. 6, 2026, 10:50 p.m. |
| 59500 | 00059500 | 7C | 461 | False | OIL | A-B-M (PENNSYLVANIAN) | 00059 | 500 | 45 | Sept. 6, 2026, 10:50 p.m. |
| 66125 | 00066125 | 02 | 175 | False | OIL | A-B-R (COOK MOUNTAIN) | 00066 | 125 | 46 | Sept. 6, 2026, 10:50 p.m. |
| 66250 | 00066250 | 02 | 175 | False | GAS | A-B-R (FRIO 2800) | 00066 | 250 | 47 | Sept. 6, 2026, 10:50 p.m. |
| 66315 | 00066315 | 02 | 175 | False | OIL | A-B-R (LULING) | 00066 | 315 | 48 | Sept. 6, 2026, 10:50 p.m. |
| 66375 | 00066375 | 02 | 175 | False | GAS | A-B-R (MACKHANK 8500) | 00066 | 375 | 49 | Sept. 6, 2026, 10:50 p.m. |
| 66390 | 00066390 | 02 | 175 | False | GAS | A-B-R (MIOCENE 1600) | 00066 | 390 | 50 | Sept. 6, 2026, 10:50 p.m. |
| 66439 | 00066439 | 02 | 175 | False | O & G | A-B-R (RECKLAW 1ST) | 00066 | 439 | 51 | Sept. 6, 2026, 10:50 p.m. |
| 66440 | 00066440 | 02 | 175 | False | OIL | A-B-R (RECKLAW 2ND) | 00066 | 440 | 52 | Sept. 6, 2026, 10:50 p.m. |
| 66500 | 00066500 | 02 | 175 | False | GAS | A-B-R(VICKSBURG,UPPER STRINGER) | 00066 | 500 | 53 | Sept. 6, 2026, 10:50 p.m. |
| 66625 | 00066625 | 02 | 175 | False | GAS | A-B-R (WILCOX 1ST, MASSIVE) | 00066 | 625 | 54 | Sept. 6, 2026, 10:50 p.m. |
| 66750 | 00066750 | 02 | 175 | False | O & G | A-B-R (WILCOX 2ND, MASSIVE) | 00066 | 750 | 55 | Sept. 6, 2026, 10:50 p.m. |
| 66875 | 00066875 | 02 | 175 | False | O & G | A-B-R (WILCOX 3RD, MASSIVE) | 00066 | 875 | 56 | Sept. 6, 2026, 10:50 p.m. |
| 66900 | 00066900 | 02 | 175 | False | O & G | A-B-R (4850 YEGUA) | 00066 | 900 | 57 | Sept. 6, 2026, 10:50 p.m. |
| 66925 | 00066925 | 02 | 175 | False | OIL | A-B-R (4950 YEGUA) | 00066 | 925 | 58 | Sept. 6, 2026, 10:50 p.m. |
| 67200 | 00067200 | 02 | 175 | False | OIL | A-B-R, EAST (MACKHANK) | 00067 | 200 | 59 | Sept. 6, 2026, 10:50 p.m. |
| 67250 | 00067250 | 02 | 175 | False | GAS | A-B-R, EAST (MASSIVE, 2ND) | 00067 | 250 | 60 | Sept. 6, 2026, 10:50 p.m. |
| 67500 | 00067500 | 02 | 175 | False | OIL | A-B-R, EAST (2ND REKLAW) | 00067 | 500 | 61 | Sept. 6, 2026, 10:50 p.m. |
| 71125 | 00071125 | 02 | 175 | False | GAS | A-B-R, NORTH (COOK MOUNTAIN) | 00071 | 125 | 62 | Sept. 6, 2026, 10:50 p.m. |
| 72500 | 00072500 | 02 | 175 | False | GAS | A-B-R, NE. (WILCOX 2ND, MASS.) | 00072 | 500 | 63 | Sept. 6, 2026, 10:50 p.m. |
| 72600 | 00072600 | 02 | 175 | False | GAS | A-B-R, NE. (2150) | 00072 | 600 | 64 | Sept. 6, 2026, 10:50 p.m. |
| 73500 | 00073500 | 7B | 447 | False | O & G | A. BAKER (MISS.) | 00073 | 500 | 65 | Sept. 6, 2026, 10:50 p.m. |
| 74300 | 00074300 | 7C | 081 | False | O & G | ACR (CANYON) | 00074 | 300 | 66 | Sept. 6, 2026, 10:50 p.m. |
| 74500 | 00074500 | 7C | 081 | False | OIL | ACR (ODOM LIME) | 00074 | 500 | 67 | Sept. 6, 2026, 10:50 p.m. |
| 77480 | 00077480 | 7C | 461 | False | OIL | ACS (WOLFCAMP, LOWER) | 00077 | 480 | 68 | Sept. 6, 2026, 10:50 p.m. |
| 79003 | 00079003 | 08 | 495 | False | OIL | A. C. MORTON (ATOKA) | 00079 | 003 | 69 | Sept. 6, 2026, 10:50 p.m. |
| 79075 | 00079075 | 08 | 495 | False | O & G | A. C. MORTON (CANYON REEF, LO.) | 00079 | 075 | 70 | Sept. 6, 2026, 10:50 p.m. |
| 79078 | 00079078 | 08 | 495 | False | OIL | A. C. MORTON (CISCO REEF) | 00079 | 078 | 71 | Sept. 6, 2026, 10:50 p.m. |
| 79080 | 00079080 | 08 | 495 | False | GAS | A. C. MORTON (DEVONIAN) | 00079 | 080 | 72 | Sept. 6, 2026, 10:50 p.m. |
| 81500 | 00081500 | 7B | 059 | False | OIL | A. C. SCOTT (CROSS PLAINS) | 00081 | 500 | 73 | Sept. 6, 2026, 10:50 p.m. |
| 85500 | 00085500 | 7B | 059 | False | OIL | A. C. SCOTT, NW. (CROSS PLAINS) | 00085 | 500 | 74 | Sept. 6, 2026, 10:50 p.m. |
| 88500 | 00088500 | 7B | 059 | False | OIL | A. C. SCOTT, W.(CROSS PLAINS SD) | 00088 | 500 | 75 | Sept. 6, 2026, 10:50 p.m. |
| 88700 | 00088700 | 7B | 059 | False | OIL | A. C. SCOTT, W. (ELLEN) | 00088 | 700 | 76 | Sept. 6, 2026, 10:50 p.m. |
| 95350 | 00095350 | 7C | 443 | False | GAS | ACU (STRAWN) | 00095 | 350 | 77 | Sept. 6, 2026, 10:50 p.m. |
| 96265 | 00096265 | 7C | 443 | False | GAS | ACU, E. (PENN SAND) | 00096 | 265 | 78 | Sept. 6, 2026, 10:50 p.m. |
| 102333 | 00102333 | 09 | 009 | False | O & G | A & D (MARBLE FALLS CONGL. 4900) | 00102 | 333 | 79 | Sept. 6, 2026, 10:50 p.m. |
| 102666 | 00102666 | 09 | 009 | False | OIL | A & D (MISSISSIPPI) | 00102 | 666 | 80 | Sept. 6, 2026, 10:50 p.m. |
| 104250 | 00104250 | 7B | 363 | False | GAS | A. B. CRAWFORD (CONGL.) | 00104 | 250 | 81 | Sept. 6, 2026, 10:50 p.m. |
| 108500 | 00108500 | 7B | 083 | False | O & G | A. D. H. (MORRIS) | 00108 | 500 | 82 | Sept. 6, 2026, 10:50 p.m. |
| 116333 | 00116333 | 09 | 009 | False | OIL | A-D & P (DELMAR) | 00116 | 333 | 83 | Sept. 6, 2026, 10:50 p.m. |
| 116666 | 00116666 | 09 | 009 | False | OIL | A-D & P (GUNSIGHT) | 00116 | 666 | 84 | Sept. 6, 2026, 10:50 p.m. |
| 119500 | 00119500 | 7B | 049 | False | GAS | A. E. DAVIS (MARBLE FALLS) | 00119 | 500 | 85 | Sept. 6, 2026, 10:50 p.m. |
| 122500 | 00122500 | 8A | 169 | False | OIL | A-F-G (CLEARFORK) | 00122 | 500 | 86 | Sept. 6, 2026, 10:50 p.m. |
| 126400 | 00126400 | 08 | 371 | False | GAS | A. G. H. (BRANDENBURG) | 00126 | 400 | 87 | Sept. 6, 2026, 10:50 p.m. |
| 126500 | 00126500 | 08 | 371 | False | OIL | A. G. H. (CHERRY CANYON) | 00126 | 500 | 88 | Sept. 6, 2026, 10:50 p.m. |
| 128500 | 00128500 | 7B | 447 | False | OIL | A. GOOD (MISSISSIPPI) | 00128 | 500 | 89 | Sept. 6, 2026, 10:50 p.m. |
| 130111 | 00130111 | 04 | 131 | False | OIL | A. & H. (C-SAND) | 00130 | 111 | 90 | Sept. 6, 2026, 10:50 p.m. |
| 130222 | 00130222 | 04 | 131 | False | OIL | A. & H. (HOCKLEY) | 00130 | 222 | 91 | Sept. 6, 2026, 10:50 p.m. |
| 130333 | 00130333 | 04 | 131 | False | O & G | A. & H. (HOCKLEY -A-4-) | 00130 | 333 | 92 | Sept. 6, 2026, 10:50 p.m. |
| 130444 | 00130444 | 04 | 131 | False | O & G | A. & H. (HOCKLEY -B-) | 00130 | 444 | 93 | Sept. 6, 2026, 10:50 p.m. |
| 130555 | 00130555 | 04 | 131 | False | GAS | A. & H. (HOCKLEY -B- SEG. 1) | 00130 | 555 | 94 | Sept. 6, 2026, 10:50 p.m. |
| 130666 | 00130666 | 04 | 131 | False | OIL | A. & H. (HOCKLEY -E-) | 00130 | 666 | 95 | Sept. 6, 2026, 10:50 p.m. |
| 130777 | 00130777 | 04 | 131 | False | O & G | A. & H. (PETTUS) | 00130 | 777 | 96 | Sept. 6, 2026, 10:50 p.m. |
| 130800 | 00130800 | 04 | 131 | False | GAS | A&H (YEGUA 4800) | 00130 | 800 | 97 | Sept. 6, 2026, 10:50 p.m. |
| 130840 | 00130840 | 04 | 131 | False | GAS | A & H (700) | 00130 | 840 | 98 | Sept. 6, 2026, 10:50 p.m. |
| 130888 | 00130888 | 04 | 131 | False | GAS | A. & H. (3250) | 00130 | 888 | 99 | Sept. 6, 2026, 10:50 p.m. |
| 130889 | 00130889 | 04 | 131 | False | GAS | A & H (4515) | 00130 | 889 | 100 | Sept. 6, 2026, 10:50 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.
field_noint4
9745900
1
19469980
1
19463500
1
19028076
1
73293235
1
68227001
1
26937500
1
1889080
1
4640500
1
989111
1
76723640
1
21023001
1
field_no_textbpchar
15831380
1
31768350
1
71815400
1
39601325
1
69022100
1
61771050
1
40957550
1
57548840
1
33010190
1
55256710
1
49961500
1
47391573
1
districtvarchar
04
17.2K
03
11.6K
02
10.2K
08
3.8K
06
2.5K
01
2.4K
09
1.5K
05
921
field_namevarchar
BUFFALO CAMP, N (FRIO 10,300-B)
2
HEYSER, SE. (SANDY G-13)
2
PONLAW (SOMA)
2
KING
2
GREEN LAKE
2
DAY
2
AGUA PRIETA (3870)
2
DECKERS PRAIRIE (WILCOX)
2
OLD INGLESIDE (D-2)
2
NORBEE (HOCKLEY, N. E.)
2
MARSTON RANCH (ELLENBURGER)
2
BRIDGES
2
county_codebpchar
355
2.6K
239
1.7K
273
1.5K
131
1.5K
215
1.4K
249
1.3K
047
1.3K
321
1.3K
175
1.2K
391
1.2K
297
988
071
976
multi_countybool
False
46.5K
True
3.5K
field_classvarchar
GAS
24.4K
OIL
17.9K
O & G
7.8K
field_prefixbpchar
00832
283
10730
263
48631
247
76723
184
15491
152
48635
135
17075
123
01095
121
59373
118
73293
118
56688
113
55389
102
Back to everything we know about Oil & Gas Field Name & Numbers