enrollments

Data source: Big Local News · About: Big Local

577 rows where grade = "grade_6", state = "MA" and year = 2017 sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 577 ✖

grade ✖

  • grade_6 · 577 ✖
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
1132093 1132093 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   0     0   0   3 8                       11 11 0 0 0   0     0   0   3 8                 11
1131086 1131086 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Elementary 04 06 2017   grade_6 130 2 3 0   1     0   4   66 74                       140 130 2 3 0   1     0   4   66 74                 140
1131076 1131076 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_6 8 0 0 0   0     0   0   3 5                       8 8 0 0 0   0     0   0   3 5                 8
1130800 1130800 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_6 15 3 34 0   1     0   2   26 29                       55 15 3 34 0   1     0   2   26 29                 55
1130878 1130878 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2017   grade_6 6 11 22 0   2     0   3   18 26                       44 6 11 22 0   2     0   3   18 26                 44
1130791 1130791 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_6 3 4 60 0   3     0   2   27 45                       72 3 4 60 0   3     0   2   27 45                 72
1131015 1131015 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2017   grade_6 9 13 34 0   3     0   3   38 24                       62 9 13 34 0   3     0   3   38 24                 62
1131037 1131037 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_6 19 17 32 0   6     0   5   34 45                       79 19 17 32 0   6     0   5   34 45                 79
1131006 1131006 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2017   grade_6 25 2 4 0   2     0   2   18 17                       35 25 2 4 0   2     0   2   18 17                 35
1130748 1130748 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_6 6 2 7 0   0     0   1   9 7                       16 6 2 7 0   0     0   1   9 7                 16
1130997 1130997 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2017   grade_6 6 9 41 0   2     0   3   30 31                       61 6 9 41 0   2     0   3   30 31                 61
1130989 1130989 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2017   grade_6 21 5 16 0   1     0   1   15 29                       44 21 5 16 0   1     0   1   15 29                 44
1130981 1130981 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2017   grade_6 19 11 18 0   2     0   1   35 16                       51 19 11 18 0   2     0   1   35 16                 51
1130972 1130972 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_6 25 5 8 0   0     0   4   14 28                       42 25 5 8 0   0     0   4   14 28                 42
1130963 1130963 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2017   grade_6 33 10 23 0   2     0   3   33 38                       71 33 10 23 0   2     0   3   33 38                 71
1130954 1130954 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No Elementary KG 06 2017   grade_6 20 10 20 0   3     0   4   35 22                       57 20 10 20 0   3     0   4   35 22                 57
1130946 1130946 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2017   grade_6 25 21 50 0   7     0   7   53 57                       110 25 21 50 0   7     0   7   53 57                 110
1130937 1130937 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2017   grade_6 24 15 17 0   4     0   1   29 32                       61 24 15 17 0   4     0   1   29 32                 61
1130928 1130928 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary KG 06 2017   grade_6 37 10 9 0   3     0   2   29 32                       61 37 10 9 0   3     0   2   29 32                 61
1130920 1130920 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   grade_6 15 0 5 0   6     0   4   16 14                       30 15 0 5 0   6     0   4   16 14                 30
1130903 1130903 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2017   grade_6 28 4 14 1   2     0   4   26 27                       53 28 4 14 1   2     0   4   26 27                 53
1130895 1130895 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   grade_6 2 5 16 0   2     0   1   11 15                       26 2 5 16 0   2     0   1   11 15                 26
1130886 1130886 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2017   grade_6 16 4 6 0   2     0   1   17 12                       29 16 4 6 0   2     0   1   17 12                 29
1130869 1130869 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2017   grade_6 21 3 5 0   5     0   0   15 19                       34 21 3 5 0   5     0   0   15 19                 34
1131041 1131041 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_6 19 7 10 0   8     0   4   25 23                       48 19 7 10 0   8     0   4   25 23                 48
1130861 1130861 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   grade_6 9 4 14 0   1     0   0   14 14                       28 9 4 14 0   1     0   0   14 14                 28
1130852 1130852 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2017   grade_6 25 15 26 0   11     0   1   46 32                       78 25 15 26 0   11     0   1   46 32                 78
1130843 1130843 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2017   grade_6 9 4 39 0   10     0   3   43 22                       65 9 4 39 0   10     0   3   43 22                 65
1130912 1130912 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   grade_6 13 9 16 0   1     0   5   19 25                       44 13 9 16 0   1     0   5   19 25                 44
1130825 1130825 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2017   grade_6 34 5 7 0   0     0   4   17 33                       50 34 5 7 0   0     0   4   17 33                 50
1130834 1130834 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary PK 06 2017   grade_6 14 7 31 1   2     0   2   22 35                       57 14 7 31 1   2     0   2   22 35                 57
1130817 1130817 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   grade_6 6 6 23 0   4     0   3   23 19                       42 6 6 23 0   4     0   3   23 19                 42
1130808 1130808 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_6 2 11 15 0   0     0   0   21 7                       28 2 11 15 0   0     0   0   21 7                 28
1130782 1130782 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_6 5 12 43 0   7     0   2   35 34                       69 5 12 43 0   7     0   2   35 34                 69
1130774 1130774 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_6 7 6 24 0   6     0   0   18 25                       43 7 6 24 0   6     0   0   18 25                 43
1130765 1130765 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_6 8 6 15 0   2     0   1   18 14                       32 8 6 15 0   2     0   1   18 14                 32
1130740 1130740 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_6 6 9 26 0   2     0   2   20 25                       45 6 9 26 0   2     0   2   20 25                 45
1130757 1130757 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_6 3 7 57 0   8     0   0   41 34                       75 3 7 57 0   8     0   0   41 34                 75
1130718 1130718 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_6 112 12 9 3   10     0   2   66 82                       148 112 12 9 3   10     0   2   66 82                 148
1130722 1130722 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_6 128 10 9 0   5     0   6   82 76                       158 128 10 9 0   5     0   6   82 76                 158
1130650 1130650 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2017   grade_6 128 0 15 0   1     0   2   77 69                       146 128 0 15 0   1     0   2   77 69                 146
1130632 1130632 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2017   grade_6 283 6 12 1   68     0   16   200 186                       386 283 6 12 1   68     0   16   200 186                 386
1130582 1130582 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_6 80 0 4 0   4     0   6   52 42                       94 80 0 4 0   4     0   6   52 42                 94
1130563 1130563 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_6 228 3 11 0   12     0   11   135 130                       265 228 3 11 0   12     0   11   135 130                 265
1130541 1130541 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No Elementary PK 06 2017   grade_6 50 0 4 0   2     0   3   30 29                       59 50 0 4 0   2     0   3   30 29                 59
1130532 1130532 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_6 25 0 0 0   0     0   0   16 9                       25 25 0 0 0   0     0   0   16 9                 25
1132963 1132963 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 06 08 2017   grade_6 129 1 5 0   0     0   1   84 52                       136 129 1 5 0   0     0   1   84 52                 136
1132959 1132959 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2017   grade_6 165 10 9 3   1     1   7   112 84                       196 165 10 9 3   1     1   7   112 84                 196
1130523 1130523 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   14 6                       20 19 0 1 0   0     0   0   14 6                 20
1130509 1130509 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2017   grade_6 365 24 33 2   20     1   13   241 217                       458 365 24 33 2   20     1   13   241 217                 458
1130462 1130462 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1130444 1130444 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2017   grade_6 216 13 11 0   22     0   11   132 141                       273 216 13 11 0   22     0   11   132 141                 273
1130351 1130351 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2017   grade_6 103 1 3 0   1     0   5   62 51                       113 103 1 3 0   1     0   5   62 51                 113
1130334 1130334 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2017   grade_6 113 12 6 1   24     0   9   95 70                       165 113 12 6 1   24     0   9   95 70                 165
1130317 1130317 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_6 16 0 1 0   0     0   0   6 11                       17 16 0 1 0   0     0   0   6 11                 17
1130301 1130301 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_6 176 0 0 0   70     0   5   144 107                       251 176 0 0 0   70     0   5   144 107                 251
1130297 1130297 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_6 132 2 0 0   56     0   1   99 92                       191 132 2 0 0   56     0   1   99 92                 191
1130257 1130257 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 South Middle School   Regular School No Middle 06 08 2017   grade_6 140 4 40 0   7     0   2   98 95                       193 140 4 40 0   7     0   2   98 95                 193
1130253 1130253 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No Middle 06 08 2017   grade_6 171 1 21 0   3     0   7   101 102                       203 171 1 21 0   3     0   7   101 102                 203
1130158 1130158 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Elementary 04 06 2017   grade_6 161 1 16 0   88     0   13   151 128                       279 161 1 16 0   88     0   13   151 128                 279
1129745 1129745 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_6 20 0 9 0   0     0   0   19 10                       29 20 0 9 0   0     0   0   19 10                 29
1130396 1130396 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2017   grade_6 220 12 54 1   25     0   4   176 140                       316 220 12 54 1   25     0   4   176 140                 316
1130193 1130193 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Elementary 04 06 2017   grade_6 85 2 6 0   0     0   0   55 38                       93 85 2 6 0   0     0   0   55 38                 93
1130176 1130176 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No Other 06 12 2017   grade_6 70 2 6 0   1     0   3   35 47                       82 70 2 6 0   1     0   3   35 47                 82
1130123 1130123 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_6 291 9 18 0   46     0   28   215 177                       392 291 9 18 0   46     0   28   215 177                 392
1130064 1130064 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_6 88 8 40 0   2     0   8   53 93                       146 88 8 40 0   2     0   8   53 93                 146
1130047 1130047 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2017   grade_6 132 12 10 0   36     0   17   97 110                       207 132 12 10 0   36     0   17   97 110                 207
1130017 1130017 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2017   grade_6 136 10 20 2   15     1   10   94 100                       194 136 10 20 2   15     1   10   94 100                 194
1132926 1132926 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 49 0 2 0   0     0   2   27 26                       53 49 0 2 0   0     0   2   27 26                 53
1132917 1132917 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2017   grade_6 68 0 6 0   0     0   2   37 39                       76 68 0 6 0   0     0   2   37 39                 76
1129979 1129979 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_6 161 16 11 2   0     0   14   109 95                       204 161 16 11 2   0     0   14   109 95                 204
1129961 1129961 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Elementary 04 06 2017   grade_6 79 1 12 0   2     0   5   48 51                       99 79 1 12 0   2     0   5   48 51                 99
1129944 1129944 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2017   grade_6 85 15 91 0   7     1   6   103 102                       205 85 15 91 0   7     1   6   103 102                 205
1129940 1129940 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_6 82 21 50 0   14     0   2   97 72                       169 82 21 50 0   14     0   2   97 72                 169
1129885 1129885 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2017   grade_6 121 2 5 0   17     0   1   78 68                       146 121 2 5 0   17     0   1   78 68                 146
1129881 1129881 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2017   grade_6 145 2 8 2   2     0   3   82 80                       162 145 2 8 2   2     0   3   82 80                 162
1129849 1129849 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   grade_6 18 0 0 1   0     0   1   8 12                       20 18 0 0 1   0     0   1   8 12                 20
1129833 1129833 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_6 217 9 19 0   6     0   6   146 111                       257 217 9 19 0   6     0   6   146 111                 257
1132884 1132884 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2017   grade_6 44 0 2 0   0     0   1   23 24                       47 44 0 2 0   0     0   1   23 24                 47
1132901 1132901 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_6 85 1 6 0   2     0   2   48 48                       96 85 1 6 0   2     0   2   48 48                 96
1132874 1132874 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2017   grade_6 59 1 2 0   1     0   1   37 27                       64 59 1 2 0   1     0   1   37 27                 64
1132896 1132896 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2017   grade_6 120 0 3 0   5     0   9   77 60                       137 120 0 3 0   5     0   9   77 60                 137
1132892 1132892 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2017   grade_6 224 7 9 0   9     0   4   133 120                       253 224 7 9 0   9     0   4   133 120                 253
1129790 1129790 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No Middle 06 08 2017   grade_6 115 3 6 0   2     0   1   73 54                       127 115 3 6 0   2     0   1   73 54                 127
1129776 1129776 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2017   grade_6 116 1 4 0   11     0   3   69 66                       135 116 1 4 0   11     0   3   69 66                 135
1132789 1132789 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2017   grade_6 49 1 2 0   2     0   2   25 31                       56 49 1 2 0   2     0   2   25 31                 56
1132807 1132807 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2017   grade_6 85 2 1 0   0     0   1   41 48                       89 85 2 1 0   0     0   1   41 48                 89
1132798 1132798 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2017   grade_6 73 0 3 0   0     0   0   42 34                       76 73 0 3 0   0     0   0   42 34                 76
1129766 1129766 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_6 8 0 1 0   0     0   0   3 6                       9 8 0 1 0   0     0   0   3 6                 9
1129751 1129751 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Elementary 04 06 2017   grade_6 82 0 5 0   0     0   2   40 49                       89 82 0 5 0   0     0   2   40 49                 89
1129725 1129725 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No Middle 05 06 2017   grade_6 254 5 5 1   8     0   2   147 128                       275 254 5 5 1   8     0   2   147 128                 275
1129694 1129694 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2017   grade_6 77 32 14 1   1     0   11   62 74                       136 77 32 14 1   1     0   11   62 74                 136
1129684 1129684 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2017   grade_6 160 35 28 1   4     0   5   131 102                       233 160 35 28 1   4     0   5   131 102                 233
1129698 1129698 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2017   grade_6 178 24 28 2   1     0   16   128 121                       249 178 24 28 2   1     0   16   128 121                 249
1129636 1129636 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2017   grade_6 151 1 2 0   0     0   2   76 80                       156 151 1 2 0   0     0   2   76 80                 156
1129610 1129610 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2017   grade_6 129 5 17 1   5     0   4   82 79                       161 129 5 17 1   5     0   4   82 79                 161
1129581 1129581 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2017   grade_6 119 1 3 0   4     0   5   72 60                       132 119 1 3 0   4     0   5   72 60                 132
1129570 1129570 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2017   grade_6 29 2 3 0   1     0   5   21 19                       40 29 2 3 0   1     0   5   21 19                 40
1129559 1129559 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2017   grade_6 243 8 10 0   27     0   17   148 157                       305 243 8 10 0   27     0   17   148 157                 305
1129528 1129528 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_6 109 0 6 0   2     0   9   70 56                       126 109 0 6 0   2     0   9   70 56                 126

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