FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Foreign_Principal = "Government of Japan" and State = "DC" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Zip, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Registrant_Name 7
Foreign_Principal_Registration_Date (date) 7 ✖
- 1954-03-25 1
- 1956-01-25 1
- 1963-07-29 1
- 1964-04-06 1
- 1978-05-04 1
- 2019-09-05 1
- 2023-05-10 1
Address_1 3 ✖
City 2
- - 5
- Washington 2
State 1
- DC · 7 ✖
Foreign_Principal 1
- Government of Japan · 7 ✖
Country/Location_Represented 1
- JAPAN 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3681 | 3681 | 1954-03-13 | Government of Japan | 1954-03-25 | JAPAN | Schaler, Butler & Associates 718 | 1952-02-26 | Schaler, Butler & Associates | Washington | DC | |||
4595 | 4595 | 2001-03-31 | Government of Japan | 1956-01-25 | JAPAN | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | Washington | DC | |||
1606 | 1606 | 1969-01-29 | Government of Japan | 1963-07-29 | JAPAN | Joyce Jr., William R. 1647 | 1963-07-29 | Joyce Jr., William R. | Washington | DC | |||
12503 | 12503 | 1965-10-06 | Government of Japan | 1964-04-06 | JAPAN | Gregg, Norman Taylor 1705 | 1964-04-06 | Gregg, Norman Taylor | Washington | DC | |||
4486 | 4486 | 1990-03-31 | Government of Japan | 1978-05-04 | JAPAN | Wilbur F. Monroe Associates, Inc. 2888 | 1978-04-20 | Wilbur F. Monroe Associates, Inc. | Washington | DC | |||
14760 | 14760 | 2019-12-02 | Government of Japan | 2019-09-05 | JAPAN | Hale Strategies, LLC 6718 | 2019-09-05 | Hale Strategies, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
286 | 286 | Government of Japan | 2023-05-10 | JAPAN | Hunton Andrews Kurth LLP 7268 | 2023-05-10 | Hunton Andrews Kurth LLP | 2520 Massachusetts Avenue NW | Washington | DC | 20008 |
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]) );