Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_5" and state = "CT" sorted by total_int descending

View and edit SQL

year

grade

  • grade_5 · 4,354
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 ▲
2766602 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2020   grade_5                                                   482                                             482
2440677 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2019   grade_5                                                   473                                             473
2441397 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   460                                             460
2747011 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_5                                                   444                                             444
2746291 CT     school 902310 770011   Manchester School District 90231001533 771711 Elisabeth M. Bennet Academy Public Schools Regular School No Middle 05 06 2021   grade_5                                                   435                                             435
2767328 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   386                                             386
2767033 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   371                                             371
2441103 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   348                                             348
2746722 CT     school 904050 1260011   Shelton School District 90405001584 1261111 Perry Hill Elementary School Public Schools Regular School No Middle 05 06 2021   grade_5                                                   334                                             334
2766739 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   329                                             329
2746429 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2021   grade_5                                                   321                                             321
2767366 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   313                                             313
2440813 CT     school 902700 900011   New Canaan School District 90270000532 905111 Saxe Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   297                                             297
2746527 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_5                                                   291                                             291
2440895 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   288                                             288
2440911 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   285                                             285
2441436 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   285                                             285
2747049 CT     school 905130 1610011   Wilton School District 90513001071 1610711 Cider Mill School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   278                                             278
2766836 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   276                                             276
2766820 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   266                                             266
2766060 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   265                                             265
2746510 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   258                                             258
2440143 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 04 05 2019   grade_5                                                   256                                             256
2766458 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   246                                             246
2440128 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   242                                             242
2745749 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2021   grade_5                                                   240                                             240
2746700 CT     school 903840 1190011   Rocky Hill School District 90384001936 1190611 Moser School Public Schools Regular School No Elementary 04 05 2021   grade_5                                                   238                                             238
2745764 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   234                                             234
2766075 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 04 05 2020   grade_5                                                   233                                             233
2767010 CT     school 903840 1190011   Rocky Hill School District 90384001936 1190611 Moser School Public Schools Regular School No Elementary 04 05 2020   grade_5                                                   232                                             232
2746151 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2021   grade_5                                                   227                                             227
2440524 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   223                                             223
2745955 CT     school 901020 340011   Danbury School District 90102001166 341711 King Street Intermediate School Public Schools Regular School No Elementary 04 05 2021   grade_5                                                   209                                             209
2440392 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   202                                             202
2440165 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   201                                             201
2767158 CT     school 904560 1420011   Tolland School District 90456000913 1420211 Tolland Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   200                                             200
2745785 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2021   grade_5                                                   194                                             194
2440663 CT     school 902280 760011   Madison School District 90228001382 760611 Dr. Robert H. Brown Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   193                                             193
2440333 CT     school 901020 340011   Danbury School District 90102001166 341711 King Street Intermediate School Public Schools Regular School No Elementary 04 05 2019   grade_5                                                   191                                             191
2441239 CT     school 904590 1430011   Torrington School District 90459000917 1430211 Forbes School Public Schools Regular School No Elementary 04 05 2019   grade_5                                                   191                                             191
2766097 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   190                                             190
2766268 CT     school 901020 340011   Danbury School District 90102001166 341711 King Street Intermediate School Public Schools Regular School No Elementary 04 05 2020   grade_5                                                   186                                             186
2441022 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2019   grade_5                                                   185                                             185
2440243 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   184                                             184
2441230 CT     school 904560 1420011   Tolland School District 90456000913 1420211 Tolland Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   184                                             184
2745866 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2021   grade_5                                                   184                                             184
2441407 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   180                                             180
2766178 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   177                                             177
2766328 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   177                                             177
2766590 CT     school 902280 760011   Madison School District 90228001382 760611 Dr. Robert H. Brown Intermediate School Public Schools Regular School No Elementary 04 05 2020   grade_5                                                   174                                             174
2747021 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   171                                             171
2440297 CT     school 900840 280011   Colchester School District 90084000137 280211 Jack Jackter Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   170                                             170
2746433 CT     school 902730 910011   New Fairfield School District 90273001195 910211 Meeting House Hill School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   169                                             169
2767338 CT     school 905010 1570011   Weston School District 90501001428 1570211 Weston Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   169                                             169
2766252 CT     school 900990 330011   Cromwell School District 90099001432 330311 Woodside Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   168                                             168
2440780 CT     school 902640 880011   Naugatuck School District 90264000504 880411 Hillside Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   167                                             167
2440985 CT     school 903270 1090011   Plainfield School District 90327000696 1090311 Plainfield Memorial School Public Schools Regular School No Elementary 04 05 2019   grade_5                                                   167                                             167
2746393 CT     school 902640 880011   Naugatuck School District 90264000504 880411 Hillside Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_5                                                   167                                             167
2440626 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   165                                             165
2746639 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2021   grade_5                                                   164                                             164
2767167 CT     school 904590 1430011   Torrington School District 90459000917 1430211 Forbes School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   164                                             164
2746015 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2021   grade_5                                                   162                                             162
2440817 CT     school 902730 910011   New Fairfield School District 90273001195 910211 Meeting House Hill School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   161                                             161
2746279 CT     school 902280 760011   Madison School District 90228001382 760611 Dr. Robert H. Brown Intermediate School Public Schools Regular School No Elementary 04 05 2021   grade_5                                                   161                                             161
2766705 CT     school 902640 880011   Naugatuck School District 90264000504 880411 Hillside Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   161                                             161
2440903 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   160                                             160
2766231 CT     school 900840 280011   Colchester School District 90084000137 280211 Jack Jackter Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   160                                             160
2766704 CT     school 902640 880011   Naugatuck School District 90264000502 880211 Cross Street Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   160                                             160
2441056 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 05 08 2019   grade_5                                                   159                                             159
2766418 CT     school 901680 560011   Granby School District 90168000293 560311 Wells Road Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   158                                             158
2766828 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   158                                             158
2745984 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2021   grade_5                                                   157                                             157
2746249 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 09 2021   grade_5                                                   157                                             157
2440779 CT     school 902640 880011   Naugatuck School District 90264000502 880211 Cross Street Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   155                                             155
2440904 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   155                                             155
2767168 CT     school 904590 1430011   Torrington School District 90459000922 1430811 Southwest School Public Schools Regular School No Elementary 04 05 2020   grade_5                                                   155                                             155
2766948 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2020   grade_5                                                   154                                             154
2440505 CT     school 901740 580011   Griswold School District 90174000019 585111 Griswold Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   152                                             152
2766557 CT     school 902070 690011   Killingly School District 90207000393 695211 Killingly Intermediate School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   152                                             152
2745939 CT     school 900990 330011   Cromwell School District 90099001432 330311 Woodside Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   151                                             151
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
2746605 CT     school 903270 1090011   Plainfield School District 90327000696 1090311 Plainfield Memorial School Public Schools Regular School No Elementary 04 05 2021   grade_5                                                   150                                             150
2766108 CT     school 900450 150011   Bridgeport School District 90045000070 151411 Cesar Batalla School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   149                                             149
2766914 CT     school 903270 1090011   Plainfield School District 90327000696 1090311 Plainfield Memorial School Public Schools Regular School No Elementary 04 05 2020   grade_5                                                   149                                             149
2746847 CT     school 904560 1420011   Tolland School District 90456000913 1420211 Tolland Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   147                                             147
2441240 CT     school 904590 1430011   Torrington School District 90459000922 1430811 Southwest School Public Schools Regular School No Elementary 04 05 2019   grade_5                                                   146                                             146
2440317 CT     school 900990 330011   Cromwell School District 90099001432 330311 Woodside Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   145                                             145
2746519 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2021   grade_5                                                   145                                             145
2766367 CT     school 901470 490011   Enfield School District 90147000254 491511 Prudence Crandall School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   145                                             145
2767147 CT     school 904470 1390011   Suffield School District 90447001394 1390311 McAlister Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   145                                             145
2440361 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2019   grade_5                                                   144                                             144
2745917 CT     school 900840 280011   Colchester School District 90084000137 280211 Jack Jackter Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_5                                                   144                                             144
2440312 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   142                                             142
2766829 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   142                                             142
2746857 CT     school 904590 1430011   Torrington School District 90459000922 1430811 Southwest School Public Schools Regular School No Elementary 04 05 2021   grade_5                                                   141                                             141
2766981 CT     school 903539 2170012   Regional School District 17 90353901921 2170512 Haddam-Killingworth Intermediate School Regional Schools Regular School No Elementary 04 05 2020   grade_5                                                   141                                             141
2440293 CT     school 900810 270011   Clinton School District 90081000131 270111 Abraham Pierson School   Regular School No Elementary 04 05 2019   grade_5                                                   140                                             140
2746392 CT     school 902640 880011   Naugatuck School District 90264000502 880211 Cross Street Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_5                                                   140                                             140
2441219 CT     school 904470 1390011   Suffield School District 90447001394 1390311 McAlister Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   138                                             138
2766297 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2020   grade_5                                                   138                                             138

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