FARA_All_Registrants

List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

21 rows where State = "OH"

View and edit SQL

Suggested facets: Name, Business_Name, Address_2, Zip, Registration_Date (date), Termination_Date (date)

State

Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
3 1942-07-03 1942-07-03 Lawrence, William S.   1438 Midland Building   Cleveland OH  
331 1945-12-12 1946-06-05 Lind, Lewis Merkt   6007 Euclid Avenue   Cleveland OH  
878 1955-03-09 1955-03-09 Circle of the Croatian Knights   Post Office Box 6071   Cleveland OH  
979 1956-10-12 1960-05-06 Radich, Ethel P.   1899 West 25th Street   Cleveland OH  
1180 1958-10-06 1959-05-14 Central Council of Croation Associations - U.S. & Canada   5703 Dibble Avenue   Cleveland OH  
1212 1959-03-23 1971-02-01 Sega, Milan   1445 East 40th Street   Cleveland OH 44103
1264 1959-08-31 1960-01-27 Provident Travel Service   Provident Bank 7th & Vine Streets Cincinnati OH  
1265 1959-09-04 1960-03-04 Brennan, Earl   Brock Electric Company 648 Kenmore Boulevard Akron OH  
1313 1959-12-16 1960-08-15 Poznan Travel Agency, Inc.   6964 Broadway Avenue   Cleveland OH  
1902 1965-06-16 1966-07-12 Lowe, Young   94 Cowles Avenue   Bedford OH 44014
2227 1970-12-03 1972-01-17 Pannonia Enterprises, Inc.   1736 East 22nd Street   Cleveland OH 44114
2456 1973-09-04 1976-02-04 Pannonia Enterprises, Inc.   1736 East 22nd Street   Cleveland OH 44114
2608 1975-09-18 1989-12-19 Chima Travel Bureau, Inc.   Wallhaven Building 1650 West Market Street Akron OH 44313
2624 1975-10-30 1988-12-31 Vintilla, Victoria A. Arta Travel Service 610 Hanna Building   Cleveland OH 44115
2874 1978-03-28 1980-04-22 Billington, Glenn   1126 Terminal Tower   Cleveland OH 44113
3426 1982-12-08 2003-06-08 Oestreicher, Michael R.   312 Walnut Street Suite 1400 Cincinnati OH 45202
4680 1992-06-03 1993-01-29 Samex Trading Company, Inc.   389 Library Park, South   Columbus OH 43215
5052 1995-09-19 1995-09-19 Parti Lumumbiste Unifie (PALU)   Representation U.S.A. Post Office Box 19873 Cincinnati OH 45219
5696 2005-07-08 2006-01-31 Brian L. Morris   2473 Bexford Place   Columbus OH 43209
6032 2011-04-14 2018-10-31 International Merchandising Corporation   1360 East 9th Street Suite 100 Cleveland OH 44114
6403 2017-02-22 2017-06-28 James S. Nathanson & Associates, LLC   131 North Ludlow Street Suite 315 Dayton OH 45402

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_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 45.286ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history