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

20 rows where Registrant_Name = "Sandler, Travis & Rosenberg, P.A."

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 2

Registrant_Name 1

  • Sandler, Travis & Rosenberg, P.A. · 20 ✖
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
1900 1900 2015-01-31 Australian Wool Innovation Limited 2014-08-20 AUSTRALIA Sandler, Travis & Rosenberg, P.A. 6244 2014-08-20 Sandler, Travis & Rosenberg, P.A. Level 30, 580 George Street, Sydney NSW 2000        
2863 2863 1993-02-26 Textile & Garment Manufacturers' Association of Singapore 1992-07-31 SINGAPORE Sandler, Travis & Rosenberg, P.A. 4698 1992-07-31 Sandler, Travis & Rosenberg, P.A.          
2866 2866 1993-02-26 Ministry of Economic Relations & Trade 1992-07-31 CHINA Sandler, Travis & Rosenberg, P.A. 4698 1992-07-31 Sandler, Travis & Rosenberg, P.A. Beijing        
4656 4656 2006-03-31 Ministerio de Economia Republica de El Salvador 2002-10-18 EL SALVADOR Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. Alameda Juan Pablo II y Calle Guadalupe, Edif, C-2 Plan Maestro, Centro de Gabierno San Salvador, C        
4657 4657 2006-03-31 Panama National Economic Council 2004-05-06 PANAMA Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. Apartado Postal 9658 Panama 4 Panama City        
5606 5606 2013-04-26 All India Rice Exports Associations (AIREA) 2012-10-26 INDIA Sandler, Travis & Rosenberg, P.A. 6115 2012-07-19 Sandler, Travis & Rosenberg, P.A.          
6611 6611 2007-05-16 Department of Trade & Industry 2006-03-28 PHILIPPINES Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. New Solid Building   Makati City    
7994 7994 2007-06-21 Minister of Labor, Kingdom of Jordan 2007-03-01 JORDAN Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. P.O. Box 8160   Amman 11121    
8664 8664 2007-06-30 Embassy of the Republic of Korea 2006-05-26 KOREA, SOUTH Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. 2450 Massachusetts Avenue, N.W.   Washington DC 20008
9853 9853 2004-07-31 Government of Sri Lanka, Embassy 2003-02-07 SRI LANKA Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. 2148 Wyoming Avenue, N.W. 20008     DC  
9856 9856 2004-07-31 Ministry of Commerce, Royal Kingdom of Cambodia 1998-12-07 CAMBODIA Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. Phnom Pehn        
10539 10539 2004-08-15 Consejo Nacional de Zonas Francas de Exportacion (Dominican Republic) 1999-08-27 DOMINICAN REPUBLIC Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. Edif. San Rafael 5 to Piso Ave. Leopoldo Navarro 61 Santo Domingo        
14537 14537 2010-11-30 Royal Thai Embassy 2010-05-20 THAILAND Sandler, Travis & Rosenberg, P.A. 5989 2010-05-20 Sandler, Travis & Rosenberg, P.A. 1024 Wisconsin Avenue, NW   Washington DC 20007
15157 15157 2015-12-15 Asociacion Nacional de Empresarios de Colombia (ANDI) 2015-07-24 COLOMBIA Sandler, Travis & Rosenberg, P.A. 6309 2015-07-24 Sandler, Travis & Rosenberg, P.A. Calle 73 No. 8-13, Torre A, Piso 6 Bogota        
15230 15230 2012-12-19 Government of Guatemala Ministry of Economy 2012-07-19 GUATEMALA Sandler, Travis & Rosenberg, P.A. 6115 2012-07-19 Sandler, Travis & Rosenberg, P.A. 8 Av. 10-43, Zona 1, Ciudad de        
16465 16465 1999-12-31 Macau Economic Services 1999-08-26 MACAU Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. Rua Dr. Pedro Jose Lobo, n. 1-3 Ed. Luso International, 13 andar        
16470 16470 1999-12-31 Republic of the Fiji Islands 1999-05-17 FIJI Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. Washington     DC  
16561 16561 2004-12-31 Philippine Garment and Textile Board 2004-05-06 PHILIPPINES Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. New Solid Building 357 Gil J Puyat Avenue Makati, Metro Manila        
16615 16615 2007-12-31 Commission de Mise en Oeuvre de la Loi HOPE (CMO-HOPE) 2007-08-17 HAITI Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A.     Port au Prince    
16794 16794 2016-12-31 Sri Lanka Ministry of Development Strategies & International Trade 2016-08-08 SRI LANKA Sandler, Travis & Rosenberg, P.A. 6366 2016-08-08 Sandler, Travis & Rosenberg, P.A. Level 06 World Trade Center Colombo, 01      

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