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

110 rows where City = "Chicago"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 2

City 1

  • Chicago · 110 ✖
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  
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  
1105 1958-01-14 1958-07-14 Vazquez, Jose Infanzon   4006 North Sheridan Road   Chicago 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  
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
2108 1968-10-17 1970-10-20 Madrazo, Jesse Miravete   808 West Junior Terrace   Chicago    
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
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
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
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
3507 1983-08-10 1986-03-07 Mandaback & Simms, Inc.   111 North Canal Street   Chicago IL 60606
3634 1984-11-15   Daniel J. Edelman, Inc.   111 North Canal Street Suite 1100 Chicago IL 60606
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
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
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
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
4837 1993-08-03 1996-02-28 Dickens & Webster   2124 North Sedgwick   Chicago IL 60614
4941 1993-08-16 1996-02-28 J.H.S. Group, Inc.   150 North Michigan Avenue Suite 2025 Chicago IL 60601-2916
5067 1995-11-07 2002-11-30 Mayeroff, Jerry M. Mayeroff & Associates 2724 West Coyle Avenue   Chicago IL 60645-3018
5229 1992-05-22 1992-12-31 Deborah Gordon Public Relations   180 North Michigan Avenue   Chicago IL 60601
5547 2003-03-24 2003-12-31 Baker & McKenzie, LLP   One Prudential Plaza 130 East Randolph Drive Chicago IL 60601
5558 2003-04-24 2004-04-30 Imnex International, Inc.   222 Merchandise Mart Suite 1540 Chicago IL 60654
5933 2009-04-27 2010-04-30 Advanced Practical Solutions, LLC   222 South Riverside Plaza 29th Floor Chicago IL 60606
5940 2009-05-29 2010-04-30 Prairie Avenue Advisors, LLC   430 North Michigan Avenue Suite 200 Chicago IL 60611
5979 2010-03-12 2012-11-30 City of Osaka, Chicago Office   200 E. Randolph Street Suite 2200 Chicago IL 60601
6047 2011-06-30 2011-11-30 Whitfield, Charles Brandon   1112 N. Ashland Avenue #2F   Chicago IL 60622
6070 2011-10-15 2012-09-29 Strategic Partnership Alliance, Ltd.   120 N LaSalle Street Suite 2600 Chicago IL 60602
6098 2012-04-26 2012-04-26 Quintairos, Prieto, Wood & Boyer, P.A.   Two Prudential Plaza 180 N. Stetson Avenue, Suite 4525 Chicago IL 60601
6175 2013-06-12 2014-03-31 Martin, Michelle E.   400 N. McClurg Ct. #2707 Chicago IL 60611
6193 2013-11-04 2021-09-30 Austrian Trade Commission, Chicago   500 N. Michigan Avenue Suite 1950 Chicago IL 60611
6196 2013-11-18 2014-05-27 Tur Partners, LLC   900 N. Michigan Avenue Suite 1720 Chicago IL 60611
6296 2015-05-21 2015-09-25 Golin/Harris International, Inc.   875 North Michigan Avenue   Chicago IL 60611

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