FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where Document_Type = "Informational Materials", Foreign_Principal_Country = "TURKEY", Foreign_Principal_Name = "Embassy of the Republic of Turkey" and Registrant_Name = "Mercury Public Affairs, LLC"
This data as json, CSV (advanced)
These facets timed out: Registrant_Name
Foreign_Principal_Name 1
- Embassy of the Republic of Turkey · 25 ✖
Foreign_Principal_Country 1
- TURKEY · 25 ✖
Document_Type 1
- Informational Materials · 25 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
4296 | 4296 | 2019-01-09 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20190109-52.pdf | |
9258 | 9258 | 2019-01-30 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20190130-44.pdf | |
10326 | 10326 | 2020-01-31 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200131-268.pdf | |
37031 | 37031 | 2019-04-01 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20190401-60.pdf | |
37045 | 37045 | 2020-04-01 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200401-359.pdf | |
37265 | 37265 | 2019-04-02 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20190402-59.pdf | |
40223 | 40223 | 2020-04-14 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200414-377.pdf | |
48834 | 48834 | 2019-05-02 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20190502-72.pdf | |
51748 | 51748 | 2020-05-13 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200513-433.pdf | |
75907 | 75907 | 2020-07-13 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200713-484.pdf | |
76519 | 76519 | 2018-07-16 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20180716-25.pdf | |
76547 | 76547 | 2020-07-16 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200716-491.pdf | |
77123 | 77123 | 2018-07-19 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20180719-26.pdf | |
86646 | 86646 | 2018-08-09 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20180809-27.pdf | |
88740 | 88740 | 2018-08-20 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20180820-28.pdf | |
98243 | 98243 | 2019-09-16 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20190916-169.pdf | |
98764 | 98764 | 2018-09-18 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20180918-31.pdf | |
99430 | 99430 | 2018-09-21 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20180921-33.pdf | |
101246 | 101246 | 2018-09-28 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20180928-34.pdf | |
106460 | 106460 | 2018-10-03 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20181003-54.pdf | |
107788 | 107788 | 2019-10-09 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20191009-188.pdf | |
109016 | 109016 | 2019-10-15 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20191015-192.pdf | |
109394 | 109394 | 2018-10-17 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20181017-32.pdf | |
117502 | 117502 | 2019-11-04 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20191104-214.pdf | |
128622 | 128622 | 2019-12-02 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Embassy of the Republic of Turkey | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20191202-226.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]) );