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

33 rows where Foreign_Principal = "Government of Haiti" sorted by Foreign_Principal_Termination_Date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

City

Foreign_Principal

  • Government of Haiti · 33 ✖

Country/Location_Represented

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
6589 6589 1952-05-26 Government of Haiti 1952-05-26 HAITI 726 726 1952-05-26 Haitian Dessalines Western Hemisphere Trade Corporation Port-au-Prince        
2547 2547 1953-02-20 Government of Haiti 1951-02-20 HAITI 660 660 1951-02-20 Barnes, James M. Port-au-Prince        
14152 14152 1958-12-01 Government of Haiti 1957-11-04 HAITI 1077 1077 1957-11-04 Gravelle, Whitlock & Markey Port-au-Prince        
1848 1848 1959-02-01 Government of Haiti 1959-03-27 HAITI 1213 1213 1959-03-27 Rutherford, Richard Chambers       NY  
14707 14707 1959-12-17 Government of Haiti 1959-06-03 HAITI 1234 1234 1959-06-03 Klein & Saks Port-au-Prince        
3857 3857 1966-03-25 Government of Haiti 1966-03-25 HAITI 1972 1972 1966-03-25 Haiti Government Tourist Bureau Port-au-Prince        
11512 11512 1980-09-29 Government of Haiti 1977-03-29 HAITI 2765 2765 1977-03-29 Peabody, Lambert & Meyers       DC  
3588 3588 1982-03-15 Government of Haiti 1981-03-09 HAITI 3207 3207 1981-03-09 Carter, Robert S. Washington     DC  
5951 5951 1982-05-01 Government of Haiti 1981-03-09 HAITI 3208 3208 1981-03-09 Anderson, Hibey & Blair Washington     DC  
13908 13908 1982-11-30 Government of Haiti 1982-03-22 HAITI 2721 2721 1976-10-05 MacKenzie McCheyne, Inc. Port-au-Prince        
14993 14993 1982-12-30 Government of Haiti 1982-03-04 HAITI 3342 3342 1982-03-04 Kanner & Avakian Associates          
15391 15391 1982-12-31 Government of Haiti 1981-11-27 HAITI 3310 3310 1981-11-27 Kanner Security Group, Inc.          
3494 3494 1985-03-12 Government of Haiti 1982-02-12 HAITI 3333 3333 1982-02-12 Kaufman & Maraffi, Inc.          
2141 2141 1986-02-07 Government of Haiti 1982-12-16 HAITI 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Port-au-Prince        
5001 5001 1986-04-12 Government of Haiti 1985-06-04 HAITI 2836 2836 1977-10-12 North American Precis Syndicate       DC  
11951 11951 1987-10-01 Government of Haiti 1986-08-20 HAITI 3874 3874 1986-08-20 Demougeot, George          
9421 9421 1988-07-31 Government of Haiti 1988-03-03 HAITI 4095 4095 1988-03-03 Murphy & Demory, Ltd. Port-au-Prince        
12450 12450 1988-10-20 Government of Haiti 1988-02-04 HAITI 3634 3634 1984-11-15 Daniel J. Edelman, Inc. Port-au-Prince        
13981 13981 1991-11-30 Government of Haiti 1991-10-15 HAITI 3857 3857 1986-07-14 Fenton Communications, Inc. Port au Prince        
12621 12621 1993-10-26 Government of Haiti 1992-07-27 HAITI 4695 4695 1992-07-27 Demougeot, George Port-au-Prince        
2853 2853 1994-02-28 Government of Haiti 1993-09-29 HAITI 4694 4694 1992-07-17 Washington Strategic Consulting Group, Inc. Washington     DC  
7271 7271 1994-06-03 Government of Haiti 1992-09-21 HAITI 4708 4708 1992-09-21 Key Bridge International, Inc. Washington     DC  
14668 14668 1994-12-15 Government of Haiti 1994-09-30 HAITI 4449 4449 1990-12-17 Rendon Group, Inc. Washington     DC  
10690 10690 1996-08-31 Government of Haiti 1993-06-03 HAITI 2244 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
12956 12956 1999-10-31 Government of Haiti 1998-10-08 HAITI 5280 5280 1998-10-08 Levy, Mike Port-au-Prince        
15992 15992 2000-12-31 Government of Haiti 1995-02-07 HAITI 4992 4992 1995-02-07 Ross-Robinson & Associates Port-au-Prince        
9841 9841 2001-08-06 Government of Haiti 2001-03-22 HAITI 5420 5420 2001-03-22 Levy, Michael Port-au-Prince        
16031 16031 2002-12-31 Government of Haiti 2002-01-18 HAITI 5411 5411 2001-02-13 Downey McGrath Group, Inc. Kurzban, Kurzban, Weinger & Tetzeli Plaza 2650, Second Floor 2650 SW 27th Avenue Miami 33133     FL  
6738 6738 2003-05-30 Government of Haiti 2003-03-21 HAITI 5546 5546 2003-03-21 Foley & Lardner c/o Ira Kurzban, Esq. 2650 S.W. 27th Avenue, 2nd Floor, Miami 33133     FL  
3181 3181 2004-03-01 Government of Haiti 2003-05-07 HAITI 3712 3712 1985-08-05 DLA Piper US LLP Plaza 2650, 2nd Floor 2650 S.W. 27th Avenue Miami 33133     FL  
3418 3418 2004-03-10 Government of Haiti 2003-07-24 HAITI 5568 5568 2003-07-24 Global Market Solutions, Inc.       FL  
16064 16064 2004-12-31 Government of Haiti 2004-05-17 HAITI 5402 5402 2000-12-14 BKSH & Associates Port - au - Prince        
5885 5885 2020-04-30 Government of Haiti 2019-06-28 HAITI 6284 6284 2015-03-20 Dentons US LLP 2311 Massachusetts Avenue, NW   Washington DC 20008

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])
);