enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1367199 1367199 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_8 3 1 0 0   0     0   4   7 1 *                     8.0 3 1 0 0   0     0   4   7 1                 8
1365884 1365884 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_8 4 27 9 0   7     0   4   26 25 *                     51.0 4 27 9 0   7     0   4   26 25                 51
1366220 1366220 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_8 5 3 1 0   0     0   0   7 2 *                     9.0 5 3 1 0   0     0   0   7 2                 9
1367688 1367688 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_8 * * * *   *     *   *   2 * *                     2.0                         2                   2
1365669 1365669 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_8 8 24 34 0   3     0   3   39 33 *                     72.0 8 24 34 0   3     0   3   39 33                 72
1365837 1365837 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_8 0 20 12 0   0     0   4   21 15 *                     36.0 0 20 12 0   0     0   4   21 15                 36
1367982 1367982 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_8 4 2 82 0   3     0   0   48 43 *                     91.0 4 2 82 0   3     0   0   48 43                 91
1368370 1368370 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_8 * * * *   *     *   *   3 * *                     3.0                         3                   3
1367816 1367816 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_8 3 3 42 0   0     0   0   30 18 *                     48.0 3 3 42 0   0     0   0   30 18                 48
1368231 1368231 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_8 18 4 10 0   1     1   5   20 19 *                     39.0 18 4 10 0   1     1   5   20 19                 39
1368822 1368822 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_8 70 1 8 0   2     0   4   39 46 *                     85.0 70 1 8 0   2     0   4   39 46                 85
1369345 1369345 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_8 2 0 5 0   0     0   2   4 5 *                     9.0 2 0 5 0   0     0   2   4 5                 9
1372770 1372770 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2020   grade_8 26 3 3 0   2     0   2   18 18 *                     36.0 26 3 3 0   2     0   2   18 18                 36
1364793 1364793 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_8 164 6 14 0   3     0   0   106 81 *                     187.0 164 6 14 0   3     0   0   106 81                 187
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
1364853 1364853 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_8 137 6 21 0   0     1   4   85 84 *                     169.0 137 6 21 0   0     1   4   85 84                 169
1365023 1365023 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_8 124 8 23 0   10     0   12   91 86 *                     177.0 124 8 23 0   10     0   12   91 86                 177
1365027 1365027 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_8 95 10 27 1   9     0   9   74 77 *                     151.0 95 10 27 1   9     0   9   74 77                 151
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
1365178 1365178 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2020   grade_8 246 13 20 1   52     0   26   180 178 *                     358.0 246 13 20 1   52     0   26   180 178                 358
1365192 1365192 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_8 87 2 4 0   0     0   1   50 44 *                     94.0 87 2 4 0   0     0   1   50 44                 94
1365222 1365222 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_8 239 9 54 0   9     0   9   175 145 *                     320.0 239 9 54 0   9     0   9   175 145                 320
1366560 1366560 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_8 120 5 18 0   28     0   2   84 89 *                     173.0 120 5 18 0   28     0   2   84 89                 173
1366564 1366564 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_8 165 12 11 0   33     1   5   116 111 *                     227.0 165 12 11 0   33     1   5   116 111                 227
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
1366597 1366597 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_8 11 2 137 1   0     0   1   78 74 *                     152.0 11 2 137 1   0     0   1   78 74                 152
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
1366700 1366700 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_8 91 3 51 0   2     0   0   74 73 *                     147.0 91 3 51 0   2     0   0   74 73                 147
1366963 1366963 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_8 78 0 11 0   6     0   2   39 58 *                     97.0 78 0 11 0   6     0   2   39 58                 97
1367259 1367259 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_8 50 10 94 0   14     0   10   82 96 *                     178.0 50 10 94 0   14     0   10   82 96                 178
1367269 1367269 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_8 33 10 95 0   7     0   10   85 70 *                     155.0 33 10 95 0   7     0   10   85 70                 155
1367318 1367318 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_8 168 16 15 0   4     1   5   108 100 *                     209.0 168 16 15 0   4     1   5   108 100                 209
1367611 1367611 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_8 208 5 5 0   5     0   1   125 99 *                     224.0 208 5 5 0   5     0   1   125 99                 224
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
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
1367707 1367707 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_8 101 9 100 1   4     0   1   119 97 *                     216.0 101 9 100 1   4     0   1   119 97                 216
1367986 1367986 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_8 2 1 146 0   0     0   0   74 73 *                     149.0 2 1 146 0   0     0   0   74 73                 149
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
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
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
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
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
1368388 1368388 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2020   grade_8 51 5 32 0   79     0   6   91 82 *                     173.0 51 5 32 0   79     0   6   91 82                 173
1368397 1368397 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2020   grade_8 39 15 85 0   26     0   6   82 89 *                     171.0 39 15 85 0   26     0   6   82 89                 171
1368401 1368401 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2020   grade_8 56 16 71 0   27     0   5   98 77 *                     175.0 56 16 71 0   27     0   5   98 77                 175
1368405 1368405 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2020   grade_8 57 18 82 0   33     0   10   89 111 *                     200.0 57 18 82 0   33     0   10   89 111                 200
1368409 1368409 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2020   grade_8 23 8 56 0   84     0   6   87 90 *                     177.0 23 8 56 0   84     0   6   87 90                 177
1368630 1368630 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2020   grade_8 153 2 9 0   7     0   4   85 90 *                     175.0 153 2 9 0   7     0   4   85 90                 175
1368746 1368746 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_8 108 6 179 0   4     0   13   149 161 *                     310.0 108 6 179 0   4     0   13   149 161                 310
1368893 1368893 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2020   grade_8 144 5 10 1   4     0   2   80 86 *                     166.0 144 5 10 1   4     0   2   80 86                 166
1369157 1369157 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2020   grade_8 120 4 10 0   18     0   4   76 80 *                     156.0 120 4 10 0   18     0   4   76 80                 156
1369161 1369161 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_8 192 6 7 0   13     0   14   124 108 *                     232.0 192 6 7 0   13     0   14   124 108                 232
1369663 1369663 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2020   grade_8 139 4 12 0   1     1   7   76 88 *                     164.0 139 4 12 0   1     1   7   76 88                 164
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
1370183 1370183 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2020   grade_8 26 9 9 0   28     0   2   40 34 *                     74.0 26 9 9 0   28     0   2   40 34                 74
1370360 1370360 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2020   grade_8 106 15 31 0   3     0   5   74 86 *                     160.0 106 15 31 0   3     0   5   74 86                 160
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
1371104 1371104 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2020   grade_8 136 5 16 0   11     0   8   84 92 *                     176.0 136 5 16 0   11     0   8   84 92                 176
1371226 1371226 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2020   grade_8 138 9 22 0   4     0   3   83 92 *                     176.0 138 9 22 0   4     0   3   83 92                 176
1371409 1371409 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2020   grade_8 205 9 23 2   7     0   7   128 125 *                     253.0 205 9 23 2   7     0   7   128 125                 253
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
1372455 1372455 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_8 19 9 142 1   3     1   2   95 82 *                     177.0 19 9 142 1   3     1   2   95 82                 177
1372471 1372471 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 2020   grade_8 5 43 25 0   1     0   1   33 42 *                     75.0 5 43 25 0   1     0   1   33 42                 75
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
1372697 1372697 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_8 27 39 22 0   3     0   4   57 38 *                     95.0 27 39 22 0   3     0   4   57 38                 95
1372853 1372853 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2020   grade_8 76 1 3 2   2     0   7   45 46 *                     91.0 76 1 3 2   2     0   7   45 46                 91
1372861 1372861 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_8 1 126 94 2   4     2   2   125 106 *                     231.0 1 126 94 2   4     2   2   125 106                 231
1372951 1372951 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2020   grade_8 34 12 41 1   0     0   3   45 46 *                     91.0 34 12 41 1   0     0   3   45 46                 91
1372972 1372972 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2020   grade_8 2 5 55 0   0     0   3   33 32 *                     65.0 2 5 55 0   0     0   3   33 32                 65
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
1373123 1373123 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_8 65 2 5 1   5     0   6   42 42 *                     84.0 65 2 5 1   5     0   6   42 42                 84
1373186 1373186 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_8 121 12 4 0   7     0   2   66 80 *                     146.0 121 12 4 0   7     0   2   66 80                 146
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
1373278 1373278 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_8 142 0 7 0   3     0   5   83 74 *                     157.0 142 0 7 0   3     0   5   83 74                 157
1373307 1373307 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2020   grade_8 130 2 14 0   1     0   4   69 82 *                     151.0 130 2 14 0   1     0   4   69 82                 151
1373311 1373311 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2020   grade_8 145 1 14 0   2     0   3   82 83 *                     165.0 145 1 14 0   2     0   3   82 83                 165
1373393 1373393 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_8 185 2 2 1   9     1   3   105 98 *                     203.0 185 2 2 1   9     1   3   105 98                 203
1373539 1373539 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2020   grade_8 173 1 13 0   4     0   12   105 98 *                     203.0 173 1 13 0   4     0   12   105 98                 203
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
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
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
1374014 1374014 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2020   grade_8 88 0 4 0   1     0   2   42 53 *                     95.0 88 0 4 0   1     0   2   42 53                 95
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
1364918 1364918 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_8 141 4 14 0   17     0   5   77 104 *                     181.0 141 4 14 0   17     0   5   77 104                 181
1364921 1364921 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_8 121 10 10 0   28     0   3   86 86 *                     172.0 121 10 10 0   28     0   3   86 86                 172
1364924 1364924 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_8 79 4 14 0   46     0   5   81 67 *                     148.0 79 4 14 0   46     0   5   81 67                 148
1364989 1364989 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_8 140 4 27 2   30     0   7   104 106 *                     210.0 140 4 27 2   30     0   7   104 106                 210
1365051 1365051 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_8 171 4 17 0   10     0   7   114 95 *                     209.0 171 4 17 0   10     0   7   114 95                 209
1365111 1365111 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2020   grade_8 113 11 15 0   28     0   14   101 80 *                     181.0 113 11 15 0   28     0   14   101 80                 181
1365387 1365387 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_8 1 43 18 0   0     2   1   30 35 *                     65.0 1 43 18 0   0     2   1   30 35                 65
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
1365870 1365870 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2020   grade_8 4 70 77 0   8     0   6   95 70 *                     165.0 4 70 77 0   8     0   6   95 70                 165
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
1365895 1365895 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2020   grade_8 5 36 37 1   1     0   2   47 35 *                     82.0 5 36 37 1   1     0   2   47 35                 82
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
1365988 1365988 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2020   grade_8 3 17 19 0   43     0   3   42 43 *                     85.0 3 17 19 0   43     0   3   42 43                 85
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
1366066 1366066 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_8 150 2 9 3   2     0   5   86 85 *                     171.0 150 2 9 3   2     0   5   86 85                 171
1366118 1366118 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2020   grade_8 145 10 15 0   41     0   1   109 103 *                     212.0 145 10 15 0   41     0   1   109 103                 212
1366121 1366121 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_8 169 14 10 0   34     0   0   108 118 *                     227.0 169 14 10 0   34     0   0   108 118                 227

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