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

26 rows where Registration_Number = 3208

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Date (date)

State 1

  • DC 26

Registration_Number 1

  • Anderson, Hibey & Blair · 26 ✖

Registrant_Name 1

  • Anderson, Hibey & Blair 26

City 1

  • Washington 26
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
2677 2677 1989-01-01 1983-06-20 Juliano Robert E. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
4999 4999 1985-01-31 1984-04-03 Teele Arthur E. , Jr. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
8740 8740 1982-03-01 1981-04-23 Washington Valoris J. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16601 16601 1995-05-17 1988-01-28 Freed Bruce F. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16602 16602 1995-05-17 1986-01-31 LeMaster Roger Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16603 16603 1995-05-17 1981-03-09 Anderson Stanton D. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16604 16604 1995-05-17 1981-03-09 Blair Robert A. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16605 16605 1995-05-17 1985-03-17 Kitchin Louis L. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16607 16607 1995-05-17 1990-05-23 Blair Robert A. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16608 16608 1995-05-17 1990-05-23 Coffee Gordon A. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16609 16609 1995-05-17 1990-05-23 Hibey Richard A. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16610 16610 1995-05-17 1990-05-23 Waldman Byron Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16612 16612 1995-05-17 1988-06-21 Blend Stanley L. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16613 16613 1995-05-17 1988-06-21 Hudson Robert F. , Jr. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16614 16614 1995-05-17 1981-08-13 Artiano Martin L. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16615 16615 1995-05-17 1987-09-27 Steindler Thomas P. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16616 16616 1995-05-17 1990-10-09 Piorkowski Anne Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
16617 16617 1995-05-17 1982-11-02 Nauheim Stephen A. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
17083 17083 1988-05-25 1987-09-10 Fontheim Claude G.B. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
19535 19535 1984-06-15 1982-02-13 Carson Virginia S. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
23719 23719 1987-07-21 1983-10-18 Garfinkel Eric I. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
24089 24089 1991-07-26 1989-10-24 Paulson Kristin E. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
28094 28094 1986-08-31 1986-01-31 McMahon Patrick J. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
28122 28122 1988-08-31 1988-03-21 Scheiner Alan H. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
31875 31875 1983-10-01 1981-03-09 Davis Robert P. Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009
34258 34258 1985-10-31 1984-10-09 Bradstock Madeline Anderson, Hibey & Blair 3208 1981-03-09 Anderson, Hibey & Blair 1708 New Hampshire Ave., N.W.   Washington DC 20009

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