FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Registrant_Name = "Powell, Goldstein, Frazer & Murphy, L.L.P." and State = "" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 17
- Hong Kong Trade Development Council 2
- China National Textiles Import/Export Corporation 1
- Cuixmala Ecological Foundation 1
- Gilbert Bigio 1
- Hitachi, Ltd. 1
- Hoogovens Group, B.V. 1
- JSB Inkombank 1
- Kluwer, N.V. 1
- Koyo Seiko Company, Ltd. 1
- Minorco Societe Anonyme 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
- Societe Generale de Surveillance, S.A. 1
Country/Location_Represented 14
- COLOMBIA 2
- HONG KONG 2
- JAPAN 2
- NETHERLANDS 2
- CHINA 1
- HAITI 1
- LUXEMBOURG 1
- MEXICO 1
- NICARAGUA 1
- PALAU 1
- PERU 1
- RUSSIA 1
- SWITZERLAND 1
- THAILAND 1
Address_1 11 ✖
- - 7
- Bogota 2
- Deventer 1
- Geneva 1
- Koror 1
- Luxembourg-Ville 1
- Moscow 1
- Port-au-Prince 1
- Puerto Vallarta 1
- Tokyo 1
- Wanchai 1
State 1
- - · 18 ✖
Registrant_Name 1
- Powell, Goldstein, Frazer & Murphy, L.L.P. · 18 ✖
City 1
- - 18
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. | |||||
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. | |||||
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. | |||||
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. | |||||
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. | |||||
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. | |||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 |
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]) );