enrollments
Data source: Big Local News · About: Big Local
3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by hispanic_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1367964 | 1367964 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000730 | 1490003 | John Breen School | Regular School | No | Elementary | PK | KG | 2020 | pre_kindergarten | 12 | 4 | 164 | 0 | 3 | 0 | 1 | 95 | 89 | * | 184.0 | 12 | 4 | 164 | 0 | 3 | 0 | 1 | 95 | 89 | 184 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1129094 | 1129094 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001794 | 2810010 | Edward P. Boland School | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 14 | 7 | 158 | 0 | 1 | 0 | 5 | 108 | 77 | 185 | 14 | 7 | 158 | 0 | 1 | 0 | 5 | 108 | 77 | 185 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1370779 | 1370779 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001794 | 2810010 | Edward P. Boland School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 15 | 15 | 156 | 1 | 2 | 1 | 0 | 111 | 79 | * | 190.0 | 15 | 15 | 156 | 1 | 2 | 1 | 0 | 111 | 79 | 190 | ||||||||||||||||||||||||||||||||
741744 | 741744 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001794 | 2810010 | Edward P. Boland School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 16 | 13 | 151 | 0 | 3 | 0 | 3 | 108 | 78 | 186 | 16 | 13 | 151 | 0 | 3 | 0 | 3 | 108 | 78 | 186 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
938550 | 938550 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001794 | 2810010 | Edward P. Boland School | Regular School | No | 1 | PK | 05 | 2016 | pre_kindergarten | 19 | 14 | 148 | 0 | 1 | 0 | 3 | 113 | 72 | 185 | 19 | 14 | 148 | 0 | 1 | 0 | 3 | 113 | 72 | 185 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1367961 | 1367961 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002651 | 1490001 | Rollins Early Childhood Center | Regular School | No | Elementary | PK | KG | 2020 | pre_kindergarten | 5 | 1 | 124 | 0 | 0 | 0 | 0 | 76 | 54 | * | 130.0 | 5 | 1 | 124 | 0 | 0 | 0 | 0 | 76 | 54 | 130 | ||||||||||||||||||||||||||||||||
1678035 | 1678035 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001794 | 2810010 | Springfield - Edward P. Boland School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 12 | 9 | 122 | 0 | 0 | 0 | 4 | 85 | 62 | * | 147.0 | 12 | 9 | 122 | 0 | 0 | 0 | 4 | 85 | 62 | 147 | ||||||||||||||||||||||||||||||||
2235906 | 2235906 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002853 | 2810001 | Springfield: Early Childhood Education Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 15 | 34 | 117 | 1 | 0 | 0 | 3 | 110 | 60 | 170.0 | 15 | 34 | 117 | 1 | 0 | 0 | 3 | 110 | 60 | 170 | |||||||||||||||||||||||||||||||||
1370845 | 1370845 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001817 | 2810060 | Margaret C Ells | Regular School | No | Elementary | PK | KG | 2020 | pre_kindergarten | 23 | 37 | 116 | 1 | 3 | 0 | 7 | 98 | 89 | * | 187.0 | 23 | 37 | 116 | 1 | 3 | 0 | 7 | 98 | 89 | 187 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1675209 | 1675209 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000730 | 1490003 | Lawrence - John Breen School | Regular School | No | Elementary | PK | KG | 2021 | pre_kindergarten | 6 | 3 | 106 | 0 | 1 | 0 | 0 | 63 | 53 | * | 116.0 | 6 | 3 | 106 | 0 | 1 | 0 | 0 | 63 | 53 | 116 | ||||||||||||||||||||||||||||||||
2232573 | 2232573 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002651 | 1490001 | Lawrence: Rollins Early Childhood Center | Regular School | No | Elementary | PK | KG | 2018 | pre_kindergarten | 5 | 1 | 106 | 0 | 0 | 0 | 0 | 69 | 43 | 112.0 | 5 | 1 | 106 | 0 | 0 | 0 | 0 | 69 | 43 | 112 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1125756 | 1125756 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002651 | 1490001 | Rollins Early Childhood Center | Regular School | No | Elementary | PK | KG | 2017 | pre_kindergarten | 7 | 5 | 103 | 0 | 2 | 0 | 0 | 78 | 39 | 117 | 7 | 5 | 103 | 0 | 2 | 0 | 0 | 78 | 39 | 117 | |||||||||||||||||||||||||||||||||
2045848 | 2045848 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002853 | 2810001 | Early Childhood Education Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 15 | 26 | 103 | 2 | 4 | 0 | 5 | 105 | 50 | 155.0 | 15 | 26 | 103 | 2 | 4 | 0 | 5 | 105 | 50 | 155 | |||||||||||||||||||||||||||||||||
935769 | 935769 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000958 | 1490020 | James F Hennessey | Regular School | No | 1 | PK | 02 | 2016 | pre_kindergarten | 4 | 2 | 101 | 0 | 0 | 0 | 0 | 74 | 33 | 107 | 4 | 2 | 101 | 0 | 0 | 0 | 0 | 74 | 33 | 107 | |||||||||||||||||||||||||||||||||
1367807 | 1367807 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000910 | 1370025 | Morgan Full Service Community School | Regular School | No | Elementary | PK | 04 | 2020 | pre_kindergarten | 9 | 4 | 100 | 0 | 1 | 0 | 6 | 69 | 51 | * | 120.0 | 9 | 4 | 100 | 0 | 1 | 0 | 6 | 69 | 51 | 120 | ||||||||||||||||||||||||||||||||
1370772 | 1370772 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002853 | 2810001 | Early Childhood Education Center | Regular School | No | Elementary | PK | KG | 2020 | pre_kindergarten | 20 | 23 | 100 | 1 | 5 | 0 | 4 | 89 | 64 | * | 153.0 | 20 | 23 | 100 | 1 | 5 | 0 | 4 | 89 | 64 | 153 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
741942 | 741942 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001822 | 2810195 | German Gerena Community School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 6 | 32 | 97 | 0 | 2 | 0 | 2 | 61 | 78 | 139 | 6 | 32 | 97 | 0 | 2 | 0 | 2 | 61 | 78 | 139 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1125540 | 1125540 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627001178 | 1370003 | Joseph Metcalf School | Regular School | No | Elementary | PK | 02 | 2017 | pre_kindergarten | 40 | 7 | 96 | 0 | 2 | 1 | 3 | 93 | 56 | 149 | 40 | 7 | 96 | 0 | 2 | 1 | 3 | 93 | 56 | 149 | |||||||||||||||||||||||||||||||||
741802 | 741802 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000341 | 2810055 | Rebecca M Johnson | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 9 | 28 | 95 | 0 | 1 | 0 | 1 | 78 | 56 | 134 | 9 | 28 | 95 | 0 | 1 | 0 | 1 | 78 | 56 | 134 | |||||||||||||||||||||||||||||||||
2235980 | 2235980 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000341 | 2810055 | Springfield: Rebecca M Johnson | Regular School | No | Elementary | PK | 05 | 2018 | pre_kindergarten | 12 | 32 | 95 | 0 | 0 | 0 | 3 | 79 | 63 | 142.0 | 12 | 32 | 95 | 0 | 0 | 0 | 3 | 79 | 63 | 142 | |||||||||||||||||||||||||||||||||
1129087 | 1129087 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002853 | 2810001 | Early Childhood Education Center | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 16 | 28 | 94 | 0 | 2 | 0 | 4 | 92 | 52 | 144 | 16 | 28 | 94 | 0 | 2 | 0 | 4 | 92 | 52 | 144 | |||||||||||||||||||||||||||||||||
2043044 | 2043044 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002651 | 1490001 | Rollins Early Childhood Center | Regular School | No | Elementary | PK | KG | 2019 | pre_kindergarten | 7 | 2 | 93 | 0 | 1 | 0 | 0 | 60 | 43 | 103.0 | 7 | 2 | 93 | 0 | 1 | 0 | 0 | 60 | 43 | 103 | |||||||||||||||||||||||||||||||||
935553 | 935553 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627001178 | 1370003 | Joseph Metcalf School | Regular School | No | 1 | PK | 01 | 2016 | pre_kindergarten | 44 | 7 | 92 | 0 | 2 | 1 | 0 | 88 | 58 | 146 | 44 | 7 | 92 | 0 | 2 | 1 | 0 | 88 | 58 | 146 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2235988 | 2235988 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001817 | 2810060 | Springfield: Margaret C Ells | Regular School | No | Elementary | PK | 01 | 2018 | pre_kindergarten | 15 | 41 | 92 | 1 | 4 | 0 | 4 | 91 | 66 | 157.0 | 15 | 41 | 92 | 1 | 4 | 0 | 4 | 91 | 66 | 157 | |||||||||||||||||||||||||||||||||
1678101 | 1678101 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001817 | 2810060 | Springfield - Margaret C Ells | Regular School | No | Elementary | PK | KG | 2021 | pre_kindergarten | 11 | 24 | 91 | 1 | 2 | 0 | 6 | 83 | 52 | * | 135.0 | 11 | 24 | 91 | 1 | 2 | 0 | 6 | 83 | 52 | 135 | ||||||||||||||||||||||||||||||||
738921 | 738921 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000958 | 1490020 | James F Hennessey | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 5 | 1 | 90 | 0 | 0 | 0 | 1 | 59 | 38 | 97 | 5 | 1 | 90 | 0 | 0 | 0 | 1 | 59 | 38 | 97 | |||||||||||||||||||||||||||||||||
938748 | 938748 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001822 | 2810195 | German Gerena Community School | Regular School | No | 1 | PK | 05 | 2016 | pre_kindergarten | 6 | 39 | 87 | 0 | 1 | 0 | 2 | 69 | 66 | 135 | 6 | 39 | 87 | 0 | 1 | 0 | 2 | 69 | 66 | 135 | |||||||||||||||||||||||||||||||||
1367993 | 1367993 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000958 | 1490020 | James F Hennessey | Regular School | No | Elementary | PK | 02 | 2020 | pre_kindergarten | 1 | 0 | 87 | 0 | 0 | 0 | 0 | 52 | 35 | * | 88.0 | 1 | 0 | 87 | 0 | 0 | 0 | 0 | 52 | 35 | 88 | ||||||||||||||||||||||||||||||||
2043076 | 2043076 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000958 | 1490020 | James F Hennessey | Regular School | No | Elementary | PK | 02 | 2019 | pre_kindergarten | 0 | 0 | 87 | 0 | 0 | 0 | 0 | 58 | 29 | 87.0 | 0 | 0 | 87 | 0 | 0 | 0 | 0 | 58 | 29 | 87 | |||||||||||||||||||||||||||||||||
2232614 | 2232614 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000958 | 1490020 | Lawrence: James F Hennessey | Regular School | No | Elementary | PK | 02 | 2018 | pre_kindergarten | 5 | 0 | 87 | 0 | 1 | 0 | 0 | 53 | 40 | 93.0 | 5 | 0 | 87 | 0 | 1 | 0 | 0 | 53 | 40 | 93 | |||||||||||||||||||||||||||||||||
1129161 | 1129161 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000341 | 2810055 | Rebecca M Johnson | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 9 | 47 | 86 | 0 | 1 | 0 | 1 | 71 | 73 | 144 | 9 | 47 | 86 | 0 | 1 | 0 | 1 | 71 | 73 | 144 | |||||||||||||||||||||||||||||||||
1129323 | 1129323 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001822 | 2810195 | German Gerena Community School | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 8 | 37 | 86 | 0 | 0 | 0 | 2 | 61 | 72 | 133 | 8 | 37 | 86 | 0 | 0 | 0 | 2 | 61 | 72 | 133 | |||||||||||||||||||||||||||||||||
940491 | 940491 | MA | Essex | school | 2500032 | 454 | Lawrence Family Development Charter (District) | 250003200553 | 4540205 | Lawrence Family Development Charter School | Regular School | Yes | 1 | PK | 08 | 2016 | pre_kindergarten | 0 | 0 | 85 | 0 | 0 | 0 | 0 | 38 | 47 | 85 | 0 | 0 | 85 | 0 | 0 | 0 | 0 | 38 | 47 | 85 | |||||||||||||||||||||||||||||||||
2045918 | 2045918 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001817 | 2810060 | Margaret C Ells | Regular School | No | Elementary | PK | 01 | 2019 | pre_kindergarten | 24 | 35 | 85 | 3 | 4 | 0 | 4 | 86 | 69 | 155.0 | 24 | 35 | 85 | 3 | 4 | 0 | 4 | 86 | 69 | 155 | |||||||||||||||||||||||||||||||||
1675206 | 1675206 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002651 | 1490001 | Lawrence - Rollins Early Childhood Center | Regular School | No | Elementary | PK | KG | 2021 | pre_kindergarten | 3 | 2 | 84 | 0 | 1 | 0 | 1 | 56 | 35 | * | 91.0 | 3 | 2 | 84 | 0 | 1 | 0 | 1 | 56 | 35 | 91 | ||||||||||||||||||||||||||||||||
2047795 | 2047795 | MA | Essex | school | 2500032 | 454 | Lawrence Family Development Charter (District) | 250003200553 | 4540205 | Lawrence Family Development Charter School | Regular School | Yes | Elementary | PK | 08 | 2019 | pre_kindergarten | 2 | 0 | 83 | 0 | 0 | 0 | 0 | 30 | 55 | 85.0 | 2 | 0 | 83 | 0 | 0 | 0 | 0 | 30 | 55 | 85 | |||||||||||||||||||||||||||||||||
1125797 | 1125797 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000958 | 1490020 | James F Hennessey | Regular School | No | Elementary | PK | 02 | 2017 | pre_kindergarten | 10 | 0 | 82 | 0 | 2 | 0 | 0 | 62 | 32 | 94 | 10 | 0 | 82 | 0 | 2 | 0 | 0 | 62 | 32 | 94 | |||||||||||||||||||||||||||||||||
1370839 | 1370839 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000341 | 2810055 | Rebecca M Johnson | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 14 | 29 | 82 | 0 | 0 | 0 | 1 | 73 | 53 | * | 126.0 | 14 | 29 | 82 | 0 | 0 | 0 | 1 | 73 | 53 | 126 | ||||||||||||||||||||||||||||||||
2238231 | 2238231 | MA | Essex | school | 2500032 | 454 | Lawrence Family Development Charter (District) | 250003200553 | 4540205 | Lawrence Family Development Charter (District): Lawrence Family Development Charter School | Regular School | Yes | Elementary | PK | 08 | 2018 | pre_kindergarten | 1 | 1 | 82 | 0 | 0 | 0 | 0 | 38 | 46 | 84.0 | 1 | 1 | 82 | 0 | 0 | 0 | 0 | 38 | 46 | 84 | |||||||||||||||||||||||||||||||||
938608 | 938608 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000341 | 2810055 | Rebecca M Johnson | Regular School | No | 1 | PK | 05 | 2016 | pre_kindergarten | 6 | 40 | 81 | 0 | 1 | 0 | 3 | 74 | 57 | 131 | 6 | 40 | 81 | 0 | 1 | 0 | 3 | 74 | 57 | 131 | |||||||||||||||||||||||||||||||||
1372725 | 1372725 | MA | Essex | school | 2500032 | 454 | Lawrence Family Development Charter (District) | 250003200553 | 4540205 | Lawrence Family Development Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | pre_kindergarten | 0 | 0 | 81 | 0 | 1 | 0 | 0 | 34 | 48 | * | 82.0 | 0 | 0 | 81 | 0 | 1 | 0 | 0 | 34 | 48 | 82 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2236142 | 2236142 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001822 | 2810195 | Springfield: German Gerena Community School | Regular School | No | Elementary | PK | 05 | 2018 | pre_kindergarten | 7 | 30 | 81 | 0 | 1 | 0 | 6 | 54 | 71 | 125.0 | 7 | 30 | 81 | 0 | 1 | 0 | 6 | 54 | 71 | 125 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1131399 | 1131399 | MA | Essex | school | 2500032 | 454 | Lawrence Family Development Charter (District) | 250003200553 | 4540205 | Lawrence Family Development Charter School | Regular School | Yes | Elementary | PK | 08 | 2017 | pre_kindergarten | 4 | 1 | 80 | 0 | 0 | 0 | 0 | 40 | 45 | 85 | 4 | 1 | 80 | 0 | 0 | 0 | 0 | 40 | 45 | 85 | |||||||||||||||||||||||||||||||||
2045911 | 2045911 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000341 | 2810055 | Rebecca M Johnson | Regular School | No | Elementary | PK | 05 | 2019 | pre_kindergarten | 9 | 28 | 80 | 0 | 0 | 0 | 3 | 66 | 54 | 120.0 | 9 | 28 | 80 | 0 | 0 | 0 | 3 | 66 | 54 | 120 | |||||||||||||||||||||||||||||||||
2046053 | 2046053 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001822 | 2810195 | German Gerena Community School | Regular School | No | Elementary | PK | 05 | 2019 | pre_kindergarten | 7 | 15 | 80 | 1 | 1 | 0 | 6 | 43 | 67 | 110.0 | 7 | 15 | 80 | 1 | 1 | 0 | 6 | 43 | 67 | 110 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
738888 | 738888 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002651 | 1490001 | Rollins Early Childhood Center | Regular School | No | 1 | PK | KG | 2015 | pre_kindergarten | 16 | 1 | 76 | 0 | 0 | 0 | 0 | 49 | 44 | 93 | 16 | 1 | 76 | 0 | 0 | 0 | 0 | 49 | 44 | 93 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1675238 | 1675238 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000958 | 1490020 | Lawrence - James F Hennessey | Regular School | No | Elementary | PK | 02 | 2021 | pre_kindergarten | 2 | 1 | 76 | 0 | 1 | 0 | 0 | 47 | 33 | * | 80.0 | 2 | 1 | 76 | 0 | 1 | 0 | 0 | 47 | 33 | 80 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
935737 | 935737 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002651 | 1490001 | Rollins Early Childhood Center | Regular School | No | 1 | PK | KG | 2016 | pre_kindergarten | 11 | 4 | 74 | 0 | 1 | 0 | 0 | 60 | 30 | 90 | 11 | 4 | 74 | 0 | 1 | 0 | 0 | 60 | 30 | 90 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1370979 | 1370979 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001822 | 2810195 | German Gerena Community School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 7 | 22 | 72 | 3 | 0 | 0 | 3 | 53 | 54 | * | 107.0 | 7 | 22 | 72 | 3 | 0 | 0 | 3 | 53 | 54 | 107 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1125776 | 1125776 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002815 | 1490011 | Lawrence Family Public Academy | Regular School | No | Elementary | PK | KG | 2017 | pre_kindergarten | 5 | 0 | 71 | 0 | 0 | 0 | 0 | 44 | 32 | 76 | 5 | 0 | 71 | 0 | 0 | 0 | 0 | 44 | 32 | 76 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1678028 | 1678028 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002853 | 2810001 | Springfield - Early Childhood Education Center | Regular School | No | Elementary | PK | KG | 2021 | pre_kindergarten | 14 | 18 | 69 | 0 | 2 | 0 | 6 | 59 | 50 | * | 109.0 | 14 | 18 | 69 | 0 | 2 | 0 | 6 | 59 | 50 | 109 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1370799 | 1370799 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000896 | 2810023 | Milton Bradley School | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 3 | 11 | 68 | 0 | 0 | 0 | 0 | 49 | 33 | * | 82.0 | 3 | 11 | 68 | 0 | 0 | 0 | 0 | 49 | 33 | 82 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1367028 | 1367028 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002804 | 930003 | Adams School | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 26 | 23 | 67 | 0 | 10 | 0 | 1 | 65 | 62 | * | 127.0 | 26 | 23 | 67 | 0 | 10 | 0 | 1 | 65 | 62 | 127 | ||||||||||||||||||||||||||||||||
1367976 | 1367976 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002815 | 1490011 | Lawrence Family Public Academy | Regular School | No | Elementary | PK | KG | 2020 | pre_kindergarten | 2 | 1 | 67 | 0 | 1 | 0 | 0 | 37 | 34 | * | 71.0 | 2 | 1 | 67 | 0 | 1 | 0 | 0 | 37 | 34 | 71 | ||||||||||||||||||||||||||||||||
1674256 | 1674256 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002900 | 930001 | Everett - Webster Extension | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 30 | 25 | 66 | 1 | 18 | 0 | 2 | 80 | 62 | * | 142.0 | 30 | 25 | 66 | 1 | 18 | 0 | 2 | 80 | 62 | 142 | ||||||||||||||||||||||||||||||||
1674920 | 1674920 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000056 | 1280045 | Haverhill - Moody | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 92 | 21 | 66 | 0 | 2 | 0 | 1 | 120 | 62 | * | 182.0 | 92 | 21 | 66 | 0 | 2 | 0 | 1 | 120 | 62 | 182 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
740179 | 740179 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001326 | 2010063 | Alfred J Gomes | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 69 | 10 | 64 | 0 | 1 | 0 | 8 | 88 | 64 | 152 | 69 | 10 | 64 | 0 | 1 | 0 | 8 | 88 | 64 | 152 |
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]);