enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_9" and state = "CT" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 4,154 ✖
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
2446914 2446914 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446922 2446922 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446939 2446939 CT     school 904230 1310011   Southington School District 90423000832 1315311 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446941 2446941 CT     school 904230 1310011   Southington School District 90423000833 1315111 Joseph A. Depaolo Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446952 2446952 CT     school 904290 1340011   Stafford School District 90429000061 1345211 Stafford Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446971 2446971 CT     school 904320 1350011   Stamford School District 90432000851 1355611 Cloonan School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446972 2446972 CT     school 904320 1350011   Stamford School District 90432000853 1355311 Dolan School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446973 2446973 CT     school 904320 1350011   Stamford School District 90432001353 1355811 Rippowam Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446974 2446974 CT     school 904320 1350011   Stamford School District 90432000009 1355711 Scofield Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446975 2446975 CT     school 904320 1350011   Stamford School District 90432000870 1355511 Turn of River School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446987 2446987 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   grade_9                                                   0                                             0
2446988 2446988 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 05 08 2019   grade_9                                                   0                                             0
2447004 2447004 CT     school 904440 1380011   Stratford School District 90444000900 1385211 David Wooster Middle School Public Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447005 2447005 CT     school 904440 1380011   Stratford School District 90444000888 1385311 Harry B. Flood Middle School Public Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447016 2447016 CT     school 904470 1390011   Suffield School District 90447000902 1395111 Suffield Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447019 2447019 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2019   grade_9                                                   0                                             0
2447023 2447023 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   grade_9                                                   0                                             0
2447027 2447027 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447037 2447037 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447047 2447047 CT     school 904620 1440011   Trumbull School District 90462000930 1445211 Hillcrest Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447048 2447048 CT     school 904620 1440011   Trumbull School District 90462000933 1445111 Madison Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447062 2447062 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447079 2447079 CT     school 904740 1480011   Wallingford School District 90474000951 1485211 Dag Hammarskjold Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447081 2447081 CT     school 904740 1480011   Wallingford School District 90474000954 1485311 James H. Moran Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447122 2447122 CT     school 904830 1510011   Waterbury School District 90483000991 1515211 West Side Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447125 2447125 CT     school 904830 1510011   Waterbury School District 90483000983 1515111 Michael F. Wallace Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447129 2447129 CT     school 904830 1510011   Waterbury School District 90483001115 1515311 North End Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447134 2447134 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447150 2447150 CT     school 904860 1520011   Waterford School District 90486000994 1525111 Clark Lane Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447157 2447157 CT     school 904890 1530011   Watertown School District 90489001007 1535111 Swift Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447177 2447177 CT     school 904920 1550011   West Hartford School District 90492001419 1555311 Bristow Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447178 2447178 CT     school 904920 1550011   West Hartford School District 90492001017 1555111 King Philip Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447179 2447179 CT     school 904920 1550011   West Hartford School District 90492001021 1555211 Sedgwick Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447193 2447193 CT     school 904950 1560011   West Haven School District 90495001037 1565311 Carrigan 5/6 Intermediate School Public Schools Regular School No Middle 05 06 2019   grade_9                                                   0                                             0
2447194 2447194 CT     school 904950 1560011   West Haven School District 90495001036 1565111 Harry M. Bailey Middle School Public Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447200 2447200 CT     school 904980 1540011   Westbrook School District 90498001043 1545111 Westbrook Middle School Public Schools Regular School No Middle 05 08 2019   grade_9                                                   0                                             0
2447204 2447204 CT     school 905010 1570011   Weston School District 90501001047 1575111 Weston Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447215 2447215 CT     school 905040 1580011   Westport School District 90504001048 1585111 Bedford Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447216 2447216 CT     school 905040 1580011   Westport School District 90504001052 1585311 Coleytown Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447225 2447225 CT     school 905070 1590011   Wethersfield School District 90507001066 1595211 Silas Deane Middle School Public Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447229 2447229 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2019   grade_9                                                   0                                             0
2447231 2447231 CT     school 905130 1610011   Wilton School District 90513001073 1615211 Middlebrook School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447246 2447246 CT     school 905190 1630011   Windham School District 90519001081 1635111 Windham Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447252 2447252 CT     school 905250 1650011   Windsor Locks School District 90525001101 1655111 Windsor Locks Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447260 2447260 CT     school 905220 1640011   Windsor School District 90522001095 1645311 Sage Park Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447268 2447268 CT     school 905280 1660011   Wolcott School District 90528001102 1665111 Tyrrell Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2447273 2447273 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2019   grade_9                                                   0                                             0
2447287 2447287 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 2019   grade_9                                                   0                                             0
2447288 2447288 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes Middle 06 10 2019   grade_9                                                   68                                             68
2447289 2447289 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 2019   grade_9                                                   0                                             0
2447290 2447290 CT     school 900023 2780013   Trailblazers Academy District 90002300965 2785113 Trailblazers Academy   Regular School Yes Middle 06 08 2019   grade_9                                                   0                                             0
2447291 2447291 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447294 2447294 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447295 2447295 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447300 2447300 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447305 2447305 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2751516 2751516 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
2751525 2751525 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2021   grade_9                                                   0                                             0
2751526 2751526 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
2751534 2751534 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751541 2751541 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751549 2751549 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_9                                                   0                                             0
2751551 2751551 CT     school 900330 110011   Bloomfield School District 90033000034 115211 Carmen Arace Middle School Public Schools Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
2751561 2751561 CT     school 900420 140011   Branford School District 90042000041 145111 Francis Walsh Intermediate School Public Schools Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
2751626 2751626 CT     school 900510 170011   Bristol School District 90051000089 175111 Chippens Hill Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751633 2751633 CT     school 900510 170011   Bristol School District 90051000104 175211 Northeast Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751642 2751642 CT     school 900540 180011   Brookfield School District 90054000112 185311 Whisconier Middle School Public Schools Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
2751645 2751645 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
2751647 2751647 CT     school 900660 220011   Canterbury School District 90066001187 225111 Dr. Helen Baldwin Middle School Public Schools Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
2751650 2751650 CT     school 900690 230011   Canton School District 90069001376 235111 Canton Middle School Public Schools Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
2751668 2751668 CT     school 900700 2410014   Capitol Region Education Council 90070001625 2415314 Greater Hartford Academy of the Arts Magnet Middle Regional Education Service Center Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751670 2751670 CT     school 900700 2410014   Capitol Region Education Council 90070001364 2415014 Two Rivers Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751684 2751684 CT     school 900750 250011   Cheshire School District 90075000125 255111 Dodd Middle School Public Schools Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
2751690 2751690 CT     school 900810 270011   Clinton School District 90081000133 275111 Jared Eliot School Public Schools Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
2751694 2751694 CT     school 900840 280011   Colchester School District 90084000136 285111 William J. Johnston Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751711 2751711 CT     school 900960 320011   Coventry School District 90096000141 325111 Capt. Nathan Hale School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751716 2751716 CT     school 900990 330011   Cromwell School District 90099000147 335111 Cromwell Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751732 2751732 CT     school 901020 340011   Danbury School District 90102000149 345111 Broadview Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751733 2751733 CT     school 901020 340011   Danbury School District 90102000160 345211 Rogers Park Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751734 2751734 CT     school 901020 340011   Danbury School District 90102001691 340311 Westside Middle School Academy Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751743 2751743 CT     school 901050 350011   Darien School District 90105000169 355111 Middlesex Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751748 2751748 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751753 2751753 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751756 2751756 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_9                                                   0                                             0
2751761 2751761 CT     school 901230 420011   East Hampton School District 90123000188 425111 East Hampton Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751774 2751774 CT     school 901260 430011   East Hartford School District 90126000197 435111 East Hartford Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751775 2751775 CT     school 901260 430011   East Hartford School District 90126001275 432411 Sunset Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751785 2751785 CT     school 901290 440011   East Haven School District 90129000217 445111 Joseph Melillo Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751791 2751791 CT     school 901320 450011   East Lyme School District 90132000224 455111 East Lyme Middle School Public Schools Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
2751796 2751796 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2021   grade_9                                                   0                                             0
2751807 2751807 CT     school 901410 460011   Easton School District 90141000233 465111 Helen Keller Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751818 2751818 CT     school 901440 480011   Ellington School District 90144000238 485111 Ellington Middle School Public Schools Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
2751840 2751840 CT     school 901470 490011   Enfield School District 90147000249 495211 John F. Kennedy Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751859 2751859 CT     school 901530 510011   Fairfield School District 90153000258 515211 Fairfield Woods Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751860 2751860 CT     school 901530 510011   Fairfield School District 90153000919 515311 Roger Ludlowe Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751861 2751861 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   0                                             0
2751871 2751871 CT     school 901560 520011   Farmington School District 90156001368 520511 West Woods Upper Elementary School Public Schools Regular School No Middle 04 06 2021   grade_9                                                   0                                             0
2751872 2751872 CT     school 901560 520011   Farmington School District 90156000274 525111 Irving A. Robbins Middle School Public Schools Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
2751883 2751883 CT     school 901620 540011   Glastonbury School District 90162000279 540811 Gideon Welles School Public Schools Regular School No Middle 06 06 2021   grade_9                                                   0                                             0
2751884 2751884 CT     school 901620 540011   Glastonbury School District 90162000282 545211 Smith Middle School Public Schools Regular School No Middle 06 08 2021   grade_9                                                   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]);