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

30 rows where City = "Chicago" and Registration_Number = 2572

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_First_Name, Short_Form_Termination_Date (date)

State 1

  • IL 30

Registration_Number 1

  • Aaron D. Cushman & Associates, Inc. · 30 ✖

Registrant_Name 1

  • Aaron D. Cushman & Associates, Inc. 30

City 1

  • Chicago · 30 ✖
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
3980 3980 1997-01-17 1994-11-17 Reed Kelly Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
5182 5182 1997-01-31 1996-07-22 Kozikowski Mitchell Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
6482 6482 1995-02-09 1994-11-17 Frankel Robyn H. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
9524 9524 1993-03-09 1987-12-01 Stat Joanie Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
9977 9977 1996-03-15 1994-08-09 Knipstein Steven C. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
10969 10969 1997-03-28 1995-12-26 Wentz Tiffany A. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
11586 11586 1988-03-31 1986-06-23 Cushman Gary Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
11765 11765 1997-03-31 1975-04-07 Cushman Aaron D. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
12902 12902 1997-04-07 1990-06-13 Patric Cheryl M. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
12904 12904 1997-04-07 1991-11-12 Amberg Thomas L. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
12905 12905 1997-04-07 1995-12-26 Robertson Kylie A. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
12906 12906 1997-04-07 1995-12-26 Stifter Paula R. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
16698 16698 1993-05-19 1986-10-08 Potts Craig Thomas Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
19117 19117 1995-06-09 1994-11-17 Brossard Nora Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
26454 26454 1995-08-11 1994-08-09 Cox Cheryl M. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
26541 26541 1996-08-13 1995-12-26 Bernstein Jennifer P. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
27219 27219 1996-08-22 1995-07-24 Gordon Pamela B. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
28267 28267 1995-08-31 1995-07-24 Johns Jan A. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
29224 29224 1995-09-05 1994-08-09 Kahn William A. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
34326 34326 1991-10-31 1990-06-13 Frankfother Kent P. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
35173 35173 1995-11-03 1994-08-09 Wos Karen L. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
36000 36000 1995-11-17 1994-08-09 Trokan Miriam Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
36269 36269 1994-11-23 1993-03-08 McClure James J. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
36270 36270 1994-11-23 1993-03-08 Papich Melanie A. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
36486 36486 1996-11-27 1996-07-22 Dale Kristine A. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
37723 37723 1981-12-04 1975-04-07 Gorman Thomas D. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
40069 40069 1978-12-31 1975-04-07 Peters Aileen Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
40170 40170 1980-12-31 1978-11-13 Patric Cheryl M. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
40288 40288 1984-12-31 1982-05-17 Cline Dennis L. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601
40302 40302 1984-12-31 1978-11-13 Hoffman Philip D. Aaron D. Cushman & Associates, Inc. 2572 1975-04-07 Aaron D. Cushman & Associates, Inc. 35 East Wacker Drive Suite 850 Chicago IL 60601

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