FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
222 rows where Registration_Number = 6399 sorted by rowid descending
This data as json, CSV (advanced)
Foreign_Principal_Name 23
- - 95
- Saro Spadaro 3
- Blueprint For Free Speech 2
- Embassy of the Republic of Kenya 2
- New Zealand Embassy 2
- Alexander Machkevich 1
- Democratic Party of Albania 1
- Democratic Republic of Congo through Mer Security and Communications, Ltd. 1
- Embassy of Iceland, Washington, DC 1
- Embassy of The Kingdom of Bahrain 1
- Government of Kenya, Ministry of Foreign Affairs 1
- Hashim Mughal 1
- Khalid Aljabri 1
- Korea International Trade Association 1
- Mer Security and Communications, Ltd. 1
- Ministry of Interior, Kingdom of Saudi Arabia 1
- Mr. Saud A.A. AL Arfaj 1
- Office of the President of the Czech Republic 1
- Reinaldo Munoz Pedroza 1
- Terra Peregrin, S.A 1
- Venable LLP (on behalf of Slobodan Tesic) 1
- Zari David ( Eliezer) KOVO 1
- Zury Mayte' Rios Sosa de Weller 1
Foreign_Principal_Country 20
- - 95
- ITALY 3
- KENYA 3
- AUSTRALIA 2
- CONGO REPUBLIC OF THE 2
- NEW ZEALAND 2
- SAUDI ARABIA 2
- ALBANIA 1
- BAHRAIN 1
- CZECHIA 1
- GUATEMALA 1
- ICELAND 1
- ISRAEL 1
- KAZAKHSTAN 1
- KOREA SOUTH 1
- KUWAIT 1
- PAKISTAN 1
- PORTUGAL 1
- SERBIA 1
- VENEZUELA 1
Document_Type 5
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]) );