enrollments
Data source: Big Local News · About: Big Local
1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by ccd_school_lvl descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2779120 | 2779120 | CT | school | 900219 | 2940013 | Great Oaks Charter School District | 90021901782 | 2940113 | Great Oaks Charter School | Public Charter Schools | Regular School | Yes | Secondary | 06 | 11 | 2020 | pk_12_total | 32 | 266 | 250 | * | 0 | * | * | 262 | 293 | 66 | 93 | 555 | 32 | 266 | 250 | 0 | 262 | 293 | 66 | 93 | 555 | ||||||||||||||||||||||||||||||||
2777768 | 2777768 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 107 | 110 | 38 | * | 33 | 0 | * | 159 | 155 | 0 | 49 | 314 | 107 | 110 | 38 | 33 | 0 | 159 | 155 | 0 | 49 | 314 | |||||||||||||||||||||||||||||||
2777790 | 2777790 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 36 | 46 | 121 | 0 | * | 0 | * | 141 | 69 | 0 | 137 | 210 | 36 | 46 | 121 | 0 | 0 | 141 | 69 | 0 | 137 | 210 | |||||||||||||||||||||||||||||||
2777829 | 2777829 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 68 | 0 | 31 | 0 | * | 0 | * | 75 | 38 | 0 | 70 | 113 | 68 | 0 | 31 | 0 | 0 | 75 | 38 | 0 | 70 | 113 | |||||||||||||||||||||||||||||||
2777943 | 2777943 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 46 | * | 81 | 0 | 13 | 0 | * | 101 | 54 | 0 | 80 | 155 | 46 | 81 | 0 | 13 | 0 | 101 | 54 | 0 | 80 | 155 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2778180 | 2778180 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 18 | 56 | 26 | * | 56 | 0 | * | 76 | 85 | 0 | 9 | 161 | 18 | 56 | 26 | 56 | 0 | 76 | 85 | 0 | 9 | 161 | |||||||||||||||||||||||||||||||
2778549 | 2778549 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 53 | 15 | 67 | * | 12 | 0 | * | 84 | 71 | 0 | 92 | 155 | 53 | 15 | 67 | 12 | 0 | 84 | 71 | 0 | 92 | 155 | |||||||||||||||||||||||||||||||
2778568 | 2778568 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 54 | 34 | 66 | * | 10 | * | 12 | 97 | 81 | 0 | 61 | 178 | 54 | 34 | 66 | 10 | 12 | 97 | 81 | 0 | 61 | 178 | |||||||||||||||||||||||||||||||
2778673 | 2778673 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 37 | 34 | 0 | 12 | 71 | 0 | 0 | 0 | 0 | 0 | 37 | 34 | 0 | 12 | 71 | |||||||||||||||||||||||||||||||
2778748 | 2778748 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 63 | 0 | 7 | 0 | * | 0 | * | 50 | 27 | 0 | 52 | 77 | 63 | 0 | 7 | 0 | 0 | 50 | 27 | 0 | 52 | 77 | |||||||||||||||||||||||||||||||
2778175 | 2778175 | CT | school | 901920 | 640011 | Hartford School District | 90192001435 | 646911 | Capital Preparatory Magnet School | Public Schools | Regular School | No | Other | PK | 12 | 2020 | pk_12_total | 40 | 392 | 162 | 0 | 10 | 0 | 27 | 318 | 313 | 31 | 95 | 631 | 40 | 392 | 162 | 0 | 10 | 0 | 27 | 318 | 313 | 31 | 95 | 631 | |||||||||||||||||||||||||||||
2778182 | 2778182 | CT | school | 901920 | 640011 | Hartford School District | 90192000370 | 641111 | Kinsella Magnet School of Performing Arts | Public Schools | Regular School | No | Other | PK | 12 | 2020 | pk_12_total | 136 | 166 | 346 | * | * | 0 | 30 | 275 | 436 | 69 | 137 | 711 | 136 | 166 | 346 | 0 | 30 | 275 | 436 | 69 | 137 | 711 | |||||||||||||||||||||||||||||||
2778201 | 2778201 | CT | school | 901920 | 640011 | Hartford School District | 90192001535 | 643611 | Global Communications Academy | Public Schools | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | * | 326 | 238 | 0 | * | 0 | 11 | 275 | 308 | 87 | 104 | 583 | 326 | 238 | 0 | 0 | 11 | 275 | 308 | 87 | 104 | 583 | |||||||||||||||||||||||||||||||
2778238 | 2778238 | CT | school | 900207 | 2860013 | Highville Charter School District | 90020700907 | 2860113 | Highville Charter School | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | pk_12_total | 6 | 426 | 20 | * | 0 | * | * | 200 | 260 | * | 24 | 460 | 6 | 426 | 20 | 0 | 200 | 260 | 24 | 460 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2779099 | 2779099 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 13 | 596 | 487 | * | 6 | * | * | 524 | 586 | 148 | 112 | 1110 | 13 | 596 | 487 | 6 | 524 | 586 | 148 | 112 | 1110 | ||||||||||||||||||||||||||||||||
2779100 | 2779100 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 842 | 299 | 6 | * | * | 15 | 553 | 616 | 70 | 117 | 1169 | 842 | 299 | 6 | 15 | 553 | 616 | 70 | 117 | 1169 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2779104 | 2779104 | CT | school | 900221 | 2970013 | Capital Preparatory Harbor School District | 90022101803 | 2970113 | Capital Preparatory Harbor School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 539 | 211 | 0 | 0 | 0 | * | 387 | 373 | 50 | 77 | 760 | 539 | 211 | 0 | 0 | 0 | 387 | 373 | 50 | 77 | 760 | |||||||||||||||||||||||||||||||
2779115 | 2779115 | 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 | 2020 | pk_12_total | 21 | 522 | 213 | * | * | 0 | 9 | 373 | 394 | 53 | 70 | 767 | 21 | 522 | 213 | 0 | 9 | 373 | 394 | 53 | 70 | 767 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2777739 | 2777739 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007001358 | 2445114 | Thomas Edison Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 144 | 100 | 381 | * | 36 | 0 | * | 342 | 356 | 67 | 79 | 698 | 144 | 100 | 381 | 36 | 0 | 342 | 356 | 67 | 79 | 698 | |||||||||||||||||||||||||||||||
2777748 | 2777748 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 306 | 31 | 39 | * | 105 | 0 | * | 237 | 265 | 8 | 57 | 502 | 306 | 31 | 39 | 105 | 0 | 237 | 265 | 8 | 57 | 502 | |||||||||||||||||||||||||||||||
2777749 | 2777749 | CT | school | 900120 | 40011 | Avon School District | 90012000012 | 45111 | Avon Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 325 | 26 | 36 | 0 | 123 | 0 | 16 | 248 | 278 | 7 | 54 | 526 | 325 | 26 | 36 | 0 | 123 | 0 | 16 | 248 | 278 | 7 | 54 | 526 | |||||||||||||||||||||||||||||
2777757 | 2777757 | CT | school | 900210 | 70011 | Berlin School District | 90021000017 | 75111 | Catherine M. McGee Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 503 | 18 | 82 | 0 | 21 | 0 | 20 | 321 | 323 | 12 | 109 | 644 | 503 | 18 | 82 | 0 | 21 | 0 | 20 | 321 | 323 | 12 | 109 | 644 | |||||||||||||||||||||||||||||
2777764 | 2777764 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 518 | 23 | 184 | 7 | 52 | 0 | 22 | 402 | 404 | 27 | 82 | 806 | 518 | 23 | 184 | 7 | 52 | 0 | 22 | 402 | 404 | 27 | 82 | 806 | |||||||||||||||||||||||||||||
2777772 | 2777772 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 9 | 191 | 30 | * | * | 0 | 8 | 118 | 123 | * | 56 | 241 | 9 | 191 | 30 | 0 | 8 | 118 | 123 | 56 | 241 | ||||||||||||||||||||||||||||||||
2777774 | 2777774 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 7 | 220 | 28 | * | * | 0 | 10 | 134 | 134 | * | 58 | 268 | 7 | 220 | 28 | 0 | 10 | 134 | 134 | 58 | 268 | ||||||||||||||||||||||||||||||||
2777785 | 2777785 | CT | school | 900420 | 140011 | Branford School District | 90042000041 | 145111 | Francis Walsh Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 627 | 39 | 91 | * | 68 | 0 | * | 451 | 404 | 31 | 105 | 855 | 627 | 39 | 91 | 68 | 0 | 451 | 404 | 31 | 105 | 855 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2777858 | 2777858 | CT | school | 900510 | 170011 | Bristol School District | 90051000104 | 175211 | Northeast Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 281 | 37 | 106 | 0 | 24 | 0 | 21 | 237 | 232 | 15 | 81 | 469 | 281 | 37 | 106 | 0 | 24 | 0 | 21 | 237 | 232 | 15 | 81 | 469 | |||||||||||||||||||||||||||||
2777866 | 2777866 | CT | school | 900540 | 180011 | Brookfield School District | 90054000112 | 185311 | Whisconier Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 628 | 17 | 111 | * | 61 | * | * | 416 | 413 | 25 | 125 | 829 | 628 | 17 | 111 | 61 | 416 | 413 | 25 | 125 | 829 | ||||||||||||||||||||||||||||||||
2777869 | 2777869 | CT | school | 900570 | 190011 | Brooklyn School District | 90057000114 | 195111 | Brooklyn Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 268 | * | 34 | 0 | 11 | * | 20 | 184 | 156 | * | 56 | 340 | 268 | 34 | 0 | 11 | 20 | 184 | 156 | 56 | 340 | ||||||||||||||||||||||||||||||||
2777871 | 2777871 | CT | school | 900660 | 220011 | Canterbury School District | 90066001187 | 225111 | Dr. Helen Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 165 | 0 | 9 | * | * | 0 | 0 | 84 | 93 | 0 | 19 | 177 | 165 | 0 | 9 | 0 | 0 | 84 | 93 | 0 | 19 | 177 | |||||||||||||||||||||||||||||||
2777873 | 2777873 | CT | school | 900690 | 230011 | Canton School District | 90069000119 | 230311 | Canton Intermediate School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 288 | 30 | 23 | 0 | 12 | * | * | 169 | 192 | * | 44 | 361 | 288 | 30 | 23 | 0 | 12 | 169 | 192 | 44 | 361 | ||||||||||||||||||||||||||||||||
2777874 | 2777874 | CT | school | 900690 | 230011 | Canton School District | 90069001376 | 235111 | Canton Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 197 | 20 | 24 | 0 | * | 0 | * | * | 125 | * | 34 | 250 | 197 | 20 | 24 | 0 | 0 | 125 | 34 | 250 | |||||||||||||||||||||||||||||||||
2777893 | 2777893 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001625 | 2415314 | Greater Hartford Academy of the Arts Magnet Middle | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 63 | 80 | 172 | 0 | * | * | 17 | 81 | 253 | 21 | 78 | 334 | 63 | 80 | 172 | 0 | 17 | 81 | 253 | 21 | 78 | 334 | |||||||||||||||||||||||||||||||
2777895 | 2777895 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001364 | 2415014 | Two Rivers Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 120 | 202 | 302 | * | * | 0 | 23 | 375 | 291 | 60 | 136 | 666 | 120 | 202 | 302 | 0 | 23 | 375 | 291 | 60 | 136 | 666 | |||||||||||||||||||||||||||||||
2777910 | 2777910 | CT | school | 900750 | 250011 | Cheshire School District | 90075000125 | 255111 | Dodd Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 520 | 20 | 34 | * | 59 | 0 | * | 319 | 332 | * | 76 | 651 | 520 | 20 | 34 | 59 | 0 | 319 | 332 | 76 | 651 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2777920 | 2777920 | CT | school | 900840 | 280011 | Colchester School District | 90084000136 | 285111 | William J. Johnston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 434 | * | 39 | * | 16 | 0 | 22 | 259 | 258 | * | 79 | 517 | 434 | 39 | 16 | 0 | 22 | 259 | 258 | 79 | 517 | ||||||||||||||||||||||||||||||||
2777936 | 2777936 | CT | school | 900960 | 320011 | Coventry School District | 90096000141 | 325111 | Capt. Nathan Hale School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 355 | * | 23 | 0 | * | 0 | 13 | 204 | 196 | 0 | 51 | 400 | 355 | 23 | 0 | 0 | 13 | 204 | 196 | 0 | 51 | 400 | |||||||||||||||||||||||||||||||
2777941 | 2777941 | CT | school | 900990 | 330011 | Cromwell School District | 90099000147 | 335111 | Cromwell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 314 | 43 | 56 | * | 28 | * | 10 | 252 | 202 | 10 | 47 | 454 | 314 | 43 | 56 | 28 | 10 | 252 | 202 | 10 | 47 | 454 | |||||||||||||||||||||||||||||||
2777957 | 2777957 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 335 | 88 | 484 | * | 45 | 0 | * | 506 | 483 | 154 | 170 | 989 | 335 | 88 | 484 | 45 | 0 | 506 | 483 | 154 | 170 | 989 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2777959 | 2777959 | CT | school | 901020 | 340011 | Danbury School District | 90102001691 | 340311 | Westside Middle School Academy | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 325 | 47 | 245 | 0 | 57 | 0 | 17 | 351 | 340 | 56 | 52 | 691 | 325 | 47 | 245 | 0 | 57 | 0 | 17 | 351 | 340 | 56 | 52 | 691 | |||||||||||||||||||||||||||||
2777968 | 2777968 | CT | school | 901050 | 350011 | Darien School District | 90105000169 | 355111 | Middlesex Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 979 | * | 65 | * | 66 | 0 | 33 | 584 | 572 | 6 | 169 | 1156 | 979 | 65 | 66 | 0 | 33 | 584 | 572 | 6 | 169 | 1156 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2777979 | 2777979 | CT | school | 901170 | 400011 | East Granby School District | 90117000182 | 405111 | East Granby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 144 | 20 | * | 0 | 20 | 0 | * | 100 | 99 | * | 26 | 199 | 144 | 20 | 0 | 20 | 0 | 100 | 99 | 26 | 199 | ||||||||||||||||||||||||||||||||
2777982 | 2777982 | CT | school | 901200 | 410011 | East Haddam School District | 90120000198 | 415111 | Nathan Hale-Ray Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2020 | pk_12_total | 342 | * | 18 | * | * | 0 | 9 | 192 | 187 | * | 62 | 379 | 342 | 18 | 0 | 9 | 192 | 187 | 62 | 379 | |||||||||||||||||||||||||||||||||
2777986 | 2777986 | CT | school | 901230 | 420011 | East Hampton School District | 90123000188 | 425111 | East Hampton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 412 | * | 29 | * | * | * | 12 | 218 | 244 | 0 | 57 | 462 | 412 | 29 | 12 | 218 | 244 | 0 | 57 | 462 | |||||||||||||||||||||||||||||||||
2777999 | 2777999 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 106 | 358 | 564 | * | 39 | * | 60 | 612 | 521 | 162 | 242 | 1133 | 106 | 358 | 564 | 39 | 60 | 612 | 521 | 162 | 242 | 1133 | |||||||||||||||||||||||||||||||
2778000 | 2778000 | CT | school | 901260 | 430011 | East Hartford School District | 90126001275 | 432411 | Sunset Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 41 | 94 | 168 | 0 | 13 | 0 | 17 | 165 | 168 | 8 | 48 | 333 | 41 | 94 | 168 | 0 | 13 | 0 | 17 | 165 | 168 | 8 | 48 | 333 | |||||||||||||||||||||||||||||
2778010 | 2778010 | CT | school | 901290 | 440011 | East Haven School District | 90129000217 | 445111 | Joseph Melillo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 272 | 40 | 184 | * | 12 | 0 | * | 257 | 263 | 51 | 82 | 520 | 272 | 40 | 184 | 12 | 0 | 257 | 263 | 51 | 82 | 520 | |||||||||||||||||||||||||||||||
2778016 | 2778016 | CT | school | 901320 | 450011 | East Lyme School District | 90132000224 | 455111 | East Lyme Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 589 | * | 68 | * | 77 | 0 | 38 | 404 | 385 | 7 | 129 | 789 | 589 | 68 | 77 | 0 | 38 | 404 | 385 | 7 | 129 | 789 | |||||||||||||||||||||||||||||||
2778021 | 2778021 | CT | school | 901350 | 470011 | East Windsor School District | 90135000230 | 475411 | East Windsor Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 170 | 33 | 72 | * | * | 0 | 11 | 137 | 160 | 6 | 52 | 297 | 170 | 33 | 72 | 0 | 11 | 137 | 160 | 6 | 52 | 297 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2778036 | 2778036 | CT | school | 901440 | 480011 | Ellington School District | 90144000238 | 485111 | Ellington Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 325 | 18 | 17 | * | 41 | 0 | * | 192 | 222 | * | 62 | 414 | 325 | 18 | 17 | 41 | 0 | 192 | 222 | 62 | 414 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778077 | 2778077 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 669 | 20 | 105 | 0 | 67 | 0 | 42 | 473 | 430 | 15 | 127 | 903 | 669 | 20 | 105 | 0 | 67 | 0 | 42 | 473 | 430 | 15 | 127 | 903 | |||||||||||||||||||||||||||||
2778078 | 2778078 | CT | school | 901530 | 510011 | Fairfield School District | 90153000919 | 515311 | Roger Ludlowe Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 706 | * | 53 | * | 42 | 0 | 34 | 441 | 404 | * | 107 | 845 | 706 | 53 | 42 | 0 | 34 | 441 | 404 | 107 | 845 | ||||||||||||||||||||||||||||||||
2778079 | 2778079 | CT | school | 901530 | 510011 | Fairfield School District | 90153000271 | 515111 | Tomlinson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 442 | 21 | 114 | * | 50 | * | 34 | 344 | 319 | 21 | 79 | 663 | 442 | 21 | 114 | 50 | 34 | 344 | 319 | 21 | 79 | 663 | |||||||||||||||||||||||||||||||
2778089 | 2778089 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 363 | 33 | 55 | * | 160 | 0 | * | 313 | 321 | 19 | 79 | 634 | 363 | 33 | 55 | 160 | 0 | 313 | 321 | 19 | 79 | 634 | |||||||||||||||||||||||||||||||
2778090 | 2778090 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 388 | 35 | 65 | * | 172 | 0 | * | 346 | 337 | 8 | 78 | 683 | 388 | 35 | 65 | 172 | 0 | 346 | 337 | 8 | 78 | 683 | |||||||||||||||||||||||||||||||
2778101 | 2778101 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000279 | 540811 | Gideon Welles School | Public Schools | Regular School | No | Middle | 06 | 06 | 2020 | pk_12_total | 312 | * | 45 | * | 54 | 0 | 28 | 230 | 219 | * | 44 | 449 | 312 | 45 | 54 | 0 | 28 | 230 | 219 | 44 | 449 | ||||||||||||||||||||||||||||||||
2778102 | 2778102 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 640 | * | 97 | * | 120 | 0 | 54 | * | 494 | 13 | 110 | 944 | 640 | 97 | 120 | 0 | 54 | 494 | 13 | 110 | 944 | ||||||||||||||||||||||||||||||||
2778107 | 2778107 | CT | school | 901680 | 560011 | Granby School District | 90168000291 | 565111 | Granby Memorial Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 353 | 25 | 14 | * | * | 0 | 12 | 207 | 208 | 0 | 64 | 415 | 353 | 25 | 14 | 0 | 12 | 207 | 208 | 0 | 64 | 415 | |||||||||||||||||||||||||||||||
2778120 | 2778120 | CT | school | 901710 | 570011 | Greenwich School District | 90171000295 | 575111 | Central Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 400 | 11 | 106 | 0 | 30 | 0 | 40 | 304 | 283 | 23 | 71 | 587 | 400 | 11 | 106 | 0 | 30 | 0 | 40 | 304 | 283 | 23 | 71 | 587 | |||||||||||||||||||||||||||||
2778121 | 2778121 | CT | school | 901710 | 570011 | Greenwich School District | 90171000298 | 575211 | Eastern Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 589 | * | 114 | * | 97 | 0 | 50 | 456 | 406 | 13 | 101 | 862 | 589 | 114 | 97 | 0 | 50 | 456 | 406 | 13 | 101 | 862 | |||||||||||||||||||||||||||||||
2778122 | 2778122 | CT | school | 901710 | 570011 | Greenwich School District | 90171000309 | 575311 | Western Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 286 | 29 | 243 | * | 51 | 0 | * | 335 | 297 | 31 | 99 | 632 | 286 | 29 | 243 | 51 | 0 | 335 | 297 | 31 | 99 | 632 | |||||||||||||||||||||||||||||||
2778127 | 2778127 | CT | school | 901740 | 580011 | Griswold School District | 90174000019 | 585111 | Griswold Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 431 | 15 | 54 | * | * | 0 | 47 | 287 | 272 | 8 | 89 | 559 | 431 | 15 | 54 | 0 | 47 | 287 | 272 | 8 | 89 | 559 | |||||||||||||||||||||||||||||||
2778136 | 2778136 | CT | school | 901770 | 590011 | Groton School District | 90177000312 | 595311 | Carl C. Cutler Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 311 | 21 | 83 | * | 30 | * | 57 | 214 | 297 | 8 | 75 | 511 | 311 | 21 | 83 | 30 | 57 | 214 | 297 | 8 | 75 | 511 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2778146 | 2778146 | CT | school | 901800 | 600011 | Guilford School District | 90180000328 | 600711 | A. Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 389 | * | 31 | 0 | 21 | * | 25 | 251 | 221 | 11 | 54 | 472 | 389 | 31 | 0 | 21 | 25 | 251 | 221 | 11 | 54 | 472 | |||||||||||||||||||||||||||||||
2778147 | 2778147 | CT | school | 901800 | 600011 | Guilford School District | 90180000331 | 605111 | E. C. Adams Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 437 | * | 50 | 0 | 27 | 0 | * | 294 | 249 | * | 69 | 543 | 437 | 50 | 0 | 27 | 0 | 294 | 249 | 69 | 543 | ||||||||||||||||||||||||||||||||
2778166 | 2778166 | CT | school | 901860 | 620011 | Hamden School District | 90186000342 | 625211 | Hamden Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 297 | 273 | 205 | * | 54 | * | 45 | 449 | 427 | 31 | 160 | 876 | 297 | 273 | 205 | 54 | 45 | 449 | 427 | 31 | 160 | 876 | |||||||||||||||||||||||||||||||
2778212 | 2778212 | CT | school | 901920 | 640011 | Hartford School District | 90192001582 | 644011 | Renzulli Gifted and Talented Academy | Public Schools | Regular School | No | Middle | 04 | 08 | 2020 | pk_12_total | 12 | 43 | 53 | * | 12 | 0 | * | 73 | 56 | * | * | 129 | 12 | 43 | 53 | 12 | 0 | 73 | 56 | 129 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778217 | 2778217 | CT | school | 901920 | 640011 | Hartford School District | 90192000369 | 641611 | M. L. King, Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | * | 121 | 42 | 0 | * | 0 | * | 97 | 72 | 17 | 45 | 169 | 121 | 42 | 0 | 0 | 97 | 72 | 17 | 45 | 169 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2778219 | 2778219 | CT | school | 901920 | 640011 | Hartford School District | 90192000381 | 641911 | Milner Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | * | 117 | 194 | 0 | 0 | 0 | * | 155 | 165 | 92 | 62 | 320 | 117 | 194 | 0 | 0 | 0 | 155 | 165 | 92 | 62 | 320 | |||||||||||||||||||||||||||||||
2778245 | 2778245 | CT | school | 902070 | 690011 | Killingly School District | 90207000393 | 695211 | Killingly Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 510 | 17 | 70 | * | 22 | * | 26 | 310 | 338 | 14 | 99 | 648 | 510 | 17 | 70 | 22 | 26 | 310 | 338 | 14 | 99 | 648 | |||||||||||||||||||||||||||||||
2778253 | 2778253 | CT | school | 903450 | 2450014 | Learn | 90345001556 | 2455014 | Dual Language & Arts Magnet Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 37 | 17 | 76 | 0 | 0 | 0 | 18 | 64 | 84 | 34 | 37 | 148 | 37 | 17 | 76 | 0 | 0 | 0 | 18 | 64 | 84 | 34 | 37 | 148 | ||||||||||||||||||||||||||||||
2778262 | 2778262 | CT | school | 902130 | 710011 | Lebanon School District | 90213000028 | 715111 | Lebanon Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 262 | 6 | 12 | * | * | * | * | 159 | 137 | * | 51 | 296 | 262 | 6 | 12 | 159 | 137 | 51 | 296 | ||||||||||||||||||||||||||||||||||
2778267 | 2778267 | CT | school | 902160 | 720011 | Ledyard School District | 90216000402 | 725111 | Ledyard Middle School | Public Schools | Regular School | No | Middle | 06 | 10 | 2020 | pk_12_total | 390 | 22 | 54 | 16 | * | * | 46 | 285 | 259 | * | 108 | 544 | 390 | 22 | 54 | 16 | 46 | 285 | 259 | 108 | 544 | ||||||||||||||||||||||||||||||||
2778272 | 2778272 | CT | school | 902220 | 740011 | Litchfield School District | 90222000407 | 740311 | Litchfield Intermediate School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 174 | * | 8 | 0 | * | 0 | * | 102 | 88 | 0 | 29 | 190 | 174 | 8 | 0 | 0 | 102 | 88 | 0 | 29 | 190 | ||||||||||||||||||||||||||||||||
2778273 | 2778273 | CT | school | 902220 | 740011 | Litchfield School District | 90222001809 | 746011 | Litchfield Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 118 | 0 | * | 0 | * | * | * | 68 | 63 | * | 23 | 131 | 118 | 0 | 0 | 68 | 63 | 23 | 131 | ||||||||||||||||||||||||||||||||||
2778279 | 2778279 | CT | school | 902280 | 760011 | Madison School District | 90228001480 | 765211 | Walter C. Polson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 499 | * | 31 | * | 18 | * | 34 | 318 | * | * | 89 | 588 | 499 | 31 | 18 | 34 | 318 | 89 | 588 | ||||||||||||||||||||||||||||||||||
2778290 | 2778290 | CT | school | 902310 | 770011 | Manchester School District | 90231001533 | 771711 | Elisabeth M. Bennet Academy | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 290 | 231 | 302 | * | 64 | * | 15 | 465 | 442 | 71 | 157 | 907 | 290 | 231 | 302 | 64 | 15 | 465 | 442 | 71 | 157 | 907 | |||||||||||||||||||||||||||||||
2778292 | 2778292 | CT | school | 902310 | 770011 | Manchester School District | 90231000421 | 775311 | Illing Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 272 | 203 | 257 | * | 68 | * | 35 | 426 | 411 | 60 | 125 | 837 | 272 | 203 | 257 | 68 | 35 | 426 | 411 | 60 | 125 | 837 | |||||||||||||||||||||||||||||||
2778301 | 2778301 | CT | school | 902340 | 780011 | Mansfield School District | 90234000433 | 785111 | Mansfield Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 375 | * | 66 | * | 69 | 0 | 26 | 267 | 285 | 11 | 66 | 552 | 375 | 66 | 69 | 0 | 26 | 267 | 285 | 11 | 66 | 552 | |||||||||||||||||||||||||||||||
2778315 | 2778315 | CT | school | 902400 | 800011 | Meriden School District | 90240000447 | 805211 | Lincoln Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 204 | 94 | 460 | * | * | 0 | 25 | 411 | 388 | 131 | 136 | 799 | 204 | 94 | 460 | 0 | 25 | 411 | 388 | 131 | 136 | 799 | |||||||||||||||||||||||||||||||
2778320 | 2778320 | CT | school | 902400 | 800011 | Meriden School District | 90240001194 | 805411 | Washington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 266 | 84 | 395 | * | 14 | * | 24 | 403 | 384 | 66 | 139 | 787 | 266 | 84 | 395 | 14 | 24 | 403 | 384 | 66 | 139 | 787 | |||||||||||||||||||||||||||||||
2778346 | 2778346 | CT | school | 902490 | 830011 | Middletown School District | 90249000456 | 831511 | Keigwin Middle School | Public Schools | Regular School | No | Middle | 06 | 06 | 2020 | pk_12_total | 159 | 51 | 62 | * | 14 | * | 28 | 152 | 164 | 14 | 38 | 316 | 159 | 51 | 62 | 14 | 28 | 152 | 164 | 14 | 38 | 316 | |||||||||||||||||||||||||||||||
2778347 | 2778347 | CT | school | 902490 | 830011 | Middletown School District | 90249000459 | 835411 | Woodrow Wilson Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 274 | 149 | 126 | * | 19 | * | 47 | 313 | 305 | 15 | 78 | 618 | 274 | 149 | 126 | 19 | 47 | 313 | 305 | 15 | 78 | 618 | |||||||||||||||||||||||||||||||
2778363 | 2778363 | CT | school | 902520 | 840011 | Milford School District | 90252000484 | 845111 | East Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 319 | 28 | 29 | 0 | 24 | 0 | 7 | 199 | 208 | * | 64 | 407 | 319 | 28 | 29 | 0 | 24 | 0 | 7 | 199 | 208 | 64 | 407 | ||||||||||||||||||||||||||||||
2778364 | 2778364 | CT | school | 902520 | 840011 | Milford School District | 90252000468 | 845211 | Harborside Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 305 | 12 | 51 | * | 44 | 0 | * | 243 | 181 | 7 | 59 | 424 | 305 | 12 | 51 | 44 | 0 | 243 | 181 | 7 | 59 | 424 | |||||||||||||||||||||||||||||||
2778365 | 2778365 | CT | school | 902520 | 840011 | Milford School District | 90252000474 | 845311 | West Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 295 | 31 | 77 | * | 60 | * | * | 241 | 230 | 9 | 74 | 471 | 295 | 31 | 77 | 60 | 241 | 230 | 9 | 74 | 471 | ||||||||||||||||||||||||||||||||
2778374 | 2778374 | CT | school | 902550 | 850011 | Monroe School District | 90255000920 | 855211 | Jockey Hollow School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 603 | 17 | 66 | 0 | 43 | 0 | 26 | 387 | 368 | * | 105 | 755 | 603 | 17 | 66 | 0 | 43 | 0 | 26 | 387 | 368 | 105 | 755 |
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]);