FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
37 rows where City = "Minneapolis" sorted by Short_Form_Date descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 14
- O'Connor & Hannan 6
- Grand Metropolitan Consumer Services & Products, Inc. 5
- Colle & McVoy Public Relations 4
- McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4
- National Salvation Front (NAS) Mission USA 4
- Sprenger, Olson & Shutes, P.A. 3
- Wells Group 2
- Ambazonia Liberation Party (ALIP) 2
- CCO Communications LLC 2
- Film Preview 1
- Schilling Travel Service, Inc. 1
- Don Braman & Associates, Inc. 1
- Noble International, Inc. 1
- Hashi Warsame Abdi-Nur 1
Registrant_Name 14
- O'Connor & Hannan 6
- Grand Metropolitan Consumer Services & Products, Inc. 5
- Colle & McVoy Public Relations 4
- McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4
- National Salvation Front (NAS) Mission USA 4
- Sprenger, Olson & Shutes, P.A. 3
- Ambazonia Liberation Party (ALIP) 2
- CCO Communications LLC 2
- Wells Group 2
- Don Braman & Associates, Inc. 1
- Film Preview 1
- Hashi Warsame Abdi-Nur 1
- Noble International, Inc. 1
- Schilling Travel Service, Inc. 1
State 1
- MN 37
City 1
- Minneapolis · 37 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37996 | 37996 | 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 |
37997 | 37997 | 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 |
13264 | 13264 | 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 |
2409 | 2409 | 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 | ||
2410 | 2410 | 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 | ||
2411 | 2411 | 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 | ||
2412 | 2412 | 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 | ||
17989 | 17989 | 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 |
17990 | 17990 | 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 |
36786 | 36786 | 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 |
36779 | 36779 | 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 |
6832 | 6832 | 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 |
6837 | 6837 | 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 |
17764 | 17764 | 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 |
17765 | 17765 | 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 |
6833 | 6833 | 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 |
16755 | 16755 | 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 |
37879 | 37879 | 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 |
37880 | 37880 | 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 |
37881 | 37881 | 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 |
37882 | 37882 | 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 |
38297 | 38297 | 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 |
33704 | 33704 | 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 | |
38299 | 38299 | 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 |
38295 | 38295 | 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 |
38296 | 38296 | 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 |
40567 | 40567 | 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 |
9120 | 9120 | 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 | |
19427 | 19427 | 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 | |
19428 | 19428 | 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 | |
19429 | 19429 | 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 | |
32571 | 32571 | 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 | |
32572 | 32572 | 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 | |
32573 | 32573 | 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 | |
30255 | 30255 | 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 | |
29076 | 29076 | 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 | ||
34001 | 34001 | 1946-10-30 | 1945-04-30 | South | Lucille A. | Film Preview 303 | 1945-04-30 | Film Preview | 1504 Hennepin Avenue | Minneapolis | MN |
Advanced export
JSON shape: default, array, newline-delimited
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]) );