FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Country/Location_Represented = "KYRGYZSTAN" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Registrant_Name 6
Foreign_Principal_Registration_Date (date) 6 ✖
- 1992-01-14 1
- 1992-08-31 1
- 1992-10-19 1
- 1997-11-13 1
- 2013-07-16 1
- 2020-11-02 1
Foreign_Principal 6
State 1
- - 6
Country/Location_Represented 1
- KYRGYZSTAN · 6 ✖
City 1
- - 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3005 | 3005 | 1995-02-28 | Republic of Kirghizstan | 1992-01-14 | KYRGYZSTAN | Kirghizstan International, Inc. 4607 | 1992-01-14 | Kirghizstan International, Inc. | Bishkek, Kirghizstan | ||||
2996 | 2996 | 1994-02-28 | Republic of Kirgizhstan | 1992-08-31 | KYRGYZSTAN | Skadden, Arps, Slate, Meagher & Flom, L.L.P. 4550 | 1991-07-29 | Skadden, Arps, Slate, Meagher & Flom, L.L.P. | Bishkek, Kirgizhstan | ||||
2050 | 2050 | 1995-02-01 | Republic of Kirghizstan American-Kirghiz Builders' Corporation | 1992-10-19 | KYRGYZSTAN | Katz, Howard B. 4721 | 1992-10-19 | Katz, Howard B. | Kirhizstan | ||||
11489 | 11489 | 1997-09-10 | Republic of Krgyzstan | 1997-11-13 | KYRGYZSTAN | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Bishkek (Frunze) | ||||
16746 | 16746 | 2014-12-31 | General Prosecutor Office of the Kyrgyz Republic | 2013-07-16 | KYRGYZSTAN | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 139 Toktonalieva Street | Bushkek | |||
421 | 421 | Kyrgyz Republic | 2020-11-02 | KYRGYZSTAN | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | Bishkek |
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]) );