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

6 rows where filing_uuid = "9aee631c-28fa-4a0c-b3f3-0f78cdbfa7c4" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 6

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
1941583 ENVIRONMENTAL WORKING GROUP 9aee631c-28fa-4a0c-b3f3-0f78cdbfa7c4 1A ENVIRONMENTAL WORKING GROUP 69457 ENVIRONMENTAL WORKING GROUP 2016 first_quarter AGR S.463 - Bill to amend the Federal Crop Insurance Act to prohibit the paying of premium subsidies on policies based on the actual market price of an agricultural commodity at the time of harvest; H.R.892 - Harvest Price Subsidy Reduction Act, all sections; and H.R. ______ - FY 2017 Agriculture Appropriations Bill, sections pertaining to cotton subsidies and conservation programs. HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2017-02-06T09:44:22.490000-05:00
1941584 ENVIRONMENTAL WORKING GROUP 9aee631c-28fa-4a0c-b3f3-0f78cdbfa7c4 1A ENVIRONMENTAL WORKING GROUP 69457 ENVIRONMENTAL WORKING GROUP 2016 first_quarter CHM S.697 - Frank R. Lautenberg Chemical Safety for the 21st Century Act, all sections; S.725 - Alan Reinstein and Trevor Schaefer Toxic Chemical Protection Act, all sections; H.R.2576 - TSCA Modernization Act of 2015, all sections; and H.R.2030 and S.700 - Reducing Exposure to Asbestos Database Act of 2015, all sections. HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2017-02-06T09:44:22.490000-05:00
1941585 ENVIRONMENTAL WORKING GROUP 9aee631c-28fa-4a0c-b3f3-0f78cdbfa7c4 1A ENVIRONMENTAL WORKING GROUP 69457 ENVIRONMENTAL WORKING GROUP 2016 first_quarter CSP S.1014 - Personal Care Products Safety Act, all sections; and H.R.4075 - Cosmetic Modernization Amendments of 2015, all sections; and H.R. ______ - Legislation that would reform federal cosmetics law. HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2017-02-06T09:44:22.490000-05:00
1941586 ENVIRONMENTAL WORKING GROUP 9aee631c-28fa-4a0c-b3f3-0f78cdbfa7c4 1A ENVIRONMENTAL WORKING GROUP 69457 ENVIRONMENTAL WORKING GROUP 2016 first_quarter FUE H.R.704 - RFS Reform Act, a bill to amend the Clean Air Act to eliminate certain requirements under the renewable fuel program, to prohibit EPA from approving gasoline that contains greater than 10-percent ethanol, and for other purposes; and S.577 - Corn Ethanol Mandate Elimination Act of 2015, to amend the Clean Air Act to eliminate the corn ethanol mandate for renewable fuel. HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2017-02-06T09:44:22.490000-05:00
1941587 ENVIRONMENTAL WORKING GROUP 9aee631c-28fa-4a0c-b3f3-0f78cdbfa7c4 1A ENVIRONMENTAL WORKING GROUP 69457 ENVIRONMENTAL WORKING GROUP 2016 first_quarter TOR H.R.526 and S.357 - Furthering Asbestos Claim Transparency Act, all sections; H.R.1927 - Fairness in Class Action Litigation Act, sections pertaining to asbestos; and H.R. 712 - Sunshine for Regulatory Decrees and Settlements Act of 2015, sections having a bearing on civil enforcement of federal consumer and environmental protection laws. HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2017-02-06T09:44:22.490000-05:00
1941588 ENVIRONMENTAL WORKING GROUP 9aee631c-28fa-4a0c-b3f3-0f78cdbfa7c4 1A ENVIRONMENTAL WORKING GROUP 69457 ENVIRONMENTAL WORKING GROUP 2016 first_quarter FOO H.R.913 and S.511- Genetically Engineered Food Right-To-Know Act, all sections; S.2609 - Bill to establish a national voluntary labeling standard for GMO foods and preempt state GMO labeling requirements; and S.2621 - Biotechnology Food Labeling Uniformity Act, all sections. HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2017-02-06T09:44:22.490000-05: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);