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,647
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
934498 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2016   kindergarten 56 7 11 0   9     0   4   48 39                       87 56 7 11 0   9     0   4   48 39                 87
1124252 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   kindergarten 43 5 8 0   7     0   4   35 32                       67 43 5 8 0   7     0   4   35 32                 67
1366720 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2020   kindergarten 45 10 7 0   4     0   10   35 41 *                     76.0 45 10 7 0   4     0   10   35 41                 76
2041791 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2019   kindergarten 55 6 9 0   7     0   4   43 38                       81.0 55 6 9 0   7     0   4   43 38                 81
741842 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   kindergarten 8 16 17 0   1     0   2   25 19                       44 8 16 17 0   1     0   2   25 19                 44
938648 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   kindergarten 8 8 20 0   1     0   1   18 20                       38 8 8 20 0   1     0   1   18 20                 38
1129208 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   kindergarten 5 15 23 0   0     0   3   26 20                       46 5 15 23 0   0     0   3   26 20                 46
1370877 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2020   kindergarten 10 5 31 0   0     0   2   18 30 *                     48.0 10 5 31 0   0     0   2   18 30                 48
2045953 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   kindergarten 8 14 16 0   0     0   4   17 25                       42.0 8 14 16 0   0     0   4   17 25                 42
740178 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2015   kindergarten 14 11 48 1   0     0   2   34 42                       76 14 11 48 1   0     0   2   34 42                 76
937022 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2016   kindergarten 19 11 51 0   0     0   5   48 38                       86 19 11 51 0   0     0   5   48 38                 86
1127274 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   kindergarten 13 14 70 0   2     0   3   58 44                       102 13 14 70 0   2     0   3   58 44                 102
1369243 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary KG 05 2020   kindergarten 9 12 60 2   0     0   1   39 45 *                     84.0 9 12 60 2   0     0   1   39 45                 84
2044316 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary KG 05 2019   kindergarten 16 12 68 0   0     0   0   47 49                       96.0 16 12 68 0   0     0   0   47 49                 96
740756 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No 1 KG 02 2015   kindergarten 120 3 12 0   0     0   3   67 71                       138 120 3 12 0   0     0   3   67 71                 138
937583 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No 1 PK 02 2016   kindergarten 108 3 16 0   0     0   6   70 63                       133 108 3 16 0   0     0   6   70 63                 133
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
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
2044886 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   kindergarten 94 1 17 1   0     0   4   58 59                       117.0 94 1 17 1   0     0   4   58 59                 117
742785 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 01 2015   kindergarten 102 0 2 0   1     0   5   55 55                       110 102 0 2 0   1     0   5   55 55                 110
939591 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 02 2016   kindergarten 104 0 2 0   0     0   4   64 46                       110 104 0 2 0   0     0   4   64 46                 110
1130343 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2017   kindergarten 94 0 4 0   0     0   6   56 48                       104 94 0 4 0   0     0   6   56 48                 104
1371821 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2020   kindergarten 102 0 3 0   0     0   0   53 52 *                     105.0 102 0 3 0   0     0   0   53 52                 105
2046896 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   kindergarten 93 1 5 0   0     0   3   45 57                       102.0 93 1 5 0   0     0   3   45 57                 102
741915 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2015   kindergarten 12 7 23 0   4     0   1   26 21                       47 12 7 23 0   4     0   1   26 21                 47
938721 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2016   kindergarten 7 5 15 0   2     0   2   13 18                       31 7 5 15 0   2     0   2   13 18                 31
1129292 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2017   kindergarten 10 11 25 0   3     0   3   25 27                       52 10 11 25 0   3     0   3   25 27                 52
1370952 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2020   kindergarten 3 9 18 0   7     0   1   21 17 *                     38.0 3 9 18 0   7     0   1   21 17                 38
2046027 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2019   kindergarten 9 7 26 0   8     0   2   28 24                       52.0 9 7 26 0   8     0   2   28 24                 52
741171 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No 1 KG 05 2015   kindergarten 56 1 1 0   2     0   0   29 31                       60 56 1 1 0   2     0   0   29 31                 60
937999 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No 1 KG 05 2016   kindergarten 66 1 2 0   4     0   7   34 46                       80 66 1 2 0   4     0   7   34 46                 80
1128432 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2017   kindergarten 46 2 1 0   1     0   3   27 26                       53 46 2 1 0   1     0   3   27 26                 53
1370227 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2020   kindergarten 55 0 2 0   2     0   1   31 29 *                     60.0 55 0 2 0   2     0   1   31 29                 60
2045300 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2019   kindergarten 50 0 2 0   3     0   0   32 23                       55.0 50 0 2 0   3     0   0   32 23                 55
740528 MA Bristol   school 2508730 212   North Attleborough 250873001400 2120005 Allen Avenue   Regular School No 1 KG 04 2015   kindergarten 23 1 0 0   1     0   0   11 14                       25 23 1 0 0   1     0   0   11 14                 25
740890 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No 1 KG 05 2015   kindergarten 33 3 7 0   2     0   6   24 27                       51 33 3 7 0   2     0   6   24 27                 51
937718 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No 1 KG 05 2016   kindergarten 28 3 4 0   1     0   5   15 26                       41 28 3 4 0   1     0   5   15 26                 41
1128099 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2017   kindergarten 36 1 4 1   1     0   8   33 18                       51 36 1 4 1   1     0   8   33 18                 51
1369945 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2020   kindergarten 34 10 10 0   0     0   5   32 27 *                     59.0 34 10 10 0   0     0   5   32 27                 59
2045019 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2019   kindergarten 30 5 10 0   2     0   7   28 26                       54.0 30 5 10 0   2     0   7   28 26                 54
743410 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   kindergarten 11 2 19 3   0     1   3   20 19                       39 11 2 19 3   0     1   3   20 19                 39
940228 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 06 2016   kindergarten 17 3 14 0   0     1   3   19 19                       38 17 3 14 0   0     1   3   19 19                 38
1131101 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   kindergarten 7 7 23 0   0     0   1   16 22                       38 7 7 23 0   0     0   1   16 22                 38
1372443 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   kindergarten 16 15 60 1   0     0   11   52 51 *                     103.0 16 15 60 1   0     0   11   52 51                 103
2047516 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   kindergarten 15 6 32 0   0     0   0   23 30                       53.0 15 6 32 0   0     0   0   23 30                 53
1679707 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   kindergarten 20 17 56 1   0     0   6   45 55 *                     100.0 20 17 56 1   0     0   6   45 55                 100
2237926 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   kindergarten 9 5 29 1   0     0   6   25 25                       50.0 9 5 29 1   0     0   6   25 25                 50
743011 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No 1 KG 05 2015   kindergarten 66 0 2 0   3     0   0   40 31                       71 66 0 2 0   3     0   0   40 31                 71
939820 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No 1 KG 05 2016   kindergarten 57 0 0 0   8     0   2   30 37                       67 57 0 0 0   8     0   2   30 37                 67
1130625 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2017   kindergarten 47 0 0 0   1     0   2   28 22                       50 47 0 0 0   1     0   2   28 22                 50
1372041 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2020   kindergarten 50 0 1 0   1     0   3   29 26 *                     55.0 50 0 1 0   1     0   3   29 26                 55
2047115 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2019   kindergarten 45 0 0 0   6     0   3   29 25                       54.0 45 0 0 0   6     0   3   29 25                 54
1672062 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   kindergarten 58 0 5 0   1     0   3   39 28 *                     67.0 58 0 5 0   1     0   3   39 28                 67
1672068 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   kindergarten 54 1 8 1   0     0   3   32 35 *                     67.0 54 1 8 1   0     0   3   32 35                 67
735714 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2015   kindergarten 53 24 2 1   0     0   7   45 42                       87 53 24 2 1   0     0   7   45 42                 87
932592 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No 1 PK 04 2016   kindergarten 52 16 4 1   0     0   5   35 43                       78 52 16 4 1   0     0   5   35 43                 78
1122016 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   kindergarten 40 10 4 0   0     0   2   31 25                       56 40 10 4 0   0     0   2   31 25                 56
1364838 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   kindergarten 60 1 1 0   0     0   1   33 30 *                     63.0 60 1 1 0   0     0   1   33 30                 63
2039866 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   kindergarten 47 0 3 0   0     1   2   25 28                       53.0 47 0 3 0   0     1   2   25 28                 53
2228822 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   kindergarten 61 0 8 0   0     0   5   45 29                       74.0 61 0 8 0   0     0   5   45 29                 74
2228829 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   kindergarten 62 0 7 0   1     0   1   40 31                       71.0 62 0 7 0   1     0   1   40 31                 71
1672086 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   kindergarten 23 7 6 0   7     1   4   22 25 *                     48.0 23 7 6 0   7     1   4   22 25                 48
1672094 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   kindergarten 15 0 17 0   3     0   0   14 21 *                     35.0 15 0 17 0   3     0   0   14 21                 35
1672101 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   kindergarten 22 4 9 0   5     0   4   24 20 *                     44.0 22 4 9 0   5     0   4   24 20                 44
2228851 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   kindergarten 16 2 5 2   6     0   5   16 19                       36.0 16 2 5 2   6     0   5   16 19                 36
2228860 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   kindergarten 14 2 8 0   7     0   2   12 21                       33.0 14 2 8 0   7     0   2   12 21                 33
2228868 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   kindergarten 27 4 10 0   7     0   4   25 27                       52.0 27 4 10 0   7     0   4   25 27                 52
737309 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   kindergarten 19 2 26 0   1     0   4   28 24                       52 19 2 26 0   1     0   4   28 24                 52
934169 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2016   kindergarten 17 3 19 0   6     0   3   24 24                       48 17 3 19 0   6     0   3   24 24                 48
1123863 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   kindergarten 21 2 20 0   0     0   3   24 22                       46 21 2 20 0   0     0   3   24 22                 46
1366387 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   kindergarten 22 3 18 0   2     0   5   23 27 *                     50.0 22 3 18 0   2     0   5   23 27                 50
2041458 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   kindergarten 26 1 16 0   1     0   3   28 19                       47.0 26 1 16 0   1     0   3   28 19                 47
740533 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No 1 KG 05 2015   kindergarten 36 1 3 0   3     0   4   27 20                       47 36 1 3 0   3     0   4   27 20                 47
937363 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No 1 KG 05 2016   kindergarten 32 0 1 0   1     0   2   25 11                       36 32 0 1 0   1     0   2   25 11                 36
1127679 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2017   kindergarten 28 3 3 0   3     0   0   22 15                       37 28 3 3 0   3     0   0   22 15                 37
1369589 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2020   kindergarten 42 1 2 0   5     0   3   30 23 *                     53.0 42 1 2 0   5     0   3   30 23                 53
2044662 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2019   kindergarten 32 1 0 0   4     0   2   24 15                       39.0 32 1 0 0   4     0   2   24 15                 39
1672108 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover - Bancroft Elementary   Regular School No Elementary KG 05 2021   kindergarten 46 0 4 0   10     0   5   28 37 *                     65.0 46 0 4 0   10     0   5   28 37                 65
1672121 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover - Henry C Sanborn Elementary   Regular School No Elementary KG 05 2021   kindergarten 23 2 5 0   6     0   2   21 17 *                     38.0 23 2 5 0   6     0   2   21 17                 38
1672114 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover - High Plain Elementary   Regular School No Elementary KG 05 2021   kindergarten 39 2 8 0   17     0   4   34 36 *                     70.0 39 2 8 0   17     0   4   34 36                 70
1672127 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover - South Elementary   Regular School No Elementary KG 05 2021   kindergarten 35 2 8 0   15     0   4   33 31 *                     64.0 35 2 8 0   15     0   4   33 31                 64
1672133 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover - West Elementary   Regular School No Elementary KG 05 2021   kindergarten 53 2 5 0   12     0   4   42 34 *                     76.0 53 2 5 0   12     0   4   42 34                 76
2228876 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover: Bancroft Elementary   Regular School No Elementary KG 05 2018   kindergarten 78 2 2 0   8     0   1   49 42                       91.0 78 2 2 0   8     0   1   49 42                 91
2228892 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover: Henry C Sanborn Elementary   Regular School No Elementary KG 05 2018   kindergarten 32 0 7 0   10     0   2   23 28                       51.0 32 0 7 0   10     0   2   23 28                 51
2228883 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover: High Plain Elementary   Regular School No Elementary KG 05 2018   kindergarten 38 2 4 0   13     0   2   36 23                       59.0 38 2 4 0   13     0   2   36 23                 59
2228899 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover: South Elementary   Regular School No Elementary KG 05 2018   kindergarten 62 1 1 0   11     0   2   39 38                       77.0 62 1 1 0   11     0   2   39 38                 77
2228906 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover: West Elementary   Regular School No Elementary KG 05 2018   kindergarten 62 0 5 1   17     0   0   45 40                       85.0 62 0 5 1   17     0   0   45 40                 85
737709 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No 1 PK KG 2015   kindergarten 60 1 1 1   0     1   7   36 35                       71 60 1 1 1   0     1   7   36 35                 71
934568 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No 1 PK KG 2016   kindergarten 62 0 3 0   0     0   2   33 34                       67 62 0 3 0   0     0   2   33 34                 67
1124333 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No Elementary PK KG 2017   kindergarten 78 1 5 0   2     0   9   55 40                       95 78 1 5 0   2     0   9   55 40                 95
1366791 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No Elementary PK KG 2020   kindergarten 74 0 4 0   0     0   5   39 44 *                     83.0 74 0 4 0   0     0   5   39 44                 83
2041862 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No Elementary PK KG 2019   kindergarten 52 2 4 0   0     0   3   30 31                       61.0 52 2 4 0   0     0   3   30 31                 61
740959 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No 1 PK 03 2015   kindergarten 72 4 4 0   6     0   3   50 39                       89 72 4 4 0   6     0   3   50 39                 89
937787 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No 1 PK 03 2016   kindergarten 72 2 7 0   5     0   3   45 44                       89 72 2 7 0   5     0   3   45 44                 89
1128181 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2017   kindergarten 75 3 4 0   2     0   4   51 37                       88 75 3 4 0   2     0   4   51 37                 88
1370015 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2020   kindergarten 72 3 5 0   2     0   3   44 41 *                     85.0 72 3 5 0   2     0   3   44 41                 85
2045090 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2019   kindergarten 70 2 7 0   7     0   1   38 49                       87.0 70 2 7 0   7     0   1   38 49                 87
1369560 MA Essex   school 2508700 211   North Andover 250870002883 2110005 Anne Bradstreet Early Childhood Center   Regular School No Elementary PK KG 2020   kindergarten 259 3 44 0   13     0   3   170 152 *                     322.0 259 3 44 0   13     0   3   170 152                 322
2044634 MA Essex   school 2508700 211   North Andover 250870002883 2110005 Anne Bradstreet Early Childhood Center   Regular School No Elementary PK KG 2019   kindergarten 255 8 38 0   26     0   16   168 175                       343.0 255 8 38 0   26     0   16   168 175                 343
939739 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No 1 PK 06 2016   kindergarten 19 0 1 0   0     0   0   12 8                       20 19 0 1 0   0     0   0   12 8                 20

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