FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where Short_Form_Termination_Date = "2021-01-15"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3838 | 3838 | 2021-01-15 | 2018-02-02 | Rose | Peter Alan | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
3839 | 3839 | 2021-01-15 | 2020-02-20 | Streit | Matthew Alan | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3840 | 3840 | 2021-01-15 | 2020-02-20 | Thompson | Jeremy Solomon | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3841 | 3841 | 2021-01-15 | 2020-02-26 | Mansfield | Adalie Joy | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3842 | 3842 | 2021-01-15 | 2020-03-11 | Coughlan | William R. | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3843 | 3843 | 2021-01-15 | 2020-03-11 | De Jesus | Jessica Joy Sayson | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3844 | 3844 | 2021-01-15 | 2020-03-11 | Ryan | Conor Patrick | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3845 | 3845 | 2021-01-15 | 2020-03-11 | Zenatti | Ana Paula De Assis | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3846 | 3846 | 2021-01-15 | 2020-03-11 | de Vlaming | Lauren | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3847 | 3847 | 2021-01-15 | 2020-03-20 | Stokes | Benjamin Noel | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3848 | 3848 | 2021-01-15 | 2020-04-02 | Edelman | Amanda | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3849 | 3849 | 2021-01-15 | 2019-05-19 | Payne | Stephen | Linden Government Solutions, LLC 6682 | 2019-05-19 | Linden Government Solutions, LLC | 5120 Woodway Drive | Suite 5004 | Houston | TX | 77056 |
3850 | 3850 | 2021-01-15 | 2019-05-28 | Fleming | Joseph | Linden Government Solutions, LLC 6682 | 2019-05-19 | Linden Government Solutions, LLC | 5120 Woodway Drive | Suite 5004 | Houston | TX | 77056 |
3851 | 3851 | 2021-01-15 | 2020-07-08 | Jarrell | Kent W | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
3852 | 3852 | 2021-01-15 | 2020-07-08 | Marchman | Benjamin Richard | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
3853 | 3853 | 2021-01-15 | 2020-07-08 | Reischer | Rosalind | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
3854 | 3854 | 2021-01-15 | 2021-07-28 | Hould | Jean-Francois | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
3855 | 3855 | 2021-01-15 | 2020-08-19 | Cazalet | Eloise Margaret Rose | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3856 | 3856 | 2021-01-15 | 2019-08-26 | Ontiveros-Oberg | Adam | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3857 | 3857 | 2021-01-15 | 2020-08-26 | Garvey | Alex | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3858 | 3858 | 2021-01-15 | 2020-08-26 | Hedley | Devon Thomas | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3859 | 3859 | 2021-01-15 | 2020-08-26 | Reid | Ross John | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3860 | 3860 | 2021-01-15 | 2020-08-27 | Iorio | Bennett | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3861 | 3861 | 2021-01-15 | 2020-08-27 | Lock | Benjamin | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3862 | 3862 | 2021-01-15 | 2020-08-28 | Mughal | Hannah | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
3863 | 3863 | 2021-01-15 | 2020-10-08 | Workman | Daniel | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
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]) );