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

33 rows where Registration_Number = 2649

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date (date), Registration_Date (date)

State 1

  • DC 33

Registration_Number 1

  • Surrey & Morse · 33 ✖

Registrant_Name 1

  • Surrey & Morse 33

City 1

  • Washington 33
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
2590 2590 1980-01-01 1979-09-24 Westbrook Jay L. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
2591 2591 1981-01-01 1979-03-28 Demuth Richard H. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
2622 2622 1984-01-01 1979-03-29 Blair William McCormick , Jr. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
4202 4202 1980-01-21 1979-03-28 Stehlin Marc Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6509 6509 1986-02-10 1980-01-18 Wallace Robert B. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6511 6511 1986-02-10 1981-03-06 Ryan Stephen G. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6512 6512 1986-02-10 1981-03-06 Weisbord P. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6513 6513 1986-02-10 1979-03-27 Surrey Walter Sterling Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6514 6514 1986-02-10 1979-03-28 Morse David A. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6515 6515 1986-02-10 1979-03-28 Popkin Richard A. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6516 6516 1986-02-10 1984-04-18 Keenan Florence R. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6517 6517 1986-02-10 1981-05-14 Ginsberg Marc C. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6519 6519 1986-02-10 1982-06-07 Crawford John F. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6520 6520 1986-02-10 1983-07-13 Harman Jane Frank Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6521 6521 1986-02-10 1980-08-08 Moery Phillip W. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6522 6522 1986-02-10 1980-08-08 Neill Denis M. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6523 6523 1986-02-10 1980-08-08 Soble Stephen M. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6524 6524 1986-02-10 1980-08-19 Helm Lewis Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6525 6525 1986-02-10 1980-09-12 Saba Joseph P. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6526 6526 1986-02-10 1980-09-12 Silverman Michael R. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6527 6527 1986-02-10 1979-09-24 Fishburne Benjamin P. , III Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6528 6528 1986-02-10 1984-10-10 Almstedt Kermit W. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6529 6529 1986-02-10 1981-11-17 Crawford Charles Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6530 6530 1986-02-10 1981-11-17 Gray Robert Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6531 6531 1986-02-10 1981-11-17 Hymel Gary Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
6532 6532 1986-02-10 1977-12-06 Cass Barry Michael Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
11483 11483 1979-03-31 1976-01-05 Guttentag Joseph Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
11496 11496 1981-03-31 1976-01-05 Nauheim Stephen Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
14542 14542 1984-04-30 1984-04-18 Steele Michael S. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
17664 17664 1981-05-31 1980-08-08 Espinosa William H. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
22629 22629 1984-07-06 1980-12-10 Church Dale W. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
40129 40129 1980-12-31 1979-03-28 Anderson Stanton D. Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   Washington DC 20005
40318 40318 1985-12-31 1985-04-26 Davis Christopher Surrey & Morse 2649 1976-01-05 Surrey & Morse 1250 I Street, N.W.   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 668.308ms · 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