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

6 rows where filing_uuid = "eb6c91ed-e3ea-4e77-9d08-4d218efc6738" sorted by lobbyist_name

✎ View and edit SQL

This data as json, CSV (advanced)

is_new 1

  • 0 6
id filing_uuid lobbyist_name ▼ covered_position is_new
2194553 COVINGTON & BURLING LLP eb6c91ed-e3ea-4e77-9d08-4d218efc6738 ALAN LARSON for International Finance and Development, (1993-1996), Ambassador to the OECD (1990-1993), Principal Deputy Assistant Secretary of State, for Economic and Business Affairs (88-90), Deputy Assistant Secretary of State for, International Energy Resources (1987-1988) 0
2194555 COVINGTON & BURLING LLP eb6c91ed-e3ea-4e77-9d08-4d218efc6738 DIRK SURINGA   0
2194557 COVINGTON & BURLING LLP eb6c91ed-e3ea-4e77-9d08-4d218efc6738 MUFTIAH MCCARTIN House Rules Committee Staff Dir. (09-10), House Rules Comm Deputy Staff Dir (07-08), House Select Committee on Voting, Irregularities, General Counsel, detailed, (9/07-9/08) 0
2194556 COVINGTON & BURLING LLP eb6c91ed-e3ea-4e77-9d08-4d218efc6738 PETER TROOBOFF   0
2194554 COVINGTON & BURLING LLP eb6c91ed-e3ea-4e77-9d08-4d218efc6738 STUART EIZENSTAT Trade (1996-1997), U.S. Ambassador to the E.U. (93-96) 0
2194552 COVINGTON & BURLING LLP eb6c91ed-e3ea-4e77-9d08-4d218efc6738 WILLIAM WICHTERMAN Special Asst to President Bush & Deputy Dir. OPL, Policy Advisor, Senator Majority Leader Bill Frist, Chief of Staff, Rep. Joseph Pitts, Chief of Staff, Rep. Bill Baker; COS, Rep. Walker 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);