enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 493 ✖

grade ✖

  • grade_8 · 493 ✖
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
2043816 2043816 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_8 117 13 174 0   8     0   8   178 142                       320.0 117 13 174 0   8     0   8   178 142                 320
2047885 2047885 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_8 47 4 20 0   0     0   3   39 35                       74.0 47 4 20 0   0     0   3   39 35                 74
2042370 2042370 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_8 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2047738 2047738 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 2019   grade_8 25 61 25 0   3     0   6   64 56                       120.0 25 61 25 0   3     0   6   64 56                 120
2039819 2039819 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_8 147 7 12 0   3     0   3   83 89                       172.0 147 7 12 0   3     0   3   83 89                 172
2047544 2047544 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_8 3 43 23 0   0     0   4   34 39                       73.0 3 43 23 0   0     0   4   34 39                 73
2047635 2047635 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_8 109 4 13 0   18     0   14   89 69                       158.0 109 4 13 0   18     0   14   89 69                 158
2039859 2039859 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2019   grade_8 251 4 25 0   13     0   7   153 147                       300.0 251 4 25 0   13     0   7   153 147                 300
2039834 2039834 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_8 108 1 1 0   0     0   1   52 59                       111.0 108 1 1 0   0     0   1   52 59                 111
2045751 2045751 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   grade_8 21 2 16 0   4     0   0   27 16                       43.0 21 2 16 0   4     0   0   27 16                 43
2043066 2043066 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_8 6 0 88 0   3     0   0   46 51                       97.0 6 0 88 0   3     0   0   46 51                 97
2045961 2045961 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_8 7 7 12 0   0     0   3   13 16                       29.0 7 7 12 0   0     0   3   13 16                 29
2047524 2047524 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_8 10 9 20 0   0     0   1   18 22                       40.0 10 9 20 0   0     0   1   18 22                 40
2039880 2039880 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_8 141 1 14 0   1     0   8   83 82                       165.0 141 1 14 0   1     0   8   83 82                 165
2048118 2048118 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2019   grade_8 108 15 30 0   21     0   19   105 88                       193.0 108 15 30 0   21     0   19   105 88                 193
2041466 2041466 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_8 14 2 13 0   0     0   7   10 26                       36.0 14 2 13 0   0     0   7   10 26                 36
2039948 2039948 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_8 138 2 6 1   24     0   6   82 95                       177.0 138 2 6 1   24     0   6   82 95                 177
2042502 2042502 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_8 145 0 4 0   6     1   2   92 65                       158.0 145 0 4 0   6     1   2   92 65                 158
2049311 2049311 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_8 70 8 17 1   2     0   5   54 49                       103.0 70 8 17 1   2     0   5   54 49                 103
2043070 2043070 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_8 3 0 165 0   0     0   1   95 74                       169.0 3 0 165 0   0     0   1   95 74                 169
2045732 2045732 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_8 12 7 11 0   6     1   2   19 20                       39.0 12 7 11 0   6     1   2   19 20                 39
2042339 2042339 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2019   grade_8 43 10 82 0   8     0   8   84 67                       151.0 43 10 82 0   8     0   8   84 67                 151
2045332 2045332 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2019   grade_8 132 2 3 1   6     0   4   82 66                       148.0 132 2 3 1   6     0   4   82 66                 148
2041307 2041307 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2019   grade_8 48 93 20 1   5     0   6   97 76                       173.0 48 93 20 1   5     0   6   97 76                 173
2040016 2040016 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2019   grade_8 123 3 25 2   30     0   2   91 94                       185.0 123 3 25 2   30     0   2   91 94                 185
2048161 2048161 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_8 84 0 6 0   1     0   3   48 46                       94.0 84 0 6 0   1     0   3   48 46                 94
2045242 2045242 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_8 55 12 11 0   77     1   5   78 83                       161.0 55 12 11 0   77     1   5   78 83                 161
2047992 2047992 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_8 84 9 10 0   4     0   2   60 49                       109.0 84 9 10 0   4     0   2   60 49                 109
2040079 2040079 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_8 182 4 24 0   7     0   4   121 100                       221.0 182 4 24 0   7     0   4   121 100                 221
2040095 2040095 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_8 35 19 7 0   1     0   4   28 38                       66.0 35 19 7 0   1     0   4   28 38                 66
2048183 2048183 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_8 109 7 18 3   0     1   3   67 74                       141.0 109 7 18 3   0     1   3   67 74                 141
2043469 2043469 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_8 39 9 41 0   31     0   6   63 63                       126.0 39 9 41 0   31     0   6   63 63                 126
2046096 2046096 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2019   grade_8 0 3 17 0   0     0   2   11 11                       22.0 0 3 17 0   0     0   2   11 11                 22
2040122 2040122 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_8 260 25 47 2   5     1   22   157 205                       362.0 260 25 47 2   5     1   22   157 205                 362
2043465 2043465 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_8 8 3 20 0   22     0   1   23 31                       54.0 8 3 20 0   22     0   1   23 31                 54
2049267 2049267 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_8 5 17 59 0   0     0   1   50 32                       82.0 5 17 59 0   0     0   1   50 32                 82
2043709 2043709 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_8 26 12 11 0   39     0   2   42 48                       90.0 26 12 11 0   39     0   2   42 48                 90
2041740 2041740 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2019   grade_8 129 10 101 0   2     0   9   138 113                       251.0 129 10 101 0   2     0   9   138 113                 251
2040170 2040170 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_8 149 5 5 0   5     0   1   79 86                       165.0 149 5 5 0   5     0   1   79 86                 165
2045555 2045555 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2019   grade_8 140 14 42 1   7     1   6   108 103                       211.0 140 14 42 1   7     1   6   108 103                 211
2047764 2047764 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 25 2 3 0   15     0   1   25 21                       46.0 25 2 3 0   15     0   1   25 21                 46
2040218 2040218 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_8 89 0 0 0   0     0   6   48 47                       95.0 89 0 0 0   0     0   6   48 47                 95
2047557 2047557 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_8 53 9 7 0   4     0   5   39 39                       78.0 53 9 7 0   4     0   5   39 39                 78
2040255 2040255 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2019   grade_8 266 11 33 0   7     0   12   166 163                       329.0 266 11 33 0   7     0   12   166 163                 329
2044536 2044536 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2019   grade_8 107 6 23 0   26     0   12   82 92                       174.0 107 6 23 0   26     0   12   82 92                 174
2042052 2042052 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2019   grade_8 188 12 19 0   10     0   4   132 101                       233.0 188 12 19 0   10     0   4   132 101                 233
2046523 2046523 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2019   grade_8 134 1 9 1   2     0   3   71 79                       150.0 134 1 9 1   2     0   3   71 79                 150
2046859 2046859 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2019   grade_8 133 1 1 0   58     0   1   102 92                       194.0 133 1 1 0   58     0   1   102 92                 194
2047768 2047768 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_8 45 25 18 0   1     0   1   49 41                       90.0 45 25 18 0   1     0   1   49 41                 90
2047535 2047535 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2019   grade_8 4 27 29 0   0     0   1   34 27                       61.0 4 27 29 0   0     0   1   34 27                 61
2041025 2041025 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_8 191 29 54 0   113     2   18   190 217                       407.0 191 29 54 0   113     2   18   190 217                 407
2041004 2041004 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_8 97 63 67 0   57     1   13   121 176                       298.0 97 63 67 0   57     1   13   121 176                 298
2047564 2047564 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_8 0 42 14 0   2     1   3   27 35                       62.0 0 42 14 0   2     1   3   27 35                 62
2040349 2040349 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_8 2 9 16 0   1     0   0   12 16                       28.0 2 9 16 0   1     0   0   12 16                 28
2041125 2041125 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_8 159 1 3 1   5     0   8   75 102                       177.0 159 1 3 1   5     0   8   75 102                 177
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
2048249 2048249 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2019   grade_8 224 10 3 1   4     0   7   129 120                       249.0 224 10 3 1   4     0   7   129 120                 249
2045245 2045245 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2019   grade_8 80 11 10 1   18     1   3   54 70                       124.0 80 11 10 1   18     1   3   54 70                 124
2042704 2042704 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_8 57 3 2 0   11     0   1   43 31                       74.0 57 3 2 0   11     0   1   43 31                 74
2047617 2047617 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_8 7 102 55 0   3     0   3   91 79                       170.0 7 102 55 0   3     0   3   91 79                 170
2047458 2047458 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2019   grade_8 105 59 136 0   11     0   12   145 178                       323.0 105 59 136 0   11     0   12   145 178                 323
2042745 2042745 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_8 125 8 32 0   3     0   3   88 83                       171.0 125 8 32 0   3     0   3   88 83                 171
2041539 2041539 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2019   grade_8 33 22 18 0   6     1   5   35 50                       85.0 33 22 18 0   6     1   5   35 50                 85
2042452 2042452 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_8 123 12 27 0   5     0   7   84 90                       174.0 123 12 27 0   5     0   7   84 90                 174
2047651 2047651 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_8 71 2 2 0   2     0   4   36 45                       81.0 71 2 2 0   2     0   4   36 45                 81
2041590 2041590 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   grade_8 49 2 1 0   15     0   4   34 37                       71.0 49 2 1 0   15     0   4   34 37                 71
2041600 2041600 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_8 128 0 2 1   1     0   1   59 74                       133.0 128 0 2 1   1     0   1   59 74                 133
2045248 2045248 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_8 106 8 7 0   92     0   5   113 105                       218.0 106 8 7 0   92     0   5   113 105                 218
2049084 2049084 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2019   grade_8 119 0 3 0   5     0   8   72 63                       135.0 119 0 3 0   5     0   8   72 63                 135
2044539 2044539 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2019   grade_8 153 5 14 0   48     0   19   116 123                       239.0 153 5 14 0   48     0   19   116 123                 239
2044157 2044157 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2019   grade_8 201 55 14 0   19     0   5   123 171                       294.0 201 55 14 0   19     0   5   123 171                 294
2048373 2048373 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2019   grade_8 160 0 9 0   3     1   2   82 93                       175.0 160 0 9 0   3     1   2   82 93                 175
2046099 2046099 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_8 0 7 78 0   0     0   0   43 42                       85.0 0 7 78 0   0     0   0   43 42                 85
2046105 2046105 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2019   grade_8 11 28 47 1   4     1   3   38 57                       95.0 11 28 47 1   4     1   3   38 57                 95
2041703 2041703 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_8 4 0 11 0   0     0   1   7 9                       16.0 4 0 11 0   0     0   1   7 9                 16
2049088 2049088 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2019   grade_8 82 1 8 0   2     0   3   48 48                       96.0 82 1 8 0   2     0   3   48 48                 96
2047580 2047580 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2019   grade_8 80 2 30 1   9     0   4   66 60                       126.0 80 2 30 1   9     0   4   66 60                 126
2047452 2047452 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_8 4 3 69 0   7     0   0   42 41                       83.0 4 3 69 0   7     0   0   42 41                 83
2040936 2040936 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_8 7 17 72 0   8     0   1   63 42                       105.0 7 17 72 0   8     0   1   63 42                 105
2041666 2041666 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_8 3 7 124 1   1     0   1   77 60                       137.0 3 7 124 1   1     0   1   77 60                 137
2041760 2041760 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_8 15 0 0 0   0     0   0   6 9                       15.0 15 0 0 0   0     0   0   6 9                 15
2041770 2041770 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2019   grade_8 93 6 30 0   2     0   0   78 53                       131.0 93 6 30 0   2     0   0   78 53                 131
2047680 2047680 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_8 0 17 1 0   0     0   0   10 8                       18.0 0 17 1 0   0     0   0   10 8                 18
2041785 2041785 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_8 118 3 1 0   4     0   1   64 63                       127.0 118 3 1 0   4     0   1   64 63                 127
2041630 2041630 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2019   grade_8 140 4 5 0   28     0   3   91 89                       180.0 140 4 5 0   28     0   3   91 89                 180
2049280 2049280 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_8 15 10 14 0   16     0   3   26 32                       58.0 15 10 14 0   16     0   3   26 32                 58
2045498 2045498 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2019   grade_8 111 18 88 1   7     0   7   119 113                       232.0 111 18 88 1   7     0   7   119 113                 232
2047662 2047662 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2019   grade_8 1 31 12 1   5     0   2   21 31                       52.0 1 31 12 1   5     0   2   21 31                 52
2047704 2047704 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   grade_8 1 0 18 0   1     0   0   11 9                       20.0 1 0 18 0   1     0   0   11 9                 20
2044028 2044028 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   grade_8 64 2 49 0   10     0   7   60 72                       132.0 64 2 49 0   10     0   7   60 72                 132
2041813 2041813 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2019   grade_8 207 13 9 1   12     0   13   129 125                       255.0 207 13 9 1   12     0   13   129 125                 255
2040526 2040526 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_8 10 25 33 0   2     0   2   41 31                       72.0 10 25 33 0   2     0   2   41 31                 72
2042794 2042794 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_8 97 4 101 0   5     1   2   104 106                       210.0 97 4 101 0   5     1   2   104 106                 210
2047694 2047694 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_8 1 12 8 0   0     0   1   7 15                       22.0 1 12 8 0   0     0   1   7 15                 22
2046108 2046108 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_8 5 15 36 0   0     0   1   10 47                       57.0 5 15 36 0   0     0   1   10 47                 57
2041353 2041353 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_8 42 9 10 0   9     0   12   45 37                       82.0 42 9 10 0   9     0   12   45 37                 82
2040382 2040382 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_8 4 17 55 0   2     0   2   32 48                       80.0 4 17 55 0   2     0   2   32 48                 80
2040054 2040054 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_8 85 10 34 1   3     0   10   75 67                       143.0 85 10 34 1   3     0   10   75 67                 143
2044192 2044192 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2019   grade_8 74 13 41 0   1     0   7   72 64                       136.0 74 13 41 0   1     0   7   72 64                 136
2047191 2047191 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_8 125 9 10 1   7     0   5   79 78                       157.0 125 9 10 1   7     0   5   79 78                 157

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