Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
This data as json, atom, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name
City
Foreign_Principal
Country/Location_Represented
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1135 | 1135 | 1982-01-11 | Federal Republic of Nigeria | 1980-08-26 | NIGERIA | 3141 3141 | 1980-08-26 | B&C International, Inc. | Lagos | ||||
| 1136 | 1136 | 1982-01-11 | Federal Republic of Nigeria | 1980-08-26 | NIGERIA | 3142 3142 | 1980-08-26 | B&C Associates, Inc. | Lagos | ||||
| 2502 | 2502 | 1992-02-18 | Federal Republic of Nigeria | 1991-10-21 | NIGERIA | 2661 2661 | 1976-02-18 | Arent Fox Kintner Plotkin & Kahn, PLLC | Lagos | ||||
| 6550 | 6550 | 2015-05-29 | Federal Republic of Nigeria | 2015-01-16 | NIGERIA | 3911 3911 | 1986-12-01 | CMGRP, Inc. | BLock B" Federal Secretariat Area 1 | Abuja" | |||
| 6551 | 6551 | 2015-05-29 | Federal Republic of Nigeria | 2015-01-16 | NIGERIA | 6272 6272 | 2015-01-16 | Cassidy & Associates, Inc. | Block B" Federal Secretariat Area 1" | Abuja | |||
| 8543 | 8543 | 1996-07-04 | Federal Republic of Nigeria | 1995-07-17 | NIGERIA | 4729 4729 | 1992-11-02 | Barron-Birrell, Inc. | Abuja | ||||
| 9615 | 9615 | 1969-08-04 | Federal Republic of Nigeria | 1968-07-30 | NIGERIA | 2096 2096 | 1968-07-30 | Burson-Marsteller Associates | Lagos | ||||
| 10598 | 10598 | 2009-08-31 | Federal Republic of Nigeria | 2007-09-21 | NIGERIA | 5641 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | Maputo Street, Wuse Zone 3, P.M.N. 130 | Garki, Abuja | |||
| 11784 | 11784 | 2005-10-01 | Federal Republic of Nigeria | 1990-04-09 | NIGERIA | 2759 2759 | 1977-03-09 | White & Case, LLP | Lagos | ||||
| 11861 | 11861 | 2019-10-04 | Federal Republic of Nigeria | 2019-05-02 | NIGERIA | 6675 6675 | 2019-05-02 | Pagefield Global | Plot 71b, Shehu Shagari Way, Maitama Abuja, PMB 192 Garki | ||||
| 12245 | 12245 | 1993-10-21 | Federal Republic of Nigeria | 1992-11-02 | NIGERIA | 4729 4729 | 1992-11-02 | Barron-Birrell, Inc. | Abuja | ||||
| 12721 | 12721 | 1998-10-31 | Federal Republic of Nigeria | 1998-10-15 | NIGERIA | 5284 5284 | 1998-10-15 | EAW Group, Inc. | Abuja | ||||
| 14440 | 14440 | 1993-12-17 | Federal Republic of Nigeria | 1982-01-11 | NIGERIA | 1815 1815 | 1964-11-13 | Prather, Seeger, Doolittle & Farmer | Lagos | ||||
| 14554 | 14554 | 2012-12-21 | Federal Republic of Nigeria | 2010-01-20 | NIGERIA | 2165 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Ministry of Foreign Affairs | Maputo Street, Wuse Zone 3, P.M.B. 130 Garki, Abuja | |||
| 15437 | 15437 | 1991-12-31 | Federal Republic of Nigeria | 1990-11-14 | NIGERIA | 4436 4436 | 1990-11-14 | Edward Aycoth & Company, Inc. | Lagos | ||||
| 15693 | 15693 | 1999-12-31 | Federal Republic of Nigeria | 1998-03-03 | NIGERIA | 5240 5240 | 1998-03-03 | Davis Manafort & Freedman, Inc. | Abuja |
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) );