FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

31 rows where Registration_Number = 6172

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped, Date_Stamped (date)

Foreign_Principal_Country 3

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
7986 7986 2017-01-27 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Heimbach, James T.     https://efile.fara.gov/docs/6172-Short-Form-20170127-30.pdf
8650 8650 2016-01-29 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Exhibit C       https://efile.fara.gov/docs/6172-Exhibit-C-20160129-2.pdf
8651 8651 2016-01-29 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20160129-5.pdf
9113 9113 2014-01-30 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Amendment       https://efile.fara.gov/docs/6172-Amendment-20140130-1.pdf
9114 9114 2014-01-30 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Exhibit AB   Embassy of New Zealand NEW ZEALAND https://efile.fara.gov/docs/6172-Exhibit-AB-20140130-2.pdf
9115 9115 2014-01-30 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20140130-1.pdf
9141 9141 2015-01-30 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20150130-3.pdf
9201 9201 2017-01-30 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20170130-8.pdf
64177 64177 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Exhibit AB   Embassy of New Zealand NEW ZEALAND https://efile.fara.gov/docs/6172-Exhibit-AB-20130610-1.pdf
64178 64178 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Exhibit C       https://efile.fara.gov/docs/6172-Exhibit-C-20130610-1.pdf
64179 64179 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Registration Statement       https://efile.fara.gov/docs/6172-Registration-Statement-20130610-1.pdf
64180 64180 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Farrell, Megan     https://efile.fara.gov/docs/6172-Short-Form-20130610-10.pdf
64181 64181 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Gonzalez, John Michael     https://efile.fara.gov/docs/6172-Short-Form-20130610-6.pdf
64182 64182 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Jones, Joseph Jonathon     https://efile.fara.gov/docs/6172-Short-Form-20130610-2.pdf
64183 64183 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Madigan, Peter T.     https://efile.fara.gov/docs/6172-Short-Form-20130610-12.pdf
64184 64184 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form McCarthy, Justin     https://efile.fara.gov/docs/6172-Short-Form-20130610-8.pdf
64185 64185 2013-06-10 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Shapiro, Jeffrey A.     https://efile.fara.gov/docs/6172-Short-Form-20130610-4.pdf
77728 77728 2016-07-21 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20160721-6.pdf
77729 77729 2016-07-21 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20160721-7.pdf
78398 78398 2014-07-24 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Exhibit AB   Embassy of the Republic of Guatemala GUATEMALA https://efile.fara.gov/docs/6172-Exhibit-AB-20140724-3.pdf
78399 78399 2014-07-24 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Cantor, Andrew     https://efile.fara.gov/docs/6172-Short-Form-20140724-16.pdf
78400 78400 2014-07-24 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Farrell, Megan     https://efile.fara.gov/docs/6172-Short-Form-20140724-14.pdf
78401 78401 2014-07-24 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Gonzalez, John Michael     https://efile.fara.gov/docs/6172-Short-Form-20140724-26.pdf
78402 78402 2014-07-24 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Madigan, Peter T.     https://efile.fara.gov/docs/6172-Short-Form-20140724-18.pdf
78403 78403 2014-07-24 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form McCarthy, Justin     https://efile.fara.gov/docs/6172-Short-Form-20140724-24.pdf
78404 78404 2014-07-24 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Murphy, Sheila H.     https://efile.fara.gov/docs/6172-Short-Form-20140724-20.pdf
78405 78405 2014-07-24 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Shapiro, Jeffrey A.     https://efile.fara.gov/docs/6172-Short-Form-20140724-22.pdf
79217 79217 2015-07-27 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20150727-4.pdf
79618 79618 2017-07-28 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20170728-9.pdf
80440 80440 2014-07-30 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Supplemental Statement       https://efile.fara.gov/docs/6172-Supplemental-Statement-20140730-2.pdf
111570 111570 2014-10-27 Peck, Madigan, Jones & Stewart, Inc. Peck, Madigan, Jones & Stewart, Inc. 6172 Short-Form Olson, Jennifer Smith     https://efile.fara.gov/docs/6172-Short-Form-20141027-28.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);