FARA_All_Registrants

List of all registrant data (active and terminated)

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

21 rows where City = "Dallas"

View and edit SQL

Suggested facets: Business_Name, Address_2, Zip, Registration_Date (date), Termination_Date (date)

State

City

  • Dallas · 21
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
895 1955-06-14 1956-12-14 Grant Advertising, Inc.   2003 Davis Building   Dallas TX  
1836 1964-12-17 1966-03-24 Spanish National Tourist Office, Dallas   1418 Commerce Street   Dallas TX 75201
1857 1965-02-16 1985-10-22 Mexican Government Tourism Office, Dallas   2 Turtle Creek Village Suite 1416 Dallas TX 75219
2348 1972-07-03 1995-03-31 Japan National Tourist Organization, Dallas   2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
2369 1972-08-15 1988-07-21 Sauermann, Donald J. Sauermann Productions 3508 Greenville Avenue Suite 20 Dallas TX 75206
2652 1976-01-16 1996-07-16 Korea Trade Center, Dallas   12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
2816 1977-07-28 1977-07-28 Sanders & Associates Advertising & Public Relations   5025 North Central Expressway Suite 2030 Dallas TX 75205
2818 1977-08-03 1978-12-31 Unicorp International, Inc.   4835 LBJ Freeway Suite 630 Dallas TX 75234
2820 1977-08-08 2003-03-24 JETRO, Dallas (Japan External Trade Organization)   2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
2971 1978-10-19 1984-11-14 Far East Trade Service, Inc., Dallas Branch Office   2050 Stemmons Freeway W.T.C. 110, P.O. Box 58007 Dallas TX 75258
3369 1982-05-13 1985-07-19 Kilgore & Kilgore, Inc.   1800 InterFirst One   Dallas TX 75202
3841 1986-06-06 1994-03-02 Santa Fe (U.S. Holdings) Inc.   Two Lincoln Centre 5420 LBJ Freeway, Suite 1100 Dallas TX 75240-2648
4078 1987-12-22 1989-03-21 E. Bruce Harrison Company/Southwest, Inc.   7920 Beltline Road Suite 340 Dallas TX 75240
4285 1989-09-05 1993-08-02 About My Father's Business, Inc.   Post Office Box 226554   Dallas TX 752226554
4732 1992-11-06 1993-11-19 Cathey, Hutton & Associates, Inc.   2711 LBJ Freeway Suite 560 Dallas TX 75234
4868 1993-11-10 1993-11-30 DeBello, Yirgu Megerssa   7100 San Mateo Blvd. Apt. 212 Dallas TX 75223-1083
4984 1995-01-04 1998-01-31 Lau, Louis Yiu-Luen   14850 Quorum Drive Suite 130 Dallas TX 75240
5109 1996-05-28 1996-06-30 Levenson, Levenson & Hill, Inc. Levenson Public Relations 600 North Pearl Street Suite 910 Dallas TX 75201
5571 2003-08-05 2003-08-27 Winstead Sechrest & Minick P.C.   5400 Renaissance Tower 1201 Elm Street Dallas TX 75270
5725 2005-12-27 2006-12-31 Allyn & Company   3232 McKinney Avenue Suite 660 Dallas TX 75204
6778 2019-12-31   Insignias Global, LLC   3522 Prescott Avenue   Dallas TX 75219

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)
);
Powered by Datasette · Query took 32.026ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history