FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

59 rows where State = "MN"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

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
1529 1529   2016-09-15 Azeez Khalid Obaid 6405 6405 2016-09-15 For Your Institute for Human Development 3058 25th Street, NW   Rochester MN 55901
2091 2091   2019-11-27 Farah Yasin Abdi 6757 6757 2019-11-27 Hashi Warsame Abdi-Nur 1920 Portland Avenue Apartment 103 Minneapolis MN 55404-5509
2260 2260   2018-12-16 Agolory Joseph Peter 6614 6614 2018-12-16 National Salvation Front (NAS) Mission USA 9109 Poplar Bridge Rd   Minneapolis MN 55437
2261 2261   2018-12-16 Gubek Ladu Jada 6614 6614 2018-12-16 National Salvation Front (NAS) Mission USA 9109 Poplar Bridge Rd   Minneapolis MN 55437
2262 2262   2018-12-16 Mahadi Vera Katafanga 6614 6614 2018-12-16 National Salvation Front (NAS) Mission USA 9109 Poplar Bridge Rd   Minneapolis MN 55437
2263 2263   2018-12-16 Tunda Oliver 6614 6614 2018-12-16 National Salvation Front (NAS) Mission USA 9109 Poplar Bridge Rd   Minneapolis MN 55437
5657 5657 1966-02-03 1961-01-09 Roth Russell F. 1343 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
5658 5658 1966-02-03 1960-03-23 Angrist Walter James 1343 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
5659 5659 1966-02-03 1960-03-23 Best Norman F. 1343 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
5660 5660 1966-02-03 1960-03-23 Campbell Ralph Blane , Jr. 1343 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
5661 5661 1966-02-03 1960-03-23 Case Winslow H. 1343 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
5663 5663 1966-02-03 1960-06-06 Mithun Raymond Otis 1343 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
6405 6405 1995-02-14 1993-02-25 Martin Ian A. 4661 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
6406 6406 1995-02-14 1992-05-06 Krause Raymond R. 4661 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
6410 6410 1995-02-14 1992-12-08 Chandler J. Howard 4661 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
8474 8474 1988-03-04 1987-04-15 Bowman Tracie 3960 3960 1987-04-15 Colle & McVoy Public Relations 7900 International Drive   Minneapolis MN 55425
9921 9921 2001-03-23 2001-02-14 Blair Wanda 5315 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
12391 12391 1983-04-13 1981-08-06 Marx Rhoda 3267 3267 1981-08-06 Minnesota Public Radio 45 East 8th Street   St. Paul MN 55101
12392 12392 1983-04-13 1981-08-06 Nash Nicholas 3267 3267 1981-08-06 Minnesota Public Radio 45 East 8th Street   St. Paul MN 55101
14576 14576 2001-05-04 2001-02-14 Bibelheimer Kia 5315 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
15431 15431 2002-05-17 2002-05-17 Vangh Nkajlo V. 5498 5498 2002-05-17 Vangh, Nkajlo V. 302 University Avenue West Suite 104 St. Paul MN 55103
15511 15511 2000-05-19 1999-05-11 Forsberg Krista 5315 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
15555 15555 1991-05-20 1991-02-06 Smith Duncan C. , III 4142 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
16511 16511 1993-05-31 1992-05-19 Bakewell Kim 4666 4666 1992-05-19 Wells Group 430 First Avenue, N. Suite 550 Minneapolis MN 55401-1735
16512 16512 1993-05-31 1992-05-19 Iwamoto Bryan 4666 4666 1992-05-19 Wells Group 430 First Avenue, N. Suite 550 Minneapolis MN 55401-1735
16693 16693 2001-05-31 1999-05-11 Kennedy Cathryn I. 5315 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
16694 16694 2001-05-31 1999-05-11 Kurschner Tracy 5315 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
16695 16695 2001-05-31 1999-05-11 Mona David 5315 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
16736 16736 2005-05-31 2004-11-04 Ngang Edith M. 5655 5655 2004-11-04 Ambazonia Liberation Party (ALIP) 18th North, 4th Street Suite 704 Minneapolis MN 55401
16737 16737 2005-05-31 2004-11-04 Ngang Edwin N. 5655 5655 2004-11-04 Ambazonia Liberation Party (ALIP) 18th North, 4th Street Suite 704 Minneapolis MN 55401
18045 18045 1989-06-14 1987-04-15 Holte Laura 3960 3960 1987-04-15 Colle & McVoy Public Relations 7900 International Drive   Minneapolis MN 55425
18046 18046 1989-06-14 1987-04-15 Nehring Susan Busch 3960 3960 1987-04-15 Colle & McVoy Public Relations 7900 International Drive   Minneapolis MN 55425
18047 18047 1989-06-14 1987-04-15 Spong Douglas K. 3960 3960 1987-04-15 Colle & McVoy Public Relations 7900 International Drive   Minneapolis MN 55425
19921 19921 2000-06-30 2001-02-14 Kondes Leah 5315 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
25624 25624 1987-08-27 1981-08-06 Kling William H. 3267 3267 1981-08-06 Minnesota Public Radio 45 East 8th Street   St. Paul MN 55101
25625 25625 1987-08-27 1981-08-06 Lewis Rich 3267 3267 1981-08-06 Minnesota Public Radio 45 East 8th Street   St. Paul MN 55101
27123 27123 1959-09-03 1958-03-03 Schilling W.H. , Jr. 1119 1119 1958-03-03 Schilling Travel Service, Inc. 722 Second Avenue, South   Minneapolis MN  
28258 28258 1975-09-22 1975-08-07 Oxley Owen 2600 2600 1975-08-07 Don Braman & Associates, Inc. 650 Baker Building   Minneapolis MN 55402
30439 30439 1986-10-10 1978-10-03 Olson Eric L. 2963 2963 1978-10-03 Sprenger, Olson & Shutes, P.A. 325 Ridgewood Avenue   Minneapolis MN 55403
30440 30440 1986-10-10 1978-10-03 Shutes Robert L. 2963 2963 1978-10-03 Sprenger, Olson & Shutes, P.A. 325 Ridgewood Avenue   Minneapolis MN 55403
30441 30441 1986-10-10 1978-10-03 Sprenger Paul C. 2963 2963 1978-10-03 Sprenger, Olson & Shutes, P.A. 325 Ridgewood Avenue   Minneapolis MN 55403
30499 30499 2017-10-11 2017-05-31 Xiong Seng 6444 6444 2017-07-11 Xiong, Seng 7932 Ewing Avenue   Brooklyn Park MN 55443
31508 31508 1992-10-27 1989-04-07 Noble John L. 4235 4235 1989-04-07 Noble International, Inc. 3848 - 35th Avenue, South   Minneapolis MN 55406
31797 31797 1946-10-30 1945-04-30 South Lucille A. 303 303 1945-04-30 Film Preview 1504 Hennepin Avenue   Minneapolis MN  
34403 34403 1995-11-30 1995-01-17 Baldwin Diane L. 4661 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
34410 34410 1995-11-30 1995-05-31 Krause Raymond R. 4661 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
35379 35379 1992-12-07 1990-04-02 Carnival Douglas M. 4357 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
35380 35380 1992-12-07 1990-04-02 Franzen Douglas J. 4357 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
35381 35381 1992-12-07 1990-04-02 Lamb Kathleen M. 4357 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
35382 35382 1992-12-07 1990-04-02 McGrann William R. 4357 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
35784 35784 1989-12-14 1988-05-12 Carnival Douglas M. 4142 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
35785 35785 1989-12-14 1988-05-12 Franzen Douglas J. 4142 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
35786 35786 1989-12-14 1989-06-02 Lamb Kathleen M. 4142 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
35788 35788 1989-12-14 1988-12-05 McGrann William R. 4142 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
36030 36030 1999-12-17 1999-05-11 VanDeusen Tess 5315 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
36188 36188 1974-12-19 1974-06-06 Haley Martin R. 2517 2517 1974-06-06 Martin, Ryan, Haley & Associates, Inc. 442 Summit Avenue   St. Paul MN 55102
36189 36189 1974-12-19 1974-06-28 Richmond Thomas L. 2517 2517 1974-06-06 Martin, Ryan, Haley & Associates, Inc. 442 Summit Avenue   St. Paul MN 55102
36190 36190 1974-12-19 1974-07-18 Revey Patricia A. 2517 2517 1974-06-06 Martin, Ryan, Haley & Associates, Inc. 442 Summit Avenue   St. Paul MN 55102
38008 38008 1989-12-31 1988-05-12 Schumacher Norma 4142 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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