FARA_All_ForeignPrincipals

Table actions
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, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 3

Foreign_Principal 1

  • Republic of Haiti · 30 ✖

Country/Location_Represented 1

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
864 864 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        
1097 1097 1995-01-06 Republic of Haiti 1992-01-09 HAITI McKinney & McDowell Associates 4516 1991-05-28 McKinney & McDowell Associates Washington     DC  
1274 1274 1986-01-14 Republic of Haiti 1984-08-06 HAITI Garrett & Company 3439 1983-02-03 Garrett & Company Port au Prince        
1288 1288 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        
2297 2297 1955-02-09 Republic of Haiti 1955-02-11 HAITI Rips, Serge 500 1947-11-14 Rips, Serge Port-au-Prince        
2712 2712 1967-02-23 Republic of Haiti 1958-09-02 HAITI Chapman, DiSalle & Friedman 867 1955-01-21 Chapman, DiSalle & Friedman Port-au-Prince        
2850 2850 1986-02-26 Republic of Haiti 1984-10-29 HAITI Shea & Gould 3624 1984-10-29 Shea & Gould Port-au-Prince        
3054 3054 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        
3055 3055 2004-02-28 Republic of Haiti 2003-12-30 HAITI Dellums & Associates 5593 2003-12-30 Dellums & Associates Port au Prince        
3440 3440 1949-03-05 Republic of Haiti 1948-03-22 HAITI Dunbaugh, Frank Montgomery 519 1948-03-22 Dunbaugh, Frank Montgomery Port-au-Prince        
3565 3565 1990-03-10 Republic of Haiti 1990-03-21 HAITI Fouch-Roseboro & Associates 4356 1990-03-21 Fouch-Roseboro & Associates Washington     DC  
3735 3735 1962-03-15 Republic of Haiti 1959-03-19 HAITI Chapman, DiSalle & Friedman 867 1955-01-21 Chapman, DiSalle & Friedman Port-au-Prince        
3772 3772 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  
3953 3953 1961-03-22 Republic of Haiti 1960-09-22 HAITI Berlanti, Louis J. 1393 1960-09-22 Berlanti, Louis J. Port-au-Prince        
9029 9029 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        
9228 9228 1961-07-15 Republic of Haiti 1961-05-01 HAITI Berlanti Overseas Corporation 1380 1960-07-19 Berlanti Overseas Corporation Port-au-Prince        
9572 9572 1959-07-30 Republic of Haiti 1959-01-30 HAITI Haitian Industries, Inc. 1196 1959-01-30 Haitian Industries, Inc. Port-au-Prince        
9922 9922 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        
10950 10950 1986-08-31 Republic of Haiti 1986-12-04 HAITI van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
11884 11884 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        
11975 11975 1988-09-30 Republic of Haiti 1986-08-06 HAITI Stroock & Stroock & Lavan 3816 1986-04-22 Stroock & Stroock & Lavan Port-au-Prince        
12113 12113 2002-09-30 Republic of Haiti 2002-02-25 HAITI Global Market Solutions 5475 2002-02-25 Global Market Solutions Port-au-Prince        
12367 12367 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        
12587 12587 1983-10-12 Republic of Haiti 1982-03-05 HAITI Walters, Costanzo, Miller & Russell 3343 1982-03-05 Walters, Costanzo, Miller & Russell       FL  
13196 13196 1980-10-31 Republic of Haiti 1978-04-21 HAITI Edelman International Corporation 2548 1974-11-29 Edelman International Corporation Port-au-Prince        
13600 13600 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        
14212 14212 1962-11-25 Republic of Haiti 1958-04-02 HAITI Keesing, John Maurice 1091 1957-11-27 Keesing, John Maurice Port-au-Prince        
15066 15066 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        
15504 15504 1952-12-31 Republic of Haiti 1947-05-21 HAITI Alexander, Raymond Pace 462 1947-05-21 Alexander, Raymond Pace Port-au-Prince        
16478 16478 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])
);