FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Foreign_Principal_Registration_Date = "1990-03-21"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 7
Foreign_Principal 7
Registrant_Date (date) 6 ✖
- 1949-11-07 2
- 1990-03-21 2
- 1982-06-16 1
- 1987-04-09 1
- 1988-08-04 1
- 1989-01-06 1
Country/Location_Represented 6
- RUSSIA 2
- TAIWAN 2
- GERMANY, FEDERAL REPUBLIC OF 1
- HAITI 1
- INTERNATIONAL 1
- POLAND 1
City 1
- - 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1747 | 1747 | 1990-01-31 | Scandinavian Tourist Boards | 1990-03-21 | INTERNATIONAL | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | New York | NY | |||
3576 | 3576 | 1990-03-10 | Republic of Haiti | 1990-03-21 | HAITI | Fouch-Roseboro & Associates 4356 | 1990-03-21 | Fouch-Roseboro & Associates | Washington | DC | |||
4205 | 4205 | 1993-03-30 | V/O Promexport"" | 1990-03-21 | RUSSIA | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | Moscow | ||||
5923 | 5923 | 1992-04-30 | V/O Soyuzkarta"" | 1990-03-21 | RUSSIA | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | Moscow | ||||
8171 | 8171 | 1990-06-29 | Panavia GmbH | 1990-03-21 | GERMANY, FEDERAL REPUBLIC OF | Edwards, Jack 3958 | 1987-04-09 | Edwards, Jack | Munich | ||||
9778 | 9778 | 1990-07-31 | Jovian Publishing Group | 1990-03-21 | TAIWAN | David D. O'Brien & Associates 4165 | 1988-08-04 | David D. O'Brien & Associates | Taiwan | ||||
9779 | 9779 | 1990-07-31 | Jovian Publishing Group | 1990-03-21 | TAIWAN | O'Brien, David D. 4355 | 1990-03-21 | O'Brien, David D. | Taipei | ||||
14278 | 14278 | 1990-11-27 | Government of Poland | 1990-03-21 | POLAND | Mark A. Siegel & Associates, Inc. 4200 | 1989-01-06 | Mark A. Siegel & Associates, Inc. | Warsaw |
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]) );