FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
222 rows where Registration_Number = 6399
This data as json, CSV (advanced)
Foreign_Principal_Name 20
- - 88
- Democratic Party of Albania 2
- Democratic Republic of Congo through Mer Security and Communications, Ltd. 2
- Elite Consulting Group 2
- African Energy Chamber 1
- Ahmad Massoud 1
- Ali Hadad 1
- Embassy of Iceland, Washington, DC 1
- Embassy of the Federal Democratic Republic of Nepal, Washington, DC 1
- Embassy of the Islamic Republic of Afghanistan 1
- Embassy of the Republic of Kenya 1
- Government of Kenya, Ministry of Foreign Affairs 1
- Mr.Julio Herrera Velutini 1
- Ms. Isabel Dos Santos 1
- New Zealand Embassy 1
- Republic of El Salvador State Intelligence Agency 1
- Saro Spadaro 1
- Terra Peregrin, S.A. 1
- Zury Mayte Rios de Smith 1
- somalia 1
Foreign_Principal_Country 16
- - 88
- SOMALI DEMOCRATIC REPUBLIC 3
- AFGHANISTAN 2
- ALBANIA 2
- CONGO REPUBLIC OF THE 2
- ITALY 2
- KENYA 2
- ALGERIA 1
- ANGOLA 1
- EL SALVADOR 1
- GUATEMALA 1
- ICELAND 1
- NEPAL 1
- NEW ZEALAND 1
- PORTUGAL 1
- SOUTH AFRICA 1
Document_Type 6
Registrant_Name 2
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]) );