Data source: Big Local News · About: Big Local

489 rows where grade = "grade_8", state = "MA" and year = 2015 sorted by school

View and edit SQL

year

  • 2015 · 489

grade

  • grade_8 · 489
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
739676 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_8 190 7 141 0   5     0   6   177 172                       349 190 7 141 0   5     0   6   177 172                 349
738212 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_8 10 0 1 0   0     0   0   4 7                       11 10 0 1 0   0     0   0   4 7                 11
743610 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_8 30 42 25 0   7     1   4   68 41                       109 30 42 25 0   7     1   4   68 41                 109
743429 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 4 05 12 2015   grade_8 10 41 20 0   2     0   5   37 41                       78 10 41 20 0   2     0   5   37 41                 78
743508 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_8 99 4 2 2   26     0   12   62 83                       145 99 4 2 2   26     0   12   62 83                 145
735709 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No 2 07 08 2015   grade_8 280 5 21 0   6     0   5   161 156                       317 280 5 21 0   6     0   5   161 156                 317
735682 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_8 114 0 0 0   1     0   0   55 60                       115 114 0 0 0   1     0   0   55 60                 115
741645 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   grade_8 18 4 16 0   3     0   0   23 18                       41 18 4 16 0   3     0   0   23 18                 41
738909 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_8 4 3 84 0   1     0   1   47 46                       93 4 3 84 0   1     0   1   47 46                 93
741851 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_8 4 4 15 0   0     0   2   16 9                       25 4 4 15 0   0     0   2   16 9                 25
735729 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_8 159 6 8 0   0     0   7   105 75                       180 159 6 8 0   0     0   7   105 75                 180
743992 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No 2 07 08 2015   grade_8 142 14 38 1   25     0   20   125 115                       240 142 14 38 1   25     0   20   125 115                 240
737318 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   grade_8 8 2 13 0   0     0   1   8 16                       24 8 2 13 0   0     0   1   8 16                 24
735797 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2015   grade_8 155 4 5 0   22     0   7   92 101                       193 155 4 5 0   22     0   7   92 101                 193
738339 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2015   grade_8 150 2 1 1   3     0   2   77 82                       159 150 2 1 1   3     0   2   77 82                 159
738914 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_8 3 2 125 0   0     0   0   63 67                       130 3 2 125 0   0     0   0   63 67                 130
741625 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   grade_8 16 10 19 0   1     0   0   23 23                       46 16 10 19 0   1     0   0   23 23                 46
738182 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_8 31 11 53 0   7     0   10   50 62                       112 31 11 53 0   7     0   10   50 62                 112
741203 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2015   grade_8 145 3 1 0   10     0   0   83 76                       159 145 3 1 0   10     0   0   83 76                 159
737160 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2015   grade_8 63 80 9 2   3     0   4   86 75                       161 63 80 9 2   3     0   4   86 75                 161
735865 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2015   grade_8 140 4 18 0   11     0   2   86 89                       175 140 4 18 0   11     0   2   86 89                 175
744040 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_8 89 1 5 0   0     0   4   53 46                       99 89 1 5 0   0     0   4   53 46                 99
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
743874 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_8 86 3 5 0   3     0   3   44 56                       100 86 3 5 0   3     0   3   44 56                 100
735929 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_8 174 4 11 0   12     0   4   109 96                       205 174 4 11 0   12     0   4   109 96                 205
735945 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2015   grade_8 37 16 4 0   2     0   1   33 27                       60 37 16 4 0   2     0   1   33 27                 60
744062 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2015   grade_8 119 6 14 0   3     0   6   74 74                       148 119 6 14 0   3     0   6   74 74                 148
737129 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 3 07 12 2015   grade_8 0 4 1 0   0     0   1   5 1                       6 0 4 1 0   0     0   1   5 1                 6
739334 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2015   grade_8 54 7 39 0   38     0   5   83 60                       143 54 7 39 0   38     0   5   83 60                 143
741982 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2015   grade_8 5 4 24 0   1     0   0   23 11                       34 5 4 24 0   1     0   0   23 11                 34
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
739330 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2015   grade_8 14 6 15 0   19     0   1   25 30                       55 14 6 15 0   19     0   1   25 30                 55
742554 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett Jr Sr High School   Regular School No 3 07 12 2015   grade_8 120 6 23 1   4     0   6   82 78                       160 120 6 23 1   4     0   6   82 78                 160
745148 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_8 5 21 42 0   0     0   2   29 41                       70 5 21 42 0   0     0   2   29 41                 70
739568 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2015   grade_8 43 17 8 1   25     0   4   51 47                       98 43 17 8 1   25     0   4   51 47                 98
737586 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_8 151 6 98 1   7     0   6   124 145                       269 151 6 98 1   7     0   6   124 145                 269
736025 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial Middle School   Regular School No 2 05 08 2015   grade_8 154 3 2 1   6     0   1   92 75                       167 154 3 2 1   6     0   1   92 75                 167
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
743636 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_8 39 0 0 0   11     0   1   21 30                       51 39 0 0 0   11     0   1   21 30                 51
736073 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2015   grade_8 85 0 4 0   0     0   2   45 46                       91 85 0 4 0   0     0   2   45 46                 91
743442 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_8 46 11 6 0   3     0   3   35 34                       69 46 11 6 0   3     0   3   35 34                 69
740399 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2015   grade_8 115 12 16 0   29     0   7   89 90                       179 115 12 16 0   29     0   7   89 90                 179
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
742397 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No 2 06 08 2015   grade_8 157 6 9 0   1     0   2   88 87                       175 157 6 9 0   1     0   2   88 87                 175
742749 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2015   grade_8 160 1 3 0   37     0   5   97 109                       206 160 1 3 0   37     0   5   97 109                 206
743640 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_8 53 20 17 0   3     0   1   39 55                       94 53 20 17 0   3     0   1   39 55                 94
736875 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_8 218 28 40 0   111     0   15   180 232                       412 218 28 40 0   111     0   15   180 232                 412
736855 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_8 81 60 68 3   58     0   8   117 161                       278 81 60 68 3   58     0   8   117 161                 278
736774 MA Suffolk   school 2502790 35   Boston 250279001615 350413 Boston Middle School Academy   Regular School No 2 07 08 2015   grade_8 0 5 2 0   0     0   0   5 *                       7 0 5 2 0   0     0   0   5                   7
743453 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_8 2 44 11 0   1     0   0   32 26                       58 2 44 11 0   1     0   0   32 26                 58
736206 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2015   grade_8 8 25 22 0   0     0   1   24 32                       56 8 25 22 0   0     0   1   24 32                 56
736978 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_8 151 1 5 1   0     0   8   75 91                       166 151 1 5 1   0     0   8   75 91                 166
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
744128 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No 2 07 08 2015   grade_8 260 7 7 0   3     0   15   146 146                       292 260 7 7 0   3     0   15   146 146                 292
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
741116 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2015   grade_8 78 6 8 0   19     0   4   63 52                       115 78 6 8 0   19     0   4   63 52                 115
738549 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_8 83 4 3 0   12     0   1   56 47                       103 83 4 3 0   12     0   1   56 47                 103
743591 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2015   grade_8 0 18 6 0   0     0   0   14 10                       24 0 18 6 0   0     0   0   14 10                 24
743497 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_8 0 26 9 0   0     0   0   15 20                       35 0 26 9 0   0     0   0   15 20                 35
743364 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2015   grade_8 112 42 113 1   14     0   11   157 136                       293 112 42 113 1   14     0   11   157 136                 293
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
737391 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2015   grade_8 29 25 11 0   10     0   4   44 35                       79 29 25 11 0   10     0   4   44 35                 79
738289 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2015   grade_8 121 10 32 0   4     0   8   92 83                       175 121 10 32 0   4     0   8   92 83                 175
743520 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2015   grade_8 73 1 0 0   1     0   5   42 38                       80 73 1 0 0   1     0   5   42 38                 80
737441 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   grade_8 69 1 0 0   10     0   6   47 39                       86 69 1 0 0   10     0   6   47 39                 86
736238 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 3 07 12 2015   grade_8 * * * *   *     *   *   3 2                       5                         3 2                 5
737451 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_8 119 2 0 0   0     0   1   67 55                       122 119 2 0 0   0     0   1   67 55                 122
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
744965 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2015   grade_8 148 0 5 0   5     0   2   70 90                       160 148 0 5 0   5     0   2   70 90                 160
740402 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2015   grade_8 159 13 12 2   44     0   10   124 116                       240 159 13 12 2   44     0   10   124 116                 240
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
744254 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2015   grade_8 176 0 9 0   3     0   3   98 93                       191 176 0 9 0   3     0   3   98 93                 191
741985 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2015   grade_8 6 10 89 0   1     0   0   54 52                       106 6 10 89 0   1     0   0   54 52                 106
741988 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2015   grade_8 7 13 65 0   0     0   2   46 41                       87 7 13 65 0   0     0   2   46 41                 87
741991 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2015   grade_8 16 16 45 0   11     1   6   54 41                       95 16 16 45 0   11     1   6   54 41                 95
737549 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_8 4 0 8 0   0     0   0   9 3                       12 4 0 8 0   0     0   0   9 3                 12
744969 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2015   grade_8 105 0 4 0   4     0   0   57 56                       113 105 0 4 0   4     0   0   57 56                 113
743465 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_8 83 9 14 2   10     0   3   55 66                       121 83 9 14 2   10     0   3   55 66                 121
743358 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_8 8 15 67 0   6     0   2   35 63                       98 8 15 67 0   6     0   2   35 63                 98
736784 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2015   grade_8 11 16 121 0   18     0   2   97 71                       168 11 16 121 0   18     0   2   97 71                 168
737515 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_8 9 4 126 0   1     0   1   75 66                       141 9 4 126 0   1     0   1   75 66                 141
737608 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_8 24 0 1 0   0     0   1   12 14                       26 24 0 1 0   0     0   1   12 14                 26
737618 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_8 97 4 31 0   4     0   0   61 75                       136 97 4 31 0   4     0   0   61 75                 136
737634 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_8 126 4 1 0   2     0   0   61 72                       133 126 4 1 0   2     0   0   61 72                 133
737481 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No 2 05 08 2015   grade_8 140 1 10 0   13     0   7   93 78                       171 140 1 10 0   13     0   7   93 78                 171
741381 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2015   grade_8 90 19 66 0   5     0   12   100 92                       192 90 19 66 0   5     0   12   100 92                 192
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
743569 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_8 3 3 38 0   1     0   0   25 20                       45 3 3 38 0   1     0   0   25 20                 45
739889 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2015   grade_8 90 0 45 0   5     0   3   93 50                       143 90 0 45 0   5     0   3   93 50                 143
737661 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_8 185 10 14 0   20     0   12   111 130                       241 185 10 14 0   20     0   12   111 130                 241
738630 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_8 118 5 90 0   6     0   1   113 107                       220 118 5 90 0   6     0   1   113 107                 220
743559 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_8 1 8 2 0   1     0   0   5 7                       12 1 8 2 0   1     0   0   5 7                 12
736232 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2015   grade_8 1 31 78 1   1     0   2   62 52                       114 1 31 78 1   1     0   2   62 52                 114
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
740056 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No 2 06 08 2015   grade_8 71 12 19 0   1     0   5   56 52                       108 71 12 19 0   1     0   5   56 52                 108
743094 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2015   grade_8 149 6 14 0   12     1   6   90 98                       188 149 6 14 0   12     1   6   90 98                 188
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
736279 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_8 1 43 24 0   0     0   2   33 37                       70 1 43 24 0   0     0   2   33 37                 70
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
744200 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_8 169 19 21 2   8     0   18   111 126                       237 169 19 21 2   8     0   18   111 126                 237

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