FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
4 rows where Foreign_Principal_Termination_Date = "" and Registration_Number = 6162
This data as json, CSV (advanced)
Suggested facets: Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
235 | 235 | Emirate of Ras Al Khaimah | 2013-04-08 | UNITED ARAB EMIRATES | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | P.O. Box 5130 | Ras Al Khaimah | ||||
308 | 308 | Government of the Republic of Serbia | 2023-07-21 | SERBIA | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 1333 16th Street, NW | Washington | DC | 20036 | ||
504 | 504 | NEOM (through Richard Attias and Associates Saudi for Organization of Exhibitions Co.) | 2023-04-11 | SAUDI ARABIA | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | RDC Complex, Building CS01, 4th Floor, Unit 9, 3884 | Al Imam Saud Ibn Abdul Aziz Branch Road Al Nakhi | ||||
658 | 658 | Stiftung Pressischer Kulturbesitz (SPK) (through Wiggin and Dana LLP) | 2020-12-06 | GERMANY | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | Von-der-Heydt-StraSe 16-18 | 10785 Berlin |
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]) );