enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,254 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▲ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2748908 2748908 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   72                                             72
2749478 2749478 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   72                                             72
2769447 2769447 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   72                                             72
2769711 2769711 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 2020   grade_7                                                   72                                             72
2748703 2748703 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   71                                             71
2769103 2769103 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   71                                             71
2443492 2443492 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   70                                             70
2749074 2749074 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   70                                             70
2749162 2749162 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   70                                             70
2769434 2769434 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   70                                             70
2443487 2443487 CT     school   640011   Hartford School District   645911 RISE - M.D. Fox School             2019   grade_7                                                   7                                             7
2443495 2443495 CT     school   640011   Hartford School District   648911 iGOAL 1 - McDonough Middle School             2019   grade_7                                                   7                                             7
2443496 2443496 CT     school   640011   Hartford School District   640110 iGOAL 1 - Milner School Program           2019   grade_7                                                   7                                             7
2443602 2443602 CT     school   800011   Meriden School District   802411 SOAR - WMS Program           2019   grade_7                                                   7                                             7
2444235 2444235 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2019   grade_7                                                   7                                             7
2444384 2444384 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary KG 08 2019   grade_7                                                   7                                             7
2748741 2748741 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2021   grade_7                                                   7                                             7
2749143 2749143 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2021   grade_7                                                   7                                             7
2749206 2749206 CT     school   800011   Meriden School District   802411 SOAR - WMS Program           2021   grade_7                                                   7                                             7
2749362 2749362 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2021   grade_7                                                   7                                             7
2749416 2749416 CT     school   970011   Newtown School District   970711 Reaching Independence through Structured Education Program           2021   grade_7                                                   7                                             7
2749828 2749828 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2021   grade_7                                                   7                                             7
2749832 2749832 CT     school   1510011   Waterbury School District   1513711 North End BDLC Program           2021   grade_7                                                   7                                             7
2770107 2770107 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   7                                             7
2770174 2770174 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   grade_7                                                   7                                             7
2770182 2770182 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2020   grade_7                                                   7                                             7
2443746 2443746 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   69                                             69
2749151 2749151 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   69                                             69
2749351 2749351 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   69                                             69
2749352 2749352 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   69                                             69
2769689 2769689 CT     school 902790 930011   New Haven School District 90279001388 933011 King/Robinson Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   69                                             69
2443169 2443169 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2019   grade_7                                                   68                                             68
2443476 2443476 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2019   grade_7                                                   68                                             68
2443519 2443519 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   grade_7                                                   68                                             68
2443555 2443555 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   68                                             68
2749997 2749997 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_7                                                   68                                             68
2770349 2770349 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_7                                                   68                                             68
2443295 2443295 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   67                                             67
2444411 2444411 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2019   grade_7                                                   67                                             67
2750001 2750001 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_7                                                   67                                             67
2769213 2769213 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   67                                             67
2443081 2443081 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   66                                             66
2769474 2769474 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2020   grade_7                                                   66                                             66
2770075 2770075 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2020   grade_7                                                   66                                             66
2749729 2749729 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2021   grade_7                                                   65                                             65
2769051 2769051 CT     school 900450 150011   Bridgeport School District 90045001127 154611 Multicultural Magnet School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   65                                             65
2443724 2443724 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   64                                             64
2444386 2444386 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2019   grade_7                                                   64                                             64
2748665 2748665 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   64                                             64
2749350 2749350 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   64                                             64
2770296 2770296 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   64                                             64
2443788 2443788 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Middle 06 09 2019   grade_7                                                   63                                             63
2769777 2769777 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_7                                                   63                                             63
2749069 2749069 CT     school 901920 640011   Hartford School District 90192000360 640711 Dwight-Bellizzi Dual Language Academy Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   62                                             62
2749945 2749945 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   62                                             62
2443055 2443055 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   61                                             61
2443451 2443451 CT     school 901920 640011   Hartford School District 90192000360 640711 Dwight-Bellizzi Dual Language Academy Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   61                                             61
2443472 2443472 CT     school 901920 640011   Hartford School District 90192000385 642211 Wish Museum School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   61                                             61
2769011 2769011 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   61                                             61
2769507 2769507 CT     school 902220 740011   Litchfield School District 90222001809 746011 Litchfield Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   61                                             61
2443096 2443096 CT     school 900450 150011   Bridgeport School District 90045001127 154611 Multicultural Magnet School Public Schools Regular School No Elementary KG 08 2019   grade_7                                                   60                                             60
2443925 2443925 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2019   grade_7                                                   60                                             60
2444341 2444341 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2019   grade_7                                                   60                                             60
2769416 2769416 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_7                                                   60                                             60
2443091 2443091 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2019   grade_7                                                   6                                             6
2443201 2443201 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2019   grade_7                                                   6                                             6
2443698 2443698 CT     school   890011   New Britain School District 90267001566 899011 New Britain Transition Center Program           2019   grade_7                                                   6                                             6
2443735 2443735 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2019   grade_7                                                   6                                             6
2444232 2444232 CT     school   1510011   Waterbury School District   1514811 North End SCOPE Program           2019   grade_7                                                   6                                             6
2748777 2748777 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2021   grade_7                                                   6                                             6
2749762 2749762 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   6                                             6
2769123 2769123 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2020   grade_7                                                   6                                             6
2769124 2769124 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2020   grade_7                                                   6                                             6
2769159 2769159 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2020   grade_7                                                   6                                             6
2769995 2769995 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2020   grade_7                                                   6                                             6
2770026 2770026 CT     school   1350011   Stamford School District 90432001744 1350411 Anchor Program           2020   grade_7                                                   6                                             6
2443014 2443014 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 2019   grade_7                                                   59                                             59
2749987 2749987 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_7                                                   59                                             59
2769451 2769451 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   59                                             59
2444122 2444122 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2019   grade_7                                                   58                                             58
2749068 2749068 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2021   grade_7                                                   58                                             58
2769429 2769429 CT     school 901920 640011   Hartford School District 90192000384 642111 West Middle School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   58                                             58
2443453 2443453 CT     school 901920 640011   Hartford School District 90192000366 640911 Environmental Sciences Magnet at Hooker School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   57                                             57
2444331 2444331 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   57                                             57
2749331 2749331 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   57                                             57
2769412 2769412 CT     school 901920 640011   Hartford School District 90192000366 640911 Environmental Sciences Magnet at Hooker School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   57                                             57
2769866 2769866 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2020   grade_7                                                   57                                             57
2443075 2443075 CT     school 900450 150011   Bridgeport School District 90045000058 150511 Columbus School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   56                                             56
2443253 2443253 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   56                                             56
2444190 2444190 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   56                                             56
2769856 2769856 CT     school 903420 1140011   Preston School District 90342000717 1145111 Preston Plains School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   56                                             56
2770285 2770285 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   56                                             56
2444193 2444193 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   55                                             55
2748690 2748690 CT     school 900450 150011   Bridgeport School District 90045001163 154511 High Horizons Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   55                                             55
2749104 2749104 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   55                                             55
2749346 2749346 CT     school 902790 930011   New Haven School District 90279001388 933011 King/Robinson Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   55                                             55
2749797 2749797 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   55                                             55
2769449 2769449 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2020   grade_7                                                   55                                             55
2769650 2769650 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 2020   grade_7                                                   55                                             55
2769686 2769686 CT     school 902790 930011   New Haven School District 90279000559 930711 Hill Central Music Academy Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   55                                             55

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