enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", 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_7 · 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
1366048 1366048 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_7 0 3 5 0   0     0   0   6 2 *                     8.0 0 3 5 0   0     0   0   6 2                 8
1367198 1367198 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_7 2 2 5 0   0     0   2   9 2 *                     11.0 2 2 5 0   0     0   2   9 2                 11
1365883 1365883 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_7 11 24 23 2   3     0   0   30 33 *                     63.0 11 24 23 2   3     0   0   30 33                 63
1366219 1366219 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_7 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1367687 1367687 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_7 * * * *   *     *   *   2 * *                     2.0                         2                   2
1365668 1365668 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_7 6 25 41 0   0     0   3   41 34 *                     75.0 6 25 41 0   0     0   3   41 34                 75
1365836 1365836 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_7 2 22 20 0   0     0   1   31 14 *                     45.0 2 22 20 0   0     0   1   31 14                 45
1367981 1367981 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_7 4 0 78 0   1     0   0   40 43 *                     83.0 4 0 78 0   1     0   0   40 43                 83
1368369 1368369 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_7 4 0 5 0   0     0   0   8 * *                     9.0 4 0 5 0   0     0   0   8                   9
1365143 1365143 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2020   grade_7 149 1 6 0   9     0   0   78 87 *                     165.0 149 1 6 0   9     0   0   78 87                 165
1367815 1367815 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_7 3 2 48 0   0     0   0   33 20 *                     53.0 3 2 48 0   0     0   0   33 20                 53
1368230 1368230 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_7 26 6 7 0   1     0   4   19 25 *                     44.0 26 6 7 0   1     0   4   19 25                 44
1368821 1368821 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_7 74 3 13 0   2     0   2   55 38 *                     94.0 74 3 13 0   2     0   2   55 38                 94
1369344 1369344 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_7 3 2 4 0   0     0   0   6 3 *                     9.0 3 2 4 0   0     0   0   6 3                 9
1371375 1371375 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2020   grade_7 118 1 8 4   2     0   1   66 68 *                     134.0 118 1 8 4   2     0   1   66 68                 134
1372769 1372769 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_7 14 1 2 0   0     0   2   11 8 *                     19.0 14 1 2 0   0     0   2   11 8                 19
1373038 1373038 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_7 84 5 2 0   1     0   2   48 46 *                     94.0 84 5 2 0   1     0   2   48 46                 94
1364792 1364792 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_7 139 3 12 1   4     0   5   86 78 *                     164.0 139 3 12 1   4     0   5   86 78                 164
1364807 1364807 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_7 99 0 6 0   1     0   6   62 50 *                     112.0 99 0 6 0   1     0   6   62 50                 112
1364852 1364852 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_7 132 3 11 0   4     1   5   69 87 *                     156.0 132 3 11 0   4     1   5   69 87                 156
1365022 1365022 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_7 124 12 23 0   5     0   11   97 78 *                     175.0 124 12 23 0   5     0   11   97 78                 175
1365026 1365026 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_7 98 10 40 0   9     0   5   88 74 *                     162.0 98 10 40 0   9     0   5   88 74                 162
1365030 1365030 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_7 84 10 20 0   11     0   7   62 70 *                     132.0 84 10 20 0   11     0   7   62 70                 132
1365177 1365177 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2020   grade_7 228 13 17 0   74     0   27   184 175 *                     359.0 228 13 17 0   74     0   27   184 175                 359
1365191 1365191 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_7 91 0 4 0   0     0   2   48 49 *                     97.0 91 0 4 0   0     0   2   48 49                 97
1365221 1365221 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_7 280 9 55 0   12     0   7   189 174 *                     363.0 280 9 55 0   12     0   7   189 174                 363
1365255 1365255 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 05 07 2020   grade_7 155 16 17 1   12     0   5   104 102 *                     206.0 155 16 17 1   12     0   5   104 102                 206
1365258 1365258 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 05 07 2020   grade_7 147 7 10 0   17     0   7   90 98 *                     188.0 147 7 10 0   17     0   7   90 98                 188
1366559 1366559 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_7 130 4 13 2   26     0   4   107 72 *                     179.0 130 4 13 2   26     0   4   107 72                 179
1366563 1366563 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_7 130 6 14 0   20     0   11   109 72 *                     181.0 130 6 14 0   20     0   11   109 72                 181
1366592 1366592 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_7 7 8 112 0   0     0   2   58 71 *                     129.0 7 8 112 0   0     0   2   58 71                 129
1366596 1366596 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_7 10 6 147 1   2     0   2   96 72 *                     168.0 10 6 147 1   2     0   2   96 72                 168
1366600 1366600 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_7 4 2 140 0   0     0   1   76 71 *                     147.0 4 2 140 0   0     0   1   76 71                 147
1366699 1366699 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_7 92 7 36 0   1     1   3   83 57 *                     140.0 92 7 36 0   1     1   3   83 57                 140
1366962 1366962 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_7 85 1 17 1   6     0   1   53 58 *                     111.0 85 1 17 1   6     0   1   53 58                 111
1367258 1367258 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_7 43 7 83 0   14     0   13   79 81 *                     160.0 43 7 83 0   14     0   13   79 81                 160
1367268 1367268 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_7 31 9 92 0   4     1   12   77 72 *                     149.0 31 9 92 0   4     1   12   77 72                 149
1367317 1367317 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_7 181 13 8 1   8     0   5   117 99 *                     216.0 181 13 8 1   8     0   5   117 99                 216
1367451 1367451 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2020   grade_7 126 3 47 0   5     0   19   104 96 *                     200.0 126 3 47 0   5     0   19   104 96                 200
1367568 1367568 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_7 88 2 21 0   2     0   5   59 59 *                     118.0 88 2 21 0   2     0   5   59 59                 118
1367610 1367610 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_7 193 6 7 0   6     0   3   99 116 *                     215.0 193 6 7 0   6     0   3   99 116                 215
1367669 1367669 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_7 70 6 59 1   5     1   5   73 74 *                     147.0 70 6 59 1   5     1   5   73 74                 147
1367702 1367702 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_7 108 6 33 0   2     0   0   77 72 *                     149.0 108 6 33 0   2     0   0   77 72                 149
1367706 1367706 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_7 118 14 82 1   7     0   2   118 106 *                     224.0 118 14 82 1   7     0   2   118 106                 224
1367913 1367913 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_7 159 6 25 0   2     0   11   105 98 *                     203.0 159 6 25 0   2     0   11   105 98                 203
1367985 1367985 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_7 1 1 162 0   0     0   1   82 83 *                     165.0 1 1 162 0   0     0   1   82 83                 165
1368002 1368002 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_7 5 2 114 0   0     0   2   61 62 *                     123.0 5 2 114 0   0     0   2   61 62                 123
1368006 1368006 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_7 12 3 140 0   1     0   0   71 83 *                     156.0 12 3 140 0   1     0   0   71 83                 156
1368053 1368053 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_7 14 3 109 0   8     0   2   76 60 *                     136.0 14 3 109 0   8     0   2   76 60                 136
1368092 1368092 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_7 83 7 13 0   3     0   5   62 49 *                     111.0 83 7 13 0   3     0   5   62 49                 111
1368383 1368383 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2020   grade_7 37 11 47 0   41     0   8   71 73 *                     144.0 37 11 47 0   41     0   8   71 73                 144
1368387 1368387 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2020   grade_7 41 8 34 0   76     0   7   96 70 *                     166.0 41 8 34 0   76     0   7   96 70                 166
1368396 1368396 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2020   grade_7 32 15 84 0   23     0   4   80 78 *                     158.0 32 15 84 0   23     0   4   80 78                 158
1368400 1368400 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2020   grade_7 55 11 70 0   26     0   13   80 95 *                     175.0 55 11 70 0   26     0   13   80 95                 175
1368404 1368404 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2020   grade_7 52 12 71 0   30     0   7   102 70 *                     172.0 52 12 71 0   30     0   7   102 70                 172
1368408 1368408 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2020   grade_7 17 11 48 0   81     0   10   82 85 *                     167.0 17 11 48 0   81     0   10   82 85                 167
1368629 1368629 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2020   grade_7 135 2 8 0   14     0   2   88 73 *                     161.0 135 2 8 0   14     0   2   88 73                 161
1368745 1368745 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_7 157 13 198 0   7     0   9   197 187 *                     384.0 157 13 198 0   7     0   9   197 187                 384
1368892 1368892 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2020   grade_7 145 2 13 0   5     1   5   91 80 *                     171.0 145 2 13 0   5     1   5   91 80                 171
1369156 1369156 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2020   grade_7 124 5 12 0   13     0   13   95 72 *                     167.0 124 5 12 0   13     0   13   95 72                 167
1369160 1369160 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_7 185 9 13 0   15     0   17   126 113 *                     239.0 185 9 13 0   15     0   17   126 113                 239
1369662 1369662 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2020   grade_7 120 2 18 0   2     0   12   70 84 *                     154.0 120 2 18 0   2     0   12   70 84                 154
1369821 1369821 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2020   grade_7 112 2 23 0   2     0   9   77 71 *                     148.0 112 2 23 0   2     0   9   77 71                 148
1370177 1370177 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 South West Middle School   Regular School No Middle 05 08 2020   grade_7 37 11 10 0   27     1   1   54 33 *                     87.0 37 11 10 0   27     1   1   54 33                 87
1370182 1370182 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2020   grade_7 31 17 14 0   24     0   6   43 49 *                     92.0 31 17 14 0   24     0   6   43 49                 92
1370359 1370359 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2020   grade_7 133 12 35 0   1     0   11   102 90 *                     192.0 133 12 35 0   1     0   11   102 90                 192
1370764 1370764 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2020   grade_7 120 1 25 0   2     0   2   62 88 *                     150.0 120 1 25 0   2     0   2   62 88                 150
1371103 1371103 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2020   grade_7 132 4 24 0   9     0   5   78 96 *                     174.0 132 4 24 0   9     0   5   78 96                 174
1371225 1371225 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2020   grade_7 157 3 16 2   2     0   8   106 82 *                     188.0 157 3 16 2   2     0   8   106 82                 188
1371286 1371286 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2020   grade_7 153 44 27 1   2     1   7   123 112 *                     235.0 153 44 27 1   2     1   7   123 112                 235
1371294 1371294 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2020   grade_7 93 31 29 0   2     1   7   81 82 *                     163.0 93 31 29 0   2     1   7   81 82                 163
1371297 1371297 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2020   grade_7 191 32 31 1   2     0   13   136 134 *                     270.0 191 32 31 1   2     0   13   136 134                 270
1371408 1371408 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2020   grade_7 218 6 22 1   7     0   11   134 131 *                     265.0 218 6 22 1   7     0   11   134 131                 265
1371533 1371533 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2020   grade_7 123 10 7 2   1     0   14   84 73 *                     157.0 123 10 7 2   1     0   14   84 73                 157
1371606 1371606 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2020   grade_7 84 4 52 0   5     1   15   79 82 *                     161.0 84 4 52 0   5     1   15   79 82                 161
1371954 1371954 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_7 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1372454 1372454 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_7 24 8 140 0   0     1   1   88 86 *                     174.0 24 8 140 0   0     1   1   88 86                 174
1372470 1372470 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_7 8 43 22 0   0     0   1   37 37 *                     74.0 8 43 22 0   0     0   1   37 37                 74
1372582 1372582 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_7 75 4 7 0   14     0   1   54 47 *                     101.0 75 4 7 0   14     0   1   54 47                 101
1372696 1372696 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_7 49 34 10 1   0     0   3   51 46 *                     97.0 49 34 10 1   0     0   3   51 46                 97
1372852 1372852 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_7 72 3 6 1   1     0   8   58 33 *                     91.0 72 3 6 1   1     0   8   58 33                 91
1372860 1372860 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_7 0 134 98 0   1     0   1   119 115 *                     234.0 0 134 98 0   1     0   1   119 115                 234
1372950 1372950 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_7 35 9 40 1   1     0   3   42 47 *                     89.0 35 9 40 1   1     0   3   42 47                 89
1372971 1372971 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2020   grade_7 2 16 60 0   0     0   1   36 43 *                     79.0 2 16 60 0   0     0   1   36 43                 79
1373087 1373087 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_7 93 0 12 1   3     0   4   66 47 *                     113.0 93 0 12 1   3     0   4   66 47                 113
1373122 1373122 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_7 77 3 10 0   2     0   5   56 41 *                     97.0 77 3 10 0   2     0   5   56 41                 97
1373185 1373185 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_7 159 13 1 0   4     0   8   115 70 *                     185.0 159 13 1 0   4     0   8   115 70                 185
1373273 1373273 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_7 84 1 7 0   0     0   5   47 50 *                     97.0 84 1 7 0   0     0   5   47 50                 97
1373277 1373277 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_7 127 1 4 0   0     0   7   72 67 *                     139.0 127 1 4 0   0     0   7   72 67                 139
1373306 1373306 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2020   grade_7 113 2 8 1   1     0   1   62 64 *                     126.0 113 2 8 1   1     0   1   62 64                 126
1373310 1373310 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2020   grade_7 145 2 16 0   2     1   3   94 75 *                     169.0 145 2 16 0   2     1   3   94 75                 169
1373392 1373392 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_7 159 5 5 0   10     0   5   88 96 *                     184.0 159 5 5 0   10     0   5   88 96                 184
1373538 1373538 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2020   grade_7 181 0 11 0   6     0   7   107 98 *                     205.0 181 0 11 0   6     0   7   107 98                 205
1373565 1373565 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_7 147 13 16 0   2     1   4   101 82 *                     183.0 147 13 16 0   2     1   4   101 82                 183
1373708 1373708 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_7 125 2 1 0   4     0   3   75 60 *                     135.0 125 2 1 0   4     0   3   75 60                 135
1373717 1373717 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2020   grade_7 133 3 7 0   3     0   4   67 83 *                     150.0 133 3 7 0   3     0   4   67 83                 150
1373894 1373894 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_7 90 3 12 1   1     0   5   55 57 *                     112.0 90 3 12 1   1     0   5   55 57                 112
1374013 1374013 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2020   grade_7 64 1 9 0   3     0   1   38 40 *                     78.0 64 1 9 0   3     0   1   38 40                 78
1374065 1374065 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_7 106 1 6 1   3     0   1   59 59 *                     118.0 106 1 6 1   3     0   1   59 59                 118
1364917 1364917 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_7 139 2 13 1   19     1   4   92 87 *                     179.0 139 2 13 1   19     1   4   92 87                 179

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