FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Country/Location_Represented = "AUSTRIA" and State = "NY" sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 15
- North American Precis Syndicate 5
- Jurgen Hartmann Agency 2
- Austrian Tourist Office, Inc. 1
- Berry, Max N. 1
- Davis Public Relations, Inc. 1
- Dosmar, Kurt John 1
- Doyle, Graf & Mabley, Inc. 1
- Graf Desley, Inc. 1
- Herman Associates, Inc. 1
- Hill & Knowlton, Inc. 1
- Keating Group, Inc. 1
- Perry, Marilyn Edith 1
- Public Service Audience Planners 1
- Ruder Finn, Inc. 1
- Tribune Films, Inc. 1
Foreign_Principal 12
- Austrian Press & Information Service 5
- Austrian National Tourist Office 4
- Austrian Trade Commission 2
- Alpine Tourist Commission 1
- Austrian State Tourist Department 1
- Austrian Tourist Board 1
- Austrian Tourist Office 1
- Austrian Trade Delegate in the U.S. 1
- Austrian Travel Sales Organization 1
- Dial Austria Instant Reservations, Inc. 1
- Permanent Mission of Austria to the United Nations 1
- Peter R. Fitz, Austrian Trade Delegate in the U.S. 1
State 1
- NY · 20 ✖
Country/Location_Represented 1
- AUSTRIA · 20 ✖
City 1
- - 20
Link | rowid | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 ▼ | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57 | 57 | Austrian National Tourist Office | 1947-10-03 | AUSTRIA | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | New York | NY | ||||
1243 | 1243 | 1991-01-12 | Austrian Tourist Board | 1985-08-09 | AUSTRIA | Doyle, Graf & Mabley, Inc. 3719 | 1985-08-09 | Doyle, Graf & Mabley, Inc. | New York | NY | |||
1708 | 1708 | 1983-01-31 | Alpine Tourist Commission | 1980-07-01 | AUSTRIA | Graf Desley, Inc. 3118 | 1980-07-01 | Graf Desley, Inc. | New York | NY | |||
3247 | 3247 | 1975-03-01 | Austrian Travel Sales Organization | 1974-09-11 | AUSTRIA | Jurgen Hartmann Agency 2395 | 1972-11-30 | Jurgen Hartmann Agency | New York | NY | |||
5204 | 5204 | 1986-04-12 | Austrian Press & Information Service | 1985-03-18 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5871 | 5871 | 1992-04-30 | Austrian Press & Information Service | 1992-04-03 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
6202 | 6202 | 1990-05-01 | Dial Austria Instant Reservations, Inc. | 1987-05-26 | AUSTRIA | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | NY | ||||
6287 | 6287 | 1993-05-03 | Austrian Trade Commission | 1992-10-28 | AUSTRIA | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | New York | NY | |||
8105 | 8105 | 1974-06-26 | Austrian Tourist Office | 1973-10-01 | AUSTRIA | Davis Public Relations, Inc. 2462 | 1973-10-01 | Davis Public Relations, Inc. | New York | NY | |||
8129 | 8129 | 1986-06-27 | Austrian National Tourist Office | 1972-11-30 | AUSTRIA | Jurgen Hartmann Agency 2395 | 1972-11-30 | Jurgen Hartmann Agency | New York | NY | |||
10657 | 10657 | 1974-08-22 | Austrian Trade Delegate in the U.S. | 1970-10-30 | AUSTRIA | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | New York | NY | |||
10677 | 10677 | 1992-08-23 | Austrian National Tourist Office | 1973-08-23 | AUSTRIA | Public Service Audience Planners 2452 | 1979-08-23 | Public Service Audience Planners | New York | NY | |||
10884 | 10884 | 1972-08-31 | Austrian State Tourist Department | 1968-08-29 | AUSTRIA | Tribune Films, Inc. 1810 | 1964-10-29 | Tribune Films, Inc. | New York | NY | |||
12953 | 12953 | 1985-10-23 | Austrian Press & Information Service | 1980-02-06 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13068 | 13068 | 1988-10-27 | Permanent Mission of Austria to the United Nations | 1984-01-09 | AUSTRIA | Perry, Marilyn Edith 2731 | 1976-10-27 | Perry, Marilyn Edith | New York | NY | |||
13226 | 13226 | 1982-10-31 | Austrian Trade Commission | 1981-04-22 | AUSTRIA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | New York | NY | |||
13585 | 13585 | 1991-11-01 | Austrian Press & Information Service | 1991-03-29 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13732 | 13732 | 1990-11-05 | Austrian Press & Information Service | 1990-06-21 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
15088 | 15088 | 1964-12-14 | Peter R. Fitz, Austrian Trade Delegate in the U.S. | 1965-02-18 | AUSTRIA | Dosmar, Kurt John 1832 | 1964-12-14 | Dosmar, Kurt John | New York | NY | |||
16375 | 16375 | 1996-12-31 | Austrian National Tourist Office | 1989-05-31 | AUSTRIA | Herman Associates, Inc. 2578 | 1975-04-22 | Herman Associates, Inc. | New York | NY |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );