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, atom, 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
72 72   2020-01-10 Porer Hugh Marc 6615 6615 2019-01-13 STRATCOMMS, LLC 3993 Howard Hughes Parkway Suite 780 Las Vegas NV 89169
84 84   2019-01-13 Porter H. Marc 6615 6615 2019-01-13 STRATCOMMS, LLC 3993 Howard Hughes Parkway Suite 780 Las Vegas NV 89169
119 119   2015-01-19 Cole Christopher 6274 6274 2015-01-19 Rogich Communications Group 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
120 120   2015-01-19 Rogich Sigmund 6274 6274 2015-01-19 Rogich Communications Group 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
726 726   2017-04-28 Venners John 6425 6425 2017-04-28 China/US Club, LLC 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
727 727   2017-04-28 Venners Theodore 6425 6425 2017-04-28 China/US Club, LLC 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
3153 3153 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
5206 5206 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
13086 13086 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
13087 13087 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
21392 21392 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
21393 21393 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
21394 21394 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
21395 21395 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
21396 21396 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
21397 21397 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
21398 21398 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
21399 21399 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
29580 29580 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
32301 32301 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
33143 33143 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
35421 35421 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
35422 35422 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
35423 35423 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
35424 35424 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
35425 35425 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
39438 39438 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
39441 39441 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 329.777ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history