First 100 rows

Out of roughly 7.2K rows in texas.r3_plant. Version obs-31dc63321fde.

First 100 rows of texas.r3_plant, 20 columns wide
districtserial_nodistrict_codeplant_idoperator_nocounty_codeplant_nameplant_typeavg_intake_capacityoffshorephone_area_codephone_prefixphone_suffixplant_fieldsr3_yyyymmr5_yyyymmr5_statuslast_r3_yyyymmdelinquent_letter_dateletter_type
2039nullnull675982291PRAXAIRG0N2818022781nullnullnullFnullnull0
2040nullnull00nullnull0null0000000000nullnullnull0nullnull0
2041nullnull00nullnull0null0000000000nullnullnull0nullnull0
2042nullnull00nullnull0null0000000000nullnullnull0nullnull0
2043nullnull00nullnull0null0000000000nullnullnull0nullnull0
2044nullnull00nullnull0null0000000000nullnullnull0nullnull0
2045nullnull00nullnull0null0000000000nullnullnull0nullnull0
2046nullnull00nullnull0null0000000000nullnullnull0nullnull0
0190101-000925709713JOURDANTON GAS PLANTG19275N5128872594JOURDANTON, IMOGENE & CHARLOTTE195101198404F198502null0
01930101-0093845650311LOMA ALTAO10000N7137593951LOMA ALTA195310nullF198304null0
012100101-021013042613FASHINGO100000N2419876347EDWARDS LIME195807nullF201106null0
012240101-022425510413FASHINGG23080N7139897221FASHING195812200608F200805null0
012290101-0229100797163WEST BIG FOOTO30000N9187283030WEST BIG FOOT & BIG FOOT195901nullF202308null0
012430101-0243125948311ROOS AREA CENTRALO30000N2815783388CAMPANA, SOUTH (7900' WX); CAMPANA, COUTH (8900')195904nullF199912null0
012450101-0245340176163BIG FOOT COMPRESSION FACILITYO247N7132419068BIG FOOT195904197905F200404Aug. 8, 20073
012510101-02512934013FASHING GASOLINE PLANTG25000N5127803665FASHING (EDWARDS LIME)195905198810F198810null0
012530101-0253255104311STAT 004/TILDENO65440N7139897221VARIOUS195906nullnull201805null0
012540101-0254534237163JONES COMPRESSORO1000N2149532178BIG FOOT195907nullF199108null0
012880101-0288252058311SAN MIGUEL CREEKO15000N7136568669SAN MIGUEL CREEK196101nullF200403null0
013060101-0306712396323CHITTIM GASOLINE PLANTG5000N3182220026SACATOSA PENA CREEK196103199602F200207null0
013190101-031916859163MARTHA BERRY PLANTG22000N7139787700WEST BIG FOOT & BIG FOOT196807198905F198912null0
013440101-0344701613311J. C. DILWORTHO28361N5125793590DILWORTH196308nullnull201712Nov. 28, 20181
013560101-035625336829SAN MARTING98343N7133816500VARIOUS196807202111A201805null0
014200101-0420844110311HOSTETTER SEPARATIONO492N5129933510HOSTETTER196609nullF198603null0
014260101-0426679278311BRAZIL SEPAR FACO500N5128877007BRAZIL & S. W. BRAZIL196704nullF199907null0
014520101-0452253368127SAN ANTONIOO0N7133811377VARIOUS196901nullF200806null0
014550101-0455640880311E. RHODE RANCH SEP FAC. #2O10000N2147883384E. RHODE RANCH196807nullF199503null0
014570101-0457253329127BIG WELLS GAS PLANTO33660N7133816500BIG WELLS (SAN MIGUEL) & (SAN MIGUEL) LO. E.197106nullA201805null0
014580101-0458509750127SOLDIER'S LAKEO1096N7136272970B-13 HUNNICUTT ALMOS INDIAN MOUND197208nullFnullnull0
014650101-0465172230127PENA CREEK ADSORPTION UNITG5000N5128840421PENA CREEK197409198009F198202null0
014670101-0467348725127686 DRIP STATIONG859N5128765541MAIN TRANSMISSION LINE197405198901F199011null0
014690101-046925319613JOURDANTONO13776N5128872676JOURDANTON197308nullF199705null0
014710101-0471425640137ROCKSPRINGS PLANTG23909N7136584657VARIOUS197312198601F198707null0
014740101-0474348610127PENA CREEK COMPRESSORO0N5128765541PENA CREEK197401nullF199011null0
014750101-0475161631323DRIP STATIONO0N5128762825CHITTIM197501nullF200202null0
014780101-0478224990127MCLEAN-BOWMAN "B"G488N5125757486BIG WELLS (SAN MIGUEL) (SAN MIGUEL, LO. E.)197507199109F199303null0
014800101-0480656600127DIMMIT COUNTY PLANTO10000N5123344128BOWERS RANCH197604nullF198307null0
014870101-048720249155LULING GAS PLANTG12000N4326826311SPILLER, DUNLAP, BRANYON, DARST, SALT FLAT197611201502F201704null0
014880101-0488212300127CATARINA DRIP STATIONO871N5128828411CATARINA197612nullF198511null0
014900101-0490886261163DOERING RANCH PLANTO385N3618823046DOERING RANCH197701nullF200808null0
014910101-0491348610127FEE DRIP STATIONO0N5128765541MAIN TRANSMISSION LINE197702198901F201205null0
014990101-0499845062283LA SALLE COUNTYO5000N8177381917WEST STUART CITY197708nullF199503null0
015000101-0500143750507THOMPSON DEHYDRATIONO3000N7136542755PEARSALL197708nullF198703null0
015010101-0501143750127JONES DEHYDRATIONO3000N7136542755PEARSALL197708nullF198703null0
015020101-0502571535331MAIN DRIP STATIONS 1,2,3,4,& 5O0N7133636965N/A196709nullF199410null0
015060101-0506202491163PEARSALLG5559N4326826311PEARSALL197703nullF201107Dec. 3, 20129
015070101-0507640150163SW PEARSALL GAS GATHERING SYSTEMO2500N7136298111PEARSALL197708198101F200612null0
015140101-05143397163FOUR CORNERSO361N7132280228PEARSALL197709198508F198808null0
015150101-0515143750127BIG WELLS 6" P/LO0N5128837483PEARSALL197801nullF198502null0
015170101-0517829293127ROCKY CREEKO33000N5129947059ROCKY CREEK (GEORGETOWN )197811198109F198802null0
015180101-0518539915177BOOTH COMPRESSORO800N7134659310MAG FIELD-TRANSOCEAN (12) TAMARACK (1)197807nullF198003null0
015210101-0521154792323MAVERICK COUNTY PLANTO25000N9156821176LOS CUATROS(LOWER),PALOMA, LOS CUATROS (GLEN ROSE)197906nullF198805null0
015270101-0527161337127WINTER GARDEN CENTRAL FAC.O3500N5126982555WINTER GARDEN198005nullF199406null0
015330101-0533204863177PEACH CREEKG0N9156826311VARIOUS198009199510F199602null0
015370101-0537154792323TEJASO25000N9153363379VARIOUS198101nullF198209null0
015390101-0539253368127CARRIZO SPRINGS COMPRESSOR STAT.O3N8326765341VARIOUS198102nullF201607null0
015400101-0540212300127COCHINA RANCH DRIP STATIONO1176N5127247191JESSUS CARDINAS SURVEY, ABSTRACT 2198103nullF199406null0
015410101-0541404550177DUBOSE SCRUBBER NURSEYO0N7138533056VARIOUS198103nullF198702null0
015420101-0542154792163FRIO COUNTY PLANTO5000N9153363379VARIOUS198104nullF198111null0
015500101-0550293097127SAN PEDRO STRIPPING PLANTG2500N8177660193FITZSIMONS198104198307F198501null0
015510101-0551881269255HOBSON COMP.O0N5122992240VARIOUS198103nullF198206null0
015520101-0552829293323MAVERICK COUNTY PLANTO254N5128815116SERBANnullnullF198304null0
015530101-0553139864127BLAKEWAY COMPRESSOR FACILITYO500N7137507563BLAKEWAY (DIXON) & BLAKEWAY (STRICKLAND)198107nullF199604null0
015540101-0554455354493WILSON COUNTY #1G3000N5126729724VARIOUS198306198801F199302null0
015550101-0555253368127PETTY RANCH M/L TRANSMISSIONO0N7133811377VARIOUS198106nullF200806null0
016140101-0614296715163KINLAW #1G50N5128297155PEARSALL199010nullF199011null0
015560101-0556354987137EDWARDS CO. COMPRESSOR STATIONO0N9156820301ROCKSPRINGS, WEST (CANYON)198105nullF198812null0
015570101-055780272913WEST JOURDANTON COMPRESSORO1000N5125907824WEST JOURDANTON198111nullF198807null0
015580101-0558778502331ROCKDALEG5000N7136547033VARIOUS198202199611F199912null0
015590101-0559204830493WILSON COUNTY # 2G2000N9156826311VARIOUS198207198801F198805null0
015600101-0560614500507ZAVALA OPERATING DISTRICTO0N5123764495VARIOUS198209nullF198307null0
015610101-0561564745373ACKER 4"O0N7139633140VARIOUS198301nullF199506null0
015620101-0562404520311MCMULLENO15000N8326681173AWP (OLMOS)198303200602Fnullnull0
015630101-056357255013JOURDANTON GAS SALESO5000N5127989701JOURDANTON198305nullF199003null0
015640101-0564627860323ALLIGATOR NO. 1G1400N2143866618CHITTIM198306198304F198710null0
015650101-0565767958127BOWERS RANCH TREATING PLANTO2500N5126470088BOWERS198308nullF199208null0
015660101-0566367880311SOUTH TEXAS SYNDICATEO2000N5128888288BIG MULE (5000')198309nullF199205null0
015670101-056748354493WILSON COUNTY PLANTO0N5123408343HASSE (BUDA) & HIGGINS N. E.198212nullF198312null0
015680101-0568253368127DIMMIT COMPRESSORO0N8326765341VARIOUS198404nullnull201806Dec. 3, 20129
015690101-056941173913EAST PLEASANTON GATHERING PLANTO300N5123583752PLEASANTON E. (EDWARDS) AND GEORGETOWN198406nullF199106null0
015700101-057089117513JOURDANTON TREATING FACILITYG13000N8173352222JOURDANTON, IMOGENE, CHARLOTTE & HORN198406nullF199907null0
015710101-0571774720311DIAMONDBACK PLANTG2000N5126632461AWP OLMOS198406198610F198610null0
015720101-05725552521BATEMAN GAS PLANT VENTUREG1000N5128216194BATEMAN (AUSTIN CHALK)198407198603F198710null0
015730101-0573862798311LA JOLLAO6500N7137393405LA JOLLA RANCH E (SLIGO)198407nullF199207null0
015750101-0575774720163BIG FOOT MINI GAS PLANTG500N5125274043BIG FOOT198505199004F199203null0
015760101-0576554240311MAIN TRANSMISSION LINE DRIPO0N2149799010AWP (OLMOS)198506nullF199803null0
015770101-0577222226323CHITTIM COMPRESSOR STATIONO2848N3612905678CHITTIM(5600), (BUDA), (4900), (5000)198505nullnullnullNov. 28, 20181
015780101-0578875431479GATES RANCH DEHY. FAC. #5O12000N2148913332CATARINA, SW. (OLMOS); (SAN MIGUEL - GAS)198503198702F200110null0
015790101-0579875431127GATES RANCH DEHY. FAC. #2O10000N2148913332CATARINA, SW. (OLMOS); (SAN MIGUEL - GAS)198505nullF200110null0
015800101-0580614500465VAL VERDE GATHERING SYSTEMO0N9158532370VINEGARONE198510nullF199702null0
015810101-058125201755PRAIRIE LEA COMPRESSOR STATIONO0N7137589820VARIOUS198601nullnull201806null0
015820101-0582125993163SHINER RANCHG600N2146613526DILLY198602198809F198901null0
015830101-0583627860323BARCLAY COMPRESSOR STATIONO1000N2143866618CHITTIM198601nullF199802null0
015840101-0584840948311LITCHENBERGERO12789N5128840731A W P198601nullF199312null0
015850101-0585822810493STOCKDALE COMPRESSOR STATIONO2000N5126729724STOCKDALE CARRIZO; ACLETO CREEK(POTH SAND);MAX198511nullF199306null0
015860101-0586255353493CINDY ANN DRIP TANKO500N7136229981CINDY ANN (AUSTIN CHALK)198612nullF199204null0
015870101-0587174017323CHITTIM/BARCLAYO882N3617593130CHITTIM198707nullnull201704Nov. 28, 20181
015880101-0588844118311BRAVO PLANTO900000N5129933510HOSTETTER198802nullF199302null0
015890101-0589386310311SCOTT #2 DEHYDRATORO75000N7132092400BONNE TERRE (10,600); BONNE TERRE (10,970)198806nullF201301null0
015900101-059040798311WEST RHODE RANCH COMPRESSOR FACO125N9189257588WEST RHODE RANCH198802nullF200201null0

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.

district

varchar

Sampled
7.2K
Distinct
13
  • 06 1.2K
  • 04 1.1K
  • 03 1K
  • 02 720
  • 10 681
  • 01 545
  • 08 437
  • 09 409
  • 14 405
  • 05 329
  • 13 186
  • 11 92

serial_no

int2

Sampled
7.2K
Distinct
3.8K
  • 945 7
  • 755 6
  • 919 6
  • 573 6
  • 1005 6
  • 1039 6
  • 1001 5
  • 1003 5
  • 966 5
  • 935 5
  • 951 5
  • 768 5

district_code

varchar

Sampled
7.2K
Distinct
12
Empty
0.0064
  • 06 1.2K
  • 04 1.1K
  • 03 1K
  • 02 720
  • 08 681
  • 01 545
  • 7B 437
  • 7C 409
  • 10 405
  • 05 329
  • 09 186
  • 8A 92

plant_id

varchar

Sampled
7.2K
Distinct
7.1K
Empty
0.0064
  • 01-0897 1
  • 01-0837 1
  • 7C-0381 1
  • 7B-0678 1
  • 03-1481 1
  • 01-0253 1
  • 10-0582 1
  • 06-2749 1
  • 05-2300 1
  • 03-0317 1
  • 7B-0861 1
  • 04-4006 1

operator_no

int4

Sampled
7.2K
Distinct
1.8K
  • 253162 186
  • 253368 138
  • 252017 131
  • 404520 123
  • 386310 107
  • 255104 87
  • 109333 77
  • 212300 76
  • 564710 71
  • 561136 68
  • 945936 60
  • 601108 57

county_code

int2

Sampled
7.2K
Distinct
209
  • 479 285
  • 365 231
  • 401 222
  • 203 221
  • 389 174
  • 371 135
  • 215 134
  • 297 125
  • 201 121
  • 127 118
  • 283 118
  • 255 115

plant_name

varchar

Sampled
7.2K
Distinct
6.9K
Empty
0.0064
  • NONE 28
  • MAIN LINE DRIP 8
  • DRIP STATION 6
  • SWD 6
  • COMPRESSOR STATION 6
  • DRIP 4
  • WASKOM 4
  • DRIPS 3
  • MADISONVILLE 3
  • NORTH PORT NECHES 3
  • TIJERINA 3
  • HEYSER 3

plant_type

varchar

Sampled
7.2K
Distinct
4
Empty
0.0063
  • O 6.1K
  • G 987
  • C 21
  • P 19

Take it away

Back to everything we know about R-3 Gas Processing Plants (EBCDIC, retired)