enrollments

Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,359 ✖
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
2238166 2238166 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_8 23 62 28 0   7     0   0   54 66                       120.0 23 62 28 0   7     0   0   54 66                 120
2238155 2238155 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   grade_8 17 32 5 2   1     0   1   29 29                       58.0 17 32 5 2   1     0   1   29 29                 58
2238140 2238140 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District): Sabis International Charter School   Regular School Yes Other KG 12 2018   grade_8 30 34 49 0   4     0   11   57 71                       128.0 30 34 49 0   4     0   11   57 71                 128
2238130 2238130 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_8 2 0 19 0   1     0   0   12 10                       22.0 2 0 19 0   1     0   0   12 10                 22
2238119 2238119 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District): Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2018   grade_8 2 23 10 0   0     0   0   19 16                       35.0 2 23 10 0   0     0   0   19 16                 35
2238104 2238104 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_8 0 15 4 0   0     0   1   10 10                       20.0 0 15 4 0   0     0   1   10 10                 20
2238084 2238084 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District): Community Charter School of Cambridge   Regular School Yes High 06 12 2018   grade_8 3 40 13 0   3     0   3   32 30                       62.0 3 40 13 0   3     0   3   32 30                 62
2238076 2238076 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_8 84 4 1 0   9     0   2   48 52                       100.0 84 4 1 0   9     0   2   48 52                 100
2238071 2238071 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District): Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2018   grade_8 68 4 4 0   0     0   5   33 48                       81.0 68 4 4 0   0     0   5   33 48                 81
2238054 2238054 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   grade_8 109 2 12 0   26     0   10   76 83                       159.0 109 2 12 0   26     0   10   76 83                 159
2238046 2238046 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District): KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2018   grade_8 6 28 77 0   4     0   6   61 60                       121.0 6 28 77 0   4     0   6   61 60                 121
2238036 2238036 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_8 6 75 53 0   1     0   3   78 60                       138.0 6 75 53 0   1     0   3   78 60                 138
2237999 2237999 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public (District): Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2018   grade_8 0 71 10 0   0     0   0   45 36                       81.0 0 71 10 0   0     0   0   45 36                 81
2237995 2237995 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public (District): Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2018   grade_8 71 7 22 2   5     1   7   62 53                       115.0 71 7 22 2   5     1   7   62 53                 115
2237978 2237978 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District): Boston Preparatory Charter Public School   Regular School Yes High 06 12 2018   grade_8 0 40 20 0   1     0   0   31 30                       61.0 0 40 20 0   1     0   0   31 30                 61
2237970 2237970 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District): Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2018   grade_8 53 7 6 0   0     0   4   35 35                       70.0 53 7 6 0   0     0   4   35 35                 70
2237962 2237962 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District): Four Rivers Charter Public School   Regular School Yes High 07 12 2018   grade_8 33 1 1 0   0     0   1   21 15                       36.0 33 1 1 0   0     0   1   21 15                 36
2237955 2237955 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   grade_8 11 50 18 0   2     0   0   41 40                       81.0 11 50 18 0   2     0   0   41 40                 81
2237946 2237946 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District): Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2018   grade_8 3 34 23 1   0     0   1   34 28                       62.0 3 34 23 1   0     0   1   34 28                 62
2237939 2237939 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_8 14 9 143 3   3     0   0   81 91                       172.0 14 9 143 3   3     0   0   81 91                 172
2237934 2237934 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   grade_8 15 7 13 0   2     0   2   16 23                       39.0 15 7 13 0   2     0   2   16 23                 39
2237868 2237868 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_8 103 56 164 1   49     0   20   199 194                       393.0 103 56 164 1   49     0   20   199 194                 393
2237864 2237864 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_8 76 57 175 0   22     0   8   174 164                       338.0 76 57 175 0   22     0   8   174 164                 338
2237860 2237860 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   grade_8 213 57 173 0   27     0   22   259 233                       492.0 213 57 173 0   27     0   22   259 233                 492
2237857 2237857 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_8 97 33 125 0   14     0   19   158 130                       288.0 97 33 125 0   14     0   19   158 130                 288
2237850 2237850 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_8 7 9 69 0   9     0   1   46 49                       95.0 7 9 69 0   9     0   1   46 49                 95
2237843 2237843 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_8 4 5 26 0   9     0   0   27 17                       44.0 4 5 26 0   9     0   0   27 17                 44
2237552 2237552 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn: Daniel L Joyce Middle School   Regular School No Middle 06 08 2018   grade_8 142 9 15 2   9     1   6   89 95                       184.0 142 9 15 2   9     1   6   89 95                 184
2237548 2237548 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_8 141 12 19 0   12     0   2   90 96                       186.0 141 12 19 0   12     0   2   90 96                 186
2237480 2237480 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop: Winthrop Middle School   Regular School No Middle 06 08 2018   grade_8 126 1 27 0   1     0   2   85 72                       157.0 126 1 27 0   1     0   2   85 72                 157
2237462 2237462 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_8 263 1 14 1   62     1   17   176 183                       359.0 263 1 14 1   62     1   17   176 183                 359
2237412 2237412 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon: Murdock Middle School   Regular School No Middle 06 08 2018   grade_8 76 4 9 1   3     0   2   50 45                       95.0 76 4 9 1   3     0   2   50 45                 95
2237393 2237393 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington: Wilmington Middle School   Regular School No Middle 06 08 2018   grade_8 270 5 17 1   10     0   8   164 147                       311.0 270 5 17 1   10     0   8   164 147                 311
2237292 2237292 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_8 354 27 32 0   23     1   21   239 218                       458.0 354 27 32 0   23     1   21   239 218                 458
2237274 2237274 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 Westwood: E W Thurston Middle   Regular School No Middle 06 08 2018   grade_8 202 11 9 0   34     0   5   119 142                       261.0 202 11 9 0   34     0   5   119 142                 261
2237229 2237229 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2237213 2237213 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield: West Springfield Middle   Regular School No Middle 06 08 2018   grade_8 193 10 57 1   19     0   6   153 133                       286.0 193 10 57 1   19     0   6   153 133                 286
2237169 2237169 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport: Westport Junior/Senior High School   Regular School No High 07 12 2018   grade_8 108 0 3 0   2     0   5   62 56                       118.0 108 0 3 0   2     0   5   62 56                 118
2237151 2237151 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston: Weston Middle   Regular School No Middle 06 08 2018   grade_8 109 11 7 1   31     0   6   69 96                       165.0 109 11 7 1   31     0   6   69 96                 165
2237118 2237118 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford: Stony Brook School   Regular School No Middle 06 08 2018   grade_8 130 4 4 0   47     0   7   94 98                       192.0 130 4 4 0   47     0   7   94 98                 192
2237114 2237114 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford: Blanchard Middle   Regular School No Middle 06 08 2018   grade_8 144 3 2 1   65     1   2   118 100                       218.0 144 3 2 1   65     1   2   118 100                 218
2237074 2237074 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield: South Middle School   Regular School No Middle 06 08 2018   grade_8 163 3 29 0   6     0   0   107 94                       201.0 163 3 29 0   6     0   0   107 94                 201
2237070 2237070 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 Westfield: North Middle School   Regular School No Middle 06 08 2018   grade_8 184 5 32 0   6     1   4   124 108                       232.0 184 5 32 0   6     1   4   124 108                 232
2237011 2237011 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater: West Bridgewater Junior/Senior   Regular School No High 07 12 2018   grade_8 107 4 4 0   1     0   0   61 55                       116.0 107 4 4 0   1     0   0   61 55                 116
2236993 2236993 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston: West Boylston Junior/Senior High   Regular School No High 06 12 2018   grade_8 77 1 9 1   1     0   4   43 50                       93.0 77 1 9 1   1     0   4   43 50                 93
2236976 2236976 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Westborough: Sarah W Gibbons Middle   Regular School No Middle 07 08 2018   grade_8 183 5 22 0   92     0   16   155 163                       318.0 183 5 22 0   92     0   16   155 163                 318
2236940 2236940 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley: Wellesley Middle   Regular School No Middle 06 08 2018   grade_8 258 17 17 0   40     0   24   176 180                       356.0 258 17 17 0   40     0   24   176 180                 356
2236881 2236881 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster: Webster Middle School   Regular School No Middle 05 08 2018   grade_8 91 12 36 0   3     2   10   70 84                       154.0 91 12 36 0   3     2   10   70 84                 154
2236864 2236864 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland: Wayland Middle School   Regular School No Middle 06 08 2018   grade_8 135 10 8 0   44     1   9   108 99                       207.0 135 10 8 0   44     1   9   108 99                 207
2236834 2236834 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown: Watertown Middle   Regular School No Middle 06 08 2018   grade_8 98 9 28 0   20     0   10   87 78                       165.0 98 9 28 0   20     0   10   87 78                 165
2236796 2236796 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham: Wareham Middle   Regular School No Middle 05 08 2018   grade_8 147 15 8 2   0     0   15   88 99                       187.0 147 15 8 2   0     0   15   88 99                 187
2236779 2236779 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware: Ware Junior/Senior High School   Regular School No High 07 12 2018   grade_8 80 2 6 1   0     0   4   55 38                       93.0 80 2 6 1   0     0   4   55 38                 93
2236761 2236761 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham: John W. McDevitt Middle School   Regular School No Middle 06 08 2018   grade_8 79 20 89 0   7     0   3   102 96                       198.0 79 20 89 0   7     0   3   102 96                 198
2236757 2236757 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 Waltham: John F Kennedy Middle   Regular School No Middle 06 08 2018   grade_8 93 16 46 0   5     0   4   79 85                       164.0 93 16 46 0   5     0   4   79 85                 164
2236701 2236701 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Walpole: Eleanor N Johnson Middle   Regular School No Middle 06 08 2018   grade_8 125 4 6 0   16     0   8   86 73                       159.0 125 4 6 0   16     0   8   86 73                 159
2236697 2236697 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Walpole: Bird Middle   Regular School No Middle 06 08 2018   grade_8 133 4 11 2   7     0   3   77 83                       160.0 133 4 11 2   7     0   3   77 83                 160
2236649 2236649 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Wakefield: Galvin Middle School   Regular School No Middle 05 08 2018   grade_8 248 7 12 1   11     0   5   136 148                       284.0 248 7 12 1   11     0   5   136 148                 284
2236607 2236607 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 Uxbridge: McCloskey Middle School   Regular School No Middle 06 08 2018   grade_8 122 0 8 0   3     0   5   71 67                       138.0 122 0 8 0   3     0   5   71 67                 138
2236593 2236593 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough: Tyngsborough Middle   Regular School No Middle 06 08 2018   grade_8 126 4 8 0   7     0   5   77 73                       150.0 126 4 8 0   7     0   5   77 73                 150
2236563 2236563 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_8 24 0 9 3   1     0   5   20 22                       42.0 24 0 9 3   1     0   5   20 22                 42
2236547 2236547 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 Tewksbury: John W. Wynn Middle   Regular School No Middle 07 08 2018   grade_8 285 6 9 0   10     0   2   131 181                       312.0 285 6 9 0   10     0   2   131 181                 312
2236518 2236518 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_8 476 81 98 1   14     0   23   342 351                       693.0 476 81 98 1   14     0   23   342 351                 693
2236455 2236455 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Swansea: Joseph Case Jr High   Regular School No Middle 06 08 2018   grade_8 162 0 5 0   1     0   0   95 73                       168.0 162 0 5 0   1     0   0   95 73                 168
2236429 2236429 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott: Swampscott Middle   Regular School No Middle 05 08 2018   grade_8 161 7 23 0   8     0   3   92 110                       202.0 161 7 23 0   8     0   3   92 110                 202
2236400 2236400 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton: Sutton Middle School   Regular School No Middle 06 08 2018   grade_8 118 0 1 0   1     0   3   58 65                       123.0 118 0 1 0   1     0   3   58 65                 123
2236378 2236378 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury: Ephraim Curtis Middle   Regular School No Middle 06 08 2018   grade_8 281 5 8 0   20     0   16   189 141                       330.0 281 5 8 0   20     0   16   189 141                 330
2236331 2236331 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton: O'Donnell Middle School   Regular School No Middle 06 08 2018   grade_8 139 53 19 0   13     1   17   135 107                       242.0 139 53 19 0   13     1   17   135 107                 242
2236284 2236284 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham: Stoneham Central Middle School   Regular School No Middle 05 08 2018   grade_8 147 2 10 0   7     0   6   91 81                       172.0 147 2 10 0   7     0   6   91 81                 172
2236216 2236216 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Springfield: Van Sickle Academy   Regular School No Middle 06 08 2018   grade_8 25 27 149 0   4     0   2   108 99                       207.0 25 27 149 0   4     0   2   108 99                 207
2236205 2236205 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield: Conservatory of the Arts   Regular School No High 06 12 2018   grade_8 5 13 38 0   0     0   1   17 40                       57.0 5 13 38 0   0     0   1   17 40                 57
2236201 2236201 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield: Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2018   grade_8 13 19 58 0   1     0   1   45 47                       92.0 13 19 58 0   1     0   1   45 47                 92
2236194 2236194 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield: Chestnut Academy   Regular School No Middle 06 08 2018   grade_8 9 26 190 1   1     0   2   121 108                       229.0 9 26 190 1   1     0   2   121 108                 229
2236190 2236190 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield: Balliet Middle School   Regular School No Middle 06 08 2018   grade_8 1 8 24 0   0     0   0   20 13                       33.0 1 8 24 0   0     0   0   20 13                 33
2236186 2236186 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 Springfield: South End Middle School   Regular School No Middle 06 08 2018   grade_8 2 8 55 0   0     0   2   37 30                       67.0 2 8 55 0   0     0   2   37 30                 67
2236182 2236182 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield: STEM Middle Academy   Regular School No Middle 06 08 2018   grade_8 13 26 56 0   2     0   0   61 36                       97.0 13 26 56 0   2     0   0   61 36                 97
2236178 2236178 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield: Springfield Public Day Middle School   Regular School No Middle 06 08 2018   grade_8 1 3 13 0   0     0   0   13 4                       17.0 1 3 13 0   0     0   0   13 4                 17
2236175 2236175 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 Springfield: M Marcus Kiley Middle   Regular School No Middle 06 08 2018   grade_8 26 53 143 0   6     0   2   125 105                       230.0 26 53 143 0   6     0   2   125 105                 230
2236171 2236171 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 Springfield: John F Kennedy Middle   Regular School No Middle 06 08 2018   grade_8 13 28 91 0   2     0   3   72 65                       137.0 13 28 91 0   2     0   3   72 65                 137
2236167 2236167 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield: Forest Park Middle   Regular School No Middle 06 08 2018   grade_8 13 51 163 0   20     1   3   129 122                       251.0 13 51 163 0   20     1   3   129 122                 251
2236159 2236159 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 Springfield: John J Duggan Middle   Regular School No High 06 12 2018   grade_8 25 48 92 0   4     0   2   98 73                       171.0 25 48 92 0   4     0   2   98 73                 171
2236151 2236151 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_8 24 26 52 0   1     0   0   54 49                       103.0 24 26 52 0   1     0   0   54 49                 103
2236036 2236036 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield: Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2018   grade_8 5 8 13 0   0     0   2   13 15                       28.0 5 8 13 0   0     0   2   13 15                 28
2235899 2235899 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley: Michael E. Smith Middle School   Regular School No Middle 05 08 2018   grade_8 102 4 19 0   5     0   3   68 65                       133.0 102 4 19 0   5     0   3   68 65                 133
2235881 2235881 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge: Southbridge Middle School   Regular School No Middle 06 08 2018   grade_8 52 1 92 1   0     0   4   84 66                       150.0 52 1 92 1   0     0   4   84 66                 150
2235863 2235863 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 Southborough: P Brent Trottier   Regular School No Middle 06 08 2018   grade_8 119 1 11 0   19     0   6   71 85                       156.0 119 1 11 0   19     0   6   71 85                 156
2235830 2235830 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville: Next Wave Junior High   Alternative School No Middle 06 08 2018   grade_8 2 0 5 0   0     0   0   6 *                       7.0 2 0 5 0   0     0   0   6                   7
2235826 2235826 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville: Winter Hill Community   Regular School No Elementary PK 08 2018   grade_8 6 9 45 0   7     0   2   38 31                       69.0 6 9 45 0   7     0   2   38 31                 69
2235815 2235815 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville: West Somerville Neighborhood   Regular School No Elementary PK 08 2018   grade_8 23 8 10 0   3     0   4   24 24                       48.0 23 8 10 0   3     0   4   24 24                 48
2235804 2235804 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 Somerville: E Somerville Community   Regular School No Elementary KG 08 2018   grade_8 4 3 42 0   1     1   0   23 28                       51.0 4 3 42 0   1     1   0   23 28                 51
2235794 2235794 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Somerville: Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2018   grade_8 15 3 19 0   6     0   1   20 24                       44.0 15 3 19 0   6     0   1   20 24                 44
2235783 2235783 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 Somerville: John F Kennedy   Regular School No Elementary KG 08 2018   grade_8 30 5 10 0   5     0   2   29 23                       52.0 30 5 10 0   5     0   2   29 23                 52
2235773 2235773 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Somerville: Arthur D Healey   Regular School No Elementary PK 08 2018   grade_8 23 3 19 0   2     0   2   27 22                       49.0 23 3 19 0   2     0   2   27 22                 49
2235752 2235752 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset: Somerset Middle School   Regular School No Middle 06 08 2018   grade_8 185 0 10 0   0     0   3   104 94                       198.0 185 0 10 0   0     0   3   104 94                 198
2235701 2235701 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Shrewsbury: Oak Middle School   Regular School No Middle 07 08 2018   grade_8 311 7 48 1   130     0   19   265 251                       516.0 311 7 48 1   130     0   19   265 251                 516
2235665 2235665 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon: Sharon Middle   Regular School No Middle 06 08 2018   grade_8 193 12 14 1   84     0   14   165 153                       318.0 193 12 14 1   84     0   14   165 153                 318
2235633 2235633 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Seekonk: Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2018   grade_8 151 3 10 0   6     0   5   88 87                       175.0 151 3 10 0   6     0   5   88 87                 175
2235608 2235608 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate: Gates Middle School   Regular School No Middle 06 08 2018   grade_8 249 12 0 0   6     0   3   132 138                       270.0 249 12 0 0   6     0   3   132 138                 270
2235562 2235562 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus: Belmonte Saugus Middle   Regular School No Middle 06 08 2018   grade_8 186 12 21 1   6     1   2   113 116                       229.0 186 12 21 1   6     1   2   113 116                 229
2235523 2235523 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich: Sandwich STEM Academy   Regular School No Middle 07 08 2018   grade_8 216 2 1 2   4     1   0   118 108                       226.0 216 2 1 2   4     1   0   118 108                 226
2235495 2235495 MA Essex   school 2510380 258   Salem 251038002404 2580305 Salem: Collins Middle   Regular School No Middle 06 08 2018   grade_8 82 7 69 0   6     0   9   99 74                       173.0 82 7 69 0   6     0   9   99 74                 173

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