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

15 rows where Country/Location_Represented = "DOMINICAN REPUBLIC" and Foreign_Principal = "Dominican Republic"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)

State 2

Foreign_Principal 1

  • Dominican Republic · 15 ✖

Country/Location_Represented 1

  • DOMINICAN REPUBLIC · 15 ✖

City 1

  • - 15
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
1375 1375 2016-01-16 Dominican Republic 2015-08-03 DOMINICAN REPUBLIC MWW Group LLC 6310 2015-08-03 MWW Group LLC Avenida Mexico esq. Doctor Delgado , Palacio Nacional, Gazcue 10205, Santo Domingo Distrito Nacional, Republica Dominicana      
2392 2392 1960-02-12 Dominican Republic 1958-02-12 DOMINICAN REPUBLIC Barbosa, Ernesto S. 1114 1958-02-12 Barbosa, Ernesto S. Ciudad Trujillo        
3595 3595 1964-03-11 Dominican Republic 1963-03-11 DOMINICAN REPUBLIC Edwards, Joseph Dean 1605 1963-03-11 Edwards, Joseph Dean Santo Domingo        
4298 4298 1958-03-31 Dominican Republic 1957-04-30 DOMINICAN REPUBLIC Pan-American Public Relations, Ltd. 1019 1957-04-30 Pan-American Public Relations, Ltd.          
4890 4890 1985-04-01 Dominican Republic 1982-10-05 DOMINICAN REPUBLIC Black, Manafort & Stone, Inc. 3415 1982-10-05 Black, Manafort & Stone, Inc.          
7012 7012 1958-05-31 Dominican Republic 1956-04-25 DOMINICAN REPUBLIC Feeney, Joseph Gerald 949 1956-04-25 Feeney, Joseph Gerald Ciudad Trujillo        
7321 7321 1958-06-01 Dominican Republic 1957-11-01 DOMINICAN REPUBLIC Bradford, T. Walter 1076 1957-11-01 Bradford, T. Walter Washington     DC  
9006 9006 1962-07-05 Dominican Republic 1962-07-05 DOMINICAN REPUBLIC Matos Gonzalez, Celeste Antonia 1557 1962-07-05 Matos Gonzalez, Celeste Antonia Santo Domingo        
9318 9318 1948-07-17 Dominican Republic 1947-10-03 DOMINICAN REPUBLIC Bolton & Lucas 491 1947-10-03 Bolton & Lucas Trujillo City        
9596 9596 1956-07-30 Dominican Republic 1956-07-30 DOMINICAN REPUBLIC Albert Frank-Guenther Law, Inc. 967 1956-07-30 Albert Frank-Guenther Law, Inc. Ciudad Trujillo        
10159 10159 1960-08-06 Dominican Republic 1959-02-06 DOMINICAN REPUBLIC Byline Newsreel Productions, New York 1199 1959-02-06 Byline Newsreel Productions, New York Cuidad Trujillo        
11360 11360 1964-09-04 Dominican Republic 1963-09-16 DOMINICAN REPUBLIC Itkin, Herbert 1641 1963-06-14 Itkin, Herbert Santo Domingo        
13528 13528 1960-11-01 Dominican Republic 1947-01-09 DOMINICAN REPUBLIC Cummings, Sellers, Reeves & Conner 420 1947-01-09 Cummings, Sellers, Reeves & Conner Washington     DC  
15020 15020 1961-12-11 Dominican Republic 1943-06-11 DOMINICAN REPUBLIC Dominican Chamber of Commerce of the U.S., Inc. 197 1943-06-11 Dominican Chamber of Commerce of the U.S., Inc.          
15052 15052 2014-12-12 Dominican Republic 2014-01-06 DOMINICAN REPUBLIC Steptoe & Johnson, LLP 6203 2014-01-06 Steptoe & Johnson, LLP Administrative Ministry of the Presidency National Palace Santo Domingo      

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