Data source: Big Local News · About: Big Local

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

View and edit SQL

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
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
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 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
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
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 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
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
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
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
1367583 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_8 36 1 5 0   3     3   3   27 24 *                     51.0 36 1 5 0   3     3   3   27 24                 51
1676900 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough - Robert E. Melican Middle School   Regular School No Middle 06 08 2021   grade_8 129 1 19 2   20     3   9   89 94 *                     183.0 129 1 19 2   20     3   9   89 94                 183
2233163 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg: Lunenburg Middle School   Regular School No Middle 06 08 2018   grade_8 122 4 13 2   2     3   1   80 67                       147.0 122 4 13 2   2     3   1   80 67                 147
2234577 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_8 180 3 5 1   22     3   7   117 104                       221.0 180 3 5 1   22     3   7   117 104                 221
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
736114 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2015   grade_8 235 11 25 0   5     2   5   133 150                       283 235 11 25 0   5     2   5   133 150                 283
736161 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No 2 06 08 2015   grade_8 192 1 6 0   10     2   3   114 100                       214 192 1 6 0   10     2   3   114 100                 214
736557 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_8 0 41 43 0   0     2   0   39 47                       86 0 41 43 0   0     2   0   39 47                 86
737154 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_8 50 86 26 0   2     2   7   88 85                       173 50 86 26 0   2     2   7   88 85                 173
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
738110 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_8 126 13 40 0   8     2   11   84 116                       200 126 13 40 0   8     2   11   84 116                 200
738342 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_8 134 0 6 0   6     2   2   73 77                       150 134 0 6 0   6     2   2   73 77                 150
934017 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2016   grade_8 65 119 31 1   8     2   8   120 114                       234 65 119 31 1   8     2   8   120 114                 234
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
935196 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2016   grade_8 140 0 3 0   8     2   7   81 79                       160 140 0 3 0   8     2   7   81 79                 160
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
937109 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2016   grade_8 218 28 101 1   1     2   18   192 177                       369 218 28 101 1   1     2   18   192 177                 369
937112 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2016   grade_8 125 27 94 1   2     2   7   131 127                       258 125 27 94 1   2     2   7   131 127                 258
937429 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2016   grade_8 169 3 8 1   20     2   4   120 87                       207 169 3 8 1   20     2   4   120 87                 207
937993 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2016   grade_8 24 133 27 1   30     2   4   107 114                       221 24 133 27 1   30     2   4   107 114                 221
939057 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_8 458 74 79 0   6     2   20   331 308                       639 458 74 79 0   6     2   20   331 308                 639
941839 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2016   grade_8 166 4 2 0   5     2   4   93 90                       183 166 4 2 0   5     2   4   93 90                 183
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
1122325 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_8 279 26 54 1   2     2   13   204 173                       377 279 26 54 1   2     2   13   204 173                 377
1123689 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2017   grade_8 54 109 28 1   5     2   9   106 102                       208 54 109 28 1   5     2   9   106 102                 208
1123960 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2017   grade_8 22 29 11 0   10     2   4   31 47                       78 22 29 11 0   10     2   4   31 47                 78
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
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
1131171 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 Middle 06 08 2017   grade_8 0 56 14 0   0     2   0   43 29                       72 0 56 14 0   0     2   0   43 29                 72
1131858 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_8 87 2 7 0   3     2   3   52 52                       104 87 2 7 0   3     2   3   52 52                 104
1365387 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_8 1 43 18 0   0     2   1   30 35 *                     65.0 1 43 18 0   0     2   1   30 35                 65
1367531 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2020   grade_8 201 5 16 2   28     2   6   130 130 *                     260.0 201 5 16 2   28     2   6   130 130                 260
1369101 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 07 12 2020   grade_8 55 0 8 0   2     2   3   36 34 *                     70.0 55 0 8 0   2     2   3   36 34                 70
1369653 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_8 148 8 14 0   21     2   11   96 108 *                     204.0 148 8 14 0   21     2   11   96 108                 204
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
1371143 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2020   grade_8 164 71 28 1   25     2   13   183 121 *                     304.0 164 71 28 1   25     2   13   183 121                 304
1372861 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_8 1 126 94 2   4     2   2   125 106 *                     231.0 1 126 94 2   4     2   2   125 106                 231
1373109 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_8 92 3 15 2   7     2   5   70 56 *                     126.0 92 3 15 2   7     2   5   70 56                 126
1672320 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_8 265 31 62 0   11     2   18   192 197 *                     389.0 265 31 62 0   11     2   18   192 197                 389
1672611 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_8 2 52 29 0   2     2   2   45 44 *                     89.0 2 52 29 0   2     2   2   45 44                 89
1673470 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_8 62 116 24 2   8     2   4   99 119 *                     218.0 62 116 24 2   8     2   4   99 119                 218
1676869 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough - North Attleborough Middle   Regular School No Middle 06 08 2021   grade_8 319 11 22 0   15     2   16   169 216 *                     385.0 319 11 22 0   15     2   16   169 216                 385
1677422 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy - Central Middle   Regular School No Middle 06 08 2021   grade_8 90 5 8 0   85     2   10   95 105 *                     200.0 90 5 8 0   85     2   10   95 105                 200
1677732 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus - Saugus Middle School   Regular School No Middle 06 08 2021   grade_8 136 8 44 1   11     2   4   112 94 *                     206.0 136 8 44 1   11     2   4   112 94                 206
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
1680288 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough - Raymond J Grey Junior High   Regular School No Middle 07 08 2021   grade_8 202 14 28 2   159     2   14   212 208 *                     421.0 202 14 28 2   159     2   14   212 208                 421
2040607 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_8 4 35 15 0   2     2   3   32 29                       61.0 4 35 15 0   2     2   3   32 29                 61
2041025 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_8 191 29 54 0   113     2   18   190 217                       407.0 191 29 54 0   113     2   18   190 217                 407
2044726 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2019   grade_8 154 5 13 1   13     2   9   107 90                       197.0 154 5 13 1   13     2   9   107 90                 197
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
2230495 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_8 20 164 23 0   3     2   4   111 105                       216.0 20 164 23 0   3     2   4   111 105                 216
2231912 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   grade_8 144 0 4 0   6     2   1   82 75                       157.0 144 0 4 0   6     2   1   82 75                 157
2233903 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Milton: Charles S Pierce Middle   Regular School No Middle 06 08 2018   grade_8 198 41 16 2   16     2   11   141 145                       286.0 198 41 16 2   16     2   11   141 145                 286
2233921 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Monson: Granite Valley Middle   Regular School No Middle 05 08 2018   grade_8 91 1 1 0   0     2   3   54 44                       98.0 91 1 1 0   0     2   3   54 44                 98
2234744 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs: Oak Bluffs Elementary   Regular School No Elementary PK 08 2018   grade_8 14 6 8 0   0     2   0   21 9                       30.0 14 6 8 0   0     2   0   21 9                 30
2234781 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford: Oxford High   Regular School No High 08 12 2018   grade_8 111 4 12 1   1     2   6   61 76                       137.0 111 4 12 1   1     2   6   61 76                 137
2236881 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster: Webster Middle School   Regular School No Middle 05 08 2018   grade_8 91 12 36 0   3     2   10   70 84                       154.0 91 12 36 0   3     2   10   70 84                 154
2238358 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_8 8 71 56 1   8     2   7   84 69                       153.0 8 71 56 1   8     2   7   84 69                 153
2239301 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba: Luther Burbank Middle School   Regular School No Middle 06 08 2018   grade_8 69 3 3 0   0     2   5   38 44                       82.0 69 3 3 0   0     2   5   38 44                 82
735667 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2015   grade_8 131 6 7 0   4     1   0   74 75                       149 131 6 7 0   4     1   0   74 75                 149
735903 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_8 102 8 27 0   2     1   6   82 64                       146 102 8 27 0   2     1   6   82 64                 146
735986 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2015   grade_8 129 12 8 0   15     1   15   96 84                       180 129 12 8 0   15     1   15   96 84                 180
736726 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_8 0 14 8 0   0     1   1   14 10                       24 0 14 8 0   0     1   1   14 10                 24
736765 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2015   grade_8 3 104 105 0   3     1   5   126 95                       221 3 104 105 0   3     1   5   126 95                 221
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
736793 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2015   grade_8 3 72 110 0   0     1   0   74 112                       186 3 72 110 0   0     1   0   74 112                 186
737148 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2015   grade_8 22 101 17 0   1     1   8   71 79                       150 22 101 17 0   1     1   8   71 79                 150
737400 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2015   grade_8 30 33 9 1   13     1   7   54 40                       94 30 33 9 1   13     1   7   54 40                 94
737903 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2015   grade_8 190 12 13 0   7     1   0   114 109                       223 190 12 13 0   7     1   0   114 109                 223
737982 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_8 35 12 31 1   10     1   1   44 47                       91 35 12 31 1   10     1   1   44 47                 91
738120 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_8 9 0 2 0   0     1   1   10 *                       13 9 0 2 0   0     1   1   10                   13
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
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
738500 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_8 43 4 7 0   1     1   1   25 32                       57 43 4 7 0   1     1   1   25 32                 57
738591 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_8 109 9 17 0   2     1   0   64 74                       138 109 9 17 0   2     1   0   64 74                 138
739049 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_8 118 5 7 0   2     1   0   68 65                       133 118 5 7 0   2     1   0   68 65                 133
739196 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2015   grade_8 104 1 1 0   1     1   4   48 64                       112 104 1 1 0   1     1   4   48 64                 112
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
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
739716 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2015   grade_8 331 1 6 1   3     1   3   170 176                       346 331 1 6 1   3     1   3   170 176                 346
739766 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2015   grade_8 193 3 3 0   10     1   3   110 103                       213 193 3 3 0   10     1   3   110 103                 213
739801 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No 2 06 08 2015   grade_8 117 28 18 0   8     1   4   91 85                       176 117 28 18 0   8     1   4   91 85                 176
739827 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2015   grade_8 184 2 3 0   6     1   4   98 102                       200 184 2 3 0   6     1   4   98 102                 200
739865 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No 2 06 08 2015   grade_8 254 14 11 0   4     1   5   150 139                       289 254 14 11 0   4     1   5   150 139                 289
739899 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2015   grade_8 87 4 60 0   3     1   2   79 78                       157 87 4 60 0   3     1   2   79 78                 157
740017 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2015   grade_8 191 57 14 0   15     1   11   125 164                       289 191 57 14 0   15     1   11   125 164                 289
740738 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_8 20 0 2 1   0     1   1   16 9                       25 20 0 2 1   0     1   1   16 9                 25
741113 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2015   grade_8 66 5 5 0   102     1   3   98 84                       182 66 5 5 0   102     1   3   98 84                 182
741119 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_8 127 7 5 0   50     1   5   101 94                       195 127 7 5 0   50     1   5   101 94                 195
741127 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2015   grade_8 57 7 8 0   21     1   5   50 49                       99 57 7 8 0   21     1   5   50 49                 99
741444 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No 2 06 08 2015   grade_8 208 4 16 1   8     1   1   116 123                       239 208 4 16 1   8     1   1   116 123                 239

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