Data source: Big Local News · About: Big Local

2,748 rows where grade = "grade_12" and state = "MA" sorted by rowid descending

View and edit SQL

year

grade

  • grade_12 · 2,648
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
2238426 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 2018   grade_12 13 38 13 0   5     0   1   30 40                       70.0 13 38 13 0   5     0   1   30 40                 70
2238402 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 2018   grade_12 18 4 19 0   3     0   0   25 19                       44.0 18 4 19 0   3     0   0   25 19                 44
2238386 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District): Rising Tide Charter Public School   Regular School Yes High 05 12 2018   grade_12 61 1 2 0   2     0   6   35 37                       72.0 61 1 2 0   2     0   6   35 37                 72
2238354 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 2018   grade_12 43 4 10 1   2     0   4   21 42                       64.0 43 4 10 1   2     0   4   21 42                 64
2238347 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential (District): Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2018   grade_12 60 0 2 0   1     0   4   31 36                       67.0 60 0 2 0   1     0   4   31 36                 67
2238333 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 2018   grade_12 24 0 1 0   1     0   1   10 17                       27.0 24 0 1 0   1     0   1   10 17                 27
2238326 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District): Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2018   grade_12 51 12 6 1   14     0   5   41 48                       89.0 51 12 6 1   14     0   5   41 48                 89
2238312 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   grade_12 4 40 28 2   0     0   1   38 37                       75.0 4 40 28 2   0     0   1   38 37                 75
2238297 MA Worcester   school 2500036 468   Ma Academy for Math and Science 250003600576 4680505 Ma Academy for Math and Science: Ma Academy for Math and Science School   Regular School No High 11 12 2018   grade_12 22 1 0 0   20     0   3   23 23                       46.0 22 1 0 0   20     0   3   23 23                 46
2238294 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_12 11 0 0 1   1     0   0   6 7                       13.0 11 0 0 1   1     0   0   6 7                 13
2238265 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter (District): Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2018   grade_12 10 0 6 0   2     0   0   8 10                       18.0 10 0 6 0   2     0   0   8 10                 18
2238218 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District): Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2018   grade_12 2 31 39 0   6     0   2   31 49                       80.0 2 31 39 0   6     0   2   31 49                 80
2238203 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   grade_12 50 11 7 2   3     0   3   29 47                       76.0 50 11 7 2   3     0   3   29 47                 76
2238184 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 2018   grade_12 30 17 3 0   5     0   2   19 38                       57.0 30 17 3 0   5     0   2   19 38                 57
2238170 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 2018   grade_12 23 35 25 0   6     0   2   30 61                       91.0 23 35 25 0   6     0   2   30 61                 91
2238144 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District): Sabis International Charter School   Regular School Yes Other KG 12 2018   grade_12 26 45 31 0   1     0   1   54 50                       104.0 26 45 31 0   1     0   1   54 50                 104
2238108 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_12 0 21 7 0   0     0   0   20 8                       28.0 0 21 7 0   0     0   0   20 8                 28
2238093 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 2018   grade_12 3 17 14 0   0     0   2   11 25                       36.0 3 17 14 0   0     0   2   11 25                 36
2238088 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District): Community Charter School of Cambridge   Regular School Yes High 06 12 2018   grade_12 0 34 13 1   0     0   3   27 24                       51.0 0 34 13 1   0     0   3   27 24                 51
2238080 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_12 71 2 9 0   8     0   4   44 50                       94.0 71 2 9 0   8     0   4   44 50                 94
2238058 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   grade_12 72 3 6 0   18     0   5   63 41                       104.0 72 3 6 0   18     0   5   63 41                 104
2238050 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District): KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2018   grade_12 8 28 72 0   3     0   1   51 61                       112.0 8 28 72 0   3     0   1   51 61                 112
2238012 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter (District): Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2018   grade_12 12 109 110 1   5     0   11   114 134                       248.0 12 109 110 1   5     0   11   114 134                 248
2237982 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 2018   grade_12 2 41 9 0   0     0   0   29 23                       52.0 2 41 9 0   0     0   0   29 23                 52
2237974 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District): Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2018   grade_12 25 2 1 0   2     1   0   11 20                       31.0 25 2 1 0   2     1   0   11 20                 31
2237966 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District): Four Rivers Charter Public School   Regular School Yes High 07 12 2018   grade_12 34 0 1 0   0     0   2   21 16                       37.0 34 0 1 0   0     0   2   21 16                 37
2237959 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 2018   grade_12 4 22 11 0   0     0   1   15 23                       38.0 4 22 11 0   0     0   1   15 23                 38
2237950 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District): Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2018   grade_12 3 39 29 1   1     0   1   43 31                       74.0 3 39 29 1   1     0   1   43 31                 74
2237916 MA Hampshire   school 2508860 406   Northampton-Smith Vocational Agricultural 250886002314 4060705 Northampton-Smith Vocational Agricultural: Smith Vocational and Agricultural High   Career and Technical School No High 09 12 2018   grade_12 88 3 17 0   2     0   0   76 34                       110.0 88 3 17 0   2     0   0   76 34                 110
2237893 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester: Worcester Technical High   Career and Technical School No High 09 12 2018   grade_12 125 44 135 0   20     0   11   149 186                       335.0 125 44 135 0   20     0   11   149 186                 335
2237888 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester: South High Community   Regular School No High 09 12 2018   grade_12 81 51 131 0   45     0   5   165 148                       313.0 81 51 131 0   45     0   5   165 148                 313
2237883 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester: North High   Regular School No High 09 12 2018   grade_12 71 69 154 2   27     0   9   163 169                       332.0 71 69 154 2   27     0   9   163 169                 332
2237878 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Worcester: Doherty Memorial High   Regular School No High 09 12 2018   grade_12 167 61 106 1   43     0   8   212 174                       386.0 167 61 106 1   43     0   8   212 174                 386
2237873 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester: Burncoat Senior High   Regular School No High 09 12 2018   grade_12 77 44 79 0   17     0   12   110 119                       229.0 77 44 79 0   17     0   12   110 119                 229
2237854 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_12 4 10 65 0   10     0   0   42 47                       89.0 4 10 65 0   10     0   0   42 47                 89
2237847 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_12 5 4 19 0   9     0   1   25 13                       38.0 5 4 19 0   9     0   1   25 13                 38
2237557 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn: Woburn High   Regular School No High 09 12 2018   grade_12 251 32 45 0   20     0   3   178 173                       351.0 251 32 45 0   20     0   3   178 173                 351
2237486 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop: Winthrop High School   Regular School No High 09 12 2018   grade_12 85 3 14 2   5     0   7   60 56                       116.0 85 3 14 2   5     0   7   60 56                 116
2237467 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester: Winchester High School   Regular School No High 09 12 2018   grade_12 249 6 12 0   54     0   12   187 146                       333.0 249 6 12 0   54     0   12   187 146                 333
2237421 MA Worcester   school 2513080 343   Winchendon 251308002786 3430515 Winchendon: Murdock High School   Regular School No High 09 12 2018   grade_12 54 2 4 1   0     0   1   36 26                       62.0 54 2 4 1   0     0   1   36 26                 62
2237416 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Winchendon: Murdock Academy for Success   Alternative School No High 09 12 2018   grade_12 8 0 0 0   0     0   1   6 3                       9.0 8 0 0 0   0     0   1   6 3                 9
2237398 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington: Wilmington High   Regular School No High 09 12 2018   grade_12 200 7 7 0   15     1   6   107 129                       236.0 200 7 7 0   15     1   6   107 129                 236
2237342 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth: Weymouth High School   Regular School No High 09 12 2018   grade_12 391 21 30 0   17     0   10   232 237                       469.0 391 21 30 0   17     0   10   232 237                 469
2237279 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood: Westwood High   Regular School No High 09 12 2018   grade_12 221 7 5 0   10     0   7   114 136                       250.0 221 7 5 0   10     0   7   114 136                 250
2237233 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_12 6 0 2 0   0     0   0   * *                       8.0 6 0 2 0   0     0   0                       8
2237218 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield: West Springfield High   Regular School No High 09 12 2018   grade_12 212 14 36 0   26     0   6   160 134                       294.0 212 14 36 0   26     0   6   160 134                 294
2237173 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport: Westport Junior/Senior High School   Regular School No High 07 12 2018   grade_12 63 1 2 0   0     0   1   38 29                       67.0 63 1 2 0   0     0   1   38 29                 67
2237156 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston: Weston High   Regular School No High 09 12 2018   grade_12 103 11 8 0   21     0   7   85 65                       150.0 103 11 8 0   21     0   7   85 65                 150
2237123 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford: Westford Academy   Regular School No High 09 12 2018   grade_12 284 4 4 0   83     0   13   183 205                       388.0 284 4 4 0   83     0   13   183 205                 388
2237084 MA Hampden   school 2512630 325   Westfield 251263002074 3250605 Westfield: Westfield Technical Academy   Career and Technical School No High 09 12 2018   grade_12 126 4 3 0   0     0   0   76 57                       133.0 126 4 3 0   0     0   0   76 57                 133
2237079 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield: Westfield High   Regular School No High 09 12 2018   grade_12 262 8 38 0   11     0   1   147 173                       320.0 262 8 38 0   11     0   1   147 173                 320
2237015 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater: West Bridgewater Junior/Senior   Regular School No High 07 12 2018   grade_12 83 3 1 1   2     1   3   33 61                       94.0 83 3 1 1   2     1   3   33 61                 94
2236997 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston: West Boylston Junior/Senior High   Regular School No High 06 12 2018   grade_12 55 0 2 0   1     0   2   27 33                       60.0 55 0 2 0   1     0   2   27 33                 60
2236981 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough: Westborough High   Regular School No High 09 12 2018   grade_12 201 7 14 0   46     0   6   132 142                       274.0 201 7 14 0   46     0   6   132 142                 274
2236945 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley: Wellesley Sr High   Regular School No High 09 12 2018   grade_12 280 29 20 0   52     1   21   197 206                       403.0 280 29 20 0   52     1   21   197 206                 403
2236886 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Webster: Bartlett High School   Regular School No High 09 12 2018   grade_12 62 2 18 0   3     0   8   49 44                       93.0 62 2 18 0   3     0   8   49 44                 93
2236869 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland: Wayland High School   Regular School No High 09 12 2018   grade_12 149 10 8 0   35     1   10   115 98                       213.0 149 10 8 0   35     1   10   115 98                 213
2236839 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown: Watertown High   Regular School No High 09 12 2018   grade_12 126 5 20 2   8     0   1   73 89                       162.0 126 5 20 2   8     0   1   73 89                 162
2236806 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham: Wareham Senior High   Regular School No High 09 12 2018   grade_12 85 9 10 2   4     0   13   59 64                       123.0 85 9 10 2   4     0   13   59 64                 123
2236801 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham: Wareham Cooperative Alternative School   Regular School No High 09 12 2018   grade_12 17 0 1 0   0     0   0   11 7                       18.0 17 0 1 0   0     0   0   11 7                 18
2236783 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware: Ware Junior/Senior High School   Regular School No High 07 12 2018   grade_12 51 3 4 0   0     0   1   30 29                       59.0 51 3 4 0   0     0   1   30 29                 59
2236766 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham: Waltham Sr High   Regular School No High 09 12 2018   grade_12 165 52 128 1   22     1   8   197 180                       377.0 165 52 128 1   22     1   8   197 180                 377
2236706 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole: Walpole High   Regular School No High 09 12 2018   grade_12 241 13 16 1   8     0   0   136 143                       279.0 241 13 16 1   8     0   0   136 143                 279
2236654 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield: Wakefield Memorial High   Regular School No High 09 12 2018   grade_12 242 8 6 1   9     1   5   135 137                       272.0 242 8 6 1   9     1   5   135 137                 272
2236619 MA Worcester   school 2511850 304   Uxbridge 251185002862 3040515 Uxbridge: Gateway to College   Alternative School No High 10 12 2018   grade_12 25 0 8 0   0     1   2   12 24                       36.0 25 0 8 0   0     1   2   12 24                 36
2236616 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge: Uxbridge High   Regular School No High 09 12 2018   grade_12 111 2 2 0   3     0   1   57 62                       119.0 111 2 2 0   3     0   1   57 62                 119
2236598 MA Middlesex   school 2511760 301   Tyngsborough 251176001934 3010505 Tyngsborough: Tyngsborough High School   Regular School No High 09 12 2018   grade_12 110 2 2 0   9     0   1   68 56                       124.0 110 2 2 0   9     0   1   68 56                 124
2236552 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury: Tewksbury Memorial High   Regular School No High 09 12 2018   grade_12 214 4 10 0   4     1   1   123 111                       234.0 214 4 10 0   4     1   1   123 111                 234
2236526 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton: Taunton Alternative High School   Alternative School No High 10 12 2018   grade_12 28 3 1 0   0     0   3   21 14                       35.0 28 3 1 0   0     0   3   21 14                 35
2236522 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_12 286 67 33 0   8     0   13   196 211                       407.0 286 67 33 0   8     0   13   196 211                 407
2236460 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Swansea: Joseph Case High   Regular School No High 09 12 2018   grade_12 117 1 1 0   1     0   3   67 56                       123.0 117 1 1 0   1     0   3   67 56                 123
2236434 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott: Swampscott High   Regular School No High 09 12 2018   grade_12 131 6 13 0   4     1   1   80 76                       156.0 131 6 13 0   4     1   1   80 76                 156
2236405 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton: Sutton High School   Regular School No High 09 12 2018   grade_12 100 1 2 1   3     0   6   62 51                       113.0 100 1 2 1   3     0   6   62 51                 113
2236336 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton: Stoughton High   Regular School No High 09 12 2018   grade_12 167 54 12 0   20     0   0   131 122                       253.0 167 54 12 0   20     0   0   131 122                 253
2236289 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham: Stoneham High   Regular School No High 09 12 2018   grade_12 127 3 10 1   7     0   4   61 91                       152.0 127 3 10 1   7     0   4   61 91                 152
2236258 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Springfield: Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2018   grade_12 49 88 205 0   5     0   5   160 192                       352.0 49 88 205 0   5     0   5   160 192                 352
2236253 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Springfield: Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2018   grade_12 0 4 6 0   0     0   0   3 7                       10.0 0 4 6 0   0     0   0   3 7                 10
2236249 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Springfield: Gateway to College at Holyoke Community College   Regular School No High 10 12 2018   grade_12 1 3 5 0   0     0   0   3 6                       9.0 1 3 5 0   0     0   0   3 6                 9
2236245 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield: Springfield High School   Regular School No High 09 12 2018   grade_12 5 12 26 0   0     0   1   22 22                       44.0 5 12 26 0   0     0   1   22 22                 44
2236236 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield: Springfield Public Day High School   Regular School No High 09 12 2018   grade_12 2 4 5 0   0     0   0   8 3                       11.0 2 4 5 0   0     0   0   8 3                 11
2236231 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield: Springfield High School of Science and Technology   Regular School No High 09 12 2018   grade_12 35 39 150 0   4     0   1   125 104                       229.0 35 39 150 0   4     0   1   125 104                 229
2236226 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 Springfield: High School Of Commerce   Regular School No High 09 12 2018   grade_12 24 53 175 0   2     0   3   142 115                       257.0 24 53 175 0   2     0   3   142 115                 257
2236221 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_12 82 96 195 0   26     0   5   212 192                       404.0 82 96 195 0   26     0   5   212 192                 404
2236209 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield: Conservatory of the Arts   Regular School No High 06 12 2018   grade_12 5 16 28 0   0     0   0   16 33                       49.0 5 16 28 0   0     0   0   16 33                 49
2236163 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 Springfield: John J Duggan Middle   Regular School No High 06 12 2018   grade_12 2 15 23 0   0     0   0   21 19                       40.0 2 15 23 0   0     0   0   21 19                 40
2236155 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_12 32 16 33 0   1     0   3   44 41                       85.0 32 16 33 0   1     0   3   44 41                 85
2235904 MA Hampshire   school 2510920 278   South Hadley 251092001754 2780505 South Hadley: South Hadley High   Regular School No High 09 12 2018   grade_12 120 6 11 0   1     1   0   79 60                       139.0 120 6 11 0   1     1   0   79 60                 139
2235886 MA Worcester   school 2511010 277   Southbridge 251101002868 2770515 Southbridge: Southbridge High School   Regular School No High 09 12 2018   grade_12 40 4 60 0   2     0   2   50 58                       108.0 40 4 60 0   2     0   2   50 58                 108
2235840 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Somerville: Full Circle High School   Alternative School No High 09 12 2018   grade_12 5 1 7 0   0     0   0   6 7                       13.0 5 1 7 0   0     0   0   6 7                 13
2235835 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville: Somerville High   Regular School No High 09 12 2018   grade_12 68 42 127 0   21     0   3   140 121                       261.0 68 42 127 0   21     0   3   140 121                 261
2235717 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury: Shrewsbury Sr High   Regular School No High 09 12 2018   grade_12 310 9 33 0   74     1   11   193 245                       438.0 310 9 33 0   74     1   11   193 245                 438
2235670 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon: Sharon High   Regular School No High 09 12 2018   grade_12 170 22 10 0   60     0   8   142 128                       270.0 170 22 10 0   60     0   8   142 128                 270
2235638 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk: Seekonk High   Regular School No High 09 12 2018   grade_12 129 2 4 0   3     0   1   65 73                       139.0 129 2 4 0   3     0   1   65 73                 139
2235613 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate: Scituate High School   Regular School No High 09 12 2018   grade_12 219 2 1 0   1     0   4   94 133                       227.0 219 2 1 0   1     0   4   94 133                 227
2235567 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus: Saugus High   Regular School No High 09 12 2018   grade_12 104 5 18 1   10     0   1   61 78                       139.0 104 5 18 1   10     0   1   61 78                 139
2235528 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich: Sandwich High   Regular School No High 09 12 2018   grade_12 163 0 2 0   4     0   0   88 81                       169.0 163 0 2 0   4     0   0   88 81                 169
2235510 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem: Salem Prep High School   Regular School No High 08 12 2018   grade_12 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2235505 MA Essex   school 2510380 258   Salem 251038002864 2580510 Salem: New Liberty Innovation School   Regular School No High 09 12 2018   grade_12 11 1 8 0   0     0   0   8 12                       20.0 11 1 8 0   0     0   0   8 12                 20
2235500 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem: Salem High   Regular School No High 09 12 2018   grade_12 84 15 103 0   9     0   12   116 107                       223.0 84 15 103 0   9     0   12   116 107                 223
2235432 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport: Rockport High   Regular School No High 09 12 2018   grade_12 65 1 2 0   0     0   0   35 33                       68.0 65 1 2 0   0     0   0   35 33                 68

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