home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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_Date, Registration_Date, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)

Registration_Number 11

  • Slovak Liberation Committee in the U.S. 35
  • Campbell-Ewald Company 8
  • Market Opinion Research 5
  • Examro, Inc. 4
  • Ross Roy/Colarossi Griswold, Inc. 3
  • Dike Motor Company, Ltd. 3
  • Durocher & Company, Inc. 3
  • Cooperative Association of Professionals, Inc. 2
  • Emil Leidich, Inc., Travel Service 1
  • Space Travel Agency 1
  • Clark Hill, PLC 1

Registrant_Name 11

  • Slovak Liberation Committee in the U.S. 35
  • Campbell-Ewald Company 8
  • Market Opinion Research 5
  • Examro, Inc. 4
  • Dike Motor Company, Ltd. 3
  • Durocher & Company, Inc. 3
  • Ross Roy/Colarossi Griswold, Inc. 3
  • Cooperative Association of Professionals, Inc. 2
  • Clark Hill, PLC 1
  • Emil Leidich, Inc., Travel Service 1
  • Space Travel Agency 1

State 1

  • MI 66

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
2502 2502 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  
3264 3264 1961-01-06 1959-07-06 Klein Carl W. , Jr. Examro, Inc. 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
3265 3265 1961-01-06 1959-07-06 Popenas Michael Examro, Inc. 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
4875 4875 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  
4876 4876 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  
4877 4877 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  
4878 4878 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  
4879 4879 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  
6769 6769 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  
9291 9291 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  
9292 9292 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  
9470 9470 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
12465 12465 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
14080 14080 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
14081 14081 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
14082 14082 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
14516 14516 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
18369 18369 1959-06-01 1959-07-06 Milan Michael Examro, Inc. 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
22126 22126 1980-07-01 1975-11-11 Stanical Stelian Space Travel Agency 2612 1975-09-29 Space Travel Agency 17432 Woodward Avenue   Detroit MI 48203
22432 22432 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
22433 22433 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
22434 22434 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
22435 22435 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
22436 22436 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
23423 23423 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
23424 23424 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
24422 24422 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  
24423 24423 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  
24424 24424 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  
24425 24425 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  
24426 24426 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  
24427 24427 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  
24428 24428 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  
24429 24429 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  
24430 24430 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  
24431 24431 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  
24432 24432 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  
24433 24433 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  
24434 24434 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  
24435 24435 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  
24436 24436 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  
24437 24437 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  
24438 24438 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  
24439 24439 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  
24440 24440 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  
24441 24441 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  
24442 24442 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  
24443 24443 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  
24444 24444 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  
24445 24445 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  
24446 24446 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  
24447 24447 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  
25498 25498 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
28795 28795 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
30818 30818 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  
31776 31776 1959-10-01 1959-07-06 Hanna Jack Examro, Inc. 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
31826 31826 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
33699 33699 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
33700 33700 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
33701 33701 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
33702 33702 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
34059 34059 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
34060 34060 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
34873 34873 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
34874 34874 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
39106 39106 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])
);
Powered by Datasette · Queries took 606.856ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows