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

34 rows where State = "MI"

View and edit SQL

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

State

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

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 · Query took 40.239ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history