Connecticut: Education Directory

Source

data.ct.gov

Quality score: 100/100.

Initial recorded revision.

Dataset refresh metadata

Current Source Files

• Education_Directory.csv 20260926191926-e099101390bb Provider source

Contract Versions

• 20260926191926-e099101390bb Copy YAML link

Current Open Data Contract YAML

Open raw YAML

dataset_id: ct-education-directory
title: 'Connecticut: Education Directory'
description: 'Connecticut: Education Directory discovered from data.ct.gov.'
source_name: data.ct.gov
source_url: https://data.ct.gov/api/views/9k2y-kqxn/rows.csv?accessType=DOWNLOAD
update_frequency: adhoc
next_scan_at: '2026-09-29T02:00:00+00:00'
license:
  name: Public Domain
  url: https://data.ct.gov/Education/Education-Directory/9k2y-kqxn
tags:
- data.ct.gov
- education
geography:
- Connecticut
revisions:
- revision_id: 20260926191926-e099101390bb
  detected_at: '2026-09-26T19:19:26+00:00'
  source_updated_at: Thu, 02 Apr 2026 12:57:12 GMT
  context: Education_Directory.csv detected from rows.csv.
  assets:
  - asset_id: asset-e3e8f4b3c3817b42
    name: Education_Directory.csv
    source_url: https://data.ct.gov/api/views/9k2y-kqxn/rows.csv?accessType=DOWNLOAD
    media_type: text/csv; charset=utf-8
    content_hash: e3e8f4b3c3817b4241765b1df34dc3c078ef2bb75c2c88d4a719c1eeca6fd1ac
    size_bytes: 303370
    parent_archive_id: null
  row_count: 1232
  headers:
  - District Name
  - School Name
  - Organization Type
  - Organization Code
  - Address
  - Town
  - Zipcode
  - Phone
  - PreKindergarten
  - Kindergarten
  - Grade 1
  - Grade 2
  - Grade 3
  - Grade 4
  - Grade 5
  - Grade 6
  - Grade 7
  - Grade 8
  - Grade 9
  - Grade 10
  - Grade 11
  - Grade 12
  - Student Open Date
  - Interdistrict Magnet
  - Location
  sample_rows:
  - District Name: Clinton School District
    School Name: Lewin G. Joel Jr. School
    Organization Type: Public Schools
    Organization Code: '0270311'
    Address: 137A Glenwood Rd.
    Town: Clinton
    Zipcode: 06413-1425
    Phone: 860-664-6501
    PreKindergarten: '1'
    Kindergarten: '1'
    Grade 1: '1'
    Grade 2: '1'
    Grade 3: '1'
    Grade 4: '1'
    Grade 5: '0'
    Grade 6: '0'
    Grade 7: '0'
    Grade 8: '0'
    Grade 9: '0'
    Grade 10: '0'
    Grade 11: '0'
    Grade 12: '0'
    Student Open Date: '1984-07-01T00:00:00.000'
    Interdistrict Magnet: '0'
    Location: ''
  - District Name: Capitol Region Education Council
    School Name: Reggio Magnet School of the Arts
    Organization Type: Regional Education Service Center Schools
    Organization Code: '2410314'
    Address: 59 Waterville Road
    Town: Avon
    Zipcode: '06001'
    Phone: 860-674-8549
    PreKindergarten: '1'
    Kindergarten: '1'
    Grade 1: '1'
    Grade 2: '1'
    Grade 3: '1'
    Grade 4: '1'
    Grade 5: '1'
    Grade 6: '0'
    Grade 7: '0'
    Grade 8: '0'
    Grade 9: '0'
    Grade 10: '0'
    Grade 11: '0'
    Grade 12: '0'
    Student Open Date: '2008-09-02T00:00:00.000'
    Interdistrict Magnet: '1'
    Location: '59 Waterville Road

      Avon, CT 06001

      (41.80047, -72.82035)'
  - District Name: Norwich School District
    School Name: Kelly STEAM Magnet Middle School
    Organization Type: Public Schools
    Organization Code: '1045111'
    Address: 25 Mahan Dr.
    Town: Norwich
    Zipcode: 06360-2425
    Phone: 860-823-4211
    PreKindergarten: '0'
    Kindergarten: '0'
    Grade 1: '0'
    Grade 2: '0'
    Grade 3: '0'
    Grade 4: '0'
    Grade 5: '0'
    Grade 6: '1'
    Grade 7: '1'
    Grade 8: '1'
    Grade 9: '0'
    Grade 10: '0'
    Grade 11: '0'
    Grade 12: '0'
    Student Open Date: '1984-07-01T00:00:00.000'
    Interdistrict Magnet: '0'
    Location: '25 Mahan Dr.

      Norwich, CT 06360-2425

      (41.54687, -72.07769)'
  - District Name: Waterbury School District
    School Name: Washington School
    Organization Type: Public Schools
    Organization Code: '1512311'
    Address: 685 Baldwin St.
    Town: Waterbury
    Zipcode: 06706-1507
    Phone: 203-574-8177
    PreKindergarten: '1'
    Kindergarten: '1'
    Grade 1: '1'
    Grade 2: '1'
    Grade 3: '1'
    Grade 4: '1'
    Grade 5: '1'
    Grade 6: '0'
    Grade 7: '0'
    Grade 8: '0'
    Grade 9: '0'
    Grade 10: '0'
    Grade 11: '0'
    Grade 12: '0'
    Student Open Date: '1984-07-01T00:00:00.000'
    Interdistrict Magnet: '0'
    Location: '685 Baldwin St.

      Waterbury, CT 06706-1507

      (41.54326, -73.03402)'
  - District Name: Bridgeport School District
    School Name: Jettie S. Tisdale School
    Organization Type: Public Schools
    Organization Code: '0152211'
    Address: 250 Hollister Avenue
    Town: Bridgeport
    Zipcode: '06607'
    Phone: 203-576-8037
    PreKindergarten: '1'
    Kindergarten: '1'
    Grade 1: '1'
    Grade 2: '1'
    Grade 3: '1'
    Grade 4: '1'
    Grade 5: '1'
    Grade 6: '1'
    Grade 7: '1'
    Grade 8: '1'
    Grade 9: '0'
    Grade 10: '0'
    Grade 11: '0'
    Grade 12: '0'
    Student Open Date: '1984-07-01T00:00:00.000'
    Interdistrict Magnet: '0'
    Location: '250 Hollister Avenue

      Bridgeport, CT 06607

      (41.17805, -73.16069)'
  parser_errors: []
  logical_asset_id: 0f50aa0ee8ecf4e1e6874a44
