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

30 rows where Registrant_Name = "L.A. Motley & Company"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 7

State 4

Registrant_Name 1

  • L.A. Motley & Company · 30 ✖

City 1

  • - 30
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
981 981 1999-01-01 ABICALCADOS 1997-04-30 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
982 982 1999-01-01 Associacao Industrias de Calcados do Rio Grands do Sul 1985-08-15 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
987 987 2000-01-01 Philippine Sugar Administration 1989-03-15 PHILIPPINES L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Quezon City        
1094 1094 1989-01-06 Eluma, S.A., Industria e Comercio 1988-12-28 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Santo Andre        
1608 1608 1987-01-29 Companhia de Navegacao Maritima Netumar 1986-08-08 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
2453 2453 1998-02-13 Companhia de Navegacao Alianca, S.A. 1997-11-07 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company South Plainfield     NJ  
2454 2454 1998-02-13 Companhia de Navegacao Alianca, S.A. 1997-11-17 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
3559 3559 1993-03-09 ABECITRUS (Associacao Brasileira dos Exportadores de Citricos) 1988-12-14 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Sao Paulo        
3560 3560 1993-03-09 Associacao Nacional das Industrias de Citricos 1987-08-20 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
3562 3562 1993-03-09 Sharp, S.A., Equipamentos Electronicos 1988-01-14 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Sao Paulo        
3848 3848 1995-03-17 Associacao Nacional dos Fabricantes de Papel e Celulose ANFPC 1989-03-30 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Sao Paulo        
3849 3849 1995-03-17 Companhia Siderurgica Nactional 1993-09-16 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Rio de Janeiro        
3850 3850 1995-03-17 Korea Foreign Trade Association 1994-07-18 KOREA, SOUTH L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Seoul        
3851 3851 1995-03-17 Ministry of Finance, Government of Chile 1994-11-25 CHILE L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Santiago        
5164 5164 1988-04-11 Associacao de Hotels de Turismo (AHT) 1987-12-03 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
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          
6222 6222 1997-05-01 Republic of the Philippines, Department of Foreign Affairs 1993-04-12 PHILIPPINES L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
6669 6669 1988-05-20 Transbrasil Airlines, Inc. 1987-02-20 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Miami     FL  
7058 7058 1987-05-31 Associacao Nacional das Industrias de Citricos (ANIC) 1986-06-04 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
8414 8414 1987-06-30 Associacao Brasileira de Industria de Computadores/Periferic 1985-12-12 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
9785 9785 1991-07-31 Companhia de Navegacao Maritima NETUMAR 1990-10-05 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Rio de Janeiro        
10529 10529 1992-08-15 S.A. San Miguel 1990-08-28 ARGENTINA L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Buenos Aires        
10780 10780 1995-08-27 Office of Commercial Affairs of the Royal Thai Embassy 1995-08-04 THAILAND L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Washington     DC  
11628 11628 1987-09-15 Thai Food Processors' Association 1987-04-24 THAILAND L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Bangkok        
11989 11989 1988-09-30 Associacao Brasileira de Sucos (ABRASUCOS) 1986-06-04 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
11996 11996 1988-09-30 H. Stern, S.A. 1988-09-09 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Rio de Janeiro        
13259 13259 1989-10-31 Companhia Siderurgica da Guanabara (COSIGUA) 1989-07-05 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Rio de Janeiro        
13713 13713 1994-11-04 Republic of Korea, Ministry of Trade, Industry & Energy 1994-07-18 KOREA, SOUTH L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Kwachon        
16039 16039 1988-12-31 Associacao Brasileira dos Produtores e Exportadores de Frang 1987-11-02 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company          
16103 16103 1989-12-31 Companhia de Navegacao Maritima NETUMAR 1988-11-18 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Rio de Janeiro        

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