enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
737985 737985 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_8 2 1 3 0   0     0   1   6 1                       7 2 1 3 0   0     0   1   6 1                 7
739016 739016 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_8 1 0 18 0   0     0   0   17 2                       19 1 0 18 0   0     0   0   17 2                 19
738605 738605 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_8 * * * *   *     *   *   4 1                       5                         4 1                 5
736563 736563 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_8 7 45 46 0   0     0   0   56 42                       98 7 45 46 0   0     0   0   56 42                 98
738909 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
736742 736742 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_8 1 76 25 1   2     0   1   68 38                       106 1 76 25 1   2     0   1   68 38                 106
737141 737141 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_8 * * * *   *     *   *   3 1                       4                         3 1                 4
737618 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
738732 738732 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_8 8 4 85 0   2     0   1   52 48                       100 8 4 85 0   2     0   1   52 48                 100
739186 739186 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2015   grade_8 24 13 7 0   2     0   1   17 30                       47 24 13 7 0   2     0   1   17 30                 47
743713 743713 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2015   grade_8 39 3 5 0   0     0   0   28 19                       47 39 3 5 0   0     0   0   28 19                 47
743769 743769 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_8 2 28 5 0   0     1   1   16 21                       37 2 28 5 0   0     1   1   16 21                 37
735682 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
735707 735707 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_8 * * * *   *     *   *   2 3                       5                         2 3                 5
735729 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
735899 735899 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_8 121 5 10 0   7     0   7   80 70                       150 121 5 10 0   7     0   7   80 70                 150
735903 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
735907 735907 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2015   grade_8 102 8 21 1   3     0   4   72 67                       139 102 8 21 1   3     0   4   72 67                 139
736025 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
736059 736059 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_8 204 16 12 0   51     0   9   134 158                       292 204 16 12 0   51     0   9   134 158                 292
736073 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
736778 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
736978 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
737481 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
737485 737485 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_8 185 9 5 0   17     0   4   123 97                       220 185 9 5 0   17     0   4   123 97                 220
737511 737511 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_8 18 13 97 0   3     0   1   58 74                       132 18 13 97 0   3     0   1   58 74                 132
737515 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
737519 737519 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_8 9 15 130 0   3     0   0   88 69                       157 9 15 130 0   3     0   0   88 69                 157
737885 737885 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2015   grade_8 112 2 17 0   3     0   2   73 63                       136 112 2 17 0   3     0   2   73 63                 136
738172 738172 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_8 58 12 74 0   10     0   11   81 84                       165 58 12 74 0   10     0   11   81 84                 165
738182 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
738232 738232 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2015   grade_8 203 6 4 0   8     0   2   122 101                       223 203 6 4 0   8     0   2   122 101                 223
738534 738534 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2015   grade_8 227 1 2 0   5     0   0   138 97                       235 227 1 2 0   5     0   0   138 97                 235
738596 738596 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_8 70 3 42 0   0     0   0   60 55                       115 70 3 42 0   0     0   0   60 55                 115
738621 738621 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_8 88 5 19 0   3     0   2   74 43                       117 88 5 19 0   3     0   2   74 43                 117
738914 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
738931 738931 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2015   grade_8 2 2 118 0   4     0   0   53 73                       126 2 2 118 0   4     0   0   53 73                 126
738935 738935 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_8 9 2 136 0   1     0   3   76 75                       151 9 2 136 0   1     0   3   76 75                 151
738978 738978 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2015   grade_8 9 2 101 0   5     0   1   54 64                       118 9 2 101 0   5     0   1   54 64                 118
739334 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
739338 739338 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2015   grade_8 57 6 22 0   78     0   5   85 83                       168 57 6 22 0   78     0   5   85 83                 168
739347 739347 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No 2 05 08 2015   grade_8 44 29 65 0   31     0   4   86 87                       173 44 29 65 0   31     0   4   86 87                 173
739351 739351 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No 2 05 08 2015   grade_8 56 11 83 0   16     0   3   87 82                       169 56 11 83 0   16     0   3   87 82                 169
739355 739355 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No 2 05 08 2015   grade_8 57 10 59 1   42     0   4   92 81                       173 57 10 59 1   42     0   4   92 81                 173
739359 739359 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2015   grade_8 19 9 37 0   107     0   4   98 78                       176 19 9 37 0   107     0   4   98 78                 176
739555 739555 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2015   grade_8 170 0 12 0   6     0   5   111 82                       193 170 0 12 0   6     0   5   111 82                 193
739676 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
739827 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
739985 739985 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_8 95 2 2 1   1     0   0   42 59                       101 95 2 2 1   1     0   0   42 59                 101
740033 740033 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_8 93 0 1 0   1     0   3   54 44                       98 93 0 1 0   1     0   3   54 44                 98
740090 740090 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No 2 05 08 2015   grade_8 126 0 4 0   11     0   2   67 76                       143 126 0 4 0   11     0   2   67 76                 143
740094 740094 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2015   grade_8 190 11 15 0   10     0   8   132 102                       234 190 11 15 0   10     0   8   132 102                 234
740609 740609 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_8 170 3 7 0   0     0   5   90 95                       185 170 3 7 0   0     0   5   90 95                 185
740760 740760 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2015   grade_8 4 2 2 0   0     0   0   7 1                       8 4 2 2 0   0     0   0   7 1                 8
740766 740766 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2015   grade_8 134 4 9 0   4     0   9   81 79                       160 134 4 9 0   4     0   9   81 79                 160
741016 741016 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No 2 05 08 2015   grade_8 227 4 4 1   3     0   9   124 124                       248 227 4 4 1   3     0   9   124 124                 248
741123 741123 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No 2 05 08 2015   grade_8 36 9 6 1   10     0   4   42 24                       66 36 9 6 1   10     0   4   42 24                 66
741127 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
741302 741302 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2015   grade_8 147 7 18 0   0     0   7   100 79                       179 147 7 18 0   0     0   7   100 79                 179
741733 741733 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2015   grade_8 126 2 6 0   6     0   8   76 72                       148 126 2 6 0   6     0   8   76 72                 148
742054 742054 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No 2 05 08 2015   grade_8 160 2 9 0   4     0   4   89 90                       179 160 2 9 0   4     0   4   89 90                 179
742178 742178 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2015   grade_8 168 8 12 0   5     1   5   101 98                       199 168 8 12 0   5     1   5   101 98                 199
742356 742356 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2015   grade_8 214 7 4 0   8     1   6   119 121                       240 214 7 4 0   8     1   6   119 121                 240
742479 742479 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_8 142 13 9 1   2     0   22   108 81                       189 142 13 9 1   2     0   22   108 81                 189
743419 743419 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_8 15 9 71 0   6     0   1   52 50                       102 15 9 71 0   6     0   1   52 50                 102
743429 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
743501 743501 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_8 7 27 57 0   2     0   2   42 53                       95 7 27 57 0   2     0   2   42 53                 95
743524 743524 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_8 86 5 2 0   3     0   4   47 53                       100 86 5 2 0   3     0   4   47 53                 100
743640 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
743811 743811 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_8 80 1 2 0   4     0   1   40 48                       88 80 1 2 0   4     0   1   40 48                 88
743819 743819 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_8 2 90 60 0   0     0   4   75 81                       156 2 90 60 0   0     0   4   75 81                 156
743895 743895 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2015   grade_8 43 13 22 2   2     0   1   38 45                       83 43 13 22 2   2     0   1   38 45                 83
744040 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
744076 744076 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_8 94 3 3 0   0     0   4   52 52                       104 94 3 3 0   0     0   4   52 52                 104
744126 744126 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2015   grade_8 170 5 4 0   1     0   7   95 92                       187 170 5 4 0   1     0   7   95 92                 187
744218 744218 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2015   grade_8 80 0 0 0   2     0   3   54 31                       85 80 0 0 0   2     0   3   54 31                 85
744222 744222 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No 2 05 08 2015   grade_8 147 3 8 0   0     0   2   88 72                       160 147 3 8 0   0     0   2   88 72                 160
744250 744250 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2015   grade_8 127 4 14 0   4     0   8   80 77                       157 127 4 14 0   4     0   8   80 77                 157
744254 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
744336 744336 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_8 194 5 3 0   11     0   5   116 102                       218 194 5 3 0   11     0   5   116 102                 218
744406 744406 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No 2 05 08 2015   grade_8 58 0 5 0   1     0   4   39 29                       68 58 0 5 0   1     0   4   39 29                 68
744482 744482 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 05 08 2015   grade_8 201 1 6 0   2     0   5   109 106                       215 201 1 6 0   2     0   5   109 106                 215
744572 744572 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2015   grade_8 130 2 0 0   1     0   2   69 66                       135 130 2 0 0   1     0   2   69 66                 135
744639 744639 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2015   grade_8 132 1 5 0   1     0   4   65 78                       143 132 1 5 0   1     0   4   65 78                 143
744648 744648 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2015   grade_8 113 2 4 0   0     0   6   58 67                       125 113 2 4 0   0     0   6   58 67                 125
744826 744826 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_8 106 5 5 0   1     0   1   57 61                       118 106 5 5 0   1     0   1   57 61                 118
744969 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
735794 735794 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2015   grade_8 161 4 5 0   16     0   6   92 100                       192 161 4 5 0   16     0   6   92 100                 192
735797 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
735800 735800 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2015   grade_8 98 2 7 0   28     0   2   76 61                       137 98 2 7 0   28     0   2   76 61                 137
735851 735851 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2015   grade_8 266 18 21 0   41     0   23   169 200                       369 266 18 21 0   41     0   23   169 200                 369
735865 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
735929 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
735986 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
736114 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
736158 736158 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2015   grade_8 203 2 11 0   3     0   7   114 112                       226 203 2 11 0   3     0   7   114 112                 226
736161 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
736279 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
736418 736418 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2015   grade_8 11 71 103 0   16     0   2   98 105                       203 11 71 103 0   16     0   2   98 105                 203
736765 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

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