enrollments
Data source: Big Local News · About: Big Local
1,444 rows where grade = "pk_12_total", state = "CT" and year = 2021 sorted by asian_int 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2758296 | 2758296 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000827 | 1325111 | Timothy Edwards School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 535 | 78 | 102 | * | 308 | 0 | * | 554 | 525 | 30 | 129 | 1079 | 535 | 78 | 102 | 308 | 0 | 554 | 525 | 30 | 129 | 1079 | |||||||||||||||||||||||||||||||
2757649 | 2757649 | CT | school | 901560 | 520011 | Farmington School District | 90156000273 | 526111 | Farmington High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 818 | 54 | 95 | * | 270 | 0 | * | 629 | 638 | 9 | 153 | 1267 | 818 | 54 | 95 | 270 | 0 | 629 | 638 | 9 | 153 | 1267 | |||||||||||||||||||||||||||||||
2758251 | 2758251 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000786 | 1190511 | West Hill School | Public Schools | Regular School | No | Elementary | PK | 03 | 2021 | pk_12_total | 148 | 9 | 23 | * | 262 | * | 9 | 215 | 238 | 78 | 55 | 453 | 148 | 9 | 23 | 262 | 9 | 215 | 238 | 78 | 55 | 453 | |||||||||||||||||||||||||||||||
2758293 | 2758293 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000825 | 1320211 | Pleasant Valley School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 216 | * | 50 | * | 258 | 0 | 35 | 301 | 289 | 102 | 44 | 590 | 216 | 50 | 258 | 0 | 35 | 301 | 289 | 102 | 44 | 590 | |||||||||||||||||||||||||||||||
2758297 | 2758297 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000826 | 1326211 | South Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 768 | 91 | 110 | 0 | 253 | * | * | 662 | * | 18 | 175 | 1283 | 768 | 91 | 110 | 0 | 253 | 662 | 18 | 175 | 1283 | ||||||||||||||||||||||||||||||||
2758295 | 2758295 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000824 | 1320611 | Orchard Hill School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 277 | 27 | 57 | 0 | 225 | 0 | 38 | 309 | 315 | 91 | 55 | 624 | 277 | 27 | 57 | 0 | 225 | 0 | 38 | 309 | 315 | 91 | 55 | 624 | |||||||||||||||||||||||||||||
2757512 | 2757512 | CT | school | 901020 | 340011 | Danbury School District | 90102000150 | 346111 | Danbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1066 | 278 | 1692 | * | 224 | * | 73 | 1737 | 1603 | 597 | 454 | 3340 | 1066 | 278 | 1692 | 224 | 73 | 1737 | 1603 | 597 | 454 | 3340 | |||||||||||||||||||||||||||||||
2758680 | 2758680 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366000770 | 2056112 | Amity Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1064 | 49 | * | * | 221 | 0 | 60 | 724 | 720 | 10 | 168 | 1444 | 1064 | 49 | 221 | 0 | 60 | 724 | 720 | 10 | 168 | 1444 | |||||||||||||||||||||||||||||||
2757661 | 2757661 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000283 | 546111 | Glastonbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1378 | 66 | 172 | * | 219 | * | 86 | * | 1007 | 10 | 201 | 1927 | 1378 | 66 | 172 | 219 | 86 | 1007 | 10 | 201 | 1927 | ||||||||||||||||||||||||||||||||
2757681 | 2757681 | CT | school | 901710 | 570011 | Greenwich School District | 90171000300 | 576111 | Greenwich High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1703 | 83 | 645 | * | 204 | * | 108 | * | 1383 | 73 | 372 | 2750 | 1703 | 83 | 645 | 204 | 108 | 1383 | 73 | 372 | 2750 | ||||||||||||||||||||||||||||||||
2758552 | 2758552 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001013 | 1556111 | Conard High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 810 | 118 | 276 | * | 190 | * | 56 | 726 | * | 53 | 192 | 1453 | 810 | 118 | 276 | 190 | 56 | 726 | 53 | 192 | 1453 | ||||||||||||||||||||||||||||||||
2758253 | 2758253 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000782 | 1195111 | Albert D. Griswold Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 326 | 19 | 66 | 0 | 179 | 0 | 20 | 302 | 308 | 20 | 94 | 610 | 326 | 19 | 66 | 0 | 179 | 0 | 20 | 302 | 308 | 20 | 94 | 610 | |||||||||||||||||||||||||||||
2758423 | 2758423 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000937 | 1446111 | Trumbull High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1513 | 119 | 283 | * | 179 | * | 36 | 1053 | 1083 | 23 | 229 | 2136 | 1513 | 119 | 283 | 179 | 36 | 1053 | 1083 | 23 | 229 | 2136 | |||||||||||||||||||||||||||||||
2757648 | 2757648 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 381 | 39 | 62 | * | 175 | 0 | * | 357 | 325 | 12 | 94 | 682 | 381 | 39 | 62 | 175 | 0 | 357 | 325 | 12 | 94 | 682 | |||||||||||||||||||||||||||||||
2757303 | 2757303 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 634 | 53 | 65 | * | 166 | 0 | * | 500 | 457 | 8 | 97 | 957 | 634 | 53 | 65 | 166 | 0 | 500 | 457 | 8 | 97 | 957 | |||||||||||||||||||||||||||||||
2757592 | 2757592 | CT | school | 901440 | 480011 | Ellington School District | 90144000239 | 480611 | Windermere School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 366 | 23 | 46 | * | 164 | 0 | * | 334 | 288 | 25 | 71 | 622 | 366 | 23 | 46 | 164 | 0 | 334 | 288 | 25 | 71 | 622 | |||||||||||||||||||||||||||||||
2758252 | 2758252 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384001936 | 1190611 | Moser School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | 214 | 12 | 42 | 0 | 164 | 0 | 19 | 215 | 236 | 45 | 55 | 451 | 214 | 12 | 42 | 0 | 164 | 0 | 19 | 215 | 236 | 45 | 55 | 451 | |||||||||||||||||||||||||||||
2758553 | 2758553 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001015 | 1556211 | Hall High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 889 | 141 | 228 | * | 156 | * | 74 | 756 | * | 46 | 162 | 1492 | 889 | 141 | 228 | 156 | 74 | 756 | 46 | 162 | 1492 | ||||||||||||||||||||||||||||||||
2757647 | 2757647 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2021 | pk_12_total | 335 | 32 | 67 | 0 | 151 | 0 | 39 | 302 | 322 | 17 | 66 | 624 | 335 | 32 | 67 | 0 | 151 | 0 | 39 | 302 | 322 | 17 | 66 | 624 | |||||||||||||||||||||||||||||
2758725 | 2758725 | CT | school | 905371 | 9010022 | Norwich Free Academy District | 90537101221 | 9016122 | Norwich Free Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1093 | 295 | 399 | 27 | 147 | 19 | 123 | * | 1128 | 194 | 260 | 2103 | 1093 | 295 | 399 | 27 | 147 | 19 | 123 | 1128 | 194 | 260 | 2103 | ||||||||||||||||||||||||||||||
2757461 | 2757461 | CT | school | 900750 | 250011 | Cheshire School District | 90075000123 | 256111 | Cheshire High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1085 | 41 | 74 | * | 146 | 0 | * | * | 704 | * | 178 | 1368 | 1085 | 41 | 74 | 146 | 0 | 704 | 178 | 1368 | |||||||||||||||||||||||||||||||||
2758353 | 2758353 | CT | school | 904320 | 1350011 | Stamford School District | 90432000871 | 1356311 | Westhill High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 708 | 308 | 1018 | * | 146 | * | 51 | 1150 | 1086 | 434 | 277 | 2236 | 708 | 308 | 1018 | 146 | 51 | 1150 | 1086 | 434 | 277 | 2236 | |||||||||||||||||||||||||||||||
2757644 | 2757644 | CT | school | 901560 | 520011 | Farmington School District | 90156001206 | 520411 | East Farms School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 219 | * | 49 | * | 138 | 0 | 25 | 247 | 207 | 49 | 34 | 454 | 219 | 49 | 138 | 0 | 25 | 247 | 207 | 49 | 34 | 454 | |||||||||||||||||||||||||||||||
2757299 | 2757299 | CT | school | 900120 | 40011 | Avon School District | 90012010010 | 40411 | Pine Grove School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 373 | 37 | 38 | 0 | 133 | 0 | 23 | 276 | 328 | 63 | 51 | 604 | 373 | 37 | 38 | 0 | 133 | 0 | 23 | 276 | 328 | 63 | 51 | 604 | |||||||||||||||||||||||||||||
2758603 | 2758603 | CT | school | 905130 | 1610011 | Wilton School District | 90513001076 | 1616111 | Wilton High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 975 | * | 76 | * | 130 | 0 | 68 | 621 | 651 | * | 200 | 1272 | 975 | 76 | 130 | 0 | 68 | 621 | 651 | 200 | 1272 | ||||||||||||||||||||||||||||||||
2758254 | 2758254 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000785 | 1196111 | Rocky Hill High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 468 | 30 | 92 | * | 126 | 0 | * | 353 | 385 | 9 | 79 | 738 | 468 | 30 | 92 | 126 | 0 | 353 | 385 | 9 | 79 | 738 | |||||||||||||||||||||||||||||||
2758643 | 2758643 | CT | school | 905310 | 1670011 | Woodbridge School District | 90531001611 | 1670311 | Beecher Road School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 544 | * | 63 | * | 123 | 0 | 52 | 443 | 373 | 24 | 93 | 816 | 544 | 63 | 123 | 0 | 52 | 443 | 373 | 24 | 93 | 816 | |||||||||||||||||||||||||||||||
2757301 | 2757301 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 296 | 28 | 38 | * | 122 | 0 | * | 255 | 248 | 8 | 53 | 503 | 296 | 28 | 38 | 122 | 0 | 255 | 248 | 8 | 53 | 503 | |||||||||||||||||||||||||||||||
2757729 | 2757729 | CT | school | 901920 | 640011 | Hartford School District | 90192001192 | 642811 | Betances Learning Lab Magnet School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 30 | 71 | 203 | * | 122 | * | 10 | 215 | 223 | 69 | 49 | 438 | 30 | 71 | 203 | 122 | 10 | 215 | 223 | 69 | 49 | 438 | |||||||||||||||||||||||||||||||
2757847 | 2757847 | CT | school | 902310 | 770011 | Manchester School District | 90231000424 | 776111 | Manchester High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 560 | 399 | 477 | * | 122 | * | 68 | 826 | 814 | 97 | 209 | 1640 | 560 | 399 | 477 | 122 | 68 | 826 | 814 | 97 | 209 | 1640 | |||||||||||||||||||||||||||||||
2758586 | 2758586 | CT | school | 905040 | 1580011 | Westport School District | 90504001058 | 1586111 | Staples High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1483 | 37 | 97 | 0 | 119 | 0 | 68 | 912 | * | 10 | 252 | 1804 | 1483 | 37 | 97 | 0 | 119 | 0 | 68 | 912 | 10 | 252 | 1804 | ||||||||||||||||||||||||||||||
2757660 | 2757660 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 619 | * | 96 | * | 116 | 0 | 55 | 448 | 462 | 8 | 92 | 910 | 619 | 96 | 116 | 0 | 55 | 448 | 462 | 8 | 92 | 910 | |||||||||||||||||||||||||||||||
2757981 | 2757981 | CT | school | 902700 | 900011 | New Canaan School District | 90270000532 | 905111 | Saxe Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 1082 | 21 | 73 | * | 113 | * | 48 | 679 | 663 | 9 | 167 | 1342 | 1082 | 21 | 73 | 113 | 48 | 679 | 663 | 9 | 167 | 1342 | |||||||||||||||||||||||||||||||
2758667 | 2758667 | CT | school | 900220 | 2960013 | Stamford Charter School for Excellence District | 90022001807 | 2960113 | Stamford Charter School for Excellence | Public Charter Schools | Regular School | Yes | Elementary | KG | 06 | 2021 | pk_12_total | * | 177 | 86 | 0 | 113 | * | 8 | 182 | 209 | 47 | 28 | 391 | 177 | 86 | 0 | 113 | 8 | 182 | 209 | 47 | 28 | 391 | |||||||||||||||||||||||||||||||
2758033 | 2758033 | CT | school | 902790 | 930011 | New Haven School District | 90279000588 | 933811 | Worthington Hooker School | Public Schools | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 172 | 60 | 46 | 0 | 108 | 0 | 14 | 197 | 203 | 52 | 27 | 400 | 172 | 60 | 46 | 0 | 108 | 0 | 14 | 197 | 203 | 52 | 27 | 400 | |||||||||||||||||||||||||||||
2758072 | 2758072 | CT | school | 902880 | 940011 | Newington School District | 90288000610 | 946111 | Newington High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 781 | 80 | 255 | * | 108 | 0 | * | 664 | 619 | 28 | 165 | 1283 | 781 | 80 | 255 | 108 | 0 | 664 | 619 | 28 | 165 | 1283 | |||||||||||||||||||||||||||||||
2757302 | 2757302 | CT | school | 900120 | 40011 | Avon School District | 90012000012 | 45111 | Avon Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 301 | 33 | 47 | 0 | 107 | 0 | 23 | 244 | 267 | * | 53 | 511 | 301 | 33 | 47 | 0 | 107 | 0 | 23 | 244 | 267 | 53 | 511 | ||||||||||||||||||||||||||||||
2757726 | 2757726 | CT | school | 901860 | 620011 | Hamden School District | 90186000339 | 626111 | Hamden High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 555 | 537 | 331 | * | 107 | * | 83 | 851 | 765 | 57 | 263 | 1616 | 555 | 537 | 331 | 107 | 83 | 851 | 765 | 57 | 263 | 1616 | |||||||||||||||||||||||||||||||
2758247 | 2758247 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000779 | 1186111 | Ridgefield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1272 | 13 | 121 | * | 106 | * | 43 | 779 | * | * | 184 | 1559 | 1272 | 13 | 121 | 106 | 43 | 779 | 184 | 1559 | |||||||||||||||||||||||||||||||||
2758351 | 2758351 | CT | school | 904320 | 1350011 | Stamford School District | 90432000867 | 1356111 | Stamford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 567 | 373 | 822 | * | 105 | * | 43 | 975 | 939 | 323 | 263 | 1914 | 567 | 373 | 822 | 105 | 43 | 975 | 939 | 323 | 263 | 1914 | |||||||||||||||||||||||||||||||
2757432 | 2757432 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001511 | 2410414 | International Magnet School for Global Citizenship | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 49 | 166 | 151 | * | 104 | 0 | * | 247 | 249 | 34 | 61 | 496 | 49 | 166 | 151 | 104 | 0 | 247 | 249 | 34 | 61 | 496 | |||||||||||||||||||||||||||||||
2757679 | 2757679 | CT | school | 901710 | 570011 | Greenwich School District | 90171000298 | 575211 | Eastern Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 555 | * | 114 | * | 102 | 0 | 53 | 453 | 384 | 11 | 97 | 837 | 555 | 114 | 102 | 0 | 53 | 453 | 384 | 11 | 97 | 837 | |||||||||||||||||||||||||||||||
2758600 | 2758600 | CT | school | 905130 | 1610011 | Wilton School District | 90513001073 | 1615211 | Middlebrook School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 697 | * | 65 | 0 | 100 | 0 | * | 453 | 467 | * | 143 | 920 | 697 | 65 | 0 | 100 | 0 | 453 | 467 | 143 | 920 | ||||||||||||||||||||||||||||||||
2757569 | 2757569 | CT | school | 901320 | 450011 | East Lyme School District | 90132000223 | 456111 | East Lyme High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 770 | 15 | 67 | * | 96 | * | 59 | 517 | 493 | * | 124 | 1010 | 770 | 15 | 67 | 96 | 59 | 517 | 493 | 124 | 1010 | ||||||||||||||||||||||||||||||||
2757669 | 2757669 | CT | school | 901710 | 570011 | Greenwich School District | 90171001288 | 571311 | International School At Dundee | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 179 | * | 45 | 0 | 96 | 0 | * | 180 | 181 | 20 | 23 | 361 | 179 | 45 | 0 | 96 | 0 | 180 | 181 | 20 | 23 | 361 | |||||||||||||||||||||||||||||||
2758342 | 2758342 | CT | school | 904320 | 1350011 | Stamford School District | 90432001916 | 1350711 | Strawberry Hill an ext. of Rogers International | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 180 | 76 | 210 | * | 96 | 0 | * | 294 | 313 | 14 | 63 | 607 | 180 | 76 | 210 | 96 | 0 | 294 | 313 | 14 | 63 | 607 | |||||||||||||||||||||||||||||||
2758601 | 2758601 | CT | school | 905130 | 1610011 | Wilton School District | 90513001071 | 1610711 | Cider Mill School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 560 | * | 64 | 0 | 93 | 0 | * | 382 | 392 | 0 | 124 | 774 | 560 | 64 | 0 | 93 | 0 | 382 | 392 | 0 | 124 | 774 | |||||||||||||||||||||||||||||||
2757639 | 2757639 | CT | school | 901530 | 510011 | Fairfield School District | 90153000256 | 516211 | Fairfield Warde High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1033 | * | 235 | * | 91 | 0 | 60 | 765 | * | 42 | 193 | 1472 | 1033 | 235 | 91 | 0 | 60 | 765 | 42 | 193 | 1472 | ||||||||||||||||||||||||||||||||
2757842 | 2757842 | CT | school | 902310 | 770011 | Manchester School District | 90231000430 | 771311 | Waddell School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 98 | 91 | 112 | * | 91 | * | 10 | 198 | 207 | 62 | 46 | 405 | 98 | 91 | 112 | 91 | 10 | 198 | 207 | 62 | 46 | 405 | |||||||||||||||||||||||||||||||
2757655 | 2757655 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000286 | 540611 | Hopewell School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 347 | * | 60 | * | 90 | 0 | 29 | 286 | 256 | 15 | 36 | 542 | 347 | 60 | 90 | 0 | 29 | 286 | 256 | 15 | 36 | 542 | |||||||||||||||||||||||||||||||
2758292 | 2758292 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000821 | 1320111 | Philip R. Smith School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 256 | 14 | 45 | 0 | 90 | 0 | 22 | 215 | 212 | 49 | 39 | 427 | 256 | 14 | 45 | 0 | 90 | 0 | 22 | 215 | 212 | 49 | 39 | 427 | |||||||||||||||||||||||||||||
2758550 | 2758550 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001021 | 1555211 | Sedgwick Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 462 | 78 | 208 | * | 88 | * | 27 | * | 446 | 36 | 105 | 867 | 462 | 78 | 208 | 88 | 27 | 446 | 36 | 105 | 867 | ||||||||||||||||||||||||||||||||
2757428 | 2757428 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001629 | 2410714 | Academy of Aerospace and Engineering Elementary | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 110 | 131 | 162 | * | 87 | * | 30 | 261 | 263 | 90 | 61 | 524 | 110 | 131 | 162 | 87 | 30 | 261 | 263 | 90 | 61 | 524 | |||||||||||||||||||||||||||||||
2757300 | 2757300 | CT | school | 900120 | 40011 | Avon School District | 90012000013 | 40311 | Roaring Brook School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 320 | 23 | 34 | * | 86 | * | 21 | 239 | 250 | 13 | 39 | 489 | 320 | 23 | 34 | 86 | 21 | 239 | 250 | 13 | 39 | 489 | |||||||||||||||||||||||||||||||
2758332 | 2758332 | CT | school | 904320 | 1350011 | Stamford School District | 90432000167 | 1352211 | Hart School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 97 | 69 | 270 | * | 86 | 0 | * | 287 | 277 | 68 | 72 | 564 | 97 | 69 | 270 | 86 | 0 | 287 | 277 | 68 | 72 | 564 | |||||||||||||||||||||||||||||||
2758421 | 2758421 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000933 | 1445111 | Madison Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 501 | 48 | 125 | * | 86 | * | 15 | 415 | 363 | 15 | 118 | 778 | 501 | 48 | 125 | 86 | 15 | 415 | 363 | 15 | 118 | 778 | |||||||||||||||||||||||||||||||
2758549 | 2758549 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 510 | 80 | 147 | * | 86 | * | 46 | 459 | 412 | 35 | 123 | 871 | 510 | 80 | 147 | 86 | 46 | 459 | 412 | 35 | 123 | 871 | |||||||||||||||||||||||||||||||
2757638 | 2757638 | CT | school | 901530 | 510011 | Fairfield School District | 90153001379 | 516011 | Fairfield Ludlowe High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1243 | 28 | 139 | 0 | 85 | 0 | 51 | 749 | 797 | 6 | 195 | 1546 | 1243 | 28 | 139 | 0 | 85 | 0 | 51 | 749 | 797 | 6 | 195 | 1546 | |||||||||||||||||||||||||||||
2758286 | 2758286 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000813 | 1286111 | Simsbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 979 | 70 | 115 | 0 | 85 | 0 | 28 | 664 | 613 | 8 | 176 | 1277 | 979 | 70 | 115 | 0 | 85 | 0 | 28 | 664 | 613 | 8 | 176 | 1277 | |||||||||||||||||||||||||||||
2757653 | 2757653 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000280 | 540211 | Buttonball Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 276 | 10 | 52 | 0 | 84 | 0 | 27 | 241 | 208 | 33 | 39 | 449 | 276 | 10 | 52 | 0 | 84 | 0 | 27 | 241 | 208 | 33 | 39 | 449 | |||||||||||||||||||||||||||||
2758276 | 2758276 | CT | school | 904050 | 1260011 | Shelton School District | 90405000806 | 1266111 | Shelton High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 870 | 83 | 189 | * | 82 | 0 | * | 661 | * | 26 | 182 | 1282 | 870 | 83 | 189 | 82 | 0 | 661 | 26 | 182 | 1282 | ||||||||||||||||||||||||||||||||
2757918 | 2757918 | CT | school | 902520 | 840011 | Milford School District | 90252000472 | 846211 | Jonathan Law High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 587 | 50 | 104 | * | 81 | * | 12 | 418 | 420 | 10 | 103 | 838 | 587 | 50 | 104 | 81 | 12 | 418 | 420 | 10 | 103 | 838 | |||||||||||||||||||||||||||||||
2757982 | 2757982 | CT | school | 902700 | 900011 | New Canaan School District | 90270000531 | 906111 | New Canaan High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1139 | * | 69 | * | 81 | 0 | 34 | 689 | 655 | * | 183 | 1344 | 1139 | 69 | 81 | 0 | 34 | 689 | 655 | 183 | 1344 | ||||||||||||||||||||||||||||||||
2757567 | 2757567 | CT | school | 901320 | 450011 | East Lyme School District | 90132000224 | 455111 | East Lyme Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 547 | 13 | 69 | 0 | 80 | 0 | 33 | 373 | 369 | 9 | 120 | 742 | 547 | 13 | 69 | 0 | 80 | 0 | 33 | 373 | 369 | 9 | 120 | 742 | |||||||||||||||||||||||||||||
2757318 | 2757318 | CT | school | 900270 | 90011 | Bethel School District | 90027000024 | 96111 | Bethel High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 628 | 32 | 183 | * | 79 | * | 10 | 485 | 450 | 27 | 129 | 935 | 628 | 32 | 183 | 79 | 10 | 485 | 450 | 27 | 129 | 935 | |||||||||||||||||||||||||||||||
2758291 | 2758291 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000822 | 1320711 | Eli Terry School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 251 | 28 | 56 | * | 79 | 0 | * | 222 | 213 | 33 | 79 | 435 | 251 | 28 | 56 | 79 | 0 | 222 | 213 | 33 | 79 | 435 | |||||||||||||||||||||||||||||||
2757520 | 2757520 | CT | school | 901050 | 350011 | Darien School District | 90105000164 | 356111 | Darien High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1182 | * | 87 | * | 78 | 0 | 17 | 714 | 668 | * | 265 | 1382 | 1182 | 87 | 78 | 0 | 17 | 714 | 668 | 265 | 1382 | ||||||||||||||||||||||||||||||||
2757553 | 2757553 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 189 | 573 | 774 | * | 78 | * | 55 | 872 | 803 | 202 | 327 | 1675 | 189 | 573 | 774 | 78 | 55 | 872 | 803 | 202 | 327 | 1675 | |||||||||||||||||||||||||||||||
2757645 | 2757645 | CT | school | 901560 | 520011 | Farmington School District | 90156000275 | 520211 | Noah Wallace School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 160 | 14 | 40 | 0 | 78 | 0 | 18 | 148 | 162 | 36 | 35 | 310 | 160 | 14 | 40 | 0 | 78 | 0 | 18 | 148 | 162 | 36 | 35 | 310 | |||||||||||||||||||||||||||||
2757419 | 2757419 | CT | school | 900540 | 180011 | Brookfield School District | 90054000109 | 186111 | Brookfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 687 | 22 | 109 | * | 77 | * | * | 458 | 444 | 13 | 138 | 902 | 687 | 22 | 109 | 77 | 458 | 444 | 13 | 138 | 902 | ||||||||||||||||||||||||||||||||
2757845 | 2757845 | CT | school | 902310 | 770011 | Manchester School District | 90231000421 | 775311 | Illing Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 253 | 219 | 277 | * | 77 | * | 23 | 425 | 427 | 57 | 122 | 852 | 253 | 219 | 277 | 77 | 23 | 425 | 427 | 57 | 122 | 852 | |||||||||||||||||||||||||||||||
2758319 | 2758319 | CT | school | 904230 | 1310011 | Southington School District | 90423000838 | 1316211 | Southington High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1580 | 51 | 199 | * | 77 | * | 65 | 959 | 1020 | 17 | 276 | 1979 | 1580 | 51 | 199 | 77 | 65 | 959 | 1020 | 17 | 276 | 1979 | |||||||||||||||||||||||||||||||
2758599 | 2758599 | CT | school | 905130 | 1610011 | Wilton School District | 90513001075 | 1610511 | Miller-Driscoll School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 522 | 7 | 57 | 0 | 77 | 0 | 50 | 338 | 375 | 25 | 97 | 713 | 522 | 7 | 57 | 0 | 77 | 0 | 50 | 338 | 375 | 25 | 97 | 713 | |||||||||||||||||||||||||||||
2758250 | 2758250 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000784 | 1190411 | Myrtle H. Stevens School | Public Schools | Regular School | No | Elementary | PK | 03 | 2021 | pk_12_total | 224 | * | 47 | * | 76 | 0 | 19 | 196 | 181 | 49 | 49 | 377 | 224 | 47 | 76 | 0 | 19 | 196 | 181 | 49 | 49 | 377 | |||||||||||||||||||||||||||||||
2758585 | 2758585 | CT | school | 905040 | 1580011 | Westport School District | 90504001048 | 1585111 | Bedford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 924 | 24 | 95 | 0 | 76 | 0 | 88 | 593 | 614 | 8 | 151 | 1207 | 924 | 24 | 95 | 0 | 76 | 0 | 88 | 593 | 614 | 8 | 151 | 1207 | |||||||||||||||||||||||||||||
2757454 | 2757454 | CT | school | 900750 | 250011 | Cheshire School District | 90075000127 | 250411 | Highland School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 571 | 20 | 61 | 0 | 75 | 0 | 19 | 370 | 376 | 33 | 70 | 746 | 571 | 20 | 61 | 0 | 75 | 0 | 19 | 370 | 376 | 33 | 70 | 746 | |||||||||||||||||||||||||||||
2757671 | 2757671 | CT | school | 901710 | 570011 | Greenwich School District | 90171000304 | 570711 | North Mianus School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 319 | * | 66 | * | 75 | * | 25 | 260 | 229 | 25 | 44 | 489 | 319 | 66 | 75 | 25 | 260 | 229 | 25 | 44 | 489 | ||||||||||||||||||||||||||||||||
2758533 | 2758533 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001012 | 1550511 | Charter Oak International Academy | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 158 | 70 | 180 | * | 74 | * | 28 | 246 | 270 | 49 | 51 | 516 | 158 | 70 | 180 | 74 | 28 | 246 | 270 | 49 | 51 | 516 | |||||||||||||||||||||||||||||||
2757914 | 2757914 | CT | school | 902520 | 840011 | Milford School District | 90252000478 | 840711 | Meadowside School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 125 | 9 | 45 | 0 | 73 | 0 | 14 | 132 | 134 | 38 | 35 | 266 | 125 | 9 | 45 | 0 | 73 | 0 | 14 | 132 | 134 | 38 | 35 | 266 | |||||||||||||||||||||||||||||
2758418 | 2758418 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000934 | 1440311 | Middlebrook School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 255 | 41 | 121 | * | 73 | * | 10 | 262 | 240 | 78 | 72 | 502 | 255 | 41 | 121 | 73 | 10 | 262 | 240 | 78 | 72 | 502 | |||||||||||||||||||||||||||||||
2758731 | 2758731 | CT | school | 905373 | 9030022 | The Woodstock Academy District | 90537311223 | 9036122 | The Woodstock Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 900 | 18 | 38 | * | 73 | 0 | * | 523 | * | * | 74 | 1044 | 900 | 18 | 38 | 73 | 0 | 523 | 74 | 1044 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2757730 | 2757730 | CT | school | 901920 | 640011 | Hartford School District | 90192001534 | 643511 | Breakthrough Magnet School, North | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | * | 161 | 66 | 0 | 71 | * | 26 | 187 | 157 | 23 | 34 | 344 | 161 | 66 | 0 | 71 | 26 | 187 | 157 | 23 | 34 | 344 | |||||||||||||||||||||||||||||||
2757460 | 2757460 | CT | school | 900750 | 250011 | Cheshire School District | 90075000125 | 255111 | Dodd Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 481 | 21 | 44 | * | 70 | 0 | * | 308 | 325 | 6 | 67 | 633 | 481 | 21 | 44 | 70 | 0 | 308 | 325 | 6 | 67 | 633 | |||||||||||||||||||||||||||||||
2757635 | 2757635 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 602 | 17 | 94 | 0 | 69 | 0 | 49 | 449 | 382 | 11 | 126 | 831 | 602 | 17 | 94 | 0 | 69 | 0 | 49 | 449 | 382 | 11 | 126 | 831 | |||||||||||||||||||||||||||||
2757442 | 2757442 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001513 | 2415114 | Academy of Aerospace and Engineering | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 125 | 253 | 304 | * | 68 | 0 | * | 479 | 297 | 38 | 130 | 776 | 125 | 253 | 304 | 68 | 0 | 479 | 297 | 38 | 130 | 776 | |||||||||||||||||||||||||||||||
2758096 | 2758096 | CT | school | 903030 | 1010011 | North Haven School District | 90303000631 | 1016111 | North Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 723 | 40 | 87 | 0 | 68 | 0 | 31 | 485 | 464 | 11 | 113 | 949 | 723 | 40 | 87 | 0 | 68 | 0 | 31 | 485 | 464 | 11 | 113 | 949 | |||||||||||||||||||||||||||||
2757595 | 2757595 | CT | school | 901440 | 480011 | Ellington School District | 90144000237 | 486111 | Ellington High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 649 | 33 | 35 | 0 | 67 | 0 | 29 | 410 | 403 | * | 97 | 813 | 649 | 33 | 35 | 0 | 67 | 0 | 29 | 410 | 403 | 97 | 813 | ||||||||||||||||||||||||||||||
2758126 | 2758126 | CT | school | 903120 | 1040011 | Norwich School District | 90312000675 | 1041711 | Thomas W. Mahan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 73 | 35 | 52 | 0 | 66 | 0 | 12 | 131 | 107 | 52 | 34 | 238 | 73 | 35 | 52 | 0 | 66 | 0 | 12 | 131 | 107 | 52 | 34 | 238 | |||||||||||||||||||||||||||||
2758352 | 2758352 | CT | school | 904320 | 1350011 | Stamford School District | 90432001468 | 1356411 | The Academy of Information, Technology & Engineering | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 269 | 89 | 181 | 0 | 66 | 0 | 23 | 349 | 279 | 17 | 71 | 628 | 269 | 89 | 181 | 0 | 66 | 0 | 23 | 349 | 279 | 17 | 71 | 628 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2757975 | 2757975 | CT | school | 902670 | 890011 | New Britain School District | 90267000521 | 896111 | New Britain High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 429 | 295 | 1432 | * | 64 | * | 58 | 1202 | 1084 | 425 | 521 | 2286 | 429 | 295 | 1432 | 64 | 58 | 1202 | 1084 | 425 | 521 | 2286 | |||||||||||||||||||||||||||||||
2757338 | 2757338 | CT | school | 900420 | 140011 | Branford School District | 90042000039 | 146111 | Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 575 | 25 | 95 | * | 63 | 0 | * | 398 | * | 14 | 94 | 780 | 575 | 25 | 95 | 63 | 0 | 398 | 14 | 94 | 780 | ||||||||||||||||||||||||||||||||
2757418 | 2757418 | CT | school | 900540 | 180011 | Brookfield School District | 90054000112 | 185311 | Whisconier Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 581 | 22 | 108 | * | 63 | * | 9 | 411 | 379 | 18 | 111 | 790 | 581 | 22 | 108 | 63 | 9 | 411 | 379 | 18 | 111 | 790 | |||||||||||||||||||||||||||||||
2757716 | 2757716 | CT | school | 901860 | 620011 | Hamden School District | 90186000346 | 620111 | Shepherd Glen School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 65 | 107 | 67 | * | 63 | 0 | * | 159 | 157 | 46 | 32 | 316 | 65 | 107 | 67 | 63 | 0 | 159 | 157 | 46 | 32 | 316 | |||||||||||||||||||||||||||||||
2758070 | 2758070 | CT | school | 902880 | 940011 | Newington School District | 90288001120 | 945311 | John Wallace Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 361 | 37 | 131 | * | 63 | * | 33 | 308 | 319 | 36 | 75 | 627 | 361 | 37 | 131 | 63 | 33 | 308 | 319 | 36 | 75 | 627 | |||||||||||||||||||||||||||||||
2758348 | 2758348 | CT | school | 904320 | 1350011 | Stamford School District | 90432000009 | 1355711 | Scofield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 214 | 75 | 276 | * | 63 | 0 | * | 317 | 326 | 52 | 54 | 643 | 214 | 75 | 276 | 63 | 0 | 317 | 326 | 52 | 54 | 643 | |||||||||||||||||||||||||||||||
2757337 | 2757337 | CT | school | 900420 | 140011 | Branford School District | 90042000041 | 145111 | Francis Walsh Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 588 | 41 | 105 | * | 62 | 0 | * | 435 | * | 29 | 103 | 825 | 588 | 41 | 105 | 62 | 0 | 435 | 29 | 103 | 825 | ||||||||||||||||||||||||||||||||
2757618 | 2757618 | CT | school | 901470 | 490011 | Enfield School District | 90147000243 | 496111 | Enfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1034 | 100 | 242 | * | 62 | * | 74 | * | 761 | 17 | 222 | 1521 | 1034 | 100 | 242 | 62 | 74 | 761 | 17 | 222 | 1521 | ||||||||||||||||||||||||||||||||
2757654 | 2757654 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000284 | 540411 | Hebron Avenue School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 290 | 7 | 49 | 0 | 62 | 0 | 21 | 236 | 193 | 17 | 34 | 429 | 290 | 7 | 49 | 0 | 62 | 0 | 21 | 236 | 193 | 17 | 34 | 429 |
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]);