enrollments
Data source: Big Local News · About: Big Local
3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by total_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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
743099 | 743099 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002684 | 3480002 | Head Start | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 173 | 122 | 284 | 0 | 25 | 0 | 2 | 283 | 323 | 606 | 173 | 122 | 284 | 0 | 25 | 0 | 2 | 283 | 323 | 606 | |||||||||||||||||||||||||||||||||
939908 | 939908 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002684 | 3480002 | Head Start | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 105 | 108 | 332 | 3 | 19 | 1 | 3 | 294 | 277 | 571 | 105 | 108 | 332 | 3 | 19 | 1 | 3 | 294 | 277 | 571 | |||||||||||||||||||||||||||||||||
1130731 | 1130731 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002684 | 3480002 | Head Start | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 98 | 103 | 330 | 2 | 18 | 2 | 7 | 280 | 280 | 560 | 98 | 103 | 330 | 2 | 18 | 2 | 7 | 280 | 280 | 560 | |||||||||||||||||||||||||||||||||
2047196 | 2047196 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002684 | 3480002 | Head Start | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 311 | 107 | 99 | 4 | 9 | 0 | 21 | 261 | 290 | 551.0 | 311 | 107 | 99 | 4 | 9 | 0 | 21 | 261 | 290 | 551 | |||||||||||||||||||||||||||||||||
2237559 | 2237559 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002684 | 3480002 | Worcester: Head Start | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 104 | 107 | 290 | 0 | 12 | 0 | 16 | 254 | 275 | 529.0 | 104 | 107 | 290 | 0 | 12 | 0 | 16 | 254 | 275 | 529 | |||||||||||||||||||||||||||||||||
1372123 | 1372123 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002684 | 3480002 | Head Start | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 253 | 86 | 23 | 3 | 13 | 0 | 15 | 191 | 202 | * | 393.0 | 253 | 86 | 23 | 3 | 13 | 0 | 15 | 191 | 202 | 393 | ||||||||||||||||||||||||||||||||
2236462 | 2236462 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152000133 | 2930005 | Taunton: Edward F. Leddy Preschool | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 225 | 40 | 46 | 0 | 10 | 0 | 17 | 193 | 145 | 338.0 | 225 | 40 | 46 | 0 | 10 | 0 | 17 | 193 | 145 | 338 | |||||||||||||||||||||||||||||||||
1368671 | 1368671 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717002046 | 1650049 | Malden Early Learning Center | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 118 | 36 | 32 | 0 | 128 | 0 | 16 | 195 | 135 | * | 330.0 | 118 | 36 | 32 | 0 | 128 | 0 | 16 | 195 | 135 | 330 | ||||||||||||||||||||||||||||||||
1129645 | 1129645 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152000133 | 2930005 | Edward F. Leddy Preschool | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 231 | 39 | 39 | 0 | 8 | 1 | 11 | 188 | 141 | 329 | 231 | 39 | 39 | 0 | 8 | 1 | 11 | 188 | 141 | 329 | |||||||||||||||||||||||||||||||||
2231446 | 2231446 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002118 | 930015 | Everett: Webster School | Regular School | No | Elementary | PK | 05 | 2018 | pre_kindergarten | 87 | 61 | 150 | 1 | 24 | 0 | 4 | 171 | 156 | 327.0 | 87 | 61 | 150 | 1 | 24 | 0 | 4 | 171 | 156 | 327 | |||||||||||||||||||||||||||||||||
2042110 | 2042110 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002118 | 930015 | Webster School | Regular School | No | Elementary | PK | 05 | 2019 | pre_kindergarten | 71 | 62 | 157 | 1 | 26 | 1 | 2 | 159 | 161 | 320.0 | 71 | 62 | 157 | 1 | 26 | 1 | 2 | 159 | 161 | 320 | |||||||||||||||||||||||||||||||||
1679385 | 1679385 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002684 | 3480002 | Worcester - Head Start | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 155 | 106 | 22 | 9 | 14 | 0 | 13 | 157 | 162 | * | 319.0 | 155 | 106 | 22 | 9 | 14 | 0 | 13 | 157 | 162 | 319 | ||||||||||||||||||||||||||||||||
2043737 | 2043737 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717002046 | 1650049 | Malden Early Learning Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 112 | 50 | 25 | 0 | 115 | 0 | 17 | 194 | 125 | 319.0 | 112 | 50 | 25 | 0 | 115 | 0 | 17 | 194 | 125 | 319 | |||||||||||||||||||||||||||||||||
2233685 | 2233685 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762001800 | 1780003 | Melrose: Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 261 | 6 | 13 | 0 | 14 | 0 | 24 | 165 | 153 | 318.0 | 261 | 6 | 13 | 0 | 14 | 0 | 24 | 165 | 153 | 318 | |||||||||||||||||||||||||||||||||
739596 | 739596 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717002046 | 1650049 | Malden Early Learning Center | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 138 | 57 | 18 | 0 | 93 | 2 | 9 | 175 | 142 | 317 | 138 | 57 | 18 | 0 | 93 | 2 | 9 | 175 | 142 | 317 | |||||||||||||||||||||||||||||||||
934812 | 934812 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002118 | 930015 | Webster School | Regular School | No | 1 | PK | 04 | 2016 | pre_kindergarten | 110 | 65 | 111 | 1 | 22 | 1 | 4 | 179 | 135 | 314 | 110 | 65 | 111 | 1 | 22 | 1 | 4 | 179 | 135 | 314 | |||||||||||||||||||||||||||||||||
2233402 | 2233402 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717002046 | 1650049 | Malden: Malden Early Learning Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 110 | 47 | 21 | 0 | 119 | 0 | 17 | 187 | 127 | 314.0 | 110 | 47 | 21 | 0 | 119 | 0 | 17 | 187 | 127 | 314 | |||||||||||||||||||||||||||||||||
739832 | 739832 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762001800 | 1780003 | Early Childhood Center | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 272 | 9 | 4 | 0 | 11 | 0 | 17 | 170 | 143 | 313 | 272 | 9 | 4 | 0 | 11 | 0 | 17 | 170 | 143 | 313 | |||||||||||||||||||||||||||||||||
1367324 | 1367324 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498002820 | 1000001 | Juniper Hill School | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 176 | 18 | 75 | 1 | 30 | 1 | 8 | 197 | 112 | * | 309.0 | 176 | 18 | 75 | 1 | 30 | 1 | 8 | 197 | 112 | 309 | ||||||||||||||||||||||||||||||||
1126581 | 1126581 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717002046 | 1650049 | Malden Early Learning Center | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 107 | 42 | 22 | 0 | 112 | 0 | 16 | 166 | 133 | 299 | 107 | 42 | 22 | 0 | 112 | 0 | 16 | 166 | 133 | 299 | |||||||||||||||||||||||||||||||||
936677 | 936677 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762001800 | 1780003 | Early Childhood Center | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 244 | 8 | 7 | 0 | 13 | 0 | 21 | 150 | 143 | 293 | 244 | 8 | 7 | 0 | 13 | 0 | 21 | 150 | 143 | 293 | |||||||||||||||||||||||||||||||||
737960 | 737960 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002118 | 930015 | Webster School | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 108 | 52 | 105 | 2 | 19 | 0 | 5 | 173 | 118 | 291 | 108 | 52 | 105 | 2 | 19 | 0 | 5 | 173 | 118 | 291 | |||||||||||||||||||||||||||||||||
1126868 | 1126868 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762001800 | 1780003 | Early Childhood Center | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 244 | 6 | 4 | 0 | 11 | 0 | 25 | 153 | 137 | 290 | 244 | 6 | 4 | 0 | 11 | 0 | 25 | 153 | 137 | 290 | |||||||||||||||||||||||||||||||||
1366570 | 1366570 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000235 | 570003 | Shurtleff Early Childhood | Regular School | No | Elementary | PK | 01 | 2020 | pre_kindergarten | 27 | 18 | 239 | 0 | 0 | 0 | 6 | 151 | 139 | * | 290.0 | 27 | 18 | 239 | 0 | 0 | 0 | 6 | 151 | 139 | 290 | ||||||||||||||||||||||||||||||||
2043969 | 2043969 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762001800 | 1780003 | Early Childhood Center | Regular School | No | Elementary | PK | KG | 2019 | pre_kindergarten | 237 | 6 | 13 | 0 | 14 | 0 | 20 | 148 | 142 | 290.0 | 237 | 6 | 13 | 0 | 14 | 0 | 20 | 148 | 142 | 290 | |||||||||||||||||||||||||||||||||
1124629 | 1124629 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002118 | 930015 | Webster School | Regular School | No | Elementary | PK | 04 | 2017 | pre_kindergarten | 93 | 58 | 109 | 0 | 24 | 0 | 5 | 155 | 134 | 289 | 93 | 58 | 109 | 0 | 24 | 0 | 5 | 155 | 134 | 289 | |||||||||||||||||||||||||||||||||
936441 | 936441 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717002046 | 1650049 | Malden Early Learning Center | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 105 | 47 | 15 | 0 | 101 | 0 | 20 | 166 | 122 | 288 | 105 | 47 | 15 | 0 | 101 | 0 | 20 | 166 | 122 | 288 | |||||||||||||||||||||||||||||||||
2046328 | 2046328 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152000133 | 2930005 | Edward F. Leddy Preschool | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 189 | 35 | 41 | 0 | 8 | 0 | 9 | 171 | 111 | 282.0 | 189 | 35 | 41 | 0 | 8 | 0 | 9 | 171 | 111 | 282 | |||||||||||||||||||||||||||||||||
1124119 | 1124119 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366002571 | 610001 | Szetela Early Childhood Center | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 175 | 13 | 69 | 0 | 13 | 0 | 11 | 169 | 112 | 281 | 175 | 13 | 69 | 0 | 13 | 0 | 11 | 169 | 112 | 281 | |||||||||||||||||||||||||||||||||
1368899 | 1368899 | MA | Middlesex | school | 2507620 | 178 | Melrose | 250762001800 | 1780003 | Early Childhood Center | Regular School | No | Elementary | PK | KG | 2020 | pre_kindergarten | 222 | 10 | 11 | 0 | 20 | 0 | 18 | 152 | 129 | * | 281.0 | 222 | 10 | 11 | 0 | 20 | 0 | 18 | 152 | 129 | 281 | ||||||||||||||||||||||||||||||||
939012 | 939012 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152000133 | 2930005 | Edward F. Leddy Preschool | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 200 | 31 | 28 | 0 | 4 | 2 | 13 | 150 | 128 | 278 | 200 | 31 | 28 | 0 | 4 | 2 | 13 | 150 | 128 | 278 | |||||||||||||||||||||||||||||||||
1371252 | 1371252 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152000133 | 2930005 | Edward F. Leddy Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 190 | 37 | 31 | 0 | 6 | 0 | 14 | 161 | 117 | * | 278.0 | 190 | 37 | 31 | 0 | 6 | 0 | 14 | 161 | 117 | 278 | ||||||||||||||||||||||||||||||||
934351 | 934351 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000235 | 570003 | Shurtleff Early Childhood | Regular School | No | 1 | PK | KG | 2016 | pre_kindergarten | 21 | 17 | 235 | 1 | 1 | 0 | 1 | 143 | 133 | 276 | 21 | 17 | 235 | 1 | 1 | 0 | 1 | 143 | 133 | 276 | |||||||||||||||||||||||||||||||||
2042396 | 2042396 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498002820 | 1000001 | Juniper Hill School | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 145 | 17 | 69 | 0 | 32 | 1 | 12 | 159 | 117 | 276.0 | 145 | 17 | 69 | 0 | 32 | 1 | 12 | 159 | 117 | 276 | |||||||||||||||||||||||||||||||||
2230891 | 2230891 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000235 | 570003 | Chelsea: Shurtleff Early Childhood | Regular School | No | Elementary | PK | 01 | 2018 | pre_kindergarten | 29 | 8 | 236 | 0 | 0 | 0 | 2 | 151 | 124 | 275.0 | 29 | 8 | 236 | 0 | 0 | 0 | 2 | 151 | 124 | 275 | |||||||||||||||||||||||||||||||||
2231786 | 2231786 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498002820 | 1000001 | Framingham: Juniper Hill School | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 136 | 19 | 70 | 0 | 30 | 1 | 17 | 143 | 130 | 273.0 | 136 | 19 | 70 | 0 | 30 | 1 | 17 | 143 | 130 | 273 | |||||||||||||||||||||||||||||||||
1124076 | 1124076 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000235 | 570003 | Shurtleff Early Childhood | Regular School | No | Elementary | PK | 01 | 2017 | pre_kindergarten | 16 | 18 | 228 | 0 | 2 | 0 | 5 | 140 | 129 | 269 | 16 | 18 | 228 | 0 | 2 | 0 | 5 | 140 | 129 | 269 | |||||||||||||||||||||||||||||||||
742203 | 742203 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152000133 | 2930005 | Edward F. Leddy Preschool | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 199 | 29 | 20 | 0 | 2 | 1 | 16 | 161 | 106 | 267 | 199 | 29 | 20 | 0 | 2 | 1 | 16 | 161 | 106 | 267 | |||||||||||||||||||||||||||||||||
934385 | 934385 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366002571 | 610001 | Szetela Early Childhood Center | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 200 | 5 | 50 | 0 | 9 | 0 | 3 | 164 | 103 | 267 | 200 | 5 | 50 | 0 | 9 | 0 | 3 | 164 | 103 | 267 | |||||||||||||||||||||||||||||||||
1123632 | 1123632 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000221 | 440050 | Gilmore School Early Childhood Center | Regular School | No | Elementary | PK | KG | 2017 | pre_kindergarten | 74 | 152 | 22 | 1 | 4 | 0 | 10 | 164 | 99 | 263 | 74 | 152 | 22 | 1 | 4 | 0 | 10 | 164 | 99 | 263 | |||||||||||||||||||||||||||||||||
933973 | 933973 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000221 | 440050 | Gilmore School Early Childhood Center | Regular School | No | 1 | PK | KG | 2016 | pre_kindergarten | 85 | 122 | 33 | 3 | 3 | 0 | 15 | 161 | 100 | 261 | 85 | 122 | 33 | 3 | 3 | 0 | 15 | 161 | 100 | 261 | |||||||||||||||||||||||||||||||||
935090 | 935090 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498002820 | 1000001 | Juniper Hill School | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 148 | 17 | 55 | 1 | 21 | 0 | 17 | 137 | 122 | 259 | 148 | 17 | 55 | 1 | 21 | 0 | 17 | 137 | 122 | 259 | |||||||||||||||||||||||||||||||||
737491 | 737491 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000235 | 570003 | Shurtleff Early Childhood | Regular School | No | 1 | PK | KG | 2015 | pre_kindergarten | 24 | 13 | 215 | 1 | 2 | 0 | 1 | 138 | 118 | 256 | 24 | 13 | 215 | 1 | 2 | 0 | 1 | 138 | 118 | 256 | |||||||||||||||||||||||||||||||||
737525 | 737525 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366002571 | 610001 | Szetela Early Childhood Center | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 196 | 3 | 49 | 0 | 4 | 0 | 2 | 140 | 114 | 254 | 196 | 3 | 49 | 0 | 4 | 0 | 2 | 140 | 114 | 254 | |||||||||||||||||||||||||||||||||
1366610 | 1366610 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366002571 | 610001 | Szetela Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 141 | 8 | 76 | 0 | 10 | 0 | 14 | 152 | 97 | * | 249.0 | 141 | 8 | 76 | 0 | 10 | 0 | 14 | 152 | 97 | 249 | ||||||||||||||||||||||||||||||||
2041639 | 2041639 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000235 | 570003 | Shurtleff Early Childhood | Regular School | No | Elementary | PK | 01 | 2019 | pre_kindergarten | 23 | 11 | 211 | 0 | 1 | 0 | 1 | 143 | 104 | 247.0 | 23 | 11 | 211 | 0 | 1 | 0 | 1 | 143 | 104 | 247 | |||||||||||||||||||||||||||||||||
737106 | 737106 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000221 | 440050 | Gilmore School Early Childhood Center | Regular School | No | 1 | PK | KG | 2015 | pre_kindergarten | 95 | 87 | 39 | 1 | 7 | 0 | 17 | 158 | 88 | 246 | 95 | 87 | 39 | 1 | 7 | 0 | 17 | 158 | 88 | 246 | |||||||||||||||||||||||||||||||||
2045677 | 2045677 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Parker Road Preschool | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 109 | 9 | 11 | 1 | 106 | 0 | 6 | 126 | 116 | 242.0 | 109 | 9 | 11 | 1 | 106 | 0 | 6 | 126 | 116 | 242 | |||||||||||||||||||||||||||||||||
2230934 | 2230934 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366002571 | 610001 | Chicopee: Szetela Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 153 | 11 | 58 | 0 | 4 | 0 | 15 | 144 | 97 | 241.0 | 153 | 11 | 58 | 0 | 4 | 0 | 15 | 144 | 97 | 241 | |||||||||||||||||||||||||||||||||
938374 | 938374 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Parker Road Preschool | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 116 | 4 | 18 | 3 | 89 | 0 | 9 | 124 | 115 | 239 | 116 | 4 | 18 | 3 | 89 | 0 | 9 | 124 | 115 | 239 | |||||||||||||||||||||||||||||||||
2045715 | 2045715 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002561 | 2740005 | Capuano Early Childhood Center | Regular School | No | Elementary | PK | KG | 2019 | pre_kindergarten | 108 | 15 | 68 | 0 | 21 | 0 | 26 | 139 | 99 | 238.0 | 108 | 15 | 68 | 0 | 21 | 0 | 26 | 139 | 99 | 238 | |||||||||||||||||||||||||||||||||
1366161 | 1366161 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002792 | 440008 | Barrett Russell Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 45 | 131 | 44 | 1 | 2 | 1 | 13 | 133 | 104 | * | 237.0 | 45 | 131 | 44 | 1 | 2 | 1 | 13 | 133 | 104 | 237 | ||||||||||||||||||||||||||||||||
2230416 | 2230416 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002792 | 440008 | Brockton: Barrett Russell Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 66 | 131 | 23 | 0 | 2 | 0 | 15 | 143 | 94 | 237.0 | 66 | 131 | 23 | 0 | 2 | 0 | 15 | 143 | 94 | 237 | |||||||||||||||||||||||||||||||||
741608 | 741608 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002561 | 2740005 | Capuano Early Childhood Center | Regular School | No | 1 | PK | KG | 2015 | pre_kindergarten | 104 | 24 | 79 | 0 | 19 | 0 | 9 | 122 | 113 | 235 | 104 | 24 | 79 | 0 | 19 | 0 | 9 | 122 | 113 | 235 | |||||||||||||||||||||||||||||||||
2235709 | 2235709 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Shrewsbury: Parker Road Preschool | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 101 | 8 | 19 | 2 | 95 | 0 | 10 | 118 | 117 | 235.0 | 101 | 8 | 19 | 2 | 95 | 0 | 10 | 118 | 117 | 235 | |||||||||||||||||||||||||||||||||
741569 | 741569 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Parker Road Preschool | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 113 | 5 | 13 | 2 | 90 | 0 | 11 | 126 | 108 | 234 | 113 | 5 | 13 | 2 | 90 | 0 | 11 | 126 | 108 | 234 | |||||||||||||||||||||||||||||||||
1124958 | 1124958 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498002820 | 1000001 | Juniper Hill School | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 134 | 17 | 56 | 0 | 14 | 0 | 13 | 124 | 110 | 234 | 134 | 17 | 56 | 0 | 14 | 0 | 13 | 124 | 110 | 234 | |||||||||||||||||||||||||||||||||
1128888 | 1128888 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Parker Road Preschool | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 109 | 5 | 22 | 4 | 83 | 0 | 9 | 122 | 110 | 232 | 109 | 5 | 22 | 4 | 83 | 0 | 9 | 122 | 110 | 232 | |||||||||||||||||||||||||||||||||
1128934 | 1128934 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002561 | 2740005 | Capuano Early Childhood Center | Regular School | No | Elementary | PK | KG | 2017 | pre_kindergarten | 105 | 14 | 78 | 0 | 25 | 0 | 9 | 142 | 89 | 231 | 105 | 14 | 78 | 0 | 25 | 0 | 9 | 142 | 89 | 231 | |||||||||||||||||||||||||||||||||
1370602 | 1370602 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Parker Road Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 104 | 9 | 11 | 2 | 97 | 0 | 7 | 131 | 99 | * | 230.0 | 104 | 9 | 11 | 2 | 97 | 0 | 7 | 131 | 99 | 230 | ||||||||||||||||||||||||||||||||
2041680 | 2041680 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366002571 | 610001 | Szetela Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 137 | 10 | 66 | 0 | 2 | 0 | 14 | 147 | 82 | 229.0 | 137 | 10 | 66 | 0 | 2 | 0 | 14 | 147 | 82 | 229 | |||||||||||||||||||||||||||||||||
938411 | 938411 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002561 | 2740005 | Capuano Early Childhood Center | Regular School | No | 1 | PK | KG | 2016 | pre_kindergarten | 102 | 14 | 80 | 0 | 23 | 0 | 9 | 120 | 108 | 228 | 102 | 14 | 80 | 0 | 23 | 0 | 9 | 120 | 108 | 228 | |||||||||||||||||||||||||||||||||
2235755 | 2235755 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002561 | 2740005 | Somerville: Capuano Early Childhood Center | Regular School | No | Elementary | PK | KG | 2018 | pre_kindergarten | 91 | 10 | 81 | 0 | 21 | 0 | 25 | 114 | 114 | 228.0 | 91 | 10 | 81 | 0 | 21 | 0 | 25 | 114 | 114 | 228 | |||||||||||||||||||||||||||||||||
1370640 | 1370640 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002561 | 2740005 | Capuano Early Childhood Center | Regular School | No | Elementary | PK | KG | 2020 | pre_kindergarten | 88 | 22 | 73 | 0 | 28 | 0 | 16 | 131 | 96 | * | 227.0 | 88 | 22 | 73 | 0 | 28 | 0 | 16 | 131 | 96 | 227 | ||||||||||||||||||||||||||||||||
742876 | 742876 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284000371 | 3360003 | Johnson Early Childhood Center | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 181 | 12 | 11 | 1 | 17 | 0 | 3 | 124 | 101 | 225 | 181 | 12 | 11 | 1 | 17 | 0 | 3 | 124 | 101 | 225 | |||||||||||||||||||||||||||||||||
2232225 | 2232225 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000056 | 1280045 | Haverhill: Moody | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 138 | 14 | 63 | 0 | 4 | 1 | 1 | 141 | 80 | 221.0 | 138 | 14 | 63 | 0 | 4 | 1 | 1 | 141 | 80 | 221 | |||||||||||||||||||||||||||||||||
2232578 | 2232578 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000730 | 1490003 | Lawrence: John Breen School | Regular School | No | Elementary | PK | KG | 2018 | pre_kindergarten | 10 | 6 | 195 | 0 | 7 | 0 | 1 | 123 | 96 | 219.0 | 10 | 6 | 195 | 0 | 7 | 0 | 1 | 123 | 96 | 219 | |||||||||||||||||||||||||||||||||
1675912 | 1675912 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717002046 | 1650049 | Malden - Malden Early Learning Center | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 72 | 37 | 14 | 0 | 82 | 0 | 12 | 136 | 81 | * | 217.0 | 72 | 37 | 14 | 0 | 82 | 0 | 12 | 136 | 81 | 217 | ||||||||||||||||||||||||||||||||
2044509 | 2044509 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001657 | 2070108 | Newton Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 120 | 9 | 12 | 0 | 55 | 0 | 16 | 126 | 86 | 212.0 | 120 | 9 | 12 | 0 | 55 | 0 | 16 | 126 | 86 | 212 | |||||||||||||||||||||||||||||||||
1367027 | 1367027 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002900 | 930001 | Webster Extension | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 40 | 37 | 108 | 0 | 23 | 0 | 3 | 103 | 108 | * | 211.0 | 40 | 37 | 108 | 0 | 23 | 0 | 3 | 103 | 108 | 211 | ||||||||||||||||||||||||||||||||
738891 | 738891 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000730 | 1490003 | John Breen School | Regular School | No | 1 | PK | KG | 2015 | pre_kindergarten | 19 | 4 | 180 | 0 | 6 | 0 | 0 | 119 | 90 | 209 | 19 | 4 | 180 | 0 | 6 | 0 | 0 | 119 | 90 | 209 | |||||||||||||||||||||||||||||||||
1124616 | 1124616 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002804 | 930003 | Adams School | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 62 | 34 | 92 | 0 | 17 | 0 | 4 | 120 | 89 | 209 | 62 | 34 | 92 | 0 | 17 | 0 | 4 | 120 | 89 | 209 | |||||||||||||||||||||||||||||||||
2045852 | 2045852 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001794 | 2810010 | Edward P. Boland School | Regular School | No | Elementary | PK | 05 | 2019 | pre_kindergarten | 20 | 19 | 166 | 1 | 2 | 0 | 1 | 119 | 90 | 209.0 | 20 | 19 | 166 | 1 | 2 | 0 | 1 | 119 | 90 | 209 | |||||||||||||||||||||||||||||||||
1367666 | 1367666 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000056 | 1280045 | Moody | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 114 | 22 | 65 | 1 | 5 | 0 | 0 | 128 | 79 | * | 207.0 | 114 | 22 | 65 | 1 | 5 | 0 | 0 | 128 | 79 | 207 | ||||||||||||||||||||||||||||||||
2041228 | 2041228 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002792 | 440008 | Barrett Russell Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 57 | 107 | 33 | 0 | 1 | 1 | 8 | 109 | 98 | 207.0 | 57 | 107 | 33 | 0 | 1 | 1 | 8 | 109 | 98 | 207 | |||||||||||||||||||||||||||||||||
935740 | 935740 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000730 | 1490003 | John Breen School | Regular School | No | 1 | PK | KG | 2016 | pre_kindergarten | 28 | 2 | 170 | 0 | 5 | 0 | 1 | 116 | 90 | 206 | 28 | 2 | 170 | 0 | 5 | 0 | 1 | 116 | 90 | 206 | |||||||||||||||||||||||||||||||||
1125761 | 1125761 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000730 | 1490003 | John Breen School | Regular School | No | Elementary | PK | KG | 2017 | pre_kindergarten | 15 | 2 | 174 | 0 | 12 | 0 | 1 | 112 | 92 | 204 | 15 | 2 | 174 | 0 | 12 | 0 | 1 | 112 | 92 | 204 | |||||||||||||||||||||||||||||||||
2235913 | 2235913 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001794 | 2810010 | Springfield: Edward P. Boland School | Regular School | No | Elementary | PK | 05 | 2018 | pre_kindergarten | 21 | 12 | 164 | 0 | 5 | 0 | 2 | 115 | 89 | 204.0 | 21 | 12 | 164 | 0 | 5 | 0 | 2 | 115 | 89 | 204 | |||||||||||||||||||||||||||||||||
1125409 | 1125409 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000056 | 1280045 | Moody | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 134 | 16 | 49 | 0 | 2 | 0 | 2 | 126 | 77 | 203 | 134 | 16 | 49 | 0 | 2 | 0 | 2 | 126 | 77 | 203 | |||||||||||||||||||||||||||||||||
2043047 | 2043047 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000730 | 1490003 | John Breen School | Regular School | No | Elementary | PK | KG | 2019 | pre_kindergarten | 15 | 2 | 177 | 0 | 8 | 0 | 0 | 121 | 79 | 202.0 | 15 | 2 | 177 | 0 | 8 | 0 | 0 | 121 | 79 | 202 | |||||||||||||||||||||||||||||||||
2236529 | 2236529 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158001922 | 2950001 | Tewksbury: L F Dewing | Regular School | No | Elementary | PK | 02 | 2018 | pre_kindergarten | 172 | 8 | 9 | 0 | 11 | 0 | 2 | 105 | 97 | 202.0 | 172 | 8 | 9 | 0 | 11 | 0 | 2 | 105 | 97 | 202 | |||||||||||||||||||||||||||||||||
738708 | 738708 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627001178 | 1370003 | Joseph Metcalf School | Regular School | No | 1 | PK | KG | 2015 | pre_kindergarten | 56 | 8 | 128 | 0 | 3 | 0 | 6 | 122 | 79 | 201 | 56 | 8 | 128 | 0 | 3 | 0 | 6 | 122 | 79 | 201 | |||||||||||||||||||||||||||||||||
740372 | 740372 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001657 | 2070108 | Newton Early Childhood Center | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 118 | 6 | 21 | 1 | 39 | 1 | 15 | 129 | 72 | 201 | 118 | 6 | 21 | 1 | 39 | 1 | 15 | 129 | 72 | 201 | |||||||||||||||||||||||||||||||||
939681 | 939681 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284000371 | 3360003 | Johnson Early Childhood Center | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 157 | 11 | 8 | 0 | 15 | 0 | 10 | 113 | 88 | 201 | 157 | 11 | 8 | 0 | 15 | 0 | 10 | 113 | 88 | 201 | |||||||||||||||||||||||||||||||||
2231433 | 2231433 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002804 | 930003 | Everett: Adams School | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 65 | 40 | 78 | 0 | 11 | 0 | 7 | 120 | 81 | 201.0 | 65 | 40 | 78 | 0 | 11 | 0 | 7 | 120 | 81 | 201 | |||||||||||||||||||||||||||||||||
2042749 | 2042749 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000056 | 1280045 | Moody | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 106 | 21 | 64 | 3 | 4 | 2 | 0 | 126 | 74 | 200.0 | 106 | 21 | 64 | 3 | 4 | 2 | 0 | 126 | 74 | 200 | |||||||||||||||||||||||||||||||||
935441 | 935441 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000056 | 1280045 | Moody | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 138 | 8 | 47 | 1 | 3 | 0 | 2 | 130 | 69 | 199 | 138 | 8 | 47 | 1 | 3 | 0 | 2 | 130 | 69 | 199 | |||||||||||||||||||||||||||||||||
1130453 | 1130453 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284000371 | 3360003 | Johnson Early Childhood Center | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 143 | 17 | 14 | 0 | 17 | 0 | 8 | 111 | 88 | 199 | 143 | 17 | 14 | 0 | 17 | 0 | 8 | 111 | 88 | 199 | |||||||||||||||||||||||||||||||||
1371909 | 1371909 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284000371 | 3360003 | Johnson Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 125 | 10 | 10 | 0 | 38 | 0 | 16 | 120 | 78 | * | 199.0 | 125 | 10 | 10 | 0 | 38 | 0 | 16 | 120 | 78 | 199 | ||||||||||||||||||||||||||||||||
2234317 | 2234317 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001657 | 2070108 | Newton: Newton Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 103 | 11 | 18 | 0 | 43 | 0 | 22 | 127 | 70 | 197.0 | 103 | 11 | 18 | 0 | 43 | 0 | 22 | 127 | 70 | 197 | |||||||||||||||||||||||||||||||||
2237017 | 2237017 | MA | Hampden | school | 2512630 | 325 | Westfield | 251263002452 | 3250003 | Westfield: Fort Meadow Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 130 | 1 | 45 | 0 | 17 | 0 | 3 | 119 | 77 | 196.0 | 130 | 1 | 45 | 0 | 17 | 0 | 3 | 119 | 77 | 196 | |||||||||||||||||||||||||||||||||
1674558 | 1674558 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498002820 | 1000001 | Framingham - Juniper Hill School | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 104 | 13 | 58 | 0 | 15 | 1 | 4 | 123 | 72 | * | 195.0 | 104 | 13 | 58 | 0 | 15 | 1 | 4 | 123 | 72 | 195 | ||||||||||||||||||||||||||||||||
735875 | 735875 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219001610 | 160008 | Early Learning Center | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 137 | 3 | 23 | 0 | 12 | 0 | 19 | 121 | 73 | 194 | 137 | 3 | 23 | 0 | 12 | 0 | 19 | 121 | 73 | 194 | |||||||||||||||||||||||||||||||||
934801 | 934801 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002804 | 930003 | Adams School | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 68 | 37 | 71 | 0 | 15 | 1 | 2 | 94 | 100 | 194 | 68 | 37 | 71 | 0 | 15 | 1 | 2 | 94 | 100 | 194 | |||||||||||||||||||||||||||||||||
2042100 | 2042100 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002804 | 930003 | Adams School | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 44 | 36 | 97 | 0 | 13 | 0 | 4 | 114 | 80 | 194.0 | 44 | 36 | 97 | 0 | 13 | 0 | 4 | 114 | 80 | 194 | |||||||||||||||||||||||||||||||||
2046984 | 2046984 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284000371 | 3360003 | Johnson Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 136 | 10 | 12 | 0 | 23 | 0 | 13 | 105 | 89 | 194.0 | 136 | 10 | 12 | 0 | 23 | 0 | 13 | 105 | 89 | 194 | |||||||||||||||||||||||||||||||||
1127495 | 1127495 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001657 | 2070108 | Newton Early Childhood Center | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 99 | 11 | 18 | 0 | 48 | 0 | 17 | 124 | 69 | 193 | 99 | 11 | 18 | 0 | 48 | 0 | 17 | 124 | 69 | 193 | |||||||||||||||||||||||||||||||||
2235103 | 2235103 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987002807 | 2430005 | Quincy: Amelio Della Chiesa Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 69 | 15 | 16 | 0 | 86 | 0 | 7 | 107 | 86 | 193.0 | 69 | 15 | 16 | 0 | 86 | 0 | 7 | 107 | 86 | 193 | |||||||||||||||||||||||||||||||||
2237281 | 2237281 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284000371 | 3360003 | Weymouth: Johnson Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 135 | 9 | 13 | 1 | 26 | 0 | 9 | 109 | 84 | 193.0 | 135 | 9 | 13 | 1 | 26 | 0 | 9 | 109 | 84 | 193 | |||||||||||||||||||||||||||||||||
737949 | 737949 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002804 | 930003 | Adams School | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 52 | 35 | 79 | 0 | 20 | 0 | 5 | 91 | 100 | 191 | 52 | 35 | 79 | 0 | 20 | 0 | 5 | 91 | 100 | 191 |
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]);