enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,461 ✖

grade ✖

  • grade_7 · 1,461 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▲ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2769043 2769043 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   99                                             99
2770333 2770333 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_7                                                   96                                             96
2769065 2769065 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   95                                             95
2769910 2769910 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2020   grade_7                                                   95                                             95
2770355 2770355 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 2020   grade_7                                                   95                                             95
2769885 2769885 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2020   grade_7                                                   93                                             93
2770332 2770332 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   93                                             93
2770019 2770019 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   91                                             91
2770335 2770335 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_7                                                   91                                             91
2769496 2769496 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   90                                             90
2769821 2769821 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   90                                             90
2769858 2769858 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   90                                             90
2769456 2769456 CT     school   640011   Hartford School District   640110 iGOAL 1 - Milner School Program           2020   grade_7                                                   9                                             9
2769525 2769525 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2020   grade_7                                                   9                                             9
2770341 2770341 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   9                                             9
2769038 2769038 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   89                                             89
2769717 2769717 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2020   grade_7                                                   89                                             89
2769736 2769736 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   86                                             86
2769034 2769034 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   85                                             85
2769255 2769255 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   85                                             85
2769454 2769454 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2020   grade_7                                                   85                                             85
2770376 2770376 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2020   grade_7                                                   85                                             85
2770353 2770353 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 2020   grade_7                                                   84                                             84
2770077 2770077 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   82                                             82
2769039 2769039 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   81                                             81
2769216 2769216 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2020   grade_7                                                   80                                             80
2769553 2769553 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2020   grade_7                                                   8                                             8
2770337 2770337 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   8                                             8
2769415 2769415 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   77                                             77
2769681 2769681 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   77                                             77
2769694 2769694 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   77                                             77
2769049 2769049 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   76                                             76
2769738 2769738 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2020   grade_7                                                   73                                             73
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2769688 2769688 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 2020   grade_7                                                   55                                             55
2770153 2770153 CT     school 904830 1510011   Waterbury School District 90483001613 1513411 Reed School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   55                                             55
2769673 2769673 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   54                                             54
2769693 2769693 CT     school 902790 930011   New Haven School District 90279000568 931411 Nathan Hale School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   54                                             54
2769695 2769695 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   54                                             54
2770338 2770338 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2020   grade_7                                                   54                                             54
2769044 2769044 CT     school 900450 150011   Bridgeport School District 90045000081 152611 Roosevelt School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   53                                             53
2769045 2769045 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   53                                             53
2769677 2769677 CT     school 902790 930011   New Haven School District 90279001585 932111 Brennan Rogers School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   53                                             53
2769687 2769687 CT     school 902790 930011   New Haven School District 90279001443 931311 John C. Daniels Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   53                                             53
2769698 2769698 CT     school 902790 930011   New Haven School District 90279000553 931211 Edgewood School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   53                                             53
2769737 2769737 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Middle 06 10 2020   grade_7                                                   53                                             53
2769027 2769027 CT     school 900450 150011   Bridgeport School District 90045000052 150311 Black Rock School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   52                                             52
2769036 2769036 CT     school 900450 150011   Bridgeport School District 90045001163 154511 High Horizons Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   52                                             52
2769692 2769692 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   52                                             52
2769701 2769701 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 2020   grade_7                                                   52                                             52
2770146 2770146 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   52                                             52
2769676 2769676 CT     school 902790 930011   New Haven School District 90279000544 931811 Benjamin Jepson Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   51                                             51
2769031 2769031 CT     school 900450 150011   Bridgeport School District 90045000075 152111 Classical Studies Academy Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   50                                             50
2769041 2769041 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   50                                             50
2769487 2769487 CT     school 903450 2450014   Learn 90345001556 2455014 Dual Language & Arts Magnet Middle School   Regular School No Middle 06 08 2020   grade_7                                                   50                                             50
2769672 2769672 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   50                                             50
2770257 2770257 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   50                                             50
2770375 2770375 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2020   grade_7                                                   50                                             50
2769674 2769674 CT     school 902790 930011   New Haven School District 90279000543 930311 Beecher School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   49                                             49
2769680 2769680 CT     school 902790 930011   New Haven School District 90279000549 934111 Columbus Family Academy Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   49                                             49
2769682 2769682 CT     school 902790 930011   New Haven School District 90279000551 930911 Davis Academy for Arts & Design Innovation Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   49                                             49
2769875 2769875 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2020   grade_7                                                   49                                             49
2769409 2769409 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2020   grade_7                                                   48                                             48
2769428 2769428 CT     school 901920 640011   Hartford School District 90192000383 642011 Webster Micro Society Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   48                                             48
2769336 2769336 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   477                                             477
2770251 2770251 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   471                                             471
2768970 2768970 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 2020   grade_7                                                   47                                             47
2769033 2769033 CT     school 900450 150011   Bridgeport School District 90045001918 153111 Geraldine Claytor Magnet Academy Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   47                                             47
2769504 2769504 CT     school 902190 730011   Lisbon School District 90219000403 730111 Lisbon Central School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   47                                             47

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