enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,361 ✖

grade ✖

  • grade_5 · 1,361 ✖
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
2766745 2766745 CT     school 902730 910011   New Fairfield School District 90273000537 916111 New Fairfield High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766795 2766795 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2020   grade_5                                                   0                                             0
2766796 2766796 CT     school 902790 930011   New Haven School District 90279001207 936411 Cooperative High School - Inter-District Magnet Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766797 2766797 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766798 2766798 CT     school 902790 930011   New Haven School District 90279000556 936311 Hill Regional Career High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766799 2766799 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766800 2766800 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766801 2766801 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766803 2766803 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766804 2766804 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766816 2766816 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2020   grade_5                                                   0                                             0
2766817 2766817 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766822 2766822 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766830 2766830 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766838 2766838 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766844 2766844 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766852 2766852 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766855 2766855 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_5                                                   0                                             0
2766873 2766873 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766874 2766874 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766876 2766876 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766877 2766877 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766900 2766900 CT     school 903180 1060011   Old Saybrook School District 90318000684 1066111 Old Saybrook Senior High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766908 2766908 CT     school 903240 1080011   Oxford School District 90324001504 1086011 Oxford High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766916 2766916 CT     school 903270 1090011   Plainfield School District 90327000695 1096111 Plainfield High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766921 2766921 CT     school 903300 1100011   Plainville School District 90330000703 1106111 Plainville High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766926 2766926 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766932 2766932 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766937 2766937 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766944 2766944 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2020   grade_5                                                   0                                             0
2766949 2766949 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766953 2766953 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2020   grade_5                                                   0                                             0
2766959 2766959 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766964 2766964 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766972 2766972 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766978 2766978 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766983 2766983 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2766989 2766989 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767005 2767005 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767012 2767012 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767021 2767021 CT     school 903990 1240011   Seymour School District 90399000793 1246111 Seymour High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767035 2767035 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767045 2767045 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767049 2767049 CT     school 904140 1290011   Somers School District 90414000819 1296111 Somers High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767056 2767056 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767057 2767057 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767078 2767078 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767086 2767086 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767110 2767110 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767111 2767111 CT     school 904320 1350011   Stamford School District 90432001468 1356411 The Academy of Information, Technology & Engineering Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767112 2767112 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767120 2767120 CT     school 904380 1370011   Stonington School District 90438000881 1376111 Stonington High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767141 2767141 CT     school 904440 1380011   Stratford School District 90444000885 1386211 Bunnell High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767144 2767144 CT     school 904440 1380011   Stratford School District 90444000897 1386111 Stratford High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767149 2767149 CT     school 904470 1390011   Suffield School District 90447000904 1396111 Suffield High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767153 2767153 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2020   grade_5                                                   0                                             0
2767156 2767156 CT     school 904530 1410011   Thompson School District 90453000911 1416111 Tourtellotte Memorial High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767160 2767160 CT     school 904560 1420011   Tolland School District 90456000914 1426111 Tolland High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767170 2767170 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767182 2767182 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767194 2767194 CT     school 904680 1460011   Vernon School District 90468000943 1466111 Rockville High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767218 2767218 CT     school 904740 1480011   Wallingford School District 90474000955 1486111 Lyman Hall High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767219 2767219 CT     school 904740 1480011   Wallingford School District 90474000956 1486211 Mark T. Sheehan High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767237 2767237 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767273 2767273 CT     school 904830 1510011   Waterbury School District 90483000971 1516211 Crosby High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767274 2767274 CT     school 904830 1510011   Waterbury School District 90483000979 1516411 John F. Kennedy High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767275 2767275 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767278 2767278 CT     school 904830 1510011   Waterbury School District 90483000992 1516311 Wilby High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767287 2767287 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767293 2767293 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767315 2767315 CT     school 904920 1550011   West Hartford School District 90492001013 1556111 Conard High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767316 2767316 CT     school 904920 1550011   West Hartford School District 90492001015 1556211 Hall High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767333 2767333 CT     school 904950 1560011   West Haven School District 90495001041 1566111 West Haven High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767336 2767336 CT     school 904980 1540011   Westbrook School District 90498001044 1546111 Westbrook High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767340 2767340 CT     school 905010 1570011   Weston School District 90501001046 1576111 Weston High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767351 2767351 CT     school 905040 1580011   Westport School District 90504001058 1586111 Staples High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767360 2767360 CT     school 905070 1590011   Wethersfield School District 90507001068 1596111 Wethersfield High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767368 2767368 CT     school 905130 1610011   Wilton School District 90513001076 1616111 Wilton High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767383 2767383 CT     school 905190 1630011   Windham School District 90519001086 1636111 Windham High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767390 2767390 CT     school 905250 1650011   Windsor Locks School District 90525001100 1656111 Windsor Locks High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767399 2767399 CT     school 905220 1640011   Windsor School District 90522001096 1646111 Windsor High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767407 2767407 CT     school 905280 1660011   Wolcott School District 90528001107 1666111 Wolcott High School Public Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767411 2767411 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_5                                                   98                                             98
2767412 2767412 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_5                                                   106                                             106
2767413 2767413 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_5                                                   97                                             97
2767416 2767416 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2020   grade_5                                                   60                                             60
2767422 2767422 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 2020   grade_5                                                   0                                             0
2767423 2767423 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 2020   grade_5                                                   0                                             0
2767425 2767425 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 10 12 2020   grade_5                                                   0                                             0
2767427 2767427 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2020   grade_5                                                   66                                             66
2767430 2767430 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767437 2767437 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767441 2767441 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767447 2767447 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767451 2767451 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2020   grade_5                                                   0                                             0
2767452 2767452 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2020   grade_5                                                   0                                             0
2767453 2767453 CT     school 900015 2690013   The Bridge Academy District 90001500809 2696113 The Bridge Academy Public Charter Schools Regular School Yes High 07 12 2020   grade_5                                                   0                                             0
2767454 2767454 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2020   grade_5                                                   0                                             0
2767467 2767467 CT     school 900014 2680013   Common Ground High School District 90001400807 2686113 Common Ground High School Public Charter Schools Regular School Yes High 09 12 2020   grade_5                                                   0                                             0
2767468 2767468 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 2020   grade_5                                                   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]);