FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where Foreign_Principal = "Republic of Haiti" sorted by Zip
This data as json, CSV (advanced)
Registrant_Name 16
- Alexander, Raymond Pace 1
- Berlanti Overseas Corporation 1
- Berle Jr., A.A. 1
- Brenda Joyce & Associates, Inc. 1
- Dellums, Brauer, Halterman & Associates, LLC 1
- Edelman International Corporation 1
- Global Market Solutions 1
- Haitian Industries, Inc. 1
- Keesing, John Maurice 1
- Public Relations Associates International 1
- QORVIS LLC 1
- Roosevelt, Summers & Hamilton, Inc. 1
- Stroock & Stroock & Lavan 1
- Tew Cardenas, LLP 1
- Walters, Costanzo, Miller & Russell 1
- van Kloberg & Associates, Ltd. 1
Foreign_Principal 1
- Republic of Haiti · 16 ✖
Country/Location_Represented 1
- HAITI 16
City 1
- - 16
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]) );