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

13 rows where filing_uuid = "d7f55be3-cbe2-409e-a50d-e0fd990820a7" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 13

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
2115537 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter CHM Public Law 114-182 Toxic Substances Control Act (TSCA) Reform Implementation Consumer Right to Know Legislation, issues, generally, no specific legislation Clean Product Right to Know Act, issues, generally, no specific legislation Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115538 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter DEF H.R.1625/H.R.3219 FY18 Defense Appropriations H.R.2810 FY18 National Defense Authorization Act H.R.2810 DOD Procurement Reform FY19 Defense Appropriations FY19 Transportation Appropriations FY19 VA Appropriations Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115539 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter FOR H.R.1625/H.R.3362/S.1780 FY18 Foreign Aid Appropriations HCFC phase-down - Montreal Protocol Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115540 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter ENG H.R.3266/S.1609 Renewable Fuel Technologies H.R.1625/H.R.3266/S.1609 FY18 Energy & Water Appropriations H.R.3266/S.1609 Energy Efficiency Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115541 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter TAR H.R.4318/S.2108 Miscellaneous Tariff Legislation Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115542 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter HCR H.R.195/H.R.184;H.R.4617/S.108 Medical Device Tax, and related repealed issues, generally Medicare and Medicaid payment quality programs and policies, including: healthcare associated complications, infections, readmission, payment bundling, potentially preventable events and outcomes, and value based purchasing Medicare and Medicaid data and patient-centered medical records policies Opioid epidemic related policies Implementation of the Patient Protection and Affordable Care Act (PL 111-148) Implementation of the Helping Hospitals Improve Patient Care Act 21st Century Cures Act (Public Law No: 114-255) Implementation of the Medicare Access CHIP Reauthorization Act (MACRA)(PL 114-10) Regulations and legislation related to International Classification of Diseases, version 10 (ICD-10) S.428, ACE Kids Act H.R.3611, the Healthcare Outcomes Act H.R.3922 Champion Act S.1827, Kids' Insurance Dependable and Secure (KIDS) Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115543 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter ROD Work Zone Safety, issues, generally, no specific legislation Traffic Safety, issues, generally, no specific legislation Fast Act Implementation, issues, generally, no specific legislation Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115544 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter TRA Solvency of the Highway Trust Fund, issues, generally, no specific legislation Intelligent Transportation Systems, issues, generally, no specific legislation Connected and Automated Vehicles S. 1885 - the AV START Act, H.R. 3388 - the SELF DRIVE Act S.1405 Federal Aviation Administration Reauthorization of 2017 H.R.1625/H.R.3353/S.1655 FY 2018 Transportation Appropriations Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115545 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter TAX Implementation of H.R. 1, Public Law No. 115-97, Tax Cuts and Jobs Act, H.R.195/H.R.1370 Medical Device Tax Repeal S.108 - Medical Device Access and Innovation Protection Acts HR 1204 Responsible Additions and Increases to Sustain Employee Health Benefits Act HR 1175, S.403 Health Savings Act The Technologies for Energy Security Act, H.R.1090/H.R.1625 Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115546 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter MMM Medicare and Medicaid payment quality programs and policies, including: healthcare associated complications, infections, readmission, payment bundling, potentially preventable events and outcomes, and value based purchasing Medicare and Medicaid data and patient-centered medical records policies Opioid epidemic related policies Implementation of the Patient Protection and Affordable Care Act (PL 111-148) Implementation of the Helping Hospitals Improve Patient Care Act 21st Century Cures Act (Public Law No: 114-255) Implementation of the Medicare Access CHIP Reauthorization Act (MACRA)(PL 114-10) Regulations and legislation related to International Classification of Diseases, version 10 (ICD-10) S.428, ACE Kids Act H.R.3611, the Healthcare Outcomes Act H.R.3922 Champion Act S.1827, Kids' Insurance Dependable and Secure (KIDS) Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115547 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter BUD H.R.1625/H.R.3219 FY18 Defense Appropriations H.R.1625/H.R.6266/S.1609 FY18 Energy & Water Appropriations H.R.1625/H.R.3353/S.1655 FY18 Transportation Appropriations H.R.1625/H.R.3362/S.1780 FY18 Foreign Aid Appropriations FY19 Defense Appropriations FY19 Transportation Appropriations FY19 VA Appropriations Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115548 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter ENV Public Law 114-182 Toxic Substances Control Act (TSCA) Reform Implementation Consumer Right to Know Legislation, issues, generally, no specific legislation Clean Product Right to Know Act, issues, generally, no specific legislation EPA Regulatory Reform, issues, generally, no specific legislation HCFC phase-down - Montreal Protocol Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-04:00
2115549 3M COMPANY d7f55be3-cbe2-409e-a50d-e0fd990820a7 Q1 3M COMPANY 25465 3M COMPANY 2018 first_quarter CSP Pandemic All Hazards Preparedness Act Reauthorization(PAHPA, issues, generally, no specific legislation Prep Act coverage of NIOSH approved respirators, issues, generally, no specific legislation Project Bioshield coverage of NIOSH - approved respirators, issues, generally, no specific legislation Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   830000 0 0 2018-04-19T13:50:46.390000-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);