lobbying_filings

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

77,219 rows where filing_year = 2017 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: registrant_country, 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,
    amount_reported 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;