Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_6" and state = "CT" sorted by total descending

View and edit SQL

year

grade

  • grade_6 · 4,254
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
2767830 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2020   grade_6                                                   8                                             8
2442272 CT     school 902760 920011   New Hartford School District 90276000538 920311 Ann Antolini School Public Schools Regular School No Elementary 03 06 2019   grade_6                                                   79                                             79
2442649 CT     school 904440 1380011   Stratford School District 90444000898 1381311 Eli Whitney School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   79                                             79
2748260 CT     school 904440 1380011   Stratford School District 90444000898 1381311 Eli Whitney School Public Schools Regular School No Elementary KG 06 2021   grade_6                                                   79                                             79
2767579 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   79                                             79
2767807 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   79                                             79
2767993 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2020   grade_6                                                   79                                             79
2441633 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   78                                             78
2442297 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   78                                             78
2442676 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   78                                             78
2767582 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   78                                             78
2747313 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   77                                             77
2747894 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   77                                             77
2748075 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   77                                             77
2767808 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   77                                             77
2747351 CT     school 900750 250011   Cheshire School District 90075000126 250611 Doolittle School Public Schools Regular School No Elementary 01 06 2021   grade_6                                                   76                                             76
2748071 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   76                                             76
2767755 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2020   grade_6                                                   76                                             76
2768589 CT     school 904440 1380011   Stratford School District 90444000898 1381311 Eli Whitney School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   76                                             76
2442041 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2019   grade_6                                                   75                                             75
2442872 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   75                                             75
2747249 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   75                                             75
2747485 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2021   grade_6                                                   75                                             75
2767752 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   75                                             75
2768013 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2020   grade_6                                                   75                                             75
2768233 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   75                                             75
2441807 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2019   grade_6                                                   74                                             74
2748498 CT     school 905160 1620011   Winchester School District 90516001080 1625111 Pearson School Public Schools Regular School No Elementary 03 06 2021   grade_6                                                   74                                             74
2767578 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   74                                             74
2768220 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   74                                             74
2768360 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   74                                             74
2768815 CT     school 905070 1590011   Wethersfield School District 90507001064 1591111 Highcrest School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   74                                             74
2441734 CT     school 900750 250011   Cheshire School District 90075000129 250511 Norton School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   73                                             73
2442282 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   73                                             73
2442296 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   73                                             73
2442648 CT     school 904440 1380011   Stratford School District 90444000887 1380311 Chapel School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   72                                             72
2747906 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   72                                             72
2748482 CT     school 905070 1590011   Wethersfield School District 90507001064 1591111 Highcrest School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   72                                             72
2441804 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2019   grade_6                                                   71                                             71
2441864 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   71                                             71
2748173 CT     school 904110 1280011   Simsbury School District 90411000810 1280111 Central School Public Schools Regular School No Elementary KG 06 2021   grade_6                                                   71                                             71
2767794 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   71                                             71
2768587 CT     school 904440 1380011   Stratford School District 90444000887 1380311 Chapel School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   71                                             71
2441986 CT     school 901860 620011   Hamden School District 90186000348 621011 Spring Glen School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   70                                             70
2442008 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2019   grade_6                                                   70                                             70
2442099 CT     school 902160 720011   Ledyard School District 90216000399 720311 Juliet W. Long School Public Schools Regular School No Elementary 03 06 2019   grade_6                                                   70                                             70
2747630 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   70                                             70
2747707 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   70                                             70
2748481 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   70                                             70
2767954 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   70                                             70
2441714 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2019   grade_6                                                   7                                             7
2442286 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2019   grade_6                                                   7                                             7
2442706 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   7                                             7
2442777 CT     school   1510011   Waterbury School District 90483001418 1519111 Enlightenment School Program           2019   grade_6                                                   7                                             7
2747328 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2021   grade_6                                                   7                                             7
2748345 CT     school   1480011   Wallingford School District   1481311 Inspire Middle School Program           2021   grade_6                                                   7                                             7
2748388 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2021   grade_6                                                   7                                             7
2767866 CT     school 901590 530011   Franklin School District 90159000278 530111 Franklin Elementary School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   7                                             7
2768713 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   grade_6                                                   7                                             7
2747747 CT     school 902370 790011   Marlborough School District 90237000437 790111 Elmer Thienes-Mary Hall Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   69                                             69
2767680 CT     school 900750 250011   Cheshire School District 90075000129 250511 Norton School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   69                                             69
2767927 CT     school 901860 620011   Hamden School District 90186000336 621211 Bear Path School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   69                                             69
2767968 CT     school 901920 640011   Hartford School District 90192000384 642111 West Middle School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   69                                             69
2442645 CT     school 904440 1380011   Stratford School District 90444000895 1381011 Second Hill Lane School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   68                                             68
2442937 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2019   grade_6                                                   68                                             68
2747464 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   68                                             68
2442423 CT     school 903210 1070011   Orange School District 90321000687 1070511 Peck Place School Public Schools Regular School No Elementary 01 06 2019   grade_6                                                   67                                             67
2442651 CT     school 904440 1380011   Stratford School District 90444000894 1380911 Nichols School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   67                                             67
2442672 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2019   grade_6                                                   67                                             67
2747424 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2021   grade_6                                                   67                                             67
2768231 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   67                                             67
2441695 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   66                                             66
2442562 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   66                                             66
2767682 CT     school 900750 250011   Cheshire School District 90075000126 250611 Doolittle School Public Schools Regular School No Elementary 01 06 2020   grade_6                                                   66                                             66
2767948 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2020   grade_6                                                   66                                             66
2442007 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   65                                             65
2747421 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   65                                             65
2748262 CT     school 904440 1380011   Stratford School District 90444000894 1380911 Nichols School Public Schools Regular School No Elementary KG 06 2021   grade_6                                                   65                                             65
2768234 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   65                                             65
2768502 CT     school 904110 1280011   Simsbury School District 90411000812 1280611 Latimer Lane School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   65                                             65
2442027 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2019   grade_6                                                   64                                             64
2442339 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Middle 06 09 2019   grade_6                                                   64                                             64
2442559 CT     school 904110 1280011   Simsbury School District 90411000810 1280111 Central School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   64                                             64
2442892 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2019   grade_6                                                   64                                             64
2747688 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   grade_6                                                   64                                             64
2748037 CT     school 903210 1070011   Orange School District 90321000687 1070511 Peck Place School Public Schools Regular School No Elementary 01 06 2021   grade_6                                                   64                                             64
2748038 CT     school 903210 1070011   Orange School District 90321000688 1070311 Race Brook School Public Schools Regular School No Elementary 01 06 2021   grade_6                                                   64                                             64
2748557 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   64                                             64
2767509 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2020   grade_6                                                   64                                             64
2767932 CT     school 901860 620011   Hamden School District 90186000349 621411 West Woods School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   64                                             64
2767973 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2020   grade_6                                                   64                                             64
2768612 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2020   grade_6                                                   64                                             64
2768814 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   64                                             64
2768888 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2020   grade_6                                                   64                                             64
2441589 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   63                                             63
2441646 CT     school 900450 150011   Bridgeport School District 90045000074 152011 Madison School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   63                                             63
2442070 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   grade_6                                                   63                                             63
2442291 CT     school 902790 930011   New Haven School District 90279001388 933011 King/Robinson Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   63                                             63
2747235 CT     school 900450 150011   Bridgeport School District 90045000049 150111 Barnum School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   63                                             63
2747631 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2021   grade_6                                                   63                                             63

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