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

18 rows where Foreign_Principal = "Government of Jamaica"

View and edit SQL

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

State

Foreign_Principal

  • Government of Jamaica · 18

Country/Location_Represented

City

  • 18
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
715 1958-01-01 Government of Jamaica 1955-10-07 JAMAICA 439 439 1947-02-17 Pehle, Riemer, Luxford & Naiden Kingston        
1651 1991-01-31 Government of Jamaica 1978-08-09 JAMAICA 2941 2941 1978-08-09 Jamaica Reservation Service Kingston 5        
2278 1993-02-12 Government of Jamaica 1989-03-10 JAMAICA 3857 3857 1986-07-14 Fenton Communications, Inc. Kingston        
2788 1989-02-28 Government of Jamaica 1988-03-11 JAMAICA 3746 3746 1985-10-15 Skadden, Arps, Slate, Meagher & Flom Washington     DC  
3140 2002-03-01 Government of Jamaica 1995-02-06 JAMAICA 4990 4990 1995-02-06 JWI, LLC Kingston        
3212 1995-03-03 Government of Jamaica 1989-03-06 JAMAICA 3320 3320 1982-01-05 Washington International Group, Inc. Kingston        
3536 1967-03-15 Government of Jamaica 1967-01-25 JAMAICA 352 352 1946-04-22 Robert R. Nathan Associates, Inc.          
4995 1990-04-15 Government of Jamaica 1989-09-18 JAMAICA 4294 4294 1989-09-18 CounterTerrorism Consultants, L.P. Kingston        
5840 1980-05-01 Government of Jamaica 1979-03-30 JAMAICA 3009 3009 1979-03-30 David Berger, P.A. Kingston        
6523 1987-05-28 Government of Jamaica 1985-09-20 JAMAICA 3736 3736 1985-09-20 Manatt, Phelps & Phillips Kingston        
6766 1993-05-31 Government of Jamaica 1991-11-07 JAMAICA 4590 4590 1991-11-07 Ward, Curtis A. Kingston        
7596 2000-06-22 Government of Jamaica 1996-08-15 JAMAICA 3718 3718 1985-08-07 Holland & Knight Kingston        
8145 1998-06-30 Government of Jamaica 1989-03-29 JAMAICA 4232 4232 1989-03-29 JAMPRO Kingston        
10013 1985-08-15 Government of Jamaica 1983-04-26 JAMAICA 2972 2972 1978-10-25 O'Connor & Hannan, L.L.P. Washington     DC  
10346 1960-08-31 Government of Jamaica 1958-09-22 JAMAICA 785 785 1953-08-21 Davis, Polk & Wardell Kingston        
11871 1967-10-05 Government of Jamaica 1963-02-28 JAMAICA 1602 1602 1963-02-28 Bloch, Henry S. Kingston        
13121 1989-11-07 Government of Jamaica 1982-02-12 JAMAICA 3115 3115 1980-06-27 A.F. Sabo Associates, Inc. Kingston        
15305 1988-12-31 Government of Jamaica 1988-05-31 JAMAICA 3718 3718 1985-08-07 Holland & Knight Kingston        

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.898ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history