enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1124818 1124818 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_6 * * * *   *     *   *   5 *                       *                         5                    
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 * * * *   *     *   *   * *                       *                                              
1126251 1126251 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_6 * * * *   *     *   *   4 *                       *                         4                    
1126451 1126451 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_6 3 3 3 0   0     0   0   7 *                       9 3 3 3 0   0     0   0   7                   9
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                    
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
1125424 1125424 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_6 * * * *   *     *   *   4 1                       *                         4 1                  
1126511 1126511 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
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
1130462 1130462 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1129745 1129745 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_6 20 0 9 0   0     0   0   19 10                       29 20 0 9 0   0     0   0   19 10                 29
1130017 1130017 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2017   grade_6 136 10 20 2   15     1   10   94 100                       194 136 10 20 2   15     1   10   94 100                 194
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
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
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
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
1127837 1127837 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2017   grade_6 177 3 3 0   3     0   5   89 102                       191 177 3 3 0   3     0   5   89 102                 191
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
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
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
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
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
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
1127814 1127814 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No Middle 06 08 2017   grade_6 172 1 6 0   5     0   7   88 103                       191 172 1 6 0   5     0   7   88 103                 191
1131789 1131789 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2017   grade_6 177 0 6 0   1     0   4   85 103                       188 177 0 6 0   1     0   4   85 103                 188
1124066 1124066 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_6 156 4 6 0   28     0   6   96 104                       200 156 4 6 0   28     0   6   96 104                 200
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
1122107 1122107 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_6 164 0 5 2   27     0   6   99 105                       204 164 0 5 2   27     0   6   99 105                 204
1125686 1125686 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2017   grade_6 176 4 14 0   2     0   8   99 105                       204 176 4 14 0   2     0   8   99 105                 204
1128533 1128533 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2017   grade_6 58 13 101 1   10     0   6   83 106                       189 58 13 101 1   10     0   6   83 106                 189
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
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
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
1132336 1132336 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2017   grade_6 179 0 6 0   7     0   4   89 107                       196 179 0 6 0   7     0   4   89 107                 196
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
1124949 1124949 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_6 174 10 9 2   3     0   6   95 109                       204 174 10 9 2   3     0   6   95 109                 204
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
1130317 1130317 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_6 16 0 1 0   0     0   0   6 11                       17 16 0 1 0   0     0   0   6 11                 17
1131379 1131379 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_6 26 0 2 0   0     0   3   20 11                       31 26 0 2 0   0     0   3   20 11                 31
1130047 1130047 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2017   grade_6 132 12 10 0   36     0   17   97 110                       207 132 12 10 0   36     0   17   97 110                 207
1126320 1126320 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2017   grade_6 187 2 13 2   2     0   1   96 111                       207 187 2 13 2   2     0   1   96 111                 207
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
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
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
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
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
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
1125448 1125448 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_6 106 1 99 0   4     1   2   98 115                       213 106 1 99 0   4     1   2   98 115                 213
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
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
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
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
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
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
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
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
1129849 1129849 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   grade_6 18 0 0 1   0     0   1   8 12                       20 18 0 0 1   0     0   1   8 12                 20
1130886 1130886 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2017   grade_6 16 4 6 0   2     0   1   17 12                       29 16 4 6 0   2     0   1   17 12                 29
1131811 1131811 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2017   grade_6 20 1 0 0   0     0   0   9 12                       21 20 1 0 0   0     0   0   9 12                 21
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
1132627 1132627 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_6 26 0 2 0   0     0   1   17 12                       29 26 0 2 0   0     0   1   17 12                 29
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1130158 1130158 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Elementary 04 06 2017   grade_6 161 1 16 0   88     0   13   151 128                       279 161 1 16 0   88     0   13   151 128                 279
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
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
1132751 1132751 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 25 0 3 0   1     0   2   18 13                       31 25 0 3 0   1     0   2   18 13                 31
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
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
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
1127533 1127533 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2017   grade_6 203 19 21 1   41     0   24   171 138                       309 203 19 21 1   41     0   24   171 138                 309
1125369 1125369 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_6 27 0 4 0   0     0   0   17 14                       31 27 0 4 0   0     0   0   17 14                 31
1127783 1127783 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 39 1 2 0   0     0   3   31 14                       45 39 1 2 0   0     0   3   31 14                 45
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
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
1130920 1130920 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   grade_6 15 0 5 0   6     0   4   16 14                       30 15 0 5 0   6     0   4   16 14                 30
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
1130396 1130396 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2017   grade_6 220 12 54 1   25     0   4   176 140                       316 220 12 54 1   25     0   4   176 140                 316
1126676 1126676 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_6 126 12 153 0   9     0   9   168 141                       309 126 12 153 0   9     0   9   168 141                 309
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
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
1128249 1128249 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2017   grade_6 279 10 15 0   9     0   12   183 142                       325 279 10 15 0   9     0   12   183 142                 325
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
1124587 1124587 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2017   grade_6 268 14 5 0   9     0   4   155 145                       300 268 14 5 0   9     0   4   155 145                 300

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