FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Foreign_Principal = "Government of Nicaragua" sorted by Address_2 descending
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 12
- Arnold & Porter Kaye Scholer LLP 1
- Barry, Frank M. 1
- Cramer & Lipsen 1
- Dorf & Stanton Communications, Inc. 1
- Fenton Communications, Inc. 1
- JWI, LLC 1
- Krock-Erwin Associates, Inc. 1
- MacKenzie McCheyne, Inc. 1
- Norman, Lawrence, Patterson & Farrell 1
- Pan-American Coffee Bureau 1
- Smithhart, Clyde Geral 1
- Sullivan, Sarria & Associates, Inc. 1
Foreign_Principal 1
- Government of Nicaragua · 12 ✖
Country/Location_Represented 1
- NICARAGUA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3224 | 3224 | 1969-03-01 | Government of Nicaragua | 1965-08-16 | NICARAGUA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Managua | ||||
3414 | 3414 | 1959-03-04 | Government of Nicaragua | 1958-09-04 | NICARAGUA | Smithhart, Clyde Geral 1167 | 1958-09-04 | Smithhart, Clyde Geral | Managua | ||||
3839 | 3839 | 1982-03-17 | Government of Nicaragua | 1982-03-03 | NICARAGUA | Fenton Communications, Inc. 3340 | 1982-03-03 | Fenton Communications, Inc. | DC | ||||
7851 | 7851 | 1996-06-15 | Government of Nicaragua | 1995-02-06 | NICARAGUA | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | Managua | ||||
9343 | 9343 | 1979-07-18 | Government of Nicaragua | 1976-10-05 | NICARAGUA | MacKenzie McCheyne, Inc. 2721 | 1976-10-05 | MacKenzie McCheyne, Inc. | Managua | ||||
9375 | 9375 | 1979-07-20 | Government of Nicaragua | 1977-06-10 | NICARAGUA | Cramer & Lipsen 2570 | 1975-04-01 | Cramer & Lipsen | Managua | ||||
10100 | 10100 | 1984-08-03 | Government of Nicaragua | 1975-06-20 | NICARAGUA | Sullivan, Sarria & Associates, Inc. 2593 | 1975-06-20 | Sullivan, Sarria & Associates, Inc. | Managua | ||||
10880 | 10880 | 1967-08-31 | Government of Nicaragua | 1957-01-03 | NICARAGUA | Barry, Frank M. 992 | 1957-01-03 | Barry, Frank M. | Managua | ||||
13219 | 13219 | 1978-10-31 | Government of Nicaragua | 1977-11-01 | NICARAGUA | Norman, Lawrence, Patterson & Farrell 2635 | 1975-11-26 | Norman, Lawrence, Patterson & Farrell | Managua | ||||
13576 | 13576 | 1990-11-01 | Government of Nicaragua | 1990-10-03 | NICARAGUA | Dorf & Stanton Communications, Inc. 4416 | 1990-10-03 | Dorf & Stanton Communications, Inc. | Managua | ||||
14243 | 14243 | 1980-11-25 | Government of Nicaragua | 1979-10-17 | NICARAGUA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Managua | ||||
15194 | 15194 | 1952-12-18 | Government of Nicaragua | 1952-06-18 | NICARAGUA | Krock-Erwin Associates, Inc. 730 | 1952-06-18 | Krock-Erwin Associates, Inc. | Managua |
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]) );