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

16 rows where City = "Falls Church"

View and edit SQL

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

State

City

  • Falls Church · 16
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
1034 1957-06-07 1958-12-07 Sims Jr., John Rogers   804 Ridge Place   Falls Church VA  
3195 1981-02-02 1981-08-25 Jack J. Morris Associates, Inc.   6071 Arlington Boulevard   Falls Church VA 22044
3797 1986-03-21 1998-09-21 National Union for the Total Independence of Angola (UNITA) Center for Democracy in Angola-CEDA-, Inc. 6021 Munson Hill Road   Falls Church VA 22041
3963 1987-04-27 1989-05-16 Northup, Graham T.   2333 Highland Avenue   Falls Church VA 22046
5203 1997-08-26 1998-08-30 Hoffman & Hoffman Public Relations   5683 Columbia Pike Suite 200 Falls Church VA 22041
5338 1999-10-29 2000-05-30 Hoffman and Hoffman Public Relations   5683 Columbia Pike Suite 200 Falls Church VA 22141
5465 2001-10-29 2003-05-31 Reed Smith LLP   3110 Fairview Park Drive Suite 1400 Falls Church VA 22042-0681
5488 2002-04-03 2002-04-03 American Friends of the BNP   P.O. Box 1746   Falls Church VA 22041-1746
5728 2006-01-25 2007-01-31 Pastreich, Emanuel Yi   2032 Peach Orchard Drive T-4 Falls Church VA 22043
5771 2006-09-29 2007-03-31 Adams, Gregory Robert   7214 Hyde Road   Falls Church VA 22043
5779 2006-12-07 2008-12-31 Tramposch, Albert   2111 Preston Square Court   Falls Church VA 22043
5828 2007-09-11 2007-12-31 Farris, Melinda Capital Resources 7307 Arlington Boulevard #185 Falls Church VA 22042
5886 2008-10-09 2009-10-31 Footlik, Jay   3035 Meeting Street   Falls Church VA 22044
5887 2008-10-09 2009-06-01 DiNovo Strategies, LLC   3035 Meeting Street   Falls Church VA 22044
5942 2009-06-15 2009-07-01 Farris, Melinda   7307 Arlington Boulevard #185 Falls Church VA 22042
6497 2017-12-08   Iron Bridge Strategies LLC   5573 Seminary Road Unit 106 Falls Church VA 22041

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 · Query took 34.226ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history