First 100 rows

Out of roughly 6.3K rows in texas.r3_report. Version 20260804T015858Z.

First 100 rows of texas.r3_report, 19 columns wide
report_monthreport_r3_keysource_fileview_profile_request_keyfacility_keyserial_numberdistrict_codeserial_nofacility_nameplant_typer3_plant_idcid_criticalperiod_yyyymmperiod_month_namelatitudelongitudeplant_average_capacitydistrict_reportedcounty
20250829667r3dataload-august-2025.zip14092968892006-2718062718HANCOCK #1OthernullNO202507July30.00000000-100.000000000.000006 - KilgorePANOLA
20250829668r3dataload-august-2025.zip14093368891906-2728062728PAGE COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000006 - KilgorePANOLA
20250829669r3dataload-august-2025.zip14094868586906-2572062572SUSAN HARRIS C POthernullNO202507July32.47162900-94.142402000.000006 - KilgoreHARRISON
20250829670r3dataload-august-2025.zip14095068588006-3024063024SWIFT WSL SALES COMMON POINTOthernullNO202507July32.44890100-94.183741000.000006 - KilgoreHARRISON
20250829671r3dataload-august-2025.zip14096468893206-2881062881SOUTH DEADWOOD COMPRESSOROthernullNO202507July30.00000000-100.000000000.000006 - KilgorePANOLA
20250829672r3dataload-august-2025.zip14096868892906-2897062897ACGC GARY COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000006 - KilgorePANOLA
20250829673r3dataload-august-2025.zip14099268520808-3452083452STERLING COUNTY GATH SYSOthernullNO202507July31.88400000-101.176400000.000008 - MidlandSTERLING
20250829674r3dataload-august-2025.zip1410216917517C-03877C387UNIVERSITY BLOCK 54 COMP STATIONOthernullNO202506June30.96843900-101.853536000.00007C - San AngeloCROCKETT
20250829675r3dataload-august-2025.zip14099668893410-1272101272BRITT #1 NORTHOthernullNO202507July30.00000000-100.000000000.000010 - PampaWHEELER
20250829676r3dataload-august-2025.zip1410266917477C-04197C419CINCO TERRY STABILIZERNatural GasolinenullNO202506June30.87302800-101.246667000.00007C - San AngeloCROCKETT
20250829677r3dataload-august-2025.zip14102468893510-1273101273BRITT #2 WESTOthernullNO202507July30.00000000-100.000000000.000010 - PampaWHEELER
20250829678r3dataload-august-2025.zip1410286917467C-04187C418BLOCK 46 STABILIZERNatural GasolinenullNO202506June30.91195800-101.313878000.00007C - San AngeloCROCKETT
20250829679r3dataload-august-2025.zip14105668893610-1274101274BRITT #3 SOUTHOthernullNO202507July30.00000000-100.000000000.000010 - PampaWHEELER
20250829680r3dataload-august-2025.zip14106669149204-4170044170EAST LA GRULLA CDPOthernullNO202507July26.32929000-98.623083000.000004 - Corpus ChristiSTARR
20250829681r3dataload-august-2025.zip14107269149304-4254044254LA SAL VIEJA DRIPOthernullNO202507July26.47468400-97.833934000.000004 - Corpus ChristiWILLACY
20250829682r3dataload-august-2025.zip14107869150004-4008044008LOMA BLANCO DELIVERY STATIONOthernullNO202507July26.36444400-98.696111000.000004 - Corpus ChristiSTARR
20250829683r3dataload-august-2025.zip14108069149804-3895043895SANTA FE DRIP STATIONOthernullNO202507July26.81418200-98.069610000.000004 - Corpus ChristiBROOKS
20250829684r3dataload-august-2025.zip14108269149504-4202044202SHEERIN GU E CDP DRIP STATIONOthernullNO202507July26.27333300-98.706111000.000004 - Corpus ChristiSTARR
20250829685r3dataload-august-2025.zip14108668893710-1275101275BRITT #4 EASTOthernullNO202507July30.00000000-100.000000000.000010 - PampaWHEELER
20250829686r3dataload-august-2025.zip14108769149104-4134044134STARRPO MINERALS CDP DRIP STATIOOthernullNO202507July26.30594000-98.717510000.000004 - Corpus ChristiSTARR
20250829687r3dataload-august-2025.zip14109068893810-1276101276HORN COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000010 - PampaWHEELER
20250829688r3dataload-august-2025.zip1411086918197C-04477C447BULLHEAD COMPRESSOROthernullNO202507July31.34800000-101.402400000.00007C - San AngeloIRION
20250829689r3dataload-august-2025.zip14113669196108-3961083961MONGOOSE PLANTOthernullNO202507July32.42242500-101.171070000.000008 - MidlandMITCHELL
20250829690r3dataload-august-2025.zip14114368610202-082202822NORTH FANNIN COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000002 - San AntonioGOLIAD
20250829691r3dataload-august-2025.zip14114668610102-082702827PETTUS DRIP STATIONOthernullNO202506June30.00000000-100.000000000.000002 - San AntonioBEE
20250829692r3dataload-august-2025.zip14114868611104-4064044064FS-6 COMPRESSOR & DRIP STATIONOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiZAPATA
20250829693r3dataload-august-2025.zip14115068893910-1277101277HUFF COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000010 - PampaWHEELER
20250829694r3dataload-august-2025.zip14115768894010-1278101278WHEELER COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000010 - PampaWHEELER
20250829695r3dataload-august-2025.zip14115669187106-3102063102FM 1637OthernullNO202507July32.92910600-94.391633000.000006 - KilgoreCASS
20250829696r3dataload-august-2025.zip14116169187206-3103063103GIVENS COMPRESSOR STATIONOthernullNO202507July32.95390600-94.386375000.000006 - KilgoreCASS
20250829697r3dataload-august-2025.zip14116369187306-3104063104LINDEN LOCKETT COMPRESSOR STATIOOthernullNO202507July32.99019100-94.376471000.000006 - KilgoreCASS
20250829698r3dataload-august-2025.zip14121569196108-3961083961MONGOOSE PLANTOthernullNO202507July32.42242500-101.171070000.000008 - MidlandMITCHELL
20250829699r3dataload-august-2025.zip14122069038206-2855062855ELLIS CP DRIPOthernullNO202507July30.00000000-100.000000000.000006 - KilgoreHARRISON
20250829700r3dataload-august-2025.zip14122369038106-2871062871WOODLAWN WEST DRIP 1OthernullNO202507July30.00000000-100.000000000.000006 - KilgoreHARRISON
20250829701r3dataload-august-2025.zip14122868853502-068302683KENEDY COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000002 - San AntonioKARNES
20250829702r3dataload-august-2025.zip14123568596002-090102901CFS/LO COMP STATOthernullNO202507July30.00000000-100.000000000.000002 - San AntonioLIVE OAK
20250829703r3dataload-august-2025.zip14123668595902-093002930RUNGE COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000002 - San AntonioDE WITT
20250829704r3dataload-august-2025.zip14124268848904-3501043501FREER COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiDUVAL
20250829705r3dataload-august-2025.zip14124369153704-3697043697CALLAGHAN ROAD COMPRESSOROthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829706r3dataload-august-2025.zip14124669153904-3985043985LOBO BMT STATIONOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829707r3dataload-august-2025.zip14125269154504-4256044256TEMPLE STATIONOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829708r3dataload-august-2025.zip14125468850203-1290031290SAN FELIPE SITEOthernullNO202507July30.00000000-100.000000000.000003 - HoustonAUSTIN
20250829709r3dataload-august-2025.zip14125668851003-072403724KATY SITEOthernullNO202507July30.00000000-100.000000000.000003 - HoustonAUSTIN
20250829710r3dataload-august-2025.zip14125768894110-1313101313BRISCOE CDPOthernullNO202507July30.00000000-100.000000000.000010 - PampaHEMPHILL
20250829711r3dataload-august-2025.zip14132268599702-1175021175OAKVILLE STATIONOthernullNO202507July28.46921500-98.077430000.000002 - San AntonioLIVE OAK
20250829712r3dataload-august-2025.zip14132169117906-2628062628HARDWOOD DRIPOthernullNO202507July30.00000000-100.000000000.000006 - KilgoreHARRISON
20250829713r3dataload-august-2025.zip14135068613810-1146101146MISC. FIELD LIQUID TERMINALOthernullNO202507July30.00000000-100.000000000.000010 - PampaHANSFORD
20250829714r3dataload-august-2025.zip14135368613810-1146101146MISC. FIELD LIQUID TERMINALOthernullNO202506June30.00000000-100.000000000.000010 - PampaHANSFORD
20250829715r3dataload-august-2025.zip1414686895868A-01648A164WPMT NGL PLANTNatural GasolinenullNO202507July30.00000000-100.000000000.00008A - LubbockGAINES
20250829716r3dataload-august-2025.zip1414716895898A-01558A155ANTELOPE GAS TREATING FACOthernullNO202507July30.00000000-100.000000000.00008A - LubbockGAINES
20250829717r3dataload-august-2025.zip1414096895918A-01398A139DENVER UNIT CO2 RECOV. PLT.CyclingnullNO202507July30.00000000-100.00000000140000.00008A - LubbockYOAKUM
20250829718r3dataload-august-2025.zip14172269078006-2973062973OAK HILL DRIP POINTOthernullNO202203March32.34587100-94.538710000.000006 - KilgoreRUSK
20250829719r3dataload-august-2025.zip14172569077406-2717062717WHITEHEAD DRIP POINTOthernullNO202203March32.07923300-94.869639000.000006 - KilgoreRUSK
20250829720r3dataload-august-2025.zip14177969117806-2649062649SW WOODLAWN DRIPOthernullNO202507July30.00000000-100.000000000.000006 - KilgoreHARRISON
20250829721r3dataload-august-2025.zip1416376863917C-03637C363PHILLIPS GATHERING SYSTEMOthernullNO202507July30.00000000-100.000000000.00007C - San AngeloCROCKETT
20250829722r3dataload-august-2025.zip14178369117706-2900062900HARDWOOD BELL DRIPOthernullNO202507July30.00000000-100.000000000.000006 - KilgoreHARRISON
20250829723r3dataload-august-2025.zip1418176901817B-06757B675BAILESOthernullNO202507July30.00000000-100.000000000.00007B - AbileneTHROCKMORTON
20250829724r3dataload-august-2025.zip1418286901817B-06757B675BAILESOthernullNO202506June30.00000000-100.000000000.00007B - AbileneTHROCKMORTON
20250829725r3dataload-august-2025.zip1418376861327C-00197C19OZONA GAS PROCESSING PLANTNatural GasolinenullNO202507July30.67395300-101.2055890060000.00007C - San AngeloCROCKETT
20250829726r3dataload-august-2025.zip14201269144202-097102971NUESTRA-DCP DELIVERY POINTOthernullNO202508August28.67802600-97.492000000.000002 - San AntonioGOLIAD
20250829727r3dataload-august-2025.zip14201569144402-1240021240AMINE/SCHENDEL/PATTON DRIP STATIOthernullNO202508August28.69068600-97.324000000.000002 - San AntonioGOLIAD
20250829728r3dataload-august-2025.zip14202868871601-087001870SAGE CREEK PIPELINE LLCOthernullNO202507July30.00000000-100.000000000.000001 - San AntonioDIMMIT
20250829729r3dataload-august-2025.zip14203369198206-3101063101TRINITY GAS STORAGEOthernullNO202507July31.90374000-95.921460000.000006 - KilgoreANDERSON
20250829730r3dataload-august-2025.zip14206068584201-092601926WEST RHODE RANCH DRIP FACILITYOthernullNO202507July30.00000000-100.000000000.000001 - San AntonioMCMULLEN
20250829731r3dataload-august-2025.zip14206968584301-093601936WEST RHODE RANCH DEHYOthernullNO202507July30.00000000-100.000000000.000001 - San AntonioMCMULLEN
20250829732r3dataload-august-2025.zip14215969081308-3832083832LOVING GAS PLANTNatural GasolinenullNO202507July30.00000000-100.000000000.000008 - MidlandLOVING
20250829733r3dataload-august-2025.zip14073568908706-2194062194KEY PRODUCTION #1OthernullNO202507July31.98889200-94.13673100210.000006 - KilgorePANOLA
20250829734r3dataload-august-2025.zip14218868584904-4096044096BMT #9OthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829735r3dataload-august-2025.zip14219368585004-4113044113SCHWARZ MALAKOFF COMP STATIONOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829736r3dataload-august-2025.zip14219468726303-051603516STATION 809OthernullNO202507July30.00000000-100.000000000.000003 - HoustonMATAGORDA
20250829737r3dataload-august-2025.zip14219768584504-4230044230RANCHO BLANCO COMPRESSOR STATIONOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829738r3dataload-august-2025.zip14220368584604-4246044246BMT WEST DRIP FACILITYOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829739r3dataload-august-2025.zip14223369194608-4019084019WCSOthernullNO202507July31.31432200-103.341005000.000008 - MidlandREEVES
20250829740r3dataload-august-2025.zip14224369194508-4027084027RBN COMPRESSOR STNOthernullNO202507July31.24788600-103.274758000.000008 - MidlandREEVES
20250829741r3dataload-august-2025.zip14224769195108-4024084024HP GAS HANDLING STATIONOthernullNO202507July31.28510700-103.361383000.000008 - MidlandREEVES
20250829742r3dataload-august-2025.zip14224969194808-4021084021BOPCSOthernullNO202507July31.37277400-103.427241000.000008 - MidlandREEVES
20250829743r3dataload-august-2025.zip14225169195008-4023084023HAGGIS CSOthernullNO202507July31.26832400-103.468104000.000008 - MidlandREEVES
20250829744r3dataload-august-2025.zip14225369194308-4025084025NE COMPRESSOR STATIONOthernullNO202507July31.28510700-103.361383000.000008 - MidlandREEVES
20250829745r3dataload-august-2025.zip14228969118206-3096063096LONGVIEW DEHYOthernullNO202507July32.47318800-94.573887000.000006 - KilgoreHARRISON
20250829746r3dataload-august-2025.zip14229269194908-4022084022CENTRAL JUNCTION CSOthernullNO202507July31.23954000-103.444014000.000008 - MidlandREEVES
20250829747r3dataload-august-2025.zip14229669033510-1194101194SHELTON DRIP FACILITYOthernullNO202507July30.00000000-100.000000000.000010 - PampaCARSON
20250829748r3dataload-august-2025.zip14229769033810-1220101220HERRING A&B DRIP FACILITYOthernullNO202507July30.00000000-100.000000000.000010 - PampaHUTCHINSON
20250829749r3dataload-august-2025.zip14230069033710-1191101191HERRING A DRIP FACILITYOthernullNO202507July30.00000000-100.000000000.000010 - PampaHUTCHINSON
20250829750r3dataload-august-2025.zip14230169033610-1190101190FEELAND DRIP FACILITYOthernullNO202507July30.00000000-100.000000000.000010 - PampaCARSON
20250829751r3dataload-august-2025.zip1423436898297B-09737B973HARRIER DRIP SYSTEMOthernullNO202406June30.00000000-100.000000000.00007B - AbileneHOOD
20250829752r3dataload-august-2025.zip14246669045606-2458062458E.N.SMITH DRIP PTOthernullNO202507July30.00000000-100.000000000.000006 - KilgoreHARRISON
20250829753r3dataload-august-2025.zip14247668493608-4000084000CHEROKEE COMPRESSOR STATIONOthernullNO202507July31.04741400-103.737427000.000008 - MidlandREEVES
20250829754r3dataload-august-2025.zip14249268989308-3904083904PIGPEN COMPRESSOR STATIONOthernullNO202507July31.80850000-104.064000000.000008 - MidlandCULBERSON
20250829755r3dataload-august-2025.zip14249868989508-3959083959JAMES COMPRESSOR STATIONOthernullNO202507July31.74196600-104.083501000.000008 - MidlandCULBERSON
20250829756r3dataload-august-2025.zip14249968989408-3905083905TYSON COMPRESSOR STATIONOthernullNO202507July31.69640000-104.095000000.000008 - MidlandCULBERSON
20250829757r3dataload-august-2025.zip14250168584804-4252044252CLARK 4 DRIP FACILITYOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829758r3dataload-august-2025.zip14250368585104-4293044293HUBBERD STATIONOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829759r3dataload-august-2025.zip14250468650008-3998083998CASH COMPRESSOR STATIONOthernullNO202507July31.94454300-103.577975000.000008 - MidlandLOVING
20250829760r3dataload-august-2025.zip14250668585204-4294044294MARTIN STATIONOthernullNO202507July30.00000000-100.000000000.000004 - Corpus ChristiWEBB
20250829761r3dataload-august-2025.zip14250768648108-3774083774COVER COMPRESSOR STATIONOthernullNO202507July31.35896100-103.619790000.000008 - MidlandREEVES
20250829762r3dataload-august-2025.zip14251268539505-2380052380LARUE GATHERING SYSTEMOthernullNO202504April30.00000000-100.0000000060.000005 - KilgoreHENDERSON
20250829763r3dataload-august-2025.zip14253668650608-3928083928SIDEWINDER COMPRESSOR STATIONOthernullNO202507July31.37912300-103.286191000.000008 - MidlandREEVES
20250829764r3dataload-august-2025.zip1425396899657B-06417B641INEZ MALESOthernullNO202504April30.00000000-100.000000005000.00007B - AbilenePARKER
20250829765r3dataload-august-2025.zip14254368648408-3776083776TYCOON COMPRESSOR STATIONOthernullNO202507July31.36710500-103.387980000.000008 - MidlandREEVES
20250829766r3dataload-august-2025.zip14254968649208-3834083834SOOL COMPRESSOR STATIONOthernullNO202507July31.45590000-103.599000000.000008 - MidlandREEVES

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.

