lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "868cbd4e-e984-4f38-bbae-4f931f80948b" and issue_code = "EDU" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1731661 | UNIVERSITY OF NORTHERN IOWA 868cbd4e-e984-4f38-bbae-4f931f80948b | Q3 | UNIVERSITY OF NORTHERN IOWA | 318276 | UNIVERSITY OF NORTHERN IOWA | 2015 | third_quarter | EDU | FY16 appropriations to NASA (H.R. 2578; H. Rept. 114-130; S. Rept. 114-66) for funding to support early childhood math and science education programs and greater enrollment in STEM programs. FY16 appropriations to Dept. of Education (H.R.3020, S. 1695) for support to increase the participation of minorities in teaching and the leadership of education; early language and literacy education, student financial aid, TRIO Programs, Teacher Quality Partnership Grants, professional development for teachers, STEM programs, and FIPSE. Higher Education Act rules related to state authorization, credit hour definitions, and gainful employment. Reauthorization of the Elementary and Secondary Education Act (Student Success Act" H.R. 5); math and science education partnership programs, physical education programs; increased funding for early childhood education; parent education/involvement programs. Literacy Education, Teacher & Leader Effectiveness, reform of teacher education preparation programs; programs to develop a more diverse teacher and educational leader workforce; funding support to promote school writing (National Writing Program). Student loan interest rates; program to increase school counselors; Title II A of the Higher Education Act on teacher preparation programs; teacher performance assessment; TEACH grant; regulations for administration of student loans. Reauthorization of the Higher Education Act (Every Child Achieves Act - S. 1177): financial aid forms; (Financial Aid Simplification and Transparency Act - S. 108) federal reporting requirements for higher education; reading recovery program support; college scorecards, evaluation and ranking of teacher education programs, proposals to tie title IV aid to completion rates of Pell students. President's college rating proposals on affordability and completion. College completion initiatives including credit for life experience, transfer credit acceptance, and common course numbers; "Strengthening Transparency in Higher Education Act;" "Empowering Students thr… | Agriculture, Dept of (USDA),Defense, Dept of (DOD),Education, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Veterans Affairs, Dept of (VA) | 50000 | 0 | 0 | 2015-10-15T12:06:30.453000-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);