FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
66 rows where City = "Detroit"
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)
Registrant_Name
- 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
- MI 66
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
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) );