enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_7", state = "MA" and year = 2018 sorted by multiracial_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_7 · 495 ✖
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
2228982 2228982 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_7 301 22 20 0   41     0   31   180 235                       415.0 301 22 20 0   41     0   31   180 235                 415
2234196 2234196 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford: Normandin Middle School   Regular School No Middle 06 08 2018   grade_7 198 28 151 2   9     0   29   216 201                       417.0 198 28 151 2   9     0   29   216 201                 417
2236939 2236939 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley: Wellesley Middle   Regular School No Middle 06 08 2018   grade_7 288 8 18 0   51     0   28   214 179                       393.0 288 8 18 0   51     0   28   214 179                 393
2229129 2229129 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable: Barnstable Intermediate School   Regular School No Middle 06 07 2018   grade_7 262 27 38 2   5     0   25   160 199                       359.0 262 27 38 2   5     0   25   160 199                 359
2237859 2237859 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   grade_7 199 65 173 1   23     0   25   238 248                       486.0 199 65 173 1   23     0   25   238 248                 486
2234356 2234356 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton: F A Day Middle   Regular School No Middle 06 08 2018   grade_7 197 19 21 2   41     0   24   175 129                       304.0 197 19 21 2   41     0   24   175 129                 304
2232877 2232877 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington: Wm Diamond Middle   Regular School No Middle 06 08 2018   grade_7 152 10 9 0   128     0   22   161 160                       321.0 152 10 9 0   128     0   22   161 160                 321
2234037 2234037 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Needham: Pollard Middle   Regular School No Middle 07 08 2018   grade_7 320 6 31 0   30     0   21   193 215                       408.0 320 6 31 0   30     0   21   193 215                 408
2234986 2234986 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield: Theodore Herberg Middle   Regular School No Middle 06 08 2018   grade_7 128 22 28 0   3     0   21   100 102                       202.0 128 22 28 0   3     0   21   100 102                 202
2234352 2234352 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton: Charles E Brown Middle   Regular School No Middle 06 08 2018   grade_7 156 7 13 0   44     0   20   117 123                       240.0 156 7 13 0   44     0   20   117 123                 240
2234982 2234982 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield: John T Reid Middle   Regular School No Middle 06 08 2018   grade_7 110 20 25 0   3     1   20   97 82                       179.0 110 20 25 0   3     1   20   97 82                 179
2229230 2229230 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont: Winthrop L Chenery Middle   Regular School No Middle 05 08 2018   grade_7 231 15 10 0   67     1   19   162 181                       343.0 231 15 10 0   67     1   19   162 181                 343
2230165 2230165 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_7 194 29 58 0   115     2   19   189 228                       417.0 194 29 58 0   115     2   19   189 228                 417
2231174 2231174 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth: Dartmouth Middle   Regular School No Middle 06 08 2018   grade_7 268 6 12 0   0     0   19   178 127                       305.0 268 6 12 0   0     0   19   178 127                 305
2234200 2234200 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford: Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_7 98 43 95 1   0     0   19   136 120                       256.0 98 43 95 1   0     0   19   136 120                 256
2236377 2236377 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury: Ephraim Curtis Middle   Regular School No Middle 06 08 2018   grade_7 238 8 11 0   27     0   19   142 161                       303.0 238 8 11 0   27     0   19   142 161                 303
2232006 2232006 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_7 169 5 14 1   4     2   18   123 90                       213.0 169 5 14 1   4     2   18   123 90                 213
2238596 2238596 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham: Amherst Regional Middle School   Regular School No Middle 07 08 2018   grade_7 105 16 33 0   22     0   18   105 89                       194.0 105 16 33 0   22     0   18   105 89                 194
2234360 2234360 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton: Oak Hill Middle   Regular School No Middle 06 08 2018   grade_7 143 8 12 0   53     0   17   108 125                       233.0 143 8 12 0   53     0   17   108 125                 233
2237863 2237863 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_7 78 69 204 0   22     0   17   196 194                       390.0 78 69 204 0   22     0   17   196 194                 390
2231622 2231622 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_7 157 26 61 0   7     0   16   136 131                       267.0 157 26 61 0   7     0   16   136 131                 267
2233306 2233306 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_7 67 37 264 1   49     0   16   216 218                       434.0 67 37 264 1   49     0   16   216 218                 434
2236863 2236863 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland: Wayland Middle School   Regular School No Middle 06 08 2018   grade_7 137 12 9 0   35     0   16   100 109                       209.0 137 12 9 0   35     0   16   100 109                 209
2237856 2237856 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_7 108 64 138 0   9     0   16   153 182                       335.0 108 64 138 0   9     0   16   153 182                 335
2237867 2237867 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_7 92 67 210 1   38     0   16   226 198                       424.0 92 67 210 1   38     0   16   226 198                 424
2230498 2230498 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton: South Middle School   Regular School No Middle 06 08 2018   grade_7 23 89 30 0   6     0   15   86 77                       163.0 23 89 30 0   6     0   15   86 77                 163
2231686 2231686 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth: Lawrence   Regular School No Middle 07 08 2018   grade_7 257 17 16 1   5     1   15   151 161                       312.0 257 17 16 1   5     1   15   151 161                 312
2231937 2231937 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   grade_7 97 1 28 0   5     0   15   70 76                       146.0 97 1 28 0   5     0   15   70 76                 146
2233992 2233992 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick: Wilson Middle   Regular School No Middle 05 08 2018   grade_7 168 10 16 0   14     0   15   112 111                       223.0 168 10 16 0   14     0   15   112 111                 223
2238053 2238053 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   grade_7 109 4 12 0   18     0   15   87 71                       158.0 109 4 12 0   18     0   15   87 71                 158
2233430 2233430 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield: Harold L Qualters Middle   Regular School No Middle 06 08 2018   grade_7 280 5 15 0   12     0   14   175 151                       326.0 280 5 15 0   12     0   14   175 151                 326
2233761 2233761 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen: Tenney Grammar School   Regular School No Elementary PK 08 2018   grade_7 80 0 72 0   6     0   14   94 78                       172.0 80 0 72 0   6     0   14   94 78                 172
2236330 2236330 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton: O'Donnell Middle School   Regular School No Middle 06 08 2018   grade_7 139 55 31 1   21     0   14   129 132                       261.0 139 55 31 1   21     0   14   129 132                 261
2236516 2236516 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton: Benjamin Friedman Middle   Regular School No Middle 05 07 2018   grade_7 172 25 28 2   1     0   14   126 116                       242.0 172 25 28 2   1     0   14   126 116                 242
2236795 2236795 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham: Wareham Middle   Regular School No Middle 05 08 2018   grade_7 139 15 10 2   0     0   14   92 88                       180.0 139 15 10 2   0     0   14   92 88                 180
2230774 2230774 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge: Putnam Avenue Upper School   Regular School No Middle 06 08 2018   grade_7 23 30 17 0   7     0   13   43 47                       90.0 23 30 17 0   7     0   13   43 47                 90
2230814 2230814 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton: Wm H Galvin Middle   Regular School No Middle 06 08 2018   grade_7 174 24 7 0   20     1   13   119 120                       239.0 174 24 7 0   20     1   13   119 120                 239
2232801 2232801 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster: Sky View Middle School   Regular School No Middle 06 08 2018   grade_7 137 23 93 0   16     0   13   141 141                       282.0 137 23 93 0   16     0   13   141 141                 282
2233302 2233302 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_7 41 40 269 0   35     0   13   195 203                       398.0 41 40 269 0   35     0   13   195 203                 398
2234448 2234448 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_7 150 4 50 1   5     0   13   116 107                       223.0 150 4 50 1   5     0   13   116 107                 223
2236975 2236975 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Westborough: Sarah W Gibbons Middle   Regular School No Middle 07 08 2018   grade_7 166 2 18 0   83     0   13   155 127                       282.0 166 2 18 0   83     0   13   155 127                 282
2237461 2237461 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_7 278 5 13 1   67     0   13   195 182                       377.0 278 5 13 1   67     0   13   195 182                 377
2239584 2239584 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua: Tantasqua Regional Jr High   Regular School No Middle 07 08 2018   grade_7 262 1 13 1   3     0   13   149 144                       293.0 262 1 13 1   3     0   13   149 144                 293
2229296 2229296 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly: Briscoe Middle   Regular School No Middle 06 08 2018   grade_7 269 10 32 0   6     0   12   170 159                       329.0 269 10 32 0   6     0   12   170 159                 329
2230140 2230140 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_7 99 63 67 0   58     1   12   120 179                       300.0 99 63 67 0   58     1   12   120 179                 300
2230660 2230660 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington: Marshall Simonds Middle   Regular School No Middle 06 08 2018   grade_7 194 14 19 0   33     0   12   143 129                       272.0 194 14 19 0   33     0   12   143 129                 272
2231092 2231092 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord: Concord Middle   Regular School No Middle 06 08 2018   grade_7 204 12 9 0   12     0   12   128 121                       249.0 204 12 9 0   12     0   12   128 121                 249
2231618 2231618 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River: Morton Middle   Regular School No Middle 06 08 2018   grade_7 120 16 44 2   13     0   12   112 95                       207.0 120 16 44 2   13     0   12   112 95                 207
2233723 2233723 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose: Melrose Middle   Regular School No Middle 06 08 2018   grade_7 196 17 8 2   12     0   12   123 124                       247.0 196 17 8 2   12     0   12   123 124                 247
2234192 2234192 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_7 121 38 111 1   2     1   12   140 146                       286.0 121 38 111 1   2     1   12   140 146                 286
2235664 2235664 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon: Sharon Middle   Regular School No Middle 06 08 2018   grade_7 149 12 17 0   79     1   12   126 144                       270.0 149 12 17 0   79     1   12   126 144                 270
2235700 2235700 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Shrewsbury: Oak Middle School   Regular School No Middle 07 08 2018   grade_7 295 15 39 1   131     0   12   237 256                       493.0 295 15 39 1   131     0   12   237 256                 493
2236512 2236512 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 Taunton: John F Parker Middle   Regular School No Middle 05 07 2018   grade_7 78 40 15 1   1     0   12   71 76                       147.0 78 40 15 1   1     0   12   71 76                 147
2237291 2237291 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_7 327 25 32 2   20     1   12   225 194                       419.0 327 25 32 2   20     1   12   225 194                 419
2229043 2229043 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_7 109 2 10 0   5     0   11   69 68                       137.0 109 2 10 0   5     0   11   69 68                 137
2229048 2229048 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_7 82 10 25 1   3     0   11   70 62                       132.0 82 10 25 1   3     0   11   70 62                 132
2230502 2230502 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton: West Middle School   Regular School No Middle 06 08 2018   grade_7 48 123 36 0   8     0   11   106 120                       226.0 48 123 36 0   8     0   11   106 120                 226
2230557 2230557 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_7 43 7 10 0   7     0   11   41 37                       78.0 43 7 10 0   7     0   11   41 37                 78
2234348 2234348 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Newton: Bigelow Middle   Regular School No Middle 06 08 2018   grade_7 105 7 21 0   27     0   11   83 88                       171.0 105 7 21 0   27     0   11   83 88                 171
2234539 2234539 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough: North Attleborough Middle   Regular School No Middle 06 08 2018   grade_7 284 10 14 1   25     1   11   183 163                       346.0 284 10 14 1   25     1   11   183 163                 346
2237273 2237273 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 Westwood: E W Thurston Middle   Regular School No Middle 06 08 2018   grade_7 208 13 10 0   19     0   11   124 137                       261.0 208 13 10 0   19     0   11   124 137                 261
2238179 2238179 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District): Foxborough Regional Charter School   Regular School Yes Other KG 12 2018   grade_7 54 52 4 1   6     0   11   63 65                       128.0 54 52 4 1   6     0   11   63 65                 128
2238571 2238571 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough: Raymond J Grey Junior High   Regular School No Middle 07 08 2018   grade_7 273 14 15 0   173     0   11   257 229                       486.0 273 14 15 0   173     0   11   257 229                 486
2238831 2238831 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_7 156 22 18 5   5     0   11   115 102                       217.0 156 22 18 5   5     0   11   115 102                 217
2230439 2230439 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_7 14 63 12 0   0     1   10   42 58                       100.0 14 63 12 0   0     1   10   42 58                 100
2231005 2231005 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_7 139 9 108 0   2     0   10   144 124                       268.0 139 9 108 0   2     0   10   144 124                 268
2231710 2231710 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg: Memorial Intermediate   Regular School No Middle 05 08 2018   grade_7 54 12 95 0   12     0   10   93 90                       183.0 54 12 95 0   12     0   10   93 90                 183
2231854 2231854 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   grade_7 59 20 63 0   5     1   10   80 78                       158.0 59 20 63 0   5     1   10   80 78                 158
2232303 2232303 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham: Hingham Middle School   Regular School No Middle 06 08 2018   grade_7 322 2 8 0   16     0   10   189 169                       358.0 322 2 8 0   16     0   10   189 169                 358
2232873 2232873 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington: Jonas Clarke Middle   Regular School No Middle 06 08 2018   grade_7 136 13 11 0   139     0   10   171 138                       309.0 136 13 11 0   139     0   10   171 138                 309
2233310 2233310 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_7 66 20 79 2   22     0   10   103 96                       199.0 66 20 79 2   22     0   10   103 96                 199
2233796 2233796 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough: John T. Nichols Middle   Regular School No Middle 06 08 2018   grade_7 215 6 12 4   6     0   10   114 139                       253.0 215 6 12 4   6     0   10   114 139                 253
2234493 2234493 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover: North Andover Middle   Regular School No Middle 06 08 2018   grade_7 280 8 33 1   21     1   10   186 168                       354.0 280 8 33 1   21     1   10   186 168                 354
2234576 2234576 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_7 156 4 16 2   15     2   10   112 93                       205.0 156 4 16 2   15     2   10   112 93                 205
2234589 2234589 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge: Northbridge Middle   Regular School No Middle 05 08 2018   grade_7 164 1 10 0   0     0   10   103 82                       185.0 164 1 10 0   0     0   10   103 82                 185
2235243 2235243 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph: Randolph Community Middle   Regular School No Middle 06 08 2018   grade_7 28 91 29 1   32     0   10   95 96                       191.0 28 91 29 1   32     0   10   95 96                 191
2237392 2237392 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington: Wilmington Middle School   Regular School No Middle 06 08 2018   grade_7 220 5 11 0   10     0   10   131 125                       256.0 220 5 11 0   10     0   10   131 125                 256
2239114 2239114 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip: King Philip Middle School   Regular School No Middle 07 08 2018   grade_7 314 8 10 0   4     0   10   177 169                       346.0 314 8 10 0   4     0   10   177 169                 346
2228838 2228838 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_7 144 1 12 0   1     0   9   86 81                       167.0 144 1 12 0   1     0   9   86 81                 167
2230510 2230510 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_7 56 88 71 1   8     0   9   116 117                       233.0 56 88 71 1   8     0   9   116 117                 233
2231009 2231009 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_7 123 16 98 1   3     0   9   145 105                       250.0 123 16 98 1   3     0   9   145 105                 250
2231141 2231141 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers: Holten Richmond Middle School   Regular School No Middle 06 08 2018   grade_7 240 5 20 0   7     0   9   136 145                       281.0 240 5 20 0   7     0   9   136 145                 281
2231301 2231301 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury: Duxbury Middle   Regular School No Middle 06 08 2018   grade_7 234 0 5 0   2     0   9   141 109                       250.0 234 0 5 0   2     0   9   141 109                 250
2232320 2232320 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_7 50 20 15 0   4     0   9   47 51                       98.0 50 20 15 0   4     0   9   47 51                 98
2232546 2232546 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich: Ipswich Middle School   Regular School No Middle 06 08 2018   grade_7 115 1 8 0   2     0   9   71 64                       135.0 115 1 8 0   2     0   9   71 64                 135
2233829 2233829 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford: Stacy Middle   Regular School No Middle 06 08 2018   grade_7 223 10 97 4   12     0   9   178 177                       355.0 223 10 97 4   12     0   9   178 177                 355
2236833 2236833 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown: Watertown Middle   Regular School No Middle 06 08 2018   grade_7 133 8 22 2   12     1   9   89 98                       187.0 133 8 22 2   12     1   9   89 98                 187
2236880 2236880 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster: Webster Middle School   Regular School No Middle 05 08 2018   grade_7 87 12 42 0   2     0   9   55 97                       152.0 87 12 42 0   2     0   9   55 97                 152
2238748 2238748 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham: Raynham Middle School   Regular School No Middle 05 08 2018   grade_7 154 6 3 0   3     1   9   91 85                       176.0 154 6 3 0   3     1   9   91 85                 176
2238751 2238751 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham: Bridgewater Middle School   Regular School No Middle 07 08 2018   grade_7 232 9 0 1   4     0   9   133 122                       255.0 232 9 0 1   4     0   9   133 122                 255
2238869 2238869 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn: Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2018   grade_7 139 7 5 1   17     0   9   83 95                       178.0 139 7 5 1   17     0   9   83 95                 178
2239712 2239712 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett: Central Tree Middle   Regular School No Middle 06 08 2018   grade_7 116 0 3 0   4     0   9   73 59                       132.0 116 0 3 0   4     0   9   73 59                 132
2228814 2228814 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam: Agawam Junior High   Regular School No Middle 07 08 2018   grade_7 257 7 26 0   13     0   8   164 147                       311.0 257 7 26 0   13     0   8   164 147                 311
2230547 2230547 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_7 38 10 4 0   15     0   8   37 38                       75.0 38 10 4 0   15     0   8   37 38                 75
2230599 2230599 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   grade_7 24 6 9 0   7     0   8   23 31                       54.0 24 6 9 0   7     0   8   23 31                 54
2231614 2231614 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River: Talbot Innovation School   Regular School No Middle 06 08 2018   grade_7 87 13 55 0   10     0   8   96 77                       173.0 87 13 55 0   10     0   8   96 77                 173
2231722 2231722 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_7 42 12 88 0   8     0   8   88 70                       158.0 42 12 88 0   8     0   8   88 70                 158
2232096 2232096 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield: Greenfield Middle   Regular School No Middle 05 07 2018   grade_7 86 1 26 0   1     0   8   64 58                       122.0 86 1 26 0   1     0   8   64 58                 122
2233090 2233090 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell: James S Daley Middle School   Regular School No Middle 05 08 2018   grade_7 46 8 35 0   76     0   8   93 80                       173.0 46 8 35 0   76     0   8   93 80                 173
2233498 2233498 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_7 123 13 173 0   8     0   8   176 149                       325.0 123 13 173 0   8     0   8   176 149                 325

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