Data source: Big Local News · About: Big Local

3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by school

View and edit SQL

year

grade

  • pre_kindergarten · 3,669
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
2230203 MA Suffolk   school   35   Boston   350652               2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
1368484 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 2 1 1 0   2     0   1   6 1 *                     7.0 2 1 1 0   2     0   1   6 1                 7
738204 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   pre_kindergarten 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
935058 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   pre_kindergarten 12 0 0 0   0     0   0   7 5                       12 12 0 0 0   0     0   0   7 5                 12
1124920 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   pre_kindergarten 10 1 0 0   0     0   0   6 5                       11 10 1 0 0   0     0   0   6 5                 11
1367291 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   pre_kindergarten 22 0 0 0   0     0   0   15 7 *                     22.0 22 0 0 0   0     0   0   15 7                 22
2042361 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   pre_kindergarten 17 0 0 0   0     0   0   9 8                       17.0 17 0 0 0   0     0   0   9 8                 17
1672008 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington - Abington Early Education Program   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 44 4 2 0   1     0   0   28 23 *                     51.0 44 4 2 0   1     0   0   28 23                 51
1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
2039810 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 71 9 9 0   1     0   0   45 45                       90.0 71 9 9 0   1     0   0   45 45                 90
2228754 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 70 9 1 0   4     0   0   45 39                       84.0 70 9 1 0   4     0   0   45 39                 84
739263 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2015   pre_kindergarten 6 3 9 0   18     0   3   25 14                       39 6 3 9 0   18     0   3   25 14                 39
741228 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   pre_kindergarten 49 2 25 1   4     0   0   39 42                       81 49 2 25 1   4     0   0   39 42                 81
936110 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No 1 PK 04 2016   pre_kindergarten 4 1 14 0   34     0   1   33 21                       54 4 1 14 0   34     0   1   33 21                 54
938056 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2016   pre_kindergarten 61 2 20 0   9     0   3   39 56                       95 61 2 20 0   9     0   3   39 56                 95
1126186 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   pre_kindergarten 7 0 11 0   27     0   4   28 21                       49 7 0 11 0   27     0   4   28 21                 49
1128500 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   pre_kindergarten 51 4 24 0   12     0   3   49 45                       94 51 4 24 0   12     0   3   49 45                 94
1368314 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2020   pre_kindergarten 9 0 8 0   24     0   5   30 16 *                     46.0 9 0 8 0   24     0   5   30 16                 46
1370284 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2020   pre_kindergarten 59 3 29 0   3     0   1   54 41 *                     95.0 59 3 29 0   3     0   1   54 41                 95
2043396 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   pre_kindergarten 6 2 10 0   28     0   1   23 24                       47.0 6 2 10 0   28     0   1   23 24                 47
2045356 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   pre_kindergarten 66 0 34 0   1     0   0   61 40                       101.0 66 0 34 0   1     0   0   61 40                 101
1680244 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Acton-Boxborough - Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 33 5 5 0   26     0   4   44 29 *                     73.0 33 5 5 0   26     0   4   44 29                 73
2238521 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Acton-Boxborough: Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 44 8 6 0   48     0   5   64 47                       111.0 44 8 6 0   48     0   5   64 47                 111
1672024 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten 25 1 1 0   0     0   1   16 12 *                     28.0 25 1 1 0   0     0   1   16 12                 28
735674 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   pre_kindergarten 48 0 1 0   0     0   2   27 24                       51 48 0 1 0   0     0   2   27 24                 51
932552 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   pre_kindergarten 45 0 2 0   0     0   1   29 19                       48 45 0 2 0   0     0   1   29 19                 48
1121966 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten 43 2 2 0   1     0   2   25 25                       50 43 2 2 0   1     0   2   25 25                 50
1364800 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 39 1 4 0   0     0   2   28 18 *                     46.0 39 1 4 0   0     0   2   28 18                 46
2039825 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten 44 0 1 0   0     0   1   22 24                       46.0 44 0 1 0   0     0   1   22 24                 46
2228774 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten 48 0 2 0   0     0   1   30 21                       51.0 48 0 2 0   0     0   1   30 21                 51
737949 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No 1 PK PK 2015   pre_kindergarten 52 35 79 0   20     0   5   91 100                       191 52 35 79 0   20     0   5   91 100                 191
934801 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No 1 PK PK 2016   pre_kindergarten 68 37 71 0   15     1   2   94 100                       194 68 37 71 0   15     1   2   94 100                 194
1124616 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Elementary PK PK 2017   pre_kindergarten 62 34 92 0   17     0   4   120 89                       209 62 34 92 0   17     0   4   120 89                 209
1367028 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 26 23 67 0   10     0   1   65 62 *                     127.0 26 23 67 0   10     0   1   65 62                 127
2042100 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 44 36 97 0   13     0   4   114 80                       194.0 44 36 97 0   13     0   4   114 80                 194
2238580 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Adams-Cheshire: Hoosac Valley Elementary School   Regular School No Elementary PK 03 2018   pre_kindergarten 51 1 1 0   0     0   0   22 31                       53.0 51 1 1 0   0     0   0   22 31                 53
1368457 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1672033 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam - Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 77 3 16 0   7     0   3   59 47 *                     106.0 77 3 16 0   7     0   3   59 47                 106
735683 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 154 2 7 0   2     0   0   105 60                       165 154 2 7 0   2     0   0   105 60                 165
932561 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 145 7 10 0   3     0   3   95 73                       168 145 7 10 0   3     0   3   95 73                 168
1121977 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 108 7 19 0   13     0   4   87 64                       151 108 7 19 0   13     0   4   87 64                 151
1364809 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 114 6 18 0   15     0   7   93 67 *                     160.0 114 6 18 0   15     0   7   93 67                 160
2039835 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 131 3 12 0   13     0   3   79 83                       162.0 131 3 12 0   13     0   3   79 83                 162
2228785 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 121 3 22 0   14     0   3   88 75                       163.0 121 3 22 0   14     0   3   88 75                 163
741637 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   pre_kindergarten 13 0 3 0   1     0   1   13 5                       18 13 0 3 0   1     0   1   13 5                 18
938440 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   pre_kindergarten 6 1 9 0   2     0   0   8 10                       18 6 1 9 0   2     0   0   8 10                 18
1128966 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   pre_kindergarten 12 0 3 0   2     0   0   4 13                       17 12 0 3 0   2     0   0   4 13                 17
1370667 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2020   pre_kindergarten 12 0 2 0   3     0   1   7 11 *                     18.0 12 0 2 0   3     0   1   7 11                 18
2045742 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   pre_kindergarten 13 0 2 0   3     0   0   11 7                       18.0 13 0 2 0   3     0   0   11 7                 18
737640 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2015   pre_kindergarten * * * *   *     *   *   3 2                       5                         3 2                 5
934499 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2016   pre_kindergarten * * * *   *     *   *   3 1                       4                         3 1                 4
1124253 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   pre_kindergarten 3 1 1 0   0     0   1   4 2                       6 3 1 1 0   0     0   1   4 2                 6
1366721 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2020   pre_kindergarten 7 0 0 0   0     0   0   2 5 *                     7.0 7 0 0 0   0     0   0   2 5                 7
2041790 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2019   pre_kindergarten 6 1 0 0   0     0   1   5 3                       8.0 6 1 0 0   0     0   1   5 3                 8
741843 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   pre_kindergarten 13 27 41 0   1     0   3   41 44                       85 13 27 41 0   1     0   3   41 44                 85
938649 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   pre_kindergarten 19 25 43 0   1     0   5   45 48                       93 19 25 43 0   1     0   5   45 48                 93
1129209 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   pre_kindergarten 17 17 38 0   0     0   4   32 44                       76 17 17 38 0   0     0   4   32 44                 76
1370878 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2020   pre_kindergarten 19 13 36 1   0     0   5   37 37 *                     74.0 19 13 36 1   0     0   5   37 37                 74
2045952 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   pre_kindergarten 20 13 47 0   0     0   2   38 44                       82.0 20 13 47 0   0     0   2   38 44                 82
740179 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2015   pre_kindergarten 69 10 64 0   1     0   8   88 64                       152 69 10 64 0   1     0   8   88 64                 152
937023 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2016   pre_kindergarten 41 8 59 0   0     0   7   72 43                       115 41 8 59 0   0     0   7   72 43                 115
1127275 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   pre_kindergarten 8 7 12 0   0     1   1   16 13                       29 8 7 12 0   0     1   1   16 13                 29
937584 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No 1 PK 02 2016   pre_kindergarten 57 1 3 0   1     0   1   41 22                       63 57 1 3 0   1     0   1   41 22                 63
1127946 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2017   pre_kindergarten 55 0 6 1   1     0   0   35 28                       63 55 0 6 1   1     0   0   35 28                 63
1369813 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2020   pre_kindergarten 34 1 7 0   1     0   3   26 20 *                     46.0 34 1 7 0   1     0   3   26 20                 46
2044885 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   pre_kindergarten 30 0 7 0   0     0   2   25 14                       39.0 30 0 7 0   0     0   2   25 14                 39
742786 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 01 2015   pre_kindergarten 70 0 1 0   0     0   2   41 32                       73 70 0 1 0   0     0   2   41 32                 73
939592 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 02 2016   pre_kindergarten 56 0 2 0   0     0   2   36 24                       60 56 0 2 0   0     0   2   36 24                 60
1130344 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2017   pre_kindergarten 44 0 0 0   0     0   1   23 22                       45 44 0 0 0   0     0   1   23 22                 45
1371822 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2020   pre_kindergarten 48 0 3 0   0     0   1   26 26 *                     52.0 48 0 3 0   0     0   1   26 26                 52
2046895 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   pre_kindergarten 46 0 2 0   0     0   0   30 18                       48.0 46 0 2 0   0     0   0   30 18                 48
741045 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 73 16 10 0   43     0   7   92 57                       149 73 16 10 0   43     0   7   92 57                 149
937874 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 62 15 7 0   55     0   9   101 47                       148 62 15 7 0   55     0   9   101 47                 148
1128282 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 59 12 8 0   80     1   10   98 72                       170 59 12 8 0   80     1   10   98 72                 170
1370100 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 62 16 18 1   76     0   10   109 74 *                     183.0 62 16 18 1   76     0   10   109 74                 183
2045174 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 15 11 3   88     1   8   107 70                       177.0 51 15 11 3   88     1   8   107 70                 177
1672063 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 13 0 1 0   0     0   0   10 4 *                     14.0 13 0 1 0   0     0   0   10 4                 14
1672069 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 11 0 0 0   0     0   0   7 4 *                     11.0 11 0 0 0   0     0   0   7 4                 11
735715 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 22 4 3 0   0     0   0   14 15                       29 22 4 3 0   0     0   0   14 15                 29
932593 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2016   pre_kindergarten 25 1 2 0   1     0   1   18 12                       30 25 1 2 0   1     0   1   18 12                 30
1122017 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten 21 0 4 0   0     0   1   16 10                       26 21 0 4 0   0     0   1   16 10                 26
1364839 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 32 0 1 0   0     0   0   18 15 *                     33.0 32 0 1 0   0     0   0   18 15                 33
2039865 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 27 0 1 0   0     0   0   16 12                       28.0 27 0 1 0   0     0   0   16 12                 28
2228823 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten 23 0 1 0   0     1   0   14 11                       25.0 23 0 1 0   0     1   0   14 11                 25
2228830 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten 26 0 2 0   0     0   0   17 11                       28.0 26 0 2 0   0     0   0   17 11                 28
1672087 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 14 3 10 0   4     0   1   23 9 *                     32.0 14 3 10 0   4     0   1   23 9                 32
2228852 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 23 5 15 0   14     0   8   36 29                       65.0 23 5 15 0   14     0   8   36 29                 65
737310 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   pre_kindergarten 11 2 10 0   4     0   1   13 15                       28 11 2 10 0   4     0   1   13 15                 28
934170 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2016   pre_kindergarten 14 2 9 0   0     0   1   13 13                       26 14 2 9 0   0     0   1   13 13                 26
1123864 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   pre_kindergarten 14 3 12 0   2     0   3   13 21                       34 14 3 12 0   2     0   3   13 21                 34
1366388 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   pre_kindergarten 10 1 15 0   2     0   2   13 17 *                     30.0 10 1 15 0   2     0   2   13 17                 30
2041457 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   pre_kindergarten 17 1 10 0   0     0   3   14 17                       31.0 17 1 10 0   0     0   3   14 17                 31
1672120 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover - Shawsheen School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 36 0 5 0   9     0   4   34 20 *                     54.0 36 0 5 0   9     0   4   34 20                 54
2228890 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover: Shawsheen School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 47 2 7 0   27     0   2   61 24                       85.0 47 2 7 0   27     0   2   61 24                 85
737710 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No 1 PK KG 2015   pre_kindergarten 53 3 1 2   2     0   1   38 24                       62 53 3 1 2   2     0   1   38 24                 62
934569 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No 1 PK KG 2016   pre_kindergarten 64 2 1 0   2     0   1   41 29                       70 64 2 1 0   2     0   1   41 29                 70
1124334 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No Elementary PK KG 2017   pre_kindergarten 61 1 0 0   1     0   3   38 28                       66 61 1 0 0   1     0   3   38 28                 66
1366792 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No Elementary PK KG 2020   pre_kindergarten 64 1 4 0   1     0   7   53 24 *                     77.0 64 1 4 0   1     0   7   53 24                 77
2041861 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No Elementary PK KG 2019   pre_kindergarten 68 0 3 0   1     0   6   41 37                       78.0 68 0 3 0   1     0   6   41 37                 78
740960 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No 1 PK 03 2015   pre_kindergarten 41 1 7 0   5     0   0   32 22                       54 41 1 7 0   5     0   0   32 22                 54

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