home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

34 rows where City = "Coral Gables"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)

Registration_Number 11

  • Kelley Swofford Roy, Inc. 10
  • Pearson Sandor Associates 5
  • Bruce Rubin Associates, Inc. 4
  • Curacao Tourist Board, Coral Gables 3
  • Samuel B. Crispin & Associates, Inc. 3
  • Balsera Communications 3
  • Patino & Associates, P.A. 2
  • Samuel B. Crispin & Associates, Inc. 1
  • Jamaica Reservation Service 1
  • Navarro, Ana 1
  • Western Hemisphere Strategies, LLC 1

Registrant_Name 10

  • Kelley Swofford Roy, Inc. 10
  • Pearson Sandor Associates 5
  • Bruce Rubin Associates, Inc. 4
  • Samuel B. Crispin & Associates, Inc. 4
  • Balsera Communications 3
  • Curacao Tourist Board, Coral Gables 3
  • Patino & Associates, P.A. 2
  • Jamaica Reservation Service 1
  • Navarro, Ana 1
  • Western Hemisphere Strategies, LLC 1

State 1

  • FL 34

City 1

  • Coral Gables · 34 ✖
Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
99 99   2012-01-12 Diaz-Balart Lincoln Western Hemisphere Strategies, LLC 6086 2012-01-12 Western Hemisphere Strategies, LLC 999 Ponce de Leon Blvd. Suite 520 Coral Gables FL 33134
565 565   2021-03-12 Brewster Jr. James Walter Patino & Associates, P.A. 6937 2021-03-12 Patino & Associates, P.A. 113 Almeria Avenue   Coral Gables FL 33134
566 566   2021-03-12 Patino Ralph Patino & Associates, P.A. 6937 2021-03-12 Patino & Associates, P.A. 113 Almeria Avenue   Coral Gables FL 33134
2775 2775 1997-01-01 1996-12-03 Helmke Mark Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
5080 5080 1991-01-31 1978-08-09 Martin F. R. Jamaica Reservation Service 2941 1978-08-09 Jamaica Reservation Service 1320 South Dixie Highway   Coral Gables FL 33146
5593 5593 2021-01-31 2020-06-13 Ligorria Julio Balsera Communications 6835 2020-06-13 Balsera Communications 2199 Ponce De Leon Blvd #200 Coral Gables FL 33134
8733 8733 1980-03-01 1980-02-07 Tocabens Tania C. Pearson Sandor Associates 2924 1978-07-03 Pearson Sandor Associates 1450 Madruga Avenue Suite 405 Coral Gables FL 33146
14741 14741 1998-04-30 1996-04-04 Hulce Roberta Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
14742 14742 1998-04-30 1996-04-04 Kelley Susan P. Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
14743 14743 1998-04-30 1996-04-04 Madariaga Monica Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
14744 14744 1998-04-30 1996-04-04 Roy William P. Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
14791 14791 1998-04-30 1996-12-03 Wolfe Jack Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
15452 15452 1997-05-01 1997-01-31 de Tobon Clemencia I. Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
15453 15453 1997-05-01 1997-02-13 Arango Yezid A. Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
15744 15744 1982-05-05 1978-07-03 Arau Barbara Pearson Sandor Associates 2924 1978-07-03 Pearson Sandor Associates 1450 Madruga Avenue Suite 405 Coral Gables FL 33146
15745 15745 1982-05-05 1978-07-03 Pearson David Pearson Sandor Associates 2924 1978-07-03 Pearson Sandor Associates 1450 Madruga Avenue Suite 405 Coral Gables FL 33146
15746 15746 1982-05-05 1978-07-03 Sandor Gary M. Pearson Sandor Associates 2924 1978-07-03 Pearson Sandor Associates 1450 Madruga Avenue Suite 405 Coral Gables FL 33146
15747 15747 1982-05-05 1980-07-08 Hernandez Olga Pearson Sandor Associates 2924 1978-07-03 Pearson Sandor Associates 1450 Madruga Avenue Suite 405 Coral Gables FL 33146
18040 18040 2008-05-31 2008-01-10 Navarro Ana Navarro, Ana 5847 2008-01-10 Navarro, Ana 1215 Country Club Prado   Coral Gables FL 33134
19196 19196 1997-06-10 1997-01-07 Nelson R. Reid Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
19198 19198 1997-06-10 1996-12-03 Silves Lamont L. Kelley Swofford Roy, Inc. 5104 1996-04-04 Kelley Swofford Roy, Inc. 355 Palermo Avenue   Coral Gables FL 33134
26467 26467 2020-08-11 2020-06-13 Duckenfield David Balsera Communications 6835 2020-06-13 Balsera Communications 2199 Ponce De Leon Blvd #200 Coral Gables FL 33134
29612 29612 1978-09-12 1976-09-15 Crispin Samuel B. Samuel B. Crispin & Associates, Inc. 2720 1976-09-15 Samuel B. Crispin & Associates, Inc. 464 South Dixie Highway   Coral Gables FL 33146
30102 30102 2020-09-19 2020-06-13 Balsera Alfredo J Balsera Communications 6835 2020-06-13 Balsera Communications 2199 Ponce De Leon Blvd #200 Coral Gables FL 33134
38287 38287 1984-12-14 1984-12-14 Babl Rich Bruce Rubin Associates, Inc. 3635 1984-12-14 Bruce Rubin Associates, Inc. 2655 Le Jeune Road Suite 203 Coral Gables FL 33134
38288 38288 1984-12-14 1984-12-14 Haber Geri Bruce Rubin Associates, Inc. 3635 1984-12-14 Bruce Rubin Associates, Inc. 2655 Le Jeune Road Suite 203 Coral Gables FL 33134
38289 38289 1984-12-14 1984-12-14 Rubin Bruce S. Bruce Rubin Associates, Inc. 3635 1984-12-14 Bruce Rubin Associates, Inc. 2655 Le Jeune Road Suite 203 Coral Gables FL 33134
38290 38290 1984-12-14 1984-12-14 Sparaga Bonnie Bruce Rubin Associates, Inc. 3635 1984-12-14 Bruce Rubin Associates, Inc. 2655 Le Jeune Road Suite 203 Coral Gables FL 33134
39974 39974 1975-12-31 1972-03-09 Vinck C.R. Curacao Tourist Board, Coral Gables 2324 1972-03-02 Curacao Tourist Board, Coral Gables 495 Biltmore Way Suite 408 Coral Gables FL 33134
39980 39980 1975-12-31 1973-06-18 Murray Sigrid E. Curacao Tourist Board, Coral Gables 2324 1972-03-02 Curacao Tourist Board, Coral Gables 495 Biltmore Way Suite 408 Coral Gables FL 33134
39990 39990 1975-12-31 1974-09-30 Van Grieken Rose Marie Curacao Tourist Board, Coral Gables 2324 1972-03-02 Curacao Tourist Board, Coral Gables 495 Biltmore Way Suite 408 Coral Gables FL 33134
40342 40342 1985-12-31 1982-12-01 Abascal Delia Samuel B. Crispin & Associates, Inc. 3424 1982-12-01 Samuel B. Crispin & Associates, Inc. 464 South Dixie Highway Suite 200 Coral Gables FL 33146
40343 40343 1985-12-31 1982-12-01 Crispin Charles C. Samuel B. Crispin & Associates, Inc. 3424 1982-12-01 Samuel B. Crispin & Associates, Inc. 464 South Dixie Highway Suite 200 Coral Gables FL 33146
40344 40344 1985-12-31 1982-12-01 Crispin Samuel B. Samuel B. Crispin & Associates, Inc. 3424 1982-12-01 Samuel B. Crispin & Associates, Inc. 464 South Dixie Highway Suite 200 Coral Gables FL 33146

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_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 · Queries took 380.999ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows