enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2016 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
934021 934021 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2016   grade_6 49 98 59 0   4     1   17   103 125                       228 49 98 59 0   4     1   17   103 125                 228
934012 934012 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_6 53 95 27 0   4     1   9   95 94                       189 53 95 27 0   4     1   9   95 94                 189
932926 932926 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2016   grade_6 245 9 15 0   53     0   19   171 170                       341 245 9 15 0   53     0   19   171 170                 341
933782 933782 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_6 20 9 132 1   6     0   2   86 84                       170 20 9 132 1   6     0   2   86 84                 170
934444 934444 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_6 153 9 101 0   6     0   5   144 130                       274 153 9 101 0   6     0   5   144 130                 274
934808 934808 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_6 14 9 38 0   4     0   1   31 35                       66 14 9 38 0   4     0   1   31 35                 66
937846 937846 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2016   grade_6 292 9 10 0   3     0   15   181 148                       329 292 9 10 0   3     0   15   181 148                 329
938199 938199 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2016   grade_6 84 9 53 0   5     0   9   91 69                       160 84 9 53 0   5     0   9   91 69                 160
938337 938337 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No 2 06 08 2016   grade_6 188 9 13 1   83     0   12   162 144                       306 188 9 13 1   83     0   12   162 144                 306
939347 939347 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2016   grade_6 128 9 6 0   40     1   9   100 93                       193 128 9 6 0   40     1   9   100 93                 193
939361 939361 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No 2 05 08 2016   grade_6 102 9 33 1   3     1   13   71 91                       162 102 9 33 1   3     1   13   71 91                 162
939674 939674 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2016   grade_6 211 9 9 0   33     0   5   125 142                       267 211 9 9 0   33     0   5   125 142                 267
939916 939916 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_6 2 9 24 0   4     0   0   19 20                       39 2 9 24 0   4     0   0   19 20                 39
940122 940122 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   grade_6 19 9 7 0   0     0   4   16 23                       39 19 9 7 0   0     0   4   16 23                 39
940617 940617 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_6 11 83 60 1   11     2   7   93 82                       175 11 83 60 1   11     2   7   93 82                 175
933336 933336 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2016   grade_6 34 8 9 0   4     0   2   31 26                       57 34 8 9 0   4     0   2   31 26                 57
933374 933374 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   grade_6 0 8 19 0   0     0   1   16 12                       28 0 8 19 0   0     0   1   16 12                 28
933514 933514 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   grade_6 5 8 27 0   5     0   0   20 25                       45 5 8 27 0   5     0   0   20 25                 45
934091 934091 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2016   grade_6 45 8 7 0   22     0   3   43 42                       85 45 8 7 0   22     0   3   43 42                 85
934369 934369 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2016   grade_6 7 8 111 1   3     0   2   71 61                       132 7 8 111 1   3     0   2   71 61                 132
934377 934377 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2016   grade_6 6 8 111 0   4     0   0   66 63                       129 6 8 111 0   4     0   0   66 63                 129
935443 935443 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_6 74 8 39 0   2     0   1   59 65                       124 74 8 39 0   2     0   1   59 65                 124
936462 936462 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2016   grade_6 272 8 11 0   18     0   14   166 157                       323 272 8 11 0   18     0   14   166 157                 323
936797 936797 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_6 202 8 69 3   6     0   10   165 133                       298 202 8 69 3   6     0   10   165 133                 298
937233 937233 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2016   grade_6 118 8 13 2   26     0   12   84 95                       179 118 8 13 2   26     0   12   84 95                 179
938052 938052 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2016   grade_6 81 8 76 2   6     0   10   99 84                       183 81 8 76 2   6     0   10   99 84                 183
938127 938127 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2016   grade_6 139 8 14 0   4     0   13   91 87                       178 139 8 14 0   4     0   13   91 87                 178
938376 938376 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2016   grade_6 302 8 43 2   129     0   16   254 246                       500 302 8 43 2   129     0   16   254 246                 500
938475 938475 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2016   grade_6 7 8 42 0   6     0   1   33 31                       64 7 8 42 0   6     0   1   33 31                 64
938985 938985 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2016   grade_6 150 8 26 0   6     0   2   90 102                       192 150 8 26 0   6     0   2   90 102                 192
939162 939162 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2016   grade_6 253 8 13 0   11     0   7   141 151                       292 253 8 13 0   11     0   7   141 151                 292
939322 939322 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2016   grade_6 107 8 17 1   20     0   11   86 78                       164 107 8 17 1   20     0   11   86 78                 164
939633 939633 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No 2 06 08 2016   grade_6 191 8 50 1   13     0   8   140 131                       271 191 8 50 1   13     0   8   140 131                 271
939969 939969 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   grade_6 11 8 36 0   1     0   5   35 26                       61 11 8 36 0   1     0   5   35 26                 61
940091 940091 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2016   grade_6 39 8 25 0   1     0   3   43 33                       76 39 8 25 0   1     0   3   43 33                 76
940114 940114 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2016   grade_6 31 8 22 0   5     0   1   36 31                       67 31 8 22 0   5     0   1   36 31                 67
940179 940179 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_6 22 8 11 0   6     0   1   19 29                       48 22 8 11 0   6     0   1   19 29                 48
940261 940261 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 2016   grade_6 58 8 6 1   0     0   1   38 36                       74 58 8 6 1   0     0   1   38 36                 74
933963 933963 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_6 15 73 13 2   0     0   2   52 53                       105 15 73 13 2   0     0   2   52 53                 105
932739 932739 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_6 147 7 22 0   26     0   5   96 111                       207 147 7 22 0   26     0   5   96 111                 207
932773 932773 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_6 157 7 20 0   5     0   7   102 94                       196 157 7 20 0   5     0   7   102 94                 196
933025 933025 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2016   grade_6 184 7 5 1   10     0   2   105 104                       209 184 7 5 1   10     0   2   105 104                 209
933186 933186 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2016   grade_6 25 7 11 0   3     0   1   19 28                       47 25 7 11 0   3     0   1   19 28                 47
933414 933414 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_6 14 7 4 0   1     0   0   19 7                       26 14 7 4 0   1     0   0   19 7                 26
933531 933531 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2016   grade_6 25 7 17 0   4     0   2   34 21                       55 25 7 17 0   4     0   2   34 21                 55
934447 934447 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No 2 06 08 2016   grade_6 132 7 92 0   1     0   9   139 102                       241 132 7 92 0   1     0   9   139 102                 241
935024 935024 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_6 43 7 98 0   8     0   14   85 85                       170 43 7 98 0   8     0   14   85 85                 170
935144 935144 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No 2 06 08 2016   grade_6 69 7 52 0   3     0   1   69 63                       132 69 7 52 0   3     0   1   69 63                 132
940039 940039 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2016   grade_6 5 7 19 0   0     0   6   16 21                       37 5 7 19 0   0     0   6   16 21                 37
940069 940069 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   grade_6 9 7 11 0   2     0   1   19 11                       30 9 7 11 0   2     0   1   19 11                 30
940234 940234 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 06 2016   grade_6 15 7 13 1   2     0   2   18 22                       40 15 7 13 1   2     0   2   18 22                 40
940956 940956 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No 2 04 06 2016   grade_6 226 7 8 0   2     0   13   151 105                       256 226 7 8 0   2     0   13   151 105                 256
941781 941781 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2016   grade_6 212 7 14 0   9     0   8   133 117                       250 212 7 14 0   9     0   8   133 117                 250
933609 933609 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_6 1 68 28 2   2     0   1   57 45                       102 1 68 28 2   2     0   1   57 45                 102
934018 934018 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2016   grade_6 77 66 20 0   4     1   7   85 90                       175 77 66 20 0   4     1   7   85 90                 175
940672 940672 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_6 9 64 18 0   5     0   1   41 56                       97 9 64 18 0   5     0   1   41 56                 97
940431 940431 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 2016   grade_6 26 63 28 0   7     0   0   57 67                       124 26 63 28 0   7     0   0   57 67                 124
932583 932583 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_6 218 6 21 0   7     0   12   123 141                       264 218 6 21 0   7     0   12   123 141                 264
932636 932636 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_6 40 6 10 0   4     0   3   30 33                       63 40 6 10 0   4     0   3   30 33                 63
934343 934343 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2016   grade_6 159 6 10 0   29     1   4   98 111                       209 159 6 10 0   29     1   4   98 111                 209
934476 934476 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_6 83 6 26 0   1     0   4   63 57                       120 83 6 26 0   1     0   4   63 57                 120
934560 934560 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2016   grade_6 230 6 17 1   7     0   7   139 129                       268 230 6 17 1   7     0   7   139 129                 268
935212 935212 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 05 07 2016   grade_6 128 6 29 1   3     0   21   102 86                       188 128 6 29 1   3     0   21   102 86                 188
935438 935438 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_6 104 6 18 0   1     1   1   61 70                       131 104 6 18 0   1     1   1   61 70                 131
935466 935466 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2016   grade_6 98 6 32 0   3     1   1   71 70                       141 98 6 32 0   3     1   1   71 70                 141
935781 935781 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2016   grade_6 12 6 133 0   0     0   1   85 67                       152 12 6 133 0   0     0   1   85 67                 152
936175 936175 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2016   grade_6 9 6 19 0   22     0   0   28 28                       56 9 6 19 0   22     0   0   28 28                 56
936183 936183 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2016   grade_6 46 6 30 0   77     0   9   82 86                       168 46 6 30 0   77     0   9   82 86                 168
937943 937943 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2016   grade_6 80 6 7 0   18     0   3   69 45                       114 80 6 7 0   18     0   3   69 45                 114
938084 938084 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No 2 06 08 2016   grade_6 65 6 87 1   12     0   2   86 87                       173 65 6 87 1   12     0   2   86 87                 173
939931 939931 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   grade_6 6 6 48 0   7     0   0   31 36                       67 6 6 48 0   7     0   0   31 36                 67
939946 939946 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2016   grade_6 7 6 18 0   15     0   2   17 31                       48 7 6 18 0   15     0   2   17 31                 48
940024 940024 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   grade_6 11 6 8 0   2     0   0   11 16                       27 11 6 8 0   2     0   0   11 16                 27
940083 940083 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2016   grade_6 54 6 6 0   6     0   3   39 36                       75 54 6 6 0   6     0   3   39 36                 75
940281 940281 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_6 98 6 17 0   5     0   8   71 63                       134 98 6 17 0   5     0   8   71 63                 134
942028 942028 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_6 27 6 4 0   4     0   11   23 29                       52 27 6 4 0   4     0   11   23 29                 52
938773 938773 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No 2 06 08 2016   grade_6 29 59 155 0   6     0   1   138 112                       250 29 59 155 0   6     0   1   138 112                 250
933655 933655 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 05 08 2016   grade_6 13 57 60 0   7     0   4   65 76                       141 13 57 60 0   7     0   4   65 76                 141
933319 933319 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2016   grade_6 3 55 17 0   10     0   1   46 40                       86 3 55 17 0   10     0   1   46 40                 86
933785 933785 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2016   grade_6 6 54 32 0   3     0   6   64 37                       101 6 54 32 0   3     0   6   64 37                 101
940284 940284 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_6 0 52 6 0   0     0   1   33 26                       59 0 52 6 0   0     0   1   33 26                 59
938903 938903 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2016   grade_6 144 51 14 0   13     1   12   132 103                       235 144 51 14 0   13     1   12   132 103                 235
940627 940627 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_6 1 50 33 0   3     0   1   43 45                       88 1 50 33 0   3     0   1   43 45                 88
932629 932629 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_6 35 5 11 0   7     1   2   28 33                       61 35 5 11 0   7     1   2   28 33                 61
932777 932777 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_6 92 5 19 0   4     0   8   69 59                       128 92 5 19 0   4     0   8   69 59                 128
932781 932781 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_6 87 5 25 0   10     1   5   73 60                       133 87 5 25 0   10     1   5   73 60                 133
932892 932892 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_6 168 5 2 0   4     0   4   89 94                       183 168 5 2 0   4     0   4   89 94                 183
933440 933440 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2016   grade_6 22 5 23 1   2     0   2   22 33                       55 22 5 23 1   2     0   2   22 33                 55
934072 934072 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   grade_6 42 5 4 0   6     0   12   39 30                       69 42 5 4 0   6     0   12   39 30                 69
934100 934100 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_6 35 5 12 0   9     0   5   35 31                       66 35 5 12 0   9     0   5   35 31                 66
935083 935083 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2016   grade_6 188 5 10 2   4     0   3   111 101                       212 188 5 10 2   4     0   3   111 101                 212
935474 935474 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_6 105 5 93 0   4     0   1   100 108                       208 105 5 93 0   4     0   1   100 108                 208
935727 935727 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2016   grade_6 163 5 2 0   2     0   1   98 75                       173 163 5 2 0   2     0   1   98 75                 173
935896 935896 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2016   grade_6 144 5 9 1   2     0   1   76 86                       162 144 5 9 1   2     0   1   76 86                 162
936219 936219 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2016   grade_6 191 5 14 0   1     0   4   112 103                       215 191 5 14 0   1     0   4   112 103                 215
936480 936480 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No 2 04 06 2016   grade_6 207 5 13 0   2     0   5   116 116                       232 207 5 13 0   2     0   5   116 116                 232
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
937394 937394 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2016   grade_6 317 5 15 2   22     1   8   190 180                       370 317 5 15 2   22     1   8   190 180                 370
937946 937946 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_6 108 5 5 0   90     2   5   120 95                       215 108 5 5 0   90     2   5   120 95                 215
938081 938081 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No 2 06 08 2016   grade_6 56 5 98 0   9     0   5   89 84                       173 56 5 98 0   9     0   5   89 84                 173

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