FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Country/Location_Represented = "SINGAPORE" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registration_Number 12 ✖
- Powell, Goldstein, Frazer & Murphy, L.L.P. 2
- Tanaka, Michele N. 1
- Hogan Lovells US LLP 1
- Bracy Williams & Company 1
- Michael K. Deaver & Associates 1
- APCO Worldwide, Inc. 1
- Reed, T. Dean 1
- MWW/Strategic Communications, Inc. 1
- Fontheim International, LLC 1
- Madison Government Affairs 1
- Fleishman-Hillard, Inc. 1
- Fratelli Group 1
Registrant_Name 12
- Powell, Goldstein, Frazer & Murphy, L.L.P. 2
- APCO Worldwide, Inc. 1
- Bracy Williams & Company 1
- Fleishman-Hillard, Inc. 1
- Fontheim International, LLC 1
- Fratelli Group 1
- Hogan Lovells US LLP 1
- MWW/Strategic Communications, Inc. 1
- Madison Government Affairs 1
- Michael K. Deaver & Associates 1
- Reed, T. Dean 1
- Tanaka, Michele N. 1
Foreign_Principal 7
City 2
- - 10
- Washington 3
State 1
- DC · 13 ✖
Country/Location_Represented 1
- SINGAPORE · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309 | 309 | Government of the Republic of Singapore | 2018-03-09 | SINGAPORE | Fratelli Group 5867 | 2008-06-03 | Fratelli Group | 3501 International Place, NW | Washington | DC | 20008 | ||
3103 | 3103 | 2013-02-28 | Republic of Singapore, Embassy | 1995-09-13 | SINGAPORE | Reed, T. Dean 5044 | 1995-09-13 | Reed, T. Dean | Washington | DC | |||
3127 | 3127 | 2018-02-28 | Embassy of Singapore | 2013-03-12 | SINGAPORE | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 3501 International Place, NW | Washington | DC | 20008 | |
3324 | 3324 | 2000-03-01 | Embassy of the Republic of Singapore | 1999-06-30 | SINGAPORE | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | 3501 International Place, NW Washington, DC 20008 | DC | |||
3334 | 3334 | 2005-03-01 | Embassy of Singapore | 2004-09-01 | SINGAPORE | Madison Government Affairs 5642 | 2004-09-01 | Madison Government Affairs | 3501 International Place 20008 | DC | |||
3336 | 3336 | 2007-03-01 | Embassy of Singapore | 2006-02-02 | SINGAPORE | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 3501 International Place, NW | Washington | DC | 20008 | |
4628 | 4628 | 2003-03-31 | Republic of Singapore, Embassy | 1996-04-26 | SINGAPORE | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Washington | DC | |||
5283 | 5283 | 1986-04-15 | Government of Singapore | 1985-12-27 | SINGAPORE | Michael K. Deaver & Associates 3734 | 1985-09-18 | Michael K. Deaver & Associates | Washington | DC | |||
5808 | 5808 | 1976-04-30 | Embassy of Republic of Singapore | 1976-05-02 | SINGAPORE | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | DC | ||||
6264 | 6264 | 1986-05-02 | Singapore Airlines, Ltd. | 1984-09-14 | SINGAPORE | Bracy Williams & Company 3612 | 1984-09-14 | Bracy Williams & Company | Washington | DC | |||
9848 | 9848 | 2003-07-31 | Republic of Singapore, Embassy | 2002-07-25 | SINGAPORE | Fontheim International, LLC 5501 | 2001-11-21 | Fontheim International, LLC | 3501 International Place, N.W. 20008 | DC | |||
12076 | 12076 | 1996-09-30 | Embassy of the Republic of Singapore | 1995-11-09 | SINGAPORE | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Washington | DC | |||
12778 | 12778 | 1996-10-16 | Republic of Singapore, Embassy | 1996-10-25 | SINGAPORE | MWW/Strategic Communications, Inc. 5149 | 1996-09-30 | MWW/Strategic Communications, Inc. | 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]) );