FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where "Foreign_Principal_Termination_Date" is on date 1985-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 21
- Akzo, N.V. 1
- Associacao das Industrias de Calcados do Rio Grand do Sul 1
- Canadian Government Office of Tourism 1
- Departamento de Turismo 1
- Frupac International Corporation 1
- Government of the United Kingdom of Great Britain & Northern Ireland 1
- Instituto Mexicano de Commercio Exterior 1
- Jamaica National Investment Promotion, Inc. 1
- Korea National Tourism Corporation, Los Angeles 1
- Korea National Tourism Corporation, New York 1
- Korean Cultural Service 1
- Korean National Tourism Corporation 1
- Kuwait Petroleum Corporation 1
- Morgan Grenfell & Company, Ltd. 1
- Motoren-und-Turbinen-Union Friedrichshafen GmbH 1
- Scand-Video, A.B. 1
- Taiwan Flour Mills' Association 1
- Taiwan Footwear Exporters' Association 1
- Tourist Development Corporation of Malaysia 1
- Tourist Office of St. Moritz 1
- Universal Marine Consultants 1
Registrant_Name 16
- Modern Education Services, Inc. 4
- Public Service Audience Planners 2
- United Friends, Inc. 2
- Aaron D. Cushman & Associates, Inc. 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Colby, Baily & Associates 1
- Davis Whitner & Associates, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Hyman Fine & Associates, Ltd. 1
- Lowe Marschalk, Inc. 1
- Manchester Associates, Ltd. 1
- Mexican Government Tourism Office, Phoenix 1
- Samuel B. Crispin & Associates, Inc. 1
- Surrey & Morse 1
- Tele-Press Associates, Inc. 1
- Wald, Harkrader & Ross 1
Country/Location_Represented 16
- KOREA, SOUTH 4
- MEXICO 2
- TAIWAN 2
- BRAZIL 1
- CANADA 1
- CHILE 1
- GERMANY, FEDERAL REPUBLIC OF 1
- GREAT BRITAIN 1
- JAMAICA 1
- JAPAN 1
- KUWAIT 1
- MALAYSIA 1
- NETHERLANDS 1
- SWEDEN 1
- SWITZERLAND 1
- UNITED KINGDOM 1
City 1
- - 21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15926 | 15926 | 1985-12-31 | Taiwan Flour Mills' Association | 1981-01-08 | TAIWAN | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | Taipei | ||||
15927 | 15927 | 1985-12-31 | Taiwan Footwear Exporters' Association | 1981-01-08 | TAIWAN | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | Taipei | ||||
15928 | 15928 | 1985-12-31 | Akzo, N.V. | 1985-07-31 | NETHERLANDS | Davis Whitner & Associates, Inc. 3708 | 1985-07-31 | Davis Whitner & Associates, Inc. | Arnhem | ||||
15929 | 15929 | 1985-12-31 | Associacao das Industrias de Calcados do Rio Grand do Sul | 1985-08-20 | BRAZIL | Colby, Baily & Associates 3663 | 1985-03-22 | Colby, Baily & Associates | Rio Grande do Sul | ||||
15930 | 15930 | 1985-12-31 | Canadian Government Office of Tourism | 1982-05-17 | CANADA | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | Ottawa | ||||
15931 | 15931 | 1985-12-31 | Departamento de Turismo | 1970-07-10 | MEXICO | Mexican Government Tourism Office, Phoenix 2201 | 1970-07-10 | Mexican Government Tourism Office, Phoenix | |||||
15932 | 15932 | 1985-12-31 | Frupac International Corporation | 1984-08-09 | CHILE | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | |||||
15933 | 15933 | 1985-12-31 | Government of the United Kingdom of Great Britain & Northern Ireland | 1984-12-10 | UNITED KINGDOM | Wald, Harkrader & Ross 3241 | 1981-05-10 | Wald, Harkrader & Ross | DC | ||||
15934 | 15934 | 1985-12-31 | Instituto Mexicano de Commercio Exterior | 1985-06-17 | MEXICO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | |||||
15935 | 15935 | 1985-12-31 | Jamaica National Investment Promotion, Inc. | 1982-12-01 | JAMAICA | Samuel B. Crispin & Associates, Inc. 3424 | 1982-12-01 | Samuel B. Crispin & Associates, Inc. | |||||
15936 | 15936 | 1985-12-31 | Korea National Tourism Corporation, Los Angeles | 1976-09-27 | KOREA, SOUTH | Public Service Audience Planners 2452 | 1979-08-23 | Public Service Audience Planners | Los Angeles | CA | |||
15937 | 15937 | 1985-12-31 | Korea National Tourism Corporation, New York | 1976-09-27 | KOREA, SOUTH | Public Service Audience Planners 2452 | 1979-08-23 | Public Service Audience Planners | New York | NY | |||
15938 | 15938 | 1985-12-31 | Korean Cultural Service | 1985-07-19 | KOREA, SOUTH | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
15939 | 15939 | 1985-12-31 | Korean National Tourism Corporation | 1984-01-11 | KOREA, SOUTH | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
15940 | 15940 | 1985-12-31 | Kuwait Petroleum Corporation | 1981-11-10 | KUWAIT | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Safat | ||||
15941 | 15941 | 1985-12-31 | Morgan Grenfell & Company, Ltd. | 1985-04-26 | GREAT BRITAIN | Surrey & Morse 2649 | 1976-01-05 | Surrey & Morse | London | ||||
15942 | 15942 | 1985-12-31 | Motoren-und-Turbinen-Union Friedrichshafen GmbH | 1985-09-16 | GERMANY, FEDERAL REPUBLIC OF | Hyman Fine & Associates, Ltd. 3273 | 1981-09-02 | Hyman Fine & Associates, Ltd. | CT | ||||
15943 | 15943 | 1985-12-31 | Scand-Video, A.B. | 1985-01-25 | SWEDEN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
15944 | 15944 | 1985-12-31 | Tourist Development Corporation of Malaysia | 1985-03-29 | MALAYSIA | Lowe Marschalk, Inc. 3670 | 1985-03-29 | Lowe Marschalk, Inc. | San Franciso | CA | |||
15945 | 15945 | 1985-12-31 | Tourist Office of St. Moritz | 1981-12-01 | SWITZERLAND | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
15946 | 15946 | 1985-12-31 | Universal Marine Consultants | 1982-06-05 | JAPAN | Tele-Press Associates, Inc. 2832 | 1977-09-30 | Tele-Press Associates, Inc. | Tokyo |
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]) );