FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where "Short_Form_Termination_Date" is on date 1991-03-31
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 13
- Carmen Group, Inc. 3
- Porter, Wright, Morris & Arthur 3
- Government of Ontario, Canada 2
- Ball, Janik & Novack 2
- CEDOK Czechoslovak Travel Bureau 1
- German-American Chamber of Commerce of Chicago 1
- JETRO, Puerto Rico 1
- Korea Trade Center, Los Angeles 1
- Korea Trade Center, Chicago 1
- Korea Trade Center, Miami 1
- Japan Tobacco, Inc. 1
- Crowell & Moring International, LLC 1
- Belin, Harris, Helmick, Lamson, McCormick, P.C. 1
Registrant_Name 13
- Carmen Group, Inc. 3
- Porter, Wright, Morris & Arthur 3
- Ball, Janik & Novack 2
- Government of Ontario, Canada 2
- Belin, Harris, Helmick, Lamson, McCormick, P.C. 1
- CEDOK Czechoslovak Travel Bureau 1
- Crowell & Moring International, LLC 1
- German-American Chamber of Commerce of Chicago 1
- JETRO, Puerto Rico 1
- Japan Tobacco, Inc. 1
- Korea Trade Center, Chicago 1
- Korea Trade Center, Los Angeles 1
- Korea Trade Center, Miami 1
City 9
- Washington 7
- New York 3
- Chicago 2
- Portland 2
- Des Moines 1
- Los Angeles 1
- Mayaguez 1
- McLean 1
- Miami 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11636 | 11636 | 1991-03-31 | 1989-01-12 | Frense | Hans Joachim | German-American Chamber of Commerce of Chicago 1878 | 1965-04-06 | German-American Chamber of Commerce of Chicago | 104 South Michigan Avenue | Suite 600 | Chicago | IL | 606035978 |
11637 | 11637 | 1991-03-31 | 1991-02-28 | Helmick | Robert H. | Belin, Harris, Helmick, Lamson, McCormick, P.C. 4478 | 1991-02-28 | Belin, Harris, Helmick, Lamson, McCormick, P.C. | 2000 Financial Center | Des Moines | IA | 50309 | |
11638 | 11638 | 1991-03-31 | 1989-03-20 | Carmen | David M. | Carmen Group, Inc. 4233 | 1989-03-20 | Carmen Group, Inc. | 2100 Pennsylvania Avenue, N.W. | Suite 365 | Washington | DC | 20037 |
11639 | 11639 | 1991-03-31 | 1989-03-28 | Beall | James A. | Ball, Janik & Novack 4230 | 1989-03-28 | Ball, Janik & Novack | 101 Southwest Main Street | Suite 1100 | Portland | OR | 97204 |
11640 | 11640 | 1991-03-31 | 1989-05-22 | Saito | Seiro | JETRO, Puerto Rico 2468 | 1973-10-23 | JETRO, Puerto Rico | Calle Cruz #3 Urb. | Bellas Lomas, Miradero | Mayaguez | PR | 00708 |
11641 | 11641 | 1991-03-31 | 1987-05-28 | Palmer | Claire A. (Nee Rickard) | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 |
11642 | 11642 | 1991-03-31 | 1989-06-16 | Cram | M. Victoria | Ball, Janik & Novack 4230 | 1989-03-28 | Ball, Janik & Novack | 101 Southwest Main Street | Suite 1100 | Portland | OR | 97204 |
11643 | 11643 | 1991-03-31 | 1985-07-19 | Gray | James H. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11644 | 11644 | 1991-03-31 | 1988-08-15 | Sysel | Jiri | CEDOK Czechoslovak Travel Bureau 1848 | 1965-02-01 | CEDOK Czechoslovak Travel Bureau | 10 East 40th Street | Suite 1902 | New York | NY | 10016 |
11645 | 11645 | 1991-03-31 | 1988-09-16 | Chung | Ho-won | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
11646 | 11646 | 1991-03-31 | 1990-09-19 | Glick | Leslie Alan | Porter, Wright, Morris & Arthur 4412 | 1990-09-19 | Porter, Wright, Morris & Arthur | 1233 - 20th Street, N.W. | Suite 400 | Washington | DC | 20036 |
11647 | 11647 | 1991-03-31 | 1990-09-19 | Kessler | Judd L. | Porter, Wright, Morris & Arthur 4412 | 1990-09-19 | Porter, Wright, Morris & Arthur | 1233 - 20th Street, N.W. | Suite 400 | Washington | DC | 20036 |
11648 | 11648 | 1991-03-31 | 1990-09-19 | Penny | Christopher | Porter, Wright, Morris & Arthur 4412 | 1990-09-19 | Porter, Wright, Morris & Arthur | 1233 - 20th Street, N.W. | Suite 400 | Washington | DC | 20036 |
11649 | 11649 | 1991-03-31 | 1985-10-03 | Hopkinson | John | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11650 | 11650 | 1991-03-31 | 1989-10-10 | Park | Eun Woo | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
11651 | 11651 | 1991-03-31 | 1989-10-13 | Asako | Seiichi | Japan Tobacco, Inc. 3568 | 1984-03-13 | Japan Tobacco, Inc. | 1207 Pine Hill Road | McLean | VA | 22101 | |
11652 | 11652 | 1991-03-31 | 1989-11-01 | Wortley | George C. | Carmen Group, Inc. 4233 | 1989-03-20 | Carmen Group, Inc. | 2100 Pennsylvania Avenue, N.W. | Suite 365 | Washington | DC | 20037 |
11653 | 11653 | 1991-03-31 | 1990-11-01 | Dierman | Roger C. | Carmen Group, Inc. 4233 | 1989-03-20 | Carmen Group, Inc. | 2100 Pennsylvania Avenue, N.W. | Suite 365 | Washington | DC | 20037 |
11654 | 11654 | 1991-03-31 | 1988-11-07 | Han | Sun Hee | Korea Trade Center, Miami 2758 | 1977-02-28 | Korea Trade Center, Miami | One Biscayne Tower | Suite 1620 | Miami | FL | 33131 |
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]) );