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 = "e378d083-059c-459d-92a4-2bec988163bd" 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
3922138 WILMER CUTLER PICKERING HALE AND DORR LLP e378d083-059c-459d-92a4-2bec988163bd JEFFREY WIEAND Counsel Rep. Whip Scalise (17-22); LD Rep. Marino (15-17);Counsel Rep. Fitzpatrick (14-15); SJC Legal Fellow (13-14);SA HT&I Comm. (09-10) 0
3922137 WILMER CUTLER PICKERING HALE AND DORR LLP e378d083-059c-459d-92a4-2bec988163bd ROBERT LEHMAN CoS Portman 11-15; CoS OMB 06-07; CoS USTR 05-06; CoS Rep Portman 03-05; CoS Rep Combest 93-03; LD/LA Rep Combest; Lobby Spec. House Clerk 88-89 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);