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 Registration_Number = 5716 sorted by Short_Form_Name
This data as json, CSV (advanced)
Registrant_Name 1
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 |
---|---|---|---|---|---|---|---|---|---|
17710 | 17710 | 2006-02-21 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Caputo, Pascal B. | Available-FARA-Public-Office | ||
111090 | 111090 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Cleveland III, Ollie Ancil (Tres) | Available-FARA-Public-Office | ||
26159 | 26159 | 2007-03-08 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Colvin, Adam R. | Available-FARA-Public-Office | ||
29466 | 29466 | 2008-03-20 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Colvin, Adam R. | https://efile.fara.gov/docs/5716-Short-Form-20080320-24.pdf | ||
111091 | 111091 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Drew, Mark L. | Available-FARA-Public-Office | ||
111092 | 111092 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Enslen, Alan F. | Available-FARA-Public-Office | ||
17711 | 17711 | 2006-02-21 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Falk, EmiIy A. | Available-FARA-Public-Office | ||
17712 | 17712 | 2006-02-21 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Hancock, Robert D. | Available-FARA-Public-Office | ||
17713 | 17713 | 2006-02-21 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Lucas, Melinda J. | Available-FARA-Public-Office | ||
111093 | 111093 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Mitchell, James L. | Available-FARA-Public-Office | ||
111094 | 111094 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Ogletree, Elizabeth T. | Available-FARA-Public-Office | ||
91345 | 91345 | 2006-08-31 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Short-Form | Sims, E. Tyler | 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]) );