Data source: Big Local News · About: Big Local

396 rows where grade = "grade_12", state = "MA" and year = 2019 sorted by district

View and edit SQL

year

  • 2019 · 396

grade

  • grade_12 · 396
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
2047742 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 2019   grade_12 23 35 16 0   5     1   3   48 35                       83.0 23 35 16 0   5     1   3   48 35                 83
2039823 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_12 90 4 9 0   3     1   0   48 59                       107.0 90 4 9 0   3     1   0   48 59                 107
2047548 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 2019   grade_12 2 21 10 0   1     1   3   19 19                       38.0 2 21 10 0   1     1   3   19 19                 38
2048100 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_12 294 9 21 0   159     0   17   271 229                       500.0 294 9 21 0   159     0   17   271 229                 500
2048115 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_12 76 3 4 1   3     0   0   42 45                       87.0 76 3 4 1   3     0   0   42 45                 87
2047639 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 2019   grade_12 82 4 3 1   20     0   9   50 69                       119.0 82 4 3 1   20     0   9   50 69                 119
2039863 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_12 243 4 18 0   8     0   4   145 132                       277.0 243 4 18 0   8     0   4   145 132                 277
2039884 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_12 114 3 11 0   3     0   7   76 62                       138.0 114 3 11 0   3     0   7   76 62                 138
2039889 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_12 13 1 1 0   0     0   0   11 4                       15.0 13 1 1 0   0     0   0   11 4                 15
2048122 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   grade_12 128 16 40 0   20     0   21   119 105                       225.0 128 16 40 0   20     0   21   119 105                 225
2039955 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_12 338 11 19 0   66     0   11   195 250                       445.0 338 11 19 0   66     0   11   195 250                 445
2040006 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_12 245 13 21 0   46     0   19   156 188                       344.0 245 13 21 0   46     0   19   156 188                 344
2048143 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2019   grade_12 150 0 2 0   3     0   4   74 85                       159.0 150 0 2 0   3     0   4   74 85                 159
2040020 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_12 142 4 15 0   21     0   2   84 100                       184.0 142 4 15 0   21     0   2   84 100                 184
2049149 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 2019   grade_12 224 0 40 0   0     0   9   155 118                       273.0 224 0 40 0   0     0   9   155 118                 273
2048165 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2019   grade_12 64 2 7 0   1     0   1   41 34                       75.0 64 2 7 0   1     0   1   41 34                 75
2047996 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_12 46 4 10 0   3     0   2   28 37                       65.0 46 4 10 0   3     0   2   28 37                 65
2040062 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_12 276 26 46 1   19     1   17   201 185                       386.0 276 26 46 1   19     1   17   201 185                 386
2040066 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 10 12 2019   grade_12 21 5 7 0   0     0   0   19 14                       33.0 21 5 7 0   0     0   0   19 14                 33
2040084 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_12 160 6 7 0   11     0   5   90 99                       189.0 160 6 7 0   11     0   5   90 99                 189
2040099 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_12 20 24 3 0   3     0   1   27 24                       51.0 20 24 3 0   3     0   1   27 24                 51
2048187 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2019   grade_12 72 6 8 2   4     0   11   48 55                       103.0 72 6 8 2   4     0   11   48 55                 103
2040126 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_12 269 26 36 2   12     4   13   174 188                       362.0 269 26 36 2   12     4   13   174 188                 362
2049271 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_12 1 11 38 0   0     0   0   22 28                       50.0 1 11 38 0   0     0   0   22 28                 50
2040141 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_12 137 16 17 0   17     1   15   112 91                       203.0 137 16 17 0   17     1   15   112 91                 203
2040155 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_12 157 6 7 0   3     0   3   98 78                       176.0 157 6 7 0   3     0   3   98 78                 176
2040174 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_12 129 2 6 0   4     0   1   82 60                       142.0 129 2 6 0   4     0   1   82 60                 142
2040179 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_12 8 0 1 0   0     0   0   5 3                       9.0 8 0 1 0   0     0   0   5 3                 9
2040208 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2019   grade_12 208 17 11 0   59     0   9   148 156                       304.0 208 17 11 0   59     0   9   148 156                 304
2047561 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 2019   grade_12 22 6 1 0   1     0   1   16 15                       31.0 22 6 1 0   1     0   1   16 15                 31
2048201 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2019   grade_12 123 4 6 0   1     0   7   74 67                       141.0 123 4 6 0   1     0   7   74 67                 141
2048209 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2019   grade_12 73 2 1 0   1     0   4   35 46                       81.0 73 2 1 0   1     0   4   35 46                 81
2040259 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2019   grade_12 220 15 28 0   8     2   5   129 148                       278.0 220 15 28 0   8     2   5   129 148                 278
2040307 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   grade_12 218 7 12 2   13     1   7   131 129                       260.0 218 7 12 2   13     1   7   131 129                 260
2049153 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2019   grade_12 282 1 6 0   9     0   4   158 144                       302.0 282 1 6 0   9     0   4   158 144                 302
2048229 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2019   grade_12 95 0 7 0   2     0   1   51 54                       105.0 95 0 7 0   2     0   1   51 54                 105
2049157 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 2019   grade_12 121 53 26 2   2     0   5   119 90                       209.0 121 53 26 2   2     0   5   119 90                 209
2040391 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_12 1 2 2 0   2     0   0   4 3                       7.0 1 2 2 0   2     0   0   4 3                 7
2040434 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_12 0 22 11 0   0     0   0   17 16                       33.0 0 22 11 0   0     0   0   17 16                 33
2040829 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_12 5 16 4 0   0     0   1   19 7                       26.0 5 16 4 0   0     0   1   19 7                 26
2040932 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_12 5 27 20 1   5     0   0   38 20                       58.0 5 27 20 1   5     0   0   38 20                 58
2040946 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2019   grade_12 10 71 100 0   8     0   2   111 80                       191.0 10 71 100 0   8     0   2   111 80                 191
2040951 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2019   grade_12 3 30 37 0   2     0   1   38 35                       73.0 3 30 37 0   2     0   1   38 35                 73
2040955 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_12 4 64 108 0   37     0   1   129 84                       214.0 4 64 108 0   37     0   1   129 84                 214
2040960 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_12 1 4 2 0   0     0   0   5 2                       7.0 1 4 2 0   0     0   0   5 2                 7
2040964 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2019   grade_12 11 43 36 1   29     0   1   64 57                       121.0 11 43 36 1   29     0   1   64 57                 121
2040968 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_12 1 99 18 0   1     0   1   64 56                       120.0 1 99 18 0   1     0   1   64 56                 120
2040972 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2019   grade_12 41 21 278 2   5     0   4   184 167                       351.0 41 21 278 2   5     0   4   184 167                 351
2040977 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2019   grade_12 2 49 79 0   4     0   1   74 61                       135.0 2 49 79 0   4     0   1   74 61                 135
2040981 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_12 2 57 85 0   1     1   4   81 69                       150.0 2 57 85 0   1     1   4   81 69                 150
2040986 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2019   grade_12 7 22 49 0   5     1   0   43 41                       84.0 7 22 49 0   5     1   0   43 41                 84
2040991 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2019   grade_12 6 25 23 0   2     0   1   29 28                       57.0 6 25 23 0   2     0   1   29 28                 57
2040997 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_12 1 53 30 0   1     0   0   37 48                       85.0 1 53 30 0   1     0   0   37 48                 85
2041002 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2019   grade_12 2 9 22 0   0     0   2   20 15                       35.0 2 9 22 0   0     0   2   20 15                 35
2041008 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_12 63 56 71 3   67     0   6   110 156                       266.0 63 56 71 3   67     0   6   110 156                 266
2041012 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2019   grade_12 13 49 43 0   7     0   5   46 71                       117.0 13 49 43 0   7     0   5   46 71                 117
2041014 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2019   grade_12 1 20 15 0   3     0   0   21 18                       39.0 1 20 15 0   3     0   0   21 18                 39
2041018 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No High 09 12 2019   grade_12 1 1 60 0   0     0   0   23 39                       62.0 1 1 60 0   0     0   0   23 39                 62
2041022 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2019   grade_12 5 44 53 0   5     0   4   51 60                       111.0 5 44 53 0   5     0   4   51 60                 111
2041029 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_12 207 26 32 0   105     0   13   175 208                       383.0 207 26 32 0   105     0   13   175 208                 383
2041036 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   grade_12 2 14 10 0   31     0   2   37 22                       59.0 2 14 10 0   31     0   2   37 22                 59
2041043 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2019   grade_12 25 82 80 1   60     1   5   116 138                       254.0 25 82 80 1   60     1   5   116 138                 254
2041047 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No High 09 12 2019   grade_12 4 50 38 0   1     0   3   56 40                       96.0 4 50 38 0   1     0   3   56 40                 96
2041052 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2019   grade_12 1 58 20 0   0     0   1   33 47                       80.0 1 58 20 0   0     0   1   33 47                 80
2041057 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No High 09 12 2019   grade_12 12 5 14 1   5     0   2   22 17                       39.0 12 5 14 1   5     0   2   22 17                 39
2041074 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_12 1 101 22 0   8     0   2   73 61                       134.0 1 101 22 0   8     0   2   73 61                 134
2041079 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No High 09 12 2019   grade_12 11 76 59 1   4     1   2   89 65                       154.0 11 76 59 1   4     1   2   89 65                 154
2041084 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2019   grade_12 4 31 53 0   6     2   2   35 63                       98.0 4 31 53 0   6     2   2   35 63                 98
2041105 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_12 0 4 6 0   1     0   0   5 6                       11.0 0 4 6 0   1     0   0   5 6                 11
2041109 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2019   grade_12 12 44 30 1   4     0   0   43 48                       91.0 12 44 30 1   4     0   0   43 48                 91
2047772 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_12 42 16 12 0   3     0   0   27 46                       73.0 42 16 12 0   3     0   0   27 46                 73
2047595 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 2019   grade_12 16 118 107 0   3     0   10   127 126                       254.0 16 118 107 0   3     0   10   127 126                 254
2047539 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 2019   grade_12 3 27 19 0   3     0   0   24 28                       52.0 3 27 19 0   3     0   0   24 28                 52
2047568 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_12 2 43 11 0   3     0   1   34 26                       60.0 2 43 11 0   3     0   1   34 26                 60
2041129 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2019   grade_12 100 3 6 1   0     0   2   55 57                       112.0 100 3 6 1   0     0   2   55 57                 112
2041192 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   grade_12 271 30 22 0   60     0   2   197 188                       385.0 271 30 22 0   60     0   2   197 188                 385
2048253 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_12 6 1 0 0   0     0   0   5 2                       7.0 6 1 0 0   0     0   0   5 2                 7
2048257 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2019   grade_12 351 12 0 0   7     2   22   198 196                       394.0 351 12 0 0   7     2   22   198 196                 394
2049256 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2019   grade_12 108 0 3 0   0     0   0   22 89                       111.0 108 0 3 0   0     0   0   22 89                 111
2049161 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2019   grade_12 246 11 21 2   2     0   10   172 119                       292.0 246 11 21 2   2     0   10   172 119                 292
2041293 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_12 7 2 0 0   0     0   1   7 3                       10.0 7 2 0 0   0     0   1   7 3                 10
2041314 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_12 201 593 108 2   22     1   37   450 514                       964.0 201 593 108 2   22     1   37   450 514                 964
2041319 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_12 5 3 3 0   1     0   2   7 7                       14.0 5 3 3 0   1     0   2   7 7                 14
2041324 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No High 09 12 2019   grade_12 8 83 7 0   2     0   5   55 50                       105.0 8 83 7 0   2     0   5   55 50                 105
2041415 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_12 292 33 59 0   81     1   33   243 255                       499.0 292 33 59 0   81     1   33   243 255                 499
2041449 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   grade_12 180 10 16 1   35     0   8   113 137                       250.0 180 10 16 1   35     0   8   113 137                 250
2041552 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_12 183 156 68 2   60     1   23   249 244                       493.0 183 156 68 2   60     1   23   249 244                 493
2041579 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2019   grade_12 164 15 7 0   25     0   13   108 116                       224.0 164 15 7 0   25     0   13   108 116                 224
2049165 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 2019   grade_12 83 7 13 5   1     1   6   73 43                       116.0 83 7 13 5   1     1   6   73 43                 116
2041604 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_12 80 1 0 0   0     0   1   44 38                       82.0 80 1 0 0   0     0   1   44 38                 82
2048292 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2019   grade_12 133 2 6 0   3     0   4   70 78                       148.0 133 2 6 0   3     0   4   70 78                 148
2041638 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2019   grade_12 272 16 15 0   39     0   9   186 165                       351.0 272 16 15 0   39     0   9   186 165                 351
2041674 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2019   grade_12 16 18 255 0   4     0   2   136 159                       295.0 16 18 255 0   4     0   2   136 159                 295
2041679 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_12 0 0 6 0   0     0   0   5 1                       6.0 0 0 6 0   0     0   0   5 1                 6
2041706 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_12 2 0 7 0   0     0   1   7 3                       10.0 2 0 7 0   0     0   1   7 3                 10
2041747 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2019   grade_12 106 14 72 0   9     0   3   103 101                       204.0 106 14 72 0   9     0   3   103 101                 204
2041751 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2019   grade_12 227 8 88 0   11     0   6   180 160                       340.0 227 8 88 0   11     0   6   180 160                 340
2047670 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 2019   grade_12 1 34 4 0   0     0   0   16 23                       39.0 1 34 4 0   0     0   0   16 23                 39
2049284 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 2019   grade_12 1 43 12 0   3     0   0   25 34                       59.0 1 43 12 0   3     0   0   25 34                 59
2049304 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 2019   grade_12 14 4 11 0   0     0   1   13 17                       30.0 14 4 11 0   0     0   1   13 17                 30

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