enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by hispanic 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
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2047627 2047627 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_7 4 20 96 0   1     0   1   60 62                       122.0 4 20 96 0   1     0   1   60 62                 122
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
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
2041742 2041742 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_7 123 12 94 0   5     0   10   137 107                       244.0 123 12 94 0   5     0   10   137 107                 244
2045497 2045497 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2019   grade_7 95 18 94 0   8     0   10   117 108                       225.0 95 18 94 0   8     0   10   117 108                 225
2042328 2042328 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_7 52 9 92 0   13     0   7   79 94                       173.0 52 9 92 0   13     0   7   79 94                 173
2042338 2042338 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2019   grade_7 35 12 92 0   7     0   10   87 69                       156.0 35 12 92 0   7     0   10   87 69                 156
2046101 2046101 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_7 7 17 92 0   0     0   0   55 61                       116.0 7 17 92 0   0     0   0   55 61                 116
2040453 2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
2040927 2040927 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_7 8 25 9 0   5     0   4   26 25                       51.0 8 25 9 0   5     0   4   26 25                 51
2041342 2041342 MA Middlesex   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2019   grade_7 34 4 9 0   24     0   8   50 29                       79.0 34 4 9 0   24     0   8   50 29                 79
2041362 2041362 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   grade_7 35 5 9 0   13     0   12   38 36                       74.0 35 5 9 0   13     0   12   38 36                 74
2041390 2041390 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2019   grade_7 27 7 9 0   10     0   3   28 28                       56.0 27 7 9 0   10     0   3   28 28                 56
2042826 2042826 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2019   grade_7 304 7 9 0   6     0   13   175 164                       339.0 304 7 9 0   6     0   13   175 164                 339
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
2043147 2043147 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_7 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2043343 2043343 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2019   grade_7 79 6 9 0   18     0   4   55 61                       116.0 79 6 9 0   18     0   4   55 61                 116
2043353 2043353 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_7 85 1 9 0   10     0   3   50 58                       108.0 85 1 9 0   10     0   3   50 58                 108
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
2043695 2043695 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2019   grade_7 155 2 9 0   7     0   4   90 87                       177.0 155 2 9 0   7     0   4   90 87                 177
2043856 2043856 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2019   grade_7 262 0 9 0   3     0   6   141 139                       280.0 262 0 9 0   3     0   6   141 139                 280
2043892 2043892 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2019   grade_7 68 2 9 0   2     0   5   40 46                       86.0 68 2 9 0   2     0   5   40 46                 86
2045615 2045615 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2019   grade_7 134 3 9 0   6     0   4   80 76                       156.0 134 3 9 0   6     0   4   80 76                 156
2045713 2045713 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2019   grade_7 197 0 9 0   0     0   1   106 101                       207.0 197 0 9 0   0     0   1   106 101                 207
2046258 2046258 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2019   grade_7 240 14 9 0   23     0   24   150 160                       310.0 240 14 9 0   23     0   24   150 160                 310
2046396 2046396 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2019   grade_7 243 9 9 0   12     0   2   149 126                       275.0 243 9 9 0   12     0   2   149 126                 275
2047634 2047634 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_7 102 0 9 0   21     0   12   78 66                       144.0 102 0 9 0   21     0   12   78 66                 144
2047896 2047896 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2019   grade_7 47 4 9 0   0     0   9   26 43                       69.0 47 4 9 0   0     0   9   26 43                 69
2048585 2048585 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2019   grade_7 281 0 9 0   13     0   6   142 167                       309.0 281 0 9 0   13     0   6   142 167                 309
2048784 2048784 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2019   grade_7 188 2 9 0   2     0   11   109 103                       212.0 188 2 9 0   2     0   11   109 103                 212
2049326 2049326 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_7 3 101 9 1   0     0   0   62 52                       114.0 3 101 9 1   0     0   0   62 52                 114
2049356 2049356 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_7 29 5 9 0   3     0   3   27 22                       49.0 29 5 9 0   3     0   3   27 22                 49
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
2046098 2046098 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_7 3 11 85 0   0     0   2   52 49                       101.0 3 11 85 0   0     0   2   52 49                 101
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
2042457 2042457 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_7 146 8 82 0   9     0   4   130 119                       249.0 146 8 82 0   9     0   4   130 119                 249
2044037 2044037 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2019   grade_7 62 2 81 0   5     0   11   91 70                       161.0 62 2 81 0   5     0   11   91 70                 161
2042158 2042158 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_7 12 18 80 0   3     0   0   53 60                       113.0 12 18 80 0   3     0   0   53 60                 113
2040324 2040324 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_7 3 3 8 0   2     0   2   9 9                       18.0 3 3 8 0   2     0   2   9 9                 18
2040348 2040348 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_7 1 8 8 0   0     0   1   8 10                       18.0 1 8 8 0   0     0   1   8 10                 18
2041409 2041409 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2019   grade_7 38 2 8 0   7     0   9   37 27                       64.0 38 2 8 0   7     0   9   37 27                 64
2042180 2042180 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2019   grade_7 138 2 8 0   5     0   6   90 69                       159.0 138 2 8 0   5     0   6   90 69                 159
2043190 2043190 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_7 55 0 8 0   2     0   2   37 30                       67.0 55 0 8 0   2     0   2   37 30                 67
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
2044231 2044231 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2019   grade_7 197 7 8 0   14     0   14   128 112                       240.0 197 7 8 0   14     0   14   128 112                 240
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
2045740 2045740 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary KG 08 2019   grade_7 52 4 8 0   3     0   3   39 31                       70.0 52 4 8 0   3     0   3   39 31                 70
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
2046889 2046889 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2019   grade_7 107 8 8 0   25     0   12   86 74                       160.0 107 8 8 0   25     0   12   86 74                 160
2047812 2047812 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 2019   grade_7 22 3 8 0   0     0   2   13 22                       35.0 22 3 8 0   0     0   2   13 22                 35
2047878 2047878 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2019   grade_7 55 34 8 0   32     0   3   62 70                       132.0 55 34 8 0   32     0   3   62 70                 132
2047961 2047961 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_7 21 51 8 0   7     0   2   52 37                       89.0 21 51 8 0   7     0   2   52 37                 89
2048348 2048348 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2019   grade_7 137 3 8 0   18     0   7   96 77                       173.0 137 3 8 0   18     0   7   96 77                 173
2043480 2043480 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2019   grade_7 37 17 78 0   27     0   7   77 89                       166.0 37 17 78 0   27     0   7   77 89                 166
2047451 2047451 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_7 5 12 78 0   9     0   4   57 51                       108.0 5 12 78 0   9     0   4   57 51                 108
2049331 2049331 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 07 2019   grade_7 2 10 77 0   0     0   2   55 36                       91.0 2 10 77 0   0     0   2   55 36                 91
2043065 2043065 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_7 4 2 76 0   3     0   0   45 40                       85.0 4 2 76 0   3     0   0   45 40                 85
2040572 2040572 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2019   grade_7 4 30 75 0   4     0   7   70 50                       120.0 4 30 75 0   4     0   7   70 50                 120
2046093 2046093 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2019   grade_7 1 8 75 0   0     0   1   41 44                       85.0 1 8 75 0   0     0   1   41 44                 85
2042454 2042454 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_7 113 19 74 0   4     1   5   114 102                       216.0 113 19 74 0   4     1   5   114 102                 216
2041003 2041003 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_7 98 65 73 0   41     0   6   99 184                       283.0 98 65 73 0   41     0   6   99 184                 283
2047616 2047616 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_7 5 99 73 0   2     0   0   91 88                       179.0 5 99 73 0   2     0   0   91 88                 179
2042939 2042939 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2019   grade_7 7 5 72 0   0     0   1   41 44                       85.0 7 5 72 0   0     0   1   41 44                 85
2043122 2043122 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_7 1 1 72 0   2     0   0   36 40                       76.0 1 1 72 0   2     0   0   36 40                 76
2043487 2043487 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2019   grade_7 64 14 72 0   32     0   7   84 105                       189.0 64 14 72 0   32     0   7   84 105                 189
2044047 2044047 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2019   grade_7 68 2 72 0   2     0   8   74 78                       152.0 68 2 72 0   2     0   8   74 78                 152
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
2041024 2041024 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_7 195 34 71 0   92     0   18   202 208                       410.0 195 34 71 0   92     0   18   202 208                 410
2042260 2042260 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2019   grade_7 69 15 71 0   8     0   18   106 75                       181.0 69 15 71 0   8     0   18   106 75                 181
2043224 2043224 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2019   grade_7 85 14 71 0   4     0   3   93 84                       177.0 85 14 71 0   4     0   3   93 84                 177
2043483 2043483 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 06 08 2019   grade_7 54 16 71 0   26     0   5   96 76                       172.0 54 16 71 0   26     0   5   96 76                 172
2040913 2040913 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2019   grade_7 4 76 70 0   5     0   6   84 77                       161.0 4 76 70 0   5     0   6   84 77                 161
2042232 2042232 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_7 25 4 7 0   3     0   5   24 20                       44.0 25 4 7 0   3     0   5   24 20                 44
2044436 2044436 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2019   grade_7 177 3 7 0   9     0   4   101 99                       200.0 177 3 7 0   9     0   4   101 99                 200
2045256 2045256 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2019   grade_7 25 7 7 0   28     0   2   36 33                       69.0 25 7 7 0   28     0   2   36 33                 69
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
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
2046774 2046774 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2019   grade_7 58 2 7 0   2     0   1   38 32                       70.0 58 2 7 0   2     0   1   38 32                 70
2046858 2046858 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2019   grade_7 111 0 7 0   62     0   4   94 90                       184.0 111 0 7 0   62     0   4   94 90                 184
2046903 2046903 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2019   grade_7 137 0 7 0   0     0   6   79 71                       150.0 137 0 7 0   0     0   6   79 71                 150
2047577 2047577 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_7 0 16 7 0   0     0   1   12 12                       24.0 0 16 7 0   0     0   1   12 12                 24
2048339 2048339 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2019   grade_7 140 0 7 0   3     0   6   85 71                       156.0 140 0 7 0   3     0   6   85 71                 156
2048478 2048478 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No Middle 06 08 2019   grade_7 77 1 7 0   0     0   9   43 51                       94.0 77 1 7 0   0     0   9   43 51                 94
2048504 2048504 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2019   grade_7 106 1 7 0   8     1   2   43 82                       125.0 106 1 7 0   8     1   2   43 82                 125
2048815 2048815 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2019   grade_7 181 0 7 0   3     0   0   90 101                       191.0 181 0 7 0   3     0   0   90 101                 191
2048885 2048885 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2019   grade_7 170 1 7 0   3     0   2   87 96                       183.0 170 1 7 0   3     0   2   87 96                 183
2048904 2048904 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No Middle 07 08 2019   grade_7 229 3 7 1   6     1   3   129 121                       250.0 229 3 7 1   6     1   3   129 121                 250
2048945 2048945 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_7 101 0 7 0   1     0   4   57 56                       113.0 101 0 7 0   1     0   4   57 56                 113
2041309 2041309 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2019   grade_7 60 84 69 0   9     0   10   104 128                       232.0 60 84 69 0   9     0   10   104 128                 232
2046114 2046114 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_7 11 11 69 0   0     0   1   48 44                       92.0 11 11 69 0   0     0   1   48 44                 92
2046090 2046090 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_7 13 11 68 0   4     0   2   54 44                       98.0 13 11 68 0   4     0   2   54 44                 98
2040935 2040935 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_7 7 18 67 0   13     0   3   64 44                       108.0 7 18 67 0   13     0   3   64 44                 108
2044969 2044969 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2019   grade_7 371 18 67 0   8     0   7   240 231                       471.0 371 18 67 0   8     0   7   240 231                 471
2040121 2040121 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2019   grade_7 264 27 65 0   8     0   18   207 175                       382.0 264 27 65 0   8     0   18   207 175                 382
2040381 2040381 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_7 5 23 65 0   1     0   1   50 45                       95.0 5 23 65 0   1     0   1   50 45                 95
2046117 2046117 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2019   grade_7 2 6 65 0   0     0   0   47 26                       73.0 2 6 65 0   0     0   0   47 26                 73
2047793 2047793 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2019   grade_7 6 0 65 0   0     0   0   33 38                       71.0 6 0 65 0   0     0   0   33 38                 71
2047903 2047903 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 2019   grade_7 5 83 65 0   12     0   4   83 86                       169.0 5 83 65 0   12     0   4   83 86                 169
2048043 2048043 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2019   grade_7 2 6 65 0   1     0   3   38 39                       77.0 2 6 65 0   1     0   3   38 39                 77

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