lobbying_bills

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

3,483,171 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE lobbying_bills (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    filing_uuid TEXT NOT NULL,
    bill_congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    bill_id TEXT,
    client_name TEXT,
    issue_code TEXT
);
CREATE INDEX idx_lb_bill ON lobbying_bills(bill_id);
CREATE INDEX idx_lb_filing ON lobbying_bills(filing_uuid);
CREATE INDEX idx_lb_client ON lobbying_bills(client_name);