FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Short_Form_Termination_Date" is on date 1988-07-31 sorted by Address_1
This data as json, CSV (advanced)
Registration_Number 11
- Korea Trade Center, Los Angeles 3
- Bahamas Tourist Office 2
- U.S.-Japan Dialogue of the Year 2001 Committee 2
- Sveriges Television AB (Swedish Broadcasting Corporation) 1
- International Public Relations Company, Ltd. 1
- St. Lucia Tourism Authority 1
- White & Case, LLP 1
- Pierson, Semmes & Bemis 1
- Harris/Ragan Management Corporation 1
- Hill and Knowlton Strategies, LLC 1
- Jefferson Group, Inc. 1
Registrant_Name 11
- Korea Trade Center, Los Angeles 3
- Bahamas Tourist Office 2
- U.S.-Japan Dialogue of the Year 2001 Committee 2
- Harris/Ragan Management Corporation 1
- Hill and Knowlton Strategies, LLC 1
- International Public Relations Company, Ltd. 1
- Jefferson Group, Inc. 1
- Pierson, Semmes & Bemis 1
- St. Lucia Tourism Authority 1
- Sveriges Television AB (Swedish Broadcasting Corporation) 1
- White & Case, LLP 1
City 4
- Washington 5
- Los Angeles 4
- New York 4
- Nassau 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24760 | 24760 | 1988-07-31 | 1979-01-17 | Olsen | Warren E. | Pierson, Semmes & Bemis 2988 | 1979-01-17 | Pierson, Semmes & Bemis | 1054 - 31st Street, N.W. | Suite 300 | Washington | DC | 20007 |
24765 | 24765 | 1988-07-31 | 1986-03-11 | Smith | Herbert J. , III | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
24771 | 24771 | 1988-07-31 | 1984-09-18 | Wetter | J. Gillis | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
24766 | 24766 | 1988-07-31 | 1988-05-11 | Ross | S. Beth | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | 1341 G Street, N.W. | Suite 1100 | Washington | DC | 20005 |
24772 | 24772 | 1988-07-31 | 1987-09-18 | Fowler | C. Grayson | U.S.-Japan Dialogue of the Year 2001 Committee 4039 | 1987-09-18 | U.S.-Japan Dialogue of the Year 2001 Committee | 2600 Virginia Avenue, N.W. | Suite 512 | Washington | DC | 20037 |
24773 | 24773 | 1988-07-31 | 1987-09-18 | Higuchi | Michiko | U.S.-Japan Dialogue of the Year 2001 Committee 4039 | 1987-09-18 | U.S.-Japan Dialogue of the Year 2001 Committee | 2600 Virginia Avenue, N.W. | Suite 512 | Washington | DC | 20037 |
24770 | 24770 | 1988-07-31 | 1987-08-17 | Virgintino | Michael R. | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | 352 Park Avenue, South | Suite 705 | New York | NY | 10010 |
24763 | 24763 | 1988-07-31 | 1982-02-25 | Kim | Myung Hee | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
24767 | 24767 | 1988-07-31 | 1986-06-13 | Koo | Ja Kul | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
24768 | 24768 | 1988-07-31 | 1986-06-13 | Lee | Jung Kyou | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
24762 | 24762 | 1988-07-31 | 1987-02-17 | Randell | Catherine | St. Lucia Tourism Authority 2668 | 1976-03-15 | St. Lucia Tourism Authority | 630 3rd Avenue | Suite 702 | New York | NY | 10017-4504 |
24761 | 24761 | 1988-07-31 | 1971-01-31 | Simonson | Britt | Sveriges Television AB (Swedish Broadcasting Corporation) 1676 | 1964-01-02 | Sveriges Television AB (Swedish Broadcasting Corporation) | 747 Third Avenue | New York | NY | 10017 | |
24769 | 24769 | 1988-07-31 | 1982-07-19 | Harris | Gregery J. | Harris/Ragan Management Corporation 3197 | 1981-02-11 | Harris/Ragan Management Corporation | 9200 Sunset Boulevard | Suite 404 | Los Angeles | CA | 90069 |
24764 | 24764 | 1988-07-31 | 1986-03-10 | Neustadt | Richard A. | Bahamas Tourist Office 2310 | 1972-01-27 | Bahamas Tourist Office | Ministry of Tourism | Post Office Box N-3701 | Nassau | ||
24774 | 24774 | 1988-07-31 | 1979-10-01 | Petschler | Julie Ann | Bahamas Tourist Office 2310 | 1972-01-27 | Bahamas Tourist Office | Ministry of Tourism | Post Office Box N-3701 | Nassau |
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]) );