enrollments
Data source: Big Local News · About: Big Local
2,748 rows where grade = "grade_12" and state = "MA" sorted by black
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
935314 | 935314 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby Jr Sr High School | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 70 | 0 | 0 | 1 | 0 | 0 | 0 | 34 | 37 | 71 | 70 | 0 | 0 | 1 | 0 | 0 | 0 | 34 | 37 | 71 | |||||||||||||||||||||||||||||||||
935355 | 935355 | MA | Hampshire | school | 2505580 | 117 | Hadley | 250558000813 | 1170505 | Hopkins Academy | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 45 | 0 | 5 | 0 | 2 | 0 | 1 | 31 | 22 | 53 | 45 | 0 | 5 | 0 | 2 | 0 | 1 | 31 | 22 | 53 | |||||||||||||||||||||||||||||||||
935403 | 935403 | MA | Worcester | school | 2505880 | 125 | Harvard | 250588000838 | 1250505 | Bromfield | Regular School | No | 4 | 06 | 12 | 2016 | grade_12 | 91 | 0 | 1 | 0 | 6 | 0 | 0 | 53 | 45 | 98 | 91 | 0 | 1 | 0 | 6 | 0 | 0 | 53 | 45 | 98 | |||||||||||||||||||||||||||||||||
935456 | 935456 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597001706 | 1280073 | TEACH | Regular School | No | 4 | 01 | 12 | 2016 | grade_12 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | |||||||||||||||||||||||||||||||||
935628 | 935628 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000913 | 1370605 | Wm J Dean Vocational Technical High | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 4 | 0 | 63 | 0 | 0 | 0 | 0 | 31 | 36 | 67 | 4 | 0 | 63 | 0 | 0 | 0 | 0 | 31 | 36 | 67 | |||||||||||||||||||||||||||||||||
935643 | 935643 | MA | Worcester | school | 2506300 | 138 | Hopedale | 250630000915 | 1380505 | Hopedale Jr Sr High | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 75 | 0 | 4 | 0 | 1 | 0 | 0 | 44 | 36 | 80 | 75 | 0 | 4 | 0 | 1 | 0 | 0 | 44 | 36 | 80 | |||||||||||||||||||||||||||||||||
935835 | 935835 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002636 | 1490531 | Health & Human Services High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 1 | 0 | 124 | 0 | 2 | 0 | 1 | 58 | 70 | 128 | 1 | 0 | 124 | 0 | 2 | 0 | 1 | 58 | 70 | 128 | |||||||||||||||||||||||||||||||||
935848 | 935848 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002631 | 1490534 | International High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 0 | 0 | 26 | 0 | 0 | 0 | 0 | 10 | 16 | 26 | 0 | 0 | 26 | 0 | 0 | 0 | 0 | 10 | 16 | 26 | |||||||||||||||||||||||||||||||||
935857 | 935857 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002628 | 1490536 | High School Learning Center | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 2 | 0 | 62 | 0 | 0 | 0 | 0 | 38 | 26 | 64 | 2 | 0 | 62 | 0 | 0 | 0 | 0 | 38 | 26 | 64 | |||||||||||||||||||||||||||||||||
935874 | 935874 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002749 | 1490540 | Phoenix Academy Lawrence | Alternative Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 1 | 0 | 15 | 0 | 0 | 0 | 0 | 4 | 12 | 16 | 1 | 0 | 15 | 0 | 0 | 0 | 0 | 4 | 12 | 16 | |||||||||||||||||||||||||||||||||
935888 | 935888 | MA | Berkshire | school | 2506690 | 150 | Lee | 250669000970 | 1500505 | Lee Middle/High School | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 50 | 0 | 8 | 0 | 2 | 0 | 1 | 33 | 28 | 61 | 50 | 0 | 8 | 0 | 2 | 0 | 1 | 33 | 28 | 61 | |||||||||||||||||||||||||||||||||
935916 | 935916 | MA | Berkshire | school | 2506750 | 152 | Lenox | 250675000978 | 1520505 | Lenox Memorial High | Regular School | No | 4 | 06 | 12 | 2016 | grade_12 | 39 | 0 | 1 | 0 | 0 | 0 | 0 | 21 | 19 | 40 | 39 | 0 | 1 | 0 | 0 | 0 | 0 | 21 | 19 | 40 | |||||||||||||||||||||||||||||||||
936190 | 936190 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002732 | 1600320 | Leblanc Therapeutic Day School | Regular School | No | 3 | 08 | 12 | 2016 | grade_12 | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 7 | 2 | 9 | 3 | 0 | 6 | 0 | 0 | 0 | 0 | 7 | 2 | 9 | |||||||||||||||||||||||||||||||||
936614 | 936614 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753001157 | 1750505 | Medfield Senior High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 211 | 0 | 6 | 0 | 11 | 0 | 3 | 113 | 118 | 231 | 211 | 0 | 6 | 0 | 11 | 0 | 3 | 113 | 118 | 231 | |||||||||||||||||||||||||||||||||
936676 | 936676 | MA | Norfolk | school | 2507590 | 177 | Medway | 250759001184 | 1770505 | Medway High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 190 | 0 | 9 | 1 | 8 | 0 | 1 | 100 | 109 | 209 | 190 | 0 | 9 | 1 | 8 | 0 | 1 | 100 | 109 | 209 | |||||||||||||||||||||||||||||||||
936884 | 936884 | MA | Hampden | school | 2508040 | 191 | Monson | 250804001269 | 1910505 | Monson High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 82 | 0 | 6 | 0 | 1 | 0 | 0 | 38 | 51 | 89 | 82 | 0 | 6 | 0 | 1 | 0 | 0 | 38 | 51 | 89 | |||||||||||||||||||||||||||||||||
937443 | 937443 | MA | Worcester | school | 2508940 | 214 | Northbridge | 250894001445 | 2140505 | Northbridge High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 135 | 0 | 11 | 0 | 1 | 0 | 5 | 86 | 66 | 152 | 135 | 0 | 11 | 0 | 1 | 0 | 5 | 86 | 66 | 152 | |||||||||||||||||||||||||||||||||
937457 | 937457 | MA | Worcester | school | 2508760 | 215 | North Brookfield | 250876001411 | 2150505 | North Brookfield High | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 41 | 0 | 2 | 0 | 0 | 0 | 0 | 24 | 19 | 43 | 41 | 0 | 2 | 0 | 0 | 0 | 0 | 24 | 19 | 43 | |||||||||||||||||||||||||||||||||
937483 | 937483 | MA | Middlesex | school | 2508820 | 217 | North Reading | 250882001422 | 2170505 | North Reading High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 183 | 0 | 2 | 0 | 4 | 0 | 4 | 102 | 91 | 193 | 183 | 0 | 2 | 0 | 4 | 0 | 4 | 102 | 91 | 193 | |||||||||||||||||||||||||||||||||
937591 | 937591 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927002810 | 2260305 | Project C.O.F.F.E.E. | Special Education School | No | 4 | 05 | 12 | 2016 | grade_12 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | * | 10 | 9 | 0 | 1 | 0 | 0 | 0 | 0 | 9 | 10 | ||||||||||||||||||||||||||||||||||
938317 | 938317 | MA | Bristol | school | 2510590 | 265 | Seekonk | 251059001699 | 2650505 | Seekonk High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 135 | 0 | 5 | 0 | 7 | 0 | 3 | 74 | 76 | 150 | 135 | 0 | 5 | 0 | 7 | 0 | 3 | 74 | 76 | 150 | |||||||||||||||||||||||||||||||||
938828 | 938828 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002734 | 2810560 | Liberty Preparatory Academy | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 3 | 0 | 5 | 0 | 0 | 0 | 0 | 4 | * | 8 | 3 | 0 | 5 | 0 | 0 | 0 | 0 | 4 | 8 | ||||||||||||||||||||||||||||||||||
938967 | 938967 | MA | Worcester | school | 2511400 | 290 | Sutton | 251140001414 | 2900510 | Sutton High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 102 | 0 | 3 | 0 | 2 | 0 | 6 | 53 | 60 | 113 | 102 | 0 | 3 | 0 | 2 | 0 | 6 | 53 | 60 | 113 | |||||||||||||||||||||||||||||||||
939275 | 939275 | MA | Hampshire | school | 2512030 | 309 | Ware | 251203001983 | 3090505 | Ware Junior/Senior High School | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 50 | 0 | 3 | 0 | 1 | 0 | 1 | 26 | 29 | 55 | 50 | 0 | 3 | 0 | 1 | 0 | 1 | 26 | 29 | 55 | |||||||||||||||||||||||||||||||||
939562 | 939562 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266002081 | 3260505 | Westford Academy | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 316 | 0 | 5 | 0 | 73 | 0 | 24 | 214 | 204 | 418 | 316 | 0 | 5 | 0 | 73 | 0 | 24 | 214 | 204 | 418 | |||||||||||||||||||||||||||||||||
940610 | 940610 | MA | Middlesex | school | 2500038 | 478 | Francis W. Parker Charter Essential (District) | 250003800581 | 4780505 | Francis W. Parker Charter Essential School | Regular School | Yes | 3 | 07 | 12 | 2016 | grade_12 | 56 | 0 | 3 | 0 | 1 | 1 | 1 | 34 | 28 | 62 | 56 | 0 | 3 | 0 | 1 | 1 | 1 | 34 | 28 | 62 | |||||||||||||||||||||||||||||||||
940695 | 940695 | MA | Barnstable | school | 2500058 | 489 | Sturgis Charter Public (District) | 250005801272 | 4890505 | Sturgis Charter Public School | Regular School | Yes | 3 | 09 | 12 | 2016 | grade_12 | 184 | 0 | 6 | 0 | 3 | 0 | 7 | 93 | 107 | 200 | 184 | 0 | 6 | 0 | 3 | 0 | 7 | 93 | 107 | 200 | |||||||||||||||||||||||||||||||||
941146 | 941146 | MA | Hampshire | school | 2505160 | 672 | Gateway | 250516000758 | 6720505 | Gateway Regional High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 60 | 0 | 1 | 0 | 0 | 0 | 1 | 28 | 34 | 62 | 60 | 0 | 1 | 0 | 0 | 0 | 1 | 28 | 34 | 62 | |||||||||||||||||||||||||||||||||
941285 | 941285 | MA | Essex | school | 2500067 | 698 | Manchester Essex Regional | 250006701109 | 6980510 | Manchester Essex Regional High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 114 | 0 | 0 | 0 | 0 | 0 | 0 | 59 | 55 | 114 | 114 | 0 | 0 | 0 | 0 | 0 | 0 | 59 | 55 | 114 | |||||||||||||||||||||||||||||||||
941344 | 941344 | MA | Berkshire | school | 2508160 | 715 | Mount Greylock | 250816001273 | 7150505 | Mt Greylock Regional High | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 71 | 0 | 2 | 0 | 2 | 0 | 3 | 41 | 37 | 78 | 71 | 0 | 2 | 0 | 2 | 0 | 3 | 41 | 37 | 78 | |||||||||||||||||||||||||||||||||
941513 | 941513 | MA | Essex | school | 2509450 | 745 | Pentucket | 250945001513 | 7450505 | Pentucket Regional Sr High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 165 | 0 | 1 | 1 | 5 | 0 | 2 | 83 | 91 | 174 | 165 | 0 | 1 | 1 | 5 | 0 | 2 | 83 | 91 | 174 | |||||||||||||||||||||||||||||||||
941550 | 941550 | MA | Franklin | school | 2509600 | 750 | Pioneer Valley | 250960001515 | 7500505 | Pioneer Valley Regional | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 55 | 0 | 0 | 0 | 1 | 0 | 3 | 27 | 32 | 59 | 55 | 0 | 0 | 0 | 1 | 0 | 3 | 27 | 32 | 59 | |||||||||||||||||||||||||||||||||
941588 | 941588 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102797 | 7530515 | IB School of Quabbin | Regular School | No | 3 | 11 | 12 | 2016 | grade_12 | 20 | 0 | 0 | 0 | 1 | 0 | 1 | 5 | 17 | 22 | 20 | 0 | 0 | 0 | 1 | 0 | 1 | 5 | 17 | 22 | |||||||||||||||||||||||||||||||||
941596 | 941596 | MA | Worcester | school | 2509900 | 755 | Ralph C Mahar | 250990002701 | 7550515 | Pathways Early College Innovation School | Regular School | No | 3 | 11 | 12 | 2016 | grade_12 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 7 | 13 | 20 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 7 | 13 | 20 | |||||||||||||||||||||||||||||||||
941632 | 941632 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001774 | 7650505 | Mt Everett Regional | Regular School | No | 3 | 07 | 12 | 2016 | grade_12 | 54 | 0 | 0 | 0 | 0 | 0 | 3 | 29 | 28 | 57 | 54 | 0 | 0 | 0 | 0 | 0 | 3 | 29 | 28 | 57 | |||||||||||||||||||||||||||||||||
941673 | 941673 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201790 | 7670505 | David Prouty High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 70 | 0 | 5 | 0 | 2 | 0 | 4 | 38 | 43 | 81 | 70 | 0 | 5 | 0 | 2 | 0 | 4 | 38 | 43 | 81 | |||||||||||||||||||||||||||||||||
941875 | 941875 | MA | Franklin | school | 2505020 | 818 | Franklin County Regional Vocational Technical | 250502000744 | 8180605 | Franklin County Technical | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 122 | 0 | 2 | 0 | 0 | 0 | 0 | 76 | 48 | 124 | 122 | 0 | 2 | 0 | 0 | 0 | 0 | 76 | 48 | 124 | |||||||||||||||||||||||||||||||||
941908 | 941908 | MA | Berkshire | school | 2508950 | 851 | Northern Berkshire Regional Vocational Technical | 250895002282 | 8510605 | Charles McCann Vocational Technical | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 119 | 0 | 1 | 0 | 0 | 0 | 2 | 75 | 47 | 122 | 119 | 0 | 1 | 0 | 0 | 0 | 2 | 75 | 47 | 122 | |||||||||||||||||||||||||||||||||
941912 | 941912 | MA | Middlesex | school | 2508320 | 852 | Nashoba Valley Regional Vocational Technical | 250832001290 | 8520605 | Nashoba Valley Technical High School | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 146 | 0 | 6 | 0 | 1 | 0 | 5 | 102 | 56 | 158 | 146 | 0 | 6 | 0 | 1 | 0 | 5 | 102 | 56 | 158 | |||||||||||||||||||||||||||||||||
941924 | 941924 | MA | Hampden | school | 2509310 | 860 | Pathfinder Regional Vocational Technical | 250931002285 | 8600605 | Pathfinder Vocational Technical | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 143 | 0 | 4 | 1 | 0 | 0 | 2 | 87 | 63 | 150 | 143 | 0 | 4 | 1 | 0 | 0 | 2 | 87 | 63 | 150 | |||||||||||||||||||||||||||||||||
941929 | 941929 | MA | Middlesex | school | 2510615 | 871 | Shawsheen Valley Regional Vocational Technical | 251061501701 | 8710605 | Shawsheen Valley Vocational Technical High School | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 326 | 0 | 6 | 0 | 4 | 0 | 3 | 198 | 141 | 339 | 326 | 0 | 6 | 0 | 4 | 0 | 3 | 198 | 141 | 339 | |||||||||||||||||||||||||||||||||
941941 | 941941 | MA | Worcester | school | 2511050 | 876 | Southern Worcester County Regional Vocational Technical | 251105001779 | 8760605 | Bay Path Regional Vocational Technical High School | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 249 | 0 | 13 | 0 | 1 | 0 | 1 | 170 | 94 | 264 | 249 | 0 | 13 | 0 | 1 | 0 | 1 | 170 | 94 | 264 | |||||||||||||||||||||||||||||||||
942021 | 942021 | MA | Franklin | school | 2500551 | 3901 | Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District | 250055102808 | 39010900 | Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School | Regular School | No | 4 | KG | 12 | 2016 | grade_12 | 27 | 0 | 4 | 0 | 0 | 1 | 0 | 11 | 21 | 32 | 27 | 0 | 4 | 0 | 0 | 1 | 0 | 11 | 21 | 32 | |||||||||||||||||||||||||||||||||
1122043 | 1122043 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186002841 | 70515 | Amesbury Innovation High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | |||||||||||||||||||||||||||||||||
1122257 | 1122257 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219002831 | 160515 | Attleboro Community Academy | Alternative School | No | High | 09 | 12 | 2017 | grade_12 | 11 | 0 | 1 | 0 | 1 | 0 | 1 | 10 | 4 | 14 | 11 | 0 | 1 | 0 | 1 | 0 | 1 | 10 | 4 | 14 | |||||||||||||||||||||||||||||||||
1123482 | 1123482 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000348 | 360505 | Bourne High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 80 | 0 | 4 | 0 | 2 | 0 | 8 | 50 | 44 | 94 | 80 | 0 | 4 | 0 | 2 | 0 | 8 | 50 | 44 | 94 | |||||||||||||||||||||||||||||||||
1125137 | 1125137 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000764 | 1050505 | Georgetown High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 90 | 0 | 1 | 0 | 0 | 0 | 2 | 44 | 49 | 93 | 90 | 0 | 1 | 0 | 0 | 0 | 2 | 44 | 49 | 93 | |||||||||||||||||||||||||||||||||
1125360 | 1125360 | MA | Worcester | school | 2505880 | 125 | Harvard | 250588000838 | 1250505 | Bromfield | Regular School | No | Other | 06 | 12 | 2017 | grade_12 | 90 | 0 | 3 | 0 | 12 | 0 | 2 | 54 | 53 | 107 | 90 | 0 | 3 | 0 | 12 | 0 | 2 | 54 | 53 | 107 | |||||||||||||||||||||||||||||||||
1125376 | 1125376 | MA | Hampshire | school | 2505940 | 127 | Hatfield | 250594000845 | 1270505 | Smith Academy | Regular School | No | High | 07 | 12 | 2017 | grade_12 | 25 | 0 | 3 | 0 | 0 | 0 | 1 | 14 | 15 | 29 | 25 | 0 | 3 | 0 | 0 | 0 | 1 | 14 | 15 | 29 | |||||||||||||||||||||||||||||||||
1125403 | 1125403 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597001698 | 1280033 | Haverhill Alternative School | Regular School | No | High | 07 | 12 | 2017 | grade_12 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | |||||||||||||||||||||||||||||||||
1125894 | 1125894 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002749 | 1490540 | Phoenix Academy Lawrence | Alternative School | No | High | 09 | 12 | 2017 | grade_12 | 3 | 0 | 30 | 0 | 0 | 0 | 0 | 16 | 17 | 33 | 3 | 0 | 30 | 0 | 0 | 0 | 0 | 16 | 17 | 33 | |||||||||||||||||||||||||||||||||
1125910 | 1125910 | MA | Berkshire | school | 2506690 | 150 | Lee | 250669000970 | 1500505 | Lee Middle/High School | Regular School | No | High | 07 | 12 | 2017 | grade_12 | 53 | 0 | 9 | 0 | 0 | 0 | 0 | 29 | 33 | 62 | 53 | 0 | 9 | 0 | 0 | 0 | 0 | 29 | 33 | 62 | |||||||||||||||||||||||||||||||||
1126108 | 1126108 | MA | Middlesex | school | 2506960 | 158 | Littleton | 250696001012 | 1580505 | Littleton High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 110 | 0 | 3 | 0 | 7 | 1 | 2 | 70 | 53 | 123 | 110 | 0 | 3 | 0 | 7 | 1 | 2 | 70 | 53 | 123 | |||||||||||||||||||||||||||||||||
1126961 | 1126961 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001213 | 1810505 | Methuen High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 244 | 0 | 131 | 1 | 19 | 0 | 16 | 202 | 209 | 411 | 244 | 0 | 131 | 1 | 19 | 0 | 16 | 202 | 209 | 411 | |||||||||||||||||||||||||||||||||
1127052 | 1127052 | MA | Norfolk | school | 2507920 | 187 | Millis | 250792001255 | 1870505 | Millis High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 81 | 0 | 2 | 1 | 2 | 1 | 1 | 46 | 42 | 88 | 81 | 0 | 2 | 1 | 2 | 1 | 1 | 46 | 42 | 88 | |||||||||||||||||||||||||||||||||
1127774 | 1127774 | MA | Worcester | school | 2508940 | 214 | Northbridge | 250894001445 | 2140505 | Northbridge High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 121 | 0 | 8 | 0 | 4 | 0 | 4 | 75 | 62 | 137 | 121 | 0 | 8 | 0 | 4 | 0 | 4 | 75 | 62 | 137 | |||||||||||||||||||||||||||||||||
1127952 | 1127952 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927002810 | 2260305 | Project C.O.F.F.E.E. | Special Education School | No | Other | 05 | 12 | 2017 | grade_12 | 5 | 0 | 2 | 0 | 0 | 0 | 1 | 7 | * | 8 | 5 | 0 | 2 | 0 | 0 | 0 | 1 | 7 | 8 | ||||||||||||||||||||||||||||||||||
1127962 | 1127962 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927001482 | 2260505 | Oxford High | Regular School | No | High | 08 | 12 | 2017 | grade_12 | 83 | 0 | 5 | 0 | 0 | 0 | 2 | 44 | 46 | 90 | 83 | 0 | 5 | 0 | 0 | 0 | 2 | 44 | 46 | 90 | |||||||||||||||||||||||||||||||||
1129422 | 1129422 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002734 | 2810560 | Liberty Preparatory Academy | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 4 | * | 6 | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 4 | 6 | ||||||||||||||||||||||||||||||||||
1129432 | 1129432 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002743 | 2810575 | Gateway to College at Holyoke Community College | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | |||||||||||||||||||||||||||||||||
1129588 | 1129588 | MA | Worcester | school | 2511400 | 290 | Sutton | 251140001414 | 2900510 | Sutton High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 93 | 0 | 2 | 0 | 0 | 0 | 5 | 56 | 44 | 100 | 93 | 0 | 2 | 0 | 0 | 0 | 5 | 56 | 44 | 100 | |||||||||||||||||||||||||||||||||
1129805 | 1129805 | MA | Worcester | school | 2511850 | 304 | Uxbridge | 251185002862 | 3040515 | Gateway to College | Alternative School | No | High | 09 | 12 | 2017 | grade_12 | 27 | 0 | 2 | 1 | 1 | 0 | 0 | 11 | 20 | 31 | 27 | 0 | 2 | 1 | 1 | 0 | 0 | 11 | 20 | 31 | |||||||||||||||||||||||||||||||||
1129968 | 1129968 | MA | Hampshire | school | 2512030 | 309 | Ware | 251203001983 | 3090505 | Ware Junior/Senior High School | Regular School | No | High | 07 | 12 | 2017 | grade_12 | 58 | 0 | 5 | 0 | 1 | 0 | 1 | 31 | 34 | 65 | 58 | 0 | 5 | 0 | 1 | 0 | 1 | 31 | 34 | 65 | |||||||||||||||||||||||||||||||||
1130182 | 1130182 | MA | Worcester | school | 2512390 | 322 | West Boylston | 251239002035 | 3220505 | West Boylston Junior/Senior High | Regular School | No | Other | 06 | 12 | 2017 | grade_12 | 50 | 0 | 10 | 0 | 0 | 0 | 1 | 33 | 28 | 61 | 50 | 0 | 10 | 0 | 0 | 0 | 1 | 33 | 28 | 61 | |||||||||||||||||||||||||||||||||
1130358 | 1130358 | MA | Bristol | school | 2512780 | 331 | Westport | 251278002861 | 3310515 | Westport Junior/Senior High School | Regular School | No | High | 07 | 12 | 2017 | grade_12 | 81 | 0 | 4 | 0 | 1 | 0 | 0 | 49 | 37 | 86 | 81 | 0 | 4 | 0 | 1 | 0 | 0 | 49 | 37 | 86 | |||||||||||||||||||||||||||||||||
1131139 | 1131139 | MA | Franklin | school | 2500076 | 413 | Four Rivers Charter Public (District) | 250007602086 | 4130505 | Four Rivers Charter Public School | Regular School | Yes | High | 07 | 12 | 2017 | grade_12 | 29 | 0 | 1 | 0 | 3 | 0 | 1 | 13 | 21 | 34 | 29 | 0 | 1 | 0 | 3 | 0 | 1 | 13 | 21 | 34 | |||||||||||||||||||||||||||||||||
1131433 | 1131433 | MA | Middlesex | school | 2500033 | 458 | Lowell Middlesex Academy Charter (District) | 250003300555 | 4580505 | Lowell Middlesex Academy Charter School | Regular School | Yes | High | 09 | 12 | 2017 | grade_12 | 11 | 0 | 6 | 0 | 4 | 0 | 1 | 12 | 10 | 22 | 11 | 0 | 6 | 0 | 4 | 0 | 1 | 12 | 10 | 22 | |||||||||||||||||||||||||||||||||
1131461 | 1131461 | MA | Dukes | school | 2500035 | 466 | Martha's Vineyard Charter (District) | 250003500569 | 4660550 | Martha's Vineyard Charter School | Regular School | Yes | Other | KG | 12 | 2017 | grade_12 | 9 | 0 | 2 | 0 | 0 | 0 | 1 | 5 | 7 | 12 | 9 | 0 | 2 | 0 | 0 | 0 | 1 | 5 | 7 | 12 | |||||||||||||||||||||||||||||||||
1131464 | 1131464 | MA | Worcester | school | 2500036 | 468 | Ma Academy for Math and Science | 250003600576 | 4680505 | Ma Academy for Math and Science School | Regular School | No | High | 11 | 12 | 2017 | grade_12 | 26 | 0 | 0 | 0 | 21 | 0 | 1 | 28 | 20 | 48 | 26 | 0 | 0 | 0 | 21 | 0 | 1 | 28 | 20 | 48 | |||||||||||||||||||||||||||||||||
1131553 | 1131553 | MA | Plymouth | school | 2500057 | 483 | Rising Tide Charter Public (District) | 250005701271 | 4830305 | Rising Tide Charter Public School | Regular School | Yes | Other | 05 | 12 | 2017 | grade_12 | 67 | 0 | 0 | 0 | 1 | 0 | 1 | 30 | 39 | 69 | 67 | 0 | 0 | 0 | 1 | 0 | 1 | 30 | 39 | 69 | |||||||||||||||||||||||||||||||||
1131611 | 1131611 | MA | Barnstable | school | 2500058 | 489 | Sturgis Charter Public (District) | 250005801272 | 4890505 | Sturgis Charter Public School | Regular School | Yes | High | 09 | 12 | 2017 | grade_12 | 166 | 0 | 0 | 0 | 3 | 0 | 13 | 71 | 111 | 182 | 166 | 0 | 0 | 0 | 3 | 0 | 13 | 71 | 111 | 182 | |||||||||||||||||||||||||||||||||
1131796 | 1131796 | MA | Worcester | school | 2502040 | 610 | Ashburnham-Westminster | 250204000069 | 6100505 | Oakmont Regional High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 165 | 0 | 8 | 0 | 2 | 0 | 4 | 90 | 89 | 179 | 165 | 0 | 8 | 0 | 2 | 0 | 4 | 90 | 89 | 179 | |||||||||||||||||||||||||||||||||
1131871 | 1131871 | MA | Worcester | school | 2502580 | 620 | Berlin-Boylston | 250258000160 | 6200505 | Tahanto Regional High | Regular School | No | Other | 06 | 12 | 2017 | grade_12 | 82 | 0 | 1 | 0 | 4 | 0 | 0 | 39 | 48 | 87 | 82 | 0 | 1 | 0 | 4 | 0 | 0 | 39 | 48 | 87 | |||||||||||||||||||||||||||||||||
1132148 | 1132148 | MA | Hampshire | school | 2505160 | 672 | Gateway | 250516000758 | 6720505 | Gateway Regional High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 51 | 0 | 1 | 0 | 1 | 0 | 2 | 23 | 32 | 55 | 51 | 0 | 1 | 0 | 1 | 0 | 2 | 23 | 32 | 55 | |||||||||||||||||||||||||||||||||
1132172 | 1132172 | MA | Middlesex | school | 2505500 | 673 | Groton-Dunstable | 250550000807 | 6730505 | Groton Dunstable Regional | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 201 | 0 | 2 | 0 | 11 | 0 | 0 | 108 | 106 | 214 | 201 | 0 | 2 | 0 | 11 | 0 | 0 | 108 | 106 | 214 | |||||||||||||||||||||||||||||||||
1132198 | 1132198 | MA | Franklin | school | 2505270 | 674 | Gill-Montague | 250527000768 | 6740505 | Turners Fall High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 53 | 0 | 4 | 0 | 0 | 0 | 1 | 28 | 30 | 58 | 53 | 0 | 4 | 0 | 0 | 0 | 1 | 28 | 30 | 58 | |||||||||||||||||||||||||||||||||
1132445 | 1132445 | MA | Worcester | school | 2508280 | 720 | Narragansett | 250828001285 | 7200505 | Narragansett Regional High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 70 | 0 | 2 | 0 | 1 | 0 | 5 | 33 | 45 | 78 | 70 | 0 | 2 | 0 | 1 | 0 | 5 | 33 | 45 | 78 | |||||||||||||||||||||||||||||||||
1132671 | 1132671 | MA | Franklin | school | 2509900 | 755 | Ralph C Mahar | 250990001587 | 7550505 | Ralph C Mahar Regional | Regular School | No | High | 07 | 12 | 2017 | grade_12 | 69 | 0 | 0 | 1 | 1 | 0 | 5 | 42 | 34 | 76 | 69 | 0 | 0 | 1 | 1 | 0 | 5 | 42 | 34 | 76 | |||||||||||||||||||||||||||||||||
1132674 | 1132674 | MA | Worcester | school | 2509900 | 755 | Ralph C Mahar | 250990002701 | 7550515 | Pathways Early College Innovation School | Regular School | No | High | 11 | 12 | 2017 | grade_12 | 16 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 11 | 17 | 16 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 11 | 17 | |||||||||||||||||||||||||||||||||
1132718 | 1132718 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001774 | 7650505 | Mt Everett Regional | Regular School | No | High | 07 | 12 | 2017 | grade_12 | 41 | 0 | 4 | 0 | 0 | 0 | 1 | 22 | 24 | 46 | 41 | 0 | 4 | 0 | 0 | 0 | 1 | 22 | 24 | 46 | |||||||||||||||||||||||||||||||||
1132767 | 1132767 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201790 | 7670505 | David Prouty High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 90 | 0 | 7 | 0 | 0 | 0 | 5 | 57 | 45 | 102 | 90 | 0 | 7 | 0 | 0 | 0 | 5 | 57 | 45 | 102 | |||||||||||||||||||||||||||||||||
1132775 | 1132775 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001900 | 7700505 | Tantasqua Regional Sr High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 187 | 0 | 10 | 0 | 5 | 0 | 7 | 81 | 128 | 209 | 187 | 0 | 10 | 0 | 5 | 0 | 7 | 81 | 128 | 209 | |||||||||||||||||||||||||||||||||
1132780 | 1132780 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001901 | 7700605 | Tantasqua Regional Vocational | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 118 | 0 | 2 | 2 | 1 | 0 | 4 | 81 | 46 | 127 | 118 | 0 | 2 | 2 | 1 | 0 | 4 | 81 | 46 | 127 | |||||||||||||||||||||||||||||||||
1132934 | 1132934 | MA | Worcester | school | 2512100 | 778 | Quaboag Regional | 251210001994 | 7780505 | Quaboag Regional High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 85 | 0 | 8 | 0 | 2 | 0 | 6 | 47 | 54 | 101 | 85 | 0 | 8 | 0 | 2 | 0 | 6 | 47 | 54 | 101 | |||||||||||||||||||||||||||||||||
1133005 | 1133005 | MA | Franklin | school | 2505020 | 818 | Franklin County Regional Vocational Technical | 250502000744 | 8180605 | Franklin County Technical | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 113 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 45 | 113 | 113 | 0 | 0 | 0 | 0 | 0 | 0 | 68 | 45 | 113 | |||||||||||||||||||||||||||||||||
1133060 | 1133060 | MA | Bristol | school | 2509140 | 855 | Old Colony Regional Vocational Technical | 250914001471 | 8550605 | Old Colony Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 129 | 0 | 1 | 0 | 0 | 0 | 4 | 73 | 61 | 134 | 129 | 0 | 1 | 0 | 0 | 0 | 4 | 73 | 61 | 134 | |||||||||||||||||||||||||||||||||
1133065 | 1133065 | MA | Hampden | school | 2509310 | 860 | Pathfinder Regional Vocational Technical | 250931002285 | 8600605 | Pathfinder Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 117 | 0 | 5 | 3 | 1 | 0 | 8 | 83 | 51 | 134 | 117 | 0 | 5 | 3 | 1 | 0 | 8 | 83 | 51 | 134 | |||||||||||||||||||||||||||||||||
1133080 | 1133080 | MA | Plymouth | school | 2510930 | 873 | South Shore Regional Vocational Technical | 251093001756 | 8730605 | So Shore Vocational Technical High | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 135 | 0 | 1 | 0 | 0 | 1 | 0 | 93 | 44 | 137 | 135 | 0 | 1 | 0 | 0 | 1 | 0 | 93 | 44 | 137 | |||||||||||||||||||||||||||||||||
1133085 | 1133085 | MA | Worcester | school | 2511050 | 876 | Southern Worcester County Regional Vocational Technical | 251105001779 | 8760605 | Bay Path Regional Vocational Technical High School | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 233 | 0 | 11 | 1 | 0 | 0 | 1 | 133 | 113 | 246 | 233 | 0 | 11 | 1 | 0 | 0 | 1 | 133 | 113 | 246 | |||||||||||||||||||||||||||||||||
1133105 | 1133105 | MA | Bristol | school | 2503070 | 910 | Bristol County Agricultural | 250307000382 | 9100705 | Bristol County Agricultural High | Career and Technical School | No | High | 09 | 12 | 2017 | grade_12 | 105 | 0 | 3 | 1 | 0 | 0 | 0 | 35 | 74 | 109 | 105 | 0 | 3 | 1 | 0 | 0 | 0 | 35 | 74 | 109 | |||||||||||||||||||||||||||||||||
1364857 | 1364857 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 132 | 0 | 6 | 0 | 2 | 0 | 2 | 71 | 71 | * | 142.0 | 132 | 0 | 6 | 0 | 2 | 0 | 2 | 71 | 71 | 142 | ||||||||||||||||||||||||||||||||
1365153 | 1365153 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246002543 | 250510 | Keough Memorial Academy | Alternative School | No | High | 08 | 12 | 2020 | grade_12 | 6 | 0 | 2 | 0 | 0 | 0 | 1 | 4 | 4 | * | 9.0 | 6 | 0 | 2 | 0 | 0 | 0 | 1 | 4 | 4 | 9 | ||||||||||||||||||||||||||||||||
1365974 | 1365974 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002753 | 350549 | Margarita Muniz Academy | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 2 | 0 | 64 | 0 | 0 | 0 | 0 | 26 | 40 | * | 66.0 | 2 | 0 | 64 | 0 | 0 | 0 | 0 | 26 | 40 | 66 | ||||||||||||||||||||||||||||||||
1367112 | 1367112 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480000642 | 940505 | Fairhaven High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 141 | 0 | 11 | 0 | 3 | 0 | 3 | 65 | 93 | * | 158.0 | 141 | 0 | 11 | 0 | 3 | 0 | 3 | 65 | 93 | 158 | ||||||||||||||||||||||||||||||||
1367474 | 1367474 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000764 | 1050505 | Georgetown High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 98 | 0 | 2 | 0 | 1 | 0 | 5 | 52 | 54 | * | 106.0 | 98 | 0 | 2 | 0 | 1 | 0 | 5 | 52 | 54 | 106 | ||||||||||||||||||||||||||||||||
1367549 | 1367549 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby Jr Sr High School | Regular School | No | High | 07 | 12 | 2020 | grade_12 | 50 | 0 | 2 | 0 | 0 | 0 | 2 | 25 | 29 | * | 54.0 | 50 | 0 | 2 | 0 | 0 | 0 | 2 | 25 | 29 | 54 | ||||||||||||||||||||||||||||||||
1367587 | 1367587 | MA | Hampshire | school | 2505580 | 117 | Hadley | 250558000813 | 1170505 | Hopkins Academy | Regular School | No | High | 07 | 12 | 2020 | grade_12 | 24 | 0 | 5 | 0 | 2 | 0 | 0 | 14 | 17 | * | 31.0 | 24 | 0 | 5 | 0 | 2 | 0 | 0 | 14 | 17 | 31 | ||||||||||||||||||||||||||||||||
1367615 | 1367615 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579000829 | 1220505 | Hanover High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 182 | 0 | 2 | 0 | 6 | 0 | 0 | 98 | 92 | * | 190.0 | 182 | 0 | 2 | 0 | 6 | 0 | 0 | 98 | 92 | 190 | ||||||||||||||||||||||||||||||||
1367643 | 1367643 | MA | Hampshire | school | 2505940 | 127 | Hatfield | 250594000845 | 1270505 | Smith Academy | Regular School | No | High | 07 | 12 | 2020 | grade_12 | 28 | 0 | 1 | 0 | 0 | 0 | 2 | 15 | 16 | * | 31.0 | 28 | 0 | 1 | 0 | 0 | 0 | 2 | 15 | 16 | 31 | ||||||||||||||||||||||||||||||||
1367892 | 1367892 | MA | Middlesex | school | 2506330 | 139 | Hopkinton | 250633000920 | 1390505 | Hopkinton High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 254 | 0 | 8 | 1 | 28 | 0 | 3 | 149 | 145 | * | 294.0 | 254 | 0 | 8 | 1 | 28 | 0 | 3 | 149 | 145 | 294 |
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]);