enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,344 ✖

grade ✖

  • grade_1 · 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
2741203 2741203 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2021   grade_1                                                   0                                             0
2741202 2741202 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2741196 2741196 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2741146 2741146 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2741175 2741175 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2741184 2741184 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2741145 2741145 CT     school 904830 1510011   Waterbury School District 90483000988 1512311 Washington School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   46                                             46
2741228 2741228 CT     school 904950 1560011   West Haven School District 90495001040 1561211 Washington School Public Schools Regular School No Elementary PK 04 2021   grade_1                                                   69                                             69
2740865 2740865 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2021   grade_1                                                   22                                             22
2740545 2740545 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740050 2740050 CT     school 900450 150011   Bridgeport School District 90045000067 156311 Warren Harding High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740858 2740858 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2021   grade_1                                                   7                                             7
2740860 2740860 CT     school   2060012   Regional School District 06   2060412 Wamogo Transition Program Program           2021   grade_1                                                   0                                             0
2740859 2740859 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2021   grade_1                                                   0                                             0
2740035 2740035 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2021   grade_1                                                   57                                             57
2740312 2740312 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2021   grade_1                                                   0                                             0
2740504 2740504 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2741144 2741144 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   62                                             62
2741130 2741130 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2021   grade_1                                                   0                                             0
2741174 2741174 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2021   grade_1                                                   0                                             0
2741173 2741173 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2021   grade_1                                                   0                                             0
2741172 2741172 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2021   grade_1                                                   0                                             0
2741310 2741310 CT     school 905280 1660011   Wolcott School District 90528001106 1660511 Wakelee School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   64                                             64
2740514 2740514 CT     school 902310 770011   Manchester School District 90231000430 771311 Waddell School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   95                                             95
2740892 2740892 CT     school   2160012   Regional School District 16 90353801747 2160412 WRHS Alternative Education Program Program           2021   grade_1                                                   0                                             0
2741115 2741115 CT     school   1480011   Wallingford School District   1481611 WISE Primary Program Program           2021   grade_1                                                   *                                              
2741122 2741122 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2021   grade_1                                                   0                                             0
2741392 2741392 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201151 9002316 W. F. Kaynor Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_1                                                   0                                             0
2741285 2741285 CT     school 905190 1630011   Windham School District 90519001084 1630611 W. B. Sweeney School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   33                                             33
2741109 2741109 CT     school 904710 1470011   Voluntown School District 90471000949 1470111 Voluntown Elementary School Public Schools Regular School No Elementary PK 08 2021   grade_1                                                   25                                             25
2741080 2741080 CT     school 904590 1430011   Torrington School District 90459001211 1431311 Vogel-Wetmore School Public Schools Regular School No Elementary KG 03 2021   grade_1                                                   143                                             143
2740574 2740574 CT     school   830011   Middletown School District 90249001765 831711 Virtual Learning Academy - MHS Program           2021   grade_1                                                   0                                             0
2740811 2740811 CT     school   1040011   Norwich School District 90312001622 1049211 Virtual Learning Academy Program           2021   grade_1                                                   0                                             0
2741391 2741391 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2021   grade_1                                                   0                                             0
2741322 2741322 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2021   grade_1                                                   *                                              
2740805 2740805 CT     school 903120 1040011   Norwich School District 90312000677 1041811 Veterans' Memorial School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   40                                             40
2740906 2740906 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   31                                             31
2740513 2740513 CT     school 902310 770011   Manchester School District 90231000429 771211 Verplanck School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   95                                             95
2741106 2741106 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740546 2740546 CT     school   800011   Meriden School District   801311 Venture Academy Program           2021   grade_1                                                   0                                             0
2740638 2740638 CT     school 902670 890011   New Britain School District 90267000527 891511 Vance Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   84                                             84
2740843 2740843 CT     school 903390 1130011   Portland School District 90339000714 1130211 Valley View School Public Schools Regular School No Elementary PK 01 2021   grade_1                                                   110                                             110
2741348 2741348 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740974 2740974 CT     school 904230 1310011   Southington School District 90423000841 1311411 Urbin T. Kelley School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   54                                             54
2740111 2740111 CT     school 900700 2410014   Capitol Region Education Council 90070001357 2410214 University of Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2021   grade_1                                                   67                                             67
2740262 2740262 CT     school   2420014   EdAdvance   2420514 University Pathways Program Program           2021   grade_1                                                   0                                             0
2740458 2740458 CT     school 901920 640011   Hartford School District 90192001381 646711 University High School of Science and Engineering Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740315 2740315 CT     school 901560 520011   Farmington School District 90156000276 520111 Union School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   54                                             54
2741098 2741098 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2021   grade_1                                                   *                                              
2740804 2740804 CT     school 903120 1040011   Norwich School District 90312000676 1041911 Uncas Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   37                                             37
2741312 2741312 CT     school 905280 1660011   Wolcott School District 90528001102 1665111 Tyrrell Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740118 2740118 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_1                                                   0                                             0
2741021 2741021 CT     school 904320 1350011   Stamford School District 90432000870 1355511 Turn of River School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740819 2740819 CT     school 903210 1070011   Orange School District 90321000689 1070411 Turkey Hill School Public Schools Regular School No Elementary 01 06 2021   grade_1                                                   58                                             58
2741095 2741095 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2741086 2741086 CT     school   1440011   Trumbull School District 90462000683 1448011 Trumbull Early Childhood Education Center Program           2021   grade_1                                                   0                                             0
2741096 2741096 CT     school   1440011   Trumbull School District 90462001669 1440211 Trumbull Alternative School Program           2021   grade_1                                                   0                                             0
2740688 2740688 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2021   grade_1                                                   47                                             47
2740949 2740949 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2021   grade_1                                                   0                                             0
2740154 2740154 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2021   grade_1                                                   0                                             0
2739984 2739984 CT     school   70011   Berlin School District   70311 Transition Academy Program           2021   grade_1                                                   0                                             0
2740370 2740370 CT     school   590011   Groton School District   591011 Transition Academy Program           2021   grade_1                                                   0                                             0
2740812 2740812 CT     school   1040011   Norwich School District   1041011 Transition Academy Program           2021   grade_1                                                   0                                             0
2740783 2740783 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   85                                             85
2740500 2740500 CT     school   760011   Madison School District 90228001549 769011 Town Campus Learning Center Program           2021   grade_1                                                   0                                             0
2741069 2741069 CT     school 904530 1410011   Thompson School District 90453000911 1416111 Tourtellotte Memorial High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740758 2740758 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2741082 2741082 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2741083 2741083 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2741079 2741079 CT     school 904590 1430011   Torrington School District 90459000923 1430911 Torringford School Public Schools Regular School No Elementary PK 03 2021   grade_1                                                   148                                             148
2741015 2741015 CT     school 904320 1350011   Stamford School District 90432000008 1351911 Toquam Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   112                                             112
2740956 2740956 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2021   grade_1                                                   42                                             42
2740309 2740309 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2741075 2741075 CT     school   1420011   Tolland School District   1420611 Tolland Transition Academy Program           2021   grade_1                                                   0                                             0
2741072 2741072 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2741071 2741071 CT     school 904560 1420011   Tolland School District 90456000913 1420211 Tolland Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2741073 2741073 CT     school 904560 1420011   Tolland School District 90456000914 1426111 Tolland High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740188 2740188 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   72                                             72
2740968 2740968 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740484 2740484 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2021   grade_1                                                   0                                             0
2741068 2741068 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2021   grade_1                                                   0                                             0
2739973 2739973 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2021   grade_1                                                   0                                             0
2741065 2741065 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2021   grade_1                                                   0                                             0
2741064 2741064 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2021   grade_1                                                   0                                             0
2740798 2740798 CT     school 903120 1040011   Norwich School District 90312000675 1041711 Thomas W. Mahan School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   35                                             35
2740036 2740036 CT     school 900450 150011   Bridgeport School District 90045000069 151311 Thomas Hooker School Public Schools Regular School No Elementary KG 08 2021   grade_1                                                   42                                             42
2740533 2740533 CT     school 902400 800011   Meriden School District 90240000451 801011 Thomas Hooker School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   90                                             90
2741327 2741327 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740944 2740944 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2021   grade_1                                                   0                                             0
2740989 2740989 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2021   grade_1                                                   0                                             0
2740151 2740151 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2021   grade_1                                                   *                                              
2741403 2741403 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740051 2740051 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2021   grade_1                                                   0                                             0
2740139 2740139 CT     school 900810 270011   Clinton School District 90081000134 276111 The Morgan School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740211 2740211 CT     school   420011   East Hampton School District 90123001514 429011 The Learning Center at East Hampton Program           2021   grade_1                                                   0                                             0
2741033 2741033 CT     school   1370011   Stonington School District   1370911 The Learning Annex Program           2021   grade_1                                                   0                                             0
2740992 2740992 CT     school   1310011   Southington School District 90423001665 1310111 The Karen Smith Academy Program           2021   grade_1                                                   0                                             0
2741365 2741365 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_1                                                   0                                             0
2740477 2740477 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2021   grade_1                                                   0                                             0
2740268 2740268 CT     school   480011   Ellington School District   480511 The Ellington Public Schools Expulsion Program (TEPSEP) Program           2021   grade_1                                                   0                                             0

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