FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Address_2 = "" and City = "Minneapolis" sorted by Registration_Date
This data as json, CSV (advanced)
Suggested facets: Zip, Registration_Date (date), Termination_Date (date)
Registration_Number | Registration_Date ▼ | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
303 | 1945-04-30 | 1946-10-30 | Film Preview | 1504 Hennepin Avenue | Minneapolis | MN | |||
1119 | 1958-03-03 | 1959-09-03 | Schilling Travel Service, Inc. | 722 Second Avenue, South | Minneapolis | MN | |||
2600 | 1975-08-07 | 1975-09-22 | Don Braman & Associates, Inc. | 650 Baker Building | Minneapolis | MN | 55402 | ||
2963 | 1978-10-03 | 1986-10-10 | Sprenger, Olson & Shutes, P.A. | 325 Ridgewood Avenue | Minneapolis | MN | 55403 | ||
3960 | 1987-04-15 | 1989-06-14 | Colle & McVoy Public Relations | 7900 International Drive | Minneapolis | MN | 55425 | ||
4235 | 1989-04-07 | 1992-10-27 | Noble International, Inc. | 3848 - 35th Avenue, South | Minneapolis | MN | 55406 | ||
6614 | 2018-12-16 | National Salvation Front (NAS) Mission USA | 9109 Poplar Bridge Rd | Minneapolis | MN | 55437 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [FARA_All_Registrants] ( [Registration_Number] INTEGER PRIMARY KEY, [Registration_Date] TEXT, [Termination_Date] TEXT, [Name] TEXT, [Business_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );