enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1125192 1125192 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125266 1125266 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1129008 1129008 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1131923 1131923 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1132002 1132002 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_6 * * * *   *     *   *   1 3                       *                         1 3                  
1122990 1122990 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_6 15 3 3 0   1     0   0   10 12                       22 15 3 3 0   1     0   0   10 12                 22
1125753 1125753 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_6 22 0 0 0   0     0   0   10 12                       22 22 0 0 0   0     0   0   10 12                 22
1129385 1129385 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No Other 06 11 2017   grade_6 3 18 36 0   0     0   0   10 47                       57 3 18 36 0   0     0   0   10 47                 57
1131542 1131542 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_6 27 1 1 0   0     0   1   10 20                       30 27 1 1 0   0     0   1   10 20                 30
1124794 1124794 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2017   grade_6 84 15 55 1   8     0   9   100 72                       172 84 15 55 1   8     0   9   100 72                 172
1132253 1132253 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2017   grade_6 151 3 13 2   6     0   2   100 77                       177 151 3 13 2   6     0   2   100 77                 177
1124392 1124392 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2017   grade_6 149 18 24 2   5     0   5   101 102                       203 149 18 24 2   5     0   5   101 102                 203
1130253 1130253 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No Middle 06 08 2017   grade_6 171 1 21 0   3     0   7   101 102                       203 171 1 21 0   3     0   7   101 102                 203
1131999 1131999 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2017   grade_6 153 17 10 3   5     0   6   101 93                       194 153 17 10 3   5     0   6   101 93                 194
1126786 1126786 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2017   grade_6 193 1 5 1   9     0   6   102 113                       215 193 1 5 1   9     0   6   102 113                 215
1128471 1128471 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No Middle 06 08 2017   grade_6 181 4 6 0   11     0   2   103 101                       204 181 4 6 0   11     0   2   103 101                 204
1129944 1129944 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2017   grade_6 85 15 91 0   7     1   6   103 102                       205 85 15 91 0   7     1   6   103 102                 205
1123687 1123687 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2017   grade_6 53 117 39 0   9     0   12   105 125                       230 53 117 39 0   9     0   12   105 125                 230
1126489 1126489 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2017   grade_6 73 20 81 2   23     0   10   106 103                       209 73 20 81 2   23     0   10   106 103                 209
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
1128738 1128738 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2017   grade_6 151 12 34 1   7     0   5   106 104                       210 151 12 34 1   7     0   5   106 104                 210
1132165 1132165 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2017   grade_6 157 1 4 1   13     1   2   106 73                       179 157 1 4 1   13     1   2   106 73                 179
1124881 1124881 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_6 64 12 103 0   12     0   13   107 97                       204 64 12 103 0   12     0   13   107 97                 204
1127767 1127767 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2017   grade_6 167 0 9 0   0     0   9   107 78                       185 167 0 9 0   0     0   9   107 78                 185
1127625 1127625 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_6 142 3 47 1   4     0   13   108 102                       210 142 3 47 1   4     0   13   108 102                 210
1128163 1128163 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_6 129 23 29 0   3     0   21   108 97                       205 129 23 29 0   3     0   21   108 97                 205
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
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
1122354 1122354 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_6 183 2 6 0   6     1   7   109 96                       205 183 2 6 0   6     1   7   109 96                 205
1127754 1127754 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2017   grade_6 151 3 17 1   16     1   10   109 90                       199 151 3 17 1   16     1   10   109 90                 199
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
1128929 1128929 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2017   grade_6 186 4 7 0   1     0   5   109 94                       203 186 4 7 0   1     0   5   109 94                 203
1129979 1129979 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_6 161 16 11 2   0     0   14   109 95                       204 161 16 11 2   0     0   14   109 95                 204
1128269 1128269 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   grade_6 32 0 0 0   0     0   0   11 21                       32 32 0 0 0   0     0   0   11 21                 32
1130895 1130895 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   grade_6 2 5 16 0   2     0   1   11 15                       26 2 5 16 0   2     0   1   11 15                 26
1131271 1131271 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_6 0 17 3 0   0     0   0   11 9                       20 0 17 3 0   0     0   0   11 9                 20
1131297 1131297 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_6 1 0 18 0   1     0   0   11 9                       20 1 0 18 0   1     0   0   11 9                 20
1131940 1131940 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   11 9                       20 19 0 1 0   0     0   0   11 9                 20
1125530 1125530 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2017   grade_6 175 1 13 2   16     0   6   110 103                       213 175 1 13 2   16     0   6   110 103                 213
1123679 1123679 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 06 08 2017   grade_6 18 137 34 1   5     0   7   111 91                       202 18 137 34 1   5     0   7   111 91                 202
1126978 1126978 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_6 211 5 10 4   6     0   9   111 134                       245 211 5 10 4   6     0   9   111 134                 245
1129353 1129353 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2017   grade_6 25 34 141 0   5     0   2   112 95                       207 25 34 141 0   5     0   2   112 95                 207
1132959 1132959 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2017   grade_6 165 10 9 3   1     1   7   112 84                       196 165 10 9 3   1     1   7   112 84                 196
1124798 1124798 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2017   grade_6 124 18 45 1   14     0   12   113 101                       214 124 18 45 1   14     0   12   113 101                 214
1122271 1122271 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_6 174 4 15 1   9     0   3   114 92                       206 174 4 15 1   9     0   3   114 92                 206
1126630 1126630 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 04 06 2017   grade_6 199 11 11 0   4     0   2   114 113                       227 199 11 11 0   4     0   2   114 113                 227
1131556 1131556 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_6 2 152 86 0   0     0   2   114 128                       242 2 152 86 0   0     0   2   114 128                 242
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
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
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
1128698 1128698 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_6 223 1 1 4   6     0   1   118 118                       236 223 1 1 4   6     0   1   118 118                 236
1127173 1127173 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_6 181 11 14 0   14     0   16   119 117                       236 181 11 14 0   14     0   16   119 117                 236
1129345 1129345 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2017   grade_6 7 30 169 1   22     0   2   119 112                       231 7 30 169 1   22     0   2   119 112                 231
1131251 1131251 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes Other 06 12 2017   grade_6 2 21 7 1   2     0   0   12 21                       33 2 21 7 1   2     0   0   12 21                 33
1132494 1132494 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2017   grade_6 21 0 1 0   2     0   0   12 12                       24 21 0 1 0   2     0   0   12 12                 24
1123545 1123545 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2017   grade_6 169 24 9 2   28     0   5   120 117                       237 169 24 9 2   28     0   5   120 117                 237
1124275 1124275 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_6 194 12 7 0   14     0   12   120 119                       239 194 12 7 0   14     0   12   120 119                 239
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
1128245 1128245 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 05 08 2017   grade_6 217 0 5 1   1     0   8   123 109                       232 217 0 5 1   1     0   8   123 109                 232
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
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
1125176 1125176 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2017   grade_6 170 5 15 2   4     1   18   124 91                       215 170 5 15 2   4     1   18   124 91                 215
1126905 1126905 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2017   grade_6 196 18 8 0   11     0   12   124 121                       245 196 18 8 0   11     0   12   124 121                 245
1132109 1132109 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2017   grade_6 238 2 2 0   2     0   2   126 120                       246 238 2 2 0   2     0   2   126 120                 246
1129698 1129698 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2017   grade_6 178 24 28 2   1     0   16   128 121                       249 178 24 28 2   1     0   16   128 121                 249
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
1125519 1125519 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_6 33 0 1 0   1     0   0   13 22                       35 33 0 1 0   1     0   0   13 22                 35
1125883 1125883 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_6 2 0 13 0   0     0   0   13 2                       15 2 0 13 0   0     0   0   13 2                 15
1128056 1128056 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_6 16 0 0 0   1     0   1   13 5                       18 16 0 0 0   1     0   1   13 5                 18
1132588 1132588 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_6 21 0 0 0   0     0   6   13 14                       27 21 0 0 0   0     0   6   13 14                 27
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
1127380 1127380 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_6 99 42 94 1   1     0   17   131 123                       254 99 42 94 1   1     0   17   131 123                 254
1127904 1127904 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2017   grade_6 175 33 35 0   15     0   5   131 132                       263 175 33 35 0   15     0   5   131 132                 263
1129684 1129684 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2017   grade_6 160 35 28 1   4     0   5   131 102                       233 160 35 28 1   4     0   5   131 102                 233
1125028 1125028 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   grade_6 130 15 74 0   15     0   5   132 107                       239 130 15 74 0   15     0   5   132 107                 239
1130444 1130444 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2017   grade_6 216 13 11 0   22     0   11   132 141                       273 216 13 11 0   22     0   11   132 141                 273
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
1124483 1124483 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2017   grade_6 229 0 3 0   2     0   9   135 108                       243 229 0 3 0   2     0   9   135 108                 243
1130563 1130563 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_6 228 3 11 0   12     0   11   135 130                       265 228 3 11 0   12     0   11   135 130                 265
1123998 1123998 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2017   grade_6 188 27 7 0   22     1   13   137 121                       258 188 27 7 0   22     1   13   137 121                 258
1125656 1125656 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2017   grade_6 238 3 6 0   32     0   7   138 148                       286 238 3 6 0   32     0   7   138 148                 286
1122872 1122872 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_6 6 0 26 0   0     0   1   14 19                       33 6 0 26 0   0     0   1   14 19                 33
1122945 1122945 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_6 0 4 22 0   0     0   0   14 12                       26 0 4 22 0   0     0   0   14 12                 26
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
1124286 1124286 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_6 26 0 0 0   0     0   0   14 12                       26 26 0 0 0   0     0   0   14 12                 26
1128769 1128769 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No Elementary KG 06 2017   grade_6 36 0 0 0   2     0   1   14 25                       39 36 0 0 0   2     0   1   14 25                 39
1130523 1130523 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   14 6                       20 19 0 1 0   0     0   0   14 6                 20
1130861 1130861 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   grade_6 9 4 14 0   1     0   0   14 14                       28 9 4 14 0   1     0   0   14 14                 28
1130972 1130972 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_6 25 5 8 0   0     0   4   14 28                       42 25 5 8 0   0     0   4   14 28                 42
1124324 1124324 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2017   grade_6 246 4 22 0   7     0   9   141 147                       288 246 4 22 0   7     0   9   141 147                 288
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
1123845 1123845 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2017   grade_6 193 17 17 0   32     0   12   142 129                       271 193 17 17 0   32     0   12   142 129                 271
1125984 1125984 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2017   grade_6 143 24 91 0   15     0   12   143 142                       285 143 24 91 0   15     0   12   143 142                 285
1127372 1127372 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_6 119 41 121 0   2     1   12   143 153                       296 119 41 121 0   2     1   12   143 153                 296
1124193 1124193 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2017   grade_6 142 16 92 0   5     0   9   144 120                       264 142 16 92 0   5     0   9   144 120                 264
1130301 1130301 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_6 176 0 0 0   70     0   5   144 107                       251 176 0 0 0   70     0   5   144 107                 251
1124802 1124802 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_6 177 24 68 0   8     0   17   146 148                       294 177 24 68 0   8     0   17   146 148                 294
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
1129725 1129725 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No Middle 05 06 2017   grade_6 254 5 5 1   8     0   2   147 128                       275 254 5 5 1   8     0   2   147 128                 275
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

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