FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
34 rows where Registration_Date = "2016-10-28"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
885 | 885 | 2023-04-26 | Hernandez | Saul | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 | |
1106 | 1106 | 2022-05-25 | Aguilar | Jorge A. | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 | |
1140 | 1140 | 2021-05-28 | Williams | Eriade | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 | |
2048 | 2048 | 2016-10-28 | Collins | Arthur | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 | |
2049 | 2049 | 2016-10-28 | Henry | Sudafi | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 | |
2050 | 2050 | 2016-10-28 | Miller | Paul | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 | |
2051 | 2051 | 2016-10-28 | Thompson | Darrel | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 | |
2113 | 2113 | 2022-11-04 | Nsiah | Joseph Kwabena | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 | |
7488 | 7488 | 2018-02-23 | 2017-09-14 | Quan | Renee | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
8323 | 8323 | 2017-02-28 | 2016-10-28 | Hunter | Henry | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 |
16686 | 16686 | 2018-05-18 | 2017-09-14 | Abueva | Jerone | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
20596 | 20596 | 2018-06-29 | 2016-10-28 | Hernandez | Michelle | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 |
26291 | 26291 | 2018-08-08 | 2016-10-28 | Collins | Andrew | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 |
28636 | 28636 | 2018-08-31 | 2018-05-09 | Bine | David | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28637 | 28637 | 2018-08-31 | 2018-05-09 | Eselevsky | Hayley | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28638 | 28638 | 2018-08-31 | 2018-05-09 | Haimes | Deborah | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28639 | 28639 | 2018-08-31 | 2018-05-09 | Jones | Jeff | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28640 | 28640 | 2018-08-31 | 2018-05-09 | Patterson | Camille Palo | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28645 | 28645 | 2018-08-31 | 2017-09-14 | Don | Matthew | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28646 | 28646 | 2018-08-31 | 2017-09-14 | Garrett | Stuart | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28647 | 28647 | 2018-08-31 | 2017-09-14 | Katz | Phillip | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28648 | 28648 | 2018-08-31 | 2017-09-14 | Mitchell | Catherine Downes | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28649 | 28649 | 2018-08-31 | 2017-09-14 | Pathiyil | Amy J. | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28650 | 28650 | 2018-08-31 | 2017-09-14 | Peplov | Artem | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28651 | 28651 | 2018-08-31 | 2017-09-14 | Rakos | Patricia | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28652 | 28652 | 2018-08-31 | 2017-09-14 | Tellup | Michael | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28653 | 28653 | 2018-08-31 | 2017-09-14 | Waldner | Robert | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28654 | 28654 | 2018-08-31 | 2017-09-14 | Williams | Kali | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
28655 | 28655 | 2018-08-31 | 2017-09-14 | Zahir | Mike | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
29781 | 29781 | 2018-09-14 | 2017-09-14 | Buchan | Debbie | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
30245 | 30245 | 2018-09-21 | 2017-09-14 | Kunze | Amanda | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
31726 | 31726 | 2022-09-30 | 2021-05-28 | Bolton | Dwayne | theGroup DC, LLC 6388 | 2016-10-28 | theGroup DC, LLC | 1730 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20006 |
33442 | 33442 | 2018-10-22 | 2017-09-14 | Becker | David C. | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
38851 | 38851 | 2017-12-20 | 2017-09-14 | Hisler | Rebecca | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | 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]) );