home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

13 rows where Registration_Number = 6295

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • VA 13

Registration_Number 1

  • McGuireWoods Consulting, LLC · 13 ✖

Registrant_Name 1

  • McGuireWoods Consulting, LLC 13

City 1

  • Richmond 13
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
8907 8907 2017-03-01 2016-06-10 Obenshain Anne McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
12284 12284 2021-03-31 2017-06-21 Schroth Kassie McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
12579 12579 2017-04-01 2016-06-14 Jones Allison McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
18171 18171 2016-05-31 2015-09-16 Fortson Robert L. McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
25765 25765 2022-08-01 2016-02-23 Greer Lauren C. McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
25768 25768 2022-08-01 2015-05-19 Bowles Mark T. McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
25770 25770 2022-08-01 2019-12-13 Thompson Danica McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
36281 36281 2020-11-23 2015-05-19 Bishop Tyler McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
37110 37110 2018-11-30 2016-06-10 Liberty Susan McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
37111 37111 2018-11-30 2016-06-14 Rennolds Davis McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
37539 37539 2018-12-01 2016-06-14 Baynard Tracy McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
37540 37540 2018-12-01 2017-06-21 Adams III Theodore F. McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
42011 42011 2015-12-31 2015-11-24 Long Andrew McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219

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])
);
Powered by Datasette · Queries took 586.802ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows