enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by asian_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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
739360 739360 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_9 277 84 226 1   289     0   12   466 423                       889 277 84 226 1   289     0   12   466 423                 889
936208 936208 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_10 244 82 185 1   269     0   12   417 376                       793 244 82 185 1   269     0   12   417 376                 793
1368208 1368208 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2020   grade_9 268 14 23 0   269     0   33   312 294 *                     607.0 268 14 23 0   269     0   33   312 294                 607
1126302 1126302 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_11 247 80 175 1   267     0   14   399 385                       784 247 80 175 1   267     0   14   399 385                 784
1675454 1675454 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_10 257 15 25 0   267     0   35   305 293 *                     599.0 257 15 25 0   267     0   35   305 293                 599
936207 936207 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_9 253 96 223 0   259     0   24   432 423                       855 253 96 223 0   259     0   24   432 423                 855
2233118 2233118 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_9 214 80 242 1   256     0   29   409 413                       822.0 214 80 242 1   256     0   29   409 413                 822
2233121 2233121 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_12 238 80 154 1   256     0   13   369 373                       742.0 238 80 154 1   256     0   13   369 373                 742
2043494 2043494 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_10 202 83 203 1   251     0   25   370 395                       765.0 202 83 203 1   251     0   25   370 395                 765
1126301 1126301 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_10 226 92 178 0   248     0   19   371 392                       763 226 92 178 0   248     0   19   371 392                 763
1675657 1675657 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_12 212 89 176 0   248     0   26   360 391 *                     751.0 212 89 176 0   248     0   26   360 391                 751
936209 936209 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_11 274 90 165 1   247     0   6   394 389                       783 274 90 165 1   247     0   6   394 389                 783
739361 739361 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_10 265 80 190 1   246     0   10   390 402                       792 265 80 190 1   246     0   10   390 402                 792
1368412 1368412 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_11 204 86 186 0   244     0   23   355 388 *                     743.0 204 86 186 0   244     0   23   355 388                 743
1126300 1126300 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_9 238 100 235 1   243     1   21   429 410                       839 238 100 235 1   243     1   21   429 410                 839
2233120 2233120 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_11 222 104 192 0   243     0   19   380 400                       780.0 222 104 192 0   243     0   19   380 400                 780
1126303 1126303 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_12 242 80 149 1   242     0   7   350 371                       721 242 80 149 1   242     0   7   350 371                 721
2043496 2043496 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_12 218 102 193 0   241     0   17   380 391                       771.0 218 102 193 0   241     0   17   380 391                 771
2233119 2233119 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_10 227 93 199 0   240     1   20   393 387                       780.0 227 93 199 0   240     1   20   393 387                 780
2232881 2232881 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington: Lexington High   Regular School No High 09 12 2018   grade_10 266 22 17 0   238     0   33   284 292                       576.0 266 22 17 0   238     0   33   284 292                 576
2043294 2043294 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_11 258 23 19 1   238     0   33   287 284                       572.0 258 23 19 1   238     0   33   287 284                 572
2043495 2043495 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_11 232 98 195 0   237     1   19   386 396                       782.0 232 98 195 0   237     1   19   386 396                 782
2043493 2043493 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_9 221 104 233 0   236     0   30   411 413                       824.0 221 104 233 0   236     0   30   411 413                 824
1126064 1126064 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_9 254 20 18 0   233     0   27   270 282                       552 254 20 18 0   233     0   27   270 282                 552
1368413 1368413 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_12 215 99 177 0   232     1   17   367 374 *                     741.0 215 99 177 0   232     1   17   367 374                 741
739362 739362 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_11 214 78 156 1   231     0   7   340 347                       687 214 78 156 1   231     0   7   340 347                 687
936210 936210 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_12 202 73 166 1   231     0   6   338 341                       679 202 73 166 1   231     0   6   338 341                 679
1368211 1368211 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2020   grade_12 250 19 20 0   231     0   31   273 277 *                     551.0 250 19 20 0   231     0   31   273 277                 551
1675453 1675453 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_9 224 25 27 0   231     0   43   261 288 *                     550.0 224 25 27 0   231     0   43   261 288                 550
1368209 1368209 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2020   grade_10 279 30 20 0   230     0   32   300 291 *                     591.0 279 30 20 0   230     0   32   300 291                 591
2043292 2043292 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_9 286 31 19 0   229     0   33   297 301                       598.0 286 31 19 0   229     0   33   297 301                 598
1368411 1368411 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_10 221 97 182 0   229     0   25   366 388 *                     754.0 221 97 182 0   229     0   25   366 388                 754
1675656 1675656 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_11 206 99 179 0   227     0   25   362 374 *                     736.0 206 99 179 0   227     0   25   362 374                 736
1675455 1675455 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_11 269 32 25 0   226     0   30   293 289 *                     582.0 269 32 25 0   226     0   30   293 289                 582
1675654 1675654 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_9 202 80 340 0   221     0   37   479 401 *                     880.0 202 80 340 0   221     0   37   479 401                 880
1675655 1675655 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_10 123 69 231 0   212     0   25   355 305 *                     660.0 123 69 231 0   212     0   25   355 305                 660
1368410 1368410 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_9 150 79 272 0   210     0   29   388 352 *                     740.0 150 79 272 0   210     0   29   388 352                 740
1368210 1368210 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2020   grade_11 248 14 26 2   203     0   33   262 264 *                     526.0 248 14 26 2   203     0   33   262 264                 526
1675456 1675456 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_12 252 14 25 2   203     0   34   260 270 *                     530.0 252 14 25 2   203     0   34   260 270                 530
739363 739363 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_12 203 83 154 1   199     0   5   321 324                       645 203 83 154 1   199     0   5   321 324                 645
2043293 2043293 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_10 269 15 24 2   199     0   33   264 278                       542.0 269 15 24 2   199     0   33   264 278                 542
2235211 2235211 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy: North Quincy High   Regular School No High 09 12 2018   grade_12 109 4 12 1   195     0   2   170 153                       323.0 109 4 12 1   195     0   2   170 153                 323
2043295 2043295 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_12 300 15 21 0   194     0   21   287 264                       551.0 300 15 21 0   194     0   21   287 264                 551
2232882 2232882 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington: Lexington High   Regular School No High 09 12 2018   grade_11 304 15 21 0   193     0   21   287 267                       554.0 304 15 21 0   193     0   21   287 267                 554
2045265 2045265 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2019   grade_12 125 12 5 1   193     0   6   180 162                       342.0 125 12 5 1   193     0   6   180 162                 342
1126065 1126065 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_10 305 14 22 0   192     0   22   279 276                       555 305 14 22 0   192     0   22   279 276                 555
2232880 2232880 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington: Lexington High   Regular School No High 09 12 2018   grade_9 267 17 20 2   191     0   33   260 270                       530.0 267 17 20 2   191     0   33   260 270                 530
1677438 1677438 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy - North Quincy High   Regular School No High 09 12 2021   grade_11 121 11 8 1   190     1   12   191 153 *                     344.0 121 11 8 1   190     1   12   191 153                 344
936011 936011 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2016   grade_11 274 22 17 0   189     0   18   257 263                       520 274 22 17 0   189     0   18   257 263                 520
1677854 1677854 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury - Sherwood Middle School   Regular School No Middle 05 06 2021   grade_5 212 17 42 1   185     0   16   236 237 *                     473.0 212 17 42 1   185     0   16   236 237                 473
936009 936009 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2016   grade_9 309 14 16 0   184     0   25   275 273                       548 309 14 16 0   184     0   25   275 273                 548
936010 936010 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2016   grade_10 310 18 26 0   184     0   24   298 264                       562 310 18 26 0   184     0   24   298 264                 562
1126066 1126066 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_11 307 20 22 0   184     0   24   293 264                       557 307 20 22 0   184     0   24   293 264                 557
1370189 1370189 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2020   grade_10 121 9 7 1   184     1   11   192 142 *                     334.0 121 9 7 1   184     1   11   192 142                 334
1126067 1126067 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_12 279 23 17 0   183     0   19   254 267                       521 279 23 17 0   183     0   19   254 267                 521
1128389 1128389 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_11 101 3 14 1   181     0   2   154 148                       302 101 3 14 1   181     0   2   154 148                 302
2232883 2232883 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington: Lexington High   Regular School No High 09 12 2018   grade_12 304 22 22 0   180     0   24   291 261                       552.0 304 22 22 0   180     0   24   291 261                 552
2235210 2235210 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy: North Quincy High   Regular School No High 09 12 2018   grade_11 120 11 3 1   179     0   6   163 157                       320.0 120 11 3 1   179     0   6   163 157                 320
2045262 2045262 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2019   grade_9 118 12 5 1   178     1   11   189 137                       326.0 118 12 5 1   178     1   11   189 137                 326
739164 739164 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_10 280 23 18 1   177     0   19   251 267                       518 280 23 18 1   177     0   19   251 267                 518
1677439 1677439 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy - North Quincy High   Regular School No High 09 12 2021   grade_12 107 14 15 1   177     0   2   165 151 *                     316.0 107 14 15 1   177     0   2   165 151                 316
1677437 1677437 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy - North Quincy High   Regular School No High 09 12 2021   grade_10 110 19 15 0   176     0   10   167 162 *                     330.0 110 19 15 0   176     0   10   167 162                 330
937962 937962 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2016   grade_10 99 6 14 1   174     0   2   152 144                       296 99 6 14 1   174     0   2   152 144                 296
2048096 2048096 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2019   grade_8 265 17 18 1   174     0   13   262 226                       488.0 265 17 18 1   174     0   13   262 226                 488
2238571 2238571 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough: Raymond J Grey Junior High   Regular School No Middle 07 08 2018   grade_7 273 14 15 0   173     0   11   257 229                       486.0 273 14 15 0   173     0   11   257 229                 486
1370190 1370190 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2020   grade_11 108 11 16 1   173     0   3   162 150 *                     312.0 108 11 16 1   173     0   3   162 150                 312
1677846 1677846 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Shrewsbury - Oak Middle School   Regular School No Middle 07 08 2021   grade_7 251 13 41 2   172     0   23   248 254 *                     502.0 251 13 41 2   172     0   23   248 254                 502
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
2045264 2045264 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2019   grade_11 92 8 10 0   170     0   1   145 136                       281.0 92 8 10 0   170     0   1   145 136                 281
1370191 1370191 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2020   grade_12 85 7 14 0   170     0   1   133 144 *                     277.0 85 7 14 0   170     0   1   133 144                 277
739163 739163 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_9 317 18 25 1   169     0   25   295 260                       555 317 18 25 1   169     0   25   295 260                 555
2045263 2045263 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2019   grade_10 106 10 13 1   169     0   3   160 142                       302.0 106 10 13 1   169     0   3   160 142                 302
1370188 1370188 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2020   grade_9 116 18 15 0   168     0   9   160 165 *                     326.0 116 18 15 0   168     0   9   160 165                 326
1128387 1128387 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_9 85 6 12 0   167     0   2   132 140                       272 85 6 12 0   167     0   2   132 140                 272
2235209 2235209 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy: North Quincy High   Regular School No High 09 12 2018   grade_10 96 8 13 0   167     0   1   137 148                       285.0 96 8 13 0   167     0   1   137 148                 285
1677436 1677436 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy - North Quincy High   Regular School No High 09 12 2021   grade_9 145 7 12 2   167     2   18   192 161 *                     353.0 145 7 12 2   167     2   18   192 161                 353
741135 741135 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2015   grade_12 111 14 6 2   166     0   0   141 158                       299 111 14 6 2   166     0   0   141 158                 299
937963 937963 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2016   grade_11 109 11 4 0   166     0   1   145 146                       291 109 11 4 0   166     0   1   145 146                 291
1128388 1128388 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_10 118 10 3 1   166     0   5   155 148                       303 118 10 3 1   166     0   5   155 148                 303
1128390 1128390 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2017   grade_12 104 9 5 0   166     0   1   144 140                       285 104 9 5 0   166     0   1   144 140                 285
1373025 1373025 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2020   grade_9 256 16 19 1   166     0   12   250 220 *                     470.0 256 16 19 1   166     0   12   250 220                 470
1680290 1680290 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough - Acton-Boxborough Regional High   Regular School No High 09 12 2021   grade_10 250 18 18 0   166     0   13   248 217 *                     465.0 250 18 18 0   166     0   13   248 217                 465
741134 741134 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2015   grade_11 126 10 17 1   164     1   2   168 153                       321 126 10 17 1   164     1   2   168 153                 321
937961 937961 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2016   grade_9 120 14 10 0   164     1   6   167 148                       315 120 14 10 0   164     1   6   167 148                 315
2045678 2045678 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2019   grade_5 254 10 40 1   164     0   21   246 244                       490.0 254 10 40 1   164     0   21   246 244                 490
1370603 1370603 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2020   grade_5 243 13 52 2   164     0   23   246 251 *                     497.0 243 13 52 2   164     0   23   246 251                 497
741132 741132 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2015   grade_9 102 7 14 1   162     0   2   151 137                       288 102 7 14 1   162     0   2   151 137                 288
739165 739165 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_11 301 27 19 0   161     0   23   270 261                       531 301 27 19 0   161     0   23   270 261                 531
936012 936012 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2016   grade_12 298 25 18 0   160     0   23   265 259                       524 298 25 18 0   160     0   23   265 259                 524
2238572 2238572 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough: Raymond J Grey Junior High   Regular School No Middle 07 08 2018   grade_8 266 8 19 0   159     0   26   242 236                       478.0 266 8 19 0   159     0   26   242 236                 478
2048100 2048100 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_12 294 9 21 0   159     0   17   271 229                       500.0 294 9 21 0   159     0   17   271 229                 500
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
1680288 1680288 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough - Raymond J Grey Junior High   Regular School No Middle 07 08 2021   grade_8 202 14 28 2   159     2   14   212 208 *                     421.0 202 14 28 2   159     2   14   212 208                 421
741133 741133 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2015   grade_10 109 9 5 0   157     0   1   143 138                       281 109 9 5 0   157     0   1   143 138                 281
743966 743966 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2015   grade_8 284 4 16 0   157     0   18   260 219                       479 284 4 16 0   157     0   18   260 219                 479
937964 937964 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2016   grade_12 118 8 14 0   157     1   1   142 157                       299 118 8 14 0   157     1   1   142 157                 299
2235208 2235208 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy: North Quincy High   Regular School No High 09 12 2018   grade_9 105 11 12 3   157     0   3   154 137                       291.0 105 11 12 3   157     0   3   154 137                 291
2238576 2238576 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough: Acton-Boxborough Regional High   Regular School No High 09 12 2018   grade_11 302 8 17 0   157     0   17   266 235                       501.0 302 8 17 0   157     0   17   266 235                 501
1677847 1677847 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Shrewsbury - Oak Middle School   Regular School No Middle 07 08 2021   grade_8 238 17 50 1   157     0   20   245 238 *                     483.0 238 17 50 1   157     0   20   245 238                 483
940800 940800 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2016   grade_9 298 5 15 0   154     0   16   260 228                       488 298 5 15 0   154     0   16   260 228                 488

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