lobbying_lobbyists
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where filing_uuid = "8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc" sorted by lobbyist_name
This data as json, CSV (advanced)
Suggested facets: covered_position
| id | filing_uuid | lobbyist_name ▼ | covered_position | is_new |
|---|---|---|---|---|
| 201758 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | DEBORAH STEELMAN | N/A | 0 |
| 201756 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | DESIREE FILIPPONE | LEG ASST SEN BAYH | 0 |
| 201753 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | EDMUND MIHALSKI | N/A | 0 |
| 201755 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | ERIN HUNTINGTON | N/A | 0 |
| 201752 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | JAY BONITT | N/A | 0 |
| 201754 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | KATHRYN KAROL | N/A | 0 |
| 201759 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | KIM LINTHICUM | N/A | 0 |
| 201757 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | NEIL PICKETT | N/A | 0 |
| 201750 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | RICHARD BUCKLEY | N/A | 0 |
| 201751 | ELI LILLY AND COMPANY 8d72decd-134f-4ee3-a3ce-9d2a8a50fbdc | SUZANNE SIMALA | N/A | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);