FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where "Date_Stamped" is on date 2023-07-05 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name
Registrant_Name 5
Foreign_Principal_Country 5
- BOSNIA & HERZEGOVINA 15
- GERMANY 3
- YEMEN 2
- KOREA SOUTH 1
- RUSSIA 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
74034 | 74034 | 2023-07-05 | Delegation of German Industry and Commerce in Washington DC, LLC | Delegation of German Industry and Commerce in Washington DC, LLC 7002 | Informational Materials | DIHK DEinternational GmbH | GERMANY | https://efile.fara.gov/docs/7002-Informational-Materials-20230705-160.pdf | |
74035 | 74035 | 2023-07-05 | Delegation of German Industry and Commerce in Washington DC, LLC | Delegation of German Industry and Commerce in Washington DC, LLC 7002 | Informational Materials | DIHK DEinternational GmbH | GERMANY | https://efile.fara.gov/docs/7002-Informational-Materials-20230705-161.pdf | |
74036 | 74036 | 2023-07-05 | Delegation of German Industry and Commerce in Washington DC, LLC | Delegation of German Industry and Commerce in Washington DC, LLC 7002 | Informational Materials | DIHK DEinternational GmbH | GERMANY | https://efile.fara.gov/docs/7002-Informational-Materials-20230705-162.pdf | |
74040 | 74040 | 2023-07-05 | 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-20230705-848.pdf | |
74041 | 74041 | 2023-07-05 | Hyperfocal Communications, LLC | Hyperfocal Communications, LLC 7267 | Informational Materials | Southern Transitional Council | YEMEN | https://efile.fara.gov/docs/7267-Informational-Materials-20230705-4.pdf | |
74042 | 74042 | 2023-07-05 | Hyperfocal Communications, LLC | Hyperfocal Communications, LLC 7267 | Informational Materials | Southern Transitional Council | YEMEN | https://efile.fara.gov/docs/7267-Informational-Materials-20230705-5.pdf | |
74044 | 74044 | 2023-07-05 | KOTRA | KOTRA 1619 | Informational Materials | Korea Trade-Investment Promotion Agency | KOREA SOUTH | https://efile.fara.gov/docs/1619-Informational-Materials-20230705-169.pdf | |
74045 | 74045 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1091.pdf | |
74046 | 74046 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1092.pdf | |
74047 | 74047 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1093.pdf | |
74048 | 74048 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1094.pdf | |
74049 | 74049 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1095.pdf | |
74050 | 74050 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1096.pdf | |
74051 | 74051 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1097.pdf | |
74052 | 74052 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1098.pdf | |
74053 | 74053 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1099.pdf | |
74054 | 74054 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1100.pdf | |
74055 | 74055 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1101.pdf | |
74056 | 74056 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1102.pdf | |
74057 | 74057 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1103.pdf | |
74058 | 74058 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1104.pdf | |
74059 | 74059 | 2023-07-05 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20230705-1105.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]) );