FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
79 rows where Foreign_Principal_Country = "TURKEY", Foreign_Principal_Name = "Turkey-U.S. Business Council (TAIK)" and Registrant_Name = "Mercury Public Affairs, LLC"
This data as json, CSV (advanced)
Document_Type 2
Registrant_Name 1
- Mercury Public Affairs, LLC · 44 ✖
Foreign_Principal_Name 1
- Turkey-U.S. Business Council (TAIK) · 44 ✖
Foreign_Principal_Country 1
- TURKEY · 44 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
48614 | 48614 | 2020-05-01 | 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-20200501-411.pdf | |
48615 | 48615 | 2020-05-01 | 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-20200501-414.pdf | |
49589 | 49589 | 2020-05-05 | 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-20200505-418.pdf | |
49835 | 49835 | 2020-05-06 | 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-20200506-421.pdf | |
50157 | 50157 | 2020-05-07 | 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-20200507-423.pdf | |
50400 | 50400 | 2020-05-08 | 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-20200508-426.pdf | |
50401 | 50401 | 2020-05-08 | 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-20200508-427.pdf | |
51463 | 51463 | 2020-05-12 | 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-20200512-430.pdf | |
51464 | 51464 | 2020-05-12 | 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-20200512-432.pdf | |
52261 | 52261 | 2020-05-15 | 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-20200515-435.pdf | |
52262 | 52262 | 2020-05-15 | 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-20200515-437.pdf | |
53251 | 53251 | 2020-05-19 | 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-20200519-440.pdf | |
53803 | 53803 | 2020-05-21 | 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-20200521-444.pdf | |
53804 | 53804 | 2020-05-21 | 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-20200521-445.pdf | |
54039 | 54039 | 2020-05-22 | 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-20200522-447.pdf | |
55035 | 55035 | 2020-05-26 | 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-20200526-448.pdf | |
55939 | 55939 | 2020-05-29 | 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-20200529-449.pdf | |
55940 | 55940 | 2020-05-29 | 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-20200529-451.pdf | |
62238 | 62238 | 2020-06-02 | 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-20200602-452.pdf | |
62918 | 62918 | 2020-06-05 | 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-20200605-456.pdf | |
63663 | 63663 | 2021-06-08 | 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-20210608-948.pdf | |
63913 | 63913 | 2020-06-09 | 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-20200609-457.pdf | |
64666 | 64666 | 2020-06-12 | 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-20200612-462.pdf | |
65275 | 65275 | 2020-06-15 | 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-20200615-464.pdf | |
67802 | 67802 | 2020-06-26 | 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-20200626-476.pdf | |
73453 | 73453 | 2020-07-01 | 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-20200701-478.pdf | |
73856 | 73856 | 2020-07-03 | 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-20200703-479.pdf | |
74268 | 74268 | 2021-07-06 | 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-20210706-964.pdf | |
74468 | 74468 | 2020-07-07 | 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-20200707-481.pdf | |
75909 | 75909 | 2020-07-13 | 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-20200713-485.pdf | |
76147 | 76147 | 2020-07-14 | 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-20200714-488.pdf | |
76401 | 76401 | 2021-07-15 | 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-20210715-976.pdf | |
77469 | 77469 | 2021-07-20 | 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-20210720-985.pdf | |
87499 | 87499 | 2020-08-13 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Exhibit AB | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Exhibit-AB-20200813-86.pdf | |
89849 | 89849 | 2021-08-26 | 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-20210826-1006.pdf | |
96260 | 96260 | 2021-09-07 | 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-20210907-1012.pdf | |
102717 | 102717 | 2021-09-30 | 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-20210930-1027.pdf | |
107186 | 107186 | 2021-10-06 | 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-20211006-1042.pdf | |
107187 | 107187 | 2021-10-06 | 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-20211006-1043.pdf | |
107188 | 107188 | 2021-10-06 | 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-20211006-1044.pdf | |
107189 | 107189 | 2021-10-06 | 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-20211006-1045.pdf | |
107190 | 107190 | 2021-10-06 | 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-20211006-1046.pdf | |
108999 | 108999 | 2018-10-15 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Exhibit AB | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Exhibit-AB-20181015-54.pdf | |
109073 | 109073 | 2021-10-15 | 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-20211015-1058.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]) );