enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_7 · 495 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int ▲ native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2233302 2233302 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_7 41 40 269 0   35     0   13   195 203                       398.0 41 40 269 0   35     0   13   195 203                 398
2233306 2233306 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_7 67 37 264 1   49     0   16   216 218                       434.0 67 37 264 1   49     0   16   216 218                 434
2237867 2237867 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_7 92 67 210 1   38     0   16   226 198                       424.0 92 67 210 1   38     0   16   226 198                 424
2237863 2237863 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_7 78 69 204 0   22     0   17   196 194                       390.0 78 69 204 0   22     0   17   196 194                 390
2233498 2233498 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_7 123 13 173 0   8     0   8   176 149                       325.0 123 13 173 0   8     0   8   176 149                 325
2237859 2237859 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   grade_7 199 65 173 1   23     0   25   238 248                       486.0 199 65 173 1   23     0   25   238 248                 486
2232630 2232630 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_7 6 0 155 0   1     0   0   83 79                       162.0 6 0 155 0   1     0   0   83 79                 162
2234196 2234196 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford: Normandin Middle School   Regular School No Middle 06 08 2018   grade_7 198 28 151 2   9     0   29   216 201                       417.0 198 28 151 2   9     0   29   216 201                 417
2236166 2236166 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield: Forest Park Middle   Regular School No Middle 06 08 2018   grade_7 8 35 150 1   21     0   2   113 104                       217.0 8 35 150 1   21     0   2   113 104                 217
2232604 2232604 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_7 3 1 143 0   0     0   1   80 68                       148.0 3 1 143 0   0     0   1   80 68                 148
2236174 2236174 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 Springfield: M Marcus Kiley Middle   Regular School No Middle 06 08 2018   grade_7 21 46 143 0   5     0   0   117 98                       215.0 21 46 143 0   5     0   0   117 98                 215
2237856 2237856 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_7 108 64 138 0   9     0   16   153 182                       335.0 108 64 138 0   9     0   16   153 182                 335
2232673 2232673 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Lawrence: Spark Academy   Regular School No Middle 06 08 2018   grade_7 5 2 129 0   3     0   1   61 79                       140.0 5 2 129 0   3     0   1   61 79                 140
2230230 2230230 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_7 10 4 126 0   1     1   0   76 66                       142.0 10 4 126 0   1     1   0   76 66                 142
2230926 2230926 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea: Joseph A. Browne School   Regular School No Middle 05 08 2018   grade_7 11 5 126 0   2     0   0   75 69                       144.0 11 5 126 0   2     0   0   75 69                 144
2232625 2232625 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_7 3 3 124 0   0     0   1   65 66                       131.0 3 3 124 0   0     0   1   65 66                 131
2237938 2237938 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_7 26 13 122 5   3     2   0   80 91                       171.0 26 13 122 5   3     2   0   80 91                 171
2230921 2230921 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea: Clark Avenue School   Regular School No Middle 05 08 2018   grade_7 5 7 121 1   1     0   1   78 58                       136.0 5 7 121 1   1     0   1   78 58                 136
2232647 2232647 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_7 3 1 115 0   0     0   0   61 58                       119.0 3 1 115 0   0     0   0   61 58                 119
2232687 2232687 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_7 7 1 112 0   3     0   1   72 52                       124.0 7 1 112 0   3     0   1   72 52                 124
2234192 2234192 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_7 121 38 111 1   2     1   12   140 146                       286.0 121 38 111 1   2     1   12   140 146                 286
2235355 2235355 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere: Susan B. Anthony Middle School   Regular School No Middle 06 08 2018   grade_7 59 11 109 1   10     0   5   85 110                       195.0 59 11 109 1   10     0   5   85 110                 195
2231005 2231005 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_7 139 9 108 0   2     0   10   144 124                       268.0 139 9 108 0   2     0   10   144 124                 268
2236170 2236170 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 Springfield: John F Kennedy Middle   Regular School No Middle 06 08 2018   grade_7 12 33 106 1   2     0   3   90 67                       157.0 12 33 106 1   2     0   3   90 67                 157
2235880 2235880 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge: Southbridge Middle School   Regular School No Middle 06 08 2018   grade_7 53 3 105 0   4     0   2   87 80                       167.0 53 3 105 0   4     0   2   87 80                 167
2232265 2232265 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_7 97 6 101 0   5     1   3   95 118                       213.0 97 6 101 0   5     1   3   95 118                 213
2235351 2235351 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere: Garfield Middle School   Regular School No Middle 06 08 2018   grade_7 59 6 101 0   13     0   2   93 88                       181.0 59 6 101 0   13     0   2   93 88                 181
2236197 2236197 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Springfield: Impact Prep at Chestnut   Regular School No Middle 06 07 2018   grade_7 4 15 101 0   0     0   0   54 66                       120.0 4 15 101 0   0     0   0   54 66                 120
2231009 2231009 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_7 123 16 98 1   3     0   9   145 105                       250.0 123 16 98 1   3     0   9   145 105                 250
2232677 2232677 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_7 1 0 98 0   1     0   0   54 46                       100.0 1 0 98 0   1     0   0   54 46                 100
2233829 2233829 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford: Stacy Middle   Regular School No Middle 06 08 2018   grade_7 223 10 97 4   12     0   9   178 177                       355.0 223 10 97 4   12     0   9   178 177                 355
2236158 2236158 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 Springfield: John J Duggan Middle   Regular School No High 06 12 2018   grade_7 21 60 97 1   6     0   3   118 70                       188.0 21 60 97 1   6     0   3   118 70                 188
2230916 2230916 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea: Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2018   grade_7 12 4 96 0   2     0   2   64 52                       116.0 12 4 96 0   2     0   2   64 52                 116
2231710 2231710 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg: Memorial Intermediate   Regular School No Middle 05 08 2018   grade_7 54 12 95 0   12     0   10   93 90                       183.0 54 12 95 0   12     0   10   93 90                 183
2234200 2234200 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford: Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_7 98 43 95 1   0     0   19   136 120                       256.0 98 43 95 1   0     0   19   136 120                 256
2232801 2232801 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster: Sky View Middle School   Regular School No Middle 06 08 2018   grade_7 137 23 93 0   16     0   13   141 141                       282.0 137 23 93 0   16     0   13   141 141                 282
2236760 2236760 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham: John W. McDevitt Middle School   Regular School No Middle 06 08 2018   grade_7 84 17 92 0   6     1   6   105 101                       206.0 84 17 92 0   6     1   6   105 101                 206
2236212 2236212 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Springfield: Rise Academy at Van Sickle   Regular School No Middle 06 07 2018   grade_7 10 19 91 0   2     0   3   66 59                       125.0 10 19 91 0   2     0   3   66 59                 125
2238045 2238045 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District): KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2018   grade_7 8 18 91 0   2     0   3   74 48                       122.0 8 18 91 0   2     0   3   74 48                 122
2232599 2232599 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_7 6 0 90 0   3     0   0   46 53                       99.0 6 0 90 0   3     0   0   46 53                 99
2231722 2231722 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_7 42 12 88 0   8     0   8   88 70                       158.0 42 12 88 0   8     0   8   88 70                 158
2236215 2236215 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Springfield: Van Sickle Academy   Regular School No Middle 06 08 2018   grade_7 16 14 87 0   2     0   1   67 53                       120.0 16 14 87 0   2     0   1   67 53                 120
2238390 2238390 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_7 5 150 86 0   1     1   1   116 128                       244.0 5 150 86 0   1     1   1   116 128                 244
2229525 2229525 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_7 12 2 85 0   1     0   1   47 54                       101.0 12 2 85 0   1     0   1   47 54                 101
2235317 2235317 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere: Rumney Marsh Academy   Regular School No Middle 06 08 2018   grade_7 94 7 84 1   6     1   2   102 93                       195.0 94 7 84 1   6     1   2   102 93                 195
2233772 2233772 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen: Donald P Timony Grammar   Regular School No Elementary PK 08 2018   grade_7 53 0 83 0   8     0   5   92 57                       149.0 53 0 83 0   8     0   5   92 57                 149
2238357 2238357 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_7 7 67 82 0   9     0   1   88 78                       166.0 7 67 82 0   9     0   1   88 78                 166
2231498 2231498 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_7 11 10 81 0   4     0   0   58 48                       106.0 11 10 81 0   4     0   0   58 48                 106
2233310 2233310 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_7 66 20 79 2   22     0   10   103 96                       199.0 66 20 79 2   22     0   10   103 96                 199
2236193 2236193 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield: Chestnut Academy   Regular School No Middle 06 08 2018   grade_7 0 10 79 0   0     0   0   41 48                       89.0 0 10 79 0   0     0   0   41 48                 89
2234864 2234864 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody: J Henry Higgins Middle   Regular School No Middle 06 08 2018   grade_7 367 20 77 0   8     0   7   246 233                       479.0 367 20 77 0   8     0   7   246 233                 479
2230064 2230064 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_7 7 14 75 0   7     0   2   63 42                       105.0 7 14 75 0   7     0   2   63 42                 105
2231858 2231858 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_7 135 14 75 0   14     0   5   135 108                       243.0 135 14 75 0   14     0   5   135 108                 243
2232669 2232669 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_7 4 1 75 0   3     0   0   39 44                       83.0 4 1 75 0   3     0   0   39 44                 83
2233761 2233761 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen: Tenney Grammar School   Regular School No Elementary PK 08 2018   grade_7 80 0 72 0   6     0   14   94 78                       172.0 80 0 72 0   6     0   14   94 78                 172
2229660 2229660 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston: John W McCormack   Regular School No Middle 06 08 2018   grade_7 8 40 71 0   3     0   2   62 62                       124.0 8 40 71 0   3     0   2   62 62                 124
2230510 2230510 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_7 56 88 71 1   8     0   9   116 117                       233.0 56 88 71 1   8     0   9   116 117                 233
2232385 2232385 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke: William R. Peck School   Regular School No Middle 04 08 2018   grade_7 6 3 71 0   0     0   0   45 35                       80.0 6 3 71 0   0     0   0   45 35                 80
2233110 2233110 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell: Dr An Wang School   Regular School No Middle 05 08 2018   grade_7 35 16 70 0   23     0   6   92 58                       150.0 35 16 70 0   23     0   6   92 58                 150
2237849 2237849 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_7 4 5 70 0   7     0   0   46 40                       86.0 4 5 70 0   7     0   0   46 40                 86
2230140 2230140 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_7 99 63 67 0   58     1   12   120 179                       300.0 99 63 67 0   58     1   12   120 179                 300
2236181 2236181 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield: STEM Middle Academy   Regular School No Middle 06 08 2018   grade_7 12 19 67 0   3     0   0   67 34                       101.0 12 19 67 0   3     0   0   67 34                 101
2238227 2238227 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter (District): Holyoke Community Charter School   Regular School Yes Elementary KG 08 2018   grade_7 3 1 66 0   0     0   2   32 40                       72.0 3 1 66 0   0     0   2   32 40                 72
2230040 2230040 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston: Lilla G. Frederick Middle School   Regular School No Middle 06 08 2018   grade_7 0 61 65 0   16     0   7   93 56                       149.0 0 61 65 0   16     0   7   93 56                 149
2230180 2230180 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_7 22 52 65 0   33     0   7   73 106                       179.0 22 52 65 0   33     0   7   73 106                 179
2236185 2236185 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 Springfield: South End Middle School   Regular School No Middle 06 08 2018   grade_7 1 13 64 0   0     0   2   35 45                       80.0 1 13 64 0   0     0   2   35 45                 80
2231854 2231854 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   grade_7 59 20 63 0   5     1   10   80 78                       158.0 59 20 63 0   5     1   10   80 78                 158
2233100 2233100 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Lowell: Henry J Robinson Middle   Regular School No Middle 05 08 2018   grade_7 37 23 63 0   26     0   7   83 73                       156.0 37 23 63 0   26     0   7   83 73                 156
2236150 2236150 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_7 24 22 62 0   1     0   0   55 54                       109.0 24 22 62 0   1     0   0   55 54                 109
2231622 2231622 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_7 157 26 61 0   7     0   16   136 131                       267.0 157 26 61 0   7     0   16   136 131                 267
2230072 2230072 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston: James P Timilty Middle   Regular School No Middle 06 08 2018   grade_7 0 31 60 0   0     1   0   42 50                       92.0 0 31 60 0   0     1   0   42 50                 92
2238035 2238035 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_7 9 99 59 0   3     0   4   88 86                       174.0 9 99 59 0   3     0   4   88 86                 174
2230165 2230165 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_7 194 29 58 0   115     2   19   189 228                       417.0 194 29 58 0   115     2   19   189 228                 417
2237212 2237212 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield: West Springfield Middle   Regular School No Middle 06 08 2018   grade_7 216 11 58 1   26     0   5   184 133                       317.0 216 11 58 1   26     0   5   184 133                 317
2233105 2233105 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell: James Sullivan Middle School   Regular School No Middle 05 08 2018   grade_7 48 13 57 0   21     0   5   77 67                       144.0 48 13 57 0   21     0   5   77 67                 144
2238510 2238510 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School (District): Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2018   grade_7 5 19 57 0   1     0   0   32 50                       82.0 5 19 57 0   1     0   0   32 50                 82
2231614 2231614 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River: Talbot Innovation School   Regular School No Middle 06 08 2018   grade_7 87 13 55 0   10     0   8   96 77                       173.0 87 13 55 0   10     0   8   96 77                 173
2233115 2233115 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell: Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2018   grade_7 16 6 55 0   85     0   6   91 77                       168.0 16 6 55 0   85     0   6   91 77                 168
2239933 2239933 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_7 6 18 55 0   0     0   1   48 32                       80.0 6 18 55 0   0     0   1   48 32                 80
2229443 2229443 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   grade_7 3 18 54 0   2     0   2   32 47                       79.0 3 18 54 0   2     0   2   32 47                 79
2236756 2236756 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 Waltham: John F Kennedy Middle   Regular School No Middle 06 08 2018   grade_7 86 21 54 0   14     0   2   99 78                       177.0 86 21 54 0   14     0   2   99 78                 177
2238139 2238139 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District): Sabis International Charter School   Regular School Yes Other KG 12 2018   grade_7 26 35 54 0   6     0   7   66 62                       128.0 26 35 54 0   6     0   7   66 62                 128
2238238 2238238 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   grade_7 0 0 54 0   0     0   0   24 30                       54.0 0 0 54 0   0     0   0   24 30                 54
2236200 2236200 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield: Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2018   grade_7 14 30 52 0   4     1   3   44 60                       104.0 14 30 52 0   4     1   3   44 60                 104
2235494 2235494 MA Essex   school 2510380 258   Salem 251038002404 2580305 Salem: Collins Middle   Regular School No Middle 06 08 2018   grade_7 105 15 51 0   7     0   7   91 94                       185.0 105 15 51 0   7     0   7   91 94                 185
2235803 2235803 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 Somerville: E Somerville Community   Regular School No Elementary KG 08 2018   grade_7 7 5 51 0   1     0   1   27 38                       65.0 7 5 51 0   1     0   1   27 38                 65
2231489 2231489 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett: Lafayette School   Regular School No Elementary KG 08 2018   grade_7 32 18 50 1   2     0   3   49 57                       106.0 32 18 50 1   2     0   3   49 57                 106
2232229 2232229 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_7 69 6 50 0   4     0   1   67 63                       130.0 69 6 50 0   4     0   1   67 63                 130
2234448 2234448 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_7 150 4 50 1   5     0   13   116 107                       223.0 150 4 50 1   5     0   13   116 107                 223
2230068 2230068 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston: Washington Irving Middle   Regular School No Middle 06 08 2018   grade_7 2 47 49 0   2     0   0   53 47                       100.0 2 47 49 0   2     0   0   53 47                 100
2232417 2232417 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke: Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2018   grade_7 8 4 49 0   0     0   1   26 36                       62.0 8 4 49 0   0     0   1   26 36                 62
2232396 2232396 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_7 2 0 48 0   0     0   0   28 22                       50.0 2 0 48 0   0     0   0   28 22                 50
2238307 2238307 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   grade_7 0 41 48 0   1     0   2   49 43                       92.0 0 41 48 0   1     0   2   49 43                 92
2233750 2233750 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen: Comprehensive Grammar School   Regular School No Elementary PK 08 2018   grade_7 59 2 46 0   8     0   8   58 65                       123.0 59 2 46 0   8     0   8   58 65                 123
2233411 2233411 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden: Salemwood   Regular School No Elementary KG 08 2018   grade_7 32 33 45 0   23     0   1   66 68                       134.0 32 33 45 0   23     0   1   66 68                 134
2231618 2231618 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River: Morton Middle   Regular School No Middle 06 08 2018   grade_7 120 16 44 2   13     0   12   112 95                       207.0 120 16 44 2   13     0   12   112 95                 207
2231470 2231470 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett: George Keverian School   Regular School No Elementary KG 08 2018   grade_7 25 20 43 0   3     0   1   45 47                       92.0 25 20 43 0   3     0   1   45 47                 92
2236880 2236880 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster: Webster Middle School   Regular School No Middle 05 08 2018   grade_7 87 12 42 0   2     0   9   55 97                       152.0 87 12 42 0   2     0   9   55 97                 152
2229616 2229616 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   grade_7 1 17 41 0   0     0   0   22 37                       59.0 1 17 41 0   0     0   0   22 37                 59
2231460 2231460 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_7 20 15 41 0   6     0   3   39 46                       85.0 20 15 41 0   6     0   3   39 46                 85

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);