FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Foreign_Principal_Termination_Date" is on date 1979-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 14
- Assessorato Turismo Regione Siciliana 1
- Associacao Brasileira de Productores de Ferro Ligas (ABRAFE) 1
- Australian Dairy Corporation 1
- Australian Wool Corporation 1
- Belgian National Tourist Office 1
- Dakar Industrial Free Zone 1
- Economic Development Corporation for North Rhine-Westphalia 1
- Government of Chile 1
- Instituto Salvadoreno de Comercio Exterio 1
- Israel Aircraft Industries Purchasing, Ltd. 1
- Kingdom of Morocco 1
- Nguyen Si Truc of Zunhansaba 1
- Nice - Congres 1
- Office of Information of the Embassy of Republic of Korea 1
Registrant_Name 13
- Fasturn, Inc. 2
- ADV, Inc. 1
- American-Chilean Council 1
- China Books & Periodicals, Inc. 1
- Donald N. Martin & Company, Inc. 1
- E.A. Jaenke & Associates, Inc. 1
- Fabian, Pierre G. 1
- German-American Chamber of Commerce, Inc., New York 1
- H. Montana Publicity Enterprises, Inc. 1
- Michael W. Moynihan & Associates, Inc. 1
- Ritter, Sheldon 1
- Robert B. Meyersburg Company 1
- Williams & King 1
Country/Location_Represented 13
- AUSTRALIA 2
- BELGIUM 1
- BRAZIL 1
- CHILE 1
- EL SALVADOR 1
- FRANCE 1
- GERMANY, FEDERAL REPUBLIC OF 1
- ISRAEL 1
- ITALY 1
- KOREA, SOUTH 1
- MOROCCO 1
- SENEGAL 1
- VIETNAM 1
City 1
- - 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15813 | 15813 | 1979-12-31 | Assessorato Turismo Regione Siciliana | 1978-09-11 | ITALY | H. Montana Publicity Enterprises, Inc. 2966 | 1978-09-11 | H. Montana Publicity Enterprises, Inc. | Palermo | ||||
15814 | 15814 | 1979-12-31 | Associacao Brasileira de Productores de Ferro Ligas (ABRAFE) | 1979-11-26 | BRAZIL | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | Rio de Jeniero | ||||
15815 | 15815 | 1979-12-31 | Australian Dairy Corporation | 1975-08-05 | AUSTRALIA | Williams & King 2502 | 1974-03-08 | Williams & King | |||||
15816 | 15816 | 1979-12-31 | Australian Wool Corporation | 1977-01-25 | AUSTRALIA | E.A. Jaenke & Associates, Inc. 2748 | 1977-01-25 | E.A. Jaenke & Associates, Inc. | |||||
15817 | 15817 | 1979-12-31 | Belgian National Tourist Office | 1974-02-23 | BELGIUM | Donald N. Martin & Company, Inc. 1381 | 1960-07-29 | Donald N. Martin & Company, Inc. | Brussels | ||||
15818 | 15818 | 1979-12-31 | Dakar Industrial Free Zone | 1980-03-30 | SENEGAL | Ritter, Sheldon 2666 | 1976-03-10 | Ritter, Sheldon | |||||
15819 | 15819 | 1979-12-31 | Economic Development Corporation for North Rhine-Westphalia | 1979-06-21 | GERMANY, FEDERAL REPUBLIC OF | German-American Chamber of Commerce, Inc., New York 1812 | 1964-11-04 | German-American Chamber of Commerce, Inc., New York | Duesseldorf | ||||
15820 | 15820 | 1979-12-31 | Government of Chile | 1979-12-31 | CHILE | American-Chilean Council 2569 | 1975-03-31 | American-Chilean Council | New York | NY | |||
15821 | 15821 | 1979-12-31 | Instituto Salvadoreno de Comercio Exterio | 1979-11-26 | EL SALVADOR | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | San Salvador | ||||
15822 | 15822 | 1979-12-31 | Israel Aircraft Industries Purchasing, Ltd. | 1971-01-31 | ISRAEL | Robert B. Meyersburg Company 2242 | 1971-01-31 | Robert B. Meyersburg Company | New York | NY | |||
15823 | 15823 | 1979-12-31 | Kingdom of Morocco | 1978-08-09 | MOROCCO | ADV, Inc. 2942 | 1978-08-09 | ADV, Inc. | Rabat | ||||
15824 | 15824 | 1979-12-31 | Nguyen Si Truc of Zunhansaba | 1967-09-06 | VIETNAM | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | |||||
15825 | 15825 | 1979-12-31 | Nice - Congres | 1976-02-25 | FRANCE | Fabian, Pierre G. 2663 | 1976-02-25 | Fabian, Pierre G. | Nice | ||||
15826 | 15826 | 1979-12-31 | Office of Information of the Embassy of Republic of Korea | 1978-04-17 | KOREA, SOUTH | Michael W. Moynihan & Associates, Inc. 2881 | 1978-04-07 | Michael W. Moynihan & Associates, 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]) );