Data source: Big Local News · About: Big Local

1,461 rows where grade = "grade_5", state = "CT" and year = 2020 sorted by total 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
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
2766930 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_5                                                   94                                             94
2767092 CT     school 904320 1350011   Stamford School District 90432000865 1350911 Roxbury School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   94                                             94
2766258 CT     school 901020 340011   Danbury School District 90102000159 341411 Ellsworth Avenue School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   93                                             93
2766305 CT     school 901260 430011   East Hartford School District 90126000196 431011 Dr. Thomas S. O'Connell School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   93                                             93
2766763 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   93                                             93
2767098 CT     school 904320 1350011   Stamford School District 90432000866 1351111 Springdale School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   93                                             93
2766491 CT     school 901920 640011   Hartford School District 90192000636 643211 Expeditionary Learning Academy at Moylan School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   92                                             92
2766619 CT     school 902400 800011   Meriden School District 90240000450 800811 Roger Sherman School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   92                                             92
2766859 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   92                                             92
2766039 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2020   grade_5                                                   91                                             91
2766974 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2020   grade_5                                                   90                                             90
2767018 CT     school 903990 1240011   Seymour School District 90399001642 1240211 Chatfield-LoPresti School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   90                                             90
2767252 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   grade_5                                                   9                                             9
2766711 CT     school 902670 890011   New Britain School District 90267000513 890611 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   89                                             89
2766866 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   89                                             89
2766407 CT     school 901620 540011   Glastonbury School District 90162000280 540211 Buttonball Lane School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   88                                             88
2766430 CT     school 901710 570011   Greenwich School District 90171000304 570711 North Mianus School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   88                                             88
2767062 CT     school 904230 1310011   Southington School District 90423000829 1311511 Derynoski Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   88                                             88
2766275 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   87                                             87
2767050 CT     school 904170 1320011   South Windsor School District 90417000822 1320711 Eli Terry School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   87                                             87
2767177 CT     school 904620 1440011   Trumbull School District 90462000934 1440311 Middlebrook School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   87                                             87
2766067 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   86                                             86
2766112 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   86                                             86
2767019 CT     school 903990 1240011   Seymour School District 90399000790 1240111 Bungay School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   86                                             86
2767039 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2020   grade_5                                                   86                                             86
2767094 CT     school 904320 1350011   Stamford School District 90432000858 1351211 Julia A. Stark School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   86                                             86
2767244 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   86                                             86
2766040 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2020   grade_5                                                   85                                             85
2767174 CT     school 904620 1440011   Trumbull School District 90462000929 1440811 Daniels Farm School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   85                                             85
2766066 CT     school 900210 70011   Berlin School District 90021000018 70411 Emma Hart Willard School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   84                                             84
2766685 CT     school 902550 850011   Monroe School District 90255000491 850311 Stepney Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   84                                             84
2766813 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   84                                             84
2766864 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   84                                             84
2767090 CT     school 904320 1350011   Stamford School District 90432000859 1350511 K. T. Murphy School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   84                                             84
2767116 CT     school 904380 1370011   Stonington School District 90438000876 1370511 Deans Mill School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   84                                             84
2767128 CT     school 904440 1380011   Stratford School District 90444000898 1381311 Eli Whitney School Public Schools Regular School No Elementary KG 06 2020   grade_5                                                   84                                             84
2767234 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   84                                             84
2766181 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   83                                             83
2766346 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2020   grade_5                                                   83                                             83
2766409 CT     school 901620 540011   Glastonbury School District 90162000286 540611 Hopewell School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   83                                             83
2766856 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   83                                             83
2766966 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2020   grade_5                                                   83                                             83
2767155 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   83                                             83
2767410 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   83                                             83
2767229 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   82                                             82
2767348 CT     school 905040 1580011   Westport School District 90504001363 1580811 Saugatuck Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   82                                             82
2766623 CT     school 902400 800011   Meriden School District 90240000443 800411 Israel Putnam School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   81                                             81
2766716 CT     school 902670 890011   New Britain School District 90267000509 890311 Chamberlain Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   81                                             81
2767186 CT     school 904680 1460011   Vernon School District 90468000939 1461411 Center Road School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   81                                             81
2766117 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   80                                             80
2766549 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2020   grade_5                                                   80                                             80
2766794 CT     school 902790 930011   New Haven School District 90279000545 935511 Betsy Ross Arts Magnet School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   80                                             80
2766850 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
2766865 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
2767172 CT     school 904620 1440011   Trumbull School District 90462000927 1440111 Booth Hill School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
2767225 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   80                                             80
2767346 CT     school 905040 1580011   Westport School District 90504001055 1580511 King's Highway Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   80                                             80
2766477 CT     school   620011   Hamden School District   620911 Bear Path IIC Program           2020   grade_5                                                   8                                             8
2766576 CT     school 902160 720011   Ledyard School District 90216000398 720411 Gallup Hill School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   79                                             79
2767223 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   79                                             79
2766276 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   78                                             78
2766279 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   78                                             78
2766563 CT     school 903450 2450014   Learn 90345000079 2450114 Regional Multicultural Magnet School Regional Education Service Center Schools Regular School No Elementary KG 05 2020   grade_5                                                   78                                             78
2766809 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   78                                             78
2766935 CT     school 903480 1160011   Putnam School District 90348000718 1160311 Putnam Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   78                                             78
2766940 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2020   grade_5                                                   78                                             78
2767070 CT     school 904230 1310011   Southington School District 90423000840 1310911 Thalberg Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   78                                             78
2767347 CT     school 905040 1580011   Westport School District 90504001056 1580711 Long Lots School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   78                                             78
2766221 CT     school 900750 250011   Cheshire School District 90075000126 250611 Doolittle School Public Schools Regular School No Elementary 01 06 2020   grade_5                                                   77                                             77
2766387 CT     school 901530 510011   Fairfield School District 90153000267 511211 Riverfield School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   77                                             77
2766512 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2020   grade_5                                                   77                                             77
2766723 CT     school 902670 890011   New Britain School District 90267000527 891511 Vance Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   77                                             77
2767175 CT     school 904620 1440011   Trumbull School District 90462001469 1441011 Frenchtown Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   77                                             77
2767235 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2020   grade_5                                                   77                                             77
2767249 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   76                                             76
2767376 CT     school 905190 1630011   Windham School District 90519001214 1630311 North Windham School Public Schools Regular School No Elementary KG 05 2020   grade_5                                                   76                                             76
2766770 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_5                                                   75                                             75

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