FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Short_Form_Termination_Date" is on date 1988-11-01
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Short_Form_Date (date)
Registration_Number 8
Registrant_Name 8
City 7
- Jacksonville 3
- Washington 2
- Anaheim 1
- Los Angeles 1
- New York 1
- New York 1
- Seattle 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34910 | 34910 | 1988-11-01 | 1985-01-31 | Bolann | Elin | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
34911 | 34911 | 1988-11-01 | 1986-02-04 | Tanaka | Ichiro | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
34912 | 34912 | 1988-11-01 | 1988-02-25 | Stephens | Amanda | Thompson & Company 4094 | 1988-02-25 | Thompson & Company | 1 Massachusetts Avenue, N.W. | Suite 330 | Washington | DC | 20001 |
34913 | 34913 | 1988-11-01 | 1975-02-28 | Boyle | Zoe Ann | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
34914 | 34914 | 1988-11-01 | 1986-04-03 | Lee | Chung Soo | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
34915 | 34915 | 1988-11-01 | 1980-05-12 | Haddad | Jeanne K. | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
34916 | 34916 | 1988-11-01 | 1983-05-20 | Zahler | Eric J. | Fried, Frank, Harris, Shriver & Jacobson 3473 | 1983-05-20 | Fried, Frank, Harris, Shriver & Jacobson | 1001 Pennsylvania Avenue, N.W. | Suite 800 | Washington | DC | 20004-2505 |
34917 | 34917 | 1988-11-01 | 1988-10-17 | Johnson | Jeanne | Productions by Hirahara 4099 | 1988-03-08 | Productions by Hirahara | Post Office Box 4581 | Anaheim | CA | 92803 | |
34918 | 34918 | 1988-11-01 | 1988-11-01 | Nichols | Todd C. | Francis & Nichols, Inc., P.S. 4186 | 1988-11-01 | Francis & Nichols, Inc., P.S. | 1600 Seattle Tower | 1218 Third Avenue | Seattle | WA | 98101 |
34919 | 34919 | 1988-11-01 | 1980-12-16 | Schillig | Roger E. | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
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]) );