FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
43 rows where "Date_Stamped" is on date 1987-03-01 and Document_Type = "Short-Form"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Date_Stamped
Foreign_Principal_Country 1
- - 43
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
21854 | 21854 | 1987-03-01 | O'CONNOR & HANNAN, LLP | O'Connor & Hannan, L.L.P. 2972 | Short-Form | TIMOTHY M. HAAKE | Available-FARA-Public-Office | ||
21870 | 21870 | 1987-03-01 | ARTER & HADDEN | Arter & Hadden 3942 | Short-Form | WILLIAM K. DABAGHI | Available-FARA-Public-Office | ||
21874 | 21874 | 1987-03-01 | BEE MOUA | Bee Moua 3311 | Short-Form | TER FONG YANG | Available-FARA-Public-Office | ||
21876 | 21876 | 1987-03-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | STUART JONATHAN SWEET | Available-FARA-Public-Office | ||
21885 | 21885 | 1987-03-01 | CIVIC SERVICE, INC. | Civic Service, Inc. 3385 | Short-Form | KAY THOMAS | Available-FARA-Public-Office | ||
21895 | 21895 | 1987-03-01 | DOW, LOHNES & ALBERTSON, LLP | Dow, Lohnes & Albertson, L.L.P. 3452 | Short-Form | RYAN T. TRAINER | Available-FARA-Public-Office | ||
21899 | 21899 | 1987-03-01 | DUDEK COMMUNICATIONS | Dudek Communications 3944 | Short-Form | DONNA H. DUDEK | Available-FARA-Public-Office | ||
21909 | 21909 | 1987-03-01 | GOVERNMENT OF INDIA TOURIST OFFICE, NEW YORK | India Tourism, New York 2329 | Short-Form | LEELA S. NADHAN | Available-FARA-Public-Office | ||
21919 | 21919 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | C. JACKSON BAIN | Available-FARA-Public-Office | ||
21920 | 21920 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | GORDON SMITH | Available-FARA-Public-Office | ||
21921 | 21921 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | HAROLD J. COSTELLO | Available-FARA-Public-Office | ||
21922 | 21922 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | HAROLD J. COSTELLO | Available-FARA-Public-Office | ||
21923 | 21923 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | JANET HENDERSON | Available-FARA-Public-Office | ||
21924 | 21924 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | JERRY COX | Available-FARA-Public-Office | ||
21925 | 21925 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | JUDY DELZOPPO | Available-FARA-Public-Office | ||
21926 | 21926 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | RICHARD L. MCELHENY | Available-FARA-Public-Office | ||
21927 | 21927 | 1987-03-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | ROGER LINDBERG | Available-FARA-Public-Office | ||
21928 | 21928 | 1987-03-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | ANDREW TZE-CHIU MA | Available-FARA-Public-Office | ||
21929 | 21929 | 1987-03-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | ANTHONY WONG | Available-FARA-Public-Office | ||
21930 | 21930 | 1987-03-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | STELLA C.S. TANG | Available-FARA-Public-Office | ||
21942 | 21942 | 1987-03-01 | IPSCO STEEL, INC. | IPSCO Tubulars, Inc. 3948 | Short-Form | JOHN TULLOCH | Available-FARA-Public-Office | ||
21943 | 21943 | 1987-03-01 | IPSCO STEEL, INC. | IPSCO Tubulars, Inc. 3948 | Short-Form | MARIO DALLA-VICENZA | Available-FARA-Public-Office | ||
21944 | 21944 | 1987-03-01 | IPSCO STEEL, INC. | IPSCO Tubulars, Inc. 3948 | Short-Form | ROGER PHILLIPS | Available-FARA-Public-Office | ||
21945 | 21945 | 1987-03-01 | IPSCO STEEL, INC. | IPSCO Tubulars, Inc. 3948 | Short-Form | S. BENTON VINZANT | Available-FARA-Public-Office | ||
21955 | 21955 | 1987-03-01 | KROLOFF, MARSHALL & ASSOCIATES | Kroloff, Marshall & Associates 3947 | Short-Form | GEORGE M. KROLOFF | Available-FARA-Public-Office | ||
21958 | 21958 | 1987-03-01 | L.A. MOTLEY & COMPANY | L.A. Motley & Company 3723 | Short-Form | CLAUD L. GINGRICH | Available-FARA-Public-Office | ||
21969 | 21969 | 1987-03-01 | MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | Short-Form | LAURA BAUGHMAN | Available-FARA-Public-Office | ||
21970 | 21970 | 1987-03-01 | MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | Short-Form | MARTIN J. LEWIN | Available-FARA-Public-Office | ||
21971 | 21971 | 1987-03-01 | NDC | One NorthEast 3476 | Short-Form | ROBERT BLAKE CREIGHTON | Available-FARA-Public-Office | ||
21982 | 21982 | 1987-03-01 | POWELL, GOLDSTEIN, FRAZER & MURPHY LLP | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | Short-Form | MICHAEL EZRA FINE | Available-FARA-Public-Office | ||
21997 | 21997 | 1987-03-01 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | R. JAMES WOOLSEY | Available-FARA-Public-Office | ||
22006 | 22006 | 1987-03-01 | TKC INTERNATIONAL, INC. | TKC International, Inc. 3075 | Short-Form | JONATHAN BLAIR SLADE | Available-FARA-Public-Office | ||
22014 | 22014 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | ALBERT C. PRINTZ, JR. | Available-FARA-Public-Office | ||
22015 | 22015 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | DAVID A. HAMOD | Available-FARA-Public-Office | ||
22016 | 22016 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | DENIS M. NEILL | Available-FARA-Public-Office | ||
22017 | 22017 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | JAMES T. SHEA | Available-FARA-Public-Office | ||
22018 | 22018 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | JENNIFER E. ROSENDAHL | Available-FARA-Public-Office | ||
22019 | 22019 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | JENNIFER NOTKIN | Available-FARA-Public-Office | ||
22020 | 22020 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | JOHN D. LAWRENCE | Available-FARA-Public-Office | ||
22021 | 22021 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | KAREN L. DONAHUE | Available-FARA-Public-Office | ||
22022 | 22022 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | LESLIE A. JANKA | Available-FARA-Public-Office | ||
22023 | 22023 | 1987-03-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | P. WELLES ORR | Available-FARA-Public-Office | ||
22024 | 22024 | 1987-03-01 | WEIL, GOTSHAL, & MANGES, LLP | Weil, Gotshal & Manges, L.L.P. 3317 | Short-Form | GARY D. SLAIMAN | 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]) );