report_month

int4

Sampled
6.3K
Distinct
12
  • 202605 1K
  • 202603 766
  • 202606 653
  • 202511 638
  • 202601 524
  • 202607 520
  • 202509 479
  • 202512 465
  • 202604 383
  • 202602 355
  • 202510 318
  • 202508 134

report_r3_key

text

Sampled
6.3K
Distinct
6.3K
  • 38632 1
  • 31007 1
  • 38711 1
  • 38548 1
  • 34793 1
  • 36743 1
  • 34884 1
  • 45445 1
  • 41847 1
  • 45328 1
  • 41711 1
  • 38682 1

facility_key

text

Sampled
6.3K
Distinct
1.4K
  • 691040 31
  • 687353 19
  • 688299 18
  • 686953 17
  • 691375 17
  • 687661 16
  • 687364 16
  • 684936 15
  • 688702 15
  • 691903 14
  • 687660 14
  • 687659 14

serial_number

text

Sampled
6.3K
Distinct
1.4K
  • 03-1370 31
  • 03-1388 19
  • 10-0049 18
  • 8A-0182 17
  • 7C-0473 17
  • 01-0689 16
  • 01-0935 16
  • 04-4291 15
  • 08-4000 15
  • 01-0650 14
  • 01-0942 14
  • 06-2660 14

