FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
37 rows where "Date_Stamped" is on date 2020-03-04
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Date_Stamped
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
25200 | 25200 | 2020-03-04 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB | BIAFRA | https://efile.fara.gov/docs/6170-Informational-Materials-20200304-303.pdf | |
25201 | 25201 | 2020-03-04 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB | BIAFRA | https://efile.fara.gov/docs/6170-Informational-Materials-20200304-305.pdf | |
25202 | 25202 | 2020-03-04 | 6650 | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20200304-118.pdf | |
25203 | 25203 | 2020-03-04 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20200304-132.pdf | |
25204 | 25204 | 2020-03-04 | 6710 | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | Aidenvironment (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20200304-161.pdf | |
25205 | 25205 | 2020-03-04 | 6710 | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | Aidenvironment (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20200304-165.pdf | |
25206 | 25206 | 2020-03-04 | 6710 | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20200304-159.pdf | |
25207 | 25207 | 2020-03-04 | 6710 | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20200304-163.pdf | |
25208 | 25208 | 2020-03-04 | 6710 | 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-20200304-160.pdf | |
25209 | 25209 | 2020-03-04 | 6710 | 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-20200304-164.pdf | |
25210 | 25210 | 2020-03-04 | 6710 | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | National Wildlife Federation (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20200304-162.pdf | |
25211 | 25211 | 2020-03-04 | 6710 | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | National Wildlife Federation (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20200304-166.pdf | |
25212 | 25212 | 2020-03-04 | 6728 | Gotham Government Relations 6728 | Informational Materials | Government of National Accord (GNA) | LIBYA | https://efile.fara.gov/docs/6728-Informational-Materials-20200304-10.pdf | |
25213 | 25213 | 2020-03-04 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20200304-33.pdf | |||
25214 | 25214 | 2020-03-04 | Korea SMEs and Startups Agency USA Office | Korea SMEs and Startups Agency USA Office 6195 | Amendment | https://efile.fara.gov/docs/6195-Amendment-20200304-2.pdf | |||
25215 | 25215 | 2020-03-04 | 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-20200304-11.pdf | |
25216 | 25216 | 2020-03-04 | 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-20200304-12.pdf | |
25217 | 25217 | 2020-03-04 | 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-20200304-13.pdf | |
25218 | 25218 | 2020-03-04 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of National Accord Libya, Office of the Prime Minister | LIBYA | https://efile.fara.gov/docs/6170-Informational-Materials-20200304-300.pdf | |
25219 | 25219 | 2020-03-04 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) | ZIMBABWE | https://efile.fara.gov/docs/6170-Informational-Materials-20200304-302.pdf | |
25220 | 25220 | 2020-03-04 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB | BIAFRA | https://efile.fara.gov/docs/6170-Informational-Materials-20200304-304.pdf | |
25221 | 25221 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Exhibit AB | The Embassy of Japan in the U.S.A., Washington, DC | JAPAN | https://efile.fara.gov/docs/6797-Exhibit-AB-20200304-2.pdf | |
25222 | 25222 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Exhibit C | https://efile.fara.gov/docs/6797-Exhibit-C-20200304-1.pdf | |||
25223 | 25223 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Registration Statement | https://efile.fara.gov/docs/6797-Registration-Statement-20200304-3.pdf | |||
25224 | 25224 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Baumann, Terri | https://efile.fara.gov/docs/6797-Short-Form-20200304-14.pdf | ||
25225 | 25225 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Dickson, Madeline | https://efile.fara.gov/docs/6797-Short-Form-20200304-20.pdf | ||
25226 | 25226 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Fairchild, Elizabeth | https://efile.fara.gov/docs/6797-Short-Form-20200304-10.pdf | ||
25227 | 25227 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Harrison, Melissa | https://efile.fara.gov/docs/6797-Short-Form-20200304-22.pdf | ||
25228 | 25228 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Mackenzie, Kimberly | https://efile.fara.gov/docs/6797-Short-Form-20200304-6.pdf | ||
25229 | 25229 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Merritt, Matthew | https://efile.fara.gov/docs/6797-Short-Form-20200304-8.pdf | ||
25230 | 25230 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Pope, Kristie | https://efile.fara.gov/docs/6797-Short-Form-20200304-18.pdf | ||
25231 | 25231 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Redmond, Hillary | https://efile.fara.gov/docs/6797-Short-Form-20200304-16.pdf | ||
25232 | 25232 | 2020-03-04 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Vardaro, Valerie | https://efile.fara.gov/docs/6797-Short-Form-20200304-12.pdf | ||
25233 | 25233 | 2020-03-04 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Government of the Republic of Angola, Embassy | ANGOLA | https://efile.fara.gov/docs/2165-Informational-Materials-20200304-37.pdf | |
25234 | 25234 | 2020-03-04 | VisitDenmark | VisitDenmark 634 | Supplemental Statement | https://efile.fara.gov/docs/634-Supplemental-Statement-20200304-29.pdf | |||
25235 | 25235 | 2020-03-04 | West Wing Writers, LLC | West Wing Writers, LLC 6367 | Supplemental Statement | https://efile.fara.gov/docs/6367-Supplemental-Statement-20200304-7.pdf | |||
25236 | 25236 | 2020-03-04 | mercury | Mercury Public Affairs, LLC 6170 | Informational Materials | Q Cyber Technologies Ltd | ISRAEL | https://efile.fara.gov/docs/6170-Informational-Materials-20200304-301.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]) );