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 2005-03-31 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 8
- Consulate of Japan at Los Angeles, CA 1
- Government of Albania Ministry of Foreign Affairs, Embassy 1
- Government of Bermuda 1
- Government of Pakistan, Embassy 1
- Government of Panama 1
- Gowling Lafleur Henderson LLP on behalf of City of Windsor (ONT) 1
- Monaco Government Tourist & Convention Bureau 1
- National Fisheries Cooperative Council of Nori and Lavor Products 1
Registrant_Name 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4638 | 4638 | 2005-03-31 | Consulate of Japan at Los Angeles, CA | 2002-06-18 | JAPAN | Policy Development Group, Inc. 5504 | 2002-06-18 | Policy Development Group, Inc. | 350 S. Grand Avenue, Suite 1700 Los Angeles | CA | |||
4639 | 4639 | 2005-03-31 | Government of Albania Ministry of Foreign Affairs, Embassy | 2003-03-04 | ALBANIA | Reffe, Paige E. 5333 | 1999-10-12 | Reffe, Paige E. | 2100 S Street, N.W. 20008 | DC | |||
4640 | 4640 | 2005-03-31 | Government of Bermuda | 1994-10-06 | BERMUDA | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | Hamilton | ||||
4641 | 4641 | 2005-03-31 | Government of Pakistan, Embassy | 2001-08-03 | PAKISTAN | Wilson Associates, LLC 5450 | 2001-08-03 | Wilson Associates, LLC | 2315 Massachusetts Avenue, N.W. | DC | |||
4642 | 4642 | 2005-03-31 | Government of Panama | 2003-05-30 | PANAMA | Johnson, Madigan, Peck, Boland, Dover & Stewart, Inc. 5526 | 2002-10-18 | Johnson, Madigan, Peck, Boland, Dover & Stewart, Inc. | Joaquin Jacome Diez Ministry of Trade and Industry Plaza Edison, Sector El Paical Pisos 2 y 3, Re | ||||
4643 | 4643 | 2005-03-31 | Gowling Lafleur Henderson LLP on behalf of City of Windsor (ONT) | 2004-11-12 | CANADA | Public I 5657 | 2004-11-12 | Public I | 40 King Street, W Suite 5800, Toronto, Ontario M5H 3Z7 | ||||
4644 | 4644 | 2005-03-31 | Monaco Government Tourist & Convention Bureau | 1993-09-10 | MONACO | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | New York | NY | |||
4645 | 4645 | 2005-03-31 | National Fisheries Cooperative Council of Nori and Lavor Products | 2004-09-23 | JAPAN | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | 7th Floor Coop. Building 1-1-12 Uchikanda, Chiyoda-ku Tokyo, Japan 101-8503 |
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]) );