Data source: Big Local News · About: Big Local

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

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
935314 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_12 70 0 0 1   0     0   0   34 37                       71 70 0 0 1   0     0   0   34 37                 71
935355 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2016   grade_12 45 0 5 0   2     0   1   31 22                       53 45 0 5 0   2     0   1   31 22                 53
935403 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_12 91 0 1 0   6     0   0   53 45                       98 91 0 1 0   6     0   0   53 45                 98
935456 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_12 5 0 1 0   0     0   0   5 1                       6 5 0 1 0   0     0   0   5 1                 6
935628 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_12 4 0 63 0   0     0   0   31 36                       67 4 0 63 0   0     0   0   31 36                 67
935643 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_12 75 0 4 0   1     0   0   44 36                       80 75 0 4 0   1     0   0   44 36                 80
935835 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2016   grade_12 1 0 124 0   2     0   1   58 70                       128 1 0 124 0   2     0   1   58 70                 128
935848 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2016   grade_12 0 0 26 0   0     0   0   10 16                       26 0 0 26 0   0     0   0   10 16                 26
935857 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2016   grade_12 2 0 62 0   0     0   0   38 26                       64 2 0 62 0   0     0   0   38 26                 64
935874 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2016   grade_12 1 0 15 0   0     0   0   4 12                       16 1 0 15 0   0     0   0   4 12                 16
935888 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2016   grade_12 50 0 8 0   2     0   1   33 28                       61 50 0 8 0   2     0   1   33 28                 61
935916 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_12 39 0 1 0   0     0   0   21 19                       40 39 0 1 0   0     0   0   21 19                 40
936190 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2016   grade_12 3 0 6 0   0     0   0   7 2                       9 3 0 6 0   0     0   0   7 2                 9
936614 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2016   grade_12 211 0 6 0   11     0   3   113 118                       231 211 0 6 0   11     0   3   113 118                 231
936676 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway High   Regular School No 3 09 12 2016   grade_12 190 0 9 1   8     0   1   100 109                       209 190 0 9 1   8     0   1   100 109                 209
936884 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No 3 09 12 2016   grade_12 82 0 6 0   1     0   0   38 51                       89 82 0 6 0   1     0   0   38 51                 89
937443 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No 3 09 12 2016   grade_12 135 0 11 0   1     0   5   86 66                       152 135 0 11 0   1     0   5   86 66                 152
937457 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2016   grade_12 41 0 2 0   0     0   0   24 19                       43 41 0 2 0   0     0   0   24 19                 43
937483 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2016   grade_12 183 0 2 0   4     0   4   102 91                       193 183 0 2 0   4     0   4   102 91                 193
937591 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_12 9 0 1 0   0     0   0   9 *                       10 9 0 1 0   0     0   0   9                   10
938317 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No 3 09 12 2016   grade_12 135 0 5 0   7     0   3   74 76                       150 135 0 5 0   7     0   3   74 76                 150
938828 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No 3 09 12 2016   grade_12 3 0 5 0   0     0   0   4 *                       8 3 0 5 0   0     0   0   4                   8
938967 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2016   grade_12 102 0 3 0   2     0   6   53 60                       113 102 0 3 0   2     0   6   53 60                 113
939275 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_12 50 0 3 0   1     0   1   26 29                       55 50 0 3 0   1     0   1   26 29                 55
939562 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No 3 09 12 2016   grade_12 316 0 5 0   73     0   24   214 204                       418 316 0 5 0   73     0   24   214 204                 418
940610 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes 3 07 12 2016   grade_12 56 0 3 0   1     1   1   34 28                       62 56 0 3 0   1     1   1   34 28                 62
940695 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2016   grade_12 184 0 6 0   3     0   7   93 107                       200 184 0 6 0   3     0   7   93 107                 200
941146 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No 3 09 12 2016   grade_12 60 0 1 0   0     0   1   28 34                       62 60 0 1 0   0     0   1   28 34                 62
941285 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_12 114 0 0 0   0     0   0   59 55                       114 114 0 0 0   0     0   0   59 55                 114
941344 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2016   grade_12 71 0 2 0   2     0   3   41 37                       78 71 0 2 0   2     0   3   41 37                 78
941513 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2016   grade_12 165 0 1 1   5     0   2   83 91                       174 165 0 1 1   5     0   2   83 91                 174
941550 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2016   grade_12 55 0 0 0   1     0   3   27 32                       59 55 0 0 0   1     0   3   27 32                 59
941588 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No 3 11 12 2016   grade_12 20 0 0 0   1     0   1   5 17                       22 20 0 0 0   1     0   1   5 17                 22
941596 MA Worcester   school 2509900 755   Ralph C Mahar 250990002701 7550515 Pathways Early College Innovation School   Regular School No 3 11 12 2016   grade_12 18 0 1 0   0     0   1   7 13                       20 18 0 1 0   0     0   1   7 13                 20
941632 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2016   grade_12 54 0 0 0   0     0   3   29 28                       57 54 0 0 0   0     0   3   29 28                 57
941673 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2016   grade_12 70 0 5 0   2     0   4   38 43                       81 70 0 5 0   2     0   4   38 43                 81
941875 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Technical   Vocational Education School No 3 09 12 2016   grade_12 122 0 2 0   0     0   0   76 48                       124 122 0 2 0   0     0   0   76 48                 124
941908 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Vocational Education School No 3 09 12 2016   grade_12 119 0 1 0   0     0   2   75 47                       122 119 0 1 0   0     0   2   75 47                 122
941912 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Vocational Education School No 3 09 12 2016   grade_12 146 0 6 0   1     0   5   102 56                       158 146 0 6 0   1     0   5   102 56                 158
941924 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2016   grade_12 143 0 4 1   0     0   2   87 63                       150 143 0 4 1   0     0   2   87 63                 150
941929 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Vocational Education School No 3 09 12 2016   grade_12 326 0 6 0   4     0   3   198 141                       339 326 0 6 0   4     0   3   198 141                 339
941941 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Vocational Education School No 3 09 12 2016   grade_12 249 0 13 0   1     0   1   170 94                       264 249 0 13 0   1     0   1   170 94                 264
942021 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_12 27 0 4 0   0     1   0   11 21                       32 27 0 4 0   0     1   0   11 21                 32
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
1364857 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_12 132 0 6 0   2     0   2   71 71 *                     142.0 132 0 6 0   2     0   2   71 71                 142
1365153 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_12 6 0 2 0   0     0   1   4 4 *                     9.0 6 0 2 0   0     0   1   4 4                 9
1365974 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No High 09 12 2020   grade_12 2 0 64 0   0     0   0   26 40 *                     66.0 2 0 64 0   0     0   0   26 40                 66
1367112 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No High 09 12 2020   grade_12 141 0 11 0   3     0   3   65 93 *                     158.0 141 0 11 0   3     0   3   65 93                 158
1367474 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2020   grade_12 98 0 2 0   1     0   5   52 54 *                     106.0 98 0 2 0   1     0   5   52 54                 106
1367549 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2020   grade_12 50 0 2 0   0     0   2   25 29 *                     54.0 50 0 2 0   0     0   2   25 29                 54
1367587 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_12 24 0 5 0   2     0   0   14 17 *                     31.0 24 0 5 0   2     0   0   14 17                 31
1367615 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2020   grade_12 182 0 2 0   6     0   0   98 92 *                     190.0 182 0 2 0   6     0   0   98 92                 190
1367643 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_12 28 0 1 0   0     0   2   15 16 *                     31.0 28 0 1 0   0     0   2   15 16                 31
1367892 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No High 09 12 2020   grade_12 254 0 8 1   28     0   3   149 145 *                     294.0 254 0 8 1   28     0   3   149 145                 294

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