FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where Country/Location_Represented = "EL SALVADOR" and State = "DC" sorted by Registrant_Date descending
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Zip, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Registrant_Name 20
- van Kloberg & Associates, Ltd. 2
- Arrive Unlimited Corporation 1
- Bannerman & Associates, Inc. 1
- Black, Kelly, Scruggs & Healey 1
- Byrnes, Sue 1
- Foley Hoag, LLP 1
- Greenberg Traurig, LLP 1
- Hemisphere Associates, Inc. 1
- Hogan Lovells US LLP 1
- Jefferson Group, Inc. 1
- Johnson, Madigan, Peck, Boland, Dover & Stewart, Inc. 1
- Manchester Trade, Ltd. 1
- North American Precis Syndicate 1
- O'Connor & Hannan, L.L.P. 1
- Phoenix Group 1
- Rick Swartz & Associates, Inc. 1
- Shepardson, Stern & Kaminsky 1
- Tew Cardenas, LLP 1
- Torres, Eduardo 1
- Veve, Michael E. 1
Foreign_Principal_Registration_Date (date) 20 ✖
- 1997-06-17 2
- 1981-10-20 1
- 1983-06-15 1
- 1989-10-23 1
- 1990-07-16 1
- 1990-10-01 1
- 1991-02-25 1
- 1992-10-23 1
- 1992-12-08 1
- 1993-01-13 1
- 1993-07-29 1
- 1994-06-28 1
- 1994-10-04 1
- 1995-09-08 1
- 1995-11-16 1
- 1998-10-14 1
- 2002-10-18 1
- 2003-07-16 1
- 2005-12-09 1
- 2006-04-06 1
Foreign_Principal 5
City 2
- - 19
- Washington 2
State 1
- DC · 21 ✖
Country/Location_Represented 1
- EL SALVADOR · 21 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16618 | 16618 | 2007-12-31 | Government of El Salvador, Embassy | 2005-12-09 | EL SALVADOR | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | 2308 California Street, NW | Washington | DC | 20008 | |
7211 | 7211 | 2006-05-31 | Republic of El Salvador | 2003-07-16 | EL SALVADOR | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | Embassy of El Salvador | DC | |||
5045 | 5045 | 2005-04-05 | Government of El Salvador, Embassy | 2002-10-18 | EL SALVADOR | Johnson, Madigan, Peck, Boland, Dover & Stewart, Inc. 5526 | 2002-10-18 | Johnson, Madigan, Peck, Boland, Dover & Stewart, Inc. | 2308 California Street, N.W. 20008 | DC | |||
3881 | 3881 | 1998-03-18 | Government of El Salvador, Embassy | 1997-06-17 | EL SALVADOR | Rick Swartz & Associates, Inc. 5185 | 1997-06-17 | Rick Swartz & Associates, Inc. | Washington | DC | |||
7152 | 7152 | 1996-05-31 | Embassy of El Salvador | 1995-11-16 | EL SALVADOR | Shepardson, Stern & Kaminsky 5078 | 1995-11-16 | Shepardson, Stern & Kaminsky | Washington | DC | |||
12093 | 12093 | 1998-09-30 | Government of El Salvador, Embassy | 1995-09-08 | EL SALVADOR | Phoenix Group 5060 | 1995-09-08 | Phoenix Group | Washington | DC | |||
958 | 958 | 1995-01-01 | Embassy of El Salvador | 1994-10-04 | EL SALVADOR | Manchester Trade, Ltd. 4956 | 1994-10-04 | Manchester Trade, Ltd. | Washington | DC | |||
1478 | 1478 | 1995-01-23 | Embassy of El Salvador | 1994-06-28 | EL SALVADOR | Byrnes, Sue 4923 | 1994-06-28 | Byrnes, Sue | Washington | DC | |||
6026 | 6026 | 2006-04-30 | Embassy of El Salvador | 2006-04-06 | EL SALVADOR | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | 2308 California Street, NW | Washington | DC | 20008 | |
15304 | 15304 | 2009-12-21 | Embassy of El Salvador | 1993-01-13 | EL SALVADOR | Veve, Michael E. 4751 | 1993-01-13 | Veve, Michael E. | Washington | DC | |||
9267 | 9267 | 1992-07-15 | Embassy of El Salvador | 1990-07-16 | EL SALVADOR | Torres, Eduardo 4400 | 1990-07-16 | Torres, Eduardo | Washington | DC | |||
4000 | 4000 | 1995-03-23 | Embassy of El Salvador | 1992-10-23 | EL SALVADOR | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | Washington | DC | |||
4648 | 4648 | 2006-03-31 | Embassy of El Salvador | 1993-07-29 | EL SALVADOR | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | Washington | DC | |||
14845 | 14845 | 1999-12-06 | Government of El Salvador, Embassy | 1998-10-14 | EL SALVADOR | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Washington | DC | |||
9040 | 9040 | 1987-07-06 | Republic of El Salvador | 1983-06-15 | EL SALVADOR | Arrive Unlimited Corporation 3483 | 1983-06-15 | Arrive Unlimited Corporation | Washington | DC | |||
6483 | 6483 | 1995-05-12 | Embassy of El Salvador | 1992-12-08 | EL SALVADOR | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | Washington | DC | |||
15493 | 15493 | 1991-12-30 | Embassy of El Salvador | 1991-02-25 | EL SALVADOR | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | Washington | DC | |||
7822 | 7822 | 1982-06-15 | Embassy of El Salvador | 1981-10-20 | EL SALVADOR | Hemisphere Associates, Inc. 3290 | 1981-10-20 | Hemisphere Associates, Inc. | DC | ||||
14245 | 14245 | 1992-11-25 | Government of El Salvador | 1989-10-23 | EL SALVADOR | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Washington | DC | |||
13731 | 13731 | 1990-11-05 | Committee for Democracy in El Salvador (Through O'Connor & Hannan) | 1990-10-01 | EL SALVADOR | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
3050 | 3050 | 2002-02-28 | Government of El Salvador, Embassy | 1997-06-17 | EL SALVADOR | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 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]) );