enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,444 ✖

grade ✖

  • grade_7 · 1,444 ✖
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
2749111 2749111 CT     school 901920 640011   Hartford School District 90192000381 641911 Milner Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   99                                             99
2749984 2749984 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_7                                                   99                                             99
2749537 2749537 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 06 08 2021   grade_7                                                   96                                             96
2749982 2749982 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_7                                                   96                                             96
2748729 2748729 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   94                                             94
2748757 2748757 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   93                                             93
2750008 2750008 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2021   grade_7                                                   93                                             93
2750029 2750029 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2021   grade_7                                                   92                                             92
2748688 2748688 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   91                                             91
2749673 2749673 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   90                                             90
2750006 2750006 CT     school 900033 2830013   Park City Prep Charter School District 90003301449 2835113 Park City Prep Charter School Public Charter Schools Regular School Yes Middle 05 08 2021   grade_7                                                   90                                             90
2748951 2748951 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2021   grade_7                                                   9                                             9
2749996 2749996 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   9                                             9
2749109 2749109 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   83                                             83
2749373 2749373 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2021   grade_7                                                   83                                             83
2749565 2749565 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2021   grade_7                                                   83                                             83
2749625 2749625 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   81                                             81
2749732 2749732 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   81                                             81
2749208 2749208 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2021   grade_7                                                   8                                             8
2749113 2749113 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2021   grade_7                                                   79                                             79
2749338 2749338 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   79                                             79
2749519 2749519 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   79                                             79
2748865 2748865 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   76                                             76
2748868 2748868 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2021   grade_7                                                   75                                             75
2749132 2749132 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   grade_7                                                   75                                             75
2748692 2748692 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   74                                             74
2749107 2749107 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2021   grade_7                                                   74                                             74
2748693 2748693 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   73                                             73
2748697 2748697 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   73                                             73
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2749071 2749071 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_7                                                   54                                             54
2749306 2749306 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_7                                                   54                                             54
2749343 2749343 CT     school 902790 930011   New Haven School District 90279000559 930711 Hill Central Music Academy Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   54                                             54
2749355 2749355 CT     school 902790 930011   New Haven School District 90279000553 931211 Edgewood School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   54                                             54
2749328 2749328 CT     school 902790 930011   New Haven School District 90279000568 931411 Nathan Hale School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   53                                             53
2749332 2749332 CT     school 902790 930011   New Haven School District 90279000543 930311 Beecher School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   53                                             53
2749335 2749335 CT     school 902790 930011   New Haven School District 90279001585 932111 Brennan Rogers School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   53                                             53
2749339 2749339 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_7                                                   53                                             53
2749357 2749357 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_7                                                   53                                             53
2749435 2749435 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_7                                                   53                                             53
2749337 2749337 CT     school 902790 930011   New Haven School District 90279000549 934111 Columbus Family Academy Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   52                                             52
2749345 2749345 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_7                                                   52                                             52
2750028 2750028 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2021   grade_7                                                   52                                             52
2748686 2748686 CT     school 900450 150011   Bridgeport School District 90045000058 150511 Columbus School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   51                                             51
2749075 2749075 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_7                                                   51                                             51
2749334 2749334 CT     school 902790 930011   New Haven School District 90279000544 931811 Benjamin Jepson Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   50                                             50
2749366 2749366 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_7                                                   50                                             50
2749394 2749394 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_7                                                   50                                             50
2748695 2748695 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   49                                             49
2748705 2748705 CT     school 900450 150011   Bridgeport School District 90045001127 154611 Multicultural Magnet School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   49                                             49
2749341 2749341 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_7                                                   49                                             49
2749804 2749804 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   49                                             49
2748699 2748699 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   48                                             48
2749329 2749329 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   48                                             48
2748681 2748681 CT     school 900450 150011   Bridgeport School District 90045000052 150311 Black Rock School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   47                                             47
2749096 2749096 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   47                                             47
2749159 2749159 CT     school 902190 730011   Lisbon School District 90219000403 730111 Lisbon Central School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   47                                             47
2749361 2749361 CT     school 902790 930011   New Haven School District 90279000550 930611 Clinton Avenue School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   47                                             47
2749532 2749532 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2021   grade_7                                                   47                                             47
2748679 2748679 CT     school 900450 150011   Bridgeport School District 90045000049 150111 Barnum School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   46                                             46
2749368 2749368 CT     school 902790 930011   New Haven School District 90279000586 933211 Wexler/Grant Community School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   46                                             46
2749799 2749799 CT     school 904830 1510011   Waterbury School District 90483001602 1511611 Duggan School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   46                                             46
2749800 2749800 CT     school 904830 1510011   Waterbury School District 90483000976 1512611 Gilmartin School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   46                                             46
2749900 2749900 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_7                                                   450                                             450
2748759 2748759 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   45                                             45
2749523 2749523 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2021   grade_7                                                   45                                             45
2748685 2748685 CT     school 900450 150011   Bridgeport School District 90045000075 152111 Classical Studies Academy Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   44                                             44
2748810 2748810 CT     school 900900 300011   Columbia School District 90090000139 300111 Horace W. Porter School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   44                                             44
2749369 2749369 CT     school 902790 930011   New Haven School District 90279000588 933811 Worthington Hooker School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   44                                             44
2748691 2748691 CT     school 900450 150011   Bridgeport School District 90045001590 153711 Interdistrict Discovery Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   43                                             43

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