FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Date_Stamped" is on date 2019-09-30 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 |
---|---|---|---|---|---|---|---|---|---|
102570 | 102570 | 2019-09-30 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20190930-415.pdf | |
102574 | 102574 | 2019-09-30 | Brownstein Hyatt Farber Schreck, LLP | Brownstein Hyatt Farber Schreck, LLP 5870 | Informational Materials | Royal Government of the Kingdom of Cambodia | CAMBODIA | https://efile.fara.gov/docs/5870-Informational-Materials-20190930-28.pdf | |
102576 | 102576 | 2019-09-30 | Capitol Counsel, LLC | Capitol Counsel, LLC 6328 | Informational Materials | China-United States Exchange Foundation | CHINA | https://efile.fara.gov/docs/6328-Informational-Materials-20190930-37.pdf | |
102577 | 102577 | 2019-09-30 | DLA Piper US LLP | DLA Piper US LLP 3712 | Informational Materials | Palestine Monetary Authority | PALESTINE | https://efile.fara.gov/docs/3712-Informational-Materials-20190930-7.pdf | |
102585 | 102585 | 2019-09-30 | Earthjustice | Earthjustice 6725 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6725-Informational-Materials-20190930-13.pdf | |
102586 | 102586 | 2019-09-30 | Earthjustice | Earthjustice 6725 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6725-Informational-Materials-20190930-14.pdf | |
102587 | 102587 | 2019-09-30 | Earthjustice | Earthjustice 6725 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6725-Informational-Materials-20190930-15.pdf | |
102588 | 102588 | 2019-09-30 | Earthjustice | Earthjustice 6725 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6725-Informational-Materials-20190930-16.pdf | |
102589 | 102589 | 2019-09-30 | Earthjustice | Earthjustice 6725 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6725-Informational-Materials-20190930-3.pdf | |
102590 | 102590 | 2019-09-30 | Earthjustice | Earthjustice 6725 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6725-Informational-Materials-20190930-4.pdf | |
102591 | 102591 | 2019-09-30 | Earthjustice | Earthjustice 6725 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6725-Informational-Materials-20190930-5.pdf | |
102605 | 102605 | 2019-09-30 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20190930-79.pdf | |
102608 | 102608 | 2019-09-30 | PacRim Bridges, LLC | PacRim Bridges, LLC 6655 | Informational Materials | Kingdom of Cambodia | CAMBODIA | https://efile.fara.gov/docs/6655-Informational-Materials-20190930-3.pdf | |
102618 | 102618 | 2019-09-30 | Waxman Consulting, Inc. DBA Waxman Strategies | 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-20190930-14.pdf | |
102619 | 102619 | 2019-09-30 | Yorktown Solutions, LLC | Yorktown Solutions, LLC 6491 | Informational Materials | PJSC AGRARIAN FUND | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20190930-38.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]) );