FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

17 rows where Foreign_Principal_Country = "SOMALI DEMOCRATIC REPUBLIC", Foreign_Principal_Name = "Federal Government of Somali" and Registrant_Name = "Hashi Warsame Abdi-Nur"

✎ View and edit SQL

This data as json, CSV (advanced)

Document_Type 2

Registrant_Name 1

  • Hashi Warsame Abdi-Nur · 17 ✖

Foreign_Principal_Name 1

  • Federal Government of Somali · 17 ✖

Foreign_Principal_Country 1

  • SOMALI DEMOCRATIC REPUBLIC · 17 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
8347 8347 2020-01-28 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200128-2.pdf
10313 10313 2020-01-31 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200131-3.pdf
10314 10314 2020-01-31 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200131-4.pdf
14886 14886 2020-02-07 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200207-6.pdf
15726 15726 2020-02-11 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200211-7.pdf
15727 15727 2020-02-11 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200211-8.pdf
18265 18265 2020-02-23 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200223-10.pdf
18266 18266 2020-02-23 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200223-11.pdf
18267 18267 2020-02-23 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200223-12.pdf
18268 18268 2020-02-23 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200223-13.pdf
18269 18269 2020-02-23 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200223-14.pdf
24955 24955 2020-03-03 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200303-15.pdf
39777 39777 2020-04-12 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200412-16.pdf
39778 39778 2020-04-12 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200412-17.pdf
39779 39779 2020-04-12 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20200412-18.pdf
122159 122159 2019-11-27 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Exhibit AB   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Exhibit-AB-20191127-1.pdf
128609 128609 2019-12-02 Hashi Warsame Abdi-Nur Hashi Warsame Abdi-Nur 6757 Informational Materials   Federal Government of Somali SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6757-Informational-Materials-20191202-1.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);