enrollments
Data source: Big Local News · About: Big Local
6,218 rows where grade = "grade_5" and state = "MA" sorted by total 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1365337 | 1365337 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002622 | 350020 | Curley K-8 School | Regular School | No | Elementary | PK | 08 | 2020 | grade_5 | 30 | 17 | 44 | 0 | 3 | 0 | 5 | 39 | 60 | * | 99.0 | 30 | 17 | 44 | 0 | 3 | 0 | 5 | 39 | 60 | 99 | ||||||||||||||||||||||||||||||||
1368012 | 1368012 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000956 | 1490040 | Francis M Leahy | Regular School | No | Elementary | 01 | 05 | 2020 | grade_5 | 1 | 0 | 98 | 0 | 0 | 0 | 0 | 55 | 44 | * | 99.0 | 1 | 0 | 98 | 0 | 0 | 0 | 0 | 55 | 44 | 99 | ||||||||||||||||||||||||||||||||
1369606 | 1369606 | MA | Bristol | school | 2508730 | 212 | North Attleborough | 250873001404 | 2120013 | Joseph W Martin Jr Elementary | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 83 | 5 | 2 | 0 | 5 | 0 | 4 | 48 | 51 | * | 99.0 | 83 | 5 | 2 | 0 | 5 | 0 | 4 | 48 | 51 | 99 | ||||||||||||||||||||||||||||||||
1373054 | 1373054 | MA | Worcester | school | 2502040 | 610 | Ashburnham-Westminster | 250204002367 | 6100005 | Westminster Elementary | Regular School | No | Elementary | 02 | 05 | 2020 | grade_5 | 86 | 0 | 6 | 0 | 1 | 0 | 6 | 53 | 46 | * | 99.0 | 86 | 0 | 6 | 0 | 1 | 0 | 6 | 53 | 46 | 99 | ||||||||||||||||||||||||||||||||
1672113 | 1672113 | MA | Essex | school | 2501950 | 9 | Andover | 250195000047 | 90003 | Andover - Bancroft Elementary | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 74 | 2 | 9 | 0 | 8 | 0 | 6 | 56 | 43 | * | 99.0 | 74 | 2 | 9 | 0 | 8 | 0 | 6 | 56 | 43 | 99 | ||||||||||||||||||||||||||||||||
1672748 | 1672748 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000268 | 350167 | Boston - UP Academy Holland | Regular School | No | Elementary | PK | 05 | 2021 | grade_5 | 1 | 50 | 36 | 0 | 9 | 0 | 3 | 44 | 55 | * | 99.0 | 1 | 50 | 36 | 0 | 9 | 0 | 3 | 44 | 55 | 99 | ||||||||||||||||||||||||||||||||
1673337 | 1673337 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000368 | 400025 | Braintree - Liberty | Regular School | No | Elementary | 01 | 05 | 2021 | grade_5 | 55 | 1 | 4 | 0 | 35 | 1 | 3 | 47 | 52 | * | 99.0 | 55 | 1 | 4 | 0 | 35 | 1 | 3 | 47 | 52 | 99 | ||||||||||||||||||||||||||||||||
1674371 | 1674371 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002656 | 950013 | Fall River - Letourneau Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_5 | 48 | 8 | 38 | 0 | 1 | 0 | 4 | 44 | 55 | * | 99.0 | 48 | 8 | 38 | 0 | 1 | 0 | 4 | 44 | 55 | 99 | ||||||||||||||||||||||||||||||||
1675377 | 1675377 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678000985 | 1530025 | Leominster - Johnny Appleseed | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 35 | 13 | 38 | 0 | 7 | 0 | 6 | 45 | 54 | * | 99.0 | 35 | 13 | 38 | 0 | 7 | 0 | 6 | 45 | 54 | 99 | ||||||||||||||||||||||||||||||||
1676310 | 1676310 | MA | Norfolk | school | 2507980 | 189 | Milton | 250798001259 | 1890005 | Milton - Collicot | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 79 | 4 | 4 | 0 | 8 | 0 | 4 | 58 | 41 | * | 99.0 | 79 | 4 | 4 | 0 | 8 | 0 | 4 | 58 | 41 | 99 | ||||||||||||||||||||||||||||||||
1678963 | 1678963 | MA | Plymouth | school | 2512420 | 323 | West Bridgewater | 251242002036 | 3230305 | West Bridgewater - Howard School | Regular School | No | Middle | 04 | 06 | 2021 | grade_5 | 82 | 6 | 4 | 0 | 2 | 0 | 5 | 47 | 52 | * | 99.0 | 82 | 6 | 4 | 0 | 2 | 0 | 5 | 47 | 52 | 99 | ||||||||||||||||||||||||||||||||
2040290 | 2040290 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000180 | 310026 | Hajjar Elementary | Regular School | No | Elementary | KG | 05 | 2019 | grade_5 | 74 | 9 | 11 | 0 | 5 | 0 | 0 | 57 | 42 | 99.0 | 74 | 9 | 11 | 0 | 5 | 0 | 0 | 57 | 42 | 99 | |||||||||||||||||||||||||||||||||
2042031 | 2042031 | MA | Hampshire | school | 2504590 | 86 | Easthampton | 250459000616 | 860305 | White Brook Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 80 | 1 | 13 | 0 | 5 | 0 | 0 | 58 | 41 | 99.0 | 80 | 1 | 13 | 0 | 5 | 0 | 0 | 58 | 41 | 99 | |||||||||||||||||||||||||||||||||
2043279 | 2043279 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684000998 | 1550030 | Harrington | Regular School | No | Elementary | KG | 05 | 2019 | grade_5 | 34 | 1 | 5 | 1 | 55 | 0 | 3 | 57 | 42 | 99.0 | 34 | 1 | 5 | 1 | 55 | 0 | 3 | 57 | 42 | 99 | |||||||||||||||||||||||||||||||||
2045249 | 2045249 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001581 | 2430320 | Reay E Sterling Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_5 | 42 | 18 | 8 | 0 | 23 | 0 | 8 | 60 | 39 | 99.0 | 42 | 18 | 8 | 0 | 23 | 0 | 8 | 60 | 39 | 99 | |||||||||||||||||||||||||||||||||
2047911 | 2047911 | MA | Suffolk | school | 2500039 | 481 | Boston Renaissance Charter Public (District) | 250003900599 | 4810550 | Boston Renaissance Charter Public School | Regular School | Yes | Elementary | PK | 06 | 2019 | grade_5 | 2 | 64 | 26 | 0 | 1 | 0 | 6 | 44 | 55 | 99.0 | 2 | 64 | 26 | 0 | 1 | 0 | 6 | 44 | 55 | 99 | |||||||||||||||||||||||||||||||||
2047959 | 2047959 | MA | Middlesex | school | 2500046 | 487 | Prospect Hill Academy Charter (District) | 250004600819 | 4870550 | Prospect Hill Academy Charter School | Regular School | Yes | Other | KG | 12 | 2019 | grade_5 | 10 | 55 | 24 | 0 | 7 | 1 | 2 | 51 | 48 | 99.0 | 10 | 55 | 24 | 0 | 7 | 1 | 2 | 51 | 48 | 99 | |||||||||||||||||||||||||||||||||
2231156 | 2231156 | MA | Bristol | school | 2504020 | 72 | Dartmouth | 250402000544 | 720015 | Dartmouth: Joseph Demello | Regular School | No | Elementary | 01 | 05 | 2018 | grade_5 | 91 | 1 | 1 | 0 | 0 | 0 | 6 | 56 | 43 | 99.0 | 91 | 1 | 1 | 0 | 0 | 0 | 6 | 56 | 43 | 99 | |||||||||||||||||||||||||||||||||
2231552 | 2231552 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002650 | 950011 | Fall River: Mary Fonseca Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | grade_5 | 40 | 7 | 34 | 1 | 6 | 0 | 11 | 43 | 56 | 99.0 | 40 | 7 | 34 | 1 | 6 | 0 | 11 | 43 | 56 | 99 | |||||||||||||||||||||||||||||||||
2232300 | 2232300 | MA | Plymouth | school | 2506090 | 131 | Hingham | 250609000874 | 1310020 | Hingham: South Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_5 | 82 | 2 | 3 | 0 | 5 | 0 | 7 | 51 | 48 | 99.0 | 82 | 2 | 3 | 0 | 5 | 0 | 7 | 51 | 48 | 99 | |||||||||||||||||||||||||||||||||
2232856 | 2232856 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684000996 | 1550015 | Lexington: Fiske | Regular School | No | Elementary | KG | 05 | 2018 | grade_5 | 57 | 2 | 2 | 0 | 28 | 0 | 10 | 53 | 46 | 99.0 | 57 | 2 | 2 | 0 | 28 | 0 | 10 | 53 | 46 | 99 | |||||||||||||||||||||||||||||||||
2233884 | 2233884 | MA | Norfolk | school | 2507980 | 189 | Milton | 250798002485 | 1890007 | Milton: Cunningham School | Regular School | No | Elementary | KG | 05 | 2018 | grade_5 | 77 | 11 | 7 | 0 | 2 | 0 | 2 | 58 | 41 | 99.0 | 77 | 11 | 7 | 0 | 2 | 0 | 2 | 58 | 41 | 99 | |||||||||||||||||||||||||||||||||
2235198 | 2235198 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001381 | 2430325 | Quincy: Point Webster Middle | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 40 | 13 | 10 | 0 | 31 | 0 | 5 | 48 | 51 | 99.0 | 40 | 13 | 10 | 0 | 31 | 0 | 5 | 48 | 51 | 99 | |||||||||||||||||||||||||||||||||
2235621 | 2235621 | MA | Bristol | school | 2510590 | 265 | Seekonk | 251059001695 | 2650007 | Seekonk: George R Martin | Regular School | No | Elementary | PK | 05 | 2018 | grade_5 | 85 | 0 | 4 | 0 | 4 | 0 | 6 | 59 | 40 | 99.0 | 85 | 0 | 4 | 0 | 4 | 0 | 6 | 59 | 40 | 99 | |||||||||||||||||||||||||||||||||
2235647 | 2235647 | MA | Norfolk | school | 2510620 | 266 | Sharon | 251062001702 | 2660005 | Sharon: Cottage Street | Regular School | No | Elementary | KG | 05 | 2018 | grade_5 | 61 | 3 | 5 | 0 | 26 | 0 | 4 | 51 | 48 | 99.0 | 61 | 3 | 5 | 0 | 26 | 0 | 4 | 51 | 48 | 99 | |||||||||||||||||||||||||||||||||
2238644 | 2238644 | MA | Worcester | school | 2502160 | 615 | Athol-Royalston | 250216000176 | 6150305 | Athol-Royalston: Athol-Royalston Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_5 | 81 | 1 | 11 | 0 | 2 | 0 | 4 | 55 | 44 | 99.0 | 81 | 1 | 11 | 0 | 2 | 0 | 4 | 55 | 44 | 99 | |||||||||||||||||||||||||||||||||
2239286 | 2239286 | MA | Worcester | school | 2508310 | 725 | Nashoba | 250831000362 | 7250020 | Nashoba: Center School | Regular School | No | Elementary | PK | 05 | 2018 | grade_5 | 79 | 0 | 7 | 1 | 11 | 0 | 1 | 54 | 45 | 99.0 | 79 | 0 | 7 | 1 | 11 | 0 | 1 | 54 | 45 | 99 | |||||||||||||||||||||||||||||||||
737083 | 737083 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000386 | 440010 | Brookfield | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 44 | 43 | 6 | 0 | 0 | 1 | 5 | 51 | 48 | 99 | 44 | 43 | 6 | 0 | 0 | 1 | 5 | 51 | 48 | 99 | |||||||||||||||||||||||||||||||||
737715 | 737715 | MA | Bristol | school | 2504020 | 72 | Dartmouth | 250402000544 | 720015 | Joseph Demello | Regular School | No | 1 | 01 | 05 | 2015 | grade_5 | 92 | 2 | 1 | 1 | 0 | 0 | 3 | 39 | 60 | 99 | 92 | 2 | 1 | 1 | 0 | 0 | 3 | 39 | 60 | 99 | |||||||||||||||||||||||||||||||||
737979 | 737979 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002038 | 930028 | George Keverian School | Regular School | No | 1 | KG | 08 | 2015 | grade_5 | 29 | 18 | 42 | 1 | 8 | 0 | 1 | 53 | 46 | 99 | 29 | 18 | 42 | 1 | 8 | 0 | 1 | 53 | 46 | 99 | |||||||||||||||||||||||||||||||||
739565 | 739565 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001344 | 1650003 | Beebe | Regular School | No | 1 | KG | 08 | 2015 | grade_5 | 28 | 17 | 14 | 0 | 37 | 0 | 3 | 44 | 55 | 99 | 28 | 17 | 14 | 0 | 37 | 0 | 3 | 44 | 55 | 99 | |||||||||||||||||||||||||||||||||
739574 | 739574 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001345 | 1650013 | Ferryway | Regular School | No | 1 | KG | 08 | 2015 | grade_5 | 23 | 29 | 22 | 1 | 23 | 0 | 1 | 41 | 58 | 99 | 23 | 29 | 22 | 1 | 23 | 0 | 1 | 41 | 58 | 99 | |||||||||||||||||||||||||||||||||
740741 | 740741 | MA | Franklin | school | 2509180 | 223 | Orange | 250918001475 | 2230010 | Dexter Park | Regular School | No | 1 | 03 | 06 | 2015 | grade_5 | 91 | 2 | 3 | 0 | 0 | 0 | 3 | 40 | 59 | 99 | 91 | 2 | 3 | 0 | 0 | 0 | 3 | 40 | 59 | 99 | |||||||||||||||||||||||||||||||||
740874 | 740874 | MA | Plymouth | school | 2509420 | 231 | Pembroke | 250942001510 | 2310015 | North Pembroke Elementary | Regular School | No | 1 | PK | 06 | 2015 | grade_5 | 93 | 0 | 3 | 0 | 1 | 0 | 2 | 48 | 51 | 99 | 93 | 0 | 3 | 0 | 1 | 0 | 2 | 48 | 51 | 99 | |||||||||||||||||||||||||||||||||
741233 | 741233 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001618 | 2480025 | Abraham Lincoln | Regular School | No | 1 | PK | 05 | 2015 | grade_5 | 39 | 8 | 45 | 0 | 4 | 0 | 3 | 55 | 44 | 99 | 39 | 8 | 45 | 0 | 4 | 0 | 3 | 55 | 44 | 99 | |||||||||||||||||||||||||||||||||
742185 | 742185 | MA | Bristol | school | 2511460 | 292 | Swansea | 251146001890 | 2920006 | Elizabeth S Brown | Regular School | No | 1 | 03 | 05 | 2015 | grade_5 | 95 | 0 | 4 | 0 | 0 | 0 | 0 | 53 | 46 | 99 | 95 | 0 | 4 | 0 | 0 | 0 | 0 | 53 | 46 | 99 | |||||||||||||||||||||||||||||||||
743206 | 743206 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002217 | 3480110 | Gates Lane | Regular School | No | 1 | PK | 06 | 2015 | grade_5 | 31 | 9 | 32 | 0 | 21 | 0 | 6 | 65 | 34 | 99 | 31 | 9 | 32 | 0 | 21 | 0 | 6 | 65 | 34 | 99 | |||||||||||||||||||||||||||||||||
744569 | 744569 | MA | Worcester | school | 2508280 | 720 | Narragansett | 250828001467 | 7200305 | Narragansett Middle | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 94 | 1 | 2 | 0 | 0 | 1 | 1 | 52 | 47 | 99 | 94 | 1 | 2 | 0 | 0 | 1 | 1 | 52 | 47 | 99 | |||||||||||||||||||||||||||||||||
744597 | 744597 | MA | Worcester | school | 2508310 | 725 | Nashoba | 250831001102 | 7250025 | Florence Sawyer School | Regular School | No | 1 | PK | 08 | 2015 | grade_5 | 88 | 0 | 4 | 0 | 3 | 0 | 4 | 42 | 57 | 99 | 88 | 0 | 4 | 0 | 3 | 0 | 4 | 42 | 57 | 99 | |||||||||||||||||||||||||||||||||
932994 | 932994 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000186 | 310005 | Thomas Ditson | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 82 | 3 | 7 | 0 | 4 | 1 | 2 | 41 | 58 | 99 | 82 | 3 | 7 | 0 | 4 | 1 | 2 | 41 | 58 | 99 | |||||||||||||||||||||||||||||||||
934517 | 934517 | MA | Middlesex | school | 2503840 | 67 | Concord | 250384000526 | 670030 | Willard | Regular School | No | 1 | PK | 05 | 2016 | grade_5 | 82 | 4 | 3 | 0 | 4 | 0 | 6 | 43 | 56 | 99 | 82 | 4 | 3 | 0 | 4 | 0 | 6 | 43 | 56 | 99 | |||||||||||||||||||||||||||||||||
937046 | 937046 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001327 | 2010078 | Hayden/McFadden | Regular School | No | 1 | PK | 05 | 2016 | grade_5 | 31 | 12 | 51 | 1 | 0 | 0 | 4 | 47 | 52 | 99 | 31 | 12 | 51 | 1 | 0 | 0 | 4 | 47 | 52 | 99 | |||||||||||||||||||||||||||||||||
937337 | 937337 | MA | Essex | school | 2508700 | 211 | North Andover | 250870001395 | 2110010 | Franklin | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 86 | 2 | 2 | 0 | 7 | 1 | 1 | 48 | 51 | 99 | 86 | 2 | 2 | 0 | 7 | 1 | 1 | 48 | 51 | 99 | |||||||||||||||||||||||||||||||||
937816 | 937816 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001542 | 2390012 | Indian Brook | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 92 | 0 | 2 | 0 | 1 | 0 | 4 | 53 | 46 | 99 | 92 | 0 | 2 | 0 | 1 | 0 | 4 | 53 | 46 | 99 | |||||||||||||||||||||||||||||||||
938641 | 938641 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001804 | 2810080 | Frederick Harris | Regular School | No | 1 | PK | 05 | 2016 | grade_5 | 20 | 10 | 66 | 0 | 2 | 0 | 1 | 48 | 51 | 99 | 20 | 10 | 66 | 0 | 2 | 0 | 1 | 48 | 51 | 99 | |||||||||||||||||||||||||||||||||
1130376 | 1130376 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002044 | 3320010 | John R Fausey | Regular School | No | Elementary | KG | 05 | 2017 | grade_5 | 77 | 4 | 9 | 0 | 5 | 0 | 4 | 55 | 44 | 99 | 77 | 4 | 9 | 0 | 5 | 0 | 4 | 55 | 44 | 99 | |||||||||||||||||||||||||||||||||
1130851 | 1130851 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002217 | 3480110 | Gates Lane | Regular School | No | Elementary | PK | 06 | 2017 | grade_5 | 25 | 17 | 41 | 0 | 13 | 0 | 3 | 65 | 34 | 99 | 25 | 17 | 41 | 0 | 13 | 0 | 3 | 65 | 34 | 99 | |||||||||||||||||||||||||||||||||
1132021 | 1132021 | MA | Bristol | school | 2504200 | 650 | Dighton-Rehoboth | 250420000400 | 6500305 | Dighton Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 89 | 1 | 4 | 0 | 1 | 0 | 4 | 54 | 45 | 99 | 89 | 1 | 4 | 0 | 1 | 0 | 4 | 54 | 45 | 99 | |||||||||||||||||||||||||||||||||
1132734 | 1132734 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001302845 | 7660315 | Powder Mill School | Regular School | No | Elementary | 03 | 06 | 2017 | grade_5 | 87 | 2 | 6 | 0 | 1 | 0 | 3 | 50 | 49 | 99 | 87 | 2 | 6 | 0 | 1 | 0 | 3 | 50 | 49 | 99 | |||||||||||||||||||||||||||||||||
1366167 | 1366167 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000386 | 440010 | Brookfield | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 16 | 60 | 12 | 0 | 3 | 1 | 6 | 51 | 47 | * | 98.0 | 16 | 60 | 12 | 0 | 3 | 1 | 6 | 51 | 47 | 98 | ||||||||||||||||||||||||||||||||
1366370 | 1366370 | MA | Middlesex | school | 2503240 | 48 | Burlington | 250324000844 | 480035 | Francis Wyman Elementary | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 60 | 10 | 6 | 0 | 19 | 0 | 3 | 48 | 50 | * | 98.0 | 60 | 10 | 6 | 0 | 19 | 0 | 3 | 48 | 50 | 98 | ||||||||||||||||||||||||||||||||
1367372 | 1367372 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000728 | 1000050 | Miriam F McCarthy School | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 37 | 18 | 35 | 0 | 1 | 0 | 7 | 51 | 47 | * | 98.0 | 37 | 18 | 35 | 0 | 1 | 0 | 7 | 51 | 47 | 98 | ||||||||||||||||||||||||||||||||
1369295 | 1369295 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001320 | 2010123 | Casimir Pulaski | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 66 | 8 | 17 | 0 | 0 | 0 | 7 | 47 | 51 | * | 98.0 | 66 | 8 | 17 | 0 | 0 | 0 | 7 | 47 | 51 | 98 | ||||||||||||||||||||||||||||||||
1370175 | 1370175 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001581 | 2430320 | South West Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_5 | 41 | 7 | 11 | 1 | 35 | 0 | 3 | 64 | 34 | * | 98.0 | 41 | 7 | 11 | 1 | 35 | 0 | 3 | 64 | 34 | 98 | ||||||||||||||||||||||||||||||||
1370893 | 1370893 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001810 | 2810100 | Indian Orchard Elementary | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 7 | 22 | 65 | 0 | 1 | 0 | 3 | 48 | 50 | * | 98.0 | 7 | 22 | 65 | 0 | 1 | 0 | 3 | 48 | 50 | 98 | ||||||||||||||||||||||||||||||||
1372694 | 1372694 | MA | Suffolk | school | 2500053 | 449 | Boston Collegiate Charter (District) | 250005301256 | 4490305 | Boston Collegiate Charter School | Regular School | Yes | High | 05 | 12 | 2020 | grade_5 | 49 | 32 | 11 | 0 | 1 | 0 | 5 | 53 | 45 | * | 98.0 | 49 | 32 | 11 | 0 | 1 | 0 | 5 | 53 | 45 | 98 | ||||||||||||||||||||||||||||||||
1676323 | 1676323 | MA | Norfolk | school | 2507980 | 189 | Milton | 250798001261 | 1890010 | Milton - Glover | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 77 | 6 | 2 | 0 | 4 | 0 | 9 | 50 | 48 | * | 98.0 | 77 | 6 | 2 | 0 | 4 | 0 | 9 | 50 | 48 | 98 | ||||||||||||||||||||||||||||||||
1679101 | 1679101 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002044 | 3320010 | West Springfield - John R Fausey | Regular School | No | Elementary | 01 | 05 | 2021 | grade_5 | 77 | 1 | 12 | 0 | 3 | 0 | 5 | 51 | 47 | * | 98.0 | 77 | 1 | 12 | 0 | 3 | 0 | 5 | 51 | 47 | 98 | ||||||||||||||||||||||||||||||||
2042049 | 2042049 | MA | Hampden | school | 2504500 | 87 | East Longmeadow | 250450000606 | 870015 | Mountain View | Regular School | No | Elementary | 03 | 05 | 2019 | grade_5 | 79 | 3 | 7 | 0 | 3 | 0 | 6 | 49 | 49 | 98.0 | 79 | 3 | 7 | 0 | 3 | 0 | 6 | 49 | 49 | 98 | |||||||||||||||||||||||||||||||||
2232870 | 2232870 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684000473 | 1550035 | Lexington: Maria Hastings | Regular School | No | Elementary | KG | 05 | 2018 | grade_5 | 39 | 3 | 4 | 0 | 43 | 0 | 9 | 43 | 55 | 98.0 | 39 | 3 | 4 | 0 | 43 | 0 | 9 | 43 | 55 | 98 | |||||||||||||||||||||||||||||||||
2233224 | 2233224 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001087 | 1630040 | Lynn: Wm P Connery | Regular School | No | Elementary | PK | 05 | 2018 | grade_5 | 5 | 7 | 67 | 0 | 17 | 0 | 2 | 52 | 46 | 98.0 | 5 | 7 | 67 | 0 | 17 | 0 | 2 | 52 | 46 | 98 | |||||||||||||||||||||||||||||||||
2235036 | 2235036 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001542 | 2390012 | Plymouth: Indian Brook | Regular School | No | Elementary | KG | 05 | 2018 | grade_5 | 92 | 1 | 4 | 0 | 0 | 0 | 1 | 54 | 44 | 98.0 | 92 | 1 | 4 | 0 | 0 | 0 | 1 | 54 | 44 | 98 | |||||||||||||||||||||||||||||||||
2238607 | 2238607 | MA | Worcester | school | 2502040 | 610 | Ashburnham-Westminster | 250204002367 | 6100005 | Ashburnham-Westminster: Westminster Elementary | Regular School | No | Elementary | 02 | 05 | 2018 | grade_5 | 91 | 1 | 4 | 0 | 0 | 0 | 2 | 53 | 45 | 98.0 | 91 | 1 | 4 | 0 | 0 | 0 | 2 | 53 | 45 | 98 | |||||||||||||||||||||||||||||||||
736070 | 736070 | MA | Bristol | school | 2502520 | 27 | Berkley | 250252001613 | 270305 | Berkley Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_5 | 93 | 1 | 2 | 0 | 1 | 0 | 1 | 50 | 48 | 98 | 93 | 1 | 2 | 0 | 1 | 0 | 1 | 50 | 48 | 98 | |||||||||||||||||||||||||||||||||
737003 | 737003 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294002570 | 400005 | Hollis | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 79 | 1 | 4 | 0 | 14 | 0 | 0 | 49 | 49 | 98 | 79 | 1 | 4 | 0 | 14 | 0 | 0 | 49 | 49 | 98 | |||||||||||||||||||||||||||||||||
737192 | 737192 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000416 | 460005 | Edith C Baker | Regular School | No | 1 | KG | 08 | 2015 | grade_5 | 54 | 2 | 9 | 0 | 22 | 1 | 10 | 50 | 48 | 98 | 54 | 2 | 9 | 0 | 22 | 1 | 10 | 50 | 48 | 98 | |||||||||||||||||||||||||||||||||
738787 | 738787 | MA | Worcester | school | 2506300 | 138 | Hopedale | 250630000916 | 1380010 | Memorial | Regular School | No | 1 | KG | 06 | 2015 | grade_5 | 88 | 3 | 5 | 0 | 1 | 0 | 1 | 45 | 53 | 98 | 88 | 3 | 5 | 0 | 1 | 0 | 1 | 45 | 53 | 98 | |||||||||||||||||||||||||||||||||
738941 | 738941 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000956 | 1490040 | Francis M Leahy | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 4 | 1 | 93 | 0 | 0 | 0 | 0 | 48 | 50 | 98 | 4 | 1 | 93 | 0 | 0 | 0 | 0 | 48 | 50 | 98 | |||||||||||||||||||||||||||||||||
741518 | 741518 | MA | Norfolk | school | 2510620 | 266 | Sharon | 251062001702 | 2660005 | Cottage Street | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 61 | 5 | 5 | 1 | 22 | 0 | 4 | 53 | 45 | 98 | 61 | 5 | 5 | 1 | 22 | 0 | 4 | 53 | 45 | 98 | |||||||||||||||||||||||||||||||||
933875 | 933875 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000365 | 400015 | Highlands | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 85 | 1 | 3 | 0 | 8 | 0 | 1 | 47 | 51 | 98 | 85 | 1 | 3 | 0 | 8 | 0 | 1 | 47 | 51 | 98 | |||||||||||||||||||||||||||||||||
938400 | 938400 | MA | Bristol | school | 2510860 | 273 | Somerset | 251086002536 | 2730008 | North Elementary | Regular School | No | 1 | KG | 05 | 2016 | grade_5 | 88 | 3 | 4 | 0 | 0 | 0 | 3 | 52 | 46 | 98 | 88 | 3 | 4 | 0 | 0 | 0 | 3 | 52 | 46 | 98 | |||||||||||||||||||||||||||||||||
938994 | 938994 | MA | Bristol | school | 2511460 | 292 | Swansea | 251146001890 | 2920006 | Elizabeth S Brown | Regular School | No | 1 | 03 | 05 | 2016 | grade_5 | 89 | 2 | 5 | 0 | 0 | 0 | 2 | 51 | 47 | 98 | 89 | 2 | 5 | 0 | 0 | 0 | 2 | 51 | 47 | 98 | |||||||||||||||||||||||||||||||||
940935 | 940935 | MA | Worcester | school | 2502715 | 622 | Blackstone-Millville | 250271501078 | 6220015 | A F Maloney | Regular School | No | 1 | 03 | 05 | 2016 | grade_5 | 87 | 2 | 5 | 0 | 0 | 0 | 4 | 45 | 53 | 98 | 87 | 2 | 5 | 0 | 0 | 0 | 4 | 45 | 53 | 98 | |||||||||||||||||||||||||||||||||
941666 | 941666 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000200639 | 7670415 | Knox Trail Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_5 | 90 | 0 | 7 | 0 | 1 | 0 | 0 | 61 | 37 | 98 | 90 | 0 | 7 | 0 | 1 | 0 | 0 | 61 | 37 | 98 | |||||||||||||||||||||||||||||||||
1131507 | 1131507 | MA | Essex | school | 2500520 | 477 | Silver Hill Horace Mann Charter (District) | 250052002641 | 4770010 | Silver Hill Horace Mann Charter School | Regular School | Yes | Elementary | KG | 05 | 2017 | grade_5 | 76 | 0 | 20 | 1 | 1 | 0 | 0 | 46 | 52 | 98 | 76 | 0 | 20 | 1 | 1 | 0 | 0 | 46 | 52 | 98 | |||||||||||||||||||||||||||||||||
1131585 | 1131585 | MA | Middlesex | school | 2500046 | 487 | Prospect Hill Academy Charter (District) | 250004600819 | 4870550 | Prospect Hill Academy Charter School | Regular School | Yes | Other | KG | 12 | 2017 | grade_5 | 22 | 56 | 9 | 1 | 7 | 0 | 3 | 53 | 45 | 98 | 22 | 56 | 9 | 1 | 7 | 0 | 3 | 53 | 45 | 98 | |||||||||||||||||||||||||||||||||
1132900 | 1132900 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188001494 | 7750315 | Chocksett Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 91 | 0 | 3 | 0 | 2 | 0 | 2 | 44 | 54 | 98 | 91 | 0 | 3 | 0 | 2 | 0 | 2 | 44 | 54 | 98 | |||||||||||||||||||||||||||||||||
1366883 | 1366883 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432000583 | 790020 | Joseph A Campbell Elementary | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 81 | 4 | 5 | 0 | 2 | 0 | 5 | 52 | 45 | * | 97.0 | 81 | 4 | 5 | 0 | 2 | 0 | 5 | 52 | 45 | 97 | ||||||||||||||||||||||||||||||||
1368508 | 1368508 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001068 | 1630035 | Cobbet Elementary | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 1 | 3 | 87 | 0 | 5 | 0 | 1 | 54 | 43 | * | 97.0 | 1 | 3 | 87 | 0 | 5 | 0 | 1 | 54 | 43 | 97 | ||||||||||||||||||||||||||||||||
1368522 | 1368522 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001070 | 1630045 | E J Harrington | Regular School | No | Elementary | PK | 05 | 2020 | grade_5 | 7 | 8 | 73 | 0 | 7 | 0 | 2 | 41 | 56 | * | 97.0 | 7 | 8 | 73 | 0 | 7 | 0 | 2 | 41 | 56 | 97 | ||||||||||||||||||||||||||||||||
1369375 | 1369375 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001356 | 2070005 | A E Angier | Regular School | No | Elementary | KG | 05 | 2020 | grade_5 | 61 | 3 | 7 | 0 | 18 | 0 | 8 | 40 | 57 | * | 97.0 | 61 | 3 | 7 | 0 | 18 | 0 | 8 | 40 | 57 | 97 | ||||||||||||||||||||||||||||||||
1372309 | 1372309 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002241 | 3480210 | Quinsigamond | Regular School | No | Elementary | PK | 06 | 2020 | grade_5 | 27 | 15 | 45 | 0 | 7 | 0 | 3 | 53 | 44 | * | 97.0 | 27 | 15 | 45 | 0 | 7 | 0 | 3 | 53 | 44 | 97 | ||||||||||||||||||||||||||||||||
1672650 | 1672650 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Boston - Eliot Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_5 | 64 | 4 | 13 | 0 | 7 | 0 | 9 | 47 | 50 | * | 97.0 | 64 | 4 | 13 | 0 | 7 | 0 | 9 | 47 | 50 | 97 | ||||||||||||||||||||||||||||||||
1673401 | 1673401 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000386 | 440010 | Brockton - Brookfield | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 29 | 61 | 6 | 0 | 0 | 0 | 1 | 48 | 49 | * | 97.0 | 29 | 61 | 6 | 0 | 0 | 0 | 1 | 48 | 49 | 97 | ||||||||||||||||||||||||||||||||
1675750 | 1675750 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001068 | 1630035 | Lynn - Cobbet Elementary | Regular School | No | Elementary | KG | 05 | 2021 | grade_5 | 3 | 7 | 81 | 0 | 3 | 0 | 3 | 59 | 38 | * | 97.0 | 3 | 7 | 81 | 0 | 3 | 0 | 3 | 59 | 38 | 97 | ||||||||||||||||||||||||||||||||
1675881 | 1675881 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001344 | 1650003 | Malden - Beebe | Regular School | No | Elementary | KG | 08 | 2021 | grade_5 | 32 | 18 | 12 | 0 | 31 | 0 | 4 | 54 | 43 | * | 97.0 | 32 | 18 | 12 | 0 | 31 | 0 | 4 | 54 | 43 | 97 | ||||||||||||||||||||||||||||||||
1677556 | 1677556 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001975 | 2480056 | Revere - Garfield Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | grade_5 | 24 | 4 | 65 | 0 | 2 | 0 | 2 | 56 | 41 | * | 97.0 | 24 | 4 | 65 | 0 | 2 | 0 | 2 | 56 | 41 | 97 | ||||||||||||||||||||||||||||||||
1678768 | 1678768 | MA | Hampshire | school | 2512030 | 309 | Ware | 251203002538 | 3090305 | Ware - Ware Middle School | Regular School | No | Middle | 04 | 06 | 2021 | grade_5 | 81 | 0 | 14 | 0 | 0 | 0 | 2 | 54 | 43 | * | 97.0 | 81 | 0 | 14 | 0 | 0 | 0 | 2 | 54 | 43 | 97 | ||||||||||||||||||||||||||||||||
2042419 | 2042419 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000721 | 1000015 | Hemenway | Regular School | No | Elementary | KG | 05 | 2019 | grade_5 | 72 | 3 | 9 | 0 | 8 | 0 | 5 | 46 | 51 | 97.0 | 72 | 3 | 9 | 0 | 8 | 0 | 5 | 46 | 51 | 97 | |||||||||||||||||||||||||||||||||
2044870 | 2044870 | MA | Franklin | school | 2509180 | 223 | Orange | 250918001475 | 2230010 | Dexter Park | Regular School | No | Elementary | 03 | 06 | 2019 | grade_5 | 85 | 2 | 8 | 0 | 1 | 0 | 1 | 49 | 48 | 97.0 | 85 | 2 | 8 | 0 | 1 | 0 | 1 | 49 | 48 | 97 | |||||||||||||||||||||||||||||||||
2045639 | 2045639 | MA | Norfolk | school | 2510620 | 266 | Sharon | 251062001704 | 2660015 | Heights Elementary | Regular School | No | Elementary | KG | 05 | 2019 | grade_5 | 43 | 6 | 0 | 0 | 36 | 0 | 12 | 58 | 39 | 97.0 | 43 | 6 | 0 | 0 | 36 | 0 | 12 | 58 | 39 | 97 | |||||||||||||||||||||||||||||||||
2046243 | 2046243 | MA | Middlesex | school | 2511340 | 288 | Sudbury | 251134001407 | 2880015 | Israel Loring School | Regular School | No | Elementary | KG | 05 | 2019 | grade_5 | 71 | 3 | 4 | 0 | 16 | 0 | 3 | 52 | 45 | 97.0 | 71 | 3 | 4 | 0 | 16 | 0 | 3 | 52 | 45 | 97 | |||||||||||||||||||||||||||||||||
2046651 | 2046651 | MA | Middlesex | school | 2512210 | 315 | Wayland | 251221002007 | 3150005 | Claypit Hill School | Regular School | No | Elementary | KG | 05 | 2019 | grade_5 | 63 | 7 | 10 | 0 | 10 | 0 | 7 | 48 | 49 | 97.0 | 63 | 7 | 10 | 0 | 10 | 0 | 7 | 48 | 49 | 97 | |||||||||||||||||||||||||||||||||
2048720 | 2048720 | MA | Middlesex | school | 2508310 | 725 | Nashoba | 250831000362 | 7250020 | Center School | Regular School | No | Elementary | PK | 05 | 2019 | grade_5 | 87 | 1 | 2 | 0 | 3 | 0 | 4 | 54 | 43 | 97.0 | 87 | 1 | 2 | 0 | 3 | 0 | 4 | 54 | 43 | 97 | |||||||||||||||||||||||||||||||||
2231840 | 2231840 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000728 | 1000050 | Framingham: Miriam F McCarthy School | Regular School | No | Elementary | KG | 05 | 2018 | grade_5 | 47 | 14 | 27 | 0 | 3 | 0 | 6 | 49 | 48 | 97.0 | 47 | 14 | 27 | 0 | 3 | 0 | 6 | 49 | 48 | 97 | |||||||||||||||||||||||||||||||||
2238366 | 2238366 | MA | Suffolk | school | 2500039 | 481 | Boston Renaissance Charter Public (District) | 250003900599 | 4810550 | Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School | Regular School | Yes | Elementary | PK | 06 | 2018 | grade_5 | 0 | 66 | 30 | 0 | 1 | 0 | 0 | 46 | 51 | 97.0 | 0 | 66 | 30 | 0 | 1 | 0 | 0 | 46 | 51 | 97 | |||||||||||||||||||||||||||||||||
2238419 | 2238419 | MA | Middlesex | school | 2500046 | 487 | Prospect Hill Academy Charter (District) | 250004600819 | 4870550 | Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School | Regular School | Yes | Other | KG | 12 | 2018 | grade_5 | 17 | 48 | 18 | 2 | 9 | 1 | 2 | 52 | 45 | 97.0 | 17 | 48 | 18 | 2 | 9 | 1 | 2 | 52 | 45 | 97 | |||||||||||||||||||||||||||||||||
736554 | 736554 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002006 | 350257 | Orchard Gardens | Regular School | No | 1 | PK | 08 | 2015 | grade_5 | 0 | 51 | 39 | 1 | 1 | 0 | 5 | 50 | 47 | 97 | 0 | 51 | 39 | 1 | 1 | 0 | 5 | 50 | 47 | 97 | |||||||||||||||||||||||||||||||||
739777 | 739777 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756001634 | 1760068 | John J McGlynn Elementary School | Regular School | No | 1 | PK | 05 | 2015 | grade_5 | 58 | 21 | 9 | 0 | 9 | 0 | 0 | 54 | 43 | 97 | 58 | 21 | 9 | 0 | 9 | 0 | 0 | 54 | 43 | 97 | |||||||||||||||||||||||||||||||||
742461 | 742461 | MA | Hampshire | school | 2512030 | 309 | Ware | 251203002538 | 3090305 | Ware Middle School | Regular School | No | 2 | 04 | 06 | 2015 | grade_5 | 85 | 2 | 5 | 1 | 0 | 0 | 4 | 52 | 45 | 97 | 85 | 2 | 5 | 1 | 0 | 0 | 4 | 52 | 45 | 97 |
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]);