FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Short_Form_Last_Name = "Fine"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 8
Registrant_Name 8
City 5
- Washington 4
- New York 2
- Arlington 1
- Cambridge 1
- Philadelphia 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2837 | 2837 | 2006-01-01 | 2005-04-14 | Fine | David | Global USA, Inc. 5292 | 1998-12-16 | Global USA, Inc. | 1990 M Street, NW | #200 | Washington | DC | 20036 |
3369 | 3369 | 1999-01-07 | 1997-10-01 | Fine | Michael E. | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | 1001 Pennsylvania Avenue, N.W. | 6th Floor, South | Washington | DC | 20004 |
9242 | 9242 | 1995-03-06 | 1981-09-02 | Fine | Hyman | Hyman Fine & Associates, Ltd. 3273 | 1981-09-02 | Hyman Fine & Associates, Ltd. | 1515 Jefferson Davis Highway | Suite 108 | Arlington | VA | 22202 |
9312 | 9312 | 1960-03-07 | 1959-04-16 | Fine | Mildred | University Travel Company 1218 | 1959-04-16 | University Travel Company | 18 Brattle Street | Cambridge | MA | ||
15675 | 15675 | 1973-05-04 | 1958-02-10 | Fine | Francis | Central News Agency of China, Washington Bureau 621 | 1950-03-29 | Central News Agency of China, Washington Bureau | 549 National Press Building | Washington | DC | 20004 | |
21039 | 21039 | 1985-06-30 | 1982-05-12 | Fine | William M. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
29526 | 29526 | 1990-09-10 | 1987-04-10 | Fine | Michael Ezra | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | 1001 Pennsylvania Avenue, N.W. | 6th Floor, South | Washington | DC | 20004 |
32132 | 32132 | 1966-10-02 | 1964-07-24 | Fine | Aaron Mones | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
38672 | 38672 | 2000-12-18 | 1993-10-18 | Fine | Natalie | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );