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, atom, 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
2377 2377 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  
3110 3110 1961-01-06 1959-07-06 Klein Carl W. , Jr. 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
3111 3111 1961-01-06 1959-07-06 Popenas Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
4585 4585 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  
4586 4586 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  
4587 4587 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  
4588 4588 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  
4589 4589 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  
6350 6350 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  
8649 8649 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  
8650 8650 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  
8812 8812 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
11638 11638 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
13148 13148 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
13149 13149 1977-04-25 1975-05-12 Guggenheim Bernard 2583 2583 1975-05-12 Campbell-Ewald Company General Motors Building 4th Floor Detroit MI 48202
13150 13150 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
13557 13557 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
17062 17062 1959-06-01 1959-07-06 Milan Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
20604 20604 1980-07-01 1975-11-11 Stanical Stelian 2612 2612 1975-09-29 Space Travel Agency 17432 Woodward Avenue   Detroit MI 48203
20869 20869 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
20870 20870 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
20871 20871 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
20872 20872 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
20873 20873 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
21818 21818 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
21819 21819 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
22752 22752 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  
22753 22753 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  
22754 22754 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  
22755 22755 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  
22756 22756 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  
22757 22757 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  
22758 22758 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  
22759 22759 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  
22760 22760 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  
22761 22761 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  
22762 22762 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  
22763 22763 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  
22764 22764 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  
22765 22765 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  
22766 22766 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  
22767 22767 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  
22768 22768 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  
22769 22769 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  
22770 22770 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  
22771 22771 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  
22772 22772 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  
22773 22773 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  
22774 22774 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  
22775 22775 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  
22776 22776 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  
22777 22777 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  
23756 23756 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
26873 26873 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
28821 28821 1959-09-30 1959-03-30 Leidich Emil 1215 1215 1959-03-30 Emil Leidich, Inc., Travel Service 228 Penobscot Building   Detroit MI  
29712 29712 1959-10-01 1959-07-06 Hanna Jack 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
29762 29762 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
31527 31527 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
31528 31528 1987-10-27 1986-03-12 Gage Alexander P. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
31529 31529 1987-10-27 1986-03-12 McGeoch Peter J. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
31530 31530 1987-10-27 1986-03-12 Teeter Robert M. 3795 3795 1986-03-12 Market Opinion Research 243 West Congress Avenue   Detroit MI 48226
31879 31879 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
31880 31880 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
32633 32633 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
32634 32634 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
36581 36581 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 337.029ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history