Data source: Big Local News · About: Big Local

1,461 rows where grade = "grade_5", state = "CT" and year = 2020 sorted by total_int descending

View and edit SQL

year

  • 2020 · 1,461

grade

  • grade_5 · 1,461
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2766743 CT     school 902730 910011   New Fairfield School District 90273001195 910211 Meeting House Hill School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   138                                             138
2767395 CT     school 905220 1640011   Windsor School District 90522001089 1640811 John F. Kennedy School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   138                                             138
2766439 CT     school 901740 580011   Griswold School District 90174000019 585111 Griswold Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   133                                             133
2766906 CT     school 903240 1080011   Oxford School District 90324000691 1080111 Oxford Center School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   130                                             130
2767408 CT     school 905310 1670011   Woodbridge School District 90531001611 1670311 Beecher Road School Public Schools Regular School No Elementary PK 06 2020   grade_5                                                   128                                             128
2766365 CT     school 901470 490011   Enfield School District 90147000241 491311 Edgar H. Parkman School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   127                                             127
2766084 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   123                                             123
2767084 CT     school 904290 1340011   Stafford School District 90429001503 1340611 Stafford Elementary School Public Schools Regular School No Elementary 02 05 2020   grade_5                                                   123                                             123
2766613 CT     school 902340 780011   Mansfield School District 90234000433 785111 Mansfield Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   122                                             122
2766185 CT     school 900690 230011   Canton School District 90069000119 230311 Canton Intermediate School Public Schools Regular School No Middle 04 06 2020   grade_5                                                   121                                             121
2766361 CT     school 901470 490011   Enfield School District 90147000242 491611 Eli Whitney School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   121                                             121
2766247 CT     school 900960 320011   Coventry School District 90096000144 320411 George Hersey Robertson School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   120                                             120
2767228 CT     school 904830 1510011   Waterbury School District 90483000977 1510711 H. S. Chase School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   119                                             119
2766118 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   117                                             117
2767099 CT     school 904320 1350011   Stamford School District 90432000868 1352111 Stillmeadow School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   117                                             117
2767102 CT     school 904320 1350011   Stamford School District 90432000008 1351911 Toquam Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   117                                             117
2767207 CT     school 904740 1480011   Wallingford School District 90474000959 1481211 Pond Hill School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   115                                             115
2767103 CT     school 904320 1350011   Stamford School District 90432000872 1351411 Westover School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   114                                             114
2766216 CT     school 900750 250011   Cheshire School District 90075000127 250411 Highland School Public Schools Regular School No Elementary KG 06 2020   grade_5                                                   113                                             113
2766228 CT     school 900810 270011   Clinton School District 90081000133 275111 Jared Eliot School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   113                                             113
2767096 CT     school 904320 1350011   Stamford School District 90432000861 1351811 Northeast School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   113                                             113
2766621 CT     school 902400 800011   Meriden School District 90240000448 800711 Nathan Hale School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   111                                             111
2767089 CT     school 904320 1350011   Stamford School District 90432000852 1352011 Davenport Ridge School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   111                                             111
2767093 CT     school 904320 1350011   Stamford School District 90432000167 1352211 Hart School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   110                                             110
2767205 CT     school 904740 1480011   Wallingford School District 90474000536 1480811 Mary G. Fritz Elementary School of Yalesville Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   110                                             110
2766106 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   109                                             109
2766720 CT     school 902670 890011   New Britain School District 90267000523 891211 Smalley Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   108                                             108
2766957 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2020   grade_5                                                   108                                             108
2766622 CT     school 902400 800011   Meriden School District 90240000440 801111 Casimir Pulaski School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   107                                             107
2766718 CT     school 902670 890011   New Britain School District 90267000515 890811 Lincoln Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   107                                             107
2766262 CT     school 901020 340011   Danbury School District 90102000157 340811 Park Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   106                                             106
2767290 CT     school 904890 1530011   Watertown School District 90489001003 1530311 Fletcher W. Judson School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   106                                             106
2767412 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_5                                                   106                                             106
2766899 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   105                                             105
2767221 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   104                                             104
2767387 CT     school 905250 1650011   Windsor Locks School District 90525001098 1650411 South Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   104                                             104
2766154 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2020   grade_5                                                   103                                             103
2766617 CT     school 902400 800011   Meriden School District 90240000445 800511 John Barry School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   101                                             101
2767047 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   101                                             101
2767206 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   101                                             101
2767291 CT     school 904890 1530011   Watertown School District 90489001005 1530411 Polk School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   100                                             100
2766143 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   99                                             99
2766264 CT     school 901020 340011   Danbury School District 90102000161 341211 Shelter Rock School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   98                                             98
2766337 CT     school 901410 460011   Easton School District 90141000234 460111 Samuel Staples Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   98                                             98
2766578 CT     school 902160 720011   Ledyard School District 90216000399 720311 Juliet W. Long School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   98                                             98
2767411 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_5                                                   98                                             98
2766858 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   97                                             97
2767053 CT     school 904170 1320011   South Windsor School District 90417000824 1320611 Orchard Hill School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   97                                             97
2767208 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   97                                             97
2767394 CT     school 905220 1640011   Windsor School District 90522001087 1640111 Clover Street School Public Schools Regular School No Elementary 03 05 2020   grade_5                                                   97                                             97
2767413 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_5                                                   97                                             97
2767431 CT     school 900033 2830013   Park City Prep Charter School District 90003301449 2835113 Park City Prep Charter School Public Charter Schools Regular School Yes Middle 05 08 2020   grade_5                                                   97                                             97
2766411 CT     school 901620 540011   Glastonbury School District 90162001447 540911 Nayaug Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   96                                             96
2766812 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   96                                             96
2767232 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   96                                             96
2766721 CT     school 902670 890011   New Britain School District 90267000524 891311 Smith Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   95                                             95
2767054 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   95                                             95
2767095 CT     school 904320 1350011   Stamford School District 90432000860 1350611 Newfield School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   95                                             95
2767097 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2020   grade_5                                                   95                                             95
2766121 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   94                                             94
2766266 CT     school 901020 340011   Danbury School District 90102000163 341611 Stadley Rough School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   94                                             94
2766616 CT     school 902400 800011   Meriden School District 90240000442 800311 Hanover School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   94                                             94
2766684 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   94                                             94
2766717 CT     school 902670 890011   New Britain School District 90267000510 891111 DiLoreto Elementary & Middle School Public Schools Regular School No Elementary KG 08 2020   grade_5                                                   94                                             94

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