First 100 rows

Out of roughly 1.3M rows in texas.uic_permit_remarks. Version obs-5027a534d263.

First 100 rows of texas.uic_permit_remarks, 4 columns wide
cntl_noremark_textrow_noingested_at
00000031099601 CANCEL INJECTION PERMIT PER PLUGGED STATUS. TRH18931236Sept. 2, 2026, 2 a.m.
00000031099701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP18931237Sept. 2, 2026, 2 a.m.
00000031099801U1PREV WELL# 218. ADP18931238Sept. 2, 2026, 2 a.m.
00000031100000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 2402 . ADP18931239Sept. 2, 2026, 2 a.m.
00000031199301 CANCELLED PER PLUG STATUS. PJJ18931240Sept. 2, 2026, 2 a.m.
00000031199401 D-5 90 DAYS E-MAIL 070601 JWE18931241Sept. 2, 2026, 2 a.m.
00000031199402 OP E-MAIL REQ:KERR-MCGEE OIL & GAS ONSHORE LLC RESPECTFULLY JWE18931242Sept. 2, 2026, 2 a.m.
00000031199403 REQUEST A 90-DAY EXTENSION FROM THE DATE OF THIS LETTER FOR JWE18931243Sept. 2, 2026, 2 a.m.
00000031199404 EXTENSION OF VIOLATION OF SWR 46 FOR THE SUBJECT WELL.KERR-MJWE18931244Sept. 2, 2026, 2 a.m.
00000031199405 CGEE HAS AN APPROVED RRC FORM W-3A (APPROVAL DATE 06/01/01) JWE18931245Sept. 2, 2026, 2 a.m.
00000031199406 ON FILE WITH THE RRC DISTRICT 01 OFFICE IN SAN ANTONIO AND CJWE18931246Sept. 2, 2026, 2 a.m.
00000031199407 URRENTLY HAS AN ACTIVE PLUGGING RIG IN THE SUBJECT FIELD. BJWE18931247Sept. 2, 2026, 2 a.m.
00000031199408 WSMU #2402 IS ONE OF 27 WELLS TO BE PLUGGED AND ABANDONED INJWE18931248Sept. 2, 2026, 2 a.m.
00000031199409 THE CURRENT PROJECT JWE18931249Sept. 2, 2026, 2 a.m.
00000031199501 CERT. LTR 061901 JWE18931250Sept. 2, 2026, 2 a.m.
00000031199601 H5/RAD (UNSTABLE TEST) LTR 042401 JWE18931251Sept. 2, 2026, 2 a.m.
00000031199701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP18931252Sept. 2, 2026, 2 a.m.
00000031199801U1*OUR RECORDS SHOW 1854' FNL & 2065' FWL ADP18931253Sept. 2, 2026, 2 a.m.
00000031199802U2PREV WELL #242. ADP18931254Sept. 2, 2026, 2 a.m.
00000031199803S1H-1 5350-5400'; H-10 5450-5486' 5/22/87 PS ADP18931255Sept. 2, 2026, 2 a.m.
00000031200000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 261 . ADP18931256Sept. 2, 2026, 2 a.m.
00000031299801U1DUPLICATE OF LSE 04421 WELL 2601 AS PER H-10 - MF ADP18931257Sept. 2, 2026, 2 a.m.
00000031300000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 2802 . ADP18931258Sept. 2, 2026, 2 a.m.
00000031399701 FR-APT CXV18931259Sept. 2, 2026, 2 a.m.
00000031399801U1PREV WELL# 282.//PLUGGED ON WB REMARKS.//IM ADP18931260Sept. 2, 2026, 2 a.m.
00000031399802S1AMEND PERMIT INTERVAL TO 5360-5386'.RVAL TO 5360-5386'. ADP18931261Sept. 2, 2026, 2 a.m.
00000031399803U2CANC PER PLUGGED STATUS//IM ADP18931262Sept. 2, 2026, 2 a.m.
00000031399901M1D100 011593 SCR;CPSEV 042293 SCR.OP LTR 101393 W/W3 REQ CANCADP18931263Sept. 2, 2026, 2 a.m.
00000031399902M2AUTH ROUTED TO MF 102093RV. ADP18931264Sept. 2, 2026, 2 a.m.
00000031400000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 2808 . ADP18931265Sept. 2, 2026, 2 a.m.
00000031499501 FR-APT CXV18931266Sept. 2, 2026, 2 a.m.
00000031499601 CANCEL INJECTION PERMIT PER PLUGGED STATUS. TRH18931267Sept. 2, 2026, 2 a.m.
00000031499701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP18931268Sept. 2, 2026, 2 a.m.
00000031499801U1PREV WELL# 288. ADP18931269Sept. 2, 2026, 2 a.m.
00000031499802S1AMEND INTERVAL TO 5350-5460'. ADP18931270Sept. 2, 2026, 2 a.m.
00000031500000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 3002 . ADP18931271Sept. 2, 2026, 2 a.m.
00000031599701 FR-APT CXV18931272Sept. 2, 2026, 2 a.m.
00000031599801U1PREV. WELL NO 302 ADP18931273Sept. 2, 2026, 2 a.m.
00000031599802U2PLUGGED ON WB REMARKS.//IM CANCELLED PER PLUG STATUS//IM ADP18931274Sept. 2, 2026, 2 a.m.
00000031599901M1D100 011593 SCR;CPSEV 042293 SCR.OP LTR 102893 W/W3 DATED ADP18931275Sept. 2, 2026, 2 a.m.
00000031599902M2101493 REQ CANC AUTH ROUTED TO MF 110193RV. ADP18931276Sept. 2, 2026, 2 a.m.
00000031600000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 3604 . ADP18931277Sept. 2, 2026, 2 a.m.
00000031699701 FR-APT CXV18931278Sept. 2, 2026, 2 a.m.
00000031699801U1PREV WELL# 364.//PLUGGED ON WB REMARKS.//IM ADP18931279Sept. 2, 2026, 2 a.m.
00000031699802S1AMEND INTERVAL TO 5350-5475' 5/7/87 PS. ADP18931280Sept. 2, 2026, 2 a.m.
00000031699803U2CANC PER PLUGGED STATUS.//IM ADP18931281Sept. 2, 2026, 2 a.m.
00000031699901M1D100 011593 SCR;CPSEV 042293 SCR.OP LTR 110193 W/W3 DATED ADP18931282Sept. 2, 2026, 2 a.m.
00000031699902M2101293 REQ CANC ROUTED TO MF 110593RV. ADP18931283Sept. 2, 2026, 2 a.m.
00000031700000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 3901 . ADP18931284Sept. 2, 2026, 2 a.m.
00000031799501 FR-APT CXV18931285Sept. 2, 2026, 2 a.m.
00000031799601 CANCELED PER PLUG STATUS. PJJ18931286Sept. 2, 2026, 2 a.m.
00000031799701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP18931287Sept. 2, 2026, 2 a.m.
00000031799801U1PREV WELL# 391. ADP18931288Sept. 2, 2026, 2 a.m.
00000031799901M1D100/H-10 040989PS. ADP18931289Sept. 2, 2026, 2 a.m.
00000031799902M2H10; ANNP; 032290 BA. PER OP LTR, PTST 112989, FILED LATE. ADP18931290Sept. 2, 2026, 2 a.m.
00000031800000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 4303 . ADP18931291Sept. 2, 2026, 2 a.m.
00000031899301 INCO H5; NO 200 PSIG PRESSURE DIFFERENTIAL H-518931292Sept. 2, 2026, 2 a.m.
00000031899401 INCO; 18B BLANK MXA18931293Sept. 2, 2026, 2 a.m.
00000031899501 MITF H-5 H-518931294Sept. 2, 2026, 2 a.m.
00000031899601 FR-APT CXV18931295Sept. 2, 2026, 2 a.m.
00000031899701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP18931296Sept. 2, 2026, 2 a.m.
00000031899801U1PREV WELL# 433. ADP18931297Sept. 2, 2026, 2 a.m.
00000031900000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 4402 . ADP18931298Sept. 2, 2026, 2 a.m.
00000031999401 FR-APT CXV18931299Sept. 2, 2026, 2 a.m.
00000031999501 CANCEL INJECTION PERMIT PER PLUGGED STATUS. TRH18931300Sept. 2, 2026, 2 a.m.
00000031999601 RECVD H10 CYCLE:96/97....ATTACHED W/W3 DTD: 11/21/95.// IXM18931301Sept. 2, 2026, 2 a.m.
00000031999701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP18931302Sept. 2, 2026, 2 a.m.
00000031999801U1PREV WELL# 442. ADP18931303Sept. 2, 2026, 2 a.m.
00000031999802S1AMEND PERMIT TO 5350-5442' 5/22/87 PS ADP18931304Sept. 2, 2026, 2 a.m.
00000032000000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 4601 . ADP18931305Sept. 2, 2026, 2 a.m.
00000032099301 ENTERED W-3 DATE=05/10/2021 JXL18931306Sept. 2, 2026, 2 a.m.
00000032099302 CHANGED H-10 STATUS TO 7 JXL18931307Sept. 2, 2026, 2 a.m.
00000032099401 ENTERED W-3 DATE=05/10/2021 JXL18931308Sept. 2, 2026, 2 a.m.
00000032099402 CHANGED H-10 STATUS TO 7 JXL18931309Sept. 2, 2026, 2 a.m.
00000032099501 MITF H-5 H-518931310Sept. 2, 2026, 2 a.m.
00000032099601 FR-APT CXV18931311Sept. 2, 2026, 2 a.m.
00000032099701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP18931312Sept. 2, 2026, 2 a.m.
00000032099801U1PREV WELL# 461. ADP18931313Sept. 2, 2026, 2 a.m.
00000032099802S1BUQW FROM TWC LETTER OF 12/14/84; #5454 ADP18931314Sept. 2, 2026, 2 a.m.
00000032200000 PERMITTED: BIG WELLS (SAN MIGUEL) 04421 4901 . ADP18931315Sept. 2, 2026, 2 a.m.
00000032299101 CANCELED PER PLUG STATUS. PJJ18931316Sept. 2, 2026, 2 a.m.
00000032299201 D100-MITF SSG18931317Sept. 2, 2026, 2 a.m.
00000032299301 OP EMAIL DATED 032205 RPTS WILL PA & REQ 30 DAYS TO RXV18931318Sept. 2, 2026, 2 a.m.
00000032299302 FILE W3A/E-D13 90D 032305RV. RXV18931319Sept. 2, 2026, 2 a.m.
00000032299401 DST OFF EMAIL DATED 030805 RPTS: RXV18931320Sept. 2, 2026, 2 a.m.
00000032299402 DDIE LICHTENBERGER WITH TEXAS AMERICAN RESOURCES COMPANY RXV18931321Sept. 2, 2026, 2 a.m.
00000032299403 (844344) CALLED REGARDING TWO H-5'S HE HAD PERFORMED IN RXV18931322Sept. 2, 2026, 2 a.m.
00000032299404 DISTRICT 01 ON THE BIG WELLS/SAN MIGUEL UNIT LEASE (04421) RXV18931323Sept. 2, 2026, 2 a.m.
00000032299405 WELLS NO. 4620 AND 4901. APPARENTLY THE PAPERWORK NEVER RXV18931324Sept. 2, 2026, 2 a.m.
00000032299406 MADE IT TO AUSTIN AND WE HAVE NO RECORD OF IT AT THE RXV18931325Sept. 2, 2026, 2 a.m.
00000032299407 DISTRICT. JUST TO LET YOU KNOW, THE TESTS WERE PERFORMED RXV18931326Sept. 2, 2026, 2 a.m.
00000032299408 AND WITNESSED BY OUR FIELD INSPECTOR ON JANUARY 12, 2005 RXV18931327Sept. 2, 2026, 2 a.m.
00000032299409 WITH WELL NO. 4620 PASSING AND WELL NO. 4901 FAILING. TEXASRXV18931328Sept. 2, 2026, 2 a.m.
00000032299410 AMERICAN IS CURRENTLY LOOKING FOR THE PAPERWORK. RXV18931329Sept. 2, 2026, 2 a.m.
00000032299501 OP RPTS RPTS RCVD LTR C/O DST OFF RE MITF REF WELL NO. 4901,RXV18931330Sept. 2, 2026, 2 a.m.
00000032299502 OP RPTS WILL WORKOVER OR PA ASAP. RXV18931331Sept. 2, 2026, 2 a.m.
00000032299601 FR-APT CXV18931332Sept. 2, 2026, 2 a.m.
00000032299701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP18931333Sept. 2, 2026, 2 a.m.
00000032299801U1PREV WELL# 491. ADP18931334Sept. 2, 2026, 2 a.m.
00000032299802S1BUQW FROM TWC LETTER OF 12/14/84; #5454. ADP18931335Sept. 2, 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.

