FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
97 rows where Registrant_Name = "Crowell & Moring International, Ltd." and Registration_Number = 3988
This data as json, CSV (advanced)
Foreign_Principal_Name 6
- - 77
- Board of Foreign Trade, ROC 2
- Bureau of Foreign Trade, Ministry of Economic Affairs, Government of the Republic of China (BOFT) 1
- Bureau of Foreign Trade, Ministry of Economic Affairs, Government of Republic of China 1
- Government of the Philippines 1
- United Nations Conference on Trade & Development (UNCTAD) 1
Document_Type 5
- Supplemental Statement 44
- Short-Form 21
- Amendment 11
- Exhibit AB 6
- Exhibit C 1
Foreign_Principal_Country 4
- - 77
- TAIWAN 4
- INTERNATIONAL 1
- PHILIPPINES 1
Registrant_Name 1
- Crowell & Moring International, Ltd. · 83 ✖
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );