Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017 sorted by school

View and edit SQL

year

  • 2017 · 490

grade

  • grade_8 · 490
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
1126678 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_8 152 7 146 0   5     0   8   167 151                       318 152 7 146 0   5     0   8   167 151                 318
1131334 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_8 23 50 32 1   7     0   2   51 64                       115 23 50 32 1   7     0   2   51 64                 115
1131128 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_8 4 53 20 0   1     0   1   40 39                       79 4 53 20 0   1     0   1   40 39                 79
1131224 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_8 101 1 10 0   32     0   5   73 76                       149 101 1 10 0   32     0   5   73 76                 149
1122009 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   grade_8 278 3 19 0   1     0   8   147 162                       309 278 3 19 0   1     0   8   147 162                 309
1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1128974 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_8 19 3 13 0   2     0   0   17 20                       37 19 3 13 0   2     0   0   17 20                 37
1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1129217 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_8 8 8 8 0   1     0   1   13 13                       26 8 8 8 0   1     0   1   13 13                 26
1122033 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_8 142 4 11 1   2     0   10   91 79                       170 142 4 11 1   2     0   10   91 79                 170
1131766 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2017   grade_8 121 16 41 0   16     1   23   100 118                       218 121 16 41 0   16     1   23   100 118                 218
1123872 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_8 10 2 13 0   0     0   2   8 19                       27 10 2 13 0   0     0   2   8 19                 27
1122113 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2017   grade_8 138 2 6 0   29     0   3   86 92                       178 138 2 6 0   29     0   3   86 92                 178
1125083 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_8 141 3 0 0   7     0   1   77 75                       152 141 3 0 0   7     0   1   77 75                 152
1133165 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_8 65 17 16 0   1     0   4   57 46                       103 65 17 16 0   1     0   4   57 46                 103
1125788 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_8 2 1 143 0   0     0   0   73 73                       146 2 1 143 0   0     0   0   73 73                 146
1128952 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_8 11 5 18 0   4     0   2   21 19                       40 11 5 18 0   4     0   2   21 19                 40
1124895 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_8 28 8 61 0   3     0   11   62 49                       111 28 8 61 0   3     0   11   62 49                 111
1128469 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2017   grade_8 148 2 2 0   5     0   5   83 79                       162 148 2 2 0   5     0   5   83 79                 162
1123693 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2017   grade_8 63 72 11 0   1     1   7   77 78                       155 63 72 11 0   1     1   7   77 78                 155
1122196 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_8 144 4 27 0   19     0   8   97 105                       202 144 4 27 0   19     0   8   97 105                 202
1131816 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_8 99 0 9 0   0     0   4   60 52                       112 99 0 9 0   0     0   4   60 52                 112
1128362 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2017   grade_8 68 6 2 2   82     0   2   75 87                       162 68 6 2 2   82     0   2   75 87                 162
1131621 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_8 86 4 5 0   3     0   1   48 51                       99 86 4 5 0   3     0   1   48 51                 99
1122273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_8 181 4 5 1   12     0   5   97 111                       208 181 4 5 1   12     0   5   97 111                 208
1122291 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_8 34 20 2 1   3     0   1   33 28                       61 34 20 2 1   3     0   1   33 28                 61
1131841 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_8 91 6 12 2   5     0   13   62 67                       129 91 6 12 2   5     0   13   62 67                 129
1126268 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_8 52 8 37 0   40     0   0   63 74                       137 52 8 37 0   40     0   0   63 74                 137
1129371 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2017   grade_8 2 6 20 0   0     0   0   21 7                       28 2 6 20 0   0     0   0   21 7                 28
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
1126263 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_8 12 4 22 0   17     0   4   38 21                       59 12 4 22 0   17     0   4   38 21                 59
1133119 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_8 3 18 57 0   1     0   1   36 44                       80 3 18 57 0   1     0   1   36 44                 80
1126549 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_8 30 12 13 0   24     1   4   43 41                       84 30 12 13 0   24     1   4   43 41                 84
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
1122385 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2017   grade_8 163 4 7 0   8     0   3   109 76                       185 163 4 7 0   8     0   3   109 76                 185
1128740 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2017   grade_8 168 7 32 1   8     1   3   121 99                       220 168 7 32 1   8     1   3   121 99                 220
1131362 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 29 0 1 0   14     0   2   32 14                       46 29 0 1 0   14     0   2   32 14                 46
1122440 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_8 93 1 1 0   1     0   3   44 55                       99 93 1 1 0   1     0   3   44 55                 99
1131143 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_8 50 14 2 0   0     0   1   35 31                       67 50 14 2 0   0     0   1   35 31                 67
1127527 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_8 96 15 12 2   27     1   10   77 86                       163 96 15 12 2   27     1   10   77 86                 163
1124561 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2017   grade_8 165 2 9 0   10     1   2   94 95                       189 165 2 9 0   10     1   2   94 95                 189
1129883 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2017   grade_8 136 10 11 1   2     0   2   82 80                       162 136 10 11 1   2     0   2   82 80                 162
1130299 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_8 142 2 1 2   57     0   5   97 112                       209 142 2 1 2   57     0   5   97 112                 209
1123455 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_8 0 2 5 0   0     0   0   5 2                       7 0 2 5 0   0     0   0   5 2                 7
1131367 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_8 35 28 17 1   2     0   1   38 46                       84 35 28 17 1   2     0   1   38 46                 84
1131119 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_8 6 31 17 0   0     0   4   28 30                       58 6 31 17 0   0     0   4   28 30                 58
1123361 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2017   grade_8 195 21 37 2   117     0   15   186 201                       387 195 21 37 2   117     0   15   186 201                 387
1123336 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_8 87 51 60 1   64     0   6   113 156                       269 87 51 60 1   64     0   6   113 156                 269
1131151 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_8 2 47 17 0   0     0   1   35 32                       67 2 47 17 0   0     0   1   35 32                 67
1122598 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_8 5 10 16 0   2     0   2   17 18                       35 5 10 16 0   2     0   2   17 18                 35
1123477 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_8 162 4 7 1   5     0   12   104 87                       191 162 4 7 1   5     0   12   104 87                 191
1126487 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_8 52 42 252 1   39     0   11   219 178                       397 52 42 252 1   39     0   11   219 178                 397
1131921 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2017   grade_8 228 12 3 0   2     0   9   122 132                       254 228 12 3 0   2     0   9   122 132                 254
1122489 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No Middle 06 08 2017   grade_8 262 10 37 0   10     0   9   170 158                       328 262 10 37 0   10     0   9   170 158                 328
1128366 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2017   grade_8 90 8 5 1   22     0   6   69 63                       132 90 8 5 1   22     0   6   69 63                 132
1125356 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_8 83 3 2 0   11     0   4   57 46                       103 83 3 2 0   11     0   4   57 46                 103
1131208 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_8 7 57 35 1   2     0   3   49 56                       105 7 57 35 1   2     0   3   49 56                 105
1131032 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_8 73 55 116 1   11     0   12   129 139                       268 73 55 116 1   11     0   12   129 139                 268
1125407 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_8 96 4 26 0   3     0   1   68 62                       130 96 4 26 0   3     0   1   68 62                 130
1123956 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2017   grade_8 33 28 10 1   8     0   3   44 39                       83 33 28 10 1   8     0   3   44 39                 83
1125022 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_8 120 17 40 0   2     0   7   97 89                       186 120 17 40 0   2     0   7   97 89                 186
1131240 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   grade_8 70 0 5 0   1     0   4   32 48                       80 70 0 5 0   1     0   4   32 48                 80
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
1124028 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_8 150 0 1 0   0     1   3   79 76                       155 150 0 1 0   0     1   3   79 76                 155
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
1132898 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2017   grade_8 130 4 6 0   3     0   2   78 67                       145 130 4 6 0   3     0   2   78 67                 145
1127531 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_8 166 10 14 1   51     0   10   142 110                       252 166 10 14 1   51     0   10   142 110                 252
1127086 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2017   grade_8 201 56 14 1   15     1   11   157 142                       299 201 56 14 1   15     1   11   157 142                 299
1132070 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_8 178 1 19 0   1     0   6   105 100                       205 178 1 19 0   1     0   6   105 100                 205
1129375 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_8 4 6 89 1   1     0   0   63 38                       101 4 6 89 1   1     0   0   63 38                 101
1129379 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_8 1 11 89 0   0     0   0   54 47                       101 1 11 89 0   0     0   0   54 47                 101
1129383 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2017   grade_8 10 8 50 0   2     0   2   27 45                       72 10 8 50 0   2     0   2   27 45                 72
1124148 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_8 4 1 8 0   0     0   0   9 4                       13 4 1 8 0   0     0   0   9 4                 13
1132903 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_8 85 1 4 0   1     0   0   56 35                       91 85 1 4 0   1     0   0   56 35                 91
1131167 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   grade_8 80 9 22 1   8     0   7   70 57                       127 80 9 22 1   8     0   7   70 57                 127
1131025 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2017   grade_8 5 4 61 0   6     0   1   45 32                       77 5 4 61 0   6     0   1   45 32                 77
1123260 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2017   grade_8 15 17 85 0   10     0   1   70 58                       128 15 17 85 0   10     0   1   70 58                 128
1124107 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_8 8 5 104 0   3     0   2   66 56                       122 8 5 104 0   3     0   2   66 56                 122
1124215 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_8 16 0 0 0   0     0   0   6 10                       16 16 0 0 0   0     0   0   6 10                 16
1124227 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_8 93 12 28 0   2     0   4   70 69                       139 93 12 28 0   2     0   4   70 69                 139
1131273 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_8 1 17 5 0   0     0   0   8 15                       23 1 17 5 0   0     0   0   8 15                 23
1124246 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_8 126 3 0 0   5     0   0   68 66                       134 126 3 0 0   5     0   0   68 66                 134
1124063 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_8 153 6 6 0   21     0   4   103 87                       190 153 6 6 0   21     0   4   103 87                 190
1128672 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2017   grade_8 98 10 67 0   4     0   5   101 83                       184 98 10 67 0   4     0   5   101 83                 184
1131253 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes Other 06 12 2017   grade_8 3 39 12 0   3     0   0   29 28                       57 3 39 12 0   3     0   0   29 28                 57
1131299 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_8 2 0 44 0   0     0   0   24 22                       46 2 0 44 0   0     0   0   24 22                 46
1126934 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_8 83 0 48 0   7     0   5   72 71                       143 83 0 48 0   7     0   5   72 71                 143
1124277 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_8 184 11 12 0   14     0   6   118 109                       227 184 11 12 0   14     0   6   118 109                 227
1125450 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_8 134 7 86 0   3     0   2   120 112                       232 134 7 86 0   3     0   2   120 112                 232
1131288 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_8 1 16 4 0   0     0   1   11 11                       22 1 16 4 0   0     0   1   11 11                 22
1129387 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No Other 06 11 2017   grade_8 11 20 26 0   0     0   1   12 46                       58 11 20 26 0   0     0   1   12 46                 58
1122630 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_8 0 18 67 0   0     0   0   40 45                       85 0 18 67 0   0     0   0   40 45                 85
1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
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
1127130 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2017   grade_8 65 15 19 0   2     1   3   56 49                       105 65 15 19 0   2     1   3   56 49                 105
1130724 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_8 122 8 13 0   8     0   3   75 79                       154 122 8 13 0   8     0   3   75 79                 154
1124358 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2017   grade_8 304 5 6 0   2     0   14   155 176                       331 304 5 6 0   2     0   14   155 176                 331
1122687 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_8 1 33 17 0   0     0   2   28 25                       53 1 33 17 0   0     0   2   28 25                 53
1124394 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2017   grade_8 161 14 26 0   5     0   9   110 105                       215 161 14 26 0   5     0   9   110 105                 215
1122702 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_8 5 24 20 0   0     0   2   18 33                       51 5 24 20 0   0     0   2   18 33                 51

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