enrollments

Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by native_american descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,459 ✖
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
1126737 1126737 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_8 120 7 6 9   3     0   3   68 80                       148 120 7 6 9   3     0   3   68 80                 148
1132003 1132003 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_8 154 20 21 8   4     1   13   125 96                       221 154 20 21 8   4     1   13   125 96                 221
1676046 1676046 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_8 101 6 5 8   5     0   16   69 72 *                     141.0 101 6 5 8   5     0   16   69 72                 141
739955 739955 MA Worcester   school 2507860 185   Milford 250786002439 1850310 Milford Middle East   Regular School No 4 08 08 2015   grade_8 228 9 57 7   13     0   4   170 148                       318 228 9 57 7   13     0   4   170 148                 318
936800 936800 MA Worcester   school 2507860 185   Milford 250786002439 1850310 Milford Middle East   Regular School No 4 08 08 2016   grade_8 223 9 55 7   7     0   10   152 159                       311 223 9 55 7   7     0   10   152 159                 311
936570 936570 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_8 103 6 4 6   3     0   5   65 62                       127 103 6 4 6   3     0   5   65 62                 127
936774 936774 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No 2 06 08 2016   grade_8 229 3 10 6   0     0   7   129 126                       255 229 3 10 6   0     0   7   129 126                 255
1127013 1127013 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_8 205 9 76 6   6     0   11   168 145                       313 205 9 76 6   6     0   11   168 145                 313
1368796 1368796 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_8 85 4 4 6   3     0   7   59 50 *                     109.0 85 4 4 6   3     0   7   59 50                 109
1369023 1369023 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2020   grade_8 212 6 95 6   5     0   7   184 147 *                     331.0 212 6 95 6   5     0   7   184 147                 331
1680519 1680519 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth - Dennis-Yarmouth Regional High   Regular School No High 08 12 2021   grade_8 151 21 33 6   6     0   11   115 113 *                     228.0 151 21 33 6   6     0   11   115 113                 228
2233303 2233303 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_8 53 40 291 6   35     0   15   227 213                       440.0 53 40 291 6   35     0   15   227 213                 440
2233558 2233558 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   grade_8 105 4 4 6   3     1   7   71 59                       130.0 105 4 4 6   3     1   7   71 59                 130
2238834 2238834 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_8 154 26 29 6   4     0   11   113 117                       230.0 154 26 29 6   4     0   11   113 117                 230
1368997 1368997 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2020   grade_8 229 5 8 5   6     0   10   137 126 *                     263.0 229 5 8 5   6     0   10   137 126                 263
1373254 1373254 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_8 140 17 35 5   4     0   16   108 109 *                     217.0 140 17 35 5   4     0   16   108 109                 217
2044068 2044068 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_8 218 6 10 5   6     0   12   118 139                       257.0 218 6 10 5   6     0   12   118 139                 257
735972 735972 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_8 316 22 13 4   21     2   20   197 201                       398 316 22 13 4   21     2   20   197 201                 398
738790 738790 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_8 87 0 2 4   0     0   2   45 50                       95 87 0 2 4   0     0   2   45 50                 95
932846 932846 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_8 297 36 44 4   12     1   12   199 207                       406 297 36 44 4   12     1   12   199 207                 406
1124860 1124860 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_8 228 12 5 4   10     0   19   134 144                       278 228 12 5 4   10     0   19   134 144                 278
1127378 1127378 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_8 188 19 104 4   2     2   10   181 148                       329 188 19 104 4   2     2   10   181 148                 329
1128497 1128497 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2017   grade_8 89 8 84 4   12     0   3   113 87                       200 89 8 84 4   12     0   3   113 87                 200
1129981 1129981 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_8 137 8 13 4   2     0   18   96 86                       182 137 8 13 4   2     0   18   96 86                 182
1371298 1371298 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   grade_8 427 122 83 4   8     1   45   356 334 *                     690.0 427 122 83 4   8     1   45   356 334                 690
1676582 1676582 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford - Normandin Middle School   Regular School No Middle 06 08 2021   grade_8 174 41 149 4   1     0   23   203 189 *                     392.0 174 41 149 4   1     0   23   203 189                 392
1678551 1678551 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_8 426 113 92 4   5     2   33   337 338 *                     675.0 426 113 92 4   5     2   33   337 338                 675
1678627 1678627 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge - Uxbridge High   Regular School No High 08 12 2021   grade_8 126 1 8 4   3     0   1   70 73 *                     143.0 126 1 8 4   3     0   1   70 73                 143
2047528 2047528 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_8 29 14 123 4   3     2   0   81 94                       175.0 29 14 123 4   3     2   0   81 94                 175
2048316 2048316 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_8 171 23 20 4   5     0   11   122 112                       234.0 171 23 20 4   5     0   11   122 112                 234
2233307 2233307 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_8 65 40 256 4   52     0   12   223 206                       429.0 65 40 256 4   52     0   12   223 206                 429
2234193 2234193 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_8 106 49 95 4   3     0   20   149 128                       277.0 106 49 95 4   3     0   20   149 128                 277
736855 736855 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_8 81 60 68 3   58     0   8   117 161                       278 81 60 68 3   58     0   8   117 161                 278
738152 738152 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2015   grade_8 228 15 8 3   9     0   12   133 142                       275 228 15 8 3   9     0   12   133 142                 275
739513 739513 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2015   grade_8 75 40 210 3   38     1   13   197 183                       380 75 40 210 3   38     1   13   197 183                 380
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
740668 740668 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2015   grade_8 190 4 2 3   5     0   4   110 98                       208 190 4 2 3   5     0   4   110 98                 208
743372 743372 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2015   grade_8 100 71 145 3   54     0   20   202 191                       393 100 71 145 3   54     0   20   202 191                 393
937106 937106 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2016   grade_8 103 55 88 3   5     2   19   142 133                       275 103 55 88 3   5     2   19   142 133                 275
939324 939324 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2016   grade_8 128 4 17 3   8     0   8   78 90                       168 128 4 17 3   8     0   8   78 90                 168
941026 941026 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2016   grade_8 167 21 19 3   5     0   12   98 129                       227 167 21 19 3   5     0   12   98 129                 227
1127374 1127374 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_8 113 48 102 3   4     2   21   146 147                       293 113 48 102 3   4     2   21   146 147                 293
1128701 1128701 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   grade_8 223 2 2 3   9     1   1   121 120                       241 223 2 2 3   9     1   1   121 120                 241
1131642 1131642 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2017   grade_8 14 18 29 3   5     1   1   33 38                       71 14 18 29 3   5     1   1   33 38                 71
1366066 1366066 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_8 150 2 9 3   2     0   5   86 85 *                     171.0 150 2 9 3   2     0   5   86 85                 171
1372943 1372943 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2020   grade_8 26 13 14 3   2     0   2   33 27 *                     60.0 26 13 14 3   2     0   2   33 27                 60
1673302 1673302 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_8 132 3 10 3   2     0   7   88 69 *                     157.0 132 3 10 3   2     0   7   88 69                 157
1676245 1676245 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough - John T. Nichols Middle   Regular School No Middle 06 08 2021   grade_8 237 11 7 3   0     0   7   134 131 *                     265.0 237 11 7 3   0     0   7   134 131                 265
2042109 2042109 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_8 5 7 25 3   3     0   2   22 23                       45.0 5 7 25 3   3     0   2   22 23                 45
2044094 2044094 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_8 218 9 106 3   13     0   12   185 176                       361.0 218 9 106 3   13     0   12   185 176                 361
2045148 2045148 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2019   grade_8 287 10 17 3   8     0   11   193 142                       336.0 287 10 17 3   8     0   11   193 142                 336
2045522 2045522 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2019   grade_8 211 2 2 3   6     0   1   112 113                       225.0 211 2 2 3   6     0   1   112 113                 225
2046374 2046374 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_8 400 110 79 3   8     0   31   331 300                       631.0 400 110 79 3   8     0   31   331 300                 631
2047188 2047188 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_8 110 6 13 3   12     0   2   70 76                       146.0 110 6 13 3   12     0   2   70 76                 146
2048183 2048183 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_8 109 7 18 3   0     1   3   67 74                       141.0 109 7 18 3   0     1   3   67 74                 141
2049135 2049135 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2019   grade_8 164 9 11 3   3     1   7   116 82                       198.0 164 9 11 3   3     1   7   116 82                 198
2230295 2230295 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_8 176 5 3 3   6     0   0   93 100                       193.0 176 5 3 3   6     0   0   93 100                 193
2231687 2231687 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth: Lawrence   Regular School No Middle 07 08 2018   grade_8 229 16 14 3   6     0   19   160 127                       287.0 229 16 14 3   6     0   19   160 127                 287
2236563 2236563 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_8 24 0 9 3   1     0   5   20 22                       42.0 24 0 9 3   1     0   5   20 22                 42
2237939 2237939 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_8 14 9 143 3   3     0   0   81 91                       172.0 14 9 143 3   3     0   0   81 91                 172
2239648 2239648 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_8 35 1 2 3   1     0   2   31 13                       44.0 35 1 2 3   1     0   2   31 13                 44
736778 736778 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_8 7 37 16 2   5     1   1   42 27                       69 7 37 16 2   5     1   1   42 27                 69
737160 737160 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2015   grade_8 63 80 9 2   3     0   4   86 75                       161 63 80 9 2   3     0   4   86 75                 161
737295 737295 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2015   grade_8 221 8 8 2   34     0   11   132 152                       284 221 8 8 2   34     0   11   132 152                 284
737958 737958 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_8 12 7 20 2   4     0   1   21 25                       46 12 7 20 2   4     0   1   21 25                 46
738113 738113 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2015   grade_8 163 16 47 2   8     0   15   125 126                       251 163 16 47 2   8     0   15   125 126                 251
738420 738420 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_8 215 2 10 2   5     1   3   133 105                       238 215 2 10 2   5     1   3   133 105                 238
739389 739389 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_8 109 2 5 2   8     1   0   65 62                       127 109 2 5 2   8     1   0   65 62                 127
739909 739909 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2015   grade_8 88 5 57 2   5     0   2   85 74                       159 88 5 57 2   5     0   2   85 74                 159
740268 740268 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_8 118 36 100 2   6     0   14   141 135                       276 118 36 100 2   6     0   14   141 135                 276
740402 740402 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2015   grade_8 159 13 12 2   44     0   10   124 116                       240 159 13 12 2   44     0   10   124 116                 240
740566 740566 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_8 375 9 13 2   19     0   10   214 214                       428 375 9 13 2   19     0   10   214 214                 428
741164 741164 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2015   grade_8 26 131 26 2   24     0   13   120 102                       222 26 131 26 2   24     0   13   120 102                 222
741226 741226 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2015   grade_8 78 11 75 2   10     0   7   87 96                       183 78 11 75 2   10     0   7   87 96                 183
741258 741258 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No 2 06 08 2015   grade_8 57 9 91 2   7     0   2   81 87                       168 57 9 91 2   7     0   2   81 87                 168
743369 743369 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2015   grade_8 64 73 178 2   19     0   13   171 178                       349 64 73 178 2   19     0   13   171 178                 349
743465 743465 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_8 83 9 14 2   10     0   3   55 66                       121 83 9 14 2   10     0   3   55 66                 121
743508 743508 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_8 99 4 2 2   26     0   12   62 83                       145 99 4 2 2   26     0   12   62 83                 145
743895 743895 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2015   grade_8 43 13 22 2   2     0   1   38 45                       83 43 13 22 2   2     0   1   38 45                 83
743986 743986 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_8 103 3 4 2   3     0   0   57 58                       115 103 3 4 2   3     0   0   57 58                 115
744200 744200 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_8 169 19 21 2   8     0   18   111 126                       237 169 19 21 2   8     0   18   111 126                 237
744467 744467 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No 2 07 08 2015   grade_8 305 0 8 2   8     0   8   177 154                       331 305 0 8 2   8     0   8   177 154                 331
744764 744764 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2015   grade_8 118 3 13 2   1     0   6   73 70                       143 118 3 13 2   1     0   6   73 70                 143
932741 932741 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_8 137 7 29 2   20     0   4   98 101                       199 137 7 29 2   20     0   4   98 101                 199
932779 932779 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_8 107 6 27 2   5     1   4   71 81                       152 107 6 27 2   5     1   4   71 81                 152
933965 933965 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_8 17 58 23 2   0     0   5   49 56                       105 17 58 23 2   0     0   5   49 56                 105
934251 934251 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2016   grade_8 29 34 13 2   3     2   4   49 38                       87 29 34 13 2   3     2   4   49 38                 87
934757 934757 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2016   grade_8 195 6 7 2   15     0   3   117 111                       228 195 6 7 2   15     0   3   117 111                 228
934957 934957 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2016   grade_8 111 14 50 2   16     0   10   103 100                       203 111 14 50 2   16     0   10   103 100                 203
934960 934960 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2016   grade_8 145 13 37 2   7     0   13   112 105                       217 145 13 37 2   7     0   13   112 105                 217
936560 936560 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2016   grade_8 332 2 6 2   4     0   2   175 173                       348 332 2 6 2   4     0   2   175 173                 348
936672 936672 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2016   grade_8 188 2 8 2   2     0   5   117 90                       207 188 2 8 2   2     0   5   117 90                 207
937320 937320 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_8 134 4 43 2   5     0   10   99 99                       198 134 4 43 2   5     0   10   99 99                 198
938368 938368 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2016   grade_8 367 12 38 2   115     0   13   297 250                       547 367 12 38 2   115     0   13   297 250                 547
939132 939132 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2016   grade_8 124 1 4 2   3     0   6   81 59                       140 124 1 4 2   3     0   6   81 59                 140
939286 939286 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2016   grade_8 147 17 14 2   3     0   24   106 101                       207 147 17 14 2   3     0   24   106 101                 207
939524 939524 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2016   grade_8 167 4 32 2   10     0   3   110 108                       218 167 4 32 2   10     0   3   110 108                 218
939586 939586 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2016   grade_8 125 12 4 2   26     0   4   94 79                       173 125 12 4 2   26     0   4   94 79                 173
939689 939689 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 05 08 2016   grade_8 377 23 40 2   28     0   9   240 239                       479 377 23 40 2   28     0   9   240 239                 479
940583 940583 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_8 73 16 6 2   14     0   5   44 72                       116 73 16 6 2   14     0   5   44 72                 116

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