lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "da7cab3e-e3d4-4f29-90c6-99c0ec415c3a" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 639476 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | TAX | S 819/HR 1419 "Pulbic Good IRA Rollover Act of 2007" - entire bill general issues on educational tax provisions, endowments HR 5719 "Taxpayer Assistance and Simplification Act" sections pertaining to employee's cell phones, 3% withholding Renewable Energy and Job Creation Act of 2008 - section pertaining to IRA Rollover & tuition deduction S. 2668 "Modernize Bookkeeping in the Law for Employee's Cell Phone Act of 2008" - entire bill | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639477 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | CPT | HR 1908/S 1145 "Patent Reform Act of 2007" - entire bill HR 4137/S 1642 "Higher Education Reauthorization Act" - sections pretaining to illegal file sharing HR 5880/S 2913 "Orphan Works" - sections regarding state sovereign immunity, dark archives HR 4853/S 2041 "False Claims Act" - sections regarding liability upon receipt of overpayment; abolition of the public disclosure defense; pleading rules for realtors; exapnsion of whistblower litagation; and statute of limitations | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639478 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | HCR | HR 4043/S 2347 "Prevention Through Affordable Access Act" - entire bill S. 2112 "Nurse-Managed Health Clinic Investment Act of 2007" - entire bill issues pertaining to value-based health insurance design | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639479 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | MMM | S. 2460 - entire bill HR 5613 "Protecting the Medicaid Safety Net Act of 2008" - entire bill S. 2376 "Medical Homes Act of 2007" - sections pertaining to nursing | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639480 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | BUD | HConRes 312/SConRes 70 "Congressional Budget Resolution for FY 2009" sections pertaining to NIH, NIST, NASA, NSF, Education Labor/HHS appropriations Department of HHS pertaining to Public Health Service, Title VII & VIII programs, CDC, NIOSH, NIH, National Institute of Nursing Research. Department of Education pertaining to student financial aid, international education programs, graduate education, grant opportunities; Corporation for Public Broadcasting S. 3182 -Science, State, Commerce, Appropriations for FY 2009 - Department of Commerce sections pertaining to the National Oceanic Atmospheric Administration's research programs and protection of external research funds at NOAA; and University Centers funded through EDA; Public Telecommunications Facilities Program, Trade Adjustment Assistance for firms, Auto Plant closing project at EDA; NASA research programs, including Space Grant; NSF research and educational programs Department of Defense Appropriations for FY 2009 - sections pertaining to basic and applied defense research, indirect costs for research grants and TACOM Robotics program; medical research; support for School of Engineering at UM-Dearborn Military and Veteran's Affairs FY 2009 - pertaining to Ann Arbor VA partnership Energy & Water FY 2009 - Department of Energy programs, specifically the Office of Science; Krell fellowships, ARPA-E, Energy Frontier Research Centers Interior and Environment FY 2009 - sections pertaining to National Endowment for the Arts, National Endowment for the Humanities HR 2642 - FY 2008 Supplemental Appropriations pertaining to NSF and DOE Office of Science | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639481 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | SPO | H. Res 1120 - Bowl Championship Series - entire bill | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639482 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | EDU | S. 1642/HR 4137 "Higher Education Reauthorization Act" - entire bill except Titles III & V HR 1469/S 991 "Paul Simon Study Abroad Act" - entire bill HR 5715 "Ensuring Continued Access to Student Loans Act of 2008" - sections pertaining to expanding eligibility to the ACG and SMART grant programs | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639483 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | TEC | Big Ten Network cable carriage issues - no bill XM/Sirius merger - no bill | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639484 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | ECN | HR 3920/S 1848 "Trade and Globalization Assistance Act: - section pertaining to TAA firms | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639485 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | ART | Issues around claims on Irani antiquities held in museums as payment for victims of terrorism | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639486 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | IMM | HR 5515 "New Employee Verification Act" - entire bill Issues regarding E-Verify; Optional Practical Training; visas for foreign students and scholars HR 5882 "To Recapture Employment Based Visas" - entire bill HR 5921 "To amend INA regarding per country limits for EB visas" - entire bill HR 6039 "Green cards for US educated STEM graduates" - entire bill | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-04:00 | |
| 639487 | UNIVERSITY OF MICHIGAN da7cab3e-e3d4-4f29-90c6-99c0ec415c3a | Q2 | UNIVERSITY OF MICHIGAN | 39473 | UNIVERSITY OF MICHIGAN | 2008 | second_quarter | IND | HR 4027 - to amend NAGPRA - issues pertaining to culturally unidentified human remains and funerary objects | Commerce, Dept of (DOC),Defense, Dept of (DOD),Economic Development Administration,Education, Dept of,Energy, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),SENATE,Veterans Affairs, Dept of (VA) | 190000 | 0 | 0 | 2008-07-18T14:26:28-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,
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);