FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

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

8 rows where Foreign_Principal_Country = "GREAT BRITAIN" and Foreign_Principal_Name = "BRITISH TOURIST AUTHORITY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Foreign_Principal_Name 1

  • BRITISH TOURIST AUTHORITY · 8 ✖

Foreign_Principal_Country 1

  • GREAT BRITAIN · 8 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
38360 38360 1993-04-07 NORTH AMERICAN PRECIS SYNDICATE North American Precis Syndicate 2836 Exhibit AB   BRITISH TOURIST AUTHORITY GREAT BRITAIN https://efile.fara.gov/docs/2836-Exhibit-AB-19930407-D05T4Q04.pdf
70410 70410 1949-07-01 BRITISH TOURIST AUTHORITY VisitBritain 579 Exhibit AB   BRITISH TOURIST AUTHORITY GREAT BRITAIN https://efile.fara.gov/docs/579-Exhibit-AB-19490701-CY6JW902.pdf
81857 81857 1974-08-01 OGILVY & MATHER U.S., A DIVISION OF THE OGILVY GROUP, INC. Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 Exhibit AB   BRITISH TOURIST AUTHORITY GREAT BRITAIN https://efile.fara.gov/docs/2530-Exhibit-AB-19740801-CZOO2H03.pdf
88042 88042 1987-08-17 NORTH AMERICAN PRECIS SYNDICATE North American Precis Syndicate 2836 Exhibit AB   BRITISH TOURIST AUTHORITY GREAT BRITAIN https://efile.fara.gov/docs/2836-Exhibit-AB-19870817-D05NKQ04.pdf
89166 89166 1973-08-23 PUBLIC SERVICE AUDIENCE PLANNERS Public Service Audience Planners 2452 Exhibit AB   BRITISH TOURIST AUTHORITY GREAT BRITAIN https://efile.fara.gov/docs/2452-Exhibit-AB-19730823-CZMIW102.pdf
103006 103006 1971-10-01 DDB NEEDHAM WORLDWIDE, INC. DDB Worldwide Communications Group, Inc. 1066 Exhibit AB   BRITISH TOURIST AUTHORITY GREAT BRITAIN https://efile.fara.gov/docs/1066-Exhibit-AB-19711001-CYNX7602.pdf
103944 103944 1986-10-01 DONALD N. MARTIN & COMPANY, INC. Donald N. Martin & Company, Inc. 1381 Exhibit AB   BRITISH TOURIST AUTHORITY GREAT BRITAIN https://efile.fara.gov/docs/1381-Exhibit-AB-19861001-CYPB7V02.pdf
114027 114027 1970-11-01 BRITISH TOURIST AUTHORITY VisitBritain 579 Exhibit AB   BRITISH TOURIST AUTHORITY GREAT BRITAIN https://efile.fara.gov/docs/579-Exhibit-AB-19701101-CY6M7X02.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_RegistrantDocs] (
   [Date_Stamped] TEXT,
   [Registrant_Name] TEXT,
   [Registration_Number] INTEGER,
   [Document_Type] TEXT,
   [Short_Form_Name] TEXT,
   [Foreign_Principal_Name] TEXT,
   [Foreign_Principal_Country] TEXT,
   [URL] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);