FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Country/Location_Represented = "SRI LANKA" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 11
- Squire Patton Boggs, LLP 2
- Alcalde & Fay 1
- Cranford Johnson Robinson Woods, Inc. 1
- Daniel J. Edelman, Inc. 1
- Fasturn, Inc. 1
- Girgenti, Sienna Brielle 1
- Hedges Strategies 1
- International Development Systems, Inc. 1
- Majority Group, LLC 1
- Rogers & Cowan, Inc., Washington Office 1
- Sandler, Travis & Rosenberg, P.A. 1
Foreign_Principal 6
City 2
- - 7
- Washington 5
State 1
- DC · 12 ✖
Country/Location_Represented 1
- SRI LANKA · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1021 | 1021 | 2015-01-01 | Embassy of Sri Lanka | 2013-04-08 | SRI LANKA | Majority Group, LLC 6087 | 2012-02-03 | Majority Group, LLC | 2148 Wyoming Avenue, NW | Washington | DC | 20008 | |
2430 | 2430 | 2013-02-12 | Embassy of Sri Lanka | 2009-02-17 | SRI LANKA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2148 Wyoming Avenue, NW | Washington | DC | 20008 | |
5105 | 5105 | 1993-04-08 | Government of Sri Lanka | 1993-01-11 | SRI LANKA | Alcalde & Fay 3571 | 1984-03-14 | Alcalde & Fay | Washington | DC | |||
7447 | 7447 | 2010-06-01 | Democratic Socialist Republic of Sri Lanka, Embassy | 2009-02-04 | SRI LANKA | Cranford Johnson Robinson Woods, Inc. 5905 | 2009-02-04 | Cranford Johnson Robinson Woods, Inc. | 2148 Wyoming Avenue, NW | Washington | DC | 20008 | |
8640 | 8640 | 2004-06-30 | Republic of Sri Lanka, Embassy | 2003-12-15 | SRI LANKA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2148 Wyoming Avenue, N.W. 20008 | DC | |||
8917 | 8917 | 2003-07-01 | Embassy of Sri Lanka | 2003-04-21 | SRI LANKA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 2148 Wyoming Avenue, N.W. 20008 | DC | |||
8934 | 8934 | 2012-07-01 | Embassy of Sri Lanka | 2010-01-07 | SRI LANKA | Hedges Strategies 5970 | 2010-01-07 | Hedges Strategies | 2148 Wyoming Avenue, NW | Washington | DC | 20008 | |
9214 | 9214 | 1993-07-13 | Embassy of Sri Lanka | 1992-07-15 | SRI LANKA | International Development Systems, Inc. 4012 | 1987-07-13 | International Development Systems, Inc. | Washington | DC | |||
9635 | 9635 | 2013-07-30 | Embassy of Sri Lanka | 2011-03-23 | SRI LANKA | Girgenti, Sienna Brielle 6030 | 2011-03-23 | Girgenti, Sienna Brielle | 2148 Wyoming Avenue, NW | Washington | DC | 20008 | |
9853 | 9853 | 2004-07-31 | Government of Sri Lanka, Embassy | 2003-02-07 | SRI LANKA | Sandler, Travis & Rosenberg, P.A. 5303 | 1998-12-07 | Sandler, Travis & Rosenberg, P.A. | 2148 Wyoming Avenue, N.W. 20008 | DC | |||
12707 | 12707 | 1986-10-15 | Democratic Socialist Republic of Sri Lanka | 1985-10-30 | SRI LANKA | Rogers & Cowan, Inc., Washington Office 3707 | 1985-07-29 | Rogers & Cowan, Inc., Washington Office | Washington | DC | |||
16479 | 16479 | 2000-12-31 | Government of Sri Lanka, Embassy | 1998-03-16 | SRI LANKA | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | 2148 Wyoming Avenue N.W. | 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]) );