lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "ab563f09-e223-48e4-b1ba-e8b3f5c6982a", filing_year = 2012 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1260276 | EDUCATION LEGISLATIVE SERVICES, INC ab563f09-e223-48e4-b1ba-e8b3f5c6982a | 2T | EDUCATION LEGISLATIVE SERVICES, INC | 13164 | LONG BEACH UNIFIED SCHOOL DISTRICT (CA) | 2012 | second_quarter | EDU | NO CHILD LEFT BEHIND CURRENT LAW IMPLEMENTATION - Regulations, guidance, waivers, and other implementation issues in diverse titles of the current Elementary and Secondary Education Act (ESEA) reauthorization and specific impacts on California preK-12 public school districts, including Title I funding fairness issues, funding flexiblity, consolidation of Title I schoolwide funds, while preserving school and district accountability, and meeting the academic achievement needs of all students * INDIVIDUALS WITH DISABILITIES EDUCATION IMPROVEMENT ACT (IDEA) IMPLEMENTATION AND PREPARATION Regulations, guidance, and other implementation issues of the latest reauthorized federal special education law, to improve services and results for children with disabilities in preK-12 grades of local public schools and districts, including specific California impact, to identify inconsistencies in issues related to the education of children with disabilities, between IDEA and the Elementary and Secondary Education Act, and try to resolve them constructively * COMPREHENSIVE ELEMENTARY AND SECONDARY EDUCATION ACT REAUTHORIZATION PREPARATION Preparation of recommendations to retain, revise, improve, add or eliminate provisions in the upcoming reauthorization of the Elementary and Secondary Education Act, the principal federal statute that affects K-12 public education, with California impact, and to increase awareness of Long Beach (CA) Unified-Fresno Unified (CA) learning partnerships achievement improvement models, and desirability of greater federal flexibilities * TO PROVIDE CONTINUING AFFORDABLE ACCESS TO FEDERAL STUDENT LOANS AND FINANCIAL AID DURING TIMES OF FINANCIAL TURMOIL IN U.S. To ensure continuing availability of and access to, federal college student financial assistance for local public school students, especially those who aspire to attend college, are from low-income families or underrepresented groups, who may be the first in their families to chart such an academic course, and who are taking a course of st… | Agriculture, Dept of (USDA),Education, Dept of,Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2012-07-11T12:05:38.833000-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);