List of all registrant data (active and terminated)

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

2 rows where City = "Wilkes-Barre" and State = "PA"

View and edit SQL

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

State

City

  • Wilkes-Barre · 2
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
2653 1976-01-21 1991-07-22 U.S. Branch Plaid Cymru   C/O Annette J. Thomas 94 North Franklin Street #6 Wilkes-Barre PA 18701-1303
5228 1998-01-15 2000-01-31 Karol Media, Inc.   375 Stewart Road Post Office Box 7600 Wilkes-Barre PA 18773-7600

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])
);