home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_Registrants

Table actions
  • GraphQL API for FARA_All_Registrants
List of all registrant data (active and terminated)

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

39 rows where State = "MI"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Business_Name, Address_2, Zip, Registration_Date (date), Termination_Date (date)

Address_1 >30

  • 100 Renaissance Center 3
  • Whittar Steel Strip 2
  • 107 Northland Towers, West 1
  • 1133 Latham Street 1
  • 11601 Joseph Campau 1
  • 118 West Ottawa Street 1
  • 13355 Trenton Road 1
  • 13530 Michigan Avenue, #325 1
  • 150 Ottawa Ave NW 1
  • 16311 Middlebelt Road 1
  • 1721 Laraway Lake Drive SE 1
  • 17432 Woodward Avenue 1
  • 19345 Bush Road 1
  • 2026 N 3 Mile Road 1
  • 2222 W. Grand River Avenue 1
  • 228 Penobscot Building 1
  • 243 West Congress Avenue 1
  • 243 West Larned Street 1
  • 2734 Holly Avenue 1
  • 2751 East Jefferson Avenue 1
  • 2950 West Square Lake Road 1
  • 3000 Town Center 1
  • 301 James Street 1
  • 31013 Bobrich Street 1
  • 371 State Street 1
  • 430 North Old Woodward Avenue 1
  • 500 Woodward Avenue 1
  • 5322 Fifteen Mile Road 1
  • 6740 E. Ten Mile Road 1
  • 7 Cumberlane Court 1
  • …

City 19

  • Detroit 15
  • Dearborn 3
  • Birmingham 2
  • Grand Rapids 2
  • Livonia 2
  • Southfield 2
  • Ada 1
  • Centerline 1
  • Chelsea 1
  • Grayling 1
  • Grosse Pointe Farms 1
  • Hamtrammck 1
  • Hessel 1
  • Holland 1
  • Lansing 1
  • Okemos 1
  • Southgate 1
  • Sterling Heights 1
  • Troy 1

State 1

  • MI · 39 ✖
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
152 1942-11-04 1943-05-04 Moraru, Glicherie   2734 Holly Avenue   Dearborn MI  
176 1943-01-27 1943-01-27 Gauthier, Donat A.   7408 Pog Street   Detroit MI  
503 1947-11-28 1948-05-28 Martin, Nicholas N.   243 West Larned Street   Detroit MI  
658 1951-01-30 1960-07-30 Slovak Liberation Committee in the U.S.   C/O Joseph Ferkovic 6627 Marcus Detroit MI  
1203 1959-02-19 1960-02-25 Amerpol Enterprises, Inc.   11601 Joseph Campau   Hamtrammck MI  
1215 1959-03-30 1959-09-30 Emil Leidich, Inc., Travel Service   228 Penobscot Building   Detroit MI  
1243 1959-07-06 1961-01-06 Examro, Inc.   371 State Street   Detroit MI  
2049 1967-09-13 1974-03-31 Netherlands Information Service, Michigan   City Hall   Holland MI 49423
2333 1972-04-19 1978-04-11 Jamaica Tourist Board, Michigan   107 Northland Towers, West   Southfield MI 48075
2439 1973-07-02 1975-05-30 LaLosh, Milton Seaway Coin Company 13355 Trenton Road   Southgate MI 48195
2583 1975-05-12 1977-04-25 Campbell-Ewald Company   General Motors Building 4th Floor Detroit MI 48202
2612 1975-09-29 1987-03-29 Space Travel Agency   17432 Woodward Avenue   Detroit MI 48203
2684 1976-04-19 1977-09-23 Papo, Madeleine Blanche   19345 Bush Road   Chelsea MI 48118
2689 1976-05-03 1977-12-31 Morrow, Thomas F.   78 Vendome   Grosse Pointe Farms MI 48236
2989 1979-01-17 1984-07-17 Ross Roy/Colarossi Griswold, Inc. Colarossi/Griswold-Eshleman 2751 East Jefferson Avenue   Detroit MI 48207
3016 1979-05-04 1985-04-23 Korea Trade Center, Detroit   3000 Town Center Suite L-111 Southfield MI 48075
3255 1981-07-02 1981-07-02 Cooperative Association of Professionals, Inc.   100 Renaissance Center Suite 2412 Detroit MI 48243
3256 1981-07-02 1981-07-02 Dike Motor Company, Ltd. Aero Nigeria Motors, Ltd. 100 Renaissance Center Suite 2412 Detroit MI 48243
3311 1981-11-27 1993-07-09 Bee Moua   301 James Street   Grayling MI 49738
3338 1982-02-25 1987-02-06 Amway Corporation   7575 East Fulton Road   Ada MI 49355
3795 1986-03-12 1987-10-27 Market Opinion Research   243 West Congress Avenue   Detroit MI 48226
4051 1987-10-15 1989-10-02 Durocher & Company, Inc.   100 Renaissance Center Suite 2480 Detroit MI 48243
4118 1988-04-14 1988-11-24 Brown, Gene W.   Whittar Steel Strip 20001 Sherwood Avenue Detroit MI 48234
4190 1988-11-29 1990-12-12 Mathews, Robert C.   Whittar Steel Strip 20001 Sherwood Avenue Detroit MI 48234
4862 1993-10-19 1994-12-22 Eisbrenner Public Relations, Inc. Eisbrenner Public Relations 2950 West Square Lake Road Suite 100 Troy MI 48098
5519 2002-10-01 2002-11-30 Sterling International Consulting Corporation   118 West Ottawa Street   Lansing MI 48933
5554 2003-04-14 2004-12-27 Hmong Foreign Council   6740 E. Ten Mile Road   Centerline MI 48015
5635 2004-07-29 2004-07-29 Pytko, D. Victor Ramp Public Communications Specialists 1133 Latham Street   Birmingham MI 48009
5657 2004-11-12 2005-03-31 Public I   430 North Old Woodward Avenue   Birmingham MI 48009
5709 2005-09-08 2006-03-08 Clark Hill, PLC   500 Woodward Avenue Suite 3500 Detroit MI 48226
5768 2006-09-19 2007-04-11 Focus on Advocacy and Advancement of International Relations   13530 Michigan Avenue, #325   Dearborn MI 48126
5792 2007-02-05 2007-08-31 Zenith Consulting, Inc.   5322 Fifteen Mile Road Suite C Sterling Heights MI 48310
6106 2012-05-31 2012-09-30 Corley, Walter   7 Cumberlane Court   Dearborn MI 48126
6449 2017-07-29   StrateVarious LLC   1721 Laraway Lake Drive SE   Grand Rapids MI 49546
6983 2021-08-03   Ahmed, Summer   2222 W. Grand River Avenue Suite A Okemos MI 48864
7114 2022-05-10 2022-11-30 Berris, Marvin Lou   16311 Middlebelt Road   Livonia MI 48154
7169 2022-09-12   U.S. Legal Advisors PLLC   2026 N 3 Mile Road P.O. Box 126 Hessel MI 49745
7261 2023-04-21   Warner Norcross + Judd   150 Ottawa Ave NW Suite 1500 Grand Rapids MI 49503
7290 2023-07-03   Aferdita Rakipi Communications LLC   31013 Bobrich Street   Livonia MI 48152

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_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 107.234ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history