First 100 rows

Out of roughly 78.2K rows in texas.operators. Version 20260726T233124Z.

idnamep5_statusorg_typeaddress1address2citystatezipphonedate_builtdate_inactiveingested_at
454093KELDON OIL COMPANYIAP.O. BOX 6129nullABILENETX796083256911021Feb. 3, 1989Jan. 31, 1992July 26, 2026, 6:30 p.m.
802622SOUTH OAK TRANSPORTS INC.IAPO BOX 28nullWILSONOK734635806685633Sept. 19, 2005June 29, 2007July 26, 2026, 6:31 p.m.
454100KELLAR, R. O.IIADDRESS UNKNOWNnullUNKNOWNXX99999nullJan. 1, 1970Oct. 6, 1983July 26, 2026, 6:30 p.m.
887530VOSKAMP EXPLORATION, INC.IAP O BOX 80381nullMIDLANDTX797084326991622July 23, 1986Aug. 30, 2011July 26, 2026, 6:31 p.m.
888057WFS-OFFSHORE GATHERING COMPANYIAATTN C HARRISPO BOX 645 WRC 3-4TULSAOK741019185730809Oct. 18, 1995Aug. 31, 2006July 26, 2026, 6:31 p.m.
890725WAGGONER & ZELLERIISTREET ADDRESS UNKNOWNnullUNKNOWNXX99999nullnullApril 29, 2005July 26, 2026, 6:31 p.m.
454365KEESEE OIL & GAS*************P5IC5407 N. IH 35, STE 400nullAUSTINTX787235124520673April 12, 1984April 30, 1984July 26, 2026, 6:30 p.m.
454390KELLEY, COY H., JR.ICHCR 1 BOX 3nullSPEARMANTX790818066592938July 26, 1985June 4, 1994July 26, 2026, 6:30 p.m.
454400KELLEY, LAWRENCE J.IC919 AMERICANA BLDG.nullHOUSTONTX770027136589533July 13, 1979May 31, 1983July 26, 2026, 6:30 p.m.
454500KELLEY, NELLIE VIRGINIAIF520 WICHITA TOWERnullWICHITA FALLSTX763018177237771July 13, 1979May 29, 1987July 26, 2026, 6:30 p.m.
454540KELLEY PRODUCTION COMPANYIAPO DRAWER CCnullFREERTX783575123946887July 13, 1979Feb. 29, 2012July 26, 2026, 6:30 p.m.
454550KELLEY, SAMMYICMEDLIN CHAPEL RD., BOX 114-AnullGRAHAMTX764508175495245Dec. 10, 1980May 28, 1982July 26, 2026, 6:30 p.m.
454553KELLEY, TOM INVESTMENTSICP.O. BOX 1318nullMANCHACATX786525122800401March 7, 1991Feb. 28, 1992July 26, 2026, 6:30 p.m.
454570KELLI-RAY CORP.IABOX 1036nullNOTREESTX797594328273642Sept. 14, 1977May 31, 1984July 26, 2026, 6:30 p.m.
454590KELLOGG CO.ICBOX 3007nullAMARILLOTX791168063528121July 25, 1979May 31, 1986July 26, 2026, 6:30 p.m.
454595KELLOGG, STEPHEN C.IC1326 SUMMERWOODnullRICHARDSONTX750819722314619Nov. 1, 1988Oct. 31, 1989July 26, 2026, 6:30 p.m.
454600KELLOGG, WALTERIC5100 WESTHEIMER, SUITE 195nullHOUSTONTX770567138400892Aug. 16, 1983July 31, 1986July 26, 2026, 6:30 p.m.
454620KELLOIL, INC.IAP O BOX 123409nullFORT WORTHTX76121-34098173770044Dec. 28, 1979May 31, 2002July 26, 2026, 6:30 p.m.
892004WALKER OIL AND GAS LTDABPO BOX 1004nullSNYDERTX795503252070274Nov. 15, 2017nullJuly 26, 2026, 6:31 p.m.
100A-1 CASING PULLERS, INC.IIBOX 5324nullWICHITA FALLSTX76307nullnullnullJuly 26, 2026, 6:30 p.m.
454640KELLUM, J. KENT OIL & GAS CO.ICRT. 4, BOX 465nullABILENETX79601-97134326848263June 13, 1985May 31, 1986July 26, 2026, 6:30 p.m.
454650KELLY-BARNETT PETROLEUM, INC.IA2004 QUAIL CREEK DR. #300nullWICHITA FALLSTX763088176961277Jan. 21, 1983Dec. 31, 1987July 26, 2026, 6:30 p.m.
454655KELLY-BEISCH & HANNA, INC.IAP.O. BOX 637nullOLNEYTX763748175645681May 19, 1980May 31, 1985July 26, 2026, 6:30 p.m.
454660KELLY-BROCKIC4836 DEXTER AVENUEnullFORT WORTHTX761077136580414Jan. 19, 1979Feb. 29, 2016July 26, 2026, 6:30 p.m.
454665KELLY-BROCK & CHADII1420 AMERICANA BLDG.nullHOUSTONTX77002nullnullnullJuly 26, 2026, 6:30 p.m.
454667KELLY-NORRIS OPERATING CO.ID1101 SCOTT STREETnullWICHITA FALLSTX763018177614147Sept. 29, 1987Aug. 31, 1988July 26, 2026, 6:30 p.m.
454670KELLY, F. F.ICBOX 1095nullSINTONTX783875123641294May 2, 1978June 30, 1993July 26, 2026, 6:30 p.m.
454671KELLY, DUKEICPO BOX 44nullWICKETTTX797884329434163Nov. 30, 1995March 31, 2009July 26, 2026, 6:30 p.m.
454672KELLY OIL CORPORATIONIA715 HAMILTON BLDG.nullWICHITA FALLSTX763018177675161Oct. 4, 1984Oct. 1, 1985July 26, 2026, 6:30 p.m.
454673KELLY PETROLEUMIC1610 MIDWESTERN PARKWAYnullWICHITA FALLSTX763078177677742Dec. 15, 1986Nov. 30, 1987July 26, 2026, 6:30 p.m.
454674KELLY-B-MC OIL COMPANYIDBOX 218nullOLNEYTX763748175645681Nov. 5, 1980May 31, 1985July 26, 2026, 6:30 p.m.
454675KELLY - MC OIL COMPANYICP.O. BOX 218nullOLNEYTX763748175645681March 5, 1980May 31, 1985July 26, 2026, 6:30 p.m.
454676KELLY RESOURCES, LTD.IB2591 DALLAS PKWY STE 207nullFRISCOTX750349727124455Jan. 31, 2003Jan. 31, 2007July 26, 2026, 6:30 p.m.
454685KELLY, MICHAEL V.IC5659 CHEVY CHASEnullHOUSTONTX770567136214412Nov. 3, 1978May 31, 1990July 26, 2026, 6:30 p.m.
454686KELLY BOULEVARDDI3939 N HAMPTON RDnullDALLASTX752122149518489June 13, 2019nullJuly 26, 2026, 6:30 p.m.
454688KELLY OIL CO.IFRT. 3, BOX 162nullOLNEYTX763748175645591July 13, 1979May 31, 1991July 26, 2026, 6:30 p.m.
454689KELLY CREEK LAND & CATTLE CO,INCIA8955 KATY FREEWAY, SUITE 108nullHOUSTONTX770247134673155June 5, 1989May 29, 1992July 26, 2026, 6:30 p.m.
454690KELLY OIL & GAS, INC.IA545 N. UPPER BROADWAY, #504nullCORPUS CHRSTITX784765128837033Dec. 12, 1978May 29, 1992July 26, 2026, 6:30 p.m.
454695KELLY MAHLER OPERATING, LLCAHP O BOX 1925nullGRAHAMTX764509405490131April 13, 2017nullJuly 26, 2026, 6:30 p.m.
454700KELLY & PARKS, OIL LEASESIIDRAWER JnullFREERTX78357nullnullnullJuly 26, 2026, 6:30 p.m.
454710KELLY, RICHARDIC203 STORY LNnullCORSICANATX751109038743573March 17, 1987May 30, 2003July 26, 2026, 6:30 p.m.
454720KELLY, TOMIC9025 WILSHIRE BLVD. #100nullBEVERLY HILLSCA902112132717100Feb. 19, 1988Jan. 31, 1989July 26, 2026, 6:30 p.m.
454770KELMIST CORPORATIONIA2708 HAWKnullMCALLENTX785042106314669July 14, 1989June 30, 1992July 26, 2026, 6:30 p.m.
454825KELO DRLG. CO.IISTREET ADDRESS UNKNOWNnullUNKNOWNXX99999nullApril 12, 1978Aug. 31, 2016July 26, 2026, 6:30 p.m.
454840KELPETRO, INC.IAPO BOX 460048nullHOUSTONTX770567134037408Oct. 22, 1981Jan. 5, 2016July 26, 2026, 6:30 p.m.
455002KENDRICK, BARBARA S.ICATTN PAUL KENDRICK922 W CEDAR BAYOU LYNCH RDBAYTOWNTX775217134592108Feb. 9, 2006June 1, 2023July 26, 2026, 6:30 p.m.
455040KELRAY OIL AND GAS, INC.IAP. O. BOX 2523nullLONGVIEWTX756069032971516Nov. 12, 1985July 31, 1989July 26, 2026, 6:30 p.m.
455045KELSEY OPERATING, INC.IA1127 ELDRIDGE PKWYSUITE 300 365HOUSTONTX770775129545512June 17, 2004May 31, 2025July 26, 2026, 6:30 p.m.
455050KELSEY, HENRY B.IC1601 HOLLYHURST (D-17)nullHOUSTONTX770567136210258June 5, 1979July 1, 1991July 26, 2026, 6:30 p.m.
455070KELSEY, LEWIS O., CORP.IISTREET ADDRESS UNKNOWNnullUNKNOWNXX99999nullnullDec. 30, 2016July 26, 2026, 6:30 p.m.
455071KELSO OIL LLCIHP O BOX 467nullCHASEKS675246209382943April 8, 2004March 31, 2008July 26, 2026, 6:30 p.m.
455072KELTON GAS SERVICES LLCDH1680 WEST HWY 40nullVERNALUT840783039259200Jan. 15, 2019nullJuly 26, 2026, 6:30 p.m.
455073KELT OIL & GAS, INC.IA2850 MONTEREY STnullTORRANCECA905033103283962Jan. 12, 1988April 28, 2000July 26, 2026, 6:30 p.m.
455074KELTON GAS SERVICES, LPDB10077 GROGANS MILL ROAD STE 300nullTHE WOODLANDSTX773803466512788Dec. 18, 2002nullJuly 26, 2026, 6:30 p.m.
455075KELTON OIL & GAS CO.IAP O BOX 426nullWHEELERTX790968068263211Oct. 15, 1981Sept. 30, 1993July 26, 2026, 6:30 p.m.
455076KELTON OIL CORPORATIONIAPOST OFFICE BOX 276nullANDREWSTX79714-02764325246400Dec. 9, 1994Nov. 26, 1997July 26, 2026, 6:30 p.m.
455077KELTON, B.J.IC1410 COUNTY RAOD 58nullROSHARONTX775832815689277Feb. 8, 1995Jan. 31, 2005July 26, 2026, 6:30 p.m.
455080KELTON, DAVE & LINCOLN, W.W.IFBOX 583nullCORSICANATX751109038743035June 14, 1977May 29, 1987July 26, 2026, 6:30 p.m.
455082KEM-GEM INC.IAP O BOX 4668nullWICHITA FALLSTX76308-06688009642039Jan. 10, 1983Feb. 26, 1993July 26, 2026, 6:30 p.m.
455104KEM ENERGY US,LLCIH22136 WESTHEIMER PKWY # 358nullKATYTX774507133768878July 26, 2017July 3, 2018July 26, 2026, 6:30 p.m.
455126KEM ENERGY, INC.AA515 SOUTH FRY ROAD NO. 406nullKATYTX774508324218985Oct. 12, 2015Sept. 28, 2018July 26, 2026, 6:30 p.m.
455170KEMCO OILIC187 CR 109nullALICETX783323616649764Dec. 16, 1987Nov. 30, 2009July 26, 2026, 6:30 p.m.
455171KEMCO RESOURCES, INC.DA1221 SOUTH MAIN ST STE 208nullBOERNETX780062107751750Oct. 11, 2002nullJuly 26, 2026, 6:30 p.m.
455175KEMCO OIL L.L.C.IH187 CR 109nullALICETX783323616649764Nov. 18, 2009Jan. 30, 2015July 26, 2026, 6:30 p.m.
455180KEMICK, JEROME G.ICBOX 492nullANDERSONTX778307135201482Sept. 14, 1977Nov. 26, 2025July 26, 2026, 6:30 p.m.
455185KEMP ENERGY COMPANYIC8440 WALNUT HILL LANE, #800nullDALLASTX752312166962484Dec. 23, 1982Jan. 29, 1988July 26, 2026, 6:30 p.m.
455295KEMP, CHARLES W.IC1701 E. HIGHLAND DR.nullHOBBSNM882405053925364April 8, 1981May 28, 1982July 26, 2026, 6:30 p.m.
455300KEMP, J. D.ICBOX 921nullKILGORETX756629039843443April 10, 1978Sept. 30, 1982July 26, 2026, 6:30 p.m.
455324KEMP, WALTERAC851 COUNTY ROAD 410nullTALPATX768823252809391Nov. 29, 2018Nov. 29, 2018July 26, 2026, 6:30 p.m.
455349KEMP, JAMES STEPHENIC388 PR 4431nullTALPATX768823257232012Feb. 3, 2006March 29, 2024July 26, 2026, 6:30 p.m.
455350KEMP, JAMES E.IIMERCANTILE BK BLDG. 20TH FLOORnullDALLASTX75201nullApril 7, 1978nullJuly 26, 2026, 6:30 p.m.
455351KEMPER OPERATING CO.IC2117 HIGHLAND AVEnullABILENETX79605-61523256980550Feb. 23, 1988May 1, 1996July 26, 2026, 6:30 p.m.
455352KEMP, THE EST. OF JAMES E.IG1717 MAIN ST., SUITE 2440nullDALLASTX752012147415841Jan. 12, 1978May 31, 1990July 26, 2026, 6:30 p.m.
455353KEMP, V. E. JR.ICP.O. BOX 61nullWEATHERFORDTX760868175942612July 20, 1987Nov. 30, 1993July 26, 2026, 6:30 p.m.
455354KEN-AMES CORP.DAP O BOX 1791nullGONZALESTX78629-12912106729724Nov. 14, 1986nullJuly 26, 2026, 6:30 p.m.
455355KEN-TEX CRUDE PRODUCERS, INC.IAPO BOX 230nullPAOLIIN474548127232108Oct. 8, 1992Sept. 30, 2013July 26, 2026, 6:30 p.m.
455356KEN-TEX ENERGY COMPANYIAP. O. BOX 1328nullFRISCOTX750349723779763Sept. 21, 1984Aug. 30, 1985July 26, 2026, 6:30 p.m.
455360KEN-BAR ENERGYIC12796 W FM 2790 S 6nullLA COSTETX780392109853675Nov. 1, 1982Oct. 31, 1994July 26, 2026, 6:30 p.m.
455410KEMPER OPERATING COMPANY, INC.IAPO BOX 7171nullGRANBURYTX760493256688886March 24, 1994Jan. 31, 2018July 26, 2026, 6:30 p.m.
892690WALKER, R.F. & TEEL, THOMAS E.IIADDRESS UNKNOWNnullUNKNOWNXX99999nullJan. 1, 1970Oct. 6, 1983July 26, 2026, 6:31 p.m.
455460KEN GAS OF TEXAS, INC.IA1525 BETSY LNnullIRVINGTX75061-24418062713344Dec. 19, 1988Jan. 29, 1993July 26, 2026, 6:30 p.m.
455560KEN KAR OIL & ROYALTY CORP.IIADDRESS UNKNOWNnullUNKNOWNXX99999nullJan. 1, 1970Oct. 6, 1983July 26, 2026, 6:30 p.m.
455770KEN-CAS OIL CO.ICBOX 1334nullLEVELLANDTX793368068945661Nov. 10, 1981Oct. 30, 1998July 26, 2026, 6:30 p.m.
455771KEN LYONS & COMPANY. LTD.IAPO BOX 1929nullSAN ANGELOTX76902-19293256557107June 21, 2016May 31, 2017July 26, 2026, 6:30 p.m.
455773KEN'S TRANSPORT CO., INC.IAPO BOX 1447nullLEVELLANDTX793368068949744Sept. 20, 1982Oct. 31, 1985July 26, 2026, 6:30 p.m.
455774KEN'S TRANSPORT COMPANYIAP. O. BOX 1447nullLEVELLANDTX793368068947765Feb. 12, 1982Jan. 31, 1984July 26, 2026, 6:30 p.m.
455775KEN PETROLEUM CORPORATIONIA8150 N CENTRAL EXP STE 1200nullDALLASTX752062148918410July 13, 1979Sept. 12, 2019July 26, 2026, 6:30 p.m.
455776KEN-GULL CORP.IAPO BOX 4319nullWICHITA FALLSTX763088176929647April 28, 1981May 28, 1982July 26, 2026, 6:30 p.m.
455777KEN-KAN, INC.IART. 1, BOX 281nullFLATONIATX789415128653790Oct. 25, 1977May 31, 1983July 26, 2026, 6:30 p.m.
455778KENAI OIL AND GAS INC.IA609 E. SPEER BLVD.nullDENVERCO80203-42403038933392Jan. 8, 1980May 31, 1986July 26, 2026, 6:30 p.m.
455779KEN RAVENELL BROKERAGE SRVC LLCIH871 PR 3599nullBIGFOOTTX780058304661631Jan. 17, 2012April 1, 2015July 26, 2026, 6:30 p.m.
455795KENANN CORP. & MITCHELL E.V.IIADDRESS UNKNOWNnullUNKNOWNXX99999nullJan. 1, 1970Oct. 6, 1983July 26, 2026, 6:30 p.m.
455798KENBRO, INC.IA1003 MALLICK TOWERnullFORT WORTHTX761028173351455Jan. 15, 1991Aug. 31, 1994July 26, 2026, 6:30 p.m.
455800KENCO CASING PULLING, INC.IABOX 766nullKILGORETX756629039843136Oct. 14, 1977May 28, 1982July 26, 2026, 6:30 p.m.
455810KENCO ENERGY INC.IAPO BOX 756nullWINNIETX776654092962171Oct. 28, 1980May 31, 1983July 26, 2026, 6:30 p.m.
455825KENCO OIL & GAS PROPERTIESIFP.O. BOX 870965nullDALLASTX752872146965521May 1, 1989April 30, 1991July 26, 2026, 6:30 p.m.
455830KENCO OIL CORPORATIONIA4009 POST OAKnullTYLERTX757019035614914Jan. 29, 1980Aug. 31, 1992July 26, 2026, 6:30 p.m.
455834KENCO PETROLEUM INC.IAP O BOX 167nullSHAMROCKTX790798062562707July 30, 1998June 30, 1999July 26, 2026, 6:30 p.m.
455835KENCO RESOURCES, INC.IA226 SAMUEL BLVD. #4FnullCOPPELLTX750199723932997Dec. 12, 1986Jan. 31, 1991July 26, 2026, 6:30 p.m.
455837KENCOPE ENERGY COMPANIESIAP. O. BOX 583nullGIDDINGSTX789424095423344Jan. 22, 1988Jan. 27, 1988July 26, 2026, 6:30 p.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.

id

int4

Sampled
50K
Distinct
50K
  • 35599 1
  • 167276 1
  • 146688 1
  • 250722 1
  • 300840 1
  • 243212 1
  • 196916 1
  • 596865 1
  • 161180 1
  • 37876 1
  • 159965 1
  • 594100 1

p5_status

bpchar

Sampled
50K
Distinct
4
  • I 39.1K
  • A 6K
  • D 4.9K
  • H 5

org_type

bpchar

Sampled
50K
Distinct
9
  • A 18.5K
  • C 10K
  • H 9K
  • I 5.7K
  • D 3.3K
  • B 1.7K
  • F 1.4K
  • E 213
  • G 184

name

varchar

Sampled
50K
Distinct
50K
  • CJRW OIL & GAS 1
  • DRENNAN & PETERSON, INC. 1
  • H A W INVESTMENT 1
  • AMTEXX ENERGY 1
  • GULFTEX ENERGY II, LP 1
  • GLADIATOR ENERGY LLC 1
  • MOORE & LASITER 1
  • G. & R. OIL ACCOUNT 1
  • G & G ENERGY, INC. 1
  • FLUSCHE, HERB 1
  • COLUMBIA OIL CORP&UNITED ENERGY 1
  • I. B. OIL COMPANY 1

address1

