FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

25 rows where City = "Cambridge" and Registration_Number = 3804

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Arthur D. Little, Inc. · 25 ✖

Registrant_Name 1

City 1

  • Cambridge · 25 ✖
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
10585 10585 1987-03-23 1987-03-23 Carlson Kathleen E. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10586 10586 1987-03-23 1987-03-23 Colas Pamela Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10587 10587 1987-03-23 1987-03-23 Collins Sarah Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10588 10588 1987-03-23 1987-03-23 Concannon Lawrence J. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10589 10589 1987-03-23 1987-03-23 Edgerly James B. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10590 10590 1987-03-23 1987-03-23 Farrar Julie A. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10591 10591 1987-03-23 1987-03-23 Fothergill William R. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10592 10592 1987-03-23 1987-03-23 Gols A. George Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10593 10593 1987-03-23 1987-03-23 Goulet Roger Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10594 10594 1987-03-23 1987-03-23 Howland John S. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10595 10595 1987-03-23 1987-03-23 Lee Robert E. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10596 10596 1987-03-23 1987-03-23 McCarthy Kathleen M. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10597 10597 1987-03-23 1987-03-23 Menegakis Demosthenes Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10598 10598 1987-03-23 1987-03-23 Michael Gerald J. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10599 10599 1987-03-23 1987-03-23 Morrill Carolyn S. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10600 10600 1987-03-23 1987-03-23 Ong Joo Hooi Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10601 10601 1987-03-23 1987-03-23 Pastan Harvey L. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10602 10602 1987-03-23 1987-03-23 Perkins Rufus M. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10603 10603 1987-03-23 1987-03-23 Reinfeld William Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10604 10604 1987-03-23 1987-03-23 Sagarino Robert F. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10605 10605 1987-03-23 1987-03-23 Smith Perry C. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10606 10606 1987-03-23 1987-03-23 Soderberg Karen Elsa Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10607 10607 1987-03-23 1987-03-23 Uek Kathleen C. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10608 10608 1987-03-23 1987-03-23 Wasserman Jerry Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10609 10609 1987-03-23 1987-04-16 Callahan Richard E. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390

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])
);