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

37 rows where Registration_Number = 4687

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped, Short_Form_Name, URL, Date_Stamped (date)

Foreign_Principal_Country

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
2830 2830 1994-01-01 SMITH MCCABE, LTD. 4687 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19940101-D1Y8IN02.pdf
2831 2831 1994-01-01 SMITH MCCABE, LTD. 4687 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19940101-D1Y8KM02.pdf
14926 14926 1995-02-14 SMITH MCCABE, LTD. 4687 4687 Exhibit AB   AUTONOMOUS GOVERNMENT OF CATALONIA, DEPARTMENT OF INDUSTRY & SPAIN https://efile.fara.gov/docs/4687-Exhibit-AB-19950214-DHQOOF91.pdf
14927 14927 1995-02-14 SMITH MCCABE, LTD. 4687 4687 Short-Form ALAN W. SMITH     Available-FARA-Public-Office
14928 14928 1995-02-14 SMITH MCCABE, LTD. 4687 4687 Short-Form IAN R. MCCABE     Available-FARA-Public-Office
36751 36751 1996-04-16 SMITH MCCABE, LTD. 4687 4687 Exhibit AB   GOVERMENT OF THAILAND, EMBASSY THAILAND https://efile.fara.gov/docs/4687-Exhibit-AB-19960416-DRGJ2D04.pdf
36752 36752 1996-04-16 SMITH MCCABE, LTD. 4687 4687 Short-Form ALAN SMITH     Available-FARA-Public-Office
36753 36753 1996-04-16 SMITH MCCABE, LTD. 4687 4687 Short-Form JAMES DILLARD     Available-FARA-Public-Office
55285 55285 1992-06-01 SMITH MCCABE, LTD. 4687 4687 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF INDONESIA INDONESIA https://efile.fara.gov/docs/4687-Exhibit-AB-19920601-D1XXZ902.pdf
55286 55286 1992-06-01 SMITH MCCABE, LTD. 4687 4687 Exhibit C       https://efile.fara.gov/docs/4687-Exhibit-C-19920601-D1XXZQ02.pdf
55287 55287 1992-06-01 SMITH MCCABE, LTD. 4687 4687 Registration Statement       Available-FARA-Public-Office
55914 55914 1993-06-01 SMITH MCCABE, LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19930601-D1WPN404.pdf
62465 62465 1994-06-30 SMITH MCCABE, LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19940630-DHQOXK01.pdf
62575 62575 1995-06-30 SMITH MCCABE, LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19950630-DHQOAZ91.pdf
62657 62657 1996-06-30 SMITH MCCABE, LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19960630-DXXPQL03.pdf
62745 62745 1997-06-30 SMITH MCCABE LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19970630-EEM1G103.pdf
62826 62826 1998-06-30 Smith McCabe, Ltd. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19980630-GFC8YR02.pdf
66425 66425 1993-07-01 SMITH MCCABE, LTD. 4687 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19930701-D1WPR304.pdf
66426 66426 1993-07-01 SMITH MCCABE, LTD. 4687 4687 Exhibit AB   MINISTRY OF TOURISM, GOVERNMENT OF MEXICO MEXICO https://efile.fara.gov/docs/4687-Exhibit-AB-19930701-D1WPO604.pdf
80699 80699 1995-08-25 SMITH MCCABE, LTD. 4687 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19950825-DHQOFI01.pdf
85240 85240 1992-09-01 SMITH MCCABE, LTD. 4687 4687 Exhibit AB   GOVERNMENT OF ALBERTA, CANADA CANADA https://efile.fara.gov/docs/4687-Exhibit-AB-19920901-D1WL0W04.pdf
86967 86967 1992-09-08 SMITH MCCABE, LTD. 4687 4687 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF INDONESIA INDONESIA https://efile.fara.gov/docs/4687-Exhibit-AB-19920908-D1WIBP04.pdf
86968 86968 1992-09-08 SMITH MCCABE, LTD. 4687 4687 Short-Form ALAN W. SMITH     Available-FARA-Public-Office
86969 86969 1992-09-08 SMITH MCCABE, LTD. 4687 4687 Short-Form ALAN W. SMITH     Available-FARA-Public-Office
86970 86970 1992-09-08 SMITH MCCABE, LTD. 4687 4687 Short-Form IAN MCCABE     Available-FARA-Public-Office
86971 86971 1992-09-08 SMITH MCCABE, LTD. 4687 4687 Short-Form ROBERT HUGHES     Available-FARA-Public-Office
95340 95340 1992-10-01 SMITH MCCABE, LTD. 4687 4687 Exhibit AB   GOVERNMENT OF ALBERTA, CANADA CANADA https://efile.fara.gov/docs/4687-Exhibit-AB-19921001-D1WLC004.pdf
110471 110471 1999-11-29 Smith McCabe, Ltd. 4687 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19991129-G2ZNF901.pdf
110472 110472 1999-11-29 Smith McCabe, Ltd. 4687 4687 Short-Form Hoffman,Margot     Available-FARA-Public-Office
110473 110473 1999-11-29 Smith McCabe, Ltd. 4687 4687 Short-Form Smith ,Alan W.     Available-FARA-Public-Office
115590 115590 1992-12-01 SMITH MCCABE, LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19921201-D1WMI504.pdf
115947 115947 1993-12-01 SMITH MCCABE, LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19931201-D1Y8H602.pdf
116859 116859 1997-12-05 SMITH MCCABE, LTD. 4687 4687 Exhibit AB       https://efile.fara.gov/docs/4687-Exhibit-AB-19971205-EN7BQ105.pdf
116860 116860 1997-12-05 SMITH MCCABE, LTD. 4687 4687 Exhibit AB   JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) JAPAN https://efile.fara.gov/docs/4687-Exhibit-AB-19971205-EO6KGP03.pdf
122020 122020 1994-12-31 SMITH MCCABE, LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19941231-DHQOI301.pdf
122092 122092 1995-12-31 SMITH MCCABE, LTD. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19951231-DOU2CE01.pdf
122217 122217 1997-12-31 Smith McCabe, Ltd. 4687 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19971231-G2ZN4E01.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])
);