FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

7 rows where City = "Miami Beach" and State = "FL"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

City 1

  • Miami Beach · 7 ✖
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
519 1948-03-22 1949-03-05 Dunbaugh, Frank Montgomery   1101 Lincoln Road   Miami Beach FL  
952 1956-05-21 1956-09-30 Public Relations Associates International   1900 Purdy Avenue   Miami Beach FL  
1703 1964-03-24 1964-09-24 Marger, Edwin   763 Arthur Godfrey Road   Miami Beach FL  
2337 1972-04-25 1973-03-19 Aruba Information Center, Miami   407 Lincoln Road   Miami Beach FL 33139
5720 2005-11-02 2005-11-02 Global Strategic Communications Group, LLC   945 Michigan Avenue Suite #8 Miami Beach FL 33139
6692 2019-06-24 2019-12-31 CYPARIS   5 Island Avenue, 3H   Miami Beach FL 33139
7211 2023-01-01   RMT SPV LLC   1521 Alton Rd 210   Miami Beach FL 33139

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])
);