Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by ccd_school_high_grade

View and edit SQL

year

grade

  • kindergarten · 6,714
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
933037 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2016   kindergarten 4 39 15 1   6     1   0   33 33                       66 4 39 15 1   6     1   0   33 33                 66
933040 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2016   kindergarten 11 8 13 0   7     0   2   23 18                       41 11 8 13 0   7     0   2   23 18                 41
933052 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2016   kindergarten 3 10 18 0   0     0   3   20 14                       34 3 10 18 0   0     0   3   20 14                 34
933060 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No 1 PK 01 2016   kindergarten 19 3 47 0   0     0   1   34 36                       70 19 3 47 0   0     0   1   34 36                 70
933063 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2016   kindergarten 1 27 27 2   2     0   1   32 28                       60 1 27 27 2   2     0   1   32 28                 60
933086 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No 1 PK 01 2016   kindergarten 2 35 6 0   3     0   1   30 17                       47 2 35 6 0   3     0   1   30 17                 47
934631 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2016   kindergarten 90 1 5 0   2     0   1   54 45                       99 90 1 5 0   2     0   1   54 45                 99
935091 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No 1 KG 01 2016   kindergarten 46 4 13 0   11     0   5   41 38                       79 46 4 13 0   11     0   5   41 38                 79
935208 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   kindergarten 120 5 26 0   4     0   17   76 96                       172 120 5 26 0   4     0   17   76 96                 172
935279 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2016   kindergarten 91 2 3 0   21     0   2   59 60                       119 91 2 3 0   21     0   2   59 60                 119
935282 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2016   kindergarten 84 0 4 0   13     1   10   58 54                       112 84 0 4 0   13     1   10   58 54                 112
935552 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK 01 2016   kindergarten 16 4 16 0   1     0   3   14 26                       40 16 4 16 0   1     0   3   14 26                 40
935645 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2016   kindergarten 163 0 5 0   29     0   10   102 105                       207 163 0 5 0   29     0   10   102 105                 207
936212 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2016   kindergarten 112 1 21 1   1     2   5   72 71                       143 112 1 21 1   1     2   5   72 71                 143
936476 MA Essex   school 2507260 168   Marblehead 250726001120 1680015 Elbridge Gerry   Regular School No 1 KG 01 2016   kindergarten 66 0 5 0   3     1   3   40 38                       78 66 0 5 0   3     1   3   40 38                 78
936601 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2016   kindergarten 152 3 3 0   6     0   4   83 85                       168 152 3 3 0   6     0   4   83 85                 168
936663 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No 1 PK 01 2016   kindergarten 153 1 2 0   4     0   2   90 72                       162 153 1 2 0   4     0   2   90 72                 162
937433 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No 1 PK 01 2016   kindergarten 139 0 19 0   0     0   7   67 98                       165 139 0 19 0   0     0   7   67 98                 165
938351 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No 1 KG 01 2016   kindergarten 103 5 21 2   99     0   6   126 110                       236 103 5 21 2   99     0   6   126 110                 236
938498 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No 1 PK 01 2016   kindergarten 94 2 7 0   21     0   4   77 51                       128 94 2 7 0   21     0   4   77 51                 128
938528 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2016   kindergarten 116 2 11 1   2     0   3   74 61                       135 116 2 11 1   2     0   3   74 61                 135
938614 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No 1 PK 01 2016   kindergarten 10 17 31 0   0     0   3   40 21                       61 10 17 31 0   0     0   3   40 21                 61
940836 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No 1 KG 01 2016   kindergarten 79 0 1 0   0     0   2   43 39                       82 79 0 1 0   0     0   2   43 39                 82
940949 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No 1 KG 01 2016   kindergarten 134 9 1 0   4     0   1   74 75                       149 134 9 1 0   4     0   1   74 75                 149
941065 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No 1 PK 01 2016   kindergarten 100 3 16 0   0     0   2   58 63                       121 100 3 16 0   0     0   2   58 63                 121
941068 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No 1 PK 01 2016   kindergarten 117 0 11 0   4     0   0   77 55                       132 117 0 11 0   4     0   0   77 55                 132
941175 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No 1 PK 01 2016   kindergarten 49 0 5 1   0     0   8   33 30                       63 49 0 5 1   0     0   8   33 30                 63
941222 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No 1 PK 01 2016   kindergarten 110 3 8 0   1     0   7   70 59                       129 110 3 8 0   1     0   7   70 59                 129
941391 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Center   Regular School No 1 KG 01 2016   kindergarten 70 1 4 0   0     0   1   42 34                       76 70 1 4 0   0     0   1   42 34                 76
941565 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2016   kindergarten 22 0 3 0   0     0   1   8 18                       26 22 0 3 0   0     0   1   8 18                 26
941617 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No 1 KG 01 2016   kindergarten 6 0 0 0   0     0   0   5 1                       6 6 0 0 0   0     0   0   5 1                 6
942001 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes 1 KG 01 2016   kindergarten 2 6 43 0   2     0   1   25 29                       54 2 6 43 0   2     0   1   25 29                 54
1122557 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2017   kindergarten 10 10 16 0   8     0   1   30 15                       45 10 10 16 0   8     0   1   30 15                 45
1122571 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2017   kindergarten 9 10 15 1   1     0   1   16 21                       37 9 10 15 1   1     0   1   16 21                 37
1122581 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2017   kindergarten 13 7 42 0   1     0   2   37 28                       65 13 7 42 0   1     0   2   37 28                 65
1122585 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2017   kindergarten 1 37 27 0   1     0   6   39 33                       72 1 37 27 0   1     0   6   39 33                 72
1124075 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2017   kindergarten 39 38 477 1   1     0   1   290 267                       557 39 38 477 1   1     0   1   290 267                 557
1124410 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2017   kindergarten 75 0 2 0   0     0   2   44 35                       79 75 0 2 0   0     0   2   44 35                 79
1125102 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   kindergarten 139 1 37 0   1     0   16   86 108                       194 139 1 37 0   1     0   16   86 108                 194
1125200 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2017   kindergarten 93 1 5 0   20     0   7   73 53                       126 93 1 5 0   20     0   7   73 53                 126
1125204 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2017   kindergarten 86 1 8 1   7     0   5   52 56                       108 86 1 8 1   7     0   5   52 56                 108
1125647 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No Elementary KG 01 2017   kindergarten 186 1 4 1   30     0   2   111 113                       224 186 1 4 1   30     0   2   111 113                 224
1126310 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2017   kindergarten 129 4 13 0   0     0   1   83 64                       147 129 4 13 0   0     0   1   83 64                 147
1126625 MA Essex   school 2507260 168   Marblehead 250726001120 1680015 Elbridge Gerry   Regular School No Elementary KG 01 2017   kindergarten 61 1 10 0   1     0   1   40 34                       74 61 1 10 0   1     0   1   40 34                 74
1126776 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2017   kindergarten 150 2 12 0   6     0   6   99 77                       176 150 2 12 0   6     0   6   99 77                 176
1126850 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2017   kindergarten 132 1 5 0   3     0   3   68 76                       144 132 1 5 0   3     0   3   68 76                 144
1127762 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2017   kindergarten 128 0 14 1   4     0   9   82 74                       156 128 0 14 1   4     0   9   82 74                 156
1127945 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2017   kindergarten 119 4 14 0   0     0   8   76 69                       145 119 4 14 0   0     0   8   76 69                 145
1128859 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2017   kindergarten 95 2 13 0   128     0   11   137 112                       249 95 2 13 0   128     0   11   137 112                 249
1129031 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2017   kindergarten 78 1 4 1   19     0   11   59 55                       114 78 1 4 1   19     0   11   59 55                 114
1129069 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2017   kindergarten 120 1 17 0   3     0   7   69 79                       148 120 1 17 0   3     0   7   69 79                 148
1129168 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2017   kindergarten 6 9 23 0   0     0   1   25 14                       39 6 9 23 0   0     0   1   25 14                 39
1131778 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2017   kindergarten 64 1 6 0   0     0   0   39 32                       71 64 1 6 0   0     0   0   39 32                 71
1131904 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2017   kindergarten 147 10 0 0   5     0   4   82 84                       166 147 10 0 0   5     0   4   82 84                 166
1132050 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2017   kindergarten 82 2 9 0   0     0   2   51 44                       95 82 2 9 0   0     0   2   51 44                 95
1132054 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2017   kindergarten 131 2 8 0   0     0   6   79 68                       147 131 2 8 0   0     0   6   79 68                 147
1132182 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2017   kindergarten 35 0 8 0   1     1   7   29 23                       52 35 0 8 0   1     1   7   29 23                 52
1132238 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2017   kindergarten 123 4 4 0   4     0   6   66 75                       141 123 4 4 0   4     0   6   66 75                 141
1132434 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Center   Regular School No Elementary KG 01 2017   kindergarten 71 0 3 0   1     0   2   43 34                       77 71 0 3 0   1     0   2   43 34                 77
1132637 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   kindergarten 19 0 0 0   0     0   0   8 11                       19 19 0 0 0   0     0   0   8 11                 19
1132701 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   kindergarten 6 0 0 0   0     0   0   4 *                       6 6 0 0 0   0     0   0   4                   6
1365271 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2020   kindergarten 13 10 9 0   5     0   3   26 14 *                     40.0 13 10 9 0   5     0   3   26 14                 40
1365283 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2020   kindergarten 2 10 9 0   4     0   4   18 11 *                     29.0 2 10 9 0   4     0   4   18 11                 29
1365291 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten 15 1 45 0   1     1   0   28 35 *                     63.0 15 1 45 0   1     1   0   28 35                 63
1365294 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2020   kindergarten 3 27 36 1   5     0   2   40 34 *                     74.0 3 27 36 1   5     0   2   40 34                 74
1365687 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2020   kindergarten 30 15 14 0   6     1   1   25 41 *                     67.0 30 15 14 0   6     1   1   25 41                 67
1366569 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   kindergarten 30 20 442 1   0     0   2   261 234 *                     495.0 30 20 442 1   0     0   2   261 234                 495
1366856 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2020   kindergarten 86 1 9 0   0     0   2   49 49 *                     98.0 86 1 9 0   0     0   2   49 49                 98
1367446 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   kindergarten 118 7 39 0   2     0   10   100 76 *                     176.0 118 7 39 0   2     0   10   100 76                 176
1367514 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2020   kindergarten 96 4 6 0   22     0   2   71 59 *                     130.0 96 4 6 0   22     0   2   71 59                 130
1367517 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2020   kindergarten 88 1 4 0   10     0   4   43 64 *                     107.0 88 1 4 0   10     0   4   43 64                 107
1367602 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 01 2020   kindergarten 191 2 1 0   3     0   1   97 101 *                     198.0 191 2 1 0   3     0   1   97 101                 198
1367880 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2020   kindergarten 160 2 14 0   79     0   13   144 124 *                     268.0 160 2 14 0   79     0   13   144 124                 268
1368427 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2020   kindergarten 124 3 25 0   5     0   4   88 73 *                     161.0 124 3 25 0   5     0   4   88 73                 161
1368827 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2020   kindergarten 172 5 4 0   5     0   9   88 107 *                     195.0 172 5 4 0   5     0   9   88 107                 195
1368884 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2020   kindergarten 124 2 13 0   4     0   2   68 77 *                     145.0 124 2 13 0   4     0   2   68 77                 145
1369657 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2020   kindergarten 147 0 11 0   0     0   4   89 73 *                     162.0 147 0 11 0   0     0   4   89 73                 162
1369812 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2020   kindergarten 78 0 17 0   1     0   6   46 56 *                     102.0 78 0 17 0   1     0   6   46 56                 102
1370579 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2020   kindergarten 97 6 18 1   123     0   5   131 119 *                     250.0 97 6 18 1   123     0   5   131 119                 250
1370725 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2020   kindergarten 95 4 9 1   24     2   5   84 56 *                     140.0 95 4 9 1   24     2   5   84 56                 140
1370739 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2020   kindergarten 52 2 107 0   4     0   2   73 94 *                     167.0 52 2 107 0   4     0   2   73 94                 167
1370756 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2020   kindergarten 87 7 23 0   5     0   4   64 62 *                     126.0 87 7 23 0   5     0   4   64 62                 126
1373055 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2020   kindergarten 75 1 6 0   0     0   4   41 45 *                     86.0 75 1 6 0   0     0   4   41 45                 86
1373175 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2020   kindergarten 137 8 6 0   4     0   9   79 85 *                     164.0 137 8 6 0   4     0   9   79 85                 164
1373295 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2020   kindergarten 88 2 12 0   0     0   2   48 56 *                     104.0 88 2 12 0   0     0   2   48 56                 104
1373298 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2020   kindergarten 127 1 12 0   0     0   2   77 65 *                     142.0 127 1 12 0   0     0   2   77 65                 142
1373406 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2020   kindergarten 35 1 12 0   0     0   3   26 25 *                     51.0 35 1 12 0   0     0   3   26 25                 51
1373457 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2020   kindergarten 125 3 9 1   3     0   7   77 71 *                     148.0 125 3 9 1   3     0   7   77 71                 148
1373804 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2020   kindergarten 23 1 1 0   0     0   0   14 11 *                     25.0 23 1 1 0   0     0   0   14 11                 25
1373850 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2020   kindergarten 8 0 1 0   1     0   0   * 6 *                     10.0 8 0 1 0   1     0   0     6                 10
1672493 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston - Baldwin Early Learning Center   Regular School No Elementary PK 01 2021   kindergarten 5 5 15 0   12     0   5   22 20 *                     42.0 5 5 15 0   12     0   5   22 20                 42
1672505 MA Suffolk   school 2502790 35   Boston 250279002514 350006 Boston - ELC - West Zone   Regular School No Elementary PK 01 2021   kindergarten 3 10 11 0   1     0   1   12 14 *                     26.0 3 10 11 0   1     0   1   12 14                 26
1672513 MA Suffolk   school 2502790 35   Boston 250279001118 350009 Boston - East Boston Early Childhood Center   Regular School No Elementary PK 01 2021   kindergarten 11 5 36 0   1     0   3   23 33 *                     56.0 11 5 36 0   1     0   3   23 33                 56
1672516 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Boston - Haynes Early Education Center   Regular School No Elementary PK 01 2021   kindergarten 1 24 30 0   1     0   6   31 31 *                     62.0 1 24 30 0   1     0   6   31 31                 62
1672921 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Boston - Dr. William Henderson Lower   Regular School No Elementary PK 01 2021   kindergarten 18 22 12 0   5     1   6   29 35 *                     64.0 18 22 12 0   5     1   6   29 35                 64
1673800 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea - Shurtleff Early Childhood   Regular School No Elementary PK 01 2021   kindergarten 36 30 404 2   0     0   5   230 247 *                     477.0 36 30 404 2   0     0   5   230 247                 477
1674085 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas - Douglas Primary School   Regular School No Elementary PK 01 2021   kindergarten 57 0 2 0   0     0   1   27 33 *                     60.0 57 0 2 0   0     0   1   27 33                 60
1674680 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner - Waterford Street   Regular School No Elementary PK 01 2021   kindergarten 100 5 36 0   7     0   5   72 81 *                     153.0 100 5 36 0   7     0   5   72 81                 153
1674764 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 Grafton - South Grafton Elementary   Regular School No Elementary PK 01 2021   kindergarten 70 5 9 1   18     0   1   53 51 *                     104.0 70 5 9 1   18     0   1   53 51                 104
1674767 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 Grafton - North Grafton Elementary   Regular School No Elementary PK 01 2021   kindergarten 77 4 6 0   13     0   0   57 43 *                     100.0 77 4 6 0   13     0   0   57 43                 100

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