enrollments

Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 20,216 ✖
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
2739313 2739313 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   kindergarten                                                   102                                             102
2739314 2739314 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   kindergarten                                                   0                                             0
2739315 2739315 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739316 2739316 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739317 2739317 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   kindergarten                                                   0                                             0
2740757 2740757 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_1                                                   124                                             124
2740758 2740758 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740759 2740759 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740760 2740760 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740761 2740761 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_1                                                   0                                             0
2742201 2742201 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_2                                                   105                                             105
2742202 2742202 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_2                                                   0                                             0
2742203 2742203 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_2                                                   0                                             0
2742204 2742204 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_2                                                   0                                             0
2742205 2742205 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_2                                                   0                                             0
2743645 2743645 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_3                                                   0                                             0
2743646 2743646 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_3                                                   110                                             110
2743647 2743647 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_3                                                   0                                             0
2743648 2743648 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_3                                                   0                                             0
2743649 2743649 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_3                                                   0                                             0
2745089 2745089 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_4                                                   0                                             0
2745090 2745090 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_4                                                   124                                             124
2745091 2745091 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_4                                                   0                                             0
2745092 2745092 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_4                                                   0                                             0
2745093 2745093 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_4                                                   0                                             0
2746533 2746533 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_5                                                   0                                             0
2746534 2746534 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   109                                             109
2746535 2746535 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_5                                                   0                                             0
2746536 2746536 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_5                                                   0                                             0
2746537 2746537 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_5                                                   0                                             0
2747977 2747977 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_6                                                   0                                             0
2747978 2747978 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_6                                                   0                                             0
2747979 2747979 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   145                                             145
2747980 2747980 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747981 2747981 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_6                                                   0                                             0
2749421 2749421 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_7                                                   0                                             0
2749422 2749422 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_7                                                   0                                             0
2749423 2749423 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   130                                             130
2749424 2749424 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_7                                                   0                                             0
2749425 2749425 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_7                                                   0                                             0
2750865 2750865 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_8                                                   0                                             0
2750866 2750866 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_8                                                   0                                             0
2750867 2750867 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   123                                             123
2750868 2750868 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_8                                                   0                                             0
2750869 2750869 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_8                                                   0                                             0
2752309 2752309 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_9                                                   0                                             0
2752310 2752310 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_9                                                   0                                             0
2752311 2752311 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2752312 2752312 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_9                                                   100                                             100
2752313 2752313 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_9                                                   0                                             0
2753753 2753753 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_10                                                   0                                             0
2753754 2753754 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_10                                                   0                                             0
2753755 2753755 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
2753756 2753756 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_10                                                   122                                             122
2753757 2753757 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_10                                                   0                                             0
2755197 2755197 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_11                                                   0                                             0
2755198 2755198 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_11                                                   0                                             0
2755199 2755199 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_11                                                   0                                             0
2755200 2755200 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_11                                                   127                                             127
2755201 2755201 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_11                                                   0                                             0
2756641 2756641 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_12                                                   0                                             0
2756642 2756642 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_12                                                   0                                             0
2756643 2756643 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756644 2756644 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_12                                                   143                                             143
2756645 2756645 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_12                                                   6                                             6
2758085 2758085 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   pk_12_total 314 * 33   0 *     0   14   * 195     6             37   368 314   33   0       0   14     195     6       37   368
2758086 2758086 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   pk_12_total 303 0 27   0 *     0   *   169 174     7             50   343 303 0 27   0       0       169 174     7       50   343
2758087 2758087 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   pk_12_total 336 * 38   * 7     0   9   228 170     *             59   398 336   38     7     0   9   228 170             59   398
2758088 2758088 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   pk_12_total 424 14 38   0 9     0   7   232 260     *             79   492 424 14 38   0 9     0   7   232 260             79   492
2758089 2758089 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   pk_12_total 6 0 0   0 0     0   0   * *     0             6   6 6 0 0   0 0     0   0           0       6   6
2739312 2739312 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   kindergarten                                                   *                                              
2740756 2740756 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_1                                                   *                                              
2742200 2742200 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_2                                                   11                                             11
2743644 2743644 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_3                                                   8                                             8
2745088 2745088 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_4                                                   13                                             13
2746532 2746532 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_5                                                   15                                             15
2747976 2747976 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   12                                             12
2749420 2749420 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2750864 2750864 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_8                                                   0                                             0
2752308 2752308 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_9                                                   0                                             0
2753752 2753752 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
2755196 2755196 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_11                                                   0                                             0
2756640 2756640 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_12                                                   0                                             0
2758084 2758084 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 68 0 *   0 0     0   *   42 38     *             18   80 68 0     0 0     0       42 38             18   80
2739301 2739301 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2021   kindergarten                                                   0                                             0
2739302 2739302 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2021   kindergarten                                                   48                                             48
2739303 2739303 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2021   kindergarten                                                   56                                             56
2739304 2739304 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2021   kindergarten                                                   76                                             76
2739305 2739305 CT     school   970011   Newtown School District   970811 Program for Adaptive Learning Program           2021   kindergarten                                                   *                                              
2739306 2739306 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2021   kindergarten                                                   67                                             67
2739307 2739307 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   kindergarten                                                   0                                             0
2739308 2739308 CT     school   970011   Newtown School District   970711 Reaching Independence through Structured Education Program           2021   kindergarten                                                   0                                             0
2739309 2739309 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2021   kindergarten                                                   0                                             0
2739310 2739310 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739311 2739311 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2021   kindergarten                                                   0                                             0
2740745 2740745 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2021   grade_1                                                   0                                             0
2740746 2740746 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   57                                             57
2740747 2740747 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   48                                             48
2740748 2740748 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   72                                             72
2740749 2740749 CT     school   970011   Newtown School District   970811 Program for Adaptive Learning Program           2021   grade_1                                                   0                                             0

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]);