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 = "Government of Guatemala"

View and edit SQL

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

State

Foreign_Principal

  • Government of Guatemala · 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
1245 1996-01-15 Government of Guatemala 1995-04-21 GUATEMALA 4950 4950 1994-09-23 R. Thompson & Company Guatemala City        
3590 1970-03-16 Government of Guatemala 1956-10-16 GUATEMALA 540 540 1948-09-16 Ginsburg, Feldman & Bress Washington     DC  
3773 1982-03-23 Government of Guatemala 1981-03-02 GUATEMALA 3206 3206 1981-03-02 Proskauer Rose Goetz & Mendelsohn          
4573 1955-04-01 Government of Guatemala 1955-02-07 GUATEMALA 872 872 1955-02-07 John A. Clements Associates Guatemala City        
6349 1954-05-21 Government of Guatemala 1953-05-21 GUATEMALA 767 767 1953-05-21 Black Eagle Associates, Inc. Guatemala City        
6705 1978-05-31 Government of Guatemala 1977-06-27 GUATEMALA 2797 2797 1977-06-27 Kaplan, Sheldon Z. Guatemala City        
8402 1959-07-01 Government of Guatemala 1958-09-08 GUATEMALA 867 867 1955-01-21 Chapman, DiSalle & Friedman Guatemala City        
10227 1956-08-24 Government of Guatemala 1956-08-24 GUATEMALA 972 972 1956-08-24 Brown, Darwin Charles Washington     DC  
10350 1955-08-30 Government of Guatemala 1955-04-05 GUATEMALA 885 885 1955-04-05 Continental-Allied Company Guatemala City        
10820 1955-09-02 Government of Guatemala 1955-03-23 GUATEMALA 880 880 1955-03-23 Cheesman, Frank Albert Guatemala City        
11750 1962-10-01 Government of Guatemala 1960-10-10 GUATEMALA 1344 1344 1960-03-28 Kaplan, Sheldon Z. Guatemala City        
11752 1967-10-01 Government of Guatemala 1958-01-28 GUATEMALA 1111 1111 1958-01-28 Curtis J. Hoxter, Inc. Guatamala City        
14885 1956-12-31 Government of Guatemala 1955-09-01 GUATEMALA 907 907 1955-09-01 Scott Wilson & Associates Guatemala City        
14924 1960-12-31 Government of Guatemala 1959-06-03 GUATEMALA 1234 1234 1959-06-03 Klein & Saks Guatemala City        
15090 1976-12-31 Government of Guatemala 1965-08-16 GUATEMALA 406 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)
);
Powered by Datasette · Query took 163.592ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history