FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Date_Stamped" is on date 2023-07-26 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
Registrant_Name 7
Foreign_Principal_Name 7
- DIHK DEinternational GmbH 3
- Royal Embassy of Saudi Arabia 3
- Sinn Fein 2
- Ad Hoc Board of Petroleos de Venezuela, S.A. through PDV Holding, Inc. 1
- Cambodia National Rescue Party 1
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 1
- Okinawa Prefectural Government of Japan 1
Foreign_Principal_Country 7
Document_Type 1
- Informational Materials · 12 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
79053 | 79053 | 2023-07-26 | 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-20230726-166.pdf | |
79054 | 79054 | 2023-07-26 | 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-20230726-167.pdf | |
79055 | 79055 | 2023-07-26 | 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-20230726-168.pdf | |
79057 | 79057 | 2023-07-26 | Friends of Sinn Fein, Inc. | Friends of Sinn Fein, Inc. 5006 | Informational Materials | Sinn Fein | IRELAND | https://efile.fara.gov/docs/5006-Informational-Materials-20230726-91.pdf | |
79058 | 79058 | 2023-07-26 | Friends of Sinn Fein, Inc. | Friends of Sinn Fein, Inc. 5006 | Informational Materials | Sinn Fein | IRELAND | https://efile.fara.gov/docs/5006-Informational-Materials-20230726-92.pdf | |
79062 | 79062 | 2023-07-26 | 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-20230726-869.pdf | |
79063 | 79063 | 2023-07-26 | Klein/Johnson Group LLC | Klein/Johnson Group LLC 7049 | Informational Materials | Ad Hoc Board of Petroleos de Venezuela, S.A. through PDV Holding, Inc. | VENEZUELA | https://efile.fara.gov/docs/7049-Informational-Materials-20230726-4.pdf | |
79064 | 79064 | 2023-07-26 | 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-20230726-1005.pdf | |
79065 | 79065 | 2023-07-26 | 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-20230726-1006.pdf | |
79066 | 79066 | 2023-07-26 | 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-20230726-1007.pdf | |
79068 | 79068 | 2023-07-26 | Okinawa Prefecture DC Office, Inc. | Okinawa Prefecture DC Office, Inc. 6332 | Informational Materials | Okinawa Prefectural Government of Japan | JAPAN | https://efile.fara.gov/docs/6332-Informational-Materials-20230726-15.pdf | |
79069 | 79069 | 2023-07-26 | Sochua Mu Leiper | Sochua Mu Leiper 7042 | Informational Materials | Cambodia National Rescue Party | CAMBODIA | https://efile.fara.gov/docs/7042-Informational-Materials-20230726-236.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]) );