enrollments

Data source: Big Local News · About: Big Local

1,461 rows where grade = "grade_12", 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_12 · 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
2777313 2777313 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2020   grade_12                                                   99                                             99
2777617 2777617 CT     school 905250 1650011   Windsor Locks School District 90525001100 1656111 Windsor Locks High School Public Schools Regular School No High 09 12 2020   grade_12                                                   98                                             98
2776430 2776430 CT     school 900700 2410014   Capitol Region Education Council 90070001513 2415114 Academy of Aerospace and Engineering Regional Education Service Center Schools Regular School No High 06 12 2020   grade_12                                                   97                                             97
2777027 2777027 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2020   grade_12                                                   97                                             97
2777657 2777657 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2020   grade_12                                                   96                                             96
2777159 2777159 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2020   grade_12                                                   95                                             95
2776364 2776364 CT     school 900450 150011   Bridgeport School District 90045001633 151511 Information Technology & Software Engineering Magnet High School Public Schools Regular School No High 09 12 2020   grade_12                                                   93                                             93
2776772 2776772 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2020   grade_12                                                   9                                             9
2776832 2776832 CT     school   770011   Manchester School District 90231000427 779011 Manchester Regional Academy Program           2020   grade_12                                                   9                                             9
2776909 2776909 CT     school   840011   Milford School District   840611 Post Grad Transitional Academy Program           2020   grade_12                                                   9                                             9
2777050 2777050 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2020   grade_12                                                   9                                             9
2777675 2777675 CT     school   2070012   Regional School District 07 90372001402 2079312 STEP Program           2020   grade_12                                                   9                                             9
2776770 2776770 CT     school   640011   Hartford School District 90192000382 646311 Weaver High School Public Schools           2020   grade_12                                                   87                                             87
2777681 2777681 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_12                                                   87                                             87
2777705 2777705 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201672 9002116 J. M. Wright Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2020   grade_12                                                   87                                             87
2776766 2776766 CT     school 901920 640011   Hartford School District 90192001479 646611 Pathways Academy of Technology and Design Public Schools Regular School No High 09 12 2020   grade_12                                                   84                                             84
2776400 2776400 CT     school   170011   Bristol School District 90051001746 173311 Bristol Preparatory Academy Program           2020   grade_12                                                   8                                             8
2776427 2776427 CT     school   2410014   Capitol Region Education Council 90070001154 2419014 John J. Allison Polaris Center Program           2020   grade_12                                                   8                                             8
2776451 2776451 CT     school   250011   Cheshire School District 90075001682 250911 Humiston Alternative School Program           2020   grade_12                                                   8                                             8
2776476 2776476 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2020   grade_12                                                   8                                             8
2776562 2776562 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2020   grade_12                                                   8                                             8
2776808 2776808 CT     school   720011   Ledyard School District   720511 Ledyard Transition Academy Program           2020   grade_12                                                   8                                             8
2776865 2776865 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2020   grade_12                                                   8                                             8
2776908 2776908 CT     school   840011   Milford School District   840411 Fifth Year Vocational Experience Program           2020   grade_12                                                   8                                             8
2776973 2776973 CT     school   910011   New Fairfield School District 90273001687 910311 Alternative Learning Center Program           2020   grade_12                                                   8                                             8
2777341 2777341 CT     school   1350011   Stamford School District   1351311 PAVE (Post-Secondary Adaptive Vocational Experience) Program           2020   grade_12                                                   8                                             8
2777366 2777366 CT     school   1380011   Stratford School District 90444001701 1380511 ALPHA Program           2020   grade_12                                                   8                                             8
2777669 2777669 CT     school   2050012   Regional School District 05   2050112 Amity Transition Academy Program           2020   grade_12                                                   8                                             8
2777715 2777715 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9010222 Night School Program Regular School No High 09 12 2020   grade_12                                                   8                                             8
2776961 2776961 CT     school   890011   New Britain School District   899511 New Britain High School Satellite Careers Academy Program           2020   grade_12                                                   79                                             79
2776359 2776359 CT     school 900450 150011   Bridgeport School District 90045001639 150811 Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School Public Schools Regular School No High 09 12 2020   grade_12                                                   78                                             78
2776813 2776813 CT     school 902220 740011   Litchfield School District 90222000406 746111 Litchfield High School Public Schools Regular School No High 09 12 2020   grade_12                                                   78                                             78
2777043 2777043 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_12                                                   78                                             78
2777022 2777022 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_12                                                   77                                             77
2777030 2777030 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2020   grade_12                                                   77                                             77
2776522 2776522 CT     school 901200 410011   East Haddam School District 90120000185 416111 Nathan Hale-Ray High School Public Schools Regular School No High 09 12 2020   grade_12                                                   76                                             76
2776802 2776802 CT     school 902130 710011   Lebanon School District 90213000396 716211 Lyman Memorial High School Public Schools Regular School No High 09 12 2020   grade_12                                                   76                                             76
2777180 2777180 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2020   grade_12                                                   76                                             76
2776433 2776433 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2020   grade_12                                                   75                                             75
2776437 2776437 CT     school 900700 2410014   Capitol Region Education Council 90070001532 2415214 Civic Leadership High School Regional Education Service Center Schools Regular School No High 09 12 2020   grade_12                                                   75                                             75
2776500 2776500 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2020   grade_12                                                   745                                             745
2776515 2776515 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2020   grade_12                                                   71                                             71
2776764 2776764 CT     school 901920 640011   Hartford School District 90192001403 647911 Great Path Academy at MCC Public Schools Regular School No High 09 12 2020   grade_12                                                   71                                             71
2776542 2776542 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2020   grade_12                                                   70                                             70
2776272 2776272 CT     school   20011   Ansonia School District   21011 Ansonia 18-21 Transition Program Program           2020   grade_12                                                   7                                             7
2776305 2776305 CT     school   90011   Bethel School District   90311 TASK Program           2020   grade_12                                                   7                                             7
2776834 2776834 CT     school   770011   Manchester School District 90231001769 770211 Manchester High School-Site 2 Program           2020   grade_12                                                   7                                             7
2776869 2776869 CT     school   800011   Meriden School District   801411 Success Academy Program           2020   grade_12                                                   7                                             7
2776923 2776923 CT     school   860011   Montville School District   860611 Montville Transition and Vocational Training Academy Program           2020   grade_12                                                   7                                             7
2777029 2777029 CT     school   930011   New Haven School District 90279001550 939111 Riverside Education Academy Program           2020   grade_12                                                   7                                             7
2777398 2777398 CT     school   1430011   Torrington School District   1430311 Post Secondary Transition Services Program           2020   grade_12                                                   7                                             7
2777596 2777596 CT     school   1610011   Wilton School District   1610311 Community Steps Program           2020   grade_12                                                   7                                             7
2777665 2777665 CT     school   2040012   Regional School District 04   2040112 Region 4 Transition Academy Program           2020   grade_12                                                   7                                             7
2776662 2776662 CT     school 901710 570011   Greenwich School District 90171000300 576111 Greenwich High School Public Schools Regular School No High 09 12 2020   grade_12                                                   674                                             674
2776561 2776561 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2020   grade_12                                                   66                                             66
2776796 2776796 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2020   grade_12                                                   65                                             65
2776362 2776362 CT     school 900450 150011   Bridgeport School District 90045001631 151611 Bridgeport Military Academy Public Schools Regular School No High 09 12 2020   grade_12                                                   63                                             63
2777101 2777101 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   grade_12                                                   61                                             61
2776282 2776282 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2020   grade_12                                                   60                                             60
2776317 2776317 CT     school 900360 120011   Bolton School District 90036000037 126111 Bolton High School Public Schools Regular School No High 09 12 2020   grade_12                                                   60                                             60
2777104 2777104 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2020   grade_12                                                   60                                             60
2776306 2776306 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2020   grade_12                                                   6                                             6
2776452 2776452 CT     school   250011   Cheshire School District 90075001766 250311 Cheshire Quinnipiac University Transition Collaborative Program           2020   grade_12                                                   6                                             6
2776556 2776556 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2020   grade_12                                                   6                                             6
2776639 2776639 CT     school   540011   Glastonbury School District 90162001801 540111 Links Academy Program           2020   grade_12                                                   6                                             6
2776835 2776835 CT     school   770011   Manchester School District 90231001717 770711 New Horizons Program           2020   grade_12                                                   6                                             6
2776968 2776968 CT     school   900011   New Canaan School District   900111 Launch Program           2020   grade_12                                                   6                                             6
2777035 2777035 CT     school   930011   New Haven School District   938511 Wilbur Cross Self Contained MD Program           2020   grade_12                                                   6                                             6
2777072 2777072 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_12                                                   6                                             6
2777165 2777165 CT     school   1160011   Putnam School District 90348001518 1169011 Helping Hands Program           2020   grade_12                                                   6                                             6
2777447 2777447 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2020   grade_12                                                   6                                             6
2777503 2777503 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2020   grade_12                                                   6                                             6
2777588 2777588 CT     school   1590011   Wethersfield School District   1590111 Wethersfield Transition Academy Program           2020   grade_12                                                   6                                             6
2777648 2777648 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2020   grade_12                                                   6                                             6
2777713 2777713 CT     school 905371 9010022   Norwich Free Academy District 90537101221 9016122 Norwich Free Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2020   grade_12                                                   599                                             599
2777563 2777563 CT     school 904980 1540011   Westbrook School District 90498001044 1546111 Westbrook High School Public Schools Regular School No High 09 12 2020   grade_12                                                   59                                             59
2776754 2776754 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2020   grade_12                                                   58                                             58
2777028 2777028 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2020   grade_12                                                   57                                             57
2777164 2777164 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2020   grade_12                                                   56                                             56
2776519 2776519 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2020   grade_12                                                   54                                             54
2777305 2777305 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2020   grade_12                                                   512                                             512
2777339 2777339 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2020   grade_12                                                   500                                             500
2777024 2777024 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2020   grade_12                                                   50                                             50
2777380 2777380 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2020   grade_12                                                   50                                             50
2776642 2776642 CT     school 901620 540011   Glastonbury School District 90162000283 546111 Glastonbury High School Public Schools Regular School No High 09 12 2020   grade_12                                                   491                                             491
2777409 2777409 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2020   grade_12                                                   482                                             482
2777034 2777034 CT     school   930011   New Haven School District   937311 Off-Campus Classroom Program (OCC) Program           2020   grade_12                                                   48                                             48
2777082 2777082 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_12                                                   48                                             48
2777640 2777640 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_12                                                   48                                             48
2776428 2776428 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2020   grade_12                                                   47                                             47
2777383 2777383 CT     school 904530 1410011   Thompson School District 90453000911 1416111 Tourtellotte Memorial High School Public Schools Regular School No High 09 12 2020   grade_12                                                   45                                             45
2777654 2777654 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_12                                                   45                                             45
2777578 2777578 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2020   grade_12                                                   440                                             440
2776960 2776960 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2020   grade_12                                                   430                                             430
2777337 2777337 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2020   grade_12                                                   430                                             430
2776540 2776540 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2020   grade_12                                                   43                                             43
2777638 2777638 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_12                                                   43                                             43
2777720 2777720 CT     school 900031 2820013   Stamford Academy District 90003101405 2826013 Stamford Academy   Regular School Yes High 09 12 2020   grade_12                                                   43                                             43
2777065 2777065 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   grade_12                                                   426                                             426
2776541 2776541 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2020   grade_12                                                   416                                             416

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