enrollments

Data source: Big Local News · About: Big Local

392 rows where grade = "grade_9", state = "MA" and year = 2016 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 392 ✖

grade ✖

  • grade_9 · 392 ✖
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
933754 933754 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2016   grade_9 33 96 91 2   69     1   6   136 162                       298 33 96 91 2   69     1   6   136 162                 298
936207 936207 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_9 253 96 223 0   259     0   24   432 423                       855 253 96 223 0   259     0   24   432 423                 855
938811 938811 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_9 43 94 303 0   4     0   8   239 213                       452 43 94 303 0   4     0   8   239 213                 452
934859 934859 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2016   grade_9 164 90 235 3   24     1   8   281 244                       525 164 90 235 3   24     1   8   281 244                 525
932677 932677 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_9 367 9 17 0   66     0   12   209 262                       471 367 9 17 0   66     0   12   209 262                 471
933825 933825 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative Education School No 3 08 12 2016   grade_9 1 9 6 1   0     0   0   8 9                       17 1 9 6 1   0     0   0   8 9                 17
933993 933993 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 4 06 12 2016   grade_9 3 9 0 0   0     0   0   9 3                       12 3 9 0 0   0     0   0   9 3                 12
934563 934563 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2016   grade_9 225 9 15 0   7     0   3   129 130                       259 225 9 15 0   7     0   3   129 130                 259
938294 938294 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2016   grade_9 199 9 0 0   3     0   2   101 112                       213 199 9 0 0   3     0   2   101 112                 213
938988 938988 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2016   grade_9 149 9 11 0   6     1   6   87 95                       182 149 9 11 0   6     1   6   87 95                 182
942018 942018 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 4 KG 12 2016   grade_9 44 9 10 1   2     1   1   30 38                       68 44 9 10 1   2     1   1   30 38                 68
933670 933670 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2016   grade_9 17 89 147 0   33     0   2   182 106                       288 17 89 147 0   33     0   2   182 106                 288
933661 933661 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2016   grade_9 6 88 116 1   3     0   5   139 80                       219 6 88 116 1   3     0   5   139 80                 219
940357 940357 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 3 09 12 2016   grade_9 2 87 17 0   0     0   2   46 62                       108 2 87 17 0   0     0   2   46 62                 108
933684 933684 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2016   grade_9 4 84 41 0   1     0   2   75 57                       132 4 84 41 0   1     0   2   75 57                 132
933697 933697 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   grade_9 3 83 119 0   2     0   6   113 100                       213 3 83 119 0   2     0   6   113 100                 213
934158 934158 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2016   grade_9 189 8 8 1   33     0   9   112 136                       248 189 8 8 1   33     0   9   112 136                 248
934680 934680 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2016   grade_9 176 8 16 0   14     0   4   106 112                       218 176 8 16 0   14     0   4   106 112                 218
935086 935086 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No 3 09 12 2016   grade_9 183 8 3 0   8     0   1   112 91                       203 183 8 3 0   8     0   1   112 91                 203
936521 936521 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2016   grade_9 133 8 127 0   4     0   6   144 134                       278 133 8 127 0   4     0   6   144 134                 278
936775 936775 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No 3 09 12 2016   grade_9 164 8 9 0   4     0   9   90 104                       194 164 8 9 0   4     0   9   90 104                 194
937849 937849 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No 3 09 12 2016   grade_9 291 8 28 2   7     0   16   177 175                       352 291 8 28 2   7     0   16   177 175                 352
938035 938035 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2016   grade_9 299 8 5 0   15     0   1   165 163                       328 299 8 5 0   15     0   1   165 163                 328
939165 939165 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No 3 09 12 2016   grade_9 194 8 5 0   7     1   5   99 121                       220 194 8 5 0   7     1   5   99 121                 220
939296 939296 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No 3 09 12 2016   grade_9 101 8 10 0   3     0   19   79 62                       141 101 8 10 0   3     0   19   79 62                 141
939525 939525 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No 3 09 12 2016   grade_9 244 8 38 0   12     0   6   134 174                       308 244 8 38 0   12     0   6   134 174                 308
939636 939636 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No 3 09 12 2016   grade_9 224 8 66 0   22     0   5   171 154                       325 224 8 66 0   22     0   5   171 154                 325
939677 939677 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No 3 09 12 2016   grade_9 231 8 6 0   14     0   1   134 126                       260 231 8 6 0   14     0   1   134 126                 260
940727 940727 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_9 25 8 14 1   1     0   1   24 26                       50 25 8 14 1   1     0   1   24 26                 50
941431 941431 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No 3 09 12 2016   grade_9 216 8 11 0   9     0   11   123 132                       255 216 8 11 0   9     0   11   123 132                 255
933763 933763 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2016   grade_9 7 70 20 0   0     0   2   57 42                       99 7 70 20 0   0     0   2   57 42                 99
932876 932876 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2016   grade_9 167 7 11 0   3     0   4   104 88                       192 167 7 11 0   3     0   4   104 88                 192
933675 933675 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No 3 09 12 2016   grade_9 0 7 0 0   0     0   0   5 2                       7 0 7 0 0   0     0   0   5 2                 7
934450 934450 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2016   grade_9 108 7 73 0   2     0   4   91 103                       194 108 7 73 0   2     0   4   91 103                 194
934455 934455 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2016   grade_9 269 7 108 0   14     0   8   204 202                       406 269 7 108 0   14     0   8   204 202                 406
935200 935200 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   grade_9 380 7 5 2   26     2   8   209 221                       430 380 7 5 2   26     2   8   209 221                 430
936222 936222 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2016   grade_9 210 7 22 1   0     0   4   124 120                       244 210 7 22 1   0     0   4   124 120                 244
938252 938252 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No 3 09 12 2016   grade_9 148 7 16 1   8     1   0   84 97                       181 148 7 16 1   8     1   0   84 97                 181
939444 939444 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No 3 09 12 2016   grade_9 184 7 12 0   59     0   8   129 141                       270 184 7 12 0   59     0   8   129 141                 270
941876 941876 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 300 7 31 2   3     0   22   185 180                       365 300 7 31 2   3     0   22   185 180                 365
941893 941893 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Vocational Education School No 3 09 12 2016   grade_9 75 7 82 2   1     0   5   103 69                       172 75 7 82 2   1     0   5   103 69                 172
941962 941962 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes 3 09 12 2016   grade_9 12 7 102 0   0     0   0   54 67                       121 12 7 102 0   0     0   0   54 67                 121
934024 934024 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_9 267 694 166 5   26     3   51   637 575                       1212 267 694 166 5   26     3   51   637 575                 1212
933693 933693 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No 3 09 12 2016   grade_9 5 69 117 0   5     0   3   132 67                       199 5 69 117 0   5     0   3   132 67                 199
933720 933720 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2016   grade_9 81 69 84 3   71     0   7   126 189                       315 81 69 84 3   71     0   7   126 189                 315
938906 938906 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No 3 09 12 2016   grade_9 203 69 18 0   12     0   4   163 143                       306 203 69 18 0   12     0   4   163 143                 306
939058 939058 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_9 339 69 58 0   14     3   22   272 233                       505 339 69 58 0   14     3   22   272 233                 505
937113 937113 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_9 209 68 261 9   4     1   25   339 238                       577 209 68 261 9   4     1   25   339 238                 577
933758 933758 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2016   grade_9 9 67 54 0   1     0   7   91 47                       138 9 67 54 0   1     0   7   91 47                 138
938816 938816 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_9 58 65 328 0   9     0   7   281 186                       467 58 65 328 0   9     0   7   281 186                 467
940194 940194 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No 3 09 12 2016   grade_9 90 65 138 2   49     0   13   178 179                       357 90 65 138 2   49     0   13   178 179                 357
940190 940190 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No 3 09 12 2016   grade_9 57 64 153 3   18     0   12   158 149                       307 57 64 153 3   18     0   12   158 149                 307
940198 940198 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2016   grade_9 126 61 121 0   16     0   12   147 189                       336 126 61 121 0   16     0   12   147 189                 336
932546 932546 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_9 93 6 6 0   0     1   4   51 59                       110 93 6 6 0   0     1   4   51 59                 110
932588 932588 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2016   grade_9 278 6 23 0   6     0   6   168 151                       319 278 6 23 0   6     0   6   168 151                 319
932805 932805 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   grade_9 170 6 7 0   12     0   5   101 99                       200 170 6 7 0   12     0   5   101 99                 200
935899 935899 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2016   grade_9 95 6 4 1   2     1   0   54 55                       109 95 6 4 1   2     1   0   54 55                 109
936802 936802 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   grade_9 183 6 60 5   9     0   2   138 127                       265 183 6 60 5   9     0   2   138 127                 265
937321 937321 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No 3 09 12 2016   grade_9 174 6 28 0   12     0   9   104 125                       229 174 6 28 0   12     0   9   104 125                 229
938821 938821 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No 3 09 12 2016   grade_9 2 6 22 0   0     0   0   18 12                       30 2 6 22 0   0     0   0   18 12                 30
939082 939082 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No 3 09 12 2016   grade_9 222 6 4 0   9     0   1   126 116                       242 222 6 4 0   9     0   1   126 116                 242
939350 939350 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No 3 09 12 2016   grade_9 147 6 7 0   35     0   11   109 97                       206 147 6 7 0   35     0   11   109 97                 206
939364 939364 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No 3 09 12 2016   grade_9 106 6 16 1   4     0   5   75 63                       138 106 6 16 1   4     0   5   75 63                 138
940692 940692 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2016   grade_9 184 6 12 2   8     1   7   87 133                       220 184 6 12 2   8     1   7   87 133                 220
940897 940897 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No 3 09 12 2016   grade_9 95 6 12 0   3     0   10   59 67                       126 95 6 12 0   3     0   10   59 67                 126
941255 941255 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No 3 09 12 2016   grade_9 289 6 3 0   6     0   2   176 130                       306 289 6 3 0   6     0   2   176 130                 306
941843 941843 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No 3 09 12 2016   grade_9 265 6 5 2   3     0   8   142 147                       289 265 6 5 2   3     0   8   142 147                 289
941864 941864 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 104 6 14 6   1     1   9   85 56                       141 104 6 14 6   1     1   9   85 56                 141
941880 941880 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 67 6 322 0   2     0   0   201 196                       397 67 6 322 0   2     0   0   201 196                 397
941897 941897 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Vocational Education School No 3 09 12 2016   grade_9 103 6 12 0   7     0   5   88 45                       133 103 6 12 0   7     0   5   88 45                 133
941901 941901 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 275 6 52 1   6     0   18   179 179                       358 275 6 52 1   6     0   18   179 179                 358
941926 941926 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Vocational Education School No 3 09 12 2016   grade_9 292 6 14 1   3     0   8   183 141                       324 292 6 14 1   3     0   8   183 141                 324
941950 941950 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 260 6 59 2   5     0   10   181 161                       342 260 6 59 2   5     0   10   181 161                 342
933792 933792 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No 3 09 12 2016   grade_9 12 57 63 0   0     1   3   75 61                       136 12 57 63 0   0     1   3   75 61                 136
938841 938841 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_9 38 57 255 0   7     1   1   162 197                       359 38 57 255 0   7     1   1   162 197                 359
940271 940271 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_9 3 57 14 0   1     0   1   41 35                       76 3 57 14 0   1     0   1   41 35                 76
940186 940186 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No 3 09 12 2016   grade_9 168 53 118 2   31     0   19   208 183                       391 168 53 118 2   31     0   19   208 183                 391
941856 941856 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 132 53 28 3   2     0   9   127 100                       227 132 53 28 3   2     0   9   127 100                 227
936369 936369 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_9 72 52 299 1   30     0   18   283 189                       472 72 52 299 1   30     0   18   283 189                 472
936866 936866 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2016   grade_9 158 51 12 0   14     1   11   115 132                       247 158 51 12 0   14     1   11   115 132                 247
936365 936365 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2016   grade_9 117 50 238 2   44     1   14   256 210                       466 117 50 238 2   44     1   14   256 210                 466
936650 936650 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2016   grade_9 188 50 29 0   23     0   8   135 163                       298 188 50 29 0   23     0   8   135 163                 298
933844 933844 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_9 99 5 4 0   0     0   5   55 58                       113 99 5 4 0   0     0   5   55 58                 113
934964 934964 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No 3 09 12 2016   grade_9 13 5 12 0   2     0   2   23 11                       34 13 5 12 0   2     0   2   23 11                 34
935297 935297 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No 3 09 12 2016   grade_9 186 5 6 0   30     1   5   113 120                       233 186 5 6 0   30     1   5   113 120                 233
935625 935625 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 3 5 104 0   1     0   0   56 57                       113 3 5 104 0   1     0   0   56 57                 113
936072 936072 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No 3 09 12 2016   grade_9 210 5 9 0   20     0   3   131 116                       247 210 5 9 0   20     0   3   131 116                 247
936375 936375 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2016   grade_9 5 5 92 1   1     0   3   66 41                       107 5 5 92 1   1     0   3   66 41                 107
937123 937123 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2016   grade_9 8 5 15 1   0     0   0   22 7                       29 8 5 15 1   0     0   0   22 7                 29
937498 937498 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2016   grade_9 171 5 3 0   5     0   3   101 86                       187 171 5 3 0   5     0   3   101 86                 187
938377 938377 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No 3 09 12 2016   grade_9 276 5 29 0   92     1   10   177 236                       413 276 5 29 0   92     1   10   177 236                 413
938486 938486 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2016   grade_9 1 5 3 0   0     0   2   6 5                       11 1 5 3 0   0     0   2   6 5                 11
940346 940346 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_9 88 5 8 0   4     0   5   50 60                       110 88 5 8 0   4     0   5   50 60                 110
940653 940653 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_9 31 5 28 0   3     0   0   29 38                       67 31 5 28 0   3     0   0   29 38                 67
940800 940800 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2016   grade_9 298 5 15 0   154     0   16   260 228                       488 298 5 15 0   154     0   16   260 228                 488
940820 940820 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_9 87 5 4 1   3     0   0   45 55                       100 87 5 4 1   3     0   0   45 55                 100
940911 940911 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2016   grade_9 120 5 6 0   1     0   4   67 69                       136 120 5 6 0   1     0   4   67 69                 136
941058 941058 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000574 6550505 Dover-Sherborn Regional High   Regular School No 3 09 12 2016   grade_9 134 5 3 0   15     0   2   84 75                       159 134 5 3 0   15     0   2   84 75                 159
941089 941089 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2016   grade_9 216 5 9 1   6     0   5   111 131                       242 216 5 9 1   6     0   5   111 131                 242
941236 941236 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No 3 09 12 2016   grade_9 271 5 19 0   9     0   9   157 156                       313 271 5 19 0   9     0   9   157 156                 313

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