Data source: Big Local News · About: Big Local

396 rows where grade = "grade_10", state = "MA" and year = 2017 sorted by black descending

View and edit SQL

year

  • 2017 · 396

grade

  • grade_10 · 396
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
1128426 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2017   grade_10 9 93 19 0   24     0   9   87 67                       154 9 93 19 0   24     0   9   87 67                 154
1123311 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2017   grade_10 3 92 129 0   2     0   8   127 107                       234 3 92 129 0   2     0   8   127 107                 234
1124685 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2017   grade_10 148 92 244 1   21     1   7   265 249                       514 148 92 244 1   21     1   7   265 249                 514
1126301 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_10 226 92 178 0   248     0   19   371 392                       763 226 92 178 0   248     0   19   371 392                 763
1126594 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_10 135 90 97 3   109     0   13   216 231                       447 135 90 97 3   109     0   13   216 231                 447
1122120 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2017   grade_10 352 9 18 0   69     0   11   204 255                       459 352 9 18 0   69     0   11   204 255                 459
1123457 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_10 3 9 14 1   0     0   0   10 17                       27 3 9 14 1   0     0   0   10 17                 27
1123851 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2017   grade_10 186 9 12 1   32     0   9   112 137                       249 186 9 12 1   32     0   9   112 137                 249
1124329 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2017   grade_10 218 9 15 0   6     0   3   124 127                       251 218 9 15 0   6     0   3   124 127                 251
1124807 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No High 09 12 2017   grade_10 27 9 17 0   1     0   3   36 21                       57 27 9 17 0   1     0   3   36 21                 57
1124954 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2017   grade_10 184 9 4 0   7     0   1   115 90                       205 184 9 4 0   7     0   1   115 90                 205
1126642 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2017   grade_10 232 9 16 1   6     0   3   123 144                       267 232 9 16 1   6     0   3   123 144                 267
1129615 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No High 09 12 2017   grade_10 145 9 9 0   6     1   4   85 89                       174 145 9 9 0   6     1   4   85 89                 174
1129838 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2017   grade_10 197 9 6 0   10     1   5   105 123                       228 197 9 6 0   10     1   5   105 123                 228
1131145 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_10 34 9 6 0   1     0   3   26 27                       53 34 9 6 0   1     0   3   26 27                 53
1131519 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2017   grade_10 44 9 7 0   1     0   7   19 49                       68 44 9 7 0   1     0   7   19 49                 68
1123271 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   grade_10 7 83 94 1   1     0   3   114 75                       189 7 83 94 1   1     0   3   114 75                 189
1123286 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2017   grade_10 1 8 3 0   0     0   1   10 *                       13 1 8 3 0   0     0   1   10                   13
1126681 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2017   grade_10 130 8 144 0   4     0   6   153 139                       292 130 8 144 0   4     0   6   153 139                 292
1128476 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2017   grade_10 302 8 6 0   16     0   1   168 165                       333 302 8 6 0   16     0   1   168 165                 333
1128743 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2017   grade_10 140 8 19 1   8     0   0   80 96                       176 140 8 19 1   8     0   0   80 96                 176
1128792 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2017   grade_10 201 8 0 0   3     0   1   102 111                       213 201 8 0 0   3     0   1   102 111                 213
1129416 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No High 09 12 2017   grade_10 2 8 18 0   0     0   0   18 10                       28 2 8 18 0   0     0   0   18 10                 28
1130401 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No High 09 12 2017   grade_10 216 8 52 0   20     0   5   162 139                       301 216 8 52 0   20     0   5   162 139                 301
1131653 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes Other 05 12 2017   grade_10 22 8 13 1   1     0   1   22 24                       46 22 8 13 1   1     0   1   22 24                 46
1132082 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   grade_10 209 8 8 1   4     0   7   111 126                       237 209 8 8 1   4     0   7   111 126                 237
1132372 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_10 91 8 3 0   3     0   5   64 46                       110 91 8 3 0   3     0   5   64 46                 110
1132483 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2017   grade_10 212 8 11 0   11     0   11   119 134                       253 212 8 11 0   11     0   11   119 134                 253
1133098 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2017   grade_10 255 8 58 1   4     0   12   183 155                       338 255 8 58 1   4     0   12   183 155                 338
1133155 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes Other 09 11 2017   grade_10 20 8 23 0   1     0   3   28 27                       55 20 8 23 0   1     0   3   28 27                 55
1123296 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2017   grade_10 3 72 33 0   0     0   1   53 56                       109 3 72 33 0   0     0   1   53 56                 109
1129703 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_10 314 71 57 0   14     4   23   261 221                       483 314 71 57 0   14     4   23   261 221                 483
1129517 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2017   grade_10 180 70 18 0   13     0   1   148 134                       282 180 70 18 0   13     0   1   148 134                 282
1122548 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2017   grade_10 228 7 13 1   15     1   9   135 139                       274 228 7 13 1   15     1   9   135 139                 274
1124863 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   grade_10 170 7 9 3   9     0   9   97 110                       207 170 7 9 3   9     0   9   97 110                 207
1125094 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   grade_10 371 7 8 1   27     2   8   205 219                       424 371 7 8 1   27     2   8   205 219                 424
1126506 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_10 4 7 16 1   0     0   1   14 15                       29 4 7 16 1   0     0   1   14 15                 29
1127016 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2017   grade_10 186 7 68 6   10     0   4   147 134                       281 186 7 68 6   10     0   4   147 134                 281
1128894 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2017   grade_10 282 7 33 0   96     1   9   186 242                       428 282 7 33 0   96     1   9   186 242                 428
1129018 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2017   grade_10 7 7 5 0   1     0   1   12 9                       21 7 7 5 0   1     0   1   12 9                 21
1129342 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No Other 06 11 2017   grade_10 7 7 25 0   0     0   1   28 12                       40 7 7 25 0   0     0   1   28 12                 40
1130022 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2017   grade_10 121 7 27 0   11     0   6   93 79                       172 121 7 27 0   11     0   6   93 79                 172
1130449 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2017   grade_10 231 7 6 0   14     0   2   132 128                       260 231 7 6 0   14     0   2   132 128                 260
1131738 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_10 297 7 18 0   153     0   17   258 234                       492 297 7 18 0   153     0   17   258 234                 492
1131761 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_10 80 7 3 1   3     0   0   43 51                       94 80 7 3 1   3     0   0   43 51                 94
1132316 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2017   grade_10 126 7 28 3   2     1   3   91 79                       170 126 7 28 3   2     1   3   91 79                 170
1132906 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2017   grade_10 523 7 26 0   26     1   6   267 322                       589 523 7 26 0   26     1   6   267 322                 589
1132968 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2017   grade_10 263 7 5 2   4     0   10   141 150                       291 263 7 5 2   4     0   10   141 150                 291
1132993 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 110 7 14 6   2     1   11   91 60                       151 110 7 14 6   2     1   11   91 60                 151
1133028 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2017   grade_10 79 7 88 2   0     0   6   111 71                       182 79 7 88 2   0     0   6   111 71                 182
1123338 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_10 73 66 77 3   67     0   7   115 178                       293 73 66 77 3   67     0   7   115 178                 293
1131061 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2017   grade_10 82 66 145 2   51     0   13   177 182                       359 82 66 145 2   51     0   13   177 182                 359
1123700 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_10 218 642 115 4   27     1   41   515 533                       1048 218 642 115 4   27     1   41   515 533                 1048
1123422 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No High 09 12 2017   grade_10 15 63 49 0   1     1   1   66 64                       130 15 63 49 0   1     1   1   66 64                 130
1129406 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2017   grade_10 29 63 195 0   7     0   5   157 142                       299 29 63 195 0   7     0   5   157 142                 299
1131056 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2017   grade_10 53 63 157 2   22     0   11   165 143                       308 53 63 157 2   22     0   11   165 143                 308
1127385 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_10 160 62 268 6   7     2   22   299 228                       527 160 62 268 6   7     2   22   299 228                 527
1122012 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_10 270 6 20 0   7     0   6   164 145                       309 270 6 20 0   7     0   6   164 145                 309
1123657 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_10 0 6 2 0   0     0   0   7 1                       8 0 6 2 0   0     0   0   7 1                 8
1124203 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2017   grade_10 248 6 106 0   12     0   8   187 193                       380 248 6 106 0   12     0   8   187 193                 380
1125926 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No High 09 12 2017   grade_10 93 6 2 0   2     1   1   55 50                       105 93 6 2 0   2     1   1   55 50                 105
1129734 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2017   grade_10 218 6 3 0   7     0   1   125 110                       235 218 6 3 0   7     0   1   125 110                 235
1130052 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2017   grade_10 144 6 9 0   35     0   10   109 95                       204 144 6 9 0   35     0   10   109 95                 204
1130069 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2017   grade_10 106 6 16 0   3     0   5   76 60                       136 106 6 16 0   3     0   5   76 60                 136
1131247 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_10 83 6 6 0   5     0   4   47 57                       104 83 6 6 0   5     0   4   47 57                 104
1131609 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   grade_10 169 6 15 3   9     1   11   84 130                       214 169 6 15 3   9     1   11   84 130                 214
1131844 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2017   grade_10 87 6 12 0   3     0   11   60 59                       119 87 6 12 0   3     0   11   60 59                 119
1132258 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2017   grade_10 263 6 17 0   8     0   9   157 146                       303 263 6 17 0   8     0   9   157 146                 303
1132279 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2017   grade_10 301 6 3 0   6     0   2   181 137                       318 301 6 3 0   6     0   2   181 137                 318
1133008 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2017   grade_10 287 6 31 2   3     0   18   184 163                       347 287 6 31 2   3     0   18   184 163                 347
1133013 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 69 6 316 0   2     0   0   200 193                       393 69 6 316 0   2     0   0   200 193                 393
1133192 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_10 52 6 11 2   0     1   3   25 50                       75 52 6 11 2   0     1   3   25 50                 75
1129440 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2017   grade_10 43 59 251 0   6     0   1   164 196                       360 43 59 251 0   6     0   1   164 196                 360
1131066 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   grade_10 121 59 118 0   15     0   12   142 183                       325 121 59 118 0   15     0   12   142 183                 325
1131560 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_10 1 58 45 1   1     0   3   48 61                       109 1 58 45 1   1     0   3   48 61                 109
1123388 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2017   grade_10 2 56 15 0   1     0   2   40 36                       76 2 56 15 0   1     0   2   40 36                 76
1129411 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2017   grade_10 41 56 243 0   7     0   4   196 155                       351 41 56 243 0   7     0   4   196 155                 351
1131260 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2017   grade_10 1 56 8 0   0     0   2   22 45                       67 1 56 8 0   0     0   2   22 45                 67
1132983 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 122 56 30 2   2     0   8   123 97                       220 122 56 30 2   2     0   8   123 97                 220
1133132 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2017   grade_10 1 56 11 0   3     0   0   29 42                       71 1 56 11 0   3     0   0   29 42                 71
1131046 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2017   grade_10 90 53 122 1   21     0   18   169 136                       305 90 53 122 1   21     0   18   169 136                 305
1123281 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2017   grade_10 7 52 93 0   34     0   2   117 71                       188 7 52 93 0   34     0   2   117 71                 188
1123343 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2017   grade_10 15 51 47 0   7     0   5   49 76                       125 15 51 47 0   7     0   5   49 76                 125
1129013 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No High 09 12 2017   grade_10 103 50 151 0   34     0   3   187 154                       341 103 50 151 0   34     0   3   187 154                 341
1131051 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2017   grade_10 159 50 121 2   34     0   19   203 182                       385 159 50 121 2   34     0   19   203 182                 385
1131153 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_10 3 50 12 0   1     0   1   35 32                       67 3 50 12 0   1     0   1   35 32                 67
1122277 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_10 168 5 8 0   11     0   5   97 100                       197 168 5 8 0   11     0   5   97 100                 197
1122364 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2017   grade_10 164 5 11 0   3     0   2   102 83                       185 164 5 11 0   3     0   2   102 83                 185
1124248 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_10 107 5 1 0   2     0   1   62 54                       116 107 5 1 0   2     0   1   62 54                 116
1125224 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2017   grade_10 177 5 9 0   31     1   5   108 120                       228 177 5 9 0   31     1   5   108 120                 228
1125287 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2017   grade_10 61 5 11 0   4     0   6   48 39                       87 61 5 11 0   4     0   6   48 39                 87
1126141 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2017   grade_10 202 5 9 0   20     1   3   127 113                       240 202 5 9 0   20     1   3   127 113                 240
1126325 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2017   grade_10 200 5 25 1   3     0   2   119 117                       236 200 5 25 1   3     0   2   119 117                 236
1127396 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No Other 06 12 2017   grade_10 6 5 11 0   0     0   2   18 6                       24 6 5 11 0   0     0   2   18 6                 24
1127591 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   grade_10 73 5 6 0   0     0   6   34 56                       90 73 5 6 0   0     0   6   34 56                 90
1127630 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2017   grade_10 160 5 26 0   14     0   8   101 112                       213 160 5 26 0   14     0   8   101 112                 213
1127960 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2017   grade_10 73 5 6 0   3     0   5   42 50                       92 73 5 6 0   3     0   5   42 50                 92
1129470 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham High   Regular School No High 09 12 2017   grade_10 152 5 13 0   4     0   4   86 92                       178 152 5 13 0   4     0   4   86 92                 178
1130164 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2017   grade_10 183 5 12 0   59     0   8   129 138                       267 183 5 12 0   59     0   8   129 138                 267
1130568 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2017   grade_10 186 5 7 1   11     0   5   112 103                       215 186 5 7 1   11     0   5   112 103                 215

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