enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by multiracial_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
1369328 1369328 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2020   grade_6 120 59 143 2   3     0   34   202 159 *                     361.0 120 59 143 2   3     0   34   202 159                 361
1672196 1672196 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Arlington - Gibbs School   Regular School No Middle 06 06 2021   grade_6 334 21 31 2   60     1   34   260 223 *                     483.0 334 21 31 2   60     1   34   260 223                 483
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
1364973 1364973 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2020   grade_6 356 20 40 0   40     0   30   255 231 *                     486.0 356 20 40 0   40     0   30   255 231                 486
2040000 2040000 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2019   grade_6 321 15 34 1   61     1   30   250 213                       463.0 321 15 34 1   61     1   30   250 213                 463
2043289 2043289 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_6 131 6 12 0   134     0   30   148 165                       313.0 131 6 12 0   134     0   30   148 165                 313
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
2047121 2047121 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_6 245 3 11 1   63     0   30   178 175                       353.0 245 3 11 1   63     0   30   178 175                 353
1372047 1372047 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2020   grade_6 285 5 10 0   75     0   29   218 186 *                     404.0 285 5 10 0   75     0   29   218 186                 404
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
1130123 1130123 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_6 291 9 18 0   46     0   28   215 177                       392 291 9 18 0   46     0   28   215 177                 392
1677816 1677816 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon - Sharon Middle   Regular School No Middle 06 08 2021   grade_6 136 16 19 1   91     1   28   143 148 *                     292.0 136 16 19 1   91     1   28   143 148                 292
2046729 2046729 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2019   grade_6 264 22 15 0   65     0   28   180 213                       394.0 264 22 15 0   65     0   28   180 213                 394
1122175 1122175 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_6 306 21 22 0   45     0   27   188 233                       421 306 21 22 0   45     0   27   188 233                 421
1365176 1365176 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2020   grade_6 225 12 23 1   96     1   27   193 192 *                     385.0 225 12 23 1   96     1   27   193 192                 385
1674684 1674684 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_6 119 4 39 1   1     0   27   109 82 *                     191.0 119 4 39 1   1     0   27   109 82                 191
1676716 1676716 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton - F A Day Middle   Regular School No Middle 06 08 2021   grade_6 205 18 32 1   50     2   27   171 164 *                     335.0 205 18 32 1   50     2   27   171 164                 335
1678440 1678440 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury - Ephraim Curtis Middle   Regular School No Middle 06 08 2021   grade_6 196 7 14 0   33     1   27   159 119 *                     278.0 196 7 14 0   33     1   27   159 119                 278
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
1368205 1368205 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2020   grade_6 118 13 9 0   134     0   26   148 152 *                     300.0 118 13 9 0   134     0   26   148 152                 300
1371656 1371656 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2020   grade_6 287 16 20 0   59     0   26   190 218 *                     408.0 287 16 20 0   59     0   26   190 218                 408
1674424 1674424 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River - Matthew J Kuss Middle   Regular School No Middle 06 08 2021   grade_6 121 22 59 0   9     0   26   124 113 *                     237.0 121 22 59 0   9     0   26   124 113                 237
2040202 2040202 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_6 229 14 18 0   77     0   26   191 173                       364.0 229 14 18 0   77     0   26   191 173                 364
742603 742603 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2015   grade_6 320 14 21 0   43     0   25   227 196                       423 320 14 21 0   43     0   25   227 196                 423
1367187 1367187 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_6 81 14 60 1   6     0   25   97 90 *                     187.0 81 14 60 1   6     0   25   97 90                 187
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
1677242 1677242 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield - John T Reid Middle   Regular School No Middle 06 08 2021   grade_6 100 22 34 1   2     0   25   96 88 *                     184.0 100 22 34 1   2     0   25   96 88                 184
1678906 1678906 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley - Wellesley Middle   Regular School No Middle 06 08 2021   grade_6 219 11 24 0   58     0   25   168 169 *                     337.0 219 11 24 0   58     0   25   168 169                 337
2229229 2229229 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont: Winthrop L Chenery Middle   Regular School No Middle 05 08 2018   grade_6 246 13 24 1   52     0   25   178 183                       361.0 246 13 24 1   52     0   25   178 183                 361
2232876 2232876 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington: Wm Diamond Middle   Regular School No Middle 06 08 2018   grade_6 123 13 11 0   93     0   25   128 137                       265.0 123 13 11 0   93     0   25   128 137                 265
2234040 2234040 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 Needham: High Rock School   Regular School No Middle 06 06 2018   grade_6 339 11 30 0   45     0   25   221 229                       450.0 339 11 30 0   45     0   25   221 229                 450
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
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
1127222 1127222 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2017   grade_6 331 8 28 0   30     0   24   200 221                       421 331 8 28 0   30     0   24   200 221                 421
1127533 1127533 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2017   grade_6 203 19 21 1   41     0   24   171 138                       309 203 19 21 1   41     0   24   171 138                 309
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
1369467 1369467 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2020   grade_6 195 19 24 1   67     0   24   164 166 *                     330.0 195 19 24 1   67     0   24   164 166                 330
1371953 1371953 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_6 323 24 58 1   33     0   24   236 227 *                     463.0 323 24 58 1   33     0   24   236 227                 463
1672398 1672398 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_6 251 8 8 0   74     0   24   184 181 *                     365.0 251 8 8 0   74     0   24   184 181                 365
1675450 1675450 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_6 127 13 12 0   113     0   24   152 137 *                     289.0 127 13 12 0   113     0   24   152 137                 289
1676577 1676577 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_6 128 59 135 0   1     0   24   181 166 *                     347.0 128 59 135 0   1     0   24   181 166                 347
1677855 1677855 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury - Sherwood Middle School   Regular School No Middle 05 06 2021   grade_6 240 13 53 2   159     0   24   236 255 *                     491.0 240 13 53 2   159     0   24   236 255                 491
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
2044271 2044271 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2019   grade_6 359 9 28 0   30     0   24   224 226                       450.0 359 9 28 0   30     0   24   224 226                 450
2044401 2044401 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_6 127 56 149 1   6     1   24   198 166                       364.0 127 56 149 1   6     1   24   198 166                 364
2048243 2048243 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2019   grade_6 247 14 4 1   4     2   24   136 160                       296.0 247 14 4 1   4     2   24   136 160                 296
939726 939726 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_6 389 30 33 0   22     1   23   267 231                       498 389 30 33 0   22     1   23   267 231                 498
1367193 1367193 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_6 145 18 57 0   13     0   23   122 134 *                     256.0 145 18 57 0   13     0   23   122 134                 256
1678784 1678784 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham - Wareham Middle   Regular School No Middle 05 07 2021   grade_6 115 22 17 1   1     1   23   99 81 *                     180.0 115 22 17 1   1     1   23   99 81                 180
2042262 2042262 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_6 127 19 47 1   6     1   23   107 117                       224.0 127 19 47 1   6     1   23   107 117                 224
2232872 2232872 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington: Jonas Clarke Middle   Regular School No Middle 06 08 2018   grade_6 124 16 15 0   125     0   23   150 153                       303.0 124 16 15 0   125     0   23   150 153                 303
932725 932725 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2016   grade_6 302 17 18 0   50     0   22   193 216                       409 302 17 18 0   50     0   22   193 216                 409
937239 937239 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No 2 06 08 2016   grade_6 190 21 23 1   51     0   22   171 137                       308 190 21 23 1   51     0   22   171 137                 308
1128159 1128159 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   grade_6 109 22 25 0   3     1   22   96 86                       182 109 22 25 0   3     1   22   96 86                 182
1674418 1674418 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River - Talbot Innovation School   Regular School No Middle 06 08 2021   grade_6 70 14 71 1   6     0   22   84 100 *                     184.0 70 14 71 1   6     0   22   84 100                 184
2042265 2042265 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2019   grade_6 139 18 64 0   11     0   22   111 143                       254.0 139 18 64 0   11     0   22   111 143                 254
2046216 2046216 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_6 154 57 32 0   8     4   22   126 151                       277.0 154 57 32 0   8     4   22   126 151                 277
2228981 2228981 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_6 328 11 28 0   52     1   22   204 238                       442.0 328 11 28 0   52     1   22   204 238                 442
2236376 2236376 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury: Ephraim Curtis Middle   Regular School No Middle 06 08 2018   grade_6 240 12 11 0   23     0   22   149 159                       308.0 240 12 11 0   23     0   22   149 159                 308
736057 736057 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_6 229 12 12 0   57     0   21   164 167                       331 229 12 12 0   57     0   21   164 167                 331
935212 935212 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 05 07 2016   grade_6 128 6 29 1   3     0   21   102 86                       188 128 6 29 1   3     0   21   102 86                 188
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
939412 939412 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2016   grade_6 279 17 18 0   27     0   21   177 185                       362 279 17 18 0   27     0   21   177 185                 362
1126060 1126060 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_6 150 9 8 0   117     0   21   148 157                       305 150 9 8 0   117     0   21   148 157                 305
1128163 1128163 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_6 129 23 29 0   3     0   21   108 97                       205 129 23 29 0   3     0   21   108 97                 205
1369083 1369083 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2020   grade_6 243 45 19 0   23     0   21   182 169 *                     351.0 243 45 19 0   23     0   21   182 169                 351
1369997 1369997 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_6 108 17 28 1   2     0   21   98 79 *                     177.0 108 17 28 1   2     0   21   98 79                 177
1370604 1370604 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2020   grade_6 257 10 43 2   171     0   21   253 251 *                     504.0 257 10 43 2   171     0   21   253 251                 504
1673969 1673969 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_6 159 9 15 0   11     0   21   114 101 *                     215.0 159 9 15 0   11     0   21   114 101                 215
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
936006 936006 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_6 143 13 4 0   91     0   20   128 143                       271 143 13 4 0   91     0   20   128 143                 271
937242 937242 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No 2 06 08 2016   grade_6 110 10 12 0   40     0   20   89 103                       192 110 10 12 0   40     0   20   89 103                 192
937770 937770 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2016   grade_6 137 18 25 1   0     0   20   93 108                       201 137 18 25 1   0     0   20   93 108                 201
939441 939441 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2016   grade_6 177 3 22 0   86     0   20   155 153                       308 177 3 22 0   86     0   20   155 153                 308
939826 939826 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2016   grade_6 264 0 14 1   63     1   20   181 182                       363 264 0 14 1   63     1   20   181 182                 363
1127529 1127529 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_6 158 6 11 0   46     0   20   118 123                       241 158 6 11 0   46     0   20   118 123                 241
1366503 1366503 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_6 205 29 10 1   24     2   20   145 146 *                     291.0 205 29 10 1   24     2   20   145 146                 291
1369200 1369200 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2020   grade_6 396 14 43 0   26     0   20   245 254 *                     499.0 396 14 43 0   26     0   20   245 254                 499
1674040 1674040 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth - Dartmouth Middle   Regular School No Middle 06 08 2021   grade_6 241 4 16 0   3     0   20   148 136 *                     284.0 241 4 16 0   3     0   20   148 136                 284
1675447 1675447 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_6 115 11 11 1   120     0   20   150 128 *                     278.0 115 11 11 1   120     0   20   150 128                 278
2044407 2044407 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_6 116 47 139 0   0     0   20   162 160                       322.0 116 47 139 0   0     0   20   162 160                 322
2234195 2234195 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford: Normandin Middle School   Regular School No Middle 06 08 2018   grade_6 242 25 144 2   7     0   20   228 212                       440.0 242 25 144 2   7     0   20   228 212                 440
741017 741017 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2015   grade_6 269 7 11 1   5     0   19   150 162                       312 269 7 11 1   5     0   19   150 162                 312
932926 932926 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2016   grade_6 245 9 15 0   53     0   19   171 170                       341 245 9 15 0   53     0   19   171 170                 341
934587 934587 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2016   grade_6 287 4 8 0   1     0   19   160 159                       319 287 4 8 0   1     0   19   160 159                 319
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
1122421 1122421 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_6 233 15 11 0   62     1   19   171 170                       341 233 15 11 0   62     1   19   171 170                 341
1125107 1125107 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   grade_6 108 2 25 0   4     0   19   72 86                       158 108 2 25 0   4     0   19   72 86                 158
1368583 1368583 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_6 43 57 350 1   27     0   19   255 242 *                     497.0 43 57 350 1   27     0   19   255 242                 497
1368586 1368586 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_6 36 48 359 1   54     0   19   260 257 *                     517.0 36 48 359 1   54     0   19   260 257                 517
1369547 1369547 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_6 141 7 36 0   4     0   19   101 105 *                     207.0 141 7 36 0   4     0   19   101 105                 207
1370565 1370565 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2020   grade_6 148 14 17 0   99     0   19   156 141 *                     297.0 148 14 17 0   99     0   19   156 141                 297
1676243 1676243 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough - John T. Nichols Middle   Regular School No Middle 06 08 2021   grade_6 192 7 5 1   2     0   19   125 101 *                     226.0 192 7 5 1   2     0   19   125 101                 226
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
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
2042521 2042521 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_6 131 3 48 0   5     0   19   107 99                       206.0 131 3 48 0   5     0   19   107 99                 206
2046257 2046257 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2019   grade_6 256 13 17 0   29     1   19   157 178                       335.0 256 13 17 0   29     1   19   157 178                 335
2231173 2231173 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth: Dartmouth Middle   Regular School No Middle 06 08 2018   grade_6 282 4 14 0   0     0   19   176 143                       319.0 282 4 14 0   0     0   19   176 143                 319
2233305 2233305 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_6 49 45 316 0   41     0   19   265 205                       470.0 49 45 316 0   41     0   19   265 205                 470
2234191 2234191 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_6 138 53 112 1   5     1   19   168 161                       329.0 138 53 112 1   5     1   19   168 161                 329

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