home / openregs

fara_registrant_docs

Documents filed by FARA registrants — registration statements, supplemental statements, and informational materials. 151,000+ filings.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

8 rows where document_type = "Conflict Provision" sorted by date_stamped descending

✎ View and edit SQL

This data as json, CSV (advanced)

document_type 1

  • Conflict Provision · 8 ✖
rowid registration_number registrant_name date_stamped ▲ document_type short_form_name foreign_principal_name foreign_principal_country url
97747 4865 GARRETT & COMPANY 11/01/1993 Conflict Provision       https://efile.fara.gov/docs/4865-Conflict-Provision-(18USC219)-19931101-D1YGDV02.pdf
98144 4827 C&O RESOURCES, INC. 10/19/1993 Conflict Provision       https://efile.fara.gov/docs/4827-Conflict-Provision-(18USC219)-19931019-DG1KGH02.pdf
84683 5276 MICHAEL LEWAN COMPANY 09/29/1998 Conflict Provision       https://efile.fara.gov/docs/5276-Conflict-Provision-(18USC219)-19980929-F0ERR501.pdf
65793 5430 BGR Government Affairs, LLC 09/17/2008 Conflict Provision       https://efile.fara.gov/docs/5430-Conflict-Provision-(18USC219)-20080917-1.pdf
83050 3723 L.A. Motley & Company 08/05/1999 Conflict Provision       https://efile.fara.gov/docs/3723-Conflict-Provision-(18USC219)-19990805-GEXCYP02.pdf
63948 5785 U.S. - Emirates Alliance, LLC 07/10/2009 Conflict Provision       https://efile.fara.gov/docs/5785-Conflict-Provision-(18USC219)-20090710-1.pdf
68623 5549 Alston & Bird, LLP 05/02/2007 Conflict Provision       https://efile.fara.gov/docs/5549-Conflict-Provision-(18USC219)-20070502-1.pdf
122440 3355 WILMER, CUTLER & PICKERING 02/01/1989 Conflict Provision       https://efile.fara.gov/docs/3355-Conflict-Provision-(18USC219)-19890201-D0THIZ01.pdf

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE fara_registrant_docs (
    rowid INTEGER PRIMARY KEY,
    registration_number TEXT,
    registrant_name TEXT,
    date_stamped TEXT,
    document_type TEXT,
    short_form_name TEXT,
    foreign_principal_name TEXT,
    foreign_principal_country TEXT,
    url TEXT
);
CREATE INDEX idx_fara_rd_reg ON fara_registrant_docs(registration_number);
CREATE INDEX idx_fara_rd_type ON fara_registrant_docs(document_type);
Powered by Datasette · Queries took 5.084ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API