enrollments
Data source: Big Local News · About: Big Local
60,956 rows where state = "CT" sorted by disability 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2452049 | 2452049 | CT | school | 901530 | 510011 | Fairfield School District | 90153000271 | 515111 | Tomlinson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 449 | * | 113 | * | 53 | 0 | 33 | 339 | 323 | 27 | 88 | 662 | 449 | 113 | 53 | 0 | 33 | 339 | 323 | 27 | 88 | 662 | |||||||||||||||||||||||||||||||
2452102 | 2452102 | CT | school | 901770 | 590011 | Groton School District | 90177000321 | 591711 | Mary Morrisson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 202 | 21 | 91 | * | 36 | * | 31 | 188 | 197 | 18 | 88 | 385 | 202 | 21 | 91 | 36 | 31 | 188 | 197 | 18 | 88 | 385 | |||||||||||||||||||||||||||||||
2452103 | 2452103 | CT | school | 901770 | 590011 | Groton School District | 90177000325 | 590111 | S. B. Butler School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 207 | 13 | 52 | * | 13 | * | 29 | 188 | 130 | * | 88 | 318 | 207 | 13 | 52 | 13 | 29 | 188 | 130 | 88 | 318 | ||||||||||||||||||||||||||||||||
2452381 | 2452381 | CT | school | 890011 | New Britain School District | 890111 | Roosevelt Early Learning Center | Program | 2019 | pk_12_total | 23 | 17 | 107 | 0 | * | 0 | * | 95 | 68 | 0 | 88 | 163 | 23 | 17 | 107 | 0 | 0 | 95 | 68 | 0 | 88 | 163 | ||||||||||||||||||||||||||||||||||||||
2452496 | 2452496 | CT | school | 902880 | 940011 | Newington School District | 90288000608 | 945111 | Martin Kellogg Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 360 | 39 | 152 | * | 63 | 0 | * | 319 | 327 | 26 | 88 | 646 | 360 | 39 | 152 | 63 | 0 | 319 | 327 | 26 | 88 | 646 | |||||||||||||||||||||||||||||||
2452504 | 2452504 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 579 | 16 | 49 | 0 | 22 | 0 | 15 | 337 | 344 | 0 | 88 | 681 | 579 | 16 | 49 | 0 | 22 | 0 | 15 | 337 | 344 | 0 | 88 | 681 | |||||||||||||||||||||||||||||
2452511 | 2452511 | CT | school | 902970 | 990011 | North Branford School District | 90297000621 | 996111 | North Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 476 | * | 38 | * | 15 | 0 | 0 | 242 | 302 | * | 88 | 544 | 476 | 38 | 15 | 0 | 0 | 242 | 302 | 88 | 544 | ||||||||||||||||||||||||||||||||
2452614 | 2452614 | CT | school | 903520 | 2100012 | Regional School District 10 | 90352000727 | 2105112 | Har-Bur Middle School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 693 | * | 15 | * | 17 | * | * | 387 | 347 | * | 88 | 734 | 693 | 15 | 17 | 387 | 347 | 88 | 734 | ||||||||||||||||||||||||||||||||||
2452771 | 2452771 | CT | school | 904320 | 1350011 | Stamford School District | 90432000870 | 1355511 | Turn of River School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 197 | 100 | 268 | 0 | 61 | 0 | 27 | 339 | 314 | 122 | 88 | 653 | 197 | 100 | 268 | 0 | 61 | 0 | 27 | 339 | 314 | 122 | 88 | 653 | |||||||||||||||||||||||||||||
2757293 | 2757293 | CT | school | 900060 | 20011 | Ansonia School District | 90006010002 | 26111 | Ansonia High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 159 | 115 | 196 | * | 13 | * | 18 | 262 | 241 | 20 | 88 | 503 | 159 | 115 | 196 | 13 | 18 | 262 | 241 | 20 | 88 | 503 | |||||||||||||||||||||||||||||||
2757555 | 2757555 | CT | school | 901290 | 440011 | East Haven School District | 90129000214 | 440111 | Deer Run School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 145 | 10 | 74 | 0 | * | * | 14 | 136 | 117 | 31 | 88 | 253 | 145 | 10 | 74 | 0 | 14 | 136 | 117 | 31 | 88 | 253 | |||||||||||||||||||||||||||||||
2757743 | 2757743 | CT | school | 901920 | 640011 | Hartford School District | 90192000372 | 641411 | Naylor/CCSU Leadership Academy | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 42 | 47 | 275 | * | 19 | * | * | 194 | 194 | 138 | 88 | 388 | 42 | 47 | 275 | 19 | 194 | 194 | 138 | 88 | 388 | ||||||||||||||||||||||||||||||||
2757783 | 2757783 | CT | school | 901920 | 640011 | Hartford School District | 90192001479 | 646611 | Pathways Academy of Technology and Design | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 79 | 114 | 201 | * | * | 0 | 20 | 293 | * | 33 | 88 | 426 | 79 | 114 | 201 | 0 | 20 | 293 | 33 | 88 | 426 | ||||||||||||||||||||||||||||||||
2757985 | 2757985 | CT | school | 902730 | 910011 | New Fairfield School District | 90273001195 | 910211 | Meeting House Hill School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 351 | * | 87 | * | * | 0 | 22 | 234 | 236 | 29 | 88 | 470 | 351 | 87 | 0 | 22 | 234 | 236 | 29 | 88 | 470 | ||||||||||||||||||||||||||||||||
2758468 | 2758468 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001613 | 1513411 | Reed School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 29 | 108 | 308 | 0 | * | 0 | * | 233 | 221 | 62 | 88 | 454 | 29 | 108 | 308 | 0 | 0 | 233 | 221 | 62 | 88 | 454 | |||||||||||||||||||||||||||||||
2758594 | 2758594 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001066 | 1595211 | Silas Deane Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 403 | * | 110 | * | 19 | 0 | 29 | 290 | 288 | 27 | 88 | 578 | 403 | 110 | 19 | 0 | 29 | 290 | 288 | 27 | 88 | 578 | |||||||||||||||||||||||||||||||
2758694 | 2758694 | CT | school | 3360015 | Unified School District #1 | 90000300404 | 3361115 | Manson Youth Institution | State Agency Facilities | 2021 | pk_12_total | * | 60 | 33 | 0 | 0 | 0 | * | 108 | 0 | * | 88 | 108 | 60 | 33 | 0 | 0 | 0 | 108 | 0 | 88 | 108 | ||||||||||||||||||||||||||||||||||||||
2778306 | 2778306 | CT | school | 800011 | Meriden School District | 802611 | PRIDE | Program | 2020 | pk_12_total | 25 | * | 53 | 0 | * | 0 | * | 64 | 24 | 0 | 88 | 88 | 25 | 53 | 0 | 0 | 64 | 24 | 0 | 88 | 88 | |||||||||||||||||||||||||||||||||||||||
2778785 | 2778785 | CT | school | 904320 | 1350011 | Stamford School District | 90432000864 | 1350811 | Rogers International School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 347 | 71 | 338 | * | 53 | 0 | * | 402 | 438 | 37 | 88 | 840 | 347 | 71 | 338 | 53 | 0 | 402 | 438 | 37 | 88 | 840 | |||||||||||||||||||||||||||||||
2778847 | 2778847 | CT | school | 904560 | 1420011 | Tolland School District | 90456000915 | 1425111 | Tolland Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 480 | 18 | 37 | 0 | 25 | * | * | 290 | 276 | * | 88 | 566 | 480 | 18 | 37 | 0 | 25 | 290 | 276 | 88 | 566 | ||||||||||||||||||||||||||||||||
2779096 | 2779096 | CT | school | 905310 | 1670011 | Woodbridge School District | 90531001611 | 1670311 | Beecher Road School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 569 | * | 63 | * | 122 | 0 | 51 | 460 | 378 | 24 | 88 | 838 | 569 | 63 | 122 | 0 | 51 | 460 | 378 | 24 | 88 | 838 | |||||||||||||||||||||||||||||||
2451890 | 2451890 | CT | school | 900840 | 280011 | Colchester School District | 90084000136 | 285111 | William J. Johnston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 440 | 7 | 36 | * | 16 | * | 19 | 251 | 269 | * | 87 | 520 | 440 | 7 | 36 | 16 | 19 | 251 | 269 | 87 | 520 | ||||||||||||||||||||||||||||||||
2452218 | 2452218 | CT | school | 902070 | 690011 | Killingly School District | 90207000393 | 695211 | Killingly Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 515 | 15 | 60 | * | 24 | * | 31 | 315 | 333 | 9 | 87 | 648 | 515 | 15 | 60 | 24 | 31 | 315 | 333 | 9 | 87 | 648 | |||||||||||||||||||||||||||||||
2452668 | 2452668 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381001361 | 1185211 | Scotts Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 441 | 7 | 38 | 0 | 46 | 0 | 20 | 285 | 267 | 0 | 87 | 552 | 441 | 7 | 38 | 0 | 46 | 0 | 20 | 285 | 267 | 0 | 87 | 552 | |||||||||||||||||||||||||||||
2452756 | 2452756 | CT | school | 904320 | 1350011 | Stamford School District | 90432000865 | 1350911 | Roxbury School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 170 | 90 | 249 | * | 35 | * | 23 | 299 | 272 | 87 | 87 | 571 | 170 | 90 | 249 | 35 | 23 | 299 | 272 | 87 | 87 | 571 | |||||||||||||||||||||||||||||||
2452880 | 2452880 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000956 | 1486211 | Mark T. Sheehan High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 608 | 20 | 102 | 0 | 59 | 0 | 6 | 380 | 415 | 9 | 87 | 795 | 608 | 20 | 102 | 0 | 59 | 0 | 6 | 380 | 415 | 9 | 87 | 795 | |||||||||||||||||||||||||||||
2452883 | 2452883 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000969 | 1510611 | Bunker Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 75 | 103 | 258 | * | * | 0 | 19 | 257 | 216 | 68 | 87 | 473 | 75 | 103 | 258 | 0 | 19 | 257 | 216 | 68 | 87 | 473 | |||||||||||||||||||||||||||||||
2453067 | 2453067 | CT | school | 905310 | 1670011 | Woodbridge School District | 90531001611 | 1670311 | Beecher Road School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 588 | * | 62 | * | 118 | 0 | 38 | 450 | 393 | 20 | 87 | 843 | 588 | 62 | 118 | 0 | 38 | 450 | 393 | 20 | 87 | 843 | |||||||||||||||||||||||||||||||
2757736 | 2757736 | CT | school | 901920 | 640011 | Hartford School District | 90192000636 | 643211 | Expeditionary Learning Academy at Moylan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 9 | 34 | 360 | * | 6 | * | * | 212 | 204 | 144 | 87 | 416 | 9 | 34 | 360 | 6 | 212 | 204 | 144 | 87 | 416 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2758079 | 2758079 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 484 | * | 50 | * | 16 | 0 | 19 | 308 | 274 | * | 87 | 582 | 484 | 50 | 16 | 0 | 19 | 308 | 274 | 87 | 582 | ||||||||||||||||||||||||||||||||
2758136 | 2758136 | CT | school | 903120 | 1040011 | Norwich School District | 90312000670 | 1045111 | Kelly STEAM Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 182 | 119 | 246 | * | 35 | * | 72 | 340 | 316 | 92 | 87 | 656 | 182 | 119 | 246 | 35 | 72 | 340 | 316 | 92 | 87 | 656 | |||||||||||||||||||||||||||||||
2758187 | 2758187 | CT | school | 903515 | 2060012 | Regional School District 06 | 90351500725 | 2066112 | Wamogo Regional High School | Regional Schools | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 432 | 8 | 28 | * | * | * | 9 | * | 267 | * | 87 | 484 | 432 | 8 | 28 | 9 | 267 | 87 | 484 | ||||||||||||||||||||||||||||||||||
2777816 | 2777816 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000074 | 152011 | Madison School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 96 | 135 | 196 | 0 | * | * | 9 | 254 | 191 | 118 | 87 | 445 | 96 | 135 | 196 | 0 | 9 | 254 | 191 | 118 | 87 | 445 | |||||||||||||||||||||||||||||||
2778195 | 2778195 | CT | school | 901920 | 640011 | Hartford School District | 90192000384 | 642111 | West Middle School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 11 | 191 | 232 | 0 | 22 | * | * | 246 | 216 | 157 | 87 | 462 | 11 | 191 | 232 | 0 | 22 | 246 | 216 | 157 | 87 | 462 | |||||||||||||||||||||||||||||||
2778196 | 2778196 | CT | school | 901920 | 640011 | Hartford School District | 90192000385 | 642211 | Wish Museum School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 6 | 129 | 189 | 0 | * | 0 | * | 174 | 158 | 102 | 87 | 332 | 6 | 129 | 189 | 0 | 0 | 174 | 158 | 102 | 87 | 332 | |||||||||||||||||||||||||||||||
2778218 | 2778218 | CT | school | 901920 | 640011 | Hartford School District | 90192000371 | 641211 | McDonough Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 11 | 38 | 335 | 0 | 7 | 0 | 0 | 207 | 184 | 165 | 87 | 391 | 11 | 38 | 335 | 0 | 7 | 0 | 0 | 207 | 184 | 165 | 87 | 391 | |||||||||||||||||||||||||||||
2778430 | 2778430 | CT | school | 902730 | 910011 | New Fairfield School District | 90273000535 | 910111 | Consolidated School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 401 | 7 | 65 | 0 | * | * | 15 | 243 | 251 | 42 | 87 | 494 | 401 | 7 | 65 | 0 | 15 | 243 | 251 | 42 | 87 | 494 | |||||||||||||||||||||||||||||||
2778732 | 2778732 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000811 | 1285111 | Henry James Memorial School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 455 | 39 | 52 | 0 | 52 | * | * | 311 | 315 | * | 87 | 626 | 455 | 39 | 52 | 0 | 52 | 311 | 315 | 87 | 626 | ||||||||||||||||||||||||||||||||
2778784 | 2778784 | CT | school | 904320 | 1350011 | Stamford School District | 90432000861 | 1351811 | Northeast School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 278 | 71 | 262 | 0 | * | * | 25 | 321 | 333 | 129 | 87 | 654 | 278 | 71 | 262 | 0 | 25 | 321 | 333 | 129 | 87 | 654 | |||||||||||||||||||||||||||||||
2452172 | 2452172 | CT | school | 901920 | 640011 | Hartford School District | 90192000377 | 640111 | SAND School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | * | 138 | 253 | 0 | 0 | 0 | * | 218 | 177 | 108 | 86 | 395 | 138 | 253 | 0 | 0 | 0 | 218 | 177 | 108 | 86 | 395 | |||||||||||||||||||||||||||||||
2452709 | 2452709 | CT | school | 904140 | 1290011 | Somers School District | 90414000526 | 1290411 | Somers Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 518 | 16 | 28 | * | * | 0 | 6 | 304 | 272 | * | 86 | 576 | 518 | 16 | 28 | 0 | 6 | 304 | 272 | 86 | 576 | ||||||||||||||||||||||||||||||||
2757862 | 2757862 | CT | school | 902400 | 800011 | Meriden School District | 90240000440 | 801111 | Casimir Pulaski School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 99 | 64 | 401 | * | * | 0 | 27 | 311 | 289 | 121 | 86 | 600 | 99 | 64 | 401 | 0 | 27 | 311 | 289 | 121 | 86 | 600 | |||||||||||||||||||||||||||||||
2758071 | 2758071 | CT | school | 902880 | 940011 | Newington School District | 90288000608 | 945111 | Martin Kellogg Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 310 | * | 171 | * | 55 | 0 | 39 | 291 | 321 | 30 | 86 | 612 | 310 | 171 | 55 | 0 | 39 | 291 | 321 | 30 | 86 | 612 | |||||||||||||||||||||||||||||||
2758627 | 2758627 | CT | school | 905220 | 1640011 | Windsor School District | 90522001092 | 1640911 | Oliver Ellsworth School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 122 | 138 | 106 | * | * | 0 | 39 | 219 | 225 | 26 | 86 | 444 | 122 | 138 | 106 | 0 | 39 | 219 | 225 | 26 | 86 | 444 | |||||||||||||||||||||||||||||||
2777815 | 2777815 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001162 | 154211 | James J. Curiale School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 38 | 231 | 258 | * | 24 | * | 6 | 290 | 272 | 132 | 86 | 562 | 38 | 231 | 258 | 24 | 6 | 290 | 272 | 132 | 86 | 562 | |||||||||||||||||||||||||||||||
2777878 | 2777878 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001623 | 2410614 | Ana Grace Academy of the Arts Elementary School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 106 | 123 | 215 | * | 9 | * | 23 | 174 | 304 | 27 | 86 | 478 | 106 | 123 | 215 | 9 | 23 | 174 | 304 | 27 | 86 | 478 | |||||||||||||||||||||||||||||||
2777884 | 2777884 | 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 | 2020 | pk_12_total | 161 | 145 | 179 | 0 | 13 | 0 | 18 | 241 | 275 | 51 | 86 | 516 | 161 | 145 | 179 | 0 | 13 | 0 | 18 | 241 | 275 | 51 | 86 | 516 | |||||||||||||||||||||||||||||
2777989 | 2777989 | CT | school | 430011 | East Hartford School District | 430211 | Early Childhood Learning Center at Hockanum School | Program | 2020 | pk_12_total | 42 | 95 | 162 | 0 | 15 | * | * | 176 | 145 | 0 | 86 | 321 | 42 | 95 | 162 | 0 | 15 | 176 | 145 | 0 | 86 | 321 | ||||||||||||||||||||||||||||||||||||||
2778307 | 2778307 | CT | school | 902400 | 800011 | Meriden School District | 90240000450 | 800811 | Roger Sherman School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 94 | 35 | 300 | * | 8 | * | 35 | 236 | 239 | 92 | 86 | 475 | 94 | 35 | 300 | 8 | 35 | 236 | 239 | 92 | 86 | 475 | |||||||||||||||||||||||||||||||
2778559 | 2778559 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000657 | 1035511 | Roton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 193 | 74 | 278 | 0 | 16 | * | * | 317 | 261 | 58 | 86 | 578 | 193 | 74 | 278 | 0 | 16 | 317 | 261 | 58 | 86 | 578 | |||||||||||||||||||||||||||||||
2778632 | 2778632 | CT | school | 903515 | 2060012 | Regional School District 06 | 90351500725 | 2066112 | Wamogo Regional High School | Regional Schools | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 461 | 7 | 20 | * | * | * | 9 | 215 | 293 | * | 86 | 508 | 461 | 7 | 20 | 9 | 215 | 293 | 86 | 508 | |||||||||||||||||||||||||||||||||
2778666 | 2778666 | CT | school | 903538 | 2160012 | Regional School District 16 | 90353801356 | 2166012 | Woodland Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 590 | 28 | 48 | * | 10 | 0 | * | 350 | 331 | * | 86 | 681 | 590 | 28 | 48 | 10 | 0 | 350 | 331 | 86 | 681 | ||||||||||||||||||||||||||||||||
2778808 | 2778808 | CT | school | 904380 | 1370011 | Stonington School District | 90438000881 | 1376111 | Stonington High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 559 | * | 40 | * | 21 | * | 17 | 344 | 301 | * | 86 | 645 | 559 | 40 | 21 | 17 | 344 | 301 | 86 | 645 | |||||||||||||||||||||||||||||||||
2778842 | 2778842 | CT | school | 904530 | 1410011 | Thompson School District | 90453000909 | 1410111 | Mary R. Fisher Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 410 | * | 8 | 0 | 0 | 0 | * | 236 | 187 | * | 86 | 423 | 410 | 8 | 0 | 0 | 0 | 236 | 187 | 86 | 423 | ||||||||||||||||||||||||||||||||
2778914 | 2778914 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001602 | 1511611 | Duggan School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 52 | 105 | 296 | * | * | 0 | 22 | 240 | 238 | 42 | 86 | 478 | 52 | 105 | 296 | 0 | 22 | 240 | 238 | 42 | 86 | 478 | |||||||||||||||||||||||||||||||
2779125 | 2779125 | CT | school | 903630 | 2040012 | Regional School District 04 | 90363000768 | 2046112 | Valley Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 528 | * | 19 | * | 15 | 0 | 15 | 281 | 302 | 6 | 86 | 583 | 528 | 19 | 15 | 0 | 15 | 281 | 302 | 6 | 86 | 583 | |||||||||||||||||||||||||||||||
2779159 | 2779159 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201140 | 9001416 | Eli Whitney Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2020 | pk_12_total | 62 | 226 | 326 | 0 | * | * | 10 | 334 | 297 | 49 | 86 | 631 | 62 | 226 | 326 | 0 | 10 | 334 | 297 | 49 | 86 | 631 | |||||||||||||||||||||||||||||||
2451957 | 2451957 | CT | school | 430011 | East Hartford School District | 430211 | Early Childhood Learning Center at Hockanum School | Program | 2019 | pk_12_total | 36 | 74 | 179 | 0 | 15 | 0 | 14 | 176 | 142 | 0 | 85 | 318 | 36 | 74 | 179 | 0 | 15 | 0 | 14 | 176 | 142 | 0 | 85 | 318 | ||||||||||||||||||||||||||||||||||||
2452184 | 2452184 | CT | school | 901920 | 640011 | Hartford School District | 90192001478 | 646411 | Classical Magnet School | Public Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 85 | 230 | 182 | 0 | * | * | 20 | * | 288 | 39 | 85 | 533 | 85 | 230 | 182 | 0 | 20 | 288 | 39 | 85 | 533 | ||||||||||||||||||||||||||||||||
2452284 | 2452284 | CT | school | 902400 | 800011 | Meriden School District | 90240000445 | 800511 | John Barry School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 58 | 59 | 374 | * | * | 0 | 20 | 259 | 259 | 105 | 85 | 518 | 58 | 59 | 374 | 0 | 20 | 259 | 259 | 105 | 85 | 518 | |||||||||||||||||||||||||||||||
2453084 | 2453084 | CT | school | 900219 | 2940013 | Great Oaks Charter School District | 90021901782 | 2940113 | Great Oaks Charter School | Public Charter Schools | Regular School | Yes | Middle | 06 | 10 | 2019 | pk_12_total | 22 | 224 | 209 | * | 0 | * | 7 | 216 | 249 | 60 | 85 | 465 | 22 | 224 | 209 | 0 | 7 | 216 | 249 | 60 | 85 | 465 | |||||||||||||||||||||||||||||||
2757362 | 2757362 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000081 | 152611 | Roosevelt School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 50 | 143 | 275 | * | 18 | 0 | * | 226 | 267 | 127 | 85 | 493 | 50 | 143 | 275 | 18 | 0 | 226 | 267 | 127 | 85 | 493 | |||||||||||||||||||||||||||||||
2757450 | 2757450 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001497 | 2416414 | Greater Hartford Academy of the Arts High School - Full Day | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 95 | 105 | 217 | 0 | * | 0 | * | 122 | 317 | 15 | 85 | 439 | 95 | 105 | 217 | 0 | 0 | 122 | 317 | 15 | 85 | 439 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2757832 | 2757832 | CT | school | 902280 | 760011 | Madison School District | 90228001480 | 765211 | Walter C. Polson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 460 | * | 37 | * | 21 | * | 23 | 287 | 261 | * | 85 | 548 | 460 | 37 | 21 | 23 | 287 | 261 | 85 | 548 | |||||||||||||||||||||||||||||||||
2758081 | 2758081 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 526 | * | 54 | 0 | 19 | * | 14 | * | 322 | * | 85 | 623 | 526 | 54 | 0 | 19 | 14 | 322 | 85 | 623 | |||||||||||||||||||||||||||||||||
2758219 | 2758219 | CT | school | 903538 | 2160012 | Regional School District 16 | 90353801356 | 2166012 | Woodland Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 564 | 28 | 41 | * | * | 0 | 6 | 325 | 319 | * | 85 | 644 | 564 | 28 | 41 | 0 | 6 | 325 | 319 | 85 | 644 | ||||||||||||||||||||||||||||||||
2777754 | 2777754 | CT | school | 900210 | 70011 | Berlin School District | 90021000018 | 70411 | Emma Hart Willard School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 361 | 9 | 55 | 0 | 16 | 0 | 19 | 236 | 224 | 13 | 85 | 460 | 361 | 9 | 55 | 0 | 16 | 0 | 19 | 236 | 224 | 13 | 85 | 460 | |||||||||||||||||||||||||||||
2778133 | 2778133 | CT | school | 901770 | 590011 | Groton School District | 90177000325 | 590111 | S. B. Butler School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 204 | 15 | 44 | * | * | 0 | 34 | 181 | 128 | 7 | 85 | 309 | 204 | 15 | 44 | 0 | 34 | 181 | 128 | 7 | 85 | 309 | |||||||||||||||||||||||||||||||
2778491 | 2778491 | CT | school | 902790 | 930011 | New Haven School District | 90279001216 | 936711 | Sound School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 159 | 43 | 130 | * | * | 0 | * | 186 | 149 | 15 | 85 | 335 | 159 | 43 | 130 | 0 | 186 | 149 | 15 | 85 | 335 | ||||||||||||||||||||||||||||||||
2778514 | 2778514 | CT | school | 902880 | 940011 | Newington School District | 90288000606 | 940811 | John Paterson School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 225 | 28 | 94 | 0 | 26 | 0 | 19 | 196 | 196 | 51 | 85 | 392 | 225 | 28 | 94 | 0 | 26 | 0 | 19 | 196 | 196 | 51 | 85 | 392 | |||||||||||||||||||||||||||||
2778517 | 2778517 | CT | school | 902880 | 940011 | Newington School District | 90288000608 | 945111 | Martin Kellogg Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 334 | 35 | 174 | * | 49 | 0 | * | 296 | 333 | 27 | 85 | 629 | 334 | 35 | 174 | 49 | 0 | 296 | 333 | 27 | 85 | 629 | |||||||||||||||||||||||||||||||
2451736 | 2451736 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 501 | 21 | 162 | * | 46 | * | 11 | 372 | 373 | 28 | 84 | 745 | 501 | 21 | 162 | 46 | 11 | 372 | 373 | 28 | 84 | 745 | |||||||||||||||||||||||||||||||
2452360 | 2452360 | CT | school | 902580 | 860011 | Montville School District | 90258000035 | 865111 | Leonard J. Tyl Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 333 | * | 52 | 9 | 34 | * | 64 | 244 | 256 | 8 | 84 | 500 | 333 | 52 | 9 | 34 | 64 | 244 | 256 | 8 | 84 | 500 | |||||||||||||||||||||||||||||||
2452823 | 2452823 | CT | school | 904560 | 1420011 | Tolland School District | 90456000915 | 1425111 | Tolland Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 490 | 17 | 26 | * | 30 | * | * | 297 | 273 | * | 84 | 570 | 490 | 17 | 26 | 30 | 297 | 273 | 84 | 570 | |||||||||||||||||||||||||||||||||
2452885 | 2452885 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000972 | 1510911 | Driggs School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 61 | 148 | 268 | * | * | 0 | 14 | 275 | 224 | 56 | 84 | 499 | 61 | 148 | 268 | 0 | 14 | 275 | 224 | 56 | 84 | 499 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2757665 | 2757665 | CT | school | 901680 | 560011 | Granby School District | 90168000291 | 565111 | Granby Memorial Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 370 | 25 | 17 | * | * | 0 | 12 | 206 | 230 | 0 | 84 | 436 | 370 | 25 | 17 | 0 | 12 | 206 | 230 | 0 | 84 | 436 | |||||||||||||||||||||||||||||||
2758285 | 2758285 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000811 | 1285111 | Henry James Memorial School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 432 | 44 | 60 | 0 | 48 | * | * | 299 | 324 | * | 84 | 623 | 432 | 44 | 60 | 0 | 48 | 299 | 324 | 84 | 623 | ||||||||||||||||||||||||||||||||
2758420 | 2758420 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000930 | 1445211 | Hillcrest Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 507 | 54 | 106 | * | 72 | * | 13 | 373 | 383 | 8 | 84 | 756 | 507 | 54 | 106 | 72 | 13 | 373 | 383 | 8 | 84 | 756 | |||||||||||||||||||||||||||||||
2777916 | 2777916 | CT | school | 900810 | 270011 | Clinton School District | 90081000133 | 275111 | Jared Eliot School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 398 | * | 93 | * | 17 | 0 | 8 | 271 | 251 | 30 | 84 | 522 | 398 | 93 | 17 | 0 | 8 | 271 | 251 | 30 | 84 | 522 | |||||||||||||||||||||||||||||||
2777993 | 2777993 | CT | school | 901260 | 430011 | East Hartford School District | 90126000196 | 431011 | Dr. Thomas S. O'Connell School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 118 | 128 | 245 | 0 | 16 | 0 | 33 | 279 | 261 | 42 | 84 | 540 | 118 | 128 | 245 | 0 | 16 | 0 | 33 | 279 | 261 | 42 | 84 | 540 | |||||||||||||||||||||||||||||
2778305 | 2778305 | CT | school | 902400 | 800011 | Meriden School District | 90240000445 | 800511 | John Barry School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 52 | 69 | 352 | 0 | 13 | 0 | 19 | 255 | 250 | 117 | 84 | 505 | 52 | 69 | 352 | 0 | 13 | 0 | 19 | 255 | 250 | 117 | 84 | 505 | |||||||||||||||||||||||||||||
2778532 | 2778532 | CT | school | 902970 | 990011 | North Branford School District | 90297000621 | 996111 | North Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 458 | 12 | 39 | 0 | 9 | 0 | 6 | 239 | 285 | * | 84 | 524 | 458 | 12 | 39 | 0 | 9 | 0 | 6 | 239 | 285 | 84 | 524 | ||||||||||||||||||||||||||||||
2778609 | 2778609 | CT | school | 903300 | 1100011 | Plainville School District | 90330000703 | 1106111 | Plainville High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 480 | 29 | 118 | * | * | 0 | 34 | 369 | 310 | 23 | 84 | 679 | 480 | 29 | 118 | 0 | 34 | 369 | 310 | 23 | 84 | 679 | |||||||||||||||||||||||||||||||
2778708 | 2778708 | CT | school | 903990 | 1240011 | Seymour School District | 90399000794 | 1245111 | Seymour Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 387 | 24 | 104 | * | 17 | 0 | * | 272 | 272 | 6 | 84 | 544 | 387 | 24 | 104 | 17 | 0 | 272 | 272 | 6 | 84 | 544 | |||||||||||||||||||||||||||||||
2778750 | 2778750 | CT | school | 904230 | 1310011 | Southington School District | 90423000829 | 1311511 | Derynoski Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 437 | 11 | 40 | 0 | 17 | 0 | 25 | 276 | 254 | 9 | 84 | 530 | 437 | 11 | 40 | 0 | 17 | 0 | 25 | 276 | 254 | 9 | 84 | 530 | |||||||||||||||||||||||||||||
2778837 | 2778837 | CT | school | 904470 | 1390011 | Suffield School District | 90447000904 | 1396111 | Suffield High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 668 | 23 | 42 | * | 29 | * | * | 357 | 414 | * | 84 | 771 | 668 | 23 | 42 | 29 | 357 | 414 | 84 | 771 | |||||||||||||||||||||||||||||||||
2778846 | 2778846 | CT | school | 904560 | 1420011 | Tolland School District | 90456000913 | 1420211 | Tolland Intermediate School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 427 | 15 | 33 | 0 | 12 | 0 | 6 | 262 | 231 | 7 | 84 | 493 | 427 | 15 | 33 | 0 | 12 | 0 | 6 | 262 | 231 | 7 | 84 | 493 | |||||||||||||||||||||||||||||
2779165 | 2779165 | 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 | 2020 | pk_12_total | 331 | 65 | 196 | 0 | 16 | 0 | 36 | 494 | 150 | 19 | 84 | 644 | 331 | 65 | 196 | 0 | 16 | 0 | 36 | 494 | 150 | 19 | 84 | 644 | |||||||||||||||||||||||||||||
2452036 | 2452036 | CT | school | 510011 | Fairfield School District | 90153000989 | 518011 | Early Childhood Center(0518011) | Program | 2019 | pk_12_total | 80 | * | 15 | 0 | * | 0 | * | 66 | 42 | 0 | 83 | 108 | 80 | 15 | 0 | 0 | 66 | 42 | 0 | 83 | 108 | ||||||||||||||||||||||||||||||||||||||
2452378 | 2452378 | CT | school | 902670 | 890011 | New Britain School District | 90267000512 | 890511 | Gaffney Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 84 | 39 | 281 | 0 | 9 | 0 | 21 | 207 | 227 | 55 | 83 | 434 | 84 | 39 | 281 | 0 | 9 | 0 | 21 | 207 | 227 | 55 | 83 | 434 | |||||||||||||||||||||||||||||
2452430 | 2452430 | CT | school | 902790 | 930011 | New Haven School District | 90279000554 | 931611 | Fair Haven School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 38 | 70 | 678 | * | 21 | * | * | 413 | 399 | 444 | 83 | 812 | 38 | 70 | 678 | 21 | 413 | 399 | 444 | 83 | 812 | ||||||||||||||||||||||||||||||||
2452463 | 2452463 | CT | school | 902790 | 930011 | New Haven School District | 90279001207 | 936411 | Cooperative High School - Inter-District Magnet | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 100 | 278 | 234 | * | * | 0 | 9 | 200 | 430 | 33 | 83 | 630 | 100 | 278 | 234 | 0 | 9 | 200 | 430 | 33 | 83 | 630 | |||||||||||||||||||||||||||||||
2452649 | 2452649 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353900759 | 2176112 | Haddam-Killingworth High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 601 | 8 | 12 | 0 | 14 | 0 | 9 | 333 | 311 | * | 83 | 644 | 601 | 8 | 12 | 0 | 14 | 0 | 9 | 333 | 311 | 83 | 644 | ||||||||||||||||||||||||||||||
2757733 | 2757733 | CT | school | 901920 | 640011 | Hartford School District | 90192000360 | 640711 | Dwight-Bellizzi Dual Language Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 23 | 65 | 452 | * | 16 | 0 | * | 297 | 269 | 245 | 83 | 566 | 23 | 65 | 452 | 16 | 0 | 297 | 269 | 245 | 83 | 566 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2757963 | 2757963 | CT | school | 902670 | 890011 | New Britain School District | 90267000524 | 891311 | Smith Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 58 | 59 | 339 | * | * | 0 | 19 | 249 | 235 | 90 | 83 | 484 | 58 | 59 | 339 | 0 | 19 | 249 | 235 | 90 | 83 | 484 | |||||||||||||||||||||||||||||||
2758706 | 2758706 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201137 | 9001116 | Bullard-Havens Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2021 | pk_12_total | 24 | 224 | 544 | * | * | 0 | 24 | 399 | 429 | 85 | 83 | 828 | 24 | 224 | 544 | 0 | 24 | 399 | 429 | 85 | 83 | 828 |
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]);