lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
15 rows where filing_uuid = "7012c498-cb3e-4bbb-90b9-45d61ba2107e" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2327157 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | HOM | Support for software assurance research and testing in the FY 20 Homeland Security appropriations bill | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327158 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | NAT | Support for Cooperative Fish & Wildlife Research Units in the FY 20 appropriations bill, support for Water Resources Research Institute in the FY 20 appropriations bill | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327159 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | TAX | Support for H.R. 3300, the Economic Mobility Act (UBIT parking tax) | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327160 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | ENG | Support for Department of Energy Office of Science in FY 20 appropriations bill, Department of Energy Office of Sciences Bioenergy Research Centers in FY 20 appropriations bill, support for fusion research FY 20 appropriations bill, support for ARPA-E, support for the Long-Baseline Neutrino Facility and Deep Underground Neutrino Experiment in FY 20 appropriations bill | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327161 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | DEF | FY 20 National Defense Authorization Act, support for National Security Education Program in FY 20 National Defense Authorization Act, support for the Securing American Science and Technology Act (H.R. 3038), support for National Security Education Program in FY 20 appropriations bill, support for future vertical lift research in the FY 20 appropriations bill, support for traumatic brain injury research in the FY 20 appropriations bill, F-35 siting in Madison, WI | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327162 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | CPT | Issues related to Section 101 patent eligibility | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327163 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | AGR | Support for USDA National Institute of Food and Agriculture (NIFA) programs in FY 20 appropriations bill including the Agriculture and Food Research Initiative, Hatch Act, Smith Lever 3(b) and 3(c) and McIntire-Stennis Cooperative Forestry, support for Genome to Phenome initiative in the FY 20 appropriations bill, support for Germplasm Enhancement of Maize in the FY 20 appropriations bill, support for new Plant Breeding Facility in the FY 20 appropriations bill, support the Veterinary Services Grant Program, support of the USDA NIFA/ERS move, TICKS: Identify, Control, and Knockout Act (HR 3073/S.220), eliminate the Speciality Crop Research Improvement program matching requirement, support for Dairy Business Innovation Initiatives | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327164 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | TEC | Support for the Corporation for Public Broadcasting, issues related to communications law, regulation, and technological innovation for non-commercial broadcasters, issues related to spectrum capacity for non-commercial broadcast stations | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327165 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | HCR | Support of the National Institutes of Health in FY 20 appropriations bill, H.R. 1046/S.377, The Medicare Negotiation and Competitive Licensing Act, issues related to rural health, regulatory burden relief, medicare payment issues, graduate medical education, research policy issues, drug shortages, federal transplant policy, federal infrastructure and transportation and access to health care, issues related to the administrations ban on use of fetal tissue | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327166 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | EDU | Wind down of the Federal Perkins student loan program, renewal of the Federal Perkins program, support for Student Aid Programs in the FY 20 Labor, Health, Human, Services appropriations bill including Pell Grant program, Title IV International Education and Foreign Language study programs, issues related to Higher Education Act reauthorization, support for the Institute for Research on Poverty in the FY 20 Labor, Health, and Human Services apppropriations bill, issues related to Title IX regulations and Executive Order, maintaining Public Student Loan Forgiveness, support the Veterinary Medicine Loan Repayment Program, issues related to the Simon Study Abroad bill (S. 1198), issues related to the Ravi Thackurdeen Safety in Study Abroad bill (S.1572 & H.R.2875), issues related to the American Students Abroad - S. 1575 & H.R. 2876, support for the Advancing International and Foreign Language Education Act (S. 342) | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327167 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | SCI | Support for the National Sea Grant College Program in the FY 20 appropriations bill, support for the National Science Foundation in the FY 20 appropriations bill, support for the National Environmental Satellite, Data, and Information Service (NESDIS) at NOAA in the FY 20 appropriations bill, support for NASA research in the FY 20 appropriations bill, support for WFIRST space satellite in the FY 20 appropriations bill, support for quantum research in the FY 20 appropriations bill, support for the joint fire science research program in the FY 20 appropriations bill, issues related to foreign threats to university research | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327168 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | TRA | Increased funding for federal transportation | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327169 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | BUD | Raise the Budget Caps | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327170 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | IMM | Executive order and issues related to H1-B/Dreamers/DACA and impact to university community, Chinese Peoples Liberation Army (PLA) Visa Security Act (H.R. 2713 / S.1451), Dream Act (H.R. 6), issues related to Optional Practical Training (OPT) processing delays, Social media data collection, Fee increase for F and J, and H-4 elimination proposal | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-04:00 | |
| 2327171 | UNIVERSITY OF WISCONSIN-MADISON 7012c498-cb3e-4bbb-90b9-45d61ba2107e | Q2 | UNIVERSITY OF WISCONSIN-MADISON | 39564 | UNIVERSITY OF WISCONSIN-MADISON | 2019 | second_quarter | ART | Support for National Endowment for the Humanities in the FY 20 appropriations bill | Federal Communications Commission (FCC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2019-07-22T15:26:54.310000-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);