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" is on date 2018-11-30
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Registration_Date, Zip
Registration_Number 14
- Mercury Public Affairs, LLC 5
- Barbados Investment & Development Corp. Barbados Tourism 3
- Kit Bond Strategies, LLP 3
- McGuireWoods Consulting, LLC 2
- CGCN Group 2
- MMGY Global, LLC 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Crowell & Moring International, LLC 1
- Polish National Tourist Office, New York 1
- Grassroots Political Consulting LLC 1
- Playmaker Strategies, LLC 1
- Boyamian, Avedis 1
- PASS LLC 1
- Kar-Mar Company LLC d/b/a CBRNE Response Solutions 1
Registrant_Name 14
- Mercury Public Affairs, LLC 5
- Barbados Investment & Development Corp. Barbados Tourism 3
- Kit Bond Strategies, LLP 3
- CGCN Group 2
- MMGY Global, LLC 2
- McGuireWoods Consulting, LLC 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Boyamian, Avedis 1
- Crowell & Moring International, LLC 1
- Grassroots Political Consulting LLC 1
- Kar-Mar Company LLC d/b/a CBRNE Response Solutions 1
- PASS LLC 1
- Playmaker Strategies, LLC 1
- Polish National Tourist Office, New York 1
City 9
- Washington 11
- New York 3
- St. Louis 3
- Overland Park 2
- Richmond 2
- Chicago 1
- Alexandria 1
- Oak Ridge 1
- Winchester 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37099 | 37099 | 2018-11-30 | 2015-01-09 | Braden | Mark | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37100 | 37100 | 2018-11-30 | 2016-01-15 | Gittens | Leslie | Barbados Investment & Development Corp. Barbados Tourism 1995 | 1966-11-30 | Barbados Investment & Development Corp. Barbados Tourism | 820 Second Avenue | 5th Floor | New York | NY | 10017 |
37101 | 37101 | 2018-11-30 | 2016-01-15 | Roach | Petra L. | Barbados Investment & Development Corp. Barbados Tourism 1995 | 1966-11-30 | Barbados Investment & Development Corp. Barbados Tourism | 820 Second Avenue | 5th Floor | New York | NY | 10017 |
37102 | 37102 | 2018-11-30 | 2019-03-08 | Millington | Deborah | Barbados Investment & Development Corp. Barbados Tourism 1995 | 1966-11-30 | Barbados Investment & Development Corp. Barbados Tourism | 820 Second Avenue | 5th Floor | New York | NY | 10017 |
37103 | 37103 | 2018-11-30 | 2018-03-20 | Mitchell | Kathryn Rae | CGCN Group 6396 | 2016-11-30 | CGCN Group | 1307 New York Avenue, NW | 6th Floor | Washington | DC | 20005 |
37104 | 37104 | 2018-11-30 | 2018-03-29 | Garcia | Jose Antonio | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37105 | 37105 | 2018-11-30 | 2018-03-30 | Goff | Mark | PASS LLC 6538 | 2018-03-30 | PASS LLC | 1101 King Street | #360 | Alexandria | VA | 22314 |
37106 | 37106 | 2018-11-30 | 2018-04-02 | Hernandez | Michael Anthony | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37107 | 37107 | 2018-11-30 | 2018-05-03 | Kauchak | Mark | Kar-Mar Company LLC d/b/a CBRNE Response Solutions 6551 | 2018-05-03 | Kar-Mar Company LLC d/b/a CBRNE Response Solutions | 1133 W Outer Drive | Oak Ridge | TN | 37830 | |
37108 | 37108 | 2018-11-30 | 2017-05-05 | Zhang | Yizhi Jing Jing | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 |
37109 | 37109 | 2018-11-30 | 2013-05-14 | Lewis | Katherine | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37110 | 37110 | 2018-11-30 | 2016-06-10 | Liberty | Susan | McGuireWoods Consulting, LLC 6295 | 2015-05-19 | McGuireWoods Consulting, LLC | 800 East Canal Street | Richmond | VA | 23219 | |
37111 | 37111 | 2018-11-30 | 2016-06-14 | Rennolds | Davis | McGuireWoods Consulting, LLC 6295 | 2015-05-19 | McGuireWoods Consulting, LLC | 800 East Canal Street | Richmond | VA | 23219 | |
37112 | 37112 | 2018-11-30 | 2018-06-29 | Hughes | Stephanie | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
37113 | 37113 | 2018-11-30 | 2018-06-29 | Koehly | Chelsea | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
37114 | 37114 | 2018-11-30 | 2008-09-11 | Gilliland | John R. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
37115 | 37115 | 2018-11-30 | 2017-10-31 | Cichonska | Anna | Polish National Tourist Office, New York 4762 | 1993-02-04 | Polish National Tourist Office, New York | 980 N Michigan Ave, STE 1550 | Suite 208 | Chicago | IL | 60611 |
37116 | 37116 | 2018-11-30 | 2017-11-01 | Faraci | Daniel | Grassroots Political Consulting LLC 6483 | 2017-11-01 | Grassroots Political Consulting LLC | P.O. Box 65459 | Washington | DC | 20035 | |
37117 | 37117 | 2018-11-30 | 2017-11-09 | Bond | Christopher S. | Kit Bond Strategies, LLP 6486 | 2017-11-09 | Kit Bond Strategies, LLP | 7733 Forsyth Boulevard | Suite 2200 | St. Louis | MO | 63105 |
37118 | 37118 | 2018-11-30 | 2017-11-09 | Feraci | Manning | Playmaker Strategies, LLC 6487 | 2017-11-09 | Playmaker Strategies, LLC | 750 Ninth Street, NW | Suite 650 | Washington | DC | 20001 |
37119 | 37119 | 2018-11-30 | 2017-11-09 | Hulshof | Kenny C. | Kit Bond Strategies, LLP 6486 | 2017-11-09 | Kit Bond Strategies, LLP | 7733 Forsyth Boulevard | Suite 2200 | St. Louis | MO | 63105 |
37120 | 37120 | 2018-11-30 | 2017-11-09 | Marchio | Shana | Kit Bond Strategies, LLP 6486 | 2017-11-09 | Kit Bond Strategies, LLP | 7733 Forsyth Boulevard | Suite 2200 | St. Louis | MO | 63105 |
37121 | 37121 | 2018-11-30 | 2017-11-14 | Boyamian | Avedis | Boyamian, Avedis 6489 | 2017-11-14 | Boyamian, Avedis | 93 Cambridge Street | Winchester | MA | 01890 | |
37122 | 37122 | 2018-11-30 | 2016-11-30 | Clark | Steve | CGCN Group 6396 | 2016-11-30 | CGCN Group | 1307 New York Avenue, NW | 6th Floor | Washington | DC | 20005 |
37123 | 37123 | 2018-11-30 | 2016-12-09 | Kaufmann | Jennifer | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | 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]) );