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

16 rows where Country/Location_Represented = "GUATEMALA" and Foreign_Principal = "Government of Guatemala"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 2

City 2

Foreign_Principal 1

  • Government of Guatemala · 16 ✖

Country/Location_Represented 1

  • GUATEMALA · 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
281 281   Government of Guatemala 2022-01-13 GUATEMALA Ballard Partners 7070 2022-01-13 Ballard Partners 2220 R Street, NW   Washington DC 20008
1341 1341 1996-01-15 Government of Guatemala 1995-04-21 GUATEMALA R. Thompson & Company 4950 1994-09-23 R. Thompson & Company Guatemala City        
3805 3805 1970-03-16 Government of Guatemala 1956-10-16 GUATEMALA Ginsburg, Feldman & Bress 540 1948-09-16 Ginsburg, Feldman & Bress Washington     DC  
3992 3992 1982-03-23 Government of Guatemala 1981-03-02 GUATEMALA Proskauer Rose Goetz & Mendelsohn 3206 1981-03-02 Proskauer Rose Goetz & Mendelsohn          
4830 4830 1955-04-01 Government of Guatemala 1955-02-07 GUATEMALA John A. Clements Associates 872 1955-02-07 John A. Clements Associates Guatemala City        
6682 6682 1954-05-21 Government of Guatemala 1953-05-21 GUATEMALA Black Eagle Associates, Inc. 767 1953-05-21 Black Eagle Associates, Inc. Guatemala City        
7049 7049 1978-05-31 Government of Guatemala 1977-06-27 GUATEMALA Kaplan, Sheldon Z. 2797 1977-06-27 Kaplan, Sheldon Z. Guatemala City        
8814 8814 1959-07-01 Government of Guatemala 1958-09-08 GUATEMALA Chapman, DiSalle & Friedman 867 1955-01-21 Chapman, DiSalle & Friedman Guatemala City        
10702 10702 1956-08-24 Government of Guatemala 1956-08-24 GUATEMALA Brown, Darwin Charles 972 1956-08-24 Brown, Darwin Charles Washington     DC  
10829 10829 1955-08-30 Government of Guatemala 1955-04-05 GUATEMALA Continental-Allied Company 885 1955-04-05 Continental-Allied Company Guatemala City        
11317 11317 1955-09-02 Government of Guatemala 1955-03-23 GUATEMALA Cheesman, Frank Albert 880 1955-03-23 Cheesman, Frank Albert Guatemala City        
12306 12306 1962-10-01 Government of Guatemala 1960-10-10 GUATEMALA Kaplan, Sheldon Z. 1344 1960-03-28 Kaplan, Sheldon Z. Guatemala City        
12308 12308 1967-10-01 Government of Guatemala 1958-01-28 GUATEMALA Curtis J. Hoxter, Inc. 1111 1958-01-28 Curtis J. Hoxter, Inc. Guatamala City        
15559 15559 1956-12-31 Government of Guatemala 1955-09-01 GUATEMALA Scott Wilson & Associates 907 1955-09-01 Scott Wilson & Associates Guatemala City        
15598 15598 1960-12-31 Government of Guatemala 1959-06-03 GUATEMALA Klein & Saks 1234 1959-06-03 Klein & Saks Guatemala City        
15764 15764 1976-12-31 Government of Guatemala 1965-08-16 GUATEMALA Pan-American Coffee Bureau 406 1946-12-06 Pan-American Coffee Bureau Guatemala City        

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