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

23 rows where Foreign_Principal_Name = "Embassy of the Republic of Korea" and Registrant_Name = "Cornerstone Government Affairs"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Document_Type 2

Registrant_Name 1

  • Cornerstone Government Affairs · 23 ✖

Foreign_Principal_Name 1

  • Embassy of the Republic of Korea · 23 ✖

Foreign_Principal_Country 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
6297 6297 2023-01-19 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20230119-32.pdf
6413 6413 2017-01-20 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20170120-1.pdf
7515 7515 2018-01-25 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20180125-26.pdf
7729 7729 2018-01-26 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20180126-18.pdf
20099 20099 2018-02-28 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20180228-3.pdf
20147 20147 2020-02-28 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20200228-13.pdf
24585 24585 2019-03-02 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20190302-7.pdf
24618 24618 2021-03-02 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20210302-20.pdf
26819 26819 2018-03-10 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20180310-20.pdf
27203 27203 2022-03-11 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20220311-25.pdf
27204 27204 2022-03-11 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20220311-26.pdf
27365 27365 2019-03-12 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20190312-22.pdf
87331 87331 2022-08-12 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20220812-28.pdf
90649 90649 2019-08-29 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20190829-10.pdf
91446 91446 2018-08-31 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Exhibit-AB-20180831-5.pdf
101203 101203 2017-09-28 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20170928-24.pdf
110910 110910 2017-10-24 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20171024-25.pdf
117048 117048 2017-11-02 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20171102-5.pdf
119487 119487 2017-11-14 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20171114-6.pdf
119945 119945 2017-11-16 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20171116-9.pdf
120224 120224 2017-11-17 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20171117-11.pdf
120225 120225 2017-11-17 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20171117-8.pdf
129628 129628 2017-12-07 Cornerstone Government Affairs Cornerstone Government Affairs 6401 Informational Materials   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6401-Informational-Materials-20171207-13.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])
);