FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Date_Stamped" is on date 1988-03-01 and Document_Type = "Short-Form"
This data as json, CSV (advanced)
These facets timed out: Foreign_Principal_Name, Foreign_Principal_Country
Registrant_Name 16
- AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 1
- ANDERSON, HIBEY & BLAIR 1
- BERLINER, CORCORAN & ROWE 1
- BURSON-MARSTELLER 1
- FINNISH TOURIST BOARD, LOS ANGELES 1
- FREEDMAN, LEVY, KROLL & SIMONDS 1
- GARVEY, SCHUBERT & BARER 1
- GOLD AND LIEBENGOOD 1
- IPAC, INC. 1
- J.R. BECHTLE & COMPANY 1
- LAW OFFICES OF PAUL H. DELANEY, JR. 1
- MURPHY & DEMORY, LTD. 1
- PERKINS COIE 1
- QUEBEC GOVERNMENT HOUSE 1
- SHAW, PITTMAN, POTTS & TROWBRIDGE 1
- TURKISH CONSULATE OFFICE OF CULTURE & INFORMATION ATTACHE 1
Document_Type 1
- Short-Form · 16 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
22043 | 22043 | 1988-03-01 | AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | Short-Form | RICHARD R. RIVERS | Available-FARA-Public-Office | ||
22047 | 22047 | 1988-03-01 | ANDERSON, HIBEY & BLAIR | Anderson, Hibey & Blair 3208 | Short-Form | ALAN H. SCHEINER | Available-FARA-Public-Office | ||
22061 | 22061 | 1988-03-01 | BERLINER, CORCORAN & ROWE | Berliner, Corcoran & Rowe 3512 | Short-Form | CLEMENS J.M. KOCHINKE | Available-FARA-Public-Office | ||
22066 | 22066 | 1988-03-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | OWEN J. DOUGHERTY | Available-FARA-Public-Office | ||
22091 | 22091 | 1988-03-01 | FINNISH TOURIST BOARD, LOS ANGELES | Finnish Tourist Board, Los Angeles 4030 | Short-Form | ULLA MAIJA PAKARINEN | Available-FARA-Public-Office | ||
22094 | 22094 | 1988-03-01 | FREEDMAN, LEVY, KROLL & SIMONDS | Freedman, Levy, Kroll & Simonds 4117 | Short-Form | JOHN H. CHETTLE | Available-FARA-Public-Office | ||
22097 | 22097 | 1988-03-01 | GARVEY, SCHUBERT & BARER | Foster Garvey PC 3047 | Short-Form | CLAY F. WEST | Available-FARA-Public-Office | ||
22100 | 22100 | 1988-03-01 | GOLD AND LIEBENGOOD | Gold & Liebengood, Inc. 3700 | Short-Form | PATRICIA J. JARVIS | Available-FARA-Public-Office | ||
22116 | 22116 | 1988-03-01 | IPAC, INC. | IPAC, Inc. 4008 | Short-Form | MARY ANN GILLEECE | Available-FARA-Public-Office | ||
22120 | 22120 | 1988-03-01 | J.R. BECHTLE & COMPANY | J.R. Bechtle & Company 4019 | Short-Form | HANS J. SPILLER | Available-FARA-Public-Office | ||
22131 | 22131 | 1988-03-01 | LAW OFFICES OF PAUL H. DELANEY, JR. | Paul H. DeLaney, Jr. 4127 | Short-Form | PAUL H. DELANEY, JR. | Available-FARA-Public-Office | ||
22147 | 22147 | 1988-03-01 | MURPHY & DEMORY, LTD. | Murphy & Demory, Ltd. 4095 | Short-Form | JEFFREY J. GRIECO | Available-FARA-Public-Office | ||
22155 | 22155 | 1988-03-01 | PERKINS COIE | Perkins Coie 3753 | Short-Form | GENE PERRY BOND | Available-FARA-Public-Office | ||
22163 | 22163 | 1988-03-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | PAUL W. VESEL | Available-FARA-Public-Office | ||
22176 | 22176 | 1988-03-01 | SHAW, PITTMAN, POTTS & TROWBRIDGE | Shaw, Pittman, Potts & Trowbridge 2580 | Short-Form | LAURA L. VISSER | Available-FARA-Public-Office | ||
22188 | 22188 | 1988-03-01 | TURKISH CONSULATE OFFICE OF CULTURE & INFORMATION ATTACHE | Turkish Consulate Office of Culture & Information Attache 498 | Short-Form | OKTAY ATAMAN | 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]) );