FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where "Foreign_Principal_Termination_Date" is on date 1982-01-01
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Registrant_Date (date)
Foreign_Principal 18
- Anglo-American Corporation of South Africa, Ltd. 1
- Brazilian Consulate General, Los Angeles 1
- British-American Chamber of Commerce 1
- Colon Free Zone 1
- Constructora Nacional de Carros de Ferrocarril, S.A. 1
- Consulate General of Japan, New York 1
- Hsinchu Science Based Industrial Park Administration 1
- Island Government of Curacao 1
- Metropolitan Council of the Central District 1
- Office of Secretary of State for Tourism of the Dominican Republic 1
- People's Republic of China 1
- Portuguese Government Trade Office 1
- Province of Nova Scotia 1
- Province of Ontario 1
- Swedish Institute for Cultural Relations 1
- Tea Association (Central Africa), Ltd. 1
- U.S.-Japan Trade Council 1
- United Nations Industrial Development Organization 1
Country/Location_Represented 16
- CANADA 2
- JAPAN 2
- BRAZIL 1
- CHINA 1
- CURACAO 1
- DOMINICAN REPUBLIC 1
- GREAT BRITAIN 1
- HONDURAS 1
- INTERNATIONAL 1
- MALAWI 1
- MEXICO 1
- PANAMA 1
- PORTUGAL 1
- SOUTH AFRICA 1
- SWEDEN 1
- TAIWAN 1
Registrant_Name 12
- Modern Education Services, Inc. 7
- Berry, Max N. 1
- Development Counsellors International, Ltd. 1
- Graydon Associates, Inc. 1
- Harshe-Rotman & Druck, Inc. 1
- Inter-American Associates, Inc. 1
- Keating Group, Inc. 1
- Martin Ryan Haley & Associates, Inc. 1
- Philip S. Goodman, Inc. 1
- Public Service Audience Planners 1
- Tea Council of the U.S.A., Inc. 1
- Warren Weil Public Relations 1
City 1
- - 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
839 | 839 | 1982-01-01 | People's Republic of China | 1980-10-27 | CHINA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
840 | 840 | 1982-01-01 | Anglo-American Corporation of South Africa, Ltd. | 1965-05-20 | SOUTH AFRICA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
841 | 841 | 1982-01-01 | Brazilian Consulate General, Los Angeles | 1976-09-27 | BRAZIL | Public Service Audience Planners 2452 | 1979-08-23 | Public Service Audience Planners | Los Angeles | CA | |||
842 | 842 | 1982-01-01 | British-American Chamber of Commerce | 1974-12-31 | GREAT BRITAIN | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | New York | NY | |||
843 | 843 | 1982-01-01 | Colon Free Zone | 1962-03-23 | PANAMA | Warren Weil Public Relations 1530 | 1962-03-23 | Warren Weil Public Relations | Colon | ||||
844 | 844 | 1982-01-01 | Constructora Nacional de Carros de Ferrocarril, S.A. | 1978-08-29 | MEXICO | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
845 | 845 | 1982-01-01 | Consulate General of Japan, New York | 1979-03-05 | JAPAN | Philip S. Goodman, Inc. 3003 | 1979-03-05 | Philip S. Goodman, Inc. | NY | ||||
846 | 846 | 1982-01-01 | Hsinchu Science Based Industrial Park Administration | 1980-12-30 | TAIWAN | Graydon Associates, Inc. 2639 | 1975-12-10 | Graydon Associates, Inc. | Taipei | ||||
847 | 847 | 1982-01-01 | Island Government of Curacao | 1964-10-19 | CURACAO | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
848 | 848 | 1982-01-01 | Metropolitan Council of the Central District | 1980-02-20 | HONDURAS | Inter-American Associates, Inc. 3091 | 1980-02-20 | Inter-American Associates, Inc. | Tegucigalpa | ||||
849 | 849 | 1982-01-01 | Office of Secretary of State for Tourism of the Dominican Republic | 1980-01-22 | DOMINICAN REPUBLIC | Martin Ryan Haley & Associates, Inc. 2727 | 1976-10-18 | Martin Ryan Haley & Associates, Inc. | |||||
850 | 850 | 1982-01-01 | Portuguese Government Trade Office | 1981-10-21 | PORTUGAL | Harshe-Rotman & Druck, Inc. 3292 | 1981-11-21 | Harshe-Rotman & Druck, Inc. | NY | ||||
851 | 851 | 1982-01-01 | Province of Nova Scotia | 1964-10-19 | CANADA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
852 | 852 | 1982-01-01 | Province of Ontario | 1964-10-19 | CANADA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
853 | 853 | 1982-01-01 | Swedish Institute for Cultural Relations | 1973-10-16 | SWEDEN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
854 | 854 | 1982-01-01 | Tea Association (Central Africa), Ltd. | 1971-07-15 | MALAWI | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | Blantyre | ||||
855 | 855 | 1982-01-01 | U.S.-Japan Trade Council | 1975-08-01 | JAPAN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
856 | 856 | 1982-01-01 | United Nations Industrial Development Organization | 1980-02-29 | INTERNATIONAL | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | NY |
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]) );