enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 493 ✖

grade ✖

  • grade_7 · 493 ✖
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
737153 737153 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_7 32 99 32 0   7     0   9   94 85                       179 32 99 32 0   7     0   9   94 85                 179
737162 737162 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2015   grade_7 58 97 54 1   5     0   6   108 113                       221 58 97 54 1   5     0   6   108 113                 221
737156 737156 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_7 69 95 32 1   8     2   8   113 102                       215 69 95 32 1   8     2   8   113 102                 215
736923 736923 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_7 3 94 27 1   7     0   2   75 59                       134 3 94 27 1   7     0   2   75 59                 134
735898 735898 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_7 134 9 11 0   8     0   4   94 72                       166 134 9 11 0   8     0   4   94 72                 166
737585 737585 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_7 155 9 131 0   2     0   5   156 146                       302 155 9 131 0   2     0   5   156 146                 302
738294 738294 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_7 113 9 75 0   18     1   9   118 107                       225 113 9 75 0   18     1   9   118 107                 225
738629 738629 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_7 131 9 81 1   5     0   1   111 117                       228 131 9 81 1   5     0   1   111 117                 228
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
741115 741115 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2015   grade_7 66 9 4 0   21     0   4   53 51                       104 66 9 4 0   21     0   4   53 51                 104
741118 741118 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_7 129 9 3 0   72     0   3   97 119                       216 129 9 3 0   72     0   3   97 119                 216
741225 741225 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2015   grade_7 89 9 75 2   4     0   6   91 94                       185 89 9 75 2   4     0   6   91 94                 185
741301 741301 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2015   grade_7 175 9 16 0   0     0   9   112 97                       209 175 9 16 0   0     0   9   112 97                 209
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
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
743700 743700 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 07 2015   grade_7 2 9 22 0   2     0   1   16 20                       36 2 9 22 0   2     0   1   16 20                 36
736764 736764 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2015   grade_7 3 81 89 0   6     1   4   92 92                       184 3 81 89 0   6     1   4   92 92                 184
737147 737147 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2015   grade_7 29 80 14 0   4     0   6   81 52                       133 29 80 14 0   4     0   6   81 52                 133
737853 737853 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_7 177 8 3 0   1     0   6   83 112                       195 177 8 3 0   1     0   6   83 112                 195
739333 739333 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2015   grade_7 38 8 42 0   46     1   7   65 77                       142 38 8 42 0   46     1   7   65 77                 142
739350 739350 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No 2 05 08 2015   grade_7 61 8 64 0   19     0   5   75 82                       157 61 8 64 0   19     0   5   75 82                 157
739618 739618 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_7 305 8 12 0   16     0   10   188 163                       351 305 8 12 0   16     0   10   188 163                 351
739642 739642 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No 2 07 08 2015   grade_7 210 8 15 0   4     0   9   124 122                       246 210 8 15 0   4     0   9   124 122                 246
741018 741018 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2015   grade_7 306 8 11 0   4     0   15   159 185                       344 306 8 11 0   4     0   15   159 185                 344
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
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
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
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
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
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
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
744260 744260 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_7 168 8 1 1   8     0   6   90 102                       192 168 8 1 1   8     0   6   90 102                 192
736417 736417 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2015   grade_7 11 76 90 0   17     0   5   112 87                       199 11 76 90 0   17     0   5   112 87                 199
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
736506 736506 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_7 0 7 16 0   0     0   0   9 14                       23 0 7 16 0   0     0   0   9 14                 23
736920 736920 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_7 13 7 109 1   4     0   2   79 57                       136 13 7 109 1   4     0   2   79 57                 136
737036 737036 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No 2 06 08 2015   grade_7 180 7 4 0   35     0   3   118 111                       229 180 7 4 0   35     0   3   118 111                 229
737241 737241 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2015   grade_7 23 7 7 0   9     0   8   30 24                       54 23 7 7 0   9     0   8   30 24                 54
737588 737588 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Fairview Middle   Regular School No 2 06 08 2015   grade_7 147 7 63 0   4     0   6   115 112                       227 147 7 63 0   4     0   6   115 112                 227
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
737633 737633 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_7 117 7 3 0   6     0   0   62 71                       133 117 7 3 0   6     0   0   62 71                 133
737660 737660 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_7 174 7 8 0   13     0   8   103 107                       210 174 7 8 0   13     0   8   103 107                 210
737902 737902 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2015   grade_7 191 7 5 2   14     0   4   113 110                       223 191 7 5 2   14     0   4   113 110                 223
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
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
739180 739180 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2015   grade_7 43 7 6 0   2     0   6   35 29                       64 43 7 6 0   2     0   6   35 29                 64
739554 739554 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2015   grade_7 150 7 1 0   4     0   5   86 81                       167 150 7 1 0   4     0   5   86 81                 167
739898 739898 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2015   grade_7 76 7 67 0   4     0   2   81 75                       156 76 7 67 0   4     0   2   81 75                 156
740565 740565 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_7 342 7 11 1   24     1   10   193 203                       396 342 7 11 1   24     1   10   193 203                 396
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
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
743965 743965 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2015   grade_7 262 7 10 2   131     0   16   220 208                       428 262 7 10 2   131     0   16   220 208                 428
744763 744763 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2015   grade_7 101 7 7 1   1     0   8   71 54                       125 101 7 7 1   1     0   8   71 54                 125
745017 745017 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2015   grade_7 162 7 2 0   5     2   3   92 89                       181 162 7 2 0   5     2   3   92 89                 181
737159 737159 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2015   grade_7 53 69 14 0   4     0   4   80 64                       144 53 69 14 0   4     0   4   80 64                 144
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
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
743789 743789 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2015   grade_7 15 66 46 1   9     0   2   62 77                       139 15 66 46 1   9     0   2   62 77                 139
737097 737097 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_7 16 65 27 1   0     0   6   52 63                       115 16 65 27 1   0     0   6   52 63                 115
737126 737126 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_7 11 60 9 0   4     0   2   50 36                       86 11 60 9 0   4     0   2   50 36                 86
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
735864 735864 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2015   grade_7 136 6 28 2   18     0   4   97 97                       194 136 6 28 2   18     0   4   97 97                 194
735906 735906 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2015   grade_7 90 6 24 0   3     0   8   64 67                       131 90 6 24 0   3     0   8   64 67                 131
736647 736647 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2015   grade_7 3 6 24 0   3     0   1   23 14                       37 3 6 24 0   3     0   1   23 14                 37
736664 736664 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_7 7 6 8 0   0     0   0   10 11                       21 7 6 8 0   0     0   0   10 11                 21
737128 737128 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 3 07 12 2015   grade_7 0 6 0 0   0     0   0   3 3                       6 0 6 0 0   0     0   0   3 3                 6
738288 738288 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2015   grade_7 119 6 30 0   3     0   5   79 84                       163 119 6 30 0   3     0   5   79 84                 163
738595 738595 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_7 82 6 44 0   1     0   1   63 71                       134 82 6 44 0   1     0   1   63 71                 134
739185 739185 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2015   grade_7 22 6 8 0   2     1   1   17 23                       40 22 6 8 0   2     1   1   17 23                 40
739260 739260 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No 1 PK 08 2015   grade_7 34 6 13 0   7     0   0   26 34                       60 34 6 13 0   7     0   0   26 34                 60
739337 739337 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2015   grade_7 40 6 25 0   77     0   5   83 70                       153 40 6 25 0   77     0   5   83 70                 153
739675 739675 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_7 177 6 115 1   10     0   8   158 159                       317 177 6 115 1   10     0   8   158 159                 317
739725 739725 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_7 101 6 4 5   5     0   6   66 61                       127 101 6 4 5   5     0   6   66 61                 127
739908 739908 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2015   grade_7 67 6 60 0   4     0   2   70 69                       139 67 6 60 0   4     0   2   70 69                 139
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
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
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
743985 743985 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_7 105 6 2 0   0     0   0   54 59                       113 105 6 2 0   0     0   0   54 59                 113
744127 744127 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No 2 07 08 2015   grade_7 228 6 3 0   2     0   2   122 119                       241 228 6 3 0   2     0   2   122 119                 241
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
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
745180 745180 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_7 45 6 14 0   2     0   5   37 35                       72 45 6 14 0   2     0   5   37 35                 72
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
736789 736789 MA Suffolk   school 2502790 35   Boston 250279000345 350470 Wm B Rogers Middle   Regular School No 2 06 08 2015   grade_7 2 56 34 0   4     0   4   51 49                       100 2 56 34 0   4     0   4   51 49                 100
740267 740267 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_7 117 56 95 3   2     2   17   158 134                       292 117 56 95 3   2     2   17   158 134                 292
736786 736786 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 06 08 2015   grade_7 3 55 43 0   0     0   4   63 42                       105 3 55 43 0   0     0   4   63 42                 105
736792 736792 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2015   grade_7 0 53 99 0   0     0   3   89 66                       155 0 53 99 0   0     0   3   89 66                 155
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
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
743843 743843 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_7 9 50 23 1   10     0   1   45 49                       94 9 50 23 1   10     0   1   45 49                 94
736157 736157 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2015   grade_7 237 5 15 0   8     0   5   146 124                       270 237 5 15 0   8     0   5   146 124                 270
736321 736321 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   grade_7 3 5 14 0   0     0   0   13 9                       22 3 5 14 0   0     0   0   13 9                 22
736572 736572 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_7 8 5 17 0   0     0   1   14 17                       31 8 5 17 0   0     0   1   14 17                 31
736958 736958 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_7 0 5 5 0   1     0   0   5 6                       11 0 5 5 0   1     0   0   5 6                 11
737957 737957 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_7 16 5 18 0   4     0   0   17 26                       43 16 5 18 0   4     0   0   17 26                 43
738620 738620 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_7 79 5 34 1   1     0   3   73 50                       123 79 5 34 1   1     0   3   73 50                 123
738829 738829 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No 2 05 07 2015   grade_7 215 5 15 1   2     0   5   129 114                       243 215 5 15 1   2     0   5   129 114                 243
739158 739158 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2015   grade_7 144 5 8 0   108     0   15   139 141                       280 144 5 8 0   108     0   15   139 141                 280
741126 741126 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2015   grade_7 34 5 4 0   27     0   7   44 33                       77 34 5 4 0   27     0   7   44 33                 77

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