FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Short_Form_Termination_Date" is on date 2018-10-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1
Registration_Number 8
Registrant_Name 8
City 7
- Kansas City 7
- Eagle 3
- New York 2
- Washington 2
- Cleveland 1
- Fairfax 1
- Oakton 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34708 | 34708 | 2018-10-31 | 2018-01-12 | Boggs | Douglas C. | Manatt, Phelps & Phillips LLP 6506 | 2018-01-12 | Manatt, Phelps & Phillips LLP | 1050 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 |
34709 | 34709 | 2018-10-31 | 2020-02-19 | Harris | Devon | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
34710 | 34710 | 2018-10-31 | 2019-04-15 | Cerullo | Timothy James | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
34711 | 34711 | 2018-10-31 | 2019-04-15 | Conaghan | Ben | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
34712 | 34712 | 2018-10-31 | 2019-04-15 | Conaghan | Ben | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
34713 | 34713 | 2018-10-31 | 2019-04-15 | Hurnevich | Merve Lara | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
34714 | 34714 | 2018-10-31 | 2019-04-15 | Keenan | Nick | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
34715 | 34715 | 2018-10-31 | 2019-04-15 | Patterson | William R. | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
34716 | 34716 | 2018-10-31 | 2018-04-28 | Reiser | Armand E. | Reiser, Armand E. 6548 | 2018-04-28 | Reiser, Armand E. | 3025 Barden Oaks Court | Oakton | VA | 22124 | |
34717 | 34717 | 2018-10-31 | 2018-05-18 | Thomas | Frederick | MHz Networks LLC 6553 | 2018-05-18 | MHz Networks LLC | 2750 Prosperity Avenue | Suite 430 | Fairfax | VA | 22031 |
34718 | 34718 | 2018-10-31 | 2017-05-31 | Mellin | Carolyn | International Merchandising Corporation 6032 | 2011-04-14 | International Merchandising Corporation | 1360 East 9th Street | Suite 100 | Cleveland | OH | 44114 |
34719 | 34719 | 2018-10-31 | 2018-07-17 | Cranney | W. Todd | Riverwood Strategies, LLC 6577 | 2018-07-17 | Riverwood Strategies, LLC | 439 E. Shore Drive | Suite 100 | Eagle | ID | 83616 |
34720 | 34720 | 2018-10-31 | 2018-07-17 | Hawkes | Travis | Riverwood Strategies, LLC 6577 | 2018-07-17 | Riverwood Strategies, LLC | 439 E. Shore Drive | Suite 100 | Eagle | ID | 83616 |
34721 | 34721 | 2018-10-31 | 2018-07-17 | Jensen | Candice | Riverwood Strategies, LLC 6577 | 2018-07-17 | Riverwood Strategies, LLC | 439 E. Shore Drive | Suite 100 | Eagle | ID | 83616 |
34722 | 34722 | 2018-10-31 | 2015-09-29 | Walsh | Brian J. | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
34723 | 34723 | 2018-10-31 | 2018-10-31 | Atkins | James | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | |
34724 | 34724 | 2018-10-31 | 2018-10-31 | Singer | Philip | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );