enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 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
744274 744274 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_6 16 1 0 0   0     0   1   11 7                       18 16 1 0 0   0     0   1   11 7                 18
743400 743400 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No 2 04 06 2015   grade_6 143 3 4 0   7     0   4   78 83                       161 143 3 4 0   7     0   4   78 83                 161
743160 743160 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2015   grade_6 19 9 32 0   2     0   3   34 31                       65 19 9 32 0   2     0   3   34 31                 65
743230 743230 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   grade_6 8 8 19 0   1     0   3   23 16                       39 8 8 19 0   1     0   3   23 16                 39
743152 743152 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   grade_6 3 0 50 0   5     0   1   32 27                       59 3 0 50 0   5     0   1   32 27                 59
743350 743350 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2015   grade_6 18 18 37 0   1     0   2   38 38                       76 18 18 37 0   1     0   2   38 38                 76
743367 743367 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2015   grade_6 14 17 38 0   9     0   6   43 41                       84 14 17 38 0   9     0   6   43 41                 84
743342 743342 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2015   grade_6 31 3 4 0   3     0   5   28 18                       46 31 3 4 0   3     0   5   28 18                 46
743114 743114 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2015   grade_6 5 4 7 0   0     0   3   10 9                       19 5 4 7 0   0     0   3   10 9                 19
743334 743334 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   grade_6 8 9 26 1   3     0   4   25 26                       51 8 9 26 1   3     0   4   25 26                 51
743327 743327 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2015   grade_6 14 5 13 0   2     0   3   16 21                       37 14 5 13 0   2     0   3   16 21                 37
743320 743320 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2015   grade_6 28 14 19 1   5     0   7   35 39                       74 28 14 19 1   5     0   7   35 39                 74
743313 743313 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2015   grade_6 21 2 17 1   1     0   2   20 24                       44 21 2 17 1   1     0   2   20 24                 44
743305 743305 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   grade_6 23 6 21 0   4     0   5   30 29                       59 23 6 21 0   4     0   5   30 29                 59
743297 743297 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   grade_6 11 9 16 0   1     0   4   23 18                       41 11 9 16 0   1     0   4   23 18                 41
743290 743290 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2015   grade_6 29 10 29 0   12     0   3   40 43                       83 29 10 29 0   12     0   3   40 43                 83
743282 743282 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2015   grade_6 33 12 20 0   5     0   1   40 31                       71 33 12 20 0   5     0   1   40 31                 71
743274 743274 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2015   grade_6 39 3 3 0   3     0   2   25 25                       50 39 3 3 0   3     0   2   25 25                 50
743267 743267 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2015   grade_6 27 5 5 0   3     0   2   21 21                       42 27 5 5 0   3     0   2   21 21                 42
743252 743252 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2015   grade_6 17 6 16 0   2     0   1   17 25                       42 17 6 16 0   2     0   1   17 25                 42
743245 743245 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2015   grade_6 3 7 10 0   1     0   0   9 12                       21 3 7 10 0   1     0   0   9 12                 21
743237 743237 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2015   grade_6 20 6 8 0   3     0   3   11 29                       40 20 6 8 0   3     0   3   11 29                 40
743222 743222 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2015   grade_6 22 3 3 1   1     0   2   19 13                       32 22 3 3 1   1     0   2   19 13                 32
743370 743370 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2015   grade_6 25 4 10 0   8     0   2   21 28                       49 25 4 10 0   8     0   2   21 28                 49
743215 743215 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2015   grade_6 11 4 15 0   3     0   2   21 14                       35 11 4 15 0   3     0   2   21 14                 35
743207 743207 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   grade_6 20 14 21 0   12     0   4   52 19                       71 20 14 21 0   12     0   4   52 19                 71
743199 743199 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2015   grade_6 7 9 47 0   10     0   3   42 34                       76 7 9 47 0   10     0   3   42 34                 76
743260 743260 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_6 10 4 3 0   0     0   1   7 11                       18 10 4 3 0   0     0   1   7 11                 18
743183 743183 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2015   grade_6 31 1 8 0   2     0   0   21 21                       42 31 1 8 0   2     0   0   21 21                 42
743191 743191 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2015   grade_6 22 8 30 0   4     0   4   40 28                       68 22 8 30 0   4     0   4   40 28                 68
743176 743176 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   grade_6 8 5 20 0   4     0   0   24 13                       37 8 5 20 0   4     0   0   24 13                 37
743168 743168 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2015   grade_6 12 2 20 0   1     0   2   17 20                       37 12 2 20 0   1     0   2   17 20                 37
743144 743144 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2015   grade_6 2 9 23 0   5     0   3   18 24                       42 2 9 23 0   5     0   3   18 24                 42
743137 743137 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   grade_6 10 8 22 0   5     0   1   27 19                       46 10 8 22 0   5     0   1   27 19                 46
743129 743129 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2015   grade_6 3 4 13 0   0     0   2   12 10                       22 3 4 13 0   0     0   2   12 10                 22
743107 743107 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   grade_6 4 9 17 0   5     0   1   21 15                       36 4 9 17 0   5     0   1   21 15                 36
743122 743122 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_6 3 6 43 0   6     0   0   38 20                       58 3 6 43 0   6     0   0   38 20                 58
743089 743089 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_6 130 14 15 0   10     0   0   84 85                       169 130 14 15 0   10     0   0   84 85                 169
743092 743092 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2015   grade_6 132 8 11 0   6     0   3   82 78                       160 132 8 11 0   6     0   3   82 78                 160
743031 743031 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2015   grade_6 147 1 16 0   1     0   1   75 91                       166 147 1 16 0   1     0   1   75 91                 166
743017 743017 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No 2 06 08 2015   grade_6 303 0 11 0   51     0   8   182 191                       373 303 0 11 0   51     0   8   182 191                 373
742979 742979 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2015   grade_6 97 1 8 1   2     0   4   55 58                       113 97 1 8 1   2     0   4   55 58                 113
742964 742964 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2015   grade_6 257 5 8 0   14     0   10   147 147                       294 257 5 8 0   14     0   10   147 147                 294
742949 742949 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2015   grade_6 48 1 6 0   3     0   7   37 28                       65 48 1 6 0   3     0   7   37 28                 65
742941 742941 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg Schools   Regular School No 1 PK 06 2015   grade_6 25 0 3 1   1     0   0   14 16                       30 25 0 3 1   1     0   0   14 16                 30
745019 745019 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2015   grade_6 121 2 1 0   2     0   4   70 60                       130 121 2 1 0   2     0   4   70 60                 130
745016 745016 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2015   grade_6 195 2 3 1   2     1   7   93 118                       211 195 2 3 1   2     1   7   93 118                 211
742933 742933 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 1 0   0     0   0   7 8                       15 14 0 1 0   0     0   0   7 8                 15
742920 742920 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_6 369 31 31 2   20     0   17   237 233                       470 369 31 31 2   20     0   17   237 233                 470
742869 742869 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2015   grade_6 234 6 10 0   21     0   1   127 145                       272 234 6 10 0   21     0   1   127 145                 272
742792 742792 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Middle   Regular School No 2 06 08 2015   grade_6 124 1 2 3   1     0   3   80 54                       134 124 1 2 3   1     0   3   80 54                 134
742777 742777 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2015   grade_6 125 12 9 0   25     0   11   91 91                       182 125 12 9 0   25     0   11   91 91                 182
742764 742764 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2015   grade_6 23 0 0 0   0     0   0   9 14                       23 23 0 0 0   0     0   0   9 14                 23
742750 742750 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2015   grade_6 185 1 6 0   50     0   9   127 124                       251 185 1 6 0   50     0   9   127 124                 251
742747 742747 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2015   grade_6 137 2 1 2   46     0   6   86 108                       194 137 2 1 2   46     0   6   86 108                 194
742716 742716 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No 2 06 08 2015   grade_6 167 4 20 0   6     0   2   100 99                       199 167 4 20 0   6     0   2   100 99                 199
742713 742713 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2015   grade_6 186 2 20 0   3     1   5   107 110                       217 186 2 20 0   3     1   5   107 110                 217
742633 742633 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2015   grade_6 204 4 16 1   72     1   11   180 129                       309 204 4 16 1   72     1   11   180 129                 309
742285 742285 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2015   grade_6 26 1 6 1   1     0   3   17 21                       38 26 1 6 1   1     0   3   17 21                 38
742828 742828 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No 2 06 08 2015   grade_6 208 7 57 0   19     0   2   148 145                       293 208 7 57 0   19     0   2   148 145                 293
742663 742663 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2015   grade_6 85 1 4 0   4     0   4   50 48                       98 85 1 4 0   4     0   4   50 48                 98
742648 742648 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2015   grade_6 67 3 4 0   0     0   3   36 41                       77 67 3 4 0   0     0   3   36 41                 77
742603 742603 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2015   grade_6 320 14 21 0   43     0   25   227 196                       423 320 14 21 0   43     0   25   227 196                 423
742552 742552 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_6 106 11 29 0   2     1   7   78 78                       156 106 11 29 0   2     1   7   78 78                 156
742538 742538 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No 2 06 08 2015   grade_6 164 13 7 0   34     0   16   109 125                       234 164 13 7 0   34     0   16   109 125                 234
742514 742514 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2015   grade_6 141 7 40 2   25     0   6   113 108                       221 141 7 40 2   25     0   6   113 108                 221
744990 744990 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 49 0 0 0   0     0   0   28 21                       49 49 0 0 0   0     0   0   28 21                 49
744982 744982 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2015   grade_6 76 0 5 0   0     0   1   37 45                       82 76 0 5 0   0     0   1   37 45                 82
742477 742477 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_6 149 11 13 3   1     0   17   102 92                       194 149 11 13 3   1     0   17   102 92                 194
742462 742462 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2015   grade_6 95 5 7 0   0     3   4   66 48                       114 95 5 7 0   0     3   4   66 48                 114
742447 742447 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No 2 06 08 2015   grade_6 86 17 69 0   6     0   7   103 82                       185 86 17 69 0   6     0   7   103 82                 185
742444 742444 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2015   grade_6 96 20 45 1   11     0   2   91 84                       175 96 20 45 1   11     0   2   91 84                 175
742398 742398 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2015   grade_6 119 5 4 0   9     0   4   66 75                       141 119 5 4 0   9     0   4   66 75                 141
742395 742395 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No 2 06 08 2015   grade_6 139 10 10 1   2     0   3   82 83                       165 139 10 10 1   2     0   3   82 83                 165
742369 742369 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   5 16                       21 20 0 1 0   0     0   0   5 16                 21
742354 742354 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2015   grade_6 263 8 14 0   5     1   2   154 139                       293 263 8 14 0   5     1   2   154 139                 293
744954 744954 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2015   grade_6 48 0 2 0   2     0   1   28 25                       53 48 0 2 0   2     0   1   28 25                 53
744967 744967 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2015   grade_6 85 1 5 0   1     0   0   58 34                       92 85 1 5 0   1     0   0   58 34                 92
744945 744945 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2015   grade_6 62 1 3 0   0     0   0   34 32                       66 62 1 3 0   0     0   0   34 32                 66
744963 744963 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2015   grade_6 118 3 6 0   3     0   3   71 62                       133 118 3 6 0   3     0   3   71 62                 133
744960 744960 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2015   grade_6 242 4 14 1   17     0   9   133 154                       287 242 4 14 1   17     0   9   133 154                 287
742321 742321 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2015   grade_6 149 2 6 0   3     0   4   83 81                       164 149 2 6 0   3     0   4   83 81                 164
742310 742310 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2015   grade_6 112 2 3 1   4     0   6   56 72                       128 112 2 3 1   4     0   6   56 72                 128
744872 744872 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No 1 PK 06 2015   grade_6 58 0 4 1   1     0   1   32 33                       65 58 0 4 1   1     0   1   32 33                 65
744888 744888 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No 1 PK 06 2015   grade_6 72 0 2 0   0     0   0   39 35                       74 72 0 2 0   0     0   0   39 35                 74
744880 744880 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2015   grade_6 66 0 3 1   1     0   0   40 31                       71 66 0 3 1   1     0   0   40 31                 71
742290 742290 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No 2 04 06 2015   grade_6 79 0 3 0   3     0   1   40 46                       86 79 0 3 0   3     0   1   40 46                 86
742268 742268 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No 2 05 06 2015   grade_6 269 8 4 0   11     0   4   147 149                       296 269 8 4 0   11     0   4   147 149                 296
742243 742243 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2015   grade_6 91 20 35 0   1     0   4   77 74                       151 91 20 35 0   1     0   4   77 74                 151
742235 742235 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2015   grade_6 162 37 29 0   4     0   7   111 128                       239 162 37 29 0   4     0   7   111 128                 239
742246 742246 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2015   grade_6 192 16 24 1   2     0   10   138 107                       245 192 16 24 1   2     0   10   138 107                 245
742196 742196 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No 2 06 08 2015   grade_6 151 2 4 0   3     0   6   87 79                       166 151 2 4 0   3     0   6   87 79                 166
742176 742176 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2015   grade_6 139 6 19 0   2     0   5   80 91                       171 139 6 19 0   2     0   5   80 91                 171
742151 742151 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2015   grade_6 109 3 0 0   3     0   7   66 56                       122 109 3 0 0   3     0   7   66 56                 122
742143 742143 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_6 22 0 2 0   3     0   1   13 15                       28 22 0 2 0   3     0   1   13 15                 28
742133 742133 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2015   grade_6 287 9 10 0   15     0   7   160 168                       328 287 9 10 0   15     0   7   160 168                 328
742107 742107 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_6 121 0 7 0   1     0   2   63 68                       131 121 0 7 0   1     0   2   63 68                 131
742092 742092 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2015   grade_6 183 68 22 0   13     0   3   140 149                       289 183 68 22 0   13     0   3   140 149                 289
742052 742052 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No 2 05 08 2015   grade_6 163 3 13 0   6     0   7   94 98                       192 163 3 13 0   6     0   7   94 98                 192
741989 741989 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2015   grade_6 7 8 57 0   4     0   1   35 42                       77 7 8 57 0   4     0   1   35 42                 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]);