enrollments
Data source: Big Local News · About: Big Local
500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1366283 | 1366283 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000417 | 460015 | Coolidge Corner School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 52 | 7 | 18 | 0 | 9 | 0 | 7 | 50 | 43 | * | 93.0 | 52 | 7 | 18 | 0 | 9 | 0 | 7 | 50 | 43 | 93 | ||||||||||||||||||||||||||||||||
1365339 | 1365339 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002622 | 350020 | Curley K-8 School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 3 | 20 | 64 | 0 | 1 | 0 | 3 | 42 | 49 | * | 91.0 | 3 | 20 | 64 | 0 | 1 | 0 | 3 | 42 | 49 | 91 | ||||||||||||||||||||||||||||||||
1374314 | 1374314 | MA | Dukes | school | 2505340 | 109 | Gosnold | 250534000725 | 1090005 | Cuttyhunk Elementary | Regular School | No | Ungraded | UG | UG | 2020 | grade_7 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1365026 | 1365026 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000087 | 160315 | Cyril K. Brennan Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 98 | 10 | 40 | 0 | 9 | 0 | 5 | 88 | 74 | * | 162.0 | 98 | 10 | 40 | 0 | 9 | 0 | 5 | 88 | 74 | 162 | ||||||||||||||||||||||||||||||||
1369120 | 1369120 | MA | Nantucket | school | 2508250 | 197 | Nantucket | 250825001281 | 1970010 | Cyrus Peirce | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 62 | 11 | 44 | 0 | 3 | 0 | 4 | 64 | 60 | * | 124.0 | 62 | 11 | 44 | 0 | 3 | 0 | 4 | 64 | 60 | 124 | ||||||||||||||||||||||||||||||||
1372117 | 1372117 | MA | Middlesex | school | 2513200 | 347 | Woburn | 251320002182 | 3470410 | Daniel L Joyce Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 142 | 18 | 28 | 0 | 9 | 0 | 8 | 102 | 103 | * | 205.0 | 142 | 18 | 28 | 0 | 9 | 0 | 8 | 102 | 103 | 205 | ||||||||||||||||||||||||||||||||
1366812 | 1366812 | MA | Bristol | school | 2504020 | 72 | Dartmouth | 250402000541 | 720050 | Dartmouth Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 274 | 3 | 11 | 0 | 2 | 1 | 16 | 173 | 134 | * | 307.0 | 274 | 3 | 11 | 0 | 2 | 1 | 16 | 173 | 134 | 307 | ||||||||||||||||||||||||||||||||
1367913 | 1367913 | MA | Middlesex | school | 2506390 | 141 | Hudson | 250639000927 | 1410410 | David J. Quinn Middle School | Regular School | No | Middle | 05 | 07 | 2020 | grade_7 | 159 | 6 | 25 | 0 | 2 | 0 | 11 | 105 | 98 | * | 203.0 | 159 | 6 | 25 | 0 | 2 | 0 | 11 | 105 | 98 | 203 | ||||||||||||||||||||||||||||||||
1365386 | 1365386 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000222 | 350074 | Dearborn | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 2 | 49 | 26 | 0 | 3 | 2 | 2 | 41 | 43 | * | 84.0 | 2 | 49 | 26 | 0 | 3 | 2 | 2 | 41 | 43 | 84 | ||||||||||||||||||||||||||||||||
1366841 | 1366841 | MA | Norfolk | school | 2504050 | 73 | Dedham | 250405000551 | 730305 | Dedham Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 173 | 21 | 45 | 1 | 5 | 0 | 13 | 137 | 121 | * | 258.0 | 173 | 21 | 45 | 1 | 5 | 0 | 13 | 137 | 121 | 258 | ||||||||||||||||||||||||||||||||
1365400 | 1365400 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000223 | 350077 | Dennis C Haley | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 1 | 15 | 21 | 0 | 0 | 1 | 3 | 18 | 23 | * | 41.0 | 1 | 15 | 21 | 0 | 0 | 1 | 3 | 18 | 23 | 41 | ||||||||||||||||||||||||||||||||
1367065 | 1367065 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002787 | 930030 | Devens School | Regular School | No | Other | KG | 12 | 2020 | grade_7 | 1 | 4 | 3 | 0 | 0 | 0 | 1 | 8 | 1 | * | 9.0 | 1 | 4 | 3 | 0 | 0 | 0 | 1 | 8 | 1 | 9 | ||||||||||||||||||||||||||||||||
1373273 | 1373273 | MA | Bristol | school | 2504200 | 650 | Dighton-Rehoboth | 250420000400 | 6500305 | Dighton Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 84 | 1 | 7 | 0 | 0 | 0 | 5 | 47 | 50 | * | 97.0 | 84 | 1 | 7 | 0 | 0 | 0 | 5 | 47 | 50 | 97 | ||||||||||||||||||||||||||||||||
1364917 | 1364917 | MA | Essex | school | 2501950 | 9 | Andover | 250195002510 | 90305 | Doherty Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 139 | 2 | 13 | 1 | 19 | 1 | 4 | 92 | 87 | * | 179.0 | 139 | 2 | 13 | 1 | 19 | 1 | 4 | 92 | 87 | 179 | ||||||||||||||||||||||||||||||||
1365410 | 1365410 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000224 | 350080 | Donald Mckay | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 6 | 1 | 97 | 0 | 1 | 0 | 0 | 55 | 50 | * | 105.0 | 6 | 1 | 97 | 0 | 1 | 0 | 0 | 55 | 50 | 105 | ||||||||||||||||||||||||||||||||
1368976 | 1368976 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001376 | 1810060 | Donald P Timony Grammar | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 57 | 1 | 63 | 1 | 7 | 0 | 8 | 78 | 59 | * | 137.0 | 57 | 1 | 63 | 1 | 7 | 0 | 8 | 78 | 59 | 137 | ||||||||||||||||||||||||||||||||
1373277 | 1373277 | MA | Bristol | school | 2504200 | 650 | Dighton-Rehoboth | 250420002430 | 6500310 | Dorothy L Beckwith | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 127 | 1 | 4 | 0 | 0 | 0 | 7 | 72 | 67 | * | 139.0 | 127 | 1 | 4 | 0 | 0 | 0 | 7 | 72 | 67 | 139 | ||||||||||||||||||||||||||||||||
1366864 | 1366864 | MA | Worcester | school | 2504230 | 77 | Douglas | 250423002788 | 770305 | Douglas Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 96 | 1 | 4 | 0 | 2 | 0 | 2 | 47 | 58 | * | 105.0 | 96 | 1 | 4 | 0 | 2 | 0 | 2 | 47 | 58 | 105 | ||||||||||||||||||||||||||||||||
1373286 | 1373286 | MA | Norfolk | school | 2504290 | 655 | Dover-Sherborn | 250429000575 | 6550405 | Dover-Sherborn Regional Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 124 | 8 | 5 | 0 | 20 | 0 | 6 | 93 | 70 | * | 163.0 | 124 | 8 | 5 | 0 | 20 | 0 | 6 | 93 | 70 | 163 | ||||||||||||||||||||||||||||||||
1368404 | 1368404 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000086 | 1600345 | Dr An Wang School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 52 | 12 | 71 | 0 | 30 | 0 | 7 | 102 | 70 | * | 172.0 | 52 | 12 | 71 | 0 | 30 | 0 | 7 | 102 | 70 | 172 | ||||||||||||||||||||||||||||||||
1367669 | 1367669 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597000852 | 1280050 | Dr Paul Nettle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 70 | 6 | 59 | 1 | 5 | 1 | 5 | 73 | 74 | * | 147.0 | 70 | 6 | 59 | 1 | 5 | 1 | 5 | 73 | 74 | 147 | ||||||||||||||||||||||||||||||||
1368425 | 1368425 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002876 | 1600605 | Dr. Janice Adie Day School | Special Education School | No | Other | PK | 12 | 2020 | grade_7 | * | * | * | * | * | * | * | 3 | 2 | * | 5.0 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||||||||
1370540 | 1370540 | MA | Bristol | school | 2510590 | 265 | Seekonk | 251059001700 | 2650405 | Dr. Kevin M. Hurley Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 162 | 2 | 7 | 0 | 3 | 0 | 10 | 109 | 75 | * | 184.0 | 162 | 2 | 7 | 0 | 3 | 0 | 10 | 109 | 75 | 184 | ||||||||||||||||||||||||||||||||
1369778 | 1369778 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001468 | 2200305 | Dr. Philip O. Coakley Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 169 | 28 | 34 | 0 | 17 | 1 | 6 | 121 | 134 | * | 255.0 | 169 | 28 | 34 | 0 | 17 | 1 | 6 | 121 | 134 | 255 | ||||||||||||||||||||||||||||||||
1365883 | 1365883 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000952 | 350426 | Dr. William Henderson Upper | Regular School | No | Other | 02 | 12 | 2020 | grade_7 | 11 | 24 | 23 | 2 | 3 | 0 | 0 | 30 | 33 | * | 63.0 | 11 | 24 | 23 | 2 | 3 | 0 | 0 | 30 | 33 | 63 | ||||||||||||||||||||||||||||||||
1369514 | 1369514 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001387 | 2090505 | Drury High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 103 | 2 | 8 | 0 | 1 | 1 | 10 | 60 | 65 | * | 125.0 | 103 | 2 | 8 | 0 | 1 | 1 | 10 | 60 | 65 | 125 | ||||||||||||||||||||||||||||||||
1373306 | 1373306 | MA | Worcester | school | 2504360 | 658 | Dudley-Charlton Reg | 250436001595 | 6580305 | Dudley Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 113 | 2 | 8 | 1 | 1 | 0 | 1 | 62 | 64 | * | 126.0 | 113 | 2 | 8 | 1 | 1 | 0 | 1 | 62 | 64 | 126 | ||||||||||||||||||||||||||||||||
1366672 | 1366672 | MA | Hampden | school | 2503660 | 61 | Chicopee | 250366000722 | 610310 | Dupont Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 119 | 10 | 124 | 1 | 9 | 0 | 8 | 155 | 116 | * | 271.0 | 119 | 10 | 124 | 1 | 9 | 0 | 8 | 155 | 116 | 271 | ||||||||||||||||||||||||||||||||
1366917 | 1366917 | MA | Plymouth | school | 2504410 | 82 | Duxbury | 250441000975 | 820305 | Duxbury Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 241 | 0 | 6 | 1 | 3 | 0 | 7 | 114 | 144 | * | 258.0 | 241 | 0 | 6 | 1 | 3 | 0 | 7 | 114 | 144 | 258 | ||||||||||||||||||||||||||||||||
1370683 | 1370683 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001736 | 2740111 | E Somerville Community | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 12 | 5 | 57 | 1 | 3 | 0 | 0 | 35 | 43 | * | 78.0 | 12 | 5 | 57 | 1 | 3 | 0 | 0 | 35 | 43 | 78 | ||||||||||||||||||||||||||||||||
1371903 | 1371903 | MA | Norfolk | school | 2512810 | 335 | Westwood | 251281002097 | 3350305 | E W Thurston Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 181 | 5 | 9 | 0 | 28 | 0 | 5 | 131 | 97 | * | 228.0 | 181 | 5 | 9 | 0 | 28 | 0 | 5 | 131 | 97 | 228 | ||||||||||||||||||||||||||||||||
1366931 | 1366931 | MA | Plymouth | school | 2504440 | 83 | East Bridgewater | 250444000597 | 830505 | East Bridgewater JR./SR. High School | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 151 | 9 | 1 | 1 | 0 | 1 | 6 | 100 | 69 | * | 169.0 | 151 | 9 | 1 | 1 | 0 | 1 | 6 | 100 | 69 | 169 | ||||||||||||||||||||||||||||||||
1366117 | 1366117 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000364 | 400305 | East Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 147 | 28 | 18 | 0 | 64 | 0 | 1 | 133 | 125 | * | 258.0 | 147 | 28 | 18 | 0 | 64 | 0 | 1 | 133 | 125 | 258 | ||||||||||||||||||||||||||||||||
1366226 | 1366226 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000389 | 440405 | East Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 24 | 199 | 33 | 2 | 3 | 0 | 11 | 139 | 133 | * | 272.0 | 24 | 199 | 33 | 2 | 3 | 0 | 11 | 139 | 133 | 272 | ||||||||||||||||||||||||||||||||
1367002 | 1367002 | MA | Bristol | school | 2504620 | 88 | Easton | 250462000618 | 880405 | Easton Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 246 | 28 | 17 | 0 | 7 | 0 | 9 | 150 | 157 | * | 307.0 | 246 | 28 | 17 | 0 | 7 | 0 | 9 | 150 | 157 | 307 | ||||||||||||||||||||||||||||||||
1366181 | 1366181 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000390 | 440023 | Edgar B Davis | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 16 | 84 | 19 | 1 | 2 | 0 | 7 | 65 | 64 | * | 129.0 | 16 | 84 | 19 | 1 | 2 | 0 | 7 | 65 | 64 | 129 | ||||||||||||||||||||||||||||||||
1367017 | 1367017 | MA | Dukes | school | 2509090 | 89 | Edgartown | 250909001469 | 890005 | Edgartown Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 25 | 1 | 7 | 2 | 1 | 0 | 2 | 20 | 18 | * | 38.0 | 25 | 1 | 7 | 2 | 1 | 0 | 2 | 20 | 18 | 38 | ||||||||||||||||||||||||||||||||
1365820 | 1365820 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002689 | 350375 | Edison K-8 | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 6 | 11 | 38 | 0 | 4 | 0 | 3 | 33 | 29 | * | 62.0 | 6 | 11 | 38 | 0 | 4 | 0 | 3 | 33 | 29 | 62 | ||||||||||||||||||||||||||||||||
1366273 | 1366273 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000416 | 460005 | Edith C Baker | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 57 | 4 | 11 | 0 | 17 | 0 | 6 | 51 | 44 | * | 95.0 | 57 | 4 | 11 | 0 | 17 | 0 | 6 | 51 | 44 | 95 | ||||||||||||||||||||||||||||||||
1371451 | 1371451 | MA | Norfolk | school | 2511970 | 307 | Walpole | 251197001965 | 3070310 | Eleanor N Johnson Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 112 | 6 | 11 | 2 | 10 | 0 | 4 | 76 | 69 | * | 145.0 | 112 | 6 | 11 | 2 | 10 | 0 | 4 | 76 | 69 | 145 | ||||||||||||||||||||||||||||||||
1365427 | 1365427 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Eliot Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 15 | 8 | 14 | 0 | 5 | 0 | 1 | 23 | 20 | * | 43.0 | 15 | 8 | 14 | 0 | 5 | 0 | 1 | 23 | 20 | 43 | ||||||||||||||||||||||||||||||||
1368038 | 1368038 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000955 | 1490080 | Emily G Wetherbee | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 6 | 1 | 65 | 0 | 1 | 0 | 1 | 36 | 38 | * | 74.0 | 6 | 1 | 65 | 0 | 1 | 0 | 1 | 36 | 38 | 74 | ||||||||||||||||||||||||||||||||
1371182 | 1371182 | MA | Middlesex | school | 2511340 | 288 | Sudbury | 251134001872 | 2880305 | Ephraim Curtis Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 260 | 12 | 18 | 0 | 31 | 1 | 22 | 158 | 186 | * | 344.0 | 260 | 12 | 18 | 0 | 31 | 1 | 22 | 158 | 186 | 344 | ||||||||||||||||||||||||||||||||
1366592 | 1366592 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001772 | 570045 | Eugene Wright Science and Technology Academy | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 7 | 8 | 112 | 0 | 0 | 0 | 2 | 58 | 71 | * | 129.0 | 7 | 8 | 112 | 0 | 0 | 0 | 2 | 58 | 71 | 129 | ||||||||||||||||||||||||||||||||
1372454 | 1372454 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | High | 05 | 12 | 2020 | grade_7 | 24 | 8 | 140 | 0 | 0 | 1 | 1 | 88 | 86 | * | 174.0 | 24 | 8 | 140 | 0 | 0 | 1 | 1 | 88 | 86 | 174 | ||||||||||||||||||||||||||||||||
1369468 | 1369468 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861000314 | 2070315 | F A Day Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 215 | 9 | 31 | 1 | 52 | 0 | 20 | 163 | 165 | * | 328.0 | 215 | 9 | 31 | 1 | 52 | 0 | 20 | 163 | 165 | 328 | ||||||||||||||||||||||||||||||||
1368601 | 1368601 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002647 | 1630525 | Fecteau-Leary Junior/Senior High School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 3 | 0 | 4 | 0 | 0 | 0 | 2 | 8 | 1 | * | 9.0 | 3 | 0 | 4 | 0 | 0 | 0 | 2 | 8 | 1 | 9 | ||||||||||||||||||||||||||||||||
1368651 | 1368651 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001345 | 1650013 | Ferryway | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 29 | 24 | 43 | 0 | 17 | 0 | 9 | 61 | 61 | * | 122.0 | 29 | 24 | 43 | 0 | 17 | 0 | 9 | 61 | 61 | 122 | ||||||||||||||||||||||||||||||||
1373668 | 1373668 | MA | Worcester | school | 2508310 | 725 | Nashoba | 250831001102 | 7250025 | Florence Sawyer School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 78 | 0 | 6 | 0 | 7 | 0 | 1 | 47 | 45 | * | 92.0 | 78 | 0 | 6 | 0 | 7 | 0 | 1 | 47 | 45 | 92 | ||||||||||||||||||||||||||||||||
1372386 | 1372386 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002213 | 3480415 | Forest Grove Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 168 | 71 | 167 | 2 | 29 | 0 | 24 | 236 | 225 | * | 461.0 | 168 | 71 | 167 | 2 | 29 | 0 | 24 | 236 | 225 | 461 | ||||||||||||||||||||||||||||||||
1371003 | 1371003 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Forest Park Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 31 | 44 | 153 | 0 | 13 | 0 | 5 | 127 | 119 | * | 246.0 | 31 | 44 | 153 | 0 | 13 | 0 | 5 | 127 | 119 | 246 | ||||||||||||||||||||||||||||||||
1368660 | 1368660 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001351 | 1650027 | Forestdale | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 31 | 13 | 23 | 0 | 4 | 0 | 4 | 27 | 48 | * | 75.0 | 31 | 13 | 23 | 0 | 4 | 0 | 4 | 27 | 48 | 75 | ||||||||||||||||||||||||||||||||
1372476 | 1372476 | MA | Franklin | school | 2500076 | 413 | Four Rivers Charter Public (District) | 250007602086 | 4130505 | Four Rivers Charter Public School | Regular School | Yes | High | 07 | 12 | 2020 | grade_7 | 35 | 0 | 1 | 0 | 0 | 0 | 2 | 16 | 22 | * | 38.0 | 35 | 0 | 1 | 0 | 0 | 0 | 2 | 16 | 22 | 38 | ||||||||||||||||||||||||||||||||
1368821 | 1368821 | MA | Middlesex | school | 2507500 | 174 | Maynard | 250750000105 | 1740305 | Fowler School | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 74 | 3 | 13 | 0 | 2 | 0 | 2 | 55 | 38 | * | 94.0 | 74 | 3 | 13 | 0 | 2 | 0 | 2 | 55 | 38 | 94 | ||||||||||||||||||||||||||||||||
1372679 | 1372679 | MA | Norfolk | school | 2500052 | 446 | Foxborough Regional Charter (District) | 250005201250 | 4460550 | Foxborough Regional Charter School | Regular School | Yes | Other | KG | 12 | 2020 | grade_7 | 33 | 86 | 4 | 0 | 15 | 0 | 10 | 69 | 79 | * | 148.0 | 33 | 86 | 4 | 0 | 15 | 0 | 10 | 69 | 79 | 148 | ||||||||||||||||||||||||||||||||
1372818 | 1372818 | MA | Middlesex | school | 2500038 | 478 | Francis W. Parker Charter Essential (District) | 250003800581 | 4780505 | Francis W. Parker Charter Essential School | Regular School | Yes | High | 07 | 12 | 2020 | grade_7 | 64 | 3 | 3 | 0 | 2 | 0 | 3 | 35 | 40 | * | 75.0 | 64 | 3 | 3 | 0 | 2 | 0 | 3 | 35 | 40 | 75 | ||||||||||||||||||||||||||||||||
1365444 | 1365444 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000239 | 350116 | Franklin D Roosevelt | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 1 | 19 | 21 | 0 | 1 | 0 | 2 | 24 | 20 | * | 44.0 | 1 | 19 | 21 | 0 | 1 | 0 | 2 | 24 | 20 | 44 | ||||||||||||||||||||||||||||||||
1373164 | 1373164 | MA | Worcester | school | 2502715 | 622 | Blackstone-Millville | 250271501082 | 6220405 | Frederick W. Hartnett Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 127 | 0 | 15 | 0 | 2 | 0 | 4 | 63 | 85 | * | 148.0 | 127 | 0 | 15 | 0 | 2 | 0 | 4 | 63 | 85 | 148 | ||||||||||||||||||||||||||||||||
1373344 | 1373344 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000748 | 6650305 | Freetown-Lakeville Middle School | Regular School | No | Middle | 06 | 09 | 2020 | grade_7 | 228 | 6 | 4 | 1 | 4 | 0 | 6 | 113 | 136 | * | 249.0 | 228 | 6 | 4 | 1 | 4 | 0 | 6 | 113 | 136 | 249 | ||||||||||||||||||||||||||||||||
1373350 | 1373350 | MA | Franklin | school | 2505100 | 670 | Frontier | 250510000749 | 6700505 | Frontier Regional | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 103 | 2 | 9 | 0 | 2 | 0 | 6 | 68 | 54 | * | 122.0 | 103 | 2 | 9 | 0 | 2 | 0 | 6 | 68 | 54 | 122 | ||||||||||||||||||||||||||||||||
1368053 | 1368053 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002654 | 1490525 | Frost Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 14 | 3 | 109 | 0 | 8 | 0 | 2 | 76 | 60 | * | 136.0 | 14 | 3 | 109 | 0 | 8 | 0 | 2 | 76 | 60 | 136 | ||||||||||||||||||||||||||||||||
1367383 | 1367383 | MA | Middlesex | school | 2504980 | 100 | Framingham | 250498000464 | 1000305 | Fuller Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 67 | 21 | 101 | 0 | 2 | 0 | 5 | 115 | 81 | * | 196.0 | 67 | 21 | 101 | 0 | 2 | 0 | 5 | 115 | 81 | 196 | ||||||||||||||||||||||||||||||||
1368785 | 1368785 | MA | Plymouth | school | 2507350 | 171 | Marshfield | 250735001143 | 1710310 | Furnace Brook Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 309 | 2 | 9 | 2 | 3 | 0 | 10 | 158 | 177 | * | 335.0 | 309 | 2 | 9 | 2 | 3 | 0 | 10 | 158 | 177 | 335 | ||||||||||||||||||||||||||||||||
1371408 | 1371408 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191000776 | 3050310 | Galvin Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 218 | 6 | 22 | 1 | 7 | 0 | 11 | 134 | 131 | * | 265.0 | 218 | 6 | 22 | 1 | 7 | 0 | 11 | 134 | 131 | 265 | ||||||||||||||||||||||||||||||||
1367451 | 1367451 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513002431 | 1030405 | Gardner Middle School | Regular School | No | Middle | 05 | 07 | 2020 | grade_7 | 126 | 3 | 47 | 0 | 5 | 0 | 19 | 104 | 96 | * | 200.0 | 126 | 3 | 47 | 0 | 5 | 0 | 19 | 104 | 96 | 200 | ||||||||||||||||||||||||||||||||
1365750 | 1365750 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000331 | 350326 | Gardner Pilot Academy | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 6 | 8 | 20 | 0 | 2 | 0 | 2 | 22 | 16 | * | 38.0 | 6 | 8 | 20 | 0 | 2 | 0 | 2 | 22 | 16 | 38 | ||||||||||||||||||||||||||||||||
1370310 | 1370310 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001976 | 2480057 | Garfield Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 68 | 8 | 119 | 0 | 7 | 0 | 3 | 103 | 102 | * | 205.0 | 68 | 8 | 119 | 0 | 7 | 0 | 3 | 103 | 102 | 205 | ||||||||||||||||||||||||||||||||
1370518 | 1370518 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Gates Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 210 | 8 | 5 | 0 | 1 | 0 | 2 | 116 | 110 | * | 226.0 | 210 | 8 | 5 | 0 | 1 | 0 | 2 | 116 | 110 | 226 | ||||||||||||||||||||||||||||||||
1373372 | 1373372 | MA | Hampshire | school | 2505160 | 672 | Gateway | 250516002667 | 6720405 | Gateway Regional Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 57 | 0 | 3 | 1 | 0 | 0 | 1 | 37 | 25 | * | 62.0 | 57 | 0 | 3 | 1 | 0 | 0 | 1 | 37 | 25 | 62 | ||||||||||||||||||||||||||||||||
1367061 | 1367061 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002038 | 930028 | George Keverian School | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 32 | 21 | 66 | 0 | 7 | 0 | 4 | 65 | 65 | * | 130.0 | 32 | 21 | 66 | 0 | 7 | 0 | 4 | 65 | 65 | 130 | ||||||||||||||||||||||||||||||||
1367469 | 1367469 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522002764 | 1050305 | Georgetown Middle School | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 84 | 0 | 1 | 0 | 2 | 1 | 0 | 41 | 47 | * | 88.0 | 84 | 0 | 1 | 0 | 2 | 1 | 0 | 41 | 47 | 88 | ||||||||||||||||||||||||||||||||
1368259 | 1368259 | MA | Hampden | school | 2506990 | 159 | Longmeadow | 250699001019 | 1590017 | Glenbrook Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 78 | 3 | 7 | 0 | 16 | 1 | 3 | 53 | 55 | * | 108.0 | 78 | 3 | 7 | 0 | 16 | 1 | 3 | 53 | 55 | 108 | ||||||||||||||||||||||||||||||||
1372950 | 1372950 | MA | Bristol | school | 2500519 | 496 | Global Learning Charter Public (District) | 250051902629 | 4960305 | Global Learning Charter Public School | Regular School | Yes | High | 05 | 12 | 2020 | grade_7 | 35 | 9 | 40 | 1 | 1 | 0 | 3 | 42 | 47 | * | 89.0 | 35 | 9 | 40 | 1 | 1 | 0 | 3 | 42 | 47 | 89 | ||||||||||||||||||||||||||||||||
1367530 | 1367530 | MA | Worcester | school | 2505370 | 110 | Grafton | 250537002520 | 1100305 | Grafton Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 214 | 3 | 17 | 0 | 26 | 0 | 10 | 150 | 120 | * | 270.0 | 214 | 3 | 17 | 0 | 26 | 0 | 10 | 150 | 120 | 270 | ||||||||||||||||||||||||||||||||
1367544 | 1367544 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000790 | 1110505 | Granby Jr Sr High School | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 47 | 0 | 4 | 0 | 0 | 0 | 1 | 29 | 23 | * | 52.0 | 47 | 0 | 4 | 0 | 0 | 0 | 1 | 29 | 23 | 52 | ||||||||||||||||||||||||||||||||
1373414 | 1373414 | MA | Franklin | school | 2505270 | 674 | Gill-Montague | 250527002386 | 6740310 | Great Falls Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 56 | 0 | 11 | 1 | 0 | 0 | 11 | 36 | 43 | * | 79.0 | 56 | 0 | 11 | 1 | 0 | 0 | 11 | 36 | 43 | 79 | ||||||||||||||||||||||||||||||||
1373455 | 1373455 | MA | Hampden | school | 2505730 | 680 | Hampden-Wilbraham | 250573000822 | 6800005 | Green Meadows Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 10 | 1 | 4 | 0 | 0 | 0 | 0 | 5 | 10 | * | 15.0 | 10 | 1 | 4 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | ||||||||||||||||||||||||||||||||
1374287 | 1374287 | MA | Franklin | school | 2500551 | 3901 | Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District | 250055102808 | 39010900 | Greenfield Commonwealth Virtual School | Regular School | No | Other | KG | 12 | 2020 | grade_7 | 35 | 3 | 11 | 0 | 5 | 0 | 6 | 25 | 35 | * | 60.0 | 35 | 3 | 11 | 0 | 5 | 0 | 6 | 25 | 35 | 60 | ||||||||||||||||||||||||||||||||
1367568 | 1367568 | MA | Franklin | school | 2505490 | 114 | Greenfield | 250549000800 | 1140305 | Greenfield Middle | Regular School | No | Middle | 05 | 07 | 2020 | grade_7 | 88 | 2 | 21 | 0 | 2 | 0 | 5 | 59 | 59 | * | 118.0 | 88 | 2 | 21 | 0 | 2 | 0 | 5 | 59 | 59 | 118 | ||||||||||||||||||||||||||||||||
1373392 | 1373392 | MA | Middlesex | school | 2505500 | 673 | Groton-Dunstable | 250550000805 | 6730305 | Groton Dunstable Regional Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 159 | 5 | 5 | 0 | 10 | 0 | 5 | 88 | 96 | * | 184.0 | 159 | 5 | 5 | 0 | 10 | 0 | 5 | 88 | 96 | 184 | ||||||||||||||||||||||||||||||||
1368002 | 1368002 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Guilmette Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 5 | 2 | 114 | 0 | 0 | 0 | 2 | 61 | 62 | * | 123.0 | 5 | 2 | 114 | 0 | 0 | 0 | 2 | 61 | 62 | 123 | ||||||||||||||||||||||||||||||||
1373674 | 1373674 | MA | Worcester | school | 2508310 | 725 | Nashoba | 250831001868 | 7250310 | Hale | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 77 | 1 | 7 | 1 | 11 | 0 | 1 | 58 | 40 | * | 98.0 | 77 | 1 | 7 | 1 | 11 | 0 | 1 | 58 | 40 | 98 | ||||||||||||||||||||||||||||||||
1372974 | 1372974 | MA | Hampden | school | 2500522 | 499 | Hampden Charter School of Science (District) | 250052202680 | 4990305 | Hampden Charter School of Science East | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 16 | 31 | 39 | 0 | 2 | 0 | 4 | 43 | 49 | * | 92.0 | 16 | 31 | 39 | 0 | 2 | 0 | 4 | 43 | 49 | 92 | ||||||||||||||||||||||||||||||||
1374268 | 1374268 | MA | Hampden | school | 2500588 | 3516 | Hampden Charter School of Science West (District) | 250058802888 | 35160305 | Hampden Charter School of Science West | Regular School | Yes | Middle | 06 | 10 | 2020 | grade_7 | 36 | 9 | 21 | 0 | 0 | 0 | 1 | 33 | 34 | * | 67.0 | 36 | 9 | 21 | 0 | 0 | 0 | 1 | 33 | 34 | 67 | ||||||||||||||||||||||||||||||||
1373472 | 1373472 | MA | Hampshire | school | 2505740 | 683 | Hampshire | 250574000825 | 6830505 | Hampshire Regional High | Regular School | No | High | 07 | 12 | 2020 | grade_7 | 105 | 1 | 11 | 0 | 1 | 0 | 3 | 63 | 58 | * | 121.0 | 105 | 1 | 11 | 0 | 1 | 0 | 3 | 63 | 58 | 121 | ||||||||||||||||||||||||||||||||
1367610 | 1367610 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579002548 | 1220305 | Hanover Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 193 | 6 | 7 | 0 | 6 | 0 | 3 | 99 | 116 | * | 215.0 | 193 | 6 | 7 | 0 | 6 | 0 | 3 | 99 | 116 | 215 | ||||||||||||||||||||||||||||||||
1368230 | 1368230 | MA | Middlesex | school | 2506900 | 157 | Lincoln | 250690001008 | 1570305 | Hanscom Middle | Regular School | No | Middle | 04 | 08 | 2020 | grade_7 | 26 | 6 | 7 | 0 | 1 | 0 | 4 | 19 | 25 | * | 44.0 | 26 | 6 | 7 | 0 | 1 | 0 | 4 | 19 | 25 | 44 | ||||||||||||||||||||||||||||||||
1374065 | 1374065 | MA | Plymouth | school | 2512930 | 780 | Whitman-Hanson | 251293001286 | 7800315 | Hanson Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 106 | 1 | 6 | 1 | 3 | 0 | 1 | 59 | 59 | * | 118.0 | 106 | 1 | 6 | 1 | 3 | 0 | 1 | 59 | 59 | 118 | ||||||||||||||||||||||||||||||||
1368694 | 1368694 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001112 | 1670035 | Harold L Qualters Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 218 | 12 | 19 | 1 | 13 | 0 | 4 | 146 | 121 | * | 267.0 | 218 | 12 | 19 | 1 | 13 | 0 | 4 | 146 | 121 | 267 | ||||||||||||||||||||||||||||||||
1367107 | 1367107 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480002572 | 940305 | Hastings Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 126 | 1 | 7 | 2 | 4 | 0 | 4 | 74 | 70 | * | 144.0 | 126 | 1 | 7 | 2 | 4 | 0 | 4 | 74 | 70 | 144 | ||||||||||||||||||||||||||||||||
1373708 | 1373708 | MA | Middlesex | school | 2508790 | 735 | North Middlesex | 250879002280 | 7350030 | Hawthorne Brook | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 125 | 2 | 1 | 0 | 4 | 0 | 3 | 75 | 60 | * | 135.0 | 125 | 2 | 1 | 0 | 4 | 0 | 3 | 75 | 60 | 135 | ||||||||||||||||||||||||||||||||
1366302 | 1366302 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000418 | 460025 | Heath | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 39 | 2 | 7 | 0 | 9 | 0 | 5 | 23 | 39 | * | 62.0 | 39 | 2 | 7 | 0 | 9 | 0 | 5 | 23 | 39 | 62 | ||||||||||||||||||||||||||||||||
1372510 | 1372510 | MA | Suffolk | school | 2500077 | 419 | Helen Y. Davis Leadership Academy Charter Public (District) | 250007702091 | 4190305 | Helen Y. Davis Leadership Academy Charter Public School | Regular School | Yes | Middle | 06 | 08 | 2020 | grade_7 | 0 | 64 | 16 | 0 | 0 | 0 | 0 | 42 | 38 | * | 80.0 | 0 | 64 | 16 | 0 | 0 | 0 | 0 | 42 | 38 | 80 | ||||||||||||||||||||||||||||||||
1368396 | 1368396 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001034 | 1600330 | Henry J Robinson Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 32 | 15 | 84 | 0 | 23 | 0 | 4 | 80 | 78 | * | 158.0 | 32 | 15 | 84 | 0 | 23 | 0 | 4 | 80 | 78 | 158 | ||||||||||||||||||||||||||||||||
1367149 | 1367149 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Henry Lord Community School | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 27 | 7 | 38 | 0 | 5 | 0 | 8 | 38 | 47 | * | 85.0 | 27 | 7 | 38 | 0 | 5 | 0 | 8 | 38 | 47 | 85 | ||||||||||||||||||||||||||||||||
1365836 | 1365836 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | Middle | 03 | 08 | 2020 | grade_7 | 2 | 22 | 20 | 0 | 0 | 0 | 1 | 31 | 14 | * | 45.0 | 2 | 22 | 20 | 0 | 0 | 0 | 1 | 31 | 14 | 45 | ||||||||||||||||||||||||||||||||
1372741 | 1372741 | MA | Essex | school | 2500083 | 455 | Hill View Montessori Charter Public (District) | 250008301846 | 4550050 | Hill View Montessori Charter Public School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 20 | 2 | 10 | 0 | 1 | 0 | 0 | 10 | 23 | * | 33.0 | 20 | 2 | 10 | 0 | 1 | 0 | 0 | 10 | 23 | 33 | ||||||||||||||||||||||||||||||||
1372709 | 1372709 | MA | Hampshire | school | 2500031 | 450 | Hilltown Cooperative Charter Public (District) | 250003100549 | 4500105 | Hilltown Cooperative Charter Public School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_7 | 28 | 0 | 2 | 0 | 0 | 0 | 2 | 12 | 19 | * | 32.0 | 28 | 0 | 2 | 0 | 0 | 0 | 2 | 12 | 19 | 32 | ||||||||||||||||||||||||||||||||
1367745 | 1367745 | MA | Plymouth | school | 2506090 | 131 | Hingham | 250609000875 | 1310410 | Hingham Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 268 | 5 | 9 | 0 | 12 | 0 | 13 | 152 | 155 | * | 307.0 | 268 | 5 | 9 | 0 | 12 | 0 | 13 | 152 | 155 | 307 | ||||||||||||||||||||||||||||||||
1367760 | 1367760 | MA | Norfolk | school | 2506150 | 133 | Holbrook | 250615000878 | 1330505 | Holbrook Middle High School | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 45 | 20 | 13 | 0 | 7 | 0 | 9 | 40 | 53 | * | 94.0 | 45 | 20 | 13 | 0 | 7 | 0 | 9 | 40 | 53 | 94 |
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]);