FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

66 rows where State = "MN"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 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
145 145   2015-01-19 Vang Tou-Fu United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 35   Pine City MN 55063
146 146   2015-01-19 Vang Victor United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 35   Pine City MN 55063
1686 1686   2012-09-05 Vang Chong United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 35   Pine City MN 55063
2028 2028   2014-10-29 Nokham Chao Khamlouang United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 35   Pine City MN 55063
2092 2092   2012-11-07 Oun Lo-Cam United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 35   Pine City MN 55063
2394 2394   2018-12-16 Agolory Joseph Peter National Salvation Front (NAS) Mission USA 6614 2018-12-16 National Salvation Front (NAS) Mission USA 9109 Poplar Bridge Rd   Minneapolis MN 55437
2395 2395   2018-12-16 Gubek Ladu Jada National Salvation Front (NAS) Mission USA 6614 2018-12-16 National Salvation Front (NAS) Mission USA 9109 Poplar Bridge Rd   Minneapolis MN 55437
2396 2396   2018-12-16 Mahadi Vera Katafanga National Salvation Front (NAS) Mission USA 6614 2018-12-16 National Salvation Front (NAS) Mission USA 9109 Poplar Bridge Rd   Minneapolis MN 55437
2397 2397   2018-12-16 Tunda Oliver National Salvation Front (NAS) Mission USA 6614 2018-12-16 National Salvation Front (NAS) Mission USA 9109 Poplar Bridge Rd   Minneapolis MN 55437
6009 6009 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  
6010 6010 1966-02-03 1960-03-23 Angrist Walter James Campbell-Mithun, Inc. 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
6011 6011 1966-02-03 1960-03-23 Best Norman F. Campbell-Mithun, Inc. 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
6012 6012 1966-02-03 1960-03-23 Campbell Ralph Blane , Jr. Campbell-Mithun, Inc. 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
6013 6013 1966-02-03 1960-03-23 Case Winslow H. Campbell-Mithun, Inc. 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
6015 6015 1966-02-03 1960-06-06 Mithun Raymond Otis Campbell-Mithun, Inc. 1343 1960-03-23 Campbell-Mithun, Inc. 1300 Northwestern Bank Building Mineapolis MN  
6802 6802 1995-02-14 1993-02-25 Martin Ian A. Grand Metropolitan Consumer Services & Products, Inc. 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
6803 6803 1995-02-14 1992-05-06 Krause Raymond R. Grand Metropolitan Consumer Services & Products, Inc. 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
6807 6807 1995-02-14 1992-12-08 Chandler J. Howard Grand Metropolitan Consumer Services & Products, Inc. 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
9086 9086 1988-03-04 1987-04-15 Bowman Tracie Colle & McVoy Public Relations 3960 1987-04-15 Colle & McVoy Public Relations 7900 International Drive   Minneapolis MN 55425
10583 10583 2001-03-23 2001-02-14 Blair Wanda Shandwick USA, Inc. 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
13216 13216 2020-04-12 2019-11-27 Farah Yasin Abdi Hashi Warsame Abdi-Nur 6757 2019-11-27 Hashi Warsame Abdi-Nur 1920 Portland Avenue Apartment 103 Minneapolis MN 55404-5509
13232 13232 1983-04-13 1981-08-06 Marx Rhoda Minnesota Public Radio 3267 1981-08-06 Minnesota Public Radio 45 East 8th Street   St. Paul MN 55101
13233 13233 1983-04-13 1981-08-06 Nash Nicholas Minnesota Public Radio 3267 1981-08-06 Minnesota Public Radio 45 East 8th Street   St. Paul MN 55101
15662 15662 2001-05-04 2001-02-14 Bibelheimer Kia Shandwick USA, Inc. 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
16566 16566 2002-05-17 2002-05-17 Vangh Nkajlo V. Vangh, Nkajlo V. 5498 2002-05-17 Vangh, Nkajlo V. 302 University Avenue West Suite 104 St. Paul MN 55103
16649 16649 2000-05-19 1999-05-11 Forsberg Krista Shandwick USA, Inc. 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
16699 16699 1991-05-20 1991-02-06 Smith Duncan C. , III O'Connor & Hannan 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
17707 17707 1993-05-31 1992-05-19 Bakewell Kim Wells Group 4666 1992-05-19 Wells Group 430 First Avenue, N. Suite 550 Minneapolis MN 55401-1735
17708 17708 1993-05-31 1992-05-19 Iwamoto Bryan Wells Group 4666 1992-05-19 Wells Group 430 First Avenue, N. Suite 550 Minneapolis MN 55401-1735
17889 17889 2001-05-31 1999-05-11 Kennedy Cathryn I. Shandwick USA, Inc. 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
17890 17890 2001-05-31 1999-05-11 Kurschner Tracy Shandwick USA, Inc. 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
17891 17891 2001-05-31 1999-05-11 Mona David Shandwick USA, Inc. 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
17932 17932 2005-05-31 2004-11-04 Ngang Edith M. Ambazonia Liberation Party (ALIP) 5655 2004-11-04 Ambazonia Liberation Party (ALIP) 18th North, 4th Street Suite 704 Minneapolis MN 55401
17933 17933 2005-05-31 2004-11-04 Ngang Edwin N. Ambazonia Liberation Party (ALIP) 5655 2004-11-04 Ambazonia Liberation Party (ALIP) 18th North, 4th Street Suite 704 Minneapolis MN 55401
19357 19357 1989-06-14 1987-04-15 Holte Laura Colle & McVoy Public Relations 3960 1987-04-15 Colle & McVoy Public Relations 7900 International Drive   Minneapolis MN 55425
19358 19358 1989-06-14 1987-04-15 Nehring Susan Busch Colle & McVoy Public Relations 3960 1987-04-15 Colle & McVoy Public Relations 7900 International Drive   Minneapolis MN 55425
19359 19359 1989-06-14 1987-04-15 Spong Douglas K. Colle & McVoy Public Relations 3960 1987-04-15 Colle & McVoy Public Relations 7900 International Drive   Minneapolis MN 55425
21276 21276 2000-06-30 2001-02-14 Kondes Leah Shandwick USA, Inc. 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
27429 27429 1987-08-27 1981-08-06 Kling William H. Minnesota Public Radio 3267 1981-08-06 Minnesota Public Radio 45 East 8th Street   St. Paul MN 55101
27430 27430 1987-08-27 1981-08-06 Lewis Rich Minnesota Public Radio 3267 1981-08-06 Minnesota Public Radio 45 East 8th Street   St. Paul MN 55101
28989 28989 1959-09-03 1958-03-03 Schilling W.H. , Jr. Schilling Travel Service, Inc. 1119 1958-03-03 Schilling Travel Service, Inc. 722 Second Avenue, South   Minneapolis MN  
29830 29830 2016-09-15 2016-09-15 Azeez Khalid Obaid For Your Institute for Human Development 6405 2016-09-15 For Your Institute for Human Development 3058 25th Street, NW   Rochester MN 55901
30168 30168 1975-09-22 1975-08-07 Oxley Owen Don Braman & Associates, Inc. 2600 1975-08-07 Don Braman & Associates, Inc. 650 Baker Building   Minneapolis MN 55402
32482 32482 1986-10-10 1978-10-03 Olson Eric L. Sprenger, Olson & Shutes, P.A. 2963 1978-10-03 Sprenger, Olson & Shutes, P.A. 325 Ridgewood Avenue   Minneapolis MN 55403
32483 32483 1986-10-10 1978-10-03 Shutes Robert L. Sprenger, Olson & Shutes, P.A. 2963 1978-10-03 Sprenger, Olson & Shutes, P.A. 325 Ridgewood Avenue   Minneapolis MN 55403
32484 32484 1986-10-10 1978-10-03 Sprenger Paul C. Sprenger, Olson & Shutes, P.A. 2963 1978-10-03 Sprenger, Olson & Shutes, P.A. 325 Ridgewood Avenue   Minneapolis MN 55403
32553 32553 2017-10-11 2017-05-31 Xiong Seng Xiong, Seng 6444 2017-07-11 Xiong, Seng 7932 Ewing Avenue   Brooklyn Park MN 55443
33615 33615 1992-10-27 1989-04-07 Noble John L. Noble International, Inc. 4235 1989-04-07 Noble International, Inc. 3848 - 35th Avenue, South   Minneapolis MN 55406
33912 33912 1946-10-30 1945-04-30 South Lucille A. Film Preview 303 1945-04-30 Film Preview 1504 Hennepin Avenue   Minneapolis MN  
36687 36687 1995-11-30 1995-01-17 Baldwin Diane L. Grand Metropolitan Consumer Services & Products, Inc. 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
36694 36694 1995-11-30 1995-05-31 Krause Raymond R. Grand Metropolitan Consumer Services & Products, Inc. 4661 1992-05-06 Grand Metropolitan Consumer Services & Products, Inc. Pillsbury Centre, M.S. 39K5 200 South Sixth Street Minneapolis MN 55402
37786 37786 1992-12-07 1990-04-02 Carnival Douglas M. McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
37787 37787 1992-12-07 1990-04-02 Franzen Douglas J. McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
37788 37788 1992-12-07 1990-04-02 Lamb Kathleen M. McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
37789 37789 1992-12-07 1990-04-02 McGrann William R. McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 1700 Lincoln Centre 333 South 7th Street Minneapolis MN 55402
37903 37903 2020-12-09 2020-10-09 Forsythe Thomas Mitchell CCO Communications LLC 6874 2020-10-09 CCO Communications LLC 200 Park Avenue Suite 405 Minneapolis MN 55415
37904 37904 2020-12-09 2020-10-09 Forsythe Thomas CCO Communications LLC 6874 2020-10-09 CCO Communications LLC 200 Park Avenue Suite 405 Minneapolis MN 55415
38202 38202 1989-12-14 1988-05-12 Carnival Douglas M. O'Connor & Hannan 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
38203 38203 1989-12-14 1988-05-12 Franzen Douglas J. O'Connor & Hannan 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
38204 38204 1989-12-14 1989-06-02 Lamb Kathleen M. O'Connor & Hannan 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
38206 38206 1989-12-14 1988-12-05 McGrann William R. O'Connor & Hannan 4142 1988-05-12 O'Connor & Hannan 3800 IDS Tower 80 South 8th Street Minneapolis MN 55402
38472 38472 1999-12-17 1999-05-11 VanDeusen Tess Shandwick USA, Inc. 5315 1999-05-11 Shandwick USA, Inc. 8000 Norman Center Drive Suite 400 Bloomington MN 55437
38633 38633 1974-12-19 1974-06-06 Haley Martin R. Martin, Ryan, Haley & Associates, Inc. 2517 1974-06-06 Martin, Ryan, Haley & Associates, Inc. 442 Summit Avenue   St. Paul MN 55102
38634 38634 1974-12-19 1974-06-28 Richmond Thomas L. Martin, Ryan, Haley & Associates, Inc. 2517 1974-06-06 Martin, Ryan, Haley & Associates, Inc. 442 Summit Avenue   St. Paul MN 55102
38635 38635 1974-12-19 1974-07-18 Revey Patricia A. Martin, Ryan, Haley & Associates, Inc. 2517 1974-06-06 Martin, Ryan, Haley & Associates, Inc. 442 Summit Avenue   St. Paul MN 55102
40473 40473 1989-12-31 1988-05-12 Schumacher Norma O'Connor & Hannan 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])
);