lobbying_registrations

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

141,323 rows sorted by received_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE lobbying_registrations (
            filing_uuid TEXT PRIMARY KEY,
            filing_type TEXT NOT NULL,
            registrant_id INTEGER,
            registrant_name TEXT NOT NULL,
            registrant_description TEXT,
            registrant_address TEXT,
            registrant_country TEXT,
            registrant_ppb_country TEXT,
            client_id INTEGER,
            client_name TEXT NOT NULL,
            client_description TEXT,
            client_country TEXT,
            client_ppb_country TEXT,
            client_state TEXT,
            effective_date TEXT,
            received_date TEXT,
            general_issue_codes TEXT,
            is_amendment INTEGER DEFAULT 0,
            termination_date TEXT
        );
CREATE INDEX idx_reg_client_name ON lobbying_registrations(client_name COLLATE NOCASE);
CREATE INDEX idx_reg_registrant_name ON lobbying_registrations(registrant_name COLLATE NOCASE);