enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2044092 2044092 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_6 193 9 107 14   5     0   13   185 156                       341.0 193 9 107 14   5     0   13   185 156                 341
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
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
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
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
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
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
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
1369021 1369021 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2020   grade_6 197 12 100 8   8     0   12   181 156 *                     337.0 197 12 100 8   8     0   12   181 156                 337
2233828 2233828 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford: Stacy Middle   Regular School No Middle 06 08 2018   grade_6 212 7 80 8   9     0   10   180 146                       326.0 212 7 80 8   9     0   10   180 146                 326
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
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
1676269 1676269 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_6 204 9 86 7   4     1   19   175 155 *                     330.0 204 9 86 7   4     1   19   175 155                 330
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
739953 739953 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 07 2015   grade_6 208 8 72 6   5     0   11   162 148                       310 208 8 72 6   5     0   11   162 148                 310
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
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
936356 936356 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_6 52 37 259 5   37     0   15   213 192                       405 52 37 259 5   37     0   15   213 192                 405
936359 936359 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_6 67 46 254 5   59     0   17   225 223                       448 67 46 254 5   59     0   17   225 223                 448
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
1131111 1131111 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_6 26 16 120 5   2     2   0   79 92                       171 26 16 120 5   2     2   0   79 92                 171
1677730 1677730 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus - Saugus Middle School   Regular School No Middle 06 08 2021   grade_6 109 10 58 5   9     1   8   101 99 *                     200.0 109 10 58 5   9     1   8   101 99                 200
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
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
740269 740269 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_6 191 27 96 4   2     2   10   183 149                       332 191 27 96 4   2     2   10   183 149                 332
741224 741224 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2015   grade_6 93 10 87 4   13     0   3   114 96                       210 93 10 87 4   13     0   3   114 96                 210
1126978 1126978 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_6 211 5 10 4   6     0   9   111 134                       245 211 5 10 4   6     0   9   111 134                 245
1127011 1127011 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_6 228 9 92 4   12     0   11   178 178                       356 228 9 92 4   12     0   11   178 178                 356
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
1364987 1364987 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_6 150 4 32 4   30     0   9   118 111 *                     229.0 150 4 32 4   30     0   9   118 111                 229
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
1674245 1674245 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_6 32 3 14 4   1     0   1   26 29 *                     55.0 32 3 14 4   1     0   1   26 29                 55
2233795 2233795 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough: John T. Nichols Middle   Regular School No Middle 06 08 2018   grade_6 219 7 8 4   7     0   11   140 116                       256.0 219 7 8 4   7     0   11   140 116                 256
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
741717 741717 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2015   grade_6 76 1 92 3   2     0   2   91 85                       176 76 1 92 3   2     0   2   91 85                 176
742477 742477 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_6 149 11 13 3   1     0   17   102 92                       194 149 11 13 3   1     0   17   102 92                 194
742792 742792 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Middle   Regular School No 2 06 08 2015   grade_6 124 1 2 3   1     0   3   80 54                       134 124 1 2 3   1     0   3   80 54                 134
934153 934153 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2016   grade_6 202 17 13 3   32     0   12   154 125                       279 202 17 13 3   32     0   12   154 125                 279
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
936797 936797 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_6 202 8 69 3   6     0   10   165 133                       298 202 8 69 3   6     0   10   165 133                 298
939284 939284 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2016   grade_6 152 15 7 3   1     0   18   96 100                       196 152 15 7 3   1     0   18   96 100                 196
940236 940236 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_6 12 11 143 3   2     0   0   83 88                       171 12 11 143 3   2     0   0   83 88                 171
1124624 1124624 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_6 7 12 32 3   2     0   2   31 27                       58 7 12 32 3   2     0   2   31 27                 58
1127376 1127376 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_6 205 32 132 3   6     0   28   211 195                       406 205 32 132 3   6     0   28   211 195                 406
1130718 1130718 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_6 112 12 9 3   10     0   2   66 82                       148 112 12 9 3   10     0   2   66 82                 148
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
1132959 1132959 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2017   grade_6 165 10 9 3   1     1   7   112 84                       196 165 10 9 3   1     1   7   112 84                 196
1366235 1366235 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_6 55 100 30 3   10     0   5   117 86 *                     203.0 55 100 30 3   10     0   5   117 86                 203
1368589 1368589 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_6 76 12 106 3   19     0   9   113 112 *                     225.0 76 12 106 3   19     0   9   113 112                 225
1371532 1371532 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2020   grade_6 128 15 11 3   2     0   31   87 103 *                     190.0 128 15 11 3   2     0   31   87 103                 190
1672210 1672210 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_6 158 7 27 3   29     0   5   115 114 *                     229.0 158 7 27 3   29     0   5   115 114                 229
1674337 1674337 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_6 133 4 9 3   2     0   9   78 82 *                     160.0 133 4 9 3   2     0   9   78 82                 160
1676085 1676085 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield - Thomas Blake Middle   Regular School No Middle 06 08 2021   grade_6 162 2 11 3   8     0   5   113 78 *                     191.0 162 2 11 3   8     0   5   113 78                 191
1676580 1676580 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford - Normandin Middle School   Regular School No Middle 06 08 2021   grade_6 176 28 117 3   2     0   19   171 174 *                     345.0 176 28 117 3   2     0   19   171 174                 345
1678549 1678549 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton - Benjamin Friedman Middle   Regular School No Middle 05 07 2021   grade_6 164 36 41 3   3     0   9   123 133 *                     256.0 164 36 41 3   3     0   9   123 133                 256
2041302 2041302 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2019   grade_6 59 162 25 3   9     1   6   151 114                       265.0 59 162 25 3   9     1   6   151 114                 265
2042578 2042578 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_6 175 3 19 3   3     0   1   87 117                       204.0 175 3 19 3   3     0   1   87 117                 204
2044066 2044066 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_6 233 11 9 3   1     0   8   137 128                       265.0 233 11 9 3   1     0   8   137 128                 265
2044404 2044404 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2019   grade_6 179 38 150 3   2     0   30   218 184                       402.0 179 38 150 3   2     0   30   218 184                 402
736467 736467 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   grade_6 39 2 6 2   5     0   3   28 29                       57 39 2 6 2   5     0   3   28 29                 57
737161 737161 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2015   grade_6 65 85 60 2   7     0   12   110 121                       231 65 85 60 2   7     0   12   110 121                 231
737398 737398 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2015   grade_6 38 23 5 2   16     0   8   59 33                       92 38 23 5 2   16     0   8   59 33                 92
737938 737938 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_6 34 1 2 2   0     0   0   17 22                       39 34 1 2 2   0     0   0   17 22                 39
738025 738025 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_6 124 2 8 2   5     0   2   77 66                       143 124 2 8 2   5     0   2   77 66                 143
738418 738418 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_6 161 0 20 2   0     2   3   88 100                       188 161 0 20 2   0     2   3   88 100                 188
738699 738699 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2015   grade_6 199 1 5 2   14     0   5   117 109                       226 199 1 5 2   14     0   5   117 109                 226
738828 738828 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No 2 05 07 2015   grade_6 190 4 11 2   3     0   2   108 104                       212 190 4 11 2   3     0   2   108 104                 212
739387 739387 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_6 111 0 4 2   0     0   1   71 47                       118 111 0 4 2   0     0   1   71 47                 118
740266 740266 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_6 128 48 95 2   4     2   24   159 144                       303 128 48 95 2   4     2   24   159 144                 303
740597 740597 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2015   grade_6 193 3 14 2   24     0   11   129 118                       247 193 3 14 2   24     0   11   129 118                 247
741111 741111 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2015   grade_6 67 6 6 2   79     0   3   77 86                       163 67 6 6 2   79     0   3   77 86                 163
741121 741121 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No 2 05 08 2015   grade_6 31 13 12 2   21     0   2   50 31                       81 31 13 12 2   21     0   2   50 31                 81
741253 741253 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No 2 06 08 2015   grade_6 62 9 90 2   15     0   3   81 100                       181 62 9 90 2   15     0   3   81 100                 181
741256 741256 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No 2 06 08 2015   grade_6 75 7 94 2   4     0   6   82 106                       188 75 7 94 2   4     0   6   82 106                 188
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
741571 741571 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2015   grade_6 288 11 30 2   122     0   16   237 232                       469 288 11 30 2   122     0   16   237 232                 469
742514 742514 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2015   grade_6 141 7 40 2   25     0   6   113 108                       221 141 7 40 2   25     0   6   113 108                 221
742747 742747 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2015   grade_6 137 2 1 2   46     0   6   86 108                       194 137 2 1 2   46     0   6   86 108                 194
742920 742920 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_6 369 31 31 2   20     0   17   237 233                       470 369 31 31 2   20     0   17   237 233                 470
743739 743739 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2015   grade_6 2 43 42 2   0     0   1   50 40                       90 2 43 42 2   0     0   1   50 40                 90
743820 743820 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2015   grade_6 29 4 21 2   5     0   0   27 34                       61 29 4 21 2   5     0   0   27 34                 61
744060 744060 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2015   grade_6 104 7 11 2   6     0   11   70 71                       141 104 7 11 2   6     0   11   70 71                 141
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
933609 933609 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_6 1 68 28 2   2     0   1   57 45                       102 1 68 28 2   2     0   1   57 45                 102
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
933963 933963 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_6 15 73 13 2   0     0   2   52 53                       105 15 73 13 2   0     0   2   52 53                 105
934255 934255 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2016   grade_6 38 24 6 2   13     0   8   52 39                       91 38 24 6 2   13     0   8   52 39                 91
934491 934491 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_6 128 4 3 2   3     0   2   77 65                       142 128 4 3 2   3     0   2   77 65                 142
934856 934856 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_6 14 20 64 2   1     0   0   48 53                       101 14 20 64 2   1     0   0   48 53                 101
934961 934961 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2016   grade_6 157 15 51 2   9     0   16   112 138                       250 157 15 51 2   9     0   16   112 138                 250
935083 935083 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2016   grade_6 188 5 10 2   4     0   3   111 101                       212 188 5 10 2   4     0   3   111 101                 212
936362 936362 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2016   grade_6 87 15 77 2   16     0   14   107 104                       211 87 15 77 2   16     0   14   107 104                 211
936978 936978 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No 2 06 06 2016   grade_6 360 11 13 2   39     0   26   218 233                       451 360 11 13 2   39     0   26   218 233                 451
937104 937104 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2016   grade_6 132 43 94 2   4     0   21   169 127                       296 132 43 94 2   4     0   21   169 127                 296
937233 937233 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2016   grade_6 118 8 13 2   26     0   12   84 95                       179 118 8 13 2   26     0   12   84 95                 179
937394 937394 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2016   grade_6 317 5 15 2   22     1   8   190 180                       370 317 5 15 2   22     1   8   190 180                 370
937593 937593 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2016   grade_6 117 2 11 2   1     2   5   58 82                       140 117 2 11 2   1     2   5   58 82                 140
938052 938052 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2016   grade_6 81 8 76 2   6     0   10   99 84                       183 81 8 76 2   6     0   10   99 84                 183
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

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