enrollments
Data source: Big Local News · About: Big Local
6,218 rows where grade = "grade_5" and state = "MA" sorted by county
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
735969 | 735969 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | 2 | 04 | 05 | 2015 | grade_5 | 299 | 29 | 29 | 2 | 7 | 0 | 17 | 186 | 197 | 383 | 299 | 29 | 29 | 2 | 7 | 0 | 17 | 186 | 197 | 383 | |||||||||||||||||||||||||||||||||
736975 | 736975 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 172 | 6 | 2 | 2 | 5 | 0 | 3 | 89 | 101 | 190 | 172 | 6 | 2 | 2 | 5 | 0 | 3 | 89 | 101 | 190 | |||||||||||||||||||||||||||||||||
737050 | 737050 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | 1 | 03 | 05 | 2015 | grade_5 | 54 | 5 | 2 | 0 | 1 | 0 | 0 | 37 | 25 | 62 | 54 | 5 | 2 | 0 | 1 | 0 | 0 | 37 | 25 | 62 | |||||||||||||||||||||||||||||||||
737865 | 737865 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | 1 | PK | 05 | 2015 | grade_5 | 34 | 0 | 0 | 1 | 1 | 0 | 1 | 22 | 15 | 37 | 34 | 0 | 0 | 1 | 1 | 0 | 1 | 22 | 15 | 37 | |||||||||||||||||||||||||||||||||
738149 | 738149 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000688 | 960305 | Morse Pond School | Regular School | No | 2 | 05 | 06 | 2015 | grade_5 | 236 | 8 | 14 | 3 | 6 | 0 | 18 | 156 | 129 | 285 | 236 | 8 | 14 | 3 | 6 | 0 | 18 | 156 | 129 | 285 | |||||||||||||||||||||||||||||||||
739729 | 739729 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744001546 | 1720035 | Quashnet School | Regular School | No | 1 | 03 | 06 | 2015 | grade_5 | 109 | 5 | 4 | 7 | 3 | 1 | 2 | 74 | 57 | 131 | 109 | 5 | 4 | 7 | 3 | 1 | 2 | 74 | 57 | 131 | |||||||||||||||||||||||||||||||||
740752 | 740752 | MA | Barnstable | school | 2509210 | 224 | Orleans | 250921001477 | 2240005 | Orleans Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 37 | 1 | 2 | 0 | 0 | 2 | 0 | 22 | 20 | 42 | 37 | 1 | 2 | 0 | 0 | 2 | 0 | 22 | 20 | 42 | |||||||||||||||||||||||||||||||||
741041 | 741041 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown Schools | Regular School | No | 1 | PK | 08 | 2015 | grade_5 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | |||||||||||||||||||||||||||||||||
741395 | 741395 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047001672 | 2610005 | Henry T Wing | Regular School | No | 1 | PK | 06 | 2015 | grade_5 | 78 | 2 | 1 | 0 | 3 | 0 | 0 | 46 | 38 | 84 | 78 | 2 | 1 | 0 | 3 | 0 | 0 | 46 | 38 | 84 | |||||||||||||||||||||||||||||||||
741402 | 741402 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002534 | 2610010 | Forestdale | Regular School | No | 1 | KG | 06 | 2015 | grade_5 | 64 | 1 | 0 | 0 | 0 | 0 | 0 | 35 | 30 | 65 | 64 | 1 | 0 | 0 | 0 | 0 | 0 | 35 | 30 | 65 | |||||||||||||||||||||||||||||||||
741409 | 741409 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002535 | 2610025 | Oak Ridge | Regular School | No | 1 | KG | 06 | 2015 | grade_5 | 80 | 0 | 1 | 2 | 3 | 0 | 1 | 44 | 43 | 87 | 80 | 0 | 1 | 2 | 3 | 0 | 1 | 44 | 43 | 87 | |||||||||||||||||||||||||||||||||
742302 | 742302 | MA | Barnstable | school | 2511730 | 300 | Truro | 251173001930 | 3000005 | Truro Central | Regular School | No | 1 | PK | 06 | 2015 | grade_5 | 17 | 1 | 0 | 0 | 0 | 0 | 0 | 8 | 10 | 18 | 17 | 1 | 0 | 0 | 0 | 0 | 0 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
742617 | 742617 | MA | Barnstable | school | 2512300 | 318 | Wellfleet | 251230002031 | 3180005 | Wellfleet Elementary | Regular School | No | 1 | PK | 05 | 2015 | grade_5 | 22 | 0 | 0 | 0 | 0 | 0 | 3 | 13 | 12 | 25 | 22 | 0 | 0 | 0 | 0 | 0 | 3 | 13 | 12 | 25 | |||||||||||||||||||||||||||||||||
744197 | 744197 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414002803 | 6450050 | N H Wixon Innovation School | Regular School | No | 2 | 04 | 05 | 2015 | grade_5 | 188 | 25 | 23 | 5 | 5 | 0 | 11 | 128 | 129 | 257 | 188 | 25 | 23 | 5 | 5 | 0 | 11 | 128 | 129 | 257 | |||||||||||||||||||||||||||||||||
744506 | 744506 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402832 | 7120315 | Monomoy Regional Middle School | Regular School | No | 2 | 05 | 07 | 2015 | grade_5 | 123 | 5 | 12 | 3 | 3 | 1 | 7 | 77 | 77 | 154 | 123 | 5 | 12 | 3 | 3 | 1 | 7 | 77 | 77 | 154 | |||||||||||||||||||||||||||||||||
932843 | 932843 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | 2 | 04 | 05 | 2016 | grade_5 | 279 | 22 | 34 | 2 | 5 | 1 | 24 | 176 | 191 | 367 | 279 | 22 | 34 | 2 | 5 | 1 | 24 | 176 | 191 | 367 | |||||||||||||||||||||||||||||||||
933840 | 933840 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 148 | 0 | 2 | 0 | 6 | 0 | 8 | 71 | 93 | 164 | 148 | 0 | 2 | 0 | 6 | 0 | 8 | 71 | 93 | 164 | |||||||||||||||||||||||||||||||||
933917 | 933917 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | 1 | 03 | 05 | 2016 | grade_5 | 65 | 3 | 1 | 0 | 2 | 0 | 2 | 37 | 36 | 73 | 65 | 3 | 1 | 0 | 2 | 0 | 2 | 37 | 36 | 73 | |||||||||||||||||||||||||||||||||
934719 | 934719 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | 1 | PK | 05 | 2016 | grade_5 | 24 | 0 | 0 | 0 | 1 | 0 | 0 | 11 | 14 | 25 | 24 | 0 | 0 | 0 | 1 | 0 | 0 | 11 | 14 | 25 | |||||||||||||||||||||||||||||||||
935003 | 935003 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000688 | 960305 | Morse Pond School | Regular School | No | 2 | 05 | 06 | 2016 | grade_5 | 263 | 17 | 14 | 1 | 6 | 1 | 15 | 154 | 163 | 317 | 263 | 17 | 14 | 1 | 6 | 1 | 15 | 154 | 163 | 317 | |||||||||||||||||||||||||||||||||
936573 | 936573 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744001546 | 1720035 | Quashnet School | Regular School | No | 1 | 03 | 06 | 2016 | grade_5 | 103 | 5 | 3 | 13 | 6 | 0 | 5 | 58 | 77 | 135 | 103 | 5 | 3 | 13 | 6 | 0 | 5 | 58 | 77 | 135 | |||||||||||||||||||||||||||||||||
937580 | 937580 | MA | Barnstable | school | 2509210 | 224 | Orleans | 250921001477 | 2240005 | Orleans Elementary | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 32 | 1 | 0 | 0 | 1 | 0 | 1 | 16 | 19 | 35 | 32 | 1 | 0 | 0 | 1 | 0 | 1 | 16 | 19 | 35 | |||||||||||||||||||||||||||||||||
937870 | 937870 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown Schools | Regular School | No | 1 | PK | 08 | 2016 | grade_5 | 7 | 2 | 4 | 0 | 0 | 0 | 1 | 10 | 4 | 14 | 7 | 2 | 4 | 0 | 0 | 0 | 1 | 10 | 4 | 14 | |||||||||||||||||||||||||||||||||
938216 | 938216 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002535 | 2610025 | Oak Ridge | Regular School | No | 1 | 03 | 06 | 2016 | grade_5 | 230 | 1 | 1 | 2 | 7 | 0 | 1 | 122 | 120 | 242 | 230 | 1 | 1 | 2 | 7 | 0 | 1 | 122 | 120 | 242 | |||||||||||||||||||||||||||||||||
939110 | 939110 | MA | Barnstable | school | 2511730 | 300 | Truro | 251173001930 | 3000005 | Truro Central | Regular School | No | 1 | PK | 06 | 2016 | grade_5 | 12 | 0 | 1 | 0 | 1 | 0 | 1 | 6 | 9 | 15 | 12 | 0 | 1 | 0 | 1 | 0 | 1 | 6 | 9 | 15 | |||||||||||||||||||||||||||||||||
939425 | 939425 | MA | Barnstable | school | 2512300 | 318 | Wellfleet | 251230002031 | 3180005 | Wellfleet Elementary | Regular School | No | 1 | PK | 05 | 2016 | grade_5 | 14 | 1 | 1 | 0 | 0 | 0 | 1 | 7 | 10 | 17 | 14 | 1 | 1 | 0 | 0 | 0 | 1 | 7 | 10 | 17 | |||||||||||||||||||||||||||||||||
941023 | 941023 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414002803 | 6450050 | N H Wixon Innovation School | Regular School | No | 2 | 04 | 05 | 2016 | grade_5 | 177 | 16 | 11 | 3 | 6 | 0 | 9 | 116 | 106 | 222 | 177 | 16 | 11 | 3 | 6 | 0 | 9 | 116 | 106 | 222 | |||||||||||||||||||||||||||||||||
941330 | 941330 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402832 | 7120315 | Monomoy Regional Middle School | Regular School | No | 2 | 05 | 07 | 2016 | grade_5 | 140 | 6 | 9 | 0 | 2 | 0 | 8 | 74 | 91 | 165 | 140 | 6 | 9 | 0 | 2 | 0 | 8 | 74 | 91 | 165 | |||||||||||||||||||||||||||||||||
1122320 | 1122320 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2017 | grade_5 | 301 | 30 | 51 | 0 | 9 | 0 | 15 | 226 | 180 | 406 | 301 | 30 | 51 | 0 | 9 | 0 | 15 | 226 | 180 | 406 | |||||||||||||||||||||||||||||||||
1123474 | 1123474 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 147 | 2 | 10 | 1 | 1 | 0 | 2 | 83 | 80 | 163 | 147 | 2 | 10 | 1 | 1 | 0 | 2 | 83 | 80 | 163 | |||||||||||||||||||||||||||||||||
1123566 | 1123566 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2017 | grade_5 | 65 | 4 | 6 | 0 | 0 | 0 | 2 | 38 | 39 | 77 | 65 | 4 | 6 | 0 | 0 | 0 | 2 | 38 | 39 | 77 | |||||||||||||||||||||||||||||||||
1124515 | 1124515 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_5 | 24 | 3 | 0 | 0 | 1 | 0 | 0 | 14 | 14 | 28 | 24 | 3 | 0 | 0 | 1 | 0 | 0 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||
1124856 | 1124856 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000688 | 960305 | Morse Pond School | Regular School | No | Middle | 05 | 06 | 2017 | grade_5 | 216 | 20 | 16 | 2 | 3 | 1 | 15 | 138 | 135 | 273 | 216 | 20 | 16 | 2 | 3 | 1 | 15 | 138 | 135 | 273 | |||||||||||||||||||||||||||||||||
1126741 | 1126741 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744001546 | 1720035 | Quashnet School | Regular School | No | Elementary | 03 | 06 | 2017 | grade_5 | 83 | 3 | 3 | 6 | 2 | 0 | 5 | 60 | 42 | 102 | 83 | 3 | 3 | 6 | 2 | 0 | 5 | 60 | 42 | 102 | |||||||||||||||||||||||||||||||||
1127939 | 1127939 | MA | Barnstable | school | 2509210 | 224 | Orleans | 250921001477 | 2240005 | Orleans Elementary | Regular School | No | Elementary | KG | 05 | 2017 | grade_5 | 32 | 0 | 0 | 0 | 2 | 0 | 1 | 19 | 16 | 35 | 32 | 0 | 0 | 0 | 2 | 0 | 1 | 19 | 16 | 35 | |||||||||||||||||||||||||||||||||
1128277 | 1128277 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown Schools | Regular School | No | Elementary | PK | 08 | 2017 | grade_5 | 5 | 2 | 1 | 0 | 0 | 0 | 1 | 5 | 4 | 9 | 5 | 2 | 1 | 0 | 0 | 0 | 1 | 5 | 4 | 9 | |||||||||||||||||||||||||||||||||
1128697 | 1128697 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002535 | 2610025 | Oak Ridge | Regular School | No | Elementary | 03 | 06 | 2017 | grade_5 | 231 | 0 | 4 | 0 | 2 | 0 | 1 | 108 | 130 | 238 | 231 | 0 | 4 | 0 | 2 | 0 | 1 | 108 | 130 | 238 | |||||||||||||||||||||||||||||||||
1129765 | 1129765 | MA | Barnstable | school | 2511730 | 300 | Truro | 251173001930 | 3000005 | Truro Central | Regular School | No | Elementary | PK | 06 | 2017 | grade_5 | 15 | 0 | 2 | 0 | 0 | 0 | 1 | 8 | 10 | 18 | 15 | 0 | 2 | 0 | 0 | 0 | 1 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
1130138 | 1130138 | MA | Barnstable | school | 2512300 | 318 | Wellfleet | 251230002031 | 3180005 | Wellfleet Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_5 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 5 | 10 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 5 | 10 | |||||||||||||||||||||||||||||||||
1131997 | 1131997 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414002803 | 6450050 | N H Wixon Innovation School | Regular School | No | Elementary | 04 | 05 | 2017 | grade_5 | 170 | 18 | 30 | 6 | 5 | 0 | 13 | 113 | 129 | 242 | 170 | 18 | 30 | 6 | 5 | 0 | 13 | 113 | 129 | 242 | |||||||||||||||||||||||||||||||||
1132366 | 1132366 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402832 | 7120315 | Monomoy Regional Middle School | Regular School | No | Middle | 05 | 07 | 2017 | grade_5 | 117 | 9 | 15 | 1 | 1 | 1 | 5 | 74 | 75 | 149 | 117 | 9 | 15 | 1 | 1 | 1 | 5 | 74 | 75 | 149 | |||||||||||||||||||||||||||||||||
1365093 | 1365093 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2020 | grade_5 | 269 | 35 | 72 | 2 | 6 | 0 | 26 | 220 | 190 | * | 410.0 | 269 | 35 | 72 | 2 | 6 | 0 | 26 | 220 | 190 | 410 | ||||||||||||||||||||||||||||||||
1366063 | 1366063 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002909 | 360030 | Bourne Intermediate School | Regular School | No | Elementary | 03 | 05 | 2020 | grade_5 | 147 | 2 | 10 | 0 | 1 | 0 | 5 | 85 | 80 | * | 165.0 | 147 | 2 | 10 | 0 | 1 | 0 | 5 | 85 | 80 | 165 | ||||||||||||||||||||||||||||||||
1366133 | 1366133 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2020 | grade_5 | 69 | 1 | 8 | 0 | 2 | 0 | 4 | 43 | 41 | * | 84.0 | 69 | 1 | 8 | 0 | 2 | 0 | 4 | 43 | 41 | 84 | ||||||||||||||||||||||||||||||||
1366943 | 1366943 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 23 | 2 | 0 | 0 | 0 | 0 | 1 | 11 | 15 | * | 26.0 | 23 | 2 | 0 | 0 | 0 | 0 | 1 | 11 | 15 | 26 | ||||||||||||||||||||||||||||||||
1367235 | 1367235 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000688 | 960305 | Morse Pond School | Regular School | No | Middle | 05 | 06 | 2020 | grade_5 | 225 | 13 | 13 | 1 | 4 | 0 | 13 | 131 | 138 | * | 269.0 | 225 | 13 | 13 | 1 | 4 | 0 | 13 | 131 | 138 | 269 | ||||||||||||||||||||||||||||||||
1368799 | 1368799 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744001546 | 1720035 | Quashnet School | Regular School | No | Elementary | 03 | 06 | 2020 | grade_5 | 86 | 2 | 8 | 8 | 2 | 0 | 11 | 56 | 61 | * | 117.0 | 86 | 2 | 8 | 8 | 2 | 0 | 11 | 56 | 61 | 117 | ||||||||||||||||||||||||||||||||
1369808 | 1369808 | MA | Barnstable | school | 2509210 | 224 | Orleans | 250921001477 | 2240005 | Orleans Elementary | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 30 | 1 | 0 | 0 | 0 | 0 | 1 | 22 | 10 | * | 32.0 | 30 | 1 | 0 | 0 | 0 | 0 | 1 | 22 | 10 | 32 | ||||||||||||||||||||||||||||||||
1370096 | 1370096 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_5 | 5 | 5 | 2 | 0 | 0 | 0 | 1 | 3 | 10 | * | 13.0 | 5 | 5 | 2 | 0 | 0 | 0 | 1 | 3 | 10 | 13 | ||||||||||||||||||||||||||||||||
1370445 | 1370445 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002535 | 2610025 | Oak Ridge | Regular School | No | Elementary | 03 | 06 | 2020 | grade_5 | 172 | 2 | 2 | 0 | 3 | 0 | 2 | 94 | 87 | * | 181.0 | 172 | 2 | 2 | 0 | 3 | 0 | 2 | 94 | 87 | 181 | ||||||||||||||||||||||||||||||||
1371351 | 1371351 | MA | Barnstable | school | 2511730 | 300 | Truro | 251173001930 | 3000005 | Truro Central | Regular School | No | Elementary | PK | 06 | 2020 | grade_5 | 9 | 0 | 1 | 0 | 0 | 0 | 2 | 9 | 3 | * | 12.0 | 9 | 0 | 1 | 0 | 0 | 0 | 2 | 9 | 3 | 12 | ||||||||||||||||||||||||||||||||
1371669 | 1371669 | MA | Barnstable | school | 2512300 | 318 | Wellfleet | 251230002031 | 3180005 | Wellfleet Elementary | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 17 | 1 | 1 | 0 | 0 | 0 | 0 | 9 | 10 | * | 19.0 | 17 | 1 | 1 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||
1373251 | 1373251 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414002803 | 6450050 | N H Wixon Innovation School | Regular School | No | Elementary | 04 | 05 | 2020 | grade_5 | 164 | 17 | 21 | 8 | 2 | 0 | 28 | 123 | 117 | * | 240.0 | 164 | 17 | 21 | 8 | 2 | 0 | 28 | 123 | 117 | 240 | ||||||||||||||||||||||||||||||||
1373563 | 1373563 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402832 | 7120315 | Monomoy Regional Middle School | Regular School | No | Middle | 05 | 07 | 2020 | grade_5 | 137 | 6 | 10 | 1 | 0 | 0 | 8 | 69 | 93 | * | 162.0 | 137 | 6 | 10 | 1 | 0 | 0 | 8 | 69 | 93 | 162 | ||||||||||||||||||||||||||||||||
1672317 | 1672317 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable - Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2021 | grade_5 | 226 | 30 | 80 | 1 | 9 | 0 | 18 | 192 | 171 | * | 364.0 | 226 | 30 | 80 | 1 | 9 | 0 | 18 | 192 | 171 | 364 | ||||||||||||||||||||||||||||||||
1673299 | 1673299 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002909 | 360030 | Bourne - Bourne Intermediate School | Regular School | No | Elementary | 03 | 05 | 2021 | grade_5 | 126 | 5 | 15 | 1 | 2 | 0 | 6 | 69 | 86 | * | 155.0 | 126 | 5 | 15 | 1 | 2 | 0 | 6 | 69 | 86 | 155 | ||||||||||||||||||||||||||||||||
1673366 | 1673366 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Brewster - Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2021 | grade_5 | 64 | 3 | 5 | 0 | 0 | 0 | 4 | 40 | 36 | * | 76.0 | 64 | 3 | 5 | 0 | 0 | 0 | 4 | 40 | 36 | 76 | ||||||||||||||||||||||||||||||||
1674173 | 1674173 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham - Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2021 | grade_5 | 25 | 3 | 1 | 0 | 1 | 0 | 0 | 14 | 16 | * | 30.0 | 25 | 3 | 1 | 0 | 1 | 0 | 0 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||
1674469 | 1674469 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000688 | 960305 | Falmouth - Morse Pond School | Regular School | No | Middle | 05 | 06 | 2021 | grade_5 | 195 | 8 | 19 | 1 | 3 | 1 | 20 | 119 | 128 | * | 247.0 | 195 | 8 | 19 | 1 | 3 | 1 | 20 | 119 | 128 | 247 | ||||||||||||||||||||||||||||||||
1676049 | 1676049 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744001546 | 1720035 | Mashpee - Quashnet School | Regular School | No | Elementary | 03 | 06 | 2021 | grade_5 | 82 | 7 | 10 | 8 | 1 | 0 | 11 | 57 | 62 | * | 119.0 | 82 | 7 | 10 | 8 | 1 | 0 | 11 | 57 | 62 | 119 | ||||||||||||||||||||||||||||||||
1677055 | 1677055 | MA | Barnstable | school | 2509210 | 224 | Orleans | 250921001477 | 2240005 | Orleans - Orleans Elementary | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 29 | 1 | 5 | 0 | 1 | 0 | 1 | 15 | 22 | * | 37.0 | 29 | 1 | 5 | 0 | 1 | 0 | 1 | 15 | 22 | 37 | ||||||||||||||||||||||||||||||||
1677344 | 1677344 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown - Provincetown Schools | Regular School | No | Elementary | PK | 08 | 2021 | grade_5 | 8 | 1 | 2 | 0 | 1 | 0 | 3 | 8 | 7 | * | 15.0 | 8 | 1 | 2 | 0 | 1 | 0 | 3 | 8 | 7 | 15 | ||||||||||||||||||||||||||||||||
1677696 | 1677696 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002535 | 2610025 | Sandwich - Oak Ridge | Regular School | No | Elementary | 03 | 06 | 2021 | grade_5 | 173 | 2 | 8 | 0 | 7 | 2 | 0 | 99 | 93 | * | 192.0 | 173 | 2 | 8 | 0 | 7 | 2 | 0 | 99 | 93 | 192 | ||||||||||||||||||||||||||||||||
1678603 | 1678603 | MA | Barnstable | school | 2511730 | 300 | Truro | 251173001930 | 3000005 | Truro - Truro Central | Regular School | No | Elementary | PK | 06 | 2021 | grade_5 | 12 | 1 | 2 | 0 | 0 | 0 | 3 | 11 | 7 | * | 18.0 | 12 | 1 | 2 | 0 | 0 | 0 | 3 | 11 | 7 | 18 | ||||||||||||||||||||||||||||||||
1678919 | 1678919 | MA | Barnstable | school | 2512300 | 318 | Wellfleet | 251230002031 | 3180005 | Wellfleet - Wellfleet Elementary | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 12 | 0 | 0 | 0 | 0 | 0 | 3 | 7 | 8 | * | 15.0 | 12 | 0 | 0 | 0 | 0 | 0 | 3 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||
1680515 | 1680515 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414002803 | 6450050 | Dennis-Yarmouth - Nathaniel H. Wixon School | Regular School | No | Elementary | 04 | 05 | 2021 | grade_5 | 166 | 21 | 25 | 3 | 8 | 0 | 22 | 136 | 109 | * | 245.0 | 166 | 21 | 25 | 3 | 8 | 0 | 22 | 136 | 109 | 245 | ||||||||||||||||||||||||||||||||
1680826 | 1680826 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402832 | 7120315 | Monomoy Regional School District - Monomoy Regional Middle School | Regular School | No | Middle | 05 | 07 | 2021 | grade_5 | 116 | 11 | 13 | 1 | 5 | 0 | 7 | 88 | 65 | * | 153.0 | 116 | 11 | 13 | 1 | 5 | 0 | 7 | 88 | 65 | 153 | ||||||||||||||||||||||||||||||||
2040119 | 2040119 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2019 | grade_5 | 279 | 24 | 65 | 4 | 8 | 1 | 15 | 209 | 187 | 396.0 | 279 | 24 | 65 | 4 | 8 | 1 | 15 | 209 | 187 | 396 | |||||||||||||||||||||||||||||||||
2041122 | 2041122 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 150 | 2 | 7 | 4 | 4 | 0 | 5 | 81 | 91 | 172.0 | 150 | 2 | 7 | 4 | 4 | 0 | 5 | 81 | 91 | 172 | |||||||||||||||||||||||||||||||||
2041200 | 2041200 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2019 | grade_5 | 76 | 1 | 4 | 0 | 1 | 0 | 3 | 44 | 41 | 85.0 | 76 | 1 | 4 | 0 | 1 | 0 | 3 | 44 | 41 | 85 | |||||||||||||||||||||||||||||||||
2042014 | 2042014 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2019 | grade_5 | 19 | 2 | 0 | 0 | 2 | 0 | 1 | 13 | 11 | 24.0 | 19 | 2 | 0 | 0 | 2 | 0 | 1 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
2042305 | 2042305 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000688 | 960305 | Morse Pond School | Regular School | No | Middle | 05 | 06 | 2019 | grade_5 | 225 | 8 | 14 | 12 | 5 | 0 | 22 | 153 | 133 | 286.0 | 225 | 8 | 14 | 12 | 5 | 0 | 22 | 153 | 133 | 286 | |||||||||||||||||||||||||||||||||
2043870 | 2043870 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744001546 | 1720035 | Quashnet School | Regular School | No | Elementary | 03 | 06 | 2019 | grade_5 | 100 | 6 | 4 | 9 | 2 | 0 | 7 | 64 | 64 | 128.0 | 100 | 6 | 4 | 9 | 2 | 0 | 7 | 64 | 64 | 128 | |||||||||||||||||||||||||||||||||
2044881 | 2044881 | MA | Barnstable | school | 2509210 | 224 | Orleans | 250921001477 | 2240005 | Orleans Elementary | Regular School | No | Elementary | KG | 05 | 2019 | grade_5 | 39 | 1 | 1 | 0 | 2 | 0 | 2 | 27 | 18 | 45.0 | 39 | 1 | 1 | 0 | 2 | 0 | 2 | 27 | 18 | 45 | |||||||||||||||||||||||||||||||||
2045170 | 2045170 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown Schools | Regular School | No | Elementary | PK | 08 | 2019 | grade_5 | 12 | 2 | 2 | 0 | 0 | 0 | 2 | 8 | 10 | 18.0 | 12 | 2 | 2 | 0 | 0 | 0 | 2 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
2045519 | 2045519 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002535 | 2610025 | Oak Ridge | Regular School | No | Elementary | 03 | 06 | 2019 | grade_5 | 189 | 4 | 5 | 2 | 8 | 0 | 2 | 106 | 104 | 210.0 | 189 | 4 | 5 | 2 | 8 | 0 | 2 | 106 | 104 | 210 | |||||||||||||||||||||||||||||||||
2046427 | 2046427 | MA | Barnstable | school | 2511730 | 300 | Truro | 251173001930 | 3000005 | Truro Central | Regular School | No | Elementary | PK | 06 | 2019 | grade_5 | 12 | 1 | 2 | 0 | 0 | 0 | 1 | 8 | 8 | 16.0 | 12 | 1 | 2 | 0 | 0 | 0 | 1 | 8 | 8 | 16 | |||||||||||||||||||||||||||||||||
2046743 | 2046743 | MA | Barnstable | school | 2512300 | 318 | Wellfleet | 251230002031 | 3180005 | Wellfleet Elementary | Regular School | No | Elementary | PK | 05 | 2019 | grade_5 | 9 | 1 | 0 | 0 | 0 | 0 | 1 | 6 | 5 | 11.0 | 9 | 1 | 0 | 0 | 0 | 0 | 1 | 6 | 5 | 11 | |||||||||||||||||||||||||||||||||
2048313 | 2048313 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414002803 | 6450050 | N H Wixon Innovation School | Regular School | No | Elementary | 04 | 05 | 2019 | grade_5 | 162 | 28 | 47 | 7 | 4 | 0 | 17 | 136 | 129 | 265.0 | 162 | 28 | 47 | 7 | 4 | 0 | 17 | 136 | 129 | 265 | |||||||||||||||||||||||||||||||||
2048624 | 2048624 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402832 | 7120315 | Monomoy Regional Middle School | Regular School | No | Middle | 05 | 07 | 2019 | grade_5 | 112 | 9 | 12 | 2 | 2 | 0 | 12 | 68 | 81 | 149.0 | 112 | 9 | 12 | 2 | 2 | 0 | 12 | 68 | 81 | 149 | |||||||||||||||||||||||||||||||||
2229126 | 2229126 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable: Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2018 | grade_5 | 324 | 29 | 53 | 0 | 11 | 3 | 13 | 216 | 217 | 433.0 | 324 | 29 | 53 | 0 | 11 | 3 | 13 | 216 | 217 | 433 | |||||||||||||||||||||||||||||||||
2230292 | 2230292 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne: Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 136 | 2 | 6 | 2 | 2 | 0 | 8 | 90 | 66 | 156.0 | 136 | 2 | 6 | 2 | 2 | 0 | 8 | 90 | 66 | 156 | |||||||||||||||||||||||||||||||||
2230384 | 2230384 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Brewster: Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2018 | grade_5 | 70 | 1 | 3 | 0 | 2 | 0 | 2 | 38 | 40 | 78.0 | 70 | 1 | 3 | 0 | 2 | 0 | 2 | 38 | 40 | 78 | |||||||||||||||||||||||||||||||||
2231332 | 2231332 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham: Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2018 | grade_5 | 35 | 3 | 0 | 1 | 0 | 0 | 0 | 19 | 20 | 39.0 | 35 | 3 | 0 | 1 | 0 | 0 | 0 | 19 | 20 | 39 | |||||||||||||||||||||||||||||||||
2231683 | 2231683 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000688 | 960305 | Falmouth: Morse Pond School | Regular School | No | Middle | 05 | 06 | 2018 | grade_5 | 222 | 13 | 14 | 2 | 10 | 0 | 16 | 140 | 137 | 277.0 | 222 | 13 | 14 | 2 | 10 | 0 | 16 | 140 | 137 | 277 | |||||||||||||||||||||||||||||||||
2233562 | 2233562 | MA | Barnstable | school | 2507440 | 172 | Mashpee | 250744001546 | 1720035 | Mashpee: Quashnet School | Regular School | No | Elementary | 03 | 06 | 2018 | grade_5 | 105 | 3 | 3 | 9 | 4 | 0 | 11 | 65 | 70 | 135.0 | 105 | 3 | 3 | 9 | 4 | 0 | 11 | 65 | 70 | 135 | |||||||||||||||||||||||||||||||||
2234761 | 2234761 | MA | Barnstable | school | 2509210 | 224 | Orleans | 250921001477 | 2240005 | Orleans: Orleans Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_5 | 33 | 1 | 0 | 0 | 1 | 0 | 0 | 18 | 17 | 35.0 | 33 | 1 | 0 | 0 | 1 | 0 | 0 | 18 | 17 | 35 | |||||||||||||||||||||||||||||||||
2235098 | 2235098 | MA | Barnstable | school | 2509840 | 242 | Provincetown | 250984002694 | 2420020 | Provincetown: Provincetown Schools | Regular School | No | Elementary | PK | 08 | 2018 | grade_5 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 3 | 5 | 8.0 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | |||||||||||||||||||||||||||||||||
2235519 | 2235519 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002535 | 2610025 | Sandwich: Oak Ridge | Regular School | No | Elementary | 03 | 06 | 2018 | grade_5 | 191 | 4 | 4 | 1 | 2 | 0 | 3 | 107 | 98 | 205.0 | 191 | 4 | 4 | 1 | 2 | 0 | 3 | 107 | 98 | 205 | |||||||||||||||||||||||||||||||||
2236581 | 2236581 | MA | Barnstable | school | 2511730 | 300 | Truro | 251173001930 | 3000005 | Truro: Truro Central | Regular School | No | Elementary | PK | 05 | 2018 | grade_5 | 14 | 1 | 4 | 0 | 0 | 0 | 0 | 6 | 13 | 19.0 | 14 | 1 | 4 | 0 | 0 | 0 | 0 | 6 | 13 | 19 | |||||||||||||||||||||||||||||||||
2236953 | 2236953 | MA | Barnstable | school | 2512300 | 318 | Wellfleet | 251230002031 | 3180005 | Wellfleet: Wellfleet Elementary | Regular School | No | Elementary | PK | 05 | 2018 | grade_5 | 26 | 0 | 3 | 0 | 0 | 0 | 0 | 10 | 19 | 29.0 | 26 | 0 | 3 | 0 | 0 | 0 | 0 | 10 | 19 | 29 | |||||||||||||||||||||||||||||||||
2238828 | 2238828 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414002803 | 6450050 | Dennis-Yarmouth: N H Wixon Innovation School | Regular School | No | Elementary | 04 | 05 | 2018 | grade_5 | 194 | 21 | 30 | 6 | 7 | 0 | 13 | 136 | 135 | 271.0 | 194 | 21 | 30 | 6 | 7 | 0 | 13 | 136 | 135 | 271 | |||||||||||||||||||||||||||||||||
2239197 | 2239197 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054402832 | 7120315 | Monomoy Regional School District: Monomoy Regional Middle School | Regular School | No | Middle | 05 | 07 | 2018 | grade_5 | 162 | 14 | 10 | 0 | 1 | 1 | 2 | 100 | 90 | 190.0 | 162 | 14 | 10 | 0 | 1 | 1 | 2 | 100 | 90 | 190 | |||||||||||||||||||||||||||||||||
737605 | 737605 | MA | Berkshire | school | 2503720 | 63 | Clarksburg | 250372000510 | 630010 | Clarksburg Elementary | Regular School | No | 1 | KG | 08 | 2015 | grade_5 | 16 | 0 | 1 | 0 | 1 | 0 | 1 | 11 | 8 | 19 | 16 | 0 | 1 | 0 | 1 | 0 | 1 | 11 | 8 | 19 | |||||||||||||||||||||||||||||||||
738209 | 738209 | MA | Berkshire | school | 2504920 | 98 | Florida | 250492000706 | 980005 | Abbott Memorial | Regular School | No | 1 | PK | 08 | 2015 | grade_5 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | |||||||||||||||||||||||||||||||||
738518 | 738518 | MA | Berkshire | school | 2505760 | 121 | Hancock | 250576000826 | 1210005 | Hancock Elementary | Regular School | No | 1 | PK | 06 | 2015 | grade_5 | * | * | * | * | * | * | * | 2 | 2 | 4 | 2 | 2 | 4 | ||||||||||||||||||||||||||||||||||||||||
738885 | 738885 | MA | Berkshire | school | 2506630 | 148 | Lanesborough | 250663000949 | 1480005 | Lanesborough Elementary | Regular School | No | 1 | PK | 06 | 2015 | grade_5 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 21 | 33 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 21 | 33 | |||||||||||||||||||||||||||||||||
739032 | 739032 | MA | Berkshire | school | 2506690 | 150 | Lee | 250669000969 | 1500025 | Lee Elementary | Regular School | No | 1 | PK | 06 | 2015 | grade_5 | 39 | 0 | 8 | 0 | 1 | 0 | 3 | 27 | 24 | 51 | 39 | 0 | 8 | 0 | 1 | 0 | 3 | 27 | 24 | 51 | |||||||||||||||||||||||||||||||||
739060 | 739060 | MA | Berkshire | school | 2506750 | 152 | Lenox | 250675000979 | 1520015 | Morris | Regular School | No | 1 | PK | 05 | 2015 | grade_5 | 54 | 0 | 1 | 0 | 2 | 0 | 0 | 19 | 38 | 57 | 54 | 0 | 1 | 0 | 2 | 0 | 0 | 19 | 38 | 57 | |||||||||||||||||||||||||||||||||
740432 | 740432 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001388 | 2090008 | J S Sullivan | Regular School | No | 1 | KG | 07 | 2015 | grade_5 | 31 | 0 | 0 | 0 | 0 | 0 | 3 | 15 | 19 | 34 | 31 | 0 | 0 | 0 | 0 | 0 | 3 | 15 | 19 | 34 |
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]);