FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "New York" and Short_Form_First_Name = "Andre"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 12
- Quebec Government Office 5
- Compagnie Generale Transatlantique (French Line) 1
- French Chamber of Commerce of the U.S., Inc. 1
- Boyer, Maurice 1
- French National Railroads, New York 1
- French Government Tourist Office 1
- France Forever, Inc. 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- European Travel Commission 1
- Belgo-American Development Corporation 1
- Needham, Harper & Steers Advertising, Inc. 1
- FCB New York 1
Registrant_Name 12
- Quebec Government Office 5
- Belgo-American Development Corporation 1
- Boyer, Maurice 1
- Compagnie Generale Transatlantique (French Line) 1
- European Travel Commission 1
- FCB New York 1
- France Forever, Inc. 1
- French Chamber of Commerce of the U.S., Inc. 1
- French Government Tourist Office 1
- French National Railroads, New York 1
- Needham, Harper & Steers Advertising, Inc. 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
State 1
- NY 16
City 1
- New York · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4265 | 4265 | 1985-01-22 | 1970-08-06 | Moraillon | Andre | French Government Tourist Office 364 | 1946-07-25 | French Government Tourist Office | 610 Fifth Avenue | New York | NY | 10020 | |
4841 | 4841 | 2004-01-30 | 2003-08-28 | Dalcourt | Andre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
5915 | 5915 | 1945-02-02 | 1943-12-16 | Koehn | Andre | Boyer, Maurice 177 | 1943-02-02 | Boyer, Maurice | 57 William Street | New York | NY | ||
9108 | 9108 | 1969-03-04 | 1967-08-03 | Jacques | Andre | Belgo-American Development Corporation 1501 | 1961-12-18 | Belgo-American Development Corporation | 605 Third Avenue | New York | NY | 10016 | |
11316 | 11316 | 1948-03-31 | 1948-12-23 | Mesnard | Andre | France Forever, Inc. 445 | 1947-03-14 | France Forever, Inc. | 122 West 50th Street | New York | NY | ||
16014 | 16014 | 1985-05-10 | 1982-02-02 | Migneault | Andre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
19507 | 19507 | 1970-06-15 | 1963-10-30 | Monzain | Andre | French National Railroads, New York 335 | 1945-12-26 | French National Railroads, New York | 610 Fifth Avenue | New York | NY | 10020 | |
20652 | 20652 | 1956-06-30 | 1946-10-21 | Quedec | Andre | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
23605 | 23605 | 1976-07-19 | 1971-09-20 | Haas | Andre | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
28747 | 28747 | 1960-09-01 | 1957-06-03 | Alphand | Andre | European Travel Commission 574 | 1949-06-30 | European Travel Commission | c/o Spring O'Brien | 30 West 26th Street, 4th Floor | New York | NY | 10010 |
29997 | 29997 | 2008-09-17 | 2006-09-13 | Prince | Andre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
30373 | 30373 | 1987-09-24 | 1981-05-21 | Boysen | Andre | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
30488 | 30488 | 1980-09-26 | 1974-02-05 | Dansereau | Andre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
34883 | 34883 | 1981-11-01 | 1981-09-25 | Smith | Andre | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
39802 | 39802 | 1966-12-31 | 1947-02-19 | Wick | Andre | French Chamber of Commerce of the U.S., Inc. 167 | 1943-01-01 | French Chamber of Commerce of the U.S., Inc. | 1350 Avenue of the Americas | New York | NY | 10019 | |
41882 | 41882 | 2013-12-31 | 2013-08-29 | Boisclair | Andre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
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]) );