enrollments
Data source: Big Local News · About: Big Local
3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by school_state_id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
745157 | 745157 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester | Regular School | Yes | 1 | PK | 06 | 2015 | pre_kindergarten | 0 | 33 | 21 | 0 | 0 | 0 | 4 | 35 | 23 | 58 | 0 | 33 | 21 | 0 | 0 | 0 | 4 | 35 | 23 | 58 | |||||||||||||||||||||||||||||||||
941980 | 941980 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester | Regular School | Yes | 1 | PK | 07 | 2016 | pre_kindergarten | 50 | 2 | 2 | 0 | 0 | 0 | 0 | 23 | 31 | 54 | 50 | 2 | 2 | 0 | 0 | 0 | 0 | 23 | 31 | 54 | |||||||||||||||||||||||||||||||||
1133137 | 1133137 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester | Regular School | Yes | Elementary | PK | 08 | 2017 | pre_kindergarten | 2 | 28 | 20 | 0 | 0 | 0 | 2 | 28 | 24 | 52 | 2 | 28 | 20 | 0 | 0 | 0 | 2 | 28 | 24 | 52 | |||||||||||||||||||||||||||||||||
1374211 | 1374211 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester | Regular School | Yes | Elementary | PK | 08 | 2020 | pre_kindergarten | 0 | 32 | 26 | 0 | 0 | 0 | 2 | 25 | 35 | * | 60.0 | 0 | 32 | 26 | 0 | 0 | 0 | 2 | 25 | 35 | 60 | ||||||||||||||||||||||||||||||||
1681456 | 1681456 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester (District) - UP Academy Charter School of Dorchester | Regular School | Yes | Elementary | PK | 08 | 2021 | pre_kindergarten | 3 | 29 | 21 | 0 | 0 | 0 | 1 | 27 | 27 | * | 54.0 | 3 | 29 | 21 | 0 | 0 | 0 | 1 | 27 | 27 | 54 | ||||||||||||||||||||||||||||||||
2049285 | 2049285 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester | Regular School | Yes | Elementary | PK | 08 | 2019 | pre_kindergarten | 1 | 28 | 25 | 1 | 0 | 1 | 0 | 22 | 34 | 56.0 | 1 | 28 | 25 | 1 | 0 | 1 | 0 | 22 | 34 | 56 | |||||||||||||||||||||||||||||||||
2239954 | 2239954 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester (District): UP Academy Charter School of Dorchester | Regular School | Yes | Elementary | PK | 08 | 2018 | pre_kindergarten | 2 | 25 | 29 | 0 | 2 | 0 | 1 | 32 | 27 | 59.0 | 2 | 25 | 29 | 0 | 2 | 0 | 1 | 32 | 27 | 59 | |||||||||||||||||||||||||||||||||
2049140 | 2049140 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293002135 | 7800505 | Whitman Hanson Regional | Regular School | No | High | 09 | 12 | 2019 | pre_kindergarten | 91 | 4 | 4 | 0 | 0 | 0 | 5 | 59 | 45 | 104.0 | 91 | 4 | 4 | 0 | 0 | 0 | 5 | 59 | 45 | 104 | |||||||||||||||||||||||||||||||||
745004 | 745004 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293000199 | 7800025 | Maquan Elementary | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 95 | 3 | 5 | 1 | 0 | 0 | 0 | 61 | 43 | 104 | 95 | 3 | 5 | 1 | 0 | 0 | 0 | 61 | 43 | 104 | |||||||||||||||||||||||||||||||||
941825 | 941825 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293000199 | 7800025 | Maquan Elementary | Regular School | No | 1 | PK | 02 | 2016 | pre_kindergarten | 95 | 2 | 3 | 2 | 3 | 0 | 3 | 74 | 34 | 108 | 95 | 2 | 3 | 2 | 3 | 0 | 3 | 74 | 34 | 108 | |||||||||||||||||||||||||||||||||
1132944 | 1132944 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293000199 | 7800025 | Maquan Elementary | Regular School | No | Elementary | PK | 02 | 2017 | pre_kindergarten | 99 | 2 | 6 | 0 | 1 | 0 | 5 | 72 | 41 | 113 | 99 | 2 | 6 | 0 | 1 | 0 | 5 | 72 | 41 | 113 | |||||||||||||||||||||||||||||||||
2239759 | 2239759 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293000199 | 7800025 | Whitman-Hanson: Maquan Elementary | Regular School | No | Elementary | PK | 02 | 2018 | pre_kindergarten | 95 | 3 | 7 | 0 | 0 | 0 | 7 | 61 | 51 | 112.0 | 95 | 3 | 7 | 0 | 0 | 0 | 7 | 61 | 51 | 112 | |||||||||||||||||||||||||||||||||
1374042 | 1374042 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293002902 | 7800001 | The Pre-School Academy at Whitman Hanson | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 91 | 3 | 5 | 0 | 3 | 0 | 7 | 67 | 42 | * | 109.0 | 91 | 3 | 5 | 0 | 3 | 0 | 7 | 67 | 42 | 109 | ||||||||||||||||||||||||||||||||
1681290 | 1681290 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293002902 | 7800001 | Whitman-Hanson - The Pre-School Academy at Whitman Hanson | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 68 | 3 | 4 | 0 | 3 | 0 | 2 | 55 | 25 | * | 80.0 | 68 | 3 | 4 | 0 | 3 | 0 | 2 | 55 | 25 | 80 | ||||||||||||||||||||||||||||||||
744984 | 744984 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210002040 | 7780010 | West Brookfield Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | |||||||||||||||||||||||||||||||||
941805 | 941805 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210002040 | 7780010 | West Brookfield Elementary | Regular School | No | 1 | PK | 06 | 2016 | pre_kindergarten | 23 | 0 | 2 | 0 | 0 | 0 | 0 | 15 | 10 | 25 | 23 | 0 | 2 | 0 | 0 | 0 | 0 | 15 | 10 | 25 | |||||||||||||||||||||||||||||||||
1132920 | 1132920 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210002040 | 7780010 | West Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pre_kindergarten | 21 | 0 | 5 | 0 | 0 | 0 | 0 | 16 | 10 | 26 | 21 | 0 | 5 | 0 | 0 | 0 | 0 | 16 | 10 | 26 | |||||||||||||||||||||||||||||||||
1374029 | 1374029 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210002040 | 7780010 | West Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2020 | pre_kindergarten | 17 | 0 | 3 | 0 | 0 | 0 | 0 | 9 | 11 | * | 20.0 | 17 | 0 | 3 | 0 | 0 | 0 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||
1681277 | 1681277 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210002040 | 7780010 | Quaboag Regional - West Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 10 | 0 | 2 | 0 | 0 | 0 | 2 | 8 | 6 | * | 14.0 | 10 | 0 | 2 | 0 | 0 | 0 | 2 | 8 | 6 | 14 | ||||||||||||||||||||||||||||||||
2049102 | 2049102 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210002040 | 7780010 | West Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pre_kindergarten | 22 | 0 | 2 | 0 | 0 | 0 | 0 | 13 | 11 | 24.0 | 22 | 0 | 2 | 0 | 0 | 0 | 0 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
2239735 | 2239735 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210002040 | 7780010 | Quaboag Regional: West Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2018 | pre_kindergarten | 22 | 0 | 5 | 0 | 0 | 0 | 0 | 16 | 11 | 27.0 | 22 | 0 | 5 | 0 | 0 | 0 | 0 | 16 | 11 | 27 | |||||||||||||||||||||||||||||||||
744976 | 744976 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210001993 | 7780005 | Warren Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 25 | 1 | 1 | 0 | 0 | 0 | 1 | 14 | 14 | 28 | 25 | 1 | 1 | 0 | 0 | 0 | 1 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||
941797 | 941797 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210001993 | 7780005 | Warren Elementary | Regular School | No | 1 | PK | 06 | 2016 | pre_kindergarten | 27 | 0 | 0 | 0 | 0 | 0 | 3 | 21 | 9 | 30 | 27 | 0 | 0 | 0 | 0 | 0 | 3 | 21 | 9 | 30 | |||||||||||||||||||||||||||||||||
1132911 | 1132911 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210001993 | 7780005 | Warren Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pre_kindergarten | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 20 | 36 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 20 | 36 | |||||||||||||||||||||||||||||||||
1374021 | 1374021 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210001993 | 7780005 | Warren Elementary | Regular School | No | Elementary | PK | 06 | 2020 | pre_kindergarten | 21 | 0 | 2 | 0 | 0 | 0 | 2 | 14 | 11 | * | 25.0 | 21 | 0 | 2 | 0 | 0 | 0 | 2 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||
1681269 | 1681269 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210001993 | 7780005 | Quaboag Regional - Warren Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 22 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 8 | * | 23.0 | 22 | 0 | 1 | 0 | 0 | 0 | 0 | 15 | 8 | 23 | ||||||||||||||||||||||||||||||||
2049094 | 2049094 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210001993 | 7780005 | Warren Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pre_kindergarten | 31 | 0 | 2 | 0 | 0 | 0 | 3 | 21 | 15 | 36.0 | 31 | 0 | 2 | 0 | 0 | 0 | 3 | 21 | 15 | 36 | |||||||||||||||||||||||||||||||||
2239726 | 2239726 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210001993 | 7780005 | Quaboag Regional: Warren Elementary | Regular School | No | Elementary | PK | 06 | 2018 | pre_kindergarten | 33 | 0 | 1 | 0 | 0 | 0 | 2 | 18 | 18 | 36.0 | 33 | 0 | 1 | 0 | 0 | 0 | 2 | 18 | 18 | 36 | |||||||||||||||||||||||||||||||||
744912 | 744912 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188002730 | 7750001 | Early Childhood Center | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 120 | 4 | 13 | 0 | 5 | 1 | 5 | 94 | 54 | 148 | 120 | 4 | 13 | 0 | 5 | 1 | 5 | 94 | 54 | 148 | |||||||||||||||||||||||||||||||||
941733 | 941733 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188002730 | 7750001 | Early Childhood Center | Regular School | No | 1 | PK | PK | 2016 | pre_kindergarten | 117 | 3 | 7 | 0 | 2 | 1 | 4 | 80 | 54 | 134 | 117 | 3 | 7 | 0 | 2 | 1 | 4 | 80 | 54 | 134 | |||||||||||||||||||||||||||||||||
1132835 | 1132835 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188002730 | 7750001 | Early Childhood Center | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 126 | 2 | 10 | 1 | 7 | 1 | 3 | 83 | 67 | 150 | 126 | 2 | 10 | 1 | 7 | 1 | 3 | 83 | 67 | 150 | |||||||||||||||||||||||||||||||||
1373957 | 1373957 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188002730 | 7750001 | Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 134 | 2 | 12 | 0 | 7 | 0 | 4 | 95 | 64 | * | 159.0 | 134 | 2 | 12 | 0 | 7 | 0 | 4 | 95 | 64 | 159 | ||||||||||||||||||||||||||||||||
1681205 | 1681205 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188002730 | 7750001 | Wachusett - Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 71 | 2 | 13 | 0 | 5 | 0 | 2 | 58 | 35 | * | 93.0 | 71 | 2 | 13 | 0 | 5 | 0 | 2 | 58 | 35 | 93 | ||||||||||||||||||||||||||||||||
2049031 | 2049031 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188002730 | 7750001 | Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2019 | pre_kindergarten | 128 | 5 | 13 | 0 | 4 | 0 | 4 | 94 | 60 | 154.0 | 128 | 5 | 13 | 0 | 4 | 0 | 4 | 94 | 60 | 154 | |||||||||||||||||||||||||||||||||
2239650 | 2239650 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188002730 | 7750001 | Wachusett: Early Childhood Center | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 134 | 3 | 12 | 0 | 8 | 1 | 4 | 94 | 68 | 162.0 | 134 | 3 | 12 | 0 | 8 | 1 | 4 | 94 | 68 | 162 | |||||||||||||||||||||||||||||||||
744903 | 744903 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | 1 | PK | 08 | 2015 | pre_kindergarten | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 6 | |||||||||||||||||||||||||||||||||
941724 | 941724 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | 1 | PK | 08 | 2016 | pre_kindergarten | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | |||||||||||||||||||||||||||||||||
1132825 | 1132825 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2017 | pre_kindergarten | 7 | 0 | 1 | 0 | 0 | 0 | 1 | 5 | 4 | 9 | 7 | 0 | 1 | 0 | 0 | 0 | 1 | 5 | 4 | 9 | |||||||||||||||||||||||||||||||||
1373948 | 1373948 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2020 | pre_kindergarten | 5 | 0 | 2 | 1 | 0 | 0 | 0 | 4 | 4 | * | 8.0 | 5 | 0 | 2 | 1 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||
1681196 | 1681196 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | Up-Island Regional - West Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 3 | * | 8.0 | 6 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||
2049021 | 2049021 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2019 | pre_kindergarten | 4 | 0 | 1 | 1 | 0 | 0 | 1 | 3 | 4 | 7.0 | 4 | 0 | 1 | 1 | 0 | 0 | 1 | 3 | 4 | 7 | |||||||||||||||||||||||||||||||||
2239640 | 2239640 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | Up-Island Regional: West Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pre_kindergarten | 3 | 0 | 1 | 1 | 0 | 0 | 1 | 4 | 2 | 6.0 | 3 | 0 | 1 | 1 | 0 | 0 | 1 | 4 | 2 | 6 | |||||||||||||||||||||||||||||||||
744882 | 744882 | MA | Essex | school | 2511740 | 773 | Triton | 251174001651 | 7730025 | Pine Grove | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 33 | 0 | 0 | 0 | 0 | 0 | 1 | 20 | 14 | 34 | 33 | 0 | 0 | 0 | 0 | 0 | 1 | 20 | 14 | 34 | |||||||||||||||||||||||||||||||||
941703 | 941703 | MA | Essex | school | 2511740 | 773 | Triton | 251174001651 | 7730025 | Pine Grove | Regular School | No | 1 | PK | 06 | 2016 | pre_kindergarten | 37 | 0 | 0 | 0 | 0 | 0 | 3 | 22 | 18 | 40 | 37 | 0 | 0 | 0 | 0 | 0 | 3 | 22 | 18 | 40 | |||||||||||||||||||||||||||||||||
1132801 | 1132801 | MA | Essex | school | 2511740 | 773 | Triton | 251174001651 | 7730025 | Pine Grove | Regular School | No | Elementary | PK | 06 | 2017 | pre_kindergarten | 20 | 0 | 0 | 0 | 0 | 0 | 1 | 12 | 9 | 21 | 20 | 0 | 0 | 0 | 0 | 0 | 1 | 12 | 9 | 21 | |||||||||||||||||||||||||||||||||
1373928 | 1373928 | MA | Essex | school | 2511740 | 773 | Triton | 251174001651 | 7730025 | Pine Grove | Regular School | No | Elementary | PK | 06 | 2020 | pre_kindergarten | 26 | 0 | 0 | 0 | 2 | 0 | 0 | 13 | 15 | * | 28.0 | 26 | 0 | 0 | 0 | 2 | 0 | 0 | 13 | 15 | 28 | ||||||||||||||||||||||||||||||||
1681176 | 1681176 | MA | Essex | school | 2511740 | 773 | Triton | 251174001651 | 7730025 | Triton - Pine Grove | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 31 | 0 | 0 | 0 | 1 | 0 | 1 | 19 | 14 | * | 33.0 | 31 | 0 | 0 | 0 | 1 | 0 | 1 | 19 | 14 | 33 | ||||||||||||||||||||||||||||||||
2049001 | 2049001 | MA | Essex | school | 2511740 | 773 | Triton | 251174001651 | 7730025 | Pine Grove | Regular School | No | Elementary | PK | 06 | 2019 | pre_kindergarten | 27 | 0 | 0 | 0 | 1 | 0 | 0 | 14 | 14 | 28.0 | 27 | 0 | 0 | 0 | 1 | 0 | 0 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||
2239616 | 2239616 | MA | Essex | school | 2511740 | 773 | Triton | 251174001651 | 7730025 | Triton: Pine Grove | Regular School | No | Elementary | PK | 06 | 2018 | pre_kindergarten | 35 | 0 | 0 | 0 | 1 | 0 | 0 | 17 | 19 | 36.0 | 35 | 0 | 0 | 0 | 1 | 0 | 0 | 17 | 19 | 36 | |||||||||||||||||||||||||||||||||
744874 | 744874 | MA | Essex | school | 2511740 | 773 | Triton | 251174001348 | 7730020 | Newbury Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 32 | 0 | 1 | 0 | 1 | 0 | 1 | 20 | 15 | 35 | 32 | 0 | 1 | 0 | 1 | 0 | 1 | 20 | 15 | 35 | |||||||||||||||||||||||||||||||||
941695 | 941695 | MA | Essex | school | 2511740 | 773 | Triton | 251174001348 | 7730020 | Newbury Elementary | Regular School | No | 1 | PK | 06 | 2016 | pre_kindergarten | 43 | 0 | 4 | 0 | 0 | 0 | 1 | 24 | 24 | 48 | 43 | 0 | 4 | 0 | 0 | 0 | 1 | 24 | 24 | 48 | |||||||||||||||||||||||||||||||||
1132792 | 1132792 | MA | Essex | school | 2511740 | 773 | Triton | 251174001348 | 7730020 | Newbury Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pre_kindergarten | 22 | 0 | 0 | 0 | 1 | 0 | 0 | 10 | 13 | 23 | 22 | 0 | 0 | 0 | 1 | 0 | 0 | 10 | 13 | 23 | |||||||||||||||||||||||||||||||||
1373920 | 1373920 | MA | Essex | school | 2511740 | 773 | Triton | 251174001348 | 7730020 | Newbury Elementary | Regular School | No | Elementary | PK | 06 | 2020 | pre_kindergarten | 39 | 2 | 0 | 0 | 1 | 0 | 1 | 21 | 22 | * | 43.0 | 39 | 2 | 0 | 0 | 1 | 0 | 1 | 21 | 22 | 43 | ||||||||||||||||||||||||||||||||
1681168 | 1681168 | MA | Essex | school | 2511740 | 773 | Triton | 251174001348 | 7730020 | Triton - Newbury Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 25 | 1 | 1 | 0 | 0 | 0 | 0 | 15 | 12 | * | 27.0 | 25 | 1 | 1 | 0 | 0 | 0 | 0 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||
2048993 | 2048993 | MA | Essex | school | 2511740 | 773 | Triton | 251174001348 | 7730020 | Newbury Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pre_kindergarten | 38 | 1 | 1 | 0 | 1 | 0 | 2 | 19 | 24 | 43.0 | 38 | 1 | 1 | 0 | 1 | 0 | 2 | 19 | 24 | 43 | |||||||||||||||||||||||||||||||||
2239607 | 2239607 | MA | Essex | school | 2511740 | 773 | Triton | 251174001348 | 7730020 | Triton: Newbury Elementary | Regular School | No | Elementary | PK | 06 | 2018 | pre_kindergarten | 48 | 0 | 3 | 0 | 0 | 0 | 0 | 26 | 25 | 51.0 | 48 | 0 | 3 | 0 | 0 | 0 | 0 | 26 | 25 | 51 | |||||||||||||||||||||||||||||||||
744866 | 744866 | MA | Essex | school | 2511740 | 773 | Triton | 251174001669 | 7730015 | Salisbury Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 58 | 0 | 1 | 0 | 1 | 0 | 3 | 28 | 35 | 63 | 58 | 0 | 1 | 0 | 1 | 0 | 3 | 28 | 35 | 63 | |||||||||||||||||||||||||||||||||
941687 | 941687 | MA | Essex | school | 2511740 | 773 | Triton | 251174001669 | 7730015 | Salisbury Elementary | Regular School | No | 1 | PK | 06 | 2016 | pre_kindergarten | 48 | 0 | 7 | 0 | 1 | 1 | 2 | 24 | 35 | 59 | 48 | 0 | 7 | 0 | 1 | 1 | 2 | 24 | 35 | 59 | |||||||||||||||||||||||||||||||||
1132783 | 1132783 | MA | Essex | school | 2511740 | 773 | Triton | 251174001669 | 7730015 | Salisbury Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pre_kindergarten | 25 | 5 | 0 | 0 | 1 | 1 | 1 | 12 | 21 | 33 | 25 | 5 | 0 | 0 | 1 | 1 | 1 | 12 | 21 | 33 | |||||||||||||||||||||||||||||||||
1373912 | 1373912 | MA | Essex | school | 2511740 | 773 | Triton | 251174001669 | 7730015 | Salisbury Elementary | Regular School | No | Elementary | PK | 06 | 2020 | pre_kindergarten | 38 | 1 | 4 | 0 | 3 | 0 | 1 | 23 | 24 | * | 47.0 | 38 | 1 | 4 | 0 | 3 | 0 | 1 | 23 | 24 | 47 | ||||||||||||||||||||||||||||||||
1681160 | 1681160 | MA | Essex | school | 2511740 | 773 | Triton | 251174001669 | 7730015 | Triton - Salisbury Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | * | 26.0 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | 26 | ||||||||||||||||||||||||||||||||
2048985 | 2048985 | MA | Essex | school | 2511740 | 773 | Triton | 251174001669 | 7730015 | Salisbury Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pre_kindergarten | 44 | 2 | 3 | 0 | 1 | 0 | 0 | 24 | 26 | 50.0 | 44 | 2 | 3 | 0 | 1 | 0 | 0 | 24 | 26 | 50 | |||||||||||||||||||||||||||||||||
2239598 | 2239598 | MA | Essex | school | 2511740 | 773 | Triton | 251174001669 | 7730015 | Triton: Salisbury Elementary | Regular School | No | Elementary | PK | 06 | 2018 | pre_kindergarten | 50 | 2 | 3 | 0 | 0 | 0 | 0 | 28 | 27 | 55.0 | 50 | 2 | 3 | 0 | 0 | 0 | 0 | 28 | 27 | 55 | |||||||||||||||||||||||||||||||||
744840 | 744840 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000202408 | 7670010 | Lake Street | Regular School | No | 1 | PK | 01 | 2015 | pre_kindergarten | 89 | 0 | 6 | 0 | 0 | 0 | 3 | 48 | 50 | 98 | 89 | 0 | 6 | 0 | 0 | 0 | 3 | 48 | 50 | 98 | |||||||||||||||||||||||||||||||||
941654 | 941654 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201766 | 7670008 | East Brookfield Elementary | Regular School | No | 1 | PK | 06 | 2016 | pre_kindergarten | 79 | 1 | 8 | 0 | 0 | 0 | 4 | 53 | 39 | 92 | 79 | 1 | 8 | 0 | 0 | 0 | 4 | 53 | 39 | 92 | |||||||||||||||||||||||||||||||||
1132745 | 1132745 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201766 | 7670008 | East Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2017 | pre_kindergarten | 40 | 1 | 3 | 0 | 0 | 0 | 2 | 24 | 22 | 46 | 40 | 1 | 3 | 0 | 0 | 0 | 2 | 24 | 22 | 46 | |||||||||||||||||||||||||||||||||
1373880 | 1373880 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201766 | 7670008 | East Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2020 | pre_kindergarten | 65 | 2 | 9 | 0 | 0 | 0 | 4 | 41 | 39 | * | 80.0 | 65 | 2 | 9 | 0 | 0 | 0 | 4 | 41 | 39 | 80 | ||||||||||||||||||||||||||||||||
1681128 | 1681128 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201766 | 7670008 | Spencer-E Brookfield - East Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 35 | 1 | 4 | 0 | 0 | 0 | 7 | 31 | 16 | * | 47.0 | 35 | 1 | 4 | 0 | 0 | 0 | 7 | 31 | 16 | 47 | ||||||||||||||||||||||||||||||||
2048952 | 2048952 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201766 | 7670008 | East Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pre_kindergarten | 65 | 3 | 14 | 0 | 0 | 0 | 3 | 46 | 39 | 85.0 | 65 | 3 | 14 | 0 | 0 | 0 | 3 | 46 | 39 | 85 | |||||||||||||||||||||||||||||||||
2239560 | 2239560 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201766 | 7670008 | Spencer-E Brookfield: East Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2018 | pre_kindergarten | 55 | 2 | 5 | 0 | 0 | 0 | 3 | 38 | 27 | 65.0 | 55 | 2 | 5 | 0 | 0 | 0 | 3 | 38 | 27 | 65 | |||||||||||||||||||||||||||||||||
744809 | 744809 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001301783 | 7660010 | Woodland Elementary | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 44 | 0 | 3 | 0 | 0 | 0 | 1 | 24 | 24 | 48 | 44 | 0 | 3 | 0 | 0 | 0 | 1 | 24 | 24 | 48 | |||||||||||||||||||||||||||||||||
941634 | 941634 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001301783 | 7660010 | Woodland School | Regular School | No | 1 | PK | 02 | 2016 | pre_kindergarten | 44 | 0 | 6 | 0 | 0 | 0 | 1 | 25 | 26 | 51 | 44 | 0 | 6 | 0 | 0 | 0 | 1 | 25 | 26 | 51 | |||||||||||||||||||||||||||||||||
1132721 | 1132721 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001301783 | 7660010 | Woodland School | Regular School | No | Elementary | PK | 02 | 2017 | pre_kindergarten | 52 | 0 | 9 | 0 | 0 | 0 | 1 | 34 | 28 | 62 | 52 | 0 | 9 | 0 | 0 | 0 | 1 | 34 | 28 | 62 | |||||||||||||||||||||||||||||||||
1373866 | 1373866 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001301783 | 7660010 | Woodland School | Regular School | No | Elementary | PK | 02 | 2020 | pre_kindergarten | 48 | 0 | 1 | 1 | 1 | 0 | 0 | 27 | 24 | * | 51.0 | 48 | 0 | 1 | 1 | 1 | 0 | 0 | 27 | 24 | 51 | ||||||||||||||||||||||||||||||||
1681114 | 1681114 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001301783 | 7660010 | Southwick-Tolland-Granville Regional School District - Woodland School | Regular School | No | Elementary | PK | 02 | 2021 | pre_kindergarten | 24 | 0 | 0 | 1 | 1 | 0 | 2 | 15 | 13 | * | 28.0 | 24 | 0 | 0 | 1 | 1 | 0 | 2 | 15 | 13 | 28 | ||||||||||||||||||||||||||||||||
2048937 | 2048937 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001301783 | 7660010 | Woodland School | Regular School | No | Elementary | PK | 02 | 2019 | pre_kindergarten | 40 | 0 | 3 | 0 | 0 | 0 | 1 | 26 | 18 | 44.0 | 40 | 0 | 3 | 0 | 0 | 0 | 1 | 26 | 18 | 44 | |||||||||||||||||||||||||||||||||
2239543 | 2239543 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001301783 | 7660010 | Southwick-Tolland-Granville Regional School District: Woodland School | Regular School | No | Elementary | PK | 02 | 2018 | pre_kindergarten | 49 | 0 | 5 | 0 | 0 | 0 | 2 | 30 | 26 | 56.0 | 49 | 0 | 5 | 0 | 0 | 0 | 2 | 30 | 26 | 56 | |||||||||||||||||||||||||||||||||
744795 | 744795 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104000428 | 7650035 | Undermountain | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | |||||||||||||||||||||||||||||||||
941620 | 941620 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104000428 | 7650035 | Undermountain | Regular School | No | 1 | PK | 06 | 2016 | pre_kindergarten | 26 | 0 | 4 | 0 | 0 | 0 | 0 | 19 | 11 | 30 | 26 | 0 | 4 | 0 | 0 | 0 | 0 | 19 | 11 | 30 | |||||||||||||||||||||||||||||||||
1132705 | 1132705 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104000428 | 7650035 | Undermountain | Regular School | No | Elementary | PK | 06 | 2017 | pre_kindergarten | 30 | 0 | 2 | 0 | 0 | 0 | 1 | 23 | 10 | 33 | 30 | 0 | 2 | 0 | 0 | 0 | 1 | 23 | 10 | 33 | |||||||||||||||||||||||||||||||||
1373852 | 1373852 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104000428 | 7650035 | Undermountain | Regular School | No | Elementary | PK | 05 | 2020 | pre_kindergarten | 27 | 0 | 6 | 0 | 0 | 0 | 1 | 14 | 20 | * | 34.0 | 27 | 0 | 6 | 0 | 0 | 0 | 1 | 14 | 20 | 34 | ||||||||||||||||||||||||||||||||
1681100 | 1681100 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104000428 | 7650035 | Southern Berkshire - Undermountain | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 22 | 0 | 8 | 0 | 0 | 0 | 1 | 12 | 19 | * | 31.0 | 22 | 0 | 8 | 0 | 0 | 0 | 1 | 12 | 19 | 31 | ||||||||||||||||||||||||||||||||
2048923 | 2048923 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104000428 | 7650035 | Undermountain | Regular School | No | Elementary | PK | 06 | 2019 | pre_kindergarten | 25 | 0 | 1 | 0 | 0 | 0 | 2 | 11 | 17 | 28.0 | 25 | 0 | 1 | 0 | 0 | 0 | 2 | 11 | 17 | 28 | |||||||||||||||||||||||||||||||||
2239527 | 2239527 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104000428 | 7650035 | Southern Berkshire: Undermountain | Regular School | No | Elementary | PK | 06 | 2018 | pre_kindergarten | 19 | 0 | 3 | 0 | 0 | 0 | 0 | 13 | 9 | 22.0 | 19 | 0 | 3 | 0 | 0 | 0 | 0 | 13 | 9 | 22 | |||||||||||||||||||||||||||||||||
744787 | 744787 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001775 | 7650018 | New Marlborough Central | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 4 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 4 | 9 | |||||||||||||||||||||||||||||||||
941612 | 941612 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001775 | 7650018 | New Marlborough Central | Regular School | No | 1 | PK | 04 | 2016 | pre_kindergarten | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 8 | 19 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 8 | 19 | |||||||||||||||||||||||||||||||||
1132695 | 1132695 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001775 | 7650018 | New Marlborough Central | Regular School | No | Elementary | PK | 04 | 2017 | pre_kindergarten | 9 | 0 | 0 | 1 | 0 | 0 | 1 | 4 | 7 | 11 | 9 | 0 | 0 | 1 | 0 | 0 | 1 | 4 | 7 | 11 | |||||||||||||||||||||||||||||||||
1373846 | 1373846 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001775 | 7650018 | New Marlborough Central | Regular School | No | Elementary | PK | 04 | 2020 | pre_kindergarten | 11 | 0 | 3 | 1 | 0 | 0 | 2 | 12 | 5 | * | 17.0 | 11 | 0 | 3 | 1 | 0 | 0 | 2 | 12 | 5 | 17 | ||||||||||||||||||||||||||||||||
1681094 | 1681094 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001775 | 7650018 | Southern Berkshire - New Marlborough Central | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 2 | * | 7.0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | ||||||||||||||||||||||||||||||||
2048916 | 2048916 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001775 | 7650018 | New Marlborough Central | Regular School | No | Elementary | PK | 04 | 2019 | pre_kindergarten | 9 | 0 | 1 | 0 | 0 | 0 | 1 | 5 | 6 | 11.0 | 9 | 0 | 1 | 0 | 0 | 0 | 1 | 5 | 6 | 11 | |||||||||||||||||||||||||||||||||
2239520 | 2239520 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001775 | 7650018 | Southern Berkshire: New Marlborough Central | Regular School | No | Elementary | PK | 04 | 2018 | pre_kindergarten | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 14.0 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 14 | |||||||||||||||||||||||||||||||||
744776 | 744776 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake Regional High | Regular School | No | 3 | 09 | 12 | 2015 | pre_kindergarten | 74 | 1 | 0 | 0 | 0 | 0 | 0 | 38 | 37 | 75 | 74 | 1 | 0 | 0 | 0 | 0 | 0 | 38 | 37 | 75 | |||||||||||||||||||||||||||||||||
941602 | 941602 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake Regional High | Regular School | No | 3 | 09 | 12 | 2016 | pre_kindergarten | 77 | 1 | 0 | 0 | 0 | 0 | 0 | 49 | 29 | 78 | 77 | 1 | 0 | 0 | 0 | 0 | 0 | 49 | 29 | 78 | |||||||||||||||||||||||||||||||||
1132683 | 1132683 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake Regional High | Regular School | No | High | 09 | 12 | 2017 | pre_kindergarten | 84 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 32 | 84 | 84 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 32 | 84 | |||||||||||||||||||||||||||||||||
1373834 | 1373834 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake Regional High | Regular School | No | High | 09 | 12 | 2020 | pre_kindergarten | 109 | 0 | 0 | 0 | 0 | 0 | 0 | 57 | 52 | * | 109.0 | 109 | 0 | 0 | 0 | 0 | 0 | 0 | 57 | 52 | 109 | ||||||||||||||||||||||||||||||||
1681082 | 1681082 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake - Silver Lake Regional High | Regular School | No | High | 09 | 12 | 2021 | pre_kindergarten | 98 | 1 | 0 | 0 | 0 | 0 | 0 | 57 | 42 | * | 99.0 | 98 | 1 | 0 | 0 | 0 | 0 | 0 | 57 | 42 | 99 | ||||||||||||||||||||||||||||||||
2048906 | 2048906 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake Regional High | Regular School | No | High | 09 | 12 | 2019 | pre_kindergarten | 111 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 46 | 111.0 | 111 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 46 | 111 | |||||||||||||||||||||||||||||||||
2239508 | 2239508 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001722 | 7600505 | Silver Lake: Silver Lake Regional High | Regular School | No | High | 09 | 12 | 2018 | pre_kindergarten | 98 | 0 | 0 | 0 | 0 | 0 | 0 | 61 | 37 | 98.0 | 98 | 0 | 0 | 0 | 0 | 0 | 0 | 61 | 37 | 98 | |||||||||||||||||||||||||||||||||
1373812 | 1373812 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102403 | 7530030 | Ruggles Lane | Regular School | No | Elementary | PK | 06 | 2020 | pre_kindergarten | 39 | 1 | 2 | 0 | 0 | 0 | 0 | 27 | 15 | * | 42.0 | 39 | 1 | 2 | 0 | 0 | 0 | 0 | 27 | 15 | 42 | ||||||||||||||||||||||||||||||||
1681060 | 1681060 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102403 | 7530030 | Quabbin - Ruggles Lane | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 32 | 0 | 2 | 0 | 1 | 0 | 1 | 24 | 12 | * | 36.0 | 32 | 0 | 2 | 0 | 1 | 0 | 1 | 24 | 12 | 36 |
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]);