lobbying: lobbying_activities: 30 rows where filing_uuid = "f7adc2b8-4875-4e08-8fc9-b8b1f0df246b" 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.

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

30 rows where filing_uuid = "f7adc2b8-4875-4e08-8fc9-b8b1f0df246b" 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	expense_amount	received_date
1158904	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	WAS	Peer reviewed research as it relates to reduction and handling of wastes; EPA proposed rules - college & university waste lab disposal Superfund funding as it relates to research	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158905	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	COM	Corporation for Public Broadcasting funding	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158906	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	ENG	Energy Sustainability and Efficiency Grants and Loans for Institutions as authorized in EISA Energy and Water Appropriations, funding for DOE	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158907	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	MIA	Distance Learning NIH Public Access Policy Copyright issues as they relate to universities/libraries Federal Research Public Access Act of 2009 Access to research publications - dissemination	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158908	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	ACC	None	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158909	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	DEF	DOD export controls Army Corps of Engineers Coralville Reservoir outflow FY 2011 Appropriations FY 2012 Appropriations	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158910	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	RET	Retirement issues related to universities' pension plans IRA issues related to philanthropic giving	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158911	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	ENV	Peer review research funding as it relates to the environment - spans agencies/NIST NIEHS funding as it relates to superfund research	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158912	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	GOV	Indirect costs issues	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158913	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	ANI	Animal Care Legislation as relates to research	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158914	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	HOM	FEMA funding for flood recovery	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158915	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	BAN	Implementation of the Higher Education Act as it relates to direct student loan - ability to consolidate loans and loan interest rates Federal Family Education Loan and Direct Loan programs	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158916	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	TEC	Modernize Our Bookkeeping in the Law for Employee's Cell Phone Act	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158917	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	UTI	Utilities deregulation as it relates to universities Incentives for green utilities Tax extenders	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158918	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	AGR	Biotechnology issues	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158919	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	TRA	DOT appropriations overall - especially NHTSA Road user fees and related research issues Reauthorization of Amtrak Iowa Road Use Study Driver Distraction Study	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158920	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	SPO	Tax issues as it relates to non-profits - athletic programs	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158921	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	ROD	DOT appropriations overall and appropriations from NHTSA Road usage fees and related research issues Iowa Road Use Study Driver Distraction Study	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158922	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	TAX	Charitable giving as it relates to universities and their foundations; (see addendum page) Collegiate Housing and Infrastructure Nonprofit Capacity Building, Serve America Act FICA issues employees/students; graduate student tax issues; IRA rollover; tax issues as they relate to research facilities and bonding; R&D Tax credit Tax incentives as it relates to higher education - UBIT - exemptions for higher education related expenses for students Comprehensive tax package Tax extenders	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158923	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	CPT	America Invents Act of 2011 (H.R. 1249) Orphan works NIH Public Access The role of gene patents in research and genetic testing Secretary's Advisory Committee on Genetics, Health and Society (SACGHS) Draft Report on Gene Patents and Licensing Practices	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158924	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	ECN	Bayh-Dole integrity issues S-493 Small business innovation research Department of Commerce export control Funding for science and techology issues and workforce across agencies Flood relief, community development block grants	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158925	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	HCR	Labor HHS FY 2011 appropriations Area Health Education Centers Nursing Education Loan Forgiveness Program funding for basic research at NIMH Role of gene patents in research and genetic testing Nurse Education, Expansion, and Development (NEED) Act conflicts of interest in research CDC funding for Injury Control Research Centers Biomonitoring for disease prevention and intervention Funding for state hygienic laboratories Funding for Birth Defects Surveillance Centers Graduate Medical Education National Network of State Health Surveys Lab Security (Biological Laboratory Security Briefing) Statewide Local Health Surveys NIOSH Worklife Center Program NIOSH Education and Research Centers Prevention Research Centers FY 2012 Appropriations High Value Healthcare Collaborative	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158926	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	FOR	Cultural diplomacy programs (see addendum page) Export controls Foreign Operations appropriations as it relates to peer reviewed projects International students & scholars - barriers to enter US Cultural exchanges - promotions Information technology resources in developing world FY 2011 Appropriations FY 2012 Appropriations	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158927	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	MMM	Medicare reimbursement Iowa hospitals; CMS interagency transfers; IME issues; Medicaid reimbursement issues; DHS; GME (dental and others); Medicare and Medicaid reimbursement issues as related to academic teaching hospitals; CMS rules as they relate to physician and hospital payments, 340 B Drug Pricing Program Federal Medical Assistance Percentages	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158928	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	BUD	FY2011 Appropriations (H.R. 3288) FY 2011 Supplemental Appropriations FY 2012 Appropriations NIOSH Education and Research Centers for Occupational Health and Safety Area Health Education Centers (AHEC) FEMA funding for flood recovery Disaster relief funding Funding for the National Institutes of Health and the National Library of Medicine FY 2011 appropriations for the National Endowment for the Humanities Funding for arts education Funding for Energy Sustainability and Efficiency Grants and Loans for Institutions as authorized in the Energy Security and Independence Act (EISA) Demonstration to Maintain Independence and Employment (DMIE) Funding for NSF and DOE Commerce, Justice, State appropriations SBIR/STTR (S. 493) Pell grants, student aid FY 2011 Defense Appropriations (H.R. 3226) Student Aid and Fiscal Responsibility Act Corporation for National and Community Service, Nonprofit Capacity Building Program Nursing Workforce Development Programs (Title VIII of the Public Health Service Act) HJ Res 48 HR 2017 Homeland Security Appropriations	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158929	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	IMM	Caps of visas F, J, and non-immigrants - student exchanges Employment verification	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158930	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	EDU	Science and Math Issues Campus Safety Act FY 2011 Appropriations FY 2012 Appropriations Science and Math priorities Increased Pell Grants - student aid Perkins Loans; FERPA; Javits; GAAN Accreditation issues; Commission on Higher Education Upward Bound; College Cost Reduction HEA Reauthorization; Title VI programs Equal access to higher education for persons with disabilities Title VII Area Health Education Centers Student financial aid system Student Veterans Association FICA witholding for graduate students Serve America Act Title II, Higher Education Act Title II, No Child Left Behind	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158931	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	PHA	Increased appropriations for systems to shorten the time between development of a drug and its release to the public FDA reform as it relates to drug development and research Collaborative research on drug development anti-malarial pharmaceuticals FY 2011 Agricultural Appropriations human factors research related to neuropharmaceuticals	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158932	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	MED	FY 2011 Appropriations Residency Caps FY 2012 Appropriations Minority Improvement Medical Affordability Act False Claims Correction Act Research Misconduct Clinical Trials NIOSH Education and Research Centers for Occupational Health and Safety Pathways for Biosimilars Act Prevention Research Centers Resident Physician Shortage Health Care Reform	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-04:00
1158933	UNIVERSITY OF IOWA f7adc2b8-4875-4e08-8fc9-b8b1f0df246b	Q3	UNIVERSITY OF IOWA	49191	UNIVERSITY OF IOWA	2011	third_quarter	SCI	FY 2012 Appropriations FY 2011 Appropriations Funding for scientific research/science agencies FY 2011 CJS appropriations National Competitiveness Act Scientific Communications Act Sowing the Seeds thru Science & Engr Competivenss Science/Math Interagency Coordination - High Performance Computing NSF Reauthorization; ACI; STEM Research funding for TB/HIV Research Public access and research published in scholarly journals America Competes Act Commercialization of University-based research	Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT)	88684	2011-10-19T14:29:01.677000-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);