Data source: Big Local News · About: Big Local

495 rows where grade = "grade_8", state = "MA" and year = 2018 sorted by male

View and edit SQL

year

  • 2018 · 495

grade

  • grade_8 · 495
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
2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2231645 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2232023 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_8 * * * *   *     *   *   * *                       1.0                                             1
2237229 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2234771 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_8 * * * *   *     *   *   1 *                       1.0                         1                   1
2233324 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_8 3 0 9 0   0     0   1   10 3                       13.0 3 0 9 0   0     0   1   10 3                 13
2238104 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_8 0 15 4 0   0     0   1   10 10                       20.0 0 15 4 0   0     0   1   10 10                 20
2238249 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2018   grade_8 20 1 9 0   0     0   1   10 21                       31.0 20 1 9 0   0     0   1   10 21                 31
2234637 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading: North Reading Middle   Regular School No Middle 06 08 2018   grade_8 170 0 4 0   7     1   6   100 88                       188.0 170 0 4 0   7     1   6   100 88                 188
2239625 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton: Triton Regional Middle School   Regular School No Middle 07 08 2018   grade_8 183 3 7 0   4     1   4   100 102                       202.0 183 3 7 0   4     1   4   100 102                 202
2234660 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton: Norton Middle   Regular School No Middle 06 08 2018   grade_8 191 6 6 0   3     0   5   102 109                       211.0 191 6 6 0   3     0   5   102 109                 211
2234987 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield: Theodore Herberg Middle   Regular School No Middle 06 08 2018   grade_8 160 20 22 0   2     0   15   102 117                       219.0 160 20 22 0   2     0   15   102 117                 219
2236761 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham: John W. McDevitt Middle School   Regular School No Middle 06 08 2018   grade_8 79 20 89 0   7     0   3   102 96                       198.0 79 20 89 0   7     0   3   102 96                 198
2230883 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford: McCarthy Middle School   Regular School No Middle 05 08 2018   grade_8 159 8 9 0   30     1   5   103 109                       212.0 159 8 9 0   30     1   5   103 109                 212
2239169 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton: Miscoe Hill School   Regular School No Middle 05 08 2018   grade_8 182 2 11 0   4     0   1   103 97                       200.0 182 2 11 0   4     0   1   103 97                 200
2232266 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_8 91 9 101 0   3     0   0   104 100                       204.0 91 9 101 0   3     0   0   104 100                 204
2232347 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston: Robert H. Adams Middle School   Regular School No Middle 06 08 2018   grade_8 198 2 7 1   20     0   4   104 128                       232.0 198 2 7 1   20     0   4   104 128                 232
2235752 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset: Somerset Middle School   Regular School No Middle 06 08 2018   grade_8 185 0 10 0   0     0   3   104 94                       198.0 185 0 10 0   0     0   3   104 94                 198
2230369 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree: South Middle School   Regular School No Middle 06 08 2018   grade_8 169 4 10 0   38     0   1   105 117                       222.0 169 4 10 0   38     0   1   105 117                 222
2239086 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham: Wilbraham Middle   Regular School No Middle 06 08 2018   grade_8 190 6 12 0   6     0   5   105 114                       219.0 190 6 12 0   6     0   5   105 114                 219
2229147 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford: John Glenn Middle   Regular School No Middle 06 08 2018   grade_8 145 14 9 0   39     0   6   106 107                       213.0 145 14 9 0   39     0   6   106 107                 213
2238910 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset: Nauset Regional Middle   Regular School No Middle 06 08 2018   grade_8 166 3 5 0   3     1   6   106 78                       184.0 166 3 5 0   3     1   6   106 78                 184
2229348 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica: Marshall Middle School   Regular School No Middle 06 08 2018   grade_8 187 10 7 1   10     0   2   107 110                       217.0 187 10 7 1   10     0   2   107 110                 217
2230041 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston: Lilla G. Frederick Middle School   Regular School No Middle 06 08 2018   grade_8 3 91 87 0   18     0   3   107 95                       202.0 3 91 87 0   18     0   3   107 95                 202
2230503 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton: West Middle School   Regular School No Middle 06 08 2018   grade_8 46 104 29 1   8     1   9   107 91                       198.0 46 104 29 1   8     1   9   107 91                 198
2237074 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield: South Middle School   Regular School No Middle 06 08 2018   grade_8 163 3 29 0   6     0   0   107 94                       201.0 163 3 29 0   6     0   0   107 94                 201
2236216 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Springfield: Van Sickle Academy   Regular School No Middle 06 08 2018   grade_8 25 27 149 0   4     0   2   108 99                       207.0 25 27 149 0   4     0   2   108 99                 207
2236864 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland: Wayland Middle School   Regular School No Middle 06 08 2018   grade_8 135 10 8 0   44     1   9   108 99                       207.0 135 10 8 0   44     1   9   108 99                 207
2229079 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn: Auburn Middle   Regular School No Middle 06 08 2018   grade_8 184 3 14 0   5     0   10   109 107                       216.0 184 3 14 0   5     0   10   109 107                 216
2231211 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham: Dedham Middle School   Regular School No Middle 06 08 2018   grade_8 149 9 40 0   4     0   6   109 99                       208.0 149 9 40 0   4     0   6   109 99                 208
2231619 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River: Morton Middle   Regular School No Middle 06 08 2018   grade_8 113 19 46 1   6     1   7   109 84                       193.0 113 19 46 1   6     1   7   109 84                 193
2234449 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_8 165 3 25 1   8     0   14   109 107                       216.0 165 3 25 1   8     0   14   109 107                 216
2238597 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham: Amherst Regional Middle School   Regular School No Middle 07 08 2018   grade_8 142 14 29 0   17     1   13   109 107                       216.0 142 14 29 0   17     1   13   109 107                 216
2229545 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_8 9 6 7 1   2     0   1   11 15                       26.0 9 6 7 1   2     0   1   11 15                 26
2229966 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_8 0 13 9 0   0     0   1   11 12                       23.0 0 13 9 0   0     0   1   11 12                 23
2234209 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford: Trinity Day Academy   Regular School No High 06 12 2018   grade_8 7 1 5 0   0     0   2   11 4                       15.0 7 1 5 0   0     0   2   11 4                 15
2234216 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford: Whaling City Junior/Senior High School   Regular School No High 06 12 2018   grade_8 6 3 5 0   0     0   0   11 3                       14.0 6 3 5 0   0     0   0   11 3                 14
2233609 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield: Thomas Blake Middle   Regular School No Middle 06 08 2018   grade_8 188 1 3 0   9     0   8   110 99                       209.0 188 1 3 0   9     0   8   110 99                 209
2234590 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge: Northbridge Middle   Regular School No Middle 05 08 2018   grade_8 176 2 10 0   5     0   8   110 91                       201.0 176 2 10 0   5     0   8   110 91                 201
2230495 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_8 20 164 23 0   3     2   4   111 105                       216.0 20 164 23 0   3     2   4   111 105                 216
2235318 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere: Rumney Marsh Academy   Regular School No Middle 06 08 2018   grade_8 87 8 82 2   9     0   9   111 86                       197.0 87 8 82 2   9     0   9   111 86                 197
2230141 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_8 83 54 62 0   45     0   13   113 144                       257.0 83 54 62 0   45     0   13   113 144                 257
2235562 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus: Belmonte Saugus Middle   Regular School No Middle 06 08 2018   grade_8 186 12 21 1   6     1   2   113 116                       229.0 186 12 21 1   6     1   2   113 116                 229
2238834 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_8 154 26 29 6   4     0   11   113 117                       230.0 154 26 29 6   4     0   11   113 117                 230
2238942 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville: Freetown-Lakeville Middle School   Regular School No Middle 06 08 2018   grade_8 215 2 10 1   2     1   6   113 124                       237.0 215 2 10 1   2     1   6   113 124                 237
2234906 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke: Pembroke Community Middle School   Regular School No Middle 07 08 2018   grade_8 241 0 3 0   4     0   3   114 137                       251.0 241 0 3 0   4     0   3   114 137                 251
2235244 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph: Randolph Community Middle   Regular School No Middle 06 08 2018   grade_8 38 107 28 0   32     1   14   114 106                       220.0 38 107 28 0   32     1   14   114 106                 220
2232007 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_8 198 3 21 0   2     0   5   115 114                       229.0 198 3 21 0   2     0   5   115 114                 229
2233993 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick: Wilson Middle   Regular School No Middle 05 08 2018   grade_8 175 9 14 1   11     0   18   115 113                       228.0 175 9 14 1   11     0   18   115 113                 228
2239776 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson: Whitman Middle   Regular School No Middle 06 08 2018   grade_8 177 6 10 0   2     0   4   115 84                       199.0 177 6 10 0   2     0   4   115 84                 199
2235191 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy: Central Middle   Regular School No Middle 06 08 2018   grade_8 103 5 7 0   90     1   6   116 96                       212.0 103 5 7 0   90     1   6   116 96                 212
2234577 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_8 180 3 5 1   22     3   7   117 104                       221.0 180 3 5 1   22     3   7   117 104                 221
2239481 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin: Quabbin Regional Middle School   Regular School No Middle 07 08 2018   grade_8 203 0 14 0   1     0   4   117 105                       222.0 203 0 14 0   1     0   4   117 105                 222
2235523 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich: Sandwich STEM Academy   Regular School No Middle 07 08 2018   grade_8 216 2 1 2   4     1   0   118 108                       226.0 216 2 1 2   4     1   0   118 108                 226
2237114 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford: Blanchard Middle   Regular School No Middle 06 08 2018   grade_8 144 3 2 1   65     1   2   118 100                       218.0 144 3 2 1   65     1   2   118 100                 218
2238391 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_8 1 136 115 0   1     0   2   118 137                       255.0 1 136 115 0   1     0   2   118 137                 255
2239399 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket: Pentucket Regional Middle   Regular School No Middle 07 08 2018   grade_8 199 0 8 0   6     0   2   118 97                       215.0 199 0 8 0   6     0   2   118 97                 215
2232152 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover: Hanover Middle   Regular School No Middle 05 08 2018   grade_8 204 2 3 0   7     0   0   119 97                       216.0 204 2 3 0   7     0   0   119 97                 216
2234728 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Norwood: Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2018   grade_8 169 27 26 0   9     0   4   119 116                       235.0 169 27 26 0   9     0   4   119 116                 235
2237274 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 Westwood: E W Thurston Middle   Regular School No Middle 06 08 2018   grade_8 202 11 9 0   34     0   5   119 142                       261.0 202 11 9 0   34     0   5   119 142                 261
2229378 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   grade_8 6 3 10 0   1     0   0   12 8                       20.0 6 3 10 0   1     0   0   12 8                 20
2229753 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_8 0 8 18 0   0     0   1   12 15                       27.0 0 8 18 0   0     0   1   12 15                 27
2229826 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston: Lyndon   Regular School No Elementary PK 08 2018   grade_8 6 6 17 0   1     0   2   12 20                       32.0 6 6 17 0   1     0   2   12 20                 32
2229996 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   grade_8 2 18 7 0   0     0   0   12 15                       27.0 2 18 7 0   0     0   0   12 15                 27
2238130 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_8 2 0 19 0   1     0   0   12 10                       22.0 2 0 19 0   1     0   0   12 10                 22
2230365 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree: East Middle School   Regular School No Middle 06 08 2018   grade_8 182 9 10 1   34     0   5   120 121                       241.0 182 9 10 1   34     0   5   120 121                 241
2231378 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 East Longmeadow: Birchland Park   Regular School No Middle 06 08 2018   grade_8 187 6 19 0   17     0   1   121 109                       230.0 187 6 19 0   17     0   1   121 109                 230
2236194 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield: Chestnut Academy   Regular School No Middle 06 08 2018   grade_8 9 26 190 1   1     0   2   121 108                       229.0 9 26 190 1   1     0   2   121 108                 229
2235068 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth: Plymouth South Middle   Regular School No Middle 06 08 2018   grade_8 219 2 7 0   2     0   8   122 116                       238.0 219 2 7 0   2     0   8   122 116                 238
2231302 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury: Duxbury Middle   Regular School No Middle 06 08 2018   grade_8 227 0 6 1   3     0   10   123 124                       247.0 227 0 6 1   3     0   10   123 124                 247
2231779 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough: John J Ahern   Regular School No Middle 05 08 2018   grade_8 184 9 18 2   6     0   4   123 100                       223.0 184 9 18 2   6     0   4   123 100                 223
2233145 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow: Paul R Baird Middle   Regular School No Middle 06 08 2018   grade_8 204 7 17 0   1     0   7   124 112                       236.0 204 7 17 0   1     0   7   124 112                 236
2233460 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead: Marblehead Veterans Middle School   Regular School No Middle 07 08 2018   grade_8 227 6 12 0   1     0   7   124 129                       253.0 227 6 12 0   1     0   7   124 129                 253
2237070 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 Westfield: North Middle School   Regular School No Middle 06 08 2018   grade_8 184 5 32 0   6     1   4   124 108                       232.0 184 5 32 0   6     1   4   124 108                 232
2230815 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton: Wm H Galvin Middle   Regular School No Middle 06 08 2018   grade_8 181 34 19 0   23     0   5   125 137                       262.0 181 34 19 0   23     0   5   125 137                 262
2236175 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 Springfield: M Marcus Kiley Middle   Regular School No Middle 06 08 2018   grade_8 26 53 143 0   6     0   2   125 105                       230.0 26 53 143 0   6     0   2   125 105                 230
2228815 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam: Agawam Junior High   Regular School No Middle 07 08 2018   grade_8 216 6 24 0   7     0   9   129 133                       262.0 216 6 24 0   7     0   9   129 133                 262
2236167 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield: Forest Park Middle   Regular School No Middle 06 08 2018   grade_8 13 51 163 0   20     1   3   129 122                       251.0 13 51 163 0   20     1   3   129 122                 251
2229718 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   grade_8 6 8 10 0   3     0   0   13 14                       27.0 6 8 10 0   3     0   0   13 14                 27
2230037 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_8 5 4 8 0   0     0   1   13 5                       18.0 5 4 8 0   0     0   1   13 5                 18
2230687 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_8 9 1 10 0   1     0   4   13 12                       25.0 9 1 10 0   1     0   4   13 12                 25
2231030 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_8 18 0 1 0   1     0   1   13 8                       21.0 18 0 1 0   1     0   1   13 8                 21
2236036 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield: Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2018   grade_8 5 8 13 0   0     0   2   13 15                       28.0 5 8 13 0   0     0   2   13 15                 28
2236178 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield: Springfield Public Day Middle School   Regular School No Middle 06 08 2018   grade_8 1 3 13 0   0     0   0   13 4                       17.0 1 3 13 0   0     0   0   13 4                 17
2238213 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2018   grade_8 23 0 6 0   1     0   2   13 19                       32.0 23 0 6 0   1     0   2   13 19                 32
2238228 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter (District): Holyoke Community Charter School   Regular School Yes Elementary KG 08 2018   grade_8 2 2 39 0   0     0   0   13 30                       43.0 2 2 39 0   0     0   0   13 30                 43
2232475 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton: Hopkinton Middle School   Regular School No Middle 06 08 2018   grade_8 228 2 3 1   35     0   8   130 147                       277.0 228 2 3 1   35     0   8   130 147                 277
2231006 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_8 163 7 87 0   4     0   5   131 135                       266.0 163 7 87 0   4     0   5   131 135                 266
2236547 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 Tewksbury: John W. Wynn Middle   Regular School No Middle 07 08 2018   grade_8 285 6 9 0   10     0   2   131 181                       312.0 285 6 9 0   10     0   2   131 181                 312
2235608 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate: Gates Middle School   Regular School No Middle 06 08 2018   grade_8 249 12 0 0   6     0   3   132 138                       270.0 249 12 0 0   6     0   3   132 138                 270
2239363 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester: Old Rochester Regional Jr High   Regular School No Middle 07 08 2018   grade_8 238 5 5 0   3     0   10   133 128                       261.0 238 5 5 0   3     0   10   133 128                 261
2231859 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_8 133 12 82 0   21     0   9   134 123                       257.0 133 12 82 0   21     0   9   134 123                 257
2232050 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton: Grafton Middle   Regular School No Middle 07 08 2018   grade_8 215 3 9 0   31     0   9   135 132                       267.0 215 3 9 0   31     0   9   135 132                 267
2236331 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton: O'Donnell Middle School   Regular School No Middle 06 08 2018   grade_8 139 53 19 0   13     1   17   135 107                       242.0 139 53 19 0   13     1   17   135 107                 242
2236649 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Wakefield: Galvin Middle School   Regular School No Middle 05 08 2018   grade_8 248 7 12 1   11     0   5   136 148                       284.0 248 7 12 1   11     0   5   136 148                 284
2234201 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford: Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_8 95 44 111 1   2     1   9   138 125                       263.0 95 44 111 1   2     1   9   138 125                 263
2233724 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose: Melrose Middle   Regular School No Middle 06 08 2018   grade_8 220 14 6 0   12     0   13   139 126                       265.0 220 14 6 0   12     0   13   139 126                 265
2233797 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough: John T. Nichols Middle   Regular School No Middle 06 08 2018   grade_8 247 6 13 1   2     0   5   139 135                       274.0 247 6 13 1   2     0   5   139 135                 274
2231284 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Dracut: Justus C. Richardson Middle School   Regular School No Middle 06 08 2018   grade_8 238 25 20 0   21     0   7   141 170                       311.0 238 25 20 0   21     0   7   141 170                 311
2232878 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington: Wm Diamond Middle   Regular School No Middle 06 08 2018   grade_8 159 11 4 0   107     0   20   141 160                       301.0 159 11 4 0   107     0   20   141 160                 301

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