enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by native_hawaiian_pacific_islander_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
2042463 2042463 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 83 1 4 1   2     11   5   61 46                       107.0 83 1 4 1   2     11   5   61 46                 107
937899 937899 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2016   grade_1 37 11 11 0   51     8   3   60 61                       121 37 11 11 0   51     8   3   60 61                 121
1122370 1122370 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No Elementary KG 03 2017   kindergarten 63 1 1 0   1     8   0   40 34                       74 63 1 1 0   1     8   0   40 34                 74
1125037 1125037 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Elementary PK PK 2017   pre_kindergarten 106 2 7 0   6     8   2   82 49                       131 106 2 7 0   6     8   2   82 49                 131
1128313 1128313 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2017   grade_2 38 12 12 0   49     8   4   65 58                       123 38 12 12 0   49     8   4   65 58                 123
1676885 1676885 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_5 41 0 6 0   4     8   3   36 26 *                     62.0 41 0 6 0   4     8   3   36 26                 62
2235135 2235135 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy: Clifford H Marshall Elementary   Regular School No Elementary KG 04 2018   grade_3 32 14 15 0   48     7   2   54 64                       118.0 32 14 15 0   48     7   2   54 64                 118
1676882 1676882 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_2 21 1 5 0   5     7   4   24 19 *                     43.0 21 1 5 0   5     7   4   24 19                 43
740277 740277 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_11 226 61 151 6   2     6   31   271 212                       483 226 61 151 6   2     6   31   271 212                 483
741069 741069 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2015   kindergarten 35 8 10 0   53     6   2   57 57                       114 35 8 10 0   53     6   2   57 57                 114
1367392 1367392 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 87 2 1 0   10     6   5   67 44 *                     111.0 87 2 1 0   10     6   5   67 44                 111
1678402 1678402 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton - O'Donnell Middle School   Regular School No Middle 06 08 2021   grade_8 148 66 39 0   9     6   22   136 154 *                     290.0 148 66 39 0   9     6   22   136 154                 290
738300 738300 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No 1 PK PK 2015   pre_kindergarten 110 2 4 1   10     5   4   84 52                       136 110 2 4 1   10     5   4   84 52                 136
738421 738421 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2015   grade_9 205 2 22 0   3     5   4   118 123                       241 205 2 22 0   3     5   4   118 123                 241
935273 935273 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2016   grade_10 186 2 18 0   3     5   3   110 107                       217 186 2 18 0   3     5   3   110 107                 217
935348 935348 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_5 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1122375 1122375 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2017   kindergarten 74 2 4 0   0     5   2   47 40                       87 74 2 4 0   0     5   2   47 40                 87
1125298 1125298 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_6 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
2229182 2229182 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   grade_1 68 2 4 0   0     5   2   43 38                       81.0 68 2 4 0   0     5   2   43 38                 81
2232113 2232113 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   grade_7 39 0 3 0   0     5   1   24 24                       48.0 39 0 3 0   0     5   1   24 24                 48
2234723 2234723 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 Norwood: George F. Willett   Regular School No Elementary PK KG 2018   kindergarten 168 24 35 0   42     5   6   140 140                       280.0 168 24 35 0   42     5   6   140 140                 280
2045202 2045202 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2019   grade_4 27 12 15 0   47     5   2   48 60                       108.0 27 12 15 0   47     5   2   48 60                 108
1370180 1370180 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2020   grade_5 26 15 20 0   44     5   3   56 57 *                     113.0 26 15 20 0   44     5   3   56 57                 113
1371142 1371142 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2020   grade_7 155 63 39 0   8     5   22   135 157 *                     292.0 155 63 39 0   8     5   22   135 157                 292
1676880 1676880 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   kindergarten 25 1 1 1   2     5   2   17 20 *                     37.0 25 1 1 1   2     5   2   17 20                 37
1676881 1676881 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_1 26 0 5 0   1     5   4   22 19 *                     41.0 26 0 5 0   1     5   4   22 19                 41
1677429 1677429 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_6 17 13 21 0   40     5   4   46 54 *                     100.0 17 13 21 0   40     5   4   46 54                 100
737596 737596 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_10 247 9 86 1   12     4   9   212 156                       368 247 9 86 1   12     4   9   212 156                 368
738496 738496 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_4 35 0 0 1   1     4   1   22 20                       42 35 0 0 1   1     4   1   22 20                 42
739100 739100 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2015   grade_7 160 20 81 1   8     4   10   144 140                       284 160 20 81 1   8     4   10   144 140                 284
740275 740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
740278 740278 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_12 183 71 105 1   10     4   32   200 206                       406 183 71 105 1   10     4   32   200 206                 406
934457 934457 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2016   grade_11 248 8 86 1   9     4   7   210 153                       363 248 8 86 1   9     4   7   210 153                 363
935154 935154 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No 1 PK PK 2016   pre_kindergarten 106 1 6 0   8     4   6   79 52                       131 106 1 6 0   8     4   6   79 52                 131
935271 935271 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2016   grade_8 164 3 15 0   4     4   7   94 103                       197 164 3 15 0   4     4   7   94 103                 197
935949 935949 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2016   grade_8 159 23 88 1   9     4   10   146 148                       294 159 23 88 1   9     4   10   146 148                 294
937114 937114 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_10 123 50 189 4   4     4   19   216 177                       393 123 50 189 4   4     4   19   216 177                 393
1125182 1125182 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2017   grade_11 176 3 16 0   3     4   2   101 103                       204 176 3 16 0   3     4   2   101 103                 204
1129703 1129703 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_10 314 71 57 0   14     4   23   261 221                       483 314 71 57 0   14     4   23   261 221                 483
2229134 2229134 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_11 277 32 39 4   12     4   15   187 196                       383.0 277 32 39 4   12     4   15   187 196                 383
2236521 2236521 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_11 313 68 57 0   15     4   24   255 225                       481.0 313 68 57 0   15     4   24   255 225                 481
2040126 2040126 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_12 269 26 36 2   12     4   13   174 188                       362.0 269 26 36 2   12     4   13   174 188                 362
2040164 2040164 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_2 71 2 5 0   0     4   2   47 37                       84.0 71 2 5 0   0     4   2   47 37                 84
2041311 2041311 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_9 174 708 154 3   20     4   45   585 523                       1108.0 174 708 154 3   20     4   45   585 523                 1108
2041312 2041312 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_10 197 601 130 3   22     4   38   541 454                       995.0 197 601 130 3   22     4   38   541 454                 995
2042657 2042657 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_8 37 1 3 0   0     4   1   24 22                       46.0 37 1 3 0   0     4   1   24 22                 46
2044848 2044848 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2019   pre_kindergarten 73 8 5 0   15     4   0   63 42                       105.0 73 8 5 0   15     4   0   63 42                 105
2046216 2046216 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_6 154 57 32 0   8     4   22   126 151                       277.0 154 57 32 0   8     4   22   126 151                 277
2046378 2046378 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_12 284 69 46 0   16     4   18   231 206                       437.0 284 69 46 0   16     4   18   231 206                 437
1366243 1366243 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_11 174 559 117 4   19     4   31   475 433 *                     908.0 174 559 117 4   19     4   31   475 433                 908
1367509 1367509 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2020   grade_9 172 3 32 1   1     4   17   147 83 *                     230.0 172 3 32 1   1     4   17   147 83                 230
1367584 1367584 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_9 28 2 4 0   0     4   0   17 21 *                     38.0 28 2 4 0   0     4   0   17 21                 38
1673477 1673477 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_12 166 561 110 4   19     4   31   471 424 *                     895.0 166 561 110 4   19     4   31   471 424                 895
1674835 1674835 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_10 30 1 3 0   0     4   0   18 20 *                     38.0 30 1 3 0   0     4   0   18 20                 38
1676884 1676884 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_4 42 1 5 0   4     4   1   30 27 *                     57.0 42 1 5 0   4     4   1   30 27                 57
1677019 1677019 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Norwood - Charles J Prescott   Regular School No Elementary KG 05 2021   grade_3 21 4 7 0   14     4   1   23 28 *                     51.0 21 4 7 0   14     4   1   23 28                 51
1677023 1677023 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 Norwood - George F. Willett   Regular School No Elementary PK KG 2021   pre_kindergarten 52 7 10 0   10     4   0   44 39 *                     83.0 52 7 10 0   10     4   0   44 39                 83
1681344 1681344 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Regional Vocational Technical - Franklin County Technical   Career and Technical School No High 09 12 2021   grade_9 152 1 11 1   0     4   2   89 82 *                     171.0 152 1 11 1   0     4   2   89 82                 171
737118 737118 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2015   grade_5 57 85 21 0   7     3   10   92 91                       183 57 85 21 0   7     3   10   92 91                 183
737165 737165 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_10 220 623 140 4   27     3   25   503 539                       1042 220 623 140 4   27     3   25   503 539                 1042
737598 737598 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_12 231 8 67 0   11     3   9   184 145                       329 231 8 67 0   11     3   9   184 145                 329
738399 738399 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Milton L Fuller Elementary   Regular School No 1 PK PK 2015   pre_kindergarten 80 1 1 1   1     3   1   56 32                       88 80 1 1 1   1     3   1   56 32                 88
738419 738419 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_7 171 3 15 0   4     3   7   95 108                       203 171 3 15 0   4     3   7   95 108                 203
738495 738495 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_3 42 2 3 0   1     3   4   28 27                       55 42 2 3 0   1     3   4   28 27                 55
739193 739193 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2015   grade_5 92 2 4 0   4     3   1   55 51                       106 92 2 4 0   4     3   1   55 51                 106
739386 739386 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_5 112 3 12 1   2     3   1   69 65                       134 112 3 12 1   2     3   1   69 65                 134
739622 739622 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_11 287 11 7 2   16     3   2   165 163                       328 287 11 7 2   16     3   2   165 163                 328
740019 740019 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2015   grade_9 158 65 8 0   17     3   10   129 132                       261 158 65 8 0   17     3   10   129 132                 261
740271 740271 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_8 221 21 94 3   2     3   12   165 191                       356 221 21 94 3   2     3   12   165 191                 356
740274 740274 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_8 88 25 93 0   0     3   9   122 96                       218 88 25 93 0   0     3   9   122 96                 218
740276 740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
740417 740417 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_12 290 18 26 0   93     3   14   209 235                       444 290 18 26 0   93     3   14   209 235                 444
740522 740522 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2015   grade_7 281 13 32 0   30     3   4   173 190                       363 281 13 32 0   30     3   4   173 190                 363
740523 740523 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2015   grade_8 342 10 32 0   23     3   6   214 202                       416 342 10 32 0   23     3   6   214 202                 416
740525 740525 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2015   grade_10 254 10 25 0   23     3   10   150 175                       325 254 10 25 0   23     3   10   150 175                 325
741060 741060 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_2 43 13 11 0   25     3   3   57 41                       98 43 13 11 0   25     3   3   57 41                 98
742075 742075 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2015   grade_2 29 7 2 0   2     3   4   19 28                       47 29 7 2 0   2     3   4   19 28                 47
742248 742248 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_8 448 75 73 1   16     3   27   346 297                       643 448 75 73 1   16     3   27   346 297                 643
742462 742462 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2015   grade_6 95 5 7 0   0     3   4   66 48                       114 95 5 7 0   0     3   4   66 48                 114
742722 742722 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No 3 09 12 2015   grade_12 269 4 39 1   14     3   3   170 163                       333 269 4 39 1   14     3   3   170 163                 333
742969 742969 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2015   grade_11 190 2 6 0   5     3   2   89 119                       208 190 2 6 0   5     3   2   89 119                 208
744370 744370 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No 1 KG 05 2015   kindergarten 36 0 1 0   0     3   1   20 21                       41 36 0 1 0   0     3   1   20 21                 41
744622 744622 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_11 317 5 13 0   30     3   7   180 195                       375 317 5 13 0   30     3   7   180 195                 375
744623 744623 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_12 317 2 8 0   22     3   2   164 190                       354 317 2 8 0   22     3   2   164 190                 354
933996 933996 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2016   grade_1 21 65 14 1   1     3   13   65 53                       118 21 65 14 1   1     3   13   65 53                 118
934024 934024 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_9 267 694 166 5   26     3   51   637 575                       1212 267 694 166 5   26     3   51   637 575                 1212
934025 934025 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_10 183 648 120 4   34     3   30   535 487                       1022 183 648 120 4   34     3   30   535 487                 1022
935342 935342 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   kindergarten 26 0 6 0   0     3   3   24 14                       38 26 0 6 0   0     3   3   24 14                 38
935347 935347 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_4 43 2 3 0   1     3   2   27 27                       54 43 2 3 0   1     3   2   27 27                 54
936234 936234 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_6 118 3 12 1   2     3   1   74 66                       140 118 3 12 1   2     3   1   74 66                 140
936867 936867 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2016   grade_10 160 62 8 0   18     3   10   131 130                       261 160 62 8 0   18     3   10   131 130                 261
937115 937115 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_11 284 93 276 5   6     3   28   351 344                       695 284 93 276 5   6     3   28   351 344                 695
937116 937116 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_12 188 54 125 1   4     3   26   215 186                       401 188 54 125 1   4     3   26   215 186                 401
937358 937358 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2016   grade_8 275 10 30 0   28     3   4   164 186                       350 275 10 30 0   28     3   4   164 186                 350
937361 937361 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2016   grade_11 249 11 24 0   21     3   10   144 174                       318 249 11 24 0   21     3   10   144 174                 318
938887 938887 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2016   grade_3 28 8 1 1   2     3   4   19 28                       47 28 8 1 1   2     3   4   19 28                 47
939058 939058 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_9 339 69 58 0   14     3   22   272 233                       505 339 69 58 0   14     3   22   272 233                 505
941197 941197 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No 1 KG 05 2016   grade_1 37 0 0 0   0     3   1   18 23                       41 37 0 0 0   0     3   1   18 23                 41
941447 941447 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2016   grade_12 316 4 12 0   31     3   7   178 195                       373 316 4 12 0   31     3   7   178 195                 373
1122319 1122319 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2017   grade_4 343 27 49 0   9     3   15   217 229                       446 343 27 49 0   9     3   15   217 229                 446

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);