enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school ▲ school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
736751 736751 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_7 0 33 15 0   0     0   0   33 15                       48 0 33 15 0   0     0   0   33 15                 48
933620 933620 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_7 0 22 24 0   0     0   1   31 16                       47 0 22 24 0   0     0   1   31 16                 47
1123221 1123221 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_7 1 25 23 0   0     0   1   31 19                       50 1 25 23 0   0     0   1   31 19                 50
1365856 1365856 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_7 0 19 23 0   0     0   0   22 20 *                     42.0 0 19 23 0   0     0   0   22 20                 42
2040900 2040900 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_7 0 24 18 0   0     0   1   24 19                       43.0 0 24 18 0   0     0   1   24 19                 43
2237863 2237863 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_7 78 69 204 0   22     0   17   196 194                       390.0 78 69 204 0   22     0   17   196 194                 390
2237842 2237842 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_7 4 7 21 0   10     0   2   21 23                       44.0 4 7 21 0   10     0   2   21 23                 44
2237867 2237867 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_7 92 67 210 1   38     0   16   226 198                       424.0 92 67 210 1   38     0   16   226 198                 424
2237859 2237859 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   grade_7 199 65 173 1   23     0   25   238 248                       486.0 199 65 173 1   23     0   25   238 248                 486
2237849 2237849 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_7 4 5 70 0   7     0   0   46 40                       86.0 4 5 70 0   7     0   0   46 40                 86
2237856 2237856 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_7 108 64 138 0   9     0   16   153 182                       335.0 108 64 138 0   9     0   16   153 182                 335
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
940177 940177 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_7 82 74 167 1   28     0   23   198 177                       375 82 74 167 1   28     0   23   198 177                 375
1131038 1131038 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_7 84 60 190 0   22     0   9   193 172                       365 84 60 190 0   22     0   9   193 172                 365
1372388 1372388 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_7 70 62 187 0   19     1   14   175 178 *                     353.0 70 62 187 0   19     1   14   175 178                 353
2047461 2047461 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2019   grade_7 64 75 189 1   38     0   17   196 188                       384.0 64 75 189 1   38     0   17   196 188                 384
1679651 1679651 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester - Worcester East Middle   Regular School No Middle 07 08 2021   grade_7 102 79 168 0   17     0   18   201 183 *                     384.0 102 79 168 0   17     0   18   201 183                 384
1679635 1679635 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester - University Pk Campus School   Regular School No High 07 12 2021   grade_7 4 5 26 1   4     0   0   20 20 *                     40.0 4 5 26 1   4     0   0   20 20                 40
1679654 1679654 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester - Sullivan Middle   Regular School No Middle 06 08 2021   grade_7 136 67 182 1   35     0   23   224 220 *                     444.0 136 67 182 1   35     0   23   224 220                 444
1679649 1679649 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester - Forest Grove Middle   Regular School No Middle 07 08 2021   grade_7 206 63 145 0   20     0   24   229 229 *                     458.0 206 63 145 0   20     0   24   229 229                 458
1679641 1679641 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_7 11 9 70 0   8     0   0   47 51 *                     98.0 11 9 70 0   8     0   0   47 51                 98
1679647 1679647 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester - Burncoat Middle School   Regular School No Middle 07 08 2021   grade_7 118 56 128 0   19     0   16   161 176 *                     337.0 118 56 128 0   19     0   16   161 176                 337
735799 735799 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2015   grade_7 91 4 5 0   23     0   1   74 50                       124 91 4 5 0   23     0   1   74 50                 124
932675 932675 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2016   grade_7 103 7 7 0   39     0   3   65 94                       159 103 7 7 0   39     0   3   65 94                 159
1122116 1122116 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_7 88 3 10 0   39     0   3   76 67                       143 88 3 10 0   39     0   3   76 67                 143
1364923 1364923 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_7 61 3 13 1   53     0   2   73 60 *                     133.0 61 3 13 1   53     0   2   73 60                 133
2039950 2039950 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_7 81 4 15 0   44     0   5   82 67                       149.0 81 4 15 0   44     0   5   82 67                 149
2237547 2237547 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_7 112 10 10 3   10     0   2   68 79                       147.0 112 10 10 3   10     0   2   68 79                 147
2237551 2237551 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn: Daniel L Joyce Middle School   Regular School No Middle 06 08 2018   grade_7 128 8 10 1   7     0   5   83 76                       159.0 128 8 10 1   7     0   5   83 76                 159
1679375 1679375 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 94 19 10 0   13     2   6   71 73 *                     144.0 94 19 10 0   13     2   6   71 73                 144
1679378 1679378 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_7 134 8 26 1   6     0   8   106 77 *                     183.0 134 8 26 1   6     0   8   106 77                 183
737426 737426 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No 2 06 08 2015   grade_7 191 24 9 0   24     0   10   127 131                       258 191 24 9 0   24     0   10   127 131                 258
934286 934286 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No 2 06 08 2016   grade_7 186 30 9 0   34     0   14   134 139                       273 186 30 9 0   34     0   14   134 139                 273
1123999 1123999 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2017   grade_7 184 32 18 0   23     0   5   123 139                       262 184 32 18 0   23     0   5   123 139                 262
1366504 1366504 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_7 171 32 8 0   28     0   12   113 138 *                     251.0 171 32 8 0   28     0   12   113 138                 251
2041574 2041574 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2019   grade_7 143 32 16 0   19     0   14   110 114                       224.0 143 32 16 0   19     0   14   110 114                 224
739161 739161 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_7 128 14 6 0   94     0   15   128 129                       257 128 14 6 0   94     0   15   128 129                 257
936007 936007 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_7 147 5 10 1   78     0   13   134 120                       254 147 5 10 1   78     0   13   134 120                 254
1126061 1126061 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_7 150 13 4 0   95     0   19   129 152                       281 150 13 4 0   95     0   19   129 152                 281
1368206 1368206 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2020   grade_7 133 8 10 0   140     0   30   154 167 *                     321.0 133 8 10 0   140     0   30   154 167                 321
2043290 2043290 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_7 123 16 13 0   100     0   26   130 148                       278.0 123 16 13 0   100     0   26   130 148                 278
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
2237479 2237479 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop: Winthrop Middle School   Regular School No Middle 06 08 2018   grade_7 130 0 21 0   1     0   2   80 74                       154.0 130 0 21 0   1     0   2   80 74                 154
1130651 1130651 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2017   grade_7 127 1 20 0   1     0   2   80 71                       151 127 1 20 0   1     0   2   80 71                 151
1372062 1372062 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2020   grade_7 124 3 26 0   1     0   1   69 86 *                     155.0 124 3 26 0   1     0   1   69 86                 155
2047136 2047136 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2019   grade_7 121 1 35 0   3     0   4   93 71                       164.0 121 1 35 0   3     0   4   93 71                 164
736058 736058 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_7 236 15 17 0   42     0   13   163 160                       323 236 15 17 0   42     0   13   163 160                 323
932927 932927 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2016   grade_7 226 11 8 1   54     0   22   155 167                       322 226 11 8 1   54     0   22   155 167                 322
1122422 1122422 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_7 243 13 17 0   51     0   19   169 174                       343 243 13 17 0   51     0   19   169 174                 343
1365177 1365177 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2020   grade_7 228 13 17 0   74     0   27   184 175 *                     359.0 228 13 17 0   74     0   27   184 175                 359
2040203 2040203 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_7 245 14 24 1   52     0   24   174 186                       360.0 245 14 24 1   52     0   24   174 186                 360
1679322 1679322 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop - Winthrop Middle School   Regular School No Middle 06 08 2021   grade_7 123 4 30 1   1     0   3   77 85 *                     162.0 123 4 30 1   1     0   3   77 85                 162
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
938476 938476 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2016   grade_7 11 5 24 0   5     0   0   20 25                       45 11 5 24 0   5     0   0   20 25                 45
1129005 1129005 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_7 5 7 45 0   6     0   1   35 29                       64 5 7 45 0   6     0   1   35 29                 64
1370703 1370703 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2020   grade_7 6 10 35 0   3     0   0   25 29 *                     54.0 6 10 35 0   3     0   0   25 29                 54
2045779 2045779 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_7 12 13 31 0   5     0   1   34 28                       62.0 12 13 31 0   5     0   1   34 28                 62
2237461 2237461 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_7 278 5 13 1   67     0   13   195 182                       377.0 278 5 13 1   67     0   13   195 182                 377
1679308 1679308 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester - McCall Middle   Regular School No Middle 06 08 2021   grade_7 272 7 9 0   71     0   29   205 183 *                     388.0 272 7 9 0   71     0   29   205 183                 388
2237411 2237411 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon: Murdock Middle School   Regular School No Middle 06 08 2018   grade_7 72 0 6 0   4     0   8   51 39                       90.0 72 0 6 0   4     0   8   51 39                 90
1679265 1679265 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon - Murdock Middle School   Regular School No Middle 06 08 2021   grade_7 73 1 8 0   0     0   4   41 45 *                     86.0 73 1 8 0   0     0   4   41 45                 86
740093 740093 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2015   grade_7 200 10 8 0   13     1   10   121 121                       242 200 10 8 0   13     1   10   121 121                 242
936938 936938 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2016   grade_7 170 7 26 0   13     1   17   107 127                       234 170 7 26 0   13     1   17   107 127                 234
1127174 1127174 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_7 180 9 12 1   9     0   14   112 113                       225 180 9 12 1   9     0   14   112 113                 225
1369160 1369160 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_7 185 9 13 0   15     0   17   126 113 *                     239.0 185 9 13 0   15     0   17   126 113                 239
2044231 2044231 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2019   grade_7 197 7 8 0   14     0   14   128 112                       240.0 197 7 8 0   14     0   14   128 112                 240
2237392 2237392 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington: Wilmington Middle School   Regular School No Middle 06 08 2018   grade_7 220 5 11 0   10     0   10   131 125                       256.0 220 5 11 0   10     0   10   131 125                 256
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
939770 939770 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2016   grade_7 260 4 9 0   15     0   10   146 152                       298 260 4 9 0   15     0   10   146 152                 298
1130564 1130564 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_7 267 5 16 1   11     0   8   161 147                       308 267 5 16 1   11     0   8   161 147                 308
1371991 1371991 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2020   grade_7 227 4 13 0   13     0   5   125 137 *                     262.0 227 4 13 0   13     0   5   125 137                 262
2047065 2047065 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_7 237 4 10 2   9     0   12   146 128                       274.0 237 4 10 2   9     0   12   146 128                 274
1679251 1679251 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington - Wilmington Middle School   Regular School No Middle 06 08 2021   grade_7 234 3 10 0   13     0   8   143 125 *                     268.0 234 3 10 0   13     0   8   143 125                 268
739224 739224 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2015   grade_7 114 3 2 0   15     0   4   69 69                       138 114 3 2 0   15     0   4   69 69                 138
936070 936070 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_7 99 1 5 1   9     0   4   58 61                       119 99 1 5 1   9     0   4   58 61                 119
1126137 1126137 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_7 111 1 5 0   6     0   4   68 59                       127 111 1 5 0   6     0   4   68 59                 127
1368269 1368269 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_7 94 1 3 0   7     0   7   57 55 *                     112.0 94 1 3 0   7     0   7   57 55                 112
2043353 2043353 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_7 85 1 9 0   10     0   3   50 58                       108.0 85 1 9 0   10     0   3   50 58                 108
738731 738731 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_7 3 1 58 0   1     0   0   42 21                       63 3 1 58 0   1     0   0   42 21                 63
935577 935577 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2016   grade_7 3 0 60 0   0     0   0   32 31                       63 3 0 60 0   0     0   0   32 31                 63
1125569 1125569 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_7 7 2 84 0   0     0   0   47 46                       93 7 2 84 0   0     0   0   47 46                 93
1367815 1367815 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_7 3 2 48 0   0     0   0   33 20 *                     53.0 3 2 48 0   0     0   0   33 20                 53
2042896 2042896 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_7 2 3 40 0   0     0   0   32 13                       45.0 2 3 40 0   0     0   0   32 13                 45
933567 933567 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_7 1 27 9 0   0     0   0   16 21                       37 1 27 9 0   0     0   0   16 21                 37
1123161 1123161 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_7 0 15 11 0   0     1   1   17 11                       28 0 15 11 0   0     1   1   17 11                 28
1365803 1365803 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_7 1 15 9 0   1     2   0   20 8 *                     28.0 1 15 9 0   1     2   0   20 8                 28
2040846 2040846 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_7 0 12 11 0   0     0   4   13 14                       27.0 0 12 11 0   0     0   4   13 14                 27
736678 736678 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_7 3 11 13 0   0     0   0   24 3                       27 3 11 13 0   0     0   0   24 3                 27
933545 933545 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_7 1 16 13 0   0     0   0   23 7                       30 1 16 13 0   0     0   0   23 7                 30
1123138 1123138 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_7 1 11 14 0   0     0   4   23 7                       30 1 11 14 0   0     0   4   23 7                 30
1365781 1365781 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_7 2 14 12 0   1     0   0   21 8 *                     29.0 2 14 12 0   1     0   0   21 8                 29
2040824 2040824 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_7 2 6 12 0   0     0   0   14 6                       20.0 2 6 12 0   0     0   0   14 6                 20
736562 736562 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_7 7 31 48 0   2     0   2   56 34                       90 7 31 48 0   2     0   2   56 34                 90
933431 933431 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_7 9 26 46 0   3     0   7   60 31                       91 9 26 46 0   3     0   7   60 31                 91
1123009 1123009 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_7 7 31 41 0   2     0   1   44 38                       82 7 31 41 0   2     0   1   44 38                 82
1365668 1365668 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_7 6 25 41 0   0     0   3   41 34 *                     75.0 6 25 41 0   0     0   3   41 34                 75
2040711 2040711 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_7 10 24 39 0   0     0   5   39 39                       78.0 10 24 39 0   0     0   5   39 39                 78
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
934101 934101 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_7 29 4 8 0   10     0   7   33 25                       58 29 4 8 0   10     0   7   33 25                 58
1123785 1123785 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2017   grade_7 36 4 8 0   7     0   5   32 28                       60 36 4 8 0   7     0   5   32 28                 60

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