enrollments

Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 20,454 ✖
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
2759536 2759536 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   kindergarten                                                   117                                             117
2759537 2759537 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   kindergarten                                                   0                                             0
2759538 2759538 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759539 2759539 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759540 2759540 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   kindergarten                                                   0                                             0
2760997 2760997 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_1                                                   110                                             110
2760998 2760998 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_1                                                   0                                             0
2760999 2760999 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2761000 2761000 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_1                                                   0                                             0
2761001 2761001 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_1                                                   0                                             0
2762458 2762458 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_2                                                   114                                             114
2762459 2762459 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_2                                                   0                                             0
2762460 2762460 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_2                                                   0                                             0
2762461 2762461 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_2                                                   0                                             0
2762462 2762462 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_2                                                   0                                             0
2763919 2763919 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_3                                                   0                                             0
2763920 2763920 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_3                                                   127                                             127
2763921 2763921 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2763922 2763922 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_3                                                   0                                             0
2763923 2763923 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_3                                                   0                                             0
2765380 2765380 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_4                                                   0                                             0
2765381 2765381 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_4                                                   119                                             119
2765382 2765382 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_4                                                   0                                             0
2765383 2765383 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_4                                                   0                                             0
2765384 2765384 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_4                                                   0                                             0
2766841 2766841 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_5                                                   0                                             0
2766842 2766842 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   151                                             151
2766843 2766843 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_5                                                   0                                             0
2766844 2766844 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766845 2766845 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_5                                                   0                                             0
2768302 2768302 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_6                                                   0                                             0
2768303 2768303 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_6                                                   0                                             0
2768304 2768304 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   132                                             132
2768305 2768305 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_6                                                   0                                             0
2768306 2768306 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_6                                                   0                                             0
2769763 2769763 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_7                                                   0                                             0
2769764 2769764 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_7                                                   0                                             0
2769765 2769765 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   125                                             125
2769766 2769766 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769767 2769767 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_7                                                   0                                             0
2771224 2771224 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_8                                                   0                                             0
2771225 2771225 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_8                                                   0                                             0
2771226 2771226 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   133                                             133
2771227 2771227 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_8                                                   0                                             0
2771228 2771228 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_8                                                   0                                             0
2772685 2772685 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_9                                                   0                                             0
2772686 2772686 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_9                                                   0                                             0
2772687 2772687 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_9                                                   0                                             0
2772688 2772688 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_9                                                   118                                             118
2772689 2772689 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_9                                                   0                                             0
2774146 2774146 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_10                                                   0                                             0
2774147 2774147 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_10                                                   0                                             0
2774148 2774148 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_10                                                   0                                             0
2774149 2774149 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_10                                                   128                                             128
2774150 2774150 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_10                                                   0                                             0
2775607 2775607 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_11                                                   0                                             0
2775608 2775608 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_11                                                   0                                             0
2775609 2775609 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775610 2775610 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_11                                                   145                                             145
2775611 2775611 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_11                                                   0                                             0
2777068 2777068 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_12                                                   0                                             0
2777069 2777069 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_12                                                   0                                             0
2777070 2777070 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777071 2777071 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_12                                                   133                                             133
2777072 2777072 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_12                                                   6                                             6
2778529 2778529 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   pk_12_total 326 * 31   0 7     0   *   187 188     7             38   375 326   31   0 7     0       187 188     7       38   375
2778530 2778530 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   pk_12_total 344 * 33   * 9     0   6   205 192     *             69   397 344   33     9     0   6   205 192             69   397
2778531 2778531 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   pk_12_total 335 12 29   * *     0   7   225 165     *             56   390 335 12 29           0   7   225 165             56   390
2778532 2778532 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   pk_12_total 458 12 39   0 9     0   6   239 285     *             84   524 458 12 39   0 9     0   6   239 285             84   524
2778533 2778533 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   pk_12_total * 0 *   0 0     0   0   * *     0             6   6   0     0 0     0   0           0       6   6
2759535 2759535 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   kindergarten                                                   *                                              
2760996 2760996 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_1                                                   9                                             9
2762457 2762457 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_2                                                   7                                             7
2763918 2763918 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_3                                                   11                                             11
2765379 2765379 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_4                                                   14                                             14
2766840 2766840 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_5                                                   10                                             10
2768301 2768301 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   12                                             12
2769762 2769762 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_7                                                   0                                             0
2771223 2771223 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_8                                                   0                                             0
2772684 2772684 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
2774145 2774145 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_10                                                   0                                             0
2775606 2775606 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_11                                                   0                                             0
2777067 2777067 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_12                                                   0                                             0
2778528 2778528 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 61 0 *   0 0     0   *   38 35     *             21   73 61 0     0 0     0       38 35             21   73
2759526 2759526 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2020   kindergarten                                                   0                                             0
2759527 2759527 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2020   kindergarten                                                   56                                             56
2759528 2759528 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2020   kindergarten                                                   53                                             53
2759529 2759529 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2020   kindergarten                                                   69                                             69
2759530 2759530 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2020   kindergarten                                                   68                                             68
2759531 2759531 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2020   kindergarten                                                   0                                             0
2759532 2759532 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   kindergarten                                                   0                                             0
2759533 2759533 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759534 2759534 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2020   kindergarten                                                   0                                             0
2760987 2760987 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2020   grade_1                                                   0                                             0
2760988 2760988 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   60                                             60
2760989 2760989 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   70                                             70
2760990 2760990 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   62                                             62
2760991 2760991 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   67                                             67
2760992 2760992 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_1                                                   0                                             0
2760993 2760993 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   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]);