FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where City = "New York" and "Short_Form_Termination_Date" is on date 2004-06-30
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Short_Form_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21493 | 21493 | 2004-06-30 | 2001-02-02 | Bernard | Anne | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21494 | 21494 | 2004-06-30 | 2003-02-03 | Marquis | Eric | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21495 | 21495 | 2004-06-30 | 2002-02-04 | Lymburner | Benoit B. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21496 | 21496 | 2004-06-30 | 2001-02-26 | Nevell | Bill | Parter International, Inc. 5260 | 1998-06-05 | Parter International, Inc. | 135 West 50th Street | 21st Floor | New York | NY | 10020-1201 |
21498 | 21498 | 2004-06-30 | 2001-04-09 | Eberhard | Urs | Alpine Tourist Office 2052 | 1967-09-27 | Alpine Tourist Office | C/O Austrian Tourist Office, Inc. | 608 Fifth Avenue | New York | NY | 10020 |
21500 | 21500 | 2004-06-30 | 2004-05-20 | Moeng | Nicodemus Solly | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
21501 | 21501 | 2004-06-30 | 1998-06-05 | Mancini | Elaine | Parter International, Inc. 5260 | 1998-06-05 | Parter International, Inc. | 135 West 50th Street | 21st Floor | New York | NY | 10020-1201 |
21502 | 21502 | 2004-06-30 | 1998-06-05 | Parter | Alan S. | Parter International, Inc. 5260 | 1998-06-05 | Parter International, Inc. | 135 West 50th Street | 21st Floor | New York | NY | 10020-1201 |
21503 | 21503 | 2004-06-30 | 2000-07-18 | Eberhard | Urs | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
21505 | 21505 | 2004-06-30 | 2002-07-26 | Walsh | John | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
21506 | 21506 | 2004-06-30 | 2004-07-26 | Krishnam | Murali | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
21507 | 21507 | 2004-06-30 | 2004-07-26 | Kuczkowski | Michael | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
21508 | 21508 | 2004-06-30 | 2003-09-05 | Hansen | Hege Vibeke | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
21510 | 21510 | 2004-06-30 | 2004-10-06 | White | Mark | Parter International, Inc. 5260 | 1998-06-05 | Parter International, Inc. | 135 West 50th Street | 21st Floor | New York | NY | 10020-1201 |
21511 | 21511 | 2004-06-30 | 2000-10-17 | Saintonge | Jean | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21512 | 21512 | 2004-06-30 | 2001-10-17 | Fujikawa | Hidehiko | NHK Cosmomedia America, Inc. 4490 | 1991-03-26 | NHK Cosmomedia America, Inc. | 100 Broadway | 15th Floor | New York | NY | 10005-1983 |
21515 | 21515 | 2004-06-30 | 2003-12-30 | Beh | Kian Teik | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
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]) );