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

22 rows where filing_uuid = "87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b" sorted by lobbyist_name

✎ View and edit SQL

This data as json, CSV (advanced)

is_new 2

  • 0 20
  • 1 2
id filing_uuid lobbyist_name ▼ covered_position is_new
4051136 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b ALEXANDER PERKINS   0
4051142 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b ALYENE MLINAR   0
4051144 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b ANNIE WOLF Dep Floor Dir (Maj Leader Scalise); CoS (Chief Dep Min Whip Ferguson); Dep Floor Dir (Min Whip Scalise); Prof Staff (House Rules/Sessions); Floor Asst (Speakers Ryan & Boehner); Staff Asst (Speaker Boehner); Intern (Rep. Sullivan) 1
4051124 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b BRUCE MEHLMAN   0
4051140 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b CAITLIN VAN SANT   0
4051131 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b CONSTANTINE HINGSON   0
4051126 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b DAVID THOMAS   0
4051125 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b DEAN ROSEN   0
4051127 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b ELISE FINLEY PICKERING   0
4051143 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b ERICA CHABOT   0
4051132 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b HELEN TOLAR   0
4051129 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b LAUREN ARONSON   0
4051141 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b LISA GOLDMAN   0
4051130 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b MICHAEL ROBINSON   0
4051145 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b NAVEEN PARMAR Chief Counsel (Sen. Hickenlooper); General Counsel (House Comm on Sm Bus/Velazquez); Tax Counsel, (House Comm on Sm Bus/Velazquez); Economic Policy Counsel (Sen. Amy Klobuchar); Ways and Means Counsel (Rep. Lloyd Doggett) 1
4051133 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b NICHOLE DISTEFANO   0
4051134 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b PAUL THORNELL   0
4051138 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b ROSEMARY GUTIERREZ   0
4051128 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b SAGE EASTMAN   0
4051135 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b STEPHEN COTE   0
4051137 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b VICTORIA FLOOD   0
4051139 MEHLMAN CONSULTING, INC. 87463dfb-e4e5-4d84-8e4d-9b3c473e7e8b ZACHARY MALLOVE   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);