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

15 rows where Country/Location_Represented = "CZECHOSLOVAKIA" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • CZECHOSLOVAKIA · 15 ✖
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
1050 1050 1981-01-02 CSA, Czechoslovak Airlines 1970-01-27 CZECHOSLOVAKIA Pace Advertising Agency, Inc. 2174 1969-12-03 Pace Advertising Agency, Inc. New York     NY  
2705 2705 1989-02-22 Czechoslovak Travel Bureau 1989-02-22 CZECHOSLOVAKIA Aviso, Inc. 4220 1989-02-22 Aviso, Inc. New York     NY  
4857 4857 1974-04-01 CEDOK 1974-09-11 CZECHOSLOVAKIA Jurgen Hartmann Agency 2395 1972-11-30 Jurgen Hartmann Agency New York     NY  
6844 6844 1955-05-26 Centrotex Ltd. 1949-05-18 CZECHOSLOVAKIA Recht, Charles 101 1942-08-20 Recht, Charles 45 Cedar Street   New York NY 10012
6845 6845 1955-05-26 Commercial Attache to the Embassy of the Republic of Czechoslovakia at Washington, DC 1949-05-18 CZECHOSLOVAKIA Recht, Charles 101 1942-08-20 Recht, Charles 6 East 67th Street   New York NY 10012
6846 6846 1955-05-26 Czechoslovakia Delegation to the United Nations 1953-06-15 CZECHOSLOVAKIA Recht, Charles 101 1942-08-20 Recht, Charles 6 East 67th Street   New York NY 10012
7077 7077 1990-05-31 Czechoslovak Travel Bureau 1988-11-23 CZECHOSLOVAKIA West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
8379 8379 1984-06-30 CEDOK, Czechoslovak Travel Bureau 1970-01-27 CZECHOSLOVAKIA Pace Advertising Agency, Inc. 2174 1969-12-03 Pace Advertising Agency, Inc. New York     NY  
9126 9126 1982-07-09 Czechoslovakia 1979-06-27 CZECHOSLOVAKIA North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
11241 11241 1983-09-01 CEDOK, Czechoslovak Travel Bureau 1966-06-03 CZECHOSLOVAKIA Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
11563 11563 1990-09-13 Commercial Counselor, Office of the Czech & Slovak Federal Republic 1990-07-25 CZECHOSLOVAKIA Bryan Cave 3599 1984-06-25 Bryan Cave New York     NY  
14142 14142 1945-11-22 Czechoslovak Arms Manufacturing Corporation Czechoslovak Zbrojovka, A.S. 1944-05-22 CZECHOSLOVAKIA North American Machine Tool Manufacturing Corporation 255 1944-05-22 North American Machine Tool Manufacturing Corporation New York     NY  
14693 14693 1988-12-01 Ministry of Foreign Trade 1986-01-22 CZECHOSLOVAKIA Bryan Cave 3599 1984-06-25 Bryan Cave New York     NY  
15362 15362 1946-12-24 No foreign principal listed - listed on statement as none 1946-12-24 CZECHOSLOVAKIA Czechoslovak Economic Council, Inc. 416 1946-12-24 Czechoslovak Economic Council, Inc.       NY  
15567 15567 1957-12-31 Czechoslovak Information Service 1946-04-22 CZECHOSLOVAKIA Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, 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])
);