FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

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

CSV options: 

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])
);