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

12 rows where filing_uuid = "da3d9fec-7c39-485a-8a79-eec75f765d77" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 12

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
2193406 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter MAN General monitoring of manufacturing issues Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193407 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter CPT General monitoring of intellectual property issues Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193408 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter BUD General monitoring of Budget issues. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193409 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter HCR Executive Order on Association Health Care Plans S. 1818 Small business Health Fairness Act H.R. 1101 Bipartisan HSA Improvement Act Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193410 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter POS HR 756 the Postal Service Reform Act of 2017 S. 2629 Senate postal reform legislation Presidential Task Force on the United States Postal System Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193411 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter SMB White House Conference on Small Business Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193412 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter GOV General monitoring of Trump Administration executive actions regarding government regulations Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193413 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter TRD Export-Import Bank Bi-lateral and multi-lateral trade agreements NAFTA revision Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193414 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter FIN SEC Rule 30e-3 Advocacy for ensuring citizens' ability to access to paper-based delivery o essential government, financial and medical information Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193415 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter TAX Comprehensive Tax Reform HR 1 Tax Cut& Jobs Act Capital investment tax policy; 100% Expensing, Bonus Depreciation, Section 179 Small business Expensing Corporate rate cut, and pass-through rate cut Repeal of Estate Tax Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193416 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter LBR General monitoring of labor/management issues Strengthening Career and Technical Education for the 21st Century Act, (H.R. 2353) American Workforce Policy Advisory Board, National Council for the American Worker Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-04:00
2193417 ASSOCIATION FOR PRINT TECHNOLOGIES da3d9fec-7c39-485a-8a79-eec75f765d77 Q3 ASSOCIATION FOR PRINT TECHNOLOGIES 4458 ASSOCIATION FOR PRINT TECHNOLOGIES 2018 third_quarter TAR Canadian Ground Wood Paper Countervailing and Anti-dumping duties petitions Section 232 Steel and Aluminum Tariffs Section 301 Chinese Tariffs Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,U.S. Trade Representative (USTR)   60000 0 0 2018-10-18T18:15:59.377000-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);