FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
112 rows where Address_1 = "Taipei"
This data as json, CSV (advanced)
Foreign_Principal 12
- Board of Foreign Trade (BOFT) 1
- Chonghwa Telecom Company, Ltd. 1
- Government Information Office 1
- Special Comm. Re. Exportation of Textiles from ROC to U.S. 1
- TECRO, Taipei Economic & Cultural Representatives Office (formerly: CETRA, China External Trade Development Council) 1
- Taipei Economic and Cultural Representative Office 1
- Taiwan Flour Mills' Association 1
- Taiwan Footwear Exporters' Association 1
- Taiwan Footwear Manufacturers' Association 1
- Taiwan Mushroom Packers' United Export Corporation 1
- Taiwan Regional Association of Rubber Industries 1
- Taiwan Textile Federation 1
Registrant_Name 8
State 1
- - 12
Country/Location_Represented 1
- TAIWAN 12
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15684 | 15684 | 1971-12-31 | Special Comm. Re. Exportation of Textiles from ROC to U.S. | 1970-09-28 | TAIWAN | Solter, Myron W. 1970 | 1966-03-22 | Solter, Myron W. | Taipei | ||||
15836 | 15836 | 1980-12-31 | Government Information Office | 1966-03-18 | TAIWAN | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | Taipei | ||||
15926 | 15926 | 1985-12-31 | Taiwan Flour Mills' Association | 1981-01-08 | TAIWAN | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | Taipei | ||||
15927 | 15927 | 1985-12-31 | Taiwan Footwear Exporters' Association | 1981-01-08 | TAIWAN | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | Taipei | ||||
15993 | 15993 | 1987-12-31 | Taiwan Mushroom Packers' United Export Corporation | 1972-06-05 | TAIWAN | Solter, Myron W. 1970 | 1966-03-22 | Solter, Myron W. | Taipei | ||||
16028 | 16028 | 1987-12-31 | Taiwan Regional Association of Rubber Industries | 1987-09-29 | TAIWAN | Solter, Myron W. 1970 | 1966-03-22 | Solter, Myron W. | Taipei | ||||
16032 | 16032 | 1988-12-31 | Taiwan Footwear Manufacturers' Association | 1986-03-10 | TAIWAN | Hu, Tsu-Wang 3791 | 1986-03-10 | Hu, Tsu-Wang | Taipei | ||||
16081 | 16081 | 1988-12-31 | Taiwan Textile Federation | 1980-01-21 | TAIWAN | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | Taipei | ||||
16413 | 16413 | 1997-12-31 | Chonghwa Telecom Company, Ltd. | 1997-03-07 | TAIWAN | Severance International, Inc. 5038 | 1995-07-26 | Severance International, Inc. | Taipei | ||||
16446 | 16446 | 1998-12-31 | Taipei Economic and Cultural Representative Office | 1994-02-02 | TAIWAN | Washington Group 4332 | 1990-01-18 | Washington Group | Taipei | ||||
16545 | 16545 | 2003-12-31 | TECRO, Taipei Economic & Cultural Representatives Office (formerly: CETRA, China External Trade Development Council) | 1993-12-21 | TAIWAN | Symms, Lehn & Associates, Inc. 4880 | 1993-12-21 | Symms, Lehn & Associates, Inc. | Taipei | ||||
16691 | 16691 | 2011-12-31 | Board of Foreign Trade (BOFT) | 2002-07-16 | TAIWAN | Miller & Chevalier, Chartered 5365 | 2000-04-03 | Miller & Chevalier, Chartered | Taipei |
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]) );