Data source: Big Local News · About: Big Local

396 rows where grade = "grade_10", state = "MA" and year = 2017 sorted by district

View and edit SQL

year

  • 2017 · 396

grade

  • grade_10 · 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
1131336 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 2017   grade_10 24 36 17 0   5     1   3   51 35                       86 24 36 17 0   5     1   3   51 35                 86
1121961 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_10 91 4 10 0   3     1   0   50 59                       109 91 4 10 0   3     1   0   50 59                 109
1131130 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 Other 05 12 2017   grade_10 6 29 14 0   1     1   4   29 26                       55 6 29 14 0   1     1   4   29 26                 55
1131738 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_10 297 7 18 0   153     0   17   258 234                       492 297 7 18 0   153     0   17   258 234                 492
1131761 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_10 80 7 3 1   3     0   0   43 51                       94 80 7 3 1   3     0   0   43 51                 94
1131226 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_10 86 4 2 1   22     0   11   55 71                       126 86 4 2 1   22     0   11   55 71                 126
1122012 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_10 270 6 20 0   7     0   6   164 145                       309 270 6 20 0   7     0   6   164 145                 309
1122036 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_10 119 3 8 0   2     0   6   77 61                       138 119 3 8 0   2     0   6   77 61                 138
1122041 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_10 * * * *   *     *   *   1 1                       *                         1 1                  
1131769 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2017   grade_10 134 12 37 0   21     0   16   115 105                       220 134 12 37 0   21     0   16   115 105                 220
1122120 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2017   grade_10 352 9 18 0   69     0   11   204 255                       459 352 9 18 0   69     0   11   204 255                 459
1122180 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_10 244 16 26 0   42     0   22   157 193                       350 244 16 26 0   42     0   22   157 193                 350
1131794 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2017   grade_10 151 0 2 0   2     0   4   74 85                       159 151 0 2 0   2     0   4   74 85                 159
1122199 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2017   grade_10 139 3 12 0   16     0   2   80 92                       172 139 3 12 0   16     0   2   80 92                 172
1132973 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 2017   grade_10 223 0 41 0   1     0   8   154 119                       273 223 0 41 0   1     0   8   154 119                 273
1131819 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2017   grade_10 68 1 5 0   0     0   2   41 35                       76 68 1 5 0   0     0   2   41 35                 76
1131623 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_10 54 4 13 0   3     0   2   31 45                       76 54 4 13 0   3     0   2   31 45                 76
1122251 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2017   grade_10 285 26 51 1   19     1   18   220 181                       401 285 26 51 1   19     1   18   220 181                 401
1122255 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2017   grade_10 11 0 3 0   0     0   0   5 9                       14 11 0 3 0   0     0   0   5 9                 14
1122277 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_10 168 5 8 0   11     0   5   97 100                       197 168 5 8 0   11     0   5   97 100                 197
1122293 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_10 21 21 3 0   2     0   2   25 24                       49 21 21 3 0   2     0   2   25 24                 49
1131844 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2017   grade_10 87 6 12 0   3     0   11   60 59                       119 87 6 12 0   3     0   11   60 59                 119
1122327 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_10 273 28 34 5   12     3   17   175 197                       372 273 28 34 5   12     3   17   175 197                 372
1133121 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_10 3 17 49 0   0     0   0   32 37                       69 3 17 49 0   0     0   0   32 37                 69
1122345 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   grade_10 142 18 13 0   17     2   14   106 100                       206 142 18 13 0   17     2   14   106 100                 206
1122364 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2017   grade_10 164 5 11 0   3     0   2   102 83                       185 164 5 11 0   3     0   2   102 83                 185
1122387 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2017   grade_10 131 1 5 0   4     0   1   81 61                       142 131 1 5 0   4     0   1   81 61                 142
1122392 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   grade_10 7 0 2 0   0     0   1   6 3                       10 7 0 2 0   0     0   1   6 3                 10
1122426 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2017   grade_10 211 18 10 0   62     0   11   145 167                       312 211 18 10 0   62     0   11   145 167                 312
1131145 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_10 34 9 6 0   1     0   3   26 27                       53 34 9 6 0   1     0   3   26 27                 53
1131861 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2017   grade_10 126 5 6 0   1     0   4   74 68                       142 126 5 6 0   1     0   4   74 68                 142
1131869 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No Other 06 12 2017   grade_10 72 1 1 0   0     0   3   30 47                       77 72 1 1 0   0     0   3   30 47                 77
1122492 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2017   grade_10 235 14 35 0   7     2   8   138 163                       301 235 14 35 0   7     2   8   138 163                 301
1122548 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2017   grade_10 228 7 13 1   15     1   9   135 139                       274 228 7 13 1   15     1   9   135 139                 274
1132978 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2017   grade_10 288 1 6 0   8     0   5   160 148                       308 288 1 6 0   8     0   5   160 148                 308
1131894 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2017   grade_10 110 1 6 0   2     0   0   57 62                       119 110 1 6 0   2     0   0   57 62                 119
1132983 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 2017   grade_10 122 56 30 2   2     0   8   123 97                       220 122 56 30 2   2     0   8   123 97                 220
1122640 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_10 * * * *   *     *   *   3 2                       *                         3 2                  
1122689 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_10 0 28 11 0   0     0   0   20 19                       39 0 28 11 0   0     0   0   20 19                 39
1123141 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_10 7 23 10 0   0     0   1   26 15                       41 7 23 10 0   0     0   1   26 15                 41
1123254 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_10 5 28 20 1   6     0   0   38 22                       60 5 28 20 1   6     0   0   38 22                 60
1123271 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   grade_10 7 83 94 1   1     0   3   114 75                       189 7 83 94 1   1     0   3   114 75                 189
1123276 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2017   grade_10 4 34 41 0   2     2   0   43 40                       83 4 34 41 0   2     2   0   43 40                 83
1123281 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2017   grade_10 7 52 93 0   34     0   2   117 71                       188 7 52 93 0   34     0   2   117 71                 188
1123286 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2017   grade_10 1 8 3 0   0     0   1   10 *                       13 1 8 3 0   0     0   1   10                   13
1123291 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No High 09 12 2017   grade_10 10 43 42 0   22     1   2   74 46                       120 10 43 42 0   22     1   2   74 46                 120
1123296 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2017   grade_10 3 72 33 0   0     0   1   53 56                       109 3 72 33 0   0     0   1   53 56                 109
1123301 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_10 52 25 306 2   4     0   4   201 192                       393 52 25 306 2   4     0   4   201 192                 393
1123306 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2017   grade_10 2 41 63 0   1     0   0   68 39                       107 2 41 63 0   1     0   0   68 39                 107
1123311 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2017   grade_10 3 92 129 0   2     0   8   127 107                       234 3 92 129 0   2     0   8   127 107                 234
1123316 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2017   grade_10 7 26 56 0   6     1   0   47 49                       96 7 26 56 0   6     1   0   47 49                 96
1123321 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2017   grade_10 4 24 25 0   1     0   1   35 20                       55 4 24 25 0   1     0   1   35 20                 55
1123326 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 09 12 2017   grade_10 1 46 28 0   1     0   0   32 44                       76 1 46 28 0   1     0   0   32 44                 76
1123331 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2017   grade_10 1 2 14 1   0     0   0   14 4                       18 1 2 14 1   0     0   0   14 4                 18
1123338 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_10 73 66 77 3   67     0   7   115 178                       293 73 66 77 3   67     0   7   115 178                 293
1123343 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2017   grade_10 15 51 47 0   7     0   5   49 76                       125 15 51 47 0   7     0   5   49 76                 125
1123351 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No High 09 12 2017   grade_10 1 2 71 0   0     0   0   33 41                       74 1 2 71 0   0     0   0   33 41                 74
1123356 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2017   grade_10 6 48 67 1   6     0   4   67 65                       132 6 48 67 1   6     0   4   67 65                 132
1123363 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2017   grade_10 212 30 38 0   112     0   15   186 221                       407 212 30 38 0   112     0   15   186 221                 407
1123371 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_10 1 14 10 0   30     0   1   34 22                       56 1 14 10 0   30     0   1   34 22                 56
1123378 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_10 29 106 92 2   67     1   5   142 160                       302 29 106 92 2   67     1   5   142 160                 302
1123383 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No High 09 12 2017   grade_10 10 45 41 0   1     0   2   58 41                       99 10 45 41 0   1     0   2   58 41                 99
1123388 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2017   grade_10 2 56 15 0   1     0   2   40 36                       76 2 56 15 0   1     0   2   40 36                 76
1123393 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No High 09 12 2017   grade_10 3 10 5 0   0     0   0   6 12                       18 3 10 5 0   0     0   0   6 12                 18
1123398 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No High 09 12 2017   grade_10 9 4 14 0   5     0   1   14 19                       33 9 4 14 0   5     0   1   14 19                 33
1123417 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_10 5 114 31 1   9     0   2   90 72                       162 5 114 31 1   9     0   2   90 72                 162
1123422 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No High 09 12 2017   grade_10 15 63 49 0   1     1   1   66 64                       130 15 63 49 0   1     1   1   66 64                 130
1123427 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2017   grade_10 5 44 67 0   4     2   3   56 69                       125 5 44 67 0   4     2   3   56 69                 125
1123451 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_10 0 3 6 0   1     0   0   4 6                       10 0 3 6 0   1     0   0   4 6                 10
1123457 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_10 3 9 14 1   0     0   0   10 17                       27 3 9 14 1   0     0   0   10 17                 27
1131369 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_10 44 17 14 0   3     0   0   30 48                       78 44 17 14 0   3     0   0   30 48                 78
1131183 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 2017   grade_10 1 14 15 0   0     0   2   10 22                       32 1 14 15 0   0     0   2   10 22                 32
1131121 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 Other 06 12 2017   grade_10 2 37 25 0   0     0   1   30 35                       65 2 37 25 0   0     0   1   30 35                 65
1131153 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_10 3 50 12 0   1     0   1   35 32                       67 3 50 12 0   1     0   1   35 32                 67
1123480 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2017   grade_10 92 4 6 0   0     0   3   59 46                       105 92 4 6 0   0     0   3   59 46                 105
1123555 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2017   grade_10 276 30 16 0   56     0   2   197 183                       380 276 30 16 0   56     0   2   197 183                 380
1131926 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_10 * * * *   *     *   *   2 *                       *                         2                    
1131930 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2017   grade_10 351 13 12 0   7     0   18   198 203                       401 351 13 12 0   7     0   18   198 203                 401
1133103 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2017   grade_10 112 0 3 0   0     0   4   25 94                       119 112 0 3 0   0     0   4   25 94                 119
1132988 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 274 14 25 2   2     0   11   201 126                       328 274 14 25 2   2     0   11   201 126                 328
1123657 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_10 0 6 2 0   0     0   0   7 1                       8 0 6 2 0   0     0   0   7 1                 8
1123671 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_10 7 3 1 0   0     0   0   7 4                       11 7 3 1 0   0     0   0   7 4                 11
1123700 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_10 218 642 115 4   27     1   41   515 533                       1048 218 642 115 4   27     1   41   515 533                 1048
1123705 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No High 09 12 2017   grade_10 10 18 18 1   1     1   4   31 22                       53 10 18 18 1   1     1   4   31 22                 53
1123709 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No High 09 12 2017   grade_10 5 4 1 0   0     0   0   5 5                       10 5 4 1 0   0     0   0   5 5                 10
1123813 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_10 300 34 58 0   85     1   31   243 266                       509 300 34 58 0   85     1   31   243 266                 509
1123851 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2017   grade_10 186 9 12 1   32     0   9   112 137                       249 186 9 12 1   32     0   9   112 137                 249
1123971 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_10 182 169 73 1   58     1   27   274 237                       511 182 169 73 1   58     1   27   274 237                 511
1124003 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2017   grade_10 170 20 10 0   28     0   13   111 130                       241 170 20 10 0   28     0   13   111 130                 241
1132993 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 2017   grade_10 110 7 14 6   2     1   11   91 60                       151 110 7 14 6   2     1   11   91 60                 151
1124030 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_10 97 1 0 0   0     0   2   52 48                       100 97 1 0 0   0     0   2   52 48                 100
1131971 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2017   grade_10 143 1 7 0   3     0   4   76 82                       158 143 1 7 0   3     0   4   76 82                 158
1124071 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2017   grade_10 273 14 17 0   35     0   8   182 165                       347 273 14 17 0   35     0   8   182 165                 347
1124115 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2017   grade_10 19 25 375 0   8     0   3   242 188                       430 19 25 375 0   8     0   3   242 188                 430
1124150 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_10 5 0 13 0   0     0   2   14 6                       20 5 0 13 0   0     0   2   14 6                 20
1124198 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2017   grade_10 119 10 66 0   3     0   6   99 105                       204 119 10 66 0   3     0   6   99 105                 204
1124203 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2017   grade_10 248 6 106 0   12     0   8   187 193                       380 248 6 106 0   12     0   8   187 193                 380
1131260 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 2017   grade_10 1 56 8 0   0     0   2   22 45                       67 1 56 8 0   0     0   2   22 45                 67
1133132 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 2017   grade_10 1 56 11 0   3     0   0   29 42                       71 1 56 11 0   3     0   0   29 42                 71
1133155 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 Other 09 11 2017   grade_10 20 8 23 0   1     0   3   28 27                       55 20 8 23 0   1     0   3   28 27                 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]);