FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
482 rows where Date_Stamped = "1993-03-01"
This data as json, CSV (advanced)
Suggested facets: Date_Stamped (date)
These facets timed out: Document_Type
Registrant_Name >30
- HONG KONG GOVERNMENT (INDUSTRY DEPARTMENT) 36
- KOREAN TELEVISION ENTERPRISES, LTD. 25
- ST. LUCIA NATIONAL DEVELOPMENT CORPORATION 19
- DUBAI COMMERCE & TOURISM PROMOTION BOARD 17
- PALESTINE AFFAIRS CENTER 12
- BROWNSTEIN, ZEIDMAN & LORE 10
- DANIEL J. EDELMAN, INC. 10
- GOVERNMENT OF HONG KONG INDUSTRY DEPARTMENT 10
- HILL & KNOWLTON, INC. 9
- QUEBEC GOVERNMENT HOUSE 8
- JETRO, ATLANTA 6
- PIERSON, SEMMES & BEMIS 6
- APCO ASSOCIATES, INC. 5
- ARNOLD & PORTER 5
- OLIVER A. DULLE, JR. & COMPANY, INC. 5
- SHAW, PITTMAN, POTTS & TROWBRIDGE 5
- CASSIDY & ASSOCIATES, INC. 4
- JETRO, CHICAGO 4
- LOCATE IN SCOTLAND 4
- OFFICE OF THE TURKISH REPUBLIC OF NORTHERN CYPRUS 4
- PAUL, HASTINGS, JANOFSKY & WALKER 4
- AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 3
- BAILEY, KINGSLEY 3
- CAMERON, BRUCE P. 3
- CAPITOLINE/MS&L 3
- COUNCIL OF KHALISTAN 3
- FAR EAST TRADE SERVICE, INC., SAN FRANCISCO 3
- FOGARTY KLEIN & PARTNERS PUBLIC RELATIONS 3
- FOLEY, HOAG & ELIOT LLP 3
- HAGER SHARP, INC. 3
- …
Foreign_Principal_Name >30
- - 446
- BRITISH AIRWAYS 2
- KYOCERA CORPORATION 2
- AJINOMOTO U.S.A., INC. 1
- ALEMAN VELASCO Y ASOCIADOS 1
- BOARD OF FOREIGN TRADE, MINISTRY OF ECONOMIC AFFAIRS 1
- BRITISH AIRWAYS, PLC 1
- BRITISH DEPARTMENT OF TRADE & INDUSTRY 1
- CEMEX, S.A. 1
- DEMOCRACY NEXT CENTURY ASSOCIATION (DNCA) 1
- DEMOCRATIC LEAGUE OF KOSOVA (LDK) (FORMERLY REPUBLIC OF 1
- EMBASSY OF EL SALVADOR 1
- FINTECT TRADE SERVICES, LTD. 1
- GOVERNMENT OF BOLIVIA 1
- GOVERNMENT OF THE REPUBLIC OF THE CONGO 1
- HASEDO (HUMANITARIAN & SOCIO-ECONOMIC DEVELOPMENT 1
- INTERNATIONAL PUBLIC RELATIONS COMPANY, LTD. 1
- JAPAN FISHERIES ASSOCIATION 1
- JOSE MARIA FIGUERES 1
- KAMM & ASSOCIATES, LTD. 1
- KIM & CHANG 1
- METHANEX, INC. 1
- MINISTRY FOR PROTECTION OF THE ENVIRONMENT AND NATURAL 1
- MINISTRY OF SPORTS & TOURISM OF THE REPUBLIC OF POLAND 1
- MIRCEA SNEGUR, PRESIDENT OF THE REPUBLIC OF MOLDOVA 1
- NATIONAL COALITION GOVERNMENT OF THE UNION OF BURMA 1
- REPRESENTATIVE OF THE PATRIOTIC UNION OF KURDISTAN 1
- REPUBLIC OF GUYANA 1
- REPUBLIC OF HUNGARY, EMBASSY 1
- REPUBLIC OF LATVIA 1
- …
Foreign_Principal_Country 23
- - 446
- GREAT BRITAIN 6
- JAPAN 6
- HONG KONG 2
- MEXICO 2
- RUSSIA 2
- TAIWAN 2
- BOLIVIA 1
- CANADA 1
- CONGO DEMOCRATIC REPUBLIC OF THE 1
- COSTA RICA 1
- EL SALVADOR 1
- GUYANA 1
- HUNGARY 1
- IRAN 1
- ISRAEL 1
- JAMAICA 1
- KOREA SOUTH 1
- KOSOVA 1
- LATVIA 1
- MOLDOVA 1
- MYANMAR BURMA 1
- POLAND 1
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]) );