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

11 rows where filing_uuid = "2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 11

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
2351226 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter ENV Draft bill on Energy Star Reform Electronics Recycling Electronics Waste Green Infrastructure Materials Restrictions Regulatory Reform US Environmental Trade Policy Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351227 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter TAX Corporate tax reform Implementation of PL. 115-97, Tax Cuts and Jobs Act Issues related to Online Sales Tax Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351228 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter CPT Chinas Intellectual Property policies and US trade tariffs as a result thereof Fair Use Intellectual Property/Trade Agreements Issues related to patent litigation abuse Japan Bilateral Trade Agreement analysis North American Free Trade Agreement (NAFTA) Online Infringement World Trade Organization reform and electronic transmission moratorium Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351229 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter IMM Issues related to Immigration Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351230 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter TRD European Union Airbus Subsidies Export Controls French Digital Tax General Trade Legislation Japan Bilateral Trade Agreement analysis US - Mexico - Canada trade agreement (USMCA) Section 301, China and Section 232, Steel and Aluminum of The Trade Act, threat on autos and auto parts Small and Medium Enterprises/Exports World Trade Organization reform and electronic transmission moratorium Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351231 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter TRA Autonomous Vehicles Policy Connected Vehicles Policy Issues related to Micromobility policy Ride Sharing Policy Unmanned Aerial Systems policy Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351232 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter CSP H.Res. 153 Supporting the development of guidelines for ethical development of artificial intelligence H.R. 827 AI JOBS Act of 2019 H.R. 2202 GrAITR Act Issues related to Artificial Intelligence, Virtual Reality and Augmented Reality Issues relating to the sharing economy and portable benefits S. 1108 Algorithmic Accountability Act of 2019 Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351233 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter ENG Draft bill on Energy Star Reform Electronics Recycling Electronics Waste Green Infrastructure Materials Restrictions Regulatory Reforms US Environmental Trade Policy Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351234 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter LBR Issues related to Worker Classification Issues related to Worker Training and Apprenticeships Legislation pertaining to the Overtime Rule Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351235 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter INT Facial Recognition policy Issues related to the Internet of Things (IOT) Privacy S. 142 American Data Dissemination Act of 2019 S. 847 Commercial Facial Recognition Privacy Act of 2019 Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-04:00
2351236 CONSUMER TECHNOLOGY ASSOCIATION 2e8a2c1e-1bbb-4286-8e04-e64a8e98a5d6 Q3 CONSUMER TECHNOLOGY ASSOCIATION 73293 CONSUMER TECHNOLOGY ASSOCIATION 2019 third_quarter COM Draft "Dig Once" bill Draft "Airwaves Act" bill H.R. 6032 the SMART IOT Act (115th Cong.) S. 19 MOBILE NOW Act (115th Cong.) S. 1611 DIGIT Act Section 230 of the Communications Decency Act Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   1620000 0 0 2019-10-18T12:25:13.347000-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);