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

7 rows where filing_uuid = "2675dcba-e1b2-4a3f-8fc2-ecc880e79928" sorted by lobbyist_name

✎ View and edit SQL

This data as json, CSV (advanced)

is_new 2

id filing_uuid lobbyist_name ▼ covered_position is_new
3333220 ARNOLD & PORTER KAYE SCHOLER LLP 2675dcba-e1b2-4a3f-8fc2-ecc880e79928 ADRIENNE JACKSON   0
3333221 ARNOLD & PORTER KAYE SCHOLER LLP 2675dcba-e1b2-4a3f-8fc2-ecc880e79928 GRACE BENDIK   0
3333219 ARNOLD & PORTER KAYE SCHOLER LLP 2675dcba-e1b2-4a3f-8fc2-ecc880e79928 JAMIE LEE   0
3333218 ARNOLD & PORTER KAYE SCHOLER LLP 2675dcba-e1b2-4a3f-8fc2-ecc880e79928 JANICE BASHFORD Leg Dir & Chief Counsel, Rep Bass (2016-21); Interim Africa Staff Dir, House Foreign Affairs Sub (2017); Leg Dir and Chief Counsel, Rep Waters (2014); Leg Dir & Chief Counsel, Rep Jackson Lee (2011-14); Staff, Senate Comm on Small Business (2000-01) 1
3333217 ARNOLD & PORTER KAYE SCHOLER LLP 2675dcba-e1b2-4a3f-8fc2-ecc880e79928 JESSICA MONAHAN   0
3333222 ARNOLD & PORTER KAYE SCHOLER LLP 2675dcba-e1b2-4a3f-8fc2-ecc880e79928 KEVIN O'NEILL   0
3333216 ARNOLD & PORTER KAYE SCHOLER LLP 2675dcba-e1b2-4a3f-8fc2-ecc880e79928 MARK EPLEY Sr Advisor/GC, Office of Speaker (2015-19); Comm GC/Staff Dir, Oversight Sub, House Ways & Means (2012-15); Staff Dir, Oversight Sub, House Fin Services (2011-12); Sr Coun, DOJ Dep AG (2006-08); GC & Counsel, Mil Per Sub, House Armed Services (2005) 1

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);