First 100 rows

Out of roughly 1.2M rows in texas.og_docket_subject. Version obs-e0573b3970ae.

First 100 rows of texas.og_docket_subject, 5 columns wide
docket_numberline_nosubject_textsubject_flagsingested_at
783330003COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783560001RULE 37 CASE, PARSELL SOUTH (MORROW-UPPER SE.) YY000Sept. 8, 2026, 2 a.m.
783560002FIELD, HEMPHILL COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783620001RULE 37 CASE, WILDCAT (ABOVE 5100') FIELD, YY000Sept. 8, 2026, 2 a.m.
783620002ARCHER COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783640001RULE 37 CASE, FOLLETT, SOUTH (MORROW) FIELD, YY000Sept. 8, 2026, 2 a.m.
783640002LIPSCOMB COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783670001RULE 37, HOUSTON, S. (SHALLOW MIOCENE)FIELD, YY000Sept. 8, 2026, 2 a.m.
783670002HARRIS COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783690001RULE 37, C. R. RICHARDSON LEASE, WELL NO. 11, YY000Sept. 8, 2026, 2 a.m.
783690002CLARA DRISCOLL, S. (SEG A), (5900) & WILDCAT YY000Sept. 8, 2026, 2 a.m.
783690003FIELDS, NUECES COUNTY, TEXAS. YY000Sept. 8, 2026, 2 a.m.
783750001RULE 37 CASE, WILDCAT (ABOVE 3000) FIELD, YY000Sept. 8, 2026, 2 a.m.
783750002COLORADO COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783770001RULE 37, PETERS K LEASE, WELL NO. 1, PETERS, YY000Sept. 8, 2026, 2 a.m.
783770002EAST (ARGO, UP. SD.) FIELD, DUVAL COUNTY, YY000Sept. 8, 2026, 2 a.m.
783770003TEXAS YY000Sept. 8, 2026, 2 a.m.
783880001RULE 37, NORTON-MUSSELMAN GAS UNIT LEASE, WELL YY000Sept. 8, 2026, 2 a.m.
783880002NO. 3, SALEM (1750) FIELDS, YY000Sept. 8, 2026, 2 a.m.
783880003VICTORIA COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783930001RULE 37 CASE, WILDCAT (ABOVE 2500') FIELD, YY000Sept. 8, 2026, 2 a.m.
783930002LIMESTONE COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783940001RULE 37 CASE, GALVESTON ISLAND (DISCORBIS-5) YY000Sept. 8, 2026, 2 a.m.
783940002AND WILDCAT (ABOVE 7900') FIELDS, GALVESTON YY000Sept. 8, 2026, 2 a.m.
783940003COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783960001RULE 37 CASE, STEPHENS COUNTY REGULAR FIELD, YY000Sept. 8, 2026, 2 a.m.
783960002STEPHENS COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
783970001RULE 37, F. E. JONES LEASE, WELL NO. 1, UNA YY000Sept. 8, 2026, 2 a.m.
783970002WEST (U SAND) FIELD, VICTORIA COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
784010001RULE 37 CASE, GRUVER, NORTH (MORROW 69851), YY000Sept. 8, 2026, 2 a.m.
784010002(HEPLER), AND (MISSISSIPPIAN) FIELDS, HANSFORD YY000Sept. 8, 2026, 2 a.m.
784010003COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
846150002RUNNELS COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
846160001RULE 37, TIDEHAVEN (8270); (9490); & WILDCAT YY000Sept. 8, 2026, 2 a.m.
846160002FIELDS, MATAGORDA COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
846170001RULE 37, LUTHER, SE (SILURIAN-DEVONIAN) FIELD, YY000Sept. 8, 2026, 2 a.m.
846170002HOWARD COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
846180001RULE 37, LUTHER, SE (SILURIAN-DEVONIAN) FIELD, YY000Sept. 8, 2026, 2 a.m.
846180002HOWARD COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
872210001RULE 37, EAST TEXAS FIELD, GREGG COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872220001RULE 37, WILDCAT FIELD, SAN PATRICIO COUNTY, YY000Sept. 8, 2026, 2:01 a.m.
872220002TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872230001RULE 37, GIDDINGS (AUSTIN CHALK-3) FIELD, YY000Sept. 8, 2026, 2:01 a.m.
872230002FAYETTE COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872240001RULE 37, MILLER LEASE, WELL NO. 1, WILDCAT YY000Sept. 8, 2026, 2:01 a.m.
872240002FIELD, COLORADO COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872250001RULE 37, WILDCAT FIELD, CALLAHAN COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872260001RULE 37, LITTLE GIANT (TANNEHILL) FIELD, KNOX YY000Sept. 8, 2026, 2:01 a.m.
872260002COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872270001RULE 37, CANNING (WOLFCAMP) FIELD, BORDEN YY000Sept. 8, 2026, 2:01 a.m.
872270002COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872280001RULE 37, SHACKELFORD COUNTY REGULAR FIELD, YY000Sept. 8, 2026, 2:01 a.m.
872280002SHACKELFORD COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872290001RULE 37, GIDDINGS (AUSTIN CHALK) FIELD, FAYETTEYY000Sept. 8, 2026, 2:01 a.m.
872290002COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872300001RULE 37, GRANBURY, N.E. (ATOKA) FIELD, HOOD YY000Sept. 8, 2026, 2:01 a.m.
872300002COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872310001RULE 37, GRANBURY, N.E. (ATOKA) FIELD, HOOD YY000Sept. 8, 2026, 2:01 a.m.
872310002COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872320001RULE 37, GRANBURY, NE (ATOKA) FIELD, HOOD YY000Sept. 8, 2026, 2:01 a.m.
872320002COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872330001RULE 37, WILDCAT FIELD, REFUGIO COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872350001RULE 37, PANHANDLE HUTCHINSON COUNTY FIELD, YY000Sept. 8, 2026, 2:01 a.m.
872350002HUTCHINSON COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872360001RULE 37, SIVELLS BEND FIELD, COOKE COUNTY, YY000Sept. 8, 2026, 2:01 a.m.
872360002TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872370001RULE 37, SHERMAN (DAVIS 9100) FIELD, GRAYSON YY000Sept. 8, 2026, 2:01 a.m.
872370002COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872380001RULE 37, COOKE COUNTY REGULAR FIELD, COOKE YY000Sept. 8, 2026, 2:01 a.m.
872380002COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872390001RULE 37, KINGSVILLE (4260) & WILDCAT FIELDS, YY000Sept. 8, 2026, 2:01 a.m.
872390002KLEBERG COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872400001RULE 37, BRELUM (CHERNOSKY) & WILDCAT FIELDS, YY000Sept. 8, 2026, 2:01 a.m.
872400002DUVAL COUNTY, TEXAS YY000Sept. 8, 2026, 2:01 a.m.
872410001RULE 37, FAITH SUMMERS LEASE, WELL NO. 1, YY000Sept. 8, 2026, 2:01 a.m.
784040001RULE 37 CASE, SHACKELFORD COUNTY REGULAR FIELD,YY000Sept. 8, 2026, 2 a.m.
784040002SHACKELFORD COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
784180001RULE 37 CASE, VERA (STRAWN), (STRAWN 3600') YY000Sept. 8, 2026, 2 a.m.
784180002AND (MISS.) FIELDS, CLAY COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
784190001RULE 37 CASE, SHACKELFORD COUNTY REGULAR YY000Sept. 8, 2026, 2 a.m.
784190002FIELD, SHACKELFORD COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
784210001RULE 37 CASE, LIVINGSTON FIELD, POLK COUNTY, YY000Sept. 8, 2026, 2 a.m.
784210002TEXAS YY000Sept. 8, 2026, 2 a.m.
784270001RULE 37 CASE, GIDDINGS-AUSTIN CHALK FIELD, YY000Sept. 8, 2026, 2 a.m.
784270002LEE COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
784420001RULE 37, THERESA PETRICH WELL #4 YY000Sept. 8, 2026, 2 a.m.
784420002HARRIS COUNTY, TEXAS YY000Sept. 8, 2026, 2 a.m.
784420012TOMBALL (COCKFIELD), TOMBALL (COCKFIELD UPPER YY000Sept. 8, 2026, 2 a.m.
7844200225500), TOMBALL (COCKFIELD 5400), TOMBALL (JACK-YY000Sept. 8, 2026, 2 a.m.
784420032SON 1), TOMBALL (JACKSON 4400), TOMBALL (JACK- YY000Sept. 8, 2026, 2 a.m.
784420042SON 4600 NW), TOMBALL (4700), TOMBALL (MIOCENE YY000Sept. 8, 2026, 2 a.m.
7844200527) TOMBALL (MIOCENE 12), TOMBALL (MIOCENE 30), YY000Sept. 8, 2026, 2 a.m.
784420062TOMBALL (MIOCENE 1450), TOMBALL (MIOCENE 3320),YY000Sept. 8, 2026, 2 a.m.
784420072TOMBALL (PETRICH NW), TOMBALL (SCHULTZ NW), TOMYY000Sept. 8, 2026, 2 a.m.
784420082BALL (SCHULTZ 5800), TOMBALL (SID MOORE), TOM- YY000Sept. 8, 2026, 2 a.m.
784420092BALL (STRAY 5300), TOMBALL (VICKSBURG 3940), YY000Sept. 8, 2026, 2 a.m.
784420102TOMBALL (MIOCENE 7AC) TOMBALL (MIOCENE 9), YY000Sept. 8, 2026, 2 a.m.
784420112VARIOUS TOMBALL FIELDS AND WILDCAT. YY000Sept. 8, 2026, 2 a.m.
784430001RULE 37 CASE, BAR-MAR (TUBB) FIELD, CRANE YY000Sept. 8, 2026, 2 a.m.
784430002COUNTY, TEXAS YY000Sept. 8, 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
55
  • 0001 20K
  • 0002 18.7K
  • 0003 8.6K
  • 0004 1.1K
  • 0005 361
  • 0006 167
  • 0012 124
  • 0010 96
  • 0007 91
  • 0013 70
  • 0011 60
  • 0020 60

subject_text

varchar

Sampled
50K
Distinct
29.4K
  • TEXAS YY0 3.2K
  • COUNTY, TEXAS YY0 3.1K
  • TEXAS. YY0 740
  • COUNTY, TEXAS. YY0 581
  • YY0 211
  • RULE 37 CASE, YY0 82
  • CROCKETT COUNTY, TEXAS YY0 79
  • BURLESON COUNTY, TEXAS YY0 77
  • RULE 37, WASSON FIELD, YOAKUM COUNTY, TEXAS YY0 76
  • STEPHENS COUNTY, TEXAS YY0 73
  • RULE 37, YATES FIELD UNIT (24061) LEASE, WELL YY0 67
  • SHACKELFORD COUNTY, TEXAS YY0 64

subject_flags

varchar

Sampled
50K
Distinct
1
  • 00 50K

ingested_at

timestamptz

Sampled
50K
Distinct
20
  • Sept. 8, 2026, 2:03 a.m. 3K
  • Sept. 8, 2026, 2:03 a.m. 3K
  • Sept. 8, 2026, 2:03 a.m. 3K
  • Sept. 8, 2026, 2:03 a.m. 3K
  • Sept. 8, 2026, 2:03 a.m. 2.9K
  • Sept. 8, 2026, 2:02 a.m. 2.9K
  • Sept. 8, 2026, 2:02 a.m. 2.9K
  • Sept. 8, 2026, 2:02 a.m. 2.9K
  • Sept. 8, 2026, 2:02 a.m. 2.9K
  • Sept. 8, 2026, 2:02 a.m. 2.9K
  • Sept. 8, 2026, 2:02 a.m. 2.8K
  • Sept. 8, 2026, 2 a.m. 2.6K

Take it away

Back to everything we know about Oil and Gas Docket Subjects