enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2016 sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
941101 941101 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2016   grade_6 16 0 0 0   0     0   1   7 10                       17 16 0 0 0   0     0   1   7 10                 17
940217 940217 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No 2 04 06 2016   grade_6 150 3 4 0   1     0   3   95 66                       161 150 3 4 0   1     0   3   95 66                 161
940209 940209 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
939969 939969 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   grade_6 11 8 36 0   1     0   5   35 26                       61 11 8 36 0   1     0   5   35 26                 61
940039 940039 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2016   grade_6 5 7 19 0   0     0   6   16 21                       37 5 7 19 0   0     0   6   16 21                 37
939961 939961 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   grade_6 5 0 68 0   3     0   0   37 39                       76 5 0 68 0   3     0   0   37 39                 76
940159 940159 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2016   grade_6 10 14 23 0   1     0   3   25 26                       51 10 14 23 0   1     0   3   25 26                 51
940176 940176 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_6 20 16 38 0   5     0   4   35 48                       83 20 16 38 0   5     0   4   35 48                 83
940151 940151 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2016   grade_6 19 4 2 0   1     0   2   12 16                       28 19 4 2 0   1     0   2   12 16                 28
939923 939923 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2016   grade_6 6 5 11 0   0     0   3   14 11                       25 6 5 11 0   0     0   3   14 11                 25
940143 940143 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2016   grade_6 11 4 30 0   2     0   7   37 17                       54 11 4 30 0   2     0   7   37 17                 54
940136 940136 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2016   grade_6 31 0 15 0   1     0   2   24 25                       49 31 0 15 0   1     0   2   24 25                 49
940129 940129 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2016   grade_6 25 11 15 0   3     0   3   28 29                       57 25 11 15 0   3     0   3   28 29                 57
940122 940122 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   grade_6 19 9 7 0   0     0   4   16 23                       39 19 9 7 0   0     0   4   16 23                 39
940114 940114 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2016   grade_6 31 8 22 0   5     0   1   36 31                       67 31 8 22 0   5     0   1   36 31                 67
940106 940106 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2016   grade_6 16 4 23 0   5     0   2   24 26                       50 16 4 23 0   5     0   2   24 26                 50
940099 940099 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2016   grade_6 24 12 30 0   9     0   3   41 37                       78 24 12 30 0   9     0   3   41 37                 78
940091 940091 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2016   grade_6 39 8 25 0   1     0   3   43 33                       76 39 8 25 0   1     0   3   43 33                 76
940083 940083 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2016   grade_6 54 6 6 0   6     0   3   39 36                       75 54 6 6 0   6     0   3   39 36                 75
940076 940076 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2016   grade_6 18 0 4 0   1     0   2   14 11                       25 18 0 4 0   1     0   2   14 11                 25
940061 940061 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2016   grade_6 19 5 12 0   5     0   3   29 15                       44 19 5 12 0   5     0   3   29 15                 44
940054 940054 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2016   grade_6 6 2 15 0   2     0   1   16 10                       26 6 2 15 0   2     0   1   16 10                 26
940046 940046 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2016   grade_6 16 2 7 0   0     0   0   12 13                       25 16 2 7 0   0     0   0   12 13                 25
940031 940031 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2016   grade_6 20 3 9 0   4     0   2   26 12                       38 20 3 9 0   4     0   2   26 12                 38
940179 940179 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_6 22 8 11 0   6     0   1   19 29                       48 22 8 11 0   6     0   1   19 29                 48
940024 940024 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   grade_6 11 6 8 0   2     0   0   11 16                       27 11 6 8 0   2     0   0   11 16                 27
940016 940016 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2016   grade_6 31 10 32 0   19     0   6   65 33                       98 31 10 32 0   19     0   6   65 33                 98
940008 940008 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2016   grade_6 3 3 34 0   7     0   2   25 24                       49 3 3 34 0   7     0   2   25 24                 49
940069 940069 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   grade_6 9 7 11 0   2     0   1   19 11                       30 9 7 11 0   2     0   1   19 11                 30
939992 939992 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2016   grade_6 40 2 12 0   7     0   1   33 29                       62 40 2 12 0   7     0   1   33 29                 62
940000 940000 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2016   grade_6 8 4 27 0   3     0   3   32 13                       45 8 4 27 0   3     0   3   32 13                 45
939985 939985 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2016   grade_6 5 3 26 0   3     0   5   21 21                       42 5 3 26 0   3     0   5   21 21                 42
939977 939977 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2016   grade_6 3 4 14 0   1     0   3   13 12                       25 3 4 14 0   1     0   3   13 12                 25
939953 939953 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2016   grade_6 3 10 36 0   1     0   0   25 25                       50 3 10 36 0   1     0   0   25 25                 50
939946 939946 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2016   grade_6 7 6 18 0   15     0   2   17 31                       48 7 6 18 0   15     0   2   17 31                 48
939938 939938 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2016   grade_6 3 1 18 0   1     0   1   13 11                       24 3 1 18 0   1     0   1   13 11                 24
939916 939916 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_6 2 9 24 0   4     0   0   19 20                       39 2 9 24 0   4     0   0   19 20                 39
939931 939931 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   grade_6 6 6 48 0   7     0   0   31 36                       67 6 6 48 0   7     0   0   31 36                 67
939898 939898 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_6 142 12 20 2   13     0   2   96 95                       191 142 12 20 2   13     0   2   96 95                 191
939901 939901 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2016   grade_6 150 11 11 2   9     1   6   93 97                       190 150 11 11 2   9     1   6   93 97                 190
939840 939840 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2016   grade_6 128 1 16 0   1     0   3   81 68                       149 128 1 16 0   1     0   3   81 68                 149
939826 939826 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2016   grade_6 264 0 14 1   63     1   20   181 182                       363 264 0 14 1   63     1   20   181 182                 363
939783 939783 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_6 76 4 9 1   3     0   2   50 45                       95 76 4 9 1   3     0   2   50 45                 95
939769 939769 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2016   grade_6 272 4 16 1   11     0   8   165 147                       312 272 4 16 1   11     0   8   165 147                 312
939754 939754 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2016   grade_6 45 1 1 0   3     0   5   30 25                       55 45 1 1 0   3     0   5   30 25                 55
939746 939746 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No 1 PK 06 2016   grade_6 20 0 1 0   0     0   0   6 15                       21 20 0 1 0   0     0   0   6 15                 21
941840 941840 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_6 136 3 1 0   0     0   3   71 72                       143 136 3 1 0   0     0   3   71 72                 143
941837 941837 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2016   grade_6 175 5 7 0   2     0   2   111 80                       191 175 5 7 0   2     0   2   111 80                 191
939738 939738 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2016   grade_6 16 0 1 0   0     0   0   9 8                       17 16 0 1 0   0     0   0   9 8                 17
939726 939726 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_6 389 30 33 0   22     1   23   267 231                       498 389 30 33 0   22     1   23   267 231                 498
939674 939674 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2016   grade_6 211 9 9 0   33     0   5   125 142                       267 211 9 9 0   33     0   5   125 142                 267
939598 939598 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 03 06 2016   grade_6 116 0 4 0   2     0   5   70 57                       127 116 0 4 0   2     0   5   70 57                 127
939584 939584 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2016   grade_6 119 14 8 2   24     0   7   78 96                       174 119 14 8 2   24     0   7   78 96                 174
939571 939571 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2016   grade_6 21 0 1 0   0     0   1   8 15                       23 21 0 1 0   0     0   1   8 15                 23
939556 939556 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2016   grade_6 124 4 4 1   43     0   7   87 96                       183 124 4 4 1   43     0   7   87 96                 183
939553 939553 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2016   grade_6 141 1 1 2   55     1   1   108 94                       202 141 1 1 2   55     1   1   108 94                 202
939522 939522 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2016   grade_6 151 3 29 0   5     0   0   99 89                       188 151 3 29 0   5     0   0   99 89                 188
939519 939519 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2016   grade_6 190 2 27 0   5     1   4   125 104                       229 190 2 27 0   5     1   4   125 104                 229
939441 939441 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2016   grade_6 177 3 22 0   86     0   20   155 153                       308 177 3 22 0   86     0   20   155 153                 308
939093 939093 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2016   grade_6 23 0 7 2   0     0   3   19 16                       35 23 0 7 2   0     0   3   19 16                 35
939633 939633 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No 2 06 08 2016   grade_6 191 8 50 1   13     0   8   140 131                       271 191 8 50 1   13     0   8   140 131                 271
939469 939469 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2016   grade_6 98 2 4 0   1     0   0   59 46                       105 98 2 4 0   1     0   0   59 46                 105
939455 939455 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2016   grade_6 71 0 7 1   1     0   2   37 45                       82 71 0 7 1   1     0   2   37 45                 82
939412 939412 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2016   grade_6 279 17 18 0   27     0   21   177 185                       362 279 17 18 0   27     0   21   177 185                 362
939361 939361 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No 2 05 08 2016   grade_6 102 9 33 1   3     1   13   71 91                       162 102 9 33 1   3     1   13   71 91                 162
939347 939347 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2016   grade_6 128 9 6 0   40     1   9   100 93                       193 128 9 6 0   40     1   9   100 93                 193
939322 939322 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2016   grade_6 107 8 17 1   20     0   11   86 78                       164 107 8 17 1   20     0   11   86 78                 164
941811 941811 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 40 0 1 0   0     0   2   21 22                       43 40 0 1 0   0     0   2   21 22                 43
941803 941803 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2016   grade_6 67 0 6 0   0     0   0   33 40                       73 67 0 6 0   0     0   0   33 40                 73
939284 939284 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2016   grade_6 152 15 7 3   1     0   18   96 100                       196 152 15 7 3   1     0   18   96 100                 196
939269 939269 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2016   grade_6 91 2 5 1   0     0   2   56 45                       101 91 2 5 1   0     0   2   56 45                 101
939255 939255 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No 2 06 08 2016   grade_6 89 16 84 0   6     0   2   98 99                       197 89 16 84 0   6     0   2   98 99                 197
939252 939252 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_6 91 17 37 0   6     0   4   73 82                       155 91 17 37 0   6     0   4   73 82                 155
939206 939206 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2016   grade_6 131 4 6 0   14     0   6   86 75                       161 131 4 6 0   14     0   6   86 75                 161
939203 939203 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No 2 06 08 2016   grade_6 136 5 8 1   7     0   4   78 83                       161 136 5 8 1   7     0   4   78 83                 161
939177 939177 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2016   grade_6 18 0 0 0   1     0   0   5 14                       19 18 0 0 0   1     0   0   5 14                 19
939162 939162 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2016   grade_6 253 8 13 0   11     0   7   141 151                       292 253 8 13 0   11     0   7   141 151                 292
941775 941775 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2016   grade_6 43 0 4 0   2     0   0   25 24                       49 43 0 4 0   2     0   0   25 24                 49
941788 941788 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_6 92 3 3 0   2     0   0   56 44                       100 92 3 3 0   2     0   0   56 44                 100
941766 941766 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2016   grade_6 55 0 5 0   2     0   0   39 23                       62 55 0 5 0   2     0   0   39 23                 62
941784 941784 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2016   grade_6 105 1 4 0   0     0   5   65 50                       115 105 1 4 0   0     0   5   65 50                 115
941781 941781 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2016   grade_6 212 7 14 0   9     0   8   133 117                       250 212 7 14 0   9     0   8   133 117                 250
939130 939130 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2016   grade_6 123 0 6 0   3     0   5   68 69                       137 123 0 6 0   3     0   5   68 69                 137
939119 939119 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2016   grade_6 116 3 5 0   6     0   5   67 68                       135 116 3 5 0   6     0   5   67 68                 135
941693 941693 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No 1 PK 06 2016   grade_6 58 1 2 0   2     0   4   38 29                       67 58 1 2 0   2     0   4   38 29                 67
941709 941709 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No 1 PK 06 2016   grade_6 62 1 0 0   1     0   0   27 37                       64 62 1 0 0   1     0   0   27 37                 64
941701 941701 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2016   grade_6 71 1 2 0   2     1   0   38 39                       77 71 1 2 0   2     1   0   38 39                 77
939111 939111 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   grade_6 8 1 0 0   0     0   0   6 3                       9 8 1 0 0   0     0   0   6 3                 9
939098 939098 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No 2 04 06 2016   grade_6 94 1 5 0   0     0   0   47 53                       100 94 1 5 0   0     0   0   47 53                 100
939077 939077 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No 2 05 06 2016   grade_6 286 5 8 0   11     0   2   136 176                       312 286 5 8 0   11     0   2   136 176                 312
939052 939052 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2016   grade_6 84 17 27 0   4     0   10   70 72                       142 84 17 27 0   4     0   10   70 72                 142
939044 939044 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2016   grade_6 191 30 33 0   8     0   10   133 139                       272 191 30 33 0   8     0   10   133 139                 272
939055 939055 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2016   grade_6 225 21 32 1   3     0   8   139 151                       290 225 21 32 1   3     0   8   139 151                 290
939005 939005 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No 2 06 08 2016   grade_6 167 0 4 0   0     0   0   92 79                       171 167 0 4 0   0     0   0   92 79                 171
938985 938985 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2016   grade_6 150 8 26 0   6     0   2   90 102                       192 150 8 26 0   6     0   2   90 102                 192
938961 938961 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2016   grade_6 115 0 1 0   1     0   4   58 63                       121 115 0 1 0   1     0   4   58 63                 121
938953 938953 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2016   grade_6 18 1 3 0   2     1   1   13 13                       26 18 1 3 0   2     1   1   13 13                 26
938943 938943 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2016   grade_6 290 4 5 0   20     1   16   190 146                       336 290 4 5 0   20     1   16   190 146                 336
938917 938917 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2016   grade_6 119 1 10 0   5     0   10   77 68                       145 119 1 10 0   5     0   10   77 68                 145
938903 938903 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2016   grade_6 144 51 14 0   13     1   12   132 103                       235 144 51 14 0   13     1   12   132 103                 235

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