FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

28 rows where State = "NV"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
78 78   2020-01-10 Porer Hugh Marc 6615 6615 2019-01-13 STRATCOMMS, LLC 3993 Howard Hughes Parkway Suite 780 Las Vegas NV 89169
88 88   2019-01-13 Porter H. Marc 6615 6615 2019-01-13 STRATCOMMS, LLC 3993 Howard Hughes Parkway Suite 780 Las Vegas NV 89169
114 114   2015-01-19 Cole Christopher 6274 6274 2015-01-19 Rogich Communications Group 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
115 115   2015-01-19 Rogich Sigmund 6274 6274 2015-01-19 Rogich Communications Group 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
764 764   2017-04-28 Venners John 6425 6425 2017-04-28 China/US Club, LLC 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
765 765   2017-04-28 Venners Theodore 6425 6425 2017-04-28 China/US Club, LLC 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
3205 3205 2017-01-06 2015-01-19 Fellows Sean 6274 6274 2015-01-19 Rogich Communications Group 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
5275 5275 2015-01-31 2014-09-25 Cochran Robert 6251 6251 2014-09-25 Porter Gordon Silver Communications, LLC 3960 Howard Hughes Parkway, 9th Floor   Las Vegas NV 89169
13267 13267 2015-04-23 2014-06-23 Tonner Sean 6229 6229 2014-06-23 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
13268 13268 2015-04-23 2014-09-08 Niehaus Jonathon F. 6229 6229 2014-06-23 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
21703 21703 2012-07-11 2012-03-22 O'Neill Peter 6095 6095 2012-03-22 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
21704 21704 2012-07-11 2012-03-22 Ernaut Peter 6095 6095 2012-03-22 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
21705 21705 2012-07-11 2012-03-22 Levy Catherine 6095 6095 2012-03-22 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
21706 21706 2012-07-11 2012-03-22 Marshall Janell 6095 6095 2012-03-22 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
21707 21707 2012-07-11 2012-03-22 Weissman David 6095 6095 2012-03-22 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
21708 21708 2012-07-11 2012-03-26 Richardson Douglas A. 6095 6095 2012-03-22 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
21709 21709 2012-07-11 2012-03-26 Thompson Jeremy B. 6095 6095 2012-03-22 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
21710 21710 2012-07-11 2012-03-26 Tonner Sean Robert 6095 6095 2012-03-22 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
29960 29960 2015-09-30 2015-06-19 Munoz Darrin 6229 6229 2014-06-23 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
32699 32699 2003-10-31 2003-04-10 Rogich Sig A. 5553 5553 2003-04-10 Rogich Communications Group 3980 Howard Hughes Parkway #550 Las Vegas NV 89109
33555 33555 1989-11-08 1982-01-27 Mailho John S. 3326 3326 1982-01-27 Mailho Company 1000 East William Street Suite 100 Carson City NV 89701
35854 35854 2015-12-07 2015-01-26 Landtroop Cathy 6229 6229 2014-06-23 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
35855 35855 2015-12-07 2015-02-10 Boafo Kweku 6229 6229 2014-06-23 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
35856 35856 2015-12-07 2015-02-10 McCafferty Monica 6229 6229 2014-06-23 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
35857 35857 2015-12-07 2015-02-26 Warren Jill 6229 6229 2014-06-23 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
35858 35858 2015-12-07 2015-03-02 Owens William F. 6229 6229 2014-06-23 R&R Partners, Inc. 900 South Pavilion Center Drive   Las Vegas NV 89144
39889 39889 2014-12-31 2014-09-25 Mauer Daniel D. 6251 6251 2014-09-25 Porter Gordon Silver Communications, LLC 3960 Howard Hughes Parkway, 9th Floor   Las Vegas NV 89169
39892 39892 2014-12-31 2014-10-13 Porter Jon C. 6251 6251 2014-09-25 Porter Gordon Silver Communications, LLC 3960 Howard Hughes Parkway, 9th Floor   Las Vegas NV 89169

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_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 434.479ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history