FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

17 rows where City = "Minneapolis"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_2, Zip, Registration_Date (date), Termination_Date (date)

State 1

City 1

  • Minneapolis · 17 ✖
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
2893 1978-05-03 1979-08-28 Sprenger, Paul C.   701 First National Bank Building Minneapolis MN 55402
2963 1978-10-03 1986-10-10 Sprenger, Olson & Shutes, P.A.   325 Ridgewood Avenue   Minneapolis MN 55403
3282 1981-10-06 1991-03-26 Hansen, Paul W.   5701 Normandale Road Suite 210 Minneapolis MN 55424
3960 1987-04-15 1989-06-14 Colle & McVoy Public Relations   7900 International Drive   Minneapolis MN 55425
4142 1988-05-12 1991-05-20 O'Connor & Hannan   3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
4235 1989-04-07 1992-10-27 Noble International, Inc.   3848 - 35th Avenue, South   Minneapolis MN 55406
4357 1990-04-02 1992-12-07 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered   1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
4661 1992-05-06 1997-05-31 Grand Metropolitan Consumer Services & Products, Inc.   Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
4666 1992-05-19 1992-12-01 Wells Group   430 First Avenue, N. Suite 550 Minneapolis MN 55401-1735
5313 1999-06-09 2001-06-30 Stewart, Ann   121 West Grant Street Suite 121 Minneapolis MN 55403-2340
5655 2004-11-04 2005-05-31 Ambazonia Liberation Party (ALIP)   18th North, 4th Street Suite 704 Minneapolis MN 55401
6614 2018-12-16   National Salvation Front (NAS) Mission USA   9109 Poplar Bridge Rd   Minneapolis MN 55437
6757 2019-11-27 2020-04-12 Hashi Warsame Abdi-Nur   1920 Portland Avenue Apartment 103 Minneapolis MN 55404-5509
6874 2020-10-09 2021-03-31 CCO Communications LLC   200 Park Avenue Suite 405 Minneapolis MN 55415

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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])
);