FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

16 rows where Foreign_Principal = "French Government Tourist Office"

Search:

descending

Link	rowid ▼	Foreign_Principal_Termination_Date	Foreign_Principal	Foreign_Principal_Registration_Date	Country/Location_Represented	Registration_Number	Registrant_Date	Registrant_Name	Address_1	State
3422	3422	1993-03-11	French Government Tourist Office	1989-06-23	FRANCE	2478 2478	1973-11-23	Keating Group, Inc.	New York	NY
3452	3452	1968-03-12	French Government Tourist Office	1967-05-04	FRANCE	2024 2024	1967-05-04	Savage, John	New York	NY
3515	3515	1994-03-14	French Government Tourist Office	1971-03-25	FRANCE	1803 1803	1964-10-19	Modern Education Services, Inc.		NY
4652	4652	1986-04-01	French Government Tourist Office	1980-11-28	FRANCE	1704 1704	1964-04-02	Van Brunt & Company Advertising-Marketing, Inc.	Paris
5360	5360	1966-04-28	French Government Tourist Office	1965-10-28	FRANCE	1934 1934	1965-10-28	Savage, John	New York	NY
5599	5599	1992-04-30	French Government Tourist Office	1992-03-27	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
6163	6163	1993-05-12	French Government Tourist Office	1993-04-07	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
6710	6710	1968-05-31	French Government Tourist Office	1967-10-06	FRANCE	2054 2054	1967-10-06	Bell & Stanton, Inc.	New York	NY
7908	7908	1971-06-30	French Government Tourist Office	1970-10-20	FRANCE	1826 1826	1964-12-03	Ogilvy & Mather, Inc.	New York	NY
7957	7957	1980-06-30	French Government Tourist Office	1971-09-08	FRANCE	1748 1748	1964-06-03	Needham, Harper & Steers Advertising, Inc.	New York	NY
8726	8726	1982-07-09	French Government Tourist Office	1979-06-27	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
12453	12453	1989-10-25	French Government Tourist Office	1985-04-18	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate		NY
12964	12964	1969-11-01	French Government Tourist Office	1959-12-21	FRANCE	1066 1066	1957-09-16	DDB Worldwide Communications Group, Inc.	Paris
13013	13013	1991-11-01	French Government Tourist Office	1991-03-29	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
13278	13278	1992-11-10	French Government Tourist Office	1992-07-23	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
13288	13288	1981-11-11	French Government Tourist Office	1971-05-06	FRANCE	1803 1803	1964-10-19	Modern Education Services, Inc.

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