Data source: Big Local News · About: Big Local

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

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
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
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
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
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
735658 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2015   kindergarten 138 2 3 2   3     0   0   80 68                       148 138 2 3 2   3     0   0   80 68                 148
932536 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2016   kindergarten 98 2 7 0   1     0   2   50 60                       110 98 2 7 0   1     0   2   50 60                 110
1121946 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   kindergarten 115 5 12 0   2     0   0   73 61                       134 115 5 12 0   2     0   0   73 61                 134
1364787 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   kindergarten 131 9 22 1   4     0   2   82 86 *                     169.0 131 9 22 1   4     0   2   82 86                 169
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
2039813 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   kindergarten 130 10 5 1   6     0   1   79 74                       153.0 130 10 5 1   6     0   1   79 74                 153
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
743921 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2015   kindergarten 25 0 1 0   14     0   1   27 14                       41 25 0 1 0   14     0   1   27 14                 41
743929 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No 1 PK 06 2015   kindergarten 42 0 1 0   12     0   2   27 30                       57 42 0 1 0   12     0   2   27 30                 57
743937 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No 1 KG 06 2015   kindergarten 38 2 6 1   11     0   2   33 27                       60 38 2 6 1   11     0   2   33 27                 60
743944 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2015   kindergarten 46 0 0 0   12     0   3   35 26                       61 46 0 0 0   12     0   3   35 26                 61
743951 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No 1 KG 06 2015   kindergarten 28 3 0 1   28     0   1   29 32                       61 28 3 0 1   28     0   1   29 32                 61
743958 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2015   kindergarten 11 2 0 0   25     0   2   24 16                       40 11 2 0 0   25     0   2   24 16                 40
940754 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2016   kindergarten 27 0 1 0   15     0   4   27 20                       47 27 0 1 0   15     0   4   27 20                 47
940762 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No 1 PK 06 2016   kindergarten 43 2 1 0   9     0   0   29 26                       55 43 2 1 0   9     0   0   29 26                 55
940770 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No 1 KG 06 2016   kindergarten 40 1 5 0   7     0   2   23 32                       55 40 1 5 0   7     0   2   23 32                 55
940777 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2016   kindergarten 43 0 0 0   6     0   5   26 28                       54 43 0 0 0   6     0   5   26 28                 54
940784 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No 1 KG 06 2016   kindergarten 16 2 1 0   30     0   3   30 22                       52 16 2 1 0   30     0   3   30 22                 52
940791 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2016   kindergarten 10 2 3 0   21     0   0   21 15                       36 10 2 3 0   21     0   0   21 15                 36
1131686 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   kindergarten 41 0 1 0   16     0   2   31 29                       60 41 0 1 0   16     0   2   31 29                 60
1131694 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   kindergarten 45 2 4 0   7     0   5   26 37                       63 45 2 4 0   7     0   5   26 37                 63
1131702 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   kindergarten 49 1 5 0   2     0   6   34 29                       63 49 1 5 0   2     0   6   34 29                 63
1131710 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   kindergarten 33 0 2 0   8     0   3   19 27                       46 33 0 2 0   8     0   3   19 27                 46
1131718 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   kindergarten 17 0 3 0   18     0   2   22 18                       40 17 0 3 0   18     0   2   22 18                 40
1131726 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   kindergarten 23 2 4 0   25     0   4   28 30                       58 23 2 4 0   25     0   4   28 30                 58
1372981 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2020   kindergarten 27 4 4 0   13     0   4   26 26 *                     52.0 27 4 4 0   13     0   4   26 26                 52
1372988 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2020   kindergarten 36 1 3 0   8     0   5   27 26 *                     53.0 36 1 3 0   8     0   5   27 26                 53
1372995 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2020   kindergarten 40 1 5 1   6     0   2   26 29 *                     55.0 40 1 5 1   6     0   2   26 29                 55
1373002 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2020   kindergarten 32 2 3 0   14     0   5   29 27 *                     56.0 32 2 3 0   14     0   5   29 27                 56
1373009 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2020   kindergarten 10 1 2 0   16     0   7   16 20 *                     36.0 10 1 2 0   16     0   7   16 20                 36
1373016 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2020   kindergarten 15 2 8 0   28     0   1   32 22 *                     54.0 15 2 8 0   28     0   1   32 22                 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
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
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
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
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
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
2048053 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   kindergarten 44 0 6 0   17     0   3   29 41                       70.0 44 0 6 0   17     0   3   29 41                 70
2048060 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   kindergarten 40 0 3 0   9     0   7   25 34                       59.0 40 0 3 0   9     0   7   25 34                 59
2048067 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   kindergarten 44 3 5 0   5     0   5   34 28                       62.0 44 3 5 0   5     0   5   34 28                 62
2048074 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   kindergarten 29 2 0 0   5     0   5   24 17                       41.0 29 2 0 0   5     0   5   24 17                 41
2048081 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   kindergarten 15 1 2 0   19     0   2   24 15                       39.0 15 1 2 0   19     0   2   24 15                 39
2048088 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   kindergarten 16 2 3 0   37     0   1   35 24                       59.0 16 2 3 0   37     0   1   35 24                 59
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
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
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
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
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
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
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
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
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
743971 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2015   kindergarten 29 3 0 0   0     0   1   16 17                       33 29 3 0 0   0     0   1   16 17                 33
743978 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No 1 KG 05 2015   kindergarten 74 4 3 0   0     2   0   50 33                       83 74 4 3 0   0     2   0   50 33                 83
940804 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2016   kindergarten 27 0 0 0   1     0   0   14 14                       28 27 0 0 0   1     0   0   14 14                 28
940811 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No 1 KG 05 2016   kindergarten 56 2 2 0   0     0   4   28 36                       64 56 2 2 0   0     0   4   28 36                 64
1131742 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   kindergarten 28 0 0 0   0     0   0   14 14                       28 28 0 0 0   0     0   0   14 14                 28
1131750 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No Elementary KG 05 2017   kindergarten 60 3 0 0   0     0   2   35 30                       65 60 3 0 0   0     0   2   35 30                 65
1373030 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2020   kindergarten 81 0 6 0   1     0   0   46 42 *                     88.0 81 0 6 0   1     0   0   46 42                 88
1680294 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Regional - Hoosac Valley Elementary School   Regular School No Elementary PK 03 2021   kindergarten 62 3 3 0   1     0   4   38 35 *                     73.0 62 3 3 0   1     0   4   38 35                 73
2048103 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2019   kindergarten 73 1 1 0   0     0   4   37 42                       79.0 73 1 1 0   0     0   4   37 42                 79
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
735684 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   kindergarten 44 0 7 0   2     0   1   32 22                       54 44 0 7 0   2     0   1   32 22                 54
735689 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   kindergarten 75 0 0 0   1     0   0   48 28                       76 75 0 0 0   1     0   0   48 28                 76
735694 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2015   kindergarten 55 3 8 0   3     0   2   38 33                       71 55 3 8 0   3     0   2   38 33                 71
735699 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No 1 KG 04 2015   kindergarten 44 4 3 0   1     0   0   26 26                       52 44 4 3 0   1     0   0   26 26                 52
932562 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2016   kindergarten 28 1 9 0   0     0   2   25 15                       40 28 1 9 0   0     0   2   25 15                 40
932567 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2016   kindergarten 57 2 1 0   2     0   0   39 23                       62 57 2 1 0   2     0   0   39 23                 62
932572 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2016   kindergarten 64 0 6 0   1     0   3   41 33                       74 64 0 6 0   1     0   3   41 33                 74
932577 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No 1 KG 04 2016   kindergarten 52 1 7 0   1     0   1   30 32                       62 52 1 7 0   1     0   1   30 32                 62
1121979 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2017   kindergarten 56 1 2 0   0     1   0   28 32                       60 56 1 2 0   0     1   0   28 32                 60
1121985 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2017   kindergarten 85 0 3 0   2     0   1   38 53                       91 85 0 3 0   2     0   1   38 53                 91
1121991 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2017   kindergarten 66 2 6 0   1     0   3   45 33                       78 66 2 6 0   1     0   3   45 33                 78
1121997 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2017   kindergarten 53 2 8 0   2     0   2   43 24                       67 53 2 8 0   2     0   2   43 24                 67
1364810 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   kindergarten 45 1 7 0   4     0   1   24 34 *                     58.0 45 1 7 0   4     0   1   24 34                 58
1364815 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   kindergarten 57 1 5 0   3     0   1   36 31 *                     67.0 57 1 5 0   3     0   1   36 31                 67
1364820 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   kindergarten 58 1 12 0   2     0   8   39 42 *                     81.0 58 1 12 0   2     0   8   39 42                 81
1364825 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   kindergarten 42 0 6 0   6     0   3   28 29 *                     57.0 42 0 6 0   6     0   3   28 29                 57
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
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
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
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
2039836 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   kindergarten 27 1 8 0   3     0   0   22 17                       39.0 27 1 8 0   3     0   0   22 17                 39
2039841 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   kindergarten 52 0 3 0   2     0   1   36 22                       58.0 52 0 3 0   2     0   1   36 22                 58
2039846 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   kindergarten 60 2 8 0   3     0   4   37 40                       77.0 60 2 8 0   3     0   4   37 40                 77
2039851 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   kindergarten 56 0 4 0   4     0   2   33 33                       66.0 56 0 4 0   4     0   2   33 33                 66
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
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
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

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