About this Dataset

Education Directory

This dataset contains the official listing of all public educational organizations in Connecticut. Data elements include district name, school name, organization type, organization code, address, open date, interdistrict magnet status and grades offered.

Included data are collected by the CT State Department of Education (CSDE) through the Directory Manager (DM) portal in accordance with Connecticut General Statute (C.G.S.) 10-4. This critical information is used by other data collection systems and for state and federal reporting.

For more information regarding DM, please visit http://www.csde.state.ct.us/public/directorymanager/default.asp
Organization: State of Connecticut
Last updated: 2020-11-12T14:54:58.245471
Tags: csde, ct-schools, directory, district, education, school, schools, sde

Tables

Table 1

@usgov.state_of_connecticut_education_directory.table_1

143.65 kB
1,238 rows
25 columns

CREATE TABLE table_1 (
  "district_name" VARCHAR,
  "school_name" VARCHAR,
  "organization_type" VARCHAR,
  "organization_code" BIGINT,
  "address" VARCHAR,
  "town" VARCHAR,
  "zipcode" VARCHAR,
  "phone" VARCHAR,
  "prekindergarten" BIGINT,
  "kindergarten" BIGINT,
  "grade_1" BIGINT,
  "grade_2" BIGINT,
  "grade_3" BIGINT,
  "grade_4" BIGINT,
  "grade_5" BIGINT,
  "grade_6" BIGINT,
  "grade_7" BIGINT,
  "grade_8" BIGINT,
  "grade_9" BIGINT,
  "grade_10" BIGINT,
  "grade_11" BIGINT,
  "grade_12" BIGINT,
  "student_open_date" TIMESTAMP,
  "interdistrict_magnet" DOUBLE,
  "location" VARCHAR
);