version: 2
sources:
- name: chicago_public_schools
  description: Chicago Public Schools discovered from data.cityofchicago.org.
  meta:
    opendataodc:
      dataset_id: chicago-public-schools
      revision_id: 20260907135241-8f73b43484f6
      detected_at: '2026-09-07T13:52:41+00:00'
      source_url: https://data.cityofchicago.org/api/views/9xs2-f89t/rows.csv?accessType=DOWNLOAD
  tables:
  - name: chicago_public_schools_progress_report_cards_2011_2012_csv
    description: Source asset Chicago_Public_Schools_-_Progress_Report_Cards__2011-2012_.csv.
    meta:
      opendataodc:
        source_url: https://data.cityofchicago.org/api/views/9xs2-f89t/rows.csv?accessType=DOWNLOAD
        content_hash: 75d8ac035ab600819217faf7fe86f47f14edf886a4fbdce7c3725edfb106284e
        row_count: 566
        parser_errors: []
    columns:
    - name: School ID
    - name: Name of School
    - name: Elementary, Middle, or High School
    - name: Street Address
    - name: City
    - name: State
    - name: ZIP Code
    - name: Phone Number
    - name: Link
    - name: Network Manager
    - name: Collaborative Name
    - name: Adequate Yearly Progress Made?
    - name: Track Schedule
    - name: CPS Performance Policy Status
    - name: CPS Performance Policy Level
    - name: Healthy Schools Certified?
    - name: Safety Icon
    - name: Safety Score
    - name: Family Involvement Icon
    - name: Family Involvement Score
    - name: Environment Icon
    - name: Environment Score
    - name: Instruction Icon
    - name: Instruction Score
    - name: Leaders Icon
    - name: Leaders Score
    - name: Teachers Icon
    - name: Teachers Score
    - name: Parent Engagement Icon
    - name: Parent Engagement Score
    - name: Parent Environment Icon
    - name: Parent Environment Score
    - name: Average Student Attendance
    - name: Rate of Misconducts (per 100 students)
    - name: Average Teacher Attendance
    - name: Individualized Education Program Compliance Rate
    - name: Pk-2 Literacy %
    - name: Pk-2 Math %
    - name: Gr3-5 Grade Level Math %
    - name: Gr3-5 Grade Level Read %
    - name: Gr3-5 Keep Pace Read %
    - name: Gr3-5 Keep Pace Math %
    - name: Gr6-8 Grade Level Math %
    - name: Gr6-8 Grade Level Read %
    - name: Gr6-8 Keep Pace Math%
    - name: Gr6-8 Keep Pace Read %
    - name: Gr-8 Explore Math %
    - name: Gr-8 Explore Read %
    - name: ISAT Exceeding Math %
    - name: ISAT Exceeding Reading %
    - name: ISAT Value Add Math
    - name: ISAT Value Add Read
    - name: ISAT Value Add Color Math
    - name: ISAT Value Add Color Read
    - name: Students Taking  Algebra %
    - name: Students Passing  Algebra %
    - name: 9th Grade EXPLORE (2009)
    - name: 9th Grade EXPLORE (2010)
    - name: 10th Grade PLAN (2009)
    - name: 10th Grade PLAN (2010)
    - name: Net Change EXPLORE and PLAN
    - name: 11th Grade Average ACT (2011)
    - name: Net Change PLAN and ACT
    - name: College Eligibility %
    - name: Graduation Rate %
    - name: College Enrollment Rate %
    - name: College Enrollment (number of students)
    - name: General Services Route
    - name: Freshman on Track Rate %
    - name: RCDTS Code
    - name: X_COORDINATE
    - name: Y_COORDINATE
    - name: Latitude
    - name: Longitude
    - name: Community Area Number
    - name: Community Area Name
    - name: Ward
    - name: Police District
    - name: Location