enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by native_american descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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
1126736 1126736 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_7 105 4 4 7   3     1   5   71 58                       129 105 4 4 7   3     1   5   71 58                 129
1132000 1132000 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2017   grade_7 158 26 26 6   3     0   10   117 112                       229 158 26 26 6   3     0   10   117 112                 229
1126482 1126482 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2017   grade_7 53 41 275 5   35     0   14   223 200                       423 53 41 275 5   35     0   14   223 200                 423
1126486 1126486 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_7 65 43 261 5   57     0   16   226 221                       447 65 43 261 5   57     0   16   226 221                 447
1124859 1124859 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_7 229 14 17 4   7     0   19   157 133                       290 229 14 17 4   7     0   19   157 133                 290
1129746 1129746 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_7 23 0 9 3   1     0   3   19 20                       39 23 0 9 3   1     0   3   19 20                 39
1129980 1129980 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_7 148 15 9 3   1     0   15   92 99                       191 148 15 9 3   1     0   15   92 99                 191
1131112 1131112 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_7 14 10 146 3   1     0   0   85 89                       174 14 10 146 3   1     0   0   85 89                 174
1132832 1132832 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_7 38 1 1 3   1     0   2   33 13                       46 38 1 1 3   1     0   2   33 13                 46
1122323 1122323 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2017   grade_7 302 34 36 2   8     0   15   200 197                       397 302 34 36 2   8     0   15   200 197                 397
1123210 1123210 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_7 1 62 19 2   2     0   0   49 37                       86 1 62 19 2   2     0   0   49 37                 86
1123476 1123476 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_7 170 3 2 2   6     0   0   86 97                       183 170 3 2 2   6     0   0   86 97                 183
1123621 1123621 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_7 14 70 12 2   0     0   2   52 48                       100 14 70 12 2   0     0   2   52 48                 100
1123846 1123846 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2017   grade_7 198 18 12 2   31     0   12   147 126                       273 198 18 12 2   31     0   12   147 126                 273
1123963 1123963 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2017   grade_7 38 29 6 2   12     0   7   54 40                       94 38 29 6 2   12     0   7   54 40                 94
1124245 1124245 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_7 114 4 3 2   3     0   2   64 64                       128 114 4 3 2   3     0   2   64 64                 128
1124681 1124681 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_7 15 16 70 2   1     0   0   52 52                       104 15 16 70 2   1     0   0   52 52                 104
1124803 1124803 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_7 151 15 51 2   13     0   17   112 137                       249 151 15 51 2   13     0   17   112 137                 249
1124950 1124950 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_7 185 8 12 2   4     0   3   113 101                       214 185 8 12 2   4     0   3   113 101                 214
1126339 1126339 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_7 119 3 15 2   2     3   1   76 69                       145 119 3 15 2   2     3   1   76 69                 145
1126490 1126490 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2017   grade_7 85 12 74 2   16     0   13   101 101                       202 85 12 74 2   16     0   13   101 101                 202
1127085 1127085 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2017   grade_7 208 36 15 2   15     2   11   145 144                       289 208 36 15 2   15     2   11   145 144                 289
1127219 1127219 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2017   grade_7 352 10 15 2   41     0   25   211 234                       445 352 10 15 2   41     0   25   211 234                 445
1127373 1127373 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_7 124 43 104 2   4     0   19   165 131                       296 124 43 104 2   4     0   19   165 131                 296
1127526 1127526 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_7 120 10 15 2   26     0   11   90 94                       184 120 10 15 2   26     0   11   90 94                 184
1127717 1127717 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2017   grade_7 310 6 19 2   23     0   12   193 179                       372 310 6 19 2   23     0   12   193 179                 372
1128496 1128496 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2017   grade_7 82 9 74 2   11     0   10   104 84                       188 82 9 74 2   11     0   10   104 84                 188
1128700 1128700 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   grade_7 218 4 1 2   3     0   1   122 107                       229 218 4 1 2   3     0   1   122 107                 229
1129699 1129699 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2017   grade_7 221 22 31 2   3     0   7   142 144                       286 221 22 31 2   3     0   7   142 144                 286
1130298 1130298 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_7 144 2 1 2   63     1   1   116 98                       214 144 2 1 2   63     1   1   116 98                 214
1130335 1130335 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2017   grade_7 110 13 9 2   28     0   6   76 92                       168 110 13 9 2   28     0   6   76 92                 168
1130719 1130719 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_7 141 13 18 2   13     0   3   93 97                       190 141 13 18 2   13     0   3   93 97                 190
1130723 1130723 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_7 146 10 12 2   10     1   5   93 93                       186 146 10 12 2   10     1   5   93 93                 186
1131166 1131166 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   grade_7 73 10 25 2   5     1   9   63 62                       125 73 10 25 2   5     1   9   63 62                 125
1131207 1131207 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_7 7 75 49 2   1     0   5   80 59                       139 7 75 49 2   1     0   5   80 59                 139
1131323 1131323 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Elementary PK 08 2017   grade_7 8 23 4 2   1     0   0   23 15                       38 8 23 4 2   1     0   0   23 15                 38
1132110 1132110 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2017   grade_7 213 2 9 2   2     1   6   112 123                       235 213 2 9 2   2     1   6   112 123                 235
1132250 1132250 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No Middle 05 08 2017   grade_7 48 4 3 2   2     0   0   28 31                       59 48 4 3 2   2     0   0   28 31                 59
1132368 1132368 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_7 108 3 13 2   2     1   6   67 68                       135 108 3 13 2   2     1   6   67 68                 135
1133144 1133144 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_7 0 45 26 2   0     0   0   28 45                       73 0 45 26 2   0     0   0   28 45                 73
1122108 1122108 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_7 132 1 7 1   23     0   4   100 68                       168 132 1 7 1   23     0   4   100 68                 168
1122539 1122539 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2017   grade_7 186 9 7 1   10     0   2   106 109                       215 186 9 7 1   10     0   2   106 109                 215
1122731 1122731 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_7 7 7 9 1   1     0   1   12 14                       26 7 7 9 1   1     0   1   12 14                 26
1122972 1122972 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_7 10 26 14 1   36     1   1   41 48                       89 10 26 14 1   36     1   1   41 48                 89
1123002 1123002 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_7 0 43 44 1   0     0   4   42 50                       92 0 43 44 1   0     0   4   42 50                 92
1123200 1123200 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_7 0 18 24 1   0     0   4   25 22                       47 0 18 24 1   0     0   4   25 22                 47
1123263 1123263 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2017   grade_7 5 44 49 1   1     0   3   49 54                       103 5 44 49 1   1     0   3   49 54                 103
1123368 1123368 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_7 0 12 17 1   40     0   1   38 33                       71 0 12 17 1   40     0   1   38 33                 71
1123375 1123375 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_7 33 47 49 1   30     0   2   70 92                       162 33 47 49 1   30     0   2   70 92                 162
1123546 1123546 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2017   grade_7 186 10 8 1   34     0   6   125 120                       245 186 10 8 1   34     0   6   125 120                 245
1123688 1123688 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2017   grade_7 49 92 27 1   8     1   13   102 89                       191 49 92 27 1   8     1   13   102 89                 191
1123955 1123955 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2017   grade_7 23 30 20 1   8     1   8   44 47                       91 23 30 20 1   8     1   8   44 47                 91
1123959 1123959 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2017   grade_7 23 34 18 1   11     1   7   50 45                       95 23 34 18 1   11     1   7   50 45                 95
1124101 1124101 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_7 6 7 112 1   3     0   2   70 61                       131 6 7 112 1   3     0   2   70 61                 131
1124190 1124190 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_7 170 7 90 1   5     0   6   142 137                       279 170 7 90 1   5     0   6   142 137                 279
1124276 1124276 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_7 198 11 11 1   14     0   14   103 146                       249 198 11 11 1   14     0   14   103 146                 249
1124325 1124325 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2017   grade_7 229 6 16 1   7     0   7   140 126                       266 229 6 16 1   7     0   7   140 126                 266
1124484 1124484 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2017   grade_7 224 0 5 1   4     0   9   127 116                       243 224 0 5 1   4     0   9   127 116                 243
1124502 1124502 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2017   grade_7 188 2 3 1   0     0   2   89 107                       196 188 2 3 1   0     0   2   89 107                 196
1124588 1124588 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2017   grade_7 239 17 13 1   11     0   13   147 147                       294 239 17 13 1   11     0   13   147 147                 294
1124652 1124652 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_7 29 20 40 1   8     0   1   56 43                       99 29 20 40 1   8     0   1   56 43                 99
1124811 1124811 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No Middle 06 08 2017   grade_7 3 0 2 1   0     0   0   4 2                       6 3 0 2 1   0     0   0   4 2                 6
1125021 1125021 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_7 117 12 36 1   6     0   6   93 85                       178 117 12 36 1   6     0   6   93 85                 178
1125108 1125108 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   grade_7 123 6 30 1   3     0   18   96 85                       181 123 6 30 1   3     0   18   96 85                 181
1125300 1125300 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2017   grade_7 34 2 3 1   0     1   1   24 18                       42 34 2 3 1   0     1   1   24 18                 42
1125531 1125531 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2017   grade_7 195 1 7 1   18     0   4   100 126                       226 195 1 7 1   18     0   4   100 126                 226
1125657 1125657 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2017   grade_7 229 2 4 1   31     0   8   130 145                       275 229 2 4 1   31     0   8   130 145                 275
1125985 1125985 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2017   grade_7 168 24 84 1   19     0   10   160 146                       306 168 24 84 1   19     0   10   160 146                 306
1126125 1126125 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2017   grade_7 92 3 5 1   7     0   4   58 54                       112 92 3 5 1   7     0   4   58 54                 112
1126558 1126558 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   grade_7 18 24 28 1   22     0   1   37 57                       94 18 24 28 1   22     0   1   37 57                 94
1126590 1126590 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2017   grade_7 27 38 50 1   25     0   5   78 68                       146 27 38 50 1   25     0   5   78 68                 146
1126768 1126768 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Elementary 04 07 2017   grade_7 93 4 13 1   1     0   2   54 60                       114 93 4 13 1   1     0   2   54 60                 114
1126860 1126860 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2017   grade_7 172 3 7 1   8     0   4   100 95                       195 172 3 7 1   8     0   4   100 95                 195
1126979 1126979 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_7 233 3 12 1   2     0   6   126 131                       257 233 3 12 1   2     0   6   126 131                 257
1127012 1127012 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_7 204 9 70 1   5     0   10   161 138                       299 204 9 70 1   5     0   10   161 138                 299
1127174 1127174 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_7 180 9 12 1   9     0   14   112 113                       225 180 9 12 1   9     0   14   112 113                 225
1127381 1127381 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_7 103 43 109 1   2     1   12   141 130                       271 103 43 109 1   2     1   12   141 130                 271
1127626 1127626 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_7 167 4 28 1   6     0   14   110 110                       220 167 4 28 1   6     0   14   110 110                 220
1127755 1127755 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2017   grade_7 168 2 5 1   22     1   7   109 97                       206 168 2 5 1   22     1   7   109 97                 206
1127956 1127956 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2017   grade_7 111 4 11 1   1     2   7   60 77                       137 111 4 11 1   1     2   7   60 77                 137
1128160 1128160 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   grade_7 133 20 24 1   0     0   16   90 104                       194 133 20 24 1   0     0   16   90 104                 194
1128739 1128739 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2017   grade_7 179 12 23 1   6     0   1   109 113                       222 179 12 23 1   6     0   1   109 113                 222
1128843 1128843 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2017   grade_7 187 10 14 1   80     0   14   160 146                       306 187 10 14 1   80     0   14   160 146                 306
1128879 1128879 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2017   grade_7 307 6 50 1   131     0   16   258 253                       511 307 6 50 1   131     0   16   258 253                 511
1129061 1129061 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2017   grade_7 57 1 98 1   0     0   4   83 78                       161 57 1 98 1   0     0   4   83 78                 161
1129382 1129382 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2017   grade_7 15 23 62 1   1     0   2   50 54                       104 15 23 62 1   1     0   2   50 54                 104
1129882 1129882 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2017   grade_7 132 4 9 1   7     0   3   76 80                       156 132 4 9 1   7     0   3   76 80                 156
1129963 1129963 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2017   grade_7 80 2 6 1   0     0   3   57 35                       92 80 2 6 1   0     0   3   57 35                 92
1130065 1130065 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_7 96 10 31 1   3     2   10   66 87                       153 96 10 31 1   3     2   10   66 87                 153
1130177 1130177 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No Other 06 12 2017   grade_7 79 1 9 1   1     0   4   45 50                       95 79 1 9 1   1     0   4   45 50                 95
1130302 1130302 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_7 126 4 3 1   45     0   7   88 98                       186 126 4 3 1   45     0   7   88 98                 186
1130397 1130397 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield Middle   Regular School No Middle 06 08 2017   grade_7 195 10 56 1   17     0   7   149 137                       286 195 10 56 1   17     0   7   149 137                 286
1130564 1130564 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2017   grade_7 267 5 16 1   11     0   8   161 147                       308 267 5 16 1   11     0   8   161 147                 308
1130583 1130583 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_7 74 5 9 1   3     0   2   47 47                       94 74 5 9 1   3     0   2   47 47                 94
1130633 1130633 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2017   grade_7 264 0 14 1   66     1   19   178 187                       365 264 0 14 1   66     1   19   178 187                 365
1131042 1131042 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_7 103 57 181 1   49     0   22   209 204                       413 103 57 181 1   49     0   22   209 204                 413
1131416 1131416 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2017   grade_7 20 1 8 1   0     0   1   10 21                       31 20 1 8 1   0     0   1   10 21                 31
1131474 1131474 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_7 2 35 51 1   1     0   2   45 47                       92 2 35 51 1   1     0   2   45 47                 92
1131524 1131524 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2017   grade_7 8 77 64 1   8     2   8   93 75                       168 8 77 64 1   8     2   8   93 75                 168
1131815 1131815 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_7 96 1 6 1   0     0   3   53 54                       107 96 1 6 1   0     0   3   53 54                 107

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