Data source: Big Local News · About: Big Local

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

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
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
1132497 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2017   grade_10 298 2 16 2   40     0   12   164 206                       370 298 2 16 2   40     0   12   164 206                 370
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
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
1132114 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2017   grade_10 173 4 3 1   1     0   7   91 98                       189 173 4 3 1   1     0   7   91 98                 189
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
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
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
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
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
1124823 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_10 283 43 128 0   28     2   29   261 252                       513 283 43 128 0   28     2   29   261 252                 513
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
1130069 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2017   grade_10 106 6 16 0   3     0   5   76 60                       136 106 6 16 0   3     0   5   76 60                 136
1133083 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2017   grade_10 272 2 21 0   0     0   4   179 120                       299 272 2 21 0   0     0   4   179 120                 299
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1125358 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_10 85 3 4 0   10     0   1   52 51                       103 85 3 4 0   10     0   1   52 51                 103
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
1131046 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2017   grade_10 90 53 122 1   21     0   18   169 136                       305 90 53 122 1   21     0   18   169 136                 305
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
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                  
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
1125999 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2017   grade_10 83 11 38 0   5     0   7   105 39                       144 83 11 38 0   5     0   7   105 39                 144
1133043 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 114 1 4 0   0     0   1   83 37                       120 114 1 4 0   0     0   1   83 37                 120
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
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
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
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
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
1131027 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2017   grade_10 7 10 69 0   6     0   2   44 50                       94 7 10 69 0   6     0   2   44 50                 94
1126494 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2017   grade_10 116 41 227 1   46     1   9   234 207                       441 116 41 227 1   46     1   9   234 207                 441
1124231 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2017   grade_10 71 4 30 0   5     0   0   55 55                       110 71 4 30 0   5     0   0   55 55                 110
1131275 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_10 0 36 9 0   0     2   0   24 23                       47 0 36 9 0   0     2   0   24 23                 47
1124248 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_10 107 5 1 0   2     0   1   62 54                       116 107 5 1 0   2     0   1   62 54                 116
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
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
1131255 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes Other 06 12 2017   grade_10 4 35 16 0   3     0   2   33 27                       60 4 35 16 0   3     0   2   33 27                 60
1131976 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2017   grade_10 259 12 12 0   35     0   16   159 174                       334 259 12 12 0   35     0   16   159 174                 334
1129389 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No Other 06 11 2017   grade_10 9 12 25 0   0     0   1   10 37                       47 9 12 25 0   0     0   1   10 37                 47
1126841 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2017   grade_10 * * * *   *     *   *   2 2                       *                         2 2                  
1125196 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_10 * * * *   *     *   *   * *                       *                                              
1124329 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2017   grade_10 218 9 15 0   6     0   3   124 127                       251 218 9 15 0   6     0   3   124 127                 251
1124361 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2017   grade_10 249 2 8 0   1     0   10   135 135                       270 249 2 8 0   1     0   10   135 135                 270
1132765 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_10 80 1 5 0   0     0   4   48 42                       90 80 1 5 0   0     0   4   48 42                 90
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
1124397 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2017   grade_10 125 20 23 0   9     0   3   95 85                       180 125 20 23 0   9     0   3   95 85                 180
1132005 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_10 138 21 20 3   9     0   10   99 102                       201 138 21 20 3   9     0   10   99 102                 201
1124660 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_10 6 2 2 0   0     0   1   9 2                       11 6 2 2 0   0     0   1   9 2                 11
1132033 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2017   grade_10 203 2 8 0   2     0   4   127 92                       219 203 2 8 0   2     0   4   127 92                 219
1133008 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2017   grade_10 287 6 31 2   3     0   18   184 163                       347 287 6 31 2   3     0   18   184 163                 347
1131051 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2017   grade_10 159 50 121 2   34     0   19   203 182                       385 159 50 121 2   34     0   19   203 182                 385
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
1124424 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_10 95 0 3 0   0     0   1   52 47                       99 95 0 3 0   0     0   1   52 47                 99

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