FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

11 rows where State = "NV" sorted by Registration_Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number Registration_Date ▼ Termination_Date Name Business_Name Address_1 Address_2 City State Zip
1006 1957-03-08 1958-09-08 Laxalt, John Maurice   Laxalt, Ross & Laxalt Post Office Box 55 Zephyr Cove NV  
3326 1982-01-27 1989-11-08 Mailho Company   1000 East William Street Suite 100 Carson City NV 89701
3920 1986-12-19 1988-12-31 Maheu, Robert A.   2523 Cochise Lane   Las Vegas NV 89109
5553 2003-04-10 2003-10-31 Rogich Communications Group   3980 Howard Hughes Parkway #550 Las Vegas NV 89109
6095 2012-03-22 2013-09-30 R&R Partners, Inc.   900 South Pavilion Center Drive   Las Vegas NV 89144
6229 2014-06-23 2015-12-07 R&R Partners, Inc.   900 South Pavilion Center Drive   Las Vegas NV 89144
6251 2014-09-25 2014-12-31 Porter Gordon Silver Communications, LLC   3960 Howard Hughes Parkway, 9th Floor   Las Vegas NV 89169
6274 2015-01-19   Rogich Communications Group   11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
6425 2017-04-28   China/US Club, LLC   11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
6528 2018-02-22 2019-01-01 Lee, Christopher G.   296 Francisco Street   Henderson NV 89014
6615 2019-01-13   STRATCOMMS, LLC   3801 Twig Lane   Las Vegas NV 89108

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