home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_RegistrantDocs

Table actions
  • GraphQL API for FARA_All_RegistrantDocs
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

23 rows where Registrant_Name = "Shaw Pittman LLP" and Registration_Number = 5198

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Name

Foreign_Principal_Name 4

  • - 19
  • Secretaria de Comercio y Fomento Industrial 2
  • Government of Liechtenstein 1
  • Secretaria de Comercio y Fomento Industrial (Secofi) (Secretariat of Commerce & Industrial Develop) 1

Document_Type 4

  • Supplemental Statement 9
  • Amendment 8
  • Exhibit AB 4
  • Short-Form 2

Foreign_Principal_Country 3

  • - 19
  • MEXICO 3
  • LIECHTENSTEIN 1

Registrant_Name 1

  • Shaw Pittman LLP · 23 ✖
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
9869 9869 2001-01-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20010131-GKQWIQ01.pdf
9911 9911 2002-01-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20020131-GTEAKP01.pdf
9955 9955 2003-01-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20030131-HBJUOI04.pdf
9992 9992 2004-01-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20040131-HUZTIK02.pdf
10058 10058 2005-01-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20050131-ICZJXK05.pdf
14808 14808 2002-02-07 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Amendment       https://efile.fara.gov/docs/5198-Amendment-20020207-GTA7H401.pdf
14809 14809 2002-02-07 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Amendment       https://efile.fara.gov/docs/5198-Amendment-20020207-GTA7IL01.pdf
16049 16049 2002-02-13 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Short-Form Becker,Stephan E.     Available-FARA-Public-Office
19851 19851 2001-02-28 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Amendment       https://efile.fara.gov/docs/5198-Amendment-20010228-GKQWNL01.pdf
19852 19852 2001-02-28 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Amendment       https://efile.fara.gov/docs/5198-Amendment-20010228-GVUXYI03.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
25402 25402 2004-03-05 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Amendment       https://efile.fara.gov/docs/5198-Amendment-20040305-HUZKYP04.pdf
27295 27295 2002-03-12 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Amendment       https://efile.fara.gov/docs/5198-Amendment-20020312-GTN63901.pdf
81140 81140 2001-07-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20010731-GRYFX302.pdf
81189 81189 2002-07-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20020731-H3H1JY02.pdf
81233 81233 2003-07-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20030731-HOLUC003.pdf
81267 81267 2004-07-31 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Supplemental Statement       https://efile.fara.gov/docs/5198-Supplemental-Statement-20040731-I3H1UG02.pdf
90749 90749 2002-08-30 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Amendment       https://efile.fara.gov/docs/5198-Amendment-20020830-H213NM05.pdf
90750 90750 2002-08-30 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Exhibit AB   Government of Liechtenstein LIECHTENSTEIN https://efile.fara.gov/docs/5198-Exhibit-AB-20020830-HF534H04.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
109139 109139 2001-10-16 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Amendment       https://efile.fara.gov/docs/5198-Amendment-20011016-GSKMGQ04.pdf
131554 131554 2002-12-17 Shaw Pittman LLP Pillsbury Winthrop Shaw Pittman, LLP 5198 Short-Form Mirani,Viraj     Available-FARA-Public-Office

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])
);
Powered by Datasette · Queries took 650.195ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history