FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Foreign_Principal_Termination_Date" is on date 1990-04-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 11
- Berliner, Corcoran & Rowe 1
- Burgum & Grimm, Ltd. 1
- Committee for Free Elections & Democracy in Nicaragua 1
- Deckmann Associates 1
- Fleishman-Hillard, Inc. 1
- Ketchum Communications, Inc., Through Ketchum P.R., New York 1
- L.A. Motley & Company 1
- North American Precis Syndicate 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Piper & Marbury 1
- Susan Davis International & Public Affairs 1
Foreign_Principal 11
Country/Location_Represented 9
- GREAT BRITAIN 2
- NICARAGUA 2
- BARBADOS 1
- CANADA 1
- GERMANY, FEDERAL REPUBLIC OF 1
- HONG KONG 1
- JAPAN 1
- NETHERLANDS ANTILLES 1
- SPAIN 1
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5850 | 5850 | 1990-04-30 | City of West Berlin | 1987-08-17 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5851 | 5851 | 1990-04-30 | Cominco, Ltd. | 1988-03-29 | CANADA | Piper & Marbury 4111 | 1988-03-29 | Piper & Marbury | Vancouver | ||||
5852 | 5852 | 1990-04-30 | Committee for Free Elections & Democracy in Nicaragua | 1989-10-04 | NICARAGUA | Burgum & Grimm, Ltd. 4301 | 1989-10-04 | Burgum & Grimm, Ltd. | Miami | FL | |||
5853 | 5853 | 1990-04-30 | Curacao, Inc. | 1989-12-27 | NETHERLANDS ANTILLES | Ketchum Communications, Inc., Through Ketchum P.R., New York 4254 | 1989-05-17 | Ketchum Communications, Inc., Through Ketchum P.R., New York | Curacao | ||||
5854 | 5854 | 1990-04-30 | Franklin, S.A. | 1991-10-30 | SPAIN | Susan Davis International & Public Affairs 3444 | 1983-02-16 | Susan Davis International & Public Affairs | Madrid | ||||
5855 | 5855 | 1990-04-30 | Government of Barbados | 1983-08-22 | BARBADOS | Berliner, Corcoran & Rowe 3512 | 1983-08-22 | Berliner, Corcoran & Rowe | Bridgetown | ||||
5856 | 5856 | 1990-04-30 | J.B.&S. Lees | 1986-04-09 | GREAT BRITAIN | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | |||||
5857 | 5857 | 1990-04-30 | Komatsu, Ltd. | 1990-02-13 | JAPAN | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | Tokyo | ||||
5858 | 5858 | 1990-04-30 | Newscan Company, Ltd. | 1988-03-03 | HONG KONG | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | |||||
5859 | 5859 | 1990-04-30 | Union Nacional Opositora | 1989-11-08 | NICARAGUA | Committee for Free Elections & Democracy in Nicaragua 4313 | 1989-11-08 | Committee for Free Elections & Democracy in Nicaragua | Managua | ||||
5860 | 5860 | 1990-04-30 | WINvest | 1984-01-23 | GREAT BRITAIN | Deckmann Associates 3552 | 1984-01-23 | Deckmann Associates |
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]) );