Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_10 · 4,354
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▲ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2773509 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2020   grade_10                                                   99                                             99
2773555 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2020   grade_10                                                   99                                             99
2774695 CT     school 905250 1650011   Windsor Locks School District 90525001100 1656111 Windsor Locks High School Public Schools Regular School No High 09 12 2020   grade_10                                                   99                                             99
2448248 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2019   grade_10                                                   98                                             98
2753113 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2021   grade_10                                                   98                                             98
2753712 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2021   grade_10                                                   98                                             98
2753996 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2021   grade_10                                                   98                                             98
2774105 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2020   grade_10                                                   98                                             98
2447604 CT     school 901200 410011   East Haddam School District 90120000185 416111 Nathan Hale-Ray High School Public Schools Regular School No High 09 12 2019   grade_10                                                   97                                             97
2447841 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2019   grade_10                                                   97                                             97
2448402 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2019   grade_10                                                   97                                             97
2774205 CT     school 903180 1060011   Old Saybrook School District 90318000684 1066111 Old Saybrook Senior High School Public Schools Regular School No High 09 12 2020   grade_10                                                   97                                             97
2774237 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2020   grade_10                                                   97                                             97
2774787 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_10                                                   97                                             97
2448136 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2019   grade_10                                                   96                                             96
2448264 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2019   grade_10                                                   96                                             96
2774182 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2020   grade_10                                                   96                                             96
2753715 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2021   grade_10                                                   95                                             95
2774735 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2020   grade_10                                                   95                                             95
2447846 CT     school 901920 640011   Hartford School District 90192001403 647911 Great Path Academy at MCC Public Schools Regular School No High 09 12 2019   grade_10                                                   94                                             94
2448242 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2019   grade_10                                                   94                                             94
2753156 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2021   grade_10                                                   94                                             94
2754293 CT     school 905250 1650011   Windsor Locks School District 90525001100 1656111 Windsor Locks High School Public Schools Regular School No High 09 12 2021   grade_10                                                   93                                             93
2447849 CT     school 901920 640011   Hartford School District 90192001559 647511 HPHS Nursing and Health Sciences Academy   Regular School No High 09 12 2019   grade_10                                                   92                                             92
2753713 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2021   grade_10                                                   92                                             92
2448758 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_10                                                   91                                             91
2753043 CT     school 900450 150011   Bridgeport School District 90045001631 151611 Bridgeport Military Academy Public Schools Regular School No High 09 12 2021   grade_10                                                   91                                             91
2447447 CT     school 900450 150011   Bridgeport School District 90045001631 151611 Bridgeport Military Academy Public Schools Regular School No High 09 12 2019   grade_10                                                   90                                             90
2753445 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2021   grade_10                                                   90                                             90
2447645 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2019   grade_10                                                   9                                             9
2447961 CT     school   800011   Meriden School District   801411 Success Academy Program           2019   grade_10                                                   9                                             9
2448459 CT     school   1380011   Stratford School District 90444001671 1380711 High School Sails Program           2019   grade_10                                                   9                                             9
2753462 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2021   grade_10                                                   9                                             9
2753516 CT     school   770011   Manchester School District 90231001769 770211 Manchester High School-Site 2 Program           2021   grade_10                                                   9                                             9
2753517 CT     school   770011   Manchester School District 90231001717 770711 New Horizons Program           2021   grade_10                                                   9                                             9
2753546 CT     school   800011   Meriden School District   802011 TLC - MHS Program           2021   grade_10                                                   9                                             9
2753603 CT     school   860011   Montville School District 90258001481 869011 Palmer Academy Program           2021   grade_10                                                   9                                             9
2773404 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2020   grade_10                                                   9                                             9
2773554 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2020   grade_10                                                   9                                             9
2448123 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2019   grade_10                                                   89                                             89
2753837 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2021   grade_10                                                   89                                             89
2754339 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes High 06 12 2021   grade_10                                                   89                                             89
2773639 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2020   grade_10                                                   89                                             89
2774108 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2020   grade_10                                                   89                                             89
2448115 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2019   grade_10                                                   88                                             88
2753811 CT     school 903180 1060011   Old Saybrook School District 90318000684 1066111 Old Saybrook Senior High School Public Schools Regular School No High 09 12 2021   grade_10                                                   88                                             88
2774102 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2020   grade_10                                                   88                                             88
2774121 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2020   grade_10                                                   88                                             88
2447597 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2019   grade_10                                                   87                                             87
2774391 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2020   grade_10                                                   87                                             87
2774717 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_10                                                   87                                             87
2448260 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2019   grade_10                                                   86                                             86
2773440 CT     school 900450 150011   Bridgeport School District 90045001631 151611 Bridgeport Military Academy Public Schools Regular School No High 09 12 2020   grade_10                                                   86                                             86
2447848 CT     school 901920 640011   Hartford School District 90192001576 647411 HPHS Law and Government Academy   Regular School No High 09 12 2019   grade_10                                                   85                                             85
2773842 CT     school 901920 640011   Hartford School District 90192001403 647911 Great Path Academy at MCC Public Schools Regular School No High 09 12 2020   grade_10                                                   84                                             84
2753705 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2021   grade_10                                                   83                                             83
2774100 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2020   grade_10                                                   83                                             83
2774231 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2020   grade_10                                                   83                                             83
2754314 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_10                                                   81                                             81
2754337 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2021   grade_10                                                   81                                             81
2447583 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2019   grade_10                                                   804                                             804
2447891 CT     school 902130 710011   Lebanon School District 90213000396 716211 Lyman Memorial High School Public Schools Regular School No High 09 12 2019   grade_10                                                   80                                             80
2754315 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_10                                                   80                                             80
2774106 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2020   grade_10                                                   80                                             80
2447789 CT     school   620011   Hamden School District 90186001741 620511 Hamden Collaborative Learning Center Program           2019   grade_10                                                   8                                             8
2447854 CT     school   640011   Hartford School District 90192001677 648211 RISE - Hartford Public High School Program           2019   grade_10                                                   8                                             8
2448527 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_10                                                   8                                             8
2448644 CT     school   1560011   West Haven School District 90495001775 1560211 PACE Program           2019   grade_10                                                   8                                             8
2448794 CT     school   2190012   Regional School District 19 90000501729 2190112 E.O. Smith High School at the Depot Campus Program           2019   grade_10                                                   8                                             8
2753364 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2021   grade_10                                                   8                                             8
2773646 CT     school   2420014   EdAdvance   2420114 Steps Program           2020   grade_10                                                   8                                             8
2773717 CT     school   540011   Glastonbury School District 90162001801 540111 Links Academy Program           2020   grade_10                                                   8                                             8
2773913 CT     school   770011   Manchester School District 90231001717 770711 New Horizons Program           2020   grade_10                                                   8                                             8
2773945 CT     school   800011   Meriden School District   801711 TSC - PHS Program           2020   grade_10                                                   8                                             8
2774381 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2020   grade_10                                                   8                                             8
2774751 CT     school   2070012   Regional School District 07 90372001400 2079112 AIM Program           2020   grade_10                                                   8                                             8
2752998 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2021   grade_10                                                   79                                             79
2753449 CT     school 901920 640011   Hartford School District 90192001403 647911 Great Path Academy at MCC Public Schools Regular School No High 09 12 2021   grade_10                                                   79                                             79
2753843 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2021   grade_10                                                   79                                             79
2753180 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2021   grade_10                                                   788                                             788
2447518 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2019   grade_10                                                   78                                             78
2753786 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2021   grade_10                                                   78                                             78
2753864 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2021   grade_10                                                   78                                             78
2773578 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2020   grade_10                                                   779                                             779
2447521 CT     school 900700 2410014   Capitol Region Education Council 90070001532 2415214 Civic Leadership High School Regional Education Service Center Schools Regular School No High 09 12 2019   grade_10                                                   77                                             77
2753484 CT     school 902130 710011   Lebanon School District 90213000396 716211 Lyman Memorial High School Public Schools Regular School No High 09 12 2021   grade_10                                                   77                                             77
2773593 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2020   grade_10                                                   76                                             76
2447885 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2019   grade_10                                                   75                                             75
2753045 CT     school 900450 150011   Bridgeport School District 90045001633 151511 Information Technology & Software Engineering Magnet High School Public Schools Regular School No High 09 12 2021   grade_10                                                   75                                             75
2753198 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2021   grade_10                                                   75                                             75
2773848 CT     school   640011   Hartford School District 90192000382 646311 Weaver High School Public Schools           2020   grade_10                                                   75                                             75
2774179 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   grade_10                                                   75                                             75
2753708 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2021   grade_10                                                   74                                             74
2773600 CT     school 901200 410011   East Haddam School District 90120000185 416111 Nathan Hale-Ray High School Public Schools Regular School No High 09 12 2020   grade_10                                                   74                                             74
2773880 CT     school 902130 710011   Lebanon School District 90213000396 716211 Lyman Memorial High School Public Schools Regular School No High 09 12 2020   grade_10                                                   74                                             74
2448725 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   grade_10                                                   73                                             73
2774716 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_10                                                   73                                             73
2753848 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2021   grade_10                                                   71                                             71
2773395 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2020   grade_10                                                   71                                             71
2753726 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2021   grade_10                                                   70                                             70

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