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

30 rows where "Registration_Date" is on date 1964-04-14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date)

State 1

Registration_Number 1

Registrant_Name 1

City 1

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
7860 7860 1970-02-28 1967-01-03 Fitzgerald Dennis Alfred Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
7863 7863 1970-02-28 1969-05-15 Fothergill William R. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
11407 11407 1969-03-31 1966-05-16 Monka Lawrence Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
13303 13303 1967-04-14 1964-12-15 McCormick William Joseph , Jr. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16546 16546 1971-05-17 1964-05-12 Checchi Arthur A. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16547 16547 1971-05-17 1964-05-12 Checchi Vincent Victor Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16548 16548 1971-05-17 1964-05-12 Corbett Jack C. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16549 16549 1971-05-17 1964-05-12 Fleming Robert Ingersoll Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16550 16550 1971-05-17 1964-05-12 Johnson Elizabeth V. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16551 16551 1971-05-17 1964-05-12 Larkin James Joseph Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16552 16552 1971-05-17 1964-05-12 Wilmot Anthony Talbot Burgh Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16553 16553 1971-05-17 1964-05-12 Youker Robert B. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16554 16554 1971-05-17 1967-05-16 Teele Thurston F. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16555 16555 1971-05-17 1966-05-17 Morrow Robert E. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16556 16556 1971-05-17 1965-05-25 Koehl Albert E. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16557 16557 1971-05-17 1969-06-02 Beekhuis Jeanne V. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16558 16558 1971-05-17 1969-06-02 Dillon J.V. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16559 16559 1971-05-17 1969-06-02 Grimm Peter Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16560 16560 1971-05-17 1969-06-02 Hooley Richard W. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16561 16561 1971-05-17 1969-06-02 Moore Arthur Cotton Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16562 16562 1971-05-17 1969-07-01 Waters Summit R. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16565 16565 1971-05-17 1965-12-02 Montgomery Ernest Emerson Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16566 16566 1971-05-17 1967-12-07 Counselman E. Gardner Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
16567 16567 1971-05-17 1964-12-15 Gomes Albert John Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
22055 22055 1964-07-01 1964-05-12 Checchi Mary E. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
27866 27866 1967-08-31 1964-05-12 Clement Harry G. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
29001 29001 1969-09-02 1969-05-15 Fair Gordon M. , Jr. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
30883 30883 1968-09-30 1965-08-26 Bell Daniel Wafena Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
36610 36610 1967-11-30 1967-12-07 Beggs Harry G. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
37766 37766 1966-12-05 1964-05-12 Chafkin Solomon Herman Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   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])
);