enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,344 ✖

grade ✖

  • grade_6 · 1,344 ✖
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
2747867 2747867 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747874 2747874 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747879 2747879 CT     school 902730 910011   New Fairfield School District 90273000537 916111 New Fairfield High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747929 2747929 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2021   grade_6                                                   84                                             84
2747930 2747930 CT     school 902790 930011   New Haven School District 90279001207 936411 Cooperative High School - Inter-District Magnet Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747932 2747932 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747933 2747933 CT     school 902790 930011   New Haven School District 90279000556 936311 Hill Regional Career High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747934 2747934 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747936 2747936 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747937 2747937 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747939 2747939 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747940 2747940 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747950 2747950 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2021   grade_6                                                   47                                             47
2747951 2747951 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747956 2747956 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747964 2747964 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747974 2747974 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747980 2747980 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747988 2747988 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2747991 2747991 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_6                                                   0                                             0
2748009 2748009 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748010 2748010 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748012 2748012 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748013 2748013 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748035 2748035 CT     school 903180 1060011   Old Saybrook School District 90318000684 1066111 Old Saybrook Senior High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748043 2748043 CT     school 903240 1080011   Oxford School District 90324001504 1086011 Oxford High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748051 2748051 CT     school 903270 1090011   Plainfield School District 90327000695 1096111 Plainfield High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748056 2748056 CT     school 903300 1100011   Plainville School District 90330000703 1106111 Plainville High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748061 2748061 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748067 2748067 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748072 2748072 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748079 2748079 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2021   grade_6                                                   0                                             0
2748084 2748084 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748088 2748088 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2021   grade_6                                                   50                                             50
2748094 2748094 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 08 12 2021   grade_6                                                   0                                             0
2748099 2748099 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748106 2748106 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748111 2748111 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748117 2748117 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748122 2748122 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748139 2748139 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748146 2748146 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748154 2748154 CT     school 903990 1240011   Seymour School District 90399000793 1246111 Seymour High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748168 2748168 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748178 2748178 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748182 2748182 CT     school 904140 1290011   Somers School District 90414000819 1296111 Somers High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748189 2748189 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748190 2748190 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748211 2748211 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748220 2748220 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748243 2748243 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748244 2748244 CT     school 904320 1350011   Stamford School District 90432001468 1356411 The Academy of Information, Technology & Engineering Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748245 2748245 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748252 2748252 CT     school 904380 1370011   Stonington School District 90438000881 1376111 Stonington High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748274 2748274 CT     school 904440 1380011   Stratford School District 90444000885 1386211 Bunnell High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748277 2748277 CT     school 904440 1380011   Stratford School District 90444000897 1386111 Stratford High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748282 2748282 CT     school 904470 1390011   Suffield School District 90447000904 1396111 Suffield High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748285 2748285 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2021   grade_6                                                   0                                             0
2748289 2748289 CT     school 904530 1410011   Thompson School District 90453000911 1416111 Tourtellotte Memorial High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748293 2748293 CT     school 904560 1420011   Tolland School District 90456000914 1426111 Tolland High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748303 2748303 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748315 2748315 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748327 2748327 CT     school 904680 1460011   Vernon School District 90468000943 1466111 Rockville High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748348 2748348 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748349 2748349 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748366 2748366 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748402 2748402 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748403 2748403 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748404 2748404 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748407 2748407 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748416 2748416 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748422 2748422 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748444 2748444 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748445 2748445 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748460 2748460 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748463 2748463 CT     school 904980 1540011   Westbrook School District 90498001044 1546111 Westbrook High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748467 2748467 CT     school 905010 1570011   Weston School District 90501001046 1576111 Weston High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748478 2748478 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748487 2748487 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748495 2748495 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748510 2748510 CT     school 905190 1630011   Windham School District 90519001086 1636111 Windham High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748517 2748517 CT     school 905250 1650011   Windsor Locks School District 90525001100 1656111 Windsor Locks High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748525 2748525 CT     school 905220 1640011   Windsor School District 90522001096 1646111 Windsor High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748534 2748534 CT     school 905280 1660011   Wolcott School District 90528001107 1666111 Wolcott High School Public Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748538 2748538 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   101                                             101
2748539 2748539 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   95                                             95
2748540 2748540 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   96                                             96
2748553 2748553 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   56                                             56
2748557 2748557 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   64                                             64
2748561 2748561 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748563 2748563 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes High 06 12 2021   grade_6                                                   115                                             115
2748568 2748568 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748572 2748572 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748578 2748578 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748582 2748582 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2021   grade_6                                                   0                                             0
2748583 2748583 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2021   grade_6                                                   0                                             0
2748584 2748584 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2021   grade_6                                                   0                                             0
2748585 2748585 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2021   grade_6                                                   0                                             0
2748596 2748596 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2021   grade_6                                                   0                                             0
2748597 2748597 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_6                                                   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]);