enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,461 ✖

grade ✖

  • grade_9 · 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
2771979 2771979 CT     school 900450 150011   Bridgeport School District 90045001631 151611 Bridgeport Military Academy Public Schools Regular School No High 09 12 2020   grade_9                                                   99                                             99
2772770 2772770 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2020   grade_9                                                   98                                             98
2771981 2771981 CT     school 900450 150011   Bridgeport School District 90045001633 151511 Information Technology & Software Engineering Magnet High School Public Schools Regular School No High 09 12 2020   grade_9                                                   96                                             96
2772644 2772644 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2020   grade_9                                                   96                                             96
2772744 2772744 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_9                                                   95                                             95
2773256 2773256 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_9                                                   95                                             95
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
2772645 2772645 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2020   grade_9                                                   94                                             94
2772094 2772094 CT     school 900960 320011   Coventry School District 90096000143 326111 Coventry High School Public Schools Regular School No High 09 12 2020   grade_9                                                   93                                             93
2772930 2772930 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2020   grade_9                                                   92                                             92
2772639 2772639 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_9                                                   91                                             91
2772660 2772660 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_9                                                   90                                             90
2772185 2772185 CT     school   2420014   EdAdvance   2420114 Steps Program           2020   grade_9                                                   9                                             9
2772451 2772451 CT     school   770011   Manchester School District 90231001769 770211 Manchester High School-Site 2 Program           2020   grade_9                                                   9                                             9
2773278 2773278 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2020   grade_9                                                   9                                             9
2773279 2773279 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2020   grade_9                                                   9                                             9
2772381 2772381 CT     school 901920 640011   Hartford School District 90192001403 647911 Great Path Academy at MCC Public Schools Regular School No High 09 12 2020   grade_9                                                   88                                             88
2773298 2773298 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2020   grade_9                                                   86                                             86
2771976 2771976 CT     school 900450 150011   Bridgeport School District 90045001639 150811 Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School Public Schools Regular School No High 09 12 2020   grade_9                                                   85                                             85
2773255 2773255 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_9                                                   85                                             85
2771934 2771934 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2020   grade_9                                                   84                                             84
2773276 2773276 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes Secondary 06 11 2020   grade_9                                                   83                                             83
2772419 2772419 CT     school 902130 710011   Lebanon School District 90213000396 716211 Lyman Memorial High School Public Schools Regular School No High 09 12 2020   grade_9                                                   82                                             82
2773274 2773274 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_9                                                   82                                             82
2772776 2772776 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2020   grade_9                                                   80                                             80
2771887 2771887 CT     school   20011   Ansonia School District 90006001678 20111 P.A.C.E. (Positive And Creative Education) Program           2020   grade_9                                                   8                                             8
2773265 2773265 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2020   grade_9                                                   8                                             8
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
2772641 2772641 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_9                                                   78                                             78
2772797 2772797 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2020   grade_9                                                   78                                             78
2772718 2772718 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   grade_9                                                   77                                             77
2772132 2772132 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2020   grade_9                                                   75                                             75
2772178 2772178 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2020   grade_9                                                   74                                             74
2772371 2772371 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2020   grade_9                                                   73                                             73
2773257 2773257 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_9                                                   72                                             72
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
2772136 2772136 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2020   grade_9                                                   70                                             70
2771975 2771975 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2020   grade_9                                                   7                                             7
2772045 2772045 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2020   grade_9                                                   7                                             7
2772256 2772256 CT     school   540011   Glastonbury School District 90162001801 540111 Links Academy Program           2020   grade_9                                                   7                                             7
2772384 2772384 CT     school   640011   Hartford School District 90192001770 648311 RISE - Bulkeley High School Program           2020   grade_9                                                   7                                             7
2773061 2773061 CT     school   1480011   Wallingford School District   1481711 Inspire High School Program           2020   grade_9                                                   7                                             7
2773233 2773233 CT     school   1650011   Windsor Locks School District 90525001709 1650611 Pine Meadow Academy Program           2020   grade_9                                                   7                                             7
2772781 2772781 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2020   grade_9                                                   69                                             69
2772413 2772413 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2020   grade_9                                                   68                                             68
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
2772331 2772331 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2020   grade_9                                                   66                                             66
2773311 2773311 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   66                                             66
2772139 2772139 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_9                                                   62                                             62
2772338 2772338 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2020   grade_9                                                   62                                             62
2773000 2773000 CT     school 904530 1410011   Thompson School District 90453000911 1416111 Tourtellotte Memorial High School Public Schools Regular School No High 09 12 2020   grade_9                                                   60                                             60
2771896 2771896 CT     school   2440014   Area Cooperative Educational Services 90007001588 2449614 Center for Autism Spectrum and Development Disorders Program           2020   grade_9                                                   6                                             6
2772284 2772284 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 08 12 2020   grade_9                                                   6                                             6
2772482 2772482 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2020   grade_9                                                   6                                             6
2772571 2772571 CT     school   890011   New Britain School District 90267001566 899011 New Britain Transition Center Program           2020   grade_9                                                   6                                             6
2772578 2772578 CT     school   890011   New Britain School District   899511 New Britain High School Satellite Careers Academy Program           2020   grade_9                                                   6                                             6
2772983 2772983 CT     school   1380011   Stratford School District 90444001701 1380511 ALPHA Program           2020   grade_9                                                   6                                             6
2773174 2773174 CT     school   1560011   West Haven School District   1560711 Blended Program           2020   grade_9                                                   6                                             6
2773290 2773290 CT     school   2070012   Regional School District 07 90372001400 2079112 AIM Program           2020   grade_9                                                   6                                             6
2772997 2772997 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2020   grade_9                                                   59                                             59
2773180 2773180 CT     school 904980 1540011   Westbrook School District 90498001044 1546111 Westbrook High School Public Schools Regular School No High 09 12 2020   grade_9                                                   59                                             59
2772430 2772430 CT     school 902220 740011   Litchfield School District 90222000406 746111 Litchfield High School Public Schools Regular School No High 09 12 2020   grade_9                                                   56                                             56
2773260 2773260 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2020   grade_9                                                   56                                             56
2772699 2772699 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_9                                                   54                                             54
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
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
2772157 2772157 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2020   grade_9                                                   51                                             51
2773271 2773271 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_9                                                   51                                             51
2773297 2773297 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2020   grade_9                                                   51                                             51
2773299 2773299 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2020   grade_9                                                   49                                             49
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
2773266 2773266 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2020   grade_9                                                   48                                             48
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
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
2773267 2773267 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001530 2536114 Quinebaug Middle College Regional Education Service Center Schools Regular School No High 09 12 2020   grade_9                                                   47                                             47
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
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
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
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
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
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
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
2772659 2772659 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 10 2020   grade_9                                                   40                                             40
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
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
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
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
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
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
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

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