Data source: Big Local News · About: Big Local

392 rows where grade = "grade_9", state = "MA" and year = 2016 sorted by rowid descending

View and edit SQL

year

  • 2016 · 392

grade

  • grade_9 · 392
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
942031 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_9 108 11 14 0   2     1   8   51 93                       144 108 11 14 0   2     1   8   51 93                 144
942018 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 4 KG 12 2016   grade_9 44 9 10 1   2     1   1   30 38                       68 44 9 10 1   2     1   1   30 38                 68
941995 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 3 09 12 2016   grade_9 8 32 87 0   2     0   5   69 65                       134 8 32 87 0   2     0   5   69 65                 134
941993 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 4 09 10 2016   grade_9 35 16 46 0   1     0   4   52 50                       102 35 16 46 0   1     0   4   52 50                 102
941990 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 4 07 11 2016   grade_9 22 19 14 2   11     0   2   38 32                       70 22 19 14 2   11     0   2   38 32                 70
941976 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 4 09 11 2016   grade_9 2 103 21 0   2     0   0   61 67                       128 2 103 21 0   2     0   0   61 67                 128
941969 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 09 2016   grade_9 3 18 43 0   0     0   1   29 36                       65 3 18 43 0   0     0   1   29 36                 65
941962 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes 3 09 12 2016   grade_9 12 7 102 0   0     0   0   54 67                       121 12 7 102 0   0     0   0   54 67                 121
941958 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Vocational Education School No 3 09 12 2016   grade_9 136 2 4 1   1     0   4   38 110                       148 136 2 4 1   1     0   4   38 110                 148
941954 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Vocational Education School No 3 09 12 2016   grade_9 118 0 3 1   0     0   4   25 101                       126 118 0 3 1   0     0   4   25 101                 126
941950 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 260 6 59 2   5     0   10   181 161                       342 260 6 59 2   5     0   10   181 161                 342
941946 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 150 13 4 0   1     0   7   112 63                       175 150 13 4 0   1     0   7   112 63                 175
941942 MA Norfolk   school 2511735 878   Tri County Regional Vocational Technical 251173501931 8780605 Tri County Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 261 1 13 0   4     1   11   156 135                       291 261 1 13 0   4     1   11   156 135                 291
941938 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Vocational Education School No 3 09 12 2016   grade_9 278 2 21 0   0     0   4   182 123                       305 278 2 21 0   0     0   4   182 123                 305
941934 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 161 2 6 0   3     0   8   115 65                       180 161 2 6 0   3     0   8   115 65                 180
941930 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 180 141 47 0   4     0   12   197 187                       384 180 141 47 0   4     0   12   197 187                 384
941926 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Vocational Education School No 3 09 12 2016   grade_9 292 6 14 1   3     0   8   183 141                       324 292 6 14 1   3     0   8   183 141                 324
941921 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 151 1 9 1   0     0   5   104 63                       167 151 1 9 1   0     0   5   104 63                 167
941917 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 138 0 0 0   0     0   2   82 58                       140 138 0 0 0   0     0   2   82 58                 140
941913 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 197 12 106 0   8     0   6   164 165                       329 197 12 106 0   8     0   6   164 165                 329
941909 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Vocational Education School No 3 09 12 2016   grade_9 169 0 11 1   1     0   4   108 78                       186 169 0 11 1   1     0   4   108 78                 186
941905 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 109 0 2 0   0     0   1   77 35                       112 109 0 2 0   0     0   1   77 35                 112
941901 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 275 6 52 1   6     0   18   179 179                       358 275 6 52 1   6     0   18   179 179                 358
941897 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Vocational Education School No 3 09 12 2016   grade_9 103 6 12 0   7     0   5   88 45                       133 103 6 12 0   7     0   5   88 45                 133
941893 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Vocational Education School No 3 09 12 2016   grade_9 75 7 82 2   1     0   5   103 69                       172 75 7 82 2   1     0   5   103 69                 172
941888 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 227 21 190 3   96     0   25   327 235                       562 227 21 190 3   96     0   25   327 235                 562
941884 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 372 44 118 3   6     0   20   268 295                       563 372 44 118 3   6     0   20   268 295                 563
941880 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 67 6 322 0   2     0   0   201 196                       397 67 6 322 0   2     0   0   201 196                 397
941876 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 300 7 31 2   3     0   22   185 180                       365 300 7 31 2   3     0   22   185 180                 365
941872 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Technical   Vocational Education School No 3 09 12 2016   grade_9 120 4 7 0   0     0   1   87 45                       132 120 4 7 0   0     0   1   87 45                 132
941868 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex Technical High School   Vocational Education School No 3 09 12 2016   grade_9 295 4 43 1   6     0   8   151 206                       357 295 4 43 1   6     0   8   151 206                 357
941864 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 104 6 14 6   1     1   9   85 56                       141 104 6 14 6   1     1   9   85 56                 141
941860 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 276 14 29 2   1     0   12   204 130                       334 276 14 29 2   1     0   12   204 130                 334
941856 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 132 53 28 3   2     0   9   127 100                       227 132 53 28 3   2     0   9   127 100                 227
941852 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Vocational Education School No 3 09 12 2016   grade_9 293 1 5 0   7     0   5   159 152                       311 293 1 5 0   7     0   5   159 152                 311
941848 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Vocational Education School No 3 09 12 2016   grade_9 233 0 44 0   1     0   6   158 126                       284 233 0 44 0   1     0   6   158 126                 284
941843 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No 3 09 12 2016   grade_9 265 6 5 2   3     0   8   142 147                       289 265 6 5 2   3     0   8   142 147                 289
941814 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No 3 09 12 2016   grade_9 107 1 7 0   0     0   2   63 54                       117 107 1 7 0   0     0   2   63 54                 117
941791 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2016   grade_9 516 5 24 0   27     0   5   263 314                       577 516 5 24 0   27     0   5   263 314                 577
941712 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No 3 09 12 2016   grade_9 171 1 7 0   4     0   2   86 99                       185 171 1 7 0   4     0   2   86 99                 185
941682 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 127 0 11 0   1     0   3   85 57                       142 127 0 11 0   1     0   3   85 57                 142
941677 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No 3 09 12 2016   grade_9 135 1 7 1   1     1   4   76 74                       150 135 1 7 1   1     1   4   76 74                 150
941670 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2016   grade_9 101 1 7 0   1     0   5   61 54                       115 101 1 7 0   1     0   5   61 54                 115
941649 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No 3 07 12 2016   grade_9 115 4 6 0   1     0   1   62 65                       127 115 4 6 0   1     0   1   62 65                 127
941629 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2016   grade_9 41 0 2 0   0     0   5   19 29                       48 41 0 2 0   0     0   5   19 29                 48
941607 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No 3 09 12 2016   grade_9 239 4 5 0   2     1   6   118 139                       257 239 4 5 0   2     1   6   118 139                 257
941603 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No 3 09 12 2016   grade_9 267 5 6 0   0     0   2   142 138                       280 267 5 6 0   0     0   2   142 138                 280
941597 MA Worcester   school 2509900 755   Ralph C Mahar 250990002707 7550525 The Gateway to College   Regular School No 3 09 12 2016   grade_9 13 1 1 0   1     0   1   3 14                       17 13 1 1 0   1     0   1   3 14                 17
941591 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2016   grade_9 103 2 11 2   1     0   4   60 63                       123 103 2 11 2   1     0   4   60 63                 123
941582 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2016   grade_9 162 1 11 0   1     0   6   87 94                       181 162 1 11 0   1     0   6   87 94                 181
941547 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2016   grade_9 59 1 1 1   1     0   2   35 30                       65 59 1 1 1   1     0   2   35 30                 65
941510 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2016   grade_9 150 1 6 0   1     0   1   74 85                       159 150 1 6 0   1     0   1   74 85                 159
941480 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No 3 09 12 2016   grade_9 169 3 4 0   7     0   3   85 101                       186 169 3 4 0   7     0   3   85 101                 186
941473 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No 3 09 12 2016   grade_9 174 2 3 0   2     0   5   83 103                       186 174 2 3 0   2     0   5   83 103                 186
941444 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2016   grade_9 309 2 13 2   37     0   11   168 206                       374 309 2 13 2   37     0   11   168 206                 374
941431 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No 3 09 12 2016   grade_9 216 8 11 0   9     0   11   123 132                       255 216 8 11 0   9     0   11   123 132                 255
941397 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No 3 09 12 2016   grade_9 97 0 3 0   1     0   2   56 47                       103 97 0 3 0   1     0   2   56 47                 103
941378 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No 3 07 12 2016   grade_9 66 0 4 0   0     0   5   37 38                       75 66 0 4 0   0     0   5   37 38                 75
941341 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2016   grade_9 85 1 0 0   1     0   2   45 44                       89 85 1 0 0   1     0   2   45 44                 89
941334 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2016   grade_9 100 11 3 0   2     0   4   66 54                       120 100 11 3 0   2     0   4   66 54                 120
941313 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No 3 09 12 2016   grade_9 149 2 5 0   1     0   4   72 89                       161 149 2 5 0   1     0   4   72 89                 161
941293 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2016   grade_9 262 2 5 2   9     0   6   145 141                       286 262 2 5 2   9     0   6   145 141                 286
941286 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2016   grade_9 121 2 22 3   1     1   3   92 61                       153 121 2 22 3   1     1   3   92 61                 153
941282 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_9 109 0 0 0   0     0   2   46 65                       111 109 0 0 0   0     0   2   46 65                 111
941262 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No 3 09 12 2016   grade_9 307 19 16 0   20     1   23   199 187                       386 307 19 16 0   20     1   23   199 187                 386
941255 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No 3 09 12 2016   grade_9 289 6 3 0   6     0   2   176 130                       306 289 6 3 0   6     0   2   176 130                 306
941242 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_9 99 0 1 0   0     0   2   54 48                       102 99 0 1 0   0     0   2   54 48                 102
941236 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No 3 09 12 2016   grade_9 271 5 19 0   9     0   9   157 156                       313 271 5 19 0   9     0   9   157 156                 313
941212 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No 3 09 12 2016   grade_9 138 0 4 0   6     0   3   77 74                       151 138 0 4 0   6     0   3   77 74                 151
941185 MA Franklin   school 2505270 674   Gill-Montague 250527000768 6740505 Turners Fall High   Regular School No 3 09 12 2016   grade_9 48 0 8 1   0     0   3   34 26                       60 48 0 8 1   0     0   3   34 26                 60
941163 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No 3 09 12 2016   grade_9 180 4 2 0   11     0   4   101 100                       201 180 4 2 0   11     0   4   101 100                 201
941143 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No 3 09 12 2016   grade_9 63 0 5 1   0     0   1   39 31                       70 63 0 5 1   0     0   1   39 31                 70
941122 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2016   grade_9 83 0 5 0   3     0   3   52 42                       94 83 0 5 0   3     0   3   52 42                 94
941116 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No 3 09 12 2016   grade_9 179 4 4 1   1     0   8   95 102                       197 179 4 4 1   1     0   8   95 102                 197
941089 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2016   grade_9 216 5 9 1   6     0   5   111 131                       242 216 5 9 1   6     0   5   111 131                 242
941082 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No 3 09 12 2016   grade_9 240 4 17 0   10     0   8   135 144                       279 240 4 17 0   10     0   8   135 144                 279
941058 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000574 6550505 Dover-Sherborn Regional High   Regular School No 3 09 12 2016   grade_9 134 5 3 0   15     0   2   84 75                       159 134 5 3 0   15     0   2   84 75                 159
941050 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No 3 09 12 2016   grade_9 201 3 9 0   3     0   4   127 93                       220 201 3 9 0   3     0   4   127 93                 220
941027 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2016   grade_9 154 18 21 2   9     0   16   107 113                       220 154 18 21 2   9     0   16   107 113                 220
941004 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No 3 09 12 2016   grade_9 256 13 14 0   35     0   15   159 174                       333 256 13 14 0   35     0   15   159 174                 333
941000 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No 3 09 12 2016   grade_9 149 2 6 0   3     0   4   79 85                       164 149 2 6 0   3     0   4   79 85                 164
940963 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2016   grade_9 344 11 12 0   6     0   21   192 202                       394 344 11 12 0   6     0   21   192 202                 394
940939 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No 3 09 12 2016   grade_9 109 2 7 0   2     0   2   60 62                       122 109 2 7 0   2     0   2   60 62                 122
940919 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_9 70 1 1 0   0     0   3   28 47                       75 70 1 1 0   0     0   3   28 47                 75
940911 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2016   grade_9 120 5 6 0   1     0   4   67 69                       136 120 5 6 0   1     0   4   67 69                 136
940897 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No 3 09 12 2016   grade_9 95 6 12 0   3     0   10   59 67                       126 95 6 12 0   3     0   10   59 67                 126
940875 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No 3 09 12 2016   grade_9 79 1 3 0   0     0   2   48 37                       85 79 1 3 0   0     0   2   48 37                 85
940848 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No 3 09 12 2016   grade_9 155 0 3 0   2     0   3   77 86                       163 155 0 3 0   2     0   3   77 86                 163
940827 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2016   grade_9 137 13 35 0   21     0   16   111 111                       222 137 13 35 0   21     0   16   111 111                 222
940820 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_9 87 5 4 1   3     0   0   45 55                       100 87 5 4 1   3     0   0   45 55                 100
940800 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2016   grade_9 298 5 15 0   154     0   16   260 228                       488 298 5 15 0   154     0   16   260 228                 488
940750 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2016   grade_9 25 11 20 0   2     0   2   29 31                       60 25 11 20 0   2     0   2   29 31                 60
940740 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_9 15 4 1 0   8     0   2   17 13                       30 15 4 1 0   8     0   2   17 13                 30
940727 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_9 25 8 14 1   1     0   1   24 26                       50 25 8 14 1   1     0   1   24 26                 50
940719 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes 3 07 12 2016   grade_9 20 29 11 1   8     0   0   28 41                       69 20 29 11 1   8     0   0   28 41                 69
940713 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes 3 09 12 2016   grade_9 4 10 66 0   1     0   0   45 36                       81 4 10 66 0   1     0   0   45 36                 81
940705 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_9 49 2 8 0   3     0   1   29 34                       63 49 2 8 0   3     0   1   29 34                 63
940692 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2016   grade_9 184 6 12 2   8     1   7   87 133                       220 184 6 12 2   8     1   7   87 133                 220
940688 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2016   grade_9 27 14 3 0   1     0   3   23 25                       48 27 14 3 0   1     0   3   23 25                 48
940675 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_9 8 47 23 0   7     0   4   39 50                       89 8 47 23 0   7     0   4   39 50                 89

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