enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
735973 735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
736979 736979 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_9 98 1 3 0   1     0   6   55 54                       109 98 1 3 0   1     0   6   55 54                 109
738153 738153 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_9 186 8 10 1   6     1   18   114 116                       230 186 8 10 1   6     1   18   114 116                 230
739731 739731 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_9 100 4 4 4   1     0   6   54 65                       119 100 4 4 4   1     0   6   54 65                 119
741413 741413 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2015   grade_9 170 1 1 1   3     0   0   91 85                       176 170 1 1 1   3     0   0   91 85                 176
743862 743862 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2015   grade_9 177 4 5 0   3     0   11   78 122                       200 177 4 5 0   3     0   11   78 122                 200
744201 744201 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_9 157 15 20 1   8     0   10   113 98                       211 157 15 20 1   8     0   10   113 98                 211
744262 744262 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2015   grade_9 189 8 8 1   7     1   3   107 110                       217 189 8 8 1   7     1   3   107 110                 217
744510 744510 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2015   grade_9 100 14 9 1   4     0   7   71 64                       135 100 14 9 1   4     0   7   71 64                 135
745043 745043 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 128 4 18 0   1     0   11   100 62                       162 128 4 18 0   1     0   11   100 62                 162
745127 745127 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 2015   grade_9 168 3 6 1   7     0   7   114 78                       192 168 3 6 1   7     0   7   114 78                 192
932847 932847 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_9 284 30 28 3   16     2   21   186 198                       384 284 30 28 3   16     2   21   186 198                 384
933844 933844 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_9 99 5 4 0   0     0   5   55 58                       113 99 5 4 0   0     0   5   55 58                 113
935007 935007 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_9 183 10 5 6   9     0   10   101 122                       223 183 10 5 6   9     0   10   101 122                 223
936575 936575 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2016   grade_9 86 4 4 10   2     0   8   66 48                       114 86 4 4 10   2     0   8   66 48                 114
938220 938220 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2016   grade_9 167 1 0 1   2     0   0   88 83                       171 167 1 0 1   2     0   0   88 83                 171
940692 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
941027 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
941089 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
941334 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
941864 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
941946 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
1122326 1122326 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_9 269 38 44 2   13     1   13   169 211                       380 269 38 44 2   13     1   13   169 211                 380
1123479 1123479 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2017   grade_9 108 1 5 0   5     1   5   60 65                       125 108 1 5 0   5     1   5   60 65                 125
1124862 1124862 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   grade_9 195 11 11 2   9     0   12   113 127                       240 195 11 11 2   9     0   12   113 127                 240
1126744 1126744 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   grade_9 91 6 4 5   2     0   5   60 53                       113 91 6 4 5   2     0   5   60 53                 113
1128703 1128703 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2017   grade_9 162 4 4 0   5     0   1   87 89                       176 162 4 4 0   5     0   1   87 89                 176
1131608 1131608 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   grade_9 182 4 15 2   6     0   8   99 118                       217 182 4 15 2   6     0   8   99 118                 217
1132004 1132004 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_9 138 18 22 1   4     0   11   86 108                       194 138 18 22 1   4     0   11   86 108                 194
1132081 1132081 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   grade_9 185 13 1 1   8     0   11   100 119                       219 185 13 1 1   8     0   11   100 119                 219
1132371 1132371 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_9 100 6 4 2   3     0   4   56 63                       119 100 6 4 2   3     0   4   56 63                 119
1132992 1132992 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_9 117 11 20 1   2     0   9   101 59                       160 117 11 20 1   2     0   9   101 59                 160
1133092 1133092 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_9 163 10 3 1   4     0   11   119 73                       192 163 10 3 1   4     0   11   119 73                 192
1365097 1365097 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_9 218 30 53 2   5     1   23   134 198 *                     332.0 218 30 53 2   5     1   23   134 198                 332
1366067 1366067 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_9 96 0 1 1   2     0   3   43 60 *                     103.0 96 0 1 1   2     0   3   43 60                 103
1367239 1367239 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_9 207 13 14 4   2     0   12   130 121 *                     252.0 207 13 14 4   2     0   12   130 121                 252
1368801 1368801 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_9 89 8 2 10   4     0   6   56 63 *                     119.0 89 8 2 10   4     0   6   56 63                 119
1370449 1370449 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2020   grade_9 156 0 2 2   5     0   0   78 87 *                     165.0 156 0 2 2   5     0   0   78 87                 165
1372908 1372908 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_9 185 5 11 1   10     0   5   96 120 *                     217.0 185 5 11 1   10     0   5   96 120                 217
1373255 1373255 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_9 127 22 23 3   5     0   7   102 85 *                     187.0 127 22 23 3   5     0   7   102 85                 187
1373320 1373320 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2020   grade_9 172 14 6 0   5     0   7   89 115 *                     204.0 172 14 6 0   5     0   7   89 115                 204
1373567 1373567 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2020   grade_9 102 8 12 0   1     0   5   59 69 *                     128.0 102 8 12 0   1     0   5   59 69                 128
1374088 1374088 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 2020   grade_9 113 16 21 4   1     0   7   98 63 *                     162.0 113 16 21 4   1     0   7   98 63                 162
1374169 1374169 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 2020   grade_9 141 9 7 1   1     1   13   100 73 *                     173.0 141 9 7 1   1     1   13   100 73                 173
1672321 1672321 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_9 221 34 74 1   9     0   16   194 160 *                     355.0 221 34 74 1   9     0   16   194 160                 355
1673303 1673303 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_9 84 1 4 3   2     0   4   49 49 *                     98.0 84 1 4 3   2     0   4   49 49                 98
1674473 1674473 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_9 158 15 13 0   2     0   11   102 97 *                     199.0 158 15 13 0   2     0   11   102 97                 199
1676051 1676051 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee - Mashpee High   Regular School No High 09 12 2021   grade_9 72 3 2 6   3     0   9   56 39 *                     95.0 72 3 2 6   3     0   9   56 39                 95
1677700 1677700 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich - Sandwich High   Regular School No High 09 12 2021   grade_9 144 0 1 0   2     0   3   71 78 *                     150.0 144 0 1 0   2     0   3   71 78                 150
1680173 1680173 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District) - Sturgis Charter Public School   Regular School Yes High 09 12 2021   grade_9 188 4 9 0   1     1   8   79 132 *                     211.0 188 4 9 0   1     1   8   79 132                 211
1680520 1680520 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth - Dennis-Yarmouth Regional High   Regular School No High 08 12 2021   grade_9 89 14 26 3   4     0   12   67 81 *                     148.0 89 14 26 3   4     0   12   67 81                 148
1680585 1680585 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset - Nauset Regional High   Regular School No High 09 12 2021   grade_9 162 9 12 0   5     0   4   85 107 *                     192.0 162 9 12 0   5     0   4   85 107                 192
1680830 1680830 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District - Monomoy Regional High School   Regular School No High 08 12 2021   grade_9 88 8 11 0   1     0   4   57 55 *                     112.0 88 8 11 0   1     0   4   57 55                 112
1681336 1681336 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical - Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 128 14 16 4   1     1   10   103 70 *                     174.0 128 14 16 4   1     1   10   103 70                 174
1681417 1681417 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Regional Vocational Technical - Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 164 4 15 2   1     0   18   112 92 *                     204.0 164 4 15 2   1     0   18   112 92                 204
2040123 2040123 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_9 246 35 39 1   6     0   14   177 164                       341.0 246 35 39 1   6     0   14   177 164                 341
2041126 2041126 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2019   grade_9 103 3 7 2   2     0   1   54 64                       118.0 103 3 7 2   2     0   1   54 64                 118
2042309 2042309 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2019   grade_9 185 15 10 5   5     0   20   123 117                       240.0 185 15 10 5   5     0   20   123 117                 240
2043872 2043872 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_9 86 7 5 5   3     1   8   65 50                       115.0 86 7 5 5   3     1   8   65 50                 115
2045523 2045523 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2019   grade_9 149 0 1 2   4     0   1   79 78                       157.0 149 0 1 2   4     0   1   79 78                 157
2047980 2047980 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2019   grade_9 198 6 16 1   2     0   0   104 119                       223.0 198 6 16 1   2     0   0   104 119                 223
2048317 2048317 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_9 127 22 27 3   3     0   11   92 101                       193.0 127 22 27 3   3     0   11   92 101                 193
2048382 2048382 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2019   grade_9 185 9 7 0   3     1   8   106 106                       213.0 185 9 7 0   3     1   8   106 106                 213
2048628 2048628 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2019   grade_9 106 5 12 2   3     1   6   66 69                       135.0 106 5 12 2   3     1   6   66 69                 135
2049162 2049162 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 2019   grade_9 107 12 21 3   1     1   7   101 51                       152.0 107 12 21 3   1     1   7   101 51                 152
2049245 2049245 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 2019   grade_9 155 5 6 2   4     0   12   115 69                       184.0 155 5 6 2   4     0   12   115 69                 184
2229132 2229132 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_9 262 31 57 1   4     1   13   200 169                       369.0 262 31 57 1   4     1   13   200 169                 369
2230297 2230297 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne: Bourne High School   Regular School No High 09 12 2018   grade_9 114 2 7 0   2     0   4   59 70                       129.0 114 2 7 0   2     0   4   59 70                 129
2231689 2231689 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth: Falmouth High   Regular School No High 09 12 2018   grade_9 188 9 6 3   6     0   19   105 126                       231.0 188 9 6 3   6     0   19   105 126                 231
2233565 2233565 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee: Mashpee High   Regular School No High 09 12 2018   grade_9 99 7 7 8   5     0   3   64 65                       129.0 99 7 7 8   5     0   3   64 65                 129
2235525 2235525 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich: Sandwich High   Regular School No High 09 12 2018   grade_9 146 0 2 3   5     1   0   68 89                       157.0 146 0 2 3   5     1   0   68 89                 157
2238442 2238442 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District): Sturgis Charter Public School   Regular School Yes High 09 12 2018   grade_9 183 5 7 0   11     0   9   97 118                       215.0 183 5 7 0   11     0   9   97 118                 215
2238835 2238835 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_9 132 16 19 6   4     1   11   109 80                       189.0 132 16 19 6   4     1   11   109 80                 189
2238912 2238912 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset: Nauset Regional High   Regular School No High 09 12 2018   grade_9 195 14 11 0   7     0   9   97 139                       236.0 195 14 11 0   7     0   9   97 139                 236
2239202 2239202 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District: Monomoy Regional High School   Regular School No High 08 12 2018   grade_9 94 9 4 0   0     0   5   52 60                       112.0 94 9 4 0   0     0   5   52 60                 112
2239807 2239807 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical: Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 110 13 12 2   0     0   7   94 50                       144.0 110 13 12 2   0     0   7   94 50                 144
2239907 2239907 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Regional Vocational Technical: Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 160 9 6 2   3     0   10   126 64                       190.0 160 9 6 2   3     0   10   126 64                 190
739036 739036 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2015   grade_9 50 0 3 0   0     0   1   28 26                       54 50 0 3 0   0     0   1   28 26                 54
739064 739064 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_9 56 0 3 0   4     0   1   33 31                       64 56 0 3 0   4     0   1   33 31                 64
740453 740453 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_9 65 2 5 0   0     0   6   37 41                       78 65 2 5 0   0     0   6   37 41                 78
740948 740948 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2015   grade_9 146 32 24 0   4     0   15   120 101                       221 146 32 24 0   4     0   15   120 101                 221
740952 740952 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2015   grade_9 145 18 15 0   2     0   13   91 102                       193 145 18 15 0   2     0   13   91 102                 193
743443 743443 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_9 43 7 4 0   2     1   0   22 35                       57 43 7 4 0   2     1   0   22 35                 57
743987 743987 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_9 73 4 1 0   0     0   1   38 41                       79 73 4 1 0   0     0   1   38 41                 79
744077 744077 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2015   grade_9 110 0 8 0   4     0   3   63 62                       125 110 0 8 0   4     0   3   63 62                 125
744173 744173 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No 3 09 12 2015   grade_9 115 2 3 0   1     0   4   57 68                       125 115 2 3 0   1     0   4   57 68                 125
744517 744517 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2015   grade_9 85 2 2 0   0     0   2   40 51                       91 85 2 2 0   0     0   2   40 51                 91
744804 744804 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2015   grade_9 47 0 3 0   0     0   0   25 25                       50 47 0 3 0   0     0   0   25 25                 50
745085 745085 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 115 1 2 1   0     0   3   75 47                       122 115 1 2 1   0     0   3   75 47                 122
935885 935885 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2016   grade_9 54 0 4 0   4     0   3   36 29                       65 54 0 4 0   4     0   3   36 29                 65
935913 935913 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_9 40 0 6 1   0     0   2   20 29                       49 40 0 6 1   0     0   2   20 29                 49
937288 937288 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2016   grade_9 76 3 8 0   0     0   7   36 58                       94 76 3 8 0   0     0   7   36 58                 94
937776 937776 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2016   grade_9 161 25 25 0   5     0   17   117 116                       233 161 25 25 0   5     0   17   117 116                 233
937780 937780 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2016   grade_9 118 29 13 0   2     0   14   103 73                       176 118 29 13 0   2     0   14   103 73                 176
940264 940264 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2016   grade_9 40 12 7 0   2     0   3   31 33                       64 40 12 7 0   2     0   3   31 33                 64
940820 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
940911 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
941000 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
941341 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
941629 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

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