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)

State 1

City 1

  • 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
2372 2372 1953-01-01 1952-09-12 Bartos Joseph Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
3119 3119 1961-01-06 1959-07-06 Klein Carl W. , Jr. Examro, Inc. 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
3120 3120 1961-01-06 1959-07-06 Popenas Michael Examro, Inc. 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
4677 4677 1954-01-31 1951-01-30 Skoda Daniel Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
4678 4678 1954-01-31 1952-02-29 Sabo Veronica M. Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
4679 4679 1954-01-31 1953-03-02 Skoda Terezia Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
4680 4680 1954-01-31 1951-04-04 Bartkovsky Albert Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
4681 4681 1954-01-31 1951-04-04 Gondar Joseph Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
6534 6534 1952-02-14 1951-04-04 Lalka Stephen Joseph Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
9022 9022 1955-03-07 1954-05-06 Kulhan Marta Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
9023 9023 1955-03-07 1954-08-17 Kulhan John Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
9187 9187 2006-03-08 2005-09-08 Richner Andrew C. Clark Hill, PLC 5709 2005-09-08 Clark Hill, PLC 500 Woodward Avenue Suite 3500 Detroit MI 48226
12118 12118 1987-04-01 1986-03-12 Reisner Robert A.F. Market Opinion Research 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
13704 13704 1977-04-25 1975-05-12 Acker Edwin L. Campbell-Ewald Company 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
13705 13705 1977-04-25 1975-05-12 Guggenheim Bernard Campbell-Ewald Company 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
13706 13706 1977-04-25 1975-05-12 Valentine James E. Campbell-Ewald Company 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
14131 14131 1979-04-30 1979-01-17 Hoebee Robert W. Ross Roy/Colarossi Griswold, Inc. 2989 1979-01-17 Ross Roy/Colarossi Griswold, Inc. 2751 East Jefferson Avenue   Detroit MI 48207
17875 17875 1959-06-01 1959-07-06 Milan Michael Examro, Inc. 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
21561 21561 1980-07-01 1975-11-11 Stanical Stelian Space Travel Agency 2612 1975-09-29 Space Travel Agency 17432 Woodward Avenue   Detroit MI 48203
21854 21854 1981-07-02 1981-07-02 Akubueze Prince Ben O. Cooperative Association of Professionals, Inc. 3255 1981-07-02 Cooperative Association of Professionals, Inc. 100 Renaissance Center Suite 2412 Detroit MI 48243
21855 21855 1981-07-02 1981-07-02 Dike E. E. Dike Motor Company, Ltd. 3256 1981-07-02 Dike Motor Company, Ltd. 100 Renaissance Center Suite 2412 Detroit MI 48243
21856 21856 1981-07-02 1981-07-02 House William A. Cooperative Association of Professionals, Inc. 3255 1981-07-02 Cooperative Association of Professionals, Inc. 100 Renaissance Center Suite 2412 Detroit MI 48243
21857 21857 1981-07-02 1981-07-02 House William A. Dike Motor Company, Ltd. 3256 1981-07-02 Dike Motor Company, Ltd. 100 Renaissance Center Suite 2412 Detroit MI 48243
21858 21858 1981-07-02 1981-07-02 Hughes Wilbur G. , III Dike Motor Company, Ltd. 3256 1981-07-02 Dike Motor Company, Ltd. 100 Renaissance Center Suite 2412 Detroit MI 48243
22837 22837 1984-07-17 1979-01-17 Colarossi Benjamin Ross Roy/Colarossi Griswold, Inc. 2989 1979-01-17 Ross Roy/Colarossi Griswold, Inc. 2751 East Jefferson Avenue   Detroit MI 48207
22838 22838 1984-07-17 1979-01-17 Ubaldo Robert C. Ross Roy/Colarossi Griswold, Inc. 2989 1979-01-17 Ross Roy/Colarossi Griswold, Inc. 2751 East Jefferson Avenue   Detroit MI 48207
23800 23800 1960-07-30 1954-02-25 Lukac Jan Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23801 23801 1960-07-30 1954-02-25 Nesnadny Viktor Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23802 23802 1960-07-30 1954-02-25 Trubinsky Joseph Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23803 23803 1960-07-30 1953-03-02 Suchan Michael J. Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23804 23804 1960-07-30 1952-03-07 Stevak Francis Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23805 23805 1960-07-30 1951-04-04 Mazur Andrew Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23806 23806 1960-07-30 1958-04-09 Pachnik Emil Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23807 23807 1960-07-30 1954-08-17 Salka Kristina Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23808 23808 1960-07-30 1954-08-17 Salka Ludovit Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23809 23809 1960-07-30 1955-08-31 Bukovsky Simon Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23810 23810 1960-07-30 1955-08-31 Husek Helen Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23811 23811 1960-07-30 1955-08-31 Kozel Joseph Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23812 23812 1960-07-30 1955-08-31 Sisulak Ludevit Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23813 23813 1960-07-30 1957-09-03 Bucko Michael Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23814 23814 1960-07-30 1957-09-03 Ferkovic Joseph Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23815 23815 1960-07-30 1957-09-03 Kulhan John Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23816 23816 1960-07-30 1957-09-03 Mirga Frank Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23817 23817 1960-07-30 1957-09-03 Trubinsky Catherine Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23818 23818 1960-07-30 1952-09-12 Hrosso Michael Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23819 23819 1960-07-30 1952-09-12 Zaduban Joseph Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23820 23820 1960-07-30 1955-10-14 Bikkal Ladislav Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23821 23821 1960-07-30 1955-10-14 Chrenovsky Ernest Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23822 23822 1960-07-30 1955-10-14 Kovac Vojtech Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23823 23823 1960-07-30 1955-10-14 Macek Helen Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23824 23824 1960-07-30 1955-10-14 Okal John Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
23825 23825 1960-07-30 1955-10-14 Vrtik Emil Slovak Liberation Committee in the U.S. 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
24852 24852 1975-08-01 1975-05-12 Hampstead Marilyn J. Campbell-Ewald Company 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
28092 28092 1975-09-01 1975-05-12 Weithas Richard T. Campbell-Ewald Company 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
30088 30088 1959-09-30 1959-03-30 Leidich Emil Emil Leidich, Inc., Travel Service 1215 1959-03-30 Emil Leidich, Inc., Travel Service 228 Penobscot Building   Detroit MI  
31024 31024 1959-10-01 1959-07-06 Hanna Jack Examro, Inc. 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
31074 31074 1975-10-01 1975-05-12 Eicher Thomas W. Campbell-Ewald Company 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
32915 32915 1987-10-27 1986-03-12 Feltus William J. , IV Market Opinion Research 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32916 32916 1987-10-27 1986-03-12 Gage Alexander P. Market Opinion Research 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32917 32917 1987-10-27 1986-03-12 McGeoch Peter J. Market Opinion Research 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
32918 32918 1987-10-27 1986-03-12 Teeter Robert M. Market Opinion Research 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
33274 33274 1987-10-30 1987-10-15 Durocher Donald P. Durocher & Company, Inc. 4051 1987-10-15 Durocher & Company, Inc. 100 Renaissance Center Suite 2480 Detroit MI 48243
33275 33275 1987-10-30 1987-10-15 MacDermott Patricia A. Durocher & Company, Inc. 4051 1987-10-15 Durocher & Company, Inc. 100 Renaissance Center Suite 2480 Detroit MI 48243
34072 34072 1975-11-01 1975-05-12 Pool Edson Kendall , Jr. Campbell-Ewald Company 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
34073 34073 1975-11-01 1975-05-12 Vogel Michael Jack Campbell-Ewald Company 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
38251 38251 1988-12-25 1988-10-28 Brown Val Durocher & Company, Inc. 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])
);