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)

These facets timed out: Document_Type

Foreign_Principal_Country 7

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. Smith McCabe, Ltd. 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19940101-D1Y8IN02.pdf
2831 2831 1994-01-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19940101-D1Y8KM02.pdf
16222 16222 1995-02-14 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB   AUTONOMOUS GOVERNMENT OF CATALONIA, DEPARTMENT OF INDUSTRY & SPAIN https://efile.fara.gov/docs/4687-Exhibit-AB-19950214-DHQOOF91.pdf
16223 16223 1995-02-14 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Short-Form ALAN W. SMITH     Available-FARA-Public-Office
16224 16224 1995-02-14 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Short-Form IAN R. MCCABE     Available-FARA-Public-Office
40641 40641 1996-04-16 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB   GOVERMENT OF THAILAND, EMBASSY THAILAND https://efile.fara.gov/docs/4687-Exhibit-AB-19960416-DRGJ2D04.pdf
40642 40642 1996-04-16 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Short-Form ALAN SMITH     Available-FARA-Public-Office
40643 40643 1996-04-16 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Short-Form JAMES DILLARD     Available-FARA-Public-Office
60990 60990 1992-06-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF INDONESIA INDONESIA https://efile.fara.gov/docs/4687-Exhibit-AB-19920601-D1XXZ902.pdf
60991 60991 1992-06-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit C       https://efile.fara.gov/docs/4687-Exhibit-C-19920601-D1XXZQ02.pdf
60992 60992 1992-06-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Registration Statement       Available-FARA-Public-Office
61619 61619 1993-06-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19930601-D1WPN404.pdf
69139 69139 1994-06-30 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19940630-DHQOXK01.pdf
69249 69249 1995-06-30 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19950630-DHQOAZ91.pdf
69331 69331 1996-06-30 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19960630-DXXPQL03.pdf
69419 69419 1997-06-30 SMITH MCCABE LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19970630-EEM1G103.pdf
69500 69500 1998-06-30 Smith McCabe, Ltd. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19980630-GFC8YR02.pdf
73213 73213 1993-07-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19930701-D1WPR304.pdf
73214 73214 1993-07-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB   MINISTRY OF TOURISM, GOVERNMENT OF MEXICO MEXICO https://efile.fara.gov/docs/4687-Exhibit-AB-19930701-D1WPO604.pdf
89578 89578 1995-08-25 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19950825-DHQOFI01.pdf
94357 94357 1992-09-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB   GOVERNMENT OF ALBERTA, CANADA CANADA https://efile.fara.gov/docs/4687-Exhibit-AB-19920901-D1WL0W04.pdf
96308 96308 1992-09-08 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB   GOVERNMENT OF THE REPUBLIC OF INDONESIA INDONESIA https://efile.fara.gov/docs/4687-Exhibit-AB-19920908-D1WIBP04.pdf
96309 96309 1992-09-08 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Short-Form ALAN W. SMITH     Available-FARA-Public-Office
96310 96310 1992-09-08 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Short-Form ALAN W. SMITH     Available-FARA-Public-Office
96311 96311 1992-09-08 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Short-Form IAN MCCABE     Available-FARA-Public-Office
96312 96312 1992-09-08 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Short-Form ROBERT HUGHES     Available-FARA-Public-Office
105496 105496 1992-10-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB   GOVERNMENT OF ALBERTA, CANADA CANADA https://efile.fara.gov/docs/4687-Exhibit-AB-19921001-D1WLC004.pdf
122411 122411 1999-11-29 Smith McCabe, Ltd. Smith McCabe, Ltd. 4687 Amendment       https://efile.fara.gov/docs/4687-Amendment-19991129-G2ZNF901.pdf
122412 122412 1999-11-29 Smith McCabe, Ltd. Smith McCabe, Ltd. 4687 Short-Form Hoffman,Margot     Available-FARA-Public-Office
122413 122413 1999-11-29 Smith McCabe, Ltd. Smith McCabe, Ltd. 4687 Short-Form Smith ,Alan W.     Available-FARA-Public-Office
127731 127731 1992-12-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19921201-D1WMI504.pdf
128088 128088 1993-12-01 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19931201-D1Y8H602.pdf
129121 129121 1997-12-05 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB       https://efile.fara.gov/docs/4687-Exhibit-AB-19971205-EN7BQ105.pdf
129122 129122 1997-12-05 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Exhibit AB   JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) JAPAN https://efile.fara.gov/docs/4687-Exhibit-AB-19971205-EO6KGP03.pdf
135024 135024 1994-12-31 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19941231-DHQOI301.pdf
135096 135096 1995-12-31 SMITH MCCABE, LTD. Smith McCabe, Ltd. 4687 Supplemental Statement       https://efile.fara.gov/docs/4687-Supplemental-Statement-19951231-DOU2CE01.pdf
135221 135221 1997-12-31 Smith McCabe, Ltd. Smith McCabe, Ltd. 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])
);