enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "pk_12_total" and state = "CT" sorted by school_nces_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2757795 | 2757795 | CT | school | 900010 | 2640013 | Integrated Day Charter School District | 90001000775 | 2640113 | Integrated Day Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 162 | 40 | 62 | * | 49 | 0 | * | 172 | 181 | 25 | 32 | 353 | 162 | 40 | 62 | 49 | 0 | 172 | 181 | 25 | 32 | 353 | |||||||||||||||||||||||||||||||
2778239 | 2778239 | CT | school | 900010 | 2640013 | Integrated Day Charter School District | 90001000775 | 2640113 | Integrated Day Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 166 | * | 63 | * | 49 | 0 | 37 | 173 | 179 | 29 | 32 | 352 | 166 | 63 | 49 | 0 | 37 | 173 | 179 | 29 | 32 | 352 | |||||||||||||||||||||||||||||||
2453085 | 2453085 | CT | school | 900011 | 2650013 | Interdistrict School for Arts and Comm District | 90001100797 | 2655113 | Interdistrict School For Arts And Communication | Public Charter Schools | Regular School | Yes | Middle | 06 | 08 | 2019 | pk_12_total | 54 | 49 | 160 | * | * | * | * | 133 | 145 | 29 | 38 | 278 | 54 | 49 | 160 | 133 | 145 | 29 | 38 | 278 | |||||||||||||||||||||||||||||||||
2758672 | 2758672 | CT | school | 900011 | 2650013 | Interdistrict School for Arts and Comm District | 90001100797 | 2655113 | Interdistrict School For Arts And Communication | Public Charter Schools | Regular School | Yes | Middle | 06 | 08 | 2021 | pk_12_total | 44 | 51 | 176 | * | * | * | * | 143 | 138 | 54 | 54 | 281 | 44 | 51 | 176 | 143 | 138 | 54 | 54 | 281 | |||||||||||||||||||||||||||||||||
2779121 | 2779121 | CT | school | 900011 | 2650013 | Interdistrict School for Arts and Comm District | 90001100797 | 2655113 | Interdistrict School For Arts And Communication | Public Charter Schools | Regular School | Yes | Middle | 06 | 08 | 2020 | pk_12_total | 49 | 42 | 174 | * | 6 | * | 0 | 143 | 136 | 55 | 51 | 279 | 49 | 42 | 174 | 6 | 0 | 143 | 136 | 55 | 51 | 279 | |||||||||||||||||||||||||||||||
2453117 | 2453117 | CT | school | 900014 | 2680013 | Common Ground High School District | 90001400807 | 2686113 | Common Ground High School | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 47 | 87 | 74 | 0 | * | 0 | * | 136 | 80 | 12 | 49 | 216 | 47 | 87 | 74 | 0 | 0 | 136 | 80 | 12 | 49 | 216 | |||||||||||||||||||||||||||||||
2758704 | 2758704 | CT | school | 900014 | 2680013 | Common Ground High School District | 90001400807 | 2686113 | Common Ground High School | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 52 | 78 | 98 | 0 | 0 | * | * | 136 | * | 11 | 56 | 236 | 52 | 78 | 98 | 0 | 0 | 136 | 11 | 56 | 236 | ||||||||||||||||||||||||||||||||
2779155 | 2779155 | CT | school | 900014 | 2680013 | Common Ground High School District | 90001400807 | 2686113 | Common Ground High School | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | * | 84 | 90 | 0 | 0 | 0 | * | 131 | * | 11 | 55 | 223 | 84 | 90 | 0 | 0 | 0 | 131 | 11 | 55 | 223 | ||||||||||||||||||||||||||||||||
2453104 | 2453104 | CT | school | 900015 | 2690013 | The Bridge Academy District | 90001500809 | 2696113 | The Bridge Academy | Public Charter Schools | Regular School | Yes | High | 07 | 12 | 2019 | pk_12_total | * | 160 | 113 | * | * | 0 | 0 | 139 | 142 | 8 | 55 | 281 | 160 | 113 | 0 | 0 | 139 | 142 | 8 | 55 | 281 | ||||||||||||||||||||||||||||||||
2758692 | 2758692 | CT | school | 900015 | 2690013 | The Bridge Academy District | 90001500809 | 2696113 | The Bridge Academy | Public Charter Schools | Regular School | Yes | High | 07 | 12 | 2021 | pk_12_total | * | 163 | 114 | 0 | * | 0 | * | 137 | 144 | 9 | 60 | 281 | 163 | 114 | 0 | 0 | 137 | 144 | 9 | 60 | 281 | ||||||||||||||||||||||||||||||||
2779141 | 2779141 | CT | school | 900015 | 2690013 | The Bridge Academy District | 90001500809 | 2696113 | The Bridge Academy | Public Charter Schools | Regular School | Yes | High | 07 | 12 | 2020 | pk_12_total | * | 129 | 122 | 0 | * | 24 | 0 | 144 | 137 | 12 | 60 | 281 | 129 | 122 | 0 | 24 | 0 | 144 | 137 | 12 | 60 | 281 | |||||||||||||||||||||||||||||||
2452700 | 2452700 | CT | school | 900016 | 2700013 | Side By Side Charter School District | 90001600823 | 2700113 | Side By Side Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 30 | 65 | 119 | 0 | 7 | 0 | 15 | 115 | 121 | 22 | 25 | 236 | 30 | 65 | 119 | 0 | 7 | 0 | 15 | 115 | 121 | 22 | 25 | 236 | |||||||||||||||||||||||||||||
2758279 | 2758279 | CT | school | 900016 | 2700013 | Side By Side Charter School District | 90001600823 | 2700113 | Side By Side Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 29 | 59 | 130 | 0 | * | 0 | * | 113 | 122 | 28 | 20 | 235 | 29 | 59 | 130 | 0 | 0 | 113 | 122 | 28 | 20 | 235 | |||||||||||||||||||||||||||||||
2778726 | 2778726 | CT | school | 900016 | 2700013 | Side By Side Charter School District | 90001600823 | 2700113 | Side By Side Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 25 | 68 | 127 | 0 | * | 0 | * | 116 | 120 | 23 | 25 | 236 | 25 | 68 | 127 | 0 | 0 | 116 | 120 | 23 | 25 | 236 | |||||||||||||||||||||||||||||||
2453135 | 2453135 | CT | school | 900018 | 2720013 | Explorations District | 90001800834 | 2726113 | Explorations | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 75 | * | 9 | 0 | 0 | 0 | * | 35 | 53 | 0 | 27 | 88 | 75 | 9 | 0 | 0 | 0 | 35 | 53 | 0 | 27 | 88 | |||||||||||||||||||||||||||||||
2758724 | 2758724 | CT | school | 900018 | 2720013 | Explorations District | 90001800834 | 2726113 | Explorations | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 68 | * | 13 | 0 | 0 | 0 | * | 45 | * | 0 | 33 | 86 | 68 | 13 | 0 | 0 | 0 | 45 | 0 | 33 | 86 | ||||||||||||||||||||||||||||||||
2779173 | 2779173 | CT | school | 900018 | 2720013 | Explorations District | 90001800834 | 2726113 | Explorations | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 76 | * | 10 | 0 | 0 | 0 | * | 48 | 45 | 0 | 38 | 93 | 76 | 10 | 0 | 0 | 0 | 48 | 45 | 0 | 38 | 93 | |||||||||||||||||||||||||||||||
2453086 | 2453086 | CT | school | 900023 | 2780013 | Trailblazers Academy District | 90002300965 | 2785113 | Trailblazers Academy | Regular School | Yes | Middle | 06 | 08 | 2019 | pk_12_total | * | 63 | 58 | 0 | * | 0 | * | 70 | 57 | 14 | 33 | 127 | 63 | 58 | 0 | 0 | 70 | 57 | 14 | 33 | 127 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2779184 | 2779184 | CT | school | 3370015 | Department of Mental Health and Addiction Services | 90002701537 | 3370515 | Greater Bridgeport Community Mental Health Center | State Agency Facilities | 2020 | pk_12_total | 0 | 0 | * | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2453146 | 2453146 | CT | school | 3370015 | Department of Mental Health and Addiction Services | 90002701539 | 3370215 | Connecticut Valley Hospital | State Agency Facilities | 2019 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2758723 | 2758723 | CT | school | 3370015 | Department of Mental Health and Addiction Services | 90002701539 | 3370215 | Connecticut Valley Hospital | State Agency Facilities | 2021 | pk_12_total | 0 | * | 0 | 0 | 0 | 0 | 0 | 0 | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2779183 | 2779183 | CT | school | 3370015 | Department of Mental Health and Addiction Services | 90002701539 | 3370215 | Connecticut Valley Hospital | State Agency Facilities | 2020 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2758722 | 2758722 | CT | school | 3370015 | Department of Mental Health and Addiction Services | 90002701922 | 3370915 | Whiting Forensic Hospital | State Agency Facilities | 2021 | pk_12_total | 0 | * | 0 | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2779185 | 2779185 | CT | school | 3370015 | Department of Mental Health and Addiction Services | 90002701922 | 3370915 | Whiting Forensic Hospital | State Agency Facilities | 2020 | pk_12_total | 0 | 0 | * | 0 | 0 | 0 | 0 | 0 | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2451698 | 2451698 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 164 | * | 17 | 0 | 0 | 0 | * | 101 | 90 | * | 12 | 191 | 164 | 17 | 0 | 0 | 0 | 101 | 90 | 12 | 191 | ||||||||||||||||||||||||||||||||
2757288 | 2757288 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 141 | * | 22 | 0 | 0 | 0 | * | 86 | 87 | * | 22 | 173 | 141 | 22 | 0 | 0 | 0 | 86 | 87 | 22 | 173 | ||||||||||||||||||||||||||||||||
2777725 | 2777725 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 158 | * | 24 | 0 | 0 | 0 | * | 99 | 96 | * | 21 | 195 | 158 | 24 | 0 | 0 | 0 | 99 | 96 | 21 | 195 | ||||||||||||||||||||||||||||||||
2453144 | 2453144 | CT | school | 900031 | 2820013 | Stamford Academy District | 90003101405 | 2826013 | Stamford Academy | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 9 | 70 | 66 | 0 | * | 0 | * | 84 | 68 | 9 | 54 | 152 | 9 | 70 | 66 | 0 | 0 | 84 | 68 | 9 | 54 | 152 | ||||||||||||||||||||||||||||||||
2779181 | 2779181 | CT | school | 900031 | 2820013 | Stamford Academy District | 90003101405 | 2826013 | Stamford Academy | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | 11 | 65 | 64 | 0 | 0 | 0 | 7 | 85 | 62 | 14 | 52 | 147 | 11 | 65 | 64 | 0 | 0 | 0 | 7 | 85 | 62 | 14 | 52 | 147 | ||||||||||||||||||||||||||||||
2453083 | 2453083 | CT | school | 900033 | 2830013 | Park City Prep Charter School District | 90003301449 | 2835113 | Park City Prep Charter School | Public Charter Schools | Regular School | Yes | Middle | 05 | 08 | 2019 | pk_12_total | 15 | 160 | 175 | * | * | * | * | 193 | 167 | 36 | 43 | 360 | 15 | 160 | 175 | 193 | 167 | 36 | 43 | 360 | |||||||||||||||||||||||||||||||||
2758670 | 2758670 | CT | school | 900033 | 2830013 | Park City Prep Charter School District | 90003301449 | 2835113 | Park City Prep Charter School | Public Charter Schools | Regular School | Yes | Middle | 05 | 08 | 2021 | pk_12_total | 21 | 157 | 172 | * | * | 0 | * | 177 | 183 | 32 | 33 | 360 | 21 | 157 | 172 | 0 | 177 | 183 | 32 | 33 | 360 | ||||||||||||||||||||||||||||||||
2779119 | 2779119 | CT | school | 900033 | 2830013 | Park City Prep Charter School District | 90003301449 | 2835113 | Park City Prep Charter School | Public Charter Schools | Regular School | Yes | Middle | 05 | 08 | 2020 | pk_12_total | 19 | 157 | 175 | * | * | * | * | 183 | 178 | 27 | 34 | 361 | 19 | 157 | 175 | 183 | 178 | 27 | 34 | 361 | |||||||||||||||||||||||||||||||||
2451700 | 2451700 | CT | school | 900060 | 20011 | Ansonia School District | 90006000005 | 20311 | Mead School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 181 | 137 | 284 | 0 | * | * | 27 | 329 | 305 | 36 | 122 | 634 | 181 | 137 | 284 | 0 | 27 | 329 | 305 | 36 | 122 | 634 | |||||||||||||||||||||||||||||||
2757290 | 2757290 | CT | school | 900060 | 20011 | Ansonia School District | 90006000005 | 20311 | Mead School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 140 | 134 | 310 | 0 | * | * | 33 | 320 | 303 | 42 | 113 | 623 | 140 | 134 | 310 | 0 | 33 | 320 | 303 | 42 | 113 | 623 | |||||||||||||||||||||||||||||||
2777727 | 2777727 | CT | school | 900060 | 20011 | Ansonia School District | 90006000005 | 20311 | Mead School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 138 | 116 | 317 | 0 | * | * | 41 | 312 | 308 | 41 | 115 | 620 | 138 | 116 | 317 | 0 | 41 | 312 | 308 | 41 | 115 | 620 | |||||||||||||||||||||||||||||||
2451701 | 2451701 | CT | school | 900060 | 20011 | Ansonia School District | 90006001020 | 20811 | Prendergast School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 256 | 85 | 239 | 0 | 15 | 0 | 49 | 338 | 306 | 37 | 120 | 644 | 256 | 85 | 239 | 0 | 15 | 0 | 49 | 338 | 306 | 37 | 120 | 644 | |||||||||||||||||||||||||||||
2757291 | 2757291 | CT | school | 900060 | 20011 | Ansonia School District | 90006001020 | 20811 | Prendergast School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 204 | 98 | 273 | 0 | 15 | 0 | 46 | 334 | 302 | 44 | 102 | 636 | 204 | 98 | 273 | 0 | 15 | 0 | 46 | 334 | 302 | 44 | 102 | 636 | |||||||||||||||||||||||||||||
2777728 | 2777728 | CT | school | 900060 | 20011 | Ansonia School District | 90006001020 | 20811 | Prendergast School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 212 | 99 | 261 | 0 | 16 | 0 | 51 | 338 | 301 | 38 | 113 | 639 | 212 | 99 | 261 | 0 | 16 | 0 | 51 | 338 | 301 | 38 | 113 | 639 | |||||||||||||||||||||||||||||
2451704 | 2451704 | CT | school | 20011 | Ansonia School District | 90006001678 | 20111 | P.A.C.E. (Positive And Creative Education) | Program | 2019 | pk_12_total | * | 8 | 15 | 0 | 0 | 0 | * | 18 | 9 | 0 | * | 27 | 8 | 15 | 0 | 0 | 0 | 18 | 9 | 0 | 27 | ||||||||||||||||||||||||||||||||||||||
2757294 | 2757294 | CT | school | 20011 | Ansonia School District | 90006001678 | 20111 | P.A.C.E. (Positive And Creative Education) | Program | 2021 | pk_12_total | * | 8 | 14 | 0 | 0 | 0 | * | 18 | 10 | * | 8 | 28 | 8 | 14 | 0 | 0 | 0 | 18 | 10 | 8 | 28 | ||||||||||||||||||||||||||||||||||||||
2777731 | 2777731 | CT | school | 20011 | Ansonia School District | 90006001678 | 20111 | P.A.C.E. (Positive And Creative Education) | Program | 2020 | pk_12_total | * | 10 | 13 | 0 | 0 | 0 | * | 17 | 12 | 0 | 6 | 29 | 10 | 13 | 0 | 0 | 0 | 17 | 12 | 0 | 6 | 29 | |||||||||||||||||||||||||||||||||||||
2451703 | 2451703 | CT | school | 900060 | 20011 | Ansonia School District | 90006010002 | 26111 | Ansonia High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 228 | 116 | 185 | * | * | 10 | 15 | 302 | 263 | 19 | 126 | 565 | 228 | 116 | 185 | 10 | 15 | 302 | 263 | 19 | 126 | 565 | |||||||||||||||||||||||||||||||
2757293 | 2757293 | CT | school | 900060 | 20011 | Ansonia School District | 90006010002 | 26111 | Ansonia High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 159 | 115 | 196 | * | 13 | * | 18 | 262 | 241 | 20 | 88 | 503 | 159 | 115 | 196 | 13 | 18 | 262 | 241 | 20 | 88 | 503 | |||||||||||||||||||||||||||||||
2777730 | 2777730 | CT | school | 900060 | 20011 | Ansonia School District | 90006010002 | 26111 | Ansonia High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 185 | 110 | 185 | * | 13 | * | 17 | 275 | 238 | 25 | 106 | 513 | 185 | 110 | 185 | 13 | 17 | 275 | 238 | 25 | 106 | 513 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2757292 | 2757292 | CT | school | 900060 | 20011 | Ansonia School District | 90006010008 | 25111 | Ansonia Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 109 | 63 | 164 | 0 | 7 | 0 | 22 | 192 | 173 | 17 | 63 | 365 | 109 | 63 | 164 | 0 | 7 | 0 | 22 | 192 | 173 | 17 | 63 | 365 | |||||||||||||||||||||||||||||
2777729 | 2777729 | CT | school | 900060 | 20011 | Ansonia School District | 90006010008 | 25111 | Ansonia Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 108 | 74 | 148 | 0 | 6 | 0 | 20 | 189 | 167 | 10 | 73 | 356 | 108 | 74 | 148 | 0 | 6 | 0 | 20 | 189 | 167 | 10 | 73 | 356 | |||||||||||||||||||||||||||||
2451708 | 2451708 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007000884 | 2440314 | Wintergreen Interdistrict Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 117 | 272 | 129 | * | 23 | * | 21 | 267 | 297 | 36 | 71 | 564 | 117 | 272 | 129 | 23 | 21 | 267 | 297 | 36 | 71 | 564 | |||||||||||||||||||||||||||||||
2758651 | 2758651 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007000884 | 2440314 | Wintergreen Interdistrict Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 95 | 215 | 127 | * | * | 0 | 30 | 227 | 264 | 56 | 74 | 491 | 95 | 215 | 127 | 0 | 30 | 227 | 264 | 56 | 74 | 491 | |||||||||||||||||||||||||||||||
2777736 | 2777736 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007000884 | 2440314 | Wintergreen Interdistrict Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 113 | 237 | 124 | * | 19 | * | 20 | 242 | 273 | 50 | 71 | 515 | 113 | 237 | 124 | 19 | 20 | 242 | 273 | 50 | 71 | 515 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2758655 | 2758655 | 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 | 2021 | pk_12_total | 133 | 111 | 405 | * | 32 | * | 34 | 362 | 358 | 74 | 97 | 720 | 133 | 111 | 405 | 32 | 34 | 362 | 358 | 74 | 97 | 720 | |||||||||||||||||||||||||||||||
2777739 | 2777739 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007001358 | 2445114 | Thomas Edison Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 144 | 100 | 381 | * | 36 | 0 | * | 342 | 356 | 67 | 79 | 698 | 144 | 100 | 381 | 36 | 0 | 342 | 356 | 67 | 79 | 698 | |||||||||||||||||||||||||||||||
2451713 | 2451713 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001490 | 2449114 | Whitney High School North | Program | 2019 | pk_12_total | 13 | 50 | 28 | 0 | 0 | * | * | 70 | 28 | * | 98 | 98 | 13 | 50 | 28 | 0 | 0 | 70 | 28 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||
2758657 | 2758657 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001490 | 2449114 | Whitney High School North | Program | 2021 | pk_12_total | * | 51 | 31 | 0 | 0 | * | 12 | 78 | 29 | 7 | 107 | 107 | 51 | 31 | 0 | 0 | 12 | 78 | 29 | 7 | 107 | 107 | |||||||||||||||||||||||||||||||||||||
2777742 | 2777742 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001490 | 2449114 | Whitney High School North | Program | 2020 | pk_12_total | 13 | 54 | 25 | 0 | 0 | * | * | 77 | 24 | * | 101 | 101 | 13 | 54 | 25 | 0 | 0 | 77 | 24 | 101 | 101 | ||||||||||||||||||||||||||||||||||||||
2451706 | 2451706 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001499 | 2449514 | Village School | Program | 2019 | pk_12_total | 54 | 46 | 28 | * | 6 | * | * | 102 | 37 | 0 | 139 | 139 | 54 | 46 | 28 | 6 | 102 | 37 | 0 | 139 | 139 | ||||||||||||||||||||||||||||||||||||||
2758650 | 2758650 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001499 | 2449514 | Village School | Program | 2021 | pk_12_total | 47 | 44 | 29 | 0 | * | 0 | * | 96 | 30 | * | 126 | 126 | 47 | 44 | 29 | 0 | 0 | 96 | 30 | 126 | 126 | ||||||||||||||||||||||||||||||||||||||
2777734 | 2777734 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001499 | 2449514 | Village School | Program | 2020 | pk_12_total | 44 | 48 | 29 | * | * | * | * | 97 | 32 | * | 129 | 129 | 44 | 48 | 29 | 97 | 32 | 129 | 129 | ||||||||||||||||||||||||||||||||||||||||
2451712 | 2451712 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001502 | 2449214 | Whitney Academy | Program | 2019 | pk_12_total | 27 | 19 | 22 | 0 | * | 0 | * | 54 | 17 | 0 | 71 | 71 | 27 | 19 | 22 | 0 | 0 | 54 | 17 | 0 | 71 | 71 | |||||||||||||||||||||||||||||||||||||
2758656 | 2758656 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001502 | 2449214 | Whitney Academy | Program | 2021 | pk_12_total | 43 | 23 | 28 | * | * | * | * | 74 | 27 | * | 101 | 101 | 43 | 23 | 28 | 74 | 27 | 101 | 101 | ||||||||||||||||||||||||||||||||||||||||
2777741 | 2777741 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001502 | 2449214 | Whitney Academy | Program | 2020 | pk_12_total | 43 | 22 | 30 | 0 | * | 0 | * | 75 | 25 | * | 100 | 100 | 43 | 22 | 30 | 0 | 0 | 75 | 25 | 100 | 100 | ||||||||||||||||||||||||||||||||||||||
2451709 | 2451709 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001505 | 2449414 | Mill Academy | Program | 2019 | pk_12_total | 20 | 68 | 40 | 0 | 0 | 0 | 6 | 107 | 27 | * | * | 134 | 20 | 68 | 40 | 0 | 0 | 0 | 6 | 107 | 27 | 134 | |||||||||||||||||||||||||||||||||||||
2758654 | 2758654 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001505 | 2449414 | Mill Academy | Program | 2021 | pk_12_total | * | 43 | 21 | 0 | 0 | 0 | * | 67 | 15 | * | * | 82 | 43 | 21 | 0 | 0 | 0 | 67 | 15 | 82 | |||||||||||||||||||||||||||||||||||||||
2777738 | 2777738 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001505 | 2449414 | Mill Academy | Program | 2020 | pk_12_total | 15 | 46 | 34 | 0 | 0 | 0 | 7 | 85 | 17 | 0 | 95 | 102 | 15 | 46 | 34 | 0 | 0 | 0 | 7 | 85 | 17 | 0 | 95 | 102 | |||||||||||||||||||||||||||||||||||
2451711 | 2451711 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001588 | 2449614 | Center for Autism Spectrum and Development Disorders | Program | 2019 | pk_12_total | 26 | 8 | * | 0 | * | 0 | * | 30 | 10 | 0 | 40 | 40 | 26 | 8 | 0 | 0 | 30 | 10 | 0 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||
2758653 | 2758653 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001588 | 2449614 | Center for Autism Spectrum and Development Disorders | Program | 2021 | pk_12_total | 24 | 8 | * | 0 | * | 0 | * | 30 | 10 | 0 | 40 | 40 | 24 | 8 | 0 | 0 | 30 | 10 | 0 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||
2777740 | 2777740 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001588 | 2449614 | Center for Autism Spectrum and Development Disorders | Program | 2020 | pk_12_total | 25 | 7 | * | 0 | * | 0 | * | 30 | 10 | 0 | 40 | 40 | 25 | 7 | 0 | 0 | 30 | 10 | 0 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||
2451716 | 2451716 | CT | school | 900090 | 30011 | Ashford School District | 90009000010 | 30111 | Ashford School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 344 | 8 | 31 | 0 | * | * | 20 | 210 | 199 | 9 | 47 | 409 | 344 | 8 | 31 | 0 | 20 | 210 | 199 | 9 | 47 | 409 | |||||||||||||||||||||||||||||||
2757297 | 2757297 | CT | school | 900090 | 30011 | Ashford School District | 90009000010 | 30111 | Ashford School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 314 | 10 | 26 | 0 | * | * | 14 | 200 | 170 | 6 | 53 | 370 | 314 | 10 | 26 | 0 | 14 | 200 | 170 | 6 | 53 | 370 | |||||||||||||||||||||||||||||||
2777744 | 2777744 | CT | school | 900090 | 30011 | Ashford School District | 90009000010 | 30111 | Ashford School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 330 | 7 | 31 | 0 | * | * | 17 | 204 | 186 | 6 | 52 | 390 | 330 | 7 | 31 | 0 | 17 | 204 | 186 | 6 | 52 | 390 | |||||||||||||||||||||||||||||||
2451722 | 2451722 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 679 | 40 | 55 | * | 142 | 0 | * | 492 | 459 | * | 110 | 951 | 679 | 40 | 55 | 142 | 0 | 492 | 459 | 110 | 951 | ||||||||||||||||||||||||||||||||
2757303 | 2757303 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 634 | 53 | 65 | * | 166 | 0 | * | 500 | 457 | 8 | 97 | 957 | 634 | 53 | 65 | 166 | 0 | 500 | 457 | 8 | 97 | 957 | |||||||||||||||||||||||||||||||
2777750 | 2777750 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 658 | 48 | 60 | * | 153 | 0 | * | 510 | 447 | 6 | 101 | 957 | 658 | 48 | 60 | 153 | 0 | 510 | 447 | 6 | 101 | 957 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2777749 | 2777749 | CT | school | 900120 | 40011 | Avon School District | 90012000012 | 45111 | Avon Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 325 | 26 | 36 | 0 | 123 | 0 | 16 | 248 | 278 | 7 | 54 | 526 | 325 | 26 | 36 | 0 | 123 | 0 | 16 | 248 | 278 | 7 | 54 | 526 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2757301 | 2757301 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 296 | 28 | 38 | * | 122 | 0 | * | 255 | 248 | 8 | 53 | 503 | 296 | 28 | 38 | 122 | 0 | 255 | 248 | 8 | 53 | 503 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451717 | 2451717 | CT | school | 40011 | Avon School District | 90012001737 | 40111 | Avon Early Learning Center at Roaring Brook School | Program | 2019 | pk_12_total | 31 | 10 | * | 0 | 10 | 0 | * | 34 | 24 | 0 | 24 | 58 | 31 | 10 | 0 | 10 | 0 | 34 | 24 | 0 | 24 | 58 | |||||||||||||||||||||||||||||||||||||
2757298 | 2757298 | CT | school | 40011 | Avon School District | 90012001737 | 40111 | Avon Early Learning Center at Roaring Brook School | Program | 2021 | pk_12_total | 21 | 7 | 7 | 0 | * | 0 | * | 22 | 21 | 0 | 17 | 43 | 21 | 7 | 7 | 0 | 0 | 22 | 21 | 0 | 17 | 43 | |||||||||||||||||||||||||||||||||||||
2777745 | 2777745 | CT | school | 40011 | Avon School District | 90012001737 | 40111 | Avon Early Learning Center at Roaring Brook School | Program | 2020 | pk_12_total | 29 | 11 | * | * | 10 | 0 | * | 29 | 27 | 0 | 23 | 56 | 29 | 11 | 10 | 0 | 29 | 27 | 0 | 23 | 56 | ||||||||||||||||||||||||||||||||||||||
2451718 | 2451718 | CT | school | 900120 | 40011 | Avon School District | 90012010010 | 40411 | Pine Grove School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 367 | 35 | 43 | * | 156 | 0 | * | 297 | 329 | 75 | 55 | 626 | 367 | 35 | 43 | 156 | 0 | 297 | 329 | 75 | 55 | 626 | |||||||||||||||||||||||||||||||
2757299 | 2757299 | CT | school | 900120 | 40011 | Avon School District | 90012010010 | 40411 | Pine Grove School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 373 | 37 | 38 | 0 | 133 | 0 | 23 | 276 | 328 | 63 | 51 | 604 | 373 | 37 | 38 | 0 | 133 | 0 | 23 | 276 | 328 | 63 | 51 | 604 | |||||||||||||||||||||||||||||
2777746 | 2777746 | CT | school | 900120 | 40011 | Avon School District | 90012010010 | 40411 | Pine Grove School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 390 | 33 | 44 | * | 138 | 0 | * | 301 | 333 | 65 | 51 | 634 | 390 | 33 | 44 | 138 | 0 | 301 | 333 | 65 | 51 | 634 | |||||||||||||||||||||||||||||||
2451723 | 2451723 | CT | school | 900150 | 50011 | Barkhamsted School District | 90015000015 | 50111 | Barkhamsted Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 184 | * | 7 | 0 | * | 0 | 10 | 99 | 105 | * | 42 | 204 | 184 | 7 | 0 | 0 | 10 | 99 | 105 | 42 | 204 | ||||||||||||||||||||||||||||||||
2757305 | 2757305 | CT | school | 900150 | 50011 | Barkhamsted School District | 90015000015 | 50111 | Barkhamsted Elementary School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 169 | * | * | 0 | * | 0 | 8 | 88 | 95 | 0 | 38 | 183 | 169 | 0 | 0 | 8 | 88 | 95 | 0 | 38 | 183 | ||||||||||||||||||||||||||||||||
2777751 | 2777751 | CT | school | 900150 | 50011 | Barkhamsted School District | 90015000015 | 50111 | Barkhamsted Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 183 | * | * | 0 | * | 0 | 9 | 94 | 103 | 0 | 48 | 197 | 183 | 0 | 0 | 9 | 94 | 103 | 0 | 48 | 197 | ||||||||||||||||||||||||||||||||
2451724 | 2451724 | CT | school | 50011 | Barkhamsted School District | 90015001373 | 58011 | Shared Services Integrated Preschool | Program | 2019 | pk_12_total | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 8 | 0 | 8 | 17 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 8 | 0 | 8 | 17 | |||||||||||||||||||||||||||||||||||
2757304 | 2757304 | CT | school | 50011 | Barkhamsted School District | 90015001373 | 58011 | Shared Services Integrated Preschool | Program | 2021 | pk_12_total | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 7 | 0 | 6 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 7 | 0 | 6 | 13 |
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]);