FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

40 rows where Registrant_Name = "Daniels, Houlihan & Palmeter"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 5

Registrant_Name 1

  • Daniels, Houlihan & Palmeter · 40 ✖

City 1

  • - 40
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
817 817 1973-01-01 Deutsche Fensterglas Ausfuhr Gesellschaft M.B.H. (Changed name to Flachglas) 1970-09-08 GERMAN DEMOCRATIC REPUBLIC Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Frankfurt        
2006 2006 1984-02-01 Korean Traders' Association 1980-01-04 KOREA, SOUTH Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Seoul        
4053 4053 1986-03-26 Japan Lumber Importers' Association 1968-01-30 JAPAN Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Tokyo        
4054 4054 1986-03-26 AHMSA Steel International, Inc. 1978-05-10 MEXICO Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter San Antonio     TX  
4055 4055 1986-03-26 Associacao Brasileira de Productores de Ferro Ligas ABRAFE"" 1978-03-17 BRAZIL Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Rio de Janiero        
4056 4056 1986-03-26 China National Textiles Import & Export Corporation 1981-06-09 CHINA Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Beijing        
4057 4057 1986-03-26 Council of Korea Textiles Export Associations 1977-11-04 KOREA, SOUTH Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Seoul        
4058 4058 1986-03-26 Embassy of Japan 1968-06-03 JAPAN Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Tokyo        
4059 4059 1986-03-26 Government of Brazil 1976-03-11 BRAZIL Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter          
4060 4060 1986-03-26 Instituto Salvadoreno de Comercio Exterior 1977-11-04 EL SALVADOR Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter San Salvador        
4061 4061 1986-03-26 Japan Chemical Fibres Association 1968-03-20 JAPAN Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Tokyo        
4062 4062 1986-03-26 Japan Trade Center 1968-06-03 JAPAN Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter New York     NY  
4063 4063 1986-03-26 Korea Iron & Steel Association 1984-08-22 KOREA, SOUTH Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Seoul        
4064 4064 1986-03-26 State Trading Corporation of India, Ltd. 1977-06-27 INDIA Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter New York     NY  
4065 4065 1986-03-26 Union des Industries de la Communaute Europeenne 1977-03-02 BELGIUM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Brussels        
4112 4112 1973-03-28 Indian Sugar Industry Export Corporation 1971-04-08 INDIA Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter New Delhi        
4344 4344 1972-03-31 Cocoa, Chocolate & Confectionery Alliance of Great Britian 1970-02-17 UNITED KINGDOM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter London        
6803 6803 1983-05-25 Japan Woolen & Linen Textiles Exporters' Association 1968-03-20 JAPAN Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Tokyo        
6804 6804 1983-05-25 Korea Leather & Fur Exporters' Association 1980-08-20 KOREA, SOUTH Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Seoul        
6805 6805 1983-05-25 Korea Stainless Steel Flatware Manufacturers' Association 1975-09-15 KOREA, SOUTH Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Seoul        
6806 6806 1983-05-25 Korean Plastic Goods Exporters' Association 1977-06-17 KOREA, SOUTH Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Seoul        
6807 6807 1983-05-25 Anci (Via Dogana 1, Milano, Italy) 1978-08-10 ITALY Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Milano        
6808 6808 1983-05-25 Government of Hong Kong Trade, Industry & Customs Department 1979-10-23 HONG KONG Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Kowloon        
6809 6809 1983-05-25 H&R Johnson-Richards Tiles, Ltd. 1972-08-22 UNITED KINGDOM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Stoke-on-Trent        
6810 6810 1983-05-25 Hong Kong Trade Development Council 1978-08-10 HONG KONG Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter          
6812 6812 1983-05-25 Korea Iron & Steel Association 1977-11-04 KOREA, SOUTH Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Seoul        
6814 6814 1983-05-25 Micam-Anci (Via Dogana 1, Milano, Italy) 1975-09-15 ITALY Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Milano        
6815 6815 1983-05-25 Norseland Foods, Inc. 1980-04-16 NORWAY Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Stamford     CT  
7356 7356 1969-06-01 Unione Industriale Pratese 1968-09-17 ITALY Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Prato        
7364 7364 1977-06-01 Confederation of Europeenne de L'Industrie de la Chaussure (European Confederation of the Footwear Industry) 1976-05-11 BELGIUM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Brussels        
8985 8985 1974-07-03 Indian Sugar Industry Export Corporation 1974-03-07 INDIA Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter New Delhi        
9726 9726 1980-07-31 Centro Dominicano de Promocion de Exportaciones 1979-08-30 DOMINICAN REPUBLIC Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Santo Domingo        
10130 10130 1980-08-04 China National Textiles Import & Export Corporation 1980-05-05 CHINA Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Beijing        
12318 12318 1975-10-01 Haitian Textile Exporters' Association 1975-01-10 HAITI Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Port-au-Prince        
13046 13046 1976-10-26 Government of El Salvador 1976-03-10 EL SALVADOR Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter San Salvador        
14187 14187 1976-11-23 Hong Kong Trade Development Council 1976-06-21 HONG KONG Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter          
14641 14641 1973-12-01 ORGALIME (Organisme de Liaison des Industries Metalliques Europennes) 1973-09-10 BELGIUM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Brussels        
15679 15679 1970-12-31 Vorort des Schweizerischen Handels-und Industrie-Vereins 1968-02-15 SWITZERLAND Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Zurich        
15682 15682 1971-12-31 ORGALIME (Organisme de Liaison des Industries Metalliques Europeennes) 1971-10-08 BELGIUM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Brussels        
15835 15835 1980-12-31 Embassy of France, French Commerical Office 1970-08-10 FRANCE Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Washington     DC  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);