related_dataset_ids: []
quality:
  score: 100
  parsing_errors: []
  stale_warning: null
  broken_source_report: null
rss_feed_url: null
odc_version: '0.1'
last_successful_scan_at: '2026-09-26T19:19:26+00:00'

Current dbt Source YAML

Open raw YAML

version: 2
sources:
- name: ct_education_directory
  description: 'Connecticut: Education Directory discovered from data.ct.gov.'
  meta:
    opendataodc:
      dataset_id: ct-education-directory
      revision_id: 20260926191926-e099101390bb
      detected_at: '2026-09-26T19:19:26+00:00'
      source_url: https://data.ct.gov/api/views/9k2y-kqxn/rows.csv?accessType=DOWNLOAD
  tables:
  - name: education_directory_csv
    description: Source asset Education_Directory.csv.
    meta:
      opendataodc:
        source_url: https://data.ct.gov/api/views/9k2y-kqxn/rows.csv?accessType=DOWNLOAD
        content_hash: e3e8f4b3c3817b4241765b1df34dc3c078ef2bb75c2c88d4a719c1eeca6fd1ac
        row_count: 1232
        parser_errors: []
    columns:
    - name: District Name
    - name: School Name
    - name: Organization Type
    - name: Organization Code
    - name: Address
    - name: Town
    - name: Zipcode
    - name: Phone
    - name: PreKindergarten
    - name: Kindergarten
    - name: Grade 1
    - name: Grade 2
    - name: Grade 3
    - name: Grade 4
    - name: Grade 5
    - name: Grade 6
    - name: Grade 7
    - name: Grade 8
    - name: Grade 9
    - name: Grade 10
    - name: Grade 11
    - name: Grade 12
    - name: Student Open Date
    - name: Interdistrict Magnet
    - name: Location

Sample Rows

Education_Directory.csv

1232 parsed rows. 20260926191926-e099101390bb