Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

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
938351 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No 1 KG 01 2016   kindergarten 103 5 21 2   99     0   6   126 110                       236 103 5 21 2   99     0   6   126 110                 236
941889 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 247 12 169 2   99     0   13   307 235                       542 247 12 169 2   99     0   13   307 235                 542
1126058 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_8 133 13 10 1   99     0   15   129 142                       271 133 13 10 1   99     0   15   129 142                 271
1364927 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_11 313 8 25 0   99     0   10   202 252 *                     455.0 313 8 25 0   99     0   10   202 252                 455
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
936453 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2016   grade_11 113 95 90 2   98     1   20   201 218                       419 113 95 90 2   98     1   20   201 218                 419
2228925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_9 333 10 21 0   98     0   10   209 262                       472.0 333 10 21 0   98     0   10   209 262                 472
2239837 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 277 29 195 1   98     0   20   335 285                       620.0 277 29 195 1   98     0   20   335 285                 620
1368682 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   grade_10 103 103 133 4   98     0   13   225 229 *                     454.0 103 103 133 4   98     0   13   225 229                 454
1678936 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Westborough - Sarah W Gibbons Middle   Regular School No Middle 07 08 2021   grade_7 153 15 14 0   98     0   9   134 155 *                     289.0 153 15 14 0   98     0   9   134 155                 289
936008 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_8 123 13 5 1   97     0   14   130 123                       253 123 13 5 1   97     0   14   130 123                 253
1130306 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2017   grade_10 337 3 5 0   97     0   13   243 212                       455 337 3 5 0   97     0   13   243 212                 455
1370602 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 104 9 11 2   97     0   7   131 99 *                     230.0 104 9 11 2   97     0   7   131 99                 230
1672151 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_12 304 9 25 0   97     0   11   196 249 *                     446.0 304 9 25 0   97     0   11   196 249                 446
1673219 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_9 197 38 72 0   97     0   20   209 215 *                     424.0 197 38 72 0   97     0   20   209 215                 424
1678934 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough - Mill Pond School   Regular School No Middle 04 06 2021   grade_5 162 5 16 0   97     0   7   154 133 *                     287.0 162 5 16 0   97     0   7   154 133                 287
939559 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No 3 09 12 2016   grade_9 341 4 6 0   96     0   10   246 211                       457 341 4 6 0   96     0   10   246 211                 457
941888 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 227 21 190 3   96     0   25   327 235                       562 227 21 190 3   96     0   25   327 235                 562
1128894 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2017   grade_10 282 7 33 0   96     1   9   186 242                       428 282 7 33 0   96     1   9   186 242                 428
2039953 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_10 324 9 21 0   96     0   10   209 250                       460.0 324 9 21 0   96     0   10   209 250                 460
2044553 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_11 313 31 30 0   96     0   20   261 229                       490.0 313 31 30 0   96     0   20   261 229                 490
2045654 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   kindergarten 87 8 18 4   96     0   8   122 99                       221.0 87 8 18 4   96     0   8   122 99                 221
2045664 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_4 72 6 11 2   96     0   10   99 98                       197.0 72 6 11 2   96     0   10   99 98                 197
2049188 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 210 31 230 2   96     0   29   300 295                       598.0 210 31 230 2   96     0   29   300 295                 598
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
1370168 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_8 74 9 4 0   96     2   8   105 88 *                     193.0 74 9 4 0   96     2   8   105 88                 193
1371683 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Middle 04 06 2020   grade_4 161 5 15 0   96     0   7   152 132 *                     284.0 161 5 15 0   96     0   7   152 132                 284
1374113 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 208 29 221 2   96     0   28   287 294 3                     584.0 208 29 221 2   96     0   28   287 294 3               584
1677435 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy - Quincy High   Regular School No High 09 12 2021   grade_12 201 37 48 3   96     1   12   190 208 *                     398.0 201 37 48 3   96     1   12   190 208                 398
936004 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2016   grade_7 130 14 10 1   95     0   14   130 134                       264 130 14 10 1   95     0   14   130 134                 264
938361 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_4 91 10 15 1   95     0   7   113 106                       219 91 10 15 1   95     0   7   113 106                 219
1123812 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_9 272 38 47 0   95     0   48   266 234                       500 272 38 47 0   95     0   48   266 234                 500
1126061 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_7 150 13 4 0   95     0   19   129 152                       281 150 13 4 0   95     0   19   129 152                 281
1128869 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_2 65 5 13 2   95     0   10   98 92                       190 65 5 13 2   95     0   10   98 92                 190
2235680 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Shrewsbury: Beal School   Regular School No Elementary KG 01 2018   kindergarten 108 11 22 5   95     0   13   128 126                       254.0 108 11 22 5   95     0   13   128 126                 254
2235692 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_4 93 2 16 1   95     0   8   106 109                       215.0 93 2 16 1   95     0   8   106 109                 215
2235709 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Shrewsbury: Parker Road Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 101 8 19 2   95     0   10   118 117                       235.0 101 8 19 2   95     0   10   118 117                 235
1370187 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2020   grade_12 196 43 24 0   95     1   9   189 179 *                     368.0 196 43 24 0   95     1   9   189 179                 368
739161 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_7 128 14 6 0   94     0   15   128 129                       257 128 14 6 0   94     0   15   128 129                 257
1133024 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_11 243 14 162 2   94     0   14   305 224                       529 243 14 162 2   94     0   14   305 224                 529
2233114 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell: Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2018   grade_6 21 6 50 0   94     0   4   86 89                       175.0 21 6 50 0   94     0   4   86 89                 175
2234371 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton: Newton South High   Regular School No High 09 12 2018   grade_12 307 19 28 0   94     0   19   233 234                       467.0 307 19 28 0   94     0   19   233 234                 467
1676727 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_9 252 17 25 1   94     1   23   219 194 *                     413.0 252 17 25 1   94     1   23   219 194                 413
739596 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No 1 PK PK 2015   pre_kindergarten 138 57 18 0   93     2   9   175 142                       317 138 57 18 0   93     2   9   175 142                 317
740417 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_12 290 18 26 0   93     3   14   209 235                       444 290 18 26 0   93     3   14   209 235                 444
741555 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_3 94 9 12 1   93     0   8   112 105                       217 94 9 12 1   93     0   8   112 105                 217
741563 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2015   grade_8 337 4 31 0   93     1   12   247 231                       478 337 4 31 0   93     1   12   247 231                 478
937252 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2016   grade_11 280 26 37 0   93     0   21   229 228                       457 280 26 37 0   93     0   21   229 228                 457
937942 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2016   grade_8 50 2 3 0   93     0   1   79 70                       149 50 2 3 0   93     0   1   79 70                 149
1128870 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_3 96 1 11 1   93     0   7   100 109                       209 96 1 11 1   93     0   7   100 109                 209
1130305 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2017   grade_9 317 2 5 0   93     0   13   228 202                       430 317 2 5 0   93     0   13   228 202                 430
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
2235190 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy: Central Middle   Regular School No Middle 06 08 2018   grade_7 105 6 7 0   93     0   5   109 107                       216.0 105 6 7 0   93     0   5   109 107                 216
2235204 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy: Quincy High   Regular School No High 09 12 2018   grade_10 210 47 22 0   93     2   10   195 189                       384.0 210 47 22 0   93     2   10   195 189                 384
2235691 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_3 71 7 11 2   93     0   8   103 89                       192.0 71 7 11 2   93     0   8   103 89                 192
2046762 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2019   grade_9 169 3 28 0   93     0   15   146 162                       308.0 169 3 28 0   93     0   15   146 162                 308
1677838 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_2 57 6 10 5   93     0   9   93 87 *                     180.0 57 6 10 5   93     0   9   93 87                 180
1678938 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough - Westborough High   Regular School No High 09 12 2021   grade_9 167 7 19 0   93     1   11   145 153 *                     298.0 167 7 19 0   93     1   11   145 153                 298
739159 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2015   grade_8 170 8 11 0   92     0   13   158 136                       294 170 8 11 0   92     0   13   158 136                 294
938377 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No 3 09 12 2016   grade_9 276 5 29 0   92     1   10   177 236                       413 276 5 29 0   92     1   10   177 236                 413
1127548 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2017   grade_11 297 20 31 0   92     0   19   224 235                       459 297 20 31 0   92     0   19   224 235                 459
1130160 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2017   grade_7 180 4 21 0   92     0   18   157 158                       315 180 4 21 0   92     0   18   157 158                 315
2235203 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy: Quincy High   Regular School No High 09 12 2018   grade_9 225 40 24 1   92     1   14   203 194                       397.0 225 40 24 1   92     1   14   203 194                 397
2236976 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Westborough: Sarah W Gibbons Middle   Regular School No Middle 07 08 2018   grade_8 183 5 22 0   92     0   16   155 163                       318.0 183 5 22 0   92     0   16   155 163                 318
2239840 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_12 236 12 157 2   92     0   14   294 219                       513.0 236 12 157 2   92     0   14   294 219                 513
2041024 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_7 195 34 71 0   92     0   18   202 208                       410.0 195 34 71 0   92     0   18   202 208                 410
2044546 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_9 328 32 52 2   92     0   35   283 258                       541.0 328 32 52 2   92     0   35   283 258                 541
2045241 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_7 73 7 4 0   92     2   9   100 87                       187.0 73 7 4 0   92     2   9   100 87                 187
2045248 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_8 106 8 7 0   92     0   5   113 105                       218.0 106 8 7 0   92     0   5   113 105                 218
2046760 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2019   grade_7 180 4 25 0   92     1   10   153 159                       312.0 180 4 25 0   92     1   10   153 159                 312
1365981 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_8 194 32 69 0   92     0   17   197 207 *                     404.0 194 32 69 0   92     0   17   197 207                 404
1369481 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2020   grade_12 313 34 31 0   92     0   21   262 229 *                     491.0 313 34 31 0   92     0   21   262 229                 491
1371687 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2020   grade_8 182 4 25 0   92     1   12   160 156 *                     316.0 182 4 25 0   92     1   12   160 156                 316
1672399 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_7 211 13 20 1   92     2   28   189 178 *                     367.0 211 13 20 1   92     2   28   189 178                 367
740415 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_10 281 26 33 0   91     0   23   227 227                       454 281 26 33 0   91     0   23   227 227                 454
933744 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2016   grade_6 6 18 24 1   91     0   4   73 71                       144 6 18 24 1   91     0   4   73 71                 144
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
1127549 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2017   grade_12 276 28 34 0   91     0   22   226 225                       451 276 28 34 0   91     0   22   226 225                 451
1130157 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Elementary 04 06 2017   grade_5 178 3 19 0   91     1   10   153 149                       302 178 3 19 0   91     1   10   153 149                 302
2234369 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton: Newton South High   Regular School No High 09 12 2018   grade_10 314 31 29 0   91     0   23   265 223                       488.0 314 31 29 0   91     0   23   265 223                 488
2235181 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Quincy: Atlantic Middle   Regular School No Middle 06 08 2018   grade_6 73 6 4 0   91     1   9   100 84                       184.0 73 6 4 0   91     1   9   100 84                 184
2235716 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury: Shrewsbury Sr High   Regular School No High 09 12 2018   grade_11 285 9 34 0   91     1   9   191 237                       429.0 285 9 34 0   91     1   9   191 237                 429
2236973 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough: Mill Pond School   Regular School No Middle 04 06 2018   grade_6 182 4 21 0   91     1   10   154 155                       309.0 182 4 21 0   91     1   10   154 155                 309
2044554 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_12 286 29 23 1   91     0   16   224 221                       446.0 286 29 23 1   91     0   16   224 221                 446
2045260 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2019   grade_11 208 48 27 0   91     2   13   191 198                       389.0 208 48 27 0   91     2   13   191 198                 389
2045683 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2019   grade_12 286 13 29 0   91     1   8   189 238                       428.0 286 13 29 0   91     1   8   189 238                 428
2049189 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 263 24 188 1   91     0   19   316 270                       586.0 263 24 188 1   91     0   19   316 270                 586
1371689 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2020   grade_10 168 2 26 0   91     0   15   147 155 *                     302.0 168 2 26 0   91     0   15   147 155                 302
1676724 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_11 316 31 60 0   91     0   40   279 259 *                     538.0 316 31 60 0   91     0   40   279 259                 538
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
741117 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_6 121 6 6 0   90     1   6   117 113                       230 121 6 6 0   90     1   6   117 113                 230
741569 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No 1 PK PK 2015   pre_kindergarten 113 5 13 2   90     0   11   126 108                       234 113 5 13 2   90     0   11   126 108                 234
937946 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_6 108 5 5 0   90     2   5   120 95                       215 108 5 5 0   90     2   5   120 95                 215
1126295 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2017   grade_5 21 6 45 0   90     0   4   85 81                       166 21 6 45 0   90     0   4   85 81                 166
1127546 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2017   grade_9 312 32 27 0   90     0   22   256 227                       483 312 32 27 0   90     0   22   256 227                 483
1128370 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_8 112 6 6 0   90     1   6   117 104                       221 112 6 6 0   90     1   6   117 104                 221
1133023 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 235 22 193 3   90     0   24   332 235                       567 235 22 193 3   90     0   24   332 235                 567
2230626 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline: Brookline High   Regular School No High 09 12 2018   grade_9 288 40 68 0   90     1   44   252 278                       531.0 288 40 68 0   90     1   44   252 278                 531
2235191 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy: Central Middle   Regular School No Middle 06 08 2018   grade_8 103 5 7 0   90     1   6   116 96                       212.0 103 5 7 0   90     1   6   116 96                 212
2237122 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford: Westford Academy   Regular School No High 09 12 2018   grade_11 331 3 5 0   90     0   14   235 208                       443.0 331 3 5 0   90     0   14   235 208                 443

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