enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_8", state = "MA" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 500 ✖

grade ✖

  • grade_8 · 500 ✖
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
1368465 1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1374315 1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1370707 1370707 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_8 0 2 7 0   1     0   0   8 * *                     10.0 0 2 7 0   1     0   0   8                   10
1372583 1372583 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_8 68 3 12 0   6     0   11   43 56 *                     100.0 68 3 12 0   6     0   11   43 56                 100
1365411 1365411 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_8 9 2 89 0   0     0   1   46 55 *                     101.0 9 2 89 0   0     0   1   46 55                 101
1367053 1367053 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_8 37 9 43 2   6     1   3   54 47 *                     101.0 37 9 43 2   6     1   3   54 47                 101
1370178 1370178 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 South West Middle School   Regular School No Middle 05 08 2020   grade_8 42 11 16 0   25     1   7   57 45 *                     102.0 42 11 16 0   25     1   7   57 45                 102
1372379 1372379 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2020   grade_8 7 15 71 0   7     0   2   50 52 *                     102.0 7 15 71 0   7     0   2   50 52                 102
1369052 1369052 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 06 08 2020   grade_8 77 2 13 0   5     0   6   56 47 *                     103.0 77 2 13 0   5     0   6   56 47                 103
1365892 1365892 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2020   grade_8 7 17 62 0   14     0   4   60 44 *                     104.0 7 17 62 0   14     0   4   60 44                 104
1368045 1368045 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_8 0 1 102 0   1     0   0   60 44 *                     104.0 0 1 102 0   1     0   0   60 44                 104
1368643 1368643 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_8 27 19 15 0   41     1   1   58 46 *                     104.0 27 19 15 0   41     1   1   58 46                 104
1370987 1370987 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2020   grade_8 17 23 59 0   2     0   4   63 42 *                     105.0 17 23 59 0   2     0   4   63 42                 105
1368652 1368652 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_8 20 18 42 0   19     0   7   45 61 *                     106.0 20 18 42 0   19     0   7   45 61                 106
1368957 1368957 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_8 63 4 32 0   5     0   2   44 62 *                     106.0 63 4 32 0   5     0   2   44 62                 106
1372667 1372667 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_8 24 61 16 0   3     1   1   51 55 *                     106.0 24 61 16 0   3     1   1   51 55                 106
1373675 1373675 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_8 100 0 2 0   1     0   3   50 56 *                     106.0 100 0 2 0   1     0   3   50 56                 106
1371519 1371519 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2020   grade_8 98 2 3 0   0     0   4   55 52 *                     107.0 98 2 3 0   0     0   4   55 52                 107
1371715 1371715 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_8 89 5 5 2   1     0   5   51 56 *                     107.0 89 5 5 2   1     0   5   51 56                 107
1367078 1367078 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_8 21 21 55 1   6     0   5   45 64 *                     109.0 21 21 55 1   6     0   5   45 64                 109
1368003 1368003 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_8 0 3 105 0   1     0   0   50 59 *                     109.0 0 3 105 0   1     0   0   50 59                 109
1368796 1368796 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_8 85 4 4 6   3     0   7   59 50 *                     109.0 85 4 4 6   3     0   7   59 50                 109
1371024 1371024 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_8 4 13 93 0   0     0   0   60 50 *                     110.0 4 13 93 0   0     0   0   60 50                 110
1372920 1372920 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_8 85 5 16 0   2     0   2   52 58 *                     110.0 85 5 16 0   2     0   2   52 58                 110
1373274 1373274 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_8 99 2 4 0   1     0   4   61 49 *                     110.0 99 2 4 0   1     0   4   61 49                 110
1373827 1373827 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2020   grade_8 96 2 9 1   1     0   1   63 47 *                     110.0 96 2 9 1   1     0   1   63 47                 110
1374254 1374254 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_8 2 97 10 1   0     0   0   60 50 *                     110.0 2 97 10 1   0     0   0   60 50                 110
1373514 1373514 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_8 106 0 2 0   1     0   2   59 52 *                     111.0 106 0 2 0   1     0   2   59 52                 111
1368260 1368260 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2020   grade_8 79 4 9 0   16     0   4   51 61 *                     112.0 79 4 9 0   16     0   4   51 61                 112
1368270 1368270 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_8 88 1 10 0   10     0   3   52 60 *                     112.0 88 1 10 0   10     0   3   52 60                 112
1365898 1365898 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_8 1 40 70 0   0     0   3   49 65 *                     114.0 1 40 70 0   0     0   3   49 65                 114
1369515 1369515 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2020   grade_8 98 4 5 0   1     1   5   60 54 *                     114.0 98 4 5 0   1     1   5   60 54                 114
1373874 1373874 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_8 102 0 8 0   1     0   3   60 54 *                     114.0 102 0 8 0   1     0   3   60 54                 114
1365530 1365530 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2020   grade_8 3 28 75 0   5     0   5   67 49 *                     116.0 3 28 75 0   5     0   5   67 49                 116
1366865 1366865 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_8 109 0 3 0   1     0   3   73 43 *                     116.0 109 0 3 0   1     0   3   73 43                 116
1369837 1369837 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2020   grade_8 85 1 15 1   4     0   10   55 61 *                     116.0 85 1 15 1   4     0   10   55 61                 116
1371201 1371201 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_8 103 2 5 0   3     0   3   57 59 *                     116.0 103 2 5 0   3     0   3   57 59                 116
1371362 1371362 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2020   grade_8 97 2 7 0   7     0   3   60 56 *                     116.0 97 2 7 0   7     0   3   60 56                 116
1373640 1373640 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 06 08 2020   grade_8 110 0 3 0   0     0   3   61 55 *                     116.0 110 0 3 0   0     0   3   61 55                 116
1366022 1366022 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_8 3 59 51 0   3     0   2   62 56 *                     118.0 3 59 51 0   3     0   2   62 56                 118
1367569 1367569 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2020   grade_8 82 2 21 0   3     0   10   64 54 *                     118.0 82 2 21 0   3     0   10   64 54                 118
1368020 1368020 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_8 6 0 110 0   1     0   1   62 56 *                     118.0 6 0 110 0   1     0   1   62 56                 118
1369121 1369121 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2020   grade_8 60 16 37 0   3     0   3   56 63 *                     119.0 60 16 37 0   3     0   3   56 63                 119
1373088 1373088 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_8 89 6 21 0   1     0   2   57 62 *                     119.0 89 6 21 0   1     0   2   57 62                 119
1368602 1368602 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2020   grade_8 3 2 6 0   0     0   1   9 3 *                     12.0 3 2 6 0   0     0   1   9 3                 12
1364808 1364808 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_8 112 2 2 0   1     0   3   62 58 *                     120.0 112 2 2 0   1     0   3   62 58                 120
1366182 1366182 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_8 19 79 15 0   0     1   6   65 55 *                     120.0 19 79 15 0   0     1   6   65 55                 120
1372508 1372508 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2020   grade_8 68 8 28 0   7     0   9   60 60 *                     120.0 68 8 28 0   7     0   9   60 60                 120
1367761 1367761 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_8 67 24 17 0   5     0   8   64 57 *                     121.0 67 24 17 0   5     0   8   64 57                 121
1374010 1374010 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2020   grade_8 109 3 3 0   3     0   3   51 70 *                     121.0 109 3 3 0   3     0   3   51 70                 121
1373351 1373351 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2020   grade_8 98 6 5 0   6     0   8   71 52 *                     123.0 98 6 5 0   6     0   8   71 52                 123
1373895 1373895 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_8 95 4 17 0   2     0   5   74 49 *                     123.0 95 4 17 0   2     0   5   74 49                 123
1372555 1372555 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_8 4 22 95 0   2     0   1   59 65 *                     124.0 4 22 95 0   2     0   1   59 65                 124
1373709 1373709 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_8 107 3 5 0   3     0   6   72 52 *                     124.0 107 3 5 0   3     0   6   72 52                 124
1367670 1367670 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_8 50 5 66 0   1     1   2   61 64 *                     125.0 50 5 66 0   1     1   2   61 64                 125
1368241 1368241 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2020   grade_8 107 5 2 0   6     0   5   52 73 *                     125.0 107 5 2 0   6     0   5   52 73                 125
1373165 1373165 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2020   grade_8 112 2 5 0   0     0   6   70 55 *                     125.0 112 2 5 0   0     0   6   70 55                 125
1367703 1367703 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_8 73 7 41 1   3     0   1   67 59 *                     126.0 73 7 41 1   3     0   1   67 59                 126
1371607 1371607 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2020   grade_8 68 11 33 0   3     0   11   66 60 *                     126.0 68 11 33 0   3     0   11   66 60                 126
1373109 1373109 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_8 92 3 15 2   7     2   5   70 56 *                     126.0 92 3 15 2   7     2   5   70 56                 126
1374066 1374066 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_8 115 2 6 0   2     0   2   65 62 *                     127.0 115 2 6 0   2     0   2   65 62                 127
1370171 1370171 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2020   grade_8 82 9 14 2   17     0   4   78 50 *                     128.0 82 9 14 2   17     0   4   78 50                 128
1371027 1371027 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2020   grade_8 8 19 100 1   0     0   0   66 62 *                     128.0 8 19 100 1   0     0   0   66 62                 128
1372641 1372641 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_8 26 43 50 0   4     0   5   57 71 *                     128.0 26 43 50 0   4     0   5   57 71                 128
1373718 1373718 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2020   grade_8 114 4 4 0   3     0   3   78 50 *                     128.0 114 4 4 0   3     0   3   78 50                 128
1368054 1368054 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_8 9 4 112 0   4     0   0   58 71 *                     129.0 9 4 112 0   4     0   0   58 71                 129
1365282 1365282 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_8 3 2 6 0   0     0   2   7 6 *                     13.0 3 2 6 0   0     0   2   7 6                 13
1368063 1368063 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_8 1 0 12 0   0     0   0   11 2 *                     13.0 1 0 12 0   0     0   0   11 2                 13
1373456 1373456 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_8 10 1 1 0   0     0   1   7 6 *                     13.0 10 1 1 0   0     0   1   7 6                 13
1366593 1366593 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_8 9 8 112 0   0     0   1   70 60 *                     130.0 9 8 112 0   0     0   1   70 60                 130
1367431 1367431 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_8 108 1 11 0   6     1   3   67 63 *                     130.0 108 1 11 0   6     1   3   67 63                 130
1373588 1373588 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   grade_8 124 2 1 0   2     0   1   56 74 *                     130.0 124 2 1 0   2     0   1   56 74                 130
1366530 1366530 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_8 124 1 3 0   0     0   3   81 50 *                     131.0 124 1 3 0   0     0   3   81 50                 131
1367062 1367062 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_8 32 23 63 1   12     0   1   68 64 *                     132.0 32 23 63 1   12     0   1   68 64                 132
1372807 1372807 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_8 55 34 8 0   33     0   3   64 69 *                     133.0 55 34 8 0   33     0   3   64 69                 133
1373566 1373566 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2020   grade_8 98 14 12 0   1     1   7   67 66 *                     133.0 98 14 12 0   1     1   7   67 66                 133
1367087 1367087 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_8 10 18 103 0   3     0   0   65 69 *                     134.0 10 18 103 0   3     0   0   65 69                 134
1368093 1368093 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_8 102 6 15 0   7     0   5   77 58 *                     135.0 102 6 15 0   7     0   5   77 58                 135
1369038 1369038 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2020   grade_8 107 4 14 0   6     0   6   67 70 *                     137.0 107 4 14 0   6     0   6   67 70                 137
1373442 1373442 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2020   grade_8 114 1 9 0   10     1   2   49 88 *                     137.0 114 1 9 0   10     1   2   49 88                 137
1368680 1368680 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2020   grade_8 35 28 49 0   24     0   2   70 68 *                     138.0 35 28 49 0   24     0   2   70 68                 138
1368007 1368007 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_8 7 0 130 0   0     0   2   58 81 *                     139.0 7 0 130 0   0     0   2   58 81                 139
1368384 1368384 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2020   grade_8 41 11 46 0   34     0   7   63 76 *                     139.0 41 11 46 0   34     0   7   63 76                 139
1368874 1368874 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No Middle 06 08 2020   grade_8 57 30 25 0   21     1   5   79 60 *                     139.0 57 30 25 0   21     1   5   79 60                 139
1373227 1373227 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_8 127 0 4 0   2     0   6   70 69 *                     139.0 127 0 4 0   2     0   6   70 69                 139
1365867 1365867 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_8 0 3 9 0   0     0   2   10 4 *                     14.0 0 3 9 0   0     0   2   10 4                 14
1369350 1369350 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2020   grade_8 3 6 5 0   0     0   0   10 4 *                     14.0 3 6 5 0   0     0   0   10 4                 14
1371013 1371013 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2020   grade_8 2 2 10 0   0     0   0   10 4 *                     14.0 2 2 10 0   0     0   0   10 4                 14
1368451 1368451 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2020   grade_8 124 2 8 2   2     0   3   75 66 *                     141.0 124 2 8 2   2     0   3   75 66                 141
1368947 1368947 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_8 77 1 46 0   10     0   7   70 71 *                     141.0 77 1 46 0   10     0   7   70 71                 141
1371452 1371452 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2020   grade_8 111 1 7 0   17     0   5   72 69 *                     141.0 111 1 7 0   17     0   5   72 69                 141
1372832 1372832 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2020   grade_8 1 71 58 0   10     0   1   60 81 *                     141.0 1 71 58 0   10     0   1   60 81                 141
1373473 1373473 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2020   grade_8 134 0 3 0   1     0   4   74 67 *                     142.0 134 0 3 0   1     0   4   74 67                 142
1369822 1369822 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2020   grade_8 115 1 16 0   2     0   9   74 69 *                     143.0 115 1 16 0   2     0   9   74 69                 143
1366237 1366237 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_8 51 62 16 1   5     0   9   71 73 *                     144.0 51 62 16 1   5     0   9   71 73                 144
1366601 1366601 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_8 8 5 129 0   0     0   2   67 77 *                     144.0 8 5 129 0   0     0   2   67 77                 144
1370765 1370765 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2020   grade_8 118 2 16 0   4     0   4   80 64 *                     144.0 118 2 16 0   4     0   4   80 64                 144
1371007 1371007 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_8 18 25 99 0   0     0   2   84 60 *                     144.0 18 25 99 0   0     0   2   84 60                 144
1365031 1365031 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_8 97 6 23 0   8     0   11   81 64 *                     145.0 97 6 23 0   8     0   11   81 64                 145
1371830 1371830 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2020   grade_8 132 2 7 0   0     0   4   71 74 *                     145.0 132 2 7 0   0     0   4   71 74                 145

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