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

19 rows where "Date_Stamped" is on date 2018-10-09

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
107755 107755 2018-10-09 APCO Worldwide LLC APCO Worldwide LLC 6582 Short-Form Gehringer, Kelly     https://efile.fara.gov/docs/6582-Short-Form-20181009-42.pdf
107756 107756 2018-10-09 APCO Worldwide LLC APCO Worldwide LLC 6582 Short-Form Werz, Michael     https://efile.fara.gov/docs/6582-Short-Form-20181009-44.pdf
107757 107757 2018-10-09 American Continental Group American Continental Group 6598 Exhibit AB   Emirates Global Aluminum PJSC UNITED ARAB EMIRATES https://efile.fara.gov/docs/6598-Exhibit-AB-20181009-1.pdf
107758 107758 2018-10-09 American Continental Group American Continental Group 6598 Exhibit C       https://efile.fara.gov/docs/6598-Exhibit-C-20181009-2.pdf
107759 107759 2018-10-09 American Continental Group American Continental Group 6598 Registration Statement       https://efile.fara.gov/docs/6598-Registration-Statement-20181009-2.pdf
107760 107760 2018-10-09 American Continental Group American Continental Group 6598 Short-Form Israel, Christian S.     https://efile.fara.gov/docs/6598-Short-Form-20181009-4.pdf
107761 107761 2018-10-09 American Continental Group American Continental Group 6598 Short-Form Smeallie, Shawn H.     https://efile.fara.gov/docs/6598-Short-Form-20181009-8.pdf
107762 107762 2018-10-09 American Continental Group American Continental Group 6598 Short-Form Urban, David J.     https://efile.fara.gov/docs/6598-Short-Form-20181009-6.pdf
107763 107763 2018-10-09 Cogent Strategies LLC Cogent Strategies LLC 6502 Informational Materials   Democratic Party of Moldova MOLDOVA https://efile.fara.gov/docs/6502-Informational-Materials-20181009-9.pdf
107764 107764 2018-10-09 General Delegation of the PLO to the US General Delegation of the PLO to the US 5244 Supplemental Statement       https://efile.fara.gov/docs/5244-Supplemental-Statement-20181009-32.pdf
107765 107765 2018-10-09 Kingery, Samet & Sorini, PLLC Kingery, Samet & Sorini, PLLC 6465 Informational Materials   Republic of Korea, Ministry of Trade, Industry and Energy KOREA SOUTH https://efile.fara.gov/docs/6465-Informational-Materials-20181009-1.pdf
107766 107766 2018-10-09 Office of Tibet Office of Tibet 1699 Short-Form Palkyi, Tenzin     https://efile.fara.gov/docs/1699-Short-Form-20181009-34.pdf
107767 107767 2018-10-09 Picard Kentz & Rowe, LLP Picard Kentz & Rowe, LLP 5939 Informational Materials   Government of Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/5939-Informational-Materials-20181009-238.pdf
107768 107768 2018-10-09 Picard Kentz & Rowe, LLP Picard Kentz & Rowe, LLP 5939 Informational Materials   Government of Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/5939-Informational-Materials-20181009-239.pdf
107769 107769 2018-10-09 Picard Kentz & Rowe, LLP Picard Kentz & Rowe, LLP 5939 Informational Materials   Government of Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/5939-Informational-Materials-20181009-240.pdf
107770 107770 2018-10-09 Southern Transitional Council (US), Ltd. Southern Transitional Council (US), Ltd. 6552 Informational Materials   Southern Transitional Council (STC) YEMEN https://efile.fara.gov/docs/6552-Informational-Materials-20181009-5.pdf
107771 107771 2018-10-09 Tourist Office for Flanders, Belgium - New York Office Tourist Office for Flanders, Belgium - New York Office 5840 Short-Form De Wilde, Peter     https://efile.fara.gov/docs/5840-Short-Form-20181009-50.pdf
107772 107772 2018-10-09 Tourist Office for Flanders, Belgium - New York Office Tourist Office for Flanders, Belgium - New York Office 5840 Short-Form Frank, Marco     https://efile.fara.gov/docs/5840-Short-Form-20181009-48.pdf
107773 107773 2018-10-09 Tourist Office for Flanders, Belgium - New York Office Tourist Office for Flanders, Belgium - New York Office 5840 Short-Form Nijs, Wimke     https://efile.fara.gov/docs/5840-Short-Form-20181009-52.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])
);