home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_Registrants

Table actions
  • GraphQL API for FARA_All_Registrants
List of all registrant data (active and terminated)

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

5 rows where "Registration_Date" is on date 1973-08-09

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Address_1 5

  • 105 West Madison Street 1
  • 1730 Pennsylvania Avenue, N.W. 1
  • 225 North Michigan Avenue 1
  • 26 O'Farrell Street 1
  • 350 South Figueroa Street 1

City 4

  • Chicago 2
  • Los Angeles 1
  • San Francisco 1
  • Washington 1

State 3

  • CA 2
  • IL 2
  • DC 1
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
2446 1973-08-09 1989-04-28 Romanian Foreign Trade Promotion Office, Chicago   105 West Madison Street   Chicago IL 60602
2447 1973-08-09 1989-04-28 Romanian Foreign Trade Promotion Office, Los Angeles   350 South Figueroa Street Suite 944 Los Angeles CA 90071
2448 1973-08-09 2003-11-15 Mexico Tourism Board   225 North Michigan Avenue Suite 1850 Chicago IL 60601-3715
2449 1973-08-09 1974-03-13 Daniel J. Edelman, Inc.   1730 Pennsylvania Avenue, N.W. Suite 460 Washington DC 20006
2450 1973-08-09 1973-08-08 Freeman, Teilmann & Associates Public Relations   26 O'Farrell Street Suite 903 San Francisco CA 94108

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])
);
Powered by Datasette · Queries took 134.074ms · 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