Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by county descending

View and edit SQL

year

grade

  • grade_9 · 2,737
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
735931 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_9 146 5 12 0   5     0   3   73 98                       171 146 5 12 0   5     0   3   73 98                 171
737620 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   grade_9 69 4 42 1   1     0   3   56 64                       120 69 4 42 1   1     0   3   56 64                 120
737784 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_9 99 0 2 0   0     0   0   52 49                       101 99 0 2 0   0     0   0   52 49                 101
738194 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2015   grade_9 101 19 146 0   20     1   11   150 148                       298 101 19 146 0   20     1   11   150 148                 298
738199 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No 3 09 12 2015   grade_9 5 0 2 0   0     0   0   5 2                       7 5 0 2 0   0     0   0   5 2                 7
738364 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 09 12 2015   grade_9 124 5 17 0   2     0   9   78 79                       157 124 5 17 0   2     0   9   78 79                 157
738369 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_9 13 0 0 0   1     0   0   9 5                       14 13 0 0 0   1     0   0   9 5                 14
738445 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No 3 09 12 2015   grade_9 185 0 6 0   17     0   4   99 113                       212 185 0 6 0   17     0   4   99 113                 212
738550 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_9 84 2 1 0   12     0   3   56 46                       102 84 2 1 0   12     0   3   56 46                 102
738791 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_9 89 0 0 0   1     0   0   44 46                       90 89 0 0 0   1     0   0   44 46                 90
739050 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2015   grade_9 106 3 6 0   1     0   0   59 57                       116 106 3 6 0   1     0   0   59 57                 116
739102 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No 3 09 12 2015   grade_9 140 16 33 0   4     0   3   95 101                       196 140 16 33 0   4     0   3   95 101                 196
739108 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_9 187 26 121 1   19     1   6   208 153                       361 187 26 121 1   19     1   6   208 153                 361
739390 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_9 102 1 3 0   1     0   1   50 58                       108 102 1 3 0   1     0   1   50 58                 108
739956 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_9 185 8 80 5   11     1   6   136 160                       296 185 8 80 5   11     1   6   136 160                 296
739971 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_9 103 1 3 2   1     0   1   53 58                       111 103 1 3 2   1     0   1   53 58                 111
740610 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No 3 09 12 2015   grade_9 142 0 22 0   3     0   3   88 82                       170 142 0 22 0   3     0   3   88 82                 170
740625 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2015   grade_9 24 2 2 0   0     0   1   15 14                       29 24 2 2 0   0     0   1   15 14                 29
740767 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No 3 09 12 2015   grade_9 92 1 14 1   0     0   3   56 55                       111 92 1 14 1   0     0   3   56 55                 111
741572 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No 3 09 12 2015   grade_9 310 9 26 0   73     1   13   187 245                       432 310 9 26 0   73     1   13   187 245                 432
741720 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2015   grade_9 65 6 88 0   1     0   3   85 78                       163 65 6 88 0   1     0   3   85 78                 163
742154 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2015   grade_9 98 0 3 2   3     0   6   59 53                       112 98 0 3 2   3     0   6   59 53                 112
742327 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No 3 09 12 2015   grade_9 120 1 3 0   3     0   1   62 66                       128 120 1 3 0   3     0   1   62 66                 128
742555 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett Jr Sr High School   Regular School No 3 07 12 2015   grade_9 97 5 24 0   2     0   10   75 63                       138 97 5 24 0   2     0   10   75 63                 138
742636 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No 3 09 12 2015   grade_9 184 5 15 0   51     0   7   128 134                       262 184 5 15 0   51     0   7   128 134                 262
742651 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2015   grade_9 69 0 3 0   0     0   2   38 36                       74 69 0 3 0   0     0   2   38 36                 74
743353 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2015   grade_9 4 4 23 0   9     0   1   26 15                       41 4 4 23 0   9     0   1   26 15                 41
743359 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_9 7 17 58 0   9     0   2   44 49                       93 7 17 58 0   9     0   2   44 49                 93
743373 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No 3 09 12 2015   grade_9 91 48 111 0   14     0   9   146 127                       273 91 48 111 0   14     0   9   146 127                 273
743377 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No 3 09 12 2015   grade_9 169 69 134 0   43     0   12   235 192                       427 169 69 134 0   43     0   12   235 192                 427
743381 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No 3 09 12 2015   grade_9 82 61 172 2   26     0   13   184 172                       356 82 61 172 2   26     0   13   184 172                 356
743385 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No 3 09 12 2015   grade_9 96 41 169 0   40     0   12   191 167                       358 96 41 169 0   40     0   12   191 167                 358
743389 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2015   grade_9 144 45 145 0   24     0   12   165 205                       370 144 45 145 0   24     0   12   165 205                 370
743611 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_9 24 35 29 0   6     0   2   33 63                       96 24 35 29 0   6     0   2   33 63                 96
743761 MA Worcester   school 2500073 474   The Sizer School: A North Central Charter Essential (District) 250007301750 4740505 The Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2015   grade_9 49 4 14 0   1     0   3   35 36                       71 49 4 14 0   1     0   3   35 36                 71
744014 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No 3 09 12 2015   grade_9 182 2 3 0   1     0   3   97 94                       191 182 2 3 0   1     0   3   97 94                 191
744041 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No 3 09 12 2015   grade_9 93 2 5 0   2     0   0   50 52                       102 93 2 5 0   2     0   0   50 52                 102
744085 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2015   grade_9 77 0 0 0   4     0   4   46 39                       85 77 0 0 0   4     0   4   46 39                 85
744105 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No 3 09 12 2015   grade_9 102 1 7 1   1     0   2   62 52                       114 102 1 7 1   1     0   2   62 52                 114
744255 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No 3 09 12 2015   grade_9 285 3 18 2   1     1   3   152 161                       313 285 3 18 2   1     1   3   152 161                 313
744489 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No 3 09 12 2015   grade_9 142 0 3 0   4     0   4   77 76                       153 142 0 3 0   4     0   4   77 76                 153
744573 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No 3 09 12 2015   grade_9 92 0 3 0   0     0   5   49 51                       100 92 0 3 0   0     0   5   49 51                 100
744607 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No 3 09 12 2015   grade_9 240 5 14 0   7     0   8   129 145                       274 240 5 14 0   7     0   8   129 145                 274
744620 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_9 293 5 12 0   37     1   9   158 199                       357 293 5 12 0   37     1   9   158 199                 357
744757 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No 3 09 12 2015   grade_9 195 3 10 0   2     0   7   107 110                       217 195 3 10 0   2     0   7   107 110                 217
744771 MA Worcester   school 2509900 755   Ralph C Mahar 250990002707 7550525 The Gateway to College   Regular School No 3 09 12 2015   grade_9 14 0 2 0   0     1   0   6 11                       17 14 0 2 0   0     1   0   6 11                 17
744849 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2015   grade_9 86 2 12 0   2     0   3   50 55                       105 86 2 12 0   2     0   3   50 55                 105
744856 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No 3 09 12 2015   grade_9 159 1 4 0   3     0   4   78 93                       171 159 1 4 0   3     0   4   78 93                 171
744861 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua Regional Vocational   Vocational Education School No 3 09 12 2015   grade_9 127 2 9 0   0     0   2   85 55                       140 127 2 9 0   0     0   2   85 55                 140
744970 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2015   grade_9 443 10 18 0   23     2   9   216 289                       505 443 10 18 0   23     2   9   216 289                 505
744993 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No 3 09 12 2015   grade_9 86 1 2 1   0     0   1   41 50                       91 86 1 2 1   0     0   1   41 50                 91
745031 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Vocational Education School No 3 09 12 2015   grade_9 300 0 7 0   1     0   2   142 168                       310 300 0 7 0   1     0   2   142 168                 310
745081 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 308 3 45 0   2     0   10   226 142                       368 308 3 45 0   2     0   10   226 142                 368
745119 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 2015   grade_9 278 1 21 0   0     0   3   177 126                       303 278 1 21 0   0     0   3   177 126                 303
932805 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   grade_9 170 6 7 0   12     0   5   101 99                       200 170 6 7 0   12     0   5   101 99                 200
934480 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2016   grade_9 74 3 28 0   5     0   0   53 57                       110 74 3 28 0   5     0   0   53 57                 110
934641 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2016   grade_9 104 0 2 0   0     0   1   56 51                       107 104 0 2 0   0     0   1   56 51                 107
935048 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2016   grade_9 94 21 141 0   19     0   21   150 146                       296 94 21 141 0   19     0   21   150 146                 296
935053 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No 3 09 12 2016   grade_9 4 1 3 0   0     0   0   4 4                       8 4 1 3 0   0     0   0   4 4                 8
935215 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   grade_9 115 2 25 1   4     0   11   83 75                       158 115 2 25 1   4     0   11   83 75                 158
935220 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2016   grade_9 11 0 0 0   0     0   1   2 10                       12 11 0 0 0   0     0   1   2 10                 12
935297 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No 3 09 12 2016   grade_9 186 5 6 0   30     1   5   113 120                       233 186 5 6 0   30     1   5   113 120                 233
935400 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_9 84 4 4 0   12     0   1   55 50                       105 84 4 4 0   12     0   1   55 50                 105
935640 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_9 79 0 2 4   0     0   3   42 46                       88 79 0 2 4   0     0   3   42 46                 88
935899 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2016   grade_9 95 6 4 1   2     1   0   54 55                       109 95 6 4 1   2     1   0   54 55                 109
935950 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No 3 09 12 2016   grade_9 268 36 123 1   16     0   14   258 200                       458 268 36 123 1   16     0   14   258 200                 458
935954 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No 3 09 12 2016   grade_9 4 1 1 0   0     0   1   3 4                       7 4 1 1 0   0     0   1   3 4                 7
936237 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2016   grade_9 101 1 5 1   8     1   0   58 59                       117 101 1 5 1   8     1   0   58 59                 117
936802 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   grade_9 183 6 60 5   9     0   2   138 127                       265 183 6 60 5   9     0   2   138 127                 265
936817 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2016   grade_9 92 2 11 0   1     0   5   63 48                       111 92 2 11 0   1     0   5   63 48                 111
937440 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No 3 09 12 2016   grade_9 139 2 11 0   0     0   3   79 76                       155 139 2 11 0   0     0   3   79 76                 155
937454 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2016   grade_9 41 0 2 0   0     0   2   22 23                       45 41 0 2 0   0     0   2   22 23                 45
937588 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_9 5 1 2 0   0     0   0   6 *                       8 5 1 2 0   0     0   0   6                   8
937596 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No 3 09 12 2016   grade_9 70 3 6 0   3     0   5   38 49                       87 70 3 6 0   3     0   5   38 49                 87
938377 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No 3 09 12 2016   grade_9 276 5 29 0   92     1   10   177 236                       413 276 5 29 0   92     1   10   177 236                 413
938524 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2016   grade_9 81 1 79 0   1     0   0   96 66                       162 81 1 79 0   1     0   0   96 66                 162
938964 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2016   grade_9 106 0 2 0   1     0   4   50 63                       113 106 0 2 0   1     0   4   50 63                 113
939136 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No 3 09 12 2016   grade_9 119 3 3 0   0     1   5   70 61                       131 119 3 3 0   0     1   5   70 61                 131
939364 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No 3 09 12 2016   grade_9 106 6 16 1   4     0   5   75 63                       138 106 6 16 1   4     0   5   75 63                 138
939444 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No 3 09 12 2016   grade_9 184 7 12 0   59     0   8   129 141                       270 184 7 12 0   59     0   8   129 141                 270
939458 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2016   grade_9 56 1 6 0   2     0   3   35 33                       68 56 1 6 0   2     0   3   35 33                 68
939787 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_9 * * * *   *     *   *   1 4                       5                         1 4                 5
940162 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2016   grade_9 5 3 18 1   10     0   2   22 17                       39 5 3 18 1   10     0   2   22 17                 39
940168 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2016   grade_9 7 12 68 0   6     0   2   43 52                       95 7 12 68 0   6     0   2   43 52                 95
940182 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No 3 09 12 2016   grade_9 96 49 136 0   14     0   17   168 144                       312 96 49 136 0   14     0   17   168 144                 312
940186 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No 3 09 12 2016   grade_9 168 53 118 2   31     0   19   208 183                       391 168 53 118 2   31     0   19   208 183                 391
940190 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No 3 09 12 2016   grade_9 57 64 153 3   18     0   12   158 149                       307 57 64 153 3   18     0   12   158 149                 307
940194 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No 3 09 12 2016   grade_9 90 65 138 2   49     0   13   178 179                       357 90 65 138 2   49     0   13   178 179                 357
940198 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2016   grade_9 126 61 121 0   16     0   12   147 189                       336 126 61 121 0   16     0   12   147 189                 336
940434 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_9 27 39 17 0   6     1   3   56 37                       93 27 39 17 0   6     1   3   56 37                 93
940590 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2016   grade_9 55 2 15 0   1     0   2   41 34                       75 55 2 15 0   1     0   2   41 34                 75
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
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
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
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
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
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
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
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
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

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