fara_short_forms

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

44,363 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE fara_short_forms (
            registration_number TEXT,
            registration_date TEXT,
            registrant_name TEXT,
            short_form_date TEXT,
            short_form_termination_date TEXT,
            last_name TEXT,
            first_name TEXT,
            address_1 TEXT,
            address_2 TEXT,
            city TEXT,
            state TEXT,
            zip TEXT
        );
CREATE INDEX idx_sf_reg ON fara_short_forms(registration_number);
CREATE INDEX idx_sf_name ON fara_short_forms(last_name, first_name);