enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2015 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 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
736957 736957 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
738210 738210 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_6 6 0 0 0   0     0   0   1 5                       6 6 0 0 0   0     0   0   1 5                 6
738603 738603 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
740285 740285 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
741275 741275 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_6 8 1 1 0   0     0   0   1 9                       10 8 1 1 0   0     0   0   1 9                 10
743114 743114 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2015   grade_6 5 4 7 0   0     0   3   10 9                       19 5 4 7 0   0     0   3   10 9                 19
744036 744036 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_6 16 0 0 0   1     0   0   10 7                       17 16 0 0 0   1     0   0   10 7                 17
740648 740648 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No 2 06 08 2015   grade_6 188 2 2 0   8     0   5   100 105                       205 188 2 2 0   8     0   5   100 105                 205
742716 742716 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2015   grade_6 167 4 20 0   6     0   2   100 99                       199 167 4 20 0   6     0   2   100 99                 199
736159 736159 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No 2 06 08 2015   grade_6 169 4 5 0   13     0   5   101 95                       196 169 4 5 0   13     0   5   101 95                 196
736976 736976 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_6 156 3 5 1   5     0   12   101 81                       182 156 3 5 1   5     0   12   101 81                 182
738293 738293 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_6 132 6 53 0   20     0   6   101 116                       217 132 6 53 0   20     0   6   101 116                 217
738230 738230 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2015   grade_6 178 7 4 0   9     0   3   102 99                       201 178 7 4 0   9     0   3   102 99                 201
742477 742477 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_6 149 11 13 3   1     0   17   102 92                       194 149 11 13 3   1     0   17   102 92                 194
742447 742447 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No 2 06 08 2015   grade_6 86 17 69 0   6     0   7   103 82                       185 86 17 69 0   6     0   7   103 82                 185
736156 736156 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2015   grade_6 173 3 8 0   9     0   2   104 91                       195 173 3 8 0   9     0   2   104 91                 195
736416 736416 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2015   grade_6 13 61 78 1   37     0   4   104 90                       194 13 61 78 1   37     0   4   104 90                 194
737587 737587 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Fairview Middle   Regular School No 2 06 08 2015   grade_6 125 5 60 1   11     0   9   104 107                       211 125 5 60 1   11     0   9   104 107                 211
739764 739764 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2015   grade_6 184 0 3 0   8     0   7   104 98                       202 184 0 3 0   8     0   7   104 98                 202
740607 740607 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_6 172 0 10 0   3     1   7   104 89                       193 172 0 10 0   3     1   7   104 89                 193
735996 735996 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2015   grade_6 183 3 4 0   4     0   4   105 93                       198 183 3 4 0   4     0   4   105 93                 198
737035 737035 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No 2 06 08 2015   grade_6 169 6 4 0   29     0   3   105 106                       211 169 6 4 0   29     0   3   105 106                 211
737152 737152 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_6 47 97 23 0   11     0   11   106 83                       189 47 97 23 0   11     0   11   106 83                 189
741204 741204 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No 2 06 08 2015   grade_6 175 5 5 1   7     0   3   106 90                       196 175 5 5 1   7     0   3   106 90                 196
742713 742713 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2015   grade_6 186 2 20 0   3     1   5   107 110                       217 186 2 20 0   3     1   5   107 110                 217
737155 737155 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_6 61 110 28 0   7     2   11   108 111                       219 61 110 28 0   7     2   11   108 111                 219
738628 738628 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_6 140 8 62 1   1     0   2   108 106                       214 140 8 62 1   1     0   2   108 106                 214
738828 738828 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No 2 05 07 2015   grade_6 190 4 11 2   3     0   2   108 104                       212 190 4 11 2   3     0   2   108 104                 212
741965 741965 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No 2 06 08 2015   grade_6 34 51 117 0   8     0   7   108 109                       217 34 51 117 0   8     0   7   108 109                 217
737483 737483 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_6 185 3 6 0   21     0   5   109 111                       220 185 3 6 0   21     0   5   109 111                 220
740092 740092 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2015   grade_6 175 9 24 0   12     1   10   109 122                       231 175 9 24 0   12     1   10   109 122                 231
741959 741959 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No 2 06 08 2015   grade_6 18 45 146 0   17     0   6   109 123                       232 18 45 146 0   17     0   6   109 123                 232
742538 742538 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2015   grade_6 164 13 7 0   34     0   16   109 125                       234 164 13 7 0   34     0   16   109 125                 234
736180 736180 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No 1 KG 08 2015   grade_6 10 1 4 0   2     0   1   11 7                       18 10 1 4 0   2     0   1   11 7                 18
743237 743237 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2015   grade_6 20 6 8 0   3     0   3   11 29                       40 20 6 8 0   3     0   3   11 29                 40
743720 743720 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_6 12 1 1 0   2     0   1   11 6                       17 12 1 1 0   2     0   1   11 6                 17
744141 744141 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
744274 744274 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_6 16 1 0 0   0     0   1   11 7                       18 16 1 0 0   0     0   1   11 7                 18
737161 737161 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2015   grade_6 65 85 60 2   7     0   12   110 121                       231 65 85 60 2   7     0   12   110 121                 231
742235 742235 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2015   grade_6 162 37 29 0   4     0   7   111 128                       239 162 37 29 0   4     0   7   111 128                 239
739372 739372 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2015   grade_6 204 4 16 1   3     2   5   113 122                       235 204 4 16 1   3     2   5   113 122                 235
739514 739514 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2015   grade_6 97 13 69 1   21     0   9   113 97                       210 97 13 69 1   21     0   9   113 97                 210
740666 740666 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2015   grade_6 196 1 3 0   4     1   3   113 95                       208 196 1 3 0   4     1   3   113 95                 208
742514 742514 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2015   grade_6 141 7 40 2   25     0   6   113 108                       221 141 7 40 2   25     0   6   113 108                 221
740945 740945 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2015   grade_6 155 21 23 1   6     0   7   114 99                       213 155 21 23 1   6     0   7   114 99                 213
741224 741224 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2015   grade_6 93 10 87 4   13     0   3   114 96                       210 93 10 87 4   13     0   3   114 96                 210
741604 741604 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No 2 06 08 2015   grade_6 191 1 4 0   3     1   4   114 90                       204 191 1 4 0   3     1   4   114 90                 204
736023 736023 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial Middle School   Regular School No 2 05 08 2015   grade_6 170 4 4 0   10     0   3   115 76                       191 170 4 4 0   10     0   3   115 76                 191
738111 738111 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2015   grade_6 166 10 44 0   7     0   7   116 118                       234 166 10 44 0   7     0   7   116 118                 234
744334 744334 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_6 187 3 3 0   13     0   1   116 91                       207 187 3 3 0   13     0   1   116 91                 207
738699 738699 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2015   grade_6 199 1 5 2   14     0   5   117 109                       226 199 1 5 2   14     0   5   117 109                 226
741117 741117 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_6 121 6 6 0   90     1   6   117 113                       230 121 6 6 0   90     1   6   117 113                 230
737759 737759 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2015   grade_6 178 14 24 1   4     0   9   119 111                       230 178 14 24 1   4     0   9   119 111                 230
738532 738532 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2015   grade_6 218 1 5 0   7     0   0   119 112                       231 218 1 5 0   7     0   0   119 112                 231
736440 736440 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   grade_6 5 0 25 0   0     0   0   12 18                       30 5 0 25 0   0     0   0   12 18                 30
743129 743129 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2015   grade_6 3 4 13 0   0     0   2   12 10                       22 3 4 13 0   0     0   2   12 10                 22
744551 744551 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No 1 KG 06 2015   grade_6 23 0 1 0   0     0   0   12 12                       24 23 0 1 0   0     0   0   12 12                 24
744713 744713 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 2 0   0     0   0   12 11                       23 21 0 2 0   0     0   0   12 11                 23
737659 737659 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_6 196 12 10 0   14     0   8   120 120                       240 196 12 10 0   14     0   8   120 120                 240
739157 739157 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2015   grade_6 126 12 9 1   88     0   14   122 128                       250 126 12 9 1   88     0   14   122 128                 250
739636 739636 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No 2 04 06 2015   grade_6 209 6 16 0   5     0   8   122 122                       244 209 6 16 0   5     0   8   122 122                 244
740721 740721 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No 2 06 08 2015   grade_6 179 20 21 0   22     0   7   123 126                       249 179 20 21 0   22     0   7   123 126                 249
743817 743817 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_6 1 135 100 1   2     2   3   123 121                       244 1 135 100 1   2     2   3   123 121                 244
744122 744122 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No 2 04 06 2015   grade_6 228 9 4 0   3     0   8   123 129                       252 228 9 4 0   3     0   8   123 129                 252
744198 744198 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2015   grade_6 163 17 19 9   4     0   14   123 103                       226 163 17 19 9   4     0   14   123 103                 226
740272 740272 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_6 109 31 105 1   0     0   17   124 139                       263 109 31 105 1   0     0   17   124 139                 263
741442 741442 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No 2 06 08 2015   grade_6 180 6 28 1   9     1   3   124 104                       228 180 6 28 1   9     1   3   124 104                 228
742750 742750 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2015   grade_6 185 1 6 0   50     0   9   127 124                       251 185 1 6 0   50     0   9   127 124                 251
742869 742869 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2015   grade_6 234 6 10 0   21     0   1   127 145                       272 234 6 10 0   21     0   1   127 145                 272
741162 741162 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2015   grade_6 31 116 33 0   44     0   11   128 107                       235 31 116 33 0   44     0   11   128 107                 235
740597 740597 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2015   grade_6 193 3 14 2   24     0   11   129 118                       247 193 3 14 2   24     0   11   129 118                 247
736734 736734 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_6 0 15 9 0   2     0   0   13 13                       26 0 15 9 0   2     0   0   13 13                 26
736760 736760 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_6 4 4 10 0   0     0   0   13 5                       18 4 4 10 0   0     0   0   13 5                 18
737669 737669 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   grade_6 24 0 2 0   0     0   0   13 13                       26 24 0 2 0   0     0   0   13 13                 26
741584 741584 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 4 0   0     0   2   13 13                       26 20 0 4 0   0     0   2   13 13                 26
741849 741849 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_6 7 9 6 0   1     0   3   13 13                       26 7 9 6 0   1     0   3   13 13                 26
741971 741971 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No 2 06 08 2015   grade_6 1 6 9 0   0     0   0   13 3                       16 1 6 9 0   0     0   0   13 3                 16
742143 742143 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_6 22 0 2 0   3     0   1   13 15                       28 22 0 2 0   3     0   1   13 15                 28
739863 739863 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No 2 06 08 2015   grade_6 239 15 4 0   9     0   8   132 143                       275 239 15 4 0   9     0   8   132 143                 275
744287 744287 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2015   grade_6 242 0 4 0   2     0   4   133 119                       252 242 0 4 0   2     0   4   133 119                 252
744960 744960 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2015   grade_6 242 4 14 1   17     0   9   133 154                       287 242 4 14 1   17     0   9   133 154                 287
741014 741014 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No 2 05 08 2015   grade_6 239 3 0 1   4     0   5   135 117                       252 239 3 0 1   4     0   5   135 117                 252
737425 737425 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No 2 06 08 2015   grade_6 192 26 9 0   32     0   13   136 136                       272 192 26 9 0   32     0   13   136 136                 272
737838 737838 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No 2 06 08 2015   grade_6 244 1 2 0   4     0   2   137 116                       253 244 1 2 0   4     0   2   137 116                 253
737032 737032 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No 2 06 08 2015   grade_6 194 16 6 0   37     0   3   138 118                       256 194 16 6 0   37     0   3   138 118                 256
739160 739160 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_6 147 8 8 0   82     0   13   138 120                       258 147 8 8 0   82     0   13   138 120                 258
739927 739927 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No 2 06 08 2015   grade_6 250 3 9 1   3     0   6   138 134                       272 250 3 9 1   3     0   6   138 134                 272
742246 742246 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2015   grade_6 192 16 24 1   2     0   10   138 107                       245 192 16 24 1   2     0   10   138 107                 245
741968 741968 MA Hampden   school 2511130 281   Springfield 251113001660 2810340 Van Sickle Middle School   Regular School No 2 06 08 2015   grade_6 29 49 187 0   1     0   7   139 134                       273 29 49 187 0   1     0   7   139 134                 273
738886 738886 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   1     0   2   14 23                       37 34 0 0 0   1     0   2   14 23                 37
742941 742941 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg Schools   Regular School No 1 PK 06 2015   grade_6 25 0 3 1   1     0   0   14 16                       30 25 0 3 1   1     0   0   14 16                 30
743682 743682 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 26 2 7 0   0     0   0   14 21                       35 26 2 7 0   0     0   0   14 21                 35
744537 744537 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   14 7                       21 20 0 1 0   0     0   0   14 7                 21
744838 744838 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_6 24 1 3 0   0     0   0   14 14                       28 24 1 3 0   0     0   0   14 14                 28
737701 737701 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2015   grade_6 247 4 18 0   6     0   7   140 142                       282 247 4 18 0   6     0   7   140 142                 282
742092 742092 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2015   grade_6 183 68 22 0   13     0   3   140 149                       289 183 68 22 0   13     0   3   140 149                 289
738150 738150 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_6 242 10 8 4   6     0   20   141 149                       290 242 10 8 4   6     0   20   141 149                 290
740400 740400 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No 2 06 08 2015   grade_6 169 11 13 1   51     0   12   143 114                       257 169 11 13 1   51     0   12   143 114                 257
735705 735705 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_6 278 3 21 0   3     0   11   146 170                       316 278 3 21 0   3     0   11   146 170                 316
737924 737924 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2015   grade_6 253 17 11 1   8     0   9   146 153                       299 253 17 11 1   8     0   9   146 153                 299

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