FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
35 rows where Registrant_Name = "Powell, Goldstein, Frazer & Murphy, L.L.P." sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Address_1
Foreign_Principal >30
- Embassy of the Republic of Singapore 2
- Hong Kong Trade Development Council 2
- Koyo Corporation of U.S.A. 2
- British Airways, PLC 1
- China National Textiles Import/Export Corporation 1
- Commercial Office of the Embassy of the People's Republic of China in Washington 1
- Cuixmala Ecological Foundation 1
- Dornier Medical Systems, Inc. 1
- Embassy of Pakistan - Commercial Division 1
- Gilbert Bigio 1
- Government of Hong Kong 1
- Government of Israel 1
- His Excellency M'Hamed Bargach, Embassy of Morocco 1
- Hitachi America, Ltd. 1
- Hitachi Sales Corporation of America 1
- Hitachi, Ltd. 1
- Hong Kong Economic and Trade Office 1
- Hoogovens Group, B.V. 1
- International Telecommunications Satellite Organization (INTELSAT) 1
- JSB Inkombank 1
- Kluwer, N.V. 1
- Koyo Seiko Company, Ltd. 1
- Minorco Societe Anonyme 1
- NVW (U.S.A.) 1
- PROEXPORT 1
- ProExport 1
- Republic of Nicaragua 1
- Republic of Palau 1
- Royal Thai Government, Department of Trade 1
- Secretary General's Office of the Andean Community 1
- …
Foreign_Principal_Termination_Date 27 ✖
- 1995-12-31 4
- 2002-05-03 3
- 1990-06-28 2
- 1992-08-12 2
- 1996-03-10 2
- 1984-04-30 1
- 1986-10-01 1
- 1988-10-31 1
- 1989-11-22 1
- 1989-11-30 1
- 1990-03-01 1
- 1990-04-01 1
- 1990-04-11 1
- 1990-06-22 1
- 1990-08-01 1
- 1993-04-09 1
- 1993-10-08 1
- 1994-04-08 1
- 1994-10-11 1
- 1995-04-10 1
- 1996-09-30 1
- 1998-03-31 1
- 1999-01-06 1
- 2000-02-14 1
- 2000-03-01 1
- 2001-06-12 1
- 2001-12-31 1
Country/Location_Represented 21
- JAPAN 6
- HONG KONG 4
- NETHERLANDS 3
- CHINA 2
- COLOMBIA 2
- INTERNATIONAL 2
- SINGAPORE 2
- GERMANY, FEDERAL REPUBLIC OF 1
- GREAT BRITAIN 1
- HAITI 1
- ISRAEL 1
- LUXEMBOURG 1
- MEXICO 1
- MOROCCO 1
- NICARAGUA 1
- PAKISTAN 1
- PALAU 1
- PERU 1
- RUSSIA 1
- SWITZERLAND 1
- THAILAND 1
Registrant_Name 1
- Powell, Goldstein, Frazer & Murphy, L.L.P. · 35 ✖
Registrant_Date (date) 1 ✖
- 1981-09-10 35
City 1
- - 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1111 | 1111 | 1999-01-06 | China National Textiles Import/Export Corporation | 1997-10-01 | CHINA | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | |||||
2528 | 2528 | 2000-02-14 | Secretary General's Office of the Andean Community | 1998-07-27 | PERU | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | |||||
3297 | 3297 | 1990-03-01 | Minorco Societe Anonyme | 1988-10-07 | LUXEMBOURG | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Luxembourg-Ville | ||||
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 | |||
3580 | 3580 | 1996-03-10 | Government of Israel | 1995-05-12 | ISRAEL | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Washington | DC | |||
3581 | 3581 | 1996-03-10 | Republic of Palau | 1994-10-31 | PALAU | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Koror | ||||
4569 | 4569 | 1998-03-31 | ProExport | 1997-10-01 | COLOMBIA | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Bogota | ||||
4924 | 4924 | 1990-04-01 | Hitachi, Ltd. | 1985-10-24 | JAPAN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Tokyo | ||||
5106 | 5106 | 1994-04-08 | Cuixmala Ecological Foundation | 1993-09-22 | MEXICO | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Puerto Vallarta | ||||
5119 | 5119 | 1993-04-09 | Gilbert Bigio | 1992-08-05 | HAITI | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Port-au-Prince | ||||
5148 | 5148 | 1995-04-10 | Royal Thai Government, Department of Trade | 1994-04-05 | THAILAND | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | |||||
5167 | 5167 | 1990-04-11 | Societe Generale de Surveillance, S.A. | 1987-04-03 | SWITZERLAND | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Geneva | ||||
5821 | 5821 | 1984-04-30 | Republic of Nicaragua | 1981-09-10 | NICARAGUA | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | |||||
6309 | 6309 | 2002-05-03 | Hong Kong Economic and Trade Office | 1997-11-21 | HONG KONG | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Washington | DC | |||
6310 | 6310 | 2002-05-03 | Hong Kong Trade Development Council | 1997-10-01 | HONG KONG | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Wanchai | ||||
6311 | 6311 | 2002-05-03 | PROEXPORT | 1999-01-06 | COLOMBIA | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Bogota | ||||
7773 | 7773 | 2001-06-12 | Embassy of Pakistan - Commercial Division | 2001-04-11 | PAKISTAN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | 2201 R Street, N.W. 20008 | DC | |||
8008 | 8008 | 1990-06-22 | Hitachi Sales Corporation of America | 1987-04-10 | JAPAN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Compton | CA | |||
8137 | 8137 | 1990-06-28 | Koyo Corporation of U.S.A. | 1989-06-28 | JAPAN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Westlake | OH | |||
8138 | 8138 | 1990-06-28 | Koyo Seiko Company, Ltd. | 1989-06-28 | JAPAN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | |||||
10008 | 10008 | 1990-08-01 | His Excellency M'Hamed Bargach, Embassy of Morocco | 1987-03-31 | MOROCCO | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Washington | DC | |||
10305 | 10305 | 1992-08-12 | Hoogovens Group, B.V. | 1989-06-28 | NETHERLANDS | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | |||||
10307 | 10307 | 1992-08-12 | NVW (U.S.A.) | 1989-06-28 | NETHERLANDS | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Scarsdale | NY | |||
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 | |||
12355 | 12355 | 1986-10-01 | Kluwer, N.V. | 1986-04-10 | NETHERLANDS | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Deventer | ||||
12553 | 12553 | 1993-10-08 | Hong Kong Trade Development Council | 1993-04-09 | HONG KONG | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | |||||
12604 | 12604 | 1994-10-11 | Government of Hong Kong | 1993-04-27 | HONG KONG | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Washington | DC | |||
13250 | 13250 | 1988-10-31 | Dornier Medical Systems, Inc. | 1988-03-17 | GERMANY, FEDERAL REPUBLIC OF | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Marietta | GA | |||
14167 | 14167 | 1989-11-22 | Sunbelt Corporation | 1988-06-30 | INTERNATIONAL | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Baltimore | MD | |||
14393 | 14393 | 1989-11-30 | Hitachi America, Ltd. | 1987-09-25 | JAPAN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Tarrytown | NY | |||
16294 | 16294 | 1995-12-31 | British Airways, PLC | 1993-03-01 | GREAT BRITAIN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Jackson Heights | NY | |||
16340 | 16340 | 1995-12-31 | International Telecommunications Satellite Organization (INTELSAT) | 1985-05-13 | INTERNATIONAL | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Washington | DC | |||
16343 | 16343 | 1995-12-31 | JSB Inkombank | 1995-10-06 | RUSSIA | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Moscow | ||||
16349 | 16349 | 1995-12-31 | Koyo Corporation of U.S.A. | 1992-06-04 | JAPAN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Westlake | OH | |||
16491 | 16491 | 2001-12-31 | Commercial Office of the Embassy of the People's Republic of China in Washington | 1999-01-06 | CHINA | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | 2133 Wisconsin 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]) );