FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
74 rows where "Date_Stamped" is on date 1999-12-31 and Document_Type = "Supplemental Statement"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Country
Registrant_Name >30
- Mexican Tourism Board 3
- World Zionist Organization - American Section, Inc. 2
- American International Development Group, Inc. 1
- Arab Information Center 1
- Arter & Hadden, LLP 1
- Australian Broadcasting Corporation 1
- Australian Tourist Commission 1
- Austrian National Tourist Office, New York 1
- Barbara Burns & Associates, Inc. 1
- Barbour Griffith & Rogers 1
- Barron-Birrell, Inc. 1
- Bermuda Department of Tourism 1
- Boland & Madigan, Inc. 1
- CMG Communications, L.L.C. 1
- Caribbean Tourism Organization 1
- China National Tourist Office 1
- Chungchong Nam-Do Provincial Government, New York 1
- Cleary, Gottlieb, Steen & Hamilton 1
- Czech Center, New York 1
- Danish Tourist Board 1
- Downen, Robert L. 1
- European Travel Commission 1
- Federation of Electric Power Companies of Japan 1
- Finnish Tourist Board, New York 1
- Foreign Policy Group 1
- German National Tourist Office 1
- Global Policy Group, Inc. 1
- Global USA, Inc. 1
- Hai Tian Development U.S.A., Inc. 1
- Hall, Thomas Forrest 1
- …
Foreign_Principal_Name 1
- - 74
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]) );