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 = "dfca5e04-e2cb-4c10-817e-d2a873eaca98" 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
593342 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter TAX Solar tax credit, IRA charitable tax roll-over issue, university endowment issues, three percent withholding on vendor payments issue. HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593343 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter HCR Funding for the National Institutes of Health, legislation addressing nursing shortage authorization HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593344 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter SCI NASA science and aeronautics funding, patent reform authorization issues, DOE Office of Science funding, National Science Foundation funding, National Science Board membership, technology transfer issues per Bayh-Dole HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593345 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter IND Funding for scholarship programs through the Bureau of Reclamation HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593346 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter ENG Energy Sustainability and Efficiency Grants and Loans program funding (section 471 of PL 110-140), Electric Power Transmission Reliability funding per Section 925 of Energy policy Act of 2005, Department of Energy Office of Science funding. HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593347 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter AGR USDA National Research Initiative USDA reorganization HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593348 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter EDU Higher Education Authorization Act, Study Abroad Foundation authorization and funding issues, Peer to Peer file sharing issues, Pell grant funding, Urban Serving Universities grant authorization program and funding issues, Universities Sustainability grant program authorization and funding, Graduate Assistance in Areas of national Need, HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593349 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter TRA Central Phx/East Valley Light rail project. HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593350 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter ENV Authorization and funding for the University Sustainability program in Higher Education Act, funding to implement program for sustainability efficiency grant and loan program. HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593351 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter DEF Funding for Electronics and electronic Devices program, Funding for End item Industrial Preparedness Activity, indirect cost cap on 6.1 funding. HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-04:00
593352 ARIZONA STATE UNIVERSITY dfca5e04-e2cb-4c10-817e-d2a873eaca98 Q1 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2008 first_quarter COM Funding for the Corporation for Public Broadcasting, Public Telecommunications Facility Program. HOUSE OF REPRESENTATIVES,SENATE   28500 0 0 2008-04-16T18:25:19-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);