FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where "Short_Form_Termination_Date" is on date 2018-03-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Address_1, Address_2, Short_Form_Termination_Date (date)
Registration_Number 10
Registrant_Name 10
City 5
- Washington 14
- New York 3
- Seattle 2
- Alexandria 1
- Los Angeles 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12215 | 12215 | 2018-03-31 | 2018-01-24 | Cooper | Christopher | Trippi & Associates 6515 | 2018-01-24 | Trippi & Associates | 1133 15th Street, NW | 8th Floor | Washington | DC | 20005 |
12216 | 12216 | 2018-03-31 | 2018-01-24 | Haber | Jon | Trippi & Associates 6515 | 2018-01-24 | Trippi & Associates | 1133 15th Street, NW | 8th Floor | Washington | DC | 20005 |
12217 | 12217 | 2018-03-31 | 2018-01-24 | Ricci | Andrew | Trippi & Associates 6515 | 2018-01-24 | Trippi & Associates | 1133 15th Street, NW | 8th Floor | Washington | DC | 20005 |
12218 | 12218 | 2018-03-31 | 2018-01-24 | Trippi | Joe | Trippi & Associates 6515 | 2018-01-24 | Trippi & Associates | 1133 15th Street, NW | 8th Floor | Washington | DC | 20005 |
12219 | 12219 | 2018-03-31 | 2017-02-06 | Hasegawa | Ryoko | Japan National Tourism Organization, Los Angeles 2350 | 1972-07-03 | Japan National Tourism Organization, Los Angeles | 707 Wilshire Blvd. | Suite 4325 | Los Angeles | CA | 90017 |
12220 | 12220 | 2018-03-31 | 2016-02-09 | Nave | Andrew | Kobe Trade Information Office 2438 | 1973-07-02 | Kobe Trade Information Office | 1001 Fourth Avenue | Suite 4310 | Seattle | WA | 98154 |
12221 | 12221 | 2018-03-31 | 2018-02-14 | Chwat | John | Chwat, John 6525 | 2018-02-14 | Chwat, John | 1423 Powhatan Street | Suite 1 | Alexandria | VA | 22314 |
12222 | 12222 | 2018-03-31 | 2017-03-01 | Reid | Morris | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
12223 | 12223 | 2018-03-31 | 2018-03-20 | Cocchiaro | Alec | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
12224 | 12224 | 2018-03-31 | 2017-05-24 | Garrido | Jorge | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
12225 | 12225 | 2018-03-31 | 2017-05-24 | McFetridge | Duncan | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
12226 | 12226 | 2018-03-31 | 2017-05-24 | Romano | Luis Rosendo Gutierrez | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
12227 | 12227 | 2018-03-31 | 2015-07-07 | Smart | David A. | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
12228 | 12228 | 2018-03-31 | 2017-07-20 | Schumacher | Lauren | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 700 New Hampshire Avenue, NW | Watergate South, Suite 1019 | Washington | DC | 20037 |
12229 | 12229 | 2018-03-31 | 2015-08-18 | Sometani | Tetsuya | Kobe Trade Information Office 2438 | 1973-07-02 | Kobe Trade Information Office | 1001 Fourth Avenue | Suite 4310 | Seattle | WA | 98154 |
12230 | 12230 | 2018-03-31 | 2014-09-19 | Tan | LI-Wen Melanie | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
12231 | 12231 | 2018-03-31 | 2015-10-05 | Thompson | Stephen Mark | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 700 New Hampshire Avenue, NW | Watergate South, Suite 1019 | Washington | DC | 20037 |
12232 | 12232 | 2018-03-31 | 2012-10-15 | McLean | Matthew | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 700 New Hampshire Avenue, NW | Watergate South, Suite 1019 | Washington | DC | 20037 |
12233 | 12233 | 2018-03-31 | 2000-12-01 | Butterfield | R. Ian | Butterfield Carter and Associates 5398 | 2000-12-01 | Butterfield Carter and Associates | P.O. Box 76600 | 304 G St., SE | Washington | DC | 20013 |
12234 | 12234 | 2018-03-31 | 2000-12-01 | Carter | Gavin J. | Butterfield Carter and Associates 5398 | 2000-12-01 | Butterfield Carter and Associates | P.O. Box 76600 | 304 G St., SE | Washington | DC | 20013 |
12235 | 12235 | 2018-03-31 | 2014-12-15 | Resch | Gary | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 |
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]) );