lobbying_activities

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

107,617 rows where issue_code = "ENV" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

Next page

CREATE TABLE lobbying_activities (
    id INTEGER PRIMARY KEY,
    filing_uuid TEXT NOT NULL,
    filing_type TEXT NOT NULL,
    registrant_name TEXT NOT NULL,
    registrant_id INTEGER,
    client_name TEXT NOT NULL,
    client_name_normalized TEXT,
    filing_year INTEGER NOT NULL,
    filing_period TEXT NOT NULL,
    issue_code TEXT,
    specific_issues TEXT,
    government_entities TEXT,
    is_no_activity INTEGER DEFAULT 0,
    is_termination INTEGER DEFAULT 0,
    received_date TEXT
);
CREATE INDEX idx_lobby_act_client ON lobbying_activities(client_name);
CREATE INDEX idx_lobby_act_client_norm ON lobbying_activities(client_name_normalized);
CREATE INDEX idx_lobby_act_issue ON lobbying_activities(issue_code);
CREATE INDEX idx_lobby_act_year ON lobbying_activities(filing_year);
CREATE INDEX idx_lobby_act_uuid ON lobbying_activities(filing_uuid);
CREATE INDEX idx_lobby_act_registrant ON lobbying_activities(registrant_name);