Data source: Big Local News · About: Big Local

393 rows where grade = "grade_12", state = "MA" and year = 2017 sorted by black

View and edit SQL

year

  • 2017 · 393

grade

  • grade_12 · 393
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
1123658 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_12 * * * *   *     *   *   1 2                       *                         1 2                  
1124662 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_12 * * * *   *     *   *   3 2                       *                         3 2                  
1125198 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_12 * * * *   *     *   *   * *                       *                                              
1125272 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_12 * * * *   *     *   *   * *                       *                                              
1128688 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_12 * * * *   *     *   *   3 *                       *                         3                    
1130589 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No Other 06 12 2017   grade_12 * * * *   *     *   *   3 2                       *                         3 2                  
1131927 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_12 * * * *   *     *   *   1 *                       *                         1                    
1122043 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_12 10 0 1 0   0     0   0   7 4                       11 10 0 1 0   0     0   0   7 4                 11
1122257 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2017   grade_12 11 0 1 0   1     0   1   10 4                       14 11 0 1 0   1     0   1   10 4                 14
1123482 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2017   grade_12 80 0 4 0   2     0   8   50 44                       94 80 0 4 0   2     0   8   50 44                 94
1125137 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2017   grade_12 90 0 1 0   0     0   2   44 49                       93 90 0 1 0   0     0   2   44 49                 93
1125360 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_12 90 0 3 0   12     0   2   54 53                       107 90 0 3 0   12     0   2   54 53                 107
1125376 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_12 25 0 3 0   0     0   1   14 15                       29 25 0 3 0   0     0   1   14 15                 29
1125403 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2017   grade_12 5 0 1 0   0     0   0   5 1                       6 5 0 1 0   0     0   0   5 1                 6
1125894 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   grade_12 3 0 30 0   0     0   0   16 17                       33 3 0 30 0   0     0   0   16 17                 33
1125910 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   grade_12 53 0 9 0   0     0   0   29 33                       62 53 0 9 0   0     0   0   29 33                 62
1126108 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2017   grade_12 110 0 3 0   7     1   2   70 53                       123 110 0 3 0   7     1   2   70 53                 123
1126961 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2017   grade_12 244 0 131 1   19     0   16   202 209                       411 244 0 131 1   19     0   16   202 209                 411
1127052 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No High 09 12 2017   grade_12 81 0 2 1   2     1   1   46 42                       88 81 0 2 1   2     1   1   46 42                 88
1127774 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No High 09 12 2017   grade_12 121 0 8 0   4     0   4   75 62                       137 121 0 8 0   4     0   4   75 62                 137
1127952 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_12 5 0 2 0   0     0   1   7 *                       8 5 0 2 0   0     0   1   7                   8
1127962 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2017   grade_12 83 0 5 0   0     0   2   44 46                       90 83 0 5 0   0     0   2   44 46                 90
1129422 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_12 2 0 4 0   0     0   0   4 *                       6 2 0 4 0   0     0   0   4                   6
1129432 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2017   grade_12 3 0 3 0   0     0   0   1 5                       6 3 0 3 0   0     0   0   1 5                 6
1129588 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No High 09 12 2017   grade_12 93 0 2 0   0     0   5   56 44                       100 93 0 2 0   0     0   5   56 44                 100
1129805 MA Worcester   school 2511850 304   Uxbridge 251185002862 3040515 Gateway to College   Alternative School No High 09 12 2017   grade_12 27 0 2 1   1     0   0   11 20                       31 27 0 2 1   1     0   0   11 20                 31
1129968 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2017   grade_12 58 0 5 0   1     0   1   31 34                       65 58 0 5 0   1     0   1   31 34                 65
1130182 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No Other 06 12 2017   grade_12 50 0 10 0   0     0   1   33 28                       61 50 0 10 0   0     0   1   33 28                 61
1130358 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_12 81 0 4 0   1     0   0   49 37                       86 81 0 4 0   1     0   0   49 37                 86
1131139 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_12 29 0 1 0   3     0   1   13 21                       34 29 0 1 0   3     0   1   13 21                 34
1131433 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2017   grade_12 11 0 6 0   4     0   1   12 10                       22 11 0 6 0   4     0   1   12 10                 22
1131461 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_12 9 0 2 0   0     0   1   5 7                       12 9 0 2 0   0     0   1   5 7                 12
1131464 MA Worcester   school 2500036 468   Ma Academy for Math and Science 250003600576 4680505 Ma Academy for Math and Science School   Regular School No High 11 12 2017   grade_12 26 0 0 0   21     0   1   28 20                       48 26 0 0 0   21     0   1   28 20                 48
1131553 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes Other 05 12 2017   grade_12 67 0 0 0   1     0   1   30 39                       69 67 0 0 0   1     0   1   30 39                 69
1131611 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   grade_12 166 0 0 0   3     0   13   71 111                       182 166 0 0 0   3     0   13   71 111                 182
1131796 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2017   grade_12 165 0 8 0   2     0   4   90 89                       179 165 0 8 0   2     0   4   90 89                 179
1131871 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No Other 06 12 2017   grade_12 82 0 1 0   4     0   0   39 48                       87 82 0 1 0   4     0   0   39 48                 87
1132148 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No High 09 12 2017   grade_12 51 0 1 0   1     0   2   23 32                       55 51 0 1 0   1     0   2   23 32                 55
1132172 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2017   grade_12 201 0 2 0   11     0   0   108 106                       214 201 0 2 0   11     0   0   108 106                 214
1132198 MA Franklin   school 2505270 674   Gill-Montague 250527000768 6740505 Turners Fall High   Regular School No High 09 12 2017   grade_12 53 0 4 0   0     0   1   28 30                       58 53 0 4 0   0     0   1   28 30                 58
1132445 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No High 09 12 2017   grade_12 70 0 2 0   1     0   5   33 45                       78 70 0 2 0   1     0   5   33 45                 78
1132671 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2017   grade_12 69 0 0 1   1     0   5   42 34                       76 69 0 0 1   1     0   5   42 34                 76
1132674 MA Worcester   school 2509900 755   Ralph C Mahar 250990002701 7550515 Pathways Early College Innovation School   Regular School No High 11 12 2017   grade_12 16 0 1 0   0     0   0   6 11                       17 16 0 1 0   0     0   0   6 11                 17
1132718 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_12 41 0 4 0   0     0   1   22 24                       46 41 0 4 0   0     0   1   22 24                 46
1132767 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_12 90 0 7 0   0     0   5   57 45                       102 90 0 7 0   0     0   5   57 45                 102
1132775 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No High 09 12 2017   grade_12 187 0 10 0   5     0   7   81 128                       209 187 0 10 0   5     0   7   81 128                 209
1132780 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua Regional Vocational   Career and Technical School No High 09 12 2017   grade_12 118 0 2 2   1     0   4   81 46                       127 118 0 2 2   1     0   4   81 46                 127
1132934 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No High 09 12 2017   grade_12 85 0 8 0   2     0   6   47 54                       101 85 0 8 0   2     0   6   47 54                 101
1133005 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Technical   Career and Technical School No High 09 12 2017   grade_12 113 0 0 0   0     0   0   68 45                       113 113 0 0 0   0     0   0   68 45                 113
1133060 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_12 129 0 1 0   0     0   4   73 61                       134 129 0 1 0   0     0   4   73 61                 134
1133065 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2017   grade_12 117 0 5 3   1     0   8   83 51                       134 117 0 5 3   1     0   8   83 51                 134
1133080 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2017   grade_12 135 0 1 0   0     1   0   93 44                       137 135 0 1 0   0     1   0   93 44                 137
1133085 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2017   grade_12 233 0 11 1   0     0   1   133 113                       246 233 0 11 1   0     0   1   133 113                 246
1133105 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2017   grade_12 105 0 3 1   0     0   0   35 74                       109 105 0 3 1   0     0   0   35 74                 109
1122014 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_12 280 1 21 0   8     0   5   158 157                       315 280 1 21 0   8     0   5   158 157                 315
1124152 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_12 2 1 8 0   0     0   1   9 3                       12 2 1 8 0   0     0   1   9 3                 12
1124490 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No High 09 12 2017   grade_12 261 1 2 0   4     0   4   149 123                       272 261 1 2 0   4     0   4   149 123                 272
1124507 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2017   grade_12 169 1 7 0   0     0   1   95 83                       178 169 1 7 0   0     0   1   95 83                 178
1124828 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River Gateway to College @ BCC   Regular School No High 10 12 2017   grade_12 10 1 1 0   1     0   0   6 7                       13 10 1 1 0   1     0   0   6 7                 13
1125344 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2017   grade_12 190 1 1 0   4     0   2   91 107                       198 190 1 1 0   4     0   2   91 107                 198
1125537 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2017   grade_12 193 1 5 0   8     0   4   111 100                       211 193 1 5 0   8     0   4   111 100                 211
1125876 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2017   grade_12 2 1 84 0   0     0   0   55 32                       87 2 1 84 0   0     0   0   55 32                 87
1125889 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_12 1 1 14 0   0     0   0   13 3                       16 1 1 14 0   0     0   0   13 3                 16
1125944 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_12 56 1 1 1   4     0   1   27 37                       64 56 1 1 1   4     0   1   27 37                 64
1125996 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2017   grade_12 2 1 3 0   0     0   1   3 4                       7 2 1 3 0   0     0   1   3 4                 7
1126747 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   grade_12 85 1 5 4   2     0   5   59 43                       102 85 1 5 4   2     0   5   59 43                 102
1126793 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2017   grade_12 193 1 6 0   12     0   6   110 108                       218 193 1 6 0   12     0   6   110 108                 218
1127109 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 09 12 2017   grade_12 79 1 1 0   1     0   1   42 41                       83 79 1 1 0   1     0   1   42 41                 83
1127593 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   grade_12 74 1 7 0   0     0   4   45 41                       86 74 1 7 0   0     0   4   45 41                 86
1127821 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2017   grade_12 176 1 6 0   3     0   2   106 82                       188 176 1 6 0   3     0   2   106 82                 188
1127869 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2017   grade_12 175 1 3 0   5     0   0   84 100                       184 175 1 3 0   5     0   0   84 100                 184
1127979 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 08 12 2017   grade_12 69 1 4 0   1     0   1   39 37                       76 69 1 4 0   1     0   1   39 37                 76
1128545 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Seacoast School   Regular School No High 09 12 2017   grade_12 4 1 2 0   0     0   0   4 3                       7 4 1 2 0   0     0   0   4 3                 7
1128610 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No High 09 12 2017   grade_12 73 1 2 0   1     0   4   46 35                       81 73 1 2 0   1     0   4   46 35                 81
1128818 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No High 09 12 2017   grade_12 131 1 3 0   1     0   4   66 74                       140 131 1 3 0   1     0   4   66 74                 140
1129020 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2017   grade_12 6 1 5 0   0     0   0   8 4                       12 6 1 5 0   0     0   0   8 4                 12
1129427 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield High School   Regular School No High 09 12 2017   grade_12 2 1 5 0   0     0   0   6 2                       8 2 1 5 0   0     0   0   6 2                 8
1129801 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No High 09 12 2017   grade_12 110 1 5 1   2     0   0   60 59                       119 110 1 5 1   2     0   0   60 59                 119
1130071 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2017   grade_12 66 1 14 0   3     0   4   40 48                       88 66 1 14 0   3     0   4   40 48                 88
1130405 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 21st Century Skills Academy   Regular School No High 09 12 2017   grade_12 10 1 2 0   0     0   0   11 *                       13 10 1 2 0   0     0   0   11                   13
1130658 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop High School   Regular School No High 09 12 2017   grade_12 102 1 11 1   6     0   4   57 68                       125 102 1 11 1   6     0   4   57 68                 125
1131091 MA Hampshire   school 2508860 406   Northampton-Smith Vocational Agricultural 250886002314 4060705 Smith Vocational and Agricultural High   Career and Technical School No High 09 12 2017   grade_12 90 1 21 0   1     0   0   74 39                       113 90 1 21 0   1     0   0   74 39                 113
1131147 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_12 15 1 0 0   0     0   0   9 7                       16 15 1 0 0   0     0   0   9 7                 16
1131500 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2017   grade_12 37 1 12 0   0     0   0   19 31                       50 37 1 12 0   0     0   0   19 31                 50
1131514 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2017   grade_12 57 1 3 0   0     0   1   31 31                       62 57 1 3 0   0     0   1   31 31                 62
1131669 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2017   grade_12 5 1 0 0   5     0   0   8 3                       11 5 1 0 0   5     0   0   8 3                 11
1131763 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_12 76 1 1 0   2     0   0   39 41                       80 76 1 1 0   2     0   0   39 41                 80
1131896 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2017   grade_12 108 1 1 0   4     0   1   51 64                       115 108 1 1 0   4     0   1   51 64                 115
1132116 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2017   grade_12 146 1 3 1   1     0   1   67 86                       153 146 1 3 1   1     0   1   67 86                 153
1132123 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2017   grade_12 79 1 1 0   4     1   3   43 46                       89 79 1 1 0   4     1   3   43 46                 89
1132229 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No High 09 12 2017   grade_12 143 1 1 0   6     1   5   69 88                       157 143 1 1 0   6     1   5   69 88                 157
1132313 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2017   grade_12 106 1 0 0   1     0   0   52 56                       108 106 1 0 0   1     0   0   52 56                 108
1132326 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No High 09 12 2017   grade_12 320 1 6 0   8     0   0   168 167                       335 320 1 6 0   8     0   0   168 167                 335
1132350 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No High 09 12 2017   grade_12 118 1 1 0   2     0   0   59 63                       122 118 1 1 0   2     0   0   59 63                 122
1132381 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_12 85 1 0 1   1     0   5   52 41                       93 85 1 0 1   1     0   5   52 41                 93
1132421 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2017   grade_12 54 1 1 0   0     0   2   32 26                       58 54 1 1 0   0     0   2   32 26                 58
1132485 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2017   grade_12 215 1 15 1   2     0   13   124 123                       247 215 1 15 1   2     0   13   124 123                 247
1132579 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2017   grade_12 176 1 4 0   3     0   1   81 104                       185 176 1 4 0   3     0   1   81 104                 185
1132664 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   grade_12 5 1 0 0   0     0   0   * 4                       6 5 1 0 0   0     0   0     4                 6
1132815 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No High 09 12 2017   grade_12 155 1 4 0   1     0   1   75 87                       162 155 1 4 0   1     0   1   75 87                 162

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