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

30 rows where filing_uuid = "7672d2b0-3370-4a85-929e-4eaa5dffa7c4" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: specific_issues, received_date (date)

issue_code 30

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
1585869 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter DEF FY 2012 Appropriations FY 2013 Appropriations FY 2014 Appropriations FY 2015 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585870 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585871 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585872 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585873 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585874 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter IMM N/A 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585875 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585876 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585877 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter WAS N/A 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585878 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585879 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter TEC N/A 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585880 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter CPT S 1720 Patent Transparency and Improvements 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585881 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585882 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter MIA Distance Learning NIH Public Access Policy Copyright issues as they relate to universities/libraries 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585883 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585884 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter ROD DOT appropriations overall and appropriations from NHTSA 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585885 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter UTI 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585886 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter TRA DOT appropriations overall - especially NHTSA FY 14 Appropriations Driver Distraction Study FY 15 Appropriations UTC Programs FY 13 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585887 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter TAX Charitable giving as it relates to universities and their foundations; (see addendum page) Collegiate Housing and InfrastructureFICA issues employees/students; graduate student tax issues; IRA rollover; tax issues as they relate to research facilities and bonding; R&D Tax credit 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585888 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter ECN Bayh-Dole integrity issues 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585889 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter HCR Area Health Education Centers Funding for basic research at NIMH Nursing Education Loan Forgiveness Program Role of gene patents in research and genetic testing Conflicts of interest in researchFunding for state hygienic laboratories Graduate Medical Education Lab Security (Biological Laboratory Security Briefing) NIOSH Worklife Center Program NIOSH Education and Research Centers Prevention Research Centers High Value Healthcare Collaborative FY 2012 Appropriations Labor HHS FY 2013 FY 2014 Appropriations National Network of Depression Centers Nurse Examiners Injury Prevention Research Center FY 2015 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585890 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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 International research teaching & engagement FY 2012 Appropriations FY 2013 Appropriations FY 2014 Appropriations FY 2015 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585891 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585892 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 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 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585893 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter BUD FY 2012 Appropriations FY 2013 Appropriations FY 2014 Appropriations FY 2015 AppropriationsNIOSH 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 Funding for arts education Funding for NSF and DOE Commerce, Justice, State appropriations Pell grants, student aid Stafford Loans 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585894 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter ENV Peer review research funding as it relates to the environment - spans agencies/NIST WRDA 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585895 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter MED FY 2012 Appropriations, Residency Caps, Minority Improvement, NIOSH Education and Research Centers for Occupational Health and Safety FY 2015 AppropriationsPrevention Research Centers Resident Physician Shortage Health Care Reform FY 2013 Appropriations FY 2014 Appropriations FY 2015 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585896 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter ENG 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585897 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter EDU Science and Math Issues / STEM FY 2012 Appropriations and FY 2013 Appropriations FY 2014 Appropriations FY 2015 AppropriationsScience and Math priorities Increased Pell Grants - student aid Perkins Loans; FERPA; Javits; GAAN Accreditation issues; Commission on Higher Education HEA Reauthorization Equal access to higher education for persons with disabilities Area Health Education Centers Student financial aid system Student Veterans Association Stafford Loans National Endowment for the Humanities 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-04:00
1585898 UNIVERSITY OF IOWA 7672d2b0-3370-4a85-929e-4eaa5dffa7c4 Q3 UNIVERSITY OF IOWA 49191 UNIVERSITY OF IOWA 2014 third_quarter SCI FY 2012 Appropriations Funding for scientific research/science agenciesPublic access and research published in scholarly journals America Competes Act Commercialization of University-based research FY 2013 Appropriations FY 2014 Appropriations FY 2015 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,Transportation, Dept of (DOT)   85562 0 0 2014-10-14T16:19:10.483000-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);