Data source: Big Local News · About: Big Local

394 rows where grade = "grade_12", state = "MA" and year = 2020 sorted by school_nces_id

View and edit SQL

year

  • 2020 · 394

grade

  • grade_12 · 394
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
1373824 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2020   grade_12 134 2 4 0   3     0   4   67 80 *                     147.0 134 2 4 0   3     0   4   67 80                 147
1373899 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2020   grade_12 44 3 8 1   2     0   1   34 25 *                     59.0 44 3 8 1   2     0   1   34 25                 59
1373878 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_12 110 1 1 0   1     0   0   62 51 *                     113.0 110 1 1 0   1     0   0   62 51                 113
1372475 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 High 05 12 2020   grade_12 4 22 12 0   1     0   1   20 20 *                     40.0 4 22 12 0   1     0   1   20 20                 40
1372587 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_12 64 6 5 0   6     0   6   38 49 *                     87.0 64 6 5 0   6     0   6   38 49                 87
1372598 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 High 09 12 2020   grade_12 2 34 11 0   0     0   1   27 21 *                     48.0 2 34 11 0   0     0   1   27 21                 48
1372645 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_12 20 28 31 0   5     0   8   48 44 *                     92.0 20 28 31 0   5     0   8   48 44                 92
1372756 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes High 09 12 2020   grade_12 7 1 9 0   9     0   0   15 11 *                     26.0 7 1 9 0   9     0   0   15 11                 26
1372782 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_12 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1372784 MA Worcester   school 2500036 468   Ma Academy for Math and Science 250003600576 4680505 Ma Academy for Math and Science School   Regular School No High 11 12 2020   grade_12 18 2 1 0   25     0   2   28 20 *                     48.0 18 2 1 0   25     0   2   28 20                 48
1372823 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2020   grade_12 49 0 2 0   0     0   3   30 24 *                     54.0 49 0 2 0   0     0   3   30 24                 54
1372907 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2020   grade_12 35 26 2 0   2     1   3   37 32 *                     69.0 35 26 2 0   2     1   3   37 32                 69
1372924 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_12 41 7 11 1   0     0   0   20 40 *                     60.0 41 7 11 1   0     0   0   20 40                 60
1372829 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2020   grade_12 40 5 12 0   3     0   3   21 41 *                     63.0 40 5 12 0   3     0   3   21 41                 63
1372894 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_12 6 31 14 1   7     0   1   27 33 *                     60.0 6 31 14 1   7     0   1   27 33                 60
1372523 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2020   grade_12 15 111 95 0   4     0   5   122 107 *                     230.0 15 111 95 0   4     0   5   122 107                 230
1372671 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_12 23 35 19 0   5     0   2   38 46 *                     84.0 23 35 19 0   5     0   2   38 46                 84
1372684 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_12 21 29 4 0   6     0   3   27 36 *                     63.0 21 29 4 0   6     0   3   27 36                 63
1372701 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_12 26 18 14 0   1     0   1   25 35 *                     60.0 26 18 14 0   1     0   1   25 35                 60
1372714 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 High 09 12 2020   grade_12 2 39 40 0   1     0   2   30 54 *                     84.0 2 39 40 0   1     0   2   30 54                 84
1372811 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_12 48 12 3 2   14     0   3   32 50 *                     82.0 48 12 3 2   14     0   3   32 50                 82
1372857 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2020   grade_12 63 1 2 0   1     0   0   27 40 *                     67.0 63 1 2 0   1     0   0   27 40                 67
1372911 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_12 166 4 12 0   7     0   2   89 101 *                     191.0 166 4 12 0   7     0   2   89 101                 191
1372865 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_12 0 60 37 0   1     0   1   38 61 *                     99.0 0 60 37 0   1     0   1   38 61                 99
1372798 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_12 3 34 36 0   0     0   2   37 38 *                     75.0 3 34 36 0   0     0   2   37 38                 75
1373518 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2020   grade_12 105 0 4 0   1     0   0   43 67 *                     110.0 105 0 4 0   1     0   0   43 67                 110
1372612 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_12 0 24 10 0   0     0   0   20 14 *                     34.0 0 24 10 0   0     0   0   20 14                 34
1372546 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_12 1 30 23 0   1     0   1   20 36 *                     56.0 1 30 23 0   1     0   1   20 36                 56
1372817 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2020   grade_12 36 3 7 0   0     0   1   21 26 *                     47.0 36 3 7 0   0     0   1   21 26                 47
1372459 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_12 13 10 121 0   2     0   0   68 78 *                     146.0 13 10 121 0   2     0   0   68 78                 146
1372481 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2020   grade_12 29 0 2 1   3     0   1   15 21 *                     36.0 29 0 2 1   3     0   1   15 21                 36
1372488 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2020   grade_12 20 2 2 0   2     0   1   17 10 *                     27.0 20 2 2 0   2     0   1   17 10                 27
1372495 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_12 1 32 17 0   0     0   1   26 25 *                     51.0 1 32 17 0   0     0   1   26 25                 51
1372559 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_12 8 35 65 0   2     0   4   48 66 *                     114.0 8 35 65 0   2     0   4   48 66                 114
1372872 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes High 06 12 2020   grade_12 32 6 24 0   3     0   1   35 31 *                     66.0 32 6 24 0   3     0   1   35 31                 66
1372566 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2020   grade_12 93 5 3 1   23     0   10   78 57 *                     135.0 93 5 3 1   23     0   10   78 57                 135
1372594 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2020   grade_12 0 33 10 1   0     0   3   16 31 *                     47.0 0 33 10 1   0     0   3   16 31                 47
1372934 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes High 09 12 2020   grade_12 1 3 5 0   0     0   0   2 7 *                     9.0 1 3 5 0   0     0   0   2 7                 9
1372968 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_12 7 0 0 0   0     0   1   1 7 *                     8.0 7 0 0 0   0     0   1   1 7                 8
1372947 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2020   grade_12 14 11 10 2   11     0   0   26 22 *                     48.0 14 11 10 2   11     0   0   26 22                 48
1372955 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2020   grade_12 20 1 8 0   0     0   0   14 15 *                     29.0 20 1 8 0   0     0   0   14 15                 29
1372979 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science East   Regular School Yes High 06 12 2020   grade_12 25 12 12 0   0     0   0   27 22 *                     49.0 25 12 12 0   0     0   0   27 22                 49
1372466 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 High 06 12 2020   grade_12 11 27 27 0   3     0   3   30 41 *                     71.0 11 27 27 0   3     0   3   30 41                 71
1373843 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2020   grade_12 238 5 14 0   7     1   2   143 124 *                     267.0 238 5 14 0   7     1   2   143 124                 267
1373113 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2020   grade_12 76 7 10 1   2     0   6   49 53 *                     102.0 76 7 10 1   2     0   6   49 53                 102
1373570 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2020   grade_12 103 9 3 2   3     0   4   65 59 *                     124.0 103 9 3 2   3     0   4   65 59                 124
1374225 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 High 07 12 2020   grade_12 10 20 6 0   9     0   0   20 25 *                     45.0 10 20 6 0   9     0   0   20 25                 45
1374188 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2020   grade_12 1 2 52 0   0     0   1   20 36 *                     56.0 1 2 52 0   0     0   1   20 36                 56
1374209 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 High 09 12 2020   grade_12 0 43 11 0   0     0   1   24 31 *                     55.0 0 43 11 0   0     0   1   24 31                 55
1374195 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_12 5 18 29 0   1     0   1   27 27 *                     54.0 5 18 29 0   1     0   1   27 27                 54
1374292 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_12 47 3 8 0   0     0   6   25 39 *                     64.0 47 3 8 0   0     0   6   25 39                 64
1374229 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 High 09 12 2020   grade_12 10 6 14 0   0     0   0   13 17 *                     30.0 10 6 14 0   0     0   0   13 17                 30
1374095 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School   Career and Technical School No High 09 12 2020   grade_12 268 3 43 1   5     0   13   150 183 *                     333.0 268 3 43 1   5     0   13   150 183                 333
1374233 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 High 09 12 2020   grade_12 0 4 7 0   0     0   0   4 7 *                     11.0 0 4 7 0   0     0   0   4 7                 11
1374305 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_12 205 8 39 0   12     1   12   91 186 *                     277.0 205 8 39 0   12     1   12   91 186                 277
1374275 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2020   grade_12 20 2 4 0   0     0   1   14 13 *                     27.0 20 2 4 0   0     0   1   14 13                 27
1374279 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2020   grade_12 2 0 10 0   0     0   0   5 7 *                     12.0 2 0 10 0   0     0   0   5 7                 12
1364797 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_12 102 3 6 0   4     0   2   55 62 *                     117.0 102 3 6 0   4     0   2   55 62                 117
1373028 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2020   grade_12 259 10 18 2   141     0   19   227 222 *                     449.0 259 10 18 2   141     0   19   227 222                 449
1373043 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2020   grade_12 63 7 1 0   0     0   0   37 34 *                     71.0 63 7 1 0   0     0   0   37 34                 71
1364837 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_12 238 3 14 0   8     0   2   135 130 *                     265.0 238 3 14 0   8     0   2   135 130                 265
1364857 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_12 132 0 6 0   2     0   2   71 71 *                     142.0 132 0 6 0   2     0   2   71 71                 142
1364862 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_12 15 2 1 0   0     0   1   8 11 *                     19.0 15 2 1 0   0     0   1   8 11                 19
1373049 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2020   grade_12 132 17 40 1   21     0   20   120 109 *                     231.0 132 17 40 1   21     0   20   120 109                 231
1364928 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_12 314 10 23 0   67     0   10   210 214 *                     424.0 314 10 23 0   67     0   10   210 214                 424
1364979 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_12 260 13 22 0   33     1   8   182 153 *                     337.0 260 13 22 0   33     1   8   182 153                 337
1373070 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2020   grade_12 160 1 2 0   3     0   2   81 87 *                     168.0 160 1 2 0   3     0   2   81 87                 168
1364993 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_12 146 7 28 1   31     0   2   100 115 *                     215.0 146 7 28 1   31     0   2   100 115                 215
1374075 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2020   grade_12 222 1 34 1   2     0   6   165 101 0                     266.0 222 1 34 1   2     0   6   165 101 0               266
1373092 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2020   grade_12 71 3 4 0   0     0   2   41 39 *                     80.0 71 3 4 0   0     0   2   41 39                 80
1365035 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_12 281 20 65 2   13     0   15   203 193 *                     396.0 281 20 65 2   13     0   15   203 193                 396
1365038 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2020   grade_12 21 2 3 0   0     0   3   16 13 *                     29.0 21 2 3 0   0     0   3   16 13                 29
1365056 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_12 141 3 20 1   10     0   8   91 92 *                     183.0 141 3 20 1   10     0   8   91 92                 183
1365070 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_12 18 18 3 0   4     0   4   19 28 *                     47.0 18 18 3 0   4     0   4   19 28                 47
1365100 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_12 246 29 52 1   10     0   13   159 192 *                     351.0 246 29 52 1   10     0   13   159 192                 351
1365115 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2020   grade_12 133 11 17 0   25     1   7   96 98 *                     194.0 133 11 17 0   25     1   7   96 98                 194
1365129 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2020   grade_12 155 2 9 0   2     0   1   90 79 *                     169.0 155 2 9 0   2     0   1   90 79                 169
1365148 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2020   grade_12 127 1 9 1   5     0   3   69 77 *                     146.0 127 1 9 1   5     0   3   69 77                 146
1365153 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_12 6 0 2 0   0     0   1   4 4 *                     9.0 6 0 2 0   0     0   1   4 4                 9
1365182 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2020   grade_12 238 12 15 0   53     0   13   156 175 *                     331.0 238 12 15 0   53     0   13   156 175                 331
1373127 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2020   grade_12 96 1 11 0   1     0   3   66 46 *                     112.0 96 1 11 0   1     0   3   66 46                 112
1373149 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2020   grade_12 69 3 3 0   1     0   0   45 31 *                     76.0 69 3 3 0   1     0   0   45 31                 76
1365226 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2020   grade_12 227 6 40 0   7     0   7   149 137 *                     287.0 227 6 40 0   7     0   7   149 137                 287
1365264 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 08 12 2020   grade_12 278 11 17 0   20     0   7   165 168 *                     333.0 278 11 17 0   20     0   7   165 168                 333
1374079 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2020   grade_12 283 2 11 0   1     0   5   149 152 *                     302.0 283 2 11 0   1     0   5   149 152                 302
1373169 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2020   grade_12 98 0 6 0   0     0   2   55 51 *                     106.0 98 0 6 0   0     0   2   55 51                 106
1374083 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 108 43 27 2   1     1   9   113 78 *                     191.0 108 43 27 2   1     1   9   113 78                 191
1365985 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_12 181 28 48 1   118     0   17   171 221 *                     393.0 181 28 48 1   118     0   17   171 221                 393
1365963 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2020   grade_12 84 41 53 0   67     0   11   109 147 *                     256.0 84 41 53 0   67     0   11   109 147                 256
1365999 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2020   grade_12 17 83 71 1   66     0   7   92 153 *                     245.0 17 83 71 1   66     0   7   92 153                 245
1365902 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2020   grade_12 2 54 77 0   9     0   2   82 62 *                     144.0 2 54 77 0   9     0   2   82 62                 144
1365348 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter School   Regular School No High 07 12 2020   grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1365911 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2020   grade_12 12 67 99 1   19     0   4   121 81 *                     202.0 12 67 99 1   19     0   4   121 81                 202
1366031 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2020   grade_12 1 31 52 0   8     0   1   45 48 *                     93.0 1 31 52 0   8     0   1   45 48                 93
1365391 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_12 0 28 4 0   0     0   3   14 21 *                     35.0 0 28 4 0   0     0   3   14 21                 35
1365928 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2020   grade_12 24 12 189 1   4     0   4   119 115 *                     234.0 24 12 189 1   4     0   4   119 115                 234
1365924 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2020   grade_12 1 87 26 0   0     1   2   63 54 *                     117.0 1 87 26 0   0     1   2   63 54                 117
1365938 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2020   grade_12 1 46 81 1   1     0   4   59 75 *                     134.0 1 46 81 1   1     0   4   59 75                 134
1365933 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2020   grade_12 6 54 76 0   0     1   1   67 70 *                     138.0 6 54 76 0   0     1   1   67 70                 138
1365786 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_12 3 13 11 0   0     0   0   19 8 *                     27.0 3 13 11 0   0     0   0   19 8                 27

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