Data source: Big Local News · About: Big Local

387 rows where grade = "grade_9", state = "MA" and year = 2021 sorted by black descending

View and edit SQL

year

  • 2021 · 387

grade

  • grade_9 · 387
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
1679806 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_9 3 93 50 0   1     0   1   72 76 *                     148.0 3 93 50 0   1     0   1   72 76                 148
1672199 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_9 271 9 23 0   41     1   18   161 201 *                     363.0 271 9 23 0   41     1   18   161 201                 363
1674134 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut - Dracut Senior High   Regular School No High 09 12 2021   grade_9 154 9 21 1   24     0   2   105 103 *                     211.0 154 9 21 1   24     0   2   105 103                 211
1674233 MA Bristol   school 2504620 88   Easton 250462000623 880505 Easton - Oliver Ames High   Regular School No High 09 12 2021   grade_9 220 9 18 0   10     0   8   137 128 *                     265.0 220 9 18 0   10     0   8   137 128                 265
1676227 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_9 192 9 194 0   15     0   22   219 212 *                     432.0 192 9 194 0   15     0   22   219 212                 432
1677733 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus - Saugus High   Regular School No High 09 12 2021   grade_9 111 9 41 1   10     0   0   91 81 *                     172.0 111 9 41 1   10     0   0   91 81                 172
1678485 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott - Swampscott High   Regular School No High 09 12 2021   grade_9 124 9 19 0   4     0   5   78 82 *                     161.0 124 9 19 0   4     0   5   78 82                 161
1679120 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield - West Springfield High   Regular School No High 09 12 2021   grade_9 208 9 67 0   21     0   10   159 156 *                     315.0 208 9 67 0   21     0   10   159 156                 315
1680134 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District) - Salem Academy Charter School   Regular School Yes High 06 12 2021   grade_9 25 9 36 0   3     0   1   42 32 *                     74.0 25 9 36 0   3     0   1   42 32                 74
1680585 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset - Nauset Regional High   Regular School No High 09 12 2021   grade_9 162 9 12 0   5     0   4   85 107 *                     192.0 162 9 12 0   5     0   4   85 107                 192
1681340 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District - Essex North Shore Agricultural and Technical School   Career and Technical School No High 09 12 2021   grade_9 338 9 54 0   10     0   15   180 244 *                     426.0 338 9 54 0   10     0   15   180 244                 426
1681369 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional Vocational Technical - Minuteman Regional High   Career and Technical School No High 09 12 2021   grade_9 136 9 17 1   4     0   12   101 78 *                     179.0 136 9 17 1   4     0   12   101 78                 179
1673260 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_9 8 88 60 1   4     1   4   97 69 *                     166.0 8 88 60 1   4     1   4   97 69                 166
1681491 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_9 2 87 7 1   0     0   1   53 45 *                     98.0 2 87 7 1   0     0   1   53 45                 98
1675922 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden - Malden High   Regular School No High 09 12 2021   grade_9 110 81 127 0   103     0   13   228 205 *                     434.0 110 81 127 0   103     0   13   228 205                 434
1678403 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton - Stoughton High   Regular School No High 09 12 2021   grade_9 146 81 24 1   24     2   12   175 115 *                     290.0 146 81 24 1   24     2   12   175 115                 290
1675654 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_9 202 80 340 0   221     0   37   479 401 *                     880.0 202 80 340 0   221     0   37   479 401                 880
1679676 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester - Worcester Technical High   Career and Technical School No High 09 12 2021   grade_9 101 80 148 0   29     0   11   160 209 *                     369.0 101 80 148 0   29     0   11   160 209                 369
1679755 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District) - Boston Preparatory Charter Public School   Regular School Yes High 06 12 2021   grade_9 1 80 35 0   0     0   8   62 62 *                     124.0 1 80 35 0   0     0   8   62 62                 124
1673208 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Boston - Margarita Muniz Academy   Regular School No High 09 12 2021   grade_9 0 8 62 0   0     0   0   32 38 *                     70.0 0 8 62 0   0     0   0   32 38                 70
1673906 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee - Chicopee Comprehensive High School   Regular School No High 09 12 2021   grade_9 179 8 110 0   6     0   17   177 143 *                     320.0 179 8 110 0   6     0   17   177 143                 320
1674043 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth - Dartmouth High   Regular School No High 09 12 2021   grade_9 220 8 16 0   0     0   16   129 131 *                     260.0 220 8 16 0   0     0   16   129 131                 260
1674672 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   grade_9 346 8 16 0   32     1   11   200 214 *                     414.0 346 8 16 0   32     1   11   200 214                 414
1676272 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford - Milford High   Regular School No High 09 12 2021   grade_9 180 8 103 6   5     0   7   177 132 *                     309.0 180 8 103 6   5     0   7   177 132                 309
1678661 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield - Wakefield Memorial High   Regular School No High 09 12 2021   grade_9 154 8 16 1   6     0   5   90 100 *                     190.0 154 8 16 1   6     0   5   90 100                 190
1679006 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield - Westfield High   Regular School No High 09 12 2021   grade_9 196 8 42 0   7     0   7   120 140 *                     260.0 196 8 42 0   7     0   7   120 140                 260
1680289 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough - Acton-Boxborough Regional High   Regular School No High 09 12 2021   grade_9 206 8 27 1   149     0   15   221 185 *                     406.0 206 8 27 1   149     0   15   221 185                 406
1680830 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District - Monomoy Regional High School   Regular School No High 08 12 2021   grade_9 88 8 11 0   1     0   4   57 55 *                     112.0 88 8 11 0   1     0   4   57 55                 112
1681263 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett - Wachusett Regional High   Regular School No High 09 12 2021   grade_9 431 8 29 1   15     0   10   203 291 *                     494.0 431 8 29 1   15     0   10   203 291                 494
1681352 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical - Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 79 8 328 1   3     1   0   180 240 *                     420.0 79 8 328 1   3     1   0   180 240                 420
1681508 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_9 33 8 16 0   1     0   1   37 22 *                     59.0 33 8 16 0   1     0   1   37 22                 59
1681527 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_9 81 8 27 1   4     1   10   62 68 2                     132.0 81 8 27 1   4     1   10   62 68 2               132
1674319 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_9 103 79 329 4   31     1   9   272 284 *                     556.0 103 79 329 4   31     1   9   272 284                 556
1673198 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston - Boston Latin Academy   Regular School No High 07 12 2021   grade_9 92 76 87 0   48     0   6   113 195 *                     309.0 92 76 87 0   48     0   6   113 195                 309
1679671 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester - South High Community   Regular School No High 09 12 2021   grade_9 110 76 191 0   43     0   16   215 221 *                     436.0 110 76 191 0   43     0   16   215 221                 436
1677469 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   grade_9 12 71 22 0   23     0   5   74 59 *                     133.0 12 71 22 0   23     0   5   74 59                 133
1674015 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers - Danvers High   Regular School No High 09 12 2021   grade_9 181 7 17 0   7     0   6   106 112 *                     218.0 181 7 17 0   7     0   6   106 112                 218
1674212 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow - East Longmeadow High   Regular School No High 09 12 2021   grade_9 171 7 11 0   9     0   5   98 105 *                     203.0 171 7 11 0   9     0   5   98 105                 203
1674782 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton - Grafton High School   Regular School No High 09 12 2021   grade_9 163 7 13 2   22     1   5   101 112 *                     213.0 163 7 13 2   22     1   5   101 112                 213
1674992 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham - Hingham High   Regular School No High 09 12 2021   grade_9 272 7 11 0   5     0   11   161 144 *                     306.0 272 7 11 0   5     0   11   161 144                 306
1675997 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough - Marlborough High   Regular School No High 09 12 2021   grade_9 68 7 121 0   2     0   9   113 94 *                     207.0 68 7 121 0   2     0   9   113 94                 207
1677436 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy - North Quincy High   Regular School No High 09 12 2021   grade_9 145 7 12 2   167     2   18   192 161 *                     353.0 145 7 12 2   167     2   18   192 161                 353
1678818 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown - Watertown High   Regular School No High 09 12 2021   grade_9 109 7 44 0   8     0   9   96 81 *                     177.0 109 7 44 0   8     0   9   96 81                 177
1678858 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Webster - Bartlett High School   Regular School No High 09 12 2021   grade_9 39 7 30 0   3     0   8   54 33 *                     87.0 39 7 30 0   3     0   8   54 33                 87
1678938 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough - Westborough High   Regular School No High 09 12 2021   grade_9 167 7 19 0   93     1   11   145 153 *                     298.0 167 7 19 0   93     1   11   145 153                 298
1679070 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston - Weston High   Regular School No High 09 12 2021   grade_9 105 7 6 0   28     0   11   82 75 *                     157.0 105 7 6 0   28     0   11   82 75                 157
1679160 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood - Westwood High   Regular School No High 09 12 2021   grade_9 181 7 12 0   33     0   10   126 116 *                     243.0 181 7 12 0   33     0   10   126 116                 243
1679637 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester - University Pk Campus School   Regular School No High 07 12 2021   grade_9 3 7 24 0   5     0   0   20 19 *                     39.0 3 7 24 0   5     0   0   20 19                 39
1680079 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential (District) - Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2021   grade_9 46 7 13 1   1     0   1   39 30 *                     69.0 46 7 13 1   1     0   1   39 30                 69
1680091 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District) - Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2021   grade_9 40 7 14 0   0     0   7   27 41 *                     68.0 40 7 14 0   0     0   7   27 41                 68
1680732 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Hampden-Wilbraham - Minnechaug Regional High   Regular School No High 09 12 2021   grade_9 210 7 21 0   6     0   17   127 134 *                     261.0 210 7 21 0   6     0   17   127 134                 261
1680783 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard - Martha's Vineyard Regional High   Regular School No High 09 12 2021   grade_9 114 7 28 3   1     0   12   79 86 *                     165.0 114 7 28 3   1     0   12   79 86                 165
1680944 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Northboro-Southboro - Algonquin Regional High   Regular School No High 09 12 2021   grade_9 214 7 25 0   47     2   19   151 163 *                     314.0 214 7 25 0   47     2   19   151 163                 314
1681373 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical - Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 268 7 58 0   6     0   16   175 179 1                     355.0 268 7 58 0   6     0   16   175 179 1               355
1681511 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School (District) - Map Academy Charter School   Regular School Yes High 09 12 2021   grade_9 21 7 7 0   0     2   2   24 15 *                     39.0 21 7 7 0   0     2   2   24 15                 39
1679666 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester - North High   Regular School No High 09 12 2021   grade_9 57 69 195 0   18     0   12   182 169 *                     351.0 57 69 195 0   18     0   12   182 169                 351
1679945 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_9 31 68 7 0   7     0   4   55 62 *                     117.0 31 68 7 0   7     0   4   55 62                 117
1678314 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield - Springfield High School of Science and Technology   Regular School No High 09 12 2021   grade_9 25 67 293 0   4     1   2   231 161 *                     392.0 25 67 293 0   4     1   2   231 161                 392
1679656 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester - Burncoat Senior High   Regular School No High 09 12 2021   grade_9 104 66 126 1   12     0   11   164 156 *                     320.0 104 66 126 1   12     0   11   164 156                 320
1673474 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_9 187 617 165 1   24     2   48   589 455 *                     1044.0 187 617 165 1   24     2   48   589 455                 1044
1672612 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_9 1 61 24 0   0     1   3   46 44 *                     90.0 1 61 24 0   0     1   3   46 44                 90
1681328 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical - Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 128 61 39 3   5     0   11   136 111 *                     247.0 128 61 39 3   5     0   11   136 111                 247
1672058 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_9 231 6 23 0   12     0   9   155 126 *                     281.0 231 6 23 0   12     0   9   155 126                 281
1672078 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_9 105 6 16 0   1     0   4   61 71 *                     132.0 105 6 16 0   1     0   4   61 71                 132
1673242 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Boston - Lyon Upper 9-12   Regular School No High 09 12 2021   grade_9 3 6 22 0   0     0   5   22 14 *                     36.0 3 6 22 0   0     0   5   22 14                 36
1673441 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton - Frederick Douglass Academy   Regular School No High 09 12 2021   grade_9 1 6 2 0   0     0   0   5 4 *                     9.0 1 6 2 0   0     0   0   5 4                 9
1674443 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_9 10 6 14 0   0     0   3   22 11 *                     33.0 10 6 14 0   0     0   3   22 11                 33
1674687 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner - Gardner High   Regular School No High 08 12 2021   grade_9 110 6 41 0   1     0   12   91 79 *                     170.0 110 6 41 0   1     0   12   91 79                 170
1675340 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester - Leicester High   Regular School No High 09 12 2021   grade_9 81 6 13 0   8     0   4   66 46 *                     112.0 81 6 13 0   8     0   4   66 46                 112
1678704 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole - Walpole High   Regular School No High 09 12 2021   grade_9 207 6 17 0   21     0   4   130 125 *                     255.0 207 6 17 0   21     0   4   130 125                 255
1679310 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester - Winchester High School   Regular School No High 09 12 2021   grade_9 251 6 12 2   57     0   16   158 185 *                     344.0 251 6 12 2   57     0   16   158 185                 344
1680216 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District) - Global Learning Charter Public School   Regular School Yes High 05 12 2021   grade_9 10 6 19 1   0     0   3   22 17 *                     39.0 10 6 19 1   0     0   3   22 17                 39
1680751 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip - King Philip Regional High   Regular School No High 09 12 2021   grade_9 273 6 14 1   12     0   0   158 148 *                     306.0 273 6 14 1   12     0   0   158 148                 306
1681324 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley Regional Vocational Technical - Blackstone Valley   Career and Technical School No High 09 12 2021   grade_9 268 6 31 0   4     0   9   164 153 *                     318.0 268 6 31 0   4     0   9   164 153                 318
1681365 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_9 123 6 81 5   4     0   7   116 109 *                     226.0 123 6 81 5   4     0   7   116 109                 226
1681413 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical - Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 214 6 25 0   1     0   14   150 108 *                     260.0 214 6 25 0   1     0   14   150 108                 260
1679932 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_9 18 59 16 0   3     0   1   46 51 *                     97.0 18 59 16 0   3     0   1   46 51                 97
1674437 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_9 250 57 149 0   31     0   38   279 246 *                     525.0 250 57 149 0   31     0   38   279 246                 525
1678334 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Springfield - Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2021   grade_9 30 56 261 1   12     0   2   162 200 *                     362.0 30 56 261 1   12     0   2   162 200                 362
1673189 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_9 4 54 51 0   4     0   3   64 52 *                     116.0 4 54 51 0   4     0   3   64 52                 116
1679858 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 (District) - City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2021   grade_9 1 52 16 0   0     0   0   32 37 *                     69.0 1 52 16 0   0     0   0   32 37                 69
1678310 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 Springfield - High School Of Commerce   Regular School No High 09 12 2021   grade_9 26 50 283 0   3     0   6   198 170 *                     368.0 26 50 283 0   3     0   6   198 170                 368
1679735 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_9 5 50 26 0   0     0   1   42 40 *                     82.0 5 50 26 0   0     0   1   42 40                 82
1672018 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_9 122 5 16 0   3     0   0   88 58 *                     146.0 122 5 16 0   3     0   0   88 58                 146
1675516 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow - Longmeadow High   Regular School No High 09 12 2021   grade_9 166 5 23 0   23     0   6   99 124 *                     223.0 166 5 23 0   23     0   6   99 124                 223
1676143 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway - Medway High   Regular School No High 09 12 2021   grade_9 120 5 10 2   4     0   2   69 74 *                     143.0 120 5 10 2   4     0   2   69 74                 143
1676246 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough - Middleborough High   Regular School No High 09 12 2021   grade_9 184 5 6 4   5     0   9   113 100 *                     213.0 184 5 6 4   5     0   9   113 100                 213
1676600 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford - Whaling City Junior/Senior High School   Regular School No High 06 12 2021   grade_9 7 5 6 0   0     0   0   11 7 *                     18.0 7 5 6 0   0     0   0   11 7                 18
1677323 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth - Plymouth North High   Regular School No High 09 12 2021   grade_9 282 5 28 1   8     0   17   176 165 *                     341.0 282 5 28 1   8     0   17   176 165                 341
1678001 MA Worcester   school 2511010 277   Southbridge 251101002868 2770515 Southbridge - Southbridge High School   Regular School No High 09 12 2021   grade_9 57 5 104 1   3     0   1   100 71 *                     171.0 57 5 104 1   3     0   1   100 71                 171
1678364 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham - Stoneham High   Regular School No High 09 12 2021   grade_9 112 5 15 0   10     0   6   69 79 *                     148.0 112 5 15 0   10     0   6   69 79                 148
1680186 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_9 33 5 19 0   1     0   0   30 28 *                     58.0 33 5 19 0   1     0   0   30 28                 58
1680577 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Dudley-Charlton Reg - Shepherd Hill Regional High   Regular School No High 09 12 2021   grade_9 211 5 33 0   4     0   9   120 142 *                     262.0 211 5 33 0   4     0   9   120 142                 262
1680618 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_9 75 5 5 0   7     0   7   58 41 *                     99.0 75 5 5 0   7     0   7   58 41                 99
1680976 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex - North Middlesex Regional   Regular School No High 09 12 2021   grade_9 159 5 9 0   7     0   7   107 80 *                     187.0 159 5 9 0   7     0   7   107 80                 187
1681385 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metropolitan Regional Vocational Technical - Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2021   grade_9 282 5 44 0   1     0   0   183 147 *                     332.0 282 5 44 0   1     0   0   183 147                 332
1679216 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth - Weymouth High School   Regular School No High 08 12 2021   grade_9 338 49 67 2   24     1   13   232 262 *                     494.0 338 49 67 2   24     1   13   232 262                 494
1680156 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District) - Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2021   grade_9 17 48 18 0   9     0   4   59 37 *                     96.0 17 48 18 0   9     0   4   59 37                 96
1673202 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston - Boston Arts Academy   Alternative School No High 09 12 2021   grade_9 8 47 66 0   3     0   6   32 97 *                     130.0 8 47 66 0   3     0   6   32 97                 130
1673212 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston - Boston Community Leadership Academy   Regular School No High 09 12 2021   grade_9 3 46 70 0   1     0   1   57 64 *                     121.0 3 46 70 0   1     0   1   57 64                 121

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