Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2019 sorted by male

View and edit SQL

year

  • 2019 · 493

grade

  • grade_8 · 493
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
2040175 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_8 6 0 0 0   0     0   0   1 4                       6.0 6 0 0 0   0     0   0   1 4                 6
2045508 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2019   grade_8 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2045829 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 08 12 2019   grade_8 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2041466 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_8 14 2 13 0   0     0   7   10 26                       36.0 14 2 13 0   0     0   7   10 26                 36
2046108 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_8 5 15 36 0   0     0   1   10 47                       57.0 5 15 36 0   0     0   1   10 47                 57
2047680 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_8 0 17 1 0   0     0   0   10 8                       18.0 0 17 1 0   0     0   0   10 8                 18
2047850 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_8 12 2 3 0   0     0   2   10 9                       19.0 12 2 3 0   0     0   2   10 9                 19
2042329 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_8 56 15 107 0   13     0   9   100 100                       200.0 56 15 107 0   13     0   9   100 100                 200
2044736 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2019   grade_8 163 2 11 0   0     0   8   100 84                       184.0 163 2 11 0   0     0   8   100 84                 184
2046666 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2019   grade_8 135 12 9 0   38     0   16   100 110                       210.0 135 12 9 0   38     0   16   100 110                 210
2041304 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2019   grade_8 43 117 37 0   7     0   10   102 112                       214.0 43 117 37 0   7     0   10   102 112                 214
2045355 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_8 94 6 88 1   6     1   2   102 96                       198.0 94 6 88 1   6     1   2   102 96                 198
2046575 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2019   grade_8 82 23 63 0   10     0   2   102 78                       180.0 82 23 63 0   10     0   2   102 78                 180
2046578 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2019   grade_8 81 19 93 0   6     0   5   102 102                       204.0 81 19 93 0   6     0   5   102 102                 204
2046859 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2019   grade_8 133 1 1 0   58     0   1   102 92                       194.0 133 1 1 0   58     0   1   102 92                 194
2042994 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_8 179 4 22 0   2     0   8   103 112                       215.0 179 4 22 0   2     0   8   103 112                 215
2043907 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2019   grade_8 190 3 4 1   11     0   8   103 114                       217.0 190 3 4 1   11     0   8   103 114                 217
2046072 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2019   grade_8 22 56 94 2   6     0   1   103 78                       181.0 22 56 94 2   6     0   1   103 78                 181
2048457 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2019   grade_8 159 1 4 1   10     1   3   103 76                       179.0 159 1 4 1   10     1   3   103 76                 179
2041296 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2019   grade_8 35 133 13 0   1     0   6   104 84                       188.0 35 133 13 0   1     0   6   104 84                 188
2042264 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_8 114 14 41 1   13     0   16   104 95                       199.0 114 14 41 1   13     0   16   104 95                 199
2042794 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_8 97 4 101 0   5     1   2   104 106                       210.0 97 4 101 0   5     1   2   104 106                 210
2043659 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2019   grade_8 69 19 81 2   22     0   12   104 101                       205.0 69 19 81 2   22     0   12   104 101                 205
2044545 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2019   grade_8 133 9 13 0   59     0   17   104 127                       231.0 133 9 13 0   59     0   17   104 127                 231
2048118 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2019   grade_8 108 15 30 0   21     0   19   105 88                       193.0 108 15 30 0   21     0   19   105 88                 193
2049010 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No Middle 07 08 2019   grade_8 195 2 4 0   1     0   2   105 99                       204.0 195 2 4 0   1     0   2   105 99                 204
2049370 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_8 163 16 31 2   8     0   11   105 126                       231.0 163 16 31 2   8     0   11   105 126                 231
2040151 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2019   grade_8 178 3 6 0   3     1   6   106 91                       197.0 178 3 6 0   3     1   6   106 91                 197
2040299 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_8 181 9 10 0   12     1   4   107 110                       217.0 181 9 10 0   12     1   4   107 110                 217
2044726 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2019   grade_8 154 5 13 1   13     2   9   107 90                       197.0 154 5 13 1   13     2   9   107 90                 197
2048529 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2019   grade_8 182 5 11 2   6     0   4   107 103                       210.0 182 5 11 2   6     0   4   107 103                 210
2045555 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2019   grade_8 140 14 42 1   7     1   6   108 103                       211.0 140 14 42 1   7     1   6   108 103                 211
2041187 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2019   grade_8 174 5 9 1   37     0   3   109 120                       229.0 174 5 9 1   37     0   3   109 120                 229
2045714 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2019   grade_8 186 4 8 0   2     0   6   109 97                       206.0 186 4 8 0   2     0   6   109 97                 206
2040624 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_8 12 7 9 0   0     0   0   11 17                       28.0 12 7 9 0   0     0   0   11 17                 28
2040655 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_8 0 6 20 0   0     0   0   11 15                       26.0 0 6 20 0   0     0   0   11 15                 26
2046096 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2019   grade_8 0 3 17 0   0     0   2   11 11                       22.0 0 3 17 0   0     0   2   11 11                 22
2047704 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 2019   grade_8 1 0 18 0   1     0   0   11 9                       20.0 1 0 18 0   1     0   0   11 9                 20
2047813 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 18 1 7 0   0     0   1   11 16                       27.0 18 1 7 0   0     0   1   11 16                 27
2047921 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_8 24 1 1 0   0     0   2   11 17                       28.0 24 1 1 0   0     0   2   11 17                 28
2043783 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2019   grade_8 207 11 12 0   4     0   2   111 125                       236.0 207 11 12 0   4     0   2   111 125                 236
2044232 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2019   grade_8 167 11 14 0   14     0   15   111 110                       221.0 167 11 14 0   14     0   15   111 110                 221
2041575 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2019   grade_8 172 20 8 0   22     1   12   112 123                       235.0 172 20 8 0   22     1   12   112 123                 235
2045522 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2019   grade_8 211 2 2 3   6     0   1   112 113                       225.0 211 2 2 3   6     0   1   112 113                 225
2041310 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2019   grade_8 51 93 72 1   7     0   9   113 120                       233.0 51 93 72 1   7     0   9   113 120                 233
2045248 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_8 106 8 7 0   92     0   5   113 105                       218.0 106 8 7 0   92     0   5   113 105                 218
2042865 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2019   grade_8 171 3 18 2   20     0   5   115 104                       219.0 171 3 18 2   20     0   5   115 104                 219
2044539 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2019   grade_8 153 5 14 0   48     0   19   116 123                       239.0 153 5 14 0   48     0   19   116 123                 239
2049135 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2019   grade_8 164 9 11 3   3     1   7   116 82                       198.0 164 9 11 3   3     1   7   116 82                 198
2042267 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2019   grade_8 144 23 51 0   7     0   17   117 125                       242.0 144 23 51 0   7     0   17   117 125                 242
2042580 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_8 164 5 16 1   3     1   17   117 90                       207.0 164 5 16 1   3     1   17   117 90                 207
2044622 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_8 150 5 47 1   5     0   12   117 103                       220.0 150 5 47 1   5     0   12   117 103                 220
2044068 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_8 218 6 10 5   6     0   12   118 139                       257.0 218 6 10 5   6     0   12   118 139                 257
2045498 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2019   grade_8 111 18 88 1   7     0   7   119 113                       232.0 111 18 88 1   7     0   7   119 113                 232
2047933 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_8 4 153 91 0   1     1   0   119 131                       250.0 4 153 91 0   1     1   0   119 131                 250
2040349 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_8 2 9 16 0   1     0   0   12 16                       28.0 2 9 16 0   1     0   0   12 16                 28
2040881 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_8 1 12 10 0   0     0   1   12 12                       24.0 1 12 10 0   0     0   1   12 12                 24
2042279 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_8 13 2 4 0   0     0   2   12 9                       21.0 13 2 4 0   0     0   2   12 9                 21
2044417 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_8 9 3 7 0   0     0   1   12 8                       20.0 9 3 7 0   0     0   1   12 8                 20
2041301 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2019   grade_8 22 146 30 0   6     0   11   120 95                       215.0 22 146 30 0   6     0   11   120 95                 215
2046079 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2019   grade_8 10 34 154 1   21     0   3   120 103                       223.0 10 34 154 1   21     0   3   120 103                 223
2040079 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_8 182 4 24 0   7     0   4   121 100                       221.0 182 4 24 0   7     0   4   121 100                 221
2041004 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_8 97 63 67 0   57     1   13   121 176                       298.0 97 63 67 0   57     1   13   121 176                 298
2046979 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2019   grade_8 204 11 10 0   19     0   11   121 134                       255.0 204 11 10 0   19     0   11   121 134                 255
2048316 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_8 171 23 20 4   5     0   11   122 112                       234.0 171 23 20 4   5     0   11   122 112                 234
2044157 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2019   grade_8 201 55 14 0   19     0   5   123 171                       294.0 201 55 14 0   19     0   5   123 171                 294
2048816 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2019   grade_8 195 1 6 0   2     0   3   123 84                       207.0 195 1 6 0   2     0   3   123 84                 207
2041184 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2019   grade_8 170 24 12 1   36     1   5   125 123                       249.0 170 24 12 1   36     1   5   125 123                 249
2042603 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_8 214 7 8 0   30     0   6   125 140                       265.0 214 7 8 0   30     0   6   125 140                 265
2047066 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_8 213 4 11 0   10     0   10   125 123                       248.0 213 4 11 0   10     0   10   125 123                 248
2044003 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2019   grade_8 204 15 9 0   14     0   11   126 127                       253.0 204 15 9 0   14     0   11   126 127                 253
2045145 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2019   grade_8 210 1 9 2   2     0   8   126 106                       232.0 210 1 9 2   2     0   8   126 106                 232
2045642 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2019   grade_8 150 14 16 0   82     1   12   127 148                       275.0 150 14 16 0   82     1   12   127 148                 275
2046218 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_8 136 60 28 1   21     0   13   127 132                       259.0 136 60 28 1   21     0   13   127 132                 259
2046085 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2019   grade_8 23 50 162 0   5     0   1   128 113                       241.0 23 50 162 0   5     0   1   128 113                 241
2041813 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2019   grade_8 207 13 9 1   12     0   13   129 125                       255.0 207 13 9 1   12     0   13   129 125                 255
2045006 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2019   grade_8 235 3 1 0   4     0   0   129 114                       243.0 235 3 1 0   4     0   0   129 114                 243
2048249 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2019   grade_8 224 10 3 1   4     0   7   129 120                       249.0 224 10 3 1   4     0   7   129 120                 249
2040784 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_8 0 6 18 0   0     0   1   13 12                       25.0 0 6 18 0   0     0   1   13 12                 25
2045961 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_8 7 7 12 0   0     0   3   13 16                       29.0 7 7 12 0   0     0   3   13 16                 29
2048519 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   grade_8 13 0 2 0   0     0   0   13 2                       15.0 13 0 2 0   0     0   0   13 2                 15
2048785 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2019   grade_8 206 2 5 0   4     0   8   130 95                       225.0 206 2 5 0   4     0   8   130 95                 225
2044403 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_8 119 40 97 1   2     1   14   131 143                       274.0 119 40 97 1   2     1   14   131 143                 274
2042052 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2019   grade_8 188 12 19 0   10     0   4   132 101                       233.0 188 12 19 0   10     0   4   132 101                 233
2044852 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2019   grade_8 167 36 36 0   12     0   7   132 126                       258.0 167 36 36 0   12     0   7   132 126                 258
2048409 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2019   grade_8 238 3 3 0   2     0   2   132 116                       248.0 238 3 3 0   2     0   2   132 116                 248
2042458 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_8 138 14 72 0   13     0   5   134 108                       242.0 138 14 72 0   13     0   5   134 108                 242
2041743 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_8 116 13 100 0   7     0   8   135 109                       244.0 116 13 100 0   7     0   8   135 109                 244
2044409 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_8 102 38 107 1   0     0   18   136 130                       266.0 102 38 107 1   0     0   18   136 130                 266
2046259 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2019   grade_8 232 8 10 0   27     0   21   137 161                       298.0 232 8 10 0   27     0   21   137 161                 298
2046483 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2019   grade_8 213 10 15 0   7     1   5   137 114                       251.0 213 10 15 0   7     1   5   137 114                 251
2041740 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2019   grade_8 129 10 101 0   2     0   9   138 113                       251.0 129 10 101 0   2     0   9   138 113                 251
2041855 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2019   grade_8 238 6 20 0   7     0   9   139 141                       280.0 238 6 20 0   7     0   9   139 141                 280
2049081 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2019   grade_8 224 9 10 0   13     0   5   139 122                       261.0 224 9 10 0   13     0   5   139 122                 261
2040847 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_8 2 15 7 0   0     0   1   14 11                       25.0 2 15 7 0   0     0   1   14 11                 25
2044423 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_8 3 5 4 0   1     0   3   14 2                       16.0 3 5 4 0   1     0   3   14 2                 16
2041988 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2019   grade_8 234 0 6 0   2     0   9   140 111                       251.0 234 0 6 0   2     0   9   140 111                 251
2048905 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No Middle 07 08 2019   grade_8 253 3 4 1   2     0   1   140 124                       264.0 253 3 4 1   2     0   1   140 124                 264
2041443 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2019   grade_8 192 15 19 0   29     0   12   141 126                       267.0 192 15 19 0   29     0   12   141 126                 267
2046862 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2019   grade_8 175 0 1 0   74     0   4   144 110                       254.0 175 0 1 0   74     0   4   144 110                 254

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