enrollments

Data source: Big Local News · About: Big Local

577 rows where grade = "grade_6", state = "MA" and year = 2017 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 577 ✖

grade ✖

  • grade_6 · 577 ✖
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
1123695 1123695 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_6 60 95 72 1   8     0   12   124 124                       248 60 95 72 1   8     0   12   124 124                 248
1123683 1123683 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_6 26 94 30 0   6     1   14   89 82                       171 26 94 30 0   6     1   14   89 82                 171
1133178 1133178 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_6 1 92 10 0   0     0   2   55 50                       105 1 92 10 0   0     0   2   55 50                 105
1122700 1122700 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_6 9 9 24 0   1     0   3   21 25                       46 9 9 24 0   1     0   3   21 25                 46
1123091 1123091 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_6 0 9 25 0   0     0   1   19 16                       35 0 9 25 0   0     0   1   19 16                 35
1123199 1123199 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_6 0 9 12 0   0     0   1   14 8                       22 0 9 12 0   0     0   1   14 8                 22
1123732 1123732 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_6 36 9 5 0   16     0   8   36 38                       74 36 9 5 0   16     0   8   36 38                 74
1124105 1124105 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_6 6 9 128 1   1     0   2   87 60                       147 6 9 128 1   1     0   2   87 60                 147
1124465 1124465 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2017   grade_6 221 9 25 1   17     0   4   149 128                       277 221 9 25 1   17     0   4   149 128                 277
1126060 1126060 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_6 150 9 8 0   117     0   21   148 157                       305 150 9 8 0   117     0   21   148 157                 305
1126088 1126088 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_6 30 9 10 0   1     0   3   22 31                       53 30 9 10 0   1     0   3   22 31                 53
1126266 1126266 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_6 43 9 41 0   32     0   7   70 62                       132 43 9 41 0   32     0   7   70 62                 132
1127011 1127011 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_6 228 9 92 4   12     0   11   178 178                       356 228 9 92 4   12     0   11   178 178                 356
1127716 1127716 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2017   grade_6 284 9 14 1   22     1   11   181 161                       342 284 9 14 1   22     1   11   181 161                 342
1128495 1128495 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2017   grade_6 100 9 87 0   6     1   2   108 97                       205 100 9 87 0   6     1   2   108 97                 205
1128842 1128842 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2017   grade_6 155 9 17 0   72     1   12   123 143                       266 155 9 17 0   72     1   12   123 143                 266
1129373 1129373 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_6 1 9 83 0   0     0   0   40 53                       93 1 9 83 0   0     0   0   40 53                 93
1129833 1129833 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_6 217 9 19 0   6     0   6   146 111                       257 217 9 19 0   6     0   6   146 111                 257
1130123 1130123 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_6 291 9 18 0   46     0   28   215 177                       392 291 9 18 0   46     0   28   215 177                 392
1130740 1130740 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_6 6 9 26 0   2     0   2   20 25                       45 6 9 26 0   2     0   2   20 25                 45
1130912 1130912 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   grade_6 13 9 16 0   1     0   5   19 25                       44 13 9 16 0   1     0   5   19 25                 44
1130997 1130997 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2017   grade_6 6 9 41 0   2     0   3   30 31                       61 6 9 41 0   2     0   3   30 31                 61
1131913 1131913 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Elementary 04 06 2017   grade_6 233 9 5 1   5     0   9   141 121                       262 233 9 5 1   5     0   9   141 121                 262
1132077 1132077 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   grade_6 138 9 4 0   4     0   4   76 83                       159 138 9 4 0   4     0   4   76 83                 159
1128421 1128421 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2017   grade_6 31 87 28 2   30     0   11   93 96                       189 31 87 28 2   30     0   11   93 96                 189
1131523 1131523 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2017   grade_6 8 82 78 0   14     0   1   108 75                       183 8 82 78 0   14     0   1   108 75                 183
1122487 1122487 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No Middle 06 08 2017   grade_6 277 8 31 0   6     0   10   175 157                       332 277 8 31 0   6     0   10   175 157                 332
1123102 1123102 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2017   grade_6 9 8 24 0   6     1   1   28 21                       49 9 8 24 0   6     1   1   28 21                 49
1123121 1123121 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_6 32 8 14 1   1     1   4   31 30                       61 32 8 14 1   1     1   4   31 30                 61
1124559 1124559 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2017   grade_6 182 8 11 0   10     0   3   120 94                       214 182 8 11 0   10     0   3   120 94                 214
1126082 1126082 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_6 45 8 5 0   1     0   2   30 31                       61 45 8 5 0   1     0   2   30 31                 61
1126271 1126271 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2017   grade_6 47 8 34 0   79     0   6   92 82                       174 47 8 34 0   79     0   6   92 82                 174
1127222 1127222 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2017   grade_6 331 8 28 0   30     0   24   200 221                       421 331 8 28 0   30     0   24   200 221                 421
1127537 1127537 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2017   grade_6 139 8 15 1   53     0   17   106 127                       233 139 8 15 1   53     0   17   106 127                 233
1127670 1127670 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2017   grade_6 278 8 27 1   23     1   10   181 167                       348 278 8 27 1   23     1   10   181 167                 348
1129215 1129215 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_6 8 8 14 0   0     0   2   15 17                       32 8 8 14 0   0     0   2   15 17                 32
1129559 1129559 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2017   grade_6 243 8 10 0   27     0   17   148 157                       305 243 8 10 0   27     0   17   148 157                 305
1130064 1130064 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_6 88 8 40 0   2     0   8   53 93                       146 88 8 40 0   2     0   8   53 93                 146
1131107 1131107 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_6 12 8 19 0   0     0   3   21 21                       42 12 8 19 0   0     0   3   21 21                 42
1131649 1131649 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes Other 05 12 2017   grade_6 50 8 24 0   1     0   7   51 39                       90 50 8 24 0   1     0   7   51 39                 90
1131839 1131839 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_6 118 8 20 0   1     2   4   72 81                       153 118 8 20 0   1     2   4   72 81                 153
1133163 1133163 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_6 79 8 6 0   3     1   5   57 45                       102 79 8 6 0   3     1   5   57 45                 102
1123691 1123691 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2017   grade_6 63 72 18 1   3     0   7   87 77                       164 63 72 18 1   3     0   7   87 77                 164
1122068 1122068 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_6 25 7 11 0   9     0   5   27 30                       57 25 7 11 0   9     0   5   27 30                 57
1122902 1122902 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_6 33 7 8 0   9     0   0   31 26                       57 33 7 8 0   9     0   0   31 26                 57
1123137 1123137 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_6 3 7 5 1   0     0   0   15 1                       16 3 7 5 1   0     0   0   15 1                 16
1123409 1123409 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_6 15 7 140 0   2     1   1   84 82                       166 15 7 140 0   2     1   1   84 82                 166
1124356 1124356 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2017   grade_6 264 7 11 0   1     0   17   176 124                       300 264 7 11 0   1     0   17   176 124                 300
1125405 1125405 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_6 117 7 27 0   2     0   3   77 79                       156 117 7 27 0   2     0   3   77 79                 156
1125980 1125980 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2017   grade_6 109 7 40 0   3     0   4   92 71                       163 109 7 40 0   3     0   4   92 71                 163
1128950 1128950 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_6 11 7 12 0   6     0   1   20 17                       37 11 7 12 0   6     0   1   20 17                 37
1129357 1129357 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2017   grade_6 1 7 9 0   0     0   0   16 1                       17 1 7 9 0   0     0   0   16 1                 17
1130757 1130757 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_6 3 7 57 0   8     0   0   41 34                       75 3 7 57 0   8     0   0   41 34                 75
1130834 1130834 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary PK 06 2017   grade_6 14 7 31 1   2     0   2   22 35                       57 14 7 31 1   2     0   2   22 35                 57
1131041 1131041 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_6 19 7 10 0   8     0   4   25 23                       48 19 7 10 0   8     0   4   25 23                 48
1132037 1132037 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2017   grade_6 137 7 4 1   15     0   8   82 90                       172 137 7 4 1   15     0   8   82 90                 172
1132367 1132367 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_6 117 7 8 0   1     0   9   63 79                       142 117 7 8 0   1     0   9   63 79                 142
1132892 1132892 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2017   grade_6 224 7 9 0   9     0   4   133 120                       253 224 7 9 0   9     0   4   133 120                 253
1133202 1133202 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_6 47 7 6 0   7     0   7   37 37                       74 47 7 6 0   7     0   7   37 37                 74
1123413 1123413 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_6 4 69 47 0   8     1   4   84 49                       133 4 69 47 0   8     1   4   84 49                 133
1123620 1123620 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_6 19 66 12 0   0     1   10   47 61                       108 19 66 12 0   0     1   10   47 61                 108
1131332 1131332 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_6 29 63 26 0   3     0   6   65 62                       127 29 63 26 0   3     0   6   65 62                 127
1121955 1121955 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_6 156 6 8 0   2     0   1   82 91                       173 156 6 8 0   2     0   1   82 91                 173
1122004 1122004 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_6 253 6 25 0   13     0   7   155 149                       304 253 6 25 0   13     0   7   155 149                 304
1122052 1122052 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_6 23 6 13 0   5     0   2   22 27                       49 23 6 13 0   5     0   2   22 27                 49
1122538 1122538 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2017   grade_6 172 6 9 0   13     1   3   97 107                       204 172 6 9 0   13     1   3   97 107                 204
1123549 1123549 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2017   grade_6 173 6 11 1   36     0   3   117 113                       230 173 6 11 1   36     0   3   117 113                 230
1123742 1123742 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_6 44 6 9 0   6     0   12   44 33                       77 44 6 9 0   6     0   12   44 33                 77
1124100 1124100 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_6 11 6 96 2   2     0   2   67 52                       119 11 6 96 2   2     0   2   67 52                 119
1124110 1124110 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_6 9 6 125 0   2     0   0   69 73                       142 9 6 125 0   2     0   0   69 73                 142
1124189 1124189 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_6 129 6 98 0   2     0   9   130 114                       244 129 6 98 0   2     0   9   130 114                 244
1124500 1124500 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No Elementary 03 06 2017   grade_6 170 6 3 1   3     0   4   90 96                       187 170 6 3 1   3     0   4   90 96                 187
1127525 1127525 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_6 109 6 24 0   26     0   13   89 89                       178 109 6 24 0   26     0   13   89 89                 178
1127529 1127529 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_6 158 6 11 0   46     0   20   118 123                       241 158 6 11 0   46     0   20   118 123                 241
1128368 1128368 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_6 105 6 6 0   89     0   5   109 102                       211 105 6 6 0   89     0   5   109 102                 211
1128529 1128529 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2017   grade_6 72 6 93 0   13     0   3   97 90                       187 72 6 93 0   13     0   3   97 90                 187
1128961 1128961 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2017   grade_6 36 6 6 0   2     0   1   28 23                       51 36 6 6 0   2     0   1   28 23                 51
1129004 1129004 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_6 14 6 30 0   6     0   0   24 32                       56 14 6 30 0   6     0   0   24 32                 56
1130632 1130632 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2017   grade_6 283 6 12 1   68     0   16   200 186                       386 283 6 12 1   68     0   16   200 186                 386
1130765 1130765 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_6 8 6 15 0   2     0   1   18 14                       32 8 6 15 0   2     0   1   18 14                 32
1130774 1130774 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_6 7 6 24 0   6     0   0   18 25                       43 7 6 24 0   6     0   0   18 25                 43
1130817 1130817 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   grade_6 6 6 23 0   4     0   3   23 19                       42 6 6 23 0   4     0   3   23 19                 42
1133188 1133188 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_6 30 6 9 0   1     0   3   22 27                       49 30 6 9 0   1     0   3   22 27                 49
1123262 1123262 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2017   grade_6 14 59 69 0   2     0   3   68 79                       147 14 59 69 0   2     0   3   68 79                 147
1129338 1129338 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No Other 06 11 2017   grade_6 20 59 97 0   6     0   3   117 68                       185 20 59 97 0   6     0   3   117 68                 185
1131586 1131586 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_6 6 59 16 0   4     0   5   47 43                       90 6 59 16 0   4     0   5   47 43                 90
1129512 1129512 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2017   grade_6 138 57 29 1   24     0   8   129 128                       257 138 57 29 1   24     0   8   129 128                 257
1123209 1123209 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_6 2 54 32 2   3     0   4   54 43                       97 2 54 32 2   3     0   4   54 43                 97
1127084 1127084 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2017   grade_6 238 54 14 0   14     0   7   160 167                       327 238 54 14 0   14     0   7   160 167                 327
1131534 1131534 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_6 0 53 16 0   0     0   1   38 32                       70 0 53 16 0   0     0   1   38 32                 70
1123235 1123235 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2017   grade_6 0 52 60 0   21     0   6   75 64                       139 0 52 60 0   21     0   6   75 64                 139
1122845 1122845 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2017   grade_6 7 50 65 0   11     0   3   73 63                       136 7 50 65 0   11     0   3   73 63                 136
1122060 1122060 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_6 20 5 9 0   6     0   4   26 18                       44 20 5 9 0   6     0   4   26 18                 44
1122194 1122194 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_6 127 5 16 2   25     0   4   96 83                       179 127 5 16 2   25     0   4   96 83                 179
1122236 1122236 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_6 108 5 12 0   5     0   11   69 72                       141 108 5 12 0   5     0   11   69 72                 141
1122542 1122542 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2017   grade_6 148 5 9 0   7     1   4   84 90                       174 148 5 9 0   7     1   4   84 90                 174
1122730 1122730 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_6 24 5 13 0   3     0   3   26 22                       48 24 5 13 0   3     0   3   26 22                 48
1123753 1123753 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2017   grade_6 37 5 3 1   13     0   7   38 28                       66 37 5 3 1   13     0   7   38 28                 66
1123784 1123784 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2017   grade_6 27 5 9 0   4     0   6   19 32                       51 27 5 9 0   4     0   6   19 32                 51
1124225 1124225 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_6 93 5 24 0   1     0   0   74 49                       123 93 5 24 0   1     0   0   74 49                 123

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