FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
37 rows where City = "Minneapolis"
This data as json, CSV (advanced)
Registration_Number 9
- O'Connor & Hannan 5
- McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4
- 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
Registrant_Name 9
- O'Connor & Hannan 5
- McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4
- 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
- Noble International, Inc. 1
- Schilling Travel Service, Inc. 1
State 1
- MN 20
City 1
- Minneapolis · 20 ✖
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 | ||
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 | |
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 |
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]) );