fara_foreign_principals

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

17,627 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE fara_foreign_principals (
            registration_number TEXT,
            registrant_date TEXT,
            registrant_name TEXT,
            foreign_principal TEXT,
            fp_registration_date TEXT,
            fp_termination_date TEXT,
            country TEXT,
            address_1 TEXT,
            address_2 TEXT,
            city TEXT,
            state TEXT,
            zip TEXT
        );
CREATE INDEX idx_fp_reg ON fara_foreign_principals(registration_number);
CREATE INDEX idx_fp_country ON fara_foreign_principals(country);
CREATE INDEX idx_fp_principal ON fara_foreign_principals(foreign_principal);