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

40 rows where "Date_Stamped" is on date 2023-04-21

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Document_Type, 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
41855 41855 2023-04-21 BGR Government Affairs, LLC BGR Government Affairs, LLC 5430 Informational Materials   Ministry of Investments and Foreign Trade of the Republic of Uzbekistan UZBEKISTAN https://efile.fara.gov/docs/5430-Informational-Materials-20230421-281.pdf
41856 41856 2023-04-21 Ballard Partners Ballard Partners 7070 Short-Form Klopp, Stephen Richard     https://efile.fara.gov/docs/7070-Short-Form-20230421-48.pdf
41857 41857 2023-04-21 Ballard Partners Ballard Partners 7070 Short-Form Klopp, Stephen Richard     https://efile.fara.gov/docs/7070-Short-Form-20230421-50.pdf
41858 41858 2023-04-21 China Daily Distribution Corporation China Daily Distribution Corporation 3457 Informational Materials   China Daily of Beijing, China CHINA https://efile.fara.gov/docs/3457-Informational-Materials-20230421-140.pdf
41859 41859 2023-04-21 China Daily Distribution Corporation China Daily Distribution Corporation 3457 Informational Materials   China Daily of Beijing, China CHINA https://efile.fara.gov/docs/3457-Informational-Materials-20230421-141.pdf
41860 41860 2023-04-21 China Daily Distribution Corporation China Daily Distribution Corporation 3457 Informational Materials   China Daily of Beijing, China CHINA https://efile.fara.gov/docs/3457-Informational-Materials-20230421-142.pdf
41861 41861 2023-04-21 China Daily Distribution Corporation China Daily Distribution Corporation 3457 Informational Materials   China Daily of Beijing, China CHINA https://efile.fara.gov/docs/3457-Informational-Materials-20230421-143.pdf
41862 41862 2023-04-21 China Daily Distribution Corporation China Daily Distribution Corporation 3457 Informational Materials   China Daily of Beijing, China CHINA https://efile.fara.gov/docs/3457-Informational-Materials-20230421-144.pdf
41863 41863 2023-04-21 Empire Consulting Group, Inc. Empire Consulting Group, Inc. 6919 Informational Materials   Tapei Economic & Cultural Representative Office in the United States TAIWAN https://efile.fara.gov/docs/6919-Informational-Materials-20230421-4.pdf
41864 41864 2023-04-21 Fish & Richardson P.C. Fish & Richardson P.C. 6830 Supplemental Statement       https://efile.fara.gov/docs/6830-Supplemental-Statement-20230421-6.pdf
41865 41865 2023-04-21 Ghebi LLC Ghebi LLC 6869 Informational Materials   Federal State Unitary Enterprise Rossiya Segodnya International Information Agency RUSSIA https://efile.fara.gov/docs/6869-Informational-Materials-20230421-783.pdf
41866 41866 2023-04-21 India Tourism, New York India Tourism, New York 2329 Supplemental Statement       https://efile.fara.gov/docs/2329-Supplemental-Statement-20230421-40.pdf
41867 41867 2023-04-21 India Tourism, New York India Tourism, New York 2329 Supplemental Statement       https://efile.fara.gov/docs/2329-Supplemental-Statement-20230421-42.pdf
41868 41868 2023-04-21 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-20230421-528.pdf
41869 41869 2023-04-21 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-20230421-912.pdf
41870 41870 2023-04-21 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-20230421-913.pdf
41871 41871 2023-04-21 Livingston Group, LLC Livingston Group, LLC 6344 Informational Materials   National Democratic Alliance of Armenia ARMENIA https://efile.fara.gov/docs/6344-Informational-Materials-20230421-108.pdf
41872 41872 2023-04-21 Mercury Public Affairs, LLC Mercury Public Affairs, LLC 6170 Informational Materials   Samsung Electronics Co., Ltd. ("Samsung") KOREA SOUTH https://efile.fara.gov/docs/6170-Informational-Materials-20230421-1101.pdf
41873 41873 2023-04-21 Prime Policy Group Prime Policy Group 6377 Amendment       https://efile.fara.gov/docs/6377-Amendment-20230421-13.pdf
41874 41874 2023-04-21 Prime Policy Group Prime Policy Group 6377 Amendment       https://efile.fara.gov/docs/6377-Amendment-20230421-14.pdf
41875 41875 2023-04-21 Prime Policy Group Prime Policy Group 6377 Exhibit AB   Dr. Sali Berisha ALBANIA https://efile.fara.gov/docs/6377-Exhibit-AB-20230421-15.pdf
41876 41876 2023-04-21 Prime Policy Group Prime Policy Group 6377 Exhibit AB   Jayu Press KOREA SOUTH https://efile.fara.gov/docs/6377-Exhibit-AB-20230421-14.pdf
41877 41877 2023-04-21 Prime Policy Group Prime Policy Group 6377 Short-Form Antebi, Karen     https://efile.fara.gov/docs/6377-Short-Form-20230421-82.pdf
41878 41878 2023-04-21 Prime Policy Group Prime Policy Group 6377 Short-Form Black, Charles R     https://efile.fara.gov/docs/6377-Short-Form-20230421-86.pdf
41879 41879 2023-04-21 Prime Policy Group Prime Policy Group 6377 Short-Form Disler, Mark     https://efile.fara.gov/docs/6377-Short-Form-20230421-80.pdf
41880 41880 2023-04-21 Prime Policy Group Prime Policy Group 6377 Short-Form Reed, Tom     https://efile.fara.gov/docs/6377-Short-Form-20230421-84.pdf
41881 41881 2023-04-21 Prime Policy Group Prime Policy Group 6377 Short-Form Terp, Andrew     https://efile.fara.gov/docs/6377-Short-Form-20230421-78.pdf
41882 41882 2023-04-21 United States Center for Diplomacy, Inc. United States Center for Diplomacy, Inc. 7162 Supplemental Statement       https://efile.fara.gov/docs/7162-Supplemental-Statement-20230421-1.pdf
41883 41883 2023-04-21 VisitBritain VisitBritain 579 Supplemental Statement       https://efile.fara.gov/docs/579-Supplemental-Statement-20230421-39.pdf
41884 41884 2023-04-21 Warner Norcross + Judd Warner Norcross + Judd 7261 Exhibit AB   Gotion, Inc. CHINA https://efile.fara.gov/docs/7261-Exhibit-AB-20230421-1.pdf
41885 41885 2023-04-21 Warner Norcross + Judd Warner Norcross + Judd 7261 Exhibit C       https://efile.fara.gov/docs/7261-Exhibit-C-20230421-1.pdf
41886 41886 2023-04-21 Warner Norcross + Judd Warner Norcross + Judd 7261 Registration Statement       https://efile.fara.gov/docs/7261-Registration-Statement-20230421-1.pdf
41887 41887 2023-04-21 Warner Norcross + Judd Warner Norcross + Judd 7261 Short-Form Belka, Jared     https://efile.fara.gov/docs/7261-Short-Form-20230421-2.pdf
41888 41888 2023-04-21 Warner Norcross + Judd Warner Norcross + Judd 7261 Short-Form Davies, Robert     https://efile.fara.gov/docs/7261-Short-Form-20230421-4.pdf
41889 41889 2023-04-21 Warner Norcross + Judd Warner Norcross + Judd 7261 Short-Form Donohue, Dennis     https://efile.fara.gov/docs/7261-Short-Form-20230421-6.pdf
41890 41890 2023-04-21 Warner Norcross + Judd Warner Norcross + Judd 7261 Short-Form Field-Foster, Monique     https://efile.fara.gov/docs/7261-Short-Form-20230421-10.pdf
41891 41891 2023-04-21 Warner Norcross + Judd Warner Norcross + Judd 7261 Short-Form Zoerhof, Lance     https://efile.fara.gov/docs/7261-Short-Form-20230421-8.pdf
41892 41892 2023-04-21 theGroup DC, LLC theGroup DC, LLC 6388 Amendment       https://efile.fara.gov/docs/6388-Amendment-20230421-10.pdf
41893 41893 2023-04-21 theGroup DC, LLC theGroup DC, LLC 6388 Exhibit AB   Embassy of Japan JAPAN https://efile.fara.gov/docs/6388-Exhibit-AB-20230421-11.pdf
41894 41894 2023-04-21 theGroup DC, LLC theGroup DC, LLC 6388 Short-Form Henry, Sudafi     https://efile.fara.gov/docs/6388-Short-Form-20230421-38.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])
);