enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1367862 1367862 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_10 53 10 318 0   1     1   5   200 187 *                     388.0 53 10 318 0   1     1   5   200 187                 388
1368593 1368593 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2020   grade_10 102 35 318 4   47     0   19   272 253 *                     525.0 102 35 318 4   47     0   19   272 253                 525
1374106 1374106 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 56 3 318 1   9     0   1   198 190 *                     388.0 56 3 318 1   9     0   1   198 190                 388
2049182 2049182 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_11 56 3 318 1   4     0   0   177 205                       382.0 56 3 318 1   4     0   0   177 205                 382
1681355 1681355 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical - Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_12 56 3 317 1   8     0   1   197 189 *                     386.0 56 3 317 1   8     0   1   197 189                 386
2233301 2233301 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_6 45 45 317 0   33     0   15   230 225                       455.0 45 45 317 0   33     0   15   230 225                 455
1133013 1133013 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 69 6 316 0   2     0   0   200 193                       393 69 6 316 0   2     0   0   200 193                 393
1675834 1675834 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn - Classical High   Regular School No High 09 12 2021   grade_10 62 37 316 1   49     0   11   247 229 *                     476.0 62 37 316 1   49     0   11   247 229                 476
2233305 2233305 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_6 49 45 316 0   41     0   19   265 205                       470.0 49 45 316 0   41     0   19   265 205                 470
1676586 1676586 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_9 296 101 315 2   7     1   34   407 349 *                     756.0 296 101 315 2   7     1   34   407 349                 756
2045388 2045388 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2019   grade_9 164 19 315 2   28     0   13   291 250                       541.0 164 19 315 2   28     0   13   291 250                 541
742004 742004 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2015   grade_9 48 58 314 1   7     0   11   256 183                       439 48 58 314 1   7     0   11   256 183                 439
1677564 1677564 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere - Revere High   Regular School No High 09 12 2021   grade_10 155 21 314 0   26     1   7   256 268 *                     524.0 155 21 314 0   26     1   7   256 268                 524
739522 739522 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_9 93 52 313 0   25     0   23   293 213                       506 93 52 313 0   25     0   23   293 213                 506
2042942 2042942 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_10 66 5 311 1   2     0   3   213 175                       388.0 66 5 311 1   2     0   3   213 175                 388
1368598 1368598 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_11 66 49 308 1   40     0   11   260 215 *                     475.0 66 49 308 1   40     0   11   260 215                 475
1123300 1123300 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_9 33 18 307 1   3     0   3   231 134                       365 33 18 307 1   3     0   3   231 134                 365
1674320 1674320 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_10 94 85 307 4   26     0   10   270 256 *                     526.0 94 85 307 4   26     0   10   270 256                 526
1123301 1123301 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_10 52 25 306 2   4     0   4   201 192                       393 52 25 306 2   4     0   4   201 192                 393
1367864 1367864 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_12 63 6 306 0   5     0   6   179 206 *                     386.0 63 6 306 0   5     0   6   179 206                 386
1675108 1675108 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke - Holyoke High   Regular School No High 09 12 2021   grade_11 51 14 306 1   1     1   4   196 181 *                     378.0 51 14 306 1   1     1   4   196 181                 378
2239829 2239829 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_11 65 6 305 0   2     0   0   193 185                       378.0 65 6 305 0   2     0   0   193 185                 378
1374107 1374107 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 53 3 304 1   4     0   0   169 196 *                     365.0 53 3 304 1   4     0   0   169 196                 365
938811 938811 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_9 43 94 303 0   4     0   8   239 213                       452 43 94 303 0   4     0   8   239 213                 452
1675107 1675107 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke - Holyoke High   Regular School No High 09 12 2021   grade_10 60 13 303 0   0     0   4   201 178 *                     380.0 60 13 303 0   0     0   4   201 178                 380
1371045 1371045 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2020   grade_10 61 135 302 0   20     0   5   292 231 *                     523.0 61 135 302 0   20     0   5   292 231                 523
2041672 2041672 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2019   grade_10 15 26 300 0   7     0   1   206 143                       349.0 15 26 300 0   7     0   1   206 143                 349
936369 936369 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_9 72 52 299 1   30     0   18   283 189                       472 72 52 299 1   30     0   18   283 189                 472
1370316 1370316 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_10 148 20 299 2   26     0   13   265 242 *                     508.0 148 20 299 2   26     0   13   265 242                 508
1367089 1367089 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_10 103 99 298 3   24     0   7   274 260 *                     534.0 103 99 298 3   24     0   7   274 260                 534
1371052 1371052 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2020   grade_9 25 72 298 0   7     1   7   223 187 *                     410.0 25 72 298 0   7     1   7   223 187                 410
1676588 1676588 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_11 216 109 298 3   7     2   36   359 311 *                     671.0 216 109 298 3   7     2   36   359 311                 671
2236219 2236219 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_10 76 121 298 1   28     1   5   267 263                       530.0 76 121 298 1   28     1   5   267 263                 530
1129410 1129410 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2017   grade_9 45 63 297 0   9     1   4   273 146                       419 45 63 297 0   9     1   4   273 146                 419
1367861 1367861 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_9 58 11 297 0   0     0   4   195 175 *                     370.0 58 11 297 0   0     0   4   195 175                 370
741259 741259 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2015   grade_9 164 24 295 1   31     0   12   278 249                       527 164 24 295 1   31     0   12   278 249                 527
745060 745060 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 55 4 295 0   4     0   0   184 174                       358 55 4 295 0   4     0   0   184 174                 358
2041673 2041673 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2019   grade_11 19 21 295 0   5     1   2   164 179                       343.0 19 21 295 0   5     1   2   164 179                 343
1675106 1675106 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke - Holyoke High   Regular School No High 09 12 2021   grade_9 52 11 294 0   1     0   3   181 180 *                     361.0 52 11 294 0   1     0   3   181 180                 361
2046120 2046120 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2019   grade_10 61 136 294 0   25     0   5   293 228                       521.0 61 136 294 0   25     0   5   293 228                 521
739517 739517 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2015   grade_9 92 55 293 1   55     0   12   266 242                       508 92 55 293 1   55     0   12   266 242                 508
741994 741994 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_9 78 135 293 0   27     0   32   293 272                       565 78 135 293 0   27     0   32   293 272                 565
1678314 1678314 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield - Springfield High School of Science and Technology   Regular School No High 09 12 2021   grade_9 25 67 293 0   4     1   2   231 161 *                     392.0 25 67 293 0   4     1   2   231 161                 392
1673835 1673835 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea - Chelsea High   Regular School No High 09 12 2021   grade_11 13 15 291 1   0     0   5   193 132 *                     325.0 13 15 291 1   0     0   5   193 132                 325
2233303 2233303 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_8 53 40 291 6   35     0   15   227 213                       440.0 53 40 291 6   35     0   15   227 213                 440
736823 736823 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2015   grade_10 58 26 290 3   6     0   4   222 165                       387 58 26 290 3   6     0   4   222 165                 387
2237559 2237559 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester: Head Start   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 104 107 290 0   12     0   16   254 275                       529.0 104 107 290 0   12     0   16   254 275                 529
941881 941881 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 55 2 289 0   4     0   0   179 171                       350 55 2 289 0   4     0   0   179 171                 350
1369338 1369338 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_10 214 107 288 4   7     1   31   350 302 *                     652.0 214 107 288 4   7     1   31   350 302                 652
1674321 1674321 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_11 99 103 287 3   25     0   7   273 251 *                     524.0 99 103 287 3   25     0   7   273 251                 524
2049183 2049183 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_12 63 6 287 0   2     0   0   180 178                       358.0 63 6 287 0   2     0   0   180 178                 358
1128539 1128539 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2017   grade_11 147 25 286 0   28     0   9   247 248                       495 147 25 286 0   28     0   9   247 248                 495
1367863 1367863 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_11 75 7 286 1   2     0   2   205 168 *                     373.0 75 7 286 1   2     0   2   205 168                 373
2230107 2230107 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_11 45 30 286 2   5     0   4   200 172                       372.0 45 30 286 2   5     0   4   200 172                 372
2233319 2233319 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn: Lynn English High   Regular School No High 09 12 2018   grade_10 66 30 286 0   48     0   10   217 223                       440.0 66 30 286 0   48     0   10   217 223                 440
2234204 2234204 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_10 179 90 285 4   5     1   22   325 261                       586.0 179 90 285 4   5     1   22   325 261                 586
742005 742005 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2015   grade_10 25 74 284 0   11     0   5   230 169                       399 25 74 284 0   11     0   5   230 169                 399
743099 743099 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No 1 PK PK 2015   pre_kindergarten 173 122 284 0   25     0   2   283 323                       606 173 122 284 0   25     0   2   283 323                 606
1678310 1678310 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 Springfield - High School Of Commerce   Regular School No High 09 12 2021   grade_9 26 50 283 0   3     0   6   198 170 *                     368.0 26 50 283 0   3     0   6   198 170                 368
2230932 2230932 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_12 16 21 283 0   12     0   1   160 173                       333.0 16 21 283 0   12     0   1   160 173                 333
938812 938812 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_10 39 92 281 0   5     0   4   226 195                       421 39 92 281 0   5     0   4   226 195                 421
1123302 1123302 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_11 48 27 281 3   6     0   3   212 156                       368 48 27 281 3   6     0   3   212 156                 368
1367088 1367088 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_9 90 86 281 4   24     0   8   251 242 *                     493.0 90 86 281 4   24     0   8   251 242                 493
1371048 1371048 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2020   grade_9 32 78 281 2   7     1   4   211 194 *                     405.0 32 78 281 2   7     1   4   211 194                 405
2043653 2043653 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2019   grade_8 36 41 281 1   31     0   12   197 204                       402.0 36 41 281 1   31     0   12   197 204                 402
2236228 2236228 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield: Springfield High School of Science and Technology   Regular School No High 09 12 2018   grade_9 27 69 281 0   6     0   1   229 155                       384.0 27 69 281 0   6     0   1   229 155                 384
738773 738773 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2015   grade_9 96 14 280 0   6     0   9   224 181                       405 96 14 280 0   6     0   9   224 181                 405
1133014 1133014 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_11 55 2 279 0   4     0   0   174 166                       340 55 2 279 0   4     0   0   174 166                 340
737521 737521 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_10 27 26 278 0   13     0   2   157 189                       346 27 26 278 0   13     0   2   157 189                 346
2040972 2040972 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2019   grade_12 41 21 278 2   5     0   4   184 167                       351.0 41 21 278 2   5     0   4   184 167                 351
2046128 2046128 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2019   grade_9 36 51 278 1   7     0   3   233 143                       376.0 36 51 278 1   7     0   3   233 143                 376
2230105 2230105 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_9 34 17 277 0   6     0   6   222 118                       340.0 34 17 277 0   6     0   6   222 118                 340
937115 937115 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_11 284 93 276 5   6     3   28   351 344                       695 284 93 276 5   6     3   28   351 344                 695
1129405 1129405 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2017   grade_9 27 63 276 0   3     0   4   208 165                       373 27 63 276 0   3     0   4   208 165                 373
1126482 1126482 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2017   grade_7 53 41 275 5   35     0   14   223 200                       423 53 41 275 5   35     0   14   223 200                 423
1126498 1126498 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2017   grade_9 74 34 275 0   44     0   13   227 213                       440 74 34 275 0   44     0   13   227 213                 440
1128537 1128537 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2017   grade_9 178 14 275 2   32     0   15   263 253                       516 178 14 275 2   32     0   15   263 253                 516
740276 740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
1368585 1368585 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_8 28 40 274 0   21     0   10   187 186 *                     373.0 28 40 274 0   21     0   10   187 186                 373
1675840 1675840 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_12 63 47 274 1   39     0   11   230 202 *                     435.0 63 47 274 1   39     0   11   230 202                 435
2043661 2043661 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2019   grade_10 70 37 274 2   29     0   6   225 193                       418.0 70 37 274 2   29     0   6   225 193                 418
2233313 2233313 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn: Classical High   Regular School No High 09 12 2018   grade_9 68 30 274 2   30     0   7   240 171                       411.0 68 30 274 2   30     0   7   240 171                 411
745061 745061 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 73 3 273 0   5     0   2   182 174                       356 73 3 273 0   5     0   2   182 174                 356
2042160 2042160 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_9 102 94 273 4   23     0   7   258 245                       503.0 102 94 273 4   23     0   7   258 245                 503
935621 935621 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2016   grade_9 73 15 272 0   1     0   5   194 172                       366 73 15 272 0   1     0   5   194 172                 366
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
1675835 1675835 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn - Classical High   Regular School No High 09 12 2021   grade_11 93 30 272 5   43     0   19   230 232 *                     462.0 93 30 272 5   43     0   19   230 232                 462
938817 938817 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_10 47 61 271 0   6     1   0   209 177                       386 47 61 271 0   6     1   0   209 177                 386
933689 933689 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_10 42 27 270 2   6     0   2   192 157                       349 42 27 270 2   6     0   2   192 157                 349
1127384 1127384 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_9 189 86 270 3   3     1   23   317 258                       575 189 86 270 3   3     1   23   317 258                 575
1678309 1678309 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield - Springfield Central High   Regular School No High 09 12 2021   grade_12 66 127 269 0   29     0   6   276 221 *                     497.0 66 127 269 0   29     0   6   276 221                 497
2233302 2233302 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_7 41 40 269 0   35     0   13   195 203                       398.0 41 40 269 0   35     0   13   195 203                 398
1127385 1127385 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_10 160 62 268 6   7     2   22   299 228                       527 160 62 268 6   7     2   22   299 228                 527
1675826 1675826 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn - Thurgood Marshall Mid   Regular School No Middle 06 08 2021   grade_8 25 34 268 0   32     0   4   198 165 *                     363.0 25 34 268 0   32     0   4   198 165                 363
2043656 2043656 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2019   grade_8 68 36 268 1   48     0   17   218 220                       438.0 68 36 268 1   48     0   17   218 220                 438
2230108 2230108 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_12 43 36 268 2   6     0   3   200 158                       358.0 43 36 268 2   6     0   3   200 158                 358
1126485 1126485 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_6 78 43 266 1   47     0   17   233 219                       452 78 43 266 1   47     0   17   233 219                 452
2231502 2231502 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_10 132 91 266 2   27     2   5   271 254                       525.0 132 91 266 2   27     2   5   271 254                 525
938087 938087 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2016   grade_9 163 31 265 3   33     0   12   251 256                       507 163 31 265 3   33     0   12   251 256                 507
2042162 2042162 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_11 128 97 265 2   23     2   5   270 252                       522.0 128 97 265 2   23     2   5   270 252                 522

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