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

173 rows where Country/Location_Represented = "HAITI"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name >30

  • Sorini, Samet & Associates, LLC 6
  • Haiti Government Tourist Bureau 4
  • Davidson, I. Irving 3
  • Loughlin, Elmer H. 3
  • BKSH & Associates 2
  • Berlanti, Louis J. 2
  • Chapman, DiSalle & Friedman 2
  • Demougeot, George 2
  • Gileadi, Ian 2
  • Haitian Industries, Inc. 2
  • Haitian Travel Center, Inc. 2
  • Key Bridge International, Inc. 2
  • Law Offices of Robert C. McCandless 2
  • McKinney & McDowell Associates 2
  • North American Precis Syndicate 2
  • Parti National Haitian (Haitian National Party) 2
  • Rigaud, Roger 2
  • Rips, Serge 2
  • Scanlon, Thomas J. 2
  • Squire Patton Boggs, LLP 2
  • Tew Cardenas, LLP 2
  • Williams & Connolly 2
  • Alexander, Raymond Pace 1
  • Allied Public Relations, Inc. 1
  • Alyse Lynn Booth & Associates 1
  • Anderson, Hibey & Blair 1
  • Anfuso Jr., Victor L. 1
  • Angelo Viard 1
  • Arent Fox Kintner Plotkin & Kahn, PLLC 1
  • Associates Detectives, Inc. 1
  • …

