FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Document_Type = "Short-Form" and Registrant_Name = "McDermott Will & Emery, LLP"
This data as json, CSV (advanced)
Registrant_Name 1
- McDermott Will & Emery, LLP · 16 ✖
Foreign_Principal_Name 1
- - 16
Foreign_Principal_Country 1
- - 16
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 |
---|---|---|---|---|---|---|---|---|---|
5417 | 5417 | 2011-01-14 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 5986 | Short-Form | Ransom, David | https://efile.fara.gov/docs/5986-Short-Form-20110114-8.pdf | ||
5418 | 5418 | 2011-01-14 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 5986 | Short-Form | Showalter, Cecilia R. | https://efile.fara.gov/docs/5986-Short-Form-20110114-10.pdf | ||
24588 | 24588 | 2019-03-02 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 6447 | Short-Form | DeMaio, Anthony | https://efile.fara.gov/docs/6447-Short-Form-20190302-16.pdf | ||
24589 | 24589 | 2019-03-02 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 6447 | Short-Form | Miller, Jefferson Bingham | https://efile.fara.gov/docs/6447-Short-Form-20190302-14.pdf | ||
43979 | 43979 | 2010-04-29 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 5986 | Short-Form | O'Connor, Eileen M. | https://efile.fara.gov/docs/5986-Short-Form-20100429-4.pdf | ||
43980 | 43980 | 2010-04-29 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 5986 | Short-Form | Socarras, Michael | https://efile.fara.gov/docs/5986-Short-Form-20100429-2.pdf | ||
54153 | 54153 | 2005-05-23 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 5686 | Short-Form | Hatch, Paul David | Available-FARA-Public-Office | ||
54154 | 54154 | 2005-05-23 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 5686 | Short-Form | Steen, Gretchen P. | Available-FARA-Public-Office | ||
79251 | 79251 | 2017-07-27 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 6447 | Short-Form | Miller, Jefferson Bingham | https://efile.fara.gov/docs/6447-Short-Form-20170727-4.pdf | ||
79252 | 79252 | 2017-07-27 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 6447 | Short-Form | Moran, James P. | https://efile.fara.gov/docs/6447-Short-Form-20170727-2.pdf | ||
79253 | 79253 | 2017-07-27 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 6447 | Short-Form | Ryan, Stephen M. | https://efile.fara.gov/docs/6447-Short-Form-20170727-6.pdf | ||
89026 | 89026 | 2005-08-22 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 5686 | Short-Form | House, Michael P. | Available-FARA-Public-Office | ||
96217 | 96217 | 2017-09-07 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 6447 | Short-Form | Miller, Jefferson Bingham | https://efile.fara.gov/docs/6447-Short-Form-20170907-10.pdf | ||
96218 | 96218 | 2017-09-07 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 6447 | Short-Form | Moran, James P. | https://efile.fara.gov/docs/6447-Short-Form-20170907-12.pdf | ||
96219 | 96219 | 2017-09-07 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 6447 | Short-Form | Ryan, Stephen M. | https://efile.fara.gov/docs/6447-Short-Form-20170907-8.pdf | ||
107121 | 107121 | 2010-10-06 | McDermott Will & Emery, LLP | McDermott Will & Emery, LLP 5986 | Short-Form | Showalter, Cecilia R. | https://efile.fara.gov/docs/5986-Short-Form-20101006-6.pdf |
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]) );