FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where Foreign_Principal = "Government of the Dominican Republic"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 23
- Frank, John Joseph 2
- Harbour Group, LLC 2
- Aguirre, Francisco 1
- BKSH & Associates 1
- Ballard Partners 1
- Black, Kelly, Scruggs & Healey 1
- Carey, Edward L. 1
- Chandor, E. Haring 1
- Dominican Republic Government Tourist Office 1
- Dominican Tourist Information Center, Inc. 1
- Franklin D. Roosevelt, Jr. & Charles Patrick Clark 1
- James N. Juliana Associates 1
- Johnson II, Robert Winthrop 1
- Mallen, George W. 1
- McLaughlin, Charles Alton 1
- Molins, Ralph 1
- Neil Keenan & Associates, Inc. 1
- Pan-American Coffee Bureau 1
- Rodenberg, Robert Ridgway 1
- Skol & Associates, Inc. 1
- Squire Patton Boggs, LLP 1
- Stanley Ross 1
- Surrey, Karasik, Gould and Efron 1
Foreign_Principal 1
- Government of the Dominican Republic · 25 ✖
Country/Location_Represented 1
City 1
- - 25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1870 | 1870 | 2010-01-31 | Government of the Dominican Republic | 1991-01-09 | DOMINICAN REPUBLIC | Johnson II, Robert Winthrop 4460 | 1991-01-09 | Johnson II, Robert Winthrop | Santo Domingo | ||||
2888 | 2888 | 1957-02-28 | Government of the Dominican Republic | 1956-03-16 | DOMINICAN REPUBLIC | Franklin D. Roosevelt, Jr. & Charles Patrick Clark 934 | 1956-03-16 | Franklin D. Roosevelt, Jr. & Charles Patrick Clark | Ciudad Trujillo | ||||
3223 | 3223 | 1972-03-01 | Government of the Dominican Republic | 1963-04-09 | DOMINICAN REPUBLIC | Surrey, Karasik, Gould and Efron 1178 | 1958-10-09 | Surrey, Karasik, Gould and Efron | |||||
3696 | 3696 | 1977-03-14 | Government of the Dominican Republic | 1975-12-10 | DOMINICAN REPUBLIC | Stanley Ross 2637 | 1975-12-10 | Stanley Ross | Santo Domingo | ||||
3892 | 3892 | 1959-03-20 | Government of the Dominican Republic | 1959-03-20 | DOMINICAN REPUBLIC | Frank, John Joseph 1211 | 1959-03-20 | Frank, John Joseph | Cuidad Trujillo | ||||
3913 | 3913 | 1961-03-21 | Government of the Dominican Republic | 1959-06-12 | DOMINICAN REPUBLIC | Carey, Edward L. 1235 | 1959-06-12 | Carey, Edward L. | Cuidad Trujillo | ||||
5311 | 5311 | 1992-04-16 | Government of the Dominican Republic | 1980-06-24 | DOMINICAN REPUBLIC | Dominican Tourist Information Center, Inc. 3114 | 1980-06-24 | Dominican Tourist Information Center, Inc. | Santo Domingo | ||||
7695 | 7695 | 1960-06-10 | Government of the Dominican Republic | 1959-11-17 | DOMINICAN REPUBLIC | Rodenberg, Robert Ridgway 1296 | 1959-11-17 | Rodenberg, Robert Ridgway | Ciudad Trujillo | ||||
7920 | 7920 | 2004-06-19 | Government of the Dominican Republic | 2001-04-30 | DOMINICAN REPUBLIC | Skol & Associates, Inc. 5346 | 1999-12-09 | Skol & Associates, Inc. | Palacio Nacional Santo Domingo | ||||
8963 | 8963 | 1986-07-03 | Government of the Dominican Republic | 1985-05-06 | DOMINICAN REPUBLIC | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Washington | DC | |||
9872 | 9872 | 2014-07-31 | Government of the Dominican Republic | 2014-01-27 | DOMINICAN REPUBLIC | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | Ave. Mexico, Gazcue Distrito Nacional, Santo Domingto | ||||
10061 | 10061 | 1962-08-03 | Government of the Dominican Republic | 1962-08-03 | DOMINICAN REPUBLIC | Molins, Ralph 1565 | 1962-08-03 | Molins, Ralph | |||||
10274 | 10274 | 1980-08-12 | Government of the Dominican Republic | 1974-07-03 | DOMINICAN REPUBLIC | Dominican Republic Government Tourist Office 2524 | 1974-07-03 | Dominican Republic Government Tourist Office | Santo Domingo | ||||
10821 | 10821 | 1993-08-30 | Government of the Dominican Republic | 1993-08-30 | DOMINICAN REPUBLIC | Neil Keenan & Associates, Inc. 4942 | 1993-08-30 | Neil Keenan & Associates, Inc. | Santo Domingo | ||||
11318 | 11318 | 1965-09-03 | Government of the Dominican Republic | 1964-12-17 | DOMINICAN REPUBLIC | Aguirre, Francisco 1837 | 1964-12-17 | Aguirre, Francisco | Santo Domingo | ||||
12943 | 12943 | 1962-10-24 | Government of the Dominican Republic | 1962-10-24 | DOMINICAN REPUBLIC | Mallen, George W. 1577 | 1962-10-24 | Mallen, George W. | |||||
13623 | 13623 | 2020-11-01 | Government of the Dominican Republic | 2017-04-05 | DOMINICAN REPUBLIC | Ballard Partners 6415 | 2017-04-05 | Ballard Partners | Ave. Mexico, Gazcue Distrito Nacional, Santa Domingo | ||||
13932 | 13932 | 1961-11-15 | Government of the Dominican Republic | 1959-07-07 | DOMINICAN REPUBLIC | Frank, John Joseph 1244 | 1959-07-07 | Frank, John Joseph | Cuidad Trujillo | ||||
13993 | 13993 | 2016-11-16 | Government of the Dominican Republic | 2015-07-17 | DOMINICAN REPUBLIC | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | National Palace | Santo Domingo | |||
14804 | 14804 | 1963-12-06 | Government of the Dominican Republic | 1963-12-06 | DOMINICAN REPUBLIC | Chandor, E. Haring 1669 | 1963-12-06 | Chandor, E. Haring | Ciudad Trujillo | ||||
15579 | 15579 | 1961-12-31 | Government of the Dominican Republic | 1947-09-22 | DOMINICAN REPUBLIC | McLaughlin, Charles Alton 488 | 1947-09-22 | McLaughlin, Charles Alton | Trujillo City | ||||
15701 | 15701 | 1974-12-31 | Government of the Dominican Republic | 1971-04-27 | DOMINICAN REPUBLIC | James N. Juliana Associates 2083 | 1968-03-25 | James N. Juliana Associates | Santo Domingo | ||||
15739 | 15739 | 1976-12-31 | Government of the Dominican Republic | 1965-08-16 | DOMINICAN REPUBLIC | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Santo Domingo | ||||
16572 | 16572 | 2006-12-31 | Government of the Dominican Republic | 2005-01-31 | DOMINICAN REPUBLIC | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | Palacio Nacional Santo Domingo, R.D. | ||||
16737 | 16737 | 2015-12-31 | Government of the Dominican Republic | 2015-07-16 | DOMINICAN REPUBLIC | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | Ave. Mexico, Gazcue Distrito Nacional, Santo Domingo |
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]) );