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

27 rows where "Date_Stamped" is on date 2022-09-29

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Foreign_Principal_Country

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
101572 101572 2022-09-29 AF International, LLC AF International, LLC 6639 Supplemental Statement       https://efile.fara.gov/docs/6639-Supplemental-Statement-20220929-8.pdf
101573 101573 2022-09-29 Barzan Aeronautical LLC Barzan Aeronautical LLC 6635 Supplemental Statement       https://efile.fara.gov/docs/6635-Supplemental-Statement-20220929-7.pdf
101574 101574 2022-09-29 Broydrick and Associates, Inc. Broydrick and Associates, Inc. 6796 Supplemental Statement       https://efile.fara.gov/docs/6796-Supplemental-Statement-20220929-5.pdf
101575 101575 2022-09-29 Brunswick Group LLC Brunswick Group LLC 6826 Amendment       https://efile.fara.gov/docs/6826-Amendment-20220929-9.pdf
101576 101576 2022-09-29 Brunswick Group LLC Brunswick Group LLC 6826 Exhibit AB   Legacy Development and Management S.A.E. EGYPT https://efile.fara.gov/docs/6826-Exhibit-AB-20220929-6.pdf
101577 101577 2022-09-29 Brunswick Group LLC Brunswick Group LLC 6826 Short-Form Belz, Anne     https://efile.fara.gov/docs/6826-Short-Form-20220929-50.pdf
101578 101578 2022-09-29 Brunswick Group LLC Brunswick Group LLC 6826 Short-Form Eliano, Liza     https://efile.fara.gov/docs/6826-Short-Form-20220929-48.pdf
101579 101579 2022-09-29 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-20220929-614.pdf
101580 101580 2022-09-29 Hai Tian Development U.S.A., Inc. Hai Tian Development U.S.A., Inc. 5143 Informational Materials   People's Daily Overseas Edition CHINA https://efile.fara.gov/docs/5143-Informational-Materials-20220929-97.pdf
101581 101581 2022-09-29 KOTRA KOTRA 1619 Informational Materials   Korea Trade-Investment Promotion Agency KOREA SOUTH https://efile.fara.gov/docs/1619-Informational-Materials-20220929-143.pdf
101582 101582 2022-09-29 KOTRA KOTRA 1619 Informational Materials   Korea Trade-Investment Promotion Agency KOREA SOUTH https://efile.fara.gov/docs/1619-Informational-Materials-20220929-144.pdf
101583 101583 2022-09-29 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-20220929-778.pdf
101584 101584 2022-09-29 Okinawa Prefecture DC Office, Inc. Okinawa Prefecture DC Office, Inc. 6332 Amendment       https://efile.fara.gov/docs/6332-Amendment-20220929-4.pdf
101585 101585 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-1.pdf
101586 101586 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-2.pdf
101587 101587 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-3.pdf
101588 101588 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-4.pdf
101589 101589 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-5.pdf
101590 101590 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-6.pdf
101591 101591 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-7.pdf
101592 101592 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-8.pdf
101593 101593 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Informational Materials   Partido Politico MIRA COLOMBIA https://efile.fara.gov/docs/7081-Informational-Materials-20220929-9.pdf
101594 101594 2022-09-29 Partido Politico Mira Partido Politico Mira 7081 Supplemental Statement       https://efile.fara.gov/docs/7081-Supplemental-Statement-20220929-1.pdf
101595 101595 2022-09-29 SAPRAC, Inc. SAPRAC, Inc. 6457 Supplemental Statement       https://efile.fara.gov/docs/6457-Supplemental-Statement-20220929-9.pdf
101596 101596 2022-09-29 Sochua Mu Leiper Sochua Mu Leiper 7042 Informational Materials   Cambodia National Rescue Party CAMBODIA https://efile.fara.gov/docs/7042-Informational-Materials-20220929-99.pdf
101597 101597 2022-09-29 Squire Patton Boggs, LLP Squire Patton Boggs, LLP 2165 Informational Materials   The Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/2165-Informational-Materials-20220929-215.pdf
101598 101598 2022-09-29 Squire Patton Boggs, LLP Squire Patton Boggs, LLP 2165 Informational Materials   The Federal Democratic Republic of Ethiopia ETHIOPIA https://efile.fara.gov/docs/2165-Informational-Materials-20220929-216.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])
);