home / fara

Menu
  • Search all tables
  • GraphQL API

fara

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

Custom SQL query returning 17 rows (hide)

 
1
select 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 from FARA_All_ForeignPrincipals where "Foreign_Principal" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowidForeign_Principal_Termination_DateForeign_PrincipalForeign_Principal_Registration_DateCountry/Location_RepresentedRegistration_NumberRegistrant_DateRegistrant_NameAddress_1Address_2CityStateZip
286   Government of Japan 2023-05-10 JAPAN 7268 2023-05-10 Hunton Andrews Kurth LLP 2520 Massachusetts Avenue NW   Washington DC 20008
287   Government of Japan 2001-08-03 JAPAN 5451 2001-08-03 Hecht, Latham, Spencer & Associates, Inc. 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100        
1606 1969-01-29 Government of Japan 1963-07-29 JAPAN 1647 1963-07-29 Joyce Jr., William R. Washington     DC  
3681 1954-03-13 Government of Japan 1954-03-25 JAPAN 718 1952-02-26 Schaler, Butler & Associates Washington     DC  
3971 1991-03-22 Government of Japan 1989-06-15 JAPAN 4266 1989-06-12 Orrick, Herrington & Sutcliffe San Francisco     CA  
4486 1990-03-31 Government of Japan 1978-05-04 JAPAN 2888 1978-04-20 Wilbur F. Monroe Associates, Inc. Washington     DC  
4504 1991-03-31 Government of Japan 1991-04-18 JAPAN 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
4595 2001-03-31 Government of Japan 1956-01-25 JAPAN 929 1956-01-25 Japan Economic Institute of America Washington     DC  
6167 1979-05-01 Government of Japan 1979-04-18 JAPAN 2548 1974-11-29 Edelman International Corporation Tokyo        
6195 1986-05-01 Government of Japan 1985-09-16 JAPAN 3732 1985-09-16 OCS America, Inc.          
6419 1978-05-09 Government of Japan 1965-01-11 JAPAN 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy Tokyo        
7251 2015-05-31 Government of Japan 2015-05-01 JAPAN 3634 1984-11-15 Daniel J. Edelman, Inc. 2-3-1, Nagata-cho, Chiyoda-ku, Tokyo 100-8968        
7403 1989-06-01 Government of Japan 1988-07-29 JAPAN 4163 1988-07-29 Greve, Clifford, Diepenbrock & Paras San Francisco     CA  
8633 2003-06-30 Government of Japan 2002-01-30 JAPAN 5470 2002-01-30 Caplin & Drysdale, Chartered 3-1-1 Kasumigaseki, Chiyoda-ku Tokyo 100-8940        
11939 1976-09-30 Government of Japan 1976-11-11 JAPAN 1803 1964-10-19 Modern Education Services, Inc.          
12503 1965-10-06 Government of Japan 1964-04-06 JAPAN 1705 1964-04-06 Gregg, Norman Taylor Washington     DC  
14760 2019-12-02 Government of Japan 2019-09-05 JAPAN 6718 2019-09-05 Hale Strategies, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
Powered by Datasette · Queries took 9.638ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history