FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Document_Type = "Short-Form" and Registrant_Name = "MCDERMOTT, WILL & EMERY"
This data as json, CSV (advanced)
Registrant_Name 1
- MCDERMOTT, WILL & EMERY · 12 ✖
Foreign_Principal_Name 1
- - 12
Foreign_Principal_Country 1
- - 12
Document_Type 1
- Short-Form · 12 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
13241 | 13241 | 1994-02-01 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | MICHAEL WOOTTON | Available-FARA-Public-Office | ||
38121 | 38121 | 1992-04-06 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4643 | Short-Form | JONI LUPOVITZ | Available-FARA-Public-Office | ||
38122 | 38122 | 1992-04-06 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4643 | Short-Form | ROBERT S. SCHWARTZ | Available-FARA-Public-Office | ||
38123 | 38123 | 1992-04-06 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4643 | Short-Form | SETH D. GREENSTEIN | Available-FARA-Public-Office | ||
52604 | 52604 | 1995-05-17 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | STANTON D. ANDERSON | Available-FARA-Public-Office | ||
52605 | 52605 | 1995-05-17 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | THOMAS P. STEINDLER | Available-FARA-Public-Office | ||
66611 | 66611 | 1993-06-22 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | EDWARD M. RUCKERT | Available-FARA-Public-Office | ||
66612 | 66612 | 1993-06-22 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | JERRY C. HILL | Available-FARA-Public-Office | ||
66613 | 66613 | 1993-06-22 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | MAGGIE A. MITCHELL | Available-FARA-Public-Office | ||
66614 | 66614 | 1993-06-22 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | PAMELA D. WALTHER | Available-FARA-Public-Office | ||
76030 | 76030 | 1995-07-14 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | GREGORY F. JENNER | Available-FARA-Public-Office | ||
76031 | 76031 | 1995-07-14 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Short-Form | RONALD L. PLATT | 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]) );