enrollments

Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by asian 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
1126058 1126058 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_8 133 13 10 1   99     0   15   129 142                       271 133 13 10 1   99     0   15   129 142                 271
936008 936008 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_8 123 13 5 1   97     0   14   130 123                       253 123 13 5 1   97     0   14   130 123                 253
1370168 1370168 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_8 74 9 4 0   96     2   8   105 88 *                     193.0 74 9 4 0   96     2   8   105 88                 193
741563 741563 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2015   grade_8 337 4 31 0   93     1   12   247 231                       478 337 4 31 0   93     1   12   247 231                 478
937942 937942 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2016   grade_8 50 2 3 0   93     0   1   79 70                       149 50 2 3 0   93     0   1   79 70                 149
739159 739159 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2015   grade_8 170 8 11 0   92     0   13   158 136                       294 170 8 11 0   92     0   13   158 136                 294
1365981 1365981 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_8 194 32 69 0   92     0   17   197 207 *                     404.0 194 32 69 0   92     0   17   197 207                 404
1371687 1371687 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2020   grade_8 182 4 25 0   92     1   12   160 156 *                     316.0 182 4 25 0   92     1   12   160 156                 316
2045248 2045248 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_8 106 8 7 0   92     0   5   113 105                       218.0 106 8 7 0   92     0   5   113 105                 218
2236976 2236976 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Westborough: Sarah W Gibbons Middle   Regular School No Middle 07 08 2018   grade_8 183 5 22 0   92     0   16   155 163                       318.0 183 5 22 0   92     0   16   155 163                 318
1128370 1128370 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_8 112 6 6 0   90     1   6   117 104                       221 112 6 6 0   90     1   6   117 104                 221
2235191 2235191 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy: Central Middle   Regular School No Middle 06 08 2018   grade_8 103 5 7 0   90     1   6   116 96                       212.0 103 5 7 0   90     1   6   116 96                 212
736924 736924 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_8 4 97 27 1   9     0   2   74 66                       140 4 97 27 1   9     0   2   74 66                 140
737703 737703 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2015   grade_8 257 6 17 0   9     2   5   155 141                       296 257 6 17 0   9     2   5   155 141                 296
737730 737730 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2015   grade_8 311 5 7 1   9     0   4   181 156                       337 311 5 7 1   9     0   4   181 156                 337
737761 737761 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2015   grade_8 159 18 24 1   9     0   6   116 101                       217 159 18 24 1   9     0   6   116 101                 217
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
738345 738345 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2015   grade_8 127 1 3 1   9     1   4   78 68                       146 127 1 3 1   9     1   4   78 68                 146
742272 742272 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No 2 07 08 2015   grade_8 316 8 7 0   9     0   0   178 162                       340 316 8 7 0   9     0   0   178 162                 340
743531 743531 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2015   grade_8 3 36 20 1   9     0   3   36 36                       72 3 36 20 1   9     0   3   36 36                 72
743578 743578 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_8 41 56 47 0   9     0   7   73 87                       160 41 56 47 0   9     0   7   73 87                 160
933027 933027 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2016   grade_8 236 7 14 0   9     0   5   143 128                       271 236 7 14 0   9     0   5   143 128                 271
934257 934257 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2016   grade_8 37 26 13 0   9     0   6   45 46                       91 37 26 13 0   9     0   6   45 46                 91
934301 934301 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_8 59 2 4 0   9     0   6   34 46                       80 59 2 4 0   9     0   6   34 46                 80
934562 934562 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2016   grade_8 262 3 14 0   9     0   4   148 144                       292 262 3 14 0   9     0   4   148 144                 292
935399 935399 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_8 79 1 3 0   9     0   1   42 51                       93 79 1 3 0   9     0   1   42 51                 93
935509 935509 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_8 296 1 14 0   9     0   9   173 156                       329 296 1 14 0   9     0   9   173 156                 329
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
936935 936935 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No 2 05 08 2016   grade_8 166 3 5 0   9     0   2   93 92                       185 166 3 5 0   9     0   2   93 92                 185
938251 938251 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No 2 06 08 2016   grade_8 167 13 27 1   9     0   0   112 105                       217 167 13 27 1   9     0   0   112 105                 217
939205 939205 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No 2 06 08 2016   grade_8 135 11 15 0   9     0   4   88 86                       174 135 11 15 0   9     0   4   88 86                 174
939254 939254 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_8 87 21 57 0   9     0   4   102 76                       178 87 21 57 0   9     0   4   102 76                 178
939771 939771 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2016   grade_8 238 3 10 0   9     0   2   137 125                       262 238 3 10 0   9     0   2   137 125                 262
939900 939900 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_8 138 10 10 0   9     0   1   83 85                       168 138 10 10 0   9     0   1   83 85                 168
939903 939903 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2016   grade_8 137 14 18 0   9     0   5   84 99                       183 137 14 18 0   9     0   5   84 99                 183
940446 940446 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_8 52 34 5 0   9     0   6   43 63                       106 52 34 5 0   9     0   6   43 63                 106
941057 941057 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No 2 06 08 2016   grade_8 147 4 8 0   9     0   9   88 89                       177 147 4 8 0   9     0   9   88 89                 177
941162 941162 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2016   grade_8 193 2 1 0   9     1   0   105 101                       206 193 2 1 0   9     1   0   105 101                 206
941235 941235 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No 2 06 08 2016   grade_8 144 3 7 0   9     0   4   79 88                       167 144 3 7 0   9     0   4   79 88                 167
941989 941989 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes 4 07 11 2016   grade_8 24 28 12 0   9     0   2   34 41                       75 24 28 12 0   9     0   2   34 41                 75
1122243 1122243 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_8 91 8 21 0   9     2   12   82 61                       143 91 8 21 0   9     2   12   82 61                 143
1123964 1123964 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2017   grade_8 28 28 14 0   9     0   6   45 40                       85 28 28 14 0   9     0   6   45 40                 85
1124016 1124016 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_8 54 0 0 0   9     0   5   35 33                       68 54 0 0 0   9     0   5   35 33                 68
1124191 1124191 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_8 161 8 78 2   9     0   7   129 136                       265 161 8 78 2   9     0   7   129 136                 265
1125488 1125488 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_8 335 5 5 0   9     0   6   167 193                       360 335 5 5 0   9     0   6   167 193                 360
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
1129355 1129355 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2017   grade_8 29 43 116 1   9     0   3   103 98                       201 29 43 116 1   9     0   3   103 98                 201
1129467 1129467 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2017   grade_8 169 4 15 0   9     0   7   98 106                       204 169 4 15 0   9     0   7   98 106                 204
1129942 1129942 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_8 95 19 52 0   9     0   2   91 86                       177 95 19 52 0   9     0   2   91 86                 177
1365027 1365027 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_8 95 10 27 1   9     0   9   74 77 *                     151.0 95 10 27 1   9     0   9   74 77                 151
1365222 1365222 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_8 239 9 54 0   9     0   9   175 145 *                     320.0 239 9 54 0   9     0   9   175 145                 320
1366240 1366240 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2020   grade_8 52 82 70 0   9     0   10   99 124 *                     223.0 52 82 70 0   9     0   10   99 124                 223
1366330 1366330 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_8 39 7 15 0   9     0   5   40 35 *                     75.0 39 7 15 0   9     0   5   40 35                 75
1366785 1366785 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_8 235 5 24 0   9     0   6   142 137 *                     279.0 235 5 24 0   9     0   6   142 137                 279
1366842 1366842 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2020   grade_8 137 13 29 0   9     0   7   108 87 *                     195.0 137 13 29 0   9     0   7   108 87                 195
1367192 1367192 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_8 112 16 45 0   9     0   13   118 77 *                     195.0 112 16 45 0   9     0   13   118 77                 195
1367437 1367437 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2020   grade_8 130 3 4 0   9     0   4   77 73 *                     150.0 130 3 4 0   9     0   4   77 73                 150
1368871 1368871 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2020   grade_8 126 13 9 0   9     0   7   87 77 *                     164.0 126 13 9 0   9     0   7   87 77                 164
1369364 1369364 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2020   grade_8 176 3 7 0   9     0   4   100 99 *                     199.0 176 3 7 0   9     0   4   100 99                 199
1369897 1369897 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2020   grade_8 370 18 77 0   9     0   7   247 234 *                     481.0 370 18 77 0   9     0   7   247 234                 481
1370074 1370074 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2020   grade_8 291 5 31 1   9     0   20   183 174 *                     357.0 291 5 31 1   9     0   20   183 174                 357
1371449 1371449 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2020   grade_8 135 9 13 1   9     0   1   87 81 *                     168.0 135 9 13 1   9     0   1   87 81                 168
1371502 1371502 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_8 102 20 53 0   9     0   1   93 92 *                     185.0 102 20 53 0   9     0   1   93 92                 185
1371992 1371992 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2020   grade_8 228 5 11 1   9     1   11   142 124 *                     266.0 228 5 11 1   9     1   11   142 124                 266
1372115 1372115 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_8 112 7 13 1   9     0   5   72 75 *                     147.0 112 7 13 1   9     0   5   72 75                 147
1373393 1373393 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_8 185 2 2 1   9     1   3   105 98 *                     203.0 185 2 2 1   9     1   3   105 98                 203
1374204 1374204 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_8 12 8 30 0   9     0   2   34 27 *                     61.0 12 8 30 0   9     0   2   34 27                 61
1672250 1672250 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_8 100 9 41 0   9     0   5   94 70 *                     164.0 100 9 41 0   9     0   5   94 70                 164
1673107 1673107 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston - Lilla G. Frederick Middle School   Regular School No Middle 06 08 2021   grade_8 2 62 66 0   9     0   4   78 65 *                     143.0 2 62 66 0   9     0   4   78 65                 143
1673536 1673536 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   grade_8 35 2 6 0   9     0   5   20 37 *                     57.0 35 2 6 0   9     0   5   20 37                 57
1673701 1673701 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge - Cambridge Street Upper School   Regular School No Middle 06 08 2021   grade_8 37 20 15 1   9     0   11   52 41 *                     93.0 37 20 15 1   9     0   11   52 41                 93
1674420 1674420 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River - Talbot Innovation School   Regular School No Middle 06 08 2021   grade_8 74 12 61 0   9     0   12   93 75 *                     168.0 74 12 61 0   9     0   12   93 75                 168
1674621 1674621 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_8 132 12 74 0   9     0   17   114 130 *                     244.0 132 12 74 0   9     0   17   114 130                 244
1676797 1676797 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_8 149 7 36 0   9     0   12   83 128 *                     213.0 149 7 36 0   9     0   12   83 128                 213
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
1678754 1678754 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 Waltham - John F Kennedy Middle   Regular School No Middle 06 08 2021   grade_8 91 14 46 0   9     0   4   93 71 *                     164.0 91 14 46 0   9     0   4   93 71                 164
1680658 1680658 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable - Groton Dunstable Regional Middle   Regular School No Middle 05 08 2021   grade_8 158 5 5 0   9     0   5   90 92 *                     182.0 158 5 5 0   9     0   5   90 92                 182
1681184 1681184 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton - Triton Regional Middle School   Regular School No Middle 07 08 2021   grade_8 168 0 7 0   9     0   5   109 80 *                     189.0 168 0 7 0   9     0   5   109 80                 189
1681526 1681526 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_8 64 4 20 0   9     0   12   57 52 0                     109.0 64 4 20 0   9     0   12   57 52 0               109
2041353 2041353 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_8 42 9 10 0   9     0   12   45 37                       82.0 42 9 10 0   9     0   12   45 37                 82
2041391 2041391 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2019   grade_8 26 6 9 0   9     0   8   24 34                       58.0 26 6 9 0   9     0   8   24 34                 58
2042075 2042075 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2019   grade_8 257 16 12 0   9     0   5   152 147                       299.0 257 16 12 0   9     0   5   152 147                 299
2042505 2042505 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_8 119 3 6 0   9     0   1   62 76                       138.0 119 3 6 0   9     0   1   62 76                 138
2043325 2043325 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_8 99 0 2 1   9     0   7   58 60                       118.0 99 0 2 1   9     0   7   58 60                 118
2043696 2043696 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2019   grade_8 124 3 14 0   9     0   5   88 67                       155.0 124 3 14 0   9     0   5   88 67                 155
2047580 2047580 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2019   grade_8 80 2 30 1   9     0   4   66 60                       126.0 80 2 30 1   9     0   4   66 60                 126
2048586 2048586 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2019   grade_8 311 2 6 0   9     0   8   174 162                       336.0 311 2 6 0   9     0   8   174 162                 336
2229054 2229054 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_8 95 10 24 1   9     1   3   81 62                       143.0 95 10 24 1   9     1   3   81 62                 143
2229297 2229297 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly: Briscoe Middle   Regular School No Middle 06 08 2018   grade_8 285 13 32 0   9     0   11   198 152                       350.0 285 13 32 0   9     0   11   198 152                 350
2229985 2229985 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston: Edison K-8   Regular School No Elementary PK 08 2018   grade_8 7 8 33 1   9     0   1   32 27                       59.0 7 8 33 1   9     0   1   32 27                 59
2230775 2230775 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge: Putnam Avenue Upper School   Regular School No Middle 06 08 2018   grade_8 23 33 19 1   9     1   8   48 46                       94.0 23 33 19 1   9     1   8   48 46                 94
2231406 2231406 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton: Easton Middle School   Regular School No Middle 06 08 2018   grade_8 239 18 12 1   9     0   14   148 145                       293.0 239 18 12 1   9     0   14   148 145                 293
2233609 2233609 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield: Thomas Blake Middle   Regular School No Middle 06 08 2018   grade_8 188 1 3 0   9     0   8   110 99                       209.0 188 1 3 0   9     0   8   110 99                 209
2233650 2233650 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford: Madeleine Dugger Andrews   Regular School No Middle 06 08 2018   grade_8 105 17 15 0   9     0   12   86 72                       158.0 105 17 15 0   9     0   12   86 72                 158
2233751 2233751 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen: Comprehensive Grammar School   Regular School No Elementary PK 08 2018   grade_8 92 0 39 0   9     0   5   83 62                       145.0 92 0 39 0   9     0   5   83 62                 145
2234728 2234728 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Norwood: Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2018   grade_8 169 27 26 0   9     0   4   119 116                       235.0 169 27 26 0   9     0   4   119 116                 235
2234865 2234865 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody: J Henry Higgins Middle   Regular School No Middle 06 08 2018   grade_8 329 17 68 0   9     0   7   224 206                       430.0 329 17 68 0   9     0   7   224 206                 430
2235294 2235294 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Reading: Walter S Parker Middle   Regular School No Middle 06 08 2018   grade_8 156 3 1 0   9     0   5   86 88                       174.0 156 3 1 0   9     0   5   86 88                 174
2235318 2235318 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere: Rumney Marsh Academy   Regular School No Middle 06 08 2018   grade_8 87 8 82 2   9     0   9   111 86                       197.0 87 8 82 2   9     0   9   111 86                 197
2235352 2235352 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere: Garfield Middle School   Regular School No Middle 06 08 2018   grade_8 48 4 108 0   9     0   5   90 84                       174.0 48 4 108 0   9     0   5   90 84                 174

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