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

8 rows where Registration_Number = 3500

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal 8

  • ALFA Industries, S.A. 1
  • Center for Development & Health 1
  • Domimican Republic Defense Project 1
  • Haitian Federation of Private Sector Associations 1
  • Industrias Synkro, S.A. 1
  • J. Armando Bermudez 3248 Prospect Street, N.W. 1
  • Sigma Alimentos 1
  • Viamar 1

Country/Location_Represented 3

  • DOMINICAN REPUBLIC 3
  • MEXICO 3
  • HAITI 2

State 1

  • - 8

Registrant_Name 1

  • Scanlon, Thomas J. 8

City 1

  • - 8
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
1249 1249 1998-01-12 ALFA Industries, S.A. 1986-02-25 MEXICO Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Nuevo Leon        
1784 1784 1995-01-31 Center for Development & Health 1993-06-21 HAITI Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Port-au-Prince        
4465 4465 1989-03-31 Haitian Federation of Private Sector Associations 1989-04-11 HAITI Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Port au Prince        
5865 5865 1991-04-30 Domimican Republic Defense Project 1990-11-26 DOMINICAN REPUBLIC Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Santo Domingo        
9047 9047 1994-07-06 Viamar 1992-05-29 DOMINICAN REPUBLIC Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Santo Domingo        
9262 9262 1985-07-15 Industrias Synkro, S.A. 1984-03-16 MEXICO Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Mexico City        
10969 10969 1983-08-31 J. Armando Bermudez 3248 Prospect Street, N.W. 1983-07-12 DOMINICAN REPUBLIC Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Santiago        
11439 11439 1993-09-08 Sigma Alimentos 1992-05-29 MEXICO Scanlon, Thomas J. 3500 1983-07-12 Scanlon, Thomas J. Garcia        

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