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

30 rows where City = "Richmond"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Address_1, Address_2, Short_Form_Termination_Date (date)

Registration_Number 10

  • McGuireWoods Consulting, LLC 13
  • LeClairRyan, A Professional Corporation 6
  • Whitmore, Judith M. 2
  • Pathfinder Group, L.L.C. 2
  • Reed, T. Dean 2
  • Promoter American/Hungarian Public Relations 1
  • Williams Mullen Strategies, Inc. 1
  • Williams, Mullen, Clark & Dobbins, P.C. 1
  • Thunderbolt Consulting, LLC 1
  • Hunton Andrews Kurth LLP 1

Registrant_Name 10

  • McGuireWoods Consulting, LLC 13
  • LeClairRyan, A Professional Corporation 6
  • Pathfinder Group, L.L.C. 2
  • Reed, T. Dean 2
  • Whitmore, Judith M. 2
  • Hunton Andrews Kurth LLP 1
  • Promoter American/Hungarian Public Relations 1
  • Thunderbolt Consulting, LLC 1
  • Williams Mullen Strategies, Inc. 1
  • Williams, Mullen, Clark & Dobbins, P.C. 1

State 2

  • VA 29
  • TX 1

City 1

  • Richmond · 30 ✖
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
997 997   2023-05-10 Bohannon Robert Trask Hunton Andrews Kurth LLP 7268 2023-05-10 Hunton Andrews Kurth LLP 951 East Byrd Street Riverfront Plaza, East Tower Richmond VA 23219
1582 1582   2021-08-09 Snow Gary D. Thunderbolt Consulting, LLC 6988 2021-08-09 Thunderbolt Consulting, LLC 8311 Buffalo Creek Drive   Richmond TX 77406
3532 3532 2001-01-10 1992-09-22 Geier-Smith Hope Whitmore, Judith M. 4336 1990-02-05 Whitmore, Judith M. 9504 Carterwood Road   Richmond VA 23229-7608
5407 5407 2008-01-31 2005-07-21 Nowlin Warren Eddy Williams, Mullen, Clark & Dobbins, P.C. 5699 2005-07-21 Williams, Mullen, Clark & Dobbins, P.C. Two James Center, 1021 East Cary Street P.O. Box 1320 Richmond VA 23218-1320
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
12597 12597 2020-04-01 2017-03-17 Arnold Kenneth P. Reed, T. Dean 5044 1995-09-13 Reed, T. Dean 1421 Westbrook Avenue   Richmond VA 23227
13495 13495 2016-04-15 2013-12-26 Arnold Kenneth P. Reed, T. Dean 5044 1995-09-13 Reed, T. Dean 1421 Westbrook Avenue   Richmond VA 23227
17309 17309 2009-05-28 2009-04-14 Williams Krystal J. LeClairRyan, A Professional Corporation 5901 2008-12-17 LeClairRyan, A Professional Corporation 919 East Main Street 24th Floor 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
19825 19825 2010-06-18 2008-12-29 McAllister Singleton B. LeClairRyan, A Professional Corporation 5901 2008-12-17 LeClairRyan, A Professional Corporation 919 East Main Street 24th Floor Richmond VA 23219
19826 19826 2010-06-18 2008-12-29 Rougeau Weldon J. LeClairRyan, A Professional Corporation 5901 2008-12-17 LeClairRyan, A Professional Corporation 919 East Main Street 24th Floor Richmond VA 23219
20109 20109 1995-06-23 1995-03-09 Harrison Robert C. Pathfinder Group, L.L.C. 5001 1995-03-09 Pathfinder Group, L.L.C. 3406 Noble Avenue   Richmond VA 23222
20110 20110 1995-06-23 1995-03-09 Rodgers Thomas C. Pathfinder Group, L.L.C. 5001 1995-03-09 Pathfinder Group, L.L.C. 3406 Noble Avenue   Richmond VA 23222
21642 21642 2009-06-30 2005-07-21 Robertson Mark John Williams Mullen Strategies, Inc. 5698 2005-07-21 Williams Mullen Strategies, Inc. Two James Center, 1021 East Cary Street P.O. Box 1320 Richmond VA 23218
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
26515 26515 2011-08-12 2009-04-14 Ashby Christopher B. LeClairRyan, A Professional Corporation 5901 2008-12-17 LeClairRyan, A Professional Corporation 919 East Main Street 24th Floor Richmond VA 23219
27597 27597 2001-08-28 1992-09-22 Kyros Kathryn Whitmore, Judith M. 4336 1990-02-05 Whitmore, Judith M. 9504 Carterwood Road   Richmond VA 23229-7608
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
37919 37919 1993-12-08 1991-10-03 Amann Henry J. , Jr. Promoter American/Hungarian Public Relations 4573 1991-10-03 Promoter American/Hungarian Public Relations 1508 Willow Lawn Drive Suite 205 Richmond VA 23230
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
42163 42163 2017-12-31 2011-11-01 Anderson David E. LeClairRyan, A Professional Corporation 5901 2008-12-17 LeClairRyan, A Professional Corporation 919 East Main Street 24th Floor Richmond VA 23219
42170 42170 2017-12-31 2008-12-17 Wolf Thomas M. LeClairRyan, A Professional Corporation 5901 2008-12-17 LeClairRyan, A Professional Corporation 919 East Main Street 24th Floor 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 506.782ms · 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