Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by district_state_id

View and edit SQL

grade

year

Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2436577 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   47                                             47
2436578 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   60                                             60
2436579 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2436580 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436581 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_2                                                   0                                             0
2438024 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   51                                             51
2438025 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   52                                             52
2438026 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   39                                             39
2438027 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   66                                             66
2438028 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_3                                                   0                                             0
2438029 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_3                                                   0                                             0
2438030 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_3                                                   0                                             0
2439473 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   *                                              
2439474 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   61                                             61
2439475 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   *                                              
2439476 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   79                                             79
2439477 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_4                                                   0                                             0
2439478 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_4                                                   0                                             0
2439479 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_4                                                   0                                             0
2440922 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   52                                             52
2440923 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   49                                             49
2440924 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   55                                             55
2440925 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   69                                             69
2440926 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_5                                                   0                                             0
2440927 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_5                                                   0                                             0
2440928 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_5                                                   0                                             0
2442371 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442372 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442373 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442374 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442375 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_6                                                   262                                             262
2442376 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_6                                                   0                                             0
2442377 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_6                                                   0                                             0
2443820 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443821 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443822 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443823 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443824 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   233                                             233
2443825 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443826 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_7                                                   0                                             0
2445269 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445270 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445271 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445272 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445273 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   236                                             236
2445274 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2445275 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_8                                                   0                                             0
2446718 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446719 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446720 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446721 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446722 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446723 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_9                                                   278                                             278
2446724 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_9                                                   0                                             0
2448167 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2448168 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2448169 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2448170 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2448171 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_10                                                   0                                             0
2448172 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_10                                                   242                                             242
2448173 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_10                                                   0                                             0
2449616 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449617 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449618 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449619 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449620 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2449621 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_11                                                   260                                             260
2449622 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_11                                                   0                                             0
2451065 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451066 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451067 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451068 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451069 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_12                                                   0                                             0
2451070 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_12                                                   254                                             254
2451071 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_12                                                   8                                             8
2452514 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 275 13 28   * 11     0   *   174 160     8             18   334 275 13 28     11     0       174 160     8       18   334
2452515 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 272 19 31   0 43     0   15   184 196     31             53   380 272 19 31   0 43     0   15   184 196     31       53   380
2452516 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 208 * 28   * 19     0   6   142 124     11             28   266 208   28     19     0   6   142 124     11       28   266
2452517 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 297 18 36   0 26     *   *   193 195     12             41   388 297 18 36   0 26             193 195     12       41   388
2452518 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 570 25 61   * 55     0   *   380 351     10             94   731 570 25 61     55     0       380 351     10       94   731
2452519 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 827 38 73   * 64     *   29   528 506     11             117   1034 827 38 73     64         29   528 506     11       117   1034
2452520 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   pk_12_total * 0 *   0 *     0   0   * *     0             8   8   0     0       0   0           0       8   8
2739319 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   44                                             44
2739320 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   64                                             64
2739321 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   50                                             50
2739322 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   36                                             36
2739323 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739324 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739325 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2021   kindergarten                                                   0                                             0
2740763 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   60                                             60
2740764 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   71                                             71
2740765 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   52                                             52
2740766 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   56                                             56
2740767 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740768 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740769 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2021   grade_1                                                   0                                             0
2742207 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   49                                             49
2742208 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_2                                                   *                                              
2742209 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   58                                             58
2742210 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_2                                                   38                                             38

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);