FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1,478 rows where City = "Chicago" sorted by Short_Form_Termination_Date
This data as json, CSV (advanced)
Registration_Number >30
- Daniel J. Edelman, Inc. 502
- JETRO, Chicago 193
- Zeno Group, Inc. 57
- Korea National Tourism Organization, Chicago 35
- Welsh Development Agency 31
- Aaron D. Cushman & Associates, Inc. 30
- Kivvit, LLC 28
- Malaysian Industrial Development Authority 27
- Far East Trade Service, Inc., Chicago 27
- Korea Trade Center, Chicago 25
- Central Parcel Service, Inc. 23
- Japan National Tourist Organization, Chicago 22
- Collegial Society of Hungarian Veterans in the U.S.A. 21
- Austrian Trade Commissioner in the U.S., Chicago 20
- Jamaica Tourist Board, Chicago 20
- Caples Company 19
- Italian Government Travel Office, Chicago 19
- Julius Klein Public Relations 17
- North of England 17
- Golin/Harris Communications, Inc. 17
- Mexican Chamber of Commerce, Inc., Chicago 16
- Jasculca/Terman & Associates, Inc. 12
- NRW.INVEST (NORTH AMERICA) LLC 9
- Grant Advertising, Inc. 8
- Mexico Tourism Board 8
- Nineveh Plain Defense Fund 8
- Beveridge, Kraus, Robbins & Manning, Inc. 7
- Government of India Tourist Office, Chicago 6
- Romanian Foreign Trade Promotion Office, Chicago 6
- Austrian National Tourist Office, Midwest Office 6
- …
Registrant_Name >30
- Daniel J. Edelman, Inc. 502
- JETRO, Chicago 193
- Zeno Group, Inc. 57
- Korea National Tourism Organization, Chicago 35
- Welsh Development Agency 31
- Aaron D. Cushman & Associates, Inc. 30
- Kivvit, LLC 28
- Far East Trade Service, Inc., Chicago 27
- Malaysian Industrial Development Authority 27
- Korea Trade Center, Chicago 25
- Central Parcel Service, Inc. 23
- Japan National Tourist Organization, Chicago 22
- Collegial Society of Hungarian Veterans in the U.S.A. 21
- Austrian Trade Commissioner in the U.S., Chicago 20
- Jamaica Tourist Board, Chicago 20
- Caples Company 19
- Italian Government Travel Office, Chicago 19
- Golin/Harris Communications, Inc. 17
- Julius Klein Public Relations 17
- North of England 17
- Mexican Chamber of Commerce, Inc., Chicago 16
- Jasculca/Terman & Associates, Inc. 12
- NRW.INVEST (NORTH AMERICA) LLC 9
- Grant Advertising, Inc. 8
- Mexico Tourism Board 8
- Nineveh Plain Defense Fund 8
- Beveridge, Kraus, Robbins & Manning, Inc. 7
- Austrian National Tourist Office, Midwest Office 6
- Government of India Tourist Office, Chicago 6
- Romanian Foreign Trade Promotion Office, Chicago 6
- …
State 1
- IL 1,378
City 1
- Chicago · 1,378 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1780 | 1780 | 2022-09-14 | Edelman | Richard | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
1783 | 1783 | 2022-09-14 | Harris | Lauren | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
1817 | 1817 | 2022-09-21 | Kawakaki | Takehiko | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1818 | 1818 | 2022-09-21 | Nemoto | Hiroyuki | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1819 | 1819 | 2022-09-21 | Togashi | Tatsuya | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1824 | 1824 | 2021-09-22 | Dueren | Daniel | NRW.INVEST (NORTH AMERICA) LLC 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | 150 North Michigan Avenue | Suite 2940 | Chicago | IL | 60601 | |
1825 | 1825 | 2021-09-22 | Rose | Joerg | NRW.INVEST (NORTH AMERICA) LLC 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | 150 North Michigan Avenue | Suite 2940 | Chicago | IL | 60601 | |
1833 | 1833 | 2019-09-23 | Buehler | Kai | NRW.INVEST (NORTH AMERICA) LLC 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | 150 North Michigan Avenue | Suite 2940 | Chicago | IL | 60601 | |
1857 | 1857 | 2019-09-27 | Platz | Eva | NRW.INVEST (NORTH AMERICA) LLC 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | 150 North Michigan Avenue | Suite 2940 | Chicago | IL | 60601 | |
1916 | 1916 | 2021-10-07 | Lehner | Tyler Joseph | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
1953 | 1953 | 2022-10-13 | Hershey | Isabella Rane | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
1960 | 1960 | 2022-10-14 | Hakimi | Nicole | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
1977 | 1977 | 2019-10-17 | Neary | Sean | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
1986 | 1986 | 2022-10-19 | Rittenberry | Jordan | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
2025 | 2025 | 2019-10-24 | Salazar | Mia | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
2052 | 2052 | 2019-10-28 | Blodgett | John Monroe | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
2106 | 2106 | 2022-11-03 | Albin | Daniela | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
2107 | 2107 | 2022-11-03 | Brown | Christina | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
2108 | 2108 | 2022-11-03 | Rudorf | Hanna | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
2135 | 2135 | 2022-11-10 | Solu | Cameron | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
2178 | 2178 | 2022-11-17 | Silva | Luis Felipe Betancourt | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
2322 | 2322 | 2020-12-01 | Loyd | Weston Yates | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
2377 | 2377 | 2022-12-09 | Carroll | Natasha | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
2378 | 2378 | 2022-12-09 | Derose | Ross | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
2401 | 2401 | 2022-12-14 | Wales | Alexandra | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
2435 | 2435 | 2022-12-19 | Casanova | Stephanie Chaney | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
2447 | 2447 | 2022-12-21 | Willner | Sean Thomas | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
30783 | 30783 | 1945-09-30 | 1945-06-08 | LaChance | Thomas E. | College Film Center 304 | 1945-06-08 | College Film Center | 84 East Randolph Street | Chicago | IL | ||
34789 | 34789 | 1946-11-01 | 1944-10-12 | Casillas | Vincent S. | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
7416 | 7416 | 1947-02-23 | 1946-08-23 | Foster | William John , Jr. | Shaheen & White, Inc. 369 | 1946-08-23 | Shaheen & White, Inc. | 33 North LaSalle Street | Chicago | IL | ||
7417 | 7417 | 1947-02-23 | 1946-08-23 | Shaheen | John Michael | Shaheen & White, Inc. 369 | 1946-08-23 | Shaheen & White, Inc. | 33 North LaSalle Street | Chicago | IL | ||
7418 | 7418 | 1947-02-23 | 1946-08-23 | White | Roger Quincy | Shaheen & White, Inc. 369 | 1946-08-23 | Shaheen & White, Inc. | 33 North LaSalle Street | Chicago | IL | ||
9594 | 9594 | 1948-03-11 | 1946-03-20 | Pichardo | Santiago | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9595 | 9595 | 1948-03-11 | 1946-03-20 | Wideman | Thelmas B. | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9596 | 9596 | 1948-03-11 | 1946-07-13 | Arroyo | David Angel | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9597 | 9597 | 1948-03-11 | 1946-07-13 | Brown | Paul Wayne | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9598 | 9598 | 1948-03-11 | 1946-07-13 | Glaser | Leon S. | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9599 | 9599 | 1948-03-11 | 1946-07-13 | Goldstone | Joe | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9600 | 9600 | 1948-03-11 | 1946-07-13 | Page | William | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9601 | 9601 | 1948-03-11 | 1946-07-13 | Scanlan | Frank T. (Pancho) | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9602 | 9602 | 1948-03-11 | 1946-07-13 | Williford | Oliver Joseph , Jr. | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9603 | 9603 | 1948-03-11 | 1944-10-12 | Baker | Russell | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9604 | 9604 | 1948-03-11 | 1944-10-12 | Capdevielle | Fernando F. | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9605 | 9605 | 1948-03-11 | 1944-10-12 | Ingram | George Daniel | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9606 | 9606 | 1948-03-11 | 1944-10-12 | Macias | Luis Gomez | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9607 | 9607 | 1948-03-11 | 1944-10-12 | Neuert | Hans | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
9608 | 9608 | 1948-03-11 | 1944-10-12 | Woolf | Elias B. | Mexican Chamber of Commerce, Inc., Chicago 278 | 1944-09-11 | Mexican Chamber of Commerce, Inc., Chicago | 201 North Wells Street | Chicago | IL | ||
22662 | 22662 | 1949-07-07 | 1949-07-07 | Rasmussen | Vagn Jul Moller | Danish Society 578 | 1949-07-07 | Danish Society | 2057 North Keystone Avenue | Chicago | IL | ||
32540 | 32540 | 1952-10-10 | 1947-07-31 | Orlowsky | Minnie Z. | Central Parcel Service, Inc. 483 | 1947-07-31 | Central Parcel Service, Inc. | 220 South State Street | Chicago | IL | 60604 | |
27833 | 27833 | 1953-08-31 | 1948-08-25 | Jacobson | Morton John | Central Parcel Service, Inc. 483 | 1947-07-31 | Central Parcel Service, Inc. | 220 South State Street | Chicago | IL | 60604 | |
34004 | 34004 | 1957-10-30 | 1956-02-27 | Kassner | Barbara | Austrian Trade Commissioner in the U.S., Chicago 874 | 1955-02-21 | Austrian Trade Commissioner in the U.S., Chicago | 500 North Michigan Avenue | Suite 1950 | Chicago | IL | 60611 |
39635 | 39635 | 1957-12-31 | 1957-10-30 | Fruehauf | Walter A. | Globe Travel Service 1075 | 1957-10-30 | Globe Travel Service | 127 North Dearborn Street | Chicago | IL | ||
12369 | 12369 | 1958-04-01 | 1958-01-14 | Montano | Hector | Vazquez, Jose Infanzon 1105 | 1958-01-14 | Vazquez, Jose Infanzon | 4006 North Sheridan Road | Chicago | IL | ||
19008 | 19008 | 1958-06-07 | 1958-01-14 | Infanzon | Jose | Vazquez, Jose Infanzon 1105 | 1958-01-14 | Vazquez, Jose Infanzon | 4006 North Sheridan Road | Chicago | IL | ||
19789 | 19789 | 1958-06-18 | 1958-06-18 | Hernandez | Serapio Montejo | Cuban Liberation Movement of July 26th 1150 | 1958-06-18 | Cuban Liberation Movement of July 26th | 3930 West Wilcox Avenue | Chicago | IL | ||
19790 | 19790 | 1958-06-18 | 1958-06-18 | Kangles | Constantine N. | Cuban Liberation Movement of July 26th 1150 | 1958-06-18 | Cuban Liberation Movement of July 26th | 3930 West Wilcox Avenue | Chicago | IL | ||
19791 | 19791 | 1958-06-18 | 1958-06-18 | Munoz | Rafael (Octanio Munoz Guide) | Cuban Liberation Movement of July 26th 1150 | 1958-06-18 | Cuban Liberation Movement of July 26th | 3930 West Wilcox Avenue | Chicago | IL | ||
19792 | 19792 | 1958-06-18 | 1958-06-18 | Oliva | Orestes Perez | Cuban Liberation Movement of July 26th 1150 | 1958-06-18 | Cuban Liberation Movement of July 26th | 3930 West Wilcox Avenue | Chicago | IL | ||
19793 | 19793 | 1958-06-18 | 1958-06-18 | Tablada | Rafael E. Silva | Cuban Liberation Movement of July 26th 1150 | 1958-06-18 | Cuban Liberation Movement of July 26th | 3930 West Wilcox Avenue | Chicago | IL | ||
23091 | 23091 | 1958-07-14 | 1958-01-14 | Ciordia | Leon Rafael | Vazquez, Jose Infanzon 1105 | 1958-01-14 | Vazquez, Jose Infanzon | 4006 North Sheridan Road | Chicago | IL | ||
23092 | 23092 | 1958-07-14 | 1958-01-14 | Infanzon | Rosa | Vazquez, Jose Infanzon 1105 | 1958-01-14 | Vazquez, Jose Infanzon | 4006 North Sheridan Road | Chicago | IL | ||
8627 | 8627 | 1959-03-01 | 1950-05-19 | Meyer | Hudson Fulton | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
7573 | 7573 | 1960-02-25 | 1959-08-27 | Dugan | John Charles | American Tourist Bureau, Inc., Chicago 1259 | 1959-08-27 | American Tourist Bureau, Inc., Chicago | 30 West Washington Street | Chicago | IL | ||
7574 | 7574 | 1960-02-25 | 1959-08-27 | Kaplinski | Vera | American Tourist Bureau, Inc., Chicago 1259 | 1959-08-27 | American Tourist Bureau, Inc., Chicago | 30 West Washington Street | Chicago | IL | ||
7575 | 7575 | 1960-02-25 | 1959-08-27 | Wiersma | John Willian | American Tourist Bureau, Inc., Chicago 1259 | 1959-08-27 | American Tourist Bureau, Inc., Chicago | 30 West Washington Street | Chicago | IL | ||
7576 | 7576 | 1960-02-25 | 1959-09-29 | Kaplinski | Alfons Florian | American Tourist Bureau, Inc., Chicago 1259 | 1959-08-27 | American Tourist Bureau, Inc., Chicago | 30 West Washington Street | Chicago | IL | ||
10094 | 10094 | 1960-03-17 | 1957-03-13 | Basta | Charles Joseph | Basta-Musil & Company, Inc. 1009 | 1957-03-13 | Basta-Musil & Company, Inc. | 3917-19 West 26th Street | Chicago | IL | ||
10095 | 10095 | 1960-03-17 | 1957-03-13 | Basta | Frank L. | Basta-Musil & Company, Inc. 1009 | 1957-03-13 | Basta-Musil & Company, Inc. | 3917-19 West 26th Street | Chicago | IL | ||
10096 | 10096 | 1960-03-17 | 1957-03-13 | Basta | George Charles | Basta-Musil & Company, Inc. 1009 | 1957-03-13 | Basta-Musil & Company, Inc. | 3917-19 West 26th Street | Chicago | IL | ||
10107 | 10107 | 1960-03-17 | 1957-10-14 | Basta | Frank J. | Basta-Musil & Company, Inc. 1009 | 1957-03-13 | Basta-Musil & Company, Inc. | 3917-19 West 26th Street | Chicago | IL | ||
10722 | 10722 | 1960-03-25 | 1957-06-27 | Matuszczak | Emilia | R. Matuszczak & Company, Travel Bureau, Inc. 1043 | 1957-06-27 | R. Matuszczak & Company, Travel Bureau, Inc. | 1143 North Milwaukee Avenue | Chicago | IL | ||
10723 | 10723 | 1960-03-25 | 1957-06-27 | Matuszczak | Richard | R. Matuszczak & Company, Travel Bureau, Inc. 1043 | 1957-06-27 | R. Matuszczak & Company, Travel Bureau, Inc. | 1143 North Milwaukee Avenue | Chicago | IL | ||
10724 | 10724 | 1960-03-25 | 1957-06-27 | Matuszczak | Romuald E. | R. Matuszczak & Company, Travel Bureau, Inc. 1043 | 1957-06-27 | R. Matuszczak & Company, Travel Bureau, Inc. | 1143 North Milwaukee Avenue | Chicago | IL | ||
15782 | 15782 | 1960-05-06 | 1959-12-14 | Migala | Barbara S. | Europe Travel Bureau, Inc. 1286 | 1959-10-12 | Europe Travel Bureau, Inc. | 1130 North California Avenue | Chicago | IL | ||
15783 | 15783 | 1960-05-06 | 1959-12-14 | Migala | Estelle | Europe Travel Bureau, Inc. 1286 | 1959-10-12 | Europe Travel Bureau, Inc. | 1130 North California Avenue | Chicago | IL | ||
15784 | 15784 | 1960-05-06 | 1959-12-14 | Migala | Joseph | Europe Travel Bureau, Inc. 1286 | 1959-10-12 | Europe Travel Bureau, Inc. | 1130 North California Avenue | Chicago | IL | ||
20063 | 20063 | 1960-06-23 | 1958-09-04 | Fruehauf | Marianne G. | Globe Travel Service 1075 | 1957-10-30 | Globe Travel Service | 127 North Dearborn Street | Chicago | IL | ||
20064 | 20064 | 1960-06-23 | 1958-09-04 | Lanctot | Raymond G. | Globe Travel Service 1075 | 1957-10-30 | Globe Travel Service | 127 North Dearborn Street | Chicago | IL | ||
22044 | 22044 | 1960-07-01 | 1960-08-03 | Cooksley | Ronald J. | Government of Ontario, Canada, Chicago 1383 | 1960-08-03 | Government of Ontario, Canada, Chicago | 11 East Adams | Room 705 | Chicago | IL | 60603 |
33181 | 33181 | 1960-10-19 | 1960-03-03 | Wolins | LeRoy | Rose, Rose 1228 | 1959-05-15 | Rose, Rose | 333 South Wacker Drive | Chicago | IL | ||
33182 | 33182 | 1960-10-19 | 1960-06-16 | Rose | Rose | Rose, Rose 1228 | 1959-05-15 | Rose, Rose | 333 South Wacker Drive | Chicago | IL | ||
33183 | 33183 | 1960-10-19 | 1959-09-21 | Hellie | Richard Jonathan | Rose, Rose 1228 | 1959-05-15 | Rose, Rose | 333 South Wacker Drive | Chicago | IL | ||
37244 | 37244 | 1960-12-01 | 1959-11-10 | Horvath | George | Collegial Society of Hungarian Veterans in the U.S.A. 920 | 1955-11-16 | Collegial Society of Hungarian Veterans in the U.S.A. | 1339 Howard Street | Chicago | IL | 60626 | |
6008 | 6008 | 1961-02-03 | 1960-01-25 | Richmond | Thomas Lloyd | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6009 | 6009 | 1961-02-03 | 1952-01-28 | Gannon | John | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6010 | 6010 | 1961-02-03 | 1953-02-10 | Kennedy | Thomas Peter | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6011 | 6011 | 1961-02-03 | 1953-02-10 | King | Henry Ward Ford | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6012 | 6012 | 1961-02-03 | 1943-03-03 | Hartsing | Ralph N. | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6013 | 6013 | 1961-02-03 | 1955-04-04 | Jaeger | Joyce Leslie Whiting | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6014 | 6014 | 1961-02-03 | 1950-05-19 | Cody | John McGee | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6015 | 6015 | 1961-02-03 | 1950-06-12 | Aspinall | Joseph | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6016 | 6016 | 1961-02-03 | 1950-06-12 | Kaiser | Gustav | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6017 | 6017 | 1961-02-03 | 1951-07-18 | Marsden | John Fowler | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6018 | 6018 | 1961-02-03 | 1953-07-20 | Davidson | DeWitt Sanger | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6019 | 6019 | 1961-02-03 | 1954-07-22 | Tery | Joseph Albert | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6020 | 6020 | 1961-02-03 | 1959-08-04 | Larner | William Clifford | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6021 | 6021 | 1961-02-03 | 1950-08-09 | Slattery | John Desmond | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6022 | 6022 | 1961-02-03 | 1955-08-16 | McLoud | Mary | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6023 | 6023 | 1961-02-03 | 1949-10-06 | Hartsing | M.P. | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL | ||
6024 | 6024 | 1961-02-03 | 1957-10-14 | Echelman | Elliott Jacob | Caples Company 34 | 1943-03-03 | Caples Company | 216 East Ontario Street | Chicago | IL |
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]) );