Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by total_int descending

View and edit SQL

year

grade

  • grade_2 · 6,831
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 ▲
1675127 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton - Elmwood   Regular School No Elementary 02 03 2021   grade_2 183 0 17 1   87     0   20   155 153 *                     308.0 183 0 17 1   87     0   20   155 153                 308
2042962 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2019   grade_2 207 1 11 1   58     0   3   143 138                       281.0 207 1 11 1   58     0   3   143 138                 281
936458 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2016   grade_2 218 7 16 0   13     0   5   142 117                       259 218 7 16 0   13     0   5   142 117                 259
739613 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2015   grade_2 225 4 12 1   12     0   3   133 124                       257 225 4 12 1   12     0   3   133 124                 257
1373173 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2020   grade_2 224 8 9 0   5     2   8   143 113 *                     256.0 224 8 9 0   5     2   8   143 113                 256
2233423 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield: Everett W Robinson   Regular School No Elementary KG 02 2018   grade_2 184 5 19 1   29     0   17   147 108                       255.0 184 5 19 1   29     0   17   147 108                 255
1367882 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2020   grade_2 149 2 12 0   76     0   15   127 127 *                     254.0 149 2 12 0   76     0   15   127 127                 254
744113 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No 1 PK 03 2015   grade_2 211 8 10 0   4     0   18   120 131                       251 211 8 10 0   4     0   18   120 131                 251
1680436 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham - Mitchell Elementary School   Regular School No Elementary PK 03 2021   grade_2 197 17 18 0   5     1   13   133 118 *                     251.0 197 17 18 0   5     1   13   133 118                 251
1125650 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2017   grade_2 195 2 7 1   36     1   8   136 114                       250 195 2 7 1   36     1   8   136 114                 250
2043755 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   grade_2 191 12 15 0   19     0   12   129 120                       249.0 191 12 15 0   19     0   12   129 120                 249
940947 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No 1 PK 03 2016   grade_2 211 12 7 0   4     0   8   126 116                       242 211 12 7 0   4     0   8   126 116                 242
2048234 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2019   grade_2 211 15 2 0   7     0   7   123 119                       242.0 211 15 2 0   7     0   7   123 119                 242
738798 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No 1 02 03 2015   grade_2 194 2 8 0   30     0   7   122 119                       241 194 2 8 0   30     0   7   122 119                 241
2232467 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton: Elmwood   Regular School No Elementary 02 03 2018   grade_2 171 1 6 1   46     0   13   119 119                       238.0 171 1 6 1   46     0   13   119 119                 238
1368689 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2020   grade_2 187 7 7 1   20     0   13   127 108 *                     235.0 187 7 7 1   20     0   13   127 108                 235
1126602 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_2 195 10 3 1   15     0   9   119 114                       233 195 10 3 1   15     0   9   119 114                 233
935647 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No 1 02 03 2016   grade_2 178 1 9 1   26     0   15   118 112                       230 178 1 9 1   26     0   15   118 112                 230
2040010 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_2 149 3 30 0   37     0   11   113 117                       230.0 149 3 30 0   37     0   11   113 117                 230
2042862 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2019   grade_2 184 3 12 0   20     0   10   118 111                       229.0 184 3 12 0   20     0   10   118 111                 229
1675930 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield - Everett W Robinson   Regular School No Elementary KG 02 2021   grade_2 172 9 16 0   12     0   14   115 108 *                     223.0 172 9 16 0   12     0   14   115 108                 223
934691 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2016   grade_2 206 0 9 0   2     0   5   114 108                       222 206 0 9 0   2     0   5   114 108                 222
737837 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2015   grade_2 211 1 4 0   1     0   4   104 117                       221 211 1 4 0   1     0   4   104 117                 221
1129972 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_2 161 17 14 2   3     0   23   118 102                       220 161 17 14 2   3     0   23   118 102                 220
932735 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   grade_2 156 2 19 5   29     0   8   116 103                       219 156 2 19 5   29     0   8   116 103                 219
1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
1125528 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2017   grade_2 174 3 9 0   24     0   9   106 113                       219 174 3 9 0   24     0   9   106 113                 219
1365105 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_2 125 11 10 0   51     0   20   94 123 *                     217.0 125 11 10 0   51     0   20   94 123                 217
935543 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2016   grade_2 180 2 15 1   12     0   6   106 110                       216 180 2 15 1   12     0   6   106 110                 216
2235515 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich: Forestdale School   Regular School No Elementary PK 02 2018   grade_2 195 3 9 0   6     1   0   106 108                       214.0 195 3 9 0   6     1   0   106 108                 214
742472 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   grade_2 167 15 10 2   3     0   16   118 95                       213 167 15 10 2   3     0   16   118 95                 213
1131901 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   grade_2 178 16 8 0   2     0   9   114 99                       213 178 16 8 0   2     0   9   114 99                 213
2232343 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston: Placentino Elementary   Regular School No Elementary PK 02 2018   grade_2 173 2 10 1   20     0   7   116 97                       213.0 173 2 10 1   20     0   7   116 97                 213
2238732 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham: Mitchell Elementary School   Regular School No Elementary PK 03 2018   grade_2 190 9 0 0   3     0   11   108 105                       213.0 190 9 0 0   3     0   11   108 105                 213
2235690 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_2 73 7 17 0   108     0   7   110 102                       212.0 73 7 17 0   108     0   7   110 102                 212
738698 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2015   grade_2 183 0 12 0   7     0   8   109 101                       210 183 0 12 0   7     0   8   109 101                 210
1367781 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   grade_2 164 0 13 2   18     0   13   109 101 *                     210.0 164 0 13 2   18     0   13   109 101                 210
935227 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_2 197 2 3 0   3     2   2   105 104                       209 197 2 3 0   3     2   2   105 104                 209
938213 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No 1 PK 02 2016   grade_2 190 4 3 1   6     0   3   102 105                       207 190 4 3 1   6     0   3   102 105                 207
1122333 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_2 137 14 10 0   35     0   10   103 103                       206 137 14 10 0   35     0   10   103 103                 206
2231298 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury: Chandler Elementary   Regular School No Elementary PK 02 2018   grade_2 188 2 8 0   2     0   6   100 106                       206.0 188 2 8 0   2     0   6   100 106                 206
1364983 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_2 118 7 27 0   43     0   9   103 101 *                     204.0 118 7 27 0   43     0   9   103 101                 204
1674856 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover - Center Elementary   Regular School No Elementary 02 04 2021   grade_2 187 2 7 0   5     0   3   112 92 *                     204.0 187 2 7 0   5     0   3   112 92                 204
938359 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_2 94 4 9 1   86     0   8   100 102                       202 94 4 9 1   86     0   8   100 102                 202
939279 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2016   grade_2 150 18 6 5   2     0   21   86 116                       202 150 18 6 5   2     0   21   86 116                 202
1672206 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland - Henry E Warren Elementary   Regular School No Elementary KG 02 2021   grade_2 121 7 28 1   37     0   8   112 90 *                     202.0 121 7 28 1   37     0   8   112 90                 202
2043903 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2019   grade_2 173 1 14 0   6     0   8   116 86                       202.0 173 1 14 0   6     0   8   116 86                 202
1672329 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford - Lt Elezer Davis   Regular School No Elementary PK 02 2021   grade_2 109 12 10 0   54     0   16   115 86 *                     201.0 109 12 10 0   54     0   16   115 86                 201
2045662 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_2 67 5 11 1   111     0   6   111 90                       201.0 67 5 11 1   111     0   6   111 90                 201
2229139 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   grade_2 123 12 14 0   36     0   16   98 103                       201.0 123 12 14 0   36     0   16   98 103                 201
1124085 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_2 19 15 162 0   1     0   3   107 93                       200 19 15 162 0   1     0   3   107 93                 200
735859 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2015   grade_2 146 4 16 0   28     0   5   95 104                       199 146 4 16 0   28     0   5   95 104                 199
937430 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No 1 02 04 2016   grade_2 172 0 20 0   1     0   6   115 84                       199 172 0 20 0   1     0   6   115 84                 199
1366915 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   grade_2 183 1 6 0   0     0   9   100 99 *                     199.0 183 1 6 0   0     0   9   100 99                 199
932854 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2016   grade_2 142 10 5 0   33     0   8   101 97                       198 142 10 5 0   33     0   8   101 97                 198
2040130 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_2 126 13 9 0   34     0   15   100 97                       197.0 126 13 9 0   34     0   15   100 97                 197
2236787 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham: John William Decas   Regular School No Elementary KG 02 2018   grade_2 139 9 16 4   1     0   27   105 91                       196.0 139 9 16 4   1     0   27   105 91                 196
2233604 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield: Ralph Wheelock School   Regular School No Elementary 02 03 2018   grade_2 170 5 5 0   9     0   6   95 100                       195.0 170 5 5 0   9     0   6   95 100                 195
1366975 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   grade_2 151 1 24 0   8     0   9   97 96 *                     193.0 151 1 24 0   8     0   9   97 96                 193
2041985 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2019   grade_2 183 0 3 0   2     0   5   91 102                       193.0 183 0 3 0   2     0   5   91 102                 193
1676083 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield - Ralph Wheelock School   Regular School No Elementary 02 03 2021   grade_2 170 1 4 1   11     0   5   102 90 *                     192.0 170 1 4 1   11     0   5   102 90                 192
936215 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No 1 02 03 2016   grade_2 158 2 25 0   0     0   6   94 97                       191 158 2 25 0   0     0   6   94 97                 191
1371528 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2020   grade_2 131 16 20 2   1     0   21   103 88 *                     191.0 131 16 20 2   1     0   21   103 88                 191
1125098 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_2 129 6 30 1   0     0   24   103 87                       190 129 6 30 1   0     0   24   103 87                 190
1128869 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_2 65 5 13 2   95     0   10   98 92                       190 65 5 13 2   95     0   10   98 92                 190
1679799 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_2 14 88 77 0   4     0   7   83 107 *                     190.0 14 88 77 0   4     0   7   83 107                 190
935205 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 02 04 2016   grade_2 136 6 28 0   2     1   16   112 77                       189 136 6 28 0   2     1   16   112 77                 189
2228994 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland: Henry E Warren Elementary   Regular School No Elementary KG 02 2018   grade_2 123 3 24 0   31     1   7   92 97                       189.0 123 3 24 0   31     1   7   92 97                 189
934472 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2016   grade_2 148 5 28 0   3     0   4   107 81                       188 148 5 28 0   3     0   4   107 81                 188
1370442 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   grade_2 165 0 14 0   3     1   5   92 96 *                     188.0 165 0 14 0   3     1   5   92 96                 188
741554 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_2 73 1 21 0   85     0   7   99 88                       187 73 1 21 0   85     0   7   99 88                 187
934751 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2016   grade_2 156 6 6 0   12     0   7   88 99                       187 156 6 6 0   12     0   7   88 99                 187
1368832 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2020   grade_2 165 4 5 0   4     0   9   81 106 *                     187.0 165 4 5 0   4     0   9   81 106                 187
1372536 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_2 4 95 81 0   5     0   2   91 96 *                     187.0 4 95 81 0   5     0   2   91 96                 187
934357 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_2 14 11 154 1   4     0   2   99 87                       186 14 11 154 1   4     0   2   99 87                 186
2045516 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2019   grade_2 165 1 10 1   5     0   4   91 95                       186.0 165 1 10 1   5     0   4   91 95                 186
1677693 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich - Forestdale School   Regular School No Elementary PK 02 2021   grade_2 167 5 6 0   7     0   0   90 95 *                     185.0 167 5 6 0   7     0   0   90 95                 185
2047611 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_2 8 103 68 0   4     0   2   84 101                       185.0 8 103 68 0   4     0   2   84 101                 185
1131202 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_2 14 95 63 2   5     0   4   86 97                       183 14 95 63 2   5     0   4   86 97                 183
1124553 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2017   grade_2 144 4 19 0   10     0   5   109 73                       182 144 4 19 0   10     0   5   109 73                 182
2231927 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   grade_2 116 9 38 0   4     0   15   81 101                       182.0 116 9 38 0   4     0   15   81 101                 182
1128693 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   grade_2 169 3 6 0   2     0   1   94 87                       181 169 3 6 0   2     0   1   94 87                 181
1367443 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2020   grade_2 108 4 53 0   4     0   11   92 88 *                     180.0 108 4 53 0   4     0   11   92 88                 180
1370587 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_2 57 11 18 4   77     0   13   102 78 *                     180.0 57 11 18 4   77     0   13   102 78                 180
1677838 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_2 57 6 10 5   93     0   9   93 87 *                     180.0 57 6 10 5   93     0   9   93 87                 180
2238030 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_2 8 99 68 0   2     0   3   81 99                       180.0 8 99 68 0   2     0   3   81 99                 180
735980 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   grade_2 138 11 8 0   21     0   1   97 82                       179 138 11 8 0   21     0   1   97 82                 179
2042514 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_2 124 2 39 0   3     0   11   83 96                       179.0 124 2 39 0   3     0   11   83 96                 179
2231370 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 East Longmeadow: Meadow Brook   Regular School No Elementary PK 02 2018   grade_2 142 2 18 0   9     0   7   92 86                       178.0 142 2 18 0   9     0   7   92 86                 178
737897 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2015   grade_2 144 6 15 0   7     0   5   91 86                       177 144 6 15 0   7     0   5   91 86                 177
739368 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No 1 02 03 2015   grade_2 152 4 14 0   1     0   6   101 76                       177 152 4 14 0   1     0   6   101 76                 177
2042046 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2019   grade_2 140 1 16 0   11     0   9   99 78                       177.0 140 1 16 0   11     0   9   99 78                 177
1124481 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2017   grade_2 156 0 2 0   2     0   16   94 82                       176 156 0 2 0   2     0   16   94 82                 176
2048238 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2019   grade_2 148 15 3 0   5     0   5   86 90                       176.0 148 15 3 0   5     0   5   86 90                 176
744117 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No 1 02 04 2015   grade_2 159 5 3 0   3     0   5   107 68                       175 159 5 3 0   3     0   5   107 68                 175
932872 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2016   grade_2 164 1 5 0   2     0   3   87 88                       175 164 1 5 0   2     0   3   87 88                 175
1674145 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury - Chandler Elementary   Regular School No Elementary PK 02 2021   grade_2 166 1 3 0   1     0   4   94 81 *                     175.0 166 1 3 0   1     0   4   94 81                 175
1126783 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2017   grade_2 148 2 14 3   5     0   2   102 72                       174 148 2 14 3   5     0   2   102 72                 174
740600 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No 1 02 04 2015   grade_2 146 1 15 0   1     0   10   84 89                       173 146 1 15 0   1     0   10   84 89                 173
744244 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No 1 02 04 2015   grade_2 150 1 14 1   2     1   4   92 81                       173 150 1 14 1   2     1   4   92 81                 173

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