FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where "Short_Form_Termination_Date" is on date 2015-07-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Address_1, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 18
- Dickstein Shapiro, LLP 3
- Fletcher Rowley, Inc. 3
- APCO Worldwide, Inc. 3
- Quebec Government Office 2
- Rasky Baerlein Strategic Communications, Inc. 2
- VisitBritain 1
- Arab Information Center 1
- JETRO, San Francisco 1
- JETRO, Houston 1
- Japan National Tourism Organization, Los Angeles 1
- British Virgin Islands Tourist Board 1
- Harbour Group, LLC 1
- Council of Khalistan 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- KBS America, Inc. 1
- Valladares, Fernando 1
- Quinn Thomas Public Affairs, LLC 1
- Outreach Strategies, LLC 1
Registrant_Name 18
- APCO Worldwide, Inc. 3
- Dickstein Shapiro, LLP 3
- Fletcher Rowley, Inc. 3
- Quebec Government Office 2
- Rasky Baerlein Strategic Communications, Inc. 2
- Arab Information Center 1
- British Virgin Islands Tourist Board 1
- Council of Khalistan 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- Harbour Group, LLC 1
- JETRO, Houston 1
- JETRO, San Francisco 1
- Japan National Tourism Organization, Los Angeles 1
- KBS America, Inc. 1
- Outreach Strategies, LLC 1
- Quinn Thomas Public Affairs, LLC 1
- Valladares, Fernando 1
- VisitBritain 1
City 9
- Washington 11
- New York 4
- Nashville 3
- Boston 2
- Los Angeles 2
- Costa Mesa 1
- Houston 1
- Lake Oswego 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25258 | 25258 | 2015-07-31 | 2015-02-02 | Granum | Rex Lars | Rasky Baerlein Strategic Communications, Inc. 6222 | 2014-05-16 | Rasky Baerlein Strategic Communications, Inc. | 70 Franklin Street | 3rd Floor | Boston | MA | 02110 |
25259 | 25259 | 2015-07-31 | 2013-02-27 | Paquette | Daniel | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
25260 | 25260 | 2015-07-31 | 2004-03-16 | Aulakh | Gurmit Singh | Council of Khalistan 5597 | 2004-01-21 | Council of Khalistan | 730 24th Street, N.W. | Suite 310 | Washington | DC | 20037 |
25261 | 25261 | 2015-07-31 | 2015-03-23 | Reiten | Richard | Quinn Thomas Public Affairs, LLC 6283 | 2015-03-19 | Quinn Thomas Public Affairs, LLC | 5 Centerpointe Drive | Suite 570 | Lake Oswego | OR | 97035 |
25262 | 25262 | 2015-07-31 | 2015-03-25 | Norton | Ruya | Outreach Strategies, LLC 6286 | 2015-03-25 | Outreach Strategies, LLC | 1001 Connecticut Avenue, NW | Suite 704 | Washington | DC | 20036 |
25263 | 25263 | 2015-07-31 | 2013-04-23 | Zhao | Yiou | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
25264 | 25264 | 2015-07-31 | 2015-04-23 | Goss | Porter | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
25265 | 25265 | 2015-07-31 | 2013-05-03 | Cardona | Carlos Enrique | Valladares, Fernando 6167 | 2013-05-03 | Valladares, Fernando | 490 Travirst Drive | Costa Mesa | CA | 92626 | |
25266 | 25266 | 2015-07-31 | 2012-05-23 | Rose | Peter Alan | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
25267 | 25267 | 2015-07-31 | 2018-05-23 | Sarhan | Salah | Arab Information Center 876 | 1955-03-03 | Arab Information Center | League of Arab States | 1100 17th Street, N.W., Suite 201 | Washington | DC | 20036 |
25268 | 25268 | 2015-07-31 | 2012-06-21 | Greene | Jason | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
25269 | 25269 | 2015-07-31 | 2015-06-22 | Eymond-Laritaz | Thomas | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
25270 | 25270 | 2015-07-31 | 2015-06-22 | King | Richard | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
25271 | 25271 | 2015-07-31 | 2014-06-26 | Leibach | Dale William | Rasky Baerlein Strategic Communications, Inc. 6222 | 2014-05-16 | Rasky Baerlein Strategic Communications, Inc. | 70 Franklin Street | 3rd Floor | Boston | MA | 02110 |
25272 | 25272 | 2015-07-31 | 2013-07-09 | Fletcher | William | Fletcher Rowley, Inc. 6173 | 2013-07-09 | Fletcher Rowley, Inc. | 1720 West End Avenue | Suite 630 | Nashville | TN | 37203 |
25273 | 25273 | 2015-07-31 | 2013-07-09 | Morgan | Mark | Fletcher Rowley, Inc. 6173 | 2013-07-09 | Fletcher Rowley, Inc. | 1720 West End Avenue | Suite 630 | Nashville | TN | 37203 |
25274 | 25274 | 2015-07-31 | 2013-07-09 | Rowley | John | Fletcher Rowley, Inc. 6173 | 2013-07-09 | Fletcher Rowley, Inc. | 1720 West End Avenue | Suite 630 | Nashville | TN | 37203 |
25275 | 25275 | 2015-07-31 | 2014-10-03 | Carrier | Jennifer | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
25276 | 25276 | 2015-07-31 | 2014-10-03 | Thompson | David | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
25277 | 25277 | 2015-07-31 | 2013-10-09 | Simmons | Joanne | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 |
25278 | 25278 | 2015-07-31 | 2013-10-18 | Brophy | Susan | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
25279 | 25279 | 2015-07-31 | 2003-10-29 | Smith | Iverson | British Virgin Islands Tourist Board 3354 | 1982-04-08 | British Virgin Islands Tourist Board | 1 West 34th Street | Suite 302 | New York | NY | 10001-3011 |
25280 | 25280 | 2015-07-31 | 2013-10-30 | El-Haj | Amara | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
25281 | 25281 | 2015-07-31 | 2015-11-05 | Patch | Alison | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
25282 | 25282 | 2015-07-31 | 2013-12-26 | Kim | Kyung Hee | KBS America, Inc. 5684 | 2005-05-17 | KBS America, Inc. | 625 South Kingsley Drive | 4th Floor | Los Angeles | CA | 90005 |
25283 | 25283 | 2015-07-31 | 2014-12-30 | Tonai | Daisuke | 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 |
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]) );