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

30 rows where Foreign_Principal_Country = "MEXICO" and Registration_Number = 5198

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Country 1

  • MEXICO · 30 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
6559 6559 2000-01-21 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Comercio y Fomento Industrial (Secofi) (Secretariat of Commerce & Industrial Develop) MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20000121-HGDIEG03.pdf
6804 6804 2018-01-22 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20180122-41.pdf
10301 10301 2019-01-31 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20190131-49.pdf
15565 15565 2022-02-10 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20220210-60.pdf
24028 24028 2004-03-01 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Comercio y Fomento Industrial MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20040301-HV1CO203.pdf
24493 24493 2011-03-02 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20110302-8.pdf
25405 25405 2008-03-05 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20080305-3.pdf
27953 27953 2023-03-14 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20230314-61.pdf
32394 32394 2021-03-30 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20210330-56.pdf
38227 38227 2015-04-06 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20150406-32.pdf
38703 38703 2008-04-08 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20080408-4.pdf
38955 38955 1998-04-09 SHAW, PITTMAN, POTTS & TROWBRIDGE Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   (SECOFI) SECRATARIAT OF COMMERCE & INDUSTRIAL DEVELOPMNET OF MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-19980409-ET0EUI05.pdf
39767 39767 2019-04-12 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20190412-50.pdf
42301 42301 2020-04-23 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20200423-55.pdf
42434 42434 2012-04-24 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20120424-14.pdf
49091 49091 2018-05-03 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20180503-45.pdf
53760 53760 2014-05-21 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20140521-25.pdf
64852 64852 2017-06-13 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20170613-40.pdf
79219 79219 2015-07-27 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20150727-34.pdf
85200 85200 2012-08-03 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20120803-15.pdf
90619 90619 2014-08-29 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20140829-27.pdf
90816 90816 2011-08-30 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20110830-9.pdf
91371 91371 2009-08-31 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20090831-6.pdf
95038 95038 2014-09-01 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20140901-28.pdf
95749 95749 2008-09-05 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20080905-5.pdf
101362 101362 2003-09-29 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Comercio y Fomento Industrial MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20030929-HONYM303.pdf
108520 108520 1998-10-13 SHAW, PITTMAN, POTTS & TROWBRIDGE Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   (SECOFI) SECRATARIAT OF COMMERCE & INDUSTRIAL DEVELOPMENT OF MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-19981013-F0VW7105.pdf
111835 111835 2013-10-28 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20131028-21.pdf
129002 129002 2013-12-04 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20131204-22.pdf
132361 132361 2019-12-20 Pillsbury Winthrop Shaw Pittman, LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Secretaria de Economia MEXICO https://efile.fara.gov/docs/5198-Exhibit-AB-20191220-54.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])
);