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 2021-03-12
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name 13
- - 9
- Presidency of the Republic of Haiti (through Mercury International UK Ltd) 5
- Republic of Angola 5
- Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP 3
- Turkey-U.S. Business Council (TAIK) 3
- Korea Institute for International Economic Policy (KIEP) 2
- Republika Srpska 2
- Royal Embassy of Saudi Arabia 2
- The Government of the Republic of the Philippines 2
- Embassy of the Republic of Haiti 1
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 1
- Ministry of Justice, Republic of Kazakhstan through Latham & Watkins LLP 1
- Qatar Foundation through Memac Ogilvy & Mather LLC 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
27384 | 27384 | 2021-03-12 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Presidency of the Republic of Haiti (through Mercury International UK Ltd) | HAITI | https://efile.fara.gov/docs/6170-Informational-Materials-20210312-887.pdf | |
27385 | 27385 | 2021-03-12 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Presidency of the Republic of Haiti (through Mercury International UK Ltd) | HAITI | https://efile.fara.gov/docs/6170-Informational-Materials-20210312-888.pdf | |
27386 | 27386 | 2021-03-12 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Presidency of the Republic of Haiti (through Mercury International UK Ltd) | HAITI | https://efile.fara.gov/docs/6170-Informational-Materials-20210312-889.pdf | |
27387 | 27387 | 2021-03-12 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Presidency of the Republic of Haiti (through Mercury International UK Ltd) | HAITI | https://efile.fara.gov/docs/6170-Informational-Materials-20210312-890.pdf | |
27388 | 27388 | 2021-03-12 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Presidency of the Republic of Haiti (through Mercury International UK Ltd) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20210312-893.pdf | |
27389 | 27389 | 2021-03-12 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20210312-891.pdf | |
27390 | 27390 | 2021-03-12 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20210312-892.pdf | |
27391 | 27391 | 2021-03-12 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210312-657.pdf | |
27392 | 27392 | 2021-03-12 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210312-658.pdf | |
27393 | 27393 | 2021-03-12 | 6814 | RF Binder Partners Inc. 6814 | Informational Materials | Qatar Foundation through Memac Ogilvy & Mather LLC | QATAR | https://efile.fara.gov/docs/6814-Informational-Materials-20210312-37.pdf | |
27394 | 27394 | 2021-03-12 | Arnold & Porter Kaye Scholer, LLP | Arnold & Porter Kaye Scholer LLP 1750 | Amendment | https://efile.fara.gov/docs/1750-Amendment-20210312-63.pdf | |||
27395 | 27395 | 2021-03-12 | Arnold & Porter Kaye Scholer, LLP | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | Bombassaro, Brian | https://efile.fara.gov/docs/1750-Short-Form-20210312-146.pdf | ||
27396 | 27396 | 2021-03-12 | BCW LLC | BCW LLC 6227 | Informational Materials | The Government of the Republic of the Philippines | PHILIPPINES | https://efile.fara.gov/docs/6227-Informational-Materials-20210312-22.pdf | |
27397 | 27397 | 2021-03-12 | BCW LLC | BCW LLC 6227 | Informational Materials | The Government of the Republic of the Philippines | PHILIPPINES | https://efile.fara.gov/docs/6227-Informational-Materials-20210312-23.pdf | |
27398 | 27398 | 2021-03-12 | Bluetext, LLC | Bluetext, LLC 6693 | Informational Materials | Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP | KOREA SOUTH | https://efile.fara.gov/docs/6693-Informational-Materials-20210312-54.pdf | |
27399 | 27399 | 2021-03-12 | Bluetext, LLC | Bluetext, LLC 6693 | Informational Materials | Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP | KOREA SOUTH | https://efile.fara.gov/docs/6693-Informational-Materials-20210312-55.pdf | |
27400 | 27400 | 2021-03-12 | Bluetext, LLC | Bluetext, LLC 6693 | Informational Materials | Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP | KOREA SOUTH | https://efile.fara.gov/docs/6693-Informational-Materials-20210312-56.pdf | |
27401 | 27401 | 2021-03-12 | Brownstein Hyatt Farber Schreck, LLP | Brownstein Hyatt Farber Schreck, LLP 5870 | Short-Form | Carl-Yoder, Samantha | https://efile.fara.gov/docs/5870-Short-Form-20210312-172.pdf | ||
27402 | 27402 | 2021-03-12 | Ghebi LLC | Ghebi LLC 6869 | Informational Materials | Federal State Unitary Enterprise Rossiya Segodnya International Information Agency | RUSSIA | https://efile.fara.gov/docs/6869-Informational-Materials-20210312-152.pdf | |
27403 | 27403 | 2021-03-12 | Korea Economic Institute | Korea Economic Institute 3327 | Informational Materials | Korea Institute for International Economic Policy (KIEP) | KOREA SOUTH | https://efile.fara.gov/docs/3327-Informational-Materials-20210312-251.pdf | |
27404 | 27404 | 2021-03-12 | Korea Economic Institute | Korea Economic Institute 3327 | Informational Materials | Korea Institute for International Economic Policy (KIEP) | KOREA SOUTH | https://efile.fara.gov/docs/3327-Informational-Materials-20210312-252.pdf | |
27405 | 27405 | 2021-03-12 | 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-20210312-454.pdf | |
27406 | 27406 | 2021-03-12 | 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-20210312-455.pdf | |
27407 | 27407 | 2021-03-12 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20210312-98.pdf | |||
27408 | 27408 | 2021-03-12 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20210312-99.pdf | |||
27409 | 27409 | 2021-03-12 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Exhibit AB | Ministry of Justice, Republic of Kazakhstan through Latham & Watkins LLP | KAZAKHSTAN | https://efile.fara.gov/docs/6170-Exhibit-AB-20210312-89.pdf | |
27410 | 27410 | 2021-03-12 | 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-20210312-90.pdf | |
27411 | 27411 | 2021-03-12 | Patino & Associates, P.A. | Patino & Associates, P.A. 6937 | Exhibit AB | Embassy of the Republic of Haiti | HAITI | https://efile.fara.gov/docs/6937-Exhibit-AB-20210312-1.pdf | |
27412 | 27412 | 2021-03-12 | Patino & Associates, P.A. | Patino & Associates, P.A. 6937 | Exhibit C | https://efile.fara.gov/docs/6937-Exhibit-C-20210312-1.pdf | |||
27413 | 27413 | 2021-03-12 | Patino & Associates, P.A. | Patino & Associates, P.A. 6937 | Registration Statement | https://efile.fara.gov/docs/6937-Registration-Statement-20210312-1.pdf | |||
27414 | 27414 | 2021-03-12 | Patino & Associates, P.A. | Patino & Associates, P.A. 6937 | Short-Form | Brewster Jr., James Walter | https://efile.fara.gov/docs/6937-Short-Form-20210312-4.pdf | ||
27415 | 27415 | 2021-03-12 | Patino & Associates, P.A. | Patino & Associates, P.A. 6937 | Short-Form | Patino, Ralph | https://efile.fara.gov/docs/6937-Short-Form-20210312-2.pdf | ||
27416 | 27416 | 2021-03-12 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Republic of Angola | ANGOLA | https://efile.fara.gov/docs/2165-Informational-Materials-20210312-89.pdf | |
27417 | 27417 | 2021-03-12 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Republic of Angola | ANGOLA | https://efile.fara.gov/docs/2165-Informational-Materials-20210312-90.pdf | |
27418 | 27418 | 2021-03-12 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Republic of Angola | ANGOLA | https://efile.fara.gov/docs/2165-Informational-Materials-20210312-92.pdf | |
27419 | 27419 | 2021-03-12 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Republic of Angola | ANGOLA | https://efile.fara.gov/docs/2165-Informational-Materials-20210312-93.pdf | |
27420 | 27420 | 2021-03-12 | squire | Squire Patton Boggs, LLP 2165 | Informational Materials | Republic of Angola | ANGOLA | https://efile.fara.gov/docs/2165-Informational-Materials-20210312-91.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]) );