enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,244 ✖

grade ✖

  • grade_1 · 1,244 ✖
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
2740184 2740184 CT     school 901020 340011   Danbury School District 90102000150 346111 Danbury High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740185 2740185 CT     school   340011   Danbury School District   340711 Western Connection Program           2021   grade_1                                                   0                                             0
2740191 2740191 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740192 2740192 CT     school 901050 350011   Darien School District 90105000164 356111 Darien High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740193 2740193 CT     school 901110 370011   Derby School District 90111001806 370111 Little Raiders University Public Schools Regular School No Prekindergarten PK PK 2021   grade_1                                                   0                                             0
2740196 2740196 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740197 2740197 CT     school   370011   Derby School District   370511 RAISE Academy Program           2021   grade_1                                                   0                                             0
2740198 2740198 CT     school 901110 370011   Derby School District 90111000175 376111 Derby High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740200 2740200 CT     school 901170 400011   East Granby School District 90117000183 400211 R. Dudley Seymour School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740201 2740201 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740202 2740202 CT     school 901170 400011   East Granby School District 90117000181 406111 East Granby High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740204 2740204 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_1                                                   0                                             0
2740205 2740205 CT     school 901200 410011   East Haddam School District 90120000185 416111 Nathan Hale-Ray High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740206 2740206 CT     school   410011   East Haddam School District   410311 East Haddam Cooperative Transition Program Program           2021   grade_1                                                   0                                             0
2740208 2740208 CT     school 901230 420011   East Hampton School District 90123000186 420311 Center School Public Schools Regular School No Elementary 04 05 2021   grade_1                                                   0                                             0
2740209 2740209 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740210 2740210 CT     school 901230 420011   East Hampton School District 90123000187 426111 East Hampton High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740211 2740211 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2021   grade_1                                                   0                                             0
2740212 2740212 CT     school   430011   East Hartford School District   430211 Early Childhood Learning Center at Hockanum School Program           2021   grade_1                                                   0                                             0
2740222 2740222 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740223 2740223 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740224 2740224 CT     school 901260 430011   East Hartford School District 90126001477 436311 Connecticut IB Academy Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740225 2740225 CT     school 901260 430011   East Hartford School District 90126000200 436211 East Hartford High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740226 2740226 CT     school   430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program           2021   grade_1                                                   0                                             0
2740228 2740228 CT     school 901290 440011   East Haven School District 90129001350 441811 Overbrook Early Learning Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_1                                                   0                                             0
2740232 2740232 CT     school 901290 440011   East Haven School District 90129000215 441311 Dominick H. Ferrara School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740233 2740233 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740234 2740234 CT     school 901290 440011   East Haven School District 90129000216 446111 East Haven High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740235 2740235 CT     school   450011   East Lyme School District 90132001450 458011 Integrated Preschool Program           2021   grade_1                                                   0                                             0
2740239 2740239 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2021   grade_1                                                   0                                             0
2740240 2740240 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2021   grade_1                                                   0                                             0
2740241 2740241 CT     school 901320 450011   East Lyme School District 90132000223 456111 East Lyme High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740242 2740242 CT     school   450011   East Lyme School District 90132001730 450511 Abilities in Motion (AIM) Program Program           2021   grade_1                                                   0                                             0
2740244 2740244 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2021   grade_1                                                   0                                             0
2740245 2740245 CT     school 901350 470011   East Windsor School District 90135000229 476111 East Windsor High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740246 2740246 CT     school   470011   East Windsor School District   470411 East Windsor Transition Program Program           2021   grade_1                                                   0                                             0
2740248 2740248 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740249 2740249 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001937 2530314 LEAP Alternative High School Regional Education Service Center Schools Alternative School No High 09 12 2021   grade_1                                                   0                                             0
2740250 2740250 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001530 2536114 Quinebaug Middle College Regional Education Service Center Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740251 2740251 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530214 Woodstock Academy Consortium Classroom Program           2021   grade_1                                                   0                                             0
2740252 2740252 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN)   2530114 Regional Transitional Services Program           2021   grade_1                                                   0                                             0
2740255 2740255 CT     school 901410 460011   Easton School District 90141000233 465111 Helen Keller Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740256 2740256 CT     school   2420014   EdAdvance 90351200575 2428014 EdAdvance Headstart Program           2021   grade_1                                                   0                                             0
2740259 2740259 CT     school   2420014   EdAdvance   2420114 Steps Program           2021   grade_1                                                   0                                             0
2740260 2740260 CT     school   2420014   EdAdvance   2420314 Steps-North Expelled Student Program           2021   grade_1                                                   0                                             0
2740261 2740261 CT     school   2420014   EdAdvance   2420414 ACCESS-South Expelled Student Program           2021   grade_1                                                   0                                             0
2740262 2740262 CT     school   2420014   EdAdvance   2420514 University Pathways Program Program           2021   grade_1                                                   0                                             0
2740266 2740266 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2021   grade_1                                                   0                                             0
2740267 2740267 CT     school 901440 480011   Ellington School District 90144000237 486111 Ellington High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740268 2740268 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2021   grade_1                                                   0                                             0
2740269 2740269 CT     school   480011   Ellington School District   480411 Ellington Continuing Life Independence Post-Secondary Education (ECLIPSE) Program           2021   grade_1                                                   0                                             0
2740271 2740271 CT     school   490011   Enfield School District 90147001915 492211 EPS Integrated Pre-Kindergarten Program           2021   grade_1                                                   0                                             0
2740272 2740272 CT     school   490011   Enfield School District 90147001810 491011 EPS PK STEAM Academy Program           2021   grade_1                                                   0                                             0
2740273 2740273 CT     school   490011   Enfield School District 90147000207 498011 Head Start Program Program           2021   grade_1                                                   0                                             0
2740279 2740279 CT     school 901470 490011   Enfield School District 90147000242 491611 Eli Whitney School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740280 2740280 CT     school   490011   Enfield School District 90147001696 490611 Henry Barnard - Educational Counseling Program (ECP) Program           2021   grade_1                                                   0                                             0
2740281 2740281 CT     school   490011   Enfield School District   492411 Eagle Academy Program           2021   grade_1                                                   0                                             0
2740282 2740282 CT     school   490011   Enfield School District 90147001676 490511 Edgar H. Parkman - Autism Spectrum Disorder (ASD) Program           2021   grade_1                                                   0                                             0
2740283 2740283 CT     school 901470 490011   Enfield School District 90147000241 491311 Edgar H. Parkman School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740284 2740284 CT     school   490011   Enfield School District   491411 Eli Whitney - Intermediate Adaptive Learning (IAL) Program           2021   grade_1                                                   0                                             0
2740285 2740285 CT     school   490011   Enfield School District 90147001702 490711 Prudence Crandall - Educational Counseling Program (ECP) Program           2021   grade_1                                                   0                                             0
2740286 2740286 CT     school 901470 490011   Enfield School District 90147000254 491511 Prudence Crandall School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740287 2740287 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2021   grade_1                                                   0                                             0
2740288 2740288 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740289 2740289 CT     school   490011   Enfield School District   492311 Enfield Alternative Education Program Program           2021   grade_1                                                   0                                             0
2740290 2740290 CT     school 901470 490011   Enfield School District 90147000243 496111 Enfield High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740291 2740291 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2021   grade_1                                                   0                                             0
2740292 2740292 CT     school   490011   Enfield School District 90147001523 499011 Enfield Transitional Learning Academy Program           2021   grade_1                                                   0                                             0
2740294 2740294 CT     school   510011   Fairfield School District   510811 Early Childhood Center(0510811) Program           2021   grade_1                                                   0                                             0
2740295 2740295 CT     school   510011   Fairfield School District 90153000989 518011 Early Childhood Center(0518011) Program           2021   grade_1                                                   0                                             0
2740307 2740307 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740308 2740308 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740309 2740309 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740310 2740310 CT     school 901530 510011   Fairfield School District 90153001379 516011 Fairfield Ludlowe High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740311 2740311 CT     school 901530 510011   Fairfield School District 90153000256 516211 Fairfield Warde High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740312 2740312 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2021   grade_1                                                   0                                             0
2740313 2740313 CT     school   510011   Fairfield School District   510511 Fairfield School/Community Partnership Program           2021   grade_1                                                   0                                             0
2740314 2740314 CT     school   520011   Farmington School District 90156001441 528011 Farmington Collaborative PK Program           2021   grade_1                                                   0                                             0
2740319 2740319 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2021   grade_1                                                   0                                             0
2740320 2740320 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 07 08 2021   grade_1                                                   0                                             0
2740321 2740321 CT     school 901560 520011   Farmington School District 90156000273 526111 Farmington High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740322 2740322 CT     school   520011   Farmington School District 90156001713 520611 Farmington Alternative High School Program           2021   grade_1                                                   0                                             0
2740324 2740324 CT     school   540011   Glastonbury School District 90162001724 540511 PreK-Eastbury Program           2021   grade_1                                                   0                                             0
2740331 2740331 CT     school 901620 540011   Glastonbury School District 90162000279 540811 Gideon Welles School Public Schools Regular School No Middle 06 06 2021   grade_1                                                   0                                             0
2740332 2740332 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740333 2740333 CT     school 901620 540011   Glastonbury School District 90162000283 546111 Glastonbury High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740334 2740334 CT     school   540011   Glastonbury School District 90162001752 541411 Glastonbury Transition Academy Program           2021   grade_1                                                   0                                             0
2740336 2740336 CT     school 901680 560011   Granby School District 90168000293 560311 Wells Road Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740337 2740337 CT     school 901680 560011   Granby School District 90168000291 565111 Granby Memorial Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740338 2740338 CT     school 901680 560011   Granby School District 90168000289 566111 Granby Memorial High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740350 2740350 CT     school 901710 570011   Greenwich School District 90171000295 575111 Central Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740351 2740351 CT     school 901710 570011   Greenwich School District 90171000298 575211 Eastern Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740352 2740352 CT     school 901710 570011   Greenwich School District 90171000309 575311 Western Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740353 2740353 CT     school 901710 570011   Greenwich School District 90171000300 576111 Greenwich High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740354 2740354 CT     school   570011   Greenwich School District   571511 Windrose Program           2021   grade_1                                                   0                                             0
2740355 2740355 CT     school   570011   Greenwich School District 90171001664 571211 Community Connections Program           2021   grade_1                                                   0                                             0
2740357 2740357 CT     school 901740 580011   Griswold School District 90174000019 585111 Griswold Middle School Public Schools Regular School No Middle 05 08 2021   grade_1                                                   0                                             0
2740358 2740358 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 08 12 2021   grade_1                                                   0                                             0
2740359 2740359 CT     school 901740 580011   Griswold School District 90174000311 586211 Griswold High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740366 2740366 CT     school 901770 590011   Groton School District 90177001938 591111 Groton Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0

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