Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1365888 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_12 5 43 10 0   5     0   2   32 33 *                     65.0 5 43 10 0   5     0   2   32 33                 65
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
1365907 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2020   grade_12 0 40 38 0   1     1   0   30 50 *                     80.0 0 40 38 0   1     1   0   30 50                 80
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
1365916 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2020   grade_12 1 11 3 0   0     0   0   5 10 *                     15.0 1 11 3 0   0     0   0   5 10                 15
1365920 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2020   grade_12 14 51 35 1   21     0   0   74 48 *                     122.0 14 51 35 1   21     0   0   74 48                 122
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
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
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
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
1365943 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2020   grade_12 1 28 55 0   1     0   1   33 53 *                     86.0 1 28 55 0   1     0   1   33 53                 86
1365947 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2020   grade_12 8 24 21 0   0     0   2   24 31 *                     55.0 8 24 21 0   0     0   2   24 31                 55
1365953 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2020   grade_12 2 39 33 0   1     0   2   35 42 *                     77.0 2 39 33 0   1     0   2   35 42                 77
1365957 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2020   grade_12 1 7 11 0   0     0   1   8 12 *                     20.0 1 7 11 0   0     0   1   8 12                 20
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
1365967 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2020   grade_12 9 51 46 0   4     0   2   41 71 *                     112.0 9 51 46 0   4     0   2   41 71                 112
1365969 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2020   grade_12 0 46 32 0   3     0   4   46 39 *                     85.0 0 46 32 0   3     0   4   46 39                 85
1365974 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No High 09 12 2020   grade_12 2 0 64 0   0     0   0   26 40 *                     66.0 2 0 64 0   0     0   0   26 40                 66
1365978 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2020   grade_12 9 31 64 1   5     0   2   66 46 *                     112.0 9 31 64 1   5     0   2   66 46                 112
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
1365992 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2020   grade_12 4 12 14 0   27     0   0   33 24 *                     57.0 4 12 14 0   27     0   0   33 24                 57
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
1366000 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No High 12 12 2020   grade_12 1 20 18 0   0     0   0   22 17 *                     39.0 1 20 18 0   0     0   0   22 17                 39
1366004 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2020   grade_12 2 46 18 0   1     0   3   31 39 *                     70.0 2 46 18 0   1     0   3   31 39                 70
1366008 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No High 09 12 2020   grade_12 6 10 10 0   4     0   1   17 14 *                     31.0 6 10 10 0   4     0   1   17 14                 31
1366026 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_12 2 103 24 1   5     0   2   70 67 *                     137.0 2 103 24 1   5     0   2   70 67                 137
1366027 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No High 12 12 2020   grade_12 2 16 9 0   0     0   1   14 14 *                     28.0 2 16 9 0   0     0   1   14 14                 28
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
1366052 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_12 0 4 5 0   1     0   0   7 3 *                     10.0 0 4 5 0   1     0   0   7 3                 10
1366056 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2020   grade_12 16 36 57 0   2     0   4   63 52 *                     115.0 16 36 57 0   2     0   4   63 52                 115
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
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
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
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
1366070 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_12 103 2 7 0   7     1   4   52 72 *                     124.0 103 2 7 0   7     1   4   52 72                 124
1366126 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2020   grade_12 315 19 22 0   67     0   3   208 218 *                     426.0 315 19 22 0   67     0   3   208 218                 426
1373192 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_12 * * * *   *     *   *   3 * *                     4.0                         3                   4
1373196 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2020   grade_12 320 17 1 0   11     0   11   179 181 *                     360.0 320 17 1 0   11     0   11   179 181                 360
1374180 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2020   grade_12 105 0 2 0   0     0   0   34 72 *                     107.0 105 0 2 0   0     0   0   34 72                 107
1374087 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 243 7 16 2   1     0   12   160 120 *                     281.0 243 7 16 2   1     0   12   160 120                 281
1366224 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_12 4 3 1 1   0     0   0   7 2 *                     9.0 4 3 1 1   0     0   0   7 2                 9
1366244 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_12 138 598 111 5   28     0   29   473 436 *                     909.0 138 598 111 5   28     0   29   473 436                 909
1366249 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2020   grade_12 3 3 4 0   0     0   0   6 4 *                     10.0 3 3 4 0   0     0   0   6 4                 10
1366254 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No High 09 12 2020   grade_12 8 70 12 0   0     0   3   60 33 *                     93.0 8 70 12 0   0     0   3   60 33                 93
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
1366345 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_12 254 39 48 0   87     0   46   250 221 3                     474.0 254 39 48 0   87     0   46   250 221 3               474
1366379 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2020   grade_12 169 13 15 2   42     0   7   131 117 *                     248.0 169 13 15 2   42     0   7   131 117                 248
1366482 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_12 189 140 69 3   61     1   31   249 245 *                     494.0 189 140 69 3   61     1   31   249 245                 494
1366509 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2020   grade_12 164 31 13 0   24     0   11   123 117 *                     243.0 164 31 13 0   24     0   11   123 117                 243
1374091 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 108 11 17 2   2     0   8   93 55 *                     148.0 108 11 17 2   2     0   8   93 55                 148
1366534 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_12 99 2 0 0   0     0   0   48 53 *                     101.0 99 2 0 0   0     0   0   48 53                 101
1373231 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2020   grade_12 113 1 4 0   0     0   0   66 52 *                     118.0 113 1 4 0   0     0   0   66 52                 118
1366568 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2020   grade_12 281 12 11 0   53     1   6   170 194 *                     364.0 281 12 11 0   53     1   6   170 194                 364
1366605 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_12 15 15 228 0   2     1   7   128 140 *                     268.0 15 15 228 0   2     1   7   128 140                 268
1366609 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2020   grade_12 0 1 30 0   0     0   0   16 15 *                     31.0 0 1 30 0   0     0   0   16 15                 31
1366637 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_12 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1366677 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2020   grade_12 107 6 95 0   9     0   2   120 99 *                     219.0 107 6 95 0   9     0   2   120 99                 219
1366681 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2020   grade_12 193 7 81 1   6     0   8   158 138 *                     296.0 193 7 81 1   6     0   8   158 138                 296
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
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

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