enrollments
Data source: Big Local News · About: Big Local
20,454 rows where state = "CT" and year = 2020 sorted by black 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2778176 | 2778176 | CT | school | 901920 | 640011 | Hartford School District | 90192000360 | 640711 | Dwight-Bellizzi Dual Language Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 27 | 77 | 425 | * | 18 | 0 | * | 288 | 267 | 221 | 74 | 555 | 27 | 77 | 425 | 18 | 0 | 288 | 267 | 221 | 74 | 555 | |||||||||||||||||||||||||||||||
2777831 | 2777831 | CT | school | 900510 | 170011 | Bristol School District | 90051000098 | 170511 | Greene-Hills School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 449 | 76 | 307 | * | 44 | * | 31 | 469 | 440 | 72 | 123 | 909 | 449 | 76 | 307 | 44 | 31 | 469 | 440 | 72 | 123 | 909 | |||||||||||||||||||||||||||||||
2777879 | 2777879 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001597 | 2418114 | Discovery Academy | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 164 | 76 | 223 | * | 31 | 0 | * | 268 | 252 | 49 | 61 | 520 | 164 | 76 | 223 | 31 | 0 | 268 | 252 | 49 | 61 | 520 | |||||||||||||||||||||||||||||||
2777898 | 2777898 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001532 | 2415214 | Civic Leadership High School | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 64 | 76 | 184 | * | * | * | 15 | 184 | 164 | 24 | 76 | 348 | 64 | 76 | 184 | 15 | 184 | 164 | 24 | 76 | 348 | ||||||||||||||||||||||||||||||||
2778334 | 2778334 | CT | school | 902490 | 830011 | Middletown School District | 90249000453 | 830211 | Bielefield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 100 | 76 | 62 | 0 | 19 | 0 | 33 | 137 | 153 | 13 | 39 | 290 | 100 | 76 | 62 | 0 | 19 | 0 | 33 | 137 | 153 | 13 | 39 | 290 | |||||||||||||||||||||||||||||
2778790 | 2778790 | CT | school | 904320 | 1350011 | Stamford School District | 90432000008 | 1351911 | Toquam Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 113 | 76 | 409 | * | 40 | * | 24 | 363 | 303 | 158 | 78 | 666 | 113 | 76 | 409 | 40 | 24 | 363 | 303 | 158 | 78 | 666 | |||||||||||||||||||||||||||||||
2778173 | 2778173 | CT | school | 901920 | 640011 | Hartford School District | 90192001369 | 643311 | Breakthrough Magnet School, South | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 49 | 75 | 170 | * | 20 | 0 | * | 169 | 158 | 41 | 54 | 327 | 49 | 75 | 170 | 20 | 0 | 169 | 158 | 41 | 54 | 327 | |||||||||||||||||||||||||||||||
2778286 | 2778286 | CT | school | 902310 | 770011 | Manchester School District | 90231000420 | 770411 | Highland Park School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 141 | 75 | 77 | * | 17 | 0 | * | 156 | 160 | 18 | 34 | 316 | 141 | 75 | 77 | 17 | 0 | 156 | 160 | 18 | 34 | 316 | |||||||||||||||||||||||||||||||
2778476 | 2778476 | CT | school | 902790 | 930011 | New Haven School District | 90279001612 | 933511 | Quinnipiac Real World Math STEM School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 23 | 75 | 143 | 0 | * | 0 | * | 132 | 123 | 40 | 35 | 255 | 23 | 75 | 143 | 0 | 0 | 132 | 123 | 40 | 35 | 255 | |||||||||||||||||||||||||||||||
2778547 | 2778547 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000649 | 1030811 | Kendall Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 48 | 75 | 336 | 0 | 25 | 0 | 19 | 246 | 257 | 174 | 52 | 503 | 48 | 75 | 336 | 0 | 25 | 0 | 19 | 246 | 257 | 174 | 52 | 503 | |||||||||||||||||||||||||||||
2778796 | 2778796 | CT | school | 904320 | 1350011 | Stamford School District | 90432000009 | 1355711 | Scofield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 226 | 75 | 258 | 0 | 76 | 0 | 10 | 321 | 324 | 49 | 43 | 645 | 226 | 75 | 258 | 0 | 76 | 0 | 10 | 321 | 324 | 49 | 43 | 645 | |||||||||||||||||||||||||||||
2777729 | 2777729 | CT | school | 900060 | 20011 | Ansonia School District | 90006010008 | 25111 | Ansonia Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 108 | 74 | 148 | 0 | 6 | 0 | 20 | 189 | 167 | 10 | 73 | 356 | 108 | 74 | 148 | 0 | 6 | 0 | 20 | 189 | 167 | 10 | 73 | 356 | |||||||||||||||||||||||||||||
2777793 | 2777793 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000052 | 150311 | Black Rock School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 135 | 74 | 282 | * | 10 | 0 | * | 258 | 247 | 106 | 80 | 505 | 135 | 74 | 282 | 10 | 0 | 258 | 247 | 106 | 80 | 505 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778451 | 2778451 | CT | school | 902790 | 930011 | New Haven School District | 90279000554 | 931611 | Fair Haven School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 32 | 73 | 682 | 0 | 40 | * | * | 423 | 410 | 466 | 101 | 833 | 32 | 73 | 682 | 0 | 40 | 423 | 410 | 466 | 101 | 833 | |||||||||||||||||||||||||||||||
2777958 | 2777958 | CT | school | 901020 | 340011 | Danbury School District | 90102000160 | 345211 | Rogers Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 297 | 72 | 611 | 0 | 47 | * | * | 533 | 516 | 366 | 135 | 1049 | 297 | 72 | 611 | 0 | 47 | 533 | 516 | 366 | 135 | 1049 | |||||||||||||||||||||||||||||||
2778171 | 2778171 | CT | school | 901920 | 640011 | Hartford School District | 90192001192 | 642811 | Betances Learning Lab Magnet School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 42 | 72 | 195 | * | 93 | * | 6 | 200 | 211 | 73 | 55 | 411 | 42 | 72 | 195 | 93 | 6 | 200 | 211 | 73 | 55 | 411 | |||||||||||||||||||||||||||||||
2778183 | 2778183 | CT | school | 901920 | 640011 | Hartford School District | 90192000364 | 640811 | M. D. Fox School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | * | 72 | 468 | 0 | 29 | * | 0 | 286 | 297 | 225 | 80 | 583 | 72 | 468 | 0 | 29 | 0 | 286 | 297 | 225 | 80 | 583 | |||||||||||||||||||||||||||||||
2778743 | 2778743 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000827 | 1325111 | Timothy Edwards School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 578 | 72 | 84 | * | 258 | * | 55 | 530 | * | 25 | 125 | 1049 | 578 | 72 | 84 | 258 | 55 | 530 | 25 | 125 | 1049 | ||||||||||||||||||||||||||||||||
2778583 | 2778583 | CT | school | 903120 | 1040011 | Norwich School District | 90312000674 | 1045211 | Teachers' Memorial Global Studies Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 104 | 71 | 143 | * | 25 | * | 44 | 202 | 194 | 66 | 100 | 396 | 104 | 71 | 143 | 25 | 44 | 202 | 194 | 66 | 100 | 396 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778178 | 2778178 | CT | school | 901920 | 640011 | Hartford School District | 90192000366 | 640911 | Environmental Sciences Magnet at Hooker School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 109 | 70 | 374 | * | 34 | 0 | * | 311 | 295 | 76 | 67 | 606 | 109 | 70 | 374 | 34 | 0 | 311 | 295 | 76 | 67 | 606 | |||||||||||||||||||||||||||||||
2778251 | 2778251 | CT | school | 903450 | 2450014 | Learn | 90345000079 | 2450114 | Regional Multicultural Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 136 | 70 | 210 | * | 7 | * | 78 | 243 | 262 | 60 | 75 | 505 | 136 | 70 | 210 | 7 | 78 | 243 | 262 | 60 | 75 | 505 | |||||||||||||||||||||||||||||||
2778573 | 2778573 | CT | school | 903120 | 1040011 | Norwich School District | 90312000672 | 1040811 | Samuel Huntington School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 144 | 70 | 95 | 0 | * | * | 47 | 190 | * | 53 | 41 | 376 | 144 | 70 | 95 | 0 | 47 | 190 | 53 | 41 | 376 | ||||||||||||||||||||||||||||||||
2779116 | 2779116 | CT | school | 900009 | 2630013 | Odyssey Community School District | 90000900774 | 2635113 | Odyssey Community School | Public Charter Schools | Regular School | Yes | Elementary | KG | 08 | 2020 | pk_12_total | 111 | 70 | 63 | * | 61 | 0 | * | 166 | 163 | 51 | 25 | 329 | 111 | 70 | 63 | 61 | 0 | 166 | 163 | 51 | 25 | 329 | |||||||||||||||||||||||||||||||
2777740 | 2777740 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001588 | 2449614 | Center for Autism Spectrum and Development Disorders | Program | 2020 | pk_12_total | 25 | 7 | * | 0 | * | 0 | * | 30 | 10 | 0 | 40 | 40 | 25 | 7 | 0 | 0 | 30 | 10 | 0 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||
2777744 | 2777744 | CT | school | 900090 | 30011 | Ashford School District | 90009000010 | 30111 | Ashford School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 330 | 7 | 31 | 0 | * | * | 17 | 204 | 186 | 6 | 52 | 390 | 330 | 7 | 31 | 0 | 17 | 204 | 186 | 6 | 52 | 390 | |||||||||||||||||||||||||||||||
2778076 | 2778076 | CT | school | 901530 | 510011 | Fairfield School District | 90153000270 | 511411 | Stratfield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 301 | 7 | 44 | 0 | 10 | 0 | 19 | 199 | 182 | 7 | 38 | 381 | 301 | 7 | 44 | 0 | 10 | 0 | 19 | 199 | 182 | 7 | 38 | 381 | |||||||||||||||||||||||||||||
2778155 | 2778155 | CT | school | 620011 | Hamden School District | 621711 | Ridge Hill IIC | Program | 2020 | pk_12_total | 0 | 7 | * | 0 | * | 0 | 0 | * | * | 0 | 15 | 15 | 0 | 7 | 0 | 0 | 0 | 0 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||
2778164 | 2778164 | CT | school | 620011 | Hamden School District | 621511 | Dunbar Hill IIC | Program | 2020 | pk_12_total | * | 7 | * | 0 | * | 0 | * | * | * | * | 16 | 16 | 7 | 0 | 0 | 16 | 16 | |||||||||||||||||||||||||||||||||||||||||||
2778169 | 2778169 | CT | school | 620011 | Hamden School District | 620611 | Hamden Transition Academy @ SCSU (AACPB) | Program | 2020 | pk_12_total | * | 7 | 0 | 0 | * | 0 | 0 | * | * | * | 10 | 10 | 7 | 0 | 0 | 0 | 0 | 10 | 10 | |||||||||||||||||||||||||||||||||||||||||
2778190 | 2778190 | CT | school | 640011 | Hartford School District | 640610 | Pre-K Integrated - West Middle School | Program | 2020 | pk_12_total | * | 7 | 7 | 0 | * | 0 | 0 | 10 | 8 | 0 | 10 | 18 | 7 | 7 | 0 | 0 | 0 | 10 | 8 | 0 | 10 | 18 | ||||||||||||||||||||||||||||||||||||||
2778250 | 2778250 | CT | school | 2450014 | Learn | 90345001680 | 2451114 | Learn Intensive Program | Program | 2020 | pk_12_total | 12 | 7 | 9 | 0 | * | 0 | * | 27 | 8 | * | 35 | 35 | 12 | 7 | 9 | 0 | 0 | 27 | 8 | 35 | 35 | ||||||||||||||||||||||||||||||||||||||
2778297 | 2778297 | CT | school | 770011 | Manchester School District | 90231001599 | 779111 | Manchester Transition Center | Program | 2020 | pk_12_total | 11 | 7 | 8 | 0 | 0 | 0 | 0 | 17 | 9 | * | 26 | 26 | 11 | 7 | 8 | 0 | 0 | 0 | 0 | 17 | 9 | 26 | 26 | ||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778431 | 2778431 | CT | school | 902730 | 910011 | New Fairfield School District | 90273001195 | 910211 | Meeting House Hill School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 338 | 7 | 77 | * | * | 0 | 14 | 221 | 221 | 28 | 79 | 442 | 338 | 7 | 77 | 0 | 14 | 221 | 221 | 28 | 79 | 442 | |||||||||||||||||||||||||||||||
2778481 | 2778481 | CT | school | 930011 | New Haven School District | 938611 | Wexler Grant Self Contained | Program | 2020 | pk_12_total | * | 7 | * | 0 | 0 | 0 | 0 | * | * | 0 | 10 | 10 | 7 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||
2778506 | 2778506 | CT | school | 902850 | 960011 | New Milford School District | 90285000599 | 960511 | Hill And Plain School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 263 | 7 | 76 | 0 | 13 | 0 | 16 | 197 | 178 | 37 | 65 | 375 | 263 | 7 | 76 | 0 | 13 | 0 | 16 | 197 | 178 | 37 | 65 | 375 | |||||||||||||||||||||||||||||
2778566 | 2778566 | CT | school | 1030011 | Norwalk School District | 1031111 | Norwalk 18-21 Next Steps (NNS) | Program | 2020 | pk_12_total | * | 7 | * | 0 | 0 | 0 | 0 | 8 | 6 | * | 14 | 14 | 7 | 0 | 0 | 0 | 0 | 8 | 6 | 14 | 14 | |||||||||||||||||||||||||||||||||||||||
2778595 | 2778595 | CT | school | 903240 | 1080011 | Oxford School District | 90324000690 | 1085111 | Oxford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 381 | 7 | 42 | * | 10 | 0 | * | 218 | 228 | 7 | 55 | 446 | 381 | 7 | 42 | 10 | 0 | 218 | 228 | 7 | 55 | 446 | |||||||||||||||||||||||||||||||
2778614 | 2778614 | CT | school | 903330 | 1110011 | Plymouth School District | 90333001199 | 1116111 | Terryville High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 313 | 7 | 33 | 0 | 11 | 0 | 10 | 185 | 189 | * | 59 | 374 | 313 | 7 | 33 | 0 | 11 | 0 | 10 | 185 | 189 | 59 | 374 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2778637 | 2778637 | CT | school | 903520 | 2100012 | Regional School District 10 | 90352000730 | 2106112 | Lewis S. Mills High School | Regional Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 598 | 7 | 38 | 0 | 10 | 0 | 65 | 358 | 360 | * | 74 | 718 | 598 | 7 | 38 | 0 | 10 | 0 | 65 | 358 | 360 | 74 | 718 | ||||||||||||||||||||||||||||||
2778652 | 2778652 | CT | school | 903536 | 2140012 | Regional School District 14 | 90353600745 | 2146112 | Nonnewaug High School | Regional Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 603 | 7 | 34 | * | 11 | 0 | * | 284 | 379 | * | 96 | 663 | 603 | 7 | 34 | 11 | 0 | 284 | 379 | 96 | 663 | ||||||||||||||||||||||||||||||||
2778671 | 2778671 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353900759 | 2176112 | Haddam-Killingworth High School | Regional Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 590 | 7 | 15 | 0 | 11 | 0 | 14 | 326 | 311 | * | 92 | 637 | 590 | 7 | 15 | 0 | 11 | 0 | 14 | 326 | 311 | 92 | 637 | ||||||||||||||||||||||||||||||
2778697 | 2778697 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000786 | 1190511 | West Hill School | Public Schools | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 141 | 7 | 23 | * | 312 | * | 10 | 256 | 241 | 102 | 52 | 497 | 141 | 7 | 23 | 312 | 10 | 256 | 241 | 102 | 52 | 497 | |||||||||||||||||||||||||||||||
2778703 | 2778703 | CT | school | 903900 | 1210011 | Salem School District | 90390000787 | 1210111 | Salem Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 352 | 7 | 31 | * | * | 0 | 15 | * | 209 | * | 59 | 416 | 352 | 7 | 31 | 0 | 15 | 209 | 59 | 416 | |||||||||||||||||||||||||||||||||
2778773 | 2778773 | CT | school | 904290 | 1340011 | Stafford School District | 90429000061 | 1345211 | Stafford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 327 | 7 | 22 | 0 | 0 | 0 | 13 | 193 | * | 0 | 54 | 369 | 327 | 7 | 22 | 0 | 0 | 0 | 13 | 193 | 0 | 54 | 369 | ||||||||||||||||||||||||||||||
2778801 | 2778801 | CT | school | 1350011 | Stamford School District | 90432001749 | 1350211 | Individuals Achieving Independence | Program | 2020 | pk_12_total | * | 7 | * | 0 | 0 | 0 | 0 | 10 | 7 | * | 17 | 17 | 7 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||
2778803 | 2778803 | CT | school | 904350 | 1360011 | Sterling School District | 90435001491 | 1360311 | Sterling Community School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 296 | 7 | 28 | * | * | 0 | 22 | 199 | 161 | 0 | 50 | 360 | 296 | 7 | 28 | 0 | 22 | 199 | 161 | 0 | 50 | 360 | |||||||||||||||||||||||||||||||
2778806 | 2778806 | CT | school | 904380 | 1370011 | Stonington School District | 90438000877 | 1375211 | Stonington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 417 | 7 | 29 | * | * | 0 | 12 | 246 | 222 | * | 77 | 468 | 417 | 7 | 29 | 0 | 12 | 246 | 222 | 77 | 468 | ||||||||||||||||||||||||||||||||
2778887 | 2778887 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000953 | 1480211 | Highland School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 252 | 7 | 39 | 0 | 18 | 0 | 9 | 170 | 155 | 13 | 30 | 325 | 252 | 7 | 39 | 0 | 18 | 0 | 9 | 170 | 155 | 13 | 30 | 325 | |||||||||||||||||||||||||||||
2778967 | 2778967 | CT | school | 1510011 | Waterbury School District | 1517111 | School to Work Transition Academy | Program | 2020 | pk_12_total | * | 7 | 6 | 0 | * | 0 | 0 | * | * | * | 15 | 15 | 7 | 6 | 0 | 0 | 0 | 15 | 15 | |||||||||||||||||||||||||||||||||||||||||
2779025 | 2779025 | CT | school | 905010 | 1570011 | Weston School District | 90501001045 | 1570111 | Hurlbutt Elementary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 303 | 7 | 46 | 0 | 21 | 0 | 36 | 224 | 189 | 11 | 56 | 413 | 303 | 7 | 46 | 0 | 21 | 0 | 36 | 224 | 189 | 11 | 56 | 413 | |||||||||||||||||||||||||||||
2779086 | 2779086 | CT | school | 1640011 | Windsor School District | 1640311 | Spark | Program | 2020 | pk_12_total | * | 7 | * | 0 | 0 | 0 | * | * | * | 0 | 12 | 12 | 7 | 0 | 0 | 0 | 0 | 12 | 12 | |||||||||||||||||||||||||||||||||||||||||
2779177 | 2779177 | CT | school | 903780 | 2090012 | Regional School District 09 | 90378000773 | 2096112 | Joel Barlow High School | Regional Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 712 | 7 | 59 | 0 | 33 | 0 | 44 | 430 | 425 | * | 105 | 855 | 712 | 7 | 59 | 0 | 33 | 0 | 44 | 430 | 425 | 105 | 855 | ||||||||||||||||||||||||||||||
2778058 | 2778058 | CT | school | 901470 | 490011 | Enfield School District | 90147000249 | 495211 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 751 | 69 | 186 | * | * | 0 | 47 | 554 | 524 | 19 | 168 | 1078 | 751 | 69 | 186 | 0 | 47 | 554 | 524 | 19 | 168 | 1078 | |||||||||||||||||||||||||||||||
2778103 | 2778103 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000283 | 546111 | Glastonbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1415 | 69 | 155 | * | 215 | * | 87 | 928 | 1019 | 9 | 202 | 1947 | 1415 | 69 | 155 | 215 | 87 | 928 | 1019 | 9 | 202 | 1947 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2778459 | 2778459 | CT | school | 902790 | 930011 | New Haven School District | 90279000568 | 931411 | Nathan Hale School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 217 | 69 | 230 | * | * | 0 | 11 | 269 | 266 | 48 | 76 | 535 | 217 | 69 | 230 | 0 | 11 | 269 | 266 | 48 | 76 | 535 | |||||||||||||||||||||||||||||||
2778733 | 2778733 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000813 | 1286111 | Simsbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1027 | 69 | 115 | 0 | 89 | * | * | 689 | 641 | 9 | 169 | 1330 | 1027 | 69 | 115 | 0 | 89 | 689 | 641 | 9 | 169 | 1330 | |||||||||||||||||||||||||||||||
2778777 | 2778777 | CT | school | 904320 | 1350011 | Stamford School District | 90432000852 | 1352011 | Davenport Ridge School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 278 | 69 | 212 | 0 | 45 | * | * | 317 | 316 | 72 | 60 | 633 | 278 | 69 | 212 | 0 | 45 | 317 | 316 | 72 | 60 | 633 | |||||||||||||||||||||||||||||||
2778789 | 2778789 | CT | school | 904320 | 1350011 | Stamford School District | 90432001916 | 1350711 | Strawberry Hill an ext. of Rogers International | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 153 | 69 | 179 | * | 83 | 0 | * | 248 | 275 | 11 | 46 | 523 | 153 | 69 | 179 | 83 | 0 | 248 | 275 | 11 | 46 | 523 | |||||||||||||||||||||||||||||||
2779101 | 2779101 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 684 | 381 | * | 0 | 0 | 20 | 498 | 605 | 111 | 80 | 1103 | 684 | 381 | 0 | 0 | 20 | 498 | 605 | 111 | 80 | 1103 | |||||||||||||||||||||||||||||||
2778726 | 2778726 | CT | school | 900016 | 2700013 | Side By Side Charter School District | 90001600823 | 2700113 | Side By Side Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 25 | 68 | 127 | 0 | * | 0 | * | 116 | 120 | 23 | 25 | 236 | 25 | 68 | 127 | 0 | 0 | 116 | 120 | 23 | 25 | 236 | |||||||||||||||||||||||||||||||
2778910 | 2778910 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000968 | 1510511 | Bucks Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 24 | 68 | 244 | 0 | * | 0 | * | 180 | 170 | 58 | 68 | 350 | 24 | 68 | 244 | 0 | 0 | 180 | 170 | 58 | 68 | 350 | |||||||||||||||||||||||||||||||
2777860 | 2777860 | CT | school | 900510 | 170011 | Bristol School District | 90051000093 | 176211 | Bristol Eastern High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 677 | 67 | 260 | * | 36 | * | 35 | * | 545 | 30 | 216 | 1079 | 677 | 67 | 260 | 36 | 35 | 545 | 30 | 216 | 1079 | ||||||||||||||||||||||||||||||||
2777972 | 2777972 | CT | school | 901110 | 370011 | Derby School District | 90111000178 | 370411 | Irving School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 70 | 67 | 135 | 0 | * | 0 | * | 172 | 134 | 14 | 62 | 306 | 70 | 67 | 135 | 0 | 0 | 172 | 134 | 14 | 62 | 306 | |||||||||||||||||||||||||||||||
2777998 | 2777998 | CT | school | 430011 | East Hartford School District | 90126000205 | 439011 | Woodland School | Program | 2020 | pk_12_total | 27 | 67 | 98 | * | * | 0 | 11 | 166 | 40 | 24 | * | 206 | 27 | 67 | 98 | 0 | 11 | 166 | 40 | 24 | 206 | ||||||||||||||||||||||||||||||||||||||
2778453 | 2778453 | CT | school | 902790 | 930011 | New Haven School District | 90279001443 | 931311 | John C. Daniels | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 58 | 67 | 377 | 0 | 7 | 0 | 7 | 269 | 247 | 152 | 54 | 516 | 58 | 67 | 377 | 0 | 7 | 0 | 7 | 269 | 247 | 152 | 54 | 516 | |||||||||||||||||||||||||||||
2778480 | 2778480 | CT | school | 902790 | 930011 | New Haven School District | 90279000588 | 933811 | Worthington Hooker School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 187 | 67 | 54 | 0 | 98 | 0 | 11 | 211 | 206 | 63 | 33 | 417 | 187 | 67 | 54 | 0 | 98 | 0 | 11 | 211 | 206 | 63 | 33 | 417 | |||||||||||||||||||||||||||||
2778546 | 2778546 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000648 | 1030711 | Jefferson Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 32 | 67 | 331 | * | 53 | 0 | * | 293 | 211 | 140 | 55 | 504 | 32 | 67 | 331 | 53 | 0 | 293 | 211 | 140 | 55 | 504 | |||||||||||||||||||||||||||||||
2778550 | 2778550 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000642 | 1030311 | Columbus Magnet School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 137 | 67 | 110 | * | 17 | * | 12 | 179 | 168 | 31 | 46 | 347 | 137 | 67 | 110 | 17 | 12 | 179 | 168 | 31 | 46 | 347 | |||||||||||||||||||||||||||||||
2778555 | 2778555 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000660 | 1031411 | Tracey Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 69 | 67 | 249 | 0 | 31 | 0 | 19 | 248 | 187 | 121 | 76 | 435 | 69 | 67 | 249 | 0 | 31 | 0 | 19 | 248 | 187 | 121 | 76 | 435 | |||||||||||||||||||||||||||||
2778812 | 2778812 | CT | school | 904440 | 1380011 | Stratford School District | 90444001805 | 1382211 | Stratford Academy - Victoria Soto School | Public Schools | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 44 | 67 | 131 | 0 | * | 0 | * | 123 | 136 | 30 | 21 | 259 | 44 | 67 | 131 | 0 | 0 | 123 | 136 | 30 | 21 | 259 | |||||||||||||||||||||||||||||||
2779013 | 2779013 | CT | school | 904950 | 1560011 | West Haven School District | 90495001039 | 1560411 | Seth G. Haley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 194 | 67 | 108 | 0 | 22 | 0 | 17 | 209 | 199 | 79 | 73 | 408 | 194 | 67 | 108 | 0 | 22 | 0 | 17 | 209 | 199 | 79 | 73 | 408 | |||||||||||||||||||||||||||||
2777990 | 2777990 | CT | school | 901260 | 430011 | East Hartford School District | 90126000191 | 430911 | Anna E. Norris School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 12 | 66 | 192 | 0 | 8 | 0 | 16 | 161 | 133 | 71 | 56 | 294 | 12 | 66 | 192 | 0 | 8 | 0 | 16 | 161 | 133 | 71 | 56 | 294 | |||||||||||||||||||||||||||||
2778470 | 2778470 | CT | school | 902790 | 930011 | New Haven School District | 90279000550 | 930611 | Clinton Avenue School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 31 | 66 | 349 | 0 | * | 0 | * | 236 | 218 | 168 | 67 | 454 | 31 | 66 | 349 | 0 | 0 | 236 | 218 | 168 | 67 | 454 | |||||||||||||||||||||||||||||||
2778240 | 2778240 | CT | school | 900007 | 2610013 | Jumoke Academy District | 90000700747 | 2610113 | Jumoke Academy | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | pk_12_total | * | 650 | 39 | * | * | 0 | 8 | * | 367 | 6 | 42 | 706 | 650 | 39 | 0 | 8 | 367 | 6 | 42 | 706 | |||||||||||||||||||||||||||||||||
2777973 | 2777973 | CT | school | 901110 | 370011 | Derby School District | 90111001578 | 375011 | Derby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 138 | 65 | 128 | 0 | * | * | 18 | 184 | 177 | * | 74 | 361 | 138 | 65 | 128 | 0 | 18 | 184 | 177 | 74 | 361 | ||||||||||||||||||||||||||||||||
2778406 | 2778406 | CT | school | 902670 | 890011 | New Britain School District | 90267000515 | 890811 | Lincoln Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 95 | 65 | 428 | * | * | 0 | 26 | 318 | 302 | 111 | 120 | 620 | 95 | 65 | 428 | 0 | 26 | 318 | 302 | 111 | 120 | 620 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2779181 | 2779181 | CT | school | 900031 | 2820013 | Stamford Academy District | 90003101405 | 2826013 | Stamford Academy | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 11 | 65 | 64 | 0 | 0 | 0 | 7 | 85 | 62 | 14 | 52 | 147 | 11 | 65 | 64 | 0 | 0 | 0 | 7 | 85 | 62 | 14 | 52 | 147 | ||||||||||||||||||||||||||||||
2778154 | 2778154 | CT | school | 901860 | 620011 | Hamden School District | 90186000336 | 621211 | Bear Path School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 226 | 64 | 77 | 0 | 23 | 0 | 26 | 204 | 212 | 18 | 36 | 416 | 226 | 64 | 77 | 0 | 23 | 0 | 26 | 204 | 212 | 18 | 36 | 416 | |||||||||||||||||||||||||||||
2779010 | 2779010 | CT | school | 904950 | 1560011 | West Haven School District | 90495001033 | 1560611 | Edith E. Mackrille School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 113 | 64 | 96 | * | 26 | 0 | * | 151 | 157 | 56 | 51 | 308 | 113 | 64 | 96 | 26 | 0 | 151 | 157 | 56 | 51 | 308 | |||||||||||||||||||||||||||||||
2778137 | 2778137 | CT | school | 901770 | 590011 | Groton School District | 90177000326 | 595211 | West Side Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 209 | 63 | 150 | * | 26 | * | 49 | 306 | 197 | 19 | 108 | 503 | 209 | 63 | 150 | 26 | 49 | 306 | 197 | 19 | 108 | 503 | ||||||||||||||||||||||||||||||||
2778213 | 2778213 | CT | school | 901920 | 640011 | Hartford School District | 90192001616 | 643811 | Betances STEM Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 39 | 63 | 129 | * | 13 | 0 | * | 153 | 100 | 31 | 39 | 253 | 39 | 63 | 129 | 13 | 0 | 153 | 100 | 31 | 39 | 253 | |||||||||||||||||||||||||||||||
2778574 | 2778574 | CT | school | 903120 | 1040011 | Norwich School District | 90312000676 | 1041911 | Uncas Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 52 | 63 | 108 | 0 | * | * | 23 | 133 | 125 | 74 | 40 | 258 | 52 | 63 | 108 | 0 | 23 | 133 | 125 | 74 | 40 | 258 | |||||||||||||||||||||||||||||||
2778159 | 2778159 | CT | school | 901860 | 620011 | Hamden School District | 90186000349 | 621411 | West Woods School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 161 | 62 | 43 | * | 48 | 0 | * | 179 | 162 | 21 | 38 | 341 | 161 | 62 | 43 | 48 | 0 | 179 | 162 | 21 | 38 | 341 | |||||||||||||||||||||||||||||||
2778936 | 2778936 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000978 | 1511311 | Hopeville School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 46 | 62 | 191 | * | 0 | 0 | * | 161 | 156 | 57 | 39 | 317 | 46 | 62 | 191 | 0 | 0 | 161 | 156 | 57 | 39 | 317 | |||||||||||||||||||||||||||||||
2779008 | 2779008 | CT | school | 904950 | 1560011 | West Haven School District | 90495001040 | 1561211 | Washington School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 105 | 62 | 225 | * | * | 0 | 22 | 227 | 193 | 117 | 58 | 420 | 105 | 62 | 225 | 0 | 22 | 227 | 193 | 117 | 58 | 420 | |||||||||||||||||||||||||||||||
2778957 | 2778957 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001395 | 1515011 | Waterbury Arts Magnet School (Middle) | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 136 | 61 | 144 | * | * | 0 | 20 | 158 | 209 | 8 | 49 | 367 | 136 | 61 | 144 | 0 | 20 | 158 | 209 | 8 | 49 | 367 | |||||||||||||||||||||||||||||||
2778487 | 2778487 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 47 | 604 | 394 | * | 12 | * | 14 | 568 | 506 | 190 | 224 | 1074 | 47 | 604 | 394 | 12 | 14 | 568 | 506 | 190 | 224 | 1074 | |||||||||||||||||||||||||||||||
2777850 | 2777850 | CT | school | 900510 | 170011 | Bristol School District | 90051000089 | 175111 | Chippens Hill Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 350 | 60 | 249 | 0 | 34 | 0 | 27 | 347 | 373 | 46 | 119 | 720 | 350 | 60 | 249 | 0 | 34 | 0 | 27 | 347 | 373 | 46 | 119 | 720 | |||||||||||||||||||||||||||||
2778409 | 2778409 | CT | school | 902670 | 890011 | New Britain School District | 90267000524 | 891311 | Smith Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 70 | 60 | 354 | * | * | 0 | 16 | 263 | 251 | 90 | 72 | 514 | 70 | 60 | 354 | 0 | 16 | 263 | 251 | 90 | 72 | 514 | |||||||||||||||||||||||||||||||
2778490 | 2778490 | CT | school | 930011 | New Haven School District | 90279001550 | 939111 | Riverside Education Academy | Program | 2020 | pk_12_total | * | 60 | * | 0 | 0 | 0 | 0 | 57 | 40 | 6 | 46 | 97 | 60 | 0 | 0 | 0 | 0 | 57 | 40 | 6 | 46 | 97 | |||||||||||||||||||||||||||||||||||||
2777970 | 2777970 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 21 | 6 | 15 | 0 | 0 | 0 | 7 | 24 | 25 | 0 | 19 | 49 | 21 | 6 | 15 | 0 | 0 | 0 | 7 | 24 | 25 | 0 | 19 | 49 | |||||||||||||||||||||||||||||
2778026 | 2778026 | CT | school | 901410 | 460011 | Easton School District | 90141000233 | 465111 | Helen Keller Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 257 | 6 | 26 | 0 | 31 | 0 | 0 | 156 | 164 | * | 45 | 320 | 257 | 6 | 26 | 0 | 31 | 0 | 0 | 156 | 164 | 45 | 320 | ||||||||||||||||||||||||||||||
2778068 | 2778068 | CT | school | 901530 | 510011 | Fairfield School District | 90153000257 | 510111 | Dwight Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 225 | 6 | 12 | 0 | 14 | 0 | 17 | 151 | 123 | * | 42 | 274 | 225 | 6 | 12 | 0 | 14 | 0 | 17 | 151 | 123 | 42 | 274 |
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]);