enrollments
Data source: Big Local News · About: Big Local
20,216 rows where state = "CT" and year = 2021 sorted by ell 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2757424 | 2757424 | CT | school | 900690 | 230011 | Canton School District | 90069000120 | 230211 | Cherry Brook Primary School | Public Schools | Regular School | No | Elementary | PK | 03 | 2021 | pk_12_total | 359 | 23 | 26 | 0 | * | * | 17 | 230 | 205 | 6 | 46 | 435 | 359 | 23 | 26 | 0 | 17 | 230 | 205 | 6 | 46 | 435 | |||||||||||||||||||||||||||||||
2757460 | 2757460 | CT | school | 900750 | 250011 | Cheshire School District | 90075000125 | 255111 | Dodd Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 481 | 21 | 44 | * | 70 | 0 | * | 308 | 325 | 6 | 67 | 633 | 481 | 21 | 44 | 70 | 0 | 308 | 325 | 6 | 67 | 633 | |||||||||||||||||||||||||||||||
2757485 | 2757485 | CT | school | 900960 | 320011 | Coventry School District | 90096000142 | 320211 | Coventry Grammar School | Public Schools | Regular School | No | Elementary | KG | 02 | 2021 | pk_12_total | 293 | * | 16 | 0 | * | 0 | 15 | 148 | 180 | 6 | 27 | 328 | 293 | 16 | 0 | 0 | 15 | 148 | 180 | 6 | 27 | 328 | |||||||||||||||||||||||||||||||
2757524 | 2757524 | CT | school | 901110 | 370011 | Derby School District | 90111001578 | 375011 | Derby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 113 | 64 | 115 | 0 | 8 | 0 | 22 | 178 | 144 | 6 | 66 | 322 | 113 | 64 | 115 | 0 | 8 | 0 | 22 | 178 | 144 | 6 | 66 | 322 | |||||||||||||||||||||||||||||
2757598 | 2757598 | CT | school | 900216 | 2910013 | Elm City Montessori School District | 90021601683 | 2910113 | Elm City Montessori School | Public Charter Schools | Regular School | Yes | Elementary | PK | 06 | 2021 | pk_12_total | 78 | 99 | 62 | 0 | * | 0 | * | 130 | 129 | 6 | 16 | 259 | 78 | 99 | 62 | 0 | 0 | 130 | 129 | 6 | 16 | 259 | |||||||||||||||||||||||||||||||
2757621 | 2757621 | CT | school | 901500 | 500011 | Essex School District | 90150000255 | 500111 | Essex Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 265 | * | 25 | 0 | * | 0 | 13 | 159 | 152 | 6 | 53 | 311 | 265 | 25 | 0 | 0 | 13 | 159 | 152 | 6 | 53 | 311 | |||||||||||||||||||||||||||||||
2757634 | 2757634 | CT | school | 901530 | 510011 | Fairfield School District | 90153000270 | 511411 | Stratfield School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 266 | 8 | 41 | 0 | 8 | 0 | 15 | 171 | 167 | 6 | 37 | 338 | 266 | 8 | 41 | 0 | 8 | 0 | 15 | 171 | 167 | 6 | 37 | 338 | |||||||||||||||||||||||||||||
2757638 | 2757638 | CT | school | 901530 | 510011 | Fairfield School District | 90153001379 | 516011 | Fairfield Ludlowe High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1243 | 28 | 139 | 0 | 85 | 0 | 51 | 749 | 797 | 6 | 195 | 1546 | 1243 | 28 | 139 | 0 | 85 | 0 | 51 | 749 | 797 | 6 | 195 | 1546 | |||||||||||||||||||||||||||||
2757692 | 2757692 | CT | school | 901770 | 590011 | Groton School District | 90177000313 | 591811 | Charles Barnum School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 207 | 21 | 78 | * | 6 | * | 33 | 172 | 179 | 6 | 52 | 351 | 207 | 21 | 78 | 6 | 33 | 172 | 179 | 6 | 52 | 351 | |||||||||||||||||||||||||||||||
2757814 | 2757814 | CT | school | 902130 | 710011 | Lebanon School District | 90213000395 | 710111 | Lebanon Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 286 | * | 30 | * | * | * | 7 | 189 | 146 | 6 | 61 | 335 | 286 | 30 | 7 | 189 | 146 | 6 | 61 | 335 | |||||||||||||||||||||||||||||||||
2757817 | 2757817 | CT | school | 902160 | 720011 | Ledyard School District | 90216000398 | 720411 | Gallup Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 427 | 19 | 55 | 27 | * | * | 29 | 311 | 266 | 6 | 100 | 577 | 427 | 19 | 55 | 27 | 29 | 311 | 266 | 6 | 100 | 577 | |||||||||||||||||||||||||||||||
2757820 | 2757820 | CT | school | 902160 | 720011 | Ledyard School District | 90216000402 | 725111 | Ledyard Middle School | Public Schools | Regular School | No | Middle | 06 | 10 | 2021 | pk_12_total | 378 | 20 | 46 | * | 17 | * | 41 | 266 | 249 | 6 | 107 | 515 | 378 | 20 | 46 | 17 | 41 | 266 | 249 | 6 | 107 | 515 | |||||||||||||||||||||||||||||||
2757879 | 2757879 | CT | school | 800011 | Meriden School District | 801911 | TLC - PHS | Program | 2021 | pk_12_total | * | * | 10 | 0 | * | 0 | 0 | 13 | 6 | 6 | 19 | 19 | 10 | 0 | 0 | 0 | 13 | 6 | 6 | 19 | 19 | |||||||||||||||||||||||||||||||||||||||
2757899 | 2757899 | CT | school | 902490 | 830011 | Middletown School District | 90249000456 | 831511 | Keigwin Middle School | Public Schools | Regular School | No | Middle | 06 | 06 | 2021 | pk_12_total | 132 | 52 | 63 | * | * | * | 35 | 149 | 140 | 6 | 42 | 289 | 132 | 52 | 63 | 35 | 149 | 140 | 6 | 42 | 289 | ||||||||||||||||||||||||||||||||
2757917 | 2757917 | CT | school | 902520 | 840011 | Milford School District | 90252000474 | 845311 | West Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 287 | 25 | 69 | * | 54 | * | * | 223 | 218 | 6 | 64 | 441 | 287 | 25 | 69 | 54 | 223 | 218 | 6 | 64 | 441 | ||||||||||||||||||||||||||||||||
2757924 | 2757924 | CT | school | 902550 | 850011 | Monroe School District | 90255000488 | 850511 | Fawn Hollow Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 444 | 13 | 75 | * | 35 | * | 21 | 287 | 303 | 6 | 61 | 590 | 444 | 13 | 75 | 35 | 21 | 287 | 303 | 6 | 61 | 590 | |||||||||||||||||||||||||||||||
2757926 | 2757926 | CT | school | 902550 | 850011 | Monroe School District | 90255000920 | 855211 | Jockey Hollow School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 577 | 18 | 103 | 0 | 48 | 0 | 26 | 379 | 393 | 6 | 107 | 772 | 577 | 18 | 103 | 0 | 48 | 0 | 26 | 379 | 393 | 6 | 107 | 772 | |||||||||||||||||||||||||||||
2758003 | 2758003 | CT | school | 902790 | 930011 | New Haven School District | 90279000551 | 930911 | Davis Academy for Arts & Design Innovation | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 80 | 293 | 99 | * | * | 0 | 15 | 247 | 251 | 6 | 42 | 498 | 80 | 293 | 99 | 0 | 15 | 247 | 251 | 6 | 42 | 498 | |||||||||||||||||||||||||||||||
2758046 | 2758046 | CT | school | 930011 | New Haven School District | 90279001550 | 939111 | Riverside Education Academy | Program | 2021 | pk_12_total | * | 67 | * | 0 | 0 | 0 | 0 | 69 | 37 | 6 | 48 | 106 | 67 | 0 | 0 | 0 | 0 | 69 | 37 | 6 | 48 | 106 | |||||||||||||||||||||||||||||||||||||
2758085 | 2758085 | CT | school | 902970 | 990011 | North Branford School District | 90297000620 | 990411 | Jerome Harrison School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 314 | * | 33 | 0 | * | 0 | 14 | * | 195 | 6 | 37 | 368 | 314 | 33 | 0 | 0 | 14 | 195 | 6 | 37 | 368 | ||||||||||||||||||||||||||||||||
2758169 | 2758169 | CT | school | 903330 | 1110011 | Plymouth School District | 90333001199 | 1116111 | Terryville High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 317 | * | 35 | * | 12 | 0 | 11 | 204 | * | 6 | 58 | 382 | 317 | 35 | 12 | 0 | 11 | 204 | 6 | 58 | 382 | ||||||||||||||||||||||||||||||||
2758180 | 2758180 | CT | school | 903480 | 1160011 | Putnam School District | 90348000719 | 1166111 | Putnam High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 200 | * | 36 | 0 | * | * | 10 | 120 | 134 | 6 | 53 | 254 | 200 | 36 | 0 | 10 | 120 | 134 | 6 | 53 | 254 | ||||||||||||||||||||||||||||||||
2758191 | 2758191 | CT | school | 903520 | 2100012 | Regional School District 10 | 90352000727 | 2105112 | Har-Bur Middle School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 562 | * | 29 | 0 | * | 0 | 114 | 375 | 335 | 6 | 96 | 710 | 562 | 29 | 0 | 0 | 114 | 375 | 335 | 6 | 96 | 710 | |||||||||||||||||||||||||||||||
2758209 | 2758209 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353701116 | 2150412 | Gainfield Elementary School | Regional Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 294 | * | 29 | * | 11 | 0 | 10 | 173 | 181 | 6 | 47 | 354 | 294 | 29 | 11 | 0 | 10 | 173 | 181 | 6 | 47 | 354 | |||||||||||||||||||||||||||||||
2758227 | 2758227 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000762 | 2180112 | Lyme Consolidated School | Regional Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 170 | * | 12 | 0 | * | 0 | 10 | 105 | 91 | 6 | 23 | 196 | 170 | 12 | 0 | 0 | 10 | 105 | 91 | 6 | 23 | 196 | |||||||||||||||||||||||||||||||
2758230 | 2758230 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000763 | 2186112 | Lyme-Old Lyme High School | Regional Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 402 | * | 25 | 0 | 12 | 0 | * | 220 | 230 | 6 | 44 | 450 | 402 | 25 | 0 | 12 | 0 | 220 | 230 | 6 | 44 | 450 | |||||||||||||||||||||||||||||||
2758234 | 2758234 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000781 | 1180211 | Veterans Park Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 171 | * | 21 | 0 | 22 | 0 | * | 113 | 120 | 6 | 23 | 233 | 171 | 21 | 0 | 22 | 0 | 113 | 120 | 6 | 23 | 233 | |||||||||||||||||||||||||||||||
2758235 | 2758235 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000780 | 1180511 | Scotland Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 274 | * | 22 | * | 14 | 0 | 15 | 160 | 168 | 6 | 36 | 328 | 274 | 22 | 14 | 0 | 15 | 160 | 168 | 6 | 36 | 328 | |||||||||||||||||||||||||||||||
2758236 | 2758236 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000525 | 1180611 | Branchville Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 289 | * | 22 | * | 16 | 0 | 10 | 163 | 176 | 6 | 51 | 339 | 289 | 22 | 16 | 0 | 10 | 163 | 176 | 6 | 51 | 339 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2758281 | 2758281 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000810 | 1280111 | Central School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 262 | * | 43 | * | 35 | 0 | 16 | 197 | 177 | 6 | 33 | 374 | 262 | 43 | 35 | 0 | 16 | 197 | 177 | 6 | 33 | 374 | |||||||||||||||||||||||||||||||
2758392 | 2758392 | CT | school | 904500 | 1400011 | Thomaston School District | 90450001117 | 1400211 | Thomaston Center School | Public Schools | Regular School | No | Middle | 04 | 06 | 2021 | pk_12_total | 169 | * | 15 | * | * | 0 | * | 102 | 94 | 6 | 29 | 196 | 169 | 15 | 0 | 102 | 94 | 6 | 29 | 196 | |||||||||||||||||||||||||||||||||
2758393 | 2758393 | CT | school | 904500 | 1400011 | Thomaston School District | 90450000908 | 1406211 | Thomaston High School | Public Schools | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 308 | * | 23 | 0 | * | * | 7 | 153 | 191 | 6 | 43 | 344 | 308 | 23 | 0 | 7 | 153 | 191 | 6 | 43 | 344 | ||||||||||||||||||||||||||||||||
2758484 | 2758484 | CT | school | 1510011 | Waterbury School District | 1513511 | Generali Autism | Program | 2021 | pk_12_total | * | 12 | 18 | 0 | * | 0 | * | 30 | 7 | 6 | * | 37 | 12 | 18 | 0 | 0 | 30 | 7 | 6 | 37 | ||||||||||||||||||||||||||||||||||||||||
2758580 | 2758580 | CT | school | 905040 | 1580011 | Westport School District | 90504001055 | 1580511 | King's Highway Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 329 | 19 | 36 | 0 | 28 | 0 | 38 | 222 | 228 | 6 | 49 | 450 | 329 | 19 | 36 | 0 | 28 | 0 | 38 | 222 | 228 | 6 | 49 | 450 | |||||||||||||||||||||||||||||
2758587 | 2758587 | CT | school | 1590011 | Wethersfield School District | 1590411 | ABA | Program | 2021 | pk_12_total | * | * | 10 | 0 | * | 0 | * | 9 | 9 | 6 | 18 | 18 | 10 | 0 | 0 | 9 | 9 | 6 | 18 | 18 | ||||||||||||||||||||||||||||||||||||||||
2758597 | 2758597 | CT | school | 905100 | 1600011 | Willington School District | 90510001069 | 1600111 | Center School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 177 | * | 20 | 0 | * | 0 | 0 | 110 | 92 | 6 | 37 | 202 | 177 | 20 | 0 | 0 | 0 | 110 | 92 | 6 | 37 | 202 | |||||||||||||||||||||||||||||||
2758605 | 2758605 | CT | school | 905160 | 1620011 | Winchester School District | 90516001077 | 1620411 | Batcheller Early Education Center | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 213 | * | 21 | 0 | * | * | 9 | * | 132 | 6 | 53 | 249 | 213 | 21 | 0 | 9 | 132 | 6 | 53 | 249 | |||||||||||||||||||||||||||||||||
2758710 | 2758710 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201141 | 9002516 | Emmett O'Brien Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2021 | pk_12_total | 391 | 48 | 213 | 0 | * | * | 29 | 415 | 277 | 6 | 81 | 692 | 391 | 48 | 213 | 0 | 29 | 415 | 277 | 6 | 81 | 692 | |||||||||||||||||||||||||||||||
2757512 | 2757512 | CT | school | 901020 | 340011 | Danbury School District | 90102000150 | 346111 | Danbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1066 | 278 | 1692 | * | 224 | * | 73 | 1737 | 1603 | 597 | 454 | 3340 | 1066 | 278 | 1692 | 224 | 73 | 1737 | 1603 | 597 | 454 | 3340 | |||||||||||||||||||||||||||||||
2757806 | 2757806 | CT | school | 903450 | 2450014 | Learn | 90345000079 | 2450114 | Regional Multicultural Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 132 | 70 | 210 | * | 7 | * | 64 | 234 | 254 | 59 | 71 | 488 | 132 | 70 | 210 | 7 | 64 | 234 | 254 | 59 | 71 | 488 | |||||||||||||||||||||||||||||||
2757316 | 2757316 | CT | school | 900270 | 90011 | Bethel School District | 90027001118 | 90511 | Ralph M. T. Johnson School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 430 | 24 | 153 | * | 49 | * | 28 | 361 | 334 | 58 | 75 | 695 | 430 | 24 | 153 | 49 | 28 | 361 | 334 | 58 | 75 | 695 | |||||||||||||||||||||||||||||||
2757336 | 2757336 | CT | school | 900420 | 140011 | Branford School District | 90042000042 | 141411 | Mary T. Murphy School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 190 | 18 | 60 | * | 37 | 0 | * | 169 | 156 | 58 | 43 | 325 | 190 | 18 | 60 | 37 | 0 | 169 | 156 | 58 | 43 | 325 | |||||||||||||||||||||||||||||||
2757951 | 2757951 | CT | school | 902670 | 890011 | New Britain School District | 90267000512 | 890511 | Gaffney Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 82 | 31 | 259 | 0 | 11 | 0 | 35 | 211 | 207 | 58 | 83 | 418 | 82 | 31 | 259 | 0 | 11 | 0 | 35 | 211 | 207 | 58 | 83 | 418 | |||||||||||||||||||||||||||||
2758471 | 2758471 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000986 | 1512011 | Sprague School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 31 | 78 | 264 | 0 | 0 | 0 | 15 | 192 | 196 | 58 | 44 | 388 | 31 | 78 | 264 | 0 | 0 | 0 | 15 | 192 | 196 | 58 | 44 | 388 | |||||||||||||||||||||||||||||
2758488 | 2758488 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000978 | 1511311 | Hopeville School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 38 | 64 | 205 | * | * | 0 | 13 | 157 | 168 | 58 | 42 | 325 | 38 | 64 | 205 | 0 | 13 | 157 | 168 | 58 | 42 | 325 | |||||||||||||||||||||||||||||||
2757726 | 2757726 | CT | school | 901860 | 620011 | Hamden School District | 90186000339 | 626111 | Hamden High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 555 | 537 | 331 | * | 107 | * | 83 | 851 | 765 | 57 | 263 | 1616 | 555 | 537 | 331 | 107 | 83 | 851 | 765 | 57 | 263 | 1616 | |||||||||||||||||||||||||||||||
2757845 | 2757845 | CT | school | 902310 | 770011 | Manchester School District | 90231000421 | 775311 | Illing Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 253 | 219 | 277 | * | 77 | * | 23 | 425 | 427 | 57 | 122 | 852 | 253 | 219 | 277 | 77 | 23 | 425 | 427 | 57 | 122 | 852 | |||||||||||||||||||||||||||||||
2758558 | 2758558 | CT | school | 904950 | 1560011 | West Haven School District | 90495001033 | 1560611 | Edith E. Mackrille School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 102 | 61 | 103 | 0 | 18 | 0 | 9 | 138 | 155 | 57 | 39 | 293 | 102 | 61 | 103 | 0 | 18 | 0 | 9 | 138 | 155 | 57 | 39 | 293 | |||||||||||||||||||||||||||||
2757571 | 2757571 | CT | school | 901350 | 470011 | East Windsor School District | 90135000228 | 470111 | Broad Brook Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 233 | 43 | 101 | 0 | 51 | 0 | 39 | 242 | 225 | 56 | 77 | 467 | 233 | 43 | 101 | 0 | 51 | 0 | 39 | 242 | 225 | 56 | 77 | 467 | |||||||||||||||||||||||||||||
2758651 | 2758651 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007000884 | 2440314 | Wintergreen Interdistrict Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 95 | 215 | 127 | * | * | 0 | 30 | 227 | 264 | 56 | 74 | 491 | 95 | 215 | 127 | 0 | 30 | 227 | 264 | 56 | 74 | 491 | |||||||||||||||||||||||||||||||
2757435 | 2757435 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001516 | 2410314 | Reggio Magnet School of the Arts | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 137 | 142 | 187 | * | * | 0 | 35 | 229 | 283 | 55 | 93 | 512 | 137 | 142 | 187 | 0 | 35 | 229 | 283 | 55 | 93 | 512 | |||||||||||||||||||||||||||||||
2757490 | 2757490 | CT | school | 900990 | 330011 | Cromwell School District | 90099000146 | 330211 | Edna C. Stevens School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 318 | 30 | 85 | 0 | 26 | 0 | 32 | 256 | 235 | 55 | 61 | 491 | 318 | 30 | 85 | 0 | 26 | 0 | 32 | 256 | 235 | 55 | 61 | 491 | |||||||||||||||||||||||||||||
2757506 | 2757506 | CT | school | 901020 | 340011 | Danbury School District | 90102001438 | 341911 | Western CT Academy of International Studies Elementary Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 157 | 32 | 118 | 0 | 29 | 0 | 10 | 187 | 159 | 55 | 29 | 346 | 157 | 32 | 118 | 0 | 29 | 0 | 10 | 187 | 159 | 55 | 29 | 346 | |||||||||||||||||||||||||||||
2757753 | 2757753 | CT | school | 901920 | 640011 | Hartford School District | 90192000383 | 642011 | Webster Micro Society Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 90 | 281 | 176 | * | 65 | 0 | * | 343 | 299 | 55 | 87 | 642 | 90 | 281 | 176 | 65 | 0 | 343 | 299 | 55 | 87 | 642 | |||||||||||||||||||||||||||||||
2757992 | 2757992 | CT | school | 902790 | 930011 | New Haven School District | 90279000568 | 931411 | Nathan Hale School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 198 | 72 | 234 | * | * | 0 | 16 | 261 | 265 | 55 | 68 | 526 | 198 | 72 | 234 | 0 | 16 | 261 | 265 | 55 | 68 | 526 | |||||||||||||||||||||||||||||||
2758068 | 2758068 | CT | school | 902880 | 940011 | Newington School District | 90288000606 | 940811 | John Paterson School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 232 | 27 | 90 | 0 | 21 | 0 | 19 | 194 | 195 | 55 | 70 | 389 | 232 | 27 | 90 | 0 | 21 | 0 | 19 | 194 | 195 | 55 | 70 | 389 | |||||||||||||||||||||||||||||
2758161 | 2758161 | CT | school | 903300 | 1100011 | Plainville School District | 90330000701 | 1100211 | Linden Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 212 | 14 | 93 | 0 | 8 | 0 | 15 | 181 | 161 | 55 | 43 | 342 | 212 | 14 | 93 | 0 | 8 | 0 | 15 | 181 | 161 | 55 | 43 | 342 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2757430 | 2757430 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001597 | 2418114 | Discovery Academy | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 144 | 78 | 244 | * | 28 | 0 | * | 260 | 262 | 54 | 54 | 522 | 144 | 78 | 244 | 28 | 0 | 260 | 262 | 54 | 54 | 522 | |||||||||||||||||||||||||||||||
2758101 | 2758101 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000645 | 1032011 | Fox Run Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 96 | 74 | 158 | 0 | 20 | * | * | 182 | 187 | 54 | 48 | 369 | 96 | 74 | 158 | 0 | 20 | 182 | 187 | 54 | 48 | 369 | |||||||||||||||||||||||||||||||
2758464 | 2758464 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000976 | 1512611 | Gilmartin School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 54 | 99 | 266 | * | 9 | * | 13 | 234 | 213 | 54 | 66 | 447 | 54 | 99 | 266 | 9 | 13 | 234 | 213 | 54 | 66 | 447 | |||||||||||||||||||||||||||||||
2758536 | 2758536 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001025 | 1551311 | Whiting Lane School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 169 | 37 | 75 | 0 | 40 | * | * | 179 | 149 | 54 | 100 | 328 | 169 | 37 | 75 | 0 | 40 | 179 | 149 | 54 | 100 | 328 | |||||||||||||||||||||||||||||||
2758672 | 2758672 | CT | school | 900011 | 2650013 | Interdistrict School for Arts and Comm District | 90001100797 | 2655113 | Interdistrict School For Arts And Communication | Public Charter Schools | Regular School | Yes | Middle | 06 | 08 | 2021 | pk_12_total | 44 | 51 | 176 | * | * | * | * | 143 | 138 | 54 | 54 | 281 | 44 | 51 | 176 | 143 | 138 | 54 | 54 | 281 | |||||||||||||||||||||||||||||||||
2757431 | 2757431 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070000072 | 2410114 | Glastonbury/East Hartford Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 80 | 116 | 190 | * | 49 | 0 | * | 237 | 228 | 53 | 71 | 465 | 80 | 116 | 190 | 49 | 0 | 237 | 228 | 53 | 71 | 465 | |||||||||||||||||||||||||||||||
2757433 | 2757433 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070000210 | 2413114 | Montessori Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 73 | 39 | 212 | 0 | 12 | 0 | 22 | 173 | 185 | 53 | 60 | 358 | 73 | 39 | 212 | 0 | 12 | 0 | 22 | 173 | 185 | 53 | 60 | 358 | |||||||||||||||||||||||||||||
2758461 | 2758461 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000970 | 1512711 | Carrington School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 103 | 101 | 225 | * | * | 0 | 26 | 233 | 236 | 53 | 60 | 469 | 103 | 101 | 225 | 0 | 26 | 233 | 236 | 53 | 60 | 469 | |||||||||||||||||||||||||||||||
2758552 | 2758552 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001013 | 1556111 | Conard High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 810 | 118 | 276 | * | 190 | * | 56 | 726 | * | 53 | 192 | 1453 | 810 | 118 | 276 | 190 | 56 | 726 | 53 | 192 | 1453 | ||||||||||||||||||||||||||||||||
2757561 | 2757561 | CT | school | 901290 | 440011 | East Haven School District | 90129000217 | 445111 | Joseph Melillo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 264 | 44 | 183 | * | 17 | 0 | * | 279 | 245 | 52 | 85 | 524 | 264 | 44 | 183 | 17 | 0 | 279 | 245 | 52 | 85 | 524 | |||||||||||||||||||||||||||||||
2757998 | 2757998 | CT | school | 902790 | 930011 | New Haven School District | 90279000544 | 931811 | Benjamin Jepson Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 66 | 126 | 275 | * | * | * | 29 | 238 | 263 | 52 | 60 | 501 | 66 | 126 | 275 | 29 | 238 | 263 | 52 | 60 | 501 | ||||||||||||||||||||||||||||||||
2758033 | 2758033 | CT | school | 902790 | 930011 | New Haven School District | 90279000588 | 933811 | Worthington Hooker School | Public Schools | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 172 | 60 | 46 | 0 | 108 | 0 | 14 | 197 | 203 | 52 | 27 | 400 | 172 | 60 | 46 | 0 | 108 | 0 | 14 | 197 | 203 | 52 | 27 | 400 | |||||||||||||||||||||||||||||
2758052 | 2758052 | CT | school | 902820 | 950011 | New London School District | 90282001685 | 950611 | Harbor Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 36 | 40 | 144 | * | 7 | * | 29 | 140 | 120 | 52 | 59 | 260 | 36 | 40 | 144 | 7 | 29 | 140 | 120 | 52 | 59 | 260 | |||||||||||||||||||||||||||||||
2758112 | 2758112 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000662 | 1032411 | Wolfpit School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 105 | 48 | 116 | * | * | 0 | 20 | 157 | 146 | 52 | 44 | 303 | 105 | 48 | 116 | 0 | 20 | 157 | 146 | 52 | 44 | 303 | |||||||||||||||||||||||||||||||
2758126 | 2758126 | CT | school | 903120 | 1040011 | Norwich School District | 90312000675 | 1041711 | Thomas W. Mahan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 73 | 35 | 52 | 0 | 66 | 0 | 12 | 131 | 107 | 52 | 34 | 238 | 73 | 35 | 52 | 0 | 66 | 0 | 12 | 131 | 107 | 52 | 34 | 238 | |||||||||||||||||||||||||||||
2758348 | 2758348 | CT | school | 904320 | 1350011 | Stamford School District | 90432000009 | 1355711 | Scofield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 214 | 75 | 276 | * | 63 | 0 | * | 317 | 326 | 52 | 54 | 643 | 214 | 75 | 276 | 63 | 0 | 317 | 326 | 52 | 54 | 643 | |||||||||||||||||||||||||||||||
2758590 | 2758590 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001064 | 1591111 | Highcrest School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 338 | 8 | 68 | 0 | 29 | 0 | 20 | 237 | 226 | 52 | 49 | 463 | 338 | 8 | 68 | 0 | 29 | 0 | 20 | 237 | 226 | 52 | 49 | 463 | |||||||||||||||||||||||||||||
2757771 | 2757771 | CT | school | 901920 | 640011 | Hartford School District | 90192001478 | 646411 | Classical Magnet School | Public Schools | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 43 | 181 | 204 | 0 | * | * | 14 | * | 253 | 51 | 69 | 452 | 43 | 181 | 204 | 0 | 14 | 253 | 51 | 69 | 452 | ||||||||||||||||||||||||||||||||
2757841 | 2757841 | CT | school | 902310 | 770011 | Manchester School District | 90231000429 | 771211 | Verplanck School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 95 | 134 | 163 | * | 32 | 0 | * | 235 | 199 | 51 | 43 | 434 | 95 | 134 | 163 | 32 | 0 | 235 | 199 | 51 | 43 | 434 | |||||||||||||||||||||||||||||||
2757956 | 2757956 | CT | school | 902670 | 890011 | New Britain School District | 90267000509 | 890311 | Chamberlain Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 48 | 40 | 294 | * | * | 0 | 21 | 215 | 197 | 51 | 69 | 412 | 48 | 40 | 294 | 0 | 21 | 215 | 197 | 51 | 69 | 412 | |||||||||||||||||||||||||||||||
2758133 | 2758133 | CT | school | 903120 | 1040011 | Norwich School District | 90312000677 | 1041811 | Veterans' Memorial School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 57 | 46 | 78 | 0 | * | * | 20 | 118 | 104 | 51 | 28 | 222 | 57 | 46 | 78 | 0 | 20 | 118 | 104 | 51 | 28 | 222 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2758416 | 2758416 | CT | school | 904620 | 1440011 | Trumbull School District | 90462001469 | 1441011 | Frenchtown Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 260 | 48 | 139 | * | 36 | 0 | * | 273 | 227 | 51 | 72 | 500 | 260 | 48 | 139 | 36 | 0 | 273 | 227 | 51 | 72 | 500 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2757356 | 2757356 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000076 | 152211 | Jettie S. Tisdale School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 45 | 230 | 265 | * | 15 | 0 | * | 299 | 264 | 50 | 150 | 563 | 45 | 230 | 265 | 15 | 0 | 299 | 264 | 50 | 150 | 563 | |||||||||||||||||||||||||||||||
2757929 | 2757929 | CT | school | 902580 | 860011 | Montville School District | 90258000494 | 860111 | Mohegan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 138 | 13 | 48 | 7 | 56 | 0 | 43 | 160 | 145 | 50 | 53 | 305 | 138 | 13 | 48 | 7 | 56 | 0 | 43 | 160 | 145 | 50 | 53 | 305 | |||||||||||||||||||||||||||||
2757993 | 2757993 | CT | school | 902790 | 930011 | New Haven School District | 90279000580 | 931511 | Augusta Lewis Troup School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 23 | 186 | 163 | 0 | 10 | 0 | 15 | 201 | 196 | 50 | 59 | 397 | 23 | 186 | 163 | 0 | 10 | 0 | 15 | 201 | 196 | 50 | 59 | 397 | |||||||||||||||||||||||||||||
2758014 | 2758014 | CT | school | 902790 | 930011 | New Haven School District | 90279001564 | 931911 | Mauro-Sheridan Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 86 | 276 | 150 | * | * | 0 | 16 | 281 | 256 | 50 | 64 | 537 | 86 | 276 | 150 | 0 | 16 | 281 | 256 | 50 | 64 | 537 | |||||||||||||||||||||||||||||||
2758462 | 2758462 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000972 | 1510911 | Driggs School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 45 | 111 | 254 | * | * | 0 | 18 | 227 | 210 | 50 | 74 | 437 | 45 | 111 | 254 | 0 | 18 | 227 | 210 | 50 | 74 | 437 | |||||||||||||||||||||||||||||||
2758621 | 2758621 | CT | school | 905250 | 1650011 | Windsor Locks School District | 90525001097 | 1650111 | North Street School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 251 | 44 | 65 | 0 | * | * | 23 | 198 | 206 | 50 | 55 | 404 | 251 | 44 | 65 | 0 | 23 | 198 | 206 | 50 | 55 | 404 | |||||||||||||||||||||||||||||||
2757545 | 2757545 | CT | school | 901260 | 430011 | East Hartford School District | 90126000201 | 432011 | Governor William Pitkin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 50 | 77 | 123 | 0 | 33 | * | * | 147 | 154 | 49 | 46 | 301 | 50 | 77 | 123 | 0 | 33 | 147 | 154 | 49 | 46 | 301 | |||||||||||||||||||||||||||||||
2757644 | 2757644 | CT | school | 901560 | 520011 | Farmington School District | 90156001206 | 520411 | East Farms School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 219 | * | 49 | * | 138 | 0 | 25 | 247 | 207 | 49 | 34 | 454 | 219 | 49 | 138 | 0 | 25 | 247 | 207 | 49 | 34 | 454 | |||||||||||||||||||||||||||||||
2758250 | 2758250 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000784 | 1190411 | Myrtle H. Stevens School | Public Schools | Regular School | No | Elementary | PK | 03 | 2021 | pk_12_total | 224 | * | 47 | * | 76 | 0 | 19 | 196 | 181 | 49 | 49 | 377 | 224 | 47 | 76 | 0 | 19 | 196 | 181 | 49 | 49 | 377 | |||||||||||||||||||||||||||||||
2758292 | 2758292 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000821 | 1320111 | Philip R. Smith School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 256 | 14 | 45 | 0 | 90 | 0 | 22 | 215 | 212 | 49 | 39 | 427 | 256 | 14 | 45 | 0 | 90 | 0 | 22 | 215 | 212 | 49 | 39 | 427 | |||||||||||||||||||||||||||||
2758533 | 2758533 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001012 | 1550511 | Charter Oak International Academy | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 158 | 70 | 180 | * | 74 | * | 28 | 246 | 270 | 49 | 51 | 516 | 158 | 70 | 180 | 74 | 28 | 246 | 270 | 49 | 51 | 516 | |||||||||||||||||||||||||||||||
2758665 | 2758665 | CT | school | 900214 | 2890013 | Elm City College Preparatory School District | 90021401548 | 2890113 | Elm City College Preparatory School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 23 | 507 | 232 | * | * | 0 | 9 | 374 | 400 | 49 | 72 | 774 | 23 | 507 | 232 | 0 | 9 | 374 | 400 | 49 | 72 | 774 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2758134 | 2758134 | CT | school | 903120 | 1040011 | Norwich School District | 90312000678 | 1041511 | Wequonnoc Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 69 | 54 | 107 | * | * | * | 35 | 134 | 137 | 48 | 37 | 271 | 69 | 54 | 107 | 35 | 134 | 137 | 48 | 37 | 271 | ||||||||||||||||||||||||||||||||
2757375 | 2757375 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001631 | 151611 | Bridgeport Military Academy | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 36 | 84 | 214 | * | * | * | * | 167 | 173 | 47 | 84 | 340 | 36 | 84 | 214 | 167 | 173 | 47 | 84 | 340 | |||||||||||||||||||||||||||||||||
2758062 | 2758062 | CT | school | 902850 | 960011 | New Milford School District | 90285001372 | 960911 | Sarah Noble Intermediate School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 521 | 24 | 135 | 0 | 21 | 0 | 33 | 377 | 357 | 47 | 124 | 734 | 521 | 24 | 135 | 0 | 21 | 0 | 33 | 377 | 357 | 47 | 124 | 734 | |||||||||||||||||||||||||||||
2758266 | 2758266 | CT | school | 904050 | 1260011 | Shelton School District | 90405000803 | 1260811 | Long Hill School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 160 | 30 | 85 | 0 | 24 | * | * | 153 | 161 | 47 | 41 | 314 | 160 | 30 | 85 | 0 | 24 | 153 | 161 | 47 | 41 | 314 |
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]);