enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by native_american_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 499 ✖

grade ✖

  • grade_7 · 499 ✖
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
2043866 2043866 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_7 89 4 2 6   3     0   7   66 45                       111.0 89 4 2 6   3     0   7   66 45                 111
2044093 2044093 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_7 214 8 89 6   6     0   10   183 150                       333.0 214 8 89 6   6     0   10   183 150                 333
2044067 2044067 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_7 227 6 8 5   6     0   11   137 126                       263.0 227 6 8 5   6     0   11   137 126                 263
2048315 2048315 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2019   grade_7 138 17 35 5   5     0   15   101 114                       215.0 138 17 35 5   5     0   15   101 114                 215
2048014 2048014 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2019   grade_7 28 12 14 3   2     0   0   29 30                       59.0 28 12 14 3   2     0   0   29 30                 59
2040890 2040890 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_7 3 62 23 2   0     0   3   47 46                       93.0 3 62 23 2   0     0   3   47 46                 93
2041124 2041124 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_7 158 1 10 2   1     0   5   90 87                       177.0 158 1 10 2   1     0   5   90 87                 177
2042124 2042124 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_7 41 10 50 2   7     1   2   57 56                       113.0 41 10 50 2   7     1   2   57 56                 113
2042307 2042307 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2019   grade_7 212 18 17 2   3     0   14   131 135                       266.0 212 18 17 2   3     0   14   131 135                 266
2042602 2042602 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_7 189 4 16 2   30     2   6   128 121                       249.0 189 4 16 2   30     2   6   128 121                 249
2043533 2043533 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2019   grade_7 124 2 9 2   1     0   3   74 67                       141.0 124 2 9 2   1     0   3   74 67                 141
2043782 2043782 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2019   grade_7 189 10 20 2   2     0   7   117 113                       230.0 189 10 20 2   2     0   7   117 113                 230
2043906 2043906 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2019   grade_7 169 2 6 2   8     0   8   103 92                       195.0 169 2 6 2   8     0   8   103 92                 195
2044656 2044656 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2019   grade_7 284 13 35 2   26     0   6   182 184                       366.0 284 13 35 2   26     0   6   182 184                 366
2044866 2044866 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2019   grade_7 32 3 8 2   0     0   2   18 29                       47.0 32 3 8 2   0     0   2   18 29                 47
2045244 2045244 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2019   grade_7 84 11 14 2   19     0   6   81 55                       136.0 84 11 14 2   19     0   6   81 55                 136
2046370 2046370 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2019   grade_7 82 48 29 2   2     0   14   82 95                       177.0 82 48 29 2   2     0   14   82 95                 177
2046411 2046411 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_7 16 2 8 2   0     0   8   17 19                       36.0 16 2 8 2   0     0   8   17 19                 36
2046482 2046482 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2019   grade_7 204 10 21 2   8     1   7   127 126                       253.0 204 10 21 2   8     1   7   127 126                 253
2046788 2046788 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_7 80 4 5 2   1     0   5   46 51                       97.0 80 4 5 2   1     0   5   46 51                 97
2046990 2046990 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 06 08 2019   grade_7 325 37 48 2   24     1   16   222 231                       453.0 325 37 48 2   24     1   16   222 231                 453
2047065 2047065 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_7 237 4 10 2   9     0   12   146 128                       274.0 237 4 10 2   9     0   12   146 128                 274
2047122 2047122 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_7 281 3 14 2   60     0   17   176 200                       377.0 281 3 14 2   60     0   17   176 200                 377
2048095 2048095 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2019   grade_7 231 10 25 2   149     0   18   239 196                       435.0 231 10 25 2   149     0   18   239 196                 435
2048182 2048182 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_7 92 3 13 2   8     2   5   66 59                       125.0 92 3 13 2   8     2   5   66 59                 125
2049134 2049134 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2019   grade_7 149 9 10 2   1     0   6   98 79                       177.0 149 9 10 2   1     0   6   98 79                 177
2040015 2040015 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2019   grade_7 137 4 31 1   29     0   6   103 105                       208.0 137 4 31 1   29     0   6   103 105                 208
2040053 2040053 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_7 98 7 27 1   9     0   7   74 75                       149.0 98 7 27 1   9     0   7   74 75                 149
2040094 2040094 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_7 29 17 4 1   3     0   3   32 25                       57.0 29 17 4 1   3     0   3   32 25                 57
2040169 2040169 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2019   grade_7 155 3 12 1   8     0   6   101 84                       185.0 155 3 12 1   8     0   6   101 84                 185
2040203 2040203 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_7 245 14 24 1   52     0   24   174 186                       360.0 245 14 24 1   52     0   24   174 186                 360
2040298 2040298 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_7 187 5 18 1   19     0   1   124 107                       231.0 187 5 18 1   19     0   1   124 107                 231
2040705 2040705 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_7 2 41 38 1   2     0   2   43 43                       86.0 2 41 38 1   2     0   2   43 43                 86
2040938 2040938 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2019   grade_7 6 36 44 1   1     0   3   46 45                       91.0 6 36 44 1   1     0   3   46 45                 91
2041038 2041038 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2019   grade_7 22 54 49 1   27     1   6   71 89                       160.0 22 54 49 1   27     1   6   71 89                 160
2041297 2041297 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 07 08 2019   grade_7 14 99 29 1   4     0   8   96 59                       155.0 14 99 29 1   4     0   8   96 59                 155
2041303 2041303 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2019   grade_7 46 127 35 1   6     1   5   113 108                       221.0 46 127 35 1   6     1   5   113 108                 221
2041306 2041306 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2019   grade_7 55 76 22 1   5     0   7   88 78                       166.0 55 76 22 1   5     0   7   88 78                 166
2041442 2041442 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2019   grade_7 180 11 15 1   40     0   4   121 130                       251.0 180 11 15 1   40     0   4   121 130                 251
2041665 2041665 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_7 11 3 124 1   1     0   0   73 67                       140.0 11 3 124 1   1     0   0   73 67                 140
2041812 2041812 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2019   grade_7 173 11 16 1   16     0   17   111 123                       234.0 173 11 16 1   16     0   17   111 123                 234
2041972 2041972 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2019   grade_7 211 15 26 1   26     0   3   131 151                       282.0 211 15 26 1   26     0   3   131 151                 282
2042002 2042002 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2019   grade_7 165 3 5 1   0     0   5   101 78                       179.0 165 3 5 1   0     0   5   101 78                 179
2042108 2042108 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_7 10 5 35 1   4     0   2   31 26                       57.0 10 5 35 1   4     0   2   31 26                 57
2042133 2042133 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_7 31 21 57 1   13     0   1   61 63                       124.0 31 21 57 1   13     0   1   61 63                 124
2042149 2042149 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_7 22 22 54 1   6     0   6   50 61                       111.0 22 22 54 1   6     0   6   50 61                 111
2042788 2042788 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_7 75 6 35 1   3     0   1   64 57                       121.0 75 6 35 1   3     0   1   64 57                 121
2042793 2042793 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_7 109 10 95 1   3     0   1   124 95                       219.0 109 10 95 1   3     0   1   124 95                 219
2042864 2042864 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2019   grade_7 191 3 16 1   16     0   3   111 119                       230.0 191 3 16 1   16     0   3   111 119                 230
2042953 2042953 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_7 77 2 4 1   2     0   1   49 38                       87.0 77 2 4 1   2     0   1   49 38                 87
2042967 2042967 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2019   grade_7 178 4 10 1   31     0   10   115 119                       234.0 178 4 10 1   31     0   10   115 119                 234
2043030 2043030 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2019   grade_7 128 2 9 1   3     0   3   71 75                       146.0 128 2 9 1   3     0   3   71 75                 146
2043309 2043309 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2019   grade_7 44 3 5 1   4     0   5   33 29                       62.0 44 3 5 1   4     0   5   33 29                 62
2043658 2043658 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2019   grade_7 67 9 111 1   19     0   11   115 103                       218.0 67 9 111 1   19     0   11   115 103                 218
2043735 2043735 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_7 42 17 13 1   19     0   4   51 44                       96.0 42 17 13 1   19     0   4   51 44                 96
2044402 2044402 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_7 131 49 110 1   5     0   16   162 150                       312.0 131 49 110 1   5     0   16   162 150                 312
2044405 2044405 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2019   grade_7 231 29 142 1   5     0   17   226 199                       425.0 231 29 142 1   5     0   17   226 199                 425
2044408 2044408 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_7 109 49 104 1   0     1   9   139 134                       273.0 109 49 104 1   0     1   9   139 134                 273
2044544 2044544 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2019   grade_7 112 9 15 1   43     1   12   109 84                       193.0 112 9 15 1   43     1   12   109 84                 193
2044621 2044621 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_7 134 4 35 1   6     0   11   106 85                       191.0 134 4 35 1   6     0   11   106 85                 191
2044776 2044776 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No Middle 06 08 2019   grade_7 139 2 5 1   8     0   4   73 86                       159.0 139 2 5 1   8     0   4   73 86                 159
2044795 2044795 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2019   grade_7 158 3 11 1   5     0   12   87 103                       190.0 158 3 11 1   5     0   12   87 103                 190
2045072 2045072 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2019   grade_7 114 24 20 1   2     0   18   88 91                       179.0 114 24 20 1   2     0   18   88 91                 179
2045144 2045144 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2019   grade_7 230 0 4 1   1     0   10   132 114                       246.0 230 0 4 1   1     0   10   132 114                 246
2045147 2045147 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2019   grade_7 299 5 27 1   8     0   18   187 170                       358.0 299 5 27 1   8     0   18   187 170                 358
2045334 2045334 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No Middle 06 08 2019   grade_7 151 9 7 1   17     0   3   95 93                       188.0 151 9 7 1   17     0   3   95 93                 188
2045354 2045354 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_7 56 11 115 1   10     0   5   103 95                       198.0 56 11 115 1   10     0   5   103 95                 198
2045383 2045383 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2019   grade_7 58 5 103 1   9     0   4   86 94                       180.0 58 5 103 1   9     0   4   86 94                 180
2045554 2045554 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2019   grade_7 130 10 54 1   12     0   1   106 102                       208.0 130 10 54 1   12     0   1   106 102                 208
2045641 2045641 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No Middle 06 08 2019   grade_7 170 12 14 1   82     0   12   160 131                       291.0 170 12 14 1   82     0   12   160 131                 291
2045670 2045670 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No Middle 07 08 2019   grade_7 297 20 34 1   144     0   15   270 241                       511.0 297 20 34 1   144     0   15   270 241                 511
2045823 2045823 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2019   grade_7 71 3 84 1   4     0   1   88 76                       164.0 71 3 84 1   4     0   1   88 76                 164
2046104 2046104 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2019   grade_7 17 20 72 1   2     0   1   51 62                       113.0 17 20 72 1   2     0   1   51 62                 113
2046107 2046107 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_7 8 9 38 1   0     0   0   22 34                       56.0 8 9 38 1   0     0   0   22 34                 56
2046217 2046217 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_7 166 71 34 1   25     2   13   184 128                       312.0 166 71 34 1   25     2   13   184 128                 312
2046362 2046362 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2019   grade_7 155 35 20 1   2     0   15   132 96                       228.0 155 35 20 1   2     0   15   132 96                 228
2046436 2046436 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2019   grade_7 95 3 5 1   9     0   3   58 58                       116.0 95 3 5 1   9     0   3   58 58                 116
2046450 2046450 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2019   grade_7 127 1 6 1   4     0   3   78 64                       142.0 127 1 6 1   4     0   3   78 64                 142
2046522 2046522 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2019   grade_7 137 8 13 1   9     0   1   91 78                       169.0 137 8 13 1   9     0   1   91 78                 169
2046607 2046607 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2019   grade_7 110 13 22 1   2     1   18   90 77                       167.0 110 13 22 1   2     1   18   90 77                 167
2046665 2046665 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland Middle School   Regular School No Middle 06 08 2019   grade_7 148 14 7 1   34     0   13   110 107                       217.0 148 14 7 1   34     0   13   110 107                 217
2046730 2046730 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2019   grade_7 272 13 32 1   46     0   15   184 195                       379.0 272 13 32 1   46     0   15   184 195                 379
2047187 2047187 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_7 109 9 16 1   9     0   6   71 79                       150.0 109 9 16 1   9     0   6   71 79                 150
2047457 2047457 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2019   grade_7 123 68 149 1   12     0   9   186 176                       362.0 123 68 149 1   12     0   9   186 176                 362
2047459 2047459 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2019   grade_7 189 70 160 1   33     0   21   247 227                       474.0 189 70 160 1   33     0   21   247 227                 474
2047461 2047461 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2019   grade_7 64 75 189 1   38     0   17   196 188                       384.0 64 75 189 1   38     0   17   196 188                 384
2047527 2047527 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_7 20 6 142 1   3     1   2   93 82                       175.0 20 6 142 1   3     1   2   93 82                 175
2047726 2047726 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_7 9 42 15 1   2     0   3   38 34                       72.0 9 42 15 1   2     0   3   38 34                 72
2047849 2047849 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_7 17 1 1 1   0     0   0   8 12                       20.0 17 1 1 1   0     0   0   8 12                 20
2047884 2047884 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_7 44 6 18 1   3     0   2   43 31                       74.0 44 6 18 1   3     0   2   43 31                 74
2047924 2047924 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2019   grade_7 78 2 2 1   2     0   7   48 44                       92.0 78 2 2 1   2     0   7   48 44                 92
2047932 2047932 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_7 1 134 95 1   4     1   2   134 104                       238.0 1 134 95 1   4     1   2   134 104                 238
2048022 2048022 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2019   grade_7 35 12 40 1   0     0   2   45 45                       90.0 35 12 40 1   0     0   2   45 45                 90
2048110 2048110 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_7 87 2 0 1   0     0   1   44 47                       91.0 87 2 0 1   0     0   1   44 47                 91
2048117 2048117 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2019   grade_7 126 22 46 1   13     0   15   114 109                       223.0 126 22 46 1   13     0   15   114 109                 223
2048138 2048138 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2019   grade_7 167 2 13 1   1     0   2   94 92                       186.0 167 2 13 1   1     0   2   94 92                 186
2048196 2048196 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2019   grade_7 61 2 6 1   5     0   6   43 38                       81.0 61 2 6 1   5     0   6   43 38                 81
2048408 2048408 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2019   grade_7 252 2 5 1   0     0   4   129 135                       264.0 252 2 5 1   0     0   4   129 135                 264
2048456 2048456 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2019   grade_7 182 2 2 1   8     1   4   104 96                       200.0 182 2 2 1   8     1   4   104 96                 200
2048555 2048555 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2019   grade_7 347 6 17 1   13     0   4   204 184                       388.0 347 6 17 1   13     0   4   204 184                 388

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