home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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" sorted by Country/Location_Represented

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 17

  • Holland & Knight 2
  • A.F. Sabo Associates, Inc. 1
  • Bloch, Henry S. 1
  • CounterTerrorism Consultants, L.P. 1
  • David Berger, P.A. 1
  • Davis, Polk & Wardell 1
  • Fenton Communications, Inc. 1
  • JAMPRO 1
  • JWI, LLC 1
  • Jamaica Reservation Service 1
  • Manatt, Phelps & Phillips 1
  • O'Connor & Hannan, L.L.P. 1
  • Pehle, Riemer, Luxford & Naiden 1
  • Robert R. Nathan Associates, Inc. 1
  • Skadden, Arps, Slate, Meagher & Flom 1
  • Ward, Curtis A. 1
  • Washington International Group, Inc. 1

Address_1 4 ✖

  • Kingston 14
  • Washington 2
  • - 1
  • Kingston 5 1

State 2

  • - 16
  • DC 2

Foreign_Principal 1

  • Government of Jamaica · 18 ✖

Country/Location_Represented 1

  • JAMAICA 18

City 1

  • - 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
778 778 1958-01-01 Government of Jamaica 1955-10-07 JAMAICA Pehle, Riemer, Luxford & Naiden 439 1947-02-17 Pehle, Riemer, Luxford & Naiden Kingston        
1755 1755 1991-01-31 Government of Jamaica 1978-08-09 JAMAICA Jamaica Reservation Service 2941 1978-08-09 Jamaica Reservation Service Kingston 5        
2415 2415 1993-02-12 Government of Jamaica 1989-03-10 JAMAICA Fenton Communications, Inc. 3857 1986-07-14 Fenton Communications, Inc. Kingston        
2951 2951 1989-02-28 Government of Jamaica 1988-03-11 JAMAICA Skadden, Arps, Slate, Meagher & Flom 3746 1985-10-15 Skadden, Arps, Slate, Meagher & Flom Washington     DC  
3326 3326 2002-03-01 Government of Jamaica 1995-02-06 JAMAICA JWI, LLC 4990 1995-02-06 JWI, LLC Kingston        
3408 3408 1995-03-03 Government of Jamaica 1989-03-06 JAMAICA Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Kingston        
3748 3748 1967-03-15 Government of Jamaica 1967-01-25 JAMAICA Robert R. Nathan Associates, Inc. 352 1946-04-22 Robert R. Nathan Associates, Inc.          
5289 5289 1990-04-15 Government of Jamaica 1989-09-18 JAMAICA CounterTerrorism Consultants, L.P. 4294 1989-09-18 CounterTerrorism Consultants, L.P. Kingston        
6175 6175 1980-05-01 Government of Jamaica 1979-03-30 JAMAICA David Berger, P.A. 3009 1979-03-30 David Berger, P.A. Kingston        
6886 6886 1987-05-28 Government of Jamaica 1985-09-20 JAMAICA Manatt, Phelps & Phillips 3736 1985-09-20 Manatt, Phelps & Phillips Kingston        
7135 7135 1993-05-31 Government of Jamaica 1991-11-07 JAMAICA Ward, Curtis A. 4590 1991-11-07 Ward, Curtis A. Kingston        
8015 8015 2000-06-22 Government of Jamaica 1996-08-15 JAMAICA Holland & Knight 3718 1985-08-07 Holland & Knight Kingston        
8568 8568 1998-06-30 Government of Jamaica 1989-03-29 JAMAICA JAMPRO 4232 1989-03-29 JAMPRO Kingston        
10521 10521 1985-08-15 Government of Jamaica 1983-04-26 JAMAICA O'Connor & Hannan, L.L.P. 2972 1978-10-25 O'Connor & Hannan, L.L.P. Washington     DC  
10871 10871 1960-08-31 Government of Jamaica 1958-09-22 JAMAICA Davis, Polk & Wardell 785 1953-08-21 Davis, Polk & Wardell Kingston        
12484 12484 1967-10-05 Government of Jamaica 1963-02-28 JAMAICA Bloch, Henry S. 1602 1963-02-28 Bloch, Henry S. Kingston        
13801 13801 1989-11-07 Government of Jamaica 1982-02-12 JAMAICA A.F. Sabo Associates, Inc. 3115 1980-06-27 A.F. Sabo Associates, Inc. Kingston        
16058 16058 1988-12-31 Government of Jamaica 1988-05-31 JAMAICA Holland & Knight 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 · Queries took 335.164ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows