FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Address_1 = "Washington" and Country/Location_Represented = "LIBERIA"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 11
Foreign_Principal 7
State 1
- DC 12
Country/Location_Represented 1
- LIBERIA · 12 ✖
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2047 | 2047 | 1994-02-01 | American Environmental Company, Inc. | 1992-06-19 | LIBERIA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
2901 | 2901 | 1960-02-28 | Embassy of Liberia | 1958-07-09 | LIBERIA | DeVeau, J. Harold 1156 | 1958-07-09 | DeVeau, J. Harold | Washington | DC | |||
3368 | 3368 | 1973-03-02 | Liberian Embassy | 1958-07-09 | LIBERIA | Cooper, Harold 1155 | 1958-07-09 | Cooper, Harold | Washington | DC | |||
4339 | 4339 | 1971-03-31 | Embassy of Liberia | 1969-11-04 | LIBERIA | Mode, Douglas G. 2167 | 1969-11-04 | Mode, Douglas G. | Washington | DC | |||
5745 | 5745 | 1993-04-29 | Interim Government of Liberia | 1992-04-28 | LIBERIA | Agendas International, Inc. 3524 | 1983-09-30 | Agendas International, Inc. | Washington | DC | |||
5794 | 5794 | 1972-04-30 | Embassy of Liberia | 1971-08-12 | LIBERIA | Cooper, Harold 1155 | 1958-07-09 | Cooper, Harold | Washington | DC | |||
8264 | 8264 | 1968-06-30 | Embassy of Liberia | 1963-03-28 | LIBERIA | Murden & Company, Inc. 1510 | 1962-01-17 | Murden & Company, Inc. | Washington | DC | |||
8287 | 8287 | 1972-06-30 | Embassy of the Republic of Liberia | 1971-07-23 | LIBERIA | Baron/Canning & Company, Inc. 2270 | 1971-07-23 | Baron/Canning & Company, Inc. | Washington | DC | |||
8839 | 8839 | 1972-07-01 | Liberian Embassy | 1970-10-06 | LIBERIA | B.M. Lawrence & Company 2211 | 1970-10-06 | B.M. Lawrence & Company | Washington | DC | |||
10830 | 10830 | 1956-08-30 | Republic of Liberia | 1952-02-26 | LIBERIA | Schaler, Butler & Associates 718 | 1952-02-26 | Schaler, Butler & Associates | Washington | DC | |||
11923 | 11923 | 1970-09-30 | Embassy of the Republic of Liberia | 1969-11-13 | LIBERIA | Sydney S. Baron & Company, Inc. 2170 | 1969-11-13 | Sydney S. Baron & Company, Inc. | Washington | DC | |||
15481 | 15481 | 1982-12-30 | Republic of Liberia, Embassy of Liberia | 1976-07-13 | LIBERIA | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | Washington | DC |
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]) );