EZRRC
Cart Sign in

Oil and Gas Docket Subjects — 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 1.2M rows in texas.og_docket_subject. Version obs-9e461a975ddb.

docket_numberline_nosubject_textsubject_flagsingested_at
819500002JIM WELLS COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
819510001RULE 37 CASE, SHACKELFORD, NORTHEAST (MISS.) YY000July 28, 2026, 2 a.m.
819510002FIELD, SHACKELFORD COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
819530001RULE 37, D. M. HEARNE GAS UNIT NO. 1 (086579) YY000July 28, 2026, 2 a.m.
819530002LEASE, WELL NO. 1, OAK HILL (COTTON VALLEY) YY000July 28, 2026, 2 a.m.
819530003FIELD, RUSK COUNTY, TEXAS. YY000July 28, 2026, 2 a.m.
819590001RULE 37 CASE, WOLF CREEK (ST. LOUIS) AND DUDE YY000July 28, 2026, 2 a.m.
819590002WILSON (CLEVELAND) FIELDS, OCHILTREE COUNTY, YY000July 28, 2026, 2 a.m.
819590003TEXAS YY000July 28, 2026, 2 a.m.
819600001WASHITA CREEK (MORROW, UPPER) FIELD, YY000July 28, 2026, 2 a.m.
819600002HEMPHILL COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
819630001RULE 37 CASE, SHAPLEY (MORROW) FIELD, YY000July 28, 2026, 2 a.m.
819630002HANSFORD COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
819650001RULE 37 CASE, WILDCAT FIELD, PECOS COUNTY, YY000July 28, 2026, 2 a.m.
819650002TEXAS YY000July 28, 2026, 2 a.m.
819710001RULE 37 CASE, YY000July 28, 2026, 2 a.m.
819710002WILDCAT FIELD, YY000July 28, 2026, 2 a.m.
819710003GALVESTON COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
819730001RULE 37 CASE, IATAN, EAST (HOWARD) FIELD, YY000July 28, 2026, 2 a.m.
819730002HOWARD COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
819740001RULE 37 CASE, RENO (CONGL.) & WILDCAT FIELDS, YY000July 28, 2026, 2 a.m.
819740002PARKER COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820080001RULE 37 CASE, MOTION FOR REHEARING, WILDCAT YY000July 28, 2026, 2 a.m.
820080002FIELD, RUNNELS COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820090001RULE 37 CASE, GARZA FIELD, GARZA COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820110001RULE 37 CASE, HANFORD (SAN ANDRES) FIELD, YY000July 28, 2026, 2 a.m.
820110002GAINES COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820120001RULE 37 CASE, GARZA FIELD, GARZA COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820130001RULE 37 CASE, GARZA FIELD, GARZA COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820140001RULE 37 CASE, GARZA FIELD, GARZA COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820150001RULE 37 CASE, GARZA FIELD, GARZA COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820410001RULE 37 CASE, EAST TEXAS FIELD, RUSK COUNTY, YY000July 28, 2026, 2 a.m.
820410002TEXAS YY000July 28, 2026, 2 a.m.
820580001RULE 37, LOCKWOOD & SHARP -A- LEASE, WELL YY000July 28, 2026, 2 a.m.
820580002NO. 87, THOMPSON (MIOCENE 12-A SEG 4) & WILDCATYY000July 28, 2026, 2 a.m.
820580003FIELDS YY000July 28, 2026, 2 a.m.
820580013FORT BEND COUNTY, TX YY000July 28, 2026, 2 a.m.
820640001RULE 37 CASE, DOTY (KING SAND) FIELD, YY000July 28, 2026, 2 a.m.
820640002JONES COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820810001RULE 37 CASE, T-C-B, E. (20-I-3) FIELD, YY000July 28, 2026, 2 a.m.
820810002KLEBERG COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820950001RULE 37 CASE, SEMINOLE, S. E. (SAN ANDRES) YY000July 28, 2026, 2 a.m.
820950002FIELD, GAINES COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
820970001RULE 37 CASE, OWNBY (CLEARFORK, UP.) FIELD, YY000July 28, 2026, 2 a.m.
820970002YOAKUM COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821050001RULE 37, CONOCO TRACT 20 FEE LEASE, WELL NO. 2,YY000July 28, 2026, 2 a.m.
821050002JERGINS; JERGINS (MARGINULINA); (MARGINULA YY000July 28, 2026, 2 a.m.
821050003STRAY 6259); (MARGINULINA STRINGER); YY000July 28, 2026, 2 a.m.
821050004(MARGINULINA 1); (MARGINULINA 1-A); YY000July 28, 2026, 2 a.m.
821050005(MARGINULA 2); AND WILDCAT FIELDS, CHAMBERS YY000July 28, 2026, 2 a.m.
821050006COUNTY, TEXAS. YY000July 28, 2026, 2 a.m.
821060001RULE 37, STEHNO-TUCKER (081399) LEASE, WELL YY000July 28, 2026, 2 a.m.
821060002NO. 1, WILDCAT FIELD, WHARTON COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821140001RULE 37 CASE, YOUNG COUNTY REGULAR FIELD, YY000July 28, 2026, 2 a.m.
821140002YOUNG COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821170001RULE 37 CASE, RENO (CONGL.) AND WILDCAT YY000July 28, 2026, 2 a.m.
821170002FIELDS, PARKER COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821190001RULE 37 CASE, GROUP, S. (CANYON REEF), (CANYON YY000July 28, 2026, 2 a.m.
821190002CREEK) FIELDS, NOLAN COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
869190002COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
869200001RULE 37 JMM (CANYON) FIELD, NOLAN COUNTY, YY000July 28, 2026, 2 a.m.
869200002TEXAS YY000July 28, 2026, 2 a.m.
869210001RULE 37, FLYING "W" FIELD, WINKLER COUNTY, YY000July 28, 2026, 2 a.m.
869210002TEXAS YY000July 28, 2026, 2 a.m.
869220001RULE 37, JO NELL (CANYON D) FIELD, SUTTON YY000July 28, 2026, 2 a.m.
869220002COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
869230001RULE 37, WARD-ESTES, NORTH FIELD, WINKLER YY000July 28, 2026, 2 a.m.
869230002COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
869240001RULE 37, GOLDSMITH (5600) FIELD, ECTOR COUNTY, YY000July 28, 2026, 2 a.m.
869240002TEXAS YY000July 28, 2026, 2 a.m.
869260001RULE 37, SHARON RIDGE (2400) & (CLEAR FORK) YY000July 28, 2026, 2 a.m.
869260002FIELDS, SCURRY COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
869270001RULE 37, WASSON FIELD, YOAKUM COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
869280001RULE 37, WASSON FIELD, YOAKUM COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
869290001RULE 37, WASSON FIELD, YOAKUM COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821280001RULE 37, LYNE GAS UNIT "B" II LEASE, WELL NO. 1YY000July 28, 2026, 2 a.m.
821280002MAXINE, E. (SLICK 7170); (LULING) AND YY000July 28, 2026, 2 a.m.
821280003AND WILDCAT FIELDS, LIVE OAK COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821290001RULES 37 & 38 CASE, LA VERNIA FIELD, YY000July 28, 2026, 2 a.m.
821290002GUADALUPE COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821320001RULES 37 & 38 CASE, LA VERNIA FIELD, YY000July 28, 2026, 2 a.m.
821320002GUADALUPE COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821370001RULE 37 CASE, OLD UPLAND (BEND) FIELD, YY000July 28, 2026, 2 a.m.
821370002UPTON COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821390001RULE 37 CASE, BOWERS (GRANITE WASH) FIELD, YY000July 28, 2026, 2 a.m.
821390002MONTAGUE COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821400001RULE 37 CASE, COOKE COUNTY REGULAR FIELD, YY000July 28, 2026, 2 a.m.
821400002COOKE COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821410001RULES 37 CASE, LULING-BRANYON FIELD, CALDWELL YY000July 28, 2026, 2 a.m.
821410002COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821460001RULE 37, T. J. MARTIN LEASE, WELL NO. 1, YY000July 28, 2026, 2 a.m.
821460002WILDCAT FIELD, MCMULLEN COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821610001RULE 37, OHIO-SUN UNIT LEASE, WELL NO. 38AL, YY000July 28, 2026, 2 a.m.
821610002MARKHAM, N.-BAY CITY, N. (CAYCE), (CHOATE 7100)YY000July 28, 2026, 2 a.m.
821610003& (CORNELIUS) FIELDS, MATAGORDA COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821650001RULE 37 CASE, WICHITA COUNTY REGULAR FIELD, YY000July 28, 2026, 2 a.m.
821650002WICHITA COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821660001RULE 37 CASE, WICHITA COUNTY REGULAR FIELD, YY000July 28, 2026, 2 a.m.
821660002WICHITA COUNTY, TEXAS YY000July 28, 2026, 2 a.m.
821670001RULE 37 CASE, WICHITA COUNTY REGULAR FIELD, YY000July 28, 2026, 2 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.

