enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 391 ✖

grade ✖

  • grade_7 · 391 ✖
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
939902 939902 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2016   grade_7 127 7 13 0   7     0   3   81 76                       157 127 7 13 0   7     0   3   81 76                 157
934588 934588 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2016   grade_7 303 6 6 1   1     0   13   156 174                       330 303 6 6 1   1     0   13   156 174                 330
935678 935678 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No 2 05 07 2016   grade_7 191 4 11 2   3     0   3   111 103                       214 191 4 11 2   3     0   3   111 103                 214
933148 933148 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 11 2016   grade_7 1 36 14 0   0     0   1   28 24                       52 1 36 14 0   0     0   1   28 24                 52
934617 934617 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2016   grade_7 166 16 27 1   4     0   9   116 107                       223 166 16 27 1   4     0   9   116 107                 223
933161 933161 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   grade_7 5 19 24 0   0     0   3   21 30                       51 5 19 24 0   0     0   3   21 30                 51
941043 941043 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2016   grade_7 108 1 5 0   1     0   2   63 54                       117 108 1 5 0   1     0   2   63 54                 117
932669 932669 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2016   grade_7 149 1 9 0   26     0   6   89 102                       191 149 1 9 0   26     0   6   89 102                 191
933170 933170 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   grade_7 7 4 66 0   0     0   1   44 34                       78 7 4 66 0   0     0   1   44 34                 78
936753 936753 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2016   grade_7 71 6 67 1   3     0   3   86 65                       151 71 6 67 1   3     0   3   86 65                 151
940597 940597 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2016   grade_7 0 27 7 0   0     0   0   17 17                       34 0 27 7 0   0     0   0   17 17                 34
941047 941047 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No 2 05 08 2016   grade_7 127 2 6 0   0     0   5   78 62                       140 127 2 6 0   0     0   5   78 62                 140
934639 934639 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2016   grade_7 119 2 3 0   0     1   2   62 65                       127 119 2 3 0   0     1   2   62 65                 127
941056 941056 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No 2 06 08 2016   grade_7 149 3 2 1   11     0   6   95 77                       172 149 3 2 1   11     0   6   95 77                 172
936201 936201 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No 2 05 08 2016   grade_7 61 9 68 0   29     0   4   93 78                       171 61 9 68 0   29     0   4   93 78                 171
935444 935444 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_7 79 2 53 0   2     0   0   66 70                       136 79 2 53 0   2     0   0   66 70                 136
938312 938312 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No 2 06 08 2016   grade_7 163 1 8 0   5     0   2   90 89                       179 163 1 8 0   5     0   2   90 89                 179
937551 937551 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No 2 06 08 2016   grade_7 178 19 23 0   21     0   7   123 125                       248 178 19 23 0   21     0   7   123 125                 248
933645 933645 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_7 9 27 17 0   4     0   1   30 28                       58 9 27 17 0   4     0   1   30 28                 58
941076 941076 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2016   grade_7 131 3 12 1   4     0   5   83 73                       156 131 3 12 1   4     0   5   83 73                 156
934448 934448 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No 2 06 08 2016   grade_7 151 6 83 1   7     0   7   142 113                       255 151 6 83 1   7     0   7   142 113                 255
934693 934693 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No 2 06 08 2016   grade_7 242 1 7 0   5     0   5   135 125                       260 242 1 7 0   5     0   5   135 125                 260
935596 935596 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_7 7 0 38 0   0     0   1   20 26                       46 7 0 38 0   0     0   1   20 26                 46
938456 938456 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2016   grade_7 14 4 38 0   2     0   0   34 24                       58 14 4 38 0   2     0   0   34 24                 58
939675 939675 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No 2 06 08 2016   grade_7 222 9 10 0   19     0   2   116 146                       262 222 9 10 0   19     0   2   116 146                 262
934707 934707 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_7 171 2 0 1   3     0   5   87 95                       182 171 2 0 1   3     0   5   87 95                 182
933900 933900 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No 2 06 08 2016   grade_7 191 15 8 0   37     0   3   137 117                       254 191 15 8 0   37     0   3   137 117                 254
934007 934007 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2016   grade_7 21 123 24 0   1     2   9   98 82                       180 21 123 24 0   1     2   9   98 82                 180
934778 934778 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_7 247 18 11 0   9     0   6   134 157                       291 247 18 11 0   9     0   6   134 157                 291
933964 933964 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_7 28 70 16 0   0     1   2   58 59                       117 28 70 16 0   0     1   2   58 59                 117
934791 934791 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_7 34 1 3 2   0     0   0   17 23                       40 34 1 3 2   0     0   0   17 23                 40
933583 933583 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   grade_7 9 17 40 1   12     0   2   47 34                       81 9 17 40 1   12     0   2   47 34                 81
934054 934054 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_7 40 3 10 0   25     1   6   48 37                       85 40 3 10 0   25     1   6   48 37                 85
934063 934063 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_7 53 5 10 0   9     0   8   45 40                       85 53 5 10 0   9     0   8   45 40                 85
939207 939207 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2016   grade_7 116 8 6 0   10     0   3   67 76                       143 116 8 6 0   10     0   3   67 76                 143
933187 933187 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2016   grade_7 8 7 11 0   3     0   1   20 10                       30 8 7 11 0   3     0   1   20 10                 30
935815 935815 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_7 4 0 77 0   4     0   1   49 37                       86 4 0 77 0   4     0   1   49 37                 86
938944 938944 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2016   grade_7 296 8 13 0   17     0   5   168 171                       339 296 8 13 0   17     0   5   168 171                 339
934370 934370 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2016   grade_7 6 8 93 0   2     0   1   64 46                       110 6 8 93 0   2     0   1   64 46                 110
940237 940237 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_7 15 11 138 0   1     0   0   95 70                       165 15 11 138 0   1     0   0   95 70                 165
937240 937240 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No 2 06 08 2016   grade_7 200 20 18 1   32     0   17   144 144                       288 200 20 18 1   32     0   17   144 144                 288
936373 936373 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2016   grade_7 8 1 3 0   0     0   0   8 4                       12 8 1 3 0   0     0   0   8 4                 12
936421 936421 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_7 29 24 20 1   22     0   5   68 33                       101 29 24 20 1   22     0   5   68 33                 101
941423 941423 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_7 97 1 1 0   2     0   0   48 53                       101 97 1 1 0   2     0   0   48 53                 101
940174 940174 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_7 235 53 145 1   33     0   26   255 238                       493 235 53 145 1   33     0   26   255 238                 493
938768 938768 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No 2 06 08 2016   grade_7 22 47 141 0   18     0   0   114 114                       228 22 47 141 0   18     0   0   114 114                 228
936430 936430 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No 1 KG 08 2016   grade_7 27 10 16 0   7     0   0   35 25                       60 27 10 16 0   7     0   0   35 25                 60
940255 940255 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2016   grade_7 27 0 6 0   2     0   1   18 18                       36 27 0 6 0   2     0   1   18 18                 36
936595 936595 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No 2 04 07 2016   grade_7 94 2 7 0   2     0   3   52 56                       108 94 2 7 0   2     0   3   52 56                 108
940445 940445 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_7 47 40 4 0   14     1   6   60 52                       112 47 40 4 0   14     1   6   60 52                 112
940605 940605 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes 3 07 12 2016   grade_7 60 1 0 0   1     0   1   26 37                       63 60 1 0 0   1     0   1   26 37                 63
933204 933204 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2016   grade_7 5 19 22 0   1     0   0   26 21                       47 5 19 22 0   1     0   0   26 21                 47
940937 940937 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2016   grade_7 120 2 10 0   3     0   1   69 67                       136 120 2 10 0   3     0   1   69 67                 136
941114 941114 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2016   grade_7 245 1 2 0   2     0   3   130 123                       253 245 1 2 0   2     0   3   130 123                 253
932544 932544 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2016   grade_7 150 7 8 0   1     0   3   90 79                       169 150 7 8 0   1     0   3   90 79                 169
941120 941120 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2016   grade_7 102 1 5 0   4     0   3   58 57                       115 102 1 5 0   4     0   3   58 57                 115
935826 935826 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2016   grade_7 16 1 104 0   7     0   1   68 61                       129 16 1 104 0   7     0   1   68 61                 129
935145 935145 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No 2 06 08 2016   grade_7 74 10 58 0   4     0   4   84 66                       150 74 10 58 0   4     0   4   84 66                 150
936559 936559 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2016   grade_7 309 0 13 1   4     0   3   160 170                       330 309 0 13 1   4     0   3   160 170                 330
939163 939163 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2016   grade_7 263 10 15 1   3     1   2   150 145                       295 263 10 15 1   3     1   2   150 145                 295
935213 935213 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 05 07 2016   grade_7 149 3 24 0   3     0   10   99 90                       189 149 3 24 0   3     0   10   99 90                 189
933515 933515 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   grade_7 7 5 20 0   1     0   1   24 10                       34 7 5 20 0   1     0   1   24 10                 34
938082 938082 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No 2 06 08 2016   grade_7 60 7 90 2   14     0   4   76 101                       177 60 7 90 2   14     0   4   76 101                 177
938292 938292 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No 2 07 08 2016   grade_7 243 7 1 0   2     0   3   126 130                       256 243 7 1 0   2     0   3   126 130                 256
941139 941139 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Junior High School   Regular School No 2 07 08 2016   grade_7 76 0 5 0   0     0   1   43 39                       82 76 0 5 0   0     0   1   43 39                 82
934833 934833 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_7 43 13 35 0   12     0   3   58 48                       106 43 13 35 0   12     0   3   58 48                 106
935232 935232 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 07 08 2016   grade_7 111 0 0 0   2     0   1   59 55                       114 111 0 0 0   2     0   1   59 55                 114
936060 936060 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2016   grade_7 77 5 5 0   9     0   5   55 46                       101 77 5 5 0   9     0   5   55 46                 101
940725 940725 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_7 31 10 33 0   2     0   5   40 41                       81 31 10 33 0   2     0   5   40 41                 81
934001 934001 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_7 3 5 1 0   0     0   0   6 3                       9 3 5 1 0   0     0   0   6 3                 9
935295 935295 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2016   grade_7 176 4 9 0   23     0   8   107 113                       220 176 4 9 0   23     0   8   107 113                 220
935309 935309 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_7 52 1 6 0   3     0   0   38 24                       62 52 1 6 0   3     0   0   38 24                 62
936879 936879 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2016   grade_7 95 1 0 0   0     0   0   45 51                       96 95 1 0 0   0     0   0   45 51                 96
941183 941183 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No 2 06 08 2016   grade_7 68 0 4 0   0     0   2   24 50                       74 68 0 4 0   0     0   2   24 50                 74
935335 935335 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2016   grade_7 63 0 17 0   3     0   11   55 39                       94 63 0 17 0   3     0   11   55 39                 94
937277 937277 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2016   grade_7 27 1 3 0   1     1   1   19 15                       34 27 1 3 0   1     1   1   19 15                 34
941161 941161 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2016   grade_7 184 3 2 0   13     0   1   115 88                       203 184 3 2 0   13     0   1   115 88                 203
935778 935778 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2016   grade_7 3 3 113 0   4     0   1   62 62                       124 3 3 113 0   4     0   1   62 62                 124
941429 941429 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2016   grade_7 82 0 1 0   5     0   0   58 30                       88 82 0 1 0   5     0   0   58 30                 88
940748 940748 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2016   grade_7 30 20 26 0   3     0   4   46 37                       83 30 20 26 0   3     0   4   46 37                 83
941240 941240 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_7 129 2 5 1   1     0   1   64 75                       139 129 2 5 1   1     0   1   64 75                 139
935383 935383 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2016   grade_7 214 1 5 0   7     0   0   117 110                       227 214 1 5 0   7     0   0   117 110                 227
936031 936031 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2016   grade_7 17 11 11 2   1     0   6   23 25                       48 17 11 11 2   1     0   6   23 25                 48
941841 941841 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_7 119 3 2 0   2     0   4   72 58                       130 119 3 2 0   2     0   4   72 58                 130
936463 936463 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2016   grade_7 314 13 11 0   19     0   12   187 182                       369 314 13 11 0   19     0   12   187 182                 369
934878 934878 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2016   grade_7 126 1 7 2   5     0   1   79 63                       142 126 1 7 2   5     0   1   79 63                 142
941462 941462 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2016   grade_7 107 1 4 0   2     0   7   61 60                       121 107 1 4 0   2     0   7   61 60                 121
934083 934083 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2016   grade_7 38 2 4 0   9     0   1   22 32                       54 38 2 4 0   9     0   1   22 32                 54
940285 940285 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2016   grade_7 0 64 15 0   0     2   1   44 38                       82 0 64 15 0   0     2   1   44 38                 82
936193 936193 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No 2 05 08 2016   grade_7 32 12 71 0   35     0   6   84 72                       156 32 12 71 0   35     0   6   84 72                 156
934918 934918 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_7 41 6 12 0   4     0   5   31 37                       68 41 6 12 0   4     0   5   31 37                 68
933602 933602 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2016   grade_7 1 16 10 0   1     0   0   16 12                       28 1 16 10 0   1     0   0   16 12                 28
940507 940507 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes 1 KG 08 2016   grade_7 25 2 7 0   0     0   0   13 21                       34 25 2 7 0   0     0   0   13 21                 34
940475 940475 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_7 29 0 2 0   0     0   0   19 12                       31 29 0 2 0   0     0   0   19 12                 31
935508 935508 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_7 342 5 4 0   8     0   6   173 192                       365 342 5 4 0   8     0   6   173 192                 365
935523 935523 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_7 62 11 15 0   5     0   2   52 43                       95 62 11 15 0   5     0   2   52 43                 95
934561 934561 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2016   grade_7 243 5 21 0   5     0   8   146 136                       282 243 5 21 0   5     0   8   146 136                 282
940488 940488 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes 1 KG 08 2016   grade_7 4 4 62 0   0     0   1   32 39                       71 4 4 62 0   0     0   1   32 39                 71
940818 940818 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_7 88 7 0 0   2     0   0   55 42                       97 88 7 0 0   2     0   0   55 42                 97
935638 935638 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_7 78 0 1 1   4     0   1   42 43                       85 78 0 1 1   4     0   1   42 43                 85

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