FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Short_Form_Termination_Date" is on date 1985-05-31
This data as json, CSV (advanced)
Suggested facets: Zip
Registration_Number 9
Registrant_Name 9
City 6
- New York 4
- Cambridge 1
- Maitland 1
- Petaluma 1
- Silver Spring 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17684 | 17684 | 1985-05-31 | 1984-01-06 | Fitzgerald | Albert W. , Jr. | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
17685 | 17685 | 1985-05-31 | 1978-01-23 | Auguste | Henri C. | Haiti Government Tourist Bureau 1901 | 1965-06-16 | Haiti Government Tourist Bureau | C/O Consulate General of Haiti | 271 Madison Avenue 17th Floor | New York | NY | 10017 |
17686 | 17686 | 1985-05-31 | 1978-04-28 | Bronstorph | Franklin H. | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
17687 | 17687 | 1985-05-31 | 1981-05-07 | Marsden | James L. | New Zealand Milk Products, Inc. 2463 | 1973-10-01 | New Zealand Milk Products, Inc. | 1269 North McDowell Boulevard | Petaluma | CA | 94952 | |
17688 | 17688 | 1985-05-31 | 1982-07-19 | Bronheim | David | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 | |
17689 | 17689 | 1985-05-31 | 1981-08-24 | Peters | Richard A. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
17690 | 17690 | 1985-05-31 | 1984-11-14 | Bario | Patricia Y. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
17691 | 17691 | 1985-05-31 | 1984-12-03 | Evans | Judith | Public Affairs Analysts, Inc. 3558 | 1984-02-07 | Public Affairs Analysts, Inc. | 342 Madison Avenue | Suite 1512 | New York | NY | 10173 |
17692 | 17692 | 1985-05-31 | 1984-12-21 | Olthof | Guenther | German-American Chamber of Commerce, Inc., New York 1812 | 1964-11-04 | German-American Chamber of Commerce, Inc., New York | 40 West 57th Street | New York | NY | 10019-4092 |
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]) );