FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Date_Stamped" is on date 2019-10-10 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
108000 | 108000 | 2019-10-10 | 6582 | APCO Worldwide LLC 6582 | Informational Materials | Goethe-Institut e.V. | GERMANY | https://efile.fara.gov/docs/6582-Informational-Materials-20191010-12.pdf | |
108001 | 108001 | 2019-10-10 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20191010-397.pdf | |
108002 | 108002 | 2019-10-10 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20191010-398.pdf | |
108003 | 108003 | 2019-10-10 | Audience Partners Worldwide LLC | Audience Partners Worldwide LLC 6657 | Informational Materials | Goethe-Institut e.V. through APCO Worldwide LLC | GERMANY | https://efile.fara.gov/docs/6657-Informational-Materials-20191010-3.pdf | |
108007 | 108007 | 2019-10-10 | Earthjustice | Earthjustice 6725 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6725-Informational-Materials-20191010-7.pdf | |
108008 | 108008 | 2019-10-10 | KOTRA | KOTRA 1619 | Informational Materials | Korea Trade-Investment Promotion Agency | KOREA SOUTH | https://efile.fara.gov/docs/1619-Informational-Materials-20191010-20.pdf | |
108009 | 108009 | 2019-10-10 | MSLGROUP Americas, LLC | QORVIS LLC 5483 | Informational Materials | Kingdom of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/5483-Informational-Materials-20191010-72.pdf | |
108010 | 108010 | 2019-10-10 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20191010-99.pdf | |
108011 | 108011 | 2019-10-10 | Waxman Consulting, Inc. DBA Waxman Strategies | 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-20191010-31.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]) );