Data source: Big Local News · About: Big Local

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

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
1133206 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_10 149 4 16 0   2     0   9   63 117                       180 149 4 16 0   2     0   9   63 117                 180
1133192 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_10 52 6 11 2   0     1   3   25 50                       75 52 6 11 2   0     1   3   25 50                 75
1133159 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2017   grade_10 0 4 11 0   1     0   2   6 12                       18 0 4 11 0   1     0   2   6 12                 18
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
1133150 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_10 15 11 13 2   9     0   1   30 21                       51 15 11 13 2   9     0   1   30 21                 51
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
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
1133113 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2017   grade_10 11 5 76 0   0     0   0   49 43                       92 11 5 76 0   0     0   0   49 43                 92
1133108 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2017   grade_10 135 2 4 1   1     0   3   38 108                       146 135 2 4 1   1     0   3   38 108                 146
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
1133098 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2017   grade_10 255 8 58 1   4     0   12   183 155                       338 255 8 58 1   4     0   12   183 155                 338
1133093 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 147 15 4 0   1     0   8   111 64                       175 147 15 4 0   1     0   8   111 64                 175
1133088 MA Norfolk   school 2511735 878   Tri County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 249 0 13 0   4     1   10   150 126                       277 249 0 13 0   4     1   10   150 126                 277
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
1133078 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2017   grade_10 156 1 9 0   3     0   7   116 60                       176 156 1 9 0   3     0   7   116 60                 176
1133073 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 176 126 44 0   5     0   10   184 177                       361 176 126 44 0   5     0   10   184 177                 361
1133068 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2017   grade_10 297 5 12 1   3     0   9   182 145                       327 297 5 12 1   3     0   9   182 145                 327
1133063 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 144 1 9 1   0     0   5   99 61                       160 144 1 9 1   0     0   5   99 61                 160
1133058 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 137 0 0 0   0     0   2   79 60                       139 137 0 0 0   0     0   2   79 60                 139
1133053 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2017   grade_10 192 12 104 0   8     0   6   158 164                       322 192 12 104 0   8     0   6   158 164                 322
1133048 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2017   grade_10 172 0 10 1   1     0   4   110 78                       188 172 0 10 1   1     0   4   110 78                 188
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
1133038 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 276 5 52 1   6     0   17   177 178                       357 276 5 52 1   6     0   17   177 178                 357
1133033 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Career and Technical School No High 09 12 2017   grade_10 107 4 12 0   6     0   7   85 50                       136 107 4 12 0   6     0   7   85 50                 136
1133028 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2017   grade_10 79 7 88 2   0     0   6   111 71                       182 79 7 88 2   0     0   6   111 71                 182
1133023 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 235 22 193 3   90     0   24   332 235                       567 235 22 193 3   90     0   24   332 235                 567
1133018 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 369 40 118 3   6     0   18   270 284                       554 369 40 118 3   6     0   18   270 284                 554
1133013 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 69 6 316 0   2     0   0   200 193                       393 69 6 316 0   2     0   0   200 193                 393
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
1133003 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Technical   Career and Technical School No High 09 12 2017   grade_10 119 4 6 0   0     0   0   83 46                       129 119 4 6 0   0     0   0   83 46                 129
1132998 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex Technical High School   Career and Technical School No High 09 12 2017   grade_10 290 4 42 0   6     0   7   148 201                       349 290 4 42 0   6     0   7   148 201                 349
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
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
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
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
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
1132968 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2017   grade_10 263 7 5 2   4     0   10   141 150                       291 263 7 5 2   4     0   10   141 150                 291
1132932 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No High 09 12 2017   grade_10 95 0 8 0   0     0   2   55 50                       105 95 0 8 0   0     0   2   55 50                 105
1132906 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2017   grade_10 523 7 26 0   26     1   6   267 322                       589 523 7 26 0   26     1   6   267 322                 589
1132813 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No High 09 12 2017   grade_10 169 1 6 0   3     0   2   85 96                       181 169 1 6 0   3     0   2   85 96                 181
1132778 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua Regional Vocational   Career and Technical School No High 09 12 2017   grade_10 119 0 9 0   1     0   3   80 52                       132 119 0 9 0   1     0   3   80 52                 132
1132773 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No High 09 12 2017   grade_10 153 1 8 1   1     0   5   87 82                       169 153 1 8 1   1     0   5   87 82                 169
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
1132740 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_10 113 3 8 0   0     0   1   61 64                       125 113 3 8 0   0     0   1   61 64                 125
1132716 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_10 38 0 4 0   0     0   6   22 26                       48 38 0 4 0   0     0   6   22 26                 48
1132690 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2017   grade_10 248 4 6 0   1     0   10   120 149                       269 248 4 6 0   1     0   10   120 149                 269
1132685 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2017   grade_10 265 5 6 0   0     0   2   140 138                       278 265 5 6 0   0     0   2   140 138                 278
1132669 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2017   grade_10 94 1 11 2   1     0   0   55 54                       109 94 1 11 2   1     0   0   55 54                 109
1132659 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2017   grade_10 142 2 8 0   1     0   5   75 83                       158 142 2 8 0   1     0   5   75 83                 158
1132617 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2017   grade_10 60 1 0 1   1     0   2   32 33                       65 60 1 0 1   1     0   2   32 33                 65
1132577 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2017   grade_10 149 1 5 0   1     0   2   73 85                       158 149 1 5 0   1     0   2   73 85                 158
1132541 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2017   grade_10 177 3 1 0   7     0   3   89 102                       191 177 3 1 0   7     0   3   89 102                 191
1132532 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No High 09 12 2017   grade_10 172 2 5 0   1     0   5   82 103                       185 172 2 5 0   1     0   5   82 103                 185
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
1132483 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2017   grade_10 212 8 11 0   11     0   11   119 134                       253 212 8 11 0   11     0   11   119 134                 253
1132443 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No High 09 12 2017   grade_10 91 0 2 0   1     0   1   52 43                       95 91 0 2 0   1     0   1   52 43                 95
1132419 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2017   grade_10 59 0 2 0   0     0   6   34 33                       67 59 0 2 0   0     0   6   34 33                 67
1132379 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_10 92 2 2 0   1     0   3   51 49                       100 92 2 2 0   1     0   3   51 49                 100
1132372 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_10 91 8 3 0   3     0   5   64 46                       110 91 8 3 0   3     0   5   64 46                 110
1132348 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No High 09 12 2017   grade_10 146 3 7 0   1     0   4   68 93                       161 146 3 7 0   1     0   4   68 93                 161
1132324 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No High 09 12 2017   grade_10 253 2 7 2   8     0   6   140 138                       278 253 2 7 2   8     0   6   140 138                 278
1132316 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2017   grade_10 126 7 28 3   2     1   3   91 79                       170 126 7 28 3   2     1   3   91 79                 170
1132311 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2017   grade_10 101 0 0 0   0     0   2   41 62                       103 101 0 0 0   0     0   2   41 62                 103
1132287 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2017   grade_10 295 20 17 0   23     1   22   198 180                       378 295 20 17 0   23     1   22   198 180                 378
1132279 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2017   grade_10 301 6 3 0   6     0   2   181 137                       318 301 6 3 0   6     0   2   181 137                 318
1132265 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2017   grade_10 90 0 3 0   0     0   2   53 42                       95 90 0 3 0   0     0   2   53 42                 95
1132258 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2017   grade_10 263 6 17 0   8     0   9   157 146                       303 263 6 17 0   8     0   9   157 146                 303
1132227 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No High 09 12 2017   grade_10 136 0 4 0   7     0   3   79 71                       150 136 0 4 0   7     0   3   79 71                 150
1132196 MA Franklin   school 2505270 674   Gill-Montague 250527000768 6740505 Turners Fall High   Regular School No High 09 12 2017   grade_10 47 0 8 0   0     0   2   31 26                       57 47 0 8 0   0     0   2   31 26                 57
1132170 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2017   grade_10 179 4 3 0   13     0   4   104 99                       203 179 4 3 0   13     0   4   104 99                 203
1132146 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No High 09 12 2017   grade_10 56 0 3 0   0     0   0   34 25                       59 56 0 3 0   0     0   0   34 25                 59
1132121 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2017   grade_10 83 0 6 0   2     0   4   53 42                       95 83 0 6 0   2     0   4   53 42                 95
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
1132082 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   grade_10 209 8 8 1   4     0   7   111 126                       237 209 8 8 1   4     0   7   111 126                 237
1132073 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2017   grade_10 227 4 19 0   11     0   8   127 142                       269 227 4 19 0   11     0   8   127 142                 269
1132042 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000574 6550505 Dover-Sherborn Regional High   Regular School No High 09 12 2017   grade_10 130 4 3 0   15     0   2   81 73                       154 130 4 3 0   15     0   2   81 73                 154
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
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
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
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
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
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                    
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
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
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
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
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
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
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
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
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
1131680 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes Other 06 12 2017   grade_10 12 10 14 0   2     0   2   16 24                       40 12 10 14 0   2     0   2   16 24                 40
1131667 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2017   grade_10 13 1 0 0   4     0   2   10 10                       20 13 1 0 0   4     0   2   10 10                 20
1131653 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes Other 05 12 2017   grade_10 22 8 13 1   1     0   1   22 24                       46 22 8 13 1   1     0   1   22 24                 46
1131644 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2017   grade_10 19 24 10 1   8     0   0   26 36                       62 19 24 10 1   8     0   0   26 36                 62
1131634 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes High 09 12 2017   grade_10 0 1 14 0   0     0   0   8 7                       15 0 1 14 0   0     0   0   8 7                 15
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
1131609 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   grade_10 169 6 15 3   9     1   11   84 130                       214 169 6 15 3   9     1   11   84 130                 214
1131604 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_10 35 17 3 0   1     0   3   27 32                       59 35 17 3 0   1     0   3   27 32                 59
1131590 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_10 7 47 20 0   7     0   4   39 46                       85 7 47 20 0   7     0   4   39 46                 85

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