enrollments

Data source: Big Local News · About: Big Local

1,444 rows where grade = "grade_8", state = "CT" and year = 2021 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,412 ✖

grade ✖

  • grade_8 · 1,412 ✖
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
2750810 2750810 CT     school 902790 930011   New Haven School District 90279001483 934211 Roberto Clemente Leadership Academy for Global Awareness Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   71                                             71
2750201 2750201 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   70                                             70
2750221 2750221 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2021   grade_8                                                   7                                             7
2750255 2750255 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2021   grade_8                                                   7                                             7
2751272 2751272 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2021   grade_8                                                   7                                             7
2751282 2751282 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2021   grade_8                                                   7                                             7
2751440 2751440 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   7                                             7
2750309 2750309 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   68                                             68
2750879 2750879 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_8                                                   67                                             67
2750149 2750149 CT     school 900450 150011   Bridgeport School District 90045001127 154611 Multicultural Magnet School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   66                                             66
2750838 2750838 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_8                                                   66                                             66
2750548 2750548 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   64                                             64
2750576 2750576 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   grade_8                                                   64                                             64
2751445 2751445 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2021   grade_8                                                   64                                             64
2751173 2751173 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2021   grade_8                                                   62                                             62
2750606 2750606 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   61                                             61
2751389 2751389 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   61                                             61
2750519 2750519 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2021   grade_8                                                   60                                             60
2750216 2750216 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2021   grade_8                                                   6                                             6
2750220 2750220 CT     school   2410014   Capitol Region Education Council 90070001154 2419014 John J. Allison Polaris Center Program           2021   grade_8                                                   6                                             6
2750355 2750355 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2021   grade_8                                                   6                                             6
2750747 2750747 CT     school   890011   New Britain School District 90267001566 899011 New Britain Transition Center Program           2021   grade_8                                                   6                                             6
2750806 2750806 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2021   grade_8                                                   6                                             6
2751279 2751279 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2021   grade_8                                                   6                                             6
2750109 2750109 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   58                                             58
2750957 2750957 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   58                                             58
2751378 2751378 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   58                                             58
2750967 2750967 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2021   grade_8                                                   57                                             57
2750142 2750142 CT     school 900450 150011   Bridgeport School District 90045000081 152611 Roosevelt School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   56                                             56
2751241 2751241 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   55                                             55
2750750 2750750 CT     school 902670 890011   New Britain School District 90267001445 895411 House of Arts Letters and Science (HALS) Academy Public Schools Regular School No Middle 06 08 2021   grade_8                                                   54                                             54
2750778 2750778 CT     school 902790 930011   New Haven School District 90279000544 931811 Benjamin Jepson Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   54                                             54
2750787 2750787 CT     school 902790 930011   New Haven School District 90279000559 930711 Hill Central Music Academy Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   54                                             54
2750796 2750796 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   54                                             54
2751441 2751441 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2021   grade_8                                                   54                                             54
2750976 2750976 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2021   grade_8                                                   53                                             53
2750125 2750125 CT     school 900450 150011   Bridgeport School District 90045000052 150311 Black Rock School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   52                                             52
2750789 2750789 CT     school 902790 930011   New Haven School District 90279001386 930811 John S. Martinez Sea and Sky STEM School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   52                                             52
2750134 2750134 CT     school 900450 150011   Bridgeport School District 90045001163 154511 High Horizons Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   51                                             51
2750551 2750551 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2021   grade_8                                                   51                                             51
2750772 2750772 CT     school 902790 930011   New Haven School District 90279000568 931411 Nathan Hale School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   51                                             51
2750775 2750775 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   51                                             51
2750794 2750794 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   51                                             51
2750773 2750773 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   50                                             50
2750801 2750801 CT     school 902790 930011   New Haven School District 90279000546 934311 Bishop Woods Architecture and Design Magnet School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   50                                             50
2750139 2750139 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   49                                             49
2750781 2750781 CT     school 902790 930011   New Haven School District 90279000549 934111 Columbus Family Academy Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   49                                             49
2750788 2750788 CT     school 902790 930011   New Haven School District 90279001443 931311 John C. Daniels Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   49                                             49
2750799 2750799 CT     school 902790 930011   New Haven School District 90279000553 931211 Edgewood School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   49                                             49
2750950 2750950 CT     school 903360 1120011   Pomfret School District 90336000709 1120111 Pomfret Community School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   49                                             49
2751472 2751472 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2021   grade_8                                                   49                                             49
2750515 2750515 CT     school 901920 640011   Hartford School District 90192000366 640911 Environmental Sciences Magnet at Hooker School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   48                                             48
2751350 2751350 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   48                                             48
2751431 2751431 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2021   grade_8                                                   48                                             48
2751344 2751344 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   477                                             477
2750440 2750440 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   475                                             475
2750131 2750131 CT     school 900450 150011   Bridgeport School District 90045001918 153111 Geraldine Claytor Magnet Academy Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   47                                             47
2750603 2750603 CT     school 902190 730011   Lisbon School District 90219000403 730111 Lisbon Central School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   47                                             47
2750837 2750837 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Secondary 06 11 2021   grade_8                                                   47                                             47
2750129 2750129 CT     school 900450 150011   Bridgeport School District 90045000075 152111 Classical Studies Academy Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   46                                             46
2750143 2750143 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   46                                             46
2750203 2750203 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2021   grade_8                                                   46                                             46
2750513 2750513 CT     school 901920 640011   Hartford School District 90192000360 640711 Dwight-Bellizzi Dual Language Academy Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   46                                             46
2750776 2750776 CT     school 902790 930011   New Haven School District 90279000543 930311 Beecher School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   46                                             46
2750779 2750779 CT     school 902790 930011   New Haven School District 90279001585 932111 Brennan Rogers School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   46                                             46
2750805 2750805 CT     school 902790 930011   New Haven School District 90279000550 930611 Clinton Avenue School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   46                                             46
2750123 2750123 CT     school 900450 150011   Bridgeport School District 90045000049 150111 Barnum School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   45                                             45
2750533 2750533 CT     school 901920 640011   Hartford School District 90192000383 642011 Webster Micro Society Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   45                                             45
2750540 2750540 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   45                                             45
2750785 2750785 CT     school 902790 930011   New Haven School District 90279000552 934611 East Rock Community Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   45                                             45
2750812 2750812 CT     school 902790 930011   New Haven School District 90279000586 933211 Wexler/Grant Community School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   45                                             45
2750135 2750135 CT     school 900450 150011   Bridgeport School District 90045001590 153711 Interdistrict Discovery Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   44                                             44
2750254 2750254 CT     school 900900 300011   Columbia School District 90090000139 300111 Horace W. Porter School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   44                                             44
2750574 2750574 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2021   grade_8                                                   44                                             44
2750783 2750783 CT     school 902790 930011   New Haven School District 90279000551 930911 Davis Academy for Arts & Design Innovation Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   44                                             44
2751243 2751243 CT     school 904830 1510011   Waterbury School District 90483001602 1511611 Duggan School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   44                                             44
2751248 2751248 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   44                                             44
2750625 2750625 CT     school 902310 770011   Manchester School District 90231000421 775311 Illing Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   434                                             434
2750130 2750130 CT     school 900450 150011   Bridgeport School District 90045000058 150511 Columbus School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   43                                             43
2750150 2750150 CT     school 900450 150011   Bridgeport School District 90045000059 153911 Wilbur Cross School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   43                                             43
2751244 2751244 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   43                                             43
2750503 2750503 CT     school 901860 620011   Hamden School District 90186000342 625211 Hamden Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   425                                             425
2751365 2751365 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   422                                             422
2750512 2750512 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2021   grade_8                                                   42                                             42
2750575 2750575 CT     school 900010 2640013   Integrated Day Charter School District 90001000775 2640113 Integrated Day Charter School Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_8                                                   42                                             42
2750780 2750780 CT     school 902790 930011   New Haven School District 90279001484 934811 Celentano BioTech, Health and Medical Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   41                                             41
2750870 2750870 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   41                                             41
2751036 2751036 CT     school 903900 1210011   Salem School District 90390000787 1210111 Salem Elementary School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   41                                             41
2750330 2750330 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   397                                             397
2750299 2750299 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   395                                             395
2751136 2751136 CT     school 904350 1360011   Sterling School District 90435001491 1360311 Sterling Community School Public Schools Regular School No Elementary PK 08 2021   grade_8                                                   39                                             39
2751471 2751471 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2021   grade_8                                                   39                                             39
2751055 2751055 CT     school 904050 1260011   Shelton School District 90405000801 1265111 Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   383                                             383
2750730 2750730 CT     school 900028 2800013   New Beginnings Inc Family Academy District 90002801366 2800113 New Beginnings Inc Family Academy Public Charter Schools Regular School Yes Elementary PK 08 2021   grade_8                                                   38                                             38
2750813 2750813 CT     school 902790 930011   New Haven School District 90279000588 933811 Worthington Hooker School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   38                                             38
2750396 2750396 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   376                                             376
2751274 2751274 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 04 08 2021   grade_8                                                   370                                             370
2750257 2750257 CT     school 900910 2430014   Cooperative Educational Services 90091000340 2430114 Six-Six Magnet School Regional Education Service Center Schools Regular School No Elementary PK 08 2021   grade_8                                                   37                                             37
2750541 2750541 CT     school 901920 640011   Hartford School District 90192000362 642511 STEM Magnet at Annie Fisher School Public Schools Regular School No Elementary KG 08 2021   grade_8                                                   37                                             37
2750289 2750289 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   369                                             369

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