FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Address_1 = "Monrovia" and Foreign_Principal = "Republic of Liberia" sorted by Address_2 descending
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 11
- Barron-Birrell, Inc. 1
- Brenda Joyce & Associates, Inc. 1
- Cohen & Woods International, Inc. 1
- Dukes, Ofield 1
- Edelman International Corporation 1
- Financial Consultants, Inc. 1
- Kastor, Hilton, Chesley, Clifford & Atherton, Inc. 1
- Kramer, Charles 1
- Lininger, Fred T. 1
- Long, Parker, Doyle & Murphy 1
- Moss, Edward K. 1
State 1
- - 11
Foreign_Principal 1
- Republic of Liberia · 11 ✖
Country/Location_Represented 1
- LIBERIA 11
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2702 | 2702 | 1982-02-22 | Republic of Liberia | 1978-02-23 | LIBERIA | Brenda Joyce & Associates, Inc. 2866 | 1978-02-23 | Brenda Joyce & Associates, Inc. | Monrovia | ||||
3574 | 3574 | 1961-03-10 | Republic of Liberia | 1961-03-13 | LIBERIA | Kastor, Hilton, Chesley, Clifford & Atherton, Inc. 1372 | 1960-06-17 | Kastor, Hilton, Chesley, Clifford & Atherton, Inc. | Monrovia | ||||
3980 | 3980 | 1995-03-22 | Republic of Liberia | 1993-03-24 | LIBERIA | Barron-Birrell, Inc. 4729 | 1992-11-02 | Barron-Birrell, Inc. | Monrovia | ||||
6171 | 6171 | 1979-05-01 | Republic of Liberia | 1979-04-18 | LIBERIA | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | Monrovia | ||||
7520 | 7520 | 1960-06-03 | Republic of Liberia | 1955-06-03 | LIBERIA | Moss, Edward K. 894 | 1955-06-03 | Moss, Edward K. | Monrovia | ||||
7634 | 7634 | 1980-06-06 | Republic of Liberia | 1978-06-22 | LIBERIA | Long, Parker, Doyle & Murphy 2920 | 1978-06-22 | Long, Parker, Doyle & Murphy | Monrovia | ||||
8336 | 8336 | 1980-06-30 | Republic of Liberia | 1979-07-05 | LIBERIA | Dukes, Ofield 3034 | 1979-07-05 | Dukes, Ofield | Monrovia | ||||
10513 | 10513 | 1967-08-15 | Republic of Liberia | 1954-06-04 | LIBERIA | Kramer, Charles 831 | 1954-06-04 | Kramer, Charles | Monrovia | ||||
11520 | 11520 | 1975-09-12 | Republic of Liberia | 1958-03-28 | LIBERIA | Lininger, Fred T. 1125 | 1958-03-28 | Lininger, Fred T. | Monrovia | ||||
12847 | 12847 | 1969-10-19 | Republic of Liberia | 1962-05-21 | LIBERIA | Financial Consultants, Inc. 1544 | 1962-05-21 | Financial Consultants, Inc. | Monrovia | ||||
13390 | 13390 | 1999-10-31 | Republic of Liberia | 1999-04-12 | LIBERIA | Cohen & Woods International, Inc. 5003 | 1995-03-10 | Cohen & Woods International, Inc. | Monrovia |
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]) );