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

11 rows where Foreign_Principal = "Japan External Trade Organization" and State = ""

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 11

  • Business Network Corporation 1
  • Daniel J. Edelman, Inc. 1
  • Dickens & Webster 1
  • Fraser Associates, Inc. 1
  • JETRO, Dallas (Japan External Trade Organization) 1
  • JETRO, New York 1
  • JETRO, Puerto Rico 1
  • Japan Trade Center, New Orleans 1
  • McCann-Marschalk Company, Inc. 1
  • Modern Education Services, Inc. 1
  • Ruder Finn, Inc. 1

State 1

  • - · 11 ✖

Foreign_Principal 1

  • Japan External Trade Organization · 11 ✖

Country/Location_Represented 1

  • JAPAN 11

City 1

  • - 11
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
373 373   Japan External Trade Organization 1963-06-25 JAPAN JETRO, New York 1643 1963-06-25 JETRO, New York Tokyo        
4022 4022 2003-03-24 Japan External Trade Organization 1977-08-08 JAPAN JETRO, Dallas (Japan External Trade Organization) 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) Tokyo        
4154 4154 1962-03-30 Japan External Trade Organization 1961-03-19 JAPAN McCann-Marschalk Company, Inc. 1477 1961-09-19 McCann-Marschalk Company, Inc. Tokyo        
4506 4506 1991-03-31 Japan External Trade Organization 1973-10-23 JAPAN JETRO, Puerto Rico 2468 1973-10-23 JETRO, Puerto Rico          
5114 5114 1980-04-09 Japan External Trade Organization 1968-05-20 JAPAN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
11976 11976 1986-09-30 Japan External Trade Organization 1961-09-27 JAPAN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc.          
12081 12081 1996-09-30 Japan External Trade Organization 1995-06-22 JAPAN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Tokyo        
12379 12379 1995-10-01 Japan External Trade Organization 1993-08-03 JAPAN Dickens & Webster 4837 1993-08-03 Dickens & Webster Chicago        
14512 14512 2004-11-30 Japan External Trade Organization 2003-05-31 JAPAN Business Network Corporation 4513 1991-05-20 Business Network Corporation 2-5 Toranomon 2-chome Minato-ku, Tokyo 105      
14663 14663 1980-12-01 Japan External Trade Organization 1980-02-15 JAPAN Fraser Associates, Inc. 2844 1977-11-08 Fraser Associates, Inc. Tokyo        
14822 14822 1977-12-05 Japan External Trade Organization 1972-01-25 JAPAN Japan Trade Center, New Orleans 2309 1972-01-25 Japan Trade Center, New Orleans Tokyo        

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