FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where City = "Washington", "Short_Form_Termination_Date" is on date 2020-12-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 12
- Waxman Consulting, Inc. DBA Waxman Strategies 6
- Akin, Gump, Strauss, Hauer & Feld, LLP 3
- Squire Patton Boggs, LLP 2
- Mercury Public Affairs, LLC 2
- DCI Group AZ, LLC 2
- Center for International Policy 2
- Representative of German Industry and Trade 1
- BGR Government Affairs, LLC 1
- Ballard Partners 1
- Avenue Strategies, LLC 1
- McDermott Will & Emery, LLP 1
- Tenam Corporation 1
Registrant_Name 12
- Waxman Consulting, Inc. DBA Waxman Strategies 6
- Akin, Gump, Strauss, Hauer & Feld, LLP 3
- Center for International Policy 2
- DCI Group AZ, LLC 2
- Mercury Public Affairs, LLC 2
- Squire Patton Boggs, LLP 2
- Avenue Strategies, LLC 1
- BGR Government Affairs, LLC 1
- Ballard Partners 1
- McDermott Will & Emery, LLP 1
- Representative of German Industry and Trade 1
- Tenam Corporation 1
State 1
- DC · 23 ✖
City 1
- Washington · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42309 | 42309 | 2020-12-31 | 2018-01-17 | Osborne | Jason | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 601 Thirteenth Street, NW | Eleventh Floor South | Washington | DC | 20005 |
42312 | 42312 | 2020-12-31 | 2019-02-18 | Newton | Fletcher T. | Tenam Corporation 6638 | 2019-02-18 | Tenam Corporation | 655 15th Street, NW | Suite 800 | Washington | DC | 20005 |
42313 | 42313 | 2020-12-31 | 2020-02-20 | Peterson | Justin | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 |
42317 | 42317 | 2020-12-31 | 2018-04-18 | McCarthy | Justin | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
42320 | 42320 | 2020-12-31 | 2019-04-30 | Vilkos | Yulianna | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
42321 | 42321 | 2020-12-31 | 2019-05-03 | Meyerweissflog | Viola Amelie | 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 |
42325 | 42325 | 2020-12-31 | 2020-06-12 | Wijeratna | Alexander Philip Lerwill | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 1150 Connecticut Avenue, NW | Suite 800 | Washington | DC | 20036 |
42328 | 42328 | 2020-12-31 | 2020-06-23 | Higgins | Casey | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
42329 | 42329 | 2020-12-31 | 2019-06-28 | Wilson | Louis J. | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
42336 | 42336 | 2020-12-31 | 2019-07-23 | Bondi | Pamela | Ballard Partners 6415 | 2017-04-05 | Ballard Partners | 601 Thirteenth Street, NW | Suite 450 N | Washington | DC | 20005 |
42337 | 42337 | 2020-12-31 | 2017-07-27 | Ryan | Stephen M. | McDermott Will & Emery, LLP 6447 | 2017-07-27 | McDermott Will & Emery, LLP | 500 North Capitol Street, NW | Washington | DC | 20001-1531 | |
42338 | 42338 | 2020-12-31 | 2019-08-23 | Hansbrough | Margaret | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 1150 Connecticut Avenue, NW | Suite 800 | Washington | DC | 20036 |
42339 | 42339 | 2020-12-31 | 2019-08-23 | Hurowitz | Glenn | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 1150 Connecticut Avenue, NW | Suite 800 | Washington | DC | 20036 |
42340 | 42340 | 2020-12-31 | 2019-08-23 | Rey | Mark | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 1150 Connecticut Avenue, NW | Suite 800 | Washington | DC | 20036 |
42341 | 42341 | 2020-12-31 | 2019-08-23 | Waxman | Henry | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 1150 Connecticut Avenue, NW | Suite 800 | Washington | DC | 20036 |
42342 | 42342 | 2020-12-31 | 2019-08-23 | von Reusner | Lucia | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 1150 Connecticut Avenue, NW | Suite 800 | Washington | DC | 20036 |
42343 | 42343 | 2020-12-31 | 2020-08-24 | Taborda | Andres | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 |
42344 | 42344 | 2020-12-31 | 2007-08-29 | Slater | Rodney | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
42346 | 42346 | 2020-12-31 | 2015-09-25 | Deschauer Jr. | John J. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
42351 | 42351 | 2020-12-31 | 2020-10-13 | Bennett | Barry | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 1627 I Street, NW | Suite 825 | Washington | DC | 20006 |
42352 | 42352 | 2020-12-31 | 2017-11-16 | Poling | Jonathan | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
42354 | 42354 | 2020-12-31 | 2020-11-25 | Weiss | Heather | Center for International Policy 6896 | 2020-11-25 | Center for International Policy | 2000 M Street, NW | Suite 720 | Washington | DC | 20036 |
42355 | 42355 | 2020-12-31 | 2020-11-25 | Younglee Feron | Henri Vincent | Center for International Policy 6896 | 2020-11-25 | Center for International Policy | 2000 M Street, NW | Suite 720 | Washington | DC | 20036 |
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]) );