Data source: Big Local News · About: Big Local

393 rows where grade = "grade_9", state = "MA" and year = 2018 sorted by school_nces_id

View and edit SQL

year

  • 2018 · 393

grade

  • grade_9 · 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
2239483 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin: Quabbin Regional High School   Regular School No High 09 12 2018   grade_9 183 1 5 0   1     0   11   96 105                       201.0 183 1 5 0   1     0   11   96 105                 201
2239579 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 Spencer-E Brookfield: David Prouty High   Regular School No High 09 12 2018   grade_9 54 2 10 1   1     0   3   34 37                       71.0 54 2 10 1   1     0   3   34 37                 71
2239554 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District: Southwick Regional School   Regular School No High 07 12 2018   grade_9 101 2 7 0   1     0   1   57 55                       112.0 101 2 7 0   1     0   1   57 55                 112
2237956 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_9 3 46 19 0   1     0   0   37 32                       69.0 3 46 19 0   1     0   0   37 32                 69
2238077 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_9 77 11 11 0   8     0   3   47 63                       110.0 77 11 11 0   8     0   3   47 63                 110
2238090 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_9 1 85 37 0   0     0   0   71 51                       123.0 1 85 37 0   0     0   0   71 51                 123
2238141 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_9 41 22 36 0   4     0   7   52 58                       110.0 41 22 36 0   4     0   7   52 58                 110
2238156 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   grade_9 7 31 9 0   0     0   0   27 20                       47.0 7 31 9 0   0     0   0   27 20                 47
2238262 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_9 3 0 13 0   5     0   0   11 10                       21.0 3 0 13 0   5     0   0   11 10                 21
2238291 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_9 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2238344 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_9 62 1 2 0   2     0   1   30 37                       68.0 62 1 2 0   2     0   1   30 37                 68
2238437 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District): South Shore Charter Public School   Regular School Yes Other KG 12 2018   grade_9 47 20 1 3   4     0   3   37 41                       78.0 47 20 1 3   4     0   3   37 41                 78
2238456 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_9 55 3 12 0   3     0   2   43 32                       75.0 55 3 12 0   3     0   2   43 32                 75
2238351 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_9 43 7 10 0   1     0   3   25 39                       64.0 43 7 10 0   1     0   3   25 39                 64
2238423 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_9 9 57 24 0   8     0   1   52 47                       99.0 9 57 24 0   8     0   1   52 47                 99
2238010 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_9 6 52 44 0   0     0   5   52 55                       107.0 6 52 44 0   0     0   5   52 55                 107
2238167 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_9 16 47 29 1   6     0   2   44 57                       101.0 16 47 29 1   6     0   2   44 57                 101
2238181 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_9 24 39 5 0   11     1   5   36 49                       85.0 24 39 5 0   11     1   5   36 49                 85
2238200 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_9 41 28 15 1   1     0   1   41 46                       87.0 41 28 15 1   1     0   1   41 46                 87
2238215 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_9 2 42 57 1   0     0   5   45 62                       107.0 2 42 57 1   0     0   5   45 62                 107
2238323 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_9 52 11 3 0   23     0   2   46 45                       91.0 52 11 3 0   23     0   2   46 45                 91
2238383 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_9 68 0 1 0   0     0   4   32 41                       73.0 68 0 1 0   0     0   4   32 41                 73
2238442 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District): Sturgis Charter Public School   Regular School Yes High 09 12 2018   grade_9 183 5 7 0   11     0   9   97 118                       215.0 183 5 7 0   11     0   9   97 118                 215
2238392 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_9 2 113 81 1   0     0   2   117 82                       199.0 2 113 81 1   0     0   2   117 82                 199
2238309 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_9 2 49 38 1   0     0   1   51 40                       91.0 2 49 38 1   0     0   1   51 40                 91
2239141 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional: Manchester Essex Regional High School   Regular School No High 09 12 2018   grade_9 129 0 0 0   2     0   0   59 72                       131.0 129 0 0 0   2     0   0   59 72                 131
2238105 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_9 1 27 11 1   0     0   1   16 25                       41.0 1 27 11 1   0     0   1   16 25                 41
2238037 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_9 2 38 24 1   1     0   0   32 34                       66.0 2 38 24 1   1     0   0   32 34                 66
2238330 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_9 46 5 18 0   0     0   0   42 27                       69.0 46 5 18 0   0     0   0   42 27                 69
2237940 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_9 12 9 148 1   0     0   2   89 83                       172.0 12 9 148 1   0     0   2   89 83                 172
2237963 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_9 27 0 7 0   2     0   2   20 18                       38.0 27 0 7 0   2     0   2   20 18                 38
2237971 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_9 35 10 2 0   0     0   1   25 23                       48.0 35 10 2 0   0     0   1   25 23                 48
2237979 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_9 3 57 28 0   1     0   0   44 45                       89.0 3 57 28 0   1     0   0   44 45                 89
2238047 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_9 9 27 87 0   4     0   4   61 70                       131.0 9 27 87 0   4     0   4   61 70                 131
2238399 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_9 25 8 43 0   4     0   2   39 43                       82.0 25 8 43 0   4     0   2   39 43                 82
2238055 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_9 99 1 10 0   43     0   5   79 79                       158.0 99 1 10 0   43     0   5   79 79                 158
2238085 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_9 2 32 11 0   1     0   0   22 24                       46.0 2 32 11 0   1     0   0   22 24                 46
2238468 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy (District): Phoenix Charter Academy   Regular School Yes High 09 12 2018   grade_9 6 15 108 1   2     0   0   69 63                       132.0 6 15 108 1   2     0   0   69 63                 132
2238503 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District): Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2018   grade_9 19 7 2 0   6     0   5   15 24                       39.0 19 7 2 0   6     0   5   15 24                 39
2238480 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District): Pioneer Charter School of Science   Regular School Yes Other KG 12 2018   grade_9 12 17 25 2   7     0   1   25 39                       64.0 12 17 25 2   7     0   1   25 39                 64
2238489 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District): Global Learning Charter Public School   Regular School Yes High 05 12 2018   grade_9 9 2 19 0   0     0   2   13 19                       32.0 9 2 19 0   0     0   2   13 19                 32
2238516 MA Hampden   school 2500522 499   Hampden Charter School of Science East (District) 250052202680 4990305 Hampden Charter School of Science East (District): Hampden Charter School of Science East   Regular School Yes High 06 12 2018   grade_9 20 28 25 0   1     0   2   42 34                       76.0 20 28 25 0   1     0   2   42 34                 76
2237947 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_9 10 41 33 0   3     0   1   48 40                       88.0 10 41 33 0   3     0   1   48 40                 88
2239514 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional School District: Somerset Berkley Regional High School   Regular School No High 09 12 2018   grade_9 232 3 9 1   0     0   4   125 124                       249.0 232 3 9 1   0     0   4   125 124                 249
2238674 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District: Ayer Shirley Regional High School   Regular School No High 09 12 2018   grade_9 71 5 13 2   2     0   13   47 59                       106.0 71 5 13 2   2     0   13   47 59                 106
2239202 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District: Monomoy Regional High School   Regular School No High 08 12 2018   grade_9 94 9 4 0   0     0   5   52 60                       112.0 94 9 4 0   0     0   5   52 60                 112
2239966 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II) (District): Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2018   grade_9 24 25 16 0   3     0   1   34 35                       69.0 24 25 16 0   3     0   1   34 35                 69
2239927 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School (District): Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2018   grade_9 2 3 61 0   0     0   0   21 45                       66.0 2 3 61 0   0     0   0   21 45                 66
2239948 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square (District): City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2018   grade_9 0 55 27 0   2     1   3   47 41                       88.0 0 55 27 0   2     1   3   47 41                 88
2239935 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_9 3 16 54 0   1     0   1   35 40                       75.0 3 16 54 0   1     0   1   35 40                 75
2240019 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_9 49 7 21 0   2     0   2   29 52                       81.0 49 7 21 0   2     0   2   29 52                 81
2239984 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   grade_9 42 17 25 0   1     0   5   49 41                       90.0 42 17 25 0   1     0   5   49 41                 90
2239971 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford (District): City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2018   grade_9 36 14 52 0   2     0   3   50 56                       107.0 36 14 52 0   2     0   3   50 56                 107
2239812 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District: Essex Technical High School   Career and Technical School No High 09 12 2018   grade_9 297 4 38 3   7     0   15   140 223                       364.0 297 4 38 3   7     0   15   140 223                 364
2239976 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield (District): Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2018   grade_9 5 30 94 1   1     0   5   69 67                       136.0 5 30 94 1   1     0   5   69 67                 136
2240033 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_9 207 16 40 2   9     2   20   133 163                       296.0 207 16 40 2   9     2   20   133 163                 296
2240001 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_9 1 87 6 0   5     0   0   52 47                       99.0 1 87 6 0   5     0   0   52 47                 99
2228768 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_9 126 7 17 1   1     0   1   81 72                       153.0 126 7 17 1   1     0   1   81 72                 153
2238574 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough: Acton-Boxborough Regional High   Regular School No High 09 12 2018   grade_9 240 9 11 1   145     0   21   225 202                       427.0 240 9 11 1   145     0   21   225 202                 427
2238591 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Adams-Cheshire: Hoosac Valley High School   Regular School No High 08 12 2018   grade_9 44 5 1 0   2     0   0   27 25                       52.0 44 5 1 0   2     0   0   27 25                 52
2228817 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   grade_9 282 5 21 0   1     0   9   159 159                       318.0 282 5 21 0   1     0   9   159 159                 318
2228841 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury: Amesbury High   Regular School No High 09 12 2018   grade_9 124 5 15 1   2     0   9   82 74                       156.0 124 5 15 1   2     0   9   82 74                 156
2228846 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   grade_9 8 0 0 0   0     0   1   5 4                       9.0 8 0 0 0   0     0   1   5 4                 9
2238599 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham: Amherst Regional High   Regular School No High 09 12 2018   grade_9 131 16 46 0   19     1   28   114 127                       241.0 131 16 46 0   19     1   28   114 127                 241
2228925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_9 333 10 21 0   98     0   10   209 262                       472.0 333 10 21 0   98     0   10   209 262                 472
2228985 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   grade_9 261 16 23 0   36     0   14   168 182                       350.0 261 16 23 0   36     0   14   168 182                 350
2238624 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Ashburnham-Westminster: Oakmont Regional High School   Regular School No High 09 12 2018   grade_9 164 0 7 0   4     0   2   83 94                       177.0 164 0 7 0   4     0   2   83 94                 177
2229004 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_9 151 4 23 0   19     0   9   99 106                       206.0 151 4 23 0   19     0   9   99 106                 206
2239787 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical: Assabet Valley Vocational High School   Career and Technical School No High 09 12 2018   grade_9 244 2 46 1   1     0   6   182 117                       300.0 244 2 46 1   1     0   6   182 117                 300
2238649 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol-Royalston: Athol High   Regular School No High 09 12 2018   grade_9 80 1 9 0   0     0   5   55 40                       95.0 80 1 9 0   0     0   5   55 40                 95
2229056 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_9 309 27 66 1   25     2   26   242 214                       456.0 309 27 66 1   25     2   26   242 214                 456
2229082 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   grade_9 155 3 6 1   11     0   5   79 102                       181.0 155 3 6 1   11     0   5   79 102                 181
2229098 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_9 19 16 1 0   2     0   1   29 10                       39.0 19 16 1 0   2     0   1   29 10                 39
2229132 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_9 262 31 57 1   4     1   13   200 169                       369.0 262 31 57 1   4     1   13   200 169                 369
2229150 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford: Bedford High   Regular School No High 09 12 2018   grade_9 121 11 17 0   20     0   11   94 86                       180.0 121 11 17 0   20     0   11   94 86                 180
2229169 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown: Belchertown High   Regular School No High 09 12 2018   grade_9 164 5 3 1   5     0   5   91 92                       183.0 164 5 3 1   5     0   5   91 92                 183
2229192 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham: Bellingham High School   Regular School No High 08 12 2018   grade_9 137 5 5 0   6     0   5   90 68                       158.0 137 5 5 0   6     0   5   90 68                 158
2229198 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham: Keough Memorial Academy   Alternative School No High 08 12 2018   grade_9 * * * *   *     *   *   1 3                       4.0                         1 3                 4
2229233 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont: Belmont High   Regular School No High 09 12 2018   grade_9 228 10 13 1   58     0   21   171 160                       331.0 228 10 13 1   58     0   21   171 160                 331
2238691 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Berkshire Hills: Monument Mt Regional High   Regular School No High 09 12 2018   grade_9 103 4 10 0   3     2   6   69 59                       128.0 103 4 10 0   3     2   6   69 59                 128
2238699 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston: Tahanto Regional High   Regular School No High 06 12 2018   grade_9 70 3 4 0   3     0   4   41 43                       84.0 70 3 4 0   3     0   4   41 43                 84
2229299 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly: Beverly High   Regular School No High 09 12 2018   grade_9 244 10 44 0   10     0   11   167 152                       319.0 244 10 44 0   10     0   11   167 152                 319
2229355 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_9 220 14 11 0   23     0   4   141 131                       272.0 220 14 11 0   23     0   4   141 131                 272
2239792 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley Regional Vocational Technical: Blackstone Valley   Career and Technical School No High 09 12 2018   grade_9 276 1 17 0   6     0   11   161 150                       311.0 276 1 17 0   6     0   11   161 150                 311
2238724 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone-Millville: Blackstone Millville RHS   Regular School No High 09 12 2018   grade_9 85 3 10 0   3     0   0   62 39                       101.0 85 3 10 0   3     0   0   62 39                 101
2239797 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical: Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 133 50 26 1   5     0   9   124 100                       224.0 133 50 26 1   5     0   9   124 100                 224
2230167 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_9 201 32 50 2   140     2   16   205 238                       443.0 201 32 50 2   140     2   16   205 238                 443
2230142 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_9 102 74 100 1   86     1   8   157 215                       372.0 102 74 100 1   86     1   8   157 215                 372
2230182 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_9 39 141 148 1   60     2   6   178 219                       397.0 39 141 148 1   60     2   6   178 219                 397
2230075 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston: Brighton High   Regular School No High 09 12 2018   grade_9 7 54 65 2   3     1   0   84 48                       132.0 7 54 65 2   3     1   0   84 48                 132
2229453 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2230085 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston: Charlestown High   Regular School No High 09 12 2018   grade_9 12 85 152 0   17     0   3   162 107                       269.0 12 85 152 0   17     0   3   162 107                 269
2230246 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Boston: Snowden International School at Copley   Regular School No High 09 12 2018   grade_9 14 49 65 1   7     0   6   84 58                       142.0 14 49 65 1   7     0   6   84 58                 142
2229501 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston: Dearborn   Regular School No High 06 12 2018   grade_9 1 45 14 0   0     0   4   32 32                       64.0 1 45 14 0   0     0   4   32 32                 64
2230105 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_9 34 17 277 0   6     0   6   222 118                       340.0 34 17 277 0   6     0   6   222 118                 340
2230100 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston: Jeremiah E Burke High   Regular School No High 09 12 2018   grade_9 0 69 29 0   0     1   3   66 36                       102.0 0 69 29 0   0     1   3   66 36                 102
2230115 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston: Madison Park High   Career and Technical School No High 09 12 2018   grade_9 4 77 144 0   4     0   3   156 76                       232.0 4 77 144 0   4     0   3   156 76                 232
2230110 MA Suffolk   school 2502790 35   Boston 250279000327 350535 Boston: The English High   Regular School No High 09 12 2018   grade_9 1 76 103 0   1     0   1   118 64                       182.0 1 76 103 0   1     0   1   118 64                 182
2229944 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_9 2 39 23 0   2     0   1   49 18                       67.0 2 39 23 0   2     0   1   49 18                 67
2230120 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Boston: Fenway High School   Alternative School No High 09 12 2018   grade_9 3 26 70 0   2     0   1   50 52                       102.0 3 26 70 0   2     0   1   50 52                 102

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