FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Address_1 = "Washington" and Country/Location_Represented = "THAILAND"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 14
- Hill and Knowlton Strategies, LLC 2
- Albrecht, Inc. 1
- Bisnow, Mark C. 1
- Colby, Baily & Associates 1
- Dickstein Shapiro, LLP 1
- Donovan, Leisure, Newton & Irvine 1
- Dorsey & Whitney 1
- Fitzgerald, David M. 1
- Grant, George 1
- International Trade & Development Agency, Inc. 1
- L.A. Motley & Company 1
- Menefee, Selden C. 1
- Shaheen & White, Inc. 1
- Smith McCabe, Ltd. 1
Foreign_Principal 12
- Royal Thai Embassy 3
- Government of Thailand 2
- Embassy of Thailand 1
- Government of Thailand (Royal Thai Embassy) 1
- Government of Thailand, Embassy 1
- Kingdom of Thailand 1
- Office of Commercial Affairs of the Royal Thai Embassy 1
- Royal Government of Thailand 1
- Royal Siamese Government 1
- Royal Siamese Legation 1
- Royal Thai Embassy - Office of Commercial Affairs 1
- Royal Thai Government 1
State 1
- DC 15
Country/Location_Represented 1
- THAILAND · 15 ✖
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1807 | 1807 | 1997-01-31 | Government of Thailand, Embassy | 1996-04-16 | THAILAND | Smith McCabe, Ltd. 4687 | 1992-06-26 | Smith McCabe, Ltd. | Washington | DC | |||
3047 | 3047 | 2001-02-28 | Royal Thai Embassy | 1987-03-05 | THAILAND | International Trade & Development Agency, Inc. 3690 | 1985-06-13 | International Trade & Development Agency, Inc. | Washington | DC | |||
3200 | 3200 | 1946-03-01 | Royal Siamese Legation | 1945-10-15 | THAILAND | Menefee, Selden C. 325 | 1945-10-15 | Menefee, Selden C. | Washington | DC | |||
4895 | 4895 | 1985-04-01 | Royal Thai Government | 1984-04-02 | THAILAND | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
5866 | 5866 | 1991-04-30 | Embassy of Thailand | 1989-10-12 | THAILAND | Bisnow, Mark C. 4306 | 1989-10-12 | Bisnow, Mark C. | Washington | DC | |||
6196 | 6196 | 1986-05-01 | Royal Thai Embassy | 1985-08-20 | THAILAND | Colby, Baily & Associates 3663 | 1985-03-22 | Colby, Baily & Associates | Washington | DC | |||
7432 | 7432 | 1998-06-01 | Royal Thai Embassy - Office of Commercial Affairs | 1997-03-17 | THAILAND | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | Washington | DC | |||
10321 | 10321 | 1985-08-13 | Kingdom of Thailand | 1981-02-24 | THAILAND | Fitzgerald, David M. 3203 | 1981-02-24 | Fitzgerald, David M. | Washington | DC | |||
10780 | 10780 | 1995-08-27 | Office of Commercial Affairs of the Royal Thai Embassy | 1995-08-04 | THAILAND | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Washington | DC | |||
11421 | 11421 | 1946-09-08 | Royal Siamese Government | 1946-08-23 | THAILAND | Shaheen & White, Inc. 369 | 1946-08-23 | Shaheen & White, Inc. | Washington | DC | |||
12007 | 12007 | 1989-09-30 | Government of Thailand (Royal Thai Embassy) | 1989-02-03 | THAILAND | Dorsey & Whitney 4214 | 1989-02-03 | Dorsey & Whitney | Washington | DC | |||
13112 | 13112 | 1965-10-29 | Government of Thailand | 1965-07-22 | THAILAND | Grant, George 1908 | 1965-07-22 | Grant, George | Washington | DC | |||
13800 | 13800 | 1987-11-07 | Royal Thai Embassy | 1985-11-06 | THAILAND | Albrecht, Inc. 3754 | 1985-11-06 | Albrecht, Inc. | Washington | DC | |||
14985 | 14985 | 1993-12-10 | Royal Government of Thailand | 1993-09-23 | THAILAND | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
15560 | 15560 | 1956-12-31 | Government of Thailand | 1955-02-18 | THAILAND | Donovan, Leisure, Newton & Irvine 873 | 1955-02-18 | Donovan, Leisure, Newton & Irvine | Washington | DC |
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]) );