enrollments

Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by hispanic_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,218 ✖
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
1368743 1368743 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_5 158 13 215 0   8     0   19   198 215 *                     413.0 158 13 215 0   8     0   19   198 215                 413
2043813 2043813 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_5 152 12 210 1   15     0   12   219 183                       402.0 152 12 210 1   15     0   12   219 183                 402
2233496 2233496 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_5 184 10 181 0   11     0   9   198 197                       395.0 184 10 181 0   11     0   9   198 197                 395
2041663 2041663 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_5 13 8 175 1   1     1   2   96 105                       201.0 13 8 175 1   1     1   2   96 105                 201
936517 936517 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_5 180 12 162 0   17     0   10   202 179                       381 180 12 162 0   17     0   10   202 179                 381
1366594 1366594 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_5 13 6 159 0   1     0   2   95 86 *                     181.0 13 6 159 0   1     0   2   95 86                 181
1673825 1673825 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea - Clark Avenue School   Regular School No Middle 05 08 2021   grade_5 10 5 159 0   0     0   2   95 81 *                     176.0 10 5 159 0   0     0   2   95 81                 176
1126675 1126675 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_5 162 9 156 0   19     0   18   168 196                       364 162 9 156 0   19     0   18   168 196                 364
2230924 2230924 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea: Joseph A. Browne School   Regular School No Middle 05 08 2018   grade_5 5 4 154 0   2     0   0   83 82                       165.0 5 4 154 0   2     0   0   83 82                 165
1675214 1675214 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_5 3 2 143 0   0     0   0   80 68 *                     148.0 3 2 143 0   0     0   0   80 68                 148
2043088 2043088 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_5 5 1 142 0   1     0   1   75 75                       150.0 5 1 142 0   1     0   1   75 75                 150
738969 738969 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No 2 05 07 2015   grade_5 5 3 141 0   4     0   2   68 87                       155 5 3 141 0   4     0   2   68 87                 155
2043053 2043053 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2019   grade_5 11 1 141 0   3     0   1   77 80                       157.0 11 1 141 0   3     0   1   77 80                 157
1124104 1124104 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_5 11 2 138 1   1     0   0   84 69                       153 11 2 138 1   1     0   0   84 69                 153
1131110 1131110 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_5 19 4 138 1   3     1   2   87 81                       168 19 4 138 1   3     1   2   87 81                 168
2230919 2230919 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea: Clark Avenue School   Regular School No Middle 05 08 2018   grade_5 9 5 138 1   0     0   3   84 72                       156.0 9 5 138 1   0     0   3   84 72                 156
1679716 1679716 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_5 20 10 137 3   2     0   2   88 86 *                     174.0 20 10 137 3   2     0   2   88 86                 174
743416 743416 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_5 14 10 136 5   2     0   0   80 87                       167 14 10 136 5   2     0   0   80 87                 167
934372 934372 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2016   grade_5 7 7 136 1   1     0   2   91 63                       154 7 7 136 1   1     0   2   91 63                 154
2232602 2232602 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_5 2 0 136 0   0     0   0   70 68                       138.0 2 0 136 0   0     0   0   70 68                 138
1124109 1124109 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_5 9 6 135 0   3     0   1   70 84                       154 9 6 135 0   3     0   1   70 84                 154
935745 935745 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 KG 05 2016   grade_5 7 1 133 0   3     0   1   66 79                       145 7 1 133 0   3     0   1   66 79                 145
2043067 2043067 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_5 4 0 133 1   0     0   0   65 72                       138.0 4 0 133 1   0     0   0   65 72                 138
1124099 1124099 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_5 14 10 132 0   1     0   2   92 67                       159 14 10 132 0   1     0   2   92 67                 159
1675249 1675249 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence - Parthum Middle School   Regular School No Middle 05 08 2021   grade_5 7 0 132 0   2     0   1   76 66 *                     142.0 7 0 132 0   2     0   1   76 66                 142
2041667 2041667 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2019   grade_5 9 12 132 0   4     0   0   92 65                       157.0 9 12 132 0   4     0   0   92 65                 157
739673 739673 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2015   grade_5 188 11 131 0   10     0   17   190 167                       357 188 11 131 0   10     0   17   190 167                 357
1125767 1125767 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary KG 05 2017   grade_5 4 3 131 0   3     0   0   65 76                       141 4 3 131 0   3     0   0   65 76                 141
1367969 1367969 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_5 4 1 131 0   3     0   0   84 54 *                     139.0 4 1 131 0   3     0   0   84 54                 139
738928 738928 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2015   grade_5 3 3 130 0   2     0   0   61 77                       138 3 3 130 0   2     0   0   61 77                 138
1368004 1368004 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_5 7 0 130 0   1     0   0   64 74 *                     138.0 7 0 130 0   1     0   0   64 74                 138
1372452 1372452 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_5 30 11 129 0   3     1   2   90 86 *                     176.0 30 11 129 0   3     1   2   90 86                 176
2047525 2047525 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_5 28 12 129 1   2     0   1   82 91                       173.0 28 12 129 1   2     0   1   82 91                 173
2232628 2232628 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_5 13 4 129 0   1     0   1   73 75                       148.0 13 4 129 0   1     0   1   73 75                 148
935780 935780 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2016   grade_5 4 2 128 0   0     0   0   70 64                       134 4 2 128 0   0     0   0   70 64                 134
1367983 1367983 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_5 1 1 128 0   0     0   0   74 56 *                     130.0 1 1 128 0   0     0   0   74 56                 130
2237936 2237936 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_5 26 12 128 0   0     1   2   83 86                       169.0 26 12 128 0   0     1   2   83 86                 169
2042937 2042937 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Veritas Prep Holyoke   Regular School No Middle 05 05 2019   grade_5 3 8 127 0   0     0   1   79 60                       139.0 3 8 127 0   0     0   1   79 60                 139
2043084 2043084 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_5 1 3 127 0   1     0   0   76 56                       132.0 1 3 127 0   1     0   0   76 56                 132
2232584 2232584 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence: South Lawrence East Elementary School   Regular School No Elementary 01 05 2018   grade_5 5 2 127 0   1     0   2   73 64                       137.0 5 2 127 0   1     0   2   73 64                 137
737512 737512 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_5 1 2 124 0   2     0   1   71 59                       130 1 2 124 0   2     0   1   71 59                 130
1125785 1125785 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_5 2 1 124 0   0     0   0   66 61                       127 2 1 124 0   0     0   0   66 61                 127
935776 935776 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2016   grade_5 6 4 122 0   0     0   1   70 63                       133 6 4 122 0   0     0   1   70 63                 133
935759 935759 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2016   grade_5 3 2 121 0   0     0   0   64 62                       126 3 2 121 0   0     0   0   64 62                 126
738932 738932 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_5 13 4 120 0   0     0   1   81 57                       138 13 4 120 0   0     0   1   81 57                 138
1675228 1675228 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence - Arlington Middle School   Regular School No Middle 05 08 2021   grade_5 4 2 120 0   0     0   0   74 51 *                     126.0 4 2 120 0   0     0   0   74 51                 126
737508 737508 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_5 8 9 118 1   4     0   3   80 63                       143 8 9 118 1   4     0   3   80 63                 143
2230914 2230914 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea: Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2018   grade_5 11 10 118 0   3     0   4   67 79                       146.0 11 10 118 0   3     0   4   67 79                 146
940235 940235 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_5 25 14 117 5   2     2   0   73 92                       165 25 14 117 5   2     2   0   73 92                 165
1368000 1368000 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_5 6 1 117 0   0     0   0   63 61 *                     124.0 6 1 117 0   0     0   0   63 61                 124
1368051 1368051 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_5 13 0 116 0   4     0   1   67 67 *                     134.0 13 0 116 0   4     0   1   67 67                 134
1675296 1675296 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_5 8 5 116 0   1     0   1   65 66 *                     131.0 8 5 116 0   1     0   1   65 66                 131
1366590 1366590 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_5 10 7 115 0   1     0   1   64 70 *                     134.0 10 7 115 0   1     0   1   64 70                 134
743816 743816 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_5 2 128 114 0   2     0   3   137 112                       249 2 128 114 0   2     0   3   137 112                 249
1675245 1675245 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_5 2 3 112 0   2     0   1   63 57 *                     120.0 2 3 112 0   2     0   1   63 57                 120
738911 738911 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_5 4 3 111 0   0     0   0   60 58                       118 4 3 111 0   0     0   0   60 58                 118
2042791 2042791 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_5 58 5 111 0   6     0   5   102 83                       185.0 58 5 111 0   6     0   5   102 83                 185
934376 934376 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2016   grade_5 10 6 110 0   3     0   0   63 66                       129 10 6 110 0   3     0   0   63 66                 129
1125806 1125806 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_5 2 3 110 0   1     0   0   57 59                       116 2 3 110 0   1     0   0   57 59                 116
1674500 1674500 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg - Arthur M Longsjo Middle School   Regular School No Middle 05 08 2021   grade_5 38 16 110 1   6     0   7   89 89 *                     178.0 38 16 110 1   6     0   7   89 89                 178
2043135 2043135 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_5 9 7 108 0   2     0   4   77 53                       130.0 9 7 108 0   2     0   4   77 53                 130
2232685 2232685 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_5 13 3 108 0   8     0   3   72 63                       135.0 13 3 108 0   8     0   3   72 63                 135
1367266 1367266 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_5 38 8 105 0   7     0   12   81 89 *                     170.0 38 8 105 0   7     0   12   81 89                 170
1676268 1676268 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford - Woodland   Regular School No Elementary 03 05 2021   grade_5 194 11 103 3   7     0   14   171 161 *                     332.0 194 11 103 3   7     0   14   171 161                 332
2042326 2042326 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_5 63 7 103 0   7     1   12   96 97                       193.0 63 7 103 0   7     1   12   96 97                 193
2232623 2232623 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_5 6 0 103 0   0     0   0   50 59                       109.0 6 0 103 0   0     0   0   50 59                 109
2233826 2233826 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_5 184 7 102 14   5     0   14   169 157                       326.0 184 7 102 14   5     0   14   169 157                 326
935794 935794 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_5 3 0 101 0   0     0   0   57 47                       104 3 0 101 0   0     0   0   57 47                 104
2043101 2043101 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_5 2 0 101 0   1     0   0   50 53                       104.0 2 0 101 0   1     0   0   50 53                 104
935824 935824 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2016   grade_5 8 2 100 0   3     0   2   71 44                       115 8 2 100 0   3     0   2   71 44                 115
1125811 1125811 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_5 8 0 100 0   0     0   2   46 64                       110 8 0 100 0   0     0   2   46 64                 110
1131213 1131213 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2017   grade_5 5 18 100 0   2     0   1   66 60                       126 5 18 100 0   2     0   1   66 60                 126
1673821 1673821 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_5 9 6 99 0   0     0   2   57 59 *                     116.0 9 6 99 0   0     0   2   57 59                 116
935023 935023 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_5 62 12 98 0   12     0   16   104 96                       200 62 12 98 0   12     0   16   104 96                 200
1366598 1366598 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_5 12 7 98 0   0     0   4   64 57 *                     121.0 12 7 98 0   0     0   4   64 57                 121
1368012 1368012 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_5 1 0 98 0   0     0   0   55 44 *                     99.0 1 0 98 0   0     0   0   55 44                 99
935033 935033 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_5 49 10 97 0   10     0   11   95 82                       177 49 10 97 0   10     0   11   95 82                 177
2041659 2041659 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_5 5 9 97 0   3     0   3   68 49                       117.0 5 9 97 0   3     0   3   68 49                 117
2047930 2047930 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_5 4 120 97 1   0     1   0   115 108                       223.0 4 120 97 1   0     1   0   115 108                 223
1125868 1125868 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_5 15 3 96 0   7     0   1   55 67                       122 15 3 96 0   7     0   1   55 67                 122
934368 934368 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2016   grade_5 9 8 95 2   2     0   2   64 54                       118 9 8 95 2   2     0   2   64 54                 118
1125827 1125827 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_5 7 1 95 0   0     0   0   54 49                       103 7 1 95 0   0     0   0   54 49                 103
2044091 2044091 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_5 190 11 95 8   11     0   14   178 151                       329.0 190 11 95 8   11     0   14   178 151                 329
1675100 1675100 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_5 1 4 94 0   1     0   1   52 49 *                     101.0 1 4 94 0   1     0   1   52 49                 101
1675257 1675257 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_5 6 1 94 0   0     0   0   49 52 *                     101.0 6 1 94 0   0     0   0   49 52                 101
737516 737516 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_5 8 6 93 0   5     0   0   54 58                       112 8 6 93 0   5     0   0   54 58                 112
738941 738941 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_5 4 1 93 0   0     0   0   48 50                       98 4 1 93 0   0     0   0   48 50                 98
935755 935755 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_5 8 0 93 0   3     0   0   47 57                       104 8 0 93 0   3     0   0   47 57                 104
1131555 1131555 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_5 3 137 93 0   6     1   4   139 105                       244 3 137 93 0   6     1   4   139 105                 244
1369020 1369020 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2020   grade_5 199 11 93 8   4     1   17   180 153 *                     333.0 199 11 93 8   4     1   17   180 153                 333
2045368 2045368 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2019   grade_5 31 7 93 0   2     0   4   74 63                       137.0 31 7 93 0   2     0   4   74 63                 137
738169 738169 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_5 44 7 92 0   9     0   12   80 84                       164 44 7 92 0   9     0   12   80 84                 164
935789 935789 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   grade_5 1 0 92 0   0     0   0   45 48                       93 1 0 92 0   0     0   0   45 48                 93
1367856 1367856 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Veritas Prep Holyoke   Regular School No Middle 05 06 2020   grade_5 4 5 92 0   1     0   1   67 36 *                     103.0 4 5 92 0   1     0   1   67 36                 103
1674490 1674490 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg - Memorial Middle School   Regular School No Middle 05 08 2021   grade_5 47 6 92 0   6     0   12   77 86 *                     163.0 47 6 92 0   6     0   12   77 86                 163
2231720 2231720 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_5 41 8 92 0   4     1   14   82 78                       160.0 41 8 92 0   4     1   14   82 78                 160
2238388 2238388 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_5 3 135 92 1   4     0   1   124 112                       236.0 3 135 92 1   4     0   1   124 112                 236
1124880 1124880 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_5 52 8 91 0   13     0   10   89 85                       174 52 8 91 0   13     0   10   89 85                 174
1128527 1128527 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2017   grade_5 25 2 91 0   2     0   1   53 68                       121 25 2 91 0   2     0   1   53 68                 121
1676213 1676213 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   grade_5 48 2 91 0   6     0   3   80 70 *                     150.0 48 2 91 0   6     0   3   80 70                 150

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