FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
50 rows where "Date_Stamped" is on date 1987-07-01 and Document_Type = "Short-Form"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country, Date_Stamped
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
71507 | 71507 | 1987-07-01 | O'MELVENY & MYERS | O'Melveny & Myers 3346 | Short-Form | ANN ALLEN | Available-FARA-Public-Office | ||
71519 | 71519 | 1987-07-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | LAWRENCE C. MAISEL | Available-FARA-Public-Office | ||
71520 | 71520 | 1987-07-01 | AUSTRIAN BUSINESS AGENCY | Austrian Business Agency 3620 | Short-Form | JAMES GREENE | Available-FARA-Public-Office | ||
71523 | 71523 | 1987-07-01 | BERMUDA DEPARTMENT OF TOURISM | Bermuda Tourism Authority 430 | Short-Form | DIANNE CARLSON | Available-FARA-Public-Office | ||
71532 | 71532 | 1987-07-01 | COHEN ASSOCIATES, LTD., INC. | Cohen Associates, Ltd., Inc. 4016 | Short-Form | ROBERT J. COHEN | Available-FARA-Public-Office | ||
71535 | 71535 | 1987-07-01 | CROWELL & MORING INTERNATIONAL, L.P. | Crowell & Moring International, LLC 3988 | Short-Form | CLAIRE A. PALMER (NEE RICKARD) | Available-FARA-Public-Office | ||
71571 | 71571 | 1987-07-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | DIANA RICHMAN | Available-FARA-Public-Office | ||
71572 | 71572 | 1987-07-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | DONALD J. FIX | Available-FARA-Public-Office | ||
71573 | 71573 | 1987-07-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | JERRY COX | Available-FARA-Public-Office | ||
71574 | 71574 | 1987-07-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | JOHN PHIPPS | Available-FARA-Public-Office | ||
71575 | 71575 | 1987-07-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | JOSEPH KRAMER | Available-FARA-Public-Office | ||
71576 | 71576 | 1987-07-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | KARNA SMALL | Available-FARA-Public-Office | ||
71577 | 71577 | 1987-07-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | MARGARET J. HAZELRIGG | Available-FARA-Public-Office | ||
71578 | 71578 | 1987-07-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | RONNA FREIBERG | Available-FARA-Public-Office | ||
71584 | 71584 | 1987-07-01 | INTERNATIONAL TRADE & DEVELOPMENT AGENCY, INC. | International Trade & Development Agency, Inc. 3690 | Short-Form | JOHN J. BRADY | Available-FARA-Public-Office | ||
71585 | 71585 | 1987-07-01 | INTERNATIONAL TRADE & DEVELOPMENT AGENCY, INC. | International Trade & Development Agency, Inc. 3690 | Short-Form | LAURA COHEN | Available-FARA-Public-Office | ||
71586 | 71586 | 1987-07-01 | INTERNATIONAL TRADE & DEVELOPMENT AGENCY, INC. | International Trade & Development Agency, Inc. 3690 | Short-Form | RICHARD COHEN | Available-FARA-Public-Office | ||
71587 | 71587 | 1987-07-01 | INTERNATIONAL TRADE & DEVELOPMENT AGENCY, INC. | International Trade & Development Agency, Inc. 3690 | Short-Form | WILLIAM E. COLBY | Available-FARA-Public-Office | ||
71593 | 71593 | 1987-07-01 | IPAC, INC. | IPAC, Inc. 4008 | Short-Form | RICHARD W. DOUGLAS | Available-FARA-Public-Office | ||
71594 | 71594 | 1987-07-01 | IPAC, INC. | IPAC, Inc. 4008 | Short-Form | RONALD L. CARLBERG | Available-FARA-Public-Office | ||
71595 | 71595 | 1987-07-01 | IPAC, INC. | IPAC, Inc. 4008 | Short-Form | WILLIAM A. GORTON | Available-FARA-Public-Office | ||
71608 | 71608 | 1987-07-01 | KELLEY, DRYE & WARREN | Kelley, Drye & Warren 3681 | Short-Form | EDWARD M. LEBOW | Available-FARA-Public-Office | ||
71610 | 71610 | 1987-07-01 | KOREA NATIONAL TOURISM ORGANIZATION | Korea National Tourism Organization, Chicago 3069 | Short-Form | KEE HANK HWANG | Available-FARA-Public-Office | ||
71614 | 71614 | 1987-07-01 | L.A. MOTLEY & COMPANY | L.A. Motley & Company 3723 | Short-Form | CLAUD L. GINGRICH | Available-FARA-Public-Office | ||
71616 | 71616 | 1987-07-01 | LIBERIAN SERVICES, INC. | Liberian Services, Inc. 2719 | Short-Form | WILLIAM PHILIP MERRIAM, JR. | Available-FARA-Public-Office | ||
71617 | 71617 | 1987-07-01 | LOCATE IN SCOTLAND | Scottish Enterprise 3013 | Short-Form | JEFFREY THORNTON | Available-FARA-Public-Office | ||
71630 | 71630 | 1987-07-01 | MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | Short-Form | DAVID A. VAUGHAN | Available-FARA-Public-Office | ||
71631 | 71631 | 1987-07-01 | MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | Short-Form | DONALD B. CAMERON, JR. | Available-FARA-Public-Office | ||
71632 | 71632 | 1987-07-01 | MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | Short-Form | DONALD J. ZOELLER | Available-FARA-Public-Office | ||
71633 | 71633 | 1987-07-01 | MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | Short-Form | JULIA CHRISTINE BLISS | Available-FARA-Public-Office | ||
71638 | 71638 | 1987-07-01 | NICARAGUAN RESISTANCE (U.S.A. OFFICE) | Nicaraguan Resistance (U.S.A. Office) 4009 | Short-Form | ERNESTO PALAZIO | Available-FARA-Public-Office | ||
71645 | 71645 | 1987-07-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | CLAUDE GIRARD | Available-FARA-Public-Office | ||
71649 | 71649 | 1987-07-01 | ROSE COMMUNICATIONS, INC. | Rose Communications, Inc. 4003 | Short-Form | WILLIAM T. KENDALL | Available-FARA-Public-Office | ||
71656 | 71656 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | DANIEL J. MCCARREL | Available-FARA-Public-Office | ||
71657 | 71657 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | EARLL M. POTT | Available-FARA-Public-Office | ||
71658 | 71658 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | ELISABETH TOBIE ROTH | Available-FARA-Public-Office | ||
71659 | 71659 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | GERALD GLENN MACDONALD | Available-FARA-Public-Office | ||
71660 | 71660 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | JOHN B. BULGOZDY | Available-FARA-Public-Office | ||
71661 | 71661 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | JOHN F. WEINKOPF | Available-FARA-Public-Office | ||
71662 | 71662 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | MARTHA H. PLATT | Available-FARA-Public-Office | ||
71663 | 71663 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | P. TAMICA GRAVES | Available-FARA-Public-Office | ||
71664 | 71664 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | SCOTT E. SCHRUM | Available-FARA-Public-Office | ||
71665 | 71665 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | SCOTT T. KRAGIE | Available-FARA-Public-Office | ||
71666 | 71666 | 1987-07-01 | SQUIRE, SANDERS & DEMPSEY | Squire, Sanders & Dempsey, L.L.P. 746 | Short-Form | TAMARA LYNN DETLOFF | Available-FARA-Public-Office | ||
71672 | 71672 | 1987-07-01 | SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS | Susan Davis International & Public Affairs 3444 | Short-Form | JAMES W. HARFF | Available-FARA-Public-Office | ||
71673 | 71673 | 1987-07-01 | SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS | Susan Davis International & Public Affairs 3444 | Short-Form | JUDITH H. WHITTLESEY | Available-FARA-Public-Office | ||
71674 | 71674 | 1987-07-01 | SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS | Susan Davis International & Public Affairs 3444 | Short-Form | MARY JANE BUTTERFIELD | Available-FARA-Public-Office | ||
71675 | 71675 | 1987-07-01 | SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS | Susan Davis International & Public Affairs 3444 | Short-Form | SUSAN A. DAVIS | Available-FARA-Public-Office | ||
71676 | 71676 | 1987-07-01 | SUSAN DAVIS INTERNATIONAL & PUBLIC AFFAIRS | Susan Davis International & Public Affairs 3444 | Short-Form | TOM E. DAVIS | Available-FARA-Public-Office | ||
71681 | 71681 | 1987-07-01 | WAGNER, HINES & AVARY, INC. | Wagner, Hines & Avary, Inc. 3845 | Short-Form | MICHAEL D. KEHS | Available-FARA-Public-Office |
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]) );