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

8 rows where Registration_Number = 4668

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 2

Foreign_Principal_Country 2

Registrant_Name 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
47745 47745 1992-05-01 LAW OFFICES OF ROBERT MCCANDLESS Law Offices of Robert C. McCandless 4668 Registration Statement       Available-FARA-Public-Office
47746 47746 1992-05-01 LAW OFFICES OF ROBERT MCCANDLESS Law Offices of Robert C. McCandless 4668 Short-Form ROBERT C. MCCANDLESS     Available-FARA-Public-Office
48259 48259 1993-05-01 LAW OFFICES OF ROBERT MCCANDLESS Law Offices of Robert C. McCandless 4668 Supplemental Statement       https://efile.fara.gov/docs/4668-Supplemental-Statement-19930501-D1Y88G02.pdf
53357 53357 1992-05-20 LAW OFFICES OF ROBERT MCCANDLESS Law Offices of Robert C. McCandless 4668 Exhibit AB   PROVISIONAL GOVERNMENT OF HAITI HAITI https://efile.fara.gov/docs/4668-Exhibit-AB-19920520-D1WG0D04.pdf
61488 61488 1993-06-01 LAW OFFICES OF ROBERT MCCANDLESS Law Offices of Robert C. McCandless 4668 Amendment       https://efile.fara.gov/docs/4668-Amendment-19930601-D1WP0704.pdf
61489 61489 1993-06-01 LAW OFFICES OF ROBERT MCCANDLESS Law Offices of Robert C. McCandless 4668 Amendment       https://efile.fara.gov/docs/4668-Amendment-19930601-D1WP1G04.pdf
64305 64305 1993-06-11 LAW OFFICES OF ROBERT MCCANDLESS Law Offices of Robert C. McCandless 4668 Exhibit AB   PROVISIONAL GOVERNMENT OF HAITI HAITI https://efile.fara.gov/docs/4668-Exhibit-AB-19930611-D1WP0Z04.pdf
116186 116186 1992-11-01 LAW OFFICES OF ROBERT MCCANDLESS Law Offices of Robert C. McCandless 4668 Supplemental Statement       https://efile.fara.gov/docs/4668-Supplemental-Statement-19921101-D1WO3D04.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])
);