enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2016 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 493 ✖

grade ✖

  • grade_8 · 493 ✖
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
934014 934014 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_8 29 96 32 0   7     0   10   90 84                       174 29 96 32 0   7     0   10   90 84                 174
933634 933634 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2016   grade_8 3 92 85 0   12     1   3   96 100                       196 3 92 85 0   12     1   3   96 100                 196
933506 933506 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_8 1 9 15 1   0     0   0   18 8                       26 1 9 15 1   0     0   0   18 8                 26
935149 935149 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_8 109 9 71 0   18     1   10   115 103                       218 109 9 71 0   18     1   10   115 103                 218
935476 935476 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_8 130 9 90 0   5     0   1   113 122                       235 130 9 90 0   5     0   1   113 122                 235
936464 936464 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2016   grade_8 303 9 13 0   15     0   11   188 163                       351 303 9 13 0   15     0   11   188 163                 351
936520 936520 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_8 177 9 122 1   6     0   8   161 162                       323 177 9 122 1   6     0   8   161 162                 323
936800 936800 MA Worcester   school 2507860 185   Milford 250786002439 1850310 Milford Middle East   Regular School No 4 08 08 2016   grade_8 223 9 55 7   7     0   10   152 159                       311 223 9 55 7   7     0   10   152 159                 311
937945 937945 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2016   grade_8 63 9 2 0   16     1   4   49 46                       95 63 9 2 0   16     1   4   49 46                 95
938787 938787 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2016   grade_8 1 9 15 0   0     0   0   15 10                       25 1 9 15 0   0     0   0   15 10                 25
940283 940283 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2016   grade_8 95 9 16 0   13     0   0   63 70                       133 95 9 16 0   13     0   0   63 70                 133
940527 940527 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 08 2016   grade_8 2 9 21 0   2     0   1   15 20                       35 2 9 21 0   2     0   1   15 20                 35
940799 940799 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2016   grade_8 273 9 9 2   134     0   16   226 217                       443 273 9 9 2   134     0   16   226 217                 443
941601 941601 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2016   grade_8 299 9 1 0   5     1   2   160 157                       317 299 9 1 0   5     1   2   160 157                 317
933376 933376 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   grade_8 0 8 18 0   0     0   0   12 14                       26 0 8 18 0   0     0   0   12 14                 26
933516 933516 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   grade_8 4 8 18 0   3     0   1   20 14                       34 4 8 18 0   3     0   1   20 14                 34
933533 933533 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2016   grade_8 6 8 10 0   1     0   0   12 13                       25 6 8 10 0   1     0   0   12 13                 25
934102 934102 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_8 23 8 9 0   8     0   9   32 25                       57 23 8 9 0   8     0   9   32 25                 57
934708 934708 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_8 178 8 3 0   1     0   5   85 110                       195 178 8 3 0   1     0   5   85 110                 195
936032 936032 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2016   grade_8 21 8 7 0   2     1   4   17 26                       43 21 8 7 0   2     1   4   17 26                 43
937848 937848 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2016   grade_8 303 8 13 0   5     0   14   163 180                       343 303 8 13 0   5     0   14   163 180                 343
938054 938054 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2016   grade_8 87 8 75 1   6     0   6   90 93                       183 87 8 75 1   6     0   6   90 93                 183
938293 938293 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No 2 07 08 2016   grade_8 218 8 0 0   3     0   5   122 112                       234 218 8 0 0   3     0   5   122 112                 234
938657 938657 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_8 4 8 10 0   0     0   0   7 15                       22 4 8 10 0   0     0   0   7 15                 22
938784 938784 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2016   grade_8 4 8 62 0   0     0   0   35 39                       74 4 8 62 0   0     0   0   35 39                 74
939164 939164 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2016   grade_8 264 8 12 0   10     0   9   151 152                       303 264 8 12 0   10     0   9   151 152                 303
939635 939635 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No 2 06 08 2016   grade_8 216 8 43 0   15     0   7   152 137                       289 216 8 43 0   15     0   7   152 137                 289
940382 940382 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2016   grade_8 0 8 12 0   0     0   0   8 12                       20 0 8 12 0   0     0   0   8 12                 20
940819 940819 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_8 103 8 3 0   0     0   0   57 57                       114 103 8 3 0   0     0   0   57 57                 114
941088 941088 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2016   grade_8 168 8 1 1   8     0   7   88 105                       193 168 8 1 1   8     0   7   88 105                 193
933287 933287 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2016   grade_8 11 78 95 0   20     0   3   118 89                       207 11 78 95 0   20     0   3   118 89                 207
934020 934020 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2016   grade_8 60 78 14 0   5     0   3   90 70                       160 60 78 14 0   5     0   3   90 70                 160
940619 940619 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2016   grade_8 15 78 52 1   10     0   3   73 86                       159 15 78 52 1   10     0   3   73 86                 159
939057 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
940178 940178 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_8 73 74 145 0   29     0   12   159 174                       333 73 74 145 0   29     0   12   159 174                 333
933657 933657 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 05 08 2016   grade_8 3 71 50 0   0     0   7   78 53                       131 3 71 50 0   0     0   7   78 53                 131
932741 932741 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_8 137 7 29 2   20     0   4   98 101                       199 137 7 29 2   20     0   4   98 101                 199
932775 932775 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_8 135 7 13 0   6     0   6   93 74                       167 135 7 13 0   6     0   6   93 74                 167
932783 932783 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_8 90 7 22 0   1     0   8   67 61                       128 90 7 22 0   1     0   8   67 61                 128
933027 933027 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2016   grade_8 236 7 14 0   9     0   5   143 128                       271 236 7 14 0   9     0   5   143 128                 271
933188 933188 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2016   grade_8 5 7 14 0   0     0   0   15 11                       26 5 7 14 0   0     0   0   15 11                 26
933784 933784 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_8 12 7 120 1   3     0   0   84 59                       143 12 7 120 1   3     0   0   84 59                 143
933904 933904 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No 2 06 08 2016   grade_8 179 7 5 0   38     0   3   121 111                       232 179 7 5 0   38     0   3   121 111                 232
934449 934449 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No 2 06 08 2016   grade_8 136 7 71 0   3     0   3   119 101                       220 136 7 71 0   3     0   3   119 101                 220
934493 934493 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_8 119 7 2 0   7     0   0   63 72                       135 119 7 2 0   7     0   0   63 72                 135
934520 934520 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2016   grade_8 170 7 9 0   14     0   8   98 110                       208 170 7 9 0   14     0   8   98 110                 208
936005 936005 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2016   grade_8 146 7 10 0   120     0   15   147 151                       298 146 7 10 0   120     0   15   147 151                 298
936027 936027 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2016   grade_8 40 7 5 0   3     0   6   31 30                       61 40 7 5 0   3     0   6   31 30                 61
936185 936185 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2016   grade_8 48 7 29 0   80     0   5   93 76                       169 48 7 29 0   80     0   5   93 76                 169
936400 936400 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2016   grade_8 148 7 3 0   4     0   4   83 83                       166 148 7 3 0   4     0   4   83 83                 166
936487 936487 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No 2 07 08 2016   grade_8 213 7 15 0   6     0   9   125 125                       250 213 7 15 0   6     0   9   125 125                 250
937396 937396 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2016   grade_8 341 7 14 1   24     1   11   193 206                       399 341 7 14 1   24     1   11   193 206                 399
937873 937873 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   grade_8 2 7 1 0   0     0   1   4 7                       11 2 7 1 0   0     0   1   4 7                 11
938438 938438 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2016   grade_8 21 7 11 0   8     0   1   31 17                       48 21 7 11 0   8     0   1   31 17                 48
938467 938467 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2016   grade_8 31 7 6 0   3     0   0   32 15                       47 31 7 6 0   3     0   0   32 15                 47
938796 938796 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2016   grade_8 6 7 40 0   2     0   0   18 37                       55 6 7 40 0   2     0   0   18 37                 55
938945 938945 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2016   grade_8 268 7 4 1   18     0   18   176 140                       316 268 7 4 1   18     0   18   176 140                 316
940612 940612 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes 3 07 12 2016   grade_8 46 7 10 0   2     0   3   24 44                       68 46 7 10 0   2     0   3   24 44                 68
941590 941590 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2016   grade_8 98 7 7 1   1     0   7   69 52                       121 98 7 7 1   1     0   7   69 52                 121
938905 938905 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2016   grade_8 199 63 21 0   20     1   11   164 151                       315 199 63 21 0   20     1   11   164 151                 315
940181 940181 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_8 107 63 173 0   49     0   14   196 210                       406 107 63 173 0   49     0   14   196 210                 406
940286 940286 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2016   grade_8 0 62 12 0   0     0   2   39 37                       76 0 62 12 0   0     0   2   39 37                 76
932779 932779 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_8 107 6 27 2   5     1   4   71 81                       152 107 6 27 2   5     1   4   71 81                 152
934446 934446 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_8 158 6 116 0   4     0   7   150 141                       291 158 6 116 0   4     0   7   150 141                 291
934757 934757 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2016   grade_8 195 6 7 2   15     0   3   117 111                       228 195 6 7 2   15     0   3   117 111                 228
934810 934810 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_8 14 6 22 0   4     0   0   16 30                       46 14 6 22 0   4     0   0   16 30                 46
935143 935143 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2016   grade_8 121 6 33 0   3     0   6   79 90                       169 121 6 33 0   3     0   6   79 90                 169
935445 935445 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_8 81 6 46 0   0     0   1   64 70                       134 81 6 46 0   0     0   1   64 70                 134
935468 935468 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2016   grade_8 78 6 33 1   1     0   3   76 46                       122 78 6 33 1   1     0   3   76 46                 122
936570 936570 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_8 103 6 4 6   3     0   5   65 62                       127 103 6 4 6   3     0   5   65 62                 127
936734 936734 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2016   grade_8 85 6 42 0   5     0   1   69 70                       139 85 6 42 0   5     0   1   69 70                 139
936744 936744 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2016   grade_8 78 6 67 0   4     0   3   82 76                       158 78 6 67 0   4     0   3   82 76                 158
936754 936754 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2016   grade_8 68 6 65 1   4     0   3   71 76                       147 68 6 65 1   4     0   3   71 76                 147
937287 937287 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2016   grade_8 84 6 5 0   0     0   3   55 43                       98 84 6 5 0   0     0   3   55 43                 98
937956 937956 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2016   grade_8 31 6 4 0   31     0   7   43 36                       79 31 6 4 0   31     0   7   43 36                 79
939443 939443 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No 2 07 08 2016   grade_8 181 6 11 0   61     0   7   148 118                       266 181 6 11 0   61     0   7   148 118                 266
939828 939828 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2016   grade_8 259 6 14 1   67     0   15   166 196                       362 259 6 14 1   67     0   15   166 196                 362
939842 939842 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2016   grade_8 131 6 9 0   1     0   0   68 79                       147 131 6 9 0   1     0   0   68 79                 147
940167 940167 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2016   grade_8 6 6 83 0   8     0   3   51 55                       106 6 6 83 0   8     0   3   51 55                 106
940652 940652 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_8 41 6 20 0   4     0   0   33 38                       71 41 6 20 0   4     0   0   33 38                 71
940704 940704 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_8 78 6 9 0   1     0   5   35 64                       99 78 6 9 0   1     0   5   35 64                 99
940962 940962 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No 2 07 08 2016   grade_8 226 6 3 0   3     0   1   118 121                       239 226 6 3 0   3     0   1   118 121                 239
941077 941077 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2016   grade_8 142 6 13 2   1     0   2   92 74                       166 142 6 13 2   1     0   2   92 74                 166
941333 941333 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2016   grade_8 123 6 6 2   4     0   4   73 72                       145 123 6 6 2   4     0   4   73 72                 145
941783 941783 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2016   grade_8 199 6 15 0   6     0   11   122 115                       237 199 6 15 0   6     0   11   122 115                 237
933965 933965 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_8 17 58 23 2   0     0   5   49 56                       105 17 58 23 2   0     0   5   49 56                 105
937106 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
940173 940173 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2016   grade_8 94 55 101 1   11     0   6   129 139                       268 94 55 101 1   11     0   6   129 139                 268
933660 933660 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2016   grade_8 0 54 100 0   0     0   5   81 78                       159 0 54 100 0   0     0   5   81 78                 159
940175 940175 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_8 237 53 151 0   23     0   28   258 234                       492 237 53 151 0   23     0   28   258 234                 492
933611 933611 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_8 2 52 18 0   0     0   2   39 35                       74 2 52 18 0   0     0   2   39 35                 74
940250 940250 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 2016   grade_8 10 51 12 0   1     0   2   37 39                       76 10 51 12 0   1     0   2   37 39                 76
936864 936864 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2016   grade_8 172 50 21 1   19     1   9   141 132                       273 172 50 21 1   19     1   9   141 132                 273
932983 932983 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2016   grade_8 247 5 45 0   6     0   9   165 147                       312 247 5 45 0   6     0   9   165 147                 312
933442 933442 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2016   grade_8 7 5 15 0   0     0   1   14 14                       28 7 5 15 0   0     0   1   14 14                 28
933818 933818 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_8 0 5 5 0   1     0   0   5 6                       11 0 5 5 0   1     0   0   5 6                 11
933992 933992 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 4 06 12 2016   grade_8 1 5 1 0   0     0   0   5 2                       7 1 5 1 0   0     0   0   5 2                 7
934002 934002 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_8 1 5 1 0   0     0   0   6 1                       7 1 5 1 0   0     0   0   6 1                 7
934074 934074 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   grade_8 39 5 5 0   10     0   6   33 32                       65 39 5 5 0   10     0   6   33 32                 65
934478 934478 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_8 84 5 30 1   2     0   2   74 50                       124 84 5 30 1   2     0   2   74 50                 124

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