FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Registrant_Name = "Swidler Berlin Shereff Friedman, LLP" and Registration_Number = 4079
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 14
- China External Trade Development Council 1
- Consolidated Iron Resources, Ltd. 1
- Government of Bermuda 1
- Government of Haiti, Ministry of Finance 1
- Government of Panama 1
- Government of Republic of Liberia 1
- Government of the British Virgin Islands 1
- Hyundai Corporation 1
- Hyundai Engineering & Construction Company, Ltd. 1
- Hyundai Motor Company 1
- National Patriotic Reconstruction Assembly Government 1
- Roussel-UCLAF 1
- STC, PLC 1
- Secretaria de Comunicaciones y Transportes 1
Country/Location_Represented 10
- KOREA, SOUTH 3
- GREAT BRITAIN 2
- LIBERIA 2
- BERMUDA 1
- BRITISH VIRGIN ISLANDS 1
- FRANCE 1
- HAITI 1
- MEXICO 1
- PANAMA 1
- TAIWAN 1
State 1
- - 14
Registrant_Name 1
- Swidler Berlin Shereff Friedman, LLP · 14 ✖
City 1
- - 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1078 | 1078 | 1996-01-05 | Hyundai Corporation | 1994-12-15 | KOREA, SOUTH | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Seoul | ||||
1079 | 1079 | 1996-01-05 | Hyundai Engineering & Construction Company, Ltd. | 1994-12-15 | KOREA, SOUTH | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Seoul | ||||
1131 | 1131 | 1994-01-07 | Government of the British Virgin Islands | 1992-12-16 | BRITISH VIRGIN ISLANDS | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Tortola | ||||
1447 | 1447 | 1990-01-21 | Government of Haiti, Ministry of Finance | 1989-07-07 | HAITI | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Port-au-Prince | ||||
3321 | 3321 | 1998-03-01 | Secretaria de Comunicaciones y Transportes | 1996-01-31 | MEXICO | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Mexico City | ||||
3691 | 3691 | 1995-03-13 | Government of Panama | 1993-11-05 | PANAMA | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Panama City | ||||
5623 | 5623 | 1993-04-27 | National Patriotic Reconstruction Assembly Government | 1991-05-31 | LIBERIA | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Monrovia | ||||
6438 | 6438 | 1991-05-10 | Consolidated Iron Resources, Ltd. | 1991-03-15 | GREAT BRITAIN | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | London, England | ||||
6689 | 6689 | 1990-05-21 | Government of Bermuda | 1988-11-03 | BERMUDA | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Hamilton | ||||
7991 | 7991 | 1996-06-21 | Hyundai Motor Company | 1988-01-07 | KOREA, SOUTH | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Seoul | ||||
7992 | 7992 | 1996-06-21 | Roussel-UCLAF | 1993-09-22 | FRANCE | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Paris | ||||
8448 | 8448 | 1989-06-30 | STC, PLC | 1988-10-07 | GREAT BRITAIN | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | London | ||||
9078 | 9078 | 2000-07-07 | Government of Republic of Liberia | 1997-09-17 | LIBERIA | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Monrovia | ||||
10995 | 10995 | 1990-08-31 | China External Trade Development Council | 1989-02-03 | TAIWAN | Swidler Berlin Shereff Friedman, LLP 4079 | 1988-01-07 | Swidler Berlin Shereff Friedman, LLP | Taipai |
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]) );