docket_number

varchar

Sampled
50K
Distinct
7K
  • 01-0243354 82
  • 01-0244803 53
  • 01-0314120 46
  • 01-0316249 46
  • 01-0320101 46
  • 01-0212177 42
  • 01-0299858 34
  • 01-0316247 33
  • 01-0312468 33
  • 01-0279591 33
  • 01-0317348 33
  • 01-0310569 33

line_no

varchar

Sampled
50K
Distinct
51
  • 0001 19.9K
  • 0002 18.6K
  • 0003 8.8K
  • 0004 1.1K
  • 0005 373
  • 0006 170
  • 0012 117
  • 0010 92
  • 0007 92
  • 0013 68
  • 0020 57
  • 0030 57

subject_text

varchar

Sampled
50K
Distinct
29.5K
  • TEXAS YY0 3.2K
  • COUNTY, TEXAS YY0 3.1K
  • TEXAS. YY0 740
  • COUNTY, TEXAS. YY0 579
  • YY0 213
  • RULE 37 CASE, YY0 82
  • BURLESON COUNTY, TEXAS YY0 77
  • RULE 37, WASSON FIELD, YOAKUM COUNTY, TEXAS YY0 76
  • CROCKETT COUNTY, TEXAS YY0 73
  • RULE 37, YATES FIELD UNIT (24061) LEASE, WELL YY0 67
  • STEPHENS COUNTY, TEXAS YY0 66
  • EXCEPTION TO SWR 37 FOR THE YY0 61

subject_flags

varchar

Sampled
50K
Distinct
1
  • 00 50K

ingested_at

timestamptz

Sampled
50K
Distinct
19
  • July 28, 2026, 2:02 a.m. 3K
  • July 28, 2026, 2:02 a.m. 3K
  • July 28, 2026, 2:02 a.m. 3K
  • July 28, 2026, 2:02 a.m. 3K
  • July 28, 2026, 2:02 a.m. 2.9K
  • July 28, 2026, 2:02 a.m. 2.9K
  • July 28, 2026, 2:01 a.m. 2.9K
  • July 28, 2026, 2:01 a.m. 2.9K
  • July 28, 2026, 2:01 a.m. 2.9K
  • July 28, 2026, 2:01 a.m. 2.9K
  • July 28, 2026, 2:01 a.m. 2.8K
  • July 28, 2026, 2:02 a.m. 2.7K

Take it away

Back to everything we know about Oil and Gas Docket Subjects