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 = "2022-05-31"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 9
Registrant_Name 9
City 5
- London 13
- Washington 9
- Syracuse 2
- Atlanta 1
- Chicago 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18249 | 18249 | 2022-05-31 | 2018-01-30 | Jablon | Ann | Capitol Counsel, LLC 6328 | 2015-11-19 | Capitol Counsel, LLC | 700 13th Street, NW | Suite 200 | Washington | DC | 20005 |
18250 | 18250 | 2022-05-31 | 2020-01-31 | Yeung | Keiko | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
18251 | 18251 | 2022-05-31 | 2022-03-10 | Rabinowitz | Steven | Rabinowitz, Inc. d/b/a Bluelight Strategies 7094 | 2022-03-10 | Rabinowitz, Inc. d/b/a Bluelight Strategies | 4201 Connecticut Avenue, NW | Suite 211 | Washington | DC | 20008 |
18252 | 18252 | 2022-05-31 | 2022-05-04 | Leone | Samantha | Terakeet LLC 6806 | 2020-03-24 | Terakeet LLC | 333 West Washington Street, Suite 500 | Syracuse | NY | 13202 | |
18253 | 18253 | 2022-05-31 | 2004-06-01 | Epstein | Jonathan M. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
18254 | 18254 | 2022-05-31 | 2018-08-30 | Lang | Joachim | Representative of German Industry and Trade 4274 | 1989-07-21 | Representative of German Industry and Trade | 1130 Connecticut Avenue, NW | Suite 1200 | Washington | DC | 20036 |
18255 | 18255 | 2022-05-31 | 2021-09-03 | Alameh | Lara S. | CTF Global LLC 7008 | 2021-09-03 | CTF Global LLC | 1401 New York Avenue, NW | Suite 925 | Washington | DC | 20005 |
18256 | 18256 | 2022-05-31 | 2021-09-03 | Floyd | Price B. | CTF Global LLC 7008 | 2021-09-03 | CTF Global LLC | 1401 New York Avenue, NW | Suite 925 | Washington | DC | 20005 |
18257 | 18257 | 2022-05-31 | 2021-09-03 | Grossman | Lawrence C. | CTF Global LLC 7008 | 2021-09-03 | CTF Global LLC | 1401 New York Avenue, NW | Suite 925 | Washington | DC | 20005 |
18258 | 18258 | 2022-05-31 | 2017-09-18 | Finley | Shannon | Capitol Counsel, LLC 6328 | 2015-11-19 | Capitol Counsel, LLC | 700 13th Street, NW | Suite 200 | Washington | DC | 20005 |
18259 | 18259 | 2022-05-31 | 2020-10-29 | MacBlane | Lauren | Terakeet LLC 6806 | 2020-03-24 | Terakeet LLC | 333 West Washington Street, Suite 500 | Syracuse | NY | 13202 | |
18260 | 18260 | 2022-05-31 | 2021-11-01 | Baker | Zara | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18261 | 18261 | 2022-05-31 | 2021-11-01 | Birnbaum | George Eli | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18262 | 18262 | 2022-05-31 | 2021-11-01 | Collier | Benjamin Britworth | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18263 | 18263 | 2022-05-31 | 2021-11-01 | Denselow | Toby | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18264 | 18264 | 2022-05-31 | 2021-11-01 | Galan | Vladislava | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18265 | 18265 | 2022-05-31 | 2021-11-01 | Hassan | Miran | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18266 | 18266 | 2022-05-31 | 2021-11-01 | McMillan | Thomas Jock | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18267 | 18267 | 2022-05-31 | 2021-11-01 | Ogborn | William | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18268 | 18268 | 2022-05-31 | 2021-11-01 | Reid | Morris | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18269 | 18269 | 2022-05-31 | 2021-11-01 | Toomey | Molly | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18270 | 18270 | 2022-05-31 | 2021-11-01 | Walker | Alexander | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18271 | 18271 | 2022-05-31 | 2021-11-02 | Walker | Alexander DJ | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London | |||
18272 | 18272 | 2022-05-31 | 2018-11-13 | Murray | Debora Comenalli | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
18273 | 18273 | 2022-05-31 | 2015-11-19 | Han | Allegra | Capitol Counsel, LLC 6328 | 2015-11-19 | Capitol Counsel, LLC | 700 13th Street, NW | Suite 200 | Washington | DC | 20005 |
18274 | 18274 | 2022-05-31 | 2021-12-14 | Fabian | Olamide Noah | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | 91 Jermyn Street, First Floor | London |
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]) );