Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2016 · 392

grade

  • grade_9 · 392
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black ▼ hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
933714 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
934033 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   3 2                       5                         3 2                 5
936655 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   1 *                       1                         1                   1
938833 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   3 2                       5                         3 2                 5
938837 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2016   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
939063 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2016   grade_9 * * * *   *     *   *   4 1                       5                         4 1                 5
939288 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_9 * * * *   *     *   *   * *                       1                                             1
939787 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_9 * * * *   *     *   *   1 4                       5                         1 4                 5
932900 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_9 5 0 1 0   0     0   1   4 3                       7 5 0 1 0   0     0   1   4 3                 7
934410 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2016   grade_9 11 0 9 0   0     0   1   14 7                       21 11 0 9 0   0     0   1   14 7                 21
934641 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2016   grade_9 104 0 2 0   0     0   1   56 51                       107 104 0 2 0   0     0   1   56 51                 107
935220 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2016   grade_9 11 0 0 0   0     0   1   2 10                       12 11 0 0 0   0     0   1   2 10                 12
935234 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2016   grade_9 88 0 1 0   1     0   0   40 50                       90 88 0 1 0   1     0   0   40 50                 90
935311 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_9 47 0 1 0   2     0   1   31 20                       51 47 0 1 0   2     0   1   31 20                 51
935414 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2016   grade_9 27 0 1 0   2     0   0   13 17                       30 27 0 1 0   2     0   0   13 17                 30
935640 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_9 79 0 2 4   0     0   3   42 46                       88 79 0 2 4   0     0   3   42 46                 88
935654 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2016   grade_9 234 0 6 0   13     0   6   132 127                       259 234 0 6 0   13     0   6   132 127                 259
935695 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No 3 09 12 2016   grade_9 78 0 3 0   0     0   1   42 40                       82 78 0 3 0   0     0   1   42 40                 82
935716 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No 3 09 12 2016   grade_9 108 0 6 0   4     0   5   60 63                       123 108 0 6 0   4     0   5   60 63                 123
935828 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2016   grade_9 1 0 14 0   0     0   0   14 1                       15 1 0 14 0   0     0   0   14 1                 15
935841 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2016   grade_9 1 0 28 0   0     0   0   22 7                       29 1 0 28 0   0     0   0   22 7                 29
935849 MA Essex   school 2506660 149   Lawrence 250666002616 1490535 Performing & Fine Arts High School   Regular School No 3 09 12 2016   grade_9 0 0 8 0   0     0   0   4 4                       8 0 0 8 0   0     0   0   4 4                 8
935854 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2016   grade_9 0 0 8 0   0     0   0   7 1                       8 0 0 8 0   0     0   0   7 1                 8
935866 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_9 2 0 19 0   0     0   0   17 4                       21 2 0 19 0   0     0   0   17 4                 21
935885 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2016   grade_9 54 0 4 0   4     0   3   36 29                       65 54 0 4 0   4     0   3   36 29                 65
935913 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_9 40 0 6 1   0     0   2   20 29                       49 40 0 6 1   0     0   2   20 29                 49
936043 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2016   grade_9 99 0 1 0   4     1   4   50 59                       109 99 0 1 0   4     1   4   50 59                 109
936187 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2016   grade_9 0 0 5 0   1     0   0   4 2                       6 0 0 5 0   1     0   0   4 2                 6
936401 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No 3 09 12 2016   grade_9 148 0 10 0   6     0   5   93 76                       169 148 0 10 0   6     0   5   93 76                 169
936881 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No 3 09 12 2016   grade_9 69 0 1 0   1     0   2   39 34                       73 69 0 1 0   1     0   2   39 34                 73
937454 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2016   grade_9 41 0 2 0   0     0   2   22 23                       45 41 0 2 0   0     0   2   22 23                 45
937480 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2016   grade_9 180 0 3 0   5     0   4   93 99                       192 180 0 3 0   5     0   4   93 99                 192
937519 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No 3 09 12 2016   grade_9 167 0 3 0   4     0   2   89 87                       176 167 0 3 0   4     0   2   89 87                 176
938145 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No 3 09 12 2016   grade_9 75 0 1 0   1     0   1   41 37                       78 75 0 1 0   1     0   1   41 37                 78
938964 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2016   grade_9 106 0 2 0   1     0   4   50 63                       113 106 0 2 0   1     0   4   50 63                 113
940257 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2016   grade_9 32 0 3 0   0     0   4   19 20                       39 32 0 3 0   0     0   4   19 20                 39
940528 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes 3 09 12 2016   grade_9 11 0 7 0   2     0   2   11 11                       22 11 0 7 0   2     0   2   11 11                 22
940552 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_9 5 0 1 0   0     0   0   3 3                       6 5 0 1 0   0     0   0   3 3                 6
940607 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_9 63 0 2 0   2     0   2   33 36                       69 63 0 2 0   2     0   2   33 36                 69
940848 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No 3 09 12 2016   grade_9 155 0 3 0   2     0   3   77 86                       163 155 0 3 0   2     0   3   77 86                 163
941122 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2016   grade_9 83 0 5 0   3     0   3   52 42                       94 83 0 5 0   3     0   3   52 42                 94
941143 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No 3 09 12 2016   grade_9 63 0 5 1   0     0   1   39 31                       70 63 0 5 1   0     0   1   39 31                 70
941185 MA Franklin   school 2505270 674   Gill-Montague 250527000768 6740505 Turners Fall High   Regular School No 3 09 12 2016   grade_9 48 0 8 1   0     0   3   34 26                       60 48 0 8 1   0     0   3   34 26                 60
941212 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No 3 09 12 2016   grade_9 138 0 4 0   6     0   3   77 74                       151 138 0 4 0   6     0   3   77 74                 151
941242 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_9 99 0 1 0   0     0   2   54 48                       102 99 0 1 0   0     0   2   54 48                 102
941282 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_9 109 0 0 0   0     0   2   46 65                       111 109 0 0 0   0     0   2   46 65                 111
941378 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No 3 07 12 2016   grade_9 66 0 4 0   0     0   5   37 38                       75 66 0 4 0   0     0   5   37 38                 75
941397 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No 3 09 12 2016   grade_9 97 0 3 0   1     0   2   56 47                       103 97 0 3 0   1     0   2   56 47                 103
941629 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2016   grade_9 41 0 2 0   0     0   5   19 29                       48 41 0 2 0   0     0   5   19 29                 48
941682 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 127 0 11 0   1     0   3   85 57                       142 127 0 11 0   1     0   3   85 57                 142
941848 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Vocational Education School No 3 09 12 2016   grade_9 233 0 44 0   1     0   6   158 126                       284 233 0 44 0   1     0   6   158 126                 284
941905 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_9 109 0 2 0   0     0   1   77 35                       112 109 0 2 0   0     0   1   77 35                 112
941909 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_9 169 0 11 1   1     0   4   108 78                       186 169 0 11 1   1     0   4   108 78                 186
941917 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 138 0 0 0   0     0   2   82 58                       140 138 0 0 0   0     0   2   82 58                 140
941954 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Vocational Education School No 3 09 12 2016   grade_9 118 0 3 1   0     0   4   25 101                       126 118 0 3 1   0     0   4   25 101                 126
932895 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 08 12 2016   grade_9 127 1 3 0   4     0   1   76 60                       136 127 1 3 0   4     0   1   76 60                 136
933107 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 4 06 12 2016   grade_9 1 1 1 0   3     0   0   3 3                       6 1 1 1 0   3     0   0   3 3                 6
934003 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_9 5 1 2 0   0     0   0   5 3                       8 5 1 2 0   0     0   0   5 3                 8
934312 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2016   grade_9 105 1 0 0   0     0   2   60 48                       108 105 1 0 0   0     0   2   60 48                 108
934695 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No 3 09 12 2016   grade_9 242 1 5 0   8     0   3   130 129                       259 242 1 5 0   8     0   3   130 129                 259
935053 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No 3 09 12 2016   grade_9 4 1 3 0   0     0   0   4 4                       8 4 1 3 0   0     0   0   4 4                 8
935337 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2016   grade_9 58 1 20 0   3     0   6   49 39                       88 58 1 20 0   3     0   6   49 39                 88
935547 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No 3 09 12 2016   grade_9 170 1 7 0   10     0   4   93 99                       192 170 1 7 0   10     0   4   93 99                 192
935836 MA Essex   school 2506660 149   Lawrence 250666002633 1490532 Humanities & Leadership Development High School   Regular School No 3 09 12 2016   grade_9 0 1 26 0   1     0   0   23 5                       28 0 1 26 0   1     0   0   23 5                 28
935845 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2016   grade_9 1 1 22 0   0     0   0   20 4                       24 1 1 22 0   0     0   0   20 4                 24
935954 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No 3 09 12 2016   grade_9 4 1 1 0   0     0   1   3 4                       7 4 1 1 0   0     0   1   3 4                 7
936237 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2016   grade_9 101 1 5 1   8     1   0   58 59                       117 101 1 5 1   8     1   0   58 59                 117
936611 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2016   grade_9 177 1 3 0   13     1   3   101 97                       198 177 1 3 0   13     1   3   101 97                 198
937119 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 4 06 12 2016   grade_9 8 1 7 0   0     0   2   11 7                       18 8 1 7 0   0     0   2   11 7                 18
937588 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_9 5 1 2 0   0     0   0   6 *                       8 5 1 2 0   0     0   0   6                   8
938220 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2016   grade_9 167 1 0 1   2     0   0   88 83                       171 167 1 0 1   2     0   0   88 83                 171
938524 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2016   grade_9 81 1 79 0   1     0   0   96 66                       162 81 1 79 0   1     0   0   96 66                 162
939122 MA Middlesex   school 2511760 301   Tyngsborough 251176001934 3010505 Tyngsborough High School   Regular School No 3 09 12 2016   grade_9 103 1 7 0   5     0   5   62 59                       121 103 1 7 0   5     0   5   62 59                 121
939272 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_9 78 1 6 0   1     0   1   41 46                       87 78 1 6 0   1     0   1   41 46                 87
939458 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2016   grade_9 56 1 6 0   2     0   3   35 33                       68 56 1 6 0   2     0   3   35 33                 68
939601 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport Senior High School   Regular School No 3 08 12 2016   grade_9 95 1 3 0   3     0   4   55 51                       106 95 1 3 0   3     0   4   55 51                 106
939829 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No 3 09 12 2016   grade_9 229 1 12 0   41     0   11   144 150                       294 229 1 12 0   41     0   11   144 150                 294
940641 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2016   grade_9 68 1 2 0   5     0   0   41 35                       76 68 1 2 0   5     0   0   41 35                 76
940875 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No 3 09 12 2016   grade_9 79 1 3 0   0     0   2   48 37                       85 79 1 3 0   0     0   2   48 37                 85
940919 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_9 70 1 1 0   0     0   3   28 47                       75 70 1 1 0   0     0   3   28 47                 75
941341 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2016   grade_9 85 1 0 0   1     0   2   45 44                       89 85 1 0 0   1     0   2   45 44                 89
941510 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2016   grade_9 150 1 6 0   1     0   1   74 85                       159 150 1 6 0   1     0   1   74 85                 159
941547 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2016   grade_9 59 1 1 1   1     0   2   35 30                       65 59 1 1 1   1     0   2   35 30                 65
941582 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2016   grade_9 162 1 11 0   1     0   6   87 94                       181 162 1 11 0   1     0   6   87 94                 181
941597 MA Worcester   school 2509900 755   Ralph C Mahar 250990002707 7550525 The Gateway to College   Regular School No 3 09 12 2016   grade_9 13 1 1 0   1     0   1   3 14                       17 13 1 1 0   1     0   1   3 14                 17
941670 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2016   grade_9 101 1 7 0   1     0   5   61 54                       115 101 1 7 0   1     0   5   61 54                 115
941677 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No 3 09 12 2016   grade_9 135 1 7 1   1     1   4   76 74                       150 135 1 7 1   1     1   4   76 74                 150
941712 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No 3 09 12 2016   grade_9 171 1 7 0   4     0   2   86 99                       185 171 1 7 0   4     0   2   86 99                 185
941814 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No 3 09 12 2016   grade_9 107 1 7 0   0     0   2   63 54                       117 107 1 7 0   0     0   2   63 54                 117
941852 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Vocational Education School No 3 09 12 2016   grade_9 293 1 5 0   7     0   5   159 152                       311 293 1 5 0   7     0   5   159 152                 311
941921 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 151 1 9 1   0     0   5   104 63                       167 151 1 9 1   0     0   5   104 63                 167
941942 MA Norfolk   school 2511735 878   Tri County Regional Vocational Technical 251173501931 8780605 Tri County Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 261 1 13 0   4     1   11   156 135                       291 261 1 13 0   4     1   11   156 135                 291
935007 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_9 183 10 5 6   9     0   10   101 122                       223 183 10 5 6   9     0   10   101 122                 223
936465 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2016   grade_9 291 10 12 0   13     0   9   165 170                       335 291 10 12 0   13     0   9   165 170                 335
936488 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No 3 09 12 2016   grade_9 229 10 15 1   6     0   4   126 139                       265 229 10 15 1   6     0   4   126 139                 265
937359 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2016   grade_9 311 10 34 0   22     2   5   186 198                       384 311 10 34 0   22     2   5   186 198                 384
937397 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No 3 09 12 2016   grade_9 235 10 12 1   18     0   6   151 131                       282 235 10 12 1   18     0   6   151 131                 282
940613 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes 3 07 12 2016   grade_9 42 10 7 0   1     0   9   20 49                       69 42 10 7 0   1     0   9   20 49                 69
940713 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes 3 09 12 2016   grade_9 4 10 66 0   1     0   0   45 36                       81 4 10 66 0   1     0   0   45 36                 81
936451 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2016   grade_9 152 101 123 4   112     0   12   265 239                       504 152 101 123 4   112     0   12   265 239                 504

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