FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where Short_Form_Termination_Date = "2019-07-31" sorted by State
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 13
- Daniel J. Edelman, Inc. 6
- Clyde Group, LLC 6
- KOTRA 2
- Aramco Affiliated Services Company (AASC) 2
- JETRO, New York 1
- Quebec Government Office 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- Independent Diplomat, Inc. 1
- Livingston Group, LLC 1
- S.G.R. LLC Government Relations and Lobbying 1
- FTI Consulting LLP 1
- Castillo, Edward O. 1
- Zeno Group, Inc. 1
Registrant_Name 13
- Clyde Group, LLC 6
- Daniel J. Edelman, Inc. 6
- Aramco Affiliated Services Company (AASC) 2
- KOTRA 2
- Castillo, Edward O. 1
- FTI Consulting LLP 1
- Independent Diplomat, Inc. 1
- JETRO, New York 1
- Livingston Group, LLC 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- Quebec Government Office 1
- S.G.R. LLC Government Relations and Lobbying 1
- Zeno Group, Inc. 1
City 7
- Washington 8
- Chicago 7
- New York 5
- Houston 2
- London 1
- San Francisco 1
- Westport 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25356 | 25356 | 2019-07-31 | 2018-07-09 | Earl | Jonathan Richard | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
25351 | 25351 | 2019-07-31 | 2019-02-23 | Putorti | Matthew F. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
25352 | 25352 | 2019-07-31 | 2019-03-11 | Castillo | Edward O. | Castillo, Edward O. 6643 | 2019-03-11 | Castillo, Edward O. | 2a Stony Point Road | Westport | CT | 06880 | |
25344 | 25344 | 2019-07-31 | 2019-01-28 | Greer | Kate | Clyde Group, LLC 6631 | 2019-01-28 | Clyde Group, LLC | 1411 K Street, NW | 3rd Floor | Washington | DC | 20005 |
25345 | 25345 | 2019-07-31 | 2019-01-28 | McIntosh Burke | Fiona Alexandra | Clyde Group, LLC 6631 | 2019-01-28 | Clyde Group, LLC | 1411 K Street, NW | 3rd Floor | Washington | DC | 20005 |
25346 | 25346 | 2019-07-31 | 2019-01-28 | McLean | Connor | Clyde Group, LLC 6631 | 2019-01-28 | Clyde Group, LLC | 1411 K Street, NW | 3rd Floor | Washington | DC | 20005 |
25347 | 25347 | 2019-07-31 | 2019-01-28 | Slater | Alex | Clyde Group, LLC 6631 | 2019-01-28 | Clyde Group, LLC | 1411 K Street, NW | 3rd Floor | Washington | DC | 20005 |
25348 | 25348 | 2019-07-31 | 2019-01-28 | Smith | Scott Nolan | Clyde Group, LLC 6631 | 2019-01-28 | Clyde Group, LLC | 1411 K Street, NW | 3rd Floor | Washington | DC | 20005 |
25349 | 25349 | 2019-07-31 | 2019-01-28 | White | Olivia | Clyde Group, LLC 6631 | 2019-01-28 | Clyde Group, LLC | 1411 K Street, NW | 3rd Floor | Washington | DC | 20005 |
25364 | 25364 | 2019-07-31 | 2018-09-07 | McEwen | Bob | Livingston Group, LLC 6344 | 2016-03-25 | Livingston Group, LLC | 499 S. Capitol Street, SW | Suite 600 | Washington | DC | 20003 |
25365 | 25365 | 2019-07-31 | 2016-09-20 | Lowman | Greg | S.G.R. LLC Government Relations and Lobbying 6379 | 2016-09-20 | S.G.R. LLC Government Relations and Lobbying | 1775 Eye Street, NW | Suite 410 | Washington | DC | 20006 |
25353 | 25353 | 2019-07-31 | 2018-04-27 | Dingwell | Makena | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25355 | 25355 | 2019-07-31 | 2019-05-28 | Eickemeyer | Nicholas | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | |
25358 | 25358 | 2019-07-31 | 2019-08-02 | Garvey | Alex Edward | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25359 | 25359 | 2019-07-31 | 2019-08-02 | Sayson De Jesus | Jessica Joy | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25360 | 25360 | 2019-07-31 | 2019-08-06 | McDermott | Evie Violet | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25361 | 25361 | 2019-07-31 | 2019-08-08 | Deepak | Kumar | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25362 | 25362 | 2019-07-31 | 2019-08-08 | Imogen | Kathryn Long | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25350 | 25350 | 2019-07-31 | 2018-02-02 | Hould | Jean Francois | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
25354 | 25354 | 2019-07-31 | 2016-05-27 | Kim | Jiyoung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25357 | 25357 | 2019-07-31 | 2009-07-10 | Lake | Jennifer Anne | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 246 Fifth Avenue | New York | NY | 10001 | |
25363 | 25363 | 2019-07-31 | 2016-08-09 | Numata | Shigehito | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25367 | 25367 | 2019-07-31 | 2016-11-30 | Park | Taewha | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25343 | 25343 | 2019-07-31 | 2019-01-08 | AlRumaih | Saleh I. | Aramco Affiliated Services Company (AASC) 6390 | 2016-11-14 | Aramco Affiliated Services Company (AASC) | Two Allen Center | 1200 Smith Street, 36th Floor | Houston | TX | 77002 |
25366 | 25366 | 2019-07-31 | 2016-11-14 | Abul-Hamayel | B.A. | Aramco Affiliated Services Company (AASC) 6390 | 2016-11-14 | Aramco Affiliated Services Company (AASC) | Two Allen Center | 1200 Smith Street, 36th Floor | Houston | TX | 77002 |
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]) );