enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1675126 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
2040749 2040749 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   grade_1 11 12 8 0   82     0   3   58 58                       116.0 11 12 8 0   82     0   3   58 58                 116
2229858 2229858 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston: Josiah Quincy   Regular School No Elementary PK 05 2018   grade_1 11 13 13 0   80     0   3   61 59                       120.0 11 13 13 0   80     0   3   61 59                 120
1367881 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
1123054 1123054 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2017   grade_1 12 15 12 1   73     0   5   58 60                       118 12 15 12 1   73     0   5   58 60                 118
741070 741070 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2015   grade_1 41 11 7 0   68     2   6   88 47                       135 41 11 7 0   68     2   6   88 47                 135
1672940 1672940 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston - Josiah Quincy   Regular School No Elementary PK 05 2021   grade_1 11 13 11 0   68     0   10   54 59 *                     113.0 11 13 11 0   68     0   10   54 59                 113
933471 933471 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No 1 PK 05 2016   grade_1 16 24 13 0   67     0   2   54 68                       122 16 24 13 0   67     0   2   54 68                 122
1365706 1365706 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2020   grade_1 19 13 10 0   67     0   5   52 62 *                     114.0 19 13 10 0   67     0   5   52 62                 114
736603 736603 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No 1 PK 05 2015   grade_1 10 23 23 0   66     0   5   66 61                       127 10 23 23 0   66     0   5   66 61                 127
2042961 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
2235689 2235689 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_1 55 2 7 2   62     0   3   72 59                       131.0 55 2 7 2   62     0   3   72 59                 131
936123 936123 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No 1 PK 04 2016   grade_1 25 4 9 0   61     0   3   48 54                       102 25 4 9 0   61     0   3   48 54                 102
1126201 1126201 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2017   grade_1 13 5 9 1   61     0   2   47 44                       91 13 5 9 1   61     0   2   47 44                 91
1128868 1128868 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_1 56 2 10 0   61     0   5   70 64                       134 56 2 10 0   61     0   5   70 64                 134
739276 739276 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No 1 PK 04 2015   grade_1 23 2 12 0   60     0   2   63 36                       99 23 2 12 0   60     0   2   63 36                 99
1677837 1677837 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_1 41 2 8 0   60     0   3   53 61 *                     114.0 41 2 8 0   60     0   3   53 61                 114
1677373 1677373 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy - Clifford H Marshall Elementary   Regular School No Elementary KG 04 2021   grade_1 28 20 16 0   59     0   0   61 62 *                     123.0 28 20 16 0   59     0   0   61 62                 123
2045661 2045661 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_1 29 5 10 4   59     0   4   54 57                       111.0 29 5 10 4   59     0   4   54 57                 111
2233018 2233018 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Lowell: Charles W Morey   Regular School No Elementary PK 04 2018   grade_1 16 4 10 1   59     0   4   40 54                       94.0 16 4 10 1   59     0   4   40 54                 94
1368326 1368326 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2020   grade_1 14 3 12 0   58     0   6   37 56 *                     93.0 14 3 12 0   58     0   6   37 56                 93
1370136 1370136 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Montclair   Regular School No Elementary KG 05 2020   grade_1 15 3 4 0   58     0   3   41 42 *                     83.0 15 3 4 0   58     0   3   41 42                 83
1675571 1675571 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Lowell - Charles W Morey   Regular School No Elementary PK 04 2021   grade_1 13 2 7 0   56     0   3   50 31 *                     81.0 13 2 7 0   56     0   3   50 31                 81
2045199 2045199 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2019   grade_1 23 14 10 0   56     0   0   49 54                       103.0 23 14 10 0   56     0   0   49 54                 103
1370125 1370125 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2020   grade_1 35 15 12 0   54     0   1   47 70 *                     117.0 35 15 12 0   54     0   1   47 70                 117
936158 936158 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No 1 PK 04 2016   grade_1 10 4 27 0   53     0   5   58 41                       99 10 4 27 0   53     0   5   58 41                 99
1365104 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
2043410 2043410 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2019   grade_1 18 5 8 0   52     0   6   47 42                       89.0 18 5 8 0   52     0   6   47 42                 89
2233004 2233004 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Lowell: Abraham Lincoln   Regular School No Elementary PK 04 2018   grade_1 5 2 27 0   52     0   4   52 38                       90.0 5 2 27 0   52     0   4   52 38                 90
937899 937899 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2016   grade_1 37 11 11 0   51     8   3   60 61                       121 37 11 11 0   51     8   3   60 61                 121
2046745 2046745 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2019   grade_1 53 2 5 0   51     0   1   64 48                       112.0 53 2 5 0   51     0   1   64 48                 112
741106 741106 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No 1 KG 05 2015   grade_1 13 1 1 0   50     0   0   31 34                       65 13 1 1 0   50     0   0   31 34                 65
2040129 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
2236956 2236956 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 Westborough: J Harding Armstrong   Regular School No Elementary KG 03 2018   grade_1 49 1 10 0   50     0   5   59 56                       115.0 49 1 10 0   50     0   5   59 56                 115
739311 739311 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No 1 PK 04 2015   grade_1 4 1 31 0   49     0   8   44 49                       93 4 1 31 0   49     0   8   44 49                 93
1371675 1371675 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No Elementary KG 03 2020   grade_1 48 1 2 0   49     1   0   54 47 *                     101.0 48 1 2 0   49     1   0   54 47                 101
2232866 2232866 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Lexington: Maria Hastings   Regular School No Elementary KG 05 2018   grade_1 29 0 3 0   49     0   8   50 39                       89.0 29 0 3 0   49     0   8   50 39                 89
939551 939551 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No 1 KG 02 2016   grade_1 66 2 0 0   48     0   6   66 56                       122 66 2 0 0   48     0   6   66 56                 122
1370586 1370586 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_1 56 3 8 2   48     0   4   61 60 *                     121.0 56 3 8 2   48     0   4   61 60                 121
1677384 1677384 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Quincy - Montclair   Regular School No Elementary KG 05 2021   grade_1 12 2 5 0   48     0   3   36 34 *                     70.0 12 2 5 0   48     0   3   36 34                 70
1677831 1677831 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Shrewsbury - Beal School   Regular School No Elementary KG 01 2021   grade_1 17 0 9 0   48     0   3   42 35 *                     77.0 17 0 9 0   48     0   3   42 35                 77
2043398 2043398 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_1 13 1 23 0   48     0   6   52 39                       91.0 13 1 23 0   48     0   6   52 39                 91
2235133 2235133 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy: Clifford H Marshall Elementary   Regular School No Elementary KG 04 2018   grade_1 38 22 10 0   48     0   2   58 62                       120.0 38 22 10 0   48     0   2   58 62                 120
2047872 2047872 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2019   grade_1 53 29 21 1   47     0   4   78 77                       155.0 53 29 21 1   47     0   4   78 77                 155
936111 936111 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2016   grade_1 9 6 33 0   46     0   2   48 48                       96 9 6 33 0   46     0   2   48 48                 96
1126029 1126029 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2017   grade_1 34 3 2 0   46     0   5   48 42                       90 34 3 2 0   46     0   5   48 42                 90
1672205 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
2045210 2045210 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Montclair   Regular School No Elementary KG 05 2019   grade_1 14 3 0 0   46     0   2   29 36                       65.0 14 3 0 0   46     0   2   29 36                 65
2235146 2235146 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Quincy: Montclair   Regular School No Elementary KG 05 2018   grade_1 24 5 4 0   46     0   3   43 39                       82.0 24 5 4 0   46     0   3   43 39                 82
1126242 1126242 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2017   grade_1 7 3 22 1   45     0   5   50 33                       83 7 3 22 1   45     0   5   50 33                 83
1370580 1370580 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2020   grade_1 6 6 1 2   45     0   6   33 33 *                     66.0 6 6 1 2   45     0   6   33 33                 66
1680065 1680065 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   grade_1 70 20 13 0   45     0   11   72 87 *                     159.0 70 20 13 0   45     0   11   72 87                 159
2043362 2043362 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2019   grade_1 34 1 12 0   45     0   2   47 47                       94.0 34 1 12 0   45     0   2   47 47                 94
2235175 2235175 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Quincy: Wollaston School   Regular School No Elementary KG 05 2018   grade_1 15 0 0 0   45     0   2   37 25                       62.0 15 0 0 0   45     0   2   37 25                 62
938358 938358 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_1 43 2 7 0   44     0   8   52 52                       104 43 2 7 0   44     0   8   52 52                 104
1364982 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
1368315 1368315 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   grade_1 10 2 33 0   44     0   4   47 46 *                     93.0 10 2 33 0   44     0   4   47 46                 93
1677362 1677362 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_1 37 8 18 2   44     0   6   61 54 *                     115.0 37 8 18 2   44     0   6   61 54                 115
2045188 2045188 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2019   grade_1 31 12 10 1   44     2   5   46 59                       105.0 31 12 10 1   44     2   5   46 59                 105
736472 736472 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No 1 PK 05 2015   grade_1 4 22 36 0   43     0   3   59 49                       108 4 22 36 0   43     0   3   59 49                 108
739146 739146 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No 1 KG 05 2015   grade_1 25 2 5 1   43     0   3   40 39                       79 25 2 5 1   43     0   3   40 39                 79
739264 739264 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   grade_1 19 3 26 0   43     0   3   52 42                       94 19 3 26 0   43     0   3   52 42                 94
939427 939427 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No 1 KG 03 2016   grade_1 48 1 4 0   43     0   0   45 51                       96 48 1 4 0   43     0   0   45 51                 96
1372800 1372800 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_1 62 24 22 0   43     0   5   72 84 *                     156.0 62 24 22 0   43     0   5   72 84                 156
2232465 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
1125648 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
1128312 1128312 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2017   grade_1 40 7 8 0   42     1   2   55 45                       100 40 7 8 0   42     1   2   55 45                 100
1128325 1128325 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Montclair   Regular School No Elementary KG 05 2017   grade_1 20 2 5 0   42     0   1   33 37                       70 20 2 5 0   42     0   1   33 37                 70
1128332 1128332 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No Elementary KG 05 2017   grade_1 8 2 1 0   42     0   3   33 23                       56 8 2 1 0   42     0   3   33 23                 56
1368278 1368278 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2020   grade_1 22 8 19 0   42     0   4   52 43 *                     95.0 22 8 19 0   42     0   4   52 43                 95
1370114 1370114 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2020   grade_1 36 7 8 2   42     0   7   56 46 *                     102.0 36 7 8 2   42     0   7   56 46                 102
1672862 1672862 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_1 5 12 4 0   42     0   3   26 40 *                     66.0 5 12 4 0   42     0   3   26 40                 66
2046855 2046855 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary KG 02 2019   grade_1 69 1 3 0   42     0   4   59 60                       119.0 69 1 3 0   42     0   4   59 60                 119
2235684 2235684 MA Worcester   school 2510770 271   Shrewsbury 251077001713 2710015 Shrewsbury: Calvin Coolidge   Regular School No Elementary KG 04 2018   grade_1 41 4 13 0   42     0   8   55 53                       108.0 41 4 13 0   42     0   8   55 53                 108
1672328 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
2043263 2043263 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2019   grade_1 36 4 3 0   41     0   15   58 41                       99.0 36 4 3 0   41     0   15   58 41                 99
2043702 2043702 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_1 33 8 14 0   41     0   5   49 52                       101.0 33 8 14 0   41     0   5   49 52                 101
741081 741081 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Montclair   Regular School No 1 KG 05 2015   grade_1 20 3 3 0   40     1   3   39 31                       70 20 3 3 0   40     1   3   39 31                 70
741087 741087 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No 1 KG 05 2015   grade_1 11 0 1 0   40     0   1   30 23                       53 11 0 1 0   40     0   1   30 23                 53
1130141 1130141 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2017   grade_1 54 1 1 0   40     0   1   58 39                       97 54 1 1 0   40     0   1   58 39                 97
1365155 1365155 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No Elementary KG 04 2020   grade_1 42 0 2 0   40     0   6   44 46 *                     90.0 42 0 2 0   40     0   6   44 46                 90
1368636 1368636 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_1 44 9 20 0   40     0   1   55 59 *                     114.0 44 9 20 0   40     0   1   55 59                 114
2043446 2043446 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2019   grade_1 13 1 29 0   40     0   4   46 41                       87.0 13 1 29 0   40     0   4   46 41                 87
741547 741547 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No 1 KG 01 2015   grade_1 32 3 5 1   39     0   4   38 46                       84 32 3 5 1   39     0   4   38 46                 84
741553 741553 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_1 55 2 10 0   39     0   2   46 62                       108 55 2 10 0   39     0   2   46 62                 108
934048 934048 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_1 54 6 7 0   39     0   5   50 61                       111 54 6 7 0   39     0   5   50 61                 111
935968 935968 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   grade_1 48 6 3 1   39     0   0   52 45                       97 48 6 3 1   39     0   0   52 45                 97
937888 937888 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2016   grade_1 35 7 12 1   39     0   3   57 40                       97 35 7 12 1   39     0   3   57 40                 97
937910 937910 MA Norfolk   school 2509870 243   Quincy 250987001574 2430065 Montclair   Regular School No 1 KG 05 2016   grade_1 14 2 5 0   39     0   1   26 35                       61 14 2 5 0   39     0   1   26 35                 61
1128860 1128860 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2017   grade_1 22 1 6 0   39     0   1   39 30                       69 22 1 6 0   39     0   1   39 30                 69
1365629 1365629 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_1 7 11 14 0   39     0   1   40 32 *                     72.0 7 11 14 0   39     0   1   40 32                 72
1370161 1370161 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Wollaston School   Regular School No Elementary KG 05 2020   grade_1 18 0 0 0   39     0   1   31 27 *                     58.0 18 0 0 0   39     0   1   31 27                 58
1371680 1371680 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2020   grade_1 36 3 12 1   39     0   3   47 47 *                     94.0 36 3 12 1   39     0   3   47 47                 94
1675424 1675424 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington - Joseph Estabrook   Regular School No Elementary KG 05 2021   grade_1 25 2 6 0   39     0   7   42 37 *                     79.0 25 2 6 0   39     0   7   42 37                 79
1675442 1675442 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Lexington - Maria Hastings   Regular School No Elementary KG 05 2021   grade_1 25 1 3 0   39     0   8   40 36 *                     76.0 25 1 3 0   39     0   8   40 36                 76
2045216 2045216 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Francis W Parker   Regular School No Elementary KG 05 2019   grade_1 15 3 1 0   39     0   0   29 29                       58.0 15 3 1 0   39     0   0   29 29                 58
2048089 2048089 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_1 11 0 9 0   39     0   5   36 28                       64.0 11 0 9 0   39     0   5   36 28                 64
2232831 2232831 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Lexington: Bridge   Regular School No Elementary KG 05 2018   grade_1 35 6 5 0   39     0   1   45 41                       86.0 35 6 5 0   39     0   1   45 41                 86
2233059 2233059 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Lowell: Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2018   grade_1 9 5 34 0   39     0   6   46 47                       93.0 9 5 34 0   39     0   6   46 47                 93
2236961 2236961 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Westborough: Annie E Fales   Regular School No Elementary KG 03 2018   grade_1 43 0 3 0   39     0   3   36 52                       88.0 43 0 3 0   39     0   3   36 52                 88

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