FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

43 rows where Registration_Number = 6401

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Cornerstone Government Affairs · 43 ✖

Registrant_Name 1

City 1

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
1 1         Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
154 154   2017-01-20 Richards James Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
221 221   2020-01-29 Jordan Justin Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
324 324   2023-02-06 Cano Courtney Marie Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
420 420   2020-02-18 Patel Nialkamal Ashok Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
631 631   2023-03-23 Marchese Steven Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1109 1109   2023-05-25 Hunter Lauren Paige Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1110 1110   2023-05-25 Sheidler Benjamin Neil Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1111 1111   2023-05-25 Tatum Thomas Joseph Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1588 1588   2017-08-10 Crumbliss John Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1589 1589   2017-08-10 Webster Peter Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1699 1699   2017-08-31 Essalih Tony Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1700 1700   2017-08-31 Perry Louie Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1701 1701   2017-08-31 Tober Eric Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
1816 1816   2021-09-21 Heathcock Alex Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
2114 2114   2020-11-05 Gomez Alice Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
2117 2117   2017-11-06 Shipman Thomas Hunt Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
2118 2118   2017-11-06 Smith Michael Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
2132 2132   2020-11-10 Cousineau William Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
2163 2163   2020-11-13 Adelman David Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
2171 2171   2017-11-15 Hinch Matthew Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
3016 3016 2021-01-01 2017-08-10 Sweat Susan Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
3017 3017 2021-01-01 2019-12-04 Nelson Tyler Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
4187 4187 2017-01-20 2017-01-20 Nelson Tyler Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
4188 4188 2017-01-20 2017-08-10 Nelson Tyler Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
5613 5613 2022-01-31 2017-08-31 Sarley Christopher Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
15878 15878 2022-05-07 2022-03-09 Drendel Amanda Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
21918 21918 2019-06-30 2019-02-05 Burghoff Mary Claire Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
21923 21923 2019-06-30 2018-03-05 Hubert Martin Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
21924 21924 2019-06-30 2018-03-06 Jordan Justin Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
21933 21933 2019-06-30 2018-07-24 Centers III James L. Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
25414 25414 2022-07-31 2020-06-04 McCord Morgan Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
25417 25417 2022-07-31 2017-08-10 Barton Joseph Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
25419 25419 2022-07-31 2017-08-31 Kaufman Campbell Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
25424 25424 2022-07-31 2020-11-11 Hubert Martin Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
25898 25898 2021-08-03 2021-08-03 Rainwater Paul Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
25899 25899 2021-08-03 2021-08-03 Roach Randy Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
25900 25900 2021-08-03 2021-08-03 Schauer Tim Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
25901 25901 2021-08-03 2021-08-03 Smith William Francis Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
29250 29250 2019-09-05 2018-02-22 Champion James C. Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
36283 36283 2021-11-23 2021-09-15 Woodall Lily Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
38528 38528 2018-12-16 2017-01-20 Keast John Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
42177 42177 2018-12-31 2017-01-20 Murray Mark Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);