FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Short_Form_Date" is on date 1986-12-03
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 7
Registrant_Name 7
City 6
- Washington 3
- Alexandria 1
- Los Angeles 1
- Mayaguez 1
- McLean 1
- New York 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2659 | 2659 | 1987-01-01 | 1986-12-03 | Grayson | Mark E. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
4488 | 4488 | 1994-01-25 | 1986-12-03 | Rubel | Eric A. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
6958 | 6958 | 1998-02-15 | 1986-12-03 | Saleh | Salim Amin | Indonesia Tourist Promotion Office for North America 2757 | 1977-02-15 | Indonesia Tourist Promotion Office for North America | 3457 Wilshire Boulevard | Los Angeles | CA | 90010-2203 | |
12782 | 12782 | 1990-04-05 | 1986-12-03 | Thompson | Richard K. | United International Consultants 3701 | 1985-07-10 | United International Consultants | 1800 Diagonal Road | Suite 665 | Alexandria | VA | 22314 |
21077 | 21077 | 1987-06-30 | 1986-12-03 | Blizen | Jerald | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
21108 | 21108 | 1988-06-30 | 1986-12-03 | Takatori | Naoki | JETRO, Puerto Rico 2468 | 1973-10-23 | JETRO, Puerto Rico | Calle Cruz #3 Urb. | Bellas Lomas, Miradero | Mayaguez | PR | 00708 |
22192 | 22192 | 1989-07-01 | 1986-12-03 | Komine | Yutaka | Japan Tobacco, Inc. 3568 | 1984-03-13 | Japan Tobacco, Inc. | 1207 Pine Hill Road | McLean | VA | 22101 | |
29411 | 29411 | 1987-09-08 | 1986-12-03 | Tanaka | Ichiro | East Asia Travel Association 2423 | 1973-05-07 | East Asia Travel Association | C/O Tourism Auth. of Thailand | 304 Park Avenue South, 8th Floor | New York | NY | 10010 |
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]) );