FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where "Date_Stamped" is on date 2020-04-24
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Country
Registrant_Name 12
- Mercury Public Affairs, LLC 4
- JJ&B, LLC 2
- Singapore Tourism Board 2
- TrailRunner International LLC 2
- Larson Shannahan Slifka Group, LLC 1
- McGinnis Lochridge 1
- Racepoint Global, Inc. 1
- Schulman Bhattacharya LLC 1
- Stellar Jay Communications 1
- Summit Information Services Inc. 1
- VisitBritain 1
- Waxman Consulting, Inc. DBA Waxman Strategies 1
Foreign_Principal_Name 11
- - 6
- Turkey-U.S. Business Council (TAIK) 3
- APNU + AFC Coalition 1
- Embassy of the Republic of Azerbaijan to the United States of America 1
- Esquel Enterprises Ltd. 1
- European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) 1
- Huawei Technologies USA 1
- Q Cyber Technologies Ltd 1
- Republika Srpska 1
- Royal Embassy of Saudi Arabia 1
- Royal Embassy of Saudi Arabia through Larson Shannahan Slifka Group, LLC 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
42510 | 42510 | 2020-04-24 | JJ&B, LLC | JJ&B, LLC 6809 | Amendment | https://efile.fara.gov/docs/6809-Amendment-20200424-1.pdf | |||
42511 | 42511 | 2020-04-24 | JJ&B, LLC | JJ&B, LLC 6809 | Exhibit AB | APNU + AFC Coalition | GUYANA | https://efile.fara.gov/docs/6809-Exhibit-AB-20200424-2.pdf | |
42512 | 42512 | 2020-04-24 | Larson Shannahan Slifka Group, LLC | Larson Shannahan Slifka Group, LLC 6749 | Informational Materials | Royal Embassy of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/6749-Informational-Materials-20200424-21.pdf | |
42513 | 42513 | 2020-04-24 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20200424-205.pdf | |
42514 | 42514 | 2020-04-24 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Q Cyber Technologies Ltd | ISRAEL | https://efile.fara.gov/docs/6170-Informational-Materials-20200424-387.pdf | |
42515 | 42515 | 2020-04-24 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200424-388.pdf | |
42516 | 42516 | 2020-04-24 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200424-389.pdf | |
42517 | 42517 | 2020-04-24 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200424-390.pdf | |
42518 | 42518 | 2020-04-24 | Racepoint Global, Inc. | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20200424-163.pdf | |
42519 | 42519 | 2020-04-24 | Schulman Bhattacharya LLC | Schulman Bhattacharya LLC 6742 | Short-Form | Gavenman, Jeffrey S. | https://efile.fara.gov/docs/6742-Short-Form-20200424-8.pdf | ||
42520 | 42520 | 2020-04-24 | Singapore Tourism Board | Singapore Tourism Board 2414 | Short-Form | Ng, Qi Hui | https://efile.fara.gov/docs/2414-Short-Form-20200424-88.pdf | ||
42521 | 42521 | 2020-04-24 | Singapore Tourism Board | Singapore Tourism Board 2414 | Supplemental Statement | https://efile.fara.gov/docs/2414-Supplemental-Statement-20200424-31.pdf | |||
42522 | 42522 | 2020-04-24 | Stellar Jay Communications | Stellar Jay Communications 6789 | Informational Materials | Embassy of the Republic of Azerbaijan to the United States of America | AZERBAIJAN | https://efile.fara.gov/docs/6789-Informational-Materials-20200424-4.pdf | |
42523 | 42523 | 2020-04-24 | Summit Information Services Inc. | Summit Information Services Inc. 6760 | Informational Materials | Royal Embassy of Saudi Arabia through Larson Shannahan Slifka Group, LLC | SAUDI ARABIA | https://efile.fara.gov/docs/6760-Informational-Materials-20200424-3.pdf | |
42524 | 42524 | 2020-04-24 | TrailRunner International LLC | TrailRunner International LLC 6808 | Amendment | https://efile.fara.gov/docs/6808-Amendment-20200424-1.pdf | |||
42525 | 42525 | 2020-04-24 | TrailRunner International LLC | TrailRunner International LLC 6808 | Exhibit AB | Esquel Enterprises Ltd. | CHINA | https://efile.fara.gov/docs/6808-Exhibit-AB-20200424-2.pdf | |
42526 | 42526 | 2020-04-24 | VisitBritain | VisitBritain 579 | Supplemental Statement | https://efile.fara.gov/docs/579-Supplemental-Statement-20200424-35.pdf | |||
42527 | 42527 | 2020-04-24 | Waxman Consulting, Inc. DBA Waxman Strategies | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20200424-200.pdf |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );