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

15 rows where Foreign_Principal = "Dominican Republic"

View and edit SQL

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

State

Foreign_Principal

  • Dominican Republic · 15

Country/Location_Represented

City

  • 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
1283 2016-01-16 Dominican Republic 2015-08-03 DOMINICAN REPUBLIC 6310 6310 2015-08-03 MWW Group LLC Avenida Mexico esq. Doctor Delgado , Palacio Nacional, Gazcue 10205, Santo Domingo Distrito Nacional, Republica Dominicana      
2255 1960-02-12 Dominican Republic 1958-02-12 DOMINICAN REPUBLIC 1114 1114 1958-02-12 Barbosa, Ernesto S. Ciudad Trujillo        
3398 1964-03-11 Dominican Republic 1963-03-11 DOMINICAN REPUBLIC 1605 1605 1963-03-11 Edwards, Joseph Dean Santo Domingo        
4084 1958-03-31 Dominican Republic 1957-04-30 DOMINICAN REPUBLIC 1019 1019 1957-04-30 Pan-American Public Relations, Ltd.          
4644 1985-04-01 Dominican Republic 1982-10-05 DOMINICAN REPUBLIC 3415 3415 1982-10-05 Black, Manafort & Stone, Inc.          
6684 1958-05-31 Dominican Republic 1956-04-25 DOMINICAN REPUBLIC 949 949 1956-04-25 Feeney, Joseph Gerald Ciudad Trujillo        
6975 1958-06-01 Dominican Republic 1957-11-01 DOMINICAN REPUBLIC 1076 1076 1957-11-01 Bradford, T. Walter Washington     DC  
8607 1962-07-05 Dominican Republic 1962-07-05 DOMINICAN REPUBLIC 1557 1557 1962-07-05 Matos Gonzalez, Celeste Antonia Santo Domingo        
8909 1948-07-17 Dominican Republic 1947-10-03 DOMINICAN REPUBLIC 491 491 1947-10-03 Bolton & Lucas Trujillo City        
9181 1956-07-30 Dominican Republic 1956-07-30 DOMINICAN REPUBLIC 967 967 1956-07-30 Albert Frank-Guenther Law, Inc. Ciudad Trujillo        
9725 1960-08-06 Dominican Republic 1959-02-06 DOMINICAN REPUBLIC 1199 1199 1959-02-06 Byline Newsreel Productions, New York Cuidad Trujillo        
10887 1964-09-04 Dominican Republic 1963-09-16 DOMINICAN REPUBLIC 1641 1641 1963-06-14 Itkin, Herbert Santo Domingo        
12952 1960-11-01 Dominican Republic 1947-01-09 DOMINICAN REPUBLIC 420 420 1947-01-09 Cummings, Sellers, Reeves & Conner Washington     DC  
14394 1961-12-11 Dominican Republic 1943-06-11 DOMINICAN REPUBLIC 197 197 1943-06-11 Dominican Chamber of Commerce of the U.S., Inc.          
14426 2014-12-12 Dominican Republic 2014-01-06 DOMINICAN REPUBLIC 6203 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)
);
Powered by Datasette · Query took 142.44ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history