FARA_All_ShortForms

Table actions
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
2258 2258 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  
2998 2998 1961-01-06 1959-07-06 Klein Carl W. , Jr. 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
2999 2999 1961-01-06 1959-07-06 Popenas Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
4507 4507 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  
4508 4508 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  
4509 4509 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  
4510 4510 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  
4511 4511 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  
6324 6324 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  
8738 8738 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  
8739 8739 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  
8901 8901 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
11762 11762 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
13302 13302 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
13303 13303 1977-04-25 1975-05-12 Guggenheim Bernard 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
13304 13304 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
13723 13723 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
17345 17345 1959-06-01 1959-07-06 Milan Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
20947 20947 1980-07-01 1975-11-11 Stanical Stelian 2612 2612 1975-09-29 Space Travel Agency 17432 Woodward Avenue   Detroit MI 48203
21218 21218 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
21219 21219 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
21220 21220 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
21221 21221 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
21222 21222 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
22182 22182 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
22183 22183 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
23140 23140 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  
23141 23141 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  
23142 23142 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  
23143 23143 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  
23144 23144 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  
23145 23145 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  
23146 23146 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  
23147 23147 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  
23148 23148 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  
23149 23149 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  
23150 23150 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  
23151 23151 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  
23152 23152 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  
23153 23153 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  
23154 23154 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  
23155 23155 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  
23156 23156 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  
23157 23157 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  
23158 23158 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  
23159 23159 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  
23160 23160 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  
23161 23161 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  
23162 23162 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  
23163 23163 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  
23164 23164 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  
23165 23165 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  
24182 24182 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
27378 27378 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
29350 29350 1959-09-30 1959-03-30 Leidich Emil 1215 1215 1959-03-30 Emil Leidich, Inc., Travel Service 228 Penobscot Building   Detroit MI  
30263 30263 1959-10-01 1959-07-06 Hanna Jack 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
30313 30313 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
32123 32123 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
32124 32124 1987-10-27 1986-03-12 Gage Alexander P. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32125 32125 1987-10-27 1986-03-12 McGeoch Peter J. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32126 32126 1987-10-27 1986-03-12 Teeter Robert M. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32479 32479 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
32480 32480 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
33267 33267 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
33268 33268 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
37317 37317 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)
);