home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

37 rows where City = "Minneapolis"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Last_Name, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_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
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
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
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
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
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
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
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
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
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
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
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

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 · Queries took 713.213ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows