List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

118 rows where State = "TX"

View and edit SQL

State

Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
6464 2017-09-15 2018-10-12 Baker Botts, LLP   910 Louisiana Street   Houston TX 77002-4995
6527 2018-02-20   Law Office of David B. Kultgen   11841 Overlook Pass   Austin TX 78738
6625 2019-01-07   Pakistan Tehreek-E-Insaf USA, LLC   7207 Regency Square Blvd. Suite 247 Houston TX 77036
6669 2019-04-25 2019-11-20 Hulsen Media Services LLC   2400 Laramie Trail   Austin TX 78745
6672 2019-05-06   McGinnis Lochridge   600 Congress Avenue Suite 2100 Austin TX 78701
6677 2019-05-10 2019-05-17 Network Companies, LLC   907 Ranch Road 620 South Suite 302 Lakeway TX 78734
6682 2019-05-19   Linden Government Solutions, LLC   5120 Woodway Drive Suite 5004 Houston TX 77056
6700 2019-07-12   Clout Public Affairs, LLC   1001 Congress Avenue Suite 100 Austin TX 78701
6751 2019-11-19   Untermeyer, Charles Graves   10000 Memorial Drive Suite 920 Houston TX 77024
6770 2019-12-17   Frinzi, James N.   3736 Bee Cave Road Suite 1-164 Austin TX 78746
6778 2019-12-31 2020-06-30 Insignias Global, LLC   3522 Prescott Avenue   Dallas TX 75219
6804 2020-03-20   Bridge Builder Communications   7518 Awty School Lane   Houston TX 77055
6808 2020-03-27 2020-08-14 TrailRunner International LLC   600 N. Carroll Ave., Suite 100   Southlake TX 76092
6921 2021-02-02 2021-02-02 Cumber, Sada   6202 Duke Trail Lane   Sugar Land TX 77479
6948 2021-04-15   Gerger Hennessy & McFarlane LLP   1001 Fannin Street Suite 2450 Houston TX 77002
6954 2021-04-30   CITGO Petroleum Corporation ("CPC")   1293 Eldridge Parkway   Houston TX 77077
6955 2021-04-30   CITGO Holding, Inc. ("CITGOH")   1293 Eldridge Parkway   Houston TX 77077
6956 2021-04-30   PDV Holding, Inc. ("PDVH")   1293 Eldridge Parkway   Houston TX 77077

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);