FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
54 rows where "Date_Stamped" is on date 1997-10-31
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Country
Registrant_Name >30
- FRIENDS OF SINN FEIN, INC. 2
- ACKERMAN, ROBERT L. 1
- AMERICAN DEFENSE INTERNATIONAL 1
- BOGGS, J.C. 1
- BRADY & BERLINER, PC 1
- BYCK, DONALD M. 1
- COLOMBIAN COFFEE FEDERATION, INC. 1
- DAIMLER-BENZ AEROSPACE OF NORTH AMERICA, INC. 1
- DAVIS, MANAFORT & FREEDMAN 1
- DERWINSKI, EDWARD 1
- DEUTSCHE TELEKOM, INC. 1
- DYMALLY INTERNATIONAL GROUP, INC. 1
- ETHIOPIAN'S PEOPLE'S REVOLUTIONARY PARTY 1
- FOGARTY KLEIN & PARTNERS PUBLIC RELATIONS 1
- GAST, LUVERNE L. 1
- GOWRAN INTERNATIONAL, LTD. 1
- HARRON & ASSOCIATES, INC. 1
- INDUSTRIAL DEVELOPMENT BOARD OF NORTHERN IRELAND 1
- KAISER, DONALD 1
- KCM INTERNATIONAL, INC. 1
- KELLER & HECKMAN, L.L.P. 1
- KELLEY SWOFFORD ROY, INC. 1
- KETCHUM COMMUNICATIONS, INC. 1
- KIMBELL SHERMAN & ELLIS 1
- KNORR, D. JAMES 1
- KRONMILLER, THEODORE G. 1
- MANATT, PHELPS & PHILLIPS 1
- MANCHESTER TRADE, LTD. 1
- MILLER & CHEVALIER 1
- O'LEARY CLARKE & PARTNERS, INC. 1
- …
Foreign_Principal_Name 1
- - 54
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]) );