lobbying_lobbyists

Individual lobbyists listed on lobbying filings. Includes covered positions (prior government roles) and whether the lobbyist is newly added to the filing.

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

2 rows where filing_uuid = "fcde9d30-c8f8-4e5b-a817-ceb7d0fb075e" sorted by lobbyist_name

✎ View and edit SQL

This data as json, CSV (advanced)

is_new 1

  • 0 2
id filing_uuid lobbyist_name ▼ covered_position is_new
3215283 DORSEY & WHITNEY LLP fcde9d30-c8f8-4e5b-a817-ceb7d0fb075e CAM WINTON   0
3215282 DORSEY & WHITNEY LLP fcde9d30-c8f8-4e5b-a817-ceb7d0fb075e DAVID TOWNSEND U.S. Senate Committee on Agriculture, Nutrition and Forestry from June 2004 through August 2006. Staff assistant and, for most of the time, the Press Secretary for the ranking member of the Committee, Senator Tom Harkin (D-IA). 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE lobbying_lobbyists (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            lobbyist_name TEXT NOT NULL,
            covered_position TEXT,
            is_new INTEGER DEFAULT 0,
            CONSTRAINT fk_lobbyist_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_lob_filing_uuid ON lobbying_lobbyists(filing_uuid);
CREATE INDEX idx_lob_name ON lobbying_lobbyists(lobbyist_name COLLATE NOCASE);