Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • kindergarten · 6,747
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
2230202 MA Suffolk   school   35   Boston   350652               2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
739411 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2015   kindergarten 8 6 56 0   13     0   5   51 37                       88 8 6 56 0   13     0   5   51 37                 88
936259 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2016   kindergarten 8 5 42 0   16     0   2   37 36                       73 8 5 42 0   16     0   2   37 36                 73
1126367 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   kindergarten 8 4 40 1   5     0   3   25 36                       61 8 4 40 1   5     0   3   25 36                 61
1368483 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   kindergarten 5 6 59 0   5     0   2   39 38 *                     77.0 5 6 59 0   5     0   2   39 38                 77
2043555 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2019   kindergarten 10 1 48 1   15     0   0   40 35                       75.0 10 1 48 1   15     0   0   40 35                 75
740306 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2015   kindergarten 43 1 4 0   11     0   6   27 38                       65 43 1 4 0   11     0   6   27 38                 65
937142 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No 1 KG 05 2016   kindergarten 50 3 1 0   7     0   1   30 32                       62 50 3 1 0   7     0   1   30 32                 62
1127418 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   kindergarten 55 0 2 0   13     0   8   40 38                       78 55 0 2 0   13     0   8   40 38                 78
1369370 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   kindergarten 43 0 3 0   11     0   8   29 36 *                     65.0 43 0 3 0   11     0   8   29 36                 65
2044443 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2019   kindergarten 60 3 2 0   11     0   8   43 41                       84.0 60 3 2 0   11     0   8   43 41                 84
741211 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2015   kindergarten 40 5 31 0   7     1   2   40 46                       86 40 5 31 0   7     1   2   40 46                 86
938039 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No 1 KG 05 2016   kindergarten 55 2 39 0   8     0   2   54 52                       106 55 2 39 0   8     0   2   54 52                 106
1128480 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   kindergarten 57 2 51 0   6     0   2   67 51                       118 57 2 51 0   6     0   2   67 51                 118
1370267 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   kindergarten 34 2 53 0   7     0   3   59 40 *                     99.0 34 2 53 0   7     0   3   59 40                 99
2045340 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2019   kindergarten 62 0 55 0   8     0   3   70 58                       128.0 62 0 55 0   8     0   3   70 58                 128
735870 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   kindergarten 56 0 33 0   2     0   0   44 47                       91 56 0 33 0   2     0   0   44 47                 91
932746 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   kindergarten 49 3 16 0   2     1   9   44 36                       80 49 3 16 0   2     1   9   44 36                 80
1122203 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   kindergarten 35 7 26 0   0     0   5   38 35                       73 35 7 26 0   0     0   5   38 35                 73
1364994 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   kindergarten 55 7 11 1   1     0   2   35 42 *                     77.0 55 7 11 1   1     0   2   35 42                 77
2040021 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2019   kindergarten 55 5 18 0   4     0   5   40 47                       87.0 55 5 18 0   4     0   5   40 47                 87
738203 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   kindergarten 6 0 0 0   0     0   1   3 4                       7 6 0 0 0   0     0   1   3 4                 7
935057 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   kindergarten 8 0 0 0   0     0   0   4 4                       8 8 0 0 0   0     0   0   4 4                 8
1124919 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   kindergarten 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1367290 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   kindergarten 7 0 0 0   0     0   0   3 4 *                     7.0 7 0 0 0   0     0   0   3 4                 7
2042362 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   kindergarten 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
1679923 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   kindergarten 16 60 7 4   8     0   22   49 68 *                     117.0 16 60 7 4   8     0   22   49 68                 117
2238158 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   kindergarten 17 54 30 1   6     0   9   46 71                       117.0 17 54 30 1   6     0   9   46 71                 117
743602 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   kindergarten 29 63 14 0   2     0   9   62 55                       117 29 63 14 0   2     0   9   62 55                 117
940425 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   kindergarten 30 54 20 0   2     0   5   55 56                       111 30 54 20 0   2     0   5   55 56                 111
1131326 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   kindergarten 25 52 34 0   5     0   0   56 60                       116 25 52 34 0   5     0   0   56 60                 116
1372659 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   kindergarten 31 59 7 1   5     0   11   52 62 *                     114.0 31 59 7 1   5     0   11   52 62                 114
2047730 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   kindergarten 18 55 35 2   2     0   5   55 62                       117.0 18 55 35 2   2     0   5   55 62                 117
1672011 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   kindergarten 124 10 23 0   4     0   12   79 94 *                     173.0 124 10 23 0   4     0   12   79 94                 173
2228759 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   kindergarten 113 6 13 2   3     0   0   67 70                       137.0 113 6 13 2   3     0   0   67 70                 137
742677 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   kindergarten 21 0 7 0   2     0   1   17 14                       31 21 0 7 0   2     0   1   17 14                 31
939483 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2016   kindergarten 21 2 6 0   4     0   0   15 18                       33 21 2 6 0   4     0   0   15 18                 33
1130211 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   kindergarten 30 0 7 0   2     0   1   23 17                       40 30 0 7 0   2     0   1   23 17                 40
1371726 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   kindergarten 19 0 11 0   5     0   3   21 17 *                     38.0 19 0 11 0   5     0   3   21 17                 38
2046800 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2019   kindergarten 16 1 13 0   9     0   3   24 18                       42.0 16 1 13 0   9     0   3   24 18                 42
739405 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2015   kindergarten 15 3 12 1   1     0   1   16 17                       33 15 3 12 1   1     0   1   16 17                 33
936253 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No 1 KG 05 2016   kindergarten 17 3 7 0   1     0   6   15 19                       34 17 3 7 0   1     0   6   15 19                 34
1126360 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   kindergarten 7 7 9 0   4     0   4   13 18                       31 7 7 9 0   4     0   4   13 18                 31
1368477 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2020   kindergarten 11 6 14 0   4     0   2   19 18 *                     37.0 11 6 14 0   4     0   2   19 18                 37
2043549 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2019   kindergarten 14 3 18 0   5     0   5   17 28                       45.0 14 3 18 0   5     0   5   17 28                 45
739262 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   kindergarten 12 6 31 0   46     0   3   44 54                       98 12 6 31 0   46     0   3   44 54                 98
740209 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   kindergarten 59 15 38 0   0     0   11   67 56                       123 59 15 38 0   0     0   11   67 56                 123
741227 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   kindergarten 38 4 50 0   2     0   0   41 53                       94 38 4 50 0   2     0   0   41 53                 94
936109 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2016   kindergarten 16 6 30 1   32     0   1   51 35                       86 16 6 30 1   32     0   1   51 35                 86
937047 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   kindergarten 80 10 43 1   1     0   8   69 74                       143 80 10 43 1   1     0   8   69 74                 143
938055 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2016   kindergarten 54 2 35 0   1     0   0   50 42                       92 54 2 35 0   1     0   0   50 42                 92
1126185 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   kindergarten 3 3 25 0   55     0   3   50 39                       89 3 3 25 0   55     0   3   50 39                 89
1127305 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   kindergarten 63 14 38 0   0     0   4   52 67                       119 63 14 38 0   0     0   4   52 67                 119
1128499 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   kindergarten 36 2 40 0   2     0   2   40 42                       82 36 2 40 0   2     0   2   40 42                 82
1368313 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   kindergarten 13 2 30 0   39     0   2   36 50 *                     86.0 13 2 30 0   39     0   2   36 50                 86
1369270 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   kindergarten 39 9 41 0   2     0   9   52 48 *                     100.0 39 9 41 0   2     0   9   52 48                 100
1370283 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   kindergarten 34 5 42 1   1     0   2   43 42 *                     85.0 34 5 42 1   1     0   2   43 42                 85
2043397 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   kindergarten 13 1 31 0   44     0   4   49 44                       93.0 13 1 31 0   44     0   4   49 44                 93
2044343 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   kindergarten 48 10 39 0   0     0   8   59 46                       105.0 48 10 39 0   0     0   8   59 46                 105
2045357 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   kindergarten 35 1 46 0   4     0   2   52 36                       88.0 35 1 46 0   4     0   2   52 36                 88
742877 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2015   kindergarten 40 4 6 0   4     0   2   29 27                       56 40 4 6 0   4     0   2   29 27                 56
939682 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2016   kindergarten 32 1 3 0   1     0   2   20 19                       39 32 1 3 0   1     0   2   20 19                 39
1130455 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   kindergarten 46 1 3 0   9     0   2   36 25                       61 46 1 3 0   9     0   2   36 25                 61
1371910 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2020   kindergarten 32 2 8 0   4     1   10   28 29 *                     57.0 32 2 8 0   4     1   10   28 29                 57
2046985 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2019   kindergarten 37 2 6 0   7     0   2   27 27                       54.0 37 2 6 0   7     0   2   27 27                 54
1680245 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough - Blanchard Memorial School   Regular School No Elementary KG 06 2021   kindergarten 35 2 8 0   18     0   6   38 31 *                     69.0 35 2 8 0   18     0   6   38 31                 69
1680266 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough - C.T. Douglas Elementary School   Regular School No Elementary KG 06 2021   kindergarten 34 3 6 0   3     0   5   31 20 *                     51.0 34 3 6 0   3     0   5   31 20                 51
1680280 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough - Luther Conant School   Regular School No Elementary KG 06 2021   kindergarten 5 2 1 0   22     0   4   17 17 *                     34.0 5 2 1 0   22     0   4   17 17                 34
1680259 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough - McCarthy-Towne School   Regular School No Elementary KG 06 2021   kindergarten 30 2 6 0   8     0   5   22 29 *                     51.0 30 2 6 0   8     0   5   22 29                 51
1680252 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough - Merriam School   Regular School No Elementary KG 06 2021   kindergarten 28 3 4 0   7     0   5   21 26 *                     47.0 28 3 4 0   7     0   5   21 26                 47
1680273 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough - Paul P Gates Elementary School   Regular School No Elementary KG 06 2021   kindergarten 9 1 1 0   23     0   0   19 15 *                     34.0 9 1 1 0   23     0   0   19 15                 34
2238523 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   kindergarten 50 0 5 0   18     0   5   37 41                       78.0 50 0 5 0   18     0   5   37 41                 78
2238547 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   kindergarten 25 1 1 0   4     0   7   21 17                       38.0 25 1 1 0   4     0   7   21 17                 38
2238563 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   kindergarten 10 0 8 0   37     0   5   35 25                       60.0 10 0 8 0   37     0   5   35 25                 60
2238539 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   kindergarten 54 3 7 0   10     0   1   46 29                       75.0 54 3 7 0   10     0   1   46 29                 75
2238531 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   kindergarten 39 1 7 0   10     0   3   33 27                       60.0 39 1 7 0   10     0   3   33 27                 60
2238555 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   kindergarten 14 2 1 0   21     0   3   25 16                       41.0 14 2 1 0   21     0   3   25 16                 41
1672023 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   kindergarten 71 0 11 0   0     0   4   48 38 *                     86.0 71 0 11 0   0     0   4   48 38                 86
735673 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   kindergarten 92 0 4 0   0     0   0   45 51                       96 92 0 4 0   0     0   0   45 51                 96
932551 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   kindergarten 89 0 1 0   0     0   2   48 44                       92 89 0 1 0   0     0   2   48 44                 92
1121965 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   kindergarten 75 1 4 1   0     0   3   43 41                       84 75 1 4 1   0     0   3   43 41                 84
1364799 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   kindergarten 79 1 5 0   1     0   3   51 38 *                     89.0 79 1 5 0   1     0   3   51 38                 89
2039826 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   kindergarten 113 0 2 0   1     0   5   60 61                       121.0 113 0 2 0   1     0   5   60 61                 121
2228773 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   kindergarten 96 3 6 0   1     0   2   55 53                       108.0 96 3 6 0   1     0   2   55 53                 108
2238579 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Adams-Cheshire: Hoosac Valley Elementary School   Regular School No Elementary PK 03 2018   kindergarten 74 3 3 0   0     0   5   48 37                       85.0 74 3 3 0   0     0   5   48 37                 85
1368456 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1672039 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   kindergarten 54 0 3 0   1     0   5   36 27 *                     63.0 54 0 3 0   1     0   5   36 27                 63
1672034 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   kindergarten 34 0 7 0   3     0   0   23 21 *                     44.0 34 0 7 0   3     0   0   23 21                 44
1672049 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   kindergarten 37 3 5 0   3     0   0   24 24 *                     48.0 37 3 5 0   3     0   0   24 24                 48
1672044 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   kindergarten 55 2 13 0   0     0   2   37 35 *                     72.0 55 2 13 0   0     0   2   37 35                 72
2228793 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam: Benjamin J Phelps   Regular School No Elementary KG 04 2018   kindergarten 54 1 6 0   3     0   4   41 27                       68.0 54 1 6 0   3     0   4   41 27                 68
2228787 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam: Clifford M Granger   Regular School No Elementary KG 04 2018   kindergarten 27 1 7 0   0     0   1   15 21                       36.0 27 1 7 0   0     0   1   15 21                 36
2228805 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam: James Clark School   Regular School No Elementary KG 04 2018   kindergarten 46 2 6 0   1     0   2   26 31                       57.0 46 2 6 0   1     0   2   26 31                 57
2228799 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam: Robinson Park   Regular School No Elementary KG 04 2018   kindergarten 53 3 10 0   3     0   3   37 35                       72.0 53 3 10 0   3     0   3   37 35                 72
741636 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   kindergarten 24 1 9 0   6     0   5   25 20                       45 24 1 9 0   6     0   5   25 20                 45
938439 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   kindergarten 28 2 11 0   2     0   4   29 18                       47 28 2 11 0   2     0   4   29 18                 47
1128965 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   kindergarten 19 0 11 0   8     0   2   20 20                       40 19 0 11 0   8     0   2   20 20                 40
1370666 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2020   kindergarten 37 0 24 0   6     0   4   34 37 *                     71.0 37 0 24 0   6     0   4   34 37                 71
2045743 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   kindergarten 34 2 6 0   2     0   3   18 29                       47.0 34 2 6 0   2     0   3   18 29                 47
737639 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2015   kindergarten 53 7 7 0   3     0   6   37 39                       76 53 7 7 0   3     0   6   37 39                 76

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