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 = "558ef049-eaba-422c-8bc2-a5e64c213906" 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
1405403 ALLETE, INC 558ef049-eaba-422c-8bc2-a5e64c213906 Q2 ALLETE, INC 25476 ALLETE INC 2013 second_quarter CAW Air quality standards and related legislative and environmental regulatory energy policy issues. Water quality standards and related legislative and environmental regulatory energy policy issues. HOUSE OF REPRESENTATIVES,SENATE   44000 0 0 2013-07-12T08:13:38.240000-04:00
1405404 ALLETE, INC 558ef049-eaba-422c-8bc2-a5e64c213906 Q2 ALLETE, INC 25476 ALLETE INC 2013 second_quarter RRR Railroad legislation and regulation related to rail competition, rail regulation and related energy and transportation policy issues. Railroad legislation and regulation related to the application of antitrust laws to the rail industry and related energy and transportation policy issues. HOUSE OF REPRESENTATIVES,SENATE   44000 0 0 2013-07-12T08:13:38.240000-04:00
1405405 ALLETE, INC 558ef049-eaba-422c-8bc2-a5e64c213906 Q2 ALLETE, INC 25476 ALLETE INC 2013 second_quarter UTI General energy, environmental, economic and business-related legislative and regulatory policy issues related to electric and gas utility operations. HOUSE OF REPRESENTATIVES,SENATE   44000 0 0 2013-07-12T08:13:38.240000-04:00
1405406 ALLETE, INC 558ef049-eaba-422c-8bc2-a5e64c213906 Q2 ALLETE, INC 25476 ALLETE INC 2013 second_quarter TAX General corporate tax issues, tax reform and related tax policy matters. Tax issues affecting electric and gas utilities, coal mining, coal use and related tax policy matters. Renewable energy, clean energy and energy efficiency tax incentives and related tax policy issues. Pension plan funding stabilization, pension security policy issues. HOUSE OF REPRESENTATIVES,SENATE   44000 0 0 2013-07-12T08:13:38.240000-04:00
1405407 ALLETE, INC 558ef049-eaba-422c-8bc2-a5e64c213906 Q2 ALLETE, INC 25476 ALLETE INC 2013 second_quarter ENV Electric utility air, water, solid waste, coal ash and related legislative and regulatory environmental policy issues. Clean energy sources, energy efficiency, conservation and related policy issues. Gas utility air, water, and related legislative and regulatory environmental policy issue. Coal mining, coal use, land use and related legislative and regulatory environmental policy issues. HOUSE OF REPRESENTATIVES,SENATE   44000 0 0 2013-07-12T08:13:38.240000-04:00
1405408 ALLETE, INC 558ef049-eaba-422c-8bc2-a5e64c213906 Q2 ALLETE, INC 25476 ALLETE INC 2013 second_quarter ENG Electric utility and related legislative and regulatory energy policy issues. Gas utility and related legislative and regulatory energy policy issues. Coal mining, coal use, land use and related legislative and regulatory energy policy issues. Renewable / clean energy use and related legislative and regulatory policy issues. HOUSE OF REPRESENTATIVES,SENATE   44000 0 0 2013-07-12T08:13:38.240000-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);