List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

9 rows where Address_1 = "Embassy of Japan" and City = "Washington"

View and edit SQL

Suggested facets: Address_2, Zip, Registration_Date (date), Termination_Date (date)

State

City

  • Washington · 9

Address_1

  • Embassy of Japan · 9
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
792 1953-10-19 1954-06-12 Singer, Derek S.   Embassy of Japan 2514 Masschusetts Avenue, NW Washington DC  
796 1953-11-18 1963-04-22 Dadian, Arnold Harry   Embassy of Japan 2514 Massachusetts Avenue, NW Washington DC  
811 1954-01-14 1954-01-14 Griggs, Elizabeth Haring   Embassy of Japan 2514 Massachusetts Avenue, NW Washington DC  
836 1954-07-02 1954-07-31 Spencer, William Byron   Embassy of Japan 2514 Massachusetts Avenue, NW Washington DC  
842 1954-08-20 1957-01-31 Brunner, Toby Emanuel Godfrey   Embassy of Japan 2514 Massachusetts Avenue, NW Washington DC  
1705 1964-04-06 1965-10-06 Gregg, Norman Taylor   Embassy of Japan 2520 Massachusetts Avenue, NW Washington DC  
1707 1964-04-08 1966-05-11 Marcus, Algene Ballif   Embassy of Japan 2520 Massachusetts Avenue, NW Washington DC 20008
1993 1966-11-08 1977-11-30 Heffner, Mary A.   Embassy of Japan 2524 Massachusetts Avenue, N.W. Washington DC 20008
2851 1977-12-16 1981-04-02 Potter, Mary Jane   Embassy of Japan 2520 Massachusetts Avenue, NW Washington DC 20008

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);