enrollments

Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by asian_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,737 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2048097 2048097 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_9 246 9 22 0   154     0   29   227 233                       460.0 246 9 22 0   154     0   29   227 233                 460
1680289 1680289 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough - Acton-Boxborough Regional High   Regular School No High 09 12 2021   grade_9 206 8 27 1   149     0   15   221 185 *                     406.0 206 8 27 1   149     0   15   221 185                 406
2238574 2238574 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough: Acton-Boxborough Regional High   Regular School No High 09 12 2018   grade_9 240 9 11 1   145     0   21   225 202                       427.0 240 9 11 1   145     0   21   225 202                 427
2230167 2230167 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_9 201 32 50 2   140     2   16   205 238                       443.0 201 32 50 2   140     2   16   205 238                 443
1131737 1131737 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_9 270 9 12 1   138     0   18   224 224                       448 270 9 12 1   138     0   18   224 224                 448
1677856 1677856 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury - Shrewsbury Sr High   Regular School No High 09 12 2021   grade_9 241 21 40 2   138     0   17   222 237 *                     459.0 241 21 40 2   138     0   17   222 237                 459
1365982 1365982 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_9 191 41 65 0   130     2   23   211 239 *                     452.0 191 41 65 0   130     2   23   211 239                 452
2041026 2041026 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_9 166 34 53 0   129     0   25   175 232                       407.0 166 34 53 0   129     0   25   175 232                 407
2235714 2235714 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury: Shrewsbury Sr High   Regular School No High 09 12 2018   grade_9 258 13 32 2   129     0   17   209 241                       451.0 258 13 32 2   129     0   17   209 241                 451
2045680 2045680 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2019   grade_9 270 7 39 1   126     0   17   211 248                       460.0 270 7 39 1   126     0   17   211 248                 460
1123362 1123362 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2017   grade_9 194 32 55 1   125     0   17   187 237                       424 194 32 55 1   125     0   17   187 237                 424
1371790 1371790 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2020   grade_9 292 3 4 0   124     0   8   234 197 *                     431.0 292 3 4 0   124     0   8   234 197                 431
1128893 1128893 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2017   grade_9 320 10 47 2   121     0   13   257 256                       513 320 10 47 2   121     0   13   257 256                 513
1370605 1370605 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2020   grade_9 278 18 35 2   120     0   14   213 254 *                     467.0 278 18 35 2   120     0   14   213 254                 467
1679042 1679042 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford - Westford Academy   Regular School No High 09 12 2021   grade_9 244 4 7 0   118     0   11   188 196 *                     384.0 244 4 7 0   118     0   11   188 196                 384
739606 739606 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_9 133 97 138 2   117     0   15   274 228                       502 133 97 138 2   117     0   15   274 228                 502
933740 933740 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2016   grade_9 218 30 40 0   117     0   15   187 233                       420 218 30 40 0   117     0   15   187 233                 420
743967 743967 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_9 294 7 13 2   115     0   26   229 228                       457 294 7 13 2   115     0   26   229 228                 457
1681360 1681360 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 2021   grade_9 197 39 221 1   115     0   23   268 324 4                     596.0 197 39 221 1   115     0   23   268 324 4               596
2044551 2044551 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_9 277 29 28 0   113     0   32   252 226                       479.0 277 29 28 0   113     0   32   252 226                 479
936451 936451 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2016   grade_9 152 101 123 4   112     0   12   265 239                       504 152 101 123 4   112     0   12   265 239                 504
1369478 1369478 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2020   grade_9 310 13 27 0   112     0   32   238 255 *                     494.0 310 13 27 0   112     0   32   238 255                 494
736876 736876 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_9 185 59 78 0   111     0   15   193 255                       448 185 59 78 0   111     0   15   193 255                 448
2046863 2046863 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2019   grade_9 261 6 5 1   109     1   14   203 194                       397.0 261 6 5 1   109     1   14   203 194                 397
1368681 1368681 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   grade_9 119 98 146 1   108     0   15   241 246 *                     487.0 119 98 146 1   108     0   15   241 246                 487
1374112 1374112 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_9 240 30 229 0   108     0   0   329 275 3                     607.0 240 30 229 0   108     0   0   329 275 3               607
2233414 2233414 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden: Malden High   Regular School No High 09 12 2018   grade_9 131 87 127 2   108     0   17   278 193                       472.0 131 87 127 2   108     0   17   278 193                 472
2043747 2043747 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   grade_9 120 113 146 2   107     0   14   255 247                       502.0 120 113 146 2   107     0   14   255 247                 502
2234368 2234368 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton: Newton South High   Regular School No High 09 12 2018   grade_9 299 22 34 0   105     0   25   244 239                       485.0 299 22 34 0   105     0   25   244 239                 485
2237120 2237120 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford: Westford Academy   Regular School No High 09 12 2018   grade_9 310 4 9 0   104     0   20   224 223                       447.0 310 4 9 0   104     0   20   224 223                 447
1675922 1675922 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden - Malden High   Regular School No High 09 12 2021   grade_9 110 81 127 0   103     0   13   228 205 *                     434.0 110 81 127 0   103     0   13   228 205                 434
745068 745068 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 256 12 173 2   102     0   14   315 244                       559 256 12 173 2   102     0   14   315 244                 559
1126593 1126593 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_9 137 98 121 2   100     0   15   257 216                       473 137 98 121 2   100     0   15   257 216                 473
2228925 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 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
1673219 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
939559 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 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
2049188 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
1123812 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
1676727 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
1130305 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
1678938 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
2046762 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
938377 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
2044546 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
2235203 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
1127546 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
2230626 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
1133022 1133022 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_9 246 21 196 1   89     0   21   305 269                       574 246 21 196 1   89     0   21   305 269                 574
740414 740414 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_9 299 16 24 0   87     0   18   212 232                       444 299 16 24 0   87     0   18   212 232                 444
1370184 1370184 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2020   grade_9 195 47 40 1   87     1   13   197 187 *                     384.0 195 47 40 1   87     1   13   197 187                 384
742753 742753 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No 3 09 12 2015   grade_9 296 4 3 0   86     0   10   188 211                       399 296 4 3 0   86     0   10   188 211                 399
1673575 1673575 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_9 256 32 79 0   86     0   56   268 240 *                     509.0 256 32 79 0   86     0   56   268 240                 509
2230142 2230142 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_9 102 74 100 1   86     1   8   157 215                       372.0 102 74 100 1   86     1   8   157 215                 372
1370568 1370568 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2020   grade_9 150 16 20 0   85     1   16   139 149 *                     288.0 150 16 20 0   85     1   16   139 149                 288
2045258 2045258 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2019   grade_9 198 45 31 0   85     1   15   186 189                       375.0 198 45 31 0   85     1   15   186 189                 375
937250 937250 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2016   grade_9 304 25 19 1   84     0   15   232 216                       448 304 25 19 1   84     0   15   232 216                 448
1364925 1364925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_9 321 8 27 3   84     0   12   208 247 *                     455.0 321 8 27 3   84     0   12   208 247                 455
2039952 2039952 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_9 293 8 32 1   84     0   8   206 219                       426.0 293 8 32 1   84     0   8   206 219                 426
1128382 1128382 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2017   grade_9 216 47 22 0   83     1   12   199 181                       381 216 47 22 0   83     1   12   199 181                 381
2236978 2236978 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough: Westborough High   Regular School No High 09 12 2018   grade_9 206 7 17 0   83     1   10   175 149                       324.0 206 7 17 0   83     1   10   175 149                 324
740409 740409 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_9 368 25 44 0   81     2   19   275 264                       539 368 25 44 0   81     2   19   275 264                 539
937245 937245 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2016   grade_9 349 20 47 2   81     0   23   260 262                       522 349 20 47 2   81     0   23   260 262                 522
1366342 1366342 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_9 281 48 54 0   81     0   57   253 268 0                     521.0 281 48 54 0   81     0   57   253 268 0               521
2235667 2235667 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon: Sharon High   Regular School No High 09 12 2018   grade_9 162 12 13 0   81     1   7   152 124                       276.0 162 12 13 0   81     1   7   152 124                 276
1371688 1371688 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2020   grade_9 154 1 20 0   80     0   11   136 130 *                     266.0 154 1 20 0   80     0   11   136 130                 266
2045643 2045643 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2019   grade_9 185 10 19 1   80     0   13   162 146                       308.0 185 10 19 1   80     0   13   162 146                 308
1677432 1677432 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy - Quincy High   Regular School No High 09 12 2021   grade_9 167 32 44 0   79     2   11   169 165 *                     335.0 167 32 44 0   79     2   11   169 165                 335
2041189 2041189 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   grade_9 294 13 19 0   79     2   7   205 209                       414.0 294 13 19 0   79     2   7   205 209                 414
1672148 1672148 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_9 285 19 42 0   78     0   13   209 226 *                     437.0 285 19 42 0   78     0   13   209 226                 437
1677819 1677819 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon - Sharon High   Regular School No High 09 12 2021   grade_9 155 14 15 1   78     0   14   150 127 *                     277.0 155 14 15 1   78     0   14   150 127                 277
1365996 1365996 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2020   grade_9 43 108 140 0   77     0   6   153 221 *                     374.0 43 108 140 0   77     0   6   153 221                 374
1676722 1676722 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_9 319 24 63 0   77     0   32   261 253 *                     515.0 319 24 63 0   77     0   32   261 253                 515
2230372 2230372 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree: Braintree High   Regular School No High 09 12 2018   grade_9 300 23 17 0   76     0   6   207 215                       422.0 300 23 17 0   76     0   6   207 215                 422
2041412 2041412 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_9 326 29 65 0   75     1   58   296 255                       554.0 326 29 65 0   75     1   58   296 255                 554
736856 736856 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_9 90 97 68 1   73     1   6   144 192                       336 90 97 68 1   73     1   6   144 192                 336

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