enrollments
Data source: Big Local News · About: Big Local
967 rows where grade = "grade_3", state = "MA" and year = 2019 sorted by white
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2042268 | 2042268 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002852 | 950340 | Stone PK-12 School | Regular School | No | Other | 01 | 12 | 2019 | grade_3 | * | * | * | * | * | * | * | 3 | 1 | 4.0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||
2042672 | 2042672 | MA | Berkshire | school | 2505760 | 121 | Hancock | 250576000826 | 1210005 | Hancock Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_3 | * | * | * | * | * | * | * | 4 | 1 | 5.0 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||||||||
2042767 | 2042767 | MA | Essex | school | 2505970 | 128 | Haverhill | 250597001706 | 1280073 | TEACH | Regular School | No | Other | 01 | 12 | 2019 | grade_3 | * | * | * | * | * | * | * | 2 | * | 2.0 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||
2043451 | 2043451 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002726 | 1600085 | Laura Lee Therapeutic Day School | Regular School | No | Middle | 02 | 08 | 2019 | grade_3 | * | * | * | * | * | * | * | 1 | * | 1.0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
2045458 | 2045458 | MA | Franklin | school | 2510230 | 253 | Rowe | 251023001649 | 2530005 | Rowe Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_3 | * | * | * | * | * | * | * | 2 | 3 | 5.0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||||||||
2048846 | 2048846 | MA | Franklin | school | 2509600 | 750 | Pioneer Valley | 250960002615 | 7500009 | Warwick Community School | Regular School | No | Elementary | PK | 06 | 2019 | grade_3 | * | * | * | * | * | * | * | 2 | 3 | 5.0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||||||||
2040333 | 2040333 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001115 | 350008 | Dr. Catherine Ellison-Rosa Parks Early Ed School | Regular School | No | Elementary | PK | 03 | 2019 | grade_3 | 0 | 19 | 13 | 0 | 0 | 0 | 0 | 17 | 15 | 32.0 | 0 | 19 | 13 | 0 | 0 | 0 | 0 | 17 | 15 | 32 | |||||||||||||||||||||||||||||||||
2040530 | 2040530 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000259 | 350153 | James W Hennigan | Regular School | No | Elementary | KG | 08 | 2019 | grade_3 | 0 | 25 | 39 | 0 | 1 | 0 | 0 | 30 | 35 | 65.0 | 0 | 25 | 39 | 0 | 1 | 0 | 0 | 30 | 35 | 65 | |||||||||||||||||||||||||||||||||
2040650 | 2040650 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Maurice J Tobin | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 0 | 14 | 36 | 1 | 0 | 0 | 0 | 26 | 25 | 51.0 | 0 | 14 | 36 | 1 | 0 | 0 | 0 | 26 | 25 | 51 | |||||||||||||||||||||||||||||||||
2040684 | 2040684 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000295 | 350243 | Nathan Hale | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 0 | 19 | 4 | 0 | 2 | 0 | 0 | 13 | 12 | 25.0 | 0 | 19 | 4 | 0 | 2 | 0 | 0 | 13 | 12 | 25 | |||||||||||||||||||||||||||||||||
2040779 | 2040779 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 0 | 13 | 33 | 0 | 0 | 0 | 2 | 22 | 26 | 48.0 | 0 | 13 | 33 | 0 | 0 | 0 | 2 | 22 | 26 | 48 | |||||||||||||||||||||||||||||||||
2040820 | 2040820 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000342 | 350363 | William McKinley | Regular School | No | Other | 01 | 12 | 2019 | grade_3 | 0 | 3 | 6 | 1 | 0 | 0 | 0 | 9 | 1 | 10.0 | 0 | 3 | 6 | 1 | 0 | 0 | 0 | 9 | 1 | 10 | |||||||||||||||||||||||||||||||||
2040835 | 2040835 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000337 | 350366 | William E Russell | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 0 | 20 | 29 | 1 | 6 | 1 | 0 | 23 | 34 | 57.0 | 0 | 20 | 29 | 1 | 6 | 1 | 0 | 23 | 34 | 57 | |||||||||||||||||||||||||||||||||
2040876 | 2040876 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | Middle | 02 | 08 | 2019 | grade_3 | 0 | 14 | 23 | 0 | 0 | 0 | 0 | 23 | 14 | 37.0 | 0 | 14 | 23 | 0 | 0 | 0 | 0 | 23 | 14 | 37 | |||||||||||||||||||||||||||||||||
2040886 | 2040886 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002670 | 350378 | Mildred Avenue K-8 | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 0 | 36 | 9 | 0 | 1 | 0 | 1 | 20 | 27 | 47.0 | 0 | 36 | 9 | 0 | 1 | 0 | 1 | 20 | 27 | 47 | |||||||||||||||||||||||||||||||||
2041098 | 2041098 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002374 | 350750 | Horace Mann School for the Deaf | Special Education School | No | Other | PK | 12 | 2019 | grade_3 | 0 | 2 | 4 | 0 | 0 | 0 | 0 | 3 | 3 | 6.0 | 0 | 2 | 4 | 0 | 0 | 0 | 0 | 3 | 3 | 6 | |||||||||||||||||||||||||||||||||
2042891 | 2042891 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000910 | 1370025 | Morgan Full Service Community School | Regular School | No | Elementary | PK | 04 | 2019 | grade_3 | 0 | 4 | 46 | 0 | 1 | 0 | 0 | 29 | 22 | 51.0 | 0 | 4 | 46 | 0 | 1 | 0 | 0 | 29 | 22 | 51 | |||||||||||||||||||||||||||||||||
2047513 | 2047513 | MA | Suffolk | school | 2500543 | 407 | Dudley Street Neighborhood Charter School (District) | 250054302763 | 4070405 | Dudley Street Neighborhood Charter School | Regular School | Yes | Elementary | PK | 05 | 2019 | grade_3 | 0 | 20 | 19 | 0 | 0 | 0 | 0 | 16 | 23 | 39.0 | 0 | 20 | 19 | 0 | 0 | 0 | 0 | 16 | 23 | 39 | |||||||||||||||||||||||||||||||||
2047573 | 2047573 | MA | Suffolk | school | 2500527 | 417 | Bridge Boston Charter School (District) | 250052702710 | 4170205 | Bridge Boston Charter School | Regular School | Yes | Elementary | PK | 07 | 2019 | grade_3 | 0 | 26 | 13 | 0 | 1 | 0 | 0 | 20 | 20 | 40.0 | 0 | 26 | 13 | 0 | 1 | 0 | 0 | 20 | 20 | 40 | |||||||||||||||||||||||||||||||||
2047644 | 2047644 | MA | Essex | school | 2500535 | 431 | Community Day Charter Public School - R. Kingman Webster (District) | 250053502719 | 4310205 | Community Day Charter Public School - R. Kingman Webster | Regular School | Yes | Elementary | PK | 07 | 2019 | grade_3 | 0 | 0 | 42 | 0 | 1 | 0 | 0 | 26 | 17 | 43.0 | 0 | 0 | 42 | 0 | 1 | 0 | 0 | 26 | 17 | 43 | |||||||||||||||||||||||||||||||||
2047675 | 2047675 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2019 | grade_3 | 0 | 15 | 5 | 0 | 0 | 0 | 0 | 10 | 10 | 20.0 | 0 | 15 | 5 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
2047699 | 2047699 | MA | Essex | school | 2500027 | 440 | Community Day Charter Public School - Prospect (District) | 250002700535 | 4400205 | Community Day Charter Public School - Prospect | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_3 | 0 | 1 | 49 | 0 | 0 | 0 | 0 | 22 | 28 | 50.0 | 0 | 1 | 49 | 0 | 0 | 0 | 0 | 22 | 28 | 50 | |||||||||||||||||||||||||||||||||
2047831 | 2047831 | MA | Suffolk | school | 2500537 | 463 | KIPP Academy Boston Charter School (District) | 250053702716 | 4630205 | KIPP Academy Boston Charter School | Regular School | Yes | Elementary | KG | 08 | 2019 | grade_3 | 0 | 50 | 23 | 0 | 0 | 0 | 0 | 41 | 32 | 73.0 | 0 | 50 | 23 | 0 | 0 | 0 | 0 | 41 | 32 | 73 | |||||||||||||||||||||||||||||||||
2049289 | 2049289 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_3 | 0 | 44 | 27 | 0 | 1 | 0 | 2 | 39 | 35 | 74.0 | 0 | 44 | 27 | 0 | 1 | 0 | 2 | 39 | 35 | 74 | |||||||||||||||||||||||||||||||||
2040313 | 2040313 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001768 | 350001 | Lee Academy | Regular School | No | Elementary | PK | 03 | 2019 | grade_3 | 1 | 30 | 16 | 0 | 3 | 0 | 0 | 26 | 24 | 50.0 | 1 | 30 | 16 | 0 | 3 | 0 | 0 | 26 | 24 | 50 | |||||||||||||||||||||||||||||||||
2040404 | 2040404 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000213 | 350054 | Charles H Taylor | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 67 | 12 | 1 | 0 | 0 | 2 | 38 | 45 | 83.0 | 1 | 67 | 12 | 1 | 0 | 0 | 2 | 38 | 45 | 83 | |||||||||||||||||||||||||||||||||
2040425 | 2040425 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000220 | 350072 | David A Ellis | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 18 | 38 | 2 | 1 | 0 | 0 | 24 | 36 | 60.0 | 1 | 18 | 38 | 2 | 1 | 0 | 0 | 24 | 36 | 60 | |||||||||||||||||||||||||||||||||
2040507 | 2040507 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002569 | 350138 | O W Holmes | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 31 | 12 | 0 | 1 | 0 | 8 | 35 | 18 | 53.0 | 1 | 31 | 12 | 0 | 1 | 0 | 8 | 35 | 18 | 53 | |||||||||||||||||||||||||||||||||
2040514 | 2040514 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000249 | 350141 | Hugh Roe O'Donnell | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 1 | 39 | 0 | 0 | 0 | 0 | 20 | 21 | 41.0 | 1 | 1 | 39 | 0 | 0 | 0 | 0 | 20 | 21 | 41 | |||||||||||||||||||||||||||||||||
2040578 | 2040578 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000270 | 350180 | John Winthrop | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 21 | 13 | 0 | 2 | 0 | 2 | 12 | 27 | 39.0 | 1 | 21 | 13 | 0 | 2 | 0 | 2 | 12 | 27 | 39 | |||||||||||||||||||||||||||||||||
2040629 | 2040629 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000244 | 350200 | Harvard-Kent | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 18 | 22 | 0 | 14 | 0 | 3 | 40 | 18 | 58.0 | 1 | 18 | 22 | 0 | 14 | 0 | 3 | 40 | 18 | 58 | |||||||||||||||||||||||||||||||||
2040701 | 2040701 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002006 | 350257 | Orchard Gardens | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 1 | 56 | 32 | 1 | 2 | 0 | 4 | 49 | 47 | 96.0 | 1 | 56 | 32 | 1 | 2 | 0 | 4 | 49 | 47 | 96 | |||||||||||||||||||||||||||||||||
2040772 | 2040772 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000322 | 350304 | Samuel W Mason | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 20 | 13 | 1 | 0 | 0 | 2 | 22 | 15 | 37.0 | 1 | 20 | 13 | 1 | 0 | 0 | 2 | 22 | 15 | 37 | |||||||||||||||||||||||||||||||||
2040842 | 2040842 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 1 | 31 | 30 | 0 | 0 | 0 | 1 | 33 | 30 | 63.0 | 1 | 31 | 30 | 0 | 0 | 0 | 1 | 33 | 30 | 63 | |||||||||||||||||||||||||||||||||
2040869 | 2040869 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002669 | 350376 | King K-8 | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 1 | 18 | 15 | 1 | 0 | 1 | 3 | 22 | 17 | 39.0 | 1 | 18 | 15 | 1 | 0 | 1 | 3 | 22 | 17 | 39 | |||||||||||||||||||||||||||||||||
2041062 | 2041062 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002721 | 350656 | Mario Umana Academy | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 1 | 2 | 59 | 0 | 1 | 0 | 0 | 35 | 28 | 63.0 | 1 | 2 | 59 | 0 | 1 | 0 | 0 | 35 | 28 | 63 | |||||||||||||||||||||||||||||||||
2043061 | 2043061 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000950 | 1490015 | Alexander B Bruce | Regular School | No | Middle | 03 | 08 | 2019 | grade_3 | 1 | 1 | 86 | 0 | 1 | 0 | 1 | 40 | 50 | 90.0 | 1 | 1 | 86 | 0 | 1 | 0 | 1 | 40 | 50 | 90 | |||||||||||||||||||||||||||||||||
2043118 | 2043118 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000955 | 1490080 | Emily G Wetherbee | Regular School | No | Elementary | KG | 08 | 2019 | grade_3 | 1 | 0 | 71 | 0 | 0 | 0 | 2 | 34 | 40 | 74.0 | 1 | 0 | 71 | 0 | 0 | 0 | 2 | 34 | 40 | 74 | |||||||||||||||||||||||||||||||||
2045876 | 2045876 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113000896 | 2810023 | Milton Bradley School | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 15 | 67 | 0 | 0 | 0 | 2 | 40 | 45 | 85.0 | 1 | 15 | 67 | 0 | 0 | 0 | 2 | 40 | 45 | 85 | |||||||||||||||||||||||||||||||||
2045902 | 2045902 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001838 | 2810045 | William N. DeBerry | Regular School | No | Elementary | KG | 05 | 2019 | grade_3 | 1 | 7 | 26 | 0 | 1 | 0 | 0 | 16 | 19 | 35.0 | 1 | 7 | 26 | 0 | 1 | 0 | 0 | 16 | 19 | 35 | |||||||||||||||||||||||||||||||||
2045973 | 2045973 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001813 | 2810110 | Kensington International School | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 1 | 9 | 39 | 0 | 1 | 0 | 1 | 24 | 27 | 51.0 | 1 | 9 | 39 | 0 | 1 | 0 | 1 | 24 | 27 | 51 | |||||||||||||||||||||||||||||||||
2047799 | 2047799 | MA | Essex | school | 2500032 | 454 | Lawrence Family Development Charter (District) | 250003200553 | 4540205 | Lawrence Family Development Charter School | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_3 | 1 | 0 | 81 | 0 | 0 | 0 | 0 | 35 | 47 | 82.0 | 1 | 0 | 81 | 0 | 0 | 0 | 0 | 35 | 47 | 82 | |||||||||||||||||||||||||||||||||
2047909 | 2047909 | MA | Suffolk | school | 2500039 | 481 | Boston Renaissance Charter Public (District) | 250003900599 | 4810550 | Boston Renaissance Charter Public School | Regular School | Yes | Elementary | PK | 06 | 2019 | grade_3 | 1 | 80 | 50 | 0 | 0 | 0 | 5 | 69 | 67 | 136.0 | 1 | 80 | 50 | 0 | 0 | 0 | 5 | 69 | 67 | 136 | |||||||||||||||||||||||||||||||||
2049317 | 2049317 | MA | Hampden | school | 2500557 | 3510 | Springfield Preparatory Charter School (District) | 250055702842 | 35100205 | Springfield Preparatory Charter School | Regular School | Yes | Elementary | KG | 04 | 2019 | grade_3 | 1 | 12 | 35 | 0 | 2 | 0 | 0 | 28 | 22 | 50.0 | 1 | 12 | 35 | 0 | 2 | 0 | 0 | 28 | 22 | 50 | |||||||||||||||||||||||||||||||||
2040320 | 2040320 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002458 | 350004 | Lyon K-8 | Regular School | No | Elementary | KG | 08 | 2019 | grade_3 | 10 | 2 | 0 | 0 | 0 | 0 | 3 | 9 | 6 | 15.0 | 10 | 2 | 0 | 0 | 0 | 0 | 3 | 9 | 6 | 15 | |||||||||||||||||||||||||||||||||
2040483 | 2040483 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000239 | 350116 | Franklin D Roosevelt | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 10 | 11 | 19 | 0 | 2 | 1 | 2 | 27 | 18 | 45.0 | 10 | 11 | 19 | 0 | 2 | 1 | 2 | 27 | 18 | 45 | |||||||||||||||||||||||||||||||||
2040493 | 2040493 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000241 | 350122 | George H Conley | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 10 | 16 | 21 | 0 | 2 | 0 | 3 | 26 | 26 | 52.0 | 10 | 16 | 21 | 0 | 2 | 0 | 3 | 26 | 26 | 52 | |||||||||||||||||||||||||||||||||
2040667 | 2040667 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000294 | 350237 | Mozart | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 10 | 8 | 6 | 0 | 2 | 0 | 1 | 19 | 8 | 27.0 | 10 | 8 | 6 | 0 | 2 | 0 | 1 | 19 | 8 | 27 | |||||||||||||||||||||||||||||||||
2041485 | 2041485 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327000443 | 490030 | Martin Luther King Jr. | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 10 | 10 | 8 | 0 | 5 | 0 | 11 | 20 | 24 | 44.0 | 10 | 10 | 8 | 0 | 5 | 0 | 11 | 20 | 24 | 44 | |||||||||||||||||||||||||||||||||
2043448 | 2043448 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000092 | 1600080 | Charlotte M Murkland Elementary | Regular School | No | Elementary | PK | 04 | 2019 | grade_3 | 10 | 7 | 28 | 0 | 40 | 0 | 4 | 54 | 35 | 89.0 | 10 | 7 | 28 | 0 | 40 | 0 | 4 | 54 | 35 | 89 | |||||||||||||||||||||||||||||||||
2043608 | 2043608 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001075 | 1630060 | Ingalls | Regular School | No | Elementary | KG | 05 | 2019 | grade_3 | 10 | 9 | 58 | 1 | 12 | 0 | 5 | 45 | 50 | 95.0 | 10 | 9 | 58 | 1 | 12 | 0 | 5 | 45 | 50 | 95 | |||||||||||||||||||||||||||||||||
2045775 | 2045775 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001749 | 2740120 | Winter Hill Community | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 10 | 5 | 19 | 0 | 1 | 0 | 3 | 22 | 15 | 38.0 | 10 | 5 | 19 | 0 | 1 | 0 | 3 | 22 | 15 | 38 | |||||||||||||||||||||||||||||||||
2045956 | 2045956 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001809 | 2810095 | Alfred G. Zanetti Montessori Magnet School | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 10 | 12 | 20 | 0 | 0 | 0 | 1 | 22 | 21 | 43.0 | 10 | 12 | 20 | 0 | 0 | 0 | 1 | 22 | 21 | 43 | |||||||||||||||||||||||||||||||||
2047201 | 2047201 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002197 | 3480020 | Belmont Street Community | Regular School | No | Elementary | PK | 06 | 2019 | grade_3 | 10 | 20 | 41 | 0 | 4 | 0 | 2 | 40 | 37 | 77.0 | 10 | 20 | 41 | 0 | 4 | 0 | 2 | 40 | 37 | 77 | |||||||||||||||||||||||||||||||||
2047222 | 2047222 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002201 | 3480035 | Burncoat Street | Regular School | No | Elementary | KG | 06 | 2019 | grade_3 | 10 | 7 | 32 | 0 | 0 | 0 | 3 | 27 | 25 | 52.0 | 10 | 7 | 32 | 0 | 0 | 0 | 3 | 27 | 25 | 52 | |||||||||||||||||||||||||||||||||
2047291 | 2047291 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002215 | 3480100 | Goddard School/Science Technical | Regular School | No | Elementary | PK | 06 | 2019 | grade_3 | 10 | 6 | 34 | 2 | 3 | 0 | 2 | 31 | 26 | 57.0 | 10 | 6 | 34 | 2 | 3 | 0 | 2 | 31 | 26 | 57 | |||||||||||||||||||||||||||||||||
2047948 | 2047948 | MA | Worcester | school | 2500045 | 486 | Seven Hills Charter Public (District) | 250004500817 | 4860105 | Seven Hills Charter School | Regular School | Yes | Elementary | KG | 08 | 2019 | grade_3 | 10 | 43 | 26 | 0 | 0 | 0 | 7 | 45 | 41 | 86.0 | 10 | 43 | 26 | 0 | 0 | 0 | 7 | 45 | 41 | 86 | |||||||||||||||||||||||||||||||||
2048391 | 2048391 | MA | Berkshire | school | 2513321 | 662 | Farmington River Reg | 251332100402 | 6620020 | Farmington River Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_3 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 10.0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | |||||||||||||||||||||||||||||||||
2047501 | 2047501 | MA | Norfolk | school | 2513290 | 350 | Wrentham | 251329002255 | 3500003 | Delaney | Regular School | No | Elementary | PK | 03 | 2019 | grade_3 | 100 | 1 | 5 | 0 | 5 | 1 | 6 | 58 | 60 | 118.0 | 100 | 1 | 5 | 0 | 5 | 1 | 6 | 58 | 60 | 118 | |||||||||||||||||||||||||||||||||
2041135 | 2041135 | MA | Essex | school | 2502880 | 38 | Boxford | 250288000358 | 380013 | Spofford Pond | Regular School | No | Elementary | 03 | 06 | 2019 | grade_3 | 101 | 1 | 4 | 1 | 4 | 0 | 5 | 62 | 54 | 116.0 | 101 | 1 | 4 | 1 | 4 | 0 | 5 | 62 | 54 | 116 | |||||||||||||||||||||||||||||||||
2048331 | 2048331 | MA | Bristol | school | 2504200 | 650 | Dighton-Rehoboth | 250420002428 | 6500010 | Palmer River | Regular School | No | Elementary | PK | 04 | 2019 | grade_3 | 101 | 0 | 9 | 0 | 2 | 0 | 1 | 58 | 55 | 113.0 | 101 | 0 | 9 | 0 | 2 | 0 | 1 | 58 | 55 | 113 | |||||||||||||||||||||||||||||||||
2043529 | 2043529 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002871 | 1620025 | Turkey Hill Elementary School | Regular School | No | Elementary | 03 | 05 | 2019 | grade_3 | 102 | 3 | 9 | 0 | 5 | 0 | 2 | 65 | 56 | 121.0 | 102 | 3 | 9 | 0 | 5 | 0 | 2 | 65 | 56 | 121 | |||||||||||||||||||||||||||||||||
2044883 | 2044883 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927001481 | 2260005 | Clara Barton | Regular School | No | Elementary | 02 | 04 | 2019 | grade_3 | 103 | 3 | 16 | 0 | 2 | 0 | 9 | 71 | 62 | 133.0 | 103 | 3 | 16 | 0 | 2 | 0 | 9 | 71 | 62 | 133 | |||||||||||||||||||||||||||||||||
2048220 | 2048220 | MA | Worcester | school | 2502715 | 622 | Blackstone-Millville | 250271501078 | 6220015 | A F Maloney | Regular School | No | Elementary | 03 | 05 | 2019 | grade_3 | 103 | 1 | 9 | 0 | 1 | 0 | 5 | 72 | 47 | 119.0 | 103 | 1 | 9 | 0 | 1 | 0 | 5 | 72 | 47 | 119 | |||||||||||||||||||||||||||||||||
2041765 | 2041765 | MA | Worcester | school | 2503750 | 64 | Clinton | 250375002379 | 640050 | Clinton Elementary | Regular School | No | Elementary | PK | 04 | 2019 | grade_3 | 105 | 5 | 31 | 0 | 2 | 0 | 3 | 69 | 77 | 146.0 | 105 | 5 | 31 | 0 | 2 | 0 | 3 | 69 | 77 | 146 | |||||||||||||||||||||||||||||||||
2041776 | 2041776 | MA | Norfolk | school | 2503780 | 65 | Cohasset | 250378000519 | 650005 | Deer Hill | Regular School | No | Elementary | 03 | 05 | 2019 | grade_3 | 105 | 5 | 0 | 0 | 3 | 0 | 0 | 63 | 50 | 113.0 | 105 | 5 | 0 | 0 | 3 | 0 | 0 | 63 | 50 | 113 | |||||||||||||||||||||||||||||||||
2048355 | 2048355 | MA | Worcester | school | 2504360 | 658 | Dudley-Charlton Reg | 250436000588 | 6580005 | Dudley Elementary | Regular School | No | Elementary | 02 | 04 | 2019 | grade_3 | 105 | 5 | 15 | 0 | 0 | 0 | 5 | 64 | 66 | 130.0 | 105 | 5 | 15 | 0 | 0 | 0 | 5 | 64 | 66 | 130 | |||||||||||||||||||||||||||||||||
2048941 | 2048941 | MA | Hampden | school | 2500013 | 766 | Southwick-Tolland-Granville Regional School District | 250001302845 | 7660315 | Powder Mill School | Regular School | No | Elementary | 03 | 06 | 2019 | grade_3 | 105 | 2 | 2 | 0 | 0 | 0 | 0 | 56 | 53 | 109.0 | 105 | 2 | 2 | 0 | 0 | 0 | 0 | 56 | 53 | 109 | |||||||||||||||||||||||||||||||||
2044061 | 2044061 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777002741 | 1820010 | Mary K. Goode Elementary School | Regular School | No | Elementary | 01 | 05 | 2019 | grade_3 | 107 | 2 | 2 | 0 | 0 | 0 | 4 | 59 | 56 | 115.0 | 107 | 2 | 2 | 0 | 0 | 0 | 4 | 59 | 56 | 115 | |||||||||||||||||||||||||||||||||
2047132 | 2047132 | MA | Suffolk | school | 2513170 | 346 | Winthrop | 251317001841 | 3460020 | Arthur T. Cummings Elementary School | Regular School | No | Elementary | 03 | 05 | 2019 | grade_3 | 107 | 1 | 21 | 0 | 0 | 0 | 3 | 64 | 68 | 132.0 | 107 | 1 | 21 | 0 | 0 | 0 | 3 | 64 | 68 | 132 | |||||||||||||||||||||||||||||||||
2039811 | 2039811 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000006 | 10015 | Woodsdale Elementary School | Regular School | No | Elementary | 03 | 04 | 2019 | grade_3 | 108 | 5 | 8 | 0 | 5 | 1 | 2 | 55 | 74 | 129.0 | 108 | 5 | 8 | 0 | 5 | 1 | 2 | 55 | 74 | 129 | |||||||||||||||||||||||||||||||||
2043320 | 2043320 | MA | Middlesex | school | 2506960 | 158 | Littleton | 250696001013 | 1580015 | Russell St Elementary | Regular School | No | Elementary | 03 | 05 | 2019 | grade_3 | 108 | 2 | 3 | 0 | 10 | 1 | 3 | 57 | 70 | 127.0 | 108 | 2 | 3 | 0 | 10 | 1 | 3 | 57 | 70 | 127 | |||||||||||||||||||||||||||||||||
2046446 | 2046446 | MA | Worcester | school | 2511850 | 304 | Uxbridge | 251185001936 | 3040005 | Taft Early Learning Center | Regular School | No | Elementary | PK | 03 | 2019 | grade_3 | 108 | 3 | 5 | 0 | 3 | 0 | 4 | 62 | 61 | 123.0 | 108 | 3 | 5 | 0 | 3 | 0 | 4 | 62 | 61 | 123 | |||||||||||||||||||||||||||||||||
2040397 | 2040397 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000214 | 350052 | Charles Sumner | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 11 | 16 | 50 | 0 | 0 | 0 | 3 | 38 | 42 | 80.0 | 11 | 16 | 50 | 0 | 0 | 0 | 3 | 38 | 42 | 80 | |||||||||||||||||||||||||||||||||
2040439 | 2040439 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000223 | 350077 | Dennis C Haley | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 11 | 16 | 14 | 0 | 0 | 0 | 5 | 26 | 20 | 46.0 | 11 | 16 | 14 | 0 | 0 | 0 | 5 | 26 | 20 | 46 | |||||||||||||||||||||||||||||||||
2042104 | 2042104 | MA | Middlesex | school | 2504770 | 93 | Everett | 250477000631 | 930010 | Sumner G. Whittier School | Regular School | No | Elementary | KG | 08 | 2019 | grade_3 | 11 | 9 | 51 | 2 | 7 | 0 | 1 | 35 | 46 | 81.0 | 11 | 9 | 51 | 2 | 7 | 0 | 1 | 35 | 46 | 81 | |||||||||||||||||||||||||||||||||
2043412 | 2043412 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001029 | 1600030 | Charles W Morey | Regular School | No | Elementary | PK | 04 | 2019 | grade_3 | 11 | 6 | 8 | 1 | 64 | 0 | 2 | 44 | 48 | 92.0 | 11 | 6 | 8 | 1 | 64 | 0 | 2 | 44 | 48 | 92 | |||||||||||||||||||||||||||||||||
2043552 | 2043552 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001061 | 1630011 | Aborn | Regular School | No | Elementary | KG | 05 | 2019 | grade_3 | 11 | 5 | 12 | 0 | 3 | 0 | 9 | 18 | 22 | 40.0 | 11 | 5 | 12 | 0 | 3 | 0 | 9 | 18 | 22 | 40 | |||||||||||||||||||||||||||||||||
2043630 | 2043630 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001084 | 1630085 | Sewell-Anderson | Regular School | No | Elementary | KG | 05 | 2019 | grade_3 | 11 | 3 | 28 | 0 | 4 | 0 | 2 | 34 | 14 | 48.0 | 11 | 3 | 28 | 0 | 4 | 0 | 2 | 34 | 14 | 48 | |||||||||||||||||||||||||||||||||
2045218 | 2045218 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001567 | 2430075 | Francis W Parker | Regular School | No | Elementary | KG | 05 | 2019 | grade_3 | 11 | 1 | 2 | 0 | 30 | 0 | 4 | 31 | 17 | 48.0 | 11 | 1 | 2 | 0 | 30 | 0 | 4 | 31 | 17 | 48 | |||||||||||||||||||||||||||||||||
2045478 | 2045478 | MA | Essex | school | 2510380 | 258 | Salem | 251038001658 | 2580030 | Horace Mann Laboratory | Regular School | No | Elementary | KG | 05 | 2019 | grade_3 | 11 | 3 | 25 | 0 | 1 | 0 | 1 | 19 | 22 | 41.0 | 11 | 3 | 25 | 0 | 1 | 0 | 1 | 19 | 22 | 41 | |||||||||||||||||||||||||||||||||
2045689 | 2045689 | MA | Franklin | school | 2510800 | 272 | Shutesbury | 251080001720 | 2720005 | Shutesbury Elementary | Regular School | No | Elementary | PK | 06 | 2019 | grade_3 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 6 | 12.0 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | |||||||||||||||||||||||||||||||||
2045943 | 2045943 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001804 | 2810080 | Frederick Harris | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 11 | 14 | 43 | 0 | 3 | 0 | 4 | 35 | 40 | 75.0 | 11 | 14 | 43 | 0 | 3 | 0 | 4 | 35 | 40 | 75 | |||||||||||||||||||||||||||||||||
2045966 | 2045966 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001810 | 2810100 | Indian Orchard Elementary | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 11 | 23 | 80 | 0 | 0 | 0 | 3 | 59 | 58 | 117.0 | 11 | 23 | 80 | 0 | 0 | 0 | 3 | 59 | 58 | 117 | |||||||||||||||||||||||||||||||||
2047237 | 2047237 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002204 | 3480050 | Chandler Elementary Community | Regular School | No | Elementary | KG | 06 | 2019 | grade_3 | 11 | 11 | 53 | 0 | 4 | 0 | 2 | 46 | 35 | 81.0 | 11 | 11 | 53 | 0 | 4 | 0 | 2 | 46 | 35 | 81 | |||||||||||||||||||||||||||||||||
2042515 | 2042515 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000750 | 1030001 | Elm Street School | Regular School | No | Elementary | 02 | 04 | 2019 | grade_3 | 110 | 9 | 44 | 0 | 6 | 0 | 14 | 89 | 94 | 183.0 | 110 | 9 | 44 | 0 | 6 | 0 | 14 | 89 | 94 | 183 | |||||||||||||||||||||||||||||||||
2046603 | 2046603 | MA | Plymouth | school | 2512060 | 310 | Wareham | 251206001989 | 3100017 | Minot Forest | Regular School | No | Elementary | 03 | 04 | 2019 | grade_3 | 110 | 13 | 17 | 5 | 1 | 0 | 20 | 95 | 71 | 166.0 | 110 | 13 | 17 | 5 | 1 | 0 | 20 | 95 | 71 | 166 | |||||||||||||||||||||||||||||||||
2047059 | 2047059 | MA | Middlesex | school | 2513050 | 342 | Wilmington | 251305002153 | 3420025 | Shawsheen Elementary | Regular School | No | Elementary | 01 | 03 | 2019 | grade_3 | 110 | 2 | 6 | 0 | 7 | 0 | 2 | 68 | 59 | 127.0 | 110 | 2 | 6 | 0 | 7 | 0 | 2 | 68 | 59 | 127 | |||||||||||||||||||||||||||||||||
2042684 | 2042684 | MA | Plymouth | school | 2505790 | 122 | Hanover | 250579000832 | 1220015 | Sylvester | Regular School | No | Elementary | 03 | 04 | 2019 | grade_3 | 111 | 0 | 3 | 0 | 5 | 0 | 1 | 52 | 68 | 120.0 | 111 | 0 | 3 | 0 | 5 | 0 | 1 | 52 | 68 | 120 | |||||||||||||||||||||||||||||||||
2045837 | 2045837 | MA | Hampshire | school | 2510920 | 278 | South Hadley | 251092002406 | 2780020 | Mosier | Regular School | No | Elementary | 02 | 04 | 2019 | grade_3 | 111 | 0 | 22 | 0 | 1 | 0 | 2 | 75 | 61 | 136.0 | 111 | 0 | 22 | 0 | 1 | 0 | 2 | 75 | 61 | 136 | |||||||||||||||||||||||||||||||||
2044104 | 2044104 | MA | Worcester | school | 2507890 | 186 | Millbury | 250789001248 | 1860017 | Elmwood Street | Regular School | No | Elementary | PK | 03 | 2019 | grade_3 | 112 | 1 | 9 | 0 | 5 | 0 | 5 | 83 | 49 | 132.0 | 112 | 1 | 9 | 0 | 5 | 0 | 5 | 83 | 49 | 132 | |||||||||||||||||||||||||||||||||
2041595 | 2041595 | MA | Plymouth | school | 2503360 | 52 | Carver | 250336002661 | 520015 | Carver Elementary School | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 113 | 1 | 3 | 0 | 2 | 0 | 2 | 67 | 54 | 121.0 | 113 | 1 | 3 | 0 | 2 | 0 | 2 | 67 | 54 | 121 | |||||||||||||||||||||||||||||||||
2046899 | 2046899 | MA | Bristol | school | 2512780 | 331 | Westport | 251278002092 | 3310030 | Westport Elementary | Regular School | No | Elementary | 03 | 06 | 2019 | grade_3 | 113 | 0 | 3 | 0 | 0 | 0 | 4 | 72 | 48 | 120.0 | 113 | 0 | 3 | 0 | 0 | 0 | 4 | 72 | 48 | 120 | |||||||||||||||||||||||||||||||||
2048403 | 2048403 | MA | Plymouth | school | 2505070 | 665 | Freetown-Lakeville | 250507002739 | 6650002 | Assawompset Elementary School | Regular School | No | Elementary | KG | 03 | 2019 | grade_3 | 114 | 5 | 1 | 0 | 2 | 0 | 7 | 57 | 72 | 129.0 | 114 | 5 | 1 | 0 | 2 | 0 | 7 | 57 | 72 | 129 | |||||||||||||||||||||||||||||||||
2046390 | 2046390 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158001923 | 2950020 | North Street | Regular School | No | Elementary | 03 | 04 | 2019 | grade_3 | 118 | 5 | 9 | 0 | 4 | 0 | 2 | 75 | 63 | 138.0 | 118 | 5 | 9 | 0 | 4 | 0 | 2 | 75 | 63 | 138 | |||||||||||||||||||||||||||||||||
2049076 | 2049076 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188002131 | 7750060 | Glenwood Elementary School | Regular School | No | Elementary | 03 | 05 | 2019 | grade_3 | 118 | 4 | 9 | 1 | 1 | 0 | 2 | 65 | 70 | 135.0 | 118 | 4 | 9 | 1 | 1 | 0 | 2 | 65 | 70 | 135 | |||||||||||||||||||||||||||||||||
2040751 | 2040751 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000277 | 350286 | Josiah Quincy | Regular School | No | Elementary | PK | 05 | 2019 | grade_3 | 12 | 16 | 13 | 1 | 77 | 0 | 6 | 61 | 64 | 125.0 | 12 | 16 | 13 | 1 | 77 | 0 | 6 | 61 | 64 | 125 | |||||||||||||||||||||||||||||||||
2041657 | 2041657 | MA | Suffolk | school | 2503540 | 57 | Chelsea | 250354000859 | 570040 | Frank M Sokolowski Elementary | Regular School | No | Elementary | 01 | 04 | 2019 | grade_3 | 12 | 5 | 117 | 0 | 0 | 0 | 2 | 66 | 70 | 136.0 | 12 | 5 | 117 | 0 | 0 | 0 | 2 | 66 | 70 | 136 | |||||||||||||||||||||||||||||||||
2043390 | 2043390 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001038 | 1600018 | Pyne Arts | Regular School | No | Elementary | PK | 08 | 2019 | grade_3 | 12 | 3 | 20 | 0 | 9 | 0 | 2 | 25 | 21 | 46.0 | 12 | 3 | 20 | 0 | 9 | 0 | 2 | 25 | 21 | 46 | |||||||||||||||||||||||||||||||||
2043400 | 2043400 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001023 | 1600020 | Abraham Lincoln | Regular School | No | Elementary | PK | 04 | 2019 | grade_3 | 12 | 6 | 29 | 1 | 35 | 0 | 4 | 49 | 38 | 87.0 | 12 | 6 | 29 | 1 | 35 | 0 | 4 | 49 | 38 | 87 |
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]);