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

15 rows where City = "Coral Gables"

View and edit SQL

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

State

City

  • Coral Gables · 15
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
804 1953-12-03 1957-06-03 Riera-Gomez, Eliseo   4015 Aurora Street   Coral Gables FL  
1480 1961-09-26 1962-03-26 Boothby, Isaac Raymond   1127 Andora Avenue   Coral Gables FL  
1575 1962-10-19 1962-10-19 Freed, Owen S.   255 University Drive   Coral Gables FL  
2324 1972-03-02 1976-07-13 Curacao Tourist Board, Coral Gables   495 Biltmore Way Suite 408 Coral Gables FL 33134
2720 1976-09-15 1978-09-12 Samuel B. Crispin & Associates, Inc.   464 South Dixie Highway   Coral Gables FL 33146
2924 1978-07-03 1982-05-05 Pearson Sandor Associates   1450 Madruga Avenue Suite 405 Coral Gables FL 33146
2941 1978-08-09 1991-01-31 Jamaica Reservation Service   1320 South Dixie Highway   Coral Gables FL 33146
3299 1981-11-05 1982-04-14 Gomez, Ellis Riera   814 Ponce de Leon Boulevard Suite 504 Coral Gables FL 33134
3424 1982-12-01 1985-12-31 Samuel B. Crispin & Associates, Inc.   464 South Dixie Highway Suite 200 Coral Gables FL 33146
3635 1984-12-14 1984-12-14 Bruce Rubin Associates, Inc.   2655 Le Jeune Road Suite 203 Coral Gables FL 33134
3715 1985-08-06 1985-08-21 Ahwee, Ronald A.   4533 Ponce De Leon Boulevard   Coral Gables FL 33146
5104 1996-04-04 1998-04-30 Kelley Swofford Roy, Inc.   355 Palermo Avenue   Coral Gables FL 33134
5847 2008-01-10 2008-05-31 Navarro, Ana   1215 Country Club Prado   Coral Gables FL 33134
5924 2009-03-27 2009-05-01 Spencer, Thomas R.   999 Ponce de Leon Boulevard Suite 510 Coral Gables FL 33134
6086 2012-01-12   Western Hemisphere Strategies, LLC   999 Ponce de Leon Blvd. Suite 520 Coral Gables FL 33134

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 40.368ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history