Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by total_int descending

View and edit SQL

year

grade

  • grade_1 · 6,880
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 ▲
1367881 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2020   grade_1 181 0 17 0   79     0   18   146 149 *                     295.0 181 0 17 0   79     0   18   146 149                 295
1675126 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Hopkinton - Marathon Elementary School   Regular School No Elementary KG 01 2021   grade_1 159 1 14 0   89     0   15   145 133 *                     278.0 159 1 14 0   89     0   15   145 133                 278
2232465 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Hopkinton: Center   Regular School No Elementary KG 01 2018   grade_1 204 1 4 1   43     0   3   133 123                       256.0 204 1 4 1   43     0   3   133 123                 256
1373172 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2020   grade_1 208 13 16 0   5     0   12   138 116 *                     254.0 208 13 16 0   5     0   12   138 116                 254
739612 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2015   grade_1 211 4 14 0   12     0   8   133 116                       249 211 4 14 0   12     0   8   133 116                 249
2048233 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2019   grade_1 229 6 3 0   3     1   7   139 110                       249.0 229 6 3 0   3     1   7   139 110                 249
1680435 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham - Mitchell Elementary School   Regular School No Elementary PK 03 2021   grade_1 187 24 18 0   9     0   9   126 121 *                     247.0 187 24 18 0   9     0   9   126 121                 247
1126601 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_1 182 4 21 0   24     0   14   143 102                       245 182 4 21 0   24     0   14   143 102                 245
935646 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2016   grade_1 183 2 7 1   37     1   8   128 111                       239 183 2 7 1   37     1   8   128 111                 239
2238731 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham: Mitchell Elementary School   Regular School No Elementary PK 03 2018   grade_1 207 18 0 0   6     0   7   125 113                       238.0 207 18 0 0   6     0   7   125 113                 238
2233422 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield: Everett W Robinson   Regular School No Elementary KG 02 2018   grade_1 183 8 14 0   18     0   13   118 118                       236.0 183 8 14 0   18     0   13   118 118                 236
744112 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No 1 PK 03 2015   grade_1 205 10 11 0   2     0   7   120 115                       235 205 10 11 0   2     0   7   120 115                 235
2043754 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   grade_1 183 7 9 1   20     0   14   128 106                       234.0 183 7 9 1   20     0   14   128 106                 234
936457 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2016   grade_1 195 8 3 1   12     0   11   119 111                       230 195 8 3 1   12     0   11   119 111                 230
742471 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   grade_1 169 20 8 6   2     0   23   101 127                       228 169 20 8 6   2     0   23   101 127                 228
1368688 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2020   grade_1 178 10 12 0   14     0   14   119 109 *                     228.0 178 10 12 0   14     0   14   119 109                 228
738797 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2015   grade_1 175 2 10 0   25     0   15   110 117                       227 175 2 10 0   25     0   15   110 117                 227
939278 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2016   grade_1 166 18 14 1   2     0   26   124 103                       227 166 18 14 1   2     0   26   124 103                 227
2232342 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston: Placentino Elementary   Regular School No Elementary PK 02 2018   grade_1 183 2 11 0   20     0   11   117 110                       227.0 183 2 11 0   20     0   11   117 110                 227
1125648 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No Elementary KG 01 2017   grade_1 166 0 6 1   42     0   11   108 118                       226 166 0 6 1   42     0   11   108 118                 226
2042961 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2019   grade_1 144 2 6 0   62     0   12   111 115                       226.0 144 2 6 0   62     0   12   111 115                 226
1364982 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_1 131 6 29 1   44     0   11   126 96 *                     222.0 131 6 29 1   44     0   11   126 96                 222
2228993 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland: Henry E Warren Elementary   Regular School No Elementary KG 02 2018   grade_1 146 1 28 0   35     0   11   110 111                       221.0 146 1 28 0   35     0   11   110 111                 221
1128692 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   grade_1 199 3 8 0   5     1   0   107 109                       216 199 3 8 0   5     1   0   107 109                 216
1129971 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_1 156 10 15 2   2     0   30   115 100                       215 156 10 15 2   2     0   30   115 100                 215
932734 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   grade_1 160 5 9 4   29     0   5   99 113                       212 160 5 9 4   29     0   5   99 113                 212
940946 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No 1 PK 03 2016   grade_1 179 16 7 0   1     0   9   107 105                       212 179 16 7 0   1     0   9   107 105                 212
935542 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2016   grade_1 168 2 9 0   23     0   9   104 107                       211 168 2 9 0   23     0   9   104 107                 211
1674855 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Hanover - Cedar Elementary   Regular School No Elementary PK 01 2021   grade_1 201 3 3 0   3     0   1   105 106 *                     211.0 201 3 3 0   3     0   1   105 106                 211
1675929 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield - Everett W Robinson   Regular School No Elementary KG 02 2021   grade_1 162 10 11 1   16     1   10   109 101 *                     211.0 162 10 11 1   16     1   10   109 101                 211
2040129 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_1 121 13 8 0   50     0   19   92 119                       211.0 121 13 8 0   50     0   19   92 119                 211
737836 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2015   grade_1 195 1 6 0   2     0   3   109 98                       207 195 1 6 0   2     0   3   109 98                 207
1125527 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2017   grade_1 171 3 11 1   15     0   6   115 92                       207 171 3 11 1   15     0   6   115 92                 207
735858 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2015   grade_1 149 3 19 4   23     0   8   108 98                       206 149 3 19 4   23     0   8   108 98                 206
2042861 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2019   grade_1 160 1 13 0   19     0   13   107 99                       206.0 160 1 13 0   19     0   13   107 99                 206
738697 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2015   grade_1 171 2 15 1   12     0   4   103 102                       205 171 2 15 1   12     0   4   103 102                 205
1131900 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   grade_1 179 9 7 0   2     0   8   103 102                       205 179 9 7 0   2     0   8   103 102                 205
2040009 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_1 123 9 25 1   36     0   10   100 104                       204.0 123 9 25 1   36     0   10   100 104                 204
735979 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   grade_1 143 14 6 0   32     0   7   102 100                       202 143 14 6 0   32     0   7   102 100                 202
740605 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2015   grade_1 175 2 17 0   1     0   6   110 91                       201 175 2 17 0   1     0   6   110 91                 201
1122332 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_1 123 11 15 0   35     0   16   99 101                       200 123 11 15 0   35     0   16   99 101                 200
1124480 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2017   grade_1 183 2 7 0   2     0   6   99 101                       200 183 2 7 0   2     0   6   99 101                 200
1367604 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 01 2020   grade_1 183 1 8 0   5     0   3   107 93 *                     200.0 183 1 8 0   5     0   3   107 93                 200
2046601 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   grade_1 136 17 21 3   1     0   21   107 92                       199.0 136 17 21 3   1     0   21   107 92                 199
2229138 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   grade_1 129 9 10 0   35     0   16   102 97                       199.0 129 9 10 0   35     0   16   102 97                 199
932853 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2016   grade_1 138 12 11 0   29     1   7   100 98                       198 138 12 11 0   29     1   7   100 98                 198
934356 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_1 18 16 159 0   1     0   4   103 95                       198 18 16 159 0   1     0   4   103 95                 198
1365104 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_1 108 11 11 0   52     0   16   117 81 *                     198.0 108 11 11 0   52     0   16   117 81                 198
935210 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   grade_1 137 7 26 1   0     0   26   106 91                       197 137 7 26 1   0     0   26   106 91                 197
1679798 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_1 8 101 72 1   5     0   8   81 114 *                     195.0 8 101 72 1   5     0   8   81 114                 195
2233599 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Medfield: Memorial School   Regular School No Elementary PK 01 2018   grade_1 165 2 14 0   4     0   8   106 87                       193.0 165 2 14 0   4     0   8   106 87                 193
737611 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2015   grade_1 148 5 32 0   3     0   4   109 83                       192 148 5 32 0   3     0   4   109 83                 192
739367 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2015   grade_1 158 2 27 0   0     0   5   95 97                       192 158 2 27 0   0     0   5   95 97                 192
1675025 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston - Placentino Elementary   Regular School No Elementary PK 02 2021   grade_1 154 3 5 0   26     0   4   91 101 *                     192.0 154 3 5 0   26     0   4   91 101                 192
2042045 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2019   grade_1 153 1 26 0   5     0   7   99 93                       192.0 153 1 26 0   5     0   7   99 93                 192
1368829 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2020   grade_1 172 2 4 1   7     0   5   100 91 *                     191.0 172 2 4 1   7     0   5   100 91                 191
737496 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_1 18 11 156 1   2     0   2   98 92                       190 18 11 156 1   2     0   2   98 92                 190
1366914 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   grade_1 180 1 3 0   1     0   5   102 88 *                     190.0 180 1 3 0   1     0   5   102 88                 190
1370441 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   grade_1 171 4 7 0   7     0   1   90 100 *                     190.0 171 4 7 0   7     0   1   90 100                 190
2041984 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2019   grade_1 175 2 5 0   0     0   8   98 92                       190.0 175 2 5 0   0     0   8   98 92                 190
2042519 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   grade_1 121 7 45 0   7     0   10   97 93                       190.0 121 7 45 0   7     0   10   97 93                 190
1366156 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2020   grade_1 15 95 73 0   1     0   5   98 91 *                     189.0 15 95 73 0   1     0   5   98 91                 189
1372535 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_1 17 86 78 0   3     0   5   82 107 *                     189.0 17 86 78 0   3     0   5   82 107                 189
1676080 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Medfield - Memorial School   Regular School No Elementary PK 01 2021   grade_1 167 5 2 0   6     0   8   91 97 *                     188.0 167 5 2 0   6     0   8   91 97                 188
2235514 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich: Forestdale School   Regular School No Elementary PK 02 2018   grade_1 164 3 11 1   5     0   4   92 96                       188.0 164 3 11 1   5     0   4   92 96                 188
1122187 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_1 125 4 25 0   24     1   8   93 94                       187 125 4 25 0   24     1   8   93 94                 187
2043900 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2019   grade_1 164 4 6 0   4     0   9   82 105                       187.0 164 4 6 0   4     0   9   82 105                 187
1678779 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham - John William Decas   Regular School No Elementary PK 02 2021   grade_1 124 7 18 3   1     0   31   91 93 *                     184.0 124 7 18 3   1     0   31   91 93                 184
2238029 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_1 8 104 66 0   4     0   2   83 101                       184.0 8 104 66 0   4     0   2   83 101                 184
1126670 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No Elementary KG 04 2017   grade_1 84 8 61 4   20     0   6   101 82                       183 84 8 61 4   20     0   6   101 82                 183
1126778 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2017   grade_1 163 5 4 0   6     0   5   89 94                       183 163 5 4 0   6     0   5   89 94                 183
1672328 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford - Lt Elezer Davis   Regular School No Elementary PK 02 2021   grade_1 109 11 12 0   41     0   10   102 81 *                     183.0 109 11 12 0   41     0   10   102 81                 183
2231933 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner: Waterford Street   Regular School No Elementary PK 01 2018   grade_1 129 4 37 0   1     0   12   84 99                       183.0 129 4 37 0   1     0   12   84 99                 183
1131201 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_1 8 95 73 0   2     0   4   87 95                       182 8 95 73 0   2     0   4   87 95                 182
2231297 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury: Chandler Elementary   Regular School No Elementary PK 02 2018   grade_1 171 0 4 0   2     0   5   89 93                       182.0 171 0 4 0   2     0   5   89 93                 182
938212 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No 1 PK 02 2016   grade_1 174 3 1 0   3     0   0   93 88                       181 174 3 1 0   3     0   0   93 88                 181
1125104 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   grade_1 118 6 35 1   4     0   17   80 101                       181 118 6 35 1   4     0   17   80 101                 181
737072 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2015   grade_1 24 62 78 5   1     0   10   94 86                       180 24 62 78 5   1     0   10   94 86                 180
1672205 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland - Henry E Warren Elementary   Regular School No Elementary KG 02 2021   grade_1 105 4 20 0   46     0   5   103 77 *                     180.0 105 4 20 0   46     0   5   103 77                 180
2047610 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_1 4 92 76 0   5     0   2   86 93                       179.0 4 92 76 0   5     0   2   86 93                 179
2045515 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2019   grade_1 156 2 12 0   5     0   3   89 89                       178.0 156 2 12 0   5     0   3   89 89                 178
1367780 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   grade_1 150 2 9 0   12     1   3   103 73 *                     177.0 150 2 9 0   12     1   3   103 73                 177
737896 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2015   grade_1 149 4 6 0   11     0   6   81 95                       176 149 4 6 0   11     0   6   81 95                 176
937435 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2016   grade_1 149 1 15 0   1     0   9   81 94                       175 149 1 15 0   1     0   9   81 94                 175
739947 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 05 2015   grade_1 110 4 41 3   5     0   11   82 92                       174 110 4 41 3   5     0   11   82 92                 174
934750 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2016   grade_1 138 5 17 0   9     0   5   103 71                       174 138 5 17 0   9     0   5   103 71                 174
2041223 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2019   grade_1 25 80 59 0   0     0   8   93 79                       172.0 25 80 59 0   0     0   8   93 79                 172
735997 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_1 161 0 5 0   2     0   3   84 87                       171 161 0 5 0   2     0   3   84 87                 171
742954 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No 1 01 03 2015   grade_1 156 2 3 0   6     0   4   93 78                       171 156 2 3 0   6     0   4   93 78                 171
1366693 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 04 2020   grade_1 117 2 44 0   3     0   5   90 81 *                     171.0 117 2 44 0   3     0   5   90 81                 171
739759 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2015   grade_1 149 1 11 0   7     0   2   82 88                       170 149 1 11 0   7     0   2   82 88                 170
939356 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No 1 PK 04 2016   grade_1 112 6 40 1   0     1   10   92 78                       170 112 6 40 1   0     1   10   92 78                 170
1127002 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2017   grade_1 104 7 48 1   4     0   6   87 83                       170 104 7 48 1   4     0   6   87 83                 170
1674144 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury - Chandler Elementary   Regular School No Elementary PK 02 2021   grade_1 149 2 8 0   3     0   8   92 78 *                     170.0 149 2 8 0   3     0   8   92 78                 170
2231369 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 East Longmeadow: Meadow Brook   Regular School No Elementary PK 02 2018   grade_1 140 1 10 0   11     0   8   92 78                       170.0 140 1 10 0   11     0   8   92 78                 170
934360 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2016   grade_1 7 2 158 0   1     0   1   91 78                       169 7 2 158 0   1     0   1   91 78                 169
936791 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 06 2016   grade_1 112 6 40 2   1     0   8   91 78                       169 112 6 40 2   1     0   8   91 78                 169
1124552 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2017   grade_1 141 0 14 0   8     0   6   84 85                       169 141 0 14 0   8     0   6   84 85                 169
737500 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_1 10 6 149 0   1     0   2   79 89                       168 10 6 149 0   1     0   2   79 89                 168
1672012 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   grade_1 127 8 26 1   4     0   2   79 88 *                     168.0 127 8 26 1   4     0   2   79 88                 168

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