enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,038 ✖
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
735970 735970 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_6 275 28 35 3   5     2   15   209 154                       363 275 28 35 3   5     2   15   209 154                 363
736976 736976 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_6 156 3 5 1   5     0   12   101 81                       182 156 3 5 1   5     0   12   101 81                 182
738150 738150 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_6 242 10 8 4   6     0   20   141 149                       290 242 10 8 4   6     0   20   141 149                 290
739730 739730 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_6 125 5 5 8   4     0   2   67 82                       149 125 5 5 8   4     0   2   67 82                 149
741042 741042 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_6 9 0 3 0   0     0   3   9 6                       15 9 0 3 0   0     0   3   9 6                 15
741396 741396 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   grade_6 62 1 0 0   5     0   0   39 29                       68 62 1 0 0   5     0   0   39 29                 68
741403 741403 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   grade_6 83 1 1 1   1     0   0   44 43                       87 83 1 1 1   1     0   0   44 43                 87
741410 741410 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   grade_6 75 0 1 2   2     0   1   40 41                       81 75 0 1 2   2     0   1   40 41                 81
743518 743518 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2015   grade_6 72 0 5 0   1     0   2   30 50                       80 72 0 5 0   1     0   2   30 50                 80
744198 744198 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2015   grade_6 163 17 19 9   4     0   14   123 103                       226 163 17 19 9   4     0   14   123 103                 226
744259 744259 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_6 152 3 8 0   3     0   3   72 97                       169 152 3 8 0   3     0   3   72 97                 169
744507 744507 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2015   grade_6 117 7 5 1   0     0   5   60 75                       135 117 7 5 1   0     0   5   60 75                 135
932844 932844 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_6 290 34 27 2   8     0   16   190 187                       377 290 34 27 2   8     0   16   190 187                 377
933841 933841 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_6 172 4 1 2   6     0   2   90 97                       187 172 4 1 2   6     0   2   90 97                 187
935004 935004 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2016   grade_6 239 13 16 3   6     0   19   160 136                       296 239 13 16 3   6     0   19   160 136                 296
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
937871 937871 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   grade_6 4 2 3 0   0     0   0   4 5                       9 4 2 3 0   0     0   0   4 5                 9
938217 938217 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 03 06 2016   grade_6 212 3 2 2   5     0   1   122 103                       225 212 3 2 2   5     0   1   122 103                 225
939111 939111 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   grade_6 8 1 0 0   0     0   0   6 3                       9 8 1 0 0   0     0   0   6 3                 9
940339 940339 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_6 70 1 4 0   0     0   5   32 48                       80 70 1 4 0   0     0   5   32 48                 80
941024 941024 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2016   grade_6 163 28 27 5   3     0   11   119 118                       237 163 28 27 5   3     0   11   119 118                 237
941086 941086 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2016   grade_6 152 3 6 0   2     1   5   94 75                       169 152 3 6 0   2     1   5   94 75                 169
941331 941331 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2016   grade_6 113 2 10 2   3     1   7   71 67                       138 113 2 10 2   3     1   7   71 67                 138
1122322 1122322 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2017   grade_6 261 26 39 2   5     0   24   167 190                       357 261 26 39 2   5     0   24   167 190                 357
1123475 1123475 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_6 157 1 2 2   5     0   7   76 98                       174 157 1 2 2   5     0   7   76 98                 174
1124857 1124857 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2017   grade_6 263 18 14 1   5     1   14   152 164                       316 263 18 14 1   5     1   14   152 164                 316
1126742 1126742 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_6 106 5 2 13   5     0   6   60 77                       137 106 5 2 13   5     0   6   60 77                 137
1128278 1128278 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_6 6 3 4 0   0     0   1   9 5                       14 6 3 4 0   0     0   1   9 5                 14
1128698 1128698 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_6 223 1 1 4   6     0   1   118 118                       236 223 1 1 4   6     0   1   118 118                 236
1129766 1129766 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_6 8 0 1 0   0     0   0   3 6                       9 8 0 1 0   0     0   0   3 6                 9
1131238 1131238 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   grade_6 71 1 2 0   2     0   4   39 41                       80 71 1 2 0   2     0   4   39 41                 80
1131999 1131999 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2017   grade_6 153 17 10 3   5     0   6   101 93                       194 153 17 10 3   5     0   6   101 93                 194
1132002 1132002 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_6 * * * *   *     *   *   1 3                       *                         1 3                  
1132077 1132077 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   grade_6 138 9 4 0   4     0   4   76 83                       159 138 9 4 0   4     0   4   76 83                 159
1132367 1132367 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_6 117 7 8 0   1     0   9   63 79                       142 117 7 8 0   1     0   9   63 79                 142
1365094 1365094 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_6 242 24 78 4   8     1   18   202 173 *                     375.0 242 24 78 4   8     1   18   202 173                 375
1366064 1366064 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_6 149 5 8 4   4     0   4   80 94 *                     174.0 149 5 8 4   4     0   4   80 94                 174
1367236 1367236 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_6 217 9 15 11   4     0   24   148 132 *                     280.0 217 9 15 11   4     0   24   148 132                 280
1368800 1368800 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_6 97 6 4 8   2     0   6   63 60 *                     123.0 97 6 4 8   2     0   6   63 60                 123
1370097 1370097 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_6 10 2 2 0   0     0   3   9 8 *                     17.0 10 2 2 0   0     0   3   9 8                 17
1370446 1370446 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_6 187 4 3 2   5     0   2   101 102 *                     203.0 187 4 3 2   5     0   2   101 102                 203
1371352 1371352 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1372577 1372577 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_6 71 1 4 0   2     0   3   42 39 *                     81.0 71 1 4 0   2     0   3   42 39                 81
1373252 1373252 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_6 133 29 44 7   4     1   12   119 111 *                     230.0 133 29 44 7   4     1   12   119 111                 230
1373317 1373317 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_6 154 7 14 0   5     0   5   95 89 *                     185.0 154 7 14 0   5     0   5   95 89                 185
1373564 1373564 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_6 102 8 9 2   2     0   13   65 71 *                     136.0 102 8 9 2   2     0   13   65 71                 136
1672318 1672318 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_6 221 33 70 2   7     0   25   190 168 *                     358.0 221 33 70 2   7     0   25   190 168                 358
1673300 1673300 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_6 124 2 6 0   1     0   5   68 70 *                     138.0 124 2 6 0   1     0   5   68 70                 138
1674470 1674470 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth - Morse Pond School   Regular School No Middle 05 06 2021   grade_6 207 14 12 1   4     0   10   120 128 *                     248.0 207 14 12 1   4     0   10   120 128                 248
1676050 1676050 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_6 84 4 9 7   2     0   13   58 61 *                     119.0 84 4 9 7   2     0   13   58 61                 119
1677345 1677345 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_6 6 5 2 0   0     0   3   5 11 *                     16.0 6 5 2 0   0     0   3   5 11                 16
1677697 1677697 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich - Oak Ridge   Regular School No Elementary 03 06 2021   grade_6 163 4 4 1   4     0   3   91 88 *                     179.0 163 4 4 1   4     0   3   91 88                 179
1679840 1679840 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District) - Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2021   grade_6 80 0 2 0   0     0   2   48 36 *                     84.0 80 0 2 0   0     0   2   48 36                 84
1680516 1680516 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_6 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1680517 1680517 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth - Mattacheese Middle School   Regular School No Middle 06 07 2021   grade_6 129 16 22 6   2     0   24   99 100 *                     199.0 129 16 22 6   2     0   24   99 100                 199
1680582 1680582 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_6 147 6 13 0   2     0   6   87 87 *                     174.0 147 6 13 0   2     0   6   87 87                 174
1680827 1680827 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District - Monomoy Regional Middle School   Regular School No Middle 05 07 2021   grade_6 130 6 10 1   0     1   10   69 89 *                     158.0 130 6 10 1   0     1   10   69 89                 158
2040120 2040120 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2019   grade_6 288 31 56 0   10     2   12   201 198                       399.0 288 31 56 0   10     2   12   201 198                 399
2041123 2041123 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_6 136 2 11 2   2     0   9   94 68                       162.0 136 2 11 2   2     0   9   94 68                 162
2042306 2042306 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2019   grade_6 210 16 15 2   10     0   16   136 133                       269.0 210 16 15 2   10     0   16   136 133                 269
2043871 2043871 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_6 106 4 5 9   4     0   12   68 72                       140.0 106 4 5 9   4     0   12   68 72                 140
2045171 2045171 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_6 2 6 1 0   0     0   0   3 6                       9.0 2 6 1 0   0     0   0   3 6                 9
2045520 2045520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2019   grade_6 194 4 3 1   2     0   4   107 101                       208.0 194 4 3 1   2     0   4   107 101                 208
2047649 2047649 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_6 71 1 4 1   2     0   2   34 47                       81.0 71 1 4 1   2     0   2   34 47                 81
2048314 2048314 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2019   grade_6 160 19 32 6   6     0   12   119 116                       235.0 160 19 32 6   6     0   12   119 116                 235
2048379 2048379 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2019   grade_6 164 9 12 1   3     0   3   94 98                       192.0 164 9 12 1   3     0   3   94 98                 192
2048625 2048625 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2019   grade_6 146 14 14 0   2     1   4   97 84                       181.0 146 14 14 0   2     1   4   97 84                 181
2229128 2229128 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable: Barnstable Intermediate School   Regular School No Middle 06 07 2018   grade_6 263 30 58 0   9     0   18   206 172                       378.0 263 30 58 0   9     0   18   206 172                 378
2230293 2230293 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_6 156 2 10 1   1     0   3   86 87                       173.0 156 2 10 1   1     0   3   86 87                 173
2231684 2231684 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth: Morse Pond School   Regular School No Middle 05 06 2018   grade_6 221 20 17 2   2     1   15   139 139                       278.0 221 20 17 2   2     1   15   139 139                 278
2233563 2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
2235099 2235099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_6 5 3 1 0   0     0   1   6 4                       10.0 5 3 1 0   0     0   1   6 4                 10
2235520 2235520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_6 216 0 4 0   2     0   1   102 121                       223.0 216 0 4 0   2     0   1   102 121                 223
2238069 2238069 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District): Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2018   grade_6 70 1 3 0   1     0   5   40 40                       80.0 70 1 3 0   1     0   5   40 40                 80
2238830 2238830 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_6 150 18 34 5   4     0   14   107 118                       225.0 150 18 34 5   4     0   14   107 118                 225
2238908 2238908 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset: Nauset Regional Middle   Regular School No Middle 06 08 2018   grade_6 152 8 13 0   5     0   7   88 97                       185.0 152 8 13 0   5     0   7   88 97                 185
2239198 2239198 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   grade_6 100 12 13 1   1     1   4   68 64                       132.0 100 12 13 1   1     1   4   68 64                 132
737606 737606 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_6 17 0 1 0   0     0   0   7 11                       18 17 0 1 0   0     0   0   7 11                 18
738210 738210 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_6 6 0 0 0   0     0   0   1 5                       6 6 0 0 0   0     0   0   1 5                 6
738519 738519 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
738886 738886 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   1     0   2   14 23                       37 34 0 0 0   1     0   2   14 23                 37
739033 739033 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_6 54 0 3 0   1     0   0   25 33                       58 54 0 3 0   1     0   0   25 33                 58
739061 739061 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_6 44 1 4 0   9     0   1   31 28                       59 44 1 4 0   9     0   1   31 28                 59
740433 740433 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_6 27 0 0 0   0     0   4   17 14                       31 27 0 0 0   0     0   4   17 14                 31
740441 740441 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_6 20 1 2 0   1     0   1   15 10                       25 20 1 2 0   1     0   1   15 10                 25
740450 740450 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_6 38 2 2 0   0     1   3   23 23                       46 38 2 2 0   0     1   3   23 23                 46
740942 740942 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2015   grade_6 123 19 26 0   0     0   13   87 94                       181 123 19 26 0   0     0   13   87 94                 181
740945 740945 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2015   grade_6 155 21 23 1   6     0   7   114 99                       213 155 21 23 1   6     0   7   114 99                 213
741275 741275 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_6 8 1 1 0   0     0   0   1 9                       10 8 1 1 0   0     0   0   1 9                 10
742949 742949 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2015   grade_6 48 1 6 0   3     0   7   37 28                       65 48 1 6 0   3     0   7   37 28                 65
743440 743440 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_6 51 17 1 0   0     0   3   39 33                       72 51 17 1 0   0     0   3   39 33                 72
743984 743984 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_6 90 5 0 0   1     0   0   56 40                       96 90 5 0 0   1     0   0   56 40                 96
744074 744074 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_6 78 1 7 0   3     2   3   46 48                       94 78 1 7 0   3     2   3   46 48                 94
744170 744170 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2015   grade_6 135 1 4 1   2     0   5   75 73                       148 135 1 4 1   2     0   5   75 73                 148
744274 744274 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_6 16 1 0 0   0     0   1   11 7                       18 16 1 0 0   0     0   1   11 7                 18
744801 744801 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2015   grade_6 38 2 3 0   0     0   5   25 23                       48 38 2 3 0   0     0   5   25 23                 48
934466 934466 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_6 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
935064 935064 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_6 9 0 0 0   0     0   0   5 4                       9 9 0 0 0   0     0   0   5 4                 9
935369 935369 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 2                       4                         2 2                 4
935735 935735 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2016   grade_6 29 0 0 0   0     0   0   12 17                       29 29 0 0 0   0     0   0   12 17                 29

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