enrollments
Data source: Big Local News · About: Big Local
20,216 rows where state = "CT" and year = 2021 sorted by male descending
This data as json, CSV (advanced)
grade ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2757947 | 2757947 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000505 | 886111 | Naugatuck High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 662 | 131 | 382 | * | * | 0 | 57 | 656 | * | 69 | 239 | 1279 | 662 | 131 | 382 | 0 | 57 | 656 | 69 | 239 | 1279 | ||||||||||||||||||||||||||||||||
2757953 | 2757953 | CT | school | 890011 | New Britain School District | 890111 | Roosevelt Early Learning Center | Program | 2021 | pk_12_total | 15 | * | 69 | 0 | 0 | 0 | * | 65 | 36 | 0 | 55 | 101 | 15 | 69 | 0 | 0 | 0 | 65 | 36 | 0 | 55 | 101 | ||||||||||||||||||||||||||||||||||||||
2758185 | 2758185 | CT | school | 903515 | 2060012 | Regional School District 06 | 90351500724 | 2060212 | James Morris School | Regional Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 116 | * | 9 | 0 | 0 | 0 | * | 65 | 64 | * | 26 | 129 | 116 | 9 | 0 | 0 | 0 | 65 | 64 | 26 | 129 | ||||||||||||||||||||||||||||||||
2758649 | 2758649 | CT | school | 2440014 | Area Cooperative Educational Services | 2440214 | ACES Mill Elementary School | Program | 2021 | pk_12_total | * | 38 | 20 | 0 | 0 | 0 | * | 65 | 17 | * | 74 | 82 | 38 | 20 | 0 | 0 | 0 | 65 | 17 | 74 | 82 | |||||||||||||||||||||||||||||||||||||||
2757378 | 2757378 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000067 | 156311 | Warren Harding High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 69 | 387 | 712 | * | 9 | * | 10 | 646 | 547 | 368 | 291 | 1193 | 69 | 387 | 712 | 9 | 10 | 646 | 547 | 368 | 291 | 1193 | |||||||||||||||||||||||||||||||
2758510 | 2758510 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000971 | 1516211 | Crosby High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 134 | 302 | 730 | 13 | 21 | 0 | 17 | 643 | 574 | 234 | 316 | 1217 | 134 | 302 | 730 | 13 | 21 | 0 | 17 | 643 | 574 | 234 | 316 | 1217 | |||||||||||||||||||||||||||||
2757552 | 2757552 | CT | school | 901260 | 430011 | East Hartford School District | 90126001477 | 436311 | Connecticut IB Academy | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 40 | 64 | 47 | * | 27 | 0 | * | 64 | 118 | * | * | 182 | 40 | 64 | 47 | 27 | 0 | 64 | 118 | 182 | |||||||||||||||||||||||||||||||||
2757554 | 2757554 | CT | school | 430011 | East Hartford School District | 90126001377 | 436411 | Synergy Alternative Program | Program | 2021 | pk_12_total | * | 24 | 58 | 0 | 0 | 0 | * | 64 | 32 | 11 | 26 | 96 | 24 | 58 | 0 | 0 | 0 | 64 | 32 | 11 | 26 | 96 | |||||||||||||||||||||||||||||||||||||
2757826 | 2757826 | CT | school | 902220 | 740011 | Litchfield School District | 90222001809 | 746011 | Litchfield Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 118 | 0 | * | 0 | * | 0 | 0 | 64 | 67 | * | 26 | 131 | 118 | 0 | 0 | 0 | 0 | 64 | 67 | 26 | 131 | ||||||||||||||||||||||||||||||||
2757381 | 2757381 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 46 | * | 38 | 0 | * | 0 | 10 | 63 | 33 | 0 | 71 | 96 | 46 | 38 | 0 | 0 | 10 | 63 | 33 | 0 | 71 | 96 | |||||||||||||||||||||||||||||||
2758263 | 2758263 | CT | school | 904020 | 1250011 | Sharon School District | 90402000795 | 1250111 | Sharon Center School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 92 | 0 | 12 | 0 | * | 0 | * | 63 | 49 | 6 | 26 | 112 | 92 | 0 | 12 | 0 | 0 | 63 | 49 | 6 | 26 | 112 | |||||||||||||||||||||||||||||||
2757649 | 2757649 | CT | school | 901560 | 520011 | Farmington School District | 90156000273 | 526111 | Farmington High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 818 | 54 | 95 | * | 270 | 0 | * | 629 | 638 | 9 | 153 | 1267 | 818 | 54 | 95 | 270 | 0 | 629 | 638 | 9 | 153 | 1267 | |||||||||||||||||||||||||||||||
2758603 | 2758603 | CT | school | 905130 | 1610011 | Wilton School District | 90513001076 | 1616111 | Wilton High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 975 | * | 76 | * | 130 | 0 | 68 | 621 | 651 | * | 200 | 1272 | 975 | 76 | 130 | 0 | 68 | 621 | 651 | 200 | 1272 | ||||||||||||||||||||||||||||||||
2757578 | 2757578 | CT | school | 901360 | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001530 | 2536114 | Quinebaug Middle College | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 121 | * | 27 | 0 | * | 0 | 11 | 62 | 103 | * | 30 | 165 | 121 | 27 | 0 | 0 | 11 | 62 | 103 | 30 | 165 | ||||||||||||||||||||||||||||||||
2757623 | 2757623 | CT | school | 510011 | Fairfield School District | 90153000989 | 518011 | Early Childhood Center(0518011) | Program | 2021 | pk_12_total | 68 | 0 | 11 | 0 | 11 | 0 | 7 | 62 | 35 | 0 | 66 | 97 | 68 | 0 | 11 | 0 | 11 | 0 | 7 | 62 | 35 | 0 | 66 | 97 | |||||||||||||||||||||||||||||||||||
2758042 | 2758042 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 54 | 615 | 445 | 0 | 23 | * | * | 610 | 546 | 216 | 252 | 1156 | 54 | 615 | 445 | 0 | 23 | 610 | 546 | 216 | 252 | 1156 | |||||||||||||||||||||||||||||||
2758515 | 2758515 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000992 | 1516311 | Wilby High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 85 | 281 | 694 | * | * | 0 | 22 | 603 | 488 | 208 | 312 | 1091 | 85 | 281 | 694 | 0 | 22 | 603 | 488 | 208 | 312 | 1091 | |||||||||||||||||||||||||||||||
2757875 | 2757875 | CT | school | 902400 | 800011 | Meriden School District | 90240000441 | 806111 | Francis T. Maloney High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 354 | 134 | 626 | * | 44 | * | 48 | 602 | 606 | 155 | 187 | 1208 | 354 | 134 | 626 | 44 | 48 | 602 | 606 | 155 | 187 | 1208 | |||||||||||||||||||||||||||||||
2758494 | 2758494 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000983 | 1515111 | Michael F. Wallace Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2021 | pk_12_total | 128 | 284 | 683 | 11 | 19 | 0 | 45 | 602 | 568 | 136 | 205 | 1170 | 128 | 284 | 683 | 11 | 19 | 0 | 45 | 602 | 568 | 136 | 205 | 1170 | |||||||||||||||||||||||||||||
2757295 | 2757295 | CT | school | 20011 | Ansonia School District | 20411 | P.A.C.E. - PM (Positive And Creative Education - PM) | Program | 2021 | pk_12_total | * | * | 0 | 0 | 0 | 0 | * | 6 | 0 | 0 | * | 6 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | ||||||||||||||||||||||||||||||||||||||||
2757304 | 2757304 | CT | school | 50011 | Barkhamsted School District | 90015001373 | 58011 | Shared Services Integrated Preschool | Program | 2021 | pk_12_total | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 7 | 0 | 6 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 7 | 0 | 6 | 13 | |||||||||||||||||||||||||||||||||||
2757749 | 2757749 | CT | school | 640011 | Hartford School District | 640610 | Pre-K Integrated - West Middle School | Program | 2021 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | 6 | 6 | 0 | * | 12 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 12 | ||||||||||||||||||||||||||||||||||||||||
2757865 | 2757865 | CT | school | 800011 | Meriden School District | 802211 | SOAR- ES | Program | 2021 | pk_12_total | * | * | 8 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 12 | 12 | 8 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||
2758034 | 2758034 | CT | school | 930011 | New Haven School District | 937811 | Clinton Self Contained ID | Program | 2021 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 6 | 8 | * | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 14 | 14 | |||||||||||||||||||||||||||||||||||||||
2758277 | 2758277 | CT | school | 1260011 | Shelton School District | 1260711 | Transition Program | Program | 2021 | pk_12_total | 13 | * | * | 0 | 0 | 0 | 0 | 6 | 10 | 0 | 16 | 16 | 13 | 0 | 0 | 0 | 0 | 6 | 10 | 0 | 16 | 16 | ||||||||||||||||||||||||||||||||||||||
2758379 | 2758379 | CT | school | 1380011 | Stratford School District | 90444001706 | 1381911 | STEPS 7-8 | Program | 2021 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||
2758585 | 2758585 | CT | school | 905040 | 1580011 | Westport School District | 90504001048 | 1585111 | Bedford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 924 | 24 | 95 | 0 | 76 | 0 | 88 | 593 | 614 | 8 | 151 | 1207 | 924 | 24 | 95 | 0 | 76 | 0 | 88 | 593 | 614 | 8 | 151 | 1207 | |||||||||||||||||||||||||||||
2757550 | 2757550 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 96 | 344 | 562 | * | 33 | * | 49 | 590 | 499 | 178 | 249 | 1089 | 96 | 344 | 562 | 33 | 49 | 590 | 499 | 178 | 249 | 1089 | |||||||||||||||||||||||||||||||
2757519 | 2757519 | CT | school | 901050 | 350011 | Darien School District | 90105000169 | 355111 | Middlesex Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 956 | * | 74 | * | 61 | 0 | 37 | 581 | 562 | 8 | 182 | 1143 | 956 | 74 | 61 | 0 | 37 | 581 | 562 | 8 | 182 | 1143 | |||||||||||||||||||||||||||||||
2757706 | 2757706 | CT | school | 620011 | Hamden School District | 90186001433 | 628011 | Alice Peck Learning Center | Program | 2021 | pk_12_total | 13 | 37 | 21 | 0 | * | 0 | * | 58 | 30 | 0 | 65 | 88 | 13 | 37 | 21 | 0 | 0 | 58 | 30 | 0 | 65 | 88 | |||||||||||||||||||||||||||||||||||||
2757616 | 2757616 | CT | school | 901470 | 490011 | Enfield School District | 90147000249 | 495211 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 754 | 68 | 218 | * | * | 0 | 45 | 573 | 539 | 22 | 168 | 1112 | 754 | 68 | 218 | 0 | 45 | 573 | 539 | 22 | 168 | 1112 | |||||||||||||||||||||||||||||||
2757642 | 2757642 | CT | school | 520011 | Farmington School District | 90156001441 | 528011 | Farmington Collaborative PK | Program | 2021 | pk_12_total | 63 | 7 | 9 | 0 | 12 | 0 | 6 | 57 | 40 | 0 | 40 | 97 | 63 | 7 | 9 | 0 | 12 | 0 | 6 | 57 | 40 | 0 | 40 | 97 | |||||||||||||||||||||||||||||||||||
2757860 | 2757860 | CT | school | 800011 | Meriden School District | 802611 | PRIDE | Program | 2021 | pk_12_total | 29 | 9 | 50 | * | * | 0 | * | 57 | 35 | 0 | * | 92 | 29 | 9 | 50 | 0 | 57 | 35 | 0 | 92 | ||||||||||||||||||||||||||||||||||||||||
2758325 | 2758325 | CT | school | 904290 | 1340011 | Stafford School District | 90429000848 | 1340411 | West Stafford School | Public Schools | Regular School | No | Elementary | PK | 01 | 2021 | pk_12_total | 102 | 0 | 12 | 0 | * | 0 | * | 57 | 63 | * | 15 | 120 | 102 | 0 | 12 | 0 | 0 | 57 | 63 | 15 | 120 | ||||||||||||||||||||||||||||||||
2757705 | 2757705 | CT | school | 901800 | 600011 | Guilford School District | 90180000332 | 606111 | Guilford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 903 | * | 93 | 0 | 53 | * | 37 | 569 | * | * | 118 | 1104 | 903 | 93 | 0 | 53 | 37 | 569 | 118 | 1104 | |||||||||||||||||||||||||||||||||
2758214 | 2758214 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700749 | 2156212 | Pomperaug Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 966 | 21 | 69 | * | 57 | * | 26 | 565 | 580 | * | 192 | 1145 | 966 | 21 | 69 | 57 | 26 | 565 | 580 | 192 | 1145 | ||||||||||||||||||||||||||||||||
2757346 | 2757346 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000053 | 154011 | Blackham School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 166 | 265 | 543 | 13 | 31 | * | * | 562 | 468 | 260 | 143 | 1030 | 166 | 265 | 543 | 13 | 31 | 562 | 468 | 260 | 143 | 1030 | |||||||||||||||||||||||||||||||
2757556 | 2757556 | CT | school | 901290 | 440011 | East Haven School District | 90129001350 | 441811 | Overbrook Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 55 | * | 36 | 0 | 7 | 0 | * | 56 | 51 | 0 | * | 107 | 55 | 36 | 0 | 7 | 0 | 56 | 51 | 0 | 107 | ||||||||||||||||||||||||||||||||
2758350 | 2758350 | CT | school | 1350011 | Stamford School District | 90432001744 | 1350411 | Anchor | Program | 2021 | pk_12_total | * | 30 | 46 | 0 | 0 | 0 | * | 56 | 40 | 20 | 51 | 96 | 30 | 46 | 0 | 0 | 0 | 56 | 40 | 20 | 51 | 96 | |||||||||||||||||||||||||||||||||||||
2757348 | 2757348 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000070 | 151411 | Cesar Batalla School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 79 | 218 | 721 | * | 16 | * | 10 | 558 | 494 | 500 | 163 | 1052 | 79 | 218 | 721 | 16 | 10 | 558 | 494 | 500 | 163 | 1052 | |||||||||||||||||||||||||||||||
2758595 | 2758595 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001068 | 1596111 | Wethersfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 778 | 54 | 207 | * | 52 | * | 28 | 557 | 566 | 41 | 144 | 1123 | 778 | 54 | 207 | 52 | 28 | 557 | 566 | 41 | 144 | 1123 | |||||||||||||||||||||||||||||||
2758296 | 2758296 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000827 | 1325111 | Timothy Edwards School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 535 | 78 | 102 | * | 308 | 0 | * | 554 | 525 | 30 | 129 | 1079 | 535 | 78 | 102 | 308 | 0 | 554 | 525 | 30 | 129 | 1079 | |||||||||||||||||||||||||||||||
2758324 | 2758324 | CT | school | 904290 | 1340011 | Stafford School District | 90429000847 | 1340311 | Staffordville School | Public Schools | Regular School | No | Elementary | PK | 01 | 2021 | pk_12_total | 101 | 0 | * | 0 | 0 | 0 | * | 55 | 58 | 0 | 14 | 113 | 101 | 0 | 0 | 0 | 0 | 55 | 58 | 0 | 14 | 113 | |||||||||||||||||||||||||||||||
2758714 | 2758714 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201145 | 9001616 | Howell Cheney Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2021 | pk_12_total | 342 | 63 | 207 | * | * | 0 | 52 | 549 | 129 | 13 | 108 | 678 | 342 | 63 | 207 | 0 | 52 | 549 | 129 | 13 | 108 | 678 | |||||||||||||||||||||||||||||||
2757508 | 2757508 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 312 | 82 | 534 | * | 59 | 0 | * | 541 | 482 | 177 | 165 | 1023 | 312 | 82 | 534 | 59 | 0 | 541 | 482 | 177 | 165 | 1023 | |||||||||||||||||||||||||||||||
2757373 | 2757373 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 53 | 316 | 516 | * | 9 | 0 | * | 540 | 364 | 202 | 272 | 904 | 53 | 316 | 516 | 9 | 0 | 540 | 364 | 202 | 272 | 904 | |||||||||||||||||||||||||||||||
2757509 | 2757509 | CT | school | 901020 | 340011 | Danbury School District | 90102000160 | 345211 | Rogers Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 266 | 84 | 646 | 0 | 41 | * | * | 540 | 528 | 370 | 144 | 1068 | 266 | 84 | 646 | 0 | 41 | 540 | 528 | 370 | 144 | 1068 | |||||||||||||||||||||||||||||||
2757584 | 2757584 | CT | school | 2420014 | EdAdvance | 90351200575 | 2428014 | EdAdvance Headstart | Program | 2021 | pk_12_total | 61 | 6 | 54 | * | * | 0 | * | 54 | 79 | 0 | * | 133 | 61 | 6 | 54 | 0 | 54 | 79 | 0 | 133 | |||||||||||||||||||||||||||||||||||||||
2757938 | 2757938 | CT | school | 880011 | Naugatuck School District | 90264001384 | 888111 | Head Start | Program | 2021 | pk_12_total | 49 | 22 | 29 | 0 | * | 0 | * | 54 | 57 | * | 17 | 111 | 49 | 22 | 29 | 0 | 0 | 54 | 57 | 17 | 111 | ||||||||||||||||||||||||||||||||||||||
2758658 | 2758658 | CT | school | 2440014 | Area Cooperative Educational Services | 2440114 | CREATE at Whitney Academy | Program | 2021 | pk_12_total | 22 | 19 | 23 | 0 | * | 0 | * | 54 | 13 | * | 67 | 67 | 22 | 19 | 23 | 0 | 0 | 54 | 13 | 67 | 67 | |||||||||||||||||||||||||||||||||||||||
2758633 | 2758633 | CT | school | 905220 | 1640011 | Windsor School District | 90522001096 | 1646111 | Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 271 | 500 | 205 | * | 32 | * | 73 | 537 | 547 | 29 | 185 | 1084 | 271 | 500 | 205 | 32 | 73 | 537 | 547 | 29 | 185 | 1084 | |||||||||||||||||||||||||||||||
2757412 | 2757412 | CT | school | 900510 | 170011 | Bristol School District | 90051000093 | 176211 | Bristol Eastern High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 658 | 86 | 274 | * | 43 | * | 42 | 535 | 573 | 45 | 226 | 1108 | 658 | 86 | 274 | 43 | 42 | 535 | 573 | 45 | 226 | 1108 | |||||||||||||||||||||||||||||||
2757833 | 2757833 | CT | school | 902280 | 760011 | Madison School District | 90228000411 | 766111 | Daniel Hand High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 829 | * | 51 | * | 35 | 0 | 37 | 535 | * | * | 113 | 958 | 829 | 51 | 35 | 0 | 37 | 535 | 113 | 958 | |||||||||||||||||||||||||||||||||
2757371 | 2757371 | CT | school | 150011 | Bridgeport School District | 90045001472 | 159011 | Bridgeport Learning Center | Program | 2021 | pk_12_total | 0 | 37 | * | 0 | * | 0 | 0 | 53 | 8 | 6 | 61 | 61 | 0 | 37 | 0 | 0 | 0 | 53 | 8 | 6 | 61 | 61 | |||||||||||||||||||||||||||||||||||||
2758646 | 2758646 | 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 | pk_12_total | 12 | 597 | 502 | * | 9 | * | * | 527 | 600 | 130 | 106 | 1127 | 12 | 597 | 502 | 9 | 527 | 600 | 130 | 106 | 1127 | ||||||||||||||||||||||||||||||||
2758385 | 2758385 | CT | school | 904440 | 1380011 | Stratford School District | 90444000897 | 1386111 | Stratford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 365 | 270 | 354 | 0 | 30 | 0 | 32 | 525 | 526 | 51 | 128 | 1051 | 365 | 270 | 354 | 0 | 30 | 0 | 32 | 525 | 526 | 51 | 128 | 1051 | |||||||||||||||||||||||||||||
2758731 | 2758731 | 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 | pk_12_total | 900 | 18 | 38 | * | 73 | 0 | * | 523 | * | * | 74 | 1044 | 900 | 18 | 38 | 73 | 0 | 523 | 74 | 1044 | |||||||||||||||||||||||||||||||||
2758226 | 2758226 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 85 | * | * | 0 | * | 0 | * | 52 | 43 | 0 | 17 | 95 | 85 | 0 | 0 | 52 | 43 | 0 | 17 | 95 | |||||||||||||||||||||||||||||||||
2758294 | 2758294 | CT | school | 1320011 | South Windsor School District | 1320511 | Preschool Outreach Program | Program | 2021 | pk_12_total | 40 | * | 12 | 0 | 17 | 0 | * | 52 | 24 | 0 | 57 | 76 | 40 | 12 | 0 | 17 | 0 | 52 | 24 | 0 | 57 | 76 | ||||||||||||||||||||||||||||||||||||||
2757927 | 2757927 | CT | school | 902550 | 850011 | Monroe School District | 90255000489 | 856111 | Masuk High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 815 | * | 109 | * | 59 | 0 | 31 | 518 | * | 8 | 134 | 1033 | 815 | 109 | 59 | 0 | 31 | 518 | 8 | 134 | 1033 | ||||||||||||||||||||||||||||||||
2757569 | 2757569 | CT | school | 901320 | 450011 | East Lyme School District | 90132000223 | 456111 | East Lyme High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 770 | 15 | 67 | * | 96 | * | 59 | 517 | 493 | * | 124 | 1010 | 770 | 15 | 67 | 96 | 59 | 517 | 493 | 124 | 1010 | ||||||||||||||||||||||||||||||||
2758410 | 2758410 | CT | school | 904590 | 1430011 | Torrington School District | 90459000925 | 1435111 | Torrington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 550 | 40 | 318 | * | 44 | * | 34 | 516 | * | 77 | 170 | 988 | 550 | 40 | 318 | 44 | 34 | 516 | 77 | 170 | 988 | ||||||||||||||||||||||||||||||||
2758718 | 2758718 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201149 | 9002616 | Platt Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2021 | pk_12_total | 297 | 123 | 364 | * | 9 | * | 27 | 516 | * | 22 | 115 | 824 | 297 | 123 | 364 | 9 | 27 | 516 | 22 | 115 | 824 | ||||||||||||||||||||||||||||||||
2757483 | 2757483 | CT | school | 900930 | 310011 | Cornwall School District | 90093000140 | 310111 | Cornwall Consolidated School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 83 | * | 12 | 0 | 7 | 0 | * | 51 | 53 | * | 11 | 104 | 83 | 12 | 0 | 7 | 0 | 51 | 53 | 11 | 104 | ||||||||||||||||||||||||||||||||
2757697 | 2757697 | CT | school | 901770 | 590011 | Groton School District | 90177000318 | 596111 | Robert E. Fitch High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 515 | 92 | 205 | * | 62 | * | 94 | 509 | 473 | 29 | 149 | 982 | 515 | 92 | 205 | 62 | 94 | 509 | 473 | 29 | 149 | 982 | |||||||||||||||||||||||||||||||
2758564 | 2758564 | CT | school | 904950 | 1560011 | West Haven School District | 90495001036 | 1565111 | Harry M. Bailey Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 271 | 223 | 364 | 0 | * | * | 37 | 509 | 418 | 83 | 154 | 927 | 271 | 223 | 364 | 0 | 37 | 509 | 418 | 83 | 154 | 927 | |||||||||||||||||||||||||||||||
2758648 | 2758648 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 11 | 701 | 396 | * | * | 0 | 20 | 506 | 628 | 104 | 101 | 1134 | 11 | 701 | 396 | 0 | 20 | 506 | 628 | 104 | 101 | 1134 | |||||||||||||||||||||||||||||||
2757303 | 2757303 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 634 | 53 | 65 | * | 166 | 0 | * | 500 | 457 | 8 | 97 | 957 | 634 | 53 | 65 | 166 | 0 | 500 | 457 | 8 | 97 | 957 | |||||||||||||||||||||||||||||||
2757601 | 2757601 | CT | school | 490011 | Enfield School District | 90147000207 | 498011 | Head Start Program | Program | 2021 | pk_12_total | 46 | * | 29 | 0 | * | 0 | 9 | 50 | 40 | 0 | 18 | 90 | 46 | 29 | 0 | 0 | 9 | 50 | 40 | 0 | 18 | 90 | |||||||||||||||||||||||||||||||||||||
2757837 | 2757837 | CT | school | 770011 | Manchester School District | 90231000519 | 778011 | Manchester Preschool Center | Program | 2021 | pk_12_total | 21 | 34 | 42 | 0 | 6 | 0 | 6 | 50 | 59 | 0 | 29 | 109 | 21 | 34 | 42 | 0 | 6 | 0 | 6 | 50 | 59 | 0 | 29 | 109 | |||||||||||||||||||||||||||||||||||
2757990 | 2757990 | CT | school | 902760 | 920011 | New Hartford School District | 90276000539 | 920111 | Bakerville Consolidated School | Public Schools | Regular School | No | Elementary | KG | 02 | 2021 | pk_12_total | 93 | 0 | * | 0 | 0 | 0 | * | 50 | 47 | * | 9 | 97 | 93 | 0 | 0 | 0 | 0 | 50 | 47 | 9 | 97 | ||||||||||||||||||||||||||||||||
2758712 | 2758712 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201143 | 9001316 | H. H. Ellis Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2021 | pk_12_total | 635 | 9 | 52 | * | * | 0 | 15 | 498 | 219 | * | 91 | 717 | 635 | 9 | 52 | 0 | 15 | 498 | 219 | 91 | 717 | ||||||||||||||||||||||||||||||||
2757876 | 2757876 | CT | school | 902400 | 800011 | Meriden School District | 90240000449 | 806211 | Orville H. Platt High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 216 | 140 | 606 | * | * | 0 | 24 | 494 | 514 | 138 | 177 | 1008 | 216 | 140 | 606 | 0 | 24 | 494 | 514 | 138 | 177 | 1008 | |||||||||||||||||||||||||||||||
2757694 | 2757694 | CT | school | 901770 | 590011 | Groton School District | 90177001938 | 591111 | Groton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 492 | 72 | 222 | * | 62 | * | 108 | 491 | 479 | 29 | 163 | 970 | 492 | 72 | 222 | 62 | 108 | 491 | 479 | 29 | 163 | 970 | |||||||||||||||||||||||||||||||
2757846 | 2757846 | CT | school | 770011 | Manchester School District | 90231000427 | 779011 | Manchester Regional Academy | Program | 2021 | pk_12_total | 20 | * | 23 | 0 | 0 | 0 | * | 49 | 14 | 0 | 53 | 63 | 20 | 23 | 0 | 0 | 0 | 49 | 14 | 0 | 53 | 63 | |||||||||||||||||||||||||||||||||||||
2758193 | 2758193 | CT | school | 903530 | 2120012 | Regional School District 12 | 90353000735 | 2120412 | Washington Primary School | Regional Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 96 | 0 | * | 0 | 0 | 0 | * | 49 | 66 | * | 14 | 115 | 96 | 0 | 0 | 0 | 0 | 49 | 66 | 14 | 115 | ||||||||||||||||||||||||||||||||
2758663 | 2758663 | CT | school | 900870 | 290011 | Colebrook School District | 90087000138 | 290111 | Colebrook Consolidated School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 69 | 0 | * | 0 | 0 | 0 | * | 49 | 26 | 0 | 20 | 75 | 69 | 0 | 0 | 0 | 0 | 49 | 26 | 0 | 20 | 75 | |||||||||||||||||||||||||||||||
2758382 | 2758382 | CT | school | 904440 | 1380011 | Stratford School District | 90444000885 | 1386211 | Bunnell High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 393 | 237 | 330 | 0 | 32 | 0 | 30 | 489 | 533 | 24 | 107 | 1022 | 393 | 237 | 330 | 0 | 32 | 0 | 30 | 489 | 533 | 24 | 107 | 1022 | |||||||||||||||||||||||||||||
2758728 | 2758728 | CT | school | 900005 | 2190012 | Regional School District 19 | 90000501215 | 2196112 | E. O. Smith High School | Regional Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 794 | * | 114 | 0 | 43 | * | 95 | 487 | 576 | 7 | 153 | 1063 | 794 | 114 | 0 | 43 | 95 | 487 | 576 | 7 | 153 | 1063 | |||||||||||||||||||||||||||||||
2757318 | 2757318 | CT | school | 900270 | 90011 | Bethel School District | 90027000024 | 96111 | Bethel High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 628 | 32 | 183 | * | 79 | * | 10 | 485 | 450 | 27 | 129 | 935 | 628 | 32 | 183 | 79 | 10 | 485 | 450 | 27 | 129 | 935 | |||||||||||||||||||||||||||||||
2758096 | 2758096 | CT | school | 903030 | 1010011 | North Haven School District | 90303000631 | 1016111 | North Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 723 | 40 | 87 | 0 | 68 | 0 | 31 | 485 | 464 | 11 | 113 | 949 | 723 | 40 | 87 | 0 | 68 | 0 | 31 | 485 | 464 | 11 | 113 | 949 | |||||||||||||||||||||||||||||
2758506 | 2758506 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000991 | 1515211 | West Side Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 152 | 206 | 510 | 8 | 16 | 0 | 43 | 483 | 452 | 102 | 170 | 935 | 152 | 206 | 510 | 8 | 16 | 0 | 43 | 483 | 452 | 102 | 170 | 935 | |||||||||||||||||||||||||||||
2757442 | 2757442 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001513 | 2415114 | Academy of Aerospace and Engineering | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 125 | 253 | 304 | * | 68 | 0 | * | 479 | 297 | 38 | 130 | 776 | 125 | 253 | 304 | 68 | 0 | 479 | 297 | 38 | 130 | 776 | |||||||||||||||||||||||||||||||
2757772 | 2757772 | CT | school | 901920 | 640011 | Hartford School District | 90192001295 | 645411 | Hartford Magnet Trinity College Academy | Public Schools | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 144 | 261 | 531 | * | 39 | * | 43 | 473 | 553 | 105 | 139 | 1026 | 144 | 261 | 531 | 39 | 43 | 473 | 553 | 105 | 139 | 1026 | |||||||||||||||||||||||||||||||
2757843 | 2757843 | CT | school | 902310 | 770011 | Manchester School District | 90231001533 | 771711 | Elisabeth M. Bennet Academy | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 301 | 218 | 300 | * | 50 | * | 14 | 473 | 416 | 48 | 139 | 889 | 301 | 218 | 300 | 50 | 14 | 473 | 416 | 48 | 139 | 889 | |||||||||||||||||||||||||||||||
2757311 | 2757311 | CT | school | 900210 | 70011 | Berlin School District | 90021000016 | 76111 | Berlin High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 716 | * | 102 | * | 36 | 0 | 32 | 469 | 434 | 10 | 119 | 903 | 716 | 102 | 36 | 0 | 32 | 469 | 434 | 10 | 119 | 903 | |||||||||||||||||||||||||||||||
2758456 | 2758456 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000955 | 1486111 | Lyman Hall High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 719 | * | 191 | * | 45 | 0 | 37 | 467 | 550 | 17 | 170 | 1017 | 719 | 191 | 45 | 0 | 37 | 467 | 550 | 17 | 170 | 1017 | |||||||||||||||||||||||||||||||
2757383 | 2757383 | CT | school | 900510 | 170011 | Bristol School District | 90051000098 | 170511 | Greene-Hills School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 454 | 69 | 295 | * | * | 0 | 40 | 463 | 435 | 54 | 120 | 898 | 454 | 69 | 295 | 0 | 40 | 463 | 435 | 54 | 120 | 898 | |||||||||||||||||||||||||||||||
2757971 | 2757971 | CT | school | 902670 | 890011 | New Britain School District | 90267000518 | 895311 | Pulaski Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 171 | 83 | 598 | 0 | 22 | 0 | 23 | 462 | 435 | 205 | 168 | 897 | 171 | 83 | 598 | 0 | 22 | 0 | 23 | 462 | 435 | 205 | 168 | 897 | |||||||||||||||||||||||||||||
2757989 | 2757989 | CT | school | 902760 | 920011 | New Hartford School District | 90276000540 | 920211 | New Hartford Elementary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 66 | * | * | 0 | * | 0 | * | 46 | 28 | 0 | 17 | 74 | 66 | 0 | 0 | 46 | 28 | 0 | 17 | 74 | |||||||||||||||||||||||||||||||||
2758549 | 2758549 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 510 | 80 | 147 | * | 86 | * | 46 | 459 | 412 | 35 | 123 | 871 | 510 | 80 | 147 | 86 | 46 | 459 | 412 | 35 | 123 | 871 | |||||||||||||||||||||||||||||||
2757419 | 2757419 | CT | school | 900540 | 180011 | Brookfield School District | 90054000109 | 186111 | Brookfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 687 | 22 | 109 | * | 77 | * | * | 458 | 444 | 13 | 138 | 902 | 687 | 22 | 109 | 77 | 458 | 444 | 13 | 138 | 902 | ||||||||||||||||||||||||||||||||
2757782 | 2757782 | CT | school | 901920 | 640011 | Hartford School District | 90192001925 | 646211 | Hartford Public High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 28 | 237 | 544 | * | 29 | * | * | 458 | 386 | 280 | 174 | 844 | 28 | 237 | 544 | 29 | 458 | 386 | 280 | 174 | 844 | ||||||||||||||||||||||||||||||||
2758690 | 2758690 | CT | school | 903750 | 2080012 | Regional School District 08 | 90375000772 | 2086112 | RHAM High School | Regional Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 808 | 8 | 49 | * | 20 | * | * | 456 | * | * | 111 | 889 | 808 | 8 | 49 | 20 | 456 | 111 | 889 | ||||||||||||||||||||||||||||||||||
2757679 | 2757679 | CT | school | 901710 | 570011 | Greenwich School District | 90171000298 | 575211 | Eastern Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 555 | * | 114 | * | 102 | 0 | 53 | 453 | 384 | 11 | 97 | 837 | 555 | 114 | 102 | 0 | 53 | 453 | 384 | 11 | 97 | 837 | |||||||||||||||||||||||||||||||
2758600 | 2758600 | CT | school | 905130 | 1610011 | Wilton School District | 90513001073 | 1615211 | Middlebrook School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 697 | * | 65 | 0 | 100 | 0 | * | 453 | 467 | * | 143 | 920 | 697 | 65 | 0 | 100 | 0 | 453 | 467 | 143 | 920 | ||||||||||||||||||||||||||||||||
2758411 | 2758411 | CT | school | 904590 | 1430011 | Torrington School District | 90459000924 | 1436111 | Torrington High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 444 | 55 | 301 | * | 49 | * | 33 | 452 | * | 74 | 156 | 888 | 444 | 55 | 301 | 49 | 33 | 452 | 74 | 156 | 888 | ||||||||||||||||||||||||||||||||
2757475 | 2757475 | CT | school | 2430014 | Cooperative Educational Services | 90091001561 | 2439114 | Preschool-Primary Learning Center (PLC) | Program | 2021 | pk_12_total | 16 | 15 | 17 | 0 | * | * | * | 45 | 10 | 0 | 55 | 55 | 16 | 15 | 17 | 0 | 45 | 10 | 0 | 55 | 55 | ||||||||||||||||||||||||||||||||||||||
2757511 | 2757511 | CT | school | 340011 | Danbury School District | 90102001129 | 346211 | Alternative Center For Excellence | Program | 2021 | pk_12_total | 27 | 8 | 35 | 0 | * | 0 | * | 45 | 35 | * | 21 | 80 | 27 | 8 | 35 | 0 | 0 | 45 | 35 | 21 | 80 | ||||||||||||||||||||||||||||||||||||||
2758724 | 2758724 | CT | school | 900018 | 2720013 | Explorations District | 90001800834 | 2726113 | Explorations | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 68 | * | 13 | 0 | 0 | 0 | * | 45 | * | 0 | 33 | 86 | 68 | 13 | 0 | 0 | 0 | 45 | 0 | 33 | 86 |
Advanced export
JSON shape: default, array, newline-delimited
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]);