lobbying: lobbying_activities: 15 rows where filing_uuid = "8c44c60c-75ac-4e68-a468-c1b73f6abeab" sorted by filing

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. Sortable columns (indexed): client_name, issue_code, filing_year, filing_uuid. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

15 rows where filing_uuid = "8c44c60c-75ac-4e68-a468-c1b73f6abeab" sorted by filing_year descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id	filing_uuid	filing_type	registrant_name	registrant_id	client_name	filing_year ▲	filing_period	issue_code	specific_issues	government_entities	received_date
511039	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	ECN	HR 1332--Small Business Lending Improvements Act, ensuring access for start-up and small businesses by maximizing eligibility	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511040	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	MMM	S 3--Medicare Prescription Drug Price Negotiation Act of 2007, lowering price of prescription drugs	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511041	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	ENV	HR 720--Water Quality Financing Act, EPA compliance, clean water supplies, research HR 1495--Water Projects Authorization bill, clear water supplies, research	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511042	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	BUD	H.Con.Res. 99--FY2008 Budget Resolution, research funding for NSF, DoE, and NIH HR 2206--FY2007 Supplemental Spending Bill, DoD research funding S.Con.Res. 21--FY2008 Budget Resolution, research funding for NSF, DoE, and NIH	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511043	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	TAX	HR 1677--Taxpayer Protection Act of 2007, revision of tax provisions and taxpayer protections	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511044	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	MED	HR 3043, S1710--FY2008 Labor/Health and Human Services/Education Appropriations bill, NIH and CDC research and training	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511045	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	DEF	HR 1591--FY2007 Emergency Supplemental War Funding, DoD research HR 2642--Military Construction and VA Appropriations bill, VA medical research funding S 965--FY2007 Emergency Supplemental War Funding, VA medical research funding HR 3222--FY2008 Defense Appropriations bill, DoD 6.1 and 6.2 medical and rehabilitation research HR 1585, S 1547--FY2008 Defense Authorization bill, DoD 6.1 and 6.2 research, including medical and rehabilitative projects	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511046	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	CPT	HR 1908--Patent Reform Act, technology transfer, patent filing, Bayh Dole Act S 1145--Patent Reform Act, technology transfer, patent filing, Bayh Dole Act S 3808--Patent Reform Act, technology transfer, patent filing, Bayh Dole Act	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511047	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	HCR	S 3--Medicare Prescription Drug Price Negotiation Act of 2007, lowering cost of prescription drugs S 5--Stem Cell Research Enhancement Act of 2007, expansion of federal funding for stem cell research S 30--Alternative Stem Cell Research bill, expansion of federal funding for stem cell research, development of new cell lines S 446--Nurse Education, Expansion, and Development Act of 2007, nursing education programs enhancement HR 976--Small Business Tax Relief Act of 2007, reauthorization of the State Children's Health Insurance Program HR 3043, S 1710--FY2008 Labor/Health and Human Services/Education Appropriations bill, NIH research and training funding, CDC research and training funding, student financial aid HR 1944--Veterans Traumatic Brain Injury Treatment Act of 2007, identification of, research on, and treatment of traumatic brain injury	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511048	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	GOV	S 1--Honest Leadership and Open Government Act of 2007, reform of Congressional ethics and lobbying rules S 230--Lobbying and Ethics Reform Act of 2007, reform of Congressional ethics and lobbying rules	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511049	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	ENG	HR 6--CLEAN Energy Act of 2007, energy research, global climate change HR 2337--Energy Policy Reform and Revitalization Act of 2007, energy research, global climate change HR 2776--Renewable Energy and Energy Conservation Tax Act of 2007, energy research, global climate change	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511050	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	IMM	S 1328--Immigration Reform Legislation/Uniting American Families Act of 2007, immigration and visa issues S 1639--Comprehensive Immigration Reform Bill, immigration and visa issues	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511051	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	EDU	HR 363--The Sowing the Seeds Through Science and Engineering Research Act, STEM education, teacher preparation, innovation and competitiveness, and scientific workforce development HR 592--Campus Fire Safety Right-to-Know Act of 2007, fire safety standards, notification of fire statistics, fire suppression and alarm systems HR 642--College Fire Prevention Act, demonstration program with funding for campus fire prevention programs HR 1469--Senator Paul Simon Study Abroad Foundation Act of 2007, international education and study abroad issues HR 1689--Curb Illegal Downloading on College Campuses Act of 2007, prevention of illegal computer file sharing of music and films HR 2220--Mental Health Security for America's Families in Education Act of 2007, FERPA, college student mental health, and violence prevention S 761--America COMPETES Act, innovation and competitiveness, workforce development, STEM education HR 2669--College Cost Reduction Act, student financial aid, access to and affordability of higher education S ??--Higher Education Access Act of 2007, student financial aid, access to and affordability of higher education S 1642--Higher Education Act Amendments of 2007, Reauthorization of the Higher Education Act, student financial aid, teacher preparation and accreditation, international education HR 2669--Student Loan Reconciliation, student financial aid issues, including student loans HR 362--10,000 Teachers, 10 Million Minds Science and Math Scholarship Act, Science, Technology, Engineering, and Mathematics (STEM) teacher preparation, scientific workforce development, innovation and competitiveness	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511052	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	ANI	HR 2419; HR 2844--Farm Bill Reauthorization, Animal Welfare Act and Class B research animal dealers	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00
511053	UNIVERSITY OF PITTSBURGH 8c44c60c-75ac-4e68-a468-c1b73f6abeab	MM	UNIVERSITY OF PITTSBURGH	53356	UNIVERSITY OF PITTSBURGH	2007	mid_year	SCI	HR 1068--To amend the High-Performance Computing Act of 1991, increase support for supercomputing centers HR 1867--National Science Foundation Authorization Act of 2007, increase support for NSF-funded research, scientific workforce development, Math and Science Partnership Program, innovation and competitiveness S 761--America COMPETES Act, innovation and competitiveness, scientific workforce development	HOUSE OF REPRESENTATIVES,SENATE	2007-08-03T20:16:09-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

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,
            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);