enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 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 ▲
2751736 2751736 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2021   grade_9                                                   965                                             965
2772117 2772117 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2020   grade_9                                                   941                                             941
2752199 2752199 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2021   grade_9                                                   856                                             856
2446134 2446134 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2019   grade_9                                                   842                                             842
2772577 2772577 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2020   grade_9                                                   791                                             791
2446603 2446603 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2019   grade_9                                                   736                                             736
2772279 2772279 CT     school 901710 570011   Greenwich School District 90171000300 576111 Greenwich High School Public Schools Regular School No High 09 12 2020   grade_9                                                   712                                             712
2446297 2446297 CT     school 901710 570011   Greenwich School District 90171000300 576111 Greenwich High School Public Schools Regular School No High 09 12 2019   grade_9                                                   691                                             691
2751905 2751905 CT     school 901710 570011   Greenwich School District 90171000300 576111 Greenwich High School Public Schools Regular School No High 09 12 2021   grade_9                                                   685                                             685
2772956 2772956 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2020   grade_9                                                   677                                             677
2752577 2752577 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2021   grade_9                                                   657                                             657
2752575 2752575 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2021   grade_9                                                   647                                             647
2446979 2446979 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2019   grade_9                                                   595                                             595
2447051 2447051 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2019   grade_9                                                   571                                             571
2752647 2752647 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2021   grade_9                                                   554                                             554
2772954 2772954 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2020   grade_9                                                   538                                             538
2772922 2772922 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2020   grade_9                                                   534                                             534
2773330 2773330 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2020   grade_9                                                   534                                             534
2447340 2447340 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_9                                                   521                                             521
2773026 2773026 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2020   grade_9                                                   515                                             515
2446746 2446746 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2019   grade_9                                                   508                                             508
2446277 2446277 CT     school 901620 540011   Glastonbury School District 90162000283 546111 Glastonbury High School Public Schools Regular School No High 09 12 2019   grade_9                                                   498                                             498
2446945 2446945 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2019   grade_9                                                   497                                             497
2446977 2446977 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2019   grade_9                                                   484                                             484
2771980 2771980 CT     school 900450 150011   Bridgeport School District 90045000056 156211 Central High School Public Schools Regular School No High 09 12 2020   grade_9                                                   483                                             483
2752543 2752543 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2021   grade_9                                                   479                                             479
2772259 2772259 CT     school 901620 540011   Glastonbury School District 90162000283 546111 Glastonbury High School Public Schools Regular School No High 09 12 2020   grade_9                                                   478                                             478
2752949 2752949 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2021   grade_9                                                   472                                             472
2772648 2772648 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2020   grade_9                                                   472                                             472
2752272 2752272 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2021   grade_9                                                   466                                             466
2447217 2447217 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2019   grade_9                                                   464                                             464
2751885 2751885 CT     school 901620 540011   Glastonbury School District 90162000283 546111 Glastonbury High School Public Schools Regular School No High 09 12 2021   grade_9                                                   464                                             464
2446477 2446477 CT     school 902310 770011   Manchester School District 90231000424 776111 Manchester High School Public Schools Regular School No High 09 12 2019   grade_9                                                   461                                             461
2773195 2773195 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2020   grade_9                                                   448                                             448
2752341 2752341 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2021   grade_9                                                   443                                             443
2446677 2446677 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2019   grade_9                                                   441                                             441
2772324 2772324 CT     school 901860 620011   Hamden School District 90186000339 626111 Hamden High School Public Schools Regular School No High 09 12 2020   grade_9                                                   440                                             440
2751950 2751950 CT     school 901860 620011   Hamden School District 90186000339 626111 Hamden High School Public Schools Regular School No High 09 12 2021   grade_9                                                   439                                             439
2752266 2752266 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2021   grade_9                                                   436                                             436
2772217 2772217 CT     school 901470 490011   Enfield School District 90147000243 496111 Enfield High School Public Schools Regular School No High 09 12 2020   grade_9                                                   433                                             433
2772643 2772643 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2020   grade_9                                                   433                                             433
2772717 2772717 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2020   grade_9                                                   433                                             433
2773177 2773177 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2020   grade_9                                                   433                                             433
2751862 2751862 CT     school 901530 510011   Fairfield School District 90153001379 516011 Fairfield Ludlowe High School Public Schools Regular School No High 09 12 2021   grade_9                                                   432                                             432
2752810 2752810 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2021   grade_9                                                   432                                             432
2752792 2752792 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2021   grade_9                                                   430                                             430
2446174 2446174 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2019   grade_9                                                   426                                             426
2771982 2771982 CT     school 900450 150011   Bridgeport School District 90045000067 156311 Warren Harding High School Public Schools Regular School No High 09 12 2020   grade_9                                                   424                                             424
2752071 2752071 CT     school 902310 770011   Manchester School District 90231000424 776111 Manchester High School Public Schools Regular School No High 09 12 2021   grade_9                                                   423                                             423
2446254 2446254 CT     school 901530 510011   Fairfield School District 90153001379 516011 Fairfield Ludlowe High School Public Schools Regular School No High 09 12 2019   grade_9                                                   418                                             418
2772450 2772450 CT     school 902310 770011   Manchester School District 90231000424 776111 Manchester High School Public Schools Regular School No High 09 12 2020   grade_9                                                   417                                             417
2446744 2446744 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2019   grade_9                                                   416                                             416
2772720 2772720 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2020   grade_9                                                   416                                             416
2446234 2446234 CT     school 901470 490011   Enfield School District 90147000243 496111 Enfield High School Public Schools Regular School No High 09 12 2019   grade_9                                                   409                                             409
2447198 2447198 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2019   grade_9                                                   409                                             409
2751842 2751842 CT     school 901470 490011   Enfield School District 90147000243 496111 Enfield High School Public Schools Regular School No High 09 12 2021   grade_9                                                   409                                             409
2772849 2772849 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2020   grade_9                                                   407                                             407
2751863 2751863 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2021   grade_9                                                   401                                             401
2446875 2446875 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2019   grade_9                                                   399                                             399
2447182 2447182 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2019   grade_9                                                   392                                             392
2752776 2752776 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2021   grade_9                                                   391                                             391
2751777 2751777 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2021   grade_9                                                   388                                             388
2752735 2752735 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2021   grade_9                                                   387                                             387
2772237 2772237 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2020   grade_9                                                   386                                             386
2773160 2773160 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2020   grade_9                                                   386                                             386
2445999 2445999 CT     school 900450 150011   Bridgeport School District 90045000056 156211 Central High School Public Schools Regular School No High 09 12 2019   grade_9                                                   385                                             385
2447181 2447181 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2019   grade_9                                                   384                                             384
2752344 2752344 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2021   grade_9                                                   384                                             384
2446142 2446142 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2019   grade_9                                                   383                                             383
2446084 2446084 CT     school 900750 250011   Cheshire School District 90075000123 256111 Cheshire High School Public Schools Regular School No High 09 12 2019   grade_9                                                   382                                             382
2447296 2447296 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2019   grade_9                                                   379                                             379
2752734 2752734 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2021   grade_9                                                   378                                             378
2772158 2772158 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2020   grade_9                                                   375                                             375
2446341 2446341 CT     school 901860 620011   Hamden School District 90186000339 626111 Hamden High School Public Schools Regular School No High 09 12 2019   grade_9                                                   374                                             374
2752739 2752739 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2021   grade_9                                                   373                                             373
2752471 2752471 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2021   grade_9                                                   370                                             370
2772015 2772015 CT     school 900510 170011   Bristol School District 90051000092 176111 Bristol Central High School Public Schools Regular School No High 09 12 2020   grade_9                                                   364                                             364
2752904 2752904 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2021   grade_9                                                   361                                             361
2772236 2772236 CT     school 901530 510011   Fairfield School District 90153001379 516011 Fairfield Ludlowe High School Public Schools Regular School No High 09 12 2020   grade_9                                                   361                                             361
2446709 2446709 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2019   grade_9                                                   360                                             360
2751600 2751600 CT     school 900450 150011   Bridgeport School District 90045000056 156211 Central High School Public Schools Regular School No High 09 12 2021   grade_9                                                   360                                             360
2752777 2752777 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2021   grade_9                                                   359                                             359
2772584 2772584 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2020   grade_9                                                   359                                             359
2772666 2772666 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2020   grade_9                                                   356                                             356
2772382 2772382 CT     school 901920 640011   Hartford School District 90192001925 646211 Hartford Public High School Public Schools Regular School No High 09 12 2020   grade_9                                                   355                                             355
2446533 2446533 CT     school 902490 830011   Middletown School District 90249000465 836211 Middletown High School Public Schools Regular School No High 09 12 2019   grade_9                                                   354                                             354
2751744 2751744 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2021   grade_9                                                   353                                             353
2772125 2772125 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2020   grade_9                                                   353                                             353
2773159 2773159 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2020   grade_9                                                   353                                             353
2772682 2772682 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   grade_9                                                   349                                             349
2446693 2446693 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2019   grade_9                                                   346                                             346
2772901 2772901 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2020   grade_9                                                   345                                             345
2772879 2772879 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2020   grade_9                                                   342                                             342
2772067 2772067 CT     school 900750 250011   Cheshire School District 90075000123 256111 Cheshire High School Public Schools Regular School No High 09 12 2020   grade_9                                                   341                                             341
2773212 2773212 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2020   grade_9                                                   341                                             341
2446255 2446255 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2019   grade_9                                                   340                                             340
2446911 2446911 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2019   grade_9                                                   340                                             340
2446701 2446701 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2019   grade_9                                                   339                                             339
2446901 2446901 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2019   grade_9                                                   336                                             336
2752306 2752306 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2021   grade_9                                                   336                                             336

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