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

38 rows where City = "Seattle" and Registration_Number = 3047

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date)

State 1

  • WA 38

Registration_Number 1

  • Foster Garvey PC · 38 ✖

Registrant_Name 1

  • Foster Garvey PC 38

City 1

  • Seattle · 38 ✖
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
557 557   2011-03-11 Duboff Scott Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
659 659   2022-03-26 Hoff Paul Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
2830 2830 2004-01-01 1982-09-27 Robertson Bruce A. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
5729 5729 1982-02-01 1980-01-17 Hoerster John K. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
8220 8220 2007-02-28 1997-03-10 Schneider Matthew R. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
8268 8268 2014-02-28 1989-03-09 Hoff Paul S. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
8269 8269 2014-02-28 1989-03-09 Wegman Richard A. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
8827 8827 2002-03-01 1999-05-05 Birch Ronald G. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
9567 9567 1993-03-10 1985-03-08 Dickinson Steven M. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
9639 9639 1994-03-11 1980-01-17 Barer Stanley H. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
9640 9640 1994-03-11 1988-03-07 West Clay F. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
9975 9975 1995-03-15 1990-12-13 Sheppard Edward J. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
11129 11129 1985-03-30 1980-09-21 O'Neal A. Daniel Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
12511 12511 2001-04-01 1992-03-09 Greenberg Eldon V.C. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
13438 13438 1990-04-15 1989-01-13 Manger Charles B. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
14337 14337 1988-04-29 1987-06-17 Shreves Frederick L. , II. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
14561 14561 1986-04-30 1980-01-17 Adams Brock Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
15385 15385 1987-05-01 1985-03-08 Templeton Patrick A. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
15389 15389 1988-05-01 1984-05-03 Garten Allan M. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
15391 15391 1988-05-01 1982-09-10 Beall James A. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
17384 17384 2019-05-29 2017-03-30 Edelman Aaron S. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
22162 22162 1985-07-01 1982-12-23 Alberger William R. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
23607 23607 1985-07-19 1984-05-03 Liebner J. Renee Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
26727 26727 1989-08-15 1989-03-09 Kramnick Rebecca Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
28097 28097 1986-08-31 1986-05-08 Dettmar Joseph H. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
28816 28816 1981-09-01 1980-09-12 Jennings Kenneth W. , Jr. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
29412 29412 1988-09-08 1980-01-17 Routh E. Charles Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
29413 29413 1988-09-08 1983-03-08 Davis Keven J. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
29414 29414 1988-09-08 1984-05-03 Woodruff Frank C. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
29423 29423 1993-09-08 1979-08-09 Johnson Stephen B. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
29761 29761 1994-09-14 1979-08-09 Swisher Donald P. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
30969 30969 1985-09-30 1982-02-22 Offutt James R. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
31682 31682 2019-09-30 2018-09-28 Simon William D. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
34412 34412 1998-10-31 1982-02-22 Butchman Alan A. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
34760 34760 2021-10-31 2018-03-30 Ames Sarah Carlin Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
41257 41257 2002-12-31 1980-01-17 Sherbrooke Alan P. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
42025 42025 2016-12-31 1989-03-09 Bailey Harold G. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101
42197 42197 2018-12-31 2018-09-28 Feldman Mark B. Foster Garvey PC 3047 1979-08-09 Foster Garvey PC 1111 Third Avenue Suite 3000 Seattle WA 98101

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 545.888ms · 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