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
1125863 1125863 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_9 39 16 921 1   12     0   1   561 429                       990 39 16 921 1   12     0   1   561 429                 990
2043130 2043130 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_9 32 14 912 0   9     0   2   543 420                       969.0 32 14 912 0   9     0   2   543 420                 969
1368046 1368046 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_9 20 5 879 0   12     0   3   483 429 7                     919.0 20 5 879 0   12     0   3   483 429 7               919
2232680 2232680 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_9 30 6 854 0   20     0   1   500 411                       911.0 30 6 854 0   20     0   1   500 411                 911
1675292 1675292 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_10 17 4 854 0   13     0   2   466 421 3                     890.0 17 4 854 0   13     0   2   466 421 3               890
1368047 1368047 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_10 28 16 833 0   8     0   1   489 394 3                     886.0 28 16 833 0   8     0   1   489 394 3               886
2232681 2232681 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_10 29 15 826 1   10     0   1   483 399                       882.0 29 15 826 1   10     0   1   483 399                 882
2043132 2043132 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_11 26 12 756 1   12     0   1   429 375                       808.0 26 12 756 1   12     0   1   429 375                 808
1125864 1125864 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_10 22 11 742 1   14     0   5   417 378                       795 22 11 742 1   14     0   5   417 378                 795
1125865 1125865 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_11 26 15 737 0   14     0   1   392 401                       793 26 15 737 0   14     0   1   392 401                 793
1675291 1675291 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_9 19 13 735 1   14     0   3   425 358 2                     785.0 19 13 735 1   14     0   3   425 358 2               785
1368049 1368049 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_12 21 9 717 0   11     0   2   401 349 10                     760.0 21 9 717 0   11     0   2   401 349 10               760
1675293 1675293 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_11 22 13 703 0   6     0   1   389 354 2                     745.0 22 13 703 0   6     0   1   389 354 2               745
935823 935823 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No 4 09 09 2016   grade_9 25 12 700 1   12     0   3   391 362                       753 25 12 700 1   12     0   3   391 362                 753
2043131 2043131 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_10 21 2 699 0   19     1   1   383 359                       743.0 21 2 699 0   19     1   1   383 359                 743
2232682 2232682 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_11 21 13 688 1   13     0   5   363 378                       741.0 21 13 688 1   13     0   5   363 378                 741
2232683 2232683 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_12 24 13 679 0   14     0   1   344 387                       731.0 24 13 679 0   14     0   1   344 387                 731
1368048 1368048 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_11 23 5 674 0   20     0   1   372 349 2                     723.0 23 5 674 0   20     0   1   372 349 2               723
1125866 1125866 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_12 33 12 652 0   5     0   0   347 355                       702 33 12 652 0   5     0   0   347 355                 702
1675294 1675294 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_12 18 5 639 1   20     0   1   347 336 1                     684.0 18 5 639 1   20     0   1   347 336 1               684
2043133 2043133 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_12 15 11 619 1   14     0   4   331 333                       664.0 15 11 619 1   14     0   4   331 333                 664
737520 737520 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_9 28 39 510 0   12     0   3   324 268                       592 28 39 510 0   12     0   3   324 268                 592
737490 737490 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2015   kindergarten 66 36 498 0   6     0   11   327 290                       617 66 36 498 0   6     0   11   327 290                 617
1124075 1124075 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2017   kindergarten 39 38 477 1   1     0   1   290 267                       557 39 38 477 1   1     0   1   290 267                 557
1678306 1678306 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield - Springfield Central High   Regular School No High 09 12 2021   grade_9 46 123 454 1   25     0   10   354 305 *                     659.0 46 123 454 1   25     0   10   354 305                 659
934350 934350 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2016   kindergarten 41 25 448 0   4     0   10   298 230                       528 41 25 448 0   4     0   10   298 230                 528
2041640 2041640 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2019   kindergarten 44 23 446 0   4     0   3   239 281                       520.0 44 23 446 0   4     0   3   239 281                 520
1366569 1366569 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   kindergarten 30 20 442 1   0     0   2   261 234 *                     495.0 30 20 442 1   0     0   2   261 234                 495
1371044 1371044 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2020   grade_9 51 119 434 1   23     0   13   349 292 *                     641.0 51 119 434 1   23     0   13   349 292                 641
934380 934380 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2016   grade_9 27 28 429 0   6     0   2   282 210                       492 27 28 429 0   6     0   2   282 210                 492
2230890 2230890 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea: Shurtleff Early Childhood   Regular School No Elementary PK 01 2018   kindergarten 39 33 429 0   8     0   4   241 272                       513.0 39 33 429 0   8     0   4   241 272                 513
1366602 1366602 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_9 22 14 428 1   1     0   6   267 205 *                     472.0 22 14 428 1   1     0   6   267 205                 472
2046119 2046119 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2019   grade_9 63 140 427 1   21     0   6   388 270                       658.0 63 140 427 1   21     0   6   388 270                 658
741999 741999 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2015   grade_9 55 140 422 0   3     0   17   352 285                       637 55 140 422 0   3     0   17   352 285                 637
1368597 1368597 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_10 56 52 413 5   40     0   10   301 275 *                     576.0 56 52 413 5   40     0   10   301 275                 576
1673834 1673834 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea - Chelsea High   Regular School No High 09 12 2021   grade_10 19 11 412 1   1     0   5   252 197 *                     449.0 19 11 412 1   1     0   5   252 197                 449
2236218 2236218 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_9 76 162 408 0   34     0   7   394 293                       687.0 76 162 408 0   34     0   7   394 293                 687
1673800 1673800 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea - Shurtleff Early Childhood   Regular School No Elementary PK 01 2021   kindergarten 36 30 404 2   0     0   5   230 247 *                     477.0 36 30 404 2   0     0   5   230 247                 477
1129400 1129400 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2017   grade_9 88 151 403 1   31     1   8   365 318                       683 88 151 403 1   31     1   8   365 318                 683
1675838 1675838 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_10 42 47 394 2   42     0   11   285 251 *                     538.0 42 47 394 2   42     0   11   285 251                 538
1675839 1675839 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_11 46 49 390 4   39     0   8   275 261 *                     536.0 46 49 390 4   39     0   8   275 261                 536
934381 934381 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2016   grade_10 24 28 383 0   10     0   2   228 219                       447 24 28 383 0   10     0   2   228 219                 447
1368596 1368596 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_9 41 51 380 2   43     0   15   287 244 *                     532.0 41 51 380 2   43     0   15   287 244                 532
1673833 1673833 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea - Chelsea High   Regular School No High 09 12 2021   grade_9 29 18 380 1   0     0   4   222 210 *                     432.0 29 18 380 1   0     0   4   222 210                 432
2232436 2232436 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke: Holyoke High   Regular School No High 09 12 2018   grade_9 74 6 378 1   4     0   2   254 211                       465.0 74 6 378 1   4     0   2   254 211                 465
1124114 1124114 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2017   grade_9 24 28 377 0   7     1   2   245 194                       439 24 28 377 0   7     1   2   245 194                 439
1124115 1124115 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2017   grade_10 19 25 375 0   8     0   3   242 188                       430 19 25 375 0   8     0   3   242 188                 430
933688 933688 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_9 56 28 369 2   4     0   6   272 193                       465 56 28 369 2   4     0   6   272 193                 465
2235358 2235358 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere: Revere High   Regular School No High 09 12 2018   grade_9 184 19 363 8   30     0   10   320 294                       614.0 184 19 363 8   30     0   10   320 294                 614
1374104 1374104 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_9 59 5 363 1   4     0   0   222 210 *                     432.0 59 5 363 1   4     0   0   222 210                 432
2230930 2230930 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_10 21 21 361 0   7     1   2   218 195                       413.0 21 21 361 0   7     1   2   218 195                 413
1675828 1675828 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn - Breed Middle School   Regular School No Middle 06 08 2021   grade_7 35 38 361 1   47     0   18   255 245 *                     500.0 35 38 361 1   47     0   18   255 245                 500
1368586 1368586 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_6 36 48 359 1   54     0   19   260 257 *                     517.0 36 48 359 1   54     0   19   260 257                 517
1681353 1681353 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_10 61 4 359 0   4     0   0   223 205 *                     428.0 61 4 359 0   4     0   0   223 205                 428
736822 736822 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2015   grade_9 53 43 357 2   8     0   1   286 178                       464 53 43 357 2   8     0   1   286 178                 464
2049180 2049180 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_9 60 5 357 0   6     0   0   218 210                       428.0 60 5 357 0   6     0   0   218 210                 428
2043664 2043664 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2019   grade_9 58 57 352 5   43     0   13   288 240                       528.0 58 57 352 5   43     0   13   288 240                 528
1676587 1676587 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_10 263 97 352 5   4     0   35   397 359 *                     756.0 263 97 352 5   4     0   35   397 359                 756
1675837 1675837 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_9 51 45 351 0   38     0   18   265 238 *                     503.0 51 45 351 0   38     0   18   265 238                 503
1368583 1368583 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_6 43 57 350 1   27     0   19   255 242 *                     497.0 43 57 350 1   27     0   19   255 242                 497
1675109 1675109 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke - Holyoke High   Regular School No High 09 12 2021   grade_12 80 10 350 1   3     0   3   243 204 *                     447.0 80 10 350 1   3     0   3   243 204                 447
2043654 2043654 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2019   grade_6 63 55 348 1   49     0   13   263 266                       529.0 63 55 348 1   49     0   13   263 266                 529
1368587 1368587 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_7 62 51 348 1   43     0   13   255 263 *                     518.0 62 51 348 1   43     0   13   255 263                 518
2230931 2230931 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_11 17 22 346 0   6     0   2   206 187                       393.0 17 22 346 0   6     0   2   206 187                 393
2233318 2233318 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn: Lynn English High   Regular School No High 09 12 2018   grade_9 73 44 345 1   41     0   13   317 200                       517.0 73 44 345 1   41     0   13   317 200                 517
1133012 1133012 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_9 65 1 344 1   4     0   0   186 229                       415 65 1 344 1   4     0   0   186 229                 415
1675825 1675825 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn - Thurgood Marshall Mid   Regular School No Middle 06 08 2021   grade_7 40 53 344 1   27     0   20   253 231 *                     485.0 40 53 344 1   27     0   20   253 231                 485
2230929 2230929 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_9 17 29 343 0   8     0   1   236 162                       398.0 17 29 343 0   8     0   1   236 162                 398
1678307 1678307 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield - Springfield Central High   Regular School No High 09 12 2021   grade_10 45 109 342 1   15     0   12   280 244 *                     524.0 45 109 342 1   15     0   12   280 244                 524
2239827 2239827 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_9 66 3 341 1   8     0   0   217 202                       419.0 66 3 341 1   8     0   0   217 202                 419
1368584 1368584 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_7 39 38 341 0   36     0   6   240 220 *                     460.0 39 38 341 0   36     0   6   240 220                 460
1125619 1125619 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2017   grade_9 72 9 340 0   6     0   6   223 210                       433 72 9 340 0   6     0   6   223 210                 433
1374105 1374105 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_10 56 5 340 0   5     0   0   215 191 *                     406.0 56 5 340 0   5     0   0   215 191                 406
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
2041671 2041671 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2019   grade_9 13 14 337 1   6     0   0   221 150                       371.0 13 14 337 1   6     0   0   221 150                 371
1677563 1677563 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere - Revere High   Regular School No High 09 12 2021   grade_9 147 24 337 3   23     0   8   281 261 *                     542.0 147 24 337 3   23     0   8   281 261                 542
1675824 1675824 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn - Thurgood Marshall Mid   Regular School No Middle 06 08 2021   grade_6 38 46 336 1   34     1   13   233 236 *                     469.0 38 46 336 1   34     1   13   233 236                 469
2049181 2049181 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_10 60 3 335 1   9     0   0   210 198                       408.0 60 3 335 1   9     0   0   210 198                 408
1681354 1681354 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_11 55 5 335 0   5     0   0   212 188 *                     400.0 55 5 335 0   5     0   0   212 188                 400
2043665 2043665 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2019   grade_10 72 45 334 2   38     0   12   297 206                       503.0 72 45 334 2   38     0   12   297 206                 503
939908 939908 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No 1 PK PK 2016   pre_kindergarten 105 108 332 3   19     1   3   294 277                       571 105 108 332 3   19     1   3   294 277                 571
1124116 1124116 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2017   grade_11 18 23 332 0   10     0   1   188 196                       384 18 23 332 0   10     0   1   188 196                 384
1369337 1369337 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_9 269 89 331 3   4     0   37   377 355 *                     733.0 269 89 331 3   4     0   37   377 355                 733
1130731 1130731 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Elementary PK PK 2017   pre_kindergarten 98 103 330 2   18     2   7   280 280                       560 98 103 330 2   18     2   7   280 280                 560
2043652 2043652 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2019   grade_7 43 50 329 0   28     0   15   231 234                       465.0 43 50 329 0   28     0   15   231 234                 465
1366603 1366603 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_10 13 17 329 1   0     0   5   211 154 *                     365.0 13 17 329 1   0     0   5   211 154                 365
1674319 1674319 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_9 103 79 329 4   31     1   9   272 284 *                     556.0 103 79 329 4   31     1   9   272 284                 556
1675827 1675827 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn - Breed Middle School   Regular School No Middle 06 08 2021   grade_6 52 39 329 1   37     0   17   257 217 *                     475.0 52 39 329 1   37     0   17   257 217                 475
938816 938816 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_9 58 65 328 0   9     0   7   281 186                       467 58 65 328 0   9     0   7   281 186                 467
2239828 2239828 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_10 60 3 328 1   4     0   0   180 216                       396.0 60 3 328 1   4     0   0   180 216                 396
1370315 1370315 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_9 167 22 328 1   27     1   7   279 273 *                     553.0 167 22 328 1   27     1   7   279 273                 553
1681352 1681352 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_9 79 8 328 1   3     1   0   180 240 *                     420.0 79 8 328 1   3     1   0   180 240                 420
938807 938807 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_9 99 148 327 0   44     1   9   347 281                       628 99 148 327 0   44     1   9   347 281                 628
941880 941880 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_9 67 6 322 0   2     0   0   201 196                       397 67 6 322 0   2     0   0   201 196                 397
2042943 2042943 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_11 63 9 322 0   5     0   6   195 210                       405.0 63 9 322 0   5     0   6   195 210                 405
2043651 2043651 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2019   grade_6 39 48 322 0   33     0   7   232 217                       449.0 39 48 322 0   33     0   7   232 217                 449
1370317 1370317 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_11 162 16 322 9   30     0   10   285 264 *                     549.0 162 16 322 9   30     0   10   285 264                 549
2045389 2045389 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2019   grade_10 170 18 321 8   29     0   8   279 275                       554.0 170 18 321 8   29     0   8   279 275                 554
2042941 2042941 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_9 48 12 319 2   1     1   4   202 185                       387.0 48 12 319 2   1     1   4   202 185                 387
2043655 2043655 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2019   grade_7 51 38 319 0   37     0   17   261 201                       462.0 51 38 319 0   37     0   17   261 201                 462

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