enrollments
Data source: Big Local News · About: Big Local
6,747 rows where grade = "kindergarten" and state = "MA" sorted by district_state_id
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1674607 | 1674607 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000734 | 1000055 | Framingham - Woodrow Wilson | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 9 | 5 | 51 | 0 | 1 | 0 | 3 | 41 | 28 | * | 69.0 | 9 | 5 | 51 | 0 | 1 | 0 | 3 | 41 | 28 | 69 | ||||||||||||||||||||||||||||||||
2042397 | 2042397 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498002823 | 1000005 | King Elementary School | Regular School | No | Elementary | KG | 04 | 2019 | kindergarten | 43 | 2 | 6 | 0 | 9 | 0 | 6 | 33 | 33 | 66.0 | 43 | 2 | 6 | 0 | 9 | 0 | 6 | 33 | 33 | 66 | |||||||||||||||||||||||||||||||||
2042402 | 2042402 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000714 | 1000006 | Brophy | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 32 | 5 | 33 | 0 | 7 | 0 | 3 | 37 | 43 | 80.0 | 32 | 5 | 33 | 0 | 7 | 0 | 3 | 37 | 43 | 80 | |||||||||||||||||||||||||||||||||
2042408 | 2042408 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000716 | 1000007 | Charlotte A Dunning | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 52 | 11 | 13 | 0 | 5 | 0 | 5 | 44 | 42 | 86.0 | 52 | 11 | 13 | 0 | 5 | 0 | 5 | 44 | 42 | 86 | |||||||||||||||||||||||||||||||||
2042414 | 2042414 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000721 | 1000015 | Hemenway | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 63 | 3 | 14 | 0 | 11 | 0 | 12 | 56 | 47 | 103.0 | 63 | 3 | 14 | 0 | 11 | 0 | 12 | 56 | 47 | 103 | |||||||||||||||||||||||||||||||||
2042420 | 2042420 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000727 | 1000035 | Barbieri Elementary | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 17 | 5 | 93 | 0 | 0 | 0 | 6 | 53 | 68 | 121.0 | 17 | 5 | 93 | 0 | 0 | 0 | 6 | 53 | 68 | 121 | |||||||||||||||||||||||||||||||||
2042426 | 2042426 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000731 | 1000039 | Potter Road | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 67 | 6 | 9 | 0 | 1 | 0 | 4 | 48 | 39 | 87.0 | 67 | 6 | 9 | 0 | 1 | 0 | 4 | 48 | 39 | 87 | |||||||||||||||||||||||||||||||||
2042432 | 2042432 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000726 | 1000045 | Mary E Stapleton Elementary | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 26 | 2 | 15 | 0 | 2 | 0 | 3 | 27 | 21 | 48.0 | 26 | 2 | 15 | 0 | 2 | 0 | 3 | 27 | 21 | 48 | |||||||||||||||||||||||||||||||||
2042438 | 2042438 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000728 | 1000050 | Miriam F McCarthy School | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 36 | 6 | 31 | 0 | 1 | 0 | 4 | 41 | 37 | 78.0 | 36 | 6 | 31 | 0 | 1 | 0 | 4 | 41 | 37 | 78 | |||||||||||||||||||||||||||||||||
2042444 | 2042444 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000734 | 1000055 | Woodrow Wilson | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 53 | 15 | 13 | 0 | 0 | 0 | 5 | 41 | 45 | 86.0 | 53 | 15 | 13 | 0 | 0 | 0 | 5 | 41 | 45 | 86 | |||||||||||||||||||||||||||||||||
2231788 | 2231788 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498002823 | 1000005 | Framingham: King Elementary School | Regular School | No | Elementary | KG | 03 | 2018 | kindergarten | 46 | 1 | 6 | 0 | 5 | 0 | 6 | 35 | 29 | 64.0 | 46 | 1 | 6 | 0 | 5 | 0 | 6 | 35 | 29 | 64 | |||||||||||||||||||||||||||||||||
2231793 | 2231793 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000714 | 1000006 | Framingham: Brophy | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 26 | 6 | 35 | 0 | 2 | 0 | 2 | 32 | 39 | 71.0 | 26 | 6 | 35 | 0 | 2 | 0 | 2 | 32 | 39 | 71 | |||||||||||||||||||||||||||||||||
2231800 | 2231800 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000716 | 1000007 | Framingham: Charlotte A Dunning | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 53 | 6 | 6 | 0 | 4 | 0 | 1 | 40 | 30 | 70.0 | 53 | 6 | 6 | 0 | 4 | 0 | 1 | 40 | 30 | 70 | |||||||||||||||||||||||||||||||||
2231807 | 2231807 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000721 | 1000015 | Framingham: Hemenway | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 54 | 9 | 10 | 0 | 7 | 0 | 8 | 43 | 45 | 88.0 | 54 | 9 | 10 | 0 | 7 | 0 | 8 | 43 | 45 | 88 | |||||||||||||||||||||||||||||||||
2231814 | 2231814 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000727 | 1000035 | Framingham: Barbieri Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 18 | 3 | 97 | 0 | 1 | 0 | 3 | 50 | 72 | 122.0 | 18 | 3 | 97 | 0 | 1 | 0 | 3 | 50 | 72 | 122 | |||||||||||||||||||||||||||||||||
2231821 | 2231821 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000731 | 1000039 | Framingham: Potter Road | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 51 | 8 | 6 | 0 | 3 | 0 | 6 | 38 | 36 | 74.0 | 51 | 8 | 6 | 0 | 3 | 0 | 6 | 38 | 36 | 74 | |||||||||||||||||||||||||||||||||
2231828 | 2231828 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000726 | 1000045 | Framingham: Mary E Stapleton Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 44 | 5 | 5 | 0 | 3 | 0 | 2 | 29 | 30 | 59.0 | 44 | 5 | 5 | 0 | 3 | 0 | 2 | 29 | 30 | 59 | |||||||||||||||||||||||||||||||||
2231835 | 2231835 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000728 | 1000050 | Framingham: Miriam F McCarthy School | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 42 | 8 | 22 | 0 | 6 | 1 | 7 | 45 | 41 | 86.0 | 42 | 8 | 22 | 0 | 6 | 1 | 7 | 45 | 41 | 86 | |||||||||||||||||||||||||||||||||
2231842 | 2231842 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000734 | 1000055 | Framingham: Woodrow Wilson | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 55 | 12 | 17 | 0 | 1 | 0 | 1 | 53 | 33 | 86.0 | 55 | 12 | 17 | 0 | 1 | 0 | 1 | 53 | 33 | 86 | |||||||||||||||||||||||||||||||||
738301 | 738301 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000868 | 1010010 | Jefferson Elementary | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 52 | 2 | 1 | 0 | 7 | 0 | 1 | 34 | 29 | 63 | 52 | 2 | 1 | 0 | 7 | 0 | 1 | 34 | 29 | 63 | |||||||||||||||||||||||||||||||||
738307 | 738307 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001694 | 1010012 | Helen Keller Elementary | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 42 | 0 | 0 | 0 | 2 | 0 | 0 | 19 | 25 | 44 | 42 | 0 | 0 | 0 | 2 | 0 | 0 | 19 | 25 | 44 | |||||||||||||||||||||||||||||||||
738313 | 738313 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000740 | 1010013 | J F Kennedy Memorial | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 44 | 0 | 2 | 0 | 3 | 0 | 2 | 23 | 28 | 51 | 44 | 0 | 2 | 0 | 3 | 0 | 2 | 23 | 28 | 51 | |||||||||||||||||||||||||||||||||
738319 | 738319 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000741 | 1010030 | Oak Street Elementary | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 54 | 0 | 4 | 0 | 1 | 0 | 0 | 30 | 29 | 59 | 54 | 0 | 4 | 0 | 1 | 0 | 0 | 30 | 29 | 59 | |||||||||||||||||||||||||||||||||
738325 | 738325 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501002519 | 1010032 | Parmenter | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 56 | 0 | 1 | 0 | 5 | 1 | 0 | 36 | 27 | 63 | 56 | 0 | 1 | 0 | 5 | 1 | 0 | 36 | 27 | 63 | |||||||||||||||||||||||||||||||||
738331 | 738331 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000736 | 1010035 | Davis Thayer | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 43 | 0 | 0 | 0 | 1 | 0 | 0 | 23 | 21 | 44 | 43 | 0 | 0 | 0 | 1 | 0 | 0 | 23 | 21 | 44 | |||||||||||||||||||||||||||||||||
935155 | 935155 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000868 | 1010010 | Jefferson Elementary | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 43 | 2 | 2 | 0 | 3 | 1 | 1 | 28 | 24 | 52 | 43 | 2 | 2 | 0 | 3 | 1 | 1 | 28 | 24 | 52 | |||||||||||||||||||||||||||||||||
935161 | 935161 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001694 | 1010012 | Helen Keller Elementary | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 62 | 3 | 1 | 0 | 4 | 0 | 0 | 39 | 31 | 70 | 62 | 3 | 1 | 0 | 4 | 0 | 0 | 39 | 31 | 70 | |||||||||||||||||||||||||||||||||
935167 | 935167 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000740 | 1010013 | J F Kennedy Memorial | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 46 | 0 | 1 | 0 | 7 | 1 | 0 | 30 | 25 | 55 | 46 | 0 | 1 | 0 | 7 | 1 | 0 | 30 | 25 | 55 | |||||||||||||||||||||||||||||||||
935173 | 935173 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000741 | 1010030 | Oak Street Elementary | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 42 | 0 | 3 | 0 | 2 | 0 | 1 | 30 | 18 | 48 | 42 | 0 | 3 | 0 | 2 | 0 | 1 | 30 | 18 | 48 | |||||||||||||||||||||||||||||||||
935179 | 935179 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501002519 | 1010032 | Parmenter | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 42 | 2 | 2 | 0 | 5 | 1 | 1 | 27 | 26 | 53 | 42 | 2 | 2 | 0 | 5 | 1 | 1 | 27 | 26 | 53 | |||||||||||||||||||||||||||||||||
935185 | 935185 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000736 | 1010035 | Davis Thayer | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 33 | 1 | 0 | 0 | 0 | 0 | 0 | 15 | 19 | 34 | 33 | 1 | 0 | 0 | 0 | 0 | 0 | 15 | 19 | 34 | |||||||||||||||||||||||||||||||||
1125039 | 1125039 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000868 | 1010010 | Jefferson Elementary | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 31 | 0 | 0 | 0 | 0 | 1 | 1 | 20 | 13 | 33 | 31 | 0 | 0 | 0 | 0 | 1 | 1 | 20 | 13 | 33 | |||||||||||||||||||||||||||||||||
1125046 | 1125046 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001694 | 1010012 | Helen Keller Elementary | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 63 | 1 | 0 | 0 | 0 | 0 | 4 | 36 | 32 | 68 | 63 | 1 | 0 | 0 | 0 | 0 | 4 | 36 | 32 | 68 | |||||||||||||||||||||||||||||||||
1125053 | 1125053 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000740 | 1010013 | J F Kennedy Memorial | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 47 | 0 | 4 | 0 | 1 | 1 | 1 | 28 | 26 | 54 | 47 | 0 | 4 | 0 | 1 | 1 | 1 | 28 | 26 | 54 | |||||||||||||||||||||||||||||||||
1125060 | 1125060 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000741 | 1010030 | Oak Street Elementary | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 51 | 0 | 4 | 0 | 4 | 0 | 3 | 32 | 30 | 62 | 51 | 0 | 4 | 0 | 4 | 0 | 3 | 32 | 30 | 62 | |||||||||||||||||||||||||||||||||
1125067 | 1125067 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501002519 | 1010032 | Parmenter | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 51 | 6 | 1 | 1 | 5 | 1 | 0 | 35 | 30 | 65 | 51 | 6 | 1 | 1 | 5 | 1 | 0 | 35 | 30 | 65 | |||||||||||||||||||||||||||||||||
1125074 | 1125074 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000736 | 1010035 | Davis Thayer | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 39 | 0 | 2 | 0 | 2 | 0 | 1 | 25 | 19 | 44 | 39 | 0 | 2 | 0 | 2 | 0 | 1 | 25 | 19 | 44 | |||||||||||||||||||||||||||||||||
1367393 | 1367393 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000868 | 1010010 | Jefferson Elementary | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 31 | 0 | 2 | 0 | 5 | 0 | 1 | 25 | 14 | * | 39.0 | 31 | 0 | 2 | 0 | 5 | 0 | 1 | 25 | 14 | 39 | ||||||||||||||||||||||||||||||||
1367399 | 1367399 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001694 | 1010012 | Helen Keller Elementary | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 40 | 1 | 0 | 0 | 4 | 0 | 1 | 22 | 24 | * | 46.0 | 40 | 1 | 0 | 0 | 4 | 0 | 1 | 22 | 24 | 46 | ||||||||||||||||||||||||||||||||
1367405 | 1367405 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000740 | 1010013 | J F Kennedy Memorial | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 33 | 1 | 0 | 0 | 1 | 0 | 1 | 19 | 17 | * | 36.0 | 33 | 1 | 0 | 0 | 1 | 0 | 1 | 19 | 17 | 36 | ||||||||||||||||||||||||||||||||
1367411 | 1367411 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000741 | 1010030 | Oak Street Elementary | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 55 | 1 | 1 | 0 | 0 | 0 | 3 | 31 | 29 | * | 60.0 | 55 | 1 | 1 | 0 | 0 | 0 | 3 | 31 | 29 | 60 | ||||||||||||||||||||||||||||||||
1367417 | 1367417 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501002519 | 1010032 | Parmenter | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 52 | 4 | 3 | 0 | 2 | 2 | 0 | 32 | 31 | * | 63.0 | 52 | 4 | 3 | 0 | 2 | 2 | 0 | 32 | 31 | 63 | ||||||||||||||||||||||||||||||||
1367423 | 1367423 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000736 | 1010035 | Davis Thayer | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 35 | 1 | 4 | 0 | 0 | 0 | 1 | 21 | 20 | * | 41.0 | 35 | 1 | 4 | 0 | 0 | 0 | 1 | 21 | 20 | 41 | ||||||||||||||||||||||||||||||||
1674627 | 1674627 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000868 | 1010010 | Franklin - Jefferson Elementary | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 43 | 3 | 2 | 0 | 3 | 1 | 0 | 29 | 23 | * | 52.0 | 43 | 3 | 2 | 0 | 3 | 1 | 0 | 29 | 23 | 52 | ||||||||||||||||||||||||||||||||
1674633 | 1674633 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001694 | 1010012 | Franklin - Helen Keller Elementary | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 32 | 1 | 0 | 0 | 1 | 0 | 1 | 18 | 17 | * | 35.0 | 32 | 1 | 0 | 0 | 1 | 0 | 1 | 18 | 17 | 35 | ||||||||||||||||||||||||||||||||
1674639 | 1674639 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000740 | 1010013 | Franklin - J F Kennedy Memorial | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 44 | 0 | 1 | 0 | 4 | 3 | 0 | 30 | 22 | * | 52.0 | 44 | 0 | 1 | 0 | 4 | 3 | 0 | 30 | 22 | 52 | ||||||||||||||||||||||||||||||||
1674645 | 1674645 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000741 | 1010030 | Franklin - Oak Street Elementary | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 38 | 0 | 3 | 0 | 6 | 1 | 2 | 21 | 29 | * | 50.0 | 38 | 0 | 3 | 0 | 6 | 1 | 2 | 21 | 29 | 50 | ||||||||||||||||||||||||||||||||
1674651 | 1674651 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501002519 | 1010032 | Franklin - Parmenter | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 38 | 1 | 5 | 0 | 0 | 0 | 2 | 22 | 24 | * | 46.0 | 38 | 1 | 5 | 0 | 0 | 0 | 2 | 22 | 24 | 46 | ||||||||||||||||||||||||||||||||
1674657 | 1674657 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000736 | 1010035 | Franklin - Davis Thayer | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 25 | 1 | 0 | 0 | 2 | 1 | 1 | 14 | 16 | * | 30.0 | 25 | 1 | 0 | 0 | 2 | 1 | 1 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||
2042464 | 2042464 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000868 | 1010010 | Jefferson Elementary | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 49 | 0 | 2 | 0 | 3 | 1 | 1 | 26 | 30 | 56.0 | 49 | 0 | 2 | 0 | 3 | 1 | 1 | 26 | 30 | 56 | |||||||||||||||||||||||||||||||||
2042470 | 2042470 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001694 | 1010012 | Helen Keller Elementary | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 46 | 2 | 2 | 0 | 1 | 0 | 0 | 28 | 23 | 51.0 | 46 | 2 | 2 | 0 | 1 | 0 | 0 | 28 | 23 | 51 | |||||||||||||||||||||||||||||||||
2042476 | 2042476 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000740 | 1010013 | J F Kennedy Memorial | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 45 | 1 | 1 | 0 | 1 | 2 | 0 | 25 | 25 | 50.0 | 45 | 1 | 1 | 0 | 1 | 2 | 0 | 25 | 25 | 50 | |||||||||||||||||||||||||||||||||
2042482 | 2042482 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000741 | 1010030 | Oak Street Elementary | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 41 | 0 | 4 | 0 | 4 | 0 | 5 | 26 | 28 | 54.0 | 41 | 0 | 4 | 0 | 4 | 0 | 5 | 26 | 28 | 54 | |||||||||||||||||||||||||||||||||
2042488 | 2042488 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501002519 | 1010032 | Parmenter | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 43 | 3 | 6 | 0 | 1 | 0 | 0 | 29 | 24 | 53.0 | 43 | 3 | 6 | 0 | 1 | 0 | 0 | 29 | 24 | 53 | |||||||||||||||||||||||||||||||||
2042494 | 2042494 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000736 | 1010035 | Davis Thayer | Regular School | No | Elementary | KG | 05 | 2019 | kindergarten | 44 | 1 | 3 | 0 | 1 | 1 | 0 | 21 | 29 | 50.0 | 44 | 1 | 3 | 0 | 1 | 1 | 0 | 21 | 29 | 50 | |||||||||||||||||||||||||||||||||
2231868 | 2231868 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000868 | 1010010 | Franklin: Jefferson Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 47 | 2 | 2 | 0 | 6 | 2 | 0 | 37 | 22 | 59.0 | 47 | 2 | 2 | 0 | 6 | 2 | 0 | 37 | 22 | 59 | |||||||||||||||||||||||||||||||||
2231875 | 2231875 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501001694 | 1010012 | Franklin: Helen Keller Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 45 | 1 | 3 | 0 | 1 | 0 | 0 | 24 | 26 | 50.0 | 45 | 1 | 3 | 0 | 1 | 0 | 0 | 24 | 26 | 50 | |||||||||||||||||||||||||||||||||
2231882 | 2231882 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000740 | 1010013 | Franklin: J F Kennedy Memorial | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 61 | 0 | 2 | 0 | 2 | 1 | 0 | 39 | 27 | 66.0 | 61 | 0 | 2 | 0 | 2 | 1 | 0 | 39 | 27 | 66 | |||||||||||||||||||||||||||||||||
2231889 | 2231889 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000741 | 1010030 | Franklin: Oak Street Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 52 | 2 | 2 | 0 | 2 | 0 | 0 | 27 | 31 | 58.0 | 52 | 2 | 2 | 0 | 2 | 0 | 0 | 27 | 31 | 58 | |||||||||||||||||||||||||||||||||
2231896 | 2231896 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501002519 | 1010032 | Franklin: Parmenter | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 35 | 3 | 2 | 0 | 2 | 1 | 3 | 22 | 24 | 46.0 | 35 | 3 | 2 | 0 | 2 | 1 | 3 | 22 | 24 | 46 | |||||||||||||||||||||||||||||||||
2231903 | 2231903 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000736 | 1010035 | Franklin: Davis Thayer | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 21 | 0 | 5 | 0 | 1 | 0 | 1 | 13 | 15 | 28.0 | 21 | 0 | 5 | 0 | 1 | 0 | 1 | 13 | 15 | 28 | |||||||||||||||||||||||||||||||||
738357 | 738357 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Waterford Street | Regular School | No | 1 | PK | 02 | 2015 | kindergarten | 149 | 7 | 25 | 1 | 0 | 0 | 22 | 113 | 91 | 204 | 149 | 7 | 25 | 1 | 0 | 0 | 22 | 113 | 91 | 204 | |||||||||||||||||||||||||||||||||
935208 | 935208 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Waterford Street | Regular School | No | 1 | PK | 01 | 2016 | kindergarten | 120 | 5 | 26 | 0 | 4 | 0 | 17 | 76 | 96 | 172 | 120 | 5 | 26 | 0 | 4 | 0 | 17 | 76 | 96 | 172 | |||||||||||||||||||||||||||||||||
1125102 | 1125102 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Waterford Street | Regular School | No | Elementary | PK | 01 | 2017 | kindergarten | 139 | 1 | 37 | 0 | 1 | 0 | 16 | 86 | 108 | 194 | 139 | 1 | 37 | 0 | 1 | 0 | 16 | 86 | 108 | 194 | |||||||||||||||||||||||||||||||||
1367446 | 1367446 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Waterford Street | Regular School | No | Elementary | PK | 01 | 2020 | kindergarten | 118 | 7 | 39 | 0 | 2 | 0 | 10 | 100 | 76 | * | 176.0 | 118 | 7 | 39 | 0 | 2 | 0 | 10 | 100 | 76 | 176 | ||||||||||||||||||||||||||||||||
1674680 | 1674680 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Gardner - Waterford Street | Regular School | No | Elementary | PK | 01 | 2021 | kindergarten | 100 | 5 | 36 | 0 | 7 | 0 | 5 | 72 | 81 | * | 153.0 | 100 | 5 | 36 | 0 | 7 | 0 | 5 | 72 | 81 | 153 | ||||||||||||||||||||||||||||||||
2042518 | 2042518 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Waterford Street | Regular School | No | Elementary | PK | 01 | 2019 | kindergarten | 115 | 3 | 39 | 0 | 0 | 0 | 16 | 102 | 71 | 173.0 | 115 | 3 | 39 | 0 | 0 | 0 | 16 | 102 | 71 | 173 | |||||||||||||||||||||||||||||||||
2231931 | 2231931 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Gardner: Waterford Street | Regular School | No | Elementary | PK | 01 | 2018 | kindergarten | 141 | 6 | 42 | 0 | 4 | 0 | 12 | 103 | 102 | 205.0 | 141 | 6 | 42 | 0 | 4 | 0 | 12 | 103 | 102 | 205 | |||||||||||||||||||||||||||||||||
738373 | 738373 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000766 | 1050005 | Perley Elementary | Regular School | No | 1 | PK | 01 | 2015 | kindergarten | 82 | 1 | 2 | 0 | 1 | 0 | 0 | 45 | 41 | 86 | 82 | 1 | 2 | 0 | 1 | 0 | 0 | 45 | 41 | 86 | |||||||||||||||||||||||||||||||||
935225 | 935225 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000765 | 1050010 | Penn Brook | Regular School | No | 1 | KG | 06 | 2016 | kindergarten | 95 | 0 | 2 | 0 | 4 | 0 | 0 | 56 | 45 | 101 | 95 | 0 | 2 | 0 | 4 | 0 | 0 | 56 | 45 | 101 | |||||||||||||||||||||||||||||||||
1125123 | 1125123 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000765 | 1050010 | Penn Brook | Regular School | No | Elementary | KG | 06 | 2017 | kindergarten | 83 | 0 | 2 | 0 | 0 | 0 | 2 | 44 | 43 | 87 | 83 | 0 | 2 | 0 | 0 | 0 | 2 | 44 | 43 | 87 | |||||||||||||||||||||||||||||||||
1367462 | 1367462 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000765 | 1050010 | Penn Brook | Regular School | No | Elementary | KG | 06 | 2020 | kindergarten | 99 | 0 | 3 | 0 | 1 | 0 | 2 | 44 | 61 | * | 105.0 | 99 | 0 | 3 | 0 | 1 | 0 | 2 | 44 | 61 | 105 | ||||||||||||||||||||||||||||||||
1674697 | 1674697 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000765 | 1050010 | Georgetown - Penn Brook | Regular School | No | Elementary | KG | 06 | 2021 | kindergarten | 77 | 0 | 1 | 0 | 1 | 0 | 4 | 40 | 43 | * | 83.0 | 77 | 0 | 1 | 0 | 1 | 0 | 4 | 40 | 43 | 83 | ||||||||||||||||||||||||||||||||
2042534 | 2042534 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000765 | 1050010 | Penn Brook | Regular School | No | Elementary | KG | 06 | 2019 | kindergarten | 103 | 0 | 0 | 0 | 1 | 0 | 5 | 55 | 54 | 109.0 | 103 | 0 | 0 | 0 | 1 | 0 | 5 | 55 | 54 | 109 | |||||||||||||||||||||||||||||||||
2231952 | 2231952 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000765 | 1050010 | Georgetown: Penn Brook | Regular School | No | Elementary | KG | 06 | 2018 | kindergarten | 93 | 1 | 1 | 0 | 2 | 0 | 1 | 52 | 46 | 98.0 | 93 | 1 | 1 | 0 | 2 | 0 | 1 | 52 | 46 | 98 | |||||||||||||||||||||||||||||||||
738387 | 738387 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000770 | 1070010 | Beeman Memorial | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 46 | 0 | 9 | 1 | 2 | 0 | 1 | 35 | 24 | 59 | 46 | 0 | 9 | 1 | 2 | 0 | 1 | 35 | 24 | 59 | |||||||||||||||||||||||||||||||||
738393 | 738393 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000771 | 1070020 | East Gloucester Elementary | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 37 | 0 | 4 | 0 | 0 | 0 | 1 | 26 | 16 | 42 | 37 | 0 | 4 | 0 | 0 | 0 | 1 | 26 | 16 | 42 | |||||||||||||||||||||||||||||||||
738400 | 738400 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000877 | 1070042 | Plum Cove School | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 33 | 0 | 0 | 0 | 1 | 1 | 0 | 15 | 20 | 35 | 33 | 0 | 0 | 0 | 1 | 1 | 0 | 15 | 20 | 35 | |||||||||||||||||||||||||||||||||
738406 | 738406 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000780 | 1070045 | Veterans Memorial | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 27 | 0 | 5 | 0 | 0 | 0 | 0 | 12 | 20 | 32 | 27 | 0 | 5 | 0 | 0 | 0 | 0 | 12 | 20 | 32 | |||||||||||||||||||||||||||||||||
738412 | 738412 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000781 | 1070050 | West Parish | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 49 | 0 | 6 | 0 | 1 | 0 | 1 | 33 | 24 | 57 | 49 | 0 | 6 | 0 | 1 | 0 | 1 | 33 | 24 | 57 | |||||||||||||||||||||||||||||||||
935238 | 935238 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000770 | 1070010 | Beeman Memorial | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 50 | 2 | 9 | 0 | 0 | 0 | 2 | 32 | 31 | 63 | 50 | 2 | 9 | 0 | 0 | 0 | 2 | 32 | 31 | 63 | |||||||||||||||||||||||||||||||||
935244 | 935244 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000771 | 1070020 | East Gloucester Elementary | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 40 | 0 | 2 | 0 | 0 | 0 | 3 | 23 | 22 | 45 | 40 | 0 | 2 | 0 | 0 | 0 | 3 | 23 | 22 | 45 | |||||||||||||||||||||||||||||||||
935251 | 935251 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000877 | 1070042 | Plum Cove School | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 34 | 1 | 2 | 0 | 0 | 0 | 2 | 21 | 18 | 39 | 34 | 1 | 2 | 0 | 0 | 0 | 2 | 21 | 18 | 39 | |||||||||||||||||||||||||||||||||
935257 | 935257 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000780 | 1070045 | Veterans Memorial | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 29 | 0 | 9 | 0 | 0 | 0 | 3 | 18 | 23 | 41 | 29 | 0 | 9 | 0 | 0 | 0 | 3 | 18 | 23 | 41 | |||||||||||||||||||||||||||||||||
935263 | 935263 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000781 | 1070050 | West Parish | Regular School | No | 1 | KG | 05 | 2016 | kindergarten | 51 | 1 | 3 | 0 | 1 | 0 | 4 | 25 | 35 | 60 | 51 | 1 | 3 | 0 | 1 | 0 | 4 | 25 | 35 | 60 | |||||||||||||||||||||||||||||||||
1125139 | 1125139 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000770 | 1070010 | Beeman Memorial | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 56 | 0 | 9 | 0 | 0 | 0 | 0 | 32 | 33 | 65 | 56 | 0 | 9 | 0 | 0 | 0 | 0 | 32 | 33 | 65 | |||||||||||||||||||||||||||||||||
1125146 | 1125146 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000771 | 1070020 | East Gloucester Elementary | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 31 | 0 | 1 | 0 | 0 | 0 | 1 | 17 | 16 | 33 | 31 | 0 | 1 | 0 | 0 | 0 | 1 | 17 | 16 | 33 | |||||||||||||||||||||||||||||||||
1125155 | 1125155 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000877 | 1070042 | Plum Cove School | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 31 | 3 | 2 | 0 | 1 | 0 | 0 | 14 | 23 | 37 | 31 | 3 | 2 | 0 | 1 | 0 | 0 | 14 | 23 | 37 | |||||||||||||||||||||||||||||||||
1125162 | 1125162 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000780 | 1070045 | Veterans Memorial | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 39 | 1 | 5 | 0 | 1 | 0 | 0 | 20 | 26 | 46 | 39 | 1 | 5 | 0 | 1 | 0 | 0 | 20 | 26 | 46 | |||||||||||||||||||||||||||||||||
1125169 | 1125169 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000781 | 1070050 | West Parish | Regular School | No | Elementary | KG | 05 | 2017 | kindergarten | 57 | 1 | 1 | 0 | 1 | 0 | 0 | 29 | 31 | 60 | 57 | 1 | 1 | 0 | 1 | 0 | 0 | 29 | 31 | 60 | |||||||||||||||||||||||||||||||||
1367475 | 1367475 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000770 | 1070010 | Beeman Memorial | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 39 | 4 | 10 | 0 | 0 | 0 | 3 | 30 | 26 | * | 56.0 | 39 | 4 | 10 | 0 | 0 | 0 | 3 | 30 | 26 | 56 | ||||||||||||||||||||||||||||||||
1367481 | 1367481 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000771 | 1070020 | East Gloucester Elementary | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 24 | 0 | 5 | 0 | 2 | 0 | 3 | 16 | 18 | * | 34.0 | 24 | 0 | 5 | 0 | 2 | 0 | 3 | 16 | 18 | 34 | ||||||||||||||||||||||||||||||||
1367488 | 1367488 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000877 | 1070042 | Plum Cove School | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 28 | 1 | 1 | 0 | 0 | 0 | 4 | 18 | 16 | * | 34.0 | 28 | 1 | 1 | 0 | 0 | 0 | 4 | 18 | 16 | 34 | ||||||||||||||||||||||||||||||||
1367494 | 1367494 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000780 | 1070045 | Veterans Memorial | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 29 | 4 | 8 | 0 | 2 | 1 | 0 | 22 | 22 | * | 44.0 | 29 | 4 | 8 | 0 | 2 | 1 | 0 | 22 | 22 | 44 | ||||||||||||||||||||||||||||||||
1367500 | 1367500 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000781 | 1070050 | West Parish | Regular School | No | Elementary | KG | 05 | 2020 | kindergarten | 53 | 1 | 2 | 0 | 0 | 0 | 2 | 36 | 22 | * | 58.0 | 53 | 1 | 2 | 0 | 0 | 0 | 2 | 36 | 22 | 58 | ||||||||||||||||||||||||||||||||
1674710 | 1674710 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000770 | 1070010 | Gloucester - Beeman Memorial | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 36 | 2 | 11 | 0 | 3 | 0 | 1 | 27 | 26 | * | 53.0 | 36 | 2 | 11 | 0 | 3 | 0 | 1 | 27 | 26 | 53 | ||||||||||||||||||||||||||||||||
1674716 | 1674716 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000771 | 1070020 | Gloucester - East Gloucester Elementary | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 31 | 0 | 2 | 0 | 1 | 0 | 1 | 18 | 17 | * | 35.0 | 31 | 0 | 2 | 0 | 1 | 0 | 1 | 18 | 17 | 35 | ||||||||||||||||||||||||||||||||
1674723 | 1674723 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000877 | 1070042 | Gloucester - Plum Cove School | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 33 | 1 | 1 | 0 | 0 | 0 | 4 | 24 | 15 | * | 39.0 | 33 | 1 | 1 | 0 | 0 | 0 | 4 | 24 | 15 | 39 | ||||||||||||||||||||||||||||||||
1674729 | 1674729 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000780 | 1070045 | Gloucester - Veterans Memorial | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 25 | 1 | 8 | 0 | 1 | 1 | 3 | 25 | 14 | * | 39.0 | 25 | 1 | 8 | 0 | 1 | 1 | 3 | 25 | 14 | 39 | ||||||||||||||||||||||||||||||||
1674735 | 1674735 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000781 | 1070050 | Gloucester - West Parish | Regular School | No | Elementary | KG | 05 | 2021 | kindergarten | 54 | 0 | 2 | 0 | 1 | 0 | 1 | 22 | 36 | * | 58.0 | 54 | 0 | 2 | 0 | 1 | 0 | 1 | 22 | 36 | 58 |
Advanced export
JSON shape: default, array, newline-delimited
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]);