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

35 rows where Registration_Number = 1178

✖
✖

✎ 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

  • DC 35

Registration_Number 1

  • Surrey, Karasik, Gould and Efron · 35 ✖

Registrant_Name 1

  • Surrey, Karasik, Gould and Efron 35

City 1

  • Washington 35
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
8668 8668 1972-03-01 1966-02-03 Braman Leonard Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8669 8669 1972-03-01 1966-02-03 Dynner Alan Roy Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8670 8670 1972-03-01 1965-02-08 Crawford John Fort Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8675 8675 1972-03-01 1971-02-17 Anderson Stanton D. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8676 8676 1972-03-01 1969-03-06 Phillips Richard M. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8677 8677 1972-03-01 1964-03-16 Schimpff Marguerite Parsons Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8678 8678 1972-03-01 1962-05-10 Guttentag Joseph H. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8680 8680 1972-03-01 1967-06-06 Berkeley Alan J. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8681 8681 1972-03-01 1967-06-06 Brigati Joseph J. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8682 8682 1972-03-01 1967-06-06 Kane Michael Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8683 8683 1972-03-01 1967-06-06 Oppenheimer Monroe Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8684 8684 1972-03-01 1967-06-06 Randall Robert L. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8685 8685 1972-03-01 1967-06-06 Rubin Seymour J. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8686 8686 1972-03-01 1967-06-06 Vander Clute Norman R. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8687 8687 1972-03-01 1967-06-06 Wilson Michael Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8688 8688 1972-03-01 1968-08-16 Elliott Robert R. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8689 8689 1972-03-01 1966-08-22 Sherrod, Jr., Henry Floyd Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8690 8690 1972-03-01 1966-09-21 Wickersham Warren George Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8692 8692 1972-03-01 1967-09-29 Prosterman Albert M. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8694 8694 1972-03-01 1958-10-09 Barnard Jane W. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8695 8695 1972-03-01 1958-10-09 Cooper Martha Janet Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8696 8696 1972-03-01 1958-10-09 Goldberg Sybil Rom Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8697 8697 1972-03-01 1958-10-09 Gould Michael Mitchell Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8698 8698 1972-03-01 1958-10-09 Karasik Monroe Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8699 8699 1972-03-01 1958-10-09 Messiry Frances Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8700 8700 1972-03-01 1958-10-09 Saalfeld Martha Janet Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8701 8701 1972-03-01 1958-10-09 Surrey Walter Sterling Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8702 8702 1972-03-01 1958-10-09 Weiss Anne Elizabeth Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8703 8703 1972-03-01 1958-10-16 Efron Samuel Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8704 8704 1972-03-01 1958-10-16 Greene Francis Thornton Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8705 8705 1972-03-01 1959-10-22 Hill Dumond Peck Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8706 8706 1972-03-01 1966-10-31 Ruby Stanley Lee Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8707 8707 1972-03-01 1960-11-09 Goekjian Samuel V. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8708 8708 1972-03-01 1964-11-10 Nussbaum Michael Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005
8709 8709 1972-03-01 1961-11-13 Christopher George L. Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron Woodward Building   Washington DC 20005

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