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

66 rows where "Date_Stamped" is on date 2020-10-30

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Registrant_Name, Foreign_Principal_Name

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
112806 112806 2020-10-30 5666 FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 Informational Materials   Ministry of Foreign Affairs, Republic of Somaliland SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/5666-Informational-Materials-20201030-51.pdf
112807 112807 2020-10-30 6170 Mercury Public Affairs, LLC 6170 Informational Materials   Turkey-U.S. Business Council (TAIK) TURKEY https://efile.fara.gov/docs/6170-Informational-Materials-20201030-761.pdf
112808 112808 2020-10-30 6278 DCI Group AZ, LLC 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20201030-106.pdf
112809 112809 2020-10-30 6278 DCI Group AZ, LLC 6278 Informational Materials   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Informational-Materials-20201030-107.pdf
112810 112810 2020-10-30 6650 Racepoint Global, Inc. 6650 Informational Materials   Huawei Technologies USA CHINA https://efile.fara.gov/docs/6650-Informational-Materials-20201030-202.pdf
112811 112811 2020-10-30 6672 McGinnis Lochridge 6672 Informational Materials   Republika Srpska BOSNIA & HERZEGOVINA https://efile.fara.gov/docs/6672-Informational-Materials-20201030-528.pdf
112812 112812 2020-10-30 6724 Hausfeld LLP 6724 Informational Materials   Environmental Youth Activists INTERNATIONAL https://efile.fara.gov/docs/6724-Informational-Materials-20201030-8.pdf
112813 112813 2020-10-30 6798 Somaliland Mission USA, LLC 6798 Informational Materials   Ministry of Foreign Affairs, Republic of Somaliland SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6798-Informational-Materials-20201030-2.pdf
112814 112814 2020-10-30 6798 Somaliland Mission USA, LLC 6798 Informational Materials   Ministry of Foreign Affairs, Republic of Somaliland SOMALI DEMOCRATIC REPUBLIC https://efile.fara.gov/docs/6798-Informational-Materials-20201030-3.pdf
112815 112815 2020-10-30 Alignment Government Strategies Alignment Government Strategies 6317 Supplemental Statement       https://efile.fara.gov/docs/6317-Supplemental-Statement-20201030-10.pdf
112816 112816 2020-10-30 Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 6535 Supplemental Statement       https://efile.fara.gov/docs/6535-Supplemental-Statement-20201030-6.pdf
112817 112817 2020-10-30 Batra, Ravi Batra, Ravi 6592 Supplemental Statement       https://efile.fara.gov/docs/6592-Supplemental-Statement-20201030-4.pdf
112818 112818 2020-10-30 Bluetext, LLC Bluetext, LLC 6693 Informational Materials   Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP KOREA SOUTH https://efile.fara.gov/docs/6693-Informational-Materials-20201030-30.pdf
112819 112819 2020-10-30 Copper Strategies LLC Copper Strategies LLC 6884 Exhibit AB   Embassy of Armenia to the United States ARMENIA https://efile.fara.gov/docs/6884-Exhibit-AB-20201030-1.pdf
112820 112820 2020-10-30 Copper Strategies LLC Copper Strategies LLC 6884 Exhibit C       https://efile.fara.gov/docs/6884-Exhibit-C-20201030-1.pdf
112821 112821 2020-10-30 Copper Strategies LLC Copper Strategies LLC 6884 Registration Statement       https://efile.fara.gov/docs/6884-Registration-Statement-20201030-1.pdf
112822 112822 2020-10-30 Copper Strategies LLC Copper Strategies LLC 6884 Short-Form Walotsky Jr., Philip Simon     https://efile.fara.gov/docs/6884-Short-Form-20201030-4.pdf
112823 112823 2020-10-30 DCI Group AZ, LLC DCI Group AZ, LLC 6278 Amendment       https://efile.fara.gov/docs/6278-Amendment-20201030-7.pdf
112824 112824 2020-10-30 DCI Group AZ, LLC DCI Group AZ, LLC 6278 Exhibit AB   31416 S.A.S. COLOMBIA https://efile.fara.gov/docs/6278-Exhibit-AB-20201030-18.pdf
112825 112825 2020-10-30 DCI Group AZ, LLC DCI Group AZ, LLC 6278 Short-Form Mears, Chelsea     https://efile.fara.gov/docs/6278-Short-Form-20201030-62.pdf
112826 112826 2020-10-30 Daschle Group, LLC Daschle Group, LLC 6280 Supplemental Statement       https://efile.fara.gov/docs/6280-Supplemental-Statement-20201030-11.pdf
112827 112827 2020-10-30 Dentons US LLP Dentons US LLP 6284 Supplemental Statement       https://efile.fara.gov/docs/6284-Supplemental-Statement-20201030-11.pdf
112828 112828 2020-10-30 Duncap Strategies, LLC Duncap Strategies, LLC 6805 Supplemental Statement       https://efile.fara.gov/docs/6805-Supplemental-Statement-20201030-1.pdf
112829 112829 2020-10-30 Hathaway Strategies, LLC Hathaway Strategies, LLC 6761 Informational Materials   Royal Embassy of Saudi Arabia through Larson Shannahan Slifka Group, LLC SAUDI ARABIA https://efile.fara.gov/docs/6761-Informational-Materials-20201030-10.pdf
112830 112830 2020-10-30 Hathaway Strategies, LLC Hathaway Strategies, LLC 6761 Informational Materials   Royal Embassy of Saudi Arabia through Larson Shannahan Slifka Group, LLC SAUDI ARABIA https://efile.fara.gov/docs/6761-Informational-Materials-20201030-8.pdf
112831 112831 2020-10-30 Hathaway Strategies, LLC Hathaway Strategies, LLC 6761 Informational Materials   Royal Embassy of Saudi Arabia through Larson Shannahan Slifka Group, LLC SAUDI ARABIA https://efile.fara.gov/docs/6761-Informational-Materials-20201030-9.pdf
112832 112832 2020-10-30 Hausfeld, LLP Hausfeld LLP 6724 Supplemental Statement       https://efile.fara.gov/docs/6724-Supplemental-Statement-20201030-3.pdf
112833 112833 2020-10-30 Korea Economic Institute Korea Economic Institute 3327 Informational Materials   Korea Institute for International Economic Policy (KIEP) KOREA SOUTH https://efile.fara.gov/docs/3327-Informational-Materials-20201030-208.pdf
112834 112834 2020-10-30 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-20201030-193.pdf
112835 112835 2020-10-30 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-20201030-194.pdf
112836 112836 2020-10-30 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-20201030-195.pdf
112837 112837 2020-10-30 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-20201030-196.pdf
112838 112838 2020-10-30 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-20201030-197.pdf
112839 112839 2020-10-30 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-20201030-198.pdf
112840 112840 2020-10-30 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-20201030-199.pdf
112841 112841 2020-10-30 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-20201030-200.pdf
112842 112842 2020-10-30 Livingston Group, LLC Livingston Group, LLC 6344 Amendment       https://efile.fara.gov/docs/6344-Amendment-20201030-38.pdf
112843 112843 2020-10-30 Livingston Group, LLC Livingston Group, LLC 6344 Amendment       https://efile.fara.gov/docs/6344-Amendment-20201030-39.pdf
112844 112844 2020-10-30 Livingston Group, LLC Livingston Group, LLC 6344 Amendment       https://efile.fara.gov/docs/6344-Amendment-20201030-40.pdf
112845 112845 2020-10-30 Livingston Group, LLC Livingston Group, LLC 6344 Amendment       https://efile.fara.gov/docs/6344-Amendment-20201030-41.pdf
112846 112846 2020-10-30 Livingston Group, LLC Livingston Group, LLC 6344 Supplemental Statement       https://efile.fara.gov/docs/6344-Supplemental-Statement-20201030-9.pdf
112847 112847 2020-10-30 Lumen8 Advisors, LLC Lumen8 Advisors, LLC 6537 Amendment       https://efile.fara.gov/docs/6537-Amendment-20201030-2.pdf
112848 112848 2020-10-30 Lumen8 Advisors, LLC Lumen8 Advisors, LLC 6537 Exhibit AB   Embassy of the State of Qatar QATAR https://efile.fara.gov/docs/6537-Exhibit-AB-20201030-3.pdf
112849 112849 2020-10-30 Lumen8 Advisors, LLC Lumen8 Advisors, LLC 6537 Supplemental Statement       https://efile.fara.gov/docs/6537-Supplemental-Statement-20201030-5.pdf
112850 112850 2020-10-30 MSLGROUP Americas, LLC QORVIS LLC 5483 Exhibit C       https://efile.fara.gov/docs/5483-Exhibit-C-20201030-5.pdf
112851 112851 2020-10-30 Miller & Chevalier Chartered Miller & Chevalier Chartered 6533 Supplemental Statement       https://efile.fara.gov/docs/6533-Supplemental-Statement-20201030-6.pdf
112852 112852 2020-10-30 Office of Tibet Office of Tibet 1699 Supplemental Statement       https://efile.fara.gov/docs/1699-Supplemental-Statement-20201030-32.pdf
112853 112853 2020-10-30 PASS LLC PASS LLC 6538 Supplemental Statement       https://efile.fara.gov/docs/6538-Supplemental-Statement-20201030-6.pdf
112854 112854 2020-10-30 Portland PR Inc. Portland PR Inc. 6064 Supplemental Statement       https://efile.fara.gov/docs/6064-Supplemental-Statement-20201030-17.pdf
112855 112855 2020-10-30 Potomac International Partners, Inc. Potomac International Partners, Inc. 6459 Short-Form Amagai, Mattie     https://efile.fara.gov/docs/6459-Short-Form-20201030-36.pdf
112856 112856 2020-10-30 Potomac International Partners, Inc. Potomac International Partners, Inc. 6459 Supplemental Statement       https://efile.fara.gov/docs/6459-Supplemental-Statement-20201030-9.pdf
112857 112857 2020-10-30 QORVIS LLC QORVIS LLC 5483 Amendment       https://efile.fara.gov/docs/5483-Amendment-20201030-84.pdf
112858 112858 2020-10-30 QORVIS LLC QORVIS LLC 5483 Amendment       https://efile.fara.gov/docs/5483-Amendment-20201030-85.pdf
112859 112859 2020-10-30 QORVIS LLC QORVIS LLC 5483 Informational Materials   Kingdom of Saudi Arabia SAUDI ARABIA https://efile.fara.gov/docs/5483-Informational-Materials-20201030-156.pdf
112860 112860 2020-10-30 QORVIS LLC QORVIS LLC 5483 Short-Form Franz, Jared     https://efile.fara.gov/docs/5483-Short-Form-20201030-790.pdf
112861 112861 2020-10-30 QORVIS LLC QORVIS LLC 5483 Short-Form Lagana, Gregory     https://efile.fara.gov/docs/5483-Short-Form-20201030-788.pdf
112862 112862 2020-10-30 QORVIS LLC QORVIS LLC 5483 Short-Form Lagana, Gregory     https://efile.fara.gov/docs/5483-Short-Form-20201030-852.pdf
112863 112863 2020-10-30 QORVIS LLC QORVIS LLC 5483 Supplemental Statement       https://efile.fara.gov/docs/5483-Supplemental-Statement-20201030-34.pdf
112864 112864 2020-10-30 Reed, T. Dean Reed, T. Dean 5044 Supplemental Statement       https://efile.fara.gov/docs/5044-Supplemental-Statement-20201030-38.pdf
112865 112865 2020-10-30 Somaliland Mission USA, LLC Somaliland Mission USA, LLC 6798 Supplemental Statement       https://efile.fara.gov/docs/6798-Supplemental-Statement-20201030-1.pdf
112866 112866 2020-10-30 Sprague, Esther Marie Sprague, Esther Marie 6091 Supplemental Statement       https://efile.fara.gov/docs/6091-Supplemental-Statement-20201030-19.pdf
112867 112867 2020-10-30 Steptoe & Johnson, LLP Steptoe & Johnson, LLP 6653 Supplemental Statement       https://efile.fara.gov/docs/6653-Supplemental-Statement-20201030-3.pdf
112868 112868 2020-10-30 TRG Advisory Services, LLC TRG Advisory Services, LLC 6596 Supplemental Statement       https://efile.fara.gov/docs/6596-Supplemental-Statement-20201030-6.pdf
112869 112869 2020-10-30 Terakeet LLC Terakeet LLC 6806 Supplemental Statement       https://efile.fara.gov/docs/6806-Supplemental-Statement-20201030-2.pdf
112870 112870 2020-10-30 Wise Capital Strategy, LLC Wise Capital Strategy, LLC 6803 Supplemental Statement       https://efile.fara.gov/docs/6803-Supplemental-Statement-20201030-1.pdf
112871 112871 2020-10-30 Zeno Group, Inc. Zeno Group, Inc. 6652 Supplemental Statement       https://efile.fara.gov/docs/6652-Supplemental-Statement-20201030-11.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])
);