district_code

text

Sampled
6.3K
Distinct
12
  • 08 1.3K
  • 01 1.1K
  • 06 1K
  • 02 717
  • 04 715
  • 03 455
  • 7C 281
  • 10 233
  • 05 211
  • 7B 132
  • 8A 76
  • 09 75

serial_no

int4

Sampled
6.3K
Distinct
1.3K
  • 1370 31
  • 935 24
  • 1388 19
  • 49 18
  • 473 17
  • 1071 17
  • 182 17
  • 951 16
  • 1061 16
  • 689 16
  • 969 16
  • 4000 15

period_yyyymm

int4

Sampled
6.3K
Distinct
35
  • 202509 604
  • 202603 597
  • 202601 555
  • 202508 539
  • 202510 530
  • 202512 493
  • 202602 475
  • 202604 471
  • 202606 460
  • 202511 401
  • 202507 356
  • 202605 286

source_file

text

Sampled
6.3K
Distinct
12
  • r3dataload-may-2026.zip 1K
  • r3dataload-march-2026.zip 766
  • r3dataload-june-2026.zip 653
  • r3dataload-november-2025.zip 638
  • r3dataload-january-2026.zip 524
  • r3dataload-july-2026.zip 520
  • r3dataload-september-2025.zip 479
  • r3dataload-december-2025.zip 465
  • r3dataload-april-2026.zip 383
  • r3dataload-february-2026.zip 355
  • r3dataload-october-2025.zip 318
  • r3dataload-august-2025.zip 134

Take it away

Back to everything we know about R-3 Gas Processing Plants (JSON)