enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2040825 2040825 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_8 3 14 11 1   0     0   0   23 6                       29.0 3 14 11 1   0     0   0   23 6                 29
2042271 2042271 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_8 4 0 2 0   0     0   0   3 3                       6.0 4 0 2 0   0     0   0   3 3                 6
2042772 2042772 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_8 * * * *   *     *   *   2 *                       2.0                         2                   2
2040881 2040881 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_8 1 12 10 0   0     0   1   12 12                       24.0 1 12 10 0   0     0   1   12 12                 24
2040928 2040928 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_8 12 22 16 0   8     0   2   34 26                       60.0 12 22 16 0   8     0   2   34 26                 60
2043455 2043455 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2040712 2040712 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_8 12 20 40 0   2     0   1   47 28                       75.0 12 20 40 0   2     0   1   47 28                 75
2041289 2041289 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_8 * * * *   *     *   *   4 1                       5.0                         4 1                 5
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
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
2042897 2042897 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_8 6 1 59 0   0     0   0   41 25                       66.0 6 1 59 0   0     0   0   41 25                 66
2043315 2043315 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_8 33 5 9 1   1     0   4   24 29                       53.0 33 5 9 1   1     0   4   24 29                 53
2043893 2043893 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2019   grade_8 74 1 10 0   2     0   4   48 43                       91.0 74 1 10 0   2     0   4   48 43                 91
2044417 2044417 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_8 9 3 7 0   0     0   1   12 8                       20.0 9 3 7 0   0     0   1   12 8                 20
2047841 2047841 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2019   grade_8 33 3 3 1   1     0   0   25 16                       41.0 33 3 3 1   1     0   0   25 16                 41
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
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
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
2040050 2040050 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_8 109 4 7 0   5     0   11   71 65                       136.0 109 4 7 0   5     0   11   71 65                 136
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
2040058 2040058 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_8 97 8 24 0   8     0   2   83 56                       139.0 97 8 24 0   8     0   2   83 56                 139
2040204 2040204 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_8 224 16 13 0   65     1   19   163 175                       338.0 224 16 13 0   65     1   19   163 175                 338
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
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
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
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
2041634 2041634 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2019   grade_8 152 6 6 0   29     0   7   98 102                       200.0 152 6 6 0   29     0   7   98 102                 200
2041662 2041662 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_8 11 6 103 0   2     0   2   65 59                       124.0 11 6 103 0   2     0   2   65 59                 124
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
2041670 2041670 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2019   grade_8 9 4 123 0   2     0   0   67 71                       138.0 9 4 123 0   2     0   0   67 71                 138
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
2042034 2042034 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_8 81 2 14 0   3     0   2   59 43                       102.0 81 2 14 0   3     0   2   59 43                 102
2042329 2042329 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_8 56 15 107 0   13     0   9   100 100                       200.0 56 15 107 0   13     0   9   100 100                 200
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
2042390 2042390 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2019   grade_8 171 8 11 2   3     0   5   92 108                       200.0 171 8 11 2   3     0   5   92 108                 200
2042689 2042689 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_8 172 2 2 0   5     0   0   91 90                       181.0 172 2 2 0   5     0   0   91 90                 181
2042753 2042753 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_8 69 7 58 0   5     0   1   75 65                       140.0 69 7 58 0   5     0   1   75 65                 140
2042789 2042789 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_8 80 5 34 0   2     1   1   58 65                       123.0 80 5 34 0   2     1   1   58 65                 123
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
2043087 2043087 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_8 4 3 125 0   0     0   1   65 68                       133.0 4 3 125 0   0     0   1   65 68                 133
2043091 2043091 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_8 5 0 158 0   1     0   0   88 76                       164.0 5 0 158 0   1     0   0   88 76                 164
2043138 2043138 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_8 6 2 119 0   2     0   1   71 59                       130.0 6 2 119 0   2     0   1   71 59                 130
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
2043473 2043473 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2019   grade_8 42 9 34 0   76     0   7   91 77                       168.0 42 9 34 0   76     0   7   91 77                 168
2043481 2043481 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2019   grade_8 39 20 61 0   27     0   5   81 71                       152.0 39 20 61 0   27     0   5   81 71                 152
2043488 2043488 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2019   grade_8 35 14 75 0   22     0   7   93 60                       153.0 35 14 75 0   22     0   7   93 60                 153
2043492 2043492 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2019   grade_8 17 5 59 0   81     0   6   92 76                       168.0 17 5 59 0   81     0   6   92 76                 168
2043696 2043696 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2019   grade_8 124 3 14 0   9     0   5   88 67                       155.0 124 3 14 0   9     0   5   88 67                 155
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
2043964 2043964 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2019   grade_8 157 1 9 1   5     0   2   78 97                       175.0 157 1 9 1   5     0   2   78 97                 175
2044124 2044124 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2019   grade_8 89 2 12 0   0     0   3   55 51                       106.0 89 2 12 0   0     0   3   55 51                 106
2044172 2044172 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2019   grade_8 48 0 1 1   0     0   0   20 30                       50.0 48 0 1 1   0     0   0   20 30                 50
2044228 2044228 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2019   grade_8 130 2 8 0   19     0   3   75 87                       162.0 130 2 8 0   19     0   3   75 87                 162
2044232 2044232 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2019   grade_8 167 11 14 0   14     0   15   111 110                       221.0 167 11 14 0   14     0   15   111 110                 221
2044736 2044736 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2019   grade_8 163 2 11 0   0     0   8   100 84                       184.0 163 2 11 0   0     0   8   100 84                 184
2045252 2045252 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No Middle 05 08 2019   grade_8 35 13 11 1   18     0   3   43 38                       81.0 35 13 11 1   18     0   3   43 38                 81
2045257 2045257 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2019   grade_8 32 10 9 0   33     0   3   45 42                       87.0 32 10 9 0   33     0   3   45 42                 87
2045433 2045433 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2019   grade_8 136 8 15 0   2     0   4   93 72                       165.0 136 8 15 0   2     0   4   93 72                 165
2045842 2045842 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2019   grade_8 115 5 20 0   0     0   6   66 80                       146.0 115 5 20 0   0     0   6   66 80                 146
2046179 2046179 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2019   grade_8 142 2 15 2   7     0   7   94 81                       175.0 142 2 15 2   7     0   7   94 81                 175
2046301 2046301 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2019   grade_8 143 6 16 1   4     0   4   86 88                       174.0 143 6 16 1   4     0   4   86 88                 174
2046483 2046483 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2019   grade_8 213 10 15 0   7     1   5   137 114                       251.0 213 10 15 0   7     1   5   137 114                 251
2046680 2046680 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2019   grade_8 87 12 40 0   2     0   9   55 95                       150.0 87 12 40 0   2     0   9   55 95                 150
2047528 2047528 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_8 29 14 123 4   3     2   0   81 94                       175.0 29 14 123 4   3     2   0   81 94                 175
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
2047655 2047655 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_8 81 3 6 0   5     0   5   57 43                       100.0 81 3 6 0   5     0   5   57 43                 100
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
2047925 2047925 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2019   grade_8 78 1 4 2   2     0   4   41 50                       91.0 78 1 4 2   2     0   4   41 50                 91
2047933 2047933 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_8 4 153 91 0   1     1   0   119 131                       250.0 4 153 91 0   1     1   0   119 131                 250
2048023 2048023 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2019   grade_8 47 10 30 0   1     0   7   52 43                       95.0 47 10 30 0   1     0   7   52 43                 95
2048044 2048044 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2019   grade_8 5 19 42 0   1     0   0   30 37                       67.0 5 19 42 0   1     0   0   30 37                 67
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
2048197 2048197 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2019   grade_8 87 0 9 0   4     0   2   51 51                       102.0 87 0 9 0   4     0   2   51 51                 102
2048247 2048247 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2019   grade_8 153 6 0 0   3     1   16   94 85                       179.0 153 6 0 0   3     1   16   94 85                 179
2048336 2048336 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_8 95 1 4 0   1     0   4   58 47                       105.0 95 1 4 0   1     0   4   58 47                 105
2048340 2048340 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2019   grade_8 134 0 5 0   1     0   6   59 87                       146.0 134 0 5 0   1     0   6   59 87                 146
2048369 2048369 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2019   grade_8 131 3 7 0   3     0   5   68 81                       149.0 131 3 7 0   3     0   5   68 81                 149
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
2048457 2048457 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2019   grade_8 159 1 4 1   10     1   3   103 76                       179.0 159 1 4 1   10     1   3   103 76                 179
2048600 2048600 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2019   grade_8 184 0 7 0   6     0   3   93 107                       200.0 184 0 7 0   6     0   3   93 107                 200
2048701 2048701 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2019   grade_8 105 0 7 0   0     0   2   61 53                       114.0 105 0 7 0   0     0   2   61 53                 114
2048769 2048769 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2019   grade_8 99 0 1 0   0     0   2   45 57                       102.0 99 0 1 0   0     0   2   45 57                 102
2048778 2048778 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2019   grade_8 118 0 3 0   4     0   2   71 56                       127.0 118 0 3 0   4     0   2   71 56                 127
2048968 2048968 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_8 87 2 17 0   2     0   1   61 48                       109.0 87 2 17 0   2     0   1   61 48                 109
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
2049139 2049139 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_8 128 1 4 0   0     0   2   86 49                       135.0 128 1 4 0   0     0   2   86 49                 135
2039945 2039945 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2019   grade_8 162 1 6 2   26     0   4   97 104                       201.0 162 1 6 2   26     0   4   97 104                 201
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
2039951 2039951 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_8 77 2 11 0   35     0   4   54 75                       129.0 77 2 11 0   35     0   4   54 75                 129
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
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
2040136 2040136 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_8 126 14 12 0   32     0   7   96 95                       191.0 126 14 12 0   32     0   7   96 95                 191
2040299 2040299 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_8 181 9 10 0   12     1   4   107 110                       217.0 181 9 10 0   12     1   4   107 110                 217
2040302 2040302 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2019   grade_8 147 2 8 0   6     1   4   83 85                       168.0 147 2 8 0   6     1   4   83 85                 168
2040430 2040430 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_8 0 42 17 0   0     0   2   32 29                       61.0 0 42 17 0   0     0   2   32 29                 61
2040573 2040573 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2019   grade_8 7 39 73 1   2     0   2   62 62                       124.0 7 39 73 1   2     0   2   62 62                 124
2040914 2040914 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2019   grade_8 0 74 72 0   16     1   4   99 68                       167.0 0 74 72 0   16     1   4   99 68                 167
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
2040939 2040939 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2019   grade_8 2 43 48 2   2     0   0   51 46                       97.0 2 43 48 2   2     0   0   51 46                 97
2040942 2040942 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_8 1 43 66 0   0     1   0   48 63                       111.0 1 43 66 0   0     1   0   48 63                 111

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