enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "pk_12_total" and state = "CT" sorted by black_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||
2758647 | 2758647 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | * | 840 | 294 | 10 | * | * | 14 | * | 607 | 70 | 115 | 1164 | 840 | 294 | 10 | 14 | 607 | 70 | 115 | 1164 | |||||||||||||||||||||||||||||||||
2453071 | 2453071 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | * | 782 | 304 | * | * | * | 15 | 519 | 593 | 52 | 115 | 1112 | 782 | 304 | 15 | 519 | 593 | 52 | 115 | 1112 | |||||||||||||||||||||||||||||||||
2758648 | 2758648 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 11 | 701 | 396 | * | * | 0 | 20 | 506 | 628 | 104 | 101 | 1134 | 11 | 701 | 396 | 0 | 20 | 506 | 628 | 104 | 101 | 1134 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2453072 | 2453072 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 19 | 681 | 360 | * | * | 0 | 21 | 509 | 574 | 118 | 71 | 1083 | 19 | 681 | 360 | 0 | 21 | 509 | 574 | 118 | 71 | 1083 | |||||||||||||||||||||||||||||||
2452213 | 2452213 | CT | school | 900007 | 2610013 | Jumoke Academy District | 90000700747 | 2610113 | Jumoke Academy | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2019 | pk_12_total | * | 666 | 38 | 0 | * | 0 | * | 336 | 381 | 0 | 42 | 717 | 666 | 38 | 0 | 0 | 336 | 381 | 0 | 42 | 717 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2757796 | 2757796 | CT | school | 900007 | 2610013 | Jumoke Academy District | 90000700747 | 2610113 | Jumoke Academy | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2021 | pk_12_total | * | 639 | 34 | * | * | 0 | 6 | * | 358 | * | 51 | 686 | 639 | 34 | 0 | 6 | 358 | 51 | 686 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2758042 | 2758042 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 54 | 615 | 445 | 0 | 23 | * | * | 610 | 546 | 216 | 252 | 1156 | 54 | 615 | 445 | 0 | 23 | 610 | 546 | 216 | 252 | 1156 | |||||||||||||||||||||||||||||||
2778487 | 2778487 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 47 | 604 | 394 | * | 12 | * | 14 | 568 | 506 | 190 | 224 | 1074 | 47 | 604 | 394 | 12 | 14 | 568 | 506 | 190 | 224 | 1074 | |||||||||||||||||||||||||||||||
2452467 | 2452467 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 46 | 597 | 289 | * | 8 | * | * | 507 | 439 | 156 | 192 | 946 | 46 | 597 | 289 | 8 | 507 | 439 | 156 | 192 | 946 | ||||||||||||||||||||||||||||||||
2758646 | 2758646 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 12 | 597 | 502 | * | 9 | * | * | 527 | 600 | 130 | 106 | 1127 | 12 | 597 | 502 | 9 | 527 | 600 | 130 | 106 | 1127 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2777824 | 2777824 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000056 | 156211 | Central High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 223 | 594 | 683 | 15 | 47 | * | * | 742 | 835 | 246 | 242 | 1577 | 223 | 594 | 683 | 15 | 47 | 742 | 835 | 246 | 242 | 1577 | |||||||||||||||||||||||||||||||
2451795 | 2451795 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000056 | 156211 | Central High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 211 | 591 | 639 | 13 | 44 | * | * | 741 | 774 | 205 | 258 | 1515 | 211 | 591 | 639 | 13 | 44 | 741 | 774 | 205 | 258 | 1515 | |||||||||||||||||||||||||||||||
2453070 | 2453070 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 13 | 584 | 480 | * | 9 | * | * | 512 | 581 | 131 | 97 | 1093 | 13 | 584 | 480 | 9 | 512 | 581 | 131 | 97 | 1093 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2453058 | 2453058 | CT | school | 905220 | 1640011 | Windsor School District | 90522001096 | 1646111 | Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 273 | 552 | 190 | 0 | * | * | 54 | 570 | 540 | 22 | 209 | 1110 | 273 | 552 | 190 | 0 | 54 | 570 | 540 | 22 | 209 | 1110 | |||||||||||||||||||||||||||||||
2757376 | 2757376 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000056 | 156211 | Central High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 196 | 551 | 730 | * | 38 | * | 17 | 727 | 818 | 236 | 267 | 1545 | 196 | 551 | 730 | 38 | 17 | 727 | 818 | 236 | 267 | 1545 | |||||||||||||||||||||||||||||||
2779087 | 2779087 | CT | school | 905220 | 1640011 | Windsor School District | 90522001096 | 1646111 | Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 272 | 541 | 195 | * | * | 0 | 66 | 564 | 549 | 32 | 215 | 1113 | 272 | 541 | 195 | 0 | 66 | 564 | 549 | 32 | 215 | 1113 | |||||||||||||||||||||||||||||||
2758661 | 2758661 | CT | school | 900221 | 2970013 | Capital Preparatory Harbor School District | 90022101803 | 2970113 | Capital Preparatory Harbor School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 8 | 539 | 231 | * | * | 0 | * | 404 | 381 | 46 | 72 | 785 | 8 | 539 | 231 | 0 | 404 | 381 | 46 | 72 | 785 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2453080 | 2453080 | 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 | 2019 | pk_12_total | 15 | 529 | 197 | * | * | 0 | 12 | 371 | 385 | 41 | 60 | 756 | 15 | 529 | 197 | 0 | 12 | 371 | 385 | 41 | 60 | 756 | |||||||||||||||||||||||||||||||
2778168 | 2778168 | CT | school | 901860 | 620011 | Hamden School District | 90186000339 | 626111 | Hamden High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 540 | 524 | 314 | * | 122 | * | 65 | 822 | 748 | 75 | 236 | 1570 | 540 | 524 | 314 | 122 | 65 | 822 | 748 | 75 | 236 | 1570 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2758665 | 2758665 | 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 | 2021 | pk_12_total | 23 | 507 | 232 | * | * | 0 | 9 | 374 | 400 | 49 | 72 | 774 | 23 | 507 | 232 | 0 | 9 | 374 | 400 | 49 | 72 | 774 | |||||||||||||||||||||||||||||||
2758633 | 2758633 | CT | school | 905220 | 1640011 | Windsor School District | 90522001096 | 1646111 | Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 271 | 500 | 205 | * | 32 | * | 73 | 537 | 547 | 29 | 185 | 1084 | 271 | 500 | 205 | 32 | 73 | 537 | 547 | 29 | 185 | 1084 | |||||||||||||||||||||||||||||||
2452211 | 2452211 | CT | school | 900207 | 2860013 | Highville Charter School District | 90020700907 | 2860113 | Highville Charter School | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2019 | pk_12_total | * | 477 | 17 | 0 | 0 | 0 | * | 227 | 275 | 0 | 26 | 502 | 477 | 17 | 0 | 0 | 0 | 227 | 275 | 0 | 26 | 502 | |||||||||||||||||||||||||||||||
2453075 | 2453075 | CT | school | 900221 | 2970013 | Capital Preparatory Harbor School District | 90022101803 | 2970113 | Capital Preparatory Harbor School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | * | 463 | 167 | * | 0 | 0 | * | 323 | 311 | * | 71 | 634 | 463 | 167 | 0 | 0 | 323 | 311 | 71 | 634 | |||||||||||||||||||||||||||||||||
2777775 | 2777775 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 11 | 460 | 64 | 0 | 6 | 0 | 15 | 287 | 269 | 13 | 98 | 556 | 11 | 460 | 64 | 0 | 6 | 0 | 15 | 287 | 269 | 13 | 98 | 556 | |||||||||||||||||||||||||||||
2451747 | 2451747 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 13 | 456 | 56 | * | * | 0 | 17 | 287 | 260 | 14 | 97 | 547 | 13 | 456 | 56 | 0 | 17 | 287 | 260 | 14 | 97 | 547 | |||||||||||||||||||||||||||||||
2452137 | 2452137 | CT | school | 901860 | 620011 | Hamden School District | 90186000339 | 626111 | Hamden High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 533 | 453 | 284 | 6 | 115 | 0 | 63 | 733 | 721 | 70 | 219 | 1454 | 533 | 453 | 284 | 6 | 115 | 0 | 63 | 733 | 721 | 70 | 219 | 1454 | |||||||||||||||||||||||||||||
2452473 | 2452473 | CT | school | 902790 | 930011 | New Haven School District | 90279000585 | 936111 | Wilbur Cross High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 179 | 429 | 944 | * | 34 | 0 | * | 805 | 789 | 314 | 254 | 1594 | 179 | 429 | 944 | 34 | 0 | 805 | 789 | 314 | 254 | 1594 | |||||||||||||||||||||||||||||||
2757732 | 2757732 | CT | school | 901920 | 640011 | Hartford School District | 90192001435 | 646911 | Capital Preparatory Magnet School | Public Schools | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 30 | 426 | 165 | 0 | 11 | 0 | 28 | 337 | 323 | 27 | 94 | 660 | 30 | 426 | 165 | 0 | 11 | 0 | 28 | 337 | 323 | 27 | 94 | 660 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2757328 | 2757328 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 10 | 422 | 58 | * | * | 0 | 10 | 267 | 239 | 13 | 101 | 506 | 10 | 422 | 58 | 0 | 10 | 267 | 239 | 13 | 101 | 506 | |||||||||||||||||||||||||||||||
2778492 | 2778492 | CT | school | 902790 | 930011 | New Haven School District | 90279000585 | 936111 | Wilbur Cross High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 173 | 410 | 936 | * | 28 | 0 | * | 781 | 772 | 316 | 259 | 1553 | 173 | 410 | 936 | 28 | 0 | 781 | 772 | 316 | 259 | 1553 | |||||||||||||||||||||||||||||||
2758568 | 2758568 | CT | school | 904950 | 1560011 | West Haven School District | 90495001041 | 1566111 | West Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 452 | 406 | 578 | * | 61 | 0 | * | 797 | 757 | 122 | 211 | 1554 | 452 | 406 | 578 | 61 | 0 | 797 | 757 | 122 | 211 | 1554 | |||||||||||||||||||||||||||||||
2757794 | 2757794 | CT | school | 900207 | 2860013 | Highville Charter School District | 90020700907 | 2860113 | Highville Charter School | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2021 | pk_12_total | 6 | 405 | 29 | * | 0 | * | * | 190 | 257 | * | 23 | 447 | 6 | 405 | 29 | 0 | 190 | 257 | 23 | 447 | |||||||||||||||||||||||||||||||||
2451797 | 2451797 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000067 | 156311 | Warren Harding High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 67 | 403 | 597 | * | * | * | 7 | 598 | 484 | 319 | 229 | 1082 | 67 | 403 | 597 | 7 | 598 | 484 | 319 | 229 | 1082 | ||||||||||||||||||||||||||||||||
2758659 | 2758659 | CT | school | 900217 | 2950013 | Booker T. Washington Academy District | 90021701750 | 2950113 | Booker T. Washington Academy | Public Charter Schools | Regular School | Yes | Elementary | KG | 07 | 2021 | pk_12_total | * | 403 | 63 | 0 | * | 0 | 10 | 242 | 238 | 22 | 36 | 480 | 403 | 63 | 0 | 0 | 10 | 242 | 238 | 22 | 36 | 480 | |||||||||||||||||||||||||||||||
2778294 | 2778294 | CT | school | 902310 | 770011 | Manchester School District | 90231000424 | 776111 | Manchester High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 546 | 403 | 443 | * | 127 | * | 66 | 800 | 797 | 96 | 200 | 1597 | 546 | 403 | 443 | 127 | 66 | 800 | 797 | 96 | 200 | 1597 | |||||||||||||||||||||||||||||||
2452273 | 2452273 | CT | school | 902310 | 770011 | Manchester School District | 90231000424 | 776111 | Manchester High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 562 | 399 | 452 | * | 128 | * | 77 | 821 | 807 | 90 | 180 | 1628 | 562 | 399 | 452 | 128 | 77 | 821 | 807 | 90 | 180 | 1628 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2758048 | 2758048 | CT | school | 902790 | 930011 | New Haven School District | 90279000585 | 936111 | Wilbur Cross High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 181 | 392 | 928 | * | 38 | 0 | * | 800 | 747 | 327 | 270 | 1547 | 181 | 392 | 928 | 38 | 0 | 800 | 747 | 327 | 270 | 1547 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2757378 | 2757378 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000067 | 156311 | Warren Harding High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 69 | 387 | 712 | * | 9 | * | 10 | 646 | 547 | 368 | 291 | 1193 | 69 | 387 | 712 | 9 | 10 | 646 | 547 | 368 | 291 | 1193 | |||||||||||||||||||||||||||||||
2777826 | 2777826 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000067 | 156311 | Warren Harding High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 81 | 385 | 668 | * | * | * | 9 | 622 | 531 | 363 | 277 | 1153 | 81 | 385 | 668 | 9 | 622 | 531 | 363 | 277 | 1153 | ||||||||||||||||||||||||||||||||
2452434 | 2452434 | CT | school | 902790 | 930011 | New Haven School District | 90279001388 | 933011 | King/Robinson Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 41 | 381 | 69 | 0 | * | 0 | * | 250 | 259 | 24 | 62 | 509 | 41 | 381 | 69 | 0 | 0 | 250 | 259 | 24 | 62 | 509 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778455 | 2778455 | CT | school | 902790 | 930011 | New Haven School District | 90279001388 | 933011 | King/Robinson Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 40 | 369 | 72 | 0 | 22 | 0 | 12 | 255 | 260 | 33 | 68 | 515 | 40 | 369 | 72 | 0 | 22 | 0 | 12 | 255 | 260 | 33 | 68 | 515 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2779021 | 2779021 | CT | school | 904950 | 1560011 | West Haven School District | 90495001041 | 1566111 | West Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 452 | 367 | 592 | * | 69 | 0 | * | 775 | 760 | 142 | 198 | 1535 | 452 | 367 | 592 | 69 | 0 | 775 | 760 | 142 | 198 | 1535 | |||||||||||||||||||||||||||||||
2452994 | 2452994 | CT | school | 904950 | 1560011 | West Haven School District | 90495001041 | 1566111 | West Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 462 | 362 | 520 | * | 70 | * | 57 | 749 | 727 | 122 | 202 | 1476 | 462 | 362 | 520 | 70 | 57 | 749 | 727 | 122 | 202 | 1476 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2779102 | 2779102 | CT | school | 900217 | 2950013 | Booker T. Washington Academy District | 90021701750 | 2950113 | Booker T. Washington Academy | Public Charter Schools | Regular School | Yes | Elementary | KG | 06 | 2020 | pk_12_total | * | 354 | 55 | 0 | * | 0 | 6 | 212 | 208 | 26 | 29 | 420 | 354 | 55 | 0 | 0 | 6 | 212 | 208 | 26 | 29 | 420 | |||||||||||||||||||||||||||||||
2758010 | 2758010 | CT | school | 902790 | 930011 | New Haven School District | 90279001388 | 933011 | King/Robinson Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 37 | 353 | 76 | 0 | 24 | 0 | 17 | 248 | 259 | 37 | 60 | 507 | 37 | 353 | 76 | 0 | 24 | 0 | 17 | 248 | 259 | 37 | 60 | 507 | |||||||||||||||||||||||||||||
2757445 | 2757445 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070000880 | 2416114 | Metropolitan Learning Center for Global and International Studies | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 98 | 350 | 203 | * | 17 | * | 43 | * | 390 | 22 | 131 | 714 | 98 | 350 | 203 | 17 | 43 | 390 | 22 | 131 | 714 | ||||||||||||||||||||||||||||||||
2777894 | 2777894 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070000880 | 2416114 | Metropolitan Learning Center for Global and International Studies | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2020 | pk_12_total | 116 | 348 | 168 | * | 24 | * | 37 | 309 | 388 | 19 | 121 | 697 | 116 | 348 | 168 | 24 | 37 | 309 | 388 | 19 | 121 | 697 | |||||||||||||||||||||||||||||||
2452171 | 2452171 | CT | school | 901920 | 640011 | Hartford School District | 90192001535 | 643611 | Global Communications Academy | Public Schools | Regular School | No | Other | KG | 12 | 2019 | pk_12_total | * | 345 | 238 | 0 | * | 0 | 8 | 284 | 315 | 88 | 97 | 599 | 345 | 238 | 0 | 0 | 8 | 284 | 315 | 88 | 97 | 599 | |||||||||||||||||||||||||||||||
2757550 | 2757550 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 96 | 344 | 562 | * | 33 | * | 49 | 590 | 499 | 178 | 249 | 1089 | 96 | 344 | 562 | 33 | 49 | 590 | 499 | 178 | 249 | 1089 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451865 | 2451865 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070000880 | 2416114 | Metropolitan Learning Center for Global and International Studies | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 137 | 337 | 159 | * | 28 | * | 46 | 314 | 396 | 14 | 104 | 710 | 137 | 337 | 159 | 28 | 46 | 314 | 396 | 14 | 104 | 710 | |||||||||||||||||||||||||||||||
2451792 | 2451792 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 55 | 332 | 477 | * | 14 | 0 | * | 530 | 354 | 194 | 233 | 884 | 55 | 332 | 477 | 14 | 0 | 530 | 354 | 194 | 233 | 884 | |||||||||||||||||||||||||||||||
2451780 | 2451780 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000080 | 152511 | Read School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 57 | 331 | 388 | * | * | * | 12 | 405 | 392 | 90 | 113 | 797 | 57 | 331 | 388 | 12 | 405 | 392 | 90 | 113 | 797 | ||||||||||||||||||||||||||||||||
2452542 | 2452542 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000655 | 1036111 | Norwalk High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 554 | 330 | 740 | * | 74 | * | 22 | 912 | 810 | 184 | 213 | 1722 | 554 | 330 | 740 | 74 | 22 | 912 | 810 | 184 | 213 | 1722 | |||||||||||||||||||||||||||||||
2453136 | 2453136 | CT | school | 905371 | 9010022 | Norwich Free Academy District | 90537101221 | 9016122 | Norwich Free Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1123 | 330 | 366 | 22 | 174 | 22 | 197 | 1084 | 1150 | 187 | 247 | 2234 | 1123 | 330 | 366 | 22 | 174 | 22 | 197 | 1084 | 1150 | 187 | 247 | 2234 | |||||||||||||||||||||||||||||
2779174 | 2779174 | CT | school | 905371 | 9010022 | Norwich Free Academy District | 90537101221 | 9016122 | Norwich Free Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1173 | 330 | 390 | 26 | 180 | 10 | 132 | 1078 | 1163 | 212 | 248 | 2241 | 1173 | 330 | 390 | 26 | 180 | 10 | 132 | 1078 | 1163 | 212 | 248 | 2241 | |||||||||||||||||||||||||||||
2778800 | 2778800 | CT | school | 904320 | 1350011 | Stamford School District | 90432000871 | 1356311 | Westhill High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 753 | 327 | 967 | * | 131 | * | 52 | 1128 | 1108 | 476 | 283 | 2236 | 753 | 327 | 967 | 131 | 52 | 1128 | 1108 | 476 | 283 | 2236 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452775 | 2452775 | CT | school | 904320 | 1350011 | Stamford School District | 90432000871 | 1356311 | Westhill High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 798 | 324 | 825 | * | 134 | * | 40 | 1060 | 1067 | 395 | 277 | 2127 | 798 | 324 | 825 | 134 | 40 | 1060 | 1067 | 395 | 277 | 2127 | |||||||||||||||||||||||||||||||
2452144 | 2452144 | CT | school | 901920 | 640011 | Hartford School District | 90192001435 | 646911 | Capital Preparatory Magnet School | Public Schools | Regular School | No | Other | PK | 12 | 2019 | pk_12_total | 43 | 323 | 121 | 0 | 11 | 0 | 25 | 263 | 260 | 29 | 62 | 523 | 43 | 323 | 121 | 0 | 11 | 0 | 25 | 263 | 260 | 29 | 62 | 523 | |||||||||||||||||||||||||||||
2453056 | 2453056 | CT | school | 905220 | 1640011 | Windsor School District | 90522001095 | 1645311 | Sage Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 196 | 322 | 122 | 0 | * | * | 54 | 367 | 351 | 26 | 107 | 718 | 196 | 322 | 122 | 0 | 54 | 367 | 351 | 26 | 107 | 718 | |||||||||||||||||||||||||||||||
2451967 | 2451967 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 107 | 321 | 519 | * | 42 | * | 60 | 537 | 514 | 120 | 203 | 1051 | 107 | 321 | 519 | 42 | 60 | 537 | 514 | 120 | 203 | 1051 | |||||||||||||||||||||||||||||||
2758631 | 2758631 | CT | school | 905220 | 1640011 | Windsor School District | 90522001095 | 1645311 | Sage Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 165 | 320 | 165 | * | 26 | * | 57 | 382 | 353 | 20 | 127 | 735 | 165 | 320 | 165 | 26 | 57 | 382 | 353 | 20 | 127 | 735 | |||||||||||||||||||||||||||||||
2758671 | 2758671 | CT | school | 900219 | 2940013 | Great Oaks Charter School District | 90021901782 | 2940113 | Great Oaks Charter School | Public Charter Schools | Regular School | Yes | High | 06 | 12 | 2021 | pk_12_total | 34 | 320 | 310 | * | 0 | * | 0 | 342 | 328 | 82 | 120 | 670 | 34 | 320 | 310 | 0 | 0 | 342 | 328 | 82 | 120 | 670 | |||||||||||||||||||||||||||||||
2777809 | 2777809 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000080 | 152511 | Read School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 60 | 318 | 399 | * | * | * | 7 | 414 | 375 | 107 | 106 | 789 | 60 | 318 | 399 | 7 | 414 | 375 | 107 | 106 | 789 | ||||||||||||||||||||||||||||||||
2778421 | 2778421 | CT | school | 902670 | 890011 | New Britain School District | 90267000521 | 896111 | New Britain High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 407 | 317 | 1375 | * | 68 | * | 48 | 1170 | 1051 | 421 | 513 | 2221 | 407 | 317 | 1375 | 68 | 48 | 1170 | 1051 | 421 | 513 | 2221 | |||||||||||||||||||||||||||||||
2757373 | 2757373 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 53 | 316 | 516 | * | 9 | 0 | * | 540 | 364 | 202 | 272 | 904 | 53 | 316 | 516 | 9 | 0 | 540 | 364 | 202 | 272 | 904 | |||||||||||||||||||||||||||||||
2777821 | 2777821 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 54 | 312 | 427 | * | 10 | 0 | * | 485 | 323 | 198 | 225 | 808 | 54 | 312 | 427 | 10 | 0 | 485 | 323 | 198 | 225 | 808 | |||||||||||||||||||||||||||||||
2452426 | 2452426 | CT | school | 902790 | 930011 | New Haven School District | 90279000551 | 930911 | Davis Academy for Arts & Design Innovation | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 99 | 309 | 91 | * | * | 0 | 10 | 251 | 266 | 8 | 59 | 517 | 99 | 309 | 91 | 0 | 10 | 251 | 266 | 8 | 59 | 517 | |||||||||||||||||||||||||||||||
2453073 | 2453073 | CT | school | 900217 | 2950013 | Booker T. Washington Academy District | 90021701750 | 2950113 | Booker T. Washington Academy | Public Charter Schools | Regular School | Yes | Elementary | KG | 05 | 2019 | pk_12_total | * | 309 | 45 | 0 | 0 | 0 | * | 186 | 174 | 27 | 22 | 360 | 309 | 45 | 0 | 0 | 0 | 186 | 174 | 27 | 22 | 360 | |||||||||||||||||||||||||||||||
2778226 | 2778226 | CT | school | 901920 | 640011 | Hartford School District | 90192001925 | 646211 | Hartford Public High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 28 | 309 | 602 | * | 28 | * | 6 | 528 | 448 | 314 | 208 | 976 | 28 | 309 | 602 | 28 | 6 | 528 | 448 | 314 | 208 | 976 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452935 | 2452935 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000971 | 1516211 | Crosby High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 172 | 306 | 645 | * | 13 | * | 18 | 637 | 525 | 188 | 311 | 1162 | 172 | 306 | 645 | 13 | 18 | 637 | 525 | 188 | 311 | 1162 | |||||||||||||||||||||||||||||||
2779084 | 2779084 | CT | school | 905220 | 1640011 | Windsor School District | 90522001095 | 1645311 | Sage Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 176 | 304 | 155 | * | 21 | * | 50 | 354 | 355 | 20 | 111 | 709 | 176 | 304 | 155 | 21 | 50 | 354 | 355 | 20 | 111 | 709 | |||||||||||||||||||||||||||||||
2758510 | 2758510 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000971 | 1516211 | Crosby High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 134 | 302 | 730 | 13 | 21 | 0 | 17 | 643 | 574 | 234 | 316 | 1217 | 134 | 302 | 730 | 13 | 21 | 0 | 17 | 643 | 574 | 234 | 316 | 1217 | |||||||||||||||||||||||||||||
2452540 | 2452540 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000638 | 1036211 | Brien McMahon High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 363 | 300 | 823 | 0 | 51 | 0 | 25 | 807 | * | 213 | 208 | 1562 | 363 | 300 | 823 | 0 | 51 | 0 | 25 | 807 | 213 | 208 | 1562 | ||||||||||||||||||||||||||||||
2452399 | 2452399 | CT | school | 902670 | 890011 | New Britain School District | 90267000521 | 896111 | New Britain High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 402 | 299 | 1385 | * | 70 | 0 | * | 1158 | 1050 | 390 | 502 | 2208 | 402 | 299 | 1385 | 70 | 0 | 1158 | 1050 | 390 | 502 | 2208 | |||||||||||||||||||||||||||||||
2452376 | 2452376 | CT | school | 900028 | 2800013 | New Beginnings Inc Family Academy District | 90002801366 | 2800113 | New Beginnings Inc Family Academy | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 10 | 298 | 166 | 0 | * | * | * | 246 | 236 | * | 40 | 482 | 10 | 298 | 166 | 0 | 246 | 236 | 40 | 482 | |||||||||||||||||||||||||||||||||
2757950 | 2757950 | CT | school | 900028 | 2800013 | New Beginnings Inc Family Academy District | 90002801366 | 2800113 | New Beginnings Inc Family Academy | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 10 | 298 | 182 | 6 | * | 0 | * | 246 | 256 | 8 | 46 | 502 | 10 | 298 | 182 | 6 | 0 | 246 | 256 | 8 | 46 | 502 | |||||||||||||||||||||||||||||||
2778398 | 2778398 | CT | school | 900028 | 2800013 | New Beginnings Inc Family Academy District | 90002801366 | 2800113 | New Beginnings Inc Family Academy | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 21 | 298 | 175 | * | * | * | 6 | 246 | 259 | 9 | 47 | 505 | 21 | 298 | 175 | 6 | 246 | 259 | 9 | 47 | 505 | ||||||||||||||||||||||||||||||||
2452466 | 2452466 | CT | school | 902790 | 930011 | New Haven School District | 90279000556 | 936311 | Hill Regional Career High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 59 | 295 | 305 | * | 30 | 0 | * | 295 | 405 | 61 | 70 | 700 | 59 | 295 | 305 | 30 | 0 | 295 | 405 | 61 | 70 | 700 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2778448 | 2778448 | CT | school | 902790 | 930011 | New Haven School District | 90279000551 | 930911 | Davis Academy for Arts & Design Innovation | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 99 | 295 | 95 | * | * | 0 | 14 | 261 | 253 | 6 | 51 | 514 | 99 | 295 | 95 | 0 | 14 | 261 | 253 | 6 | 51 | 514 |
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]);