varchar

Sampled
50K
Distinct
36.3K
  • ADDRESS UNKNOWN 1.3K
  • STREET ADDRESS UNKNOWN 1.1K
  • PO BOX 921 116
  • P O BOX 921 69
  • PO BOX 1925 64
  • BOX 747 39
  • P O BOX 1327 38
  • BOX 953 35
  • 1001 LOUISIANA ST 33
  • ATTN DAN SAWYER 33
  • PO BOX 1327 31
  • BOX 1058 27

address2

varchar

Sampled
50K
Distinct
1.7K
Empty
0.9475
  • 1300 MAIN STREET 51
  • SUITE 1000 24
  • 811 LOUISIANA ST 22
  • STE 200 20
  • 200 WEST FOSTER RM 300 19
  • 811 LOUISIANA ST STE 2100 17
  • STE 1000 16
  • STE 300 15
  • SUITE 200 15
  • SUITE 100 14
  • PO BOX 4324 14
  • STE 400 14

city

varchar

Sampled
50K
Distinct
2.1K
Empty
0.0002
  • HOUSTON 5.6K
  • MIDLAND 2.8K
  • DALLAS 2.7K
  • UNKNOWN 2.4K
  • SAN ANTONIO 1.6K
  • ABILENE 1.3K
  • WICHITA FALLS 1.1K
  • FORT WORTH 1.1K
  • AUSTIN 933
  • ODESSA 838
  • GRAHAM 768
  • CORPUS CHRSTI 583

state

bpchar

Sampled
50K
Distinct
54
Empty
0.0019
  • TX 41.6K
  • XX 2.4K
  • OK 1.7K
  • LA 966
  • CO 687
  • NM 583
  • CA 337
  • KS 171
  • AR 104
  • FL 103
  • IL 101
  • MS 94

Take it away

Back to everything we know about P-5 Organization (EBCDIC)