home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

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

30 rows where Foreign_Principal = "Republic of Haiti"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Registrant_Name 29

  • Chapman, DiSalle & Friedman 2
  • Alexander, Raymond Pace 1
  • Allied Public Relations, Inc. 1
  • Berlanti Overseas Corporation 1
  • Berlanti, Louis J. 1
  • Berle Jr., A.A. 1
  • Brenda Joyce & Associates, Inc. 1
  • Dellums & Associates 1
  • Dellums, Brauer, Halterman & Associates, LLC 1
  • Dunbaugh, Frank Montgomery 1
  • Edelman International Corporation 1
  • Foley Hoag, LLP 1
  • Fouch-Roseboro & Associates 1
  • Garrett & Company 1
  • Global Market Solutions 1
  • Haitian Industries, Inc. 1
  • Jack McDonald Associates, Inc. 1
  • Keesing, John Maurice 1
  • Kurzban, Kurzban, Weinger & Tetzeli, P.A. 1
  • McKinney & McDowell Associates 1
  • Public Relations Associates International 1
  • QORVIS LLC 1
  • Rips, Serge 1
  • Roosevelt, Summers & Hamilton, Inc. 1
  • Shea & Gould 1
  • Stroock & Stroock & Lavan 1
  • Tew Cardenas, LLP 1
  • Walters, Costanzo, Miller & Russell 1
  • van Kloberg & Associates, Ltd. 1

State 3

  • - 24
  • DC 4
  • FL 2

Foreign_Principal 1

  • Republic of Haiti · 30 ✖

Country/Location_Represented 1

  • HAITI 30

City 1

  • - 30
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
874 874 1985-01-01 Republic of Haiti 1983-01-20 HAITI Jack McDonald Associates, Inc. 3038 1979-07-13 Jack McDonald Associates, Inc. Port-au-Prince        
1107 1107 1995-01-06 Republic of Haiti 1992-01-09 HAITI McKinney & McDowell Associates 4516 1991-05-28 McKinney & McDowell Associates Washington     DC  
1284 1284 1986-01-14 Republic of Haiti 1984-08-06 HAITI Garrett & Company 3439 1983-02-03 Garrett & Company Port au Prince        
1298 1298 1959-01-15 Republic of Haiti 1958-10-09 HAITI Allied Public Relations, Inc. 1177 1958-10-09 Allied Public Relations, Inc. Port-au-Prince        
2307 2307 1955-02-09 Republic of Haiti 1955-02-11 HAITI Rips, Serge 500 1947-11-14 Rips, Serge Port-au-Prince        
2722 2722 1967-02-23 Republic of Haiti 1958-09-02 HAITI Chapman, DiSalle & Friedman 867 1955-01-21 Chapman, DiSalle & Friedman Port-au-Prince        
2860 2860 1986-02-26 Republic of Haiti 1984-10-29 HAITI Shea & Gould 3624 1984-10-29 Shea & Gould Port-au-Prince        
3064 3064 2004-02-28 Republic of Haiti 2003-04-24 HAITI Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Palais National Port-au-Prince        
3065 3065 2004-02-28 Republic of Haiti 2003-12-30 HAITI Dellums & Associates 5593 2003-12-30 Dellums & Associates Port au Prince        
3450 3450 1949-03-05 Republic of Haiti 1948-03-22 HAITI Dunbaugh, Frank Montgomery 519 1948-03-22 Dunbaugh, Frank Montgomery Port-au-Prince        
3576 3576 1990-03-10 Republic of Haiti 1990-03-21 HAITI Fouch-Roseboro & Associates 4356 1990-03-21 Fouch-Roseboro & Associates Washington     DC  
3746 3746 1962-03-15 Republic of Haiti 1959-03-19 HAITI Chapman, DiSalle & Friedman 867 1955-01-21 Chapman, DiSalle & Friedman Port-au-Prince        
3783 3783 2004-03-15 Republic of Haiti 1991-12-31 HAITI Kurzban, Kurzban, Weinger & Tetzeli, P.A. 4604 1991-12-31 Kurzban, Kurzban, Weinger & Tetzeli, P.A. Washington     DC  
3964 3964 1961-03-22 Republic of Haiti 1960-09-22 HAITI Berlanti, Louis J. 1393 1960-09-22 Berlanti, Louis J. Port-au-Prince        
9055 9055 1958-07-07 Republic of Haiti 1958-01-07 HAITI Roosevelt, Summers & Hamilton, Inc. 1099 1958-01-01 Roosevelt, Summers & Hamilton, Inc. Port-au-Prince        
9255 9255 1961-07-15 Republic of Haiti 1961-05-01 HAITI Berlanti Overseas Corporation 1380 1960-07-19 Berlanti Overseas Corporation Port-au-Prince        
9599 9599 1959-07-30 Republic of Haiti 1959-01-30 HAITI Haitian Industries, Inc. 1196 1959-01-30 Haitian Industries, Inc. Port-au-Prince        
9949 9949 1950-08-01 Republic of Haiti 1947-01-03 HAITI Berle Jr., A.A. 432 1947-01-03 Berle Jr., A.A. Port-au-Prince        
10977 10977 1986-08-31 Republic of Haiti 1986-12-04 HAITI van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
11910 11910 1956-09-30 Republic of Haiti 1956-05-21 HAITI Public Relations Associates International 952 1956-05-21 Public Relations Associates International Port-au-Prince        
12001 12001 1988-09-30 Republic of Haiti 1986-08-06 HAITI Stroock & Stroock & Lavan 3816 1986-04-22 Stroock & Stroock & Lavan Port-au-Prince        
12139 12139 2002-09-30 Republic of Haiti 2002-02-25 HAITI Global Market Solutions 5475 2002-02-25 Global Market Solutions Port-au-Prince        
12394 12394 2003-10-01 Republic of Haiti 2003-06-10 HAITI Tew Cardenas, LLP 5562 2003-06-10 Tew Cardenas, LLP c/o Ministre de 1'Economie et des Finances Palais de Ministeres Rue Mgr. Guilloux Port-au-Prince        
12614 12614 1983-10-12 Republic of Haiti 1982-03-05 HAITI Walters, Costanzo, Miller & Russell 3343 1982-03-05 Walters, Costanzo, Miller & Russell       FL  
13223 13223 1980-10-31 Republic of Haiti 1978-04-21 HAITI Edelman International Corporation 2548 1974-11-29 Edelman International Corporation Port-au-Prince        
13627 13627 2003-11-01 Republic of Haiti 2001-06-18 HAITI Dellums, Brauer, Halterman & Associates, LLC 5442 2001-06-18 Dellums, Brauer, Halterman & Associates, LLC Port au Prince        
14240 14240 1962-11-25 Republic of Haiti 1958-04-02 HAITI Keesing, John Maurice 1091 1957-11-27 Keesing, John Maurice Port-au-Prince        
15096 15096 1978-12-14 Republic of Haiti 1978-02-23 HAITI Brenda Joyce & Associates, Inc. 2866 1978-02-23 Brenda Joyce & Associates, Inc. Port-au-Prince        
15534 15534 1952-12-31 Republic of Haiti 1947-05-21 HAITI Alexander, Raymond Pace 462 1947-05-21 Alexander, Raymond Pace Port-au-Prince        
16508 16508 2001-12-31 Republic of Haiti 2003-06-04 HAITI QORVIS LLC 5483 2002-03-06 QORVIS LLC Kurzban, Kurzban, Weinger & Tetzeli Plaza 2650, Second Floor 2650 S.W. 27th Avenue Miami 33133     FL  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_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 776.655ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history