Data source: Big Local News · About: Big Local

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

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
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
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
941649 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No 3 07 12 2016   grade_9 115 4 6 0   1     0   1   62 65                       127 115 4 6 0   1     0   1   62 65                 127
940251 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2016   grade_9 7 37 16 0   1     1   5   36 31                       67 7 37 16 0   1     1   5   36 31                 67
940346 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_9 88 5 8 0   4     0   5   50 60                       110 88 5 8 0   4     0   5   50 60                 110
940357 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   Regular School Yes 3 09 12 2016   grade_9 2 87 17 0   0     0   2   46 62                       108 2 87 17 0   0     0   2   46 62                 108
940402 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_9 33 49 41 0   8     0   5   63 73                       136 33 49 41 0   8     0   5   63 73                 136
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
940688 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2016   grade_9 27 14 3 0   1     0   3   23 25                       48 27 14 3 0   1     0   3   23 25                 48
940705 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_9 49 2 8 0   3     0   1   29 34                       63 49 2 8 0   3     0   1   29 34                 63
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
940675 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_9 8 47 23 0   7     0   4   39 50                       89 8 47 23 0   7     0   4   39 50                 89
940294 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2016   grade_9 3 38 31 2   2     1   2   41 38                       79 3 38 31 2   2     1   2   41 38                 79
940434 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_9 27 39 17 0   6     1   3   56 37                       93 27 39 17 0   6     1   3   56 37                 93
940447 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_9 30 33 3 0   8     0   2   41 35                       76 30 33 3 0   8     0   2   41 35                 76
940464 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_9 47 18 14 0   3     0   1   31 52                       83 47 18 14 0   3     0   1   31 52                 83
940477 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 School)   Regular School Yes 3 09 12 2016   grade_9 8 33 49 1   0     0   2   30 63                       93 8 33 49 1   0     0   2   30 63                 93
940584 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_9 50 16 6 0   23     0   2   47 50                       97 50 16 6 0   23     0   2   47 50                 97
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
940692 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2016   grade_9 184 6 12 2   8     1   7   87 133                       220 184 6 12 2   8     1   7   87 133                 220
940649 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_9 2 103 65 1   1     0   3   84 91                       175 2 103 65 1   1     0   3   84 91                 175
940571 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   grade_9 4 43 34 1   0     0   4   40 46                       86 4 43 34 1   0     0   4   40 46                 86
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
940369 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   grade_9 0 38 13 0   0     1   0   26 26                       52 0 38 13 0   0     1   0   26 26                 52
940590 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2016   grade_9 55 2 15 0   1     0   2   41 34                       75 55 2 15 0   1     0   2   41 34                 75
940239 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_9 12 18 79 2   4     0   0   56 59                       115 12 18 79 2   4     0   0   56 59                 115
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
940264 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2016   grade_9 40 12 7 0   2     0   3   31 33                       64 40 12 7 0   2     0   3   31 33                 64
940271 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_9 3 57 14 0   1     0   1   41 35                       76 3 57 14 0   1     0   1   41 35                 76
940322 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_9 5 38 80 0   3     0   4   63 67                       130 5 38 80 0   3     0   4   63 67                 130
940653 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_9 31 5 28 0   3     0   0   29 38                       67 31 5 28 0   3     0   0   29 38                 67
940329 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2016   grade_9 93 4 2 1   24     0   11   61 74                       135 93 4 2 1   24     0   11   61 74                 135
940353 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2016   grade_9 4 38 18 0   3     0   2   37 28                       65 4 38 18 0   3     0   2   37 28                 65
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
940740 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_9 15 4 1 0   8     0   2   17 13                       30 15 4 1 0   8     0   2   17 13                 30
940719 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes 3 07 12 2016   grade_9 20 29 11 1   8     0   0   28 41                       69 20 29 11 1   8     0   0   28 41                 69
940727 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_9 25 8 14 1   1     0   1   24 26                       50 25 8 14 1   1     0   1   24 26                 50
940750 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2016   grade_9 25 11 20 0   2     0   2   29 31                       60 25 11 20 0   2     0   2   29 31                 60
940242 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2016   grade_9 5 44 21 0   1     0   1   35 37                       72 5 44 21 0   1     0   1   35 37                 72
941607 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No 3 09 12 2016   grade_9 239 4 5 0   2     1   6   118 139                       257 239 4 5 0   2     1   6   118 139                 257
940897 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No 3 09 12 2016   grade_9 95 6 12 0   3     0   10   59 67                       126 95 6 12 0   3     0   10   59 67                 126
941334 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2016   grade_9 100 11 3 0   2     0   4   66 54                       120 100 11 3 0   2     0   4   66 54                 120
941990 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes 4 07 11 2016   grade_9 22 19 14 2   11     0   2   38 32                       70 22 19 14 2   11     0   2   38 32                 70
941962 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes 3 09 12 2016   grade_9 12 7 102 0   0     0   0   54 67                       121 12 7 102 0   0     0   0   54 67                 121
941976 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   Regular School Yes 4 09 11 2016   grade_9 2 103 21 0   2     0   0   61 67                       128 2 103 21 0   2     0   0   61 67                 128
941969 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 09 2016   grade_9 3 18 43 0   0     0   1   29 36                       65 3 18 43 0   0     0   1   29 36                 65
942018 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_9 44 9 10 1   2     1   1   30 38                       68 44 9 10 1   2     1   1   30 38                 68
941993 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   Regular School Yes 4 09 10 2016   grade_9 35 16 46 0   1     0   4   52 50                       102 35 16 46 0   1     0   4   52 50                 102
941868 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex Technical High School   Vocational Education School No 3 09 12 2016   grade_9 295 4 43 1   6     0   8   151 206                       357 295 4 43 1   6     0   8   151 206                 357
941995 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes 3 09 12 2016   grade_9 8 32 87 0   2     0   5   69 65                       134 8 32 87 0   2     0   5   69 65                 134
942031 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_9 108 11 14 0   2     1   8   51 93                       144 108 11 14 0   2     1   8   51 93                 144
932546 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_9 93 6 6 0   0     1   4   51 59                       110 93 6 6 0   0     1   4   51 59                 110
940800 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2016   grade_9 298 5 15 0   154     0   16   260 228                       488 298 5 15 0   154     0   16   260 228                 488
940820 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_9 87 5 4 1   3     0   0   45 55                       100 87 5 4 1   3     0   0   45 55                 100
932588 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2016   grade_9 278 6 23 0   6     0   6   168 151                       319 278 6 23 0   6     0   6   168 151                 319
932608 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2016   grade_9 127 3 9 0   2     0   5   81 65                       146 127 3 9 0   2     0   5   81 65                 146
940827 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2016   grade_9 137 13 35 0   21     0   16   111 111                       222 137 13 35 0   21     0   16   111 111                 222
932677 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_9 367 9 17 0   66     0   12   209 262                       471 367 9 17 0   66     0   12   209 262                 471
932728 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2016   grade_9 241 17 21 0   41     0   24   154 190                       344 241 17 21 0   41     0   24   154 190                 344
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
932742 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2016   grade_9 143 3 12 0   14     0   4   84 92                       176 143 3 12 0   14     0   4   84 92                 176
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
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
932784 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2016   grade_9 300 23 54 1   17     1   18   228 186                       414 300 23 54 1   17     1   18   228 186                 414
932805 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   grade_9 170 6 7 0   12     0   5   101 99                       200 170 6 7 0   12     0   5   101 99                 200
932820 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_9 23 21 4 0   2     0   1   29 22                       51 23 21 4 0   2     0   1   29 22                 51
932847 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_9 284 30 28 3   16     2   21   186 198                       384 284 30 28 3   16     2   21   186 198                 384
932862 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2016   grade_9 152 18 14 1   19     2   16   115 107                       222 152 18 14 1   19     2   16   115 107                 222
932876 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2016   grade_9 167 7 11 0   3     0   4   104 88                       192 167 7 11 0   3     0   4   104 88                 192
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
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
932929 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2016   grade_9 211 17 9 0   52     0   11   138 162                       300 211 17 9 0   52     0   11   138 162                 300
940911 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2016   grade_9 120 5 6 0   1     0   4   67 69                       136 120 5 6 0   1     0   4   67 69                 136
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
932984 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2016   grade_9 234 14 30 0   8     2   7   132 163                       295 234 14 30 0   8     2   7   132 163                 295
933032 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2016   grade_9 254 3 11 1   15     1   9   145 149                       294 254 3 11 1   15     1   9   145 149                 294
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
940939 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No 3 09 12 2016   grade_9 109 2 7 0   2     0   2   60 62                       122 109 2 7 0   2     0   2   60 62                 122
941856 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 132 53 28 3   2     0   9   127 100                       227 132 53 28 3   2     0   9   127 100                 227
933740 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2016   grade_9 218 30 40 0   117     0   15   187 233                       420 218 30 40 0   117     0   15   187 233                 420
933720 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2016   grade_9 81 69 84 3   71     0   7   126 189                       315 81 69 84 3   71     0   7   126 189                 315
933754 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2016   grade_9 33 96 91 2   69     1   6   136 162                       298 33 96 91 2   69     1   6   136 162                 298
933661 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2016   grade_9 6 88 116 1   3     0   5   139 80                       219 6 88 116 1   3     0   5   139 80                 219
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
933670 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2016   grade_9 17 89 147 0   33     0   2   182 106                       288 17 89 147 0   33     0   2   182 106                 288
933797 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No 3 09 12 2016   grade_9 8 47 79 0   9     2   1   77 69                       146 8 47 79 0   9     2   1   77 69                 146
933150 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 11 2016   grade_9 0 32 11 0   0     0   1   24 20                       44 0 32 11 0   0     0   1   24 20                 44
933688 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_9 56 28 369 2   4     0   6   272 193                       465 56 28 369 2   4     0   6   272 193                 465
933684 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2016   grade_9 4 84 41 0   1     0   2   75 57                       132 4 84 41 0   1     0   2   75 57                 132
933697 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   grade_9 3 83 119 0   2     0   6   113 100                       213 3 83 119 0   2     0   6   113 100                 213
933693 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No 3 09 12 2016   grade_9 5 69 117 0   5     0   3   132 67                       199 5 69 117 0   5     0   3   132 67                 199
933547 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_9 5 19 14 0   0     0   0   29 9                       38 5 19 14 0   0     0   0   29 9                 38
933702 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2016   grade_9 7 27 62 0   4     1   0   49 52                       101 7 27 62 0   4     1   0   49 52                 101
933706 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2016   grade_9 8 16 25 0   4     0   1   31 23                       54 8 16 25 0   4     0   1   31 23                 54
933710 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2016   grade_9 1 48 29 0   2     0   0   33 47                       80 1 48 29 0   2     0   0   33 47                 80
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
933647 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_9 8 32 22 1   7     0   1   46 25                       71 8 32 22 1   7     0   1   46 25                 71
933724 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2016   grade_9 14 49 45 0   8     0   5   47 74                       121 14 49 45 0   8     0   5   47 74                 121

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