FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where "Date_Stamped" is on date 2021-07-09
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name, Foreign_Principal_Country
Registrant_Name 11
- Media Planning International Corporation 9
- Karv Communications, Inc. 7
- Mercury Public Affairs, LLC 5
- Hai Tian Development U.S.A., Inc. 2
- Bluetext, LLC 1
- Ghebi LLC 1
- Manatos & Manatos (through the National Coordinated Effort of Hellenes - CEH) 1
- McGinnis Lochridge 1
- Proof Strategies Inc. 1
- Racepoint Global, Inc. 1
- Reston Translator, LLC 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
74962 | 74962 | 2021-07-09 | 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-20210709-114.pdf | |
74963 | 74963 | 2021-07-09 | 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-20210709-268.pdf | |
74964 | 74964 | 2021-07-09 | Hai Tian Development U.S.A., Inc. | Hai Tian Development U.S.A., Inc. 5143 | Informational Materials | People's Daily Overseas Edition | CHINA | https://efile.fara.gov/docs/5143-Informational-Materials-20210709-38.pdf | |
74965 | 74965 | 2021-07-09 | Hai Tian Development U.S.A., Inc. | Hai Tian Development U.S.A., Inc. 5143 | Informational Materials | People's Daily Overseas Edition | CHINA | https://efile.fara.gov/docs/5143-Informational-Materials-20210709-39.pdf | |
74966 | 74966 | 2021-07-09 | Karv Communications, Inc. | KARV Communications, Inc. 6162 | Amendment | https://efile.fara.gov/docs/6162-Amendment-20210709-9.pdf | |||
74967 | 74967 | 2021-07-09 | Karv Communications, Inc. | KARV Communications, Inc. 6162 | Exhibit AB | Ukranian Federation of Employers of the Oil and Gas Industry (UFEOGI) | UKRAINE | https://efile.fara.gov/docs/6162-Exhibit-AB-20210709-10.pdf | |
74968 | 74968 | 2021-07-09 | Karv Communications, Inc. | KARV Communications, Inc. 6162 | Short-Form | Andrus, Eric | https://efile.fara.gov/docs/6162-Short-Form-20210709-40.pdf | ||
74969 | 74969 | 2021-07-09 | Karv Communications, Inc. | KARV Communications, Inc. 6162 | Short-Form | Frank, Andrew D. | https://efile.fara.gov/docs/6162-Short-Form-20210709-38.pdf | ||
74970 | 74970 | 2021-07-09 | Karv Communications, Inc. | KARV Communications, Inc. 6162 | Short-Form | Karatnycky, Adrian | https://efile.fara.gov/docs/6162-Short-Form-20210709-46.pdf | ||
74971 | 74971 | 2021-07-09 | Karv Communications, Inc. | KARV Communications, Inc. 6162 | Short-Form | Nolan, Kevin | https://efile.fara.gov/docs/6162-Short-Form-20210709-42.pdf | ||
74972 | 74972 | 2021-07-09 | Karv Communications, Inc. | KARV Communications, Inc. 6162 | Short-Form | Sommer, Will | https://efile.fara.gov/docs/6162-Short-Form-20210709-44.pdf | ||
74973 | 74973 | 2021-07-09 | Manatos & Manatos (through the National Coordinated Effort of Hellenes - CEH) | Manatos & Manatos (through the National Coordinated Effort of Hellenes - CEH) 6683 | Supplemental Statement | https://efile.fara.gov/docs/6683-Supplemental-Statement-20210709-4.pdf | |||
74974 | 74974 | 2021-07-09 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210709-780.pdf | |
74975 | 74975 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Alvarez, Luisa | https://efile.fara.gov/docs/6621-Short-Form-20210709-102.pdf | ||
74976 | 74976 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Amador, Diana | https://efile.fara.gov/docs/6621-Short-Form-20210709-106.pdf | ||
74977 | 74977 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Angeles Fuentes, Dennys Dante | https://efile.fara.gov/docs/6621-Short-Form-20210709-96.pdf | ||
74978 | 74978 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Arteaga, William | https://efile.fara.gov/docs/6621-Short-Form-20210709-104.pdf | ||
74979 | 74979 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Castillo, Aldo | https://efile.fara.gov/docs/6621-Short-Form-20210709-100.pdf | ||
74980 | 74980 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Chappell Martinez, Francesca Jessica | https://efile.fara.gov/docs/6621-Short-Form-20210709-90.pdf | ||
74981 | 74981 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Garrido, Wendolyn | https://efile.fara.gov/docs/6621-Short-Form-20210709-92.pdf | ||
74982 | 74982 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Lopez, Victor | https://efile.fara.gov/docs/6621-Short-Form-20210709-94.pdf | ||
74983 | 74983 | 2021-07-09 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Navarro Bereche, Karla Alexandra | https://efile.fara.gov/docs/6621-Short-Form-20210709-98.pdf | ||
74984 | 74984 | 2021-07-09 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of National Unity of Libya (through Mercury International UK Ltd.) | LIBYA | https://efile.fara.gov/docs/6170-Informational-Materials-20210709-969.pdf | |
74985 | 74985 | 2021-07-09 | Mercury Public Affairs, LLC | 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-20210709-967.pdf | |
74986 | 74986 | 2021-07-09 | Mercury Public Affairs, LLC | 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-20210709-968.pdf | |
74987 | 74987 | 2021-07-09 | Mercury Public Affairs, LLC | 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-20210709-970.pdf | |
74988 | 74988 | 2021-07-09 | Mercury Public Affairs, LLC | 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-20210709-971.pdf | |
74989 | 74989 | 2021-07-09 | Proof Strategies Inc. | Proof Strategies Inc. 6822 | Amendment | https://efile.fara.gov/docs/6822-Amendment-20210709-5.pdf | |||
74990 | 74990 | 2021-07-09 | Racepoint Global, Inc. | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20210709-292.pdf | |
74991 | 74991 | 2021-07-09 | Reston Translator, LLC | Reston Translator, LLC 6490 | Informational Materials | Federal State Unitary Enterprise Rossiya Segodnya International Information Agency | RUSSIA | https://efile.fara.gov/docs/6490-Informational-Materials-20210709-5.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]) );