FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where "Short_Form_Termination_Date" is on date 2015-06-30
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date)
Registration_Number 13
- Daniel J. Edelman, Inc. 8
- Squire Patton Boggs, LLP 6
- Bryan Cave, LLP 4
- Akin, Gump, Strauss, Hauer & Feld, LLP 2
- Peck, Madigan, Jones & Stewart, Inc. 2
- Lanny J. Davis & Associates, LLC 2
- Kivvit, LLC 2
- Quebec Government Office 1
- Invest Northern Ireland 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- General Delegation of the PLO to the US 1
- Tourism Ireland Limited 1
- Finsbury, LLC 1
Registrant_Name 13
- Daniel J. Edelman, Inc. 8
- Squire Patton Boggs, LLP 6
- Bryan Cave, LLP 4
- Akin, Gump, Strauss, Hauer & Feld, LLP 2
- Kivvit, LLC 2
- Lanny J. Davis & Associates, LLC 2
- Peck, Madigan, Jones & Stewart, Inc. 2
- Finsbury, LLC 1
- General Delegation of the PLO to the US 1
- Invest Northern Ireland 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- Quebec Government Office 1
- Tourism Ireland Limited 1
City 5
- Washington 17
- Chicago 10
- New York 3
- Bannockburn 1
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21816 | 21816 | 2015-06-30 | 2014-01-28 | Lott | Trent | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21817 | 21817 | 2015-06-30 | 2015-02-18 | Carpentier | Lucie | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21818 | 21818 | 2015-06-30 | 2014-03-11 | Verhoff | Geoff | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21819 | 21819 | 2015-06-30 | 2014-04-04 | Thompson | Ryan Day | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21820 | 21820 | 2015-06-30 | 2013-04-08 | Chanin | Michael H. | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
21821 | 21821 | 2015-06-30 | 2013-04-08 | Jesse | Matt | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
21822 | 21822 | 2015-06-30 | 2013-04-08 | Russell | David | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
21823 | 21823 | 2015-06-30 | 1998-04-09 | Epstein | Anita K. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
21824 | 21824 | 2015-06-30 | 2015-05-01 | Belcher | Amanda | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21825 | 21825 | 2015-06-30 | 2015-05-01 | Coxon | Mio | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21826 | 21826 | 2015-06-30 | 2015-05-01 | Eitaki | Kazuki | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21827 | 21827 | 2015-06-30 | 2015-05-01 | Lochmann | Daniel | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21828 | 21828 | 2015-06-30 | 2015-05-01 | Miyazaki | Yosuke | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21829 | 21829 | 2015-06-30 | 2015-05-01 | Rowbury | Ross John | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21830 | 21830 | 2015-06-30 | 2013-05-03 | Wilson | Emily M. | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
21831 | 21831 | 2015-06-30 | 2015-05-12 | Carpenter | Kevin | Finsbury, LLC 6293 | 2015-05-12 | Finsbury, LLC | 3 Columbus Circle, Floor 9 | New York | NY | 10019 | |
21832 | 21832 | 2015-06-30 | 2014-05-18 | Breaux | John B. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21833 | 21833 | 2015-06-30 | 2009-06-09 | Byrne | Joseph | Tourism Ireland Limited 5594 | 2003-11-20 | Tourism Ireland Limited | 345 Park Avenue | New York | NY | 10154 | |
21834 | 21834 | 2015-06-30 | 2014-06-11 | Pajor | Ashley Mandolini | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
21835 | 21835 | 2015-06-30 | 2012-06-12 | Sullivan | Jere | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21836 | 21836 | 2015-06-30 | 2012-06-14 | Brolly | Aine | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
21837 | 21837 | 2015-06-30 | 2015-06-18 | Brodnax | Traci Lashawn | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
21838 | 21838 | 2015-06-30 | 2014-06-24 | Davis | Lanny J. | Lanny J. Davis & Associates, LLC 6230 | 2014-06-24 | Lanny J. Davis & Associates, LLC | 1900 M Street, NW | Suite 300 | Washington | DC | 20036 |
21839 | 21839 | 2015-06-30 | 2014-06-24 | McManus | Eleanor | Lanny J. Davis & Associates, LLC 6230 | 2014-06-24 | Lanny J. Davis & Associates, LLC | 1900 M Street, NW | Suite 300 | Washington | DC | 20036 |
21840 | 21840 | 2015-06-30 | 1999-07-14 | Brand | Joseph L. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21841 | 21841 | 2015-06-30 | 2014-07-24 | Cantor | Andrew | Peck, Madigan, Jones & Stewart, Inc. 6172 | 2013-06-10 | Peck, Madigan, Jones & Stewart, Inc. | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 |
21842 | 21842 | 2015-06-30 | 2014-07-24 | Murphy | Sheila H. | Peck, Madigan, Jones & Stewart, Inc. 6172 | 2013-06-10 | Peck, Madigan, Jones & Stewart, Inc. | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 |
21843 | 21843 | 2015-06-30 | 1995-07-27 | Deschauer | John J., Jr. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21844 | 21844 | 2015-06-30 | 2020-07-30 | Schmaler | Tracy | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
21845 | 21845 | 2015-06-30 | 2012-08-06 | Mirijanian | Peter | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21846 | 21846 | 2015-06-30 | 2020-08-06 | Johnston | Michael | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
21847 | 21847 | 2015-06-30 | 2012-10-04 | Cutts | Matthew D. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 |
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]) );