lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
15 rows where filing_uuid = "c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2560805 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | DEF | Defense Appropriations Act - Title IV - In support of increased funding for Defense Science and Technology, and Basic and Applied Research in all services. In support of funding for MK-48 ADCAP, Lightweight Torpedo Development, Large Unmanned Undersea Vehicles, Advanced Submarine System Development, and Vertical Lift Research Center of Excellence. In support of funding for New Design SSN. In support of National Defense Authorization Act provision that would establish an academic liaison at the Department to protect from undue foreign influence and other security threats. In support of provisions that support scientific research and engineering to enhance national security in NDAA conference agreement. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560806 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | AGR | Agriculture, Rural Development, Food and Drug Administration and Related Agencies Appropriation - Title I - National Institute of Food and Agriculture - In support of increased funding for Agriculture Food and Research Initiative, Hatch Act, Smith-Lever, and McIntire-Stennis Cooperative Forestry Research program. In support of Regional Rural Development Center. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560807 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | HCR | Health and Human Services Appropriations - In support of funding for the National Institutes of Health, Area Health Education Centers Program, and Health Resources and Services Administration Title VII programs. In support of funding for Regional Response Health Collaboration Program. In support of extension for 340B program and opposition to proposal to reduce Medicare Part B payments for drugs acquired through 340B program. In support of a one-year moratorium on 340B regulations. In support of forgiveness for Medicare accelerated payments. In support of protection of 340B eligibility in future supplemental funding bills. In support of liability coverage for COVID-19 services in provider relief. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560808 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | POS | In support of U.S. Postal Service recategorization of buildings in State College to receive mail delivery onsite in unit mailboxes. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560809 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | SMB | In support of Small Business Administration Women's Business Center grant proposal. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560810 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | BUD | Defense Appropriations Act - Title IV - In support of increased funding for Defense Science and Technology, and Basic and Applied Research in all services. In support of funding for MK-48 ADCAP, Lightweight Torpedo Development, Large Unmanned Undersea Vehicles, Advanced Submarine System Development, and Vertical Lift Research Center of Excellence. In support of funding for New Design SSN. Education Appropriations - In support of funding for the Federal Pell Grant Program, Federal Supplemental Educational Opportunity Grant, and Federal Work-Study program. Agricultural, Rural Development, Food and Drug Administration and Related Agencies Appropriation - Title I - National Institute of Food and Agriculture - In support of increased funding for Agriculture and Food Research Initiative, Hatch Act, Smith-Lever, and McIntire Stennis Cooperative Forestry Research program. In support of funding for Regional Rural Development Centers. Commerce, Justice, Science Appropriations - In support of funding for National Science Foundation. In support of funding for NASA Space Grant, Science Mission Directorate, and technosignatures research. In support of funding for Sea Grant program. In support of funding for science researchers whose work is suspended while labs are closed during pandemic. Transportation - In support of funding for Bus Testing Facility program and repeal of anti-competitive language; and opposition to Senate provision that prevents access by bus testing center to previously appropriated component testing funds. In support of funding for the Federal Contract Tower program. State and Foreign Operations Appropriations - In support of Feed the Future Food Security Innovation Labs. Interior Appropriations - In support of funding for Water Resources Research Act program. In support of funding for the National Endowment for the Humanities and National Endowment for the Arts. Energy and Water Development Appropriations - In support of funding for Fossil Energy Research and Development, Advanced… | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560811 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | IMM | In opposition to Immigration and Customs Enforcement guidance removing international students amid online learning. Expressing concerns with Department of Homeland Security proposed rule limiting the duration of status for international student visas and additional restrictions based on country of origin. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560812 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | EDU | Education Appropriations - In support of funding for the Federal Pell Grant Program, Federal Supplemental Educational Opportunity Grant Program, and Federal Work-Study program. In support of funding and regulatory flexibility for students, healthcare, research, extension, and operations, including limited liability protections, at institutions of higher education. In support of Fostering Postsecondary Success for Foster and Homeless Youth Act. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560813 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | SCI | Commerce, Justice, Science Appropriations - In support of funding for National Science Foundation. In support of funding for NASA Space Grant, Science Mission Directorate, and technosignature research. In support of funding for Sea Grant program. In support of funding for science researchers whose work is suspended while labs are closed during pandemic. In support of H.R.6216/S.1558, the National Artificial Intelligence Initiative Act. In support of language in National Science Foundation reauthorization that directs NSF to develop a multi-year strategic plan. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560814 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | NAT | Interior Appropriations - In support of funding for Water Resources Research Act program. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560815 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | ART | Interior Appropriations - In support of funding for the National Endowment for the Humanities and National Endowment for the Arts. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560816 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | TEC | Labor - HHS - Education and Related Agencies Appropriations - In support of the Corporation for Public Broadcasting. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560817 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | ENG | Energy and Water Development Appropriations - In support of Fossil Energy Research and Development, Advanced Research Projects Agency - Energy, and Office of Science. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560818 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | FOR | State and Foreign Operations Appropriations - In support of Feed the Future Food Security Innovation Labs. In support of H.R.8346, the Academic Research Protection Act, and a Senate companion. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05:00 | |
| 2560819 | THE PENNSYLVANIA STATE UNIVERSITY c74e65fc-5baa-46a5-9dc4-9d8f0a16ef4e | Q4 | THE PENNSYLVANIA STATE UNIVERSITY | 31100 | PENNSYLVANIA STATE UNIVERSITY | 2020 | fourth_quarter | TRA | Transportation - In support of funding for Bus Testing Facility program and repeal of anti-competitive language in appropriations and surface transportation authorization; and opposition to Senate provision that prevents access by bus testing center to previously appropriated component testing fund. In support of funding for the Federal Contract Tower program. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,U.S. Postal Service (USPS) | 100000 | 0 | 0 | 2021-01-19T17:03:41.557000-05: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);