enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "pk_12_total" and state = "CT" sorted by ccd_school_lvl descending
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl ▲ | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2758057 | 2758057 | CT | school | 902820 | 950011 | New London School District | 90282001919 | 951411 | New London Visual and Performing Arts Magnet School | Public Schools | Regular School | No | Secondary | 06 | 11 | 2021 | pk_12_total | 42 | 55 | 95 | * | * | * | 37 | 99 | 136 | 27 | 55 | 235 | 42 | 55 | 95 | 37 | 99 | 136 | 27 | 55 | 235 | ||||||||||||||||||||||||||||||||
2779120 | 2779120 | CT | school | 900219 | 2940013 | Great Oaks Charter School District | 90021901782 | 2940113 | Great Oaks Charter School | Public Charter Schools | Regular School | Yes | Secondary | 06 | 11 | 2020 | pk_12_total | 32 | 266 | 250 | * | 0 | * | * | 262 | 293 | 66 | 93 | 555 | 32 | 266 | 250 | 0 | 262 | 293 | 66 | 93 | 555 | ||||||||||||||||||||||||||||||||
2451740 | 2451740 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 115 | 120 | 37 | * | 25 | 0 | * | 170 | 149 | 0 | 44 | 319 | 115 | 120 | 37 | 25 | 0 | 170 | 149 | 0 | 44 | 319 | |||||||||||||||||||||||||||||||
2451761 | 2451761 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 41 | 63 | 107 | 0 | * | 0 | * | 145 | 81 | 0 | 127 | 226 | 41 | 63 | 107 | 0 | 0 | 145 | 81 | 0 | 127 | 226 | |||||||||||||||||||||||||||||||
2451800 | 2451800 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 66 | * | 29 | 0 | * | 0 | 8 | 62 | 45 | 0 | 65 | 107 | 66 | 29 | 0 | 0 | 8 | 62 | 45 | 0 | 65 | 107 | |||||||||||||||||||||||||||||||
2451912 | 2451912 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 49 | 8 | 73 | * | 12 | 0 | * | 90 | 60 | 0 | 72 | 150 | 49 | 8 | 73 | 12 | 0 | 90 | 60 | 0 | 72 | 150 | |||||||||||||||||||||||||||||||
2451939 | 2451939 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 16 | 10 | 13 | 0 | 0 | * | * | 31 | 13 | 0 | 15 | 44 | 16 | 10 | 13 | 0 | 0 | 31 | 13 | 0 | 15 | 44 | |||||||||||||||||||||||||||||||
2451973 | 2451973 | CT | school | 901290 | 440011 | East Haven School District | 90129001350 | 441811 | Overbrook Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 74 | 9 | 55 | 0 | 9 | 0 | 12 | 69 | 90 | 0 | 7 | 159 | 74 | 9 | 55 | 0 | 9 | 0 | 12 | 69 | 90 | 0 | 7 | 159 | |||||||||||||||||||||||||||||
2452013 | 2452013 | CT | school | 901470 | 490011 | Enfield School District | 90147001915 | 492211 | EPS Integrated Pre-Kindergarten | Program | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 62 | * | * | 0 | * | 0 | * | 48 | 26 | 0 | 46 | 74 | 62 | 0 | 0 | 48 | 26 | 0 | 46 | 74 | |||||||||||||||||||||||||||||||||
2452014 | 2452014 | CT | school | 901470 | 490011 | Enfield School District | 90147001810 | 491011 | EPS PK STEAM Academy | Program | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 31 | 17 | 14 | 0 | * | 0 | * | 39 | 29 | 0 | 10 | 68 | 31 | 17 | 14 | 0 | 0 | 39 | 29 | 0 | 10 | 68 | |||||||||||||||||||||||||||||||
2452149 | 2452149 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 12 | 50 | 23 | * | 57 | 0 | * | 71 | 80 | 0 | 6 | 151 | 12 | 50 | 23 | 57 | 0 | 71 | 80 | 0 | 6 | 151 | |||||||||||||||||||||||||||||||
2452526 | 2452526 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 74 | 14 | 54 | 0 | 15 | 0 | 6 | 100 | 63 | 0 | 104 | 163 | 74 | 14 | 54 | 0 | 15 | 0 | 6 | 100 | 63 | 0 | 104 | 163 | |||||||||||||||||||||||||||||
2452544 | 2452544 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 61 | 33 | 54 | * | 15 | 0 | * | 90 | 85 | 0 | 74 | 175 | 61 | 33 | 54 | 15 | 0 | 90 | 85 | 0 | 74 | 175 | |||||||||||||||||||||||||||||||
2452651 | 2452651 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 40 | * | * | 0 | 0 | 0 | * | 26 | 23 | 0 | 13 | 49 | 40 | 0 | 0 | 0 | 26 | 23 | 0 | 13 | 49 | ||||||||||||||||||||||||||||||||
2452722 | 2452722 | CT | school | 904230 | 1310011 | Southington School District | 90423001804 | 1312111 | Southington Public Schools Preschool Program | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | * | * | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 0 | 11 | 19 | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 0 | 11 | 19 | |||||||||||||||||||||||||||||||
2452723 | 2452723 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 56 | * | 7 | 0 | * | 0 | * | 52 | 18 | 0 | 46 | 70 | 56 | 7 | 0 | 0 | 52 | 18 | 0 | 46 | 70 | ||||||||||||||||||||||||||||||||
2452778 | 2452778 | CT | school | 904380 | 1370011 | Stonington School District | 90438001637 | 1370111 | Stonington BOE Pre-School | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 22 | 0 | * | 0 | * | 0 | 0 | 15 | 11 | 0 | 16 | 26 | 22 | 0 | 0 | 0 | 0 | 15 | 11 | 0 | 16 | 26 | ||||||||||||||||||||||||||||||||
2452779 | 2452779 | CT | school | 904380 | 1370011 | Stonington School District | 90438001635 | 1370211 | Stonington HS PreK | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 22 | 0 | * | 0 | 0 | 0 | * | 17 | 9 | 0 | 17 | 26 | 22 | 0 | 0 | 0 | 0 | 17 | 9 | 0 | 17 | 26 | ||||||||||||||||||||||||||||||||
2757321 | 2757321 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 106 | 113 | 37 | 0 | 35 | 0 | 18 | 139 | 170 | 0 | 37 | 309 | 106 | 113 | 37 | 0 | 35 | 0 | 18 | 139 | 170 | 0 | 37 | 309 | |||||||||||||||||||||||||||||
2757342 | 2757342 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 20 | 58 | 117 | * | 6 | 0 | * | 125 | 80 | 0 | 126 | 205 | 20 | 58 | 117 | 6 | 0 | 125 | 80 | 0 | 126 | 205 | |||||||||||||||||||||||||||||||
2757381 | 2757381 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 46 | * | 38 | 0 | * | 0 | 10 | 63 | 33 | 0 | 71 | 96 | 46 | 38 | 0 | 0 | 10 | 63 | 33 | 0 | 71 | 96 | |||||||||||||||||||||||||||||||
2757494 | 2757494 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 31 | 12 | 80 | 0 | * | 0 | * | 80 | 54 | 0 | 97 | 134 | 31 | 12 | 80 | 0 | 0 | 80 | 54 | 0 | 97 | 134 | |||||||||||||||||||||||||||||||
2757521 | 2757521 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 18 | * | 16 | 0 | * | 0 | * | 25 | 18 | 0 | 18 | 43 | 18 | 16 | 0 | 0 | 25 | 18 | 0 | 18 | 43 | ||||||||||||||||||||||||||||||||
2757556 | 2757556 | CT | school | 901290 | 440011 | East Haven School District | 90129001350 | 441811 | Overbrook Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 55 | * | 36 | 0 | 7 | 0 | * | 56 | 51 | 0 | * | 107 | 55 | 36 | 0 | 7 | 0 | 56 | 51 | 0 | 107 | ||||||||||||||||||||||||||||||||
2757737 | 2757737 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 12 | 64 | 37 | * | 55 | 0 | * | 82 | 98 | 0 | 10 | 180 | 12 | 64 | 37 | 55 | 0 | 82 | 98 | 0 | 10 | 180 | |||||||||||||||||||||||||||||||
2758105 | 2758105 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 38 | 16 | 59 | 0 | * | 0 | * | 78 | 47 | 0 | 82 | 125 | 38 | 16 | 59 | 0 | 0 | 78 | 47 | 0 | 82 | 125 | |||||||||||||||||||||||||||||||
2758124 | 2758124 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 34 | 25 | 36 | * | * | 0 | 12 | 73 | 40 | 0 | 64 | 113 | 34 | 25 | 36 | 0 | 12 | 73 | 40 | 0 | 64 | 113 | |||||||||||||||||||||||||||||||
2758226 | 2758226 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 85 | * | * | 0 | * | 0 | * | 52 | 43 | 0 | 17 | 95 | 85 | 0 | 0 | 52 | 43 | 0 | 17 | 95 | |||||||||||||||||||||||||||||||||
2758301 | 2758301 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 30 | 0 | * | 0 | * | 0 | * | 23 | 15 | 0 | 25 | 38 | 30 | 0 | 0 | 0 | 23 | 15 | 0 | 25 | 38 | ||||||||||||||||||||||||||||||||
2777768 | 2777768 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 107 | 110 | 38 | * | 33 | 0 | * | 159 | 155 | 0 | 49 | 314 | 107 | 110 | 38 | 33 | 0 | 159 | 155 | 0 | 49 | 314 | |||||||||||||||||||||||||||||||
2777790 | 2777790 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 36 | 46 | 121 | 0 | * | 0 | * | 141 | 69 | 0 | 137 | 210 | 36 | 46 | 121 | 0 | 0 | 141 | 69 | 0 | 137 | 210 | |||||||||||||||||||||||||||||||
2777829 | 2777829 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 68 | 0 | 31 | 0 | * | 0 | * | 75 | 38 | 0 | 70 | 113 | 68 | 0 | 31 | 0 | 0 | 75 | 38 | 0 | 70 | 113 | |||||||||||||||||||||||||||||||
2777943 | 2777943 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 46 | * | 81 | 0 | 13 | 0 | * | 101 | 54 | 0 | 80 | 155 | 46 | 81 | 0 | 13 | 0 | 101 | 54 | 0 | 80 | 155 | |||||||||||||||||||||||||||||||
2777970 | 2777970 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 21 | 6 | 15 | 0 | 0 | 0 | 7 | 24 | 25 | 0 | 19 | 49 | 21 | 6 | 15 | 0 | 0 | 0 | 7 | 24 | 25 | 0 | 19 | 49 | |||||||||||||||||||||||||||||
2778180 | 2778180 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 18 | 56 | 26 | * | 56 | 0 | * | 76 | 85 | 0 | 9 | 161 | 18 | 56 | 26 | 56 | 0 | 76 | 85 | 0 | 9 | 161 | |||||||||||||||||||||||||||||||
2778549 | 2778549 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 53 | 15 | 67 | * | 12 | 0 | * | 84 | 71 | 0 | 92 | 155 | 53 | 15 | 67 | 12 | 0 | 84 | 71 | 0 | 92 | 155 | |||||||||||||||||||||||||||||||
2778568 | 2778568 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 54 | 34 | 66 | * | 10 | * | 12 | 97 | 81 | 0 | 61 | 178 | 54 | 34 | 66 | 10 | 12 | 97 | 81 | 0 | 61 | 178 | |||||||||||||||||||||||||||||||
2778673 | 2778673 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 37 | 34 | 0 | 12 | 71 | 0 | 0 | 0 | 0 | 0 | 37 | 34 | 0 | 12 | 71 | |||||||||||||||||||||||||||||||
2778748 | 2778748 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 63 | 0 | 7 | 0 | * | 0 | * | 50 | 27 | 0 | 52 | 77 | 63 | 0 | 7 | 0 | 0 | 50 | 27 | 0 | 52 | 77 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452151 | 2452151 | CT | school | 901920 | 640011 | Hartford School District | 90192000370 | 641111 | Kinsella Magnet School of Performing Arts | Public Schools | Regular School | No | Other | PK | 12 | 2019 | pk_12_total | 177 | 179 | 403 | * | * | 0 | 45 | 312 | 521 | 72 | 139 | 833 | 177 | 179 | 403 | 0 | 45 | 312 | 521 | 72 | 139 | 833 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452744 | 2452744 | CT | school | 904260 | 1330011 | Sprague School District | 90426000842 | 1330111 | Sayles School | Public Schools | Regular School | No | Other | PK | 12 | 2019 | pk_12_total | 217 | 6 | 47 | * | * | * | 35 | 178 | 135 | * | 50 | 313 | 217 | 6 | 47 | 35 | 178 | 135 | 50 | 313 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2757739 | 2757739 | CT | school | 901920 | 640011 | Hartford School District | 90192000370 | 641111 | Kinsella Magnet School of Performing Arts | Public Schools | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 104 | 171 | 372 | * | 32 | 0 | * | 260 | 452 | 76 | 138 | 712 | 104 | 171 | 372 | 32 | 0 | 260 | 452 | 76 | 138 | 712 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778175 | 2778175 | CT | school | 901920 | 640011 | Hartford School District | 90192001435 | 646911 | Capital Preparatory Magnet School | Public Schools | Regular School | No | Other | PK | 12 | 2020 | pk_12_total | 40 | 392 | 162 | 0 | 10 | 0 | 27 | 318 | 313 | 31 | 95 | 631 | 40 | 392 | 162 | 0 | 10 | 0 | 27 | 318 | 313 | 31 | 95 | 631 | |||||||||||||||||||||||||||||
2778182 | 2778182 | CT | school | 901920 | 640011 | Hartford School District | 90192000370 | 641111 | Kinsella Magnet School of Performing Arts | Public Schools | Regular School | No | Other | PK | 12 | 2020 | pk_12_total | 136 | 166 | 346 | * | * | 0 | 30 | 275 | 436 | 69 | 137 | 711 | 136 | 166 | 346 | 0 | 30 | 275 | 436 | 69 | 137 | 711 | |||||||||||||||||||||||||||||||
2778201 | 2778201 | CT | school | 901920 | 640011 | Hartford School District | 90192001535 | 643611 | Global Communications Academy | Public Schools | Regular School | No | Other | KG | 12 | 2020 | pk_12_total | * | 326 | 238 | 0 | * | 0 | 11 | 275 | 308 | 87 | 104 | 583 | 326 | 238 | 0 | 0 | 11 | 275 | 308 | 87 | 104 | 583 | |||||||||||||||||||||||||||||||
2778238 | 2778238 | CT | school | 900207 | 2860013 | Highville Charter School District | 90020700907 | 2860113 | Highville Charter School | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | pk_12_total | 6 | 426 | 20 | * | 0 | * | * | 200 | 260 | * | 24 | 460 | 6 | 426 | 20 | 0 | 200 | 260 | 24 | 460 | |||||||||||||||||||||||||||||||||
2778240 | 2778240 | CT | school | 900007 | 2610013 | Jumoke Academy District | 90000700747 | 2610113 | Jumoke Academy | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | pk_12_total | * | 650 | 39 | * | * | 0 | 8 | * | 367 | 6 | 42 | 706 | 650 | 39 | 0 | 8 | 367 | 6 | 42 | 706 | |||||||||||||||||||||||||||||||||
2779099 | 2779099 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 13 | 596 | 487 | * | 6 | * | * | 524 | 586 | 148 | 112 | 1110 | 13 | 596 | 487 | 6 | 524 | 586 | 148 | 112 | 1110 | ||||||||||||||||||||||||||||||||
2779100 | 2779100 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 842 | 299 | 6 | * | * | 15 | 553 | 616 | 70 | 117 | 1169 | 842 | 299 | 6 | 15 | 553 | 616 | 70 | 117 | 1169 | ||||||||||||||||||||||||||||||||
2779101 | 2779101 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 684 | 381 | * | 0 | 0 | 20 | 498 | 605 | 111 | 80 | 1103 | 684 | 381 | 0 | 0 | 20 | 498 | 605 | 111 | 80 | 1103 | |||||||||||||||||||||||||||||||
2779104 | 2779104 | CT | school | 900221 | 2970013 | Capital Preparatory Harbor School District | 90022101803 | 2970113 | Capital Preparatory Harbor School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 539 | 211 | 0 | 0 | 0 | * | 387 | 373 | 50 | 77 | 760 | 539 | 211 | 0 | 0 | 0 | 387 | 373 | 50 | 77 | 760 | |||||||||||||||||||||||||||||||
2779115 | 2779115 | CT | school | 900214 | 2890013 | Elm City College Preparatory School District | 90021401548 | 2890113 | Elm City College Preparatory School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 21 | 522 | 213 | * | * | 0 | 9 | 373 | 394 | 53 | 70 | 767 | 21 | 522 | 213 | 0 | 9 | 373 | 394 | 53 | 70 | 767 | |||||||||||||||||||||||||||||||
2451929 | 2451929 | CT | school | 901020 | 340011 | Danbury School District | 90102001129 | 346211 | Alternative Center For Excellence | Program | Alternative School | No | Not reported | M | M | 2019 | pk_12_total | 30 | 10 | 44 | * | * | 0 | * | 49 | 42 | 6 | 16 | 91 | 30 | 10 | 44 | 0 | 49 | 42 | 6 | 16 | 91 | ||||||||||||||||||||||||||||||||
2451702 | 2451702 | CT | school | 900060 | 20011 | Ansonia School District | 90006010008 | 25111 | Ansonia Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 121 | 64 | 130 | 0 | * | * | 13 | 173 | 162 | 12 | 72 | 335 | 121 | 64 | 130 | 0 | 13 | 173 | 162 | 12 | 72 | 335 | |||||||||||||||||||||||||||||||
2451710 | 2451710 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007001358 | 2445114 | Thomas Edison Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 174 | 94 | 364 | * | 37 | * | 36 | 348 | 361 | 49 | 82 | 709 | 174 | 94 | 364 | 37 | 36 | 348 | 361 | 49 | 82 | 709 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2451729 | 2451729 | CT | school | 900210 | 70011 | Berlin School District | 90021000017 | 75111 | Catherine M. McGee Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 548 | * | 83 | * | 19 | 0 | 19 | 361 | 324 | 10 | 100 | 685 | 548 | 83 | 19 | 0 | 19 | 361 | 324 | 10 | 100 | 685 | |||||||||||||||||||||||||||||||
2451736 | 2451736 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 501 | 21 | 162 | * | 46 | * | 11 | 372 | 373 | 28 | 84 | 745 | 501 | 21 | 162 | 46 | 11 | 372 | 373 | 28 | 84 | 745 | |||||||||||||||||||||||||||||||
2451744 | 2451744 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 8 | 207 | 23 | 0 | * | * | 6 | 123 | 123 | * | 45 | 246 | 8 | 207 | 23 | 0 | 6 | 123 | 123 | 45 | 246 | ||||||||||||||||||||||||||||||||
2451746 | 2451746 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 8 | 173 | 25 | * | * | 0 | 13 | 127 | 96 | * | 45 | 223 | 8 | 173 | 25 | 0 | 13 | 127 | 96 | 45 | 223 | ||||||||||||||||||||||||||||||||
2451757 | 2451757 | CT | school | 900420 | 140011 | Branford School District | 90042000041 | 145111 | Francis Walsh Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 640 | 35 | 102 | * | 65 | 0 | * | 447 | 424 | 23 | 103 | 871 | 640 | 35 | 102 | 65 | 0 | 447 | 424 | 23 | 103 | 871 | |||||||||||||||||||||||||||||||
2451819 | 2451819 | CT | school | 900510 | 170011 | Bristol School District | 90051000089 | 175111 | Chippens Hill Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 392 | 57 | 234 | * | 26 | * | 28 | 363 | 376 | 35 | 111 | 739 | 392 | 57 | 234 | 26 | 28 | 363 | 376 | 35 | 111 | 739 | |||||||||||||||||||||||||||||||
2451825 | 2451825 | CT | school | 900510 | 170011 | Bristol School District | 90051000104 | 175211 | Northeast Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 318 | 36 | 96 | * | 19 | * | 19 | 245 | 245 | 12 | 82 | 490 | 318 | 36 | 96 | 19 | 19 | 245 | 245 | 12 | 82 | 490 | |||||||||||||||||||||||||||||||
2451835 | 2451835 | CT | school | 900540 | 180011 | Brookfield School District | 90054000112 | 185311 | Whisconier Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 641 | 26 | 104 | * | 70 | * | 7 | 432 | 422 | 26 | 133 | 854 | 641 | 26 | 104 | 70 | 7 | 432 | 422 | 26 | 133 | 854 | |||||||||||||||||||||||||||||||
2451838 | 2451838 | CT | school | 900570 | 190011 | Brooklyn School District | 90057000114 | 195111 | Brooklyn Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 301 | * | 33 | * | 9 | * | 12 | 185 | 177 | * | 54 | 362 | 301 | 33 | 9 | 12 | 185 | 177 | 54 | 362 | |||||||||||||||||||||||||||||||||
2451840 | 2451840 | CT | school | 900660 | 220011 | Canterbury School District | 90066001187 | 225111 | Dr. Helen Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 167 | * | 8 | 0 | 0 | 0 | * | 93 | 86 | 0 | 22 | 179 | 167 | 8 | 0 | 0 | 0 | 93 | 86 | 0 | 22 | 179 | |||||||||||||||||||||||||||||||
2451842 | 2451842 | CT | school | 900690 | 230011 | Canton School District | 90069000119 | 230311 | Canton Intermediate School | Public Schools | Regular School | No | Middle | 04 | 06 | 2019 | pk_12_total | 281 | 31 | 24 | 0 | 10 | * | * | 176 | 176 | * | 40 | 352 | 281 | 31 | 24 | 0 | 10 | 176 | 176 | 40 | 352 | ||||||||||||||||||||||||||||||||
2451843 | 2451843 | CT | school | 900690 | 230011 | Canton School District | 90069001376 | 235111 | Canton Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 204 | 14 | 25 | 0 | * | 0 | * | 131 | 124 | * | 34 | 255 | 204 | 14 | 25 | 0 | 0 | 131 | 124 | 34 | 255 | ||||||||||||||||||||||||||||||||
2451864 | 2451864 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001625 | 2415314 | Greater Hartford Academy of the Arts Magnet Middle | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 86 | 79 | 155 | 0 | * | 0 | * | 88 | 247 | 16 | 88 | 335 | 86 | 79 | 155 | 0 | 0 | 88 | 247 | 16 | 88 | 335 | |||||||||||||||||||||||||||||||
2451866 | 2451866 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001364 | 2415014 | Two Rivers Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 142 | 183 | 272 | * | * | 0 | 39 | 389 | 277 | 43 | 122 | 666 | 142 | 183 | 272 | 0 | 39 | 389 | 277 | 43 | 122 | 666 | |||||||||||||||||||||||||||||||
2451879 | 2451879 | CT | school | 900750 | 250011 | Cheshire School District | 90075000125 | 255111 | Dodd Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 548 | 21 | 40 | 0 | 61 | 0 | 12 | 326 | 356 | * | 79 | 682 | 548 | 21 | 40 | 0 | 61 | 0 | 12 | 326 | 356 | 79 | 682 | ||||||||||||||||||||||||||||||
2451886 | 2451886 | CT | school | 900810 | 270011 | Clinton School District | 90081000133 | 275111 | Jared Eliot School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 349 | * | 62 | * | 18 | 0 | 6 | 223 | 215 | 16 | 77 | 438 | 349 | 62 | 18 | 0 | 6 | 223 | 215 | 16 | 77 | 438 | |||||||||||||||||||||||||||||||
2451890 | 2451890 | CT | school | 900840 | 280011 | Colchester School District | 90084000136 | 285111 | William J. Johnston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 440 | 7 | 36 | * | 16 | * | 19 | 251 | 269 | * | 87 | 520 | 440 | 7 | 36 | 16 | 19 | 251 | 269 | 87 | 520 | ||||||||||||||||||||||||||||||||
2451905 | 2451905 | CT | school | 900960 | 320011 | Coventry School District | 90096000141 | 325111 | Capt. Nathan Hale School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 326 | * | 24 | * | * | 0 | 6 | 170 | 193 | 0 | 49 | 363 | 326 | 24 | 0 | 6 | 170 | 193 | 0 | 49 | 363 | ||||||||||||||||||||||||||||||||
2451910 | 2451910 | CT | school | 900990 | 330011 | Cromwell School District | 90099000147 | 335111 | Cromwell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 339 | 41 | 43 | 0 | 43 | * | * | 257 | 220 | 10 | 41 | 477 | 339 | 41 | 43 | 0 | 43 | 257 | 220 | 10 | 41 | 477 | |||||||||||||||||||||||||||||||
2451926 | 2451926 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 331 | 72 | 479 | * | 56 | 0 | * | 480 | 497 | 130 | 170 | 977 | 331 | 72 | 479 | 56 | 0 | 480 | 497 | 130 | 170 | 977 | |||||||||||||||||||||||||||||||
2451927 | 2451927 | CT | school | 901020 | 340011 | Danbury School District | 90102000160 | 345211 | Rogers Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 253 | 68 | 579 | 0 | 53 | * | * | 499 | 480 | 267 | 139 | 979 | 253 | 68 | 579 | 0 | 53 | 499 | 480 | 267 | 139 | 979 | |||||||||||||||||||||||||||||||
2451928 | 2451928 | CT | school | 901020 | 340011 | Danbury School District | 90102001691 | 340311 | Westside Middle School Academy | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 283 | 40 | 242 | * | 53 | 0 | * | 329 | 310 | 42 | 52 | 639 | 283 | 40 | 242 | 53 | 0 | 329 | 310 | 42 | 52 | 639 | |||||||||||||||||||||||||||||||
2451937 | 2451937 | CT | school | 901050 | 350011 | Darien School District | 90105000169 | 355111 | Middlesex Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 947 | * | 61 | * | 57 | 0 | 27 | 552 | 549 | * | 152 | 1101 | 947 | 61 | 57 | 0 | 27 | 552 | 549 | 152 | 1101 | ||||||||||||||||||||||||||||||||
2451942 | 2451942 | CT | school | 901110 | 370011 | Derby School District | 90111001578 | 375011 | Derby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 147 | 56 | 109 | 0 | * | * | 18 | 167 | 174 | 6 | 69 | 341 | 147 | 56 | 109 | 0 | 18 | 167 | 174 | 6 | 69 | 341 | |||||||||||||||||||||||||||||||
2451947 | 2451947 | CT | school | 901170 | 400011 | East Granby School District | 90117000182 | 405111 | East Granby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 155 | 16 | * | 0 | 16 | 0 | * | 107 | 94 | 0 | 29 | 201 | 155 | 16 | 0 | 16 | 0 | 107 | 94 | 0 | 29 | 201 | |||||||||||||||||||||||||||||||
2451950 | 2451950 | CT | school | 901200 | 410011 | East Haddam School District | 90120000198 | 415111 | Nathan Hale-Ray Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | pk_12_total | 327 | * | 16 | * | 6 | 0 | * | 188 | 172 | 0 | 51 | 360 | 327 | 16 | 6 | 0 | 188 | 172 | 0 | 51 | 360 |
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]);