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

27 rows where Registration_Number = 1001

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Date (date)

State 1

  • DC 27

Registration_Number 1

  • Arter, Hadden & Hemmendinger · 27 ✖

Registrant_Name 1

  • Arter, Hadden & Hemmendinger 27

City 1

  • Washington 27
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
2543 2543 1968-01-01 1960-07-21 Daniels Michael P. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
5954 5954 1971-02-02 1970-01-29 Farrell Edward J. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
7877 7877 1976-02-28 1957-02-21 Stitt Nelson A. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
9687 9687 1973-03-12 1965-02-04 Houlihan David P. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
11416 11416 1970-03-31 1969-10-27 Runkle Scott F. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
20948 20948 1980-06-30 1973-02-07 Berg R. Christian Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
20992 20992 1983-06-30 1979-02-01 Cohen Barry E. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
20993 20993 1983-06-30 1979-02-01 Guzik-Farber Ilene Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
20994 20994 1983-06-30 1977-02-02 Barringer William H. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
20995 20995 1983-06-30 1983-02-03 Clinton William John Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
20996 20996 1983-06-30 1983-02-03 Moye Melissa G. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
20997 20997 1983-06-30 1981-02-04 Aldrich Claire Elizabeth Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
20999 20999 1983-06-30 1957-02-21 Hemmendinger Noel Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
21004 21004 1983-06-30 1982-04-13 Ehrgood Thomas A. , Jr. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
21005 21005 1983-06-30 1979-05-01 Dunn Christopher A. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
21007 21007 1983-06-30 1967-06-01 Gass Oscar Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
21008 21008 1983-06-30 1971-07-29 Dazey William B. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
21009 21009 1983-06-30 1978-07-31 Spak Walter J. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
21010 21010 1983-06-30 1981-07-31 Daniel Royal , III Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
21011 21011 1983-06-30 1976-08-02 Hunter William D. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
21014 21014 1983-06-30 1981-10-26 Lafave Arthur J. , III Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
23604 23604 1974-07-19 1973-02-07 Lieblich William C. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
24174 24174 1982-07-27 1979-06-29 Hochberg Jerome A. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
30426 30426 1982-09-25 1961-02-01 Kennedy John A. , Jr. Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
34207 34207 1979-10-31 1978-07-31 Oliphant Alexandra Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
38347 38347 1959-12-15 1959-07-13 Latimer Hugh Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
40149 40149 1980-12-31 1976-06-17 Silverman William Arter, Hadden & Hemmendinger 1001 1957-02-21 Arter, Hadden & Hemmendinger 1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006

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.603ms · 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