FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Termination_Date" is on date 1984-10-31
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Date (date)
Registration_Number 10
- Korea Trade Center, Seattle 2
- Bermuda Tourism Authority 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Hong Kong Trade Development Council, Inc. 1
- Doremus & Company 1
- Mexican Government Tourism Office, Denver 1
- Korea National Tourism Organization, New Jersey 1
- Hill & Knowlton, Inc. 1
- Korea Trade Center, Detroit 1
- McDermott, Will & Emery 1
Registrant_Name 10
- Korea Trade Center, Seattle 2
- Bermuda Tourism Authority 1
- Doremus & Company 1
- Hill & Knowlton, Inc. 1
- Hong Kong Trade Development Council, Inc. 1
- Korea National Tourism Organization, New Jersey 1
- Korea Trade Center, Detroit 1
- McDermott, Will & Emery 1
- Mexican Government Tourism Office, Denver 1
- Squire, Sanders & Dempsey, L.L.P. 1
City 6
- New York 4
- Seattle 2
- Washington 2
- Denver 1
- Fort Lee 1
- Southfield 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34242 | 34242 | 1984-10-31 | 1973-01-29 | Day | J. Edward | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
34243 | 34243 | 1984-10-31 | 1982-02-22 | Choy | Francis Chi Kwong | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
34244 | 34244 | 1984-10-31 | 1981-03-25 | Millman | Ronald B. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
34245 | 34245 | 1984-10-31 | 1972-07-25 | Ryan | Thelma A. | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
34246 | 34246 | 1984-10-31 | 1984-07-30 | Chung | Jae W. | Korea Trade Center, Seattle 2495 | 1974-02-19 | Korea Trade Center, Seattle | Bank of California Center | Suite 1245 | Seattle | WA | 98164 |
34247 | 34247 | 1984-10-31 | 1983-08-23 | Blatchford | John T. | Korea Trade Center, Seattle 2495 | 1974-02-19 | Korea Trade Center, Seattle | Bank of California Center | Suite 1245 | Seattle | WA | 98164 |
34248 | 34248 | 1984-10-31 | 1979-10-01 | Bayardo | Francisco | Mexican Government Tourism Office, Denver 2455 | 1973-08-24 | Mexican Government Tourism Office, Denver | 425 South Cherry Street | Suite 640 | Denver | CO | 80222 |
34249 | 34249 | 1984-10-31 | 1984-10-18 | Kim | Yong-ii | Korea National Tourism Organization, New Jersey 2614 | 1975-10-04 | Korea National Tourism Organization, New Jersey | 400 Kelby Street | Suite 1602 | Fort Lee | NJ | 07024 |
34250 | 34250 | 1984-10-31 | 1984-11-06 | Park | Hoon Pyung | Korea Trade Center, Detroit 3016 | 1979-05-04 | Korea Trade Center, Detroit | 3000 Town Center | Suite L-111 | Southfield | MI | 48075 |
34251 | 34251 | 1984-10-31 | 1983-11-07 | Murphy | Terence Roche | McDermott, Will & Emery 3533 | 1983-10-28 | McDermott, Will & Emery | 1850 K Street, N.W. | Suite 500 | Washington | DC | 20006 |
34252 | 34252 | 1984-10-31 | 1983-12-02 | Boland | John | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 |
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]) );