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

66 rows where City = "Detroit"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

City

  • Detroit · 66 ✖
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
2424 2424 1953-01-01 1952-09-12 Bartos Joseph 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
3160 3160 1961-01-06 1959-07-06 Klein Carl W. , Jr. 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
3161 3161 1961-01-06 1959-07-06 Popenas Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
4652 4652 1954-01-31 1951-01-30 Skoda Daniel 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
4653 4653 1954-01-31 1952-02-29 Sabo Veronica M. 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
4654 4654 1954-01-31 1953-03-02 Skoda Terezia 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
4655 4655 1954-01-31 1951-04-04 Bartkovsky Albert 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
4656 4656 1954-01-31 1951-04-04 Gondar Joseph 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
6445 6445 1952-02-14 1951-04-04 Lalka Stephen Joseph 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
8781 8781 1955-03-07 1954-05-06 Kulhan Marta 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
8782 8782 1955-03-07 1954-08-17 Kulhan John 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
8944 8944 2006-03-08 2005-09-08 Richner Andrew C. 5709 5709 2005-09-08 Clark Hill, PLC 500 Woodward Avenue Suite 3500 Detroit MI 48226
11801 11801 1987-04-01 1986-03-12 Reisner Robert A.F. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
13328 13328 1977-04-25 1975-05-12 Acker Edwin L. 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
13329 13329 1977-04-25 1975-05-12 Guggenheim Bernard 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
13330 13330 1977-04-25 1975-05-12 Valentine James E. 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
13748 13748 1979-04-30 1979-01-17 Hoebee Robert W. 2989 2989 1979-01-17 Ross Roy/Colarossi Griswold, Inc. 2751 East Jefferson Avenue   Detroit MI 48207
17330 17330 1959-06-01 1959-07-06 Milan Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
20909 20909 1980-07-01 1975-11-11 Stanical Stelian 2612 2612 1975-09-29 Space Travel Agency 17432 Woodward Avenue   Detroit MI 48203
21176 21176 1981-07-02 1981-07-02 Akubueze Prince Ben O. 3255 3255 1981-07-02 Cooperative Association of Professionals, Inc. 100 Renaissance Center Suite 2412 Detroit MI 48243
21177 21177 1981-07-02 1981-07-02 Dike E. E. 3256 3256 1981-07-02 Dike Motor Company, Ltd. 100 Renaissance Center Suite 2412 Detroit MI 48243
21178 21178 1981-07-02 1981-07-02 House William A. 3255 3255 1981-07-02 Cooperative Association of Professionals, Inc. 100 Renaissance Center Suite 2412 Detroit MI 48243
21179 21179 1981-07-02 1981-07-02 House William A. 3256 3256 1981-07-02 Dike Motor Company, Ltd. 100 Renaissance Center Suite 2412 Detroit MI 48243
21180 21180 1981-07-02 1981-07-02 Hughes Wilbur G. , III 3256 3256 1981-07-02 Dike Motor Company, Ltd. 100 Renaissance Center Suite 2412 Detroit MI 48243
22129 22129 1984-07-17 1979-01-17 Colarossi Benjamin 2989 2989 1979-01-17 Ross Roy/Colarossi Griswold, Inc. 2751 East Jefferson Avenue   Detroit MI 48207
22130 22130 1984-07-17 1979-01-17 Ubaldo Robert C. 2989 2989 1979-01-17 Ross Roy/Colarossi Griswold, Inc. 2751 East Jefferson Avenue   Detroit MI 48207
23067 23067 1960-07-30 1954-02-25 Lukac Jan 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23068 23068 1960-07-30 1954-02-25 Nesnadny Viktor 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23069 23069 1960-07-30 1954-02-25 Trubinsky Joseph 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23070 23070 1960-07-30 1953-03-02 Suchan Michael J. 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23071 23071 1960-07-30 1952-03-07 Stevak Francis 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23072 23072 1960-07-30 1951-04-04 Mazur Andrew 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23073 23073 1960-07-30 1958-04-09 Pachnik Emil 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23074 23074 1960-07-30 1954-08-17 Salka Kristina 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23075 23075 1960-07-30 1954-08-17 Salka Ludovit 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23076 23076 1960-07-30 1955-08-31 Bukovsky Simon 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23077 23077 1960-07-30 1955-08-31 Husek Helen 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23078 23078 1960-07-30 1955-08-31 Kozel Joseph 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23079 23079 1960-07-30 1955-08-31 Sisulak Ludevit 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23080 23080 1960-07-30 1957-09-03 Bucko Michael 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23081 23081 1960-07-30 1957-09-03 Ferkovic Joseph 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23082 23082 1960-07-30 1957-09-03 Kulhan John 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23083 23083 1960-07-30 1957-09-03 Mirga Frank 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23084 23084 1960-07-30 1957-09-03 Trubinsky Catherine 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23085 23085 1960-07-30 1952-09-12 Hrosso Michael 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23086 23086 1960-07-30 1952-09-12 Zaduban Joseph 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23087 23087 1960-07-30 1955-10-14 Bikkal Ladislav 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23088 23088 1960-07-30 1955-10-14 Chrenovsky Ernest 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23089 23089 1960-07-30 1955-10-14 Kovac Vojtech 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23090 23090 1960-07-30 1955-10-14 Macek Helen 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23091 23091 1960-07-30 1955-10-14 Okal John 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23092 23092 1960-07-30 1955-10-14 Vrtik Emil 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
24087 24087 1975-08-01 1975-05-12 Hampstead Marilyn J. 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
27239 27239 1975-09-01 1975-05-12 Weithas Richard T. 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
29199 29199 1959-09-30 1959-03-30 Leidich Emil 1215 1215 1959-03-30 Emil Leidich, Inc., Travel Service 228 Penobscot Building   Detroit MI  
30095 30095 1959-10-01 1959-07-06 Hanna Jack 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
30145 30145 1975-10-01 1975-05-12 Eicher Thomas W. 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
31923 31923 1987-10-27 1986-03-12 Feltus William J. , IV 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
31924 31924 1987-10-27 1986-03-12 Gage Alexander P. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
31925 31925 1987-10-27 1986-03-12 McGeoch Peter J. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
31926 31926 1987-10-27 1986-03-12 Teeter Robert M. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32275 32275 1987-10-30 1987-10-15 Durocher Donald P. 4051 4051 1987-10-15 Durocher & Company, Inc. 100 Renaissance Center Suite 2480 Detroit MI 48243
32276 32276 1987-10-30 1987-10-15 MacDermott Patricia A. 4051 4051 1987-10-15 Durocher & Company, Inc. 100 Renaissance Center Suite 2480 Detroit MI 48243
33043 33043 1975-11-01 1975-05-12 Pool Edson Kendall , Jr. 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
33044 33044 1975-11-01 1975-05-12 Vogel Michael Jack 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
37026 37026 1988-12-25 1988-10-28 Brown Val 4051 4051 1987-10-15 Durocher & Company, Inc. 100 Renaissance Center Suite 2480 Detroit MI 48243

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