lobbying_filings

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

77,891 rows where filing_year = 2012 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_amendment, 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,
    client_id INTEGER,
    client_name TEXT,
    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
);
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);