enrollments
Data source: Big Local News · About: Big Local
491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by white_int
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
933337 | 933337 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000278 | 350190 | Joyce Kilmer | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 10 | 4 | 6 | 1 | 1 | 0 | 3 | 10 | 15 | 25 | 10 | 4 | 6 | 1 | 1 | 0 | 3 | 10 | 15 | 25 | |||||||||||||||||||||||||||||||||
938780 | 938780 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002642 | 2810350 | STEM Middle Academy | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 10 | 31 | 56 | 0 | 0 | 0 | 0 | 61 | 36 | 97 | 10 | 31 | 56 | 0 | 0 | 0 | 0 | 61 | 36 | 97 | |||||||||||||||||||||||||||||||||
938795 | 938795 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002840 | 2810367 | Chestnut Accelerated Middle School (Talented and Gifted) | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 10 | 9 | 53 | 0 | 2 | 0 | 3 | 33 | 44 | 77 | 10 | 9 | 53 | 0 | 2 | 0 | 3 | 33 | 44 | 77 | |||||||||||||||||||||||||||||||||
938802 | 938802 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002859 | 2810480 | Van Sickle Academy | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 10 | 25 | 84 | 0 | 1 | 0 | 0 | 69 | 51 | 120 | 10 | 25 | 84 | 0 | 1 | 0 | 0 | 69 | 51 | 120 | |||||||||||||||||||||||||||||||||
940320 | 940320 | MA | Essex | school | 2500082 | 429 | KIPP Academy Lynn Charter (District) | 250008201845 | 4290010 | KIPP Academy Lynn Charter School | Regular School | Yes | 4 | 05 | 12 | 2016 | grade_7 | 10 | 24 | 79 | 0 | 3 | 0 | 4 | 52 | 68 | 120 | 10 | 24 | 79 | 0 | 3 | 0 | 4 | 52 | 68 | 120 | |||||||||||||||||||||||||||||||||
933532 | 933532 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000333 | 350346 | Warren-Prescott | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 11 | 11 | 10 | 1 | 1 | 0 | 0 | 20 | 14 | 34 | 11 | 11 | 10 | 1 | 1 | 0 | 0 | 20 | 14 | 34 | |||||||||||||||||||||||||||||||||
935818 | 935818 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002758 | 1490085 | Spark Academy | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 11 | 0 | 138 | 0 | 5 | 0 | 0 | 73 | 81 | 154 | 11 | 0 | 138 | 0 | 5 | 0 | 0 | 73 | 81 | 154 | |||||||||||||||||||||||||||||||||
938427 | 938427 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001731 | 2740075 | Arthur D Healey | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 11 | 5 | 22 | 0 | 4 | 0 | 2 | 23 | 21 | 44 | 11 | 5 | 22 | 0 | 4 | 0 | 2 | 23 | 21 | 44 | |||||||||||||||||||||||||||||||||
938476 | 938476 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001749 | 2740120 | Winter Hill Community | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 11 | 5 | 24 | 0 | 5 | 0 | 0 | 20 | 25 | 45 | 11 | 5 | 24 | 0 | 5 | 0 | 0 | 20 | 25 | 45 | |||||||||||||||||||||||||||||||||
938798 | 938798 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002818 | 2810475 | Conservatory of the Arts | Regular School | No | 4 | 06 | 10 | 2016 | grade_7 | 11 | 17 | 29 | 0 | 0 | 0 | 1 | 14 | 44 | 58 | 11 | 17 | 29 | 0 | 0 | 0 | 1 | 14 | 44 | 58 | |||||||||||||||||||||||||||||||||
933398 | 933398 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000315 | 350240 | Richard J Murphy | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 12 | 26 | 18 | 0 | 25 | 1 | 6 | 56 | 32 | 88 | 12 | 26 | 18 | 0 | 25 | 1 | 6 | 56 | 32 | 88 | |||||||||||||||||||||||||||||||||
934374 | 934374 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354001158 | 570050 | Clark Avenue School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 12 | 6 | 111 | 0 | 4 | 0 | 2 | 75 | 60 | 135 | 12 | 6 | 111 | 0 | 4 | 0 | 2 | 75 | 60 | 135 | |||||||||||||||||||||||||||||||||
935562 | 935562 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000908 | 1370015 | Lt Elmer J McMahon Elementary | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 12 | 0 | 29 | 1 | 0 | 0 | 0 | 26 | 16 | 42 | 12 | 0 | 29 | 1 | 0 | 0 | 0 | 26 | 16 | 42 | |||||||||||||||||||||||||||||||||
936176 | 936176 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001954 | 1600090 | Bartlett Community Partnership | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 12 | 4 | 22 | 0 | 16 | 0 | 4 | 37 | 21 | 58 | 12 | 4 | 22 | 0 | 16 | 0 | 4 | 37 | 21 | 58 | |||||||||||||||||||||||||||||||||
938771 | 938771 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002601 | 2810328 | John F Kennedy Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 12 | 27 | 91 | 0 | 0 | 0 | 0 | 63 | 67 | 130 | 12 | 27 | 91 | 0 | 0 | 0 | 0 | 63 | 67 | 130 | |||||||||||||||||||||||||||||||||
940550 | 940550 | MA | Dukes | school | 2500035 | 466 | Martha's Vineyard Charter (District) | 250003500569 | 4660550 | Martha's Vineyard Charter School | Regular School | Yes | 4 | KG | 12 | 2016 | grade_7 | 12 | 0 | 1 | 0 | 2 | 0 | 1 | 12 | 4 | 16 | 12 | 0 | 1 | 0 | 2 | 0 | 1 | 12 | 4 | 16 | |||||||||||||||||||||||||||||||||
934010 | 934010 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000404 | 440410 | North Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 13 | 137 | 30 | 0 | 4 | 1 | 6 | 98 | 93 | 191 | 13 | 137 | 30 | 0 | 4 | 1 | 6 | 98 | 93 | 191 | |||||||||||||||||||||||||||||||||
938456 | 938456 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001736 | 2740111 | E Somerville Community | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 14 | 4 | 38 | 0 | 2 | 0 | 0 | 34 | 24 | 58 | 14 | 4 | 38 | 0 | 2 | 0 | 0 | 34 | 24 | 58 | |||||||||||||||||||||||||||||||||
940717 | 940717 | MA | Middlesex | school | 2500518 | 494 | Pioneer Charter School of Science (District) | 250051802632 | 4940205 | Pioneer Charter School of Science | Regular School | Yes | 3 | 07 | 12 | 2016 | grade_7 | 14 | 19 | 32 | 2 | 4 | 1 | 1 | 38 | 35 | 73 | 14 | 19 | 32 | 2 | 4 | 1 | 1 | 38 | 35 | 73 | |||||||||||||||||||||||||||||||||
933783 | 933783 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002721 | 350656 | Mario Umana Academy | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 15 | 7 | 116 | 0 | 6 | 0 | 2 | 77 | 69 | 146 | 15 | 7 | 116 | 0 | 6 | 0 | 2 | 77 | 69 | 146 | |||||||||||||||||||||||||||||||||
936205 | 936205 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001955 | 1600360 | Kathryn P. Stoklosa Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 15 | 4 | 43 | 0 | 101 | 0 | 5 | 90 | 78 | 168 | 15 | 4 | 43 | 0 | 101 | 0 | 5 | 90 | 78 | 168 | |||||||||||||||||||||||||||||||||
940237 | 940237 | MA | Suffolk | school | 2500075 | 410 | Excel Academy Charter (District) | 250007502084 | 4100205 | Excel Academy Charter School | Regular School | Yes | 2 | 05 | 09 | 2016 | grade_7 | 15 | 11 | 138 | 0 | 1 | 0 | 0 | 95 | 70 | 165 | 15 | 11 | 138 | 0 | 1 | 0 | 0 | 95 | 70 | 165 | |||||||||||||||||||||||||||||||||
933652 | 933652 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000216 | 350430 | Clarence R Edwards Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 16 | 11 | 86 | 0 | 8 | 0 | 0 | 63 | 58 | 121 | 16 | 11 | 86 | 0 | 8 | 0 | 0 | 63 | 58 | 121 | |||||||||||||||||||||||||||||||||
934467 | 934467 | MA | Berkshire | school | 2503720 | 63 | Clarksburg | 250372000510 | 630010 | Clarksburg Elementary | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 11 | 16 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 11 | 16 | |||||||||||||||||||||||||||||||||
935826 | 935826 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002654 | 1490525 | Frost Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 16 | 1 | 104 | 0 | 7 | 0 | 1 | 68 | 61 | 129 | 16 | 1 | 104 | 0 | 7 | 0 | 1 | 68 | 61 | 129 | |||||||||||||||||||||||||||||||||
938805 | 938805 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002855 | 2810485 | Van Sickle International Baccalaureate | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 16 | 18 | 100 | 0 | 1 | 0 | 0 | 67 | 68 | 135 | 16 | 18 | 100 | 0 | 1 | 0 | 0 | 67 | 68 | 135 | |||||||||||||||||||||||||||||||||
941731 | 941731 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 16 | 1 | 1 | 1 | 0 | 0 | 0 | 6 | 13 | 19 | 16 | 1 | 1 | 1 | 0 | 0 | 0 | 6 | 13 | 19 | |||||||||||||||||||||||||||||||||
936031 | 936031 | MA | Middlesex | school | 2506900 | 157 | Lincoln | 250690001008 | 1570305 | Hanscom Middle | Regular School | No | 2 | 04 | 08 | 2016 | grade_7 | 17 | 11 | 11 | 2 | 1 | 0 | 6 | 23 | 25 | 48 | 17 | 11 | 11 | 2 | 1 | 0 | 6 | 23 | 25 | 48 | |||||||||||||||||||||||||||||||||
934007 | 934007 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000389 | 440405 | East Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 21 | 123 | 24 | 0 | 1 | 2 | 9 | 98 | 82 | 180 | 21 | 123 | 24 | 0 | 1 | 2 | 9 | 98 | 82 | 180 | |||||||||||||||||||||||||||||||||
934857 | 934857 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477001521 | 930058 | Parlin School | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 21 | 24 | 43 | 0 | 1 | 0 | 2 | 48 | 43 | 91 | 21 | 24 | 43 | 0 | 1 | 0 | 2 | 48 | 43 | 91 | |||||||||||||||||||||||||||||||||
938447 | 938447 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001739 | 2740087 | Albert F. Argenziano School at Lincoln Park | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 21 | 4 | 16 | 0 | 2 | 0 | 0 | 21 | 22 | 43 | 21 | 4 | 16 | 0 | 2 | 0 | 0 | 21 | 22 | 43 | |||||||||||||||||||||||||||||||||
938191 | 938191 | MA | Essex | school | 2510380 | 258 | Salem | 251038000773 | 2580050 | Saltonstall School | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 22 | 0 | 9 | 0 | 0 | 0 | 3 | 12 | 22 | 34 | 22 | 0 | 9 | 0 | 0 | 0 | 3 | 12 | 22 | 34 | |||||||||||||||||||||||||||||||||
938466 | 938466 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089000891 | 2740115 | West Somerville Neighborhood | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 22 | 5 | 10 | 0 | 2 | 0 | 3 | 25 | 17 | 42 | 22 | 5 | 10 | 0 | 2 | 0 | 3 | 25 | 17 | 42 | |||||||||||||||||||||||||||||||||
938768 | 938768 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002600 | 2810325 | Forest Park Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 22 | 47 | 141 | 0 | 18 | 0 | 0 | 114 | 114 | 228 | 22 | 47 | 141 | 0 | 18 | 0 | 0 | 114 | 114 | 228 | |||||||||||||||||||||||||||||||||
934253 | 934253 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327002768 | 490310 | Putnam Avenue Upper School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 23 | 29 | 11 | 1 | 11 | 1 | 4 | 30 | 50 | 80 | 23 | 29 | 11 | 1 | 11 | 1 | 4 | 30 | 50 | 80 | |||||||||||||||||||||||||||||||||
937452 | 937452 | MA | Worcester | school | 2508760 | 215 | North Brookfield | 250876001411 | 2150505 | North Brookfield High | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 24 | 0 | 2 | 0 | 0 | 0 | 3 | 14 | 15 | 29 | 24 | 0 | 2 | 0 | 0 | 0 | 3 | 14 | 15 | 29 | |||||||||||||||||||||||||||||||||
938755 | 938755 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002137 | 2810205 | The Springfield Renaissance School an Expeditionary Learning School | Regular School | No | 4 | 06 | 12 | 2016 | grade_7 | 24 | 29 | 53 | 1 | 0 | 1 | 0 | 61 | 47 | 108 | 24 | 29 | 53 | 1 | 0 | 1 | 0 | 61 | 47 | 108 | |||||||||||||||||||||||||||||||||
939094 | 939094 | MA | Dukes | school | 2512570 | 296 | Tisbury | 251257002054 | 2960005 | Tisbury Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 24 | 1 | 5 | 2 | 1 | 0 | 2 | 16 | 19 | 35 | 24 | 1 | 5 | 2 | 1 | 0 | 2 | 16 | 19 | 35 | |||||||||||||||||||||||||||||||||
940507 | 940507 | MA | Essex | school | 2500083 | 455 | Hill View Montessori Charter Public (District) | 250008301846 | 4550050 | Hill View Montessori Charter Public School | Regular School | Yes | 1 | KG | 08 | 2016 | grade_7 | 25 | 2 | 7 | 0 | 0 | 0 | 0 | 13 | 21 | 34 | 25 | 2 | 7 | 0 | 0 | 0 | 0 | 13 | 21 | 34 | |||||||||||||||||||||||||||||||||
940635 | 940635 | MA | Essex | school | 2500062 | 482 | River Valley Charter (District) | 250006201446 | 4820050 | River Valley Charter School | Regular School | Yes | 1 | KG | 08 | 2016 | grade_7 | 25 | 0 | 2 | 0 | 4 | 0 | 0 | 15 | 16 | 31 | 25 | 0 | 2 | 0 | 4 | 0 | 0 | 15 | 16 | 31 | |||||||||||||||||||||||||||||||||
935045 | 935045 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002775 | 970340 | McKay Arts Academy | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 26 | 5 | 36 | 0 | 3 | 0 | 8 | 32 | 46 | 78 | 26 | 5 | 36 | 0 | 3 | 0 | 8 | 32 | 46 | 78 | |||||||||||||||||||||||||||||||||
936449 | 936449 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001363 | 1650057 | Salemwood | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 26 | 25 | 26 | 0 | 23 | 0 | 6 | 53 | 53 | 106 | 26 | 25 | 26 | 0 | 23 | 0 | 6 | 53 | 53 | 106 | |||||||||||||||||||||||||||||||||
937286 | 937286 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001390 | 2090035 | Brayton | Regular School | No | 1 | PK | 07 | 2016 | grade_7 | 26 | 1 | 1 | 0 | 0 | 0 | 3 | 21 | 10 | 31 | 26 | 1 | 1 | 0 | 0 | 0 | 3 | 21 | 10 | 31 | |||||||||||||||||||||||||||||||||
938774 | 938774 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002602 | 2810330 | M Marcus Kiley Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 26 | 54 | 119 | 0 | 9 | 0 | 3 | 104 | 107 | 211 | 26 | 54 | 119 | 0 | 9 | 0 | 3 | 104 | 107 | 211 | |||||||||||||||||||||||||||||||||
941988 | 941988 | MA | Middlesex | school | 2500546 | 3506 | Pioneer Charter School of Science II (PCSS-II) (District) | 250054602780 | 35060505 | Pioneer Charter School of Science II (PCSS-II) | Regular School | Yes | 4 | 07 | 11 | 2016 | grade_7 | 26 | 22 | 19 | 1 | 2 | 0 | 2 | 28 | 44 | 72 | 26 | 22 | 19 | 1 | 2 | 0 | 2 | 28 | 44 | 72 | |||||||||||||||||||||||||||||||||
934092 | 934092 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000420 | 460030 | Lawrence | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 27 | 3 | 3 | 0 | 21 | 0 | 7 | 30 | 31 | 61 | 27 | 3 | 3 | 0 | 21 | 0 | 7 | 30 | 31 | 61 | |||||||||||||||||||||||||||||||||
936430 | 936430 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001351 | 1650027 | Forestdale | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 27 | 10 | 16 | 0 | 7 | 0 | 0 | 35 | 25 | 60 | 27 | 10 | 16 | 0 | 7 | 0 | 0 | 35 | 25 | 60 | |||||||||||||||||||||||||||||||||
937277 | 937277 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001389 | 2090015 | Greylock | Regular School | No | 1 | KG | 07 | 2016 | grade_7 | 27 | 1 | 3 | 0 | 1 | 1 | 1 | 19 | 15 | 34 | 27 | 1 | 3 | 0 | 1 | 1 | 1 | 19 | 15 | 34 | |||||||||||||||||||||||||||||||||
940255 | 940255 | MA | Franklin | school | 2500076 | 413 | Four Rivers Charter Public (District) | 250007602086 | 4130505 | Four Rivers Charter Public School | Regular School | Yes | 3 | 07 | 12 | 2016 | grade_7 | 27 | 0 | 6 | 0 | 2 | 0 | 1 | 18 | 18 | 36 | 27 | 0 | 6 | 0 | 2 | 0 | 1 | 18 | 18 | 36 | |||||||||||||||||||||||||||||||||
940432 | 940432 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public School | Regular School | Yes | 4 | KG | 12 | 2016 | grade_7 | 27 | 49 | 34 | 1 | 7 | 0 | 2 | 54 | 66 | 120 | 27 | 49 | 34 | 1 | 7 | 0 | 2 | 54 | 66 | 120 | |||||||||||||||||||||||||||||||||
940738 | 940738 | MA | Hampshire | school | 2500517 | 497 | Pioneer Valley Chinese Immersion Charter (District) | 250051702619 | 4970205 | Pioneer Valley Chinese Immersion Charter School | Regular School | Yes | 4 | KG | 11 | 2016 | grade_7 | 27 | 5 | 3 | 0 | 9 | 0 | 8 | 18 | 34 | 52 | 27 | 5 | 3 | 0 | 9 | 0 | 8 | 18 | 34 | 52 | |||||||||||||||||||||||||||||||||
933964 | 933964 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000390 | 440023 | Edgar B Davis | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 28 | 70 | 16 | 0 | 0 | 1 | 2 | 58 | 59 | 117 | 28 | 70 | 16 | 0 | 0 | 1 | 2 | 58 | 59 | 117 | |||||||||||||||||||||||||||||||||
937951 | 937951 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001581 | 2430320 | Reay E Sterling Middle | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 28 | 12 | 12 | 1 | 22 | 0 | 2 | 45 | 32 | 77 | 28 | 12 | 12 | 1 | 22 | 0 | 2 | 45 | 32 | 77 | |||||||||||||||||||||||||||||||||
934101 | 934101 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000423 | 460035 | William H Lincoln | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 29 | 4 | 8 | 0 | 10 | 0 | 7 | 33 | 25 | 58 | 29 | 4 | 8 | 0 | 10 | 0 | 7 | 33 | 25 | 58 | |||||||||||||||||||||||||||||||||
936107 | 936107 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001038 | 1600018 | Pyne Arts | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 29 | 7 | 7 | 0 | 7 | 0 | 2 | 21 | 31 | 52 | 29 | 7 | 7 | 0 | 7 | 0 | 2 | 21 | 31 | 52 | |||||||||||||||||||||||||||||||||
936412 | 936412 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001344 | 1650003 | Beebe | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 29 | 12 | 13 | 0 | 26 | 1 | 3 | 44 | 40 | 84 | 29 | 12 | 13 | 0 | 26 | 1 | 3 | 44 | 40 | 84 | |||||||||||||||||||||||||||||||||
936421 | 936421 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001345 | 1650013 | Ferryway | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 29 | 24 | 20 | 1 | 22 | 0 | 5 | 68 | 33 | 101 | 29 | 24 | 20 | 1 | 22 | 0 | 5 | 68 | 33 | 101 | |||||||||||||||||||||||||||||||||
937992 | 937992 | MA | Norfolk | school | 2509930 | 244 | Randolph | 250993001392 | 2440410 | Randolph Community Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 29 | 113 | 37 | 0 | 41 | 1 | 8 | 123 | 106 | 229 | 29 | 113 | 37 | 0 | 41 | 1 | 8 | 123 | 106 | 229 | |||||||||||||||||||||||||||||||||
940475 | 940475 | MA | Hampshire | school | 2500031 | 450 | Hilltown Cooperative Charter Public (District) | 250003100549 | 4500105 | Hilltown Cooperative Charter Public School | Regular School | Yes | 1 | KG | 08 | 2016 | grade_7 | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | |||||||||||||||||||||||||||||||||
933752 | 933752 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000205 | 350575 | O'Bryant School Math/Science | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 30 | 39 | 48 | 2 | 24 | 0 | 3 | 71 | 75 | 146 | 30 | 39 | 48 | 2 | 24 | 0 | 3 | 71 | 75 | 146 | |||||||||||||||||||||||||||||||||
934256 | 934256 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327002746 | 490315 | Rindge Avenue Upper School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 30 | 28 | 14 | 0 | 10 | 0 | 5 | 47 | 40 | 87 | 30 | 28 | 14 | 0 | 10 | 0 | 5 | 47 | 40 | 87 | |||||||||||||||||||||||||||||||||
934848 | 934848 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477001520 | 930038 | Lafayette School | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 30 | 18 | 30 | 0 | 8 | 0 | 3 | 40 | 49 | 89 | 30 | 18 | 30 | 0 | 8 | 0 | 3 | 40 | 49 | 89 | |||||||||||||||||||||||||||||||||
934927 | 934927 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000666 | 950045 | John J Doran | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 30 | 2 | 19 | 0 | 3 | 0 | 4 | 31 | 27 | 58 | 30 | 2 | 19 | 0 | 3 | 0 | 4 | 31 | 27 | 58 | |||||||||||||||||||||||||||||||||
940458 | 940458 | MA | Norfolk | school | 2500030 | 447 | Benjamin Franklin Classical Charter Public (District) | 250003000547 | 4470205 | Benjamin Franklin Classical Charter Public School | Regular School | Yes | 1 | KG | 08 | 2016 | grade_7 | 30 | 0 | 1 | 0 | 14 | 0 | 3 | 32 | 16 | 48 | 30 | 0 | 1 | 0 | 14 | 0 | 3 | 32 | 16 | 48 | |||||||||||||||||||||||||||||||||
940686 | 940686 | MA | Plymouth | school | 2500040 | 488 | South Shore Charter Public (District) | 250004000600 | 4880550 | South Shore Charter Public School | Regular School | Yes | 4 | KG | 12 | 2016 | grade_7 | 30 | 9 | 2 | 0 | 3 | 0 | 1 | 20 | 25 | 45 | 30 | 9 | 2 | 0 | 3 | 0 | 1 | 20 | 25 | 45 | |||||||||||||||||||||||||||||||||
940748 | 940748 | MA | Hampden | school | 2500522 | 499 | Hampden Charter School of Science (District) | 250052202680 | 4990305 | Hampden Charter School of Science | Regular School | Yes | 4 | 06 | 12 | 2016 | grade_7 | 30 | 20 | 26 | 0 | 3 | 0 | 4 | 46 | 37 | 83 | 30 | 20 | 26 | 0 | 3 | 0 | 4 | 46 | 37 | 83 | |||||||||||||||||||||||||||||||||
934259 | 934259 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327002756 | 490320 | Vassal Lane Upper School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 31 | 22 | 6 | 2 | 10 | 0 | 8 | 47 | 32 | 79 | 31 | 22 | 6 | 2 | 10 | 0 | 8 | 47 | 32 | 79 | |||||||||||||||||||||||||||||||||
934824 | 934824 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002033 | 930018 | Madeline English School | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 31 | 12 | 25 | 0 | 4 | 0 | 3 | 35 | 40 | 75 | 31 | 12 | 25 | 0 | 4 | 0 | 3 | 35 | 40 | 75 | |||||||||||||||||||||||||||||||||
940725 | 940725 | MA | Bristol | school | 2500519 | 496 | Global Learning Charter Public (District) | 250051902629 | 4960305 | Global Learning Charter Public School | Regular School | Yes | 4 | 05 | 12 | 2016 | grade_7 | 31 | 10 | 33 | 0 | 2 | 0 | 5 | 40 | 41 | 81 | 31 | 10 | 33 | 0 | 2 | 0 | 5 | 40 | 41 | 81 | |||||||||||||||||||||||||||||||||
936193 | 936193 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001034 | 1600330 | Henry J Robinson Middle | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 32 | 12 | 71 | 0 | 35 | 0 | 6 | 84 | 72 | 156 | 32 | 12 | 71 | 0 | 35 | 0 | 6 | 84 | 72 | 156 | |||||||||||||||||||||||||||||||||
934120 | 934120 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000419 | 460045 | John D Runkle | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 33 | 2 | 7 | 0 | 14 | 0 | 6 | 29 | 33 | 62 | 33 | 2 | 7 | 0 | 14 | 0 | 6 | 29 | 33 | 62 | |||||||||||||||||||||||||||||||||
932818 | 932818 | MA | Norfolk | school | 2502250 | 18 | Avon | 250225001295 | 180510 | Avon Middle High School | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 34 | 21 | 4 | 1 | 4 | 0 | 2 | 36 | 30 | 66 | 34 | 21 | 4 | 1 | 4 | 0 | 2 | 36 | 30 | 66 | |||||||||||||||||||||||||||||||||
934250 | 934250 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327002759 | 490305 | Cambridge Street Upper School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 34 | 27 | 11 | 1 | 9 | 1 | 2 | 44 | 41 | 85 | 34 | 27 | 11 | 1 | 9 | 1 | 2 | 44 | 41 | 85 | |||||||||||||||||||||||||||||||||
934791 | 934791 | MA | Dukes | school | 2509090 | 89 | Edgartown | 250909001469 | 890005 | Edgartown Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 34 | 1 | 3 | 2 | 0 | 0 | 0 | 17 | 23 | 40 | 34 | 1 | 3 | 2 | 0 | 0 | 0 | 17 | 23 | 40 | |||||||||||||||||||||||||||||||||
937269 | 937269 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001388 | 2090008 | Colegrove Park Elementary | Regular School | No | 1 | KG | 07 | 2016 | grade_7 | 34 | 0 | 0 | 0 | 0 | 0 | 5 | 19 | 20 | 39 | 34 | 0 | 0 | 0 | 0 | 0 | 5 | 19 | 20 | 39 | |||||||||||||||||||||||||||||||||
940651 | 940651 | MA | Essex | school | 2500084 | 485 | Salem Academy Charter (District) | 250008401847 | 4850485 | Salem Academy Charter School | Regular School | Yes | 4 | 06 | 12 | 2016 | grade_7 | 34 | 6 | 27 | 0 | 5 | 0 | 0 | 31 | 41 | 72 | 34 | 6 | 27 | 0 | 5 | 0 | 0 | 31 | 41 | 72 | |||||||||||||||||||||||||||||||||
935035 | 935035 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489002672 | 970315 | Arthur M Longsjo Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 35 | 8 | 58 | 0 | 3 | 0 | 9 | 58 | 55 | 113 | 35 | 8 | 58 | 0 | 3 | 0 | 9 | 58 | 55 | 113 | |||||||||||||||||||||||||||||||||
935412 | 935412 | MA | Hampshire | school | 2505940 | 127 | Hatfield | 250594000845 | 1270505 | Smith Academy | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 35 | 0 | 1 | 0 | 0 | 0 | 0 | 26 | 10 | 36 | 35 | 0 | 1 | 0 | 0 | 0 | 0 | 26 | 10 | 36 | |||||||||||||||||||||||||||||||||
937565 | 937565 | MA | Dukes | school | 2504650 | 221 | Oak Bluffs | 250465000625 | 2210005 | Oak Bluffs Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 35 | 2 | 7 | 1 | 1 | 0 | 3 | 25 | 24 | 49 | 35 | 2 | 7 | 1 | 1 | 0 | 3 | 25 | 24 | 49 | |||||||||||||||||||||||||||||||||
938763 | 938763 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002599 | 2810320 | John J Duggan Middle | Regular School | No | 4 | 06 | 10 | 2016 | grade_7 | 35 | 42 | 77 | 0 | 7 | 0 | 1 | 85 | 77 | 162 | 35 | 42 | 77 | 0 | 7 | 0 | 1 | 85 | 77 | 162 | |||||||||||||||||||||||||||||||||
936357 | 936357 | MA | Essex | school | 2507110 | 163 | Lynn | 250711000301 | 1630305 | Thurgood Marshall Mid | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 36 | 34 | 233 | 0 | 29 | 0 | 10 | 194 | 148 | 342 | 36 | 34 | 233 | 0 | 29 | 0 | 10 | 194 | 148 | 342 | |||||||||||||||||||||||||||||||||
934110 | 934110 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000422 | 460040 | Pierce | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 37 | 10 | 12 | 0 | 13 | 0 | 9 | 41 | 40 | 81 | 37 | 10 | 12 | 0 | 13 | 0 | 9 | 41 | 40 | 81 | |||||||||||||||||||||||||||||||||
936439 | 936439 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001361 | 1650047 | Linden | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 37 | 17 | 17 | 0 | 21 | 0 | 3 | 46 | 49 | 95 | 37 | 17 | 17 | 0 | 21 | 0 | 3 | 46 | 49 | 95 | |||||||||||||||||||||||||||||||||
934083 | 934083 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000418 | 460025 | Heath | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 38 | 2 | 4 | 0 | 9 | 0 | 1 | 22 | 32 | 54 | 38 | 2 | 4 | 0 | 9 | 0 | 1 | 22 | 32 | 54 | |||||||||||||||||||||||||||||||||
934073 | 934073 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000421 | 460020 | Michael Driscoll | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 39 | 2 | 5 | 0 | 6 | 0 | 5 | 27 | 30 | 57 | 39 | 2 | 5 | 0 | 6 | 0 | 5 | 27 | 30 | 57 | |||||||||||||||||||||||||||||||||
938437 | 938437 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001738 | 2740083 | John F Kennedy | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 39 | 6 | 10 | 0 | 0 | 0 | 1 | 31 | 25 | 56 | 39 | 6 | 10 | 0 | 0 | 0 | 1 | 31 | 25 | 56 | |||||||||||||||||||||||||||||||||
934054 | 934054 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000416 | 460005 | Edith C Baker | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 40 | 3 | 10 | 0 | 25 | 1 | 6 | 48 | 37 | 85 | 40 | 3 | 10 | 0 | 25 | 1 | 6 | 48 | 37 | 85 | |||||||||||||||||||||||||||||||||
940462 | 940462 | MA | Suffolk | school | 2500053 | 449 | Boston Collegiate Charter (District) | 250005301256 | 4490305 | Boston Collegiate Charter School | Regular School | Yes | 4 | 05 | 12 | 2016 | grade_7 | 40 | 31 | 18 | 1 | 2 | 0 | 2 | 49 | 45 | 94 | 40 | 31 | 18 | 1 | 2 | 0 | 2 | 49 | 45 | 94 | |||||||||||||||||||||||||||||||||
934918 | 934918 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Henry Lord Community School | Regular School | No | 1 | PK | 07 | 2016 | grade_7 | 41 | 6 | 12 | 0 | 4 | 0 | 5 | 31 | 37 | 68 | 41 | 6 | 12 | 0 | 4 | 0 | 5 | 31 | 37 | 68 | |||||||||||||||||||||||||||||||||
934833 | 934833 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477002038 | 930028 | George Keverian School | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 43 | 13 | 35 | 0 | 12 | 0 | 3 | 58 | 48 | 106 | 43 | 13 | 35 | 0 | 12 | 0 | 3 | 58 | 48 | 106 | |||||||||||||||||||||||||||||||||
942016 | 942016 | 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_7 | 43 | 11 | 4 | 1 | 2 | 0 | 2 | 26 | 37 | 63 | 43 | 11 | 4 | 1 | 2 | 0 | 2 | 26 | 37 | 63 | |||||||||||||||||||||||||||||||||
935350 | 935350 | MA | Hampshire | school | 2505580 | 117 | Hadley | 250558000813 | 1170505 | Hopkins Academy | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 44 | 0 | 2 | 0 | 0 | 0 | 2 | 29 | 19 | 48 | 44 | 0 | 2 | 0 | 0 | 0 | 2 | 29 | 19 | 48 | |||||||||||||||||||||||||||||||||
937955 | 937955 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001381 | 2430325 | Point Webster Middle | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 44 | 8 | 2 | 0 | 26 | 0 | 3 | 44 | 39 | 83 | 44 | 8 | 2 | 0 | 26 | 0 | 3 | 44 | 39 | 83 | |||||||||||||||||||||||||||||||||
941627 | 941627 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001774 | 7650505 | Mt Everett Regional | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 44 | 2 | 3 | 0 | 0 | 0 | 5 | 28 | 26 | 54 | 44 | 2 | 3 | 0 | 0 | 0 | 5 | 28 | 26 | 54 | |||||||||||||||||||||||||||||||||
936026 | 936026 | MA | Middlesex | school | 2506900 | 157 | Lincoln | 250690001183 | 1570025 | Lincoln School | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 45 | 7 | 7 | 0 | 8 | 0 | 5 | 28 | 44 | 72 | 45 | 7 | 7 | 0 | 8 | 0 | 5 | 28 | 44 | 72 | |||||||||||||||||||||||||||||||||
940541 | 940541 | MA | Essex | school | 2500034 | 464 | Marblehead Community Charter Public (District) | 250003400567 | 4640305 | Marblehead Community Charter Public School | Regular School | Yes | 2 | 04 | 08 | 2016 | grade_7 | 45 | 0 | 2 | 0 | 1 | 0 | 0 | 21 | 27 | 48 | 45 | 0 | 2 | 0 | 1 | 0 | 0 | 21 | 27 | 48 | |||||||||||||||||||||||||||||||||
940611 | 940611 | MA | Hampshire | school | 2500044 | 479 | Pioneer Valley Performing Arts Charter Public (District) | 250004400816 | 4790505 | Pioneer Valley Performing Arts Charter Public School | Regular School | Yes | 3 | 07 | 12 | 2016 | grade_7 | 45 | 6 | 10 | 0 | 1 | 0 | 5 | 21 | 46 | 67 | 45 | 6 | 10 | 0 | 1 | 0 | 5 | 21 | 46 | 67 | |||||||||||||||||||||||||||||||||
940400 | 940400 | MA | Hampden | school | 2500028 | 441 | Sabis International Charter (District) | 250002800537 | 4410505 | Sabis International Charter School | Regular School | Yes | 4 | KG | 12 | 2016 | grade_7 | 47 | 28 | 41 | 0 | 5 | 0 | 7 | 60 | 68 | 128 | 47 | 28 | 41 | 0 | 5 | 0 | 7 | 60 | 68 | 128 | |||||||||||||||||||||||||||||||||
940445 | 940445 | MA | Norfolk | school | 2500052 | 446 | Foxborough Regional Charter (District) | 250005201250 | 4460550 | Foxborough Regional Charter School | Regular School | Yes | 4 | KG | 12 | 2016 | grade_7 | 47 | 40 | 4 | 0 | 14 | 1 | 6 | 60 | 52 | 112 | 47 | 40 | 4 | 0 | 14 | 1 | 6 | 60 | 52 | 112 | |||||||||||||||||||||||||||||||||
934013 | 934013 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000407 | 440415 | South Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 48 | 101 | 22 | 1 | 10 | 0 | 9 | 108 | 83 | 191 | 48 | 101 | 22 | 1 | 10 | 0 | 9 | 108 | 83 | 191 |
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]);