cntl_no

varchar

Sampled
50K
Distinct
6.2K
  • 000002193 185
  • 000002187 162
  • 000002195 160
  • 000002191 158
  • 000002188 157
  • 000002182 156
  • 000002181 156
  • 000002186 154
  • 000002184 154
  • 000002192 154
  • 000002183 153
  • 000002194 152

row_no

int4

Sampled
50K
Distinct
50K
  • 18966928 1
  • 18936535 1
  • 18962520 1
  • 18957198 1
  • 18937685 1
  • 18953673 1
  • 18966716 1
  • 18966339 1
  • 18963269 1
  • 18976385 1
  • 18968731 1
  • 18980020 1

remark_text

varchar

Sampled
50K
Distinct
36.7K
  • 99701 H-10 MAILED JANUARY 11, 1996 FOR MONTH(S) 01/95 - 03/95. ADP 435
  • 99701 CANCEL INJECTION PERMIT PER PLUGGED STATUS. TRH 349
  • 99901 CANCEL INJECTION PERMIT PER PLUGGED STATUS. TRH 315
  • 99801 CANCEL INJECTION PERMIT PER PLUGGED STATUS. TRH 237
  • 99701 FR-APT CXV 192
  • 99801U1DOC 24 041687 MP. ADP 191
  • 99701 CANCEL DISPOSAL PERMIT PER PLUGGED STATUS. TRH 142
  • 99601 FR-APT CXV 114
  • 99601 CANCEL INJECTION PERMIT PER PLUGGED STATUS. TRH 104
  • 99901 CANCEL DISPOSAL PERMIT PER PLUGGED STATUS. TRH 104
  • 00000 HISTORICAL WELL, NO PERMIT FOUND ANYWHERE, NEVER PERMITTED. MAF 92
  • 99801S1FR-APT & WKLY TCAM; PRES GRAD >.5 PSI/FT ADP 88

ingested_at

timestamptz

Sampled
50K
Distinct
14
  • Sept. 2, 2026, 2:01 a.m. 4.7K
  • Sept. 2, 2026, 2 a.m. 4.3K
  • Sept. 2, 2026, 2:01 a.m. 4.3K
  • Sept. 2, 2026, 2 a.m. 4.3K
  • Sept. 2, 2026, 2:02 a.m. 4.2K
  • Sept. 2, 2026, 2 a.m. 4.2K
  • Sept. 2, 2026, 2:01 a.m. 4.2K
  • Sept. 2, 2026, 2:01 a.m. 4.1K
  • Sept. 2, 2026, 2:02 a.m. 4K
  • Sept. 2, 2026, 2:02 a.m. 3.8K
  • Sept. 2, 2026, 2:02 a.m. 3.7K
  • Sept. 2, 2026, 2:02 a.m. 2.3K

Take it away

Back to everything we know about UIC Permit Remarks