home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_RegistrantDocs

Table actions
  • GraphQL API for FARA_All_RegistrantDocs
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

42 rows where Registrant_Name = "Cornerstone Government Affairs, LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Document_Type 6

  • Short-Form 23
  • Amendment 9
  • Exhibit AB 4
  • Supplemental Statement 4
  • Exhibit C 1
  • Registration Statement 1

Foreign_Principal_Name 4

  • - 38
  • Embassy of the Republic of Korea 2
  • Justice and Equality Movement thru Skimstone Communications 1
  • LNG Allies, Inc. 1

Foreign_Principal_Country 4

  • - 38
  • KOREA SOUTH 2
  • INTERNATIONAL 1
  • SUDAN 1

Registrant_Name 1

  • Cornerstone Government Affairs, LLC · 42 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
3902 3902 2015-01-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20150107-6.pdf
5779 5779 2015-01-16 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Exhibit AB   Justice and Equality Movement thru Skimstone Communications SUDAN https://efile.fara.gov/docs/6211-Exhibit-AB-20150116-5.pdf
5780 5780 2015-01-16 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Crumbliss, John     https://efile.fara.gov/docs/6211-Short-Form-20150116-108.pdf
5781 5781 2015-01-16 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form DiNino, Paul     https://efile.fara.gov/docs/6211-Short-Form-20150116-102.pdf
5782 5782 2015-01-16 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Murray, Mark     https://efile.fara.gov/docs/6211-Short-Form-20150116-106.pdf
5783 5783 2015-01-16 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Smith, Michael     https://efile.fara.gov/docs/6211-Short-Form-20150116-104.pdf
25931 25931 2011-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Exhibit C       https://efile.fara.gov/docs/6211-Exhibit-C-20110307-1.pdf
25957 25957 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6211-Exhibit-AB-20140307-2.pdf
25958 25958 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Registration Statement       https://efile.fara.gov/docs/6211-Registration-Statement-20140307-1.pdf
25959 25959 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form DiNino, Paul     https://efile.fara.gov/docs/6211-Short-Form-20140307-64.pdf
25960 25960 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Essalih, Hassan Anthony     https://efile.fara.gov/docs/6211-Short-Form-20140307-66.pdf
25961 25961 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Gonella, Geoff     https://efile.fara.gov/docs/6211-Short-Form-20140307-68.pdf
25962 25962 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Higdon, Michael     https://efile.fara.gov/docs/6211-Short-Form-20140307-70.pdf
25963 25963 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Keast, John     https://efile.fara.gov/docs/6211-Short-Form-20140307-72.pdf
25964 25964 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Mrdeza, Michelle     https://efile.fara.gov/docs/6211-Short-Form-20140307-74.pdf
25965 25965 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Murray, Mark     https://efile.fara.gov/docs/6211-Short-Form-20140307-76.pdf
25966 25966 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Peacock, Nelson     https://efile.fara.gov/docs/6211-Short-Form-20140307-78.pdf
25967 25967 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Richards, James     https://efile.fara.gov/docs/6211-Short-Form-20140307-80.pdf
25968 25968 2014-03-07 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Smith, Michael     https://efile.fara.gov/docs/6211-Short-Form-20140307-82.pdf
36985 36985 2014-04-01 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Crumbliss, John     https://efile.fara.gov/docs/6211-Short-Form-20140401-88.pdf
36986 36986 2014-04-01 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Kaufman, Willaim Campbell     https://efile.fara.gov/docs/6211-Short-Form-20140401-86.pdf
36987 36987 2014-04-01 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Perry III, Schley Louis     https://efile.fara.gov/docs/6211-Short-Form-20140401-84.pdf
37448 37448 2015-04-03 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20150403-7.pdf
40730 40730 2014-04-16 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Exhibit AB   LNG Allies, Inc. INTERNATIONAL https://efile.fara.gov/docs/6211-Exhibit-AB-20140416-3.pdf
40731 40731 2014-04-16 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Hutchison, Fred H.     https://efile.fara.gov/docs/6211-Short-Form-20140416-90.pdf
40983 40983 2014-04-17 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20140417-1.pdf
40984 40984 2014-04-17 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Tober, Eric     https://efile.fara.gov/docs/6211-Short-Form-20140417-92.pdf
44031 44031 2016-04-29 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Supplemental Statement       https://efile.fara.gov/docs/6211-Supplemental-Statement-20160429-5.pdf
44951 44951 2015-04-30 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Supplemental Statement       https://efile.fara.gov/docs/6211-Supplemental-Statement-20150430-3.pdf
62198 62198 2015-06-02 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20150602-8.pdf
73586 73586 2014-07-02 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Smith, Michael     https://efile.fara.gov/docs/6211-Short-Form-20140702-94.pdf
74700 74700 2014-07-08 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form DiNino, Paul     https://efile.fara.gov/docs/6211-Short-Form-20140708-96.pdf
76699 76699 2014-07-17 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Keast, John     https://efile.fara.gov/docs/6211-Short-Form-20140717-98.pdf
78388 78388 2014-07-24 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Short-Form Barton, Joseph     https://efile.fara.gov/docs/6211-Short-Form-20140724-100.pdf
95377 95377 2014-09-03 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20140903-3.pdf
98725 98725 2014-09-18 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20140918-4.pdf
98726 98726 2014-09-18 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Exhibit AB   Embassy of the Republic of Korea KOREA SOUTH https://efile.fara.gov/docs/6211-Exhibit-AB-20140918-4.pdf
110482 110482 2014-10-22 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20141022-5.pdf
112203 112203 2015-10-29 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20151029-9.pdf
112204 112204 2015-10-29 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Supplemental Statement       https://efile.fara.gov/docs/6211-Supplemental-Statement-20151029-4.pdf
112651 112651 2014-10-30 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Supplemental Statement       https://efile.fara.gov/docs/6211-Supplemental-Statement-20141030-2.pdf
117707 117707 2015-11-05 Cornerstone Government Affairs, LLC Cornerstone Government Affairs, LLC 6211 Amendment       https://efile.fara.gov/docs/6211-Amendment-20151105-10.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])
);
Powered by Datasette · Queries took 551.245ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history