FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Foreign_Principal_Termination_Date" is on date 2002-03-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registrant_Date (date)
Registrant_Name 8
Foreign_Principal 8
Country/Location_Represented 8
- AUSTRALIA 1
- BURKINA FASO 1
- CAMEROON 1
- COTE D'IVOIRE (IVORY COAST) 1
- EGYPT 1
- JAPAN 1
- MACEDONIA 1
- SOUTH AFRICA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4604 | 4604 | 2002-03-31 | Republic of Cote D'Ivoire | 2001-04-24 | COTE D'IVOIRE (IVORY COAST) | Valis Associates 5427 | 2001-04-24 | Valis Associates | 01 B.P. 1533 Abidjan 01 | ||||
4605 | 4605 | 2002-03-31 | Australian Dairy Corporation | 2000-10-05 | AUSTRALIA | Fazzone, Patrick Brock 5390 | 2000-10-05 | Fazzone, Patrick Brock | Level 5, IBM Tower, 60 City Road Southbank, Victoria 3006 | ||||
4606 | 4606 | 2002-03-31 | EgyptAir | 2000-03-10 | EGYPT | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 720 Fifth Avenue NY | NY | |||
4607 | 4607 | 2002-03-31 | Government of Burkina Faso | 1998-09-23 | BURKINA FASO | Cohen & Woods International, Inc. 5003 | 1995-03-10 | Cohen & Woods International, Inc. | Ouagadougou | ||||
4608 | 4608 | 2002-03-31 | Ministry of Industrial and Commercial Development of the Republic of Cameroon | 2001-09-07 | CAMEROON | Tamen & Tamen - Attorneys at Law 5456 | 2001-09-07 | Tamen & Tamen - Attorneys at Law | Yaounde | ||||
4609 | 4609 | 2002-03-31 | Nagano Prefectural Government | 1974-05-28 | JAPAN | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | Nagano | ||||
4610 | 4610 | 2002-03-31 | Peace Parks Foundation | 1999-04-06 | SOUTH AFRICA | C/R International, L.L.C. 5117 | 1996-07-02 | C/R International, L.L.C. | 29 Magnolia Street Somerset West 7129 | ||||
4611 | 4611 | 2002-03-31 | Republic of Macedonia | 2001-03-21 | MACEDONIA | Alexander, William 5418 | 2001-03-21 | Alexander, William | The Government Building Ilindenska bb 91000 Skopje |
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]) );