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

21 rows where Registrant_Name = "Sawyer Miller Group"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 21

  • Alvaro Sanchez Mallarino Publicidad 1
  • Campaign of Corazon Aquino 1
  • Central Bank, Government of the Philippines 1
  • Freedom & Justice for Cyprus Trust 1
  • Fundacion Pro-Imagen de Colombia en el Exterior 1
  • Government of Canada (Through Market Opinion Research) 1
  • Government of Colombia (Through Alvaro Sanchez Mallarino Publicidad) 1
  • Government of Ecuador 1
  • Government of Norway, Embassy 1
  • Government of Portugal 1
  • Government of the Republic of Colombia 1
  • Government of the Republic of Panama (In Exile), Eric Arturo Delvalle, President 1
  • Government of the Republic of the Philippines 1
  • Holden Roberto, President of the National Front for the Liberation of Angola (FNLA) 1
  • Ministry of Information, New Republic of the Philippines 1
  • NEC Corporation 1
  • Philippine Coconut Authority (PCA) 1
  • Philippine Sugar Administration 1
  • Presidential Campaign of Mr. Gonzalo Sanchez de Lozada 1
  • Sociedad Estatal para la Ejecucion de Programas y Actuaciones Commemorativas del Quinto Centerario del etc. 1
  • Venezuela Cement Producers' Association 1

Country/Location_Represented 13

  • PHILIPPINES 6
  • COLOMBIA 4
  • ANGOLA 1
  • BOLIVIA 1
  • CANADA 1
  • CYPRUS 1
  • ECUADOR 1
  • JAPAN 1
  • NORWAY 1
  • PANAMA 1
  • PORTUGAL 1
  • SPAIN 1
  • VENEZUELA 1

State 3

  • - 17
  • DC 3
  • CA 1

Registrant_Name 1

  • Sawyer Miller Group · 21 ✖

City 1

  • - 21
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
908 908 1988-01-01 Freedom & Justice for Cyprus Trust 1986-10-21 CYPRUS Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Nicosia        
1757 1757 1991-01-31 Philippine Sugar Administration 1989-03-03 PHILIPPINES Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Quezon City        
2291 2291 1986-02-08 Campaign of Corazon Aquino 1986-02-12 PHILIPPINES Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group       CA  
2401 2401 1988-02-12 Alvaro Sanchez Mallarino Publicidad 1986-10-16 COLOMBIA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Bogota, Colombia        
2402 2402 1988-02-12 Central Bank, Government of the Philippines 1987-12-31 PHILIPPINES Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group          
2404 2404 1988-02-12 Government of Colombia (Through Alvaro Sanchez Mallarino Publicidad) 1986-10-16 COLOMBIA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group          
2406 2406 1989-02-12 Philippine Coconut Authority (PCA) 1987-11-12 PHILIPPINES Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group          
5142 5142 1992-04-10 Venezuela Cement Producers' Association 1991-10-04 VENEZUELA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Caracas        
5143 5143 1992-04-10 Government of Ecuador 1989-08-21 ECUADOR Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Quito        
5144 5144 1992-04-10 Government of the Republic of the Philippines 1988-05-31 PHILIPPINES Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Washington     DC  
5145 5145 1992-04-10 Holden Roberto, President of the National Front for the Liberation of Angola (FNLA) 1991-10-22 ANGOLA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Paris        
5146 5146 1992-04-10 Sociedad Estatal para la Ejecucion de Programas y Actuaciones Commemorativas del Quinto Centerario del etc. 1991-06-10 SPAIN Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Madrid        
6201 6201 1988-05-01 Government of the Republic of Panama (In Exile), Eric Arturo Delvalle, President 1988-03-03 PANAMA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Washington     DC  
9788 9788 1991-07-31 Government of Portugal 1989-09-28 PORTUGAL Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Lisboa        
9791 9791 1991-07-31 NEC Corporation 1991-04-02 JAPAN Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Tokyo        
10991 10991 1989-08-31 Presidential Campaign of Mr. Gonzalo Sanchez de Lozada 1989-08-15 BOLIVIA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group La Paz        
11588 11588 1993-09-14 Fundacion Pro-Imagen de Colombia en el Exterior 1988-03-03 COLOMBIA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Bogota        
11589 11589 1993-09-14 Government of Norway, Embassy 1993-01-22 NORWAY Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Washington     DC  
11590 11590 1993-09-14 Government of the Republic of Colombia 1988-05-27 COLOMBIA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Bogota        
15046 15046 1986-12-12 Government of Canada (Through Market Opinion Research) 1986-06-24 CANADA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group          
15969 15969 1986-12-31 Ministry of Information, New Republic of the Philippines 1986-09-15 PHILIPPINES Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Manila        

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 379.017ms · 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