FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Short_Form_Termination_Date" is on date 1994-02-14
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Zip
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6819 | 6819 | 1994-02-14 | 1991-01-18 | Varin | Robert Louis | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
6820 | 6820 | 1994-02-14 | 1992-01-30 | Cardinal | Laurent | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
6821 | 6821 | 1994-02-14 | 1992-01-30 | Lavigne | Rachel | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
6822 | 6822 | 1994-02-14 | 1992-02-13 | Euachongprasit | Santichai | ASEAN Promotional Chapter for Tourism - North America 2744 | 1977-01-04 | ASEAN Promotional Chapter for Tourism - North America | c/o Tourism Authority of Thailand | 611 North Larchmont Blvd., 1st Floor | Los Angeles | CA | 90004 |
6823 | 6823 | 1994-02-14 | 1991-07-18 | Walker | Lynda K. | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | 1455 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20004 |
6824 | 6824 | 1994-02-14 | 1991-07-29 | Proulx | Rejean Pierre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
6825 | 6825 | 1994-02-14 | 1990-07-31 | Downing | Kevin R. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
6826 | 6826 | 1994-02-14 | 1988-08-01 | Brimmer | Jenefer | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
6827 | 6827 | 1994-02-14 | 1990-08-03 | Ohashi | Koshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6828 | 6828 | 1994-02-14 | 1989-08-04 | Cloutier | Michel | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
6829 | 6829 | 1994-02-14 | 1989-08-14 | Ito | Kunio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6830 | 6830 | 1994-02-14 | 1993-09-16 | Bissonette | Ann-Marie | Samuels International Associates, Inc. 4848 | 1993-08-26 | Samuels International Associates, Inc. | 1140 Connecticut Avenue, N.W. | Suite 950 | Washington | DC | 20036 |
6831 | 6831 | 1994-02-14 | 1990-11-15 | Davies | Brian | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
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]) );