Foreign_Principal >30

  • Government of Haiti 33
  • Republic of Haiti 30
  • Government of Haiti, Embassy 4
  • Government of the Republic of Haiti 3
  • Haiti National Office of Tourism 3
  • Boulos, Reginald 2
  • Dr. Reginald Boulos 2
  • Embassy of Haiti 2
  • Embassy of the Republic of Haiti 2
  • Haitian Government 2
  • Parti Agricole Industriel National 2
  • Provisional Government of Haiti 2
  • Republique d'Haiti 2
  • A Voluntary Committee of the Parti National 1
  • Agri-Supply Company, S.A. 1
  • Allied Public Relations, Inc. 1
  • Arthur Bonhomme 1
  • CMO-HOPE 1
  • Caribbean Rice Company 1
  • Center for Development & Health 1
  • Center for Facilitation of Investments (through L' Association des Industries d' Haiti (ADIH) 1
  • Clement S. Benoit 1
  • Commission de Mise en Oeuvre de la Loi HOPE (CMO-HOPE) 1
  • Conseil National du Tourisme (Haiti Tourist Board) 1
  • Consulate of Republic of Haiti 1
  • Departement des Affaires Estrangeres et des Cultes 1
  • Dove Industries, S.A. 1
  • Dr. Ariel Henry 1
  • Dr. Francois Duvalier 1
  • Dr. Francois Duvalier (President de la Republique D'Haiti) 1
  • …

City 7

  • - 160
  • Washington 7
  • Port-au-Prince 2
  • London W1K 4QJ 1
  • Port Au Prince, Ouest, 1
  • Port au Prince 1
  • Port-au-Prince 1

State 5

  • - 130
  • DC 29
  • FL 10
  • NY 3
  • NJ 1

Country/Location_Represented 1

  • HAITI · 173 ✖
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
6 6   Center for Facilitation of Investments (through L' Association des Industries d' Haiti (ADIH) 2021-04-22 HAITI Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC          
153 153   Dr. Ariel Henry 2023-03-16 HAITI Angelo Viard 7244 2023-03-16 Angelo Viard 33 Boulevard Harry Truman   Port Au Prince, Ouest,    
201 201   Embassy of the Republic of Haiti 2021-03-12 HAITI Patino & Associates, P.A. 6937 2021-03-12 Patino & Associates, P.A. 2311 Massachusetts Avenue, NW   Washington DC 20008
871 871 1985-01-01 Departement des Affaires Estrangeres et des Cultes 1982-10-15 HAITI Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Port-au-Prince        
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        
878 878 1986-01-01 Haiti National Office of Tourism 1985-07-24 HAITI Benford Associates, Inc. 3703 1985-07-24 Benford Associates, Inc.          
1107 1107 1995-01-06 Republic of Haiti 1992-01-09 HAITI McKinney & McDowell Associates 4516 1991-05-28 McKinney & McDowell Associates Washington     DC  
1152 1152 1960-01-08 Secretairerie d'Etat Republique d'Haiti 1959-07-08 HAITI Osherman, Jack A. 1245 1959-07-08 Osherman, Jack A. Port-au-Prince        
1254 1254 1959-01-13 President Duvalier (Government of Haiti) 1959-01-13 HAITI James, Chauncey Thomas 1193 1959-01-13 James, Chauncey Thomas Port-au-Prince        
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        
1415 1415 2018-01-19 Ministry of Commerce and Industry of Haiti (through Association des Industries d'Haiti) (ADIH) 2017-06-19 HAITI Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC          
1447 1447 1990-01-21 Government of Haiti, Ministry of Finance 1989-07-07 HAITI Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Port-au-Prince        
1453 1453 2014-01-21 Government of Haiti/Republic of Haiti 2014-01-21 HAITI Bastien, Goldstein, & Blackthorne Group (BGB Group) 6206 2014-01-21 Bastien, Goldstein, & Blackthorne Group (BGB Group) Primature d'Haiti 33, Boulevard Harry Truman Port-au-Prince HT 6110      
1532 1532 1970-01-26 L'Office du Timbre, Government of Haiti 1968-02-26 HAITI Fatoullah & Lazar, Inc. 2075 1968-02-26 Fatoullah & Lazar, Inc. Port-au-Prince        
1628 1628 1964-01-30 Republique d'Haiti 1963-07-19 HAITI Shindler, Bernard 1646 1963-07-19 Shindler, Bernard Port-au-Prince        
1701 1701 1976-01-31 Haiti Government Tourist Bureau 1976-04-26 HAITI Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc.          
1784 1784 1995-01-31 Center for Development & Health 1993-06-21 HAITI Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Port-au-Prince        
1824 1824 1999-01-31 Government of Haiti (Customs) 1997-07-17 HAITI Sandler & Travis Trade Advisory Services, Inc. 4699 1992-07-31 Sandler & Travis Trade Advisory Services, Inc. Port Au Prince        
1936 1936 2022-01-31 Embassy of the Republic of Haiti Government of the Republic of Haiti 2019-03-11 HAITI LeBlanc, Johanna 6644 2019-03-11 LeBlanc, Johanna 2311 Massachusetts Avenue, NW   Washington DC 20008
1961 1961 1959-02-01 Government of Haiti 1959-03-27 HAITI Rutherford, Richard Chambers 1213 1959-03-27 Rutherford, Richard Chambers       NY  
2260 2260 1986-02-07 Government of Haiti 1982-12-16 HAITI Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Port-au-Prince        
2306 2306 1955-02-09 Jacques Leger 1955-02-11 HAITI Rips, Serge 500 1947-11-14 Rips, Serge Washington     DC  
2307 2307 1955-02-09 Republic of Haiti 1955-02-11 HAITI Rips, Serge 500 1947-11-14 Rips, Serge Port-au-Prince        
2378 2378 1981-02-11 Republic of Haiti, West Indies ONACORA Corporation 1980-08-06 HAITI Buohl, Chauncey R. 3134 1980-08-06 Buohl, Chauncey R. Port-au-Prince        
2677 2677 1953-02-20 Government of Haiti 1951-02-20 HAITI Barnes, James M. 660 1951-02-20 Barnes, James M. 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        
2991 2991 1994-02-28 Government of Haiti 1993-09-29 HAITI Washington Strategic Consulting Group, Inc. 4694 1992-07-17 Washington Strategic Consulting Group, Inc. Washington     DC  
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        
3073 3073 2006-02-28 Government of Haiti, Embassy 2005-10-31 HAITI BKSH & Associates 5402 2000-12-14 BKSH & Associates 2311 Massachusetts Avenue, NW   Washington DC 20008
3183 3183 2020-02-29 Boulos, Reginald 2020-01-27 HAITI Shamlin, Richard 6788 2020-01-27 Shamlin, Richard 20 Boulevard Toussaint Louverture Port au Prince, HT6120      
3283 3283 1987-03-01 Mr. Marc Bazin 1986-08-15 HAITI Alyse Lynn Booth & Associates 3870 1986-08-15 Alyse Lynn Booth & Associates Port-au-Prince        
3312 3312 1994-03-01 Usine A. Manteque de Port-Au-Prince 1993-05-10 HAITI Law Offices of Robert K. Kelley 4754 1993-01-19 Law Offices of Robert K. Kelley Port-Au-Prince        
3332 3332 2004-03-01 Government of Haiti 2003-05-07 HAITI DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Plaza 2650, 2nd Floor 2650 S.W. 27th Avenue Miami 33133     FL  
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        
3569 3569 1950-03-10 Gerard De Catalogne 1948-03-11 HAITI Haitian Travel Center, Inc. 516 1948-03-11 Haitian Travel Center, Inc. Lexington     NY  
3570 3570 1950-03-10 Haitian Government 1948-04-14 HAITI Haitian Travel Center, Inc. 516 1948-03-11 Haitian Travel Center, Inc. Port-au-Prince        
3571 3571 1959-03-10 Haiti 1958-09-10 HAITI Associates Detectives, Inc. 1168 1958-09-10 Associates Detectives, Inc. Miami Springs     FL  
3575 3575 1983-03-10 Consulate of Republic of Haiti 1982-09-14 HAITI Paul, Landy, Beiley, Harper & Metsch, P.A. 3413 1982-09-14 Paul, Landy, Beiley, Harper & Metsch, P.A. Miami     FL  
3576 3576 1990-03-10 Republic of Haiti 1990-03-21 HAITI Fouch-Roseboro & Associates 4356 1990-03-21 Fouch-Roseboro & Associates Washington     DC  
3585 3585 2004-03-10 Government of Haiti 2003-07-24 HAITI Global Market Solutions, Inc. 5568 2003-07-24 Global Market Solutions, Inc.       FL  
3592 3592 1960-03-11 Gaston Jumelle 1959-09-11 HAITI Rigaud, Roger 1268 1959-09-11 Rigaud, Roger Mexico City        
3593 3593 1960-03-11 Parti National of Haiti 1959-09-11 HAITI Rigaud, Roger 1268 1959-09-11 Rigaud, Roger Mexico City        
3663 3663 1985-03-12 Government of Haiti 1982-02-12 HAITI Kaufman & Maraffi, Inc. 3333 1982-02-12 Kaufman & Maraffi, Inc.          
3732 3732 2022-03-14 MTVAYITI 2019-11-25 HAITI Llera, Allison Maria 6756 2019-11-25 Llera, Allison Maria El Rancho Petion Ville      
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        
3761 3761 1982-03-15 Government of Haiti 1981-03-09 HAITI Carter, Robert S. 3207 1981-03-09 Carter, Robert S. Washington     DC  
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  
3807 3807 1970-03-16 Jean Excellent 1959-06-15 HAITI Ginsburg, Feldman & Bress 540 1948-09-16 Ginsburg, Feldman & Bress Washington     DC  
3811 3811 1978-03-16 Republique d'Haiti (Corps d'Aviation, Forces Armees d'Haiti) (Compagnie Haitienne de Transport Aeriens) 1966-03-16 HAITI Rincones, Ralph Antonio 1968 1966-03-16 Rincones, Ralph Antonio          
3904 3904 1962-03-20 Inter-American Regional Organization of the International Confederation of Free Trade Unions 1962-04-04 HAITI L'Union Nationale des Ouvriers d'Haiti en Exil 1534 1962-04-04 L'Union Nationale des Ouvriers d'Haiti en Exil          
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        
3965 3965 1961-03-22 Special Economic Commission 1961-05-01 HAITI Berlanti, Louis J. 1393 1960-09-22 Berlanti, Louis J. Port-au-Prince        
4036 4036 1966-03-25 Government of Haiti 1966-03-25 HAITI Haiti Government Tourist Bureau 1972 1966-03-25 Haiti Government Tourist Bureau Port-au-Prince        
4149 4149 1959-03-30 Allied Public Relations, Inc. 1958-10-03 HAITI Borger Associates 1174 1958-10-03 Borger Associates New York     NY  
4293 4293 1955-03-31 Embassy of Haiti 1955-05-26 HAITI Finley, Forrest E. 891 1955-05-26 Finley, Forrest E. Washington     DC  
4465 4465 1989-03-31 Haitian Federation of Private Sector Associations 1989-04-11 HAITI Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Port au Prince        
5119 5119 1993-04-09 Gilbert Bigio 1992-08-05 HAITI Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Port-au-Prince        
5210 5210 1986-04-12 Government of Haiti 1985-06-04 HAITI North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       DC  
5211 5211 1986-04-12 Haiti National Offices of Tourism 1985-11-05 HAITI North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NJ  
5243 5243 1988-04-13 Government of Haiti, Leslie F. Manigat, President 1988-02-17 HAITI Miner, Fraser & Gabriel Public Affairs, Inc. 4022 1987-08-11 Miner, Fraser & Gabriel Public Affairs, Inc. Port-au-Prince        
5256 5256 1982-04-14 Government of Republic of Haiti 1981-11-05 HAITI Gomez, Ellis Riera 3299 1981-11-05 Gomez, Ellis Riera          
5612 5612 1965-04-27 Provisional Government of the Republic of Haiti (Haitian Government in Exile) 1964-07-24 HAITI Bolte, Jean Antoine Max 1774 1964-07-24 Bolte, Jean Antoine Max San Juan        
5806 5806 1975-04-30 Republic of Haiti, National Office of Tourism & Propaganda 1965-09-24 HAITI Newman-Schulte-Reece, Inc. 1928 1965-09-24 Newman-Schulte-Reece, Inc.          
5951 5951 1996-04-30 Government of Haiti, Embassy 1993-02-22 HAITI International Liaison Office, Inc. 4767 1993-02-22 International Liaison Office, Inc. Washington     DC  
6108 6108 2020-04-30 Government of Haiti 2019-06-28 HAITI Dentons US LLP 6284 2015-03-20 Dentons US LLP 2311 Massachusetts Avenue, NW   Washington DC 20008
6182 6182 1982-05-01 Government of Haiti 1981-03-09 HAITI Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair Washington     DC  
6200 6200 1987-05-01 Marc Bazin 1986-09-21 HAITI Friends of Marc Bazin, Inc. 3885 1986-09-21 Friends of Marc Bazin, Inc. Port au Price        
6369 6369 2013-05-06 Societe Nationale des Parcs Industriels (SONAPI) 2013-02-12 HAITI Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC Boulevard Toussaint Louvertur (route A rope e rt) PO Box 2345 Port-au-Prince      
6802 6802 1983-05-25 Haitian Textile Exporters' Association (AHATEX) 1979-11-26 HAITI Fasturn, Inc. 2944 1978-08-09 Fasturn, Inc. Port-au-Prince        
6840 6840 1952-05-26 Government of Haiti 1952-05-26 HAITI Haitian Dessalines Western Hemisphere Trade Corporation 726 1952-05-26 Haitian Dessalines Western Hemisphere Trade Corporation Port-au-Prince        
6991 6991 2003-05-30 Government of Haiti 2003-03-21 HAITI Foley & Lardner 5546 2003-03-21 Foley & Lardner c/o Ira Kurzban, Esq. 2650 S.W. 27th Avenue, 2nd Floor, Miami 33133     FL  
7025 7025 1963-05-31 Government of the Republic of Haiti 1963-05-31 HAITI Anfuso Jr., Victor L. 1633 1963-05-31 Anfuso Jr., Victor L. Port-au-Prince        
7212 7212 2006-05-31 Republic of Haiti, Embassy 2006-03-24 HAITI Tew Cardenas, LLP 5562 2003-06-10 Tew Cardenas, LLP 2311 Massachusetts Avenue, NW   Washington DC 20008
7336 7336 1964-06-01 Haytian (Haitian)-American Sugar Company, S.A. 1962-02-16 HAITI Richard C. O'Hare & James H. Rowe, Jr. 1519 1962-02-16 Richard C. O'Hare & James H. Rowe, Jr. Port-au-Prince        
7549 7549 1994-06-03 Government of Haiti 1992-09-21 HAITI Key Bridge International, Inc. 4708 1992-09-21 Key Bridge International, Inc. Washington     DC  
7628 7628 1966-06-06 Republic of Haiti, City of Port-au-Prince 1965-12-06 HAITI Kenneth G. Smith & Associates, Inc. 1943 1965-12-06 Kenneth G. Smith & Associates, Inc. Port-au-Prince        
7750 7750 1993-06-11 Provisional Government of Haiti 1992-05-20 HAITI Law Offices of Robert C. McCandless 4668 1992-05-20 Law Offices of Robert C. McCandless Port-au-Prince        
7868 7868 1964-06-16 Caribbean Rice Company 1963-12-16 HAITI Loughlin, Elmer H. 1671 1963-12-16 Loughlin, Elmer H. Port-au-Prince        
7869 7869 1964-06-16 Dove Industries, S.A. 1963-12-16 HAITI Loughlin, Elmer H. 1671 1963-12-16 Loughlin, Elmer H. Port-au-Prince        
7870 7870 1964-06-16 Francois Duvalier 1963-12-16 HAITI Loughlin, Elmer H. 1671 1963-12-16 Loughlin, Elmer H. Port-au-Prince        
7880 7880 1994-06-16 H.E. Jean Bertrand Aristide 1992-05-19 HAITI Haiti Government Tourist Bureau 1901 1965-06-16 Haiti Government Tourist Bureau Port-au-Prince        
7881 7881 1994-06-16 Jean Francois Chamblain 1992-05-19 HAITI Haiti Government Tourist Bureau 1901 1965-06-16 Haiti Government Tourist Bureau Port-au-Prince        
7882 7882 1994-06-16 Republic of Haiti, Office National du Tourisme et de la Propagande 1965-09-20 HAITI Haiti Government Tourist Bureau 1901 1965-06-16 Haiti Government Tourist Bureau Port Au Prince        
7908 7908 1973-06-18 Dr. Francois Duvalier (President de la Republique D'Haiti) 1970-06-30 HAITI Davidson, I. Irving 886 1955-04-18 Davidson, I. Irving Port-au-Prince        
7917 7917 1973-06-18 President Jean-Claude Duvalier 1971-06-15 HAITI Davidson, I. Irving 886 1955-04-18 Davidson, I. Irving Port-au-Prince        
7921 7921 1973-06-18 Republique of Haiti 1964-01-03 HAITI Davidson, I. Irving 886 1955-04-18 Davidson, I. Irving Port-au-Haiti        
8607 8607 2001-06-30 Government of the Republic of Haiti, Ministry of Foreign Affairs 1998-10-01 HAITI Burton V. Wides, P.C. 5278 1998-10-01 Burton V. Wides, P.C. Port-au-Prince        
8793 8793 2023-06-30 Embassy of the Republic of Haiti 2020-12-09 HAITI Latin America Advisory Group, LLC 6898 2020-12-09 Latin America Advisory Group, LLC 2311 Massachusetts Avenue, NW   Washington DC 20008
9035 9035 1971-07-06 Republique d'Haiti 1971-06-23 HAITI Ellison, Byron G. 2267 1971-06-23 Ellison, Byron G. 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        
9444 9444 1963-07-23 A Voluntary Committee of the Parti National 1960-06-30 HAITI Parti National Haitian (Haitian National Party) 1365 1960-06-03 Parti National Haitian (Haitian National Party) Port-au-Haiti        
9445 9445 1963-07-23 Dr. Gaston Jumelle 1960-06-03 HAITI Parti National Haitian (Haitian National Party) 1365 1960-06-03 Parti National Haitian (Haitian National Party) Port-au-Prince        
9598 9598 1959-07-30 Haitian Industries, S.A. 1959-01-30 HAITI Haitian Industries, Inc. 1196 1959-01-30 Haitian Industries, Inc. 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        
9622 9622 1987-07-30 Parti Agricole Industriel National 1987-07-23 HAITI Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Port-au-Prince        
9747 9747 1988-07-31 Government of Haiti 1988-03-03 HAITI Murphy & Demory, Ltd. 4095 1988-03-03 Murphy & Demory, Ltd. Port-au-Prince        

Next page

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 224.868ms · 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