FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Roth"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 11
- Swedish-American Chamber of Commerce, Inc. 1
- Charles W. Hoyt Company, Inc. 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Grant Advertising, Inc. 1
- Campbell-Mithun, Inc. 1
- Doremus & Company 1
- Walters, Costanzo, Miller & Russell 1
- Roth, L. James 1
- M+R Strategic Services 1
- Wiggin and Dana LLP 1
Registrant_Name 11
- Campbell-Mithun, Inc. 1
- Charles W. Hoyt Company, Inc. 1
- Doremus & Company 1
- Grant Advertising, Inc. 1
- M+R Strategic Services 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Roth, L. James 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Swedish-American Chamber of Commerce, Inc. 1
- Walters, Costanzo, Miller & Russell 1
- Wiggin and Dana LLP 1
City 6
- New York 4
- Washington 3
- Chicago 1
- Miami 1
- Mineapolis 1
- New Haven 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1060 | 1060 | 2021-05-19 | Roth | David | Wiggin and Dana LLP 6878 | 2020-10-14 | Wiggin and Dana LLP | 265 Church Street | One Century Tower | New Haven | CT | 06510 | |
6027 | 6027 | 1966-02-03 | 1961-01-09 | Roth | Russell F. | Campbell-Mithun, Inc. 1343 | 1960-03-23 | Campbell-Mithun, Inc. | 1300 Northwestern Bank | Building | Mineapolis | MN | |
10509 | 10509 | 1985-03-22 | 1975-04-11 | Roth | Stephen A. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
15903 | 15903 | 1974-05-08 | 1953-06-08 | Roth | Gerda Johanna Elizabeth Berman | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
17938 | 17938 | 2000-05-31 | 1998-11-16 | Roth | L. James | Roth, L. James 5288 | 1998-11-16 | Roth, L. James | 2121 K Street N.W. | Suite 650 | Washington | DC | 20037 |
22883 | 22883 | 1966-07-10 | 1958-12-03 | Roth | Frederick J. | Grant Advertising, Inc. 1184 | 1958-12-03 | Grant Advertising, Inc. | 10 South Riverside Plaza | Chicago | IL | 60606 | |
26613 | 26613 | 1987-08-14 | 1987-07-06 | Roth | Elisabeth Tobie | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
27564 | 27564 | 1964-08-28 | 1960-08-17 | Roth | Hyman L. | Charles W. Hoyt Company, Inc. 361 | 1946-06-10 | Charles W. Hoyt Company, Inc. | 380 Madison Avenue | New York | NY | 10017 | |
27648 | 27648 | 1972-08-29 | 1955-07-26 | Roth | Carl Anders Reinhold | Swedish-American Chamber of Commerce, Inc. 13 | 1942-07-06 | Swedish-American Chamber of Commerce, Inc. | 250 Park Avenue | New York | NY | 10017 | |
32664 | 32664 | 1983-10-12 | 1982-03-05 | Roth | James G. | Walters, Costanzo, Miller & Russell 3343 | 1982-03-05 | Walters, Costanzo, Miller & Russell | 330 North Biscayne Boulevard | Suite 500 | Miami | FL | 33132 |
41576 | 41576 | 2007-12-31 | 2007-09-19 | Roth | Susan | M+R Strategic Services 5829 | 2007-09-19 | M+R Strategic Services | 2120 L Street, NW | Suite 600 | Washington | DC | 20037 |
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]) );