enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
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
735928 735928 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_7 164 4 10 1   6     0   11   106 90                       196 164 4 10 1   6     0   11   106 90                 196
737617 737617 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_7 87 7 31 1   1     0   2   73 56                       129 87 7 31 1   1     0   2   73 56                 129
737782 737782 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_7 140 0 2 0   3     1   4   65 85                       150 140 0 2 0   3     1   4   65 85                 150
738171 738171 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_7 39 13 74 0   14     0   8   68 80                       148 39 13 74 0   14     0   8   68 80                 148
738181 738181 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_7 44 7 47 0   6     0   8   66 46                       112 44 7 47 0   6     0   8   66 46                 112
738191 738191 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_7 29 3 27 0   5     0   5   34 35                       69 29 3 27 0   5     0   5   34 35                 69
738362 738362 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_7 164 10 26 0   4     0   9   108 105                       213 164 10 26 0   4     0   9   108 105                 213
738443 738443 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2015   grade_7 203 0 12 0   33     0   3   138 113                       251 203 0 12 0   33     0   3   138 113                 251
738548 738548 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_7 78 1 4 0   9     0   2   45 49                       94 78 1 4 0   9     0   2   45 49                 94
738789 738789 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_7 84 1 2 0   3     0   0   40 50                       90 84 1 2 0   3     0   0   40 50                 90
739048 739048 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_7 122 2 6 0   3     0   4   71 66                       137 122 2 6 0   3     0   4   71 66                 137
739097 739097 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No 2 06 08 2015   grade_7 104 7 41 0   1     0   5   75 83                       158 104 7 41 0   1     0   5   75 83                 158
739100 739100 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2015   grade_7 160 20 81 1   8     4   10   144 140                       284 160 20 81 1   8     4   10   144 140                 284
739388 739388 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_7 106 4 2 0   2     0   0   63 51                       114 106 4 2 0   2     0   0   63 51                 114
739954 739954 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 07 2015   grade_7 229 9 58 6   7     0   7   157 159                       316 229 9 58 6   7     0   7   157 159                 316
739969 739969 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_7 129 0 11 0   0     0   2   64 78                       142 129 0 11 0   0     0   2   64 78                 142
740598 740598 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2015   grade_7 170 2 7 1   22     2   4   119 89                       208 170 2 7 1   22     2   4   119 89                 208
740608 740608 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_7 159 0 11 0   2     0   7   93 86                       179 159 0 11 0   2     0   7   93 86                 179
740623 740623 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2015   grade_7 47 0 2 0   1     0   1   28 23                       51 47 0 2 0   1     0   1   28 23                 51
740759 740759 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2015   grade_7 * * * *   *     *   *   1 1                       2                         1 1                 2
740765 740765 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2015   grade_7 123 0 17 0   1     0   3   67 77                       144 123 0 17 0   1     0   3   67 77                 144
741562 741562 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2015   grade_7 360 12 31 2   113     0   11   285 244                       529 360 12 31 2   113     0   11   285 244                 529
741703 741703 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2015   grade_7 126 2 8 0   18     1   5   83 77                       160 126 2 8 0   18     1   5   83 77                 160
741718 741718 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2015   grade_7 87 2 91 0   5     1   0   90 96                       186 87 2 91 0   5     1   0   90 96                 186
742152 742152 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2015   grade_7 112 1 1 0   0     0   3   48 69                       117 112 1 1 0   0     0   3   48 69                 117
742322 742322 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2015   grade_7 125 1 4 2   3     0   7   82 60                       142 125 1 4 2   3     0   7   82 60                 142
742553 742553 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett Jr Sr High School   Regular School No 3 07 12 2015   grade_7 100 6 21 0   4     0   11   75 67                       142 100 6 21 0   4     0   11   75 67                 142
742634 742634 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No 2 07 08 2015   grade_7 175 6 12 0   69     0   6   145 123                       268 175 6 12 0   69     0   6   145 123                 268
742649 742649 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2015   grade_7 69 1 8 0   0     0   2   37 43                       80 69 1 8 0   0     0   2   37 43                 80
743351 743351 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2015   grade_7 5 1 30 0   6     0   2   24 20                       44 5 1 30 0   6     0   2   24 20                 44
743357 743357 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_7 7 9 80 0   8     0   3   49 58                       107 7 9 80 0   8     0   3   49 58                 107
743363 743363 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2015   grade_7 105 59 108 2   9     0   6   132 157                       289 105 59 108 2   9     0   6   132 157                 289
743365 743365 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2015   grade_7 241 52 143 0   24     0   28   267 221                       488 241 52 143 0   24     0   28   267 221                 488
743368 743368 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2015   grade_7 78 74 157 0   29     0   17   175 180                       355 78 74 157 0   29     0   17   175 180                 355
743371 743371 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2015   grade_7 95 69 175 0   50     0   17   198 208                       406 95 69 175 0   50     0   17   198 208                 406
743609 743609 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_7 38 23 47 0   5     0   4   59 58                       117 38 23 47 0   5     0   4   59 58                 117
743759 743759 MA Worcester   school 2500073 474   The Sizer School: A North Central Charter Essential (District) 250007301750 4740505 The Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2015   grade_7 58 5 6 0   1     0   1   38 33                       71 58 5 6 0   1     0   1   38 33                 71
743834 743834 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2015   grade_7 7 23 26 0   1     0   1   31 27                       58 7 23 26 0   1     0   1   31 27                 58
744012 744012 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2015   grade_7 178 3 3 0   2     0   3   99 90                       189 178 3 3 0   2     0   3   99 90                 189
744039 744039 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_7 99 2 10 0   1     0   0   57 55                       112 99 2 10 0   1     0   0   57 55                 112
744083 744083 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2015   grade_7 78 2 4 0   0     0   0   48 36                       84 78 2 4 0   0     0   0   48 36                 84
744103 744103 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2015   grade_7 140 0 8 0   1     0   1   69 81                       150 140 0 8 0   1     0   1   69 81                 150
744249 744249 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2015   grade_7 146 6 12 2   1     0   2   94 75                       169 146 6 12 2   1     0   2   94 75                 169
744253 744253 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2015   grade_7 168 4 10 0   3     0   2   89 98                       187 168 4 10 0   3     0   2   89 98                 187
744481 744481 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 05 08 2015   grade_7 191 2 4 0   3     0   5   99 106                       205 191 2 4 0   3     0   5   99 106                 205
744571 744571 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2015   grade_7 109 1 2 0   0     0   1   51 62                       113 109 1 2 0   0     0   1   51 62                 113
744599 744599 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_7 77 0 3 0   3     0   2   41 44                       85 77 0 3 0   3     0   2   41 44                 85
744602 744602 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2015   grade_7 71 2 1 0   1     0   1   38 38                       76 71 2 1 0   1     0   1   38 38                 76
744605 744605 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2015   grade_7 85 0 2 0   3     0   2   45 47                       92 85 0 2 0   3     0   2   45 47                 92
744755 744755 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No 2 07 08 2015   grade_7 188 1 4 0   2     0   5   102 98                       200 188 1 4 0   2     0   5   102 98                 200
744847 744847 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_7 99 2 13 0   1     0   1   77 39                       116 99 2 13 0   1     0   1   77 39                 116
744854 744854 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No 2 07 08 2015   grade_7 252 2 16 1   3     0   8   132 150                       282 252 2 16 1   3     0   8   132 150                 282
744946 744946 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2015   grade_7 60 3 3 0   2     0   0   32 36                       68 60 3 3 0   2     0   0   32 36                 68
744955 744955 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2015   grade_7 48 0 0 0   0     0   2   25 25                       50 48 0 0 0   0     0   2   25 25                 50
744961 744961 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2015   grade_7 199 6 14 0   7     0   10   122 114                       236 199 6 14 0   7     0   10   122 114                 236
744964 744964 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2015   grade_7 117 1 8 0   1     0   2   66 63                       129 117 1 8 0   1     0   2   66 63                 129
744968 744968 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2015   grade_7 103 0 4 0   4     0   0   61 50                       111 103 0 4 0   4     0   0   61 50                 111
744991 744991 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2015   grade_7 87 3 4 0   1     0   0   55 40                       95 87 3 4 0   1     0   0   55 40                 95
932802 932802 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2016   grade_7 181 3 6 1   10     0   5   100 106                       206 181 3 6 1   10     0   5   100 106                 206
934477 934477 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_7 102 15 29 0   2     0   3   79 72                       151 102 15 29 0   2     0   3   79 72                 151
934639 934639 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2016   grade_7 119 2 3 0   0     1   2   62 65                       127 119 2 3 0   0     1   2   62 65                 127
935025 935025 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_7 53 11 80 0   7     0   16   73 94                       167 53 11 80 0   7     0   16   73 94                 167
935035 935035 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_7 35 8 58 0   3     0   9   58 55                       113 35 8 58 0   3     0   9   58 55                 113
935045 935045 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_7 26 5 36 0   3     0   8   32 46                       78 26 5 36 0   3     0   8   32 46                 78
935213 935213 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 05 07 2016   grade_7 149 3 24 0   3     0   10   99 90                       189 149 3 24 0   3     0   10   99 90                 189
935295 935295 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2016   grade_7 176 4 9 0   23     0   8   107 113                       220 176 4 9 0   23     0   8   107 113                 220
935398 935398 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_7 79 3 3 0   11     0   3   52 47                       99 79 3 3 0   11     0   3   52 47                 99
935638 935638 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_7 78 0 1 1   4     0   1   42 43                       85 78 0 1 1   4     0   1   42 43                 85
935897 935897 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2016   grade_7 102 2 10 0   3     0   1   68 50                       118 102 2 10 0   3     0   1   68 50                 118
935945 935945 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No 2 06 08 2016   grade_7 92 13 46 0   4     0   2   81 76                       157 92 13 46 0   4     0   2   81 76                 157
935948 935948 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2016   grade_7 160 17 88 0   10     0   8   155 128                       283 160 17 88 0   10     0   8   155 128                 283
936235 936235 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_7 112 1 5 1   0     0   0   69 50                       119 112 1 5 1   0     0   0   69 50                 119
936798 936798 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_7 209 9 72 6   5     0   10   163 148                       311 209 9 72 6   5     0   10   163 148                 311
936815 936815 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2016   grade_7 125 2 8 0   2     0   5   67 75                       142 125 2 8 0   2     0   5   67 75                 142
937428 937428 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2016   grade_7 194 2 10 2   25     0   10   131 112                       243 194 2 10 2   25     0   10   131 112                 243
937438 937438 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2016   grade_7 174 0 10 0   2     1   6   101 92                       193 174 0 10 0   2     1   6   101 92                 193
937452 937452 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2016   grade_7 24 0 2 0   0     0   3   14 15                       29 24 0 2 0   0     0   3   14 15                 29
937594 937594 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2016   grade_7 127 1 8 0   5     0   2   76 67                       143 127 1 8 0   5     0   2   76 67                 143
938367 938367 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2016   grade_7 292 11 31 2   126     0   18   247 233                       480 292 11 31 2   126     0   18   247 233                 480
938506 938506 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2016   grade_7 122 0 7 0   23     0   4   83 73                       156 122 0 7 0   23     0   4   83 73                 156
938522 938522 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2016   grade_7 72 3 95 2   1     0   3   92 84                       176 72 3 95 2   1     0   3   92 84                 176
938962 938962 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2016   grade_7 111 3 0 0   3     0   6   66 57                       123 111 3 0 0   3     0   6   66 57                 123
939131 939131 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2016   grade_7 146 2 6 0   3     0   3   81 79                       160 146 2 6 0   3     0   3   81 79                 160
939362 939362 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No 2 05 08 2016   grade_7 109 10 35 0   1     1   13   87 82                       169 109 10 35 0   1     1   13   87 82                 169
939442 939442 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No 2 07 08 2016   grade_7 203 4 19 1   78     1   10   181 135                       316 203 4 19 1   78     1   10   181 135                 316
939456 939456 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2016   grade_7 70 2 2 0   0     0   3   37 40                       77 70 2 2 0   0     0   3   37 40                 77
940160 940160 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2016   grade_7 3 5 24 0   12     0   1   21 24                       45 3 5 24 0   12     0   1   21 24                 45
940166 940166 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2016   grade_7 3 4 60 0   6     0   1   44 30                       74 3 4 60 0   6     0   1   44 30                 74
940172 940172 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2016   grade_7 74 49 120 1   8     0   14   127 139                       266 74 49 120 1   8     0   14   127 139                 266
940174 940174 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_7 235 53 145 1   33     0   26   255 238                       493 235 53 145 1   33     0   26   255 238                 493
940177 940177 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_7 82 74 167 1   28     0   23   198 177                       375 82 74 167 1   28     0   23   198 177                 375
940180 940180 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_7 114 61 168 1   41     0   15   216 184                       400 114 61 168 1   41     0   15   216 184                 400
940432 940432 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_7 27 49 34 1   7     0   2   54 66                       120 27 49 34 1   7     0   2   54 66                 120
940588 940588 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2016   grade_7 53 1 9 0   1     0   1   29 36                       65 53 1 9 0   1     0   1   29 36                 65
940664 940664 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2016   grade_7 6 17 26 0   1     0   1   26 25                       51 6 17 26 0   1     0   1   26 25                 51
940846 940846 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2016   grade_7 189 0 7 0   3     0   1   99 101                       200 189 0 7 0   3     0   1   99 101                 200
940873 940873 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_7 99 1 10 0   0     0   4   61 53                       114 99 1 10 0   0     0   4   61 53                 114
940917 940917 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_7 76 1 1 0   5     0   3   44 42                       86 76 1 1 0   5     0   3   44 42                 86
940937 940937 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2016   grade_7 120 2 10 0   3     0   1   69 67                       136 120 2 10 0   3     0   1   69 67                 136
941076 941076 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2016   grade_7 131 3 12 1   4     0   5   83 73                       156 131 3 12 1   4     0   5   83 73                 156

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