FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

138 rows where State = "IL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Business_Name, Registration_Date (date), Termination_Date (date)

State 1

  • IL · 138 ✖
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
33 1942-07-10 1945-01-10 Luehne Jr., John H.   7743 South Colfax Avenue   Chicago IL  
34 1943-03-03 1961-02-03 Caples Company   216 East Ontario Street   Chicago IL  
151 1942-10-29 1945-04-29 Koenig, Harry D.   111 West Washington Street Room 1701 Chicago IL 60290
278 1944-09-11 1948-03-11 Mexican Chamber of Commerce, Inc., Chicago   201 North Wells Street   Chicago IL  
304 1945-06-08 1946-06-06 College Film Center   84 East Randolph Street   Chicago IL  
369 1946-08-23 1947-02-23 Shaheen & White, Inc.   33 North LaSalle Street   Chicago IL  
375 1946-10-07 1947-09-01 Giunio-Zorkin, Mladen   1802 South Allport   Chicago IL  
393 1946-11-18 1954-06-15 Dorsey, LeRoy H.   509 South Wabash Avenue   Chicago IL  
446 1947-03-18 1947-10-07 Supreme Committee of Croatian Peasant Society   1806 S. Allport Street   Chicago IL 00000
483 1947-07-31 1985-01-28 Central Parcel Service, Inc.   220 South State Street   Chicago IL 60604
510 1948-01-29 1948-03-15 Karas, Dr. Frantisek   St. Procopius Church 1641 Allport Street, South Chicago IL  
578 1949-07-07 1949-07-07 Danish Society   2057 North Keystone Avenue   Chicago IL  
661 1951-02-21 1951-11-30 Simon, Hugo Ferdinand   443 Barry Avenue   Chicago IL  
874 1955-02-21 1992-06-17 Austrian Trade Commissioner in the U.S., Chicago   500 North Michigan Avenue Suite 1950 Chicago IL 60611
920 1955-11-16 1968-06-30 Collegial Society of Hungarian Veterans in the U.S.A.   1339 Howard Street   Chicago IL 60626
975 1956-09-07 1967-10-26 Julius Klein Public Relations   110 South Dearborn Street   Chicago IL  
988 1956-12-11 1957-09-01 Skala, John B. Skala National Bank of Chicago Travel Bureau 1817 South Loomis Street   Chicago IL  
1009 1957-03-13 1960-03-17 Basta-Musil & Company, Inc.   3917-19 West 26th Street   Chicago IL  
1038 1957-06-14 1960-08-12 Atlantic Travel Bureau   1824 West Chicago Avenue   Chicago IL  
1043 1957-06-27 1960-03-25 R. Matuszczak & Company, Travel Bureau, Inc.   1143 North Milwaukee Avenue   Chicago IL  
1061 1957-08-22 1958-09-23 Senese, Anthony M.   918 South Leavitt Street   Chicago IL  
1075 1957-10-30 1960-06-23 Globe Travel Service   127 North Dearborn Street   Chicago IL  
1096 1957-12-23 1960-08-03 Skala-Weber Travel Agency   7045 Cermak Plaze   Berwyn IL  
1105 1958-01-14 1958-07-14 Vazquez, Jose Infanzon   4006 North Sheridan Road   Chicago IL  
1137 1958-04-29 1960-05-06 Bork Tour & Travel Service   6636 Cermak Road   Berwyn IL  
1150 1958-06-18 1958-06-18 Cuban Liberation Movement of July 26th   3930 West Wilcox Avenue   Chicago IL  
1184 1958-12-03 1966-07-10 Grant Advertising, Inc.   10 South Riverside Plaza   Chicago IL 60606
1228 1959-05-15 1960-10-19 Rose, Rose Cross World Books & Periodicals 333 South Wacker Drive   Chicago IL  
1237 1959-06-15 1961-02-15 Kangles, Constantine N.   100 North La Salle Street   Chicago IL  
1259 1959-08-27 1960-02-25 American Tourist Bureau, Inc., Chicago   30 West Washington Street   Chicago IL  
1286 1959-10-12 1960-05-06 Europe Travel Bureau, Inc.   1130 North California Avenue   Chicago IL  
1301 1959-12-02 1961-06-02 Lejarza Mora, Salvador   1606 West Grand Avenue   Chicago IL  
1341 1960-03-17 1960-03-17 Nicaraguan Liberation Movement of July 23rd   1422 Elmwood Street   Evanston IL  
1383 1960-08-03 1968-04-11 Government of Ontario, Canada, Chicago   11 East Adams Room 705 Chicago IL 60603
1457 1961-06-19 1968-12-19 Crossworld Books & Periodicals, Inc.   333 South Wacker Drive 5th Floor Chicago IL 60606
1689 1964-02-13 1973-03-23 Buchen Advertising, Inc.   10 South Riverside Plaza   Chicago IL 60606
1780 1964-08-19 1964-08-19 Bloemer, Dr. Klaus   104 South Michigan Avenue   Chicago IL  
1798 1964-10-05 1964-12-24 Drost, John A.   2661 North Lincoln Avenue   Chicago IL 60614
1830 1964-12-11 1979-12-12 Spanish National Tourist Office, Chicago   845 North Michigan Avenue   Chicago IL 60611
1831 1964-12-14 1964-12-14 Mayer & O'Brien, Inc.   333 North Michigan Avenue Room 1500 Chicago IL 60601
1850 1965-02-02   JETRO, Chicago   1 East Wacker Drive Suite 3350 Chicago IL 60601
1852 1965-02-04 1976-12-31 Mexican Ministry of Tourism, Chicago   210 North Michigan Avenue   Chicago IL 60601
1878 1965-04-06 1995-03-31 German-American Chamber of Commerce of Chicago   104 South Michigan Avenue Suite 600 Chicago IL 606035978
1892 1968-06-07 2018-12-31 Italian Government Travel Office, Chicago   401 North Michigan Avenue Suite 1720 Chicago IL 60611
1972 1966-03-25 1966-03-25 Haiti Government Tourist Bureau   600 South Michigan Boulevard   Chicago IL 60605
2046 1967-09-06 1969-03-31 Johnson, Robert Bruce   333 North Michigan   Chicago IL 60601
2065 1967-11-24 1977-01-11 Public Relations Board, Inc.   150 East Huron Street   Chicago IL 60611
2109 1968-10-24 1970-12-21 Clinton E. Frank, Inc.   120 South Riverside Plaza   Chicago IL 60606
2118 1968-12-16 2004-06-16 Jamaica Tourist Board, Chicago   4655 S. Dr. Martin Luther King Drive Suite 201 Chicago IL 60653
2136 1969-05-14 1970-06-30 Government of Quebec   111 West Jackson Boulevard   Chicago IL 60604
2295 1971-12-14 1974-02-27 Australian Tourist Commission, Chicago   111 East Wacker Drive Suite 2216 Chicago IL 60601
2331 1972-04-17   Malaysian Industrial Development Authority   875 North Michigan Avenue Suite 1810 Chicago IL 60611
2347 1972-07-03 2003-07-31 Japan National Tourist Organization, Chicago   401 North Michigan Avenue Suite 770 Chicago IL 60611
2382 1972-09-25 1975-11-08 Beveridge, Kraus, Robbins & Manning, Inc.   75 East Wacker Drive   Chicago IL 60601
2394 1972-11-30 1973-11-20 Mandabach & Simms, Inc.   20 North Wacker Drive   Chicago IL 60606
2398 1972-12-27 1990-06-14 Government of India Tourist Office, Chicago   5701 North Sheridan Road   Chicago IL 60660
2420 1973-05-01 1973-11-01 Quarnstrom, Gordon M.   1726 Wilmette Avenue   Wilmette IL 60091
2446 1973-08-09 1989-04-28 Romanian Foreign Trade Promotion Office, Chicago   105 West Madison Street   Chicago IL 60602
2448 1973-08-09 2003-11-15 Mexico Tourism Board   225 North Michigan Avenue Suite 1850 Chicago IL 60601-3715
2457 1973-09-04 1993-10-20 Austrian National Tourist Office, Midwest Office   500 North Michigan Avenue Suite 1950 Chicago IL 60611
2459 1973-09-12 1986-09-12 Imported Publications, Inc.   Post Office Box 618101   Chicago IL 60661-8101
2461 1973-09-12 1974-02-01 Mayer & O'Brien, Inc.   333 North Michigan Avenue   Chicago IL 60601
2572 1975-04-07 1997-04-07 Aaron D. Cushman & Associates, Inc.   35 East Wacker Drive Suite 850 Chicago IL 60601
2638 1975-12-10 1993-12-10 Film Comm, Inc. FILMCOMM/Audience Planners 641 North Avenue   Glendale Heights IL 60139
2648 1975-12-31 1996-12-31 Korea Trade Center, Chicago   111 East Wacker Drive Suite 2229 Chicago IL 60601
2695 1976-06-08 1976-06-08 Thomas H. Miner & Associates, Inc.   135 South LaSalle Street   Chicago IL 60603
2698 1976-06-15 1992-11-23 International Marketing Center, Ltd.   601 Skokie Boulevard Suite 204 Northbrook IL 60062
2749 1977-01-26 1979-12-03 Szygowski, Julius   138 Custer Avenue   Evanston IL 60202
2849 1977-11-25 1978-05-30 Grimstad, William N.   Box 141A   Princevill IL 61559
2889 1978-04-20 1989-03-27 Liu, Henry H.C.   333 North Michigan Avenue Suite 2329 Chicago IL 60601
2911 1978-06-08 2002-05-29 Far East Trade Service, Inc., Chicago Taiwan Trade Center-Chicago 225 North Michigan Avenue Suite 1888 Chicago IL 60601
2917 1978-06-16 1978-10-31 PRM Corporation   919 North Michigan Avenue   Chicago IL 60611
2999 1979-02-15 1983-12-30 Dellow, Reginald L.   845 North Michigan Avenue Suite 903-E Chicago IL 60611
3069 1979-11-23 2011-01-31 Korea National Tourism Organization, Chicago   737 North Michigan Avenue Suite 910 Chicago IL 60611
3127 1980-07-25 1981-08-27 Bentley, Barnes & Lynn, Inc.   303 East Ohio Street   Chicago IL 60611
3232 1981-04-23 1985-11-08 Morocco Government Tourist Office   408 South Michigan Avenue   Chicago IL 60605
3360 1982-04-21 1994-10-21 Polish National Tourist Office, Chicago   333 North Michigan Avenue Suite 228 Chicago IL 60601
3455 1983-03-31 1988-12-31 A.M.K. Berlin   104 North Michigan Avenue Suite 1200 Chicago IL 60601
3476 1983-05-25 2000-11-25 One NorthEast   Meadows Corporate Center 2850 West Golf Road, Suite 401 Rolling Meadows IL 60008-4033
3507 1983-08-10 1986-03-07 Mandaback & Simms, Inc.   111 North Canal Street   Chicago IL 60606
3532 1983-10-25 1991-04-25 Piero Ottinetti Design   1034 North Sheridan Road   Waukegan IL 60085-2054
3634 1984-11-15   Daniel J. Edelman, Inc.   111 North Canal Street Suite 1100 Chicago IL 60606
3668 1985-04-08 1990-07-31 Miluski, Krystine R.L.   Post Office Box 714 Hidden Hills Trail West Dundee IL 60118-0714
3799 1986-03-19 1992-12-07 Derus Media Service, Inc.   500 North Dearborn Street   Chicago IL 60610
3819 1986-04-24 2006-03-31 Welsh Development Agency   191 North Wacker Drive Suite 1685 Chicago IL 60606
3823 1986-05-01 1987-05-29 Drotning, Phillip T.   360 East Randolph Drive   Chicago IL 60601
3842 1986-06-09 1987-12-09 Chicago Committee for Progressive Democrats of Ireland   C/O Holiday Inn of Oak Lawn 4140 West 95th Street Oak Lawn IL 60453
3844 1986-06-16 2011-06-30 North of England   444 N. Michigan Avenue Suite 411 Chicago IL 60611
3949 1987-03-18 1993-09-07 Golin/Harris Communications, Inc.   500 North Michigan Avenue   Chicago IL 60611
4101 1988-03-17 1989-10-10 Hopkins & Sutter   3 First National Plaza   Chicago IL 60602
4108 1988-03-25 1989-12-31 Rothschild, Mary Kathleen   165 Church Road   Winnetka IL 60093
4159 1988-07-13 1989-01-13 Chicago Committee for Progressive Democrats of Ireland   C/O Holiday Inn of Oak Lawn 4140 West 95th Street Oak Lawn IL 60453
4271 1989-07-17 1993-06-29 Mozambique Solidarity Office   343 South Dearborn Suite 300 Chicago IL 60604
4289 1989-09-12 1993-05-04 Jasculca/Terman & Associates, Inc.   730 North Franklin Street Suite 150 Chicago IL 60610
4351 1990-03-16 1990-10-30 Neuman, Williams, Anderson & Olson   77 West Washington Street   Chicago IL 60602
4364 1990-04-13   Invest Northern Ireland   2201 Waukegan Road Suite 150 South Bannockburn IL 60015
4430 1990-11-05 1992-08-25 Ruder Finn, Inc.   444 North Michigan Avenue Suite 1600 Chicago IL 60611
4451 1990-12-19 1993-09-27 IBUSZ Hungarian Travel Company, Midwest Office   233 North Michigan Avenue Suite 1308 Chicago IL 60601
4622 1992-02-21 1998-05-30 Tourism Authority of Thailand, Chicago   303 East Wacker Drive Suite 400 Chicago IL 60601
4670 1992-05-20 1992-07-31 Redex Packaging Corporation   5050 Newport Drive Section 7 Rolling Meadows IL 60008

Next page

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])
);