FARA_All_Registrants

List of all registrant data (active and terminated)

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

29 rows where State = "MN"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

State

Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
276 1944-08-18 1945-01-01 Stasser, Rev. Paul, O.S.B.   St. Johns Abbey   Collegeville MN 00000
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  
1343 1960-03-23 1966-02-03 Campbell-Mithun, Inc.   1300 Northwestern Bank Building Mineapolis MN  
2517 1974-06-06 1974-12-19 Martin, Ryan, Haley & Associates, Inc.   442 Summit Avenue   St. Paul MN 55102
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
3008 1979-03-27 1979-11-19 Martin, Ryan, Haley & Associates, Inc.   111 East Kellogg Boulevard   St. Paul MN 55101
3267 1981-08-06 1987-08-27 Minnesota Public Radio   45 East 8th Street   St. Paul MN 55101
3282 1981-10-06 1991-03-26 Hansen, Paul W.   5701 Normandale Road Suite 210 Minneapolis MN 55424
3902 1986-10-30 1987-12-01 Caine, Terry   Post Office Box 484   Stillwater MN 55082
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
5315 1999-05-11 2001-05-31 Shandwick USA, Inc.   8000 Norman Center Drive Suite 400 Bloomington MN 55437
5449 2001-08-03 2002-02-14 Anderson, Janet C.   1514 Laurel Avenue   St. Paul MN 55104
5473 2002-02-19 2005-02-28 Rudnicki, Timothy J.   4224 Lynn Avenue   Edina MN 55416-5023
5498 2002-05-17 2002-05-17 Vangh, Nkajlo V.   302 University Avenue West Suite 104 St. Paul MN 55103
5655 2004-11-04 2005-05-31 Ambazonia Liberation Party (ALIP)   18th North, 4th Street Suite 704 Minneapolis MN 55401
6405 2016-09-15   For Your Institute for Human Development   3058 25th Street, NW   Rochester MN 55901
6444 2017-07-11 2017-10-11 Xiong, Seng   7932 Ewing Avenue   Brooklyn Park MN 55443
6614 2018-12-16   National Salvation Front (NAS) Mission USA   9109 Poplar Bridge Rd   Minneapolis MN 55437
6619 2019-01-20   Silverbridge, Khendhrah   5511 Vermont Street   St. Louis Park MN 44516
6757 2019-11-27   Hashi Warsame Abdi-Nur   1920 Portland Avenue Apartment 103 Minneapolis MN 55404-5509

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)
);
Powered by Datasette · Query took 54.823ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history