enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by native_hawaiian_pacific_islander_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
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
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
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
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
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
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
1126339 1126339 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_7 119 3 15 2   2     3   1   76 69                       145 119 3 15 2   2     3   1   76 69                 145
1369652 1369652 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_7 133 2 17 0   23     3   6   85 99 *                     184.0 133 2 17 0   23     3   6   85 99                 184
1370479 1370479 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_7 139 7 39 1   10     3   5   107 97 *                     204.0 139 7 39 1   10     3   5   107 97                 204
2042656 2042656 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_7 33 0 3 0   3     3   3   25 20                       45.0 33 0 3 0   3     3   3   25 20                 45
737156 737156 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_7 69 95 32 1   8     2   8   113 102                       215 69 95 32 1   8     2   8   113 102                 215
737390 737390 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2015   grade_7 35 32 13 2   4     2   4   53 39                       92 35 32 13 2   4     2   4   53 39                 92
738341 738341 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_7 141 1 2 0   8     2   7   81 80                       161 141 1 2 0   8     2   7   81 80                 161
740267 740267 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_7 117 56 95 3   2     2   17   158 134                       292 117 56 95 3   2     2   17   158 134                 292
740270 740270 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_7 212 29 97 1   1     2   16   183 175                       358 212 29 97 1   1     2   16   183 175                 358
740273 740273 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_7 123 31 93 1   2     2   10   136 126                       262 123 31 93 1   2     2   10   136 126                 262
740598 740598 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2015   grade_7 170 2 7 1   22     2   4   119 89                       208 170 2 7 1   22     2   4   119 89                 208
741163 741163 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2015   grade_7 24 139 31 0   33     2   4   114 119                       233 24 139 31 0   33     2   4   114 119                 233
742244 742244 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2015   grade_7 83 24 25 0   0     2   4   67 71                       138 83 24 25 0   0     2   4   67 71                 138
743768 743768 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_7 0 29 7 0   0     2   0   19 19                       38 0 29 7 0   0     2   0   19 19                 38
745017 745017 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2015   grade_7 162 7 2 0   5     2   3   92 89                       181 162 7 2 0   5     2   3   92 89                 181
932778 932778 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_7 95 9 17 0   6     2   12   79 62                       141 95 9 17 0   6     2   12   79 62                 141
932845 932845 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_7 264 27 42 1   3     2   13   203 149                       352 264 27 42 1   3     2   13   203 149                 352
934007 934007 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2016   grade_7 21 123 24 0   1     2   9   98 82                       180 21 123 24 0   1     2   9   98 82                 180
934016 934016 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2016   grade_7 55 124 28 0   5     2   10   113 111                       224 55 124 28 0   5     2   10   113 111                 224
936220 936220 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2016   grade_7 204 5 15 1   3     2   5   110 125                       235 204 5 15 1   3     2   5   110 125                 235
937105 937105 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2016   grade_7 122 49 101 2   4     2   21   153 148                       301 122 49 101 2   4     2   21   153 148                 301
937108 937108 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2016   grade_7 193 26 101 4   3     2   11   193 147                       340 193 26 101 4   3     2   11   193 147                 340
939270 939270 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_7 90 4 11 0   0     2   4   64 47                       111 90 4 11 0   0     2   4   64 47                 111
940285 940285 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2016   grade_7 0 64 15 0   0     2   1   44 38                       82 0 64 15 0   0     2   1   44 38                 82
940909 940909 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_7 83 2 7 0   3     2   3   50 50                       100 83 2 7 0   3     2   3   50 50                 100
1123676 1123676 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2017   grade_7 22 124 15 0   3     2   9   94 81                       175 22 124 15 0   3     2   9   94 81                 175
1125082 1125082 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_7 140 0 5 0   6     2   1   81 73                       154 140 0 5 0   6     2   1   81 73                 154
1127085 1127085 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2017   grade_7 208 36 15 2   15     2   11   145 144                       289 208 36 15 2   15     2   11   145 144                 289
1127103 1127103 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_7 91 1 1 0   0     2   3   51 47                       98 91 1 1 0   0     2   3   51 47                 98
1127921 1127921 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2017   grade_7 15 5 4 0   0     2   0   19 7                       26 15 5 4 0   0     2   0   19 7                 26
1127956 1127956 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2017   grade_7 111 4 11 1   1     2   7   60 77                       137 111 4 11 1   1     2   7   60 77                 137
1128369 1128369 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_7 102 6 6 0   86     2   5   112 95                       207 102 6 6 0   86     2   5   112 95                 207
1130065 1130065 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_7 96 10 31 1   3     2   10   66 87                       153 96 10 31 1   3     2   10   66 87                 153
1131524 1131524 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2017   grade_7 8 77 64 1   8     2   8   93 75                       168 8 77 64 1   8     2   8   93 75                 168
1132475 1132475 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2017   grade_7 67 2 2 0   0     2   2   33 42                       75 67 2 2 0   0     2   2   33 42                 75
1365095 1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
1365386 1365386 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_7 2 49 26 0   3     2   2   41 43 *                     84.0 2 49 26 0   3     2   2   41 43                 84
1365803 1365803 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_7 1 15 9 0   1     2   0   20 8 *                     28.0 1 15 9 0   1     2   0   20 8                 28
1366236 1366236 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_7 64 117 25 2   7     2   4   96 125 *                     221.0 64 117 25 2   7     2   4   96 125                 221
1369621 1369621 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2020   grade_7 329 11 22 0   16     2   16   175 221 *                     396.0 329 11 22 0   16     2   16   175 221                 396
1370173 1370173 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_7 90 6 9 0   85     2   9   94 107 *                     201.0 90 6 9 0   85     2   9   94 107                 201
1373023 1373023 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2020   grade_7 203 13 27 2   151     2   14   208 204 *                     412.0 203 13 27 2   151     2   14   208 204                 412
1672399 1672399 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_7 211 13 20 1   92     2   28   189 178 *                     367.0 211 13 20 1   92     2   28   189 178                 367
1673127 1673127 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston - Clarence R Edwards Middle   Regular School No Middle 06 08 2021   grade_7 7 16 60 0   3     2   1   47 42 *                     89.0 7 16 60 0   3     2   1   47 42                 89
1673217 1673217 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_7 189 29 55 0   121     2   23   228 191 *                     419.0 189 29 55 0   121     2   23   228 191                 419
1673736 1673736 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_7 197 29 8 2   27     2   18   137 146 *                     283.0 197 29 8 2   27     2   18   137 146                 283
1674670 1674670 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_7 111 2 4 0   8     2   4   70 61 *                     131.0 111 2 4 0   8     2   4   70 61                 131
1675514 1675514 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow - Williams Middle   Regular School No Middle 06 08 2021   grade_7 94 0 7 0   17     2   9   55 74 *                     129.0 94 0 7 0   17     2   9   55 74                 129
1675691 1675691 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg - Lunenburg Middle School   Regular School No Middle 06 08 2021   grade_7 120 1 9 0   4     2   5   73 68 *                     141.0 120 1 9 0   4     2   5   73 68                 141
1677421 1677421 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy - Central Middle   Regular School No Middle 06 08 2021   grade_7 93 7 7 0   103     2   5   109 108 *                     217.0 93 7 7 0   103     2   5   109 108                 217
1679375 1679375 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 94 19 10 0   13     2   6   71 73 *                     144.0 94 19 10 0   13     2   6   71 73                 144
1679943 1679943 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_7 47 65 5 1   13     2   12   64 81 *                     145.0 47 65 5 1   13     2   12   64 81                 145
1680154 1680154 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District) - Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2021   grade_7 4 62 24 0   4     2   4   49 51 *                     100.0 4 62 24 0   4     2   4   49 51                 100
2040001 2040001 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_7 329 10 29 0   52     2   19   205 236                       441.0 329 10 29 0   52     2   19   205 236                 441
2040301 2040301 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2019   grade_7 129 7 15 0   10     2   4   91 76                       167.0 129 7 15 0   10     2   4   91 76                 167
2040429 2040429 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_7 0 36 19 0   0     2   1   26 32                       58.0 0 36 19 0   0     2   1   26 32                 58
2042602 2042602 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_7 189 4 16 2   30     2   6   128 121                       249.0 189 4 16 2   30     2   6   128 121                 249
2044171 2044171 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2019   grade_7 54 1 6 0   2     2   3   33 35                       68.0 54 1 6 0   2     2   3   33 35                 68
2044725 2044725 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2019   grade_7 147 8 12 0   21     2   11   93 108                       201.0 147 8 12 0   21     2   11   93 108                 201
2045241 2045241 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_7 73 7 4 0   92     2   9   100 87                       187.0 73 7 4 0   92     2   9   100 87                 187
2046217 2046217 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_7 166 71 34 1   25     2   13   184 128                       312.0 166 71 34 1   25     2   13   184 128                 312
2048182 2048182 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_7 92 3 13 2   8     2   5   66 59                       125.0 92 3 13 2   8     2   5   66 59                 125
2229698 2229698 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_7 2 35 22 0   2     2   5   38 30                       68.0 2 35 22 0   2     2   5   38 30                 68
2230165 2230165 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_7 194 29 58 0   115     2   19   189 228                       417.0 194 29 58 0   115     2   19   189 228                 417
2232006 2232006 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_7 169 5 14 1   4     2   18   123 90                       213.0 169 5 14 1   4     2   18   123 90                 213
2234576 2234576 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_7 156 4 16 2   15     2   10   112 93                       205.0 156 4 16 2   15     2   10   112 93                 205
2237938 2237938 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_7 26 13 122 5   3     2   0   80 91                       171.0 26 13 122 5   3     2   0   80 91                 171
735850 735850 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2015   grade_7 269 11 17 0   33     1   10   183 158                       341 269 11 17 0   33     1   10   183 158                 341
735902 735902 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_7 109 2 25 2   6     1   6   72 79                       151 109 2 25 2   6     1   6   72 79                 151
735971 735971 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_7 292 29 38 4   13     1   11   185 203                       388 292 29 38 4   13     1   11   185 203                 388
736205 736205 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2015   grade_7 0 21 23 0   0     1   2   20 27                       47 0 21 23 0   0     1   2   20 27                 47
736556 736556 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_7 1 33 43 0   1     1   2   27 54                       81 1 33 43 0   1     1   2   27 54                 81
736715 736715 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_7 5 24 35 0   6     1   1   41 31                       72 5 24 35 0   6     1   1   41 31                 72
736764 736764 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2015   grade_7 3 81 89 0   6     1   4   92 92                       184 3 81 89 0   6     1   4   92 92                 184
737150 737150 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_7 18 133 19 1   2     1   9   106 77                       183 18 133 19 1   2     1   9   106 77                 183
737484 737484 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_7 186 3 7 0   30     1   3   117 113                       230 186 3 7 0   30     1   3   117 113                 230
737782 737782 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_7 140 0 2 0   3     1   4   65 85                       150 140 0 2 0   3     1   4   65 85                 150
737972 737972 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_7 40 14 32 0   5     1   1   50 43                       93 40 14 32 0   5     1   1   50 43                 93
738112 738112 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2015   grade_7 165 12 57 0   12     1   11   124 134                       258 165 12 57 0   12     1   11   124 134                 258
738294 738294 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_7 113 9 75 0   18     1   9   118 107                       225 113 9 75 0   18     1   9   118 107                 225
738499 738499 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_7 35 0 3 0   3     1   0   21 21                       42 35 0 3 0   3     1   0   21 21                 42
739185 739185 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2015   grade_7 22 6 8 0   2     1   1   17 23                       40 22 6 8 0   2     1   1   17 23                 40
739333 739333 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2015   grade_7 38 8 42 0   46     1   7   65 77                       142 38 8 42 0   46     1   7   65 77                 142
739878 739878 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_7 103 2 19 0   5     1   3   69 64                       133 103 2 19 0   5     1   3   69 64                 133
740016 740016 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2015   grade_7 192 47 22 1   17     1   9   153 136                       289 192 47 22 1   17     1   9   153 136                 289
740032 740032 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_7 88 0 2 0   0     1   2   43 50                       93 88 0 2 0   0     1   2   43 50                 93
740055 740055 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No 2 06 08 2015   grade_7 83 14 27 0   3     1   4   65 67                       132 83 14 27 0   3     1   4   65 67                 132
740093 740093 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2015   grade_7 200 10 8 0   13     1   10   121 121                       242 200 10 8 0   13     1   10   121 121                 242
740565 740565 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_7 342 7 11 1   24     1   10   193 203                       396 342 7 11 1   24     1   10   193 203                 396
740667 740667 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2015   grade_7 193 2 4 0   3     1   2   100 105                       205 193 2 4 0   3     1   2   100 105                 205
740688 740688 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No 2 06 08 2015   grade_7 194 3 0 0   6     1   2   100 106                       206 194 3 0 0   6     1   2   100 106                 206
740876 740876 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No 2 07 08 2015   grade_7 240 2 0 1   4     1   2   129 121                       250 240 2 0 1   4     1   2   129 121                 250
741257 741257 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No 2 06 08 2015   grade_7 54 5 88 1   11     1   10   79 91                       170 54 5 88 1   11     1   10   79 91                 170
741703 741703 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2015   grade_7 126 2 8 0   18     1   5   83 77                       160 126 2 8 0   18     1   5   83 77                 160
741718 741718 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2015   grade_7 87 2 91 0   5     1   0   90 96                       186 87 2 91 0   5     1   0   90 96                 186

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