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
3412	3412	1993-03-11	French Government Tourist Office	1989-06-23	FRANCE	2478 2478	1973-11-23	Keating Group, Inc.	New York	NY
3442	3442	1968-03-12	French Government Tourist Office	1967-05-04	FRANCE	2024 2024	1967-05-04	Savage, John	New York	NY
3505	3505	1994-03-14	French Government Tourist Office	1971-03-25	FRANCE	1803 1803	1964-10-19	Modern Education Services, Inc.		NY
4628	4628	1986-04-01	French Government Tourist Office	1980-11-28	FRANCE	1704 1704	1964-04-02	Van Brunt & Company Advertising-Marketing, Inc.	Paris
5326	5326	1966-04-28	French Government Tourist Office	1965-10-28	FRANCE	1934 1934	1965-10-28	Savage, John	New York	NY
5563	5563	1992-04-30	French Government Tourist Office	1992-03-27	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
6124	6124	1993-05-12	French Government Tourist Office	1993-04-07	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
6667	6667	1968-05-31	French Government Tourist Office	1967-10-06	FRANCE	2054 2054	1967-10-06	Bell & Stanton, Inc.	New York	NY
7856	7856	1971-06-30	French Government Tourist Office	1970-10-20	FRANCE	1826 1826	1964-12-03	Ogilvy & Mather, Inc.	New York	NY
7905	7905	1980-06-30	French Government Tourist Office	1971-09-08	FRANCE	1748 1748	1964-06-03	Needham, Harper & Steers Advertising, Inc.	New York	NY
8668	8668	1982-07-09	French Government Tourist Office	1979-06-27	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
12364	12364	1989-10-25	French Government Tourist Office	1985-04-18	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate		NY
12869	12869	1969-11-01	French Government Tourist Office	1959-12-21	FRANCE	1066 1066	1957-09-16	DDB Worldwide Communications Group, Inc.	Paris
12918	12918	1991-11-01	French Government Tourist Office	1991-03-29	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
13182	13182	1992-11-10	French Government Tourist Office	1992-07-23	FRANCE	2836 2836	1977-10-12	North American Precis Syndicate	New York	NY
13192	13192	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)
);