enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "pk_12_total" and state = "CT" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2778427 | 2778427 | CT | school | 902700 | 900011 | New Canaan School District | 90270000532 | 905111 | Saxe Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 1079 | 18 | 68 | * | 110 | * | 43 | 682 | 642 | 8 | 159 | 1324 | 1079 | 18 | 68 | 110 | 43 | 682 | 642 | 8 | 159 | 1324 | |||||||||||||||||||||||||||||||
2452072 | 2452072 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 681 | * | 86 | * | 108 | 0 | 45 | * | 495 | * | 112 | 952 | 681 | 86 | 108 | 0 | 45 | 495 | 112 | 952 | |||||||||||||||||||||||||||||||||
2452758 | 2452758 | CT | school | 904320 | 1350011 | Stamford School District | 90432000167 | 1352211 | Hart School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 127 | 81 | 259 | 0 | 108 | 0 | 37 | 305 | 307 | 70 | 59 | 612 | 127 | 81 | 259 | 0 | 108 | 0 | 37 | 305 | 307 | 70 | 59 | 612 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452671 | 2452671 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000779 | 1186111 | Ridgefield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1353 | 15 | 103 | * | 107 | * | 37 | 791 | 827 | * | 160 | 1618 | 1353 | 15 | 103 | 107 | 37 | 791 | 827 | 160 | 1618 | ||||||||||||||||||||||||||||||||
2452715 | 2452715 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000821 | 1320111 | Philip R. Smith School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 230 | 8 | 31 | 0 | 107 | 0 | 18 | 199 | 195 | 50 | 29 | 394 | 230 | 8 | 31 | 0 | 107 | 0 | 18 | 199 | 195 | 50 | 29 | 394 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2779054 | 2779054 | CT | school | 905130 | 1610011 | Wilton School District | 90513001071 | 1610711 | Cider Mill School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 620 | * | 67 | 0 | 107 | 0 | * | 431 | 422 | * | 128 | 853 | 620 | 67 | 0 | 107 | 0 | 431 | 422 | 128 | 853 | ||||||||||||||||||||||||||||||||
2779182 | 2779182 | CT | school | 905373 | 9030022 | The Woodstock Academy District | 90537311223 | 9036122 | The Woodstock Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 928 | * | 49 | * | 107 | 0 | 11 | 552 | 555 | 0 | 69 | 1107 | 928 | 49 | 107 | 0 | 11 | 552 | 555 | 0 | 69 | 1107 | |||||||||||||||||||||||||||||||
2453029 | 2453029 | CT | school | 905130 | 1610011 | Wilton School District | 90513001076 | 1616111 | Wilton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1004 | * | 73 | * | 106 | 0 | 58 | 630 | 633 | * | 174 | 1263 | 1004 | 73 | 106 | 0 | 58 | 630 | 633 | 174 | 1263 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2778116 | 2778116 | CT | school | 901710 | 570011 | Greenwich School District | 90171001288 | 571311 | International School At Dundee | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 178 | * | 49 | 0 | 106 | 0 | * | 189 | 180 | 21 | 27 | 369 | 178 | 49 | 0 | 106 | 0 | 189 | 180 | 21 | 27 | 369 | |||||||||||||||||||||||||||||||
2452405 | 2452405 | CT | school | 902700 | 900011 | New Canaan School District | 90270000532 | 905111 | Saxe Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 1102 | 8 | 72 | * | 105 | * | 42 | 686 | 648 | 9 | 162 | 1334 | 1102 | 8 | 72 | 105 | 42 | 686 | 648 | 9 | 162 | 1334 | |||||||||||||||||||||||||||||||
2452677 | 2452677 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000785 | 1196111 | Rocky Hill High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 495 | 36 | 87 | * | 105 | 0 | * | 373 | 368 | 10 | 103 | 741 | 495 | 36 | 87 | 105 | 0 | 373 | 368 | 10 | 103 | 741 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451720 | 2451720 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 309 | 28 | 44 | * | 104 | 0 | * | 243 | 266 | 9 | 49 | 509 | 309 | 28 | 44 | 104 | 0 | 243 | 266 | 9 | 49 | 509 | |||||||||||||||||||||||||||||||
2453027 | 2453027 | CT | school | 905130 | 1610011 | Wilton School District | 90513001073 | 1615211 | Middlebrook School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 770 | * | 66 | * | 104 | 0 | 54 | 471 | 532 | * | 138 | 1003 | 770 | 66 | 104 | 0 | 54 | 471 | 532 | 138 | 1003 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778798 | 2778798 | CT | school | 904320 | 1350011 | Stamford School District | 90432000867 | 1356111 | Stamford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 537 | 342 | 788 | 0 | 103 | * | * | 901 | 912 | 314 | 223 | 1813 | 537 | 342 | 788 | 0 | 103 | 901 | 912 | 314 | 223 | 1813 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451970 | 2451970 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 230 | 624 | 782 | * | 101 | * | 34 | 948 | 829 | 147 | 311 | 1777 | 230 | 624 | 782 | 101 | 34 | 948 | 829 | 147 | 311 | 1777 | |||||||||||||||||||||||||||||||
2452773 | 2452773 | CT | school | 904320 | 1350011 | Stamford School District | 90432000867 | 1356111 | Stamford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 581 | 367 | 647 | 0 | 100 | * | * | 857 | 886 | 241 | 209 | 1743 | 581 | 367 | 647 | 0 | 100 | 857 | 886 | 241 | 209 | 1743 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2453028 | 2453028 | CT | school | 905130 | 1610011 | Wilton School District | 90513001071 | 1610711 | Cider Mill School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 648 | * | * | 0 | 99 | 0 | 56 | 449 | 409 | * | 120 | 858 | 648 | 0 | 99 | 0 | 56 | 449 | 409 | 120 | 858 | ||||||||||||||||||||||||||||||||
2778289 | 2778289 | CT | school | 902310 | 770011 | Manchester School District | 90231000430 | 771311 | Waddell School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 126 | 120 | 128 | 0 | 99 | * | * | 243 | 241 | 71 | 39 | 484 | 126 | 120 | 128 | 0 | 99 | 243 | 241 | 71 | 39 | 484 | |||||||||||||||||||||||||||||||
2452697 | 2452697 | CT | school | 904050 | 1260011 | Shelton School District | 90405000806 | 1266111 | Shelton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 983 | 79 | 196 | * | 98 | 0 | * | 717 | * | 18 | 160 | 1401 | 983 | 79 | 196 | 98 | 0 | 717 | 18 | 160 | 1401 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452751 | 2452751 | CT | school | 900220 | 2960013 | Stamford Charter School for Excellence District | 90022001807 | 2960113 | Stamford Charter School for Excellence | Public Charter Schools | Regular School | Yes | Elementary | PK | 04 | 2019 | pk_12_total | * | 163 | 72 | * | 97 | * | * | 161 | 178 | 12 | 20 | 339 | 163 | 72 | 97 | 161 | 178 | 12 | 20 | 339 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778739 | 2778739 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000821 | 1320111 | Philip R. Smith School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 232 | 12 | 39 | 0 | 97 | 0 | 17 | 199 | 198 | 50 | 32 | 397 | 232 | 12 | 39 | 0 | 97 | 0 | 17 | 199 | 198 | 50 | 32 | 397 | |||||||||||||||||||||||||||||
2779053 | 2779053 | CT | school | 905130 | 1610011 | Wilton School District | 90513001073 | 1615211 | Middlebrook School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 713 | * | 66 | * | 97 | 0 | 55 | 447 | 498 | * | 132 | 945 | 713 | 66 | 97 | 0 | 55 | 447 | 498 | 132 | 945 | ||||||||||||||||||||||||||||||||
2451721 | 2451721 | CT | school | 900120 | 40011 | Avon School District | 90012000012 | 45111 | Avon Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 339 | 21 | 34 | 0 | 96 | 0 | 21 | 251 | 260 | 6 | 48 | 511 | 339 | 21 | 34 | 0 | 96 | 0 | 21 | 251 | 260 | 6 | 48 | 511 | |||||||||||||||||||||||||||||
2451986 | 2451986 | CT | school | 901320 | 450011 | East Lyme School District | 90132000223 | 456111 | East Lyme High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 750 | 23 | 74 | * | 96 | * | 53 | 506 | 496 | * | 132 | 1002 | 750 | 23 | 74 | 96 | 53 | 506 | 496 | 132 | 1002 | ||||||||||||||||||||||||||||||||
2452267 | 2452267 | CT | school | 902310 | 770011 | Manchester School District | 90231000430 | 771311 | Waddell School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 141 | 110 | 122 | * | 96 | * | 9 | 231 | 250 | 71 | 34 | 481 | 141 | 110 | 122 | 96 | 9 | 231 | 250 | 71 | 34 | 481 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2777747 | 2777747 | CT | school | 900120 | 40011 | Avon School District | 90012000013 | 40311 | Roaring Brook School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 314 | 24 | 30 | * | 96 | 0 | * | 251 | 236 | 10 | 38 | 487 | 314 | 24 | 30 | 96 | 0 | 251 | 236 | 10 | 38 | 487 | |||||||||||||||||||||||||||||||
2452088 | 2452088 | CT | school | 901710 | 570011 | Greenwich School District | 90171000304 | 570711 | North Mianus School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 293 | * | 75 | 0 | 95 | 0 | * | 263 | 229 | 25 | 40 | 492 | 293 | 75 | 0 | 95 | 0 | 263 | 229 | 25 | 40 | 492 | |||||||||||||||||||||||||||||||
2778781 | 2778781 | CT | school | 904320 | 1350011 | Stamford School District | 90432000167 | 1352211 | Hart School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 117 | 81 | 266 | 0 | 95 | 0 | 42 | 309 | 292 | 76 | 65 | 601 | 117 | 81 | 266 | 0 | 95 | 0 | 42 | 309 | 292 | 76 | 65 | 601 | |||||||||||||||||||||||||||||
2779001 | 2779001 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001021 | 1555211 | Sedgwick Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 496 | 85 | 207 | * | 95 | * | 33 | 445 | 475 | 49 | 114 | 920 | 496 | 85 | 207 | 95 | 33 | 445 | 475 | 49 | 114 | 920 | |||||||||||||||||||||||||||||||
2452050 | 2452050 | CT | school | 901530 | 510011 | Fairfield School District | 90153001379 | 516011 | Fairfield Ludlowe High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1243 | * | 130 | * | 94 | 0 | 45 | 751 | 782 | 10 | 171 | 1533 | 1243 | 130 | 94 | 0 | 45 | 751 | 782 | 10 | 171 | 1533 | |||||||||||||||||||||||||||||||
2777881 | 2777881 | 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 | 2020 | pk_12_total | 70 | 158 | 155 | 0 | 94 | 0 | 22 | 242 | 257 | 31 | 62 | 499 | 70 | 158 | 155 | 0 | 94 | 0 | 22 | 242 | 257 | 31 | 62 | 499 | |||||||||||||||||||||||||||||
2451719 | 2451719 | CT | school | 900120 | 40011 | Avon School District | 90012000013 | 40311 | Roaring Brook School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 319 | 24 | 27 | * | 93 | 0 | * | 252 | 231 | 15 | 38 | 483 | 319 | 24 | 27 | 93 | 0 | 252 | 231 | 15 | 38 | 483 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2779000 | 2779000 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 517 | 81 | 152 | 0 | 93 | * | * | 459 | 436 | 41 | 121 | 895 | 517 | 81 | 152 | 0 | 93 | 459 | 436 | 41 | 121 | 895 | |||||||||||||||||||||||||||||||
2452975 | 2452975 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001021 | 1555211 | Sedgwick Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 489 | 75 | 201 | * | 92 | * | 27 | 421 | 466 | 34 | 108 | 887 | 489 | 75 | 201 | 92 | 27 | 421 | 466 | 34 | 108 | 887 | |||||||||||||||||||||||||||||||
2778095 | 2778095 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000280 | 540211 | Buttonball Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 296 | 14 | 45 | 0 | 92 | 0 | 24 | 251 | 220 | 36 | 42 | 471 | 296 | 14 | 45 | 0 | 92 | 0 | 24 | 251 | 220 | 36 | 42 | 471 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778868 | 2778868 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000933 | 1445111 | Madison Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 573 | 50 | 128 | * | 91 | * | 20 | 452 | 412 | 12 | 126 | 864 | 573 | 50 | 128 | 91 | 20 | 452 | 412 | 12 | 126 | 864 | |||||||||||||||||||||||||||||||
2452051 | 2452051 | CT | school | 901530 | 510011 | Fairfield School District | 90153000256 | 516211 | Fairfield Warde High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1056 | * | 225 | * | 90 | 0 | 60 | 748 | 731 | 43 | 191 | 1479 | 1056 | 225 | 90 | 0 | 60 | 748 | 731 | 43 | 191 | 1479 | |||||||||||||||||||||||||||||||
2452085 | 2452085 | CT | school | 901710 | 570011 | Greenwich School District | 90171001288 | 571311 | International School At Dundee | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 184 | * | 52 | * | 90 | 0 | 37 | 189 | 180 | 24 | 29 | 369 | 184 | 52 | 90 | 0 | 37 | 189 | 180 | 24 | 29 | 369 | |||||||||||||||||||||||||||||||
2452341 | 2452341 | CT | school | 902520 | 840011 | Milford School District | 90252000478 | 840711 | Meadowside School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 133 | * | 32 | 0 | 90 | 0 | * | 117 | 149 | 45 | 29 | 266 | 133 | 32 | 0 | 90 | 0 | 117 | 149 | 45 | 29 | 266 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2778080 | 2778080 | CT | school | 901530 | 510011 | Fairfield School District | 90153001379 | 516011 | Fairfield Ludlowe High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1213 | * | 130 | * | 90 | 0 | 45 | 713 | 787 | * | 191 | 1500 | 1213 | 130 | 90 | 0 | 45 | 713 | 787 | 191 | 1500 | ||||||||||||||||||||||||||||||||
2452707 | 2452707 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000813 | 1286111 | Simsbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1100 | 69 | 113 | 0 | 89 | * | * | 740 | 652 | 7 | 182 | 1392 | 1100 | 69 | 113 | 0 | 89 | 740 | 652 | 7 | 182 | 1392 | |||||||||||||||||||||||||||||||
2452770 | 2452770 | CT | school | 904320 | 1350011 | Stamford School District | 90432000009 | 1355711 | Scofield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 224 | 74 | 251 | 0 | 89 | 0 | 8 | 325 | 321 | 24 | 41 | 646 | 224 | 74 | 251 | 0 | 89 | 0 | 8 | 325 | 321 | 24 | 41 | 646 | |||||||||||||||||||||||||||||
2778696 | 2778696 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000784 | 1190411 | Myrtle H. Stevens School | Public Schools | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 231 | * | 47 | * | 89 | 0 | 19 | 202 | 194 | 44 | 44 | 396 | 231 | 47 | 89 | 0 | 19 | 202 | 194 | 44 | 44 | 396 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451850 | 2451850 | 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 | 2019 | pk_12_total | 69 | 155 | 140 | 0 | 88 | 0 | 25 | 240 | 237 | 32 | 50 | 477 | 69 | 155 | 140 | 0 | 88 | 0 | 25 | 240 | 237 | 32 | 50 | 477 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452065 | 2452065 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000280 | 540211 | Buttonball Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 301 | * | 50 | * | 87 | 0 | 31 | 248 | 235 | 34 | 44 | 483 | 301 | 50 | 87 | 0 | 31 | 248 | 235 | 34 | 44 | 483 | |||||||||||||||||||||||||||||||
2452974 | 2452974 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 533 | 75 | 153 | 0 | 87 | * | * | 467 | 436 | 38 | 121 | 903 | 533 | 75 | 153 | 0 | 87 | 467 | 436 | 38 | 121 | 903 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778018 | 2778018 | CT | school | 901320 | 450011 | East Lyme School District | 90132000223 | 456111 | East Lyme High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 767 | 12 | 70 | * | 87 | * | 57 | 498 | 498 | 6 | 115 | 996 | 767 | 12 | 70 | 87 | 57 | 498 | 498 | 6 | 115 | 996 | |||||||||||||||||||||||||||||||
2452091 | 2452091 | CT | school | 901710 | 570011 | Greenwich School District | 90171000298 | 575211 | Eastern Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 613 | 11 | 103 | 0 | 86 | 0 | 32 | 417 | 428 | 8 | 110 | 845 | 613 | 11 | 103 | 0 | 86 | 0 | 32 | 417 | 428 | 8 | 110 | 845 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451846 | 2451846 | 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 | 2019 | pk_12_total | 121 | 124 | 150 | * | 85 | * | 19 | 263 | 238 | 86 | 68 | 501 | 121 | 124 | 150 | 85 | 19 | 263 | 238 | 86 | 68 | 501 | |||||||||||||||||||||||||||||||
2452754 | 2452754 | CT | school | 904320 | 1350011 | Stamford School District | 90432000859 | 1350511 | K. T. Murphy School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 96 | 58 | 242 | 0 | 85 | 0 | 20 | 265 | 236 | 75 | 52 | 501 | 96 | 58 | 242 | 0 | 85 | 0 | 20 | 265 | 236 | 75 | 52 | 501 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2778081 | 2778081 | CT | school | 901530 | 510011 | Fairfield School District | 90153000256 | 516211 | Fairfield Warde High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1022 | * | 225 | 0 | 85 | * | 55 | 740 | 698 | 42 | 198 | 1438 | 1022 | 225 | 0 | 85 | 55 | 740 | 698 | 42 | 198 | 1438 | |||||||||||||||||||||||||||||||
2778097 | 2778097 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000286 | 540611 | Hopewell School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 332 | * | 52 | * | 85 | 0 | 23 | 272 | 233 | 12 | 36 | 505 | 332 | 52 | 85 | 0 | 23 | 272 | 233 | 12 | 36 | 505 | |||||||||||||||||||||||||||||||
2778118 | 2778118 | CT | school | 901710 | 570011 | Greenwich School District | 90171000304 | 570711 | North Mianus School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 317 | * | 68 | 0 | 85 | * | 25 | 274 | 223 | 30 | 46 | 497 | 317 | 68 | 0 | 85 | 25 | 274 | 223 | 30 | 46 | 497 | |||||||||||||||||||||||||||||||
2451875 | 2451875 | CT | school | 900750 | 250011 | Cheshire School District | 90075000127 | 250411 | Highland School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 573 | 19 | 48 | * | 84 | 0 | * | 388 | 355 | 17 | 88 | 743 | 573 | 19 | 48 | 84 | 0 | 388 | 355 | 17 | 88 | 743 | |||||||||||||||||||||||||||||||
2453026 | 2453026 | CT | school | 905130 | 1610011 | Wilton School District | 90513001075 | 1610511 | Miller-Driscoll School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 590 | 6 | 56 | 0 | 84 | 0 | 55 | 395 | 396 | 15 | 94 | 791 | 590 | 6 | 56 | 0 | 84 | 0 | 55 | 395 | 396 | 15 | 94 | 791 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2777877 | 2777877 | 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 | 2020 | pk_12_total | 105 | 123 | 149 | * | 84 | * | 16 | 250 | 230 | 90 | 67 | 480 | 105 | 123 | 149 | 84 | 16 | 250 | 230 | 90 | 67 | 480 | |||||||||||||||||||||||||||||||
2778002 | 2778002 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 212 | 580 | 754 | * | 84 | * | 45 | 868 | 814 | 171 | 294 | 1682 | 212 | 580 | 754 | 84 | 45 | 868 | 814 | 171 | 294 | 1682 | |||||||||||||||||||||||||||||||
2778723 | 2778723 | CT | school | 904050 | 1260011 | Shelton School District | 90405000806 | 1266111 | Shelton High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 946 | 86 | 188 | * | 84 | 0 | * | 696 | * | 22 | 167 | 1357 | 946 | 86 | 188 | 84 | 0 | 696 | 22 | 167 | 1357 | ||||||||||||||||||||||||||||||||
2778087 | 2778087 | CT | school | 901560 | 520011 | Farmington School District | 90156000275 | 520211 | Noah Wallace School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 202 | 18 | 36 | 0 | 83 | 0 | 18 | 179 | 178 | 35 | 41 | 357 | 202 | 18 | 36 | 0 | 83 | 0 | 18 | 179 | 178 | 35 | 41 | 357 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452057 | 2452057 | CT | school | 901560 | 520011 | Farmington School District | 90156000275 | 520211 | Noah Wallace School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 205 | 19 | 31 | 0 | 82 | 0 | 17 | 176 | 178 | 27 | 28 | 354 | 205 | 19 | 31 | 0 | 82 | 0 | 17 | 176 | 178 | 27 | 28 | 354 | |||||||||||||||||||||||||||||
2452741 | 2452741 | CT | school | 904230 | 1310011 | Southington School District | 90423000838 | 1316211 | Southington High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1620 | * | 153 | 0 | 82 | * | 71 | 962 | 1008 | 12 | 233 | 1970 | 1620 | 153 | 0 | 82 | 71 | 962 | 1008 | 12 | 233 | 1970 | |||||||||||||||||||||||||||||||
2452766 | 2452766 | CT | school | 904320 | 1350011 | Stamford School District | 90432000872 | 1351411 | Westover School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 167 | 158 | 251 | 0 | 82 | 0 | 27 | 346 | 339 | 51 | 70 | 685 | 167 | 158 | 251 | 0 | 82 | 0 | 27 | 346 | 339 | 51 | 70 | 685 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2778766 | 2778766 | CT | school | 904230 | 1310011 | Southington School District | 90423000838 | 1316211 | Southington High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1660 | 45 | 167 | * | 82 | * | 72 | 978 | 1052 | 15 | 260 | 2030 | 1660 | 45 | 167 | 82 | 72 | 978 | 1052 | 15 | 260 | 2030 | |||||||||||||||||||||||||||||||
2452764 | 2452764 | CT | school | 904320 | 1350011 | Stamford School District | 90432001916 | 1350711 | Strawberry Hill an ext. of Rogers International | Public Schools | Regular School | No | Elementary | KG | 03 | 2019 | pk_12_total | 142 | 59 | 121 | * | 81 | 0 | * | 210 | 226 | 16 | 32 | 436 | 142 | 59 | 121 | 81 | 0 | 210 | 226 | 16 | 32 | 436 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2778738 | 2778738 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000822 | 1320711 | Eli Terry School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 269 | 32 | 57 | * | 81 | 0 | * | 227 | 231 | 24 | 76 | 458 | 269 | 32 | 57 | 81 | 0 | 227 | 231 | 24 | 76 | 458 |
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]);