FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Date_Stamped" is on date 2021-04-07 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name 6
- Embassy of Italy 1
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 1
- Huawei Technologies USA 1
- Korea Institute for International Economic Policy (KIEP) 1
- The Government of the Republic of the Philippines 1
- United Nations Development Programme on behalf of the Government of Panama 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
38498 | 38498 | 2021-04-07 | 3634 | Daniel J. Edelman, Inc. 3634 | Informational Materials | United Nations Development Programme on behalf of the Government of Panama | PANAMA | https://efile.fara.gov/docs/3634-Informational-Materials-20210407-33.pdf | |
38499 | 38499 | 2021-04-07 | 6422 | S-3 Group 6422 | Informational Materials | Embassy of Italy | ITALY | https://efile.fara.gov/docs/6422-Informational-Materials-20210407-16.pdf | |
38500 | 38500 | 2021-04-07 | 6650 | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20210407-254.pdf | |
38506 | 38506 | 2021-04-07 | BCW LLC | BCW LLC 6227 | Informational Materials | The Government of the Republic of the Philippines | PHILIPPINES | https://efile.fara.gov/docs/6227-Informational-Materials-20210407-32.pdf | |
38507 | 38507 | 2021-04-07 | 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-20210407-181.pdf | |
38515 | 38515 | 2021-04-07 | 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-20210407-264.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]) );