lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

1 row where filing_uuid = "e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f" and issue_code = "TAX" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

filing_year 1

filing_period 1

id filing_uuid filing_type registrant_name registrant_id client_name filing_year ▲ filing_period issue_code specific_issues government_entities income_amount expense_amount is_no_activity is_termination received_date
2876447 AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f Q3 AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2321 AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES 2022 third_quarter TAX Billionaires Surtax- various proposals Individual taxes- Surtax, increase rates on high income, return top rate to 39.6%, close loopholes, Mark to Market Corporate tax rates, close loopholes Supporting Americans with Lower Taxes (SALT) Act Earned income tax credits, child tax credits HR 2549, S 1157- Tax Fairness for Workers Act, Individual tax deduction for union dues S 4192, HR 8448- No Tax Breaks for Union Busting Act HR 2337- Public Servants Protection and Fairness Act of 2021 Tax Filing Simplification Act HR 5376, HR 1785, S 714- International tax incentives for outsourcing and rates, No Tax Breaks for Outsourcing Act HR 5376, HR 2576, S 994- Estate Taxes, For the 99.5% Act HR 5376, S 510, HR 1459- Ultra-Millionaire Tax Act of 2021 HR 3805, S 2028- Millionaires Surtax Act HR 5376, S 2617, HR 1068, S 1598- Carried interest tax loophole HR 7502- Babies Over Billionaires Act HR 8558- Billionaire Minimum Income Tax Deemed realization (1 time) at death/transfer for large assets (e.g. >$1 B) HR 2286- Deemed Realization of capital gains HR 5376, HR 1116, HR 1200, S 1857, S 1788- Increase funds for IRS tax enforcement and services, IRS Enhancement and Tax Gap Reduction Act of 2021, Stop CHEATERS Act, Restoring the IRS Act S 1652- Paying a Fair Share Act Close NIIT and SECA tax loopholes- use revenue for Medicare HR 5376, S 2680, HR 4940- Corporate tax: minimum rate (e.g. 15%), Real Corporate Profits Tax Act of 2021 General Business Tax Credits refundability Tax extenders General, R&D Tax Credit, Refundable NOL Carryover Opportunity Zone Reform Act HOUSE OF REPRESENTATIVES,SENATE,White House Office   470000 0 0 2022-10-19T13:02:47-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE lobbying_activities (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            filing_type TEXT NOT NULL,
            registrant_name TEXT NOT NULL,
            registrant_id INTEGER,
            client_name TEXT NOT NULL,
            filing_year INTEGER NOT NULL,
            filing_period TEXT NOT NULL,
            issue_code TEXT,
            specific_issues TEXT,
            government_entities TEXT,
            income_amount INTEGER,
            expense_amount INTEGER,
            is_no_activity INTEGER DEFAULT 0,
            is_termination INTEGER DEFAULT 0,
            received_date TEXT,
            CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);