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

10 rows where filing_uuid = "5bded9f5-e0fa-4954-a847-e78aa4e5e9b7" 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
2591281 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 AMY WREN   0
2591282 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 DOUGLAS SCHWARTZ   0
2591277 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 GARY LYTLE   0
2591279 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 JAY CRANFORD   0
2591283 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 JOHN STIPICEVIC   0
2591284 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 JULIANE SULLIVAN Senior Appropriations Adviser, House Majority Whip Tom DeLay, 1999-2003 Senior Legislative Assistant, Appropriations, Rep Anne Northup, 1997-1999 Legislative Assistant, Rep Ed Whitfield 1994-1997 1
2591285 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 KATIE MITCHELL Scheduler, Rep. Paul Cook - Jan 2014-Nov 2014 Intern, Rep. Devin Nunes - Aug 2013-Dec 2013 1
2591280 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 MIKE NIELSEN   0
2591278 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 SAM GEDULDIG   0
2591276 CGCN GROUP, LLC 5bded9f5-e0fa-4954-a847-e78aa4e5e9b7 STEVE CLARK   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);