FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
66 rows where State = "MN"
This data as json, CSV (advanced)
Registration_Number 13
- O'Connor & Hannan 5
- McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4
- Martin, Ryan, Haley & Associates, Inc. 3
- Sprenger, Olson & Shutes, P.A. 3
- Grand Metropolitan Consumer Services & Products, Inc. 2
- CCO Communications LLC 2
- Film Preview 1
- Schilling Travel Service, Inc. 1
- Don Braman & Associates, Inc. 1
- Noble International, Inc. 1
- Shandwick USA, Inc. 1
- For Your Institute for Human Development 1
- Xiong, Seng 1
Registrant_Name 13
- O'Connor & Hannan 5
- McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4
- Martin, Ryan, Haley & Associates, Inc. 3
- Sprenger, Olson & Shutes, P.A. 3
- CCO Communications LLC 2
- Grand Metropolitan Consumer Services & Products, Inc. 2
- Don Braman & Associates, Inc. 1
- Film Preview 1
- For Your Institute for Human Development 1
- Noble International, Inc. 1
- Schilling Travel Service, Inc. 1
- Shandwick USA, Inc. 1
- Xiong, Seng 1
City 5
- Minneapolis 20
- St. Paul 3
- Bloomington 1
- Brooklyn Park 1
- Rochester 1
State 1
- MN · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
29917 | 29917 | 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 | |
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 | |
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 | |
32642 | 32642 | 2017-10-11 | 2017-05-31 | Xiong | Seng | Xiong, Seng 6444 | 2017-07-11 | Xiong, Seng | 7932 Ewing Avenue | Brooklyn Park | MN | 55443 | |
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 | |
34001 | 34001 | 1946-10-30 | 1945-04-30 | South | Lucille A. | Film Preview 303 | 1945-04-30 | Film Preview | 1504 Hennepin Avenue | Minneapolis | MN | ||
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 |
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 |
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 |
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 |
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 |
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 |
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 |
38565 | 38565 | 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 |
38726 | 38726 | 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 | |
38727 | 38727 | 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 | |
38728 | 38728 | 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 | |
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 |
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]) );