enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_7", state = "MA" and year = 2015 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 393 ✖

grade ✖

  • grade_7 · 393 ✖
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
743590 743590 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2015   grade_7 0 21 11 0   2     0   0   16 18                       34 0 21 11 0   2     0   0   16 18                 34
743577 743577 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_7 31 35 56 0   6     0   8   67 69                       136 31 35 56 0   6     0   8   67 69                 136
743568 743568 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_7 5 1 38 0   0     0   0   13 31                       44 5 1 38 0   0     0   0   13 31                 44
743558 743558 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_7 0 8 10 0   0     0   1   6 13                       19 0 8 10 0   0     0   1   6 13                 19
743530 743530 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2015   grade_7 1 31 11 0   0     1   5   20 29                       49 1 31 11 0   0     1   5   20 29                 49
743523 743523 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_7 83 3 3 1   6     0   4   52 48                       100 83 3 3 1   6     0   4   52 48                 100
743519 743519 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2015   grade_7 70 3 2 0   2     0   3   41 39                       80 70 3 2 0   2     0   3   41 39                 80
743507 743507 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_7 101 5 3 0   30     0   8   85 62                       147 101 5 3 0   30     0   8   85 62                 147
743500 743500 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_7 13 34 69 0   2     0   2   61 59                       120 13 34 69 0   2     0   2   61 59                 120
743496 743496 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_7 0 43 7 0   0     0   1   21 30                       51 0 43 7 0   0     0   1   21 30                 51
743467 743467 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_7 0 69 13 0   0     0   2   45 39                       84 0 69 13 0   0     0   2   45 39                 84
743464 743464 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_7 125 1 6 0   5     0   1   67 71                       138 125 1 6 0   5     0   1   67 71                 138
743452 743452 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_7 1 38 19 0   0     0   0   26 32                       58 1 38 19 0   0     0   0   26 32                 58
743441 743441 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_7 49 10 2 0   1     0   2   35 29                       64 49 10 2 0   1     0   2   35 29                 64
743434 743434 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_7 33 0 1 0   1     0   2   16 21                       37 33 0 1 0   1     0   2   16 21                 37
743428 743428 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 4 05 12 2015   grade_7 12 48 14 0   1     0   2   38 39                       77 12 48 14 0   1     0   2   38 39                 77
743418 743418 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_7 19 12 131 0   2     0   3   85 82                       167 19 12 131 0   2     0   3   85 82                 167
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
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
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
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
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
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
743093 743093 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2015   grade_7 135 13 16 0   9     1   6   87 93                       180 135 13 16 0   9     1   6   87 93                 180
743090 743090 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_7 140 10 13 0   9     0   2   85 89                       174 140 10 13 0   9     0   2   85 89                 174
743032 743032 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2015   grade_7 138 6 10 0   1     0   0   69 86                       155 138 6 10 0   1     0   0   69 86                 155
743018 743018 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2015   grade_7 264 6 13 1   66     0   15   172 193                       365 264 6 13 1   66     0   15   172 193                 365
742980 742980 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2015   grade_7 99 1 8 0   8     0   2   53 65                       118 99 1 8 0   8     0   2   53 65                 118
742965 742965 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2015   grade_7 240 4 9 0   9     0   3   139 126                       265 240 4 9 0   9     0   3   139 126                 265
742882 742882 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 07 08 2015   grade_7 375 19 39 2   30     0   9   241 233                       474 375 19 39 2   30     0   9   241 233                 474
742870 742870 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2015   grade_7 211 11 5 0   23     0   5   116 139                       255 211 11 5 0   23     0   5   116 139                 255
742829 742829 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No 2 06 08 2015   grade_7 216 12 49 0   15     0   9   156 145                       301 216 12 49 0   15     0   9   156 145                 301
742793 742793 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Middle   Regular School No 2 06 08 2015   grade_7 119 0 4 2   1     0   4   70 60                       130 119 0 4 2   1     0   4   70 60                 130
742778 742778 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2015   grade_7 124 12 3 2   25     0   4   93 77                       170 124 12 3 2   25     0   4   93 77                 170
742751 742751 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2015   grade_7 180 1 2 0   52     0   6   132 109                       241 180 1 2 0   52     0   6   132 109                 241
742748 742748 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2015   grade_7 149 0 2 0   39     0   2   101 91                       192 149 0 2 0   39     0   2   101 91                 192
742717 742717 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2015   grade_7 164 4 29 0   8     0   2   104 103                       207 164 4 29 0   8     0   2   104 103                 207
742714 742714 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2015   grade_7 197 4 22 0   2     0   9   116 118                       234 197 4 22 0   2     0   9   116 118                 234
742664 742664 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_7 91 3 0 0   1     0   5   47 53                       100 91 3 0 0   1     0   5   47 53                 100
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
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
742604 742604 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2015   grade_7 296 21 20 0   32     0   14   188 195                       383 296 21 20 0   32     0   14   188 195                 383
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
742539 742539 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2015   grade_7 151 13 16 0   28     0   11   109 110                       219 151 13 16 0   28     0   11   109 110                 219
742515 742515 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2015   grade_7 121 4 19 3   9     0   9   76 89                       165 121 4 19 3   9     0   9   76 89                 165
742478 742478 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_7 152 19 13 3   3     0   25   110 105                       215 152 19 13 3   3     0   25   110 105                 215
742463 742463 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2015   grade_7 88 2 11 0   2     0   1   46 58                       104 88 2 11 0   2     0   1   46 58                 104
742448 742448 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No 2 06 08 2015   grade_7 93 16 79 1   5     0   7   111 90                       201 93 16 79 1   5     0   7   111 90                 201
742445 742445 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2015   grade_7 86 21 49 0   9     0   4   93 76                       169 86 21 49 0   9     0   4   93 76                 169
742399 742399 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2015   grade_7 115 2 2 1   8     0   1   62 67                       129 115 2 2 1   8     0   1   62 67                 129
742396 742396 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No 2 06 08 2015   grade_7 136 11 16 0   6     0   4   86 87                       173 136 11 16 0   6     0   4   86 87                 173
742355 742355 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2015   grade_7 262 3 11 1   10     0   9   150 146                       296 262 3 11 1   10     0   9   150 146                 296
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
742311 742311 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2015   grade_7 132 0 6 0   12     0   8   76 82                       158 132 0 6 0   12     0   8   76 82                 158
742286 742286 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2015   grade_7 25 3 5 0   0     0   1   13 21                       34 25 3 5 0   0     0   1   13 21                 34
742271 742271 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No 2 07 08 2015   grade_7 295 2 10 0   7     1   1   172 144                       316 295 2 10 0   7     1   1   172 144                 316
742247 742247 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2015   grade_7 200 24 32 0   4     0   8   136 132                       268 200 24 32 0   4     0   8   136 132                 268
742244 742244 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2015   grade_7 83 24 25 0   0     2   4   67 71                       138 83 24 25 0   0     2   4   67 71                 138
742236 742236 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2015   grade_7 180 24 14 0   2     0   7   122 105                       227 180 24 14 0   2     0   7   122 105                 227
742197 742197 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No 2 06 08 2015   grade_7 160 1 6 1   2     0   2   85 87                       172 160 1 6 1   2     0   2   85 87                 172
742177 742177 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2015   grade_7 125 5 25 0   4     0   1   70 90                       160 125 5 25 0   4     0   1   70 90                 160
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
742134 742134 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2015   grade_7 278 7 3 1   19     0   17   178 147                       325 278 7 3 1   19     0   17   178 147                 325
742093 742093 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2015   grade_7 198 60 24 0   20     1   7   166 144                       310 198 60 24 0   20     1   7   166 144                 310
742053 742053 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No 2 05 08 2015   grade_7 181 4 9 0   7     0   5   106 100                       206 181 4 9 0   7     0   5   106 100                 206
741990 741990 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2015   grade_7 10 10 48 0   3     0   0   27 44                       71 10 10 48 0   3     0   0   27 44                 71
741987 741987 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2015   grade_7 5 8 63 0   0     0   1   39 38                       77 5 8 63 0   0     0   1   39 38                 77
741984 741984 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2015   grade_7 2 8 72 0   0     0   1   54 29                       83 2 8 72 0   0     0   1   54 29                 83
741981 741981 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2015   grade_7 0 4 8 0   0     0   0   6 6                       12 0 4 8 0   0     0   0   6 6                 12
741978 741978 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2015   grade_7 3 8 76 0   0     0   2   42 47                       89 3 8 76 0   0     0   2   42 47                 89
741975 741975 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2015   grade_7 20 23 46 0   2     0   4   52 43                       95 20 23 46 0   2     0   4   52 43                 95
741972 741972 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No 2 06 08 2015   grade_7 2 3 11 0   0     0   1   15 2                       17 2 3 11 0   0     0   1   15 2                 17
741969 741969 MA Hampden   school 2511130 281   Springfield 251113001660 2810340 Van Sickle Middle School   Regular School No 2 06 08 2015   grade_7 43 53 187 1   6     1   7   151 147                       298 43 53 187 1   6     1   7   151 147                 298
741966 741966 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No 2 06 08 2015   grade_7 33 40 113 0   5     0   12   113 90                       203 33 40 113 0   5     0   12   113 90                 203
741963 741963 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2015   grade_7 28 34 133 0   1     0   5   101 100                       201 28 34 133 0   1     0   5   101 100                 201
741960 741960 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No 2 06 08 2015   grade_7 28 41 156 0   20     0   2   142 105                       247 28 41 156 0   20     0   2   142 105                 247
741956 741956 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No 2 06 09 2015   grade_7 29 49 80 0   6     1   5   94 76                       170 29 49 80 0   6     1   5   94 76                 170
741949 741949 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_7 28 32 41 0   4     0   3   58 50                       108 28 32 41 0   4     0   3   58 50                 108
741850 741850 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_7 4 8 9 0   0     0   0   6 15                       21 4 8 9 0   0     0   0   6 15                 21
741732 741732 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2015   grade_7 118 2 7 0   2     0   9   63 75                       138 118 2 7 0   2     0   9   63 75                 138
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
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
741676 741676 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_7 0 2 4 0   0     0   0   5 *                       6 0 2 4 0   0     0   0   5                   6
741673 741673 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2015   grade_7 7 10 27 0   12     0   1   28 29                       57 7 10 27 0   12     0   1   28 29                 57
741663 741663 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2015   grade_7 32 7 6 0   4     0   0   33 16                       49 32 7 6 0   4     0   0   33 16                 49
741653 741653 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2015   grade_7 13 3 43 0   1     0   0   26 34                       60 13 3 43 0   1     0   0   26 34                 60
741644 741644 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   grade_7 19 5 18 0   7     0   0   21 28                       49 19 5 18 0   7     0   0   21 28                 49
741634 741634 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2015   grade_7 23 8 12 0   6     0   1   32 18                       50 23 8 12 0   6     0   1   32 18                 50
741624 741624 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   grade_7 23 14 24 0   2     0   1   33 31                       64 23 14 24 0   2     0   1   33 31                 64
741605 741605 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No 2 06 08 2015   grade_7 200 2 5 0   8     0   2   118 99                       217 200 2 5 0   8     0   2   118 99                 217
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
741533 741533 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No 2 06 08 2015   grade_7 153 17 11 0   60     0   10   137 114                       251 153 17 11 0   60     0   10   137 114                 251
741507 741507 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No 2 06 08 2015   grade_7 161 3 6 0   5     0   2   81 96                       177 161 3 6 0   5     0   2   81 96                 177
741486 741486 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No 2 07 08 2015   grade_7 215 8 0 0   4     0   5   118 114                       232 215 8 0 0   4     0   5   118 114                 232
741443 741443 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No 2 06 08 2015   grade_7 168 12 26 1   7     0   1   116 99                       215 168 12 26 1   7     0   1   116 99                 215
741411 741411 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No 2 07 08 2015   grade_7 241 5 4 1   7     0   1   133 126                       259 241 5 4 1   7     0   1   133 126                 259
741380 741380 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2015   grade_7 107 9 78 0   6     0   9   110 99                       209 107 9 78 0   6     0   9   110 99                 209
741371 741371 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No 1 KG 08 2015   grade_7 29 3 19 0   0     0   1   30 22                       52 29 3 19 0   0     0   1   30 22                 52
741356 741356 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No 1 KG 08 2015   grade_7 12 2 37 0   0     0   0   23 28                       51 12 2 37 0   0     0   0   23 28                 51
741317 741317 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No 2 06 08 2015   grade_7 75 1 2 0   2     0   0   39 41                       80 75 1 2 0   2     0   0   39 41                 80

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