FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
129 rows where Registrant_Name = "POWELL, GOLDSTEIN, FRAZER & MURPHY LLP" and Registration_Number = 3274
This data as json, CSV (advanced)
These facets timed out: Registrant_Name
Foreign_Principal_Name 27
- - 93
- BRITISH AIRWAYS, PLC 3
- CUIXMALA ECOLOGICAL FOUNDATION 2
- DORNIER MEDICAL SYSTEMS, INC. 2
- EMBASSY OF THE REPUBLIC OF SINGAPORE 2
- GILBERT BIGIO 2
- HITACHI SALES CORPORATION OF AMERICA 2
- HONG KONG TRADE DEVELOPMENT COUNCIL 2
- KOYO CORPORATION OF U.S.A. 2
- KOYO SEIKO COMPANY, LTD. 2
- BRITISH AIRWAYS PLC 1
- GOVERNMENT OF HONG KONG 1
- GOVERNMENT OF ISRAEL 1
- HIS EXCELLENCY M'HAMED BARGACH 1
- HITACHI, LTD. 1
- HOOGOVENS GROUP, B.V. 1
- INTERNATIONAL TELECOMMUNICATIONS SATELLITE 1
- INTERNATIONAL TELECOMMUNICATIONS SATELLITE ORGANIZATION 1
- JSB INKOMBANK 1
- KLUWER, N.V. 1
- MINORCO SOCIETE ANONYME 1
- NVW (U.S.A.) 1
- REPUBLIC OF NICARAGUA 1
- REPUBLIC OF PALAU 1
- ROYAL THAI GOVERNMENT, DEPARTMENT OF TRADE 1
- SOCIETE GENERALE DE SURVEILLANCE, S.A. 1
- SUNBELT CORPORATION 1
Foreign_Principal_Country 18
- - 93
- JAPAN 7
- GREAT BRITAIN 4
- HONG KONG 3
- INTERNATIONAL 3
- NETHERLANDS 3
- GERMANY FEDERAL REPUBLIC OF 2
- HAITI 2
- MEXICO 2
- SINGAPORE 2
- ISRAEL 1
- LUXEMBOURG 1
- MOROCCO 1
- NICARAGUA 1
- PALAU 1
- RUSSIA 1
- SWITZERLAND 1
- THAILAND 1
Document_Type 7
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );