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
2221 2221 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  
2966 2966 1961-01-06 1959-07-06 Klein Carl W. , Jr. 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
2967 2967 1961-01-06 1959-07-06 Popenas Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
4501 4501 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  
4502 4502 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  
4503 4503 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  
4504 4504 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  
4505 4505 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  
6325 6325 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  
8766 8766 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  
8767 8767 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  
8929 8929 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
11816 11816 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
13370 13370 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
13371 13371 1977-04-25 1975-05-12 Guggenheim Bernard 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
13372 13372 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
13792 13792 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
17419 17419 1959-06-01 1959-07-06 Milan Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
21031 21031 1980-07-01 1975-11-11 Stanical Stelian 2612 2612 1975-09-29 Space Travel Agency 17432 Woodward Avenue   Detroit MI 48203
21302 21302 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
21303 21303 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
21304 21304 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
21305 21305 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
21306 21306 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
22270 22270 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
22271 22271 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
23229 23229 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  
23230 23230 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  
23231 23231 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  
23232 23232 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  
23233 23233 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  
23234 23234 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  
23235 23235 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  
23236 23236 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  
23237 23237 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  
23238 23238 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  
23239 23239 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  
23240 23240 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  
23241 23241 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  
23242 23242 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  
23243 23243 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  
23244 23244 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  
23245 23245 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  
23246 23246 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  
23247 23247 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  
23248 23248 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  
23249 23249 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  
23250 23250 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  
23251 23251 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  
23252 23252 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  
23253 23253 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  
23254 23254 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  
24273 24273 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
27473 27473 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
29448 29448 1959-09-30 1959-03-30 Leidich Emil 1215 1215 1959-03-30 Emil Leidich, Inc., Travel Service 228 Penobscot Building   Detroit MI  
30360 30360 1959-10-01 1959-07-06 Hanna Jack 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
30410 30410 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
32222 32222 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
32223 32223 1987-10-27 1986-03-12 Gage Alexander P. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32224 32224 1987-10-27 1986-03-12 McGeoch Peter J. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32225 32225 1987-10-27 1986-03-12 Teeter Robert M. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32578 32578 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
32579 32579 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
33368 33368 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
33369 33369 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
37422 37422 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)
);