FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Short_Form_Termination_Date = "2020-09-30" and "Short_Form_Termination_Date" is on date 2020-09-30
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 11
Registrant_Name 11
City 8
- Washington 7
- Alexandria 2
- Indianapolis 2
- East Rutherford 1
- Houston 1
- Los Angeles 1
- New York 1
- Syracuse 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31689 | 31689 | 2020-09-30 | 2020-01-22 | Lovallo | John | Levick Strategic Communications, LP 6642 | 2019-03-06 | Levick Strategic Communications, LP | 1900 M Street, NW | 4th Floor | Washington | DC | 20036 |
31690 | 31690 | 2020-09-30 | 2019-03-06 | Levick | Richard | Levick Strategic Communications, LP 6642 | 2019-03-06 | Levick Strategic Communications, LP | 1900 M Street, NW | 4th Floor | Washington | DC | 20036 |
31691 | 31691 | 2020-09-30 | 2018-03-19 | Armstrong | Phil | Potomac International Partners, Inc. 6459 | 2017-09-08 | Potomac International Partners, Inc. | 119 Oronoco Street | Suite 101 | Alexandria | VA | 22314 |
31692 | 31692 | 2020-09-30 | 2018-03-19 | Weber | James Daniel | Potomac International Partners, Inc. 6459 | 2017-09-08 | Potomac International Partners, Inc. | 119 Oronoco Street | Suite 101 | Alexandria | VA | 22314 |
31693 | 31693 | 2020-09-30 | 2015-03-20 | Lurie | Alexander | Dentons US LLP 6284 | 2015-03-20 | Dentons US LLP | 1900 K Street, NW | Washington | DC | 20006 | |
31694 | 31694 | 2020-09-30 | 2015-03-20 | Zaki | Jasmine | Dentons US LLP 6284 | 2015-03-20 | Dentons US LLP | 1900 K Street, NW | Washington | DC | 20006 | |
31695 | 31695 | 2020-09-30 | 2020-03-24 | Hurlburt | Ryan | Terakeet LLC 6806 | 2020-03-24 | Terakeet LLC | 333 West Washington Street, Suite 500 | Syracuse | NY | 13202 | |
31696 | 31696 | 2020-09-30 | 2019-04-12 | Koyama | Isao | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
31697 | 31697 | 2020-09-30 | 2018-06-05 | Wooten | Todd | S-3 Group 6422 | 2017-04-26 | S-3 Group | 418 C Street, NE | Washington | DC | 20002 | |
31698 | 31698 | 2020-09-30 | 2020-07-27 | Parker | Claire Buchan | Barnes & Thornburg LLP 6594 | 2018-09-24 | Barnes & Thornburg LLP | 11 South Meridian Street | Indianapolis | IN | 46204 | |
31699 | 31699 | 2020-09-30 | 2019-07-30 | Pike | Chika Yamaga | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
31700 | 31700 | 2020-09-30 | 2018-08-01 | LeBlanc | Donald | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
31701 | 31701 | 2020-09-30 | 2020-08-19 | Meroud Jr. | Jules Frank | Barnes & Thornburg LLP 6594 | 2018-09-24 | Barnes & Thornburg LLP | 11 South Meridian Street | Indianapolis | IN | 46204 | |
31702 | 31702 | 2020-09-30 | 2019-10-07 | Epstein | Jason | Southfive Strategies, LLC 6737 | 2019-10-07 | Southfive Strategies, LLC | 2021 L Street, NW | Suite 101-295 | Washington | DC | 20036 |
31703 | 31703 | 2020-09-30 | 2019-11-22 | Carr | Shahaley | Levick Strategic Communications, LP 6642 | 2019-03-06 | Levick Strategic Communications, LP | 1900 M Street, NW | 4th Floor | Washington | DC | 20036 |
31704 | 31704 | 2020-09-30 | 2017-12-15 | Macias | Stephen Fernando | MWW Group, LLC 6381 | 2016-09-30 | MWW Group, LLC | One Meadowlands Plaza | East Rutherford | NJ | 07073 |
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]) );