FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Short_Form_Termination_Date" is on date 1986-03-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_2, Zip, Short_Form_Termination_Date (date)
Registration_Number 13
- Korea Trade Center, Los Angeles 2
- Switzerland Tourism 1
- German National Tourist Office 1
- Modern Education Services, Inc. 1
- Haiti Government Tourist Bureau 1
- Hong Kong Trade Development Council, Inc. 1
- National Federation of Coffee Growers of Colombia 1
- Beef + Lamb New Zealand, Ltd. 1
- Hill & Knowlton, Inc. 1
- Korea National Tourism Organization, Chicago 1
- Ablondi, Foster, Sobin & Davidow, P.C. 1
- Jones Day 1
- Milbank, Furia Samuels 1
Registrant_Name 13
- Korea Trade Center, Los Angeles 2
- Ablondi, Foster, Sobin & Davidow, P.C. 1
- Beef + Lamb New Zealand, Ltd. 1
- German National Tourist Office 1
- Haiti Government Tourist Bureau 1
- Hill & Knowlton, Inc. 1
- Hong Kong Trade Development Council, Inc. 1
- Jones Day 1
- Korea National Tourism Organization, Chicago 1
- Milbank, Furia Samuels 1
- Modern Education Services, Inc. 1
- National Federation of Coffee Growers of Colombia 1
- Switzerland Tourism 1
City 5
- New York 6
- Washington 4
- Los Angeles 2
- Chicago 1
- McLean 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11541 | 11541 | 1986-03-31 | 1978-01-23 | Carre | Gylda | Haiti Government Tourist Bureau 1901 | 1965-06-16 | Haiti Government Tourist Bureau | C/O Consulate General of Haiti | 271 Madison Avenue 17th Floor | New York | NY | 10017 |
11542 | 11542 | 1986-03-31 | 1986-01-23 | Shapiro | Isaac | Milbank, Furia Samuels 3837 | 1986-01-23 | Milbank, Furia Samuels | 1825 I Street, N.W. | Washington | DC | 20006 | |
11543 | 11543 | 1986-03-31 | 1986-02-05 | Almstedt | Kermit W. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
11544 | 11544 | 1986-03-31 | 1974-02-14 | Jones | Maurice Amos | Beef + Lamb New Zealand, Ltd. 2526 | 1974-07-08 | Beef + Lamb New Zealand, Ltd. | 6841 Elm Street | #7401 | McLean | VA | 22106 |
11545 | 11545 | 1986-03-31 | 1981-03-05 | Hearle | Douglas G. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
11546 | 11546 | 1986-03-31 | 1981-03-17 | Davenport | Luther M. | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
11547 | 11547 | 1986-03-31 | 1985-04-10 | Lee | Gahng Up | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
11548 | 11548 | 1986-03-31 | 1979-05-09 | Steward | R. Bradley | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | 1015 - 18th Street, N.W. | Suite 704 | Washington | DC | 20036 |
11549 | 11549 | 1986-03-31 | 1984-06-07 | McCarthy | Pamela A. | Ablondi, Foster, Sobin & Davidow, P.C. 3235 | 1981-05-04 | Ablondi, Foster, Sobin & Davidow, P.C. | 1150 18th Street, N.W. | Suite 900 | Washington | DC | 20036-4129 |
11550 | 11550 | 1986-03-31 | 1974-06-10 | Soto | Enrique | National Federation of Coffee Growers of Colombia 2519 | 1974-06-10 | National Federation of Coffee Growers of Colombia | 140 East 57th Street | New York | NY | 10022 | |
11551 | 11551 | 1986-03-31 | 1984-06-22 | Lee | Joun Shik | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
11552 | 11552 | 1986-03-31 | 1975-08-01 | Blaettermann | Knut Helge | German National Tourist Office 616 | 1950-02-28 | German National Tourist Office | 1350 Broadway | Suite 440 | New York | NY | 10018 |
11553 | 11553 | 1986-03-31 | 1982-09-17 | Fragniere | Marcel | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
11554 | 11554 | 1986-03-31 | 1982-12-28 | Ahn | Kwang Charn | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
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]) );