enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by asian_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2045679 2045679 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No Middle 05 06 2019   grade_6 236 15 50 1   149     0   17   248 220                       468.0 236 15 50 1   149     0   17   248 220                 468
2048095 2048095 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2019   grade_7 231 10 25 2   149     0   18   239 196                       435.0 231 10 25 2   149     0   18   239 196                 435
2045670 2045670 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2019   grade_7 297 20 34 1   144     0   15   270 241                       511.0 297 20 34 1   144     0   15   270 241                 511
2048098 2048098 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_10 243 8 11 1   143     0   23   223 206                       429.0 243 8 11 1   143     0   23   223 206                 429
2048099 2048099 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_11 259 10 16 2   140     0   18   225 220                       445.0 259 10 16 2   140     0   18   225 220                 445
2041027 2041027 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_10 198 30 48 1   138     2   14   197 234                       431.0 198 30 48 1   138     2   14   197 234                 431
2043288 2043288 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_8 139 12 12 0   138     0   11   170 142                       312.0 139 12 12 0   138     0   11   170 142                 312
2043291 2043291 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_8 149 9 10 0   137     0   23   160 168                       328.0 149 9 10 0   137     0   23   160 168                 328
2043289 2043289 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_6 131 6 12 0   134     0   30   148 165                       313.0 131 6 12 0   134     0   30   148 165                 313
2045681 2045681 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2019   grade_10 250 13 33 2   130     0   18   209 236                       446.0 250 13 33 2   130     0   18   209 236                 446
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
2043286 2043286 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_6 144 11 12 0   128     0   11   147 159                       306.0 144 11 12 0   128     0   11   147 159                 306
2045671 2045671 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2019   grade_8 292 18 42 1   128     0   13   242 252                       494.0 292 18 42 1   128     0   13   242 252                 494
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
2041028 2041028 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_11 184 31 48 1   121     0   17   175 227                       402.0 184 31 48 1   121     0   17   175 227                 402
2043287 2043287 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_7 123 14 16 0   120     0   23   144 152                       296.0 123 14 16 0   120     0   23   144 152                 296
2045682 2045682 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No High 09 12 2019   grade_11 309 12 45 2   120     0   12   250 249                       500.0 309 12 45 2   120     0   12   250 249                 500
2046759 2046759 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Middle 04 06 2019   grade_6 175 2 17 0   120     0   7   152 169                       321.0 175 2 17 0   120     0   7   152 169                 321
2043737 2043737 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 112 50 25 0   115     0   17   194 125                       319.0 112 50 25 0   115     0   17   194 125                 319
2046757 2046757 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Middle 04 06 2019   grade_4 135 9 17 2   115     0   5   152 131                       283.0 135 9 17 2   115     0   5   152 131                 283
2041025 2041025 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_8 191 29 54 0   113     2   18   190 217                       407.0 191 29 54 0   113     2   18   190 217                 407
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
2044552 2044552 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_10 301 25 34 0   111     0   25   257 237                       496.0 301 25 34 0   111     0   25   257 237                 496
2045662 2045662 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_2 67 5 11 1   111     0   6   111 90                       201.0 67 5 11 1   111     0   6   111 90                 201
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
2045663 2045663 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_3 74 8 16 0   108     0   5   110 101                       211.0 74 8 16 0   108     0   5   110 101                 211
2046758 2046758 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Middle 04 06 2019   grade_5 164 12 15 0   108     0   9   143 165                       308.0 164 12 15 0   108     0   9   143 165                 308
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
2043749 2043749 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   grade_11 111 110 121 1   106     0   16   235 230                       465.0 111 110 121 1   106     0   16   235 230                 465
2045677 2045677 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 109 9 11 1   106     0   6   126 116                       242.0 109 9 11 1   106     0   6   126 116                 242
2041029 2041029 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_12 207 26 32 0   105     0   13   175 208                       383.0 207 26 32 0   105     0   13   175 208                 383
2043750 2043750 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   grade_12 119 89 100 0   105     1   11   195 230                       425.0 119 89 100 0   105     1   11   195 230                 425
2043748 2043748 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   grade_10 115 88 118 1   104     0   14   253 186                       440.0 115 88 118 1   104     0   14   253 186                 440
2046864 2046864 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2019   grade_10 306 4 10 0   104     0   20   227 217                       444.0 306 4 10 0   104     0   20   227 217                 444
2045240 2045240 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_6 71 3 8 0   101     0   3   95 91                       186.0 71 3 8 0   101     0   3   95 91                 186
2041413 2041413 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_10 287 40 73 0   100     1   41   261 279                       542.0 287 40 73 0   100     1   41   261 279                 542
2043290 2043290 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_7 123 16 13 0   100     0   26   130 148                       278.0 123 16 13 0   100     0   26   130 148                 278
2039953 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 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 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 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 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
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
2041024 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 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 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 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 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
2044554 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 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 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 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
2040201 2040201 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_5 210 12 24 1   90     1   28   189 177                       366.0 210 12 24 1   90     1   28   189 177                 366
2046866 2046866 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2019   grade_12 333 3 7 0   90     0   14   237 210                       447.0 333 3 7 0   90     0   14   237 210                 447
2041414 2041414 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_11 266 38 51 0   88     0   46   260 227                       489.0 266 38 51 0   88     0   46   260 227                 489
2043491 2043491 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2019   grade_7 22 8 55 0   88     0   5   88 90                       178.0 22 8 55 0   88     0   5   88 90                 178
2045174 2045174 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 15 11 3   88     1   8   107 70                       177.0 51 15 11 3   88     1   8   107 70                 177
2045259 2045259 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2019   grade_10 215 37 30 2   88     1   12   191 194                       385.0 215 37 30 2   88     1   12   191 194                 385
2046865 2046865 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2019   grade_11 319 2 7 0   88     0   17   225 208                       433.0 319 2 7 0   88     0   17   225 208                 433
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
2049190 2049190 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_11 236 21 177 1   85     0   16   284 252                       536.0 236 21 177 1   85     0   16   284 252                 536
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
2041006 2041006 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_10 98 72 98 1   84     1   8   156 206                       362.0 98 72 98 1   84     1   8   156 206                 362
2041030 2041030 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   grade_6 10 19 22 0   84     0   8   78 65                       143.0 10 19 22 0   84     0   8   78 65                 143
2043470 2043470 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2019   grade_5 47 9 32 0   83     0   13   103 81                       184.0 47 9 32 0   83     0   13   103 81                 184
2044549 2044549 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_12 361 18 56 3   83     0   23   269 274                       544.0 361 18 56 3   83     0   23   269 274                 544
2045246 2045246 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_6 92 5 6 0   83     2   9   94 103                       197.0 92 5 6 0   83     2   9   94 103                 197
2040749 2040749 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   grade_1 11 12 8 0   82     0   3   58 58                       116.0 11 12 8 0   82     0   3   58 58                 116
2045640 2045640 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2019   grade_6 170 10 10 0   82     0   14   138 148                       286.0 170 10 10 0   82     0   14   138 148                 286
2045641 2045641 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2019   grade_7 170 12 14 1   82     0   12   160 131                       291.0 170 12 14 1   82     0   12   160 131                 291
2045642 2045642 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2019   grade_8 150 14 16 0   82     1   12   127 148                       275.0 150 14 16 0   82     1   12   127 148                 275
2040750 2040750 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   grade_2 11 13 14 0   81     0   3   64 58                       122.0 11 13 14 0   81     0   3   64 58                 122
2041415 2041415 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_12 292 33 59 0   81     1   33   243 255                       499.0 292 33 59 0   81     1   33   243 255                 499
2043489 2043489 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2019   grade_5 24 9 43 0   81     0   5   82 80                       162.0 24 9 43 0   81     0   5   82 80                 162
2043492 2043492 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2019   grade_8 17 5 59 0   81     0   6   92 76                       168.0 17 5 59 0   81     0   6   92 76                 168
2046761 2046761 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No Middle 07 08 2019   grade_8 164 2 18 0   81     0   13   147 131                       278.0 164 2 18 0   81     0   13   147 131                 278
2043471 2043471 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2019   grade_6 42 7 35 0   80     0   7   99 72                       171.0 42 7 35 0   80     0   7   99 72                 171
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
2049191 2049191 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_12 214 17 179 2   80     0   22   300 214                       514.0 214 17 179 2   80     0   22   300 214                 514
2040753 2040753 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   grade_5 7 21 20 0   79     0   5   66 66                       132.0 7 21 20 0   79     0   5   66 66                 132
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
2043472 2043472 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2019   grade_7 50 4 31 0   79     0   8   92 80                       172.0 50 4 31 0   79     0   8   92 80                 172
2045644 2045644 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2019   grade_10 157 13 13 0   78     1   7   153 116                       269.0 157 13 13 0   78     1   7   153 116                 269
2046752 2046752 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2019   pre_kindergarten 33 3 11 1   78     0   1   73 54                       127.0 33 3 11 1   78     0   1   73 54                 127

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