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 Registration_Number = 6274

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped, Short_Form_Name, Date_Stamped (date)

Foreign_Principal_Country

Registrant_Name

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
5635 5635 2015-01-19 Rogich Communications Group 6274 6274 Exhibit AB   People's Republic of China Ambassador Cui Tiankai CHINA https://efile.fara.gov/docs/6274-Exhibit-AB-20150119-1.pdf
5636 5636 2015-01-19 Rogich Communications Group 6274 6274 Exhibit C       https://efile.fara.gov/docs/6274-Exhibit-C-20150119-1.pdf
5637 5637 2015-01-19 Rogich Communications Group 6274 6274 Registration Statement       https://efile.fara.gov/docs/6274-Registration-Statement-20150119-1.pdf
5638 5638 2015-01-19 Rogich Communications Group 6274 6274 Short-Form Cole, Christopher     https://efile.fara.gov/docs/6274-Short-Form-20150119-2.pdf
5639 5639 2015-01-19 Rogich Communications Group 6274 6274 Short-Form Fellows, Sean     https://efile.fara.gov/docs/6274-Short-Form-20150119-6.pdf
5640 5640 2015-01-19 Rogich Communications Group 6274 6274 Short-Form Rogich, Sigmund     https://efile.fara.gov/docs/6274-Short-Form-20150119-4.pdf
14311 14311 2020-02-14 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20200214-10.pdf
14593 14593 2017-02-16 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20170216-4.pdf
16660 16660 2018-02-27 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20180227-6.pdf
17369 17369 2019-02-28 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20190228-8.pdf
27027 27027 2016-03-28 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20160328-1.pdf
27028 27028 2016-03-28 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20160328-2.pdf
37404 37404 2017-04-28 Rogich Communications Group 6274 6274 Exhibit AB   China Rilin Industrial Group through China/US Club, LLC CHINA https://efile.fara.gov/docs/6274-Exhibit-AB-20170428-2.pdf
37405 37405 2017-04-28 Rogich Communications Group 6274 6274 Short-Form Rogich, Sigmund     https://efile.fara.gov/docs/6274-Short-Form-20170428-8.pdf
78313 78313 2016-08-30 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20160830-3.pdf
78335 78335 2017-08-30 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20170830-5.pdf
78408 78408 2019-08-30 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20190830-9.pdf
78412 78412 2020-08-30 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20200830-11.pdf
99121 99121 2018-10-31 Rogich Communications Group 6274 6274 Supplemental Statement       https://efile.fara.gov/docs/6274-Supplemental-Statement-20181031-7.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)
);