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

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

Foreign_Principal

  • Republic of Haiti · 30

Country/Location_Represented

City

  • 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
797 1985-01-01 Republic of Haiti 1983-01-20 HAITI 3038 3038 1979-07-13 Jack McDonald Associates, Inc. Port-au-Prince        
1021 1995-01-06 Republic of Haiti 1992-01-09 HAITI 4516 4516 1991-05-28 McKinney & McDowell Associates Washington     DC  
1195 1986-01-14 Republic of Haiti 1984-08-06 HAITI 3439 3439 1983-02-03 Garrett & Company Port au Prince        
1209 1959-01-15 Republic of Haiti 1958-10-09 HAITI 1177 1177 1958-10-09 Allied Public Relations, Inc. Port-au-Prince        
2172 1955-02-09 Republic of Haiti 1955-02-11 HAITI 500 500 1947-11-14 Rips, Serge Port-au-Prince        
2569 1967-02-23 Republic of Haiti 1958-09-02 HAITI 867 867 1955-01-21 Chapman, DiSalle & Friedman Port-au-Prince        
2703 1986-02-26 Republic of Haiti 1984-10-29 HAITI 3624 3624 1984-10-29 Shea & Gould Port-au-Prince        
2905 2004-02-28 Republic of Haiti 2003-04-24 HAITI 4776 4776 1993-03-02 Foley Hoag, LLP Palais National Port-au-Prince        
2906 2004-02-28 Republic of Haiti 2003-12-30 HAITI 5593 5593 2003-12-30 Dellums & Associates Port au Prince        
3263 1949-03-05 Republic of Haiti 1948-03-22 HAITI 519 519 1948-03-22 Dunbaugh, Frank Montgomery Port-au-Prince        
3380 1990-03-10 Republic of Haiti 1990-03-21 HAITI 4356 4356 1990-03-21 Fouch-Roseboro & Associates Washington     DC  
3544 1962-03-15 Republic of Haiti 1959-03-19 HAITI 867 867 1955-01-21 Chapman, DiSalle & Friedman Port-au-Prince        
3581 2004-03-15 Republic of Haiti 1991-12-31 HAITI 4604 4604 1991-12-31 Kurzban, Kurzban, Weinger & Tetzeli, P.A. Washington     DC  
3756 1961-03-22 Republic of Haiti 1960-09-22 HAITI 1393 1393 1960-09-22 Berlanti, Louis J. Port-au-Prince        
8655 1958-07-07 Republic of Haiti 1958-01-07 HAITI 1099 1099 1958-01-01 Roosevelt, Summers & Hamilton, Inc. Port-au-Prince        
8847 1961-07-15 Republic of Haiti 1961-05-01 HAITI 1380 1380 1960-07-19 Berlanti Overseas Corporation Port-au-Prince        
9184 1959-07-30 Republic of Haiti 1959-01-30 HAITI 1196 1196 1959-01-30 Haitian Industries, Inc. Port-au-Prince        
9521 1950-08-01 Republic of Haiti 1947-01-03 HAITI 432 432 1947-01-03 Berle Jr., A.A. Port-au-Prince        
10524 1986-08-31 Republic of Haiti 1986-12-04 HAITI 3466 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
11416 1956-09-30 Republic of Haiti 1956-05-21 HAITI 952 952 1956-05-21 Public Relations Associates International Port-au-Prince        
11507 1988-09-30 Republic of Haiti 1986-08-06 HAITI 3816 3816 1986-04-22 Stroock & Stroock & Lavan Port-au-Prince        
11644 2002-09-30 Republic of Haiti 2002-02-25 HAITI 5475 5475 2002-02-25 Global Market Solutions Port-au-Prince        
11866 2003-10-01 Republic of Haiti 2003-06-10 HAITI 5562 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        
12069 1983-10-12 Republic of Haiti 1982-03-05 HAITI 3343 3343 1982-03-05 Walters, Costanzo, Miller & Russell       FL  
12657 1980-10-31 Republic of Haiti 1978-04-21 HAITI 2548 2548 1974-11-29 Edelman International Corporation Port-au-Prince        
13051 2003-11-01 Republic of Haiti 2001-06-18 HAITI 5442 5442 2001-06-18 Dellums, Brauer, Halterman & Associates, LLC Port au Prince        
13642 1962-11-25 Republic of Haiti 1958-04-02 HAITI 1091 1091 1957-11-27 Keesing, John Maurice Port-au-Prince        
14469 1978-12-14 Republic of Haiti 1978-02-23 HAITI 2866 2866 1978-02-23 Brenda Joyce & Associates, Inc. Port-au-Prince        
14889 1952-12-31 Republic of Haiti 1947-05-21 HAITI 462 462 1947-05-21 Alexander, Raymond Pace Port-au-Prince        
15863 2001-12-31 Republic of Haiti 2003-06-04 HAITI 5483 5483 2002-03-06 MSLGROUP Americas, 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 · Query took 145.023ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history