lobbying_filings

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

95,597 rows where filing_year = 2009 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: client_government_entity, filing_period, is_amendment, is_termination, affiliated_org_count, received_date (date)

Next page

CREATE TABLE lobbying_filings (
                filing_uuid TEXT PRIMARY KEY,
                filing_type TEXT NOT NULL,
                registrant_id INTEGER,
                registrant_name TEXT,
                registrant_state TEXT,
                registrant_country TEXT,
                registrant_house_id INTEGER,
                client_id INTEGER,
                client_name TEXT,
                client_state TEXT,
                client_ppb_state TEXT,
                client_country TEXT,
                client_ppb_country TEXT,
                client_general_description TEXT,
                client_government_entity INTEGER,
                filing_year INTEGER,
                filing_period TEXT,
                received_date TEXT,
                income_amount REAL,
                expense_amount REAL,
                is_amendment INTEGER DEFAULT 0,
                is_no_activity INTEGER DEFAULT 0,
                is_termination INTEGER DEFAULT 0,
                affiliated_org_count INTEGER
            );
CREATE INDEX idx_lobby_filing_type ON lobbying_filings(filing_type);
CREATE INDEX idx_lobby_client ON lobbying_filings(client_name);
CREATE INDEX idx_lobby_year ON lobbying_filings(filing_year);
CREATE INDEX idx_lobby_client_state ON lobbying_filings(client_state);
CREATE INDEX idx_lobby_registrant_state ON lobbying_filings(registrant_state);
CREATE INDEX idx_lobby_house_id ON lobbying_filings(registrant_house_id) WHERE registrant_house_id IS NOT NULL;
CREATE INDEX idx_lobby_govt_entity ON lobbying_filings(client_government_entity) WHERE client_government_entity = 1;