enrollments
Data source: Big Local News · About: Big Local
70,226 rows where state = "MA" sorted by school_state_type
This data as json, CSV (advanced)
grade ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
735758 | 735758 | MA | Essex | school | 2501950 | 9 | Andover | 250195000047 | 90003 | Bancroft Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 48 | 1 | 6 | 0 | 3 | 0 | 4 | 27 | 35 | 62 | 48 | 1 | 6 | 0 | 3 | 0 | 4 | 27 | 35 | 62 | |||||||||||||||||||||||||||||||||
735759 | 735759 | MA | Essex | school | 2501950 | 9 | Andover | 250195000047 | 90003 | Bancroft Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 63 | 2 | 4 | 1 | 6 | 0 | 4 | 42 | 38 | 80 | 63 | 2 | 4 | 1 | 6 | 0 | 4 | 42 | 38 | 80 | |||||||||||||||||||||||||||||||||
735760 | 735760 | MA | Essex | school | 2501950 | 9 | Andover | 250195000047 | 90003 | Bancroft Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 69 | 3 | 6 | 0 | 8 | 0 | 4 | 45 | 45 | 90 | 69 | 3 | 6 | 0 | 8 | 0 | 4 | 45 | 45 | 90 | |||||||||||||||||||||||||||||||||
735761 | 735761 | MA | Essex | school | 2501950 | 9 | Andover | 250195000047 | 90003 | Bancroft Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 77 | 0 | 3 | 1 | 12 | 0 | 2 | 52 | 43 | 95 | 77 | 0 | 3 | 1 | 12 | 0 | 2 | 52 | 43 | 95 | |||||||||||||||||||||||||||||||||
735762 | 735762 | MA | Essex | school | 2501950 | 9 | Andover | 250195000047 | 90003 | Bancroft Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 57 | 1 | 2 | 1 | 6 | 0 | 3 | 43 | 27 | 70 | 57 | 1 | 2 | 1 | 6 | 0 | 3 | 43 | 27 | 70 | |||||||||||||||||||||||||||||||||
735763 | 735763 | MA | Essex | school | 2501950 | 9 | Andover | 250195001676 | 90004 | High Plain Elementary | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 32 | 2 | 7 | 0 | 12 | 0 | 3 | 31 | 25 | 56 | 32 | 2 | 7 | 0 | 12 | 0 | 3 | 31 | 25 | 56 | |||||||||||||||||||||||||||||||||
735764 | 735764 | MA | Essex | school | 2501950 | 9 | Andover | 250195001676 | 90004 | High Plain Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 46 | 3 | 5 | 0 | 17 | 0 | 5 | 39 | 37 | 76 | 46 | 3 | 5 | 0 | 17 | 0 | 5 | 39 | 37 | 76 | |||||||||||||||||||||||||||||||||
735765 | 735765 | MA | Essex | school | 2501950 | 9 | Andover | 250195001676 | 90004 | High Plain Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 48 | 1 | 8 | 0 | 25 | 0 | 0 | 47 | 35 | 82 | 48 | 1 | 8 | 0 | 25 | 0 | 0 | 47 | 35 | 82 | |||||||||||||||||||||||||||||||||
735766 | 735766 | MA | Essex | school | 2501950 | 9 | Andover | 250195001676 | 90004 | High Plain Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 60 | 4 | 7 | 0 | 20 | 0 | 4 | 48 | 47 | 95 | 60 | 4 | 7 | 0 | 20 | 0 | 4 | 48 | 47 | 95 | |||||||||||||||||||||||||||||||||
735767 | 735767 | MA | Essex | school | 2501950 | 9 | Andover | 250195001676 | 90004 | High Plain Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 60 | 4 | 10 | 0 | 27 | 0 | 3 | 47 | 57 | 104 | 60 | 4 | 10 | 0 | 27 | 0 | 3 | 47 | 57 | 104 | |||||||||||||||||||||||||||||||||
735768 | 735768 | MA | Essex | school | 2501950 | 9 | Andover | 250195001676 | 90004 | High Plain Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 65 | 1 | 12 | 1 | 27 | 0 | 4 | 55 | 55 | 110 | 65 | 1 | 12 | 1 | 27 | 0 | 4 | 55 | 55 | 110 | |||||||||||||||||||||||||||||||||
735769 | 735769 | MA | Essex | school | 2501950 | 9 | Andover | 250195002366 | 90005 | Shawsheen School | Regular School | No | 1 | PK | 02 | 2015 | kindergarten | 52 | 3 | 1 | 0 | 8 | 0 | 6 | 41 | 29 | 70 | 52 | 3 | 1 | 0 | 8 | 0 | 6 | 41 | 29 | 70 | |||||||||||||||||||||||||||||||||
735770 | 735770 | MA | Essex | school | 2501950 | 9 | Andover | 250195002366 | 90005 | Shawsheen School | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 35 | 3 | 4 | 0 | 13 | 0 | 5 | 36 | 24 | 60 | 35 | 3 | 4 | 0 | 13 | 0 | 5 | 36 | 24 | 60 | |||||||||||||||||||||||||||||||||
735771 | 735771 | MA | Essex | school | 2501950 | 9 | Andover | 250195002366 | 90005 | Shawsheen School | Regular School | No | 1 | PK | 02 | 2015 | grade_1 | 39 | 1 | 4 | 0 | 5 | 0 | 1 | 24 | 26 | 50 | 39 | 1 | 4 | 0 | 5 | 0 | 1 | 24 | 26 | 50 | |||||||||||||||||||||||||||||||||
735772 | 735772 | MA | Essex | school | 2501950 | 9 | Andover | 250195002366 | 90005 | Shawsheen School | Regular School | No | 1 | PK | 02 | 2015 | grade_2 | 37 | 1 | 5 | 0 | 5 | 0 | 5 | 32 | 21 | 53 | 37 | 1 | 5 | 0 | 5 | 0 | 5 | 32 | 21 | 53 | |||||||||||||||||||||||||||||||||
735773 | 735773 | MA | Essex | school | 2501950 | 9 | Andover | 250195000048 | 90010 | Henry C Sanborn Elementary | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 31 | 0 | 3 | 0 | 12 | 0 | 0 | 22 | 24 | 46 | 31 | 0 | 3 | 0 | 12 | 0 | 0 | 22 | 24 | 46 | |||||||||||||||||||||||||||||||||
735774 | 735774 | MA | Essex | school | 2501950 | 9 | Andover | 250195000048 | 90010 | Henry C Sanborn Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 34 | 0 | 0 | 1 | 11 | 0 | 2 | 31 | 17 | 48 | 34 | 0 | 0 | 1 | 11 | 0 | 2 | 31 | 17 | 48 | |||||||||||||||||||||||||||||||||
735775 | 735775 | MA | Essex | school | 2501950 | 9 | Andover | 250195000048 | 90010 | Henry C Sanborn Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 36 | 0 | 2 | 0 | 22 | 0 | 1 | 27 | 34 | 61 | 36 | 0 | 2 | 0 | 22 | 0 | 1 | 27 | 34 | 61 | |||||||||||||||||||||||||||||||||
735776 | 735776 | MA | Essex | school | 2501950 | 9 | Andover | 250195000048 | 90010 | Henry C Sanborn Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 42 | 1 | 6 | 2 | 20 | 0 | 2 | 45 | 28 | 73 | 42 | 1 | 6 | 2 | 20 | 0 | 2 | 45 | 28 | 73 | |||||||||||||||||||||||||||||||||
735777 | 735777 | MA | Essex | school | 2501950 | 9 | Andover | 250195000048 | 90010 | Henry C Sanborn Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 46 | 0 | 2 | 0 | 21 | 0 | 3 | 32 | 40 | 72 | 46 | 0 | 2 | 0 | 21 | 0 | 3 | 32 | 40 | 72 | |||||||||||||||||||||||||||||||||
735778 | 735778 | MA | Essex | school | 2501950 | 9 | Andover | 250195000048 | 90010 | Henry C Sanborn Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 47 | 1 | 4 | 0 | 13 | 0 | 1 | 33 | 33 | 66 | 47 | 1 | 4 | 0 | 13 | 0 | 1 | 33 | 33 | 66 | |||||||||||||||||||||||||||||||||
735779 | 735779 | MA | Essex | school | 2501950 | 9 | Andover | 250195000050 | 90020 | South Elementary | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 56 | 1 | 3 | 0 | 9 | 0 | 0 | 42 | 27 | 69 | 56 | 1 | 3 | 0 | 9 | 0 | 0 | 42 | 27 | 69 | |||||||||||||||||||||||||||||||||
735780 | 735780 | MA | Essex | school | 2501950 | 9 | Andover | 250195000050 | 90020 | South Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 59 | 1 | 4 | 0 | 9 | 0 | 0 | 33 | 40 | 73 | 59 | 1 | 4 | 0 | 9 | 0 | 0 | 33 | 40 | 73 | |||||||||||||||||||||||||||||||||
735781 | 735781 | MA | Essex | school | 2501950 | 9 | Andover | 250195000050 | 90020 | South Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 57 | 1 | 3 | 0 | 17 | 1 | 0 | 41 | 38 | 79 | 57 | 1 | 3 | 0 | 17 | 1 | 0 | 41 | 38 | 79 | |||||||||||||||||||||||||||||||||
735782 | 735782 | MA | Essex | school | 2501950 | 9 | Andover | 250195000050 | 90020 | South Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 73 | 1 | 5 | 0 | 17 | 0 | 0 | 46 | 50 | 96 | 73 | 1 | 5 | 0 | 17 | 0 | 0 | 46 | 50 | 96 | |||||||||||||||||||||||||||||||||
735783 | 735783 | MA | Essex | school | 2501950 | 9 | Andover | 250195000050 | 90020 | South Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 70 | 0 | 3 | 1 | 20 | 0 | 2 | 48 | 48 | 96 | 70 | 0 | 3 | 1 | 20 | 0 | 2 | 48 | 48 | 96 | |||||||||||||||||||||||||||||||||
735784 | 735784 | MA | Essex | school | 2501950 | 9 | Andover | 250195000050 | 90020 | South Elementary | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 78 | 0 | 3 | 0 | 22 | 0 | 3 | 56 | 50 | 106 | 78 | 0 | 3 | 0 | 22 | 0 | 3 | 56 | 50 | 106 | |||||||||||||||||||||||||||||||||
735785 | 735785 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | West Elementary | Regular School | No | 1 | PK | 05 | 2015 | kindergarten | 54 | 2 | 2 | 0 | 9 | 0 | 2 | 33 | 36 | 69 | 54 | 2 | 2 | 0 | 9 | 0 | 2 | 33 | 36 | 69 | |||||||||||||||||||||||||||||||||
735786 | 735786 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | West Elementary | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | * | * | * | * | * | * | * | 1 | 2 | 3 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||
735787 | 735787 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | West Elementary | Regular School | No | 1 | PK | 05 | 2015 | grade_1 | 59 | 3 | 3 | 0 | 11 | 0 | 2 | 36 | 42 | 78 | 59 | 3 | 3 | 0 | 11 | 0 | 2 | 36 | 42 | 78 | |||||||||||||||||||||||||||||||||
735788 | 735788 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | West Elementary | Regular School | No | 1 | PK | 05 | 2015 | grade_2 | 65 | 1 | 5 | 1 | 13 | 0 | 4 | 48 | 41 | 89 | 65 | 1 | 5 | 1 | 13 | 0 | 4 | 48 | 41 | 89 | |||||||||||||||||||||||||||||||||
735789 | 735789 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | West Elementary | Regular School | No | 1 | PK | 05 | 2015 | grade_3 | 100 | 4 | 7 | 0 | 9 | 0 | 5 | 65 | 60 | 125 | 100 | 4 | 7 | 0 | 9 | 0 | 5 | 65 | 60 | 125 | |||||||||||||||||||||||||||||||||
735790 | 735790 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | West Elementary | Regular School | No | 1 | PK | 05 | 2015 | grade_4 | 125 | 1 | 7 | 0 | 13 | 0 | 6 | 74 | 78 | 152 | 125 | 1 | 7 | 0 | 13 | 0 | 6 | 74 | 78 | 152 | |||||||||||||||||||||||||||||||||
735791 | 735791 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | West Elementary | Regular School | No | 1 | PK | 05 | 2015 | grade_5 | 103 | 3 | 8 | 0 | 21 | 0 | 2 | 65 | 72 | 137 | 103 | 3 | 8 | 0 | 21 | 0 | 2 | 65 | 72 | 137 | |||||||||||||||||||||||||||||||||
735792 | 735792 | MA | Essex | school | 2501950 | 9 | Andover | 250195002510 | 90305 | Doherty Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_6 | 150 | 1 | 9 | 0 | 24 | 0 | 6 | 90 | 100 | 190 | 150 | 1 | 9 | 0 | 24 | 0 | 6 | 90 | 100 | 190 | |||||||||||||||||||||||||||||||||
735793 | 735793 | MA | Essex | school | 2501950 | 9 | Andover | 250195002510 | 90305 | Doherty Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 159 | 3 | 11 | 0 | 13 | 0 | 6 | 107 | 85 | 192 | 159 | 3 | 11 | 0 | 13 | 0 | 6 | 107 | 85 | 192 | |||||||||||||||||||||||||||||||||
735794 | 735794 | MA | Essex | school | 2501950 | 9 | Andover | 250195002510 | 90305 | Doherty Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_8 | 161 | 4 | 5 | 0 | 16 | 0 | 6 | 92 | 100 | 192 | 161 | 4 | 5 | 0 | 16 | 0 | 6 | 92 | 100 | 192 | |||||||||||||||||||||||||||||||||
735795 | 735795 | MA | Essex | school | 2501950 | 9 | Andover | 250195002511 | 90310 | Andover West Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_6 | 138 | 2 | 8 | 1 | 30 | 0 | 3 | 92 | 90 | 182 | 138 | 2 | 8 | 1 | 30 | 0 | 3 | 92 | 90 | 182 | |||||||||||||||||||||||||||||||||
735796 | 735796 | MA | Essex | school | 2501950 | 9 | Andover | 250195002511 | 90310 | Andover West Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 153 | 2 | 4 | 1 | 28 | 0 | 4 | 89 | 103 | 192 | 153 | 2 | 4 | 1 | 28 | 0 | 4 | 89 | 103 | 192 | |||||||||||||||||||||||||||||||||
735797 | 735797 | MA | Essex | school | 2501950 | 9 | Andover | 250195002511 | 90310 | Andover West Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_8 | 155 | 4 | 5 | 0 | 22 | 0 | 7 | 92 | 101 | 193 | 155 | 4 | 5 | 0 | 22 | 0 | 7 | 92 | 101 | 193 | |||||||||||||||||||||||||||||||||
735798 | 735798 | MA | Essex | school | 2501950 | 9 | Andover | 250195001678 | 90350 | Wood Hill Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_6 | 104 | 7 | 5 | 0 | 38 | 0 | 4 | 67 | 91 | 158 | 104 | 7 | 5 | 0 | 38 | 0 | 4 | 67 | 91 | 158 | |||||||||||||||||||||||||||||||||
735799 | 735799 | MA | Essex | school | 2501950 | 9 | Andover | 250195001678 | 90350 | Wood Hill Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 91 | 4 | 5 | 0 | 23 | 0 | 1 | 74 | 50 | 124 | 91 | 4 | 5 | 0 | 23 | 0 | 1 | 74 | 50 | 124 | |||||||||||||||||||||||||||||||||
735800 | 735800 | MA | Essex | school | 2501950 | 9 | Andover | 250195001678 | 90350 | Wood Hill Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_8 | 98 | 2 | 7 | 0 | 28 | 0 | 2 | 76 | 61 | 137 | 98 | 2 | 7 | 0 | 28 | 0 | 2 | 76 | 61 | 137 | |||||||||||||||||||||||||||||||||
735801 | 735801 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | 3 | 09 | 12 | 2015 | grade_9 | 321 | 7 | 23 | 0 | 61 | 0 | 8 | 199 | 221 | 420 | 321 | 7 | 23 | 0 | 61 | 0 | 8 | 199 | 221 | 420 | |||||||||||||||||||||||||||||||||
735802 | 735802 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | 3 | 09 | 12 | 2015 | grade_10 | 369 | 11 | 25 | 0 | 61 | 0 | 11 | 248 | 229 | 477 | 369 | 11 | 25 | 0 | 61 | 0 | 11 | 248 | 229 | 477 | |||||||||||||||||||||||||||||||||
735803 | 735803 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 331 | 5 | 18 | 2 | 63 | 0 | 13 | 208 | 224 | 432 | 331 | 5 | 18 | 2 | 63 | 0 | 13 | 208 | 224 | 432 | |||||||||||||||||||||||||||||||||
735804 | 735804 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 326 | 5 | 20 | 1 | 53 | 0 | 10 | 199 | 216 | 415 | 326 | 5 | 20 | 1 | 53 | 0 | 10 | 199 | 216 | 415 | |||||||||||||||||||||||||||||||||
735805 | 735805 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | 3 | 09 | 12 | 2015 | SP | 15 | 1 | 0 | 0 | 0 | 0 | 0 | 16 | 15 | 1 | 0 | 0 | 0 | 0 | 0 | 16 | |||||||||||||||||||||||||||||||||||||
735806 | 735806 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000059 | 100005 | John A Bishop | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 46 | 3 | 1 | 0 | 9 | 0 | 9 | 35 | 33 | 68 | 46 | 3 | 1 | 0 | 9 | 0 | 9 | 35 | 33 | 68 | |||||||||||||||||||||||||||||||||
735807 | 735807 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000059 | 100005 | John A Bishop | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 60 | 3 | 2 | 0 | 6 | 0 | 1 | 35 | 37 | 72 | 60 | 3 | 2 | 0 | 6 | 0 | 1 | 35 | 37 | 72 | |||||||||||||||||||||||||||||||||
735808 | 735808 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000059 | 100005 | John A Bishop | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 46 | 5 | 4 | 0 | 10 | 0 | 3 | 32 | 36 | 68 | 46 | 5 | 4 | 0 | 10 | 0 | 3 | 32 | 36 | 68 | |||||||||||||||||||||||||||||||||
735809 | 735809 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000059 | 100005 | John A Bishop | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 60 | 1 | 2 | 0 | 11 | 0 | 2 | 34 | 42 | 76 | 60 | 1 | 2 | 0 | 11 | 0 | 2 | 34 | 42 | 76 | |||||||||||||||||||||||||||||||||
735810 | 735810 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000059 | 100005 | John A Bishop | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 60 | 4 | 3 | 0 | 5 | 0 | 0 | 37 | 35 | 72 | 60 | 4 | 3 | 0 | 5 | 0 | 0 | 37 | 35 | 72 | |||||||||||||||||||||||||||||||||
735811 | 735811 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000059 | 100005 | John A Bishop | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 49 | 3 | 1 | 0 | 6 | 0 | 0 | 28 | 31 | 59 | 49 | 3 | 1 | 0 | 6 | 0 | 0 | 28 | 31 | 59 | |||||||||||||||||||||||||||||||||
735812 | 735812 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000054 | 100010 | Brackett | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 67 | 2 | 9 | 1 | 8 | 1 | 9 | 50 | 47 | 97 | 67 | 2 | 9 | 1 | 8 | 1 | 9 | 50 | 47 | 97 | |||||||||||||||||||||||||||||||||
735813 | 735813 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000054 | 100010 | Brackett | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 65 | 2 | 7 | 0 | 4 | 0 | 5 | 41 | 42 | 83 | 65 | 2 | 7 | 0 | 4 | 0 | 5 | 41 | 42 | 83 | |||||||||||||||||||||||||||||||||
735814 | 735814 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000054 | 100010 | Brackett | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 54 | 1 | 1 | 0 | 7 | 0 | 5 | 41 | 27 | 68 | 54 | 1 | 1 | 0 | 7 | 0 | 5 | 41 | 27 | 68 | |||||||||||||||||||||||||||||||||
735815 | 735815 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000054 | 100010 | Brackett | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 67 | 2 | 5 | 0 | 11 | 0 | 7 | 47 | 45 | 92 | 67 | 2 | 5 | 0 | 11 | 0 | 7 | 47 | 45 | 92 | |||||||||||||||||||||||||||||||||
735816 | 735816 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000054 | 100010 | Brackett | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 65 | 2 | 6 | 0 | 7 | 0 | 8 | 43 | 45 | 88 | 65 | 2 | 6 | 0 | 7 | 0 | 8 | 43 | 45 | 88 | |||||||||||||||||||||||||||||||||
735817 | 735817 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000054 | 100010 | Brackett | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 50 | 0 | 5 | 0 | 7 | 0 | 7 | 32 | 37 | 69 | 50 | 0 | 5 | 0 | 7 | 0 | 7 | 32 | 37 | 69 | |||||||||||||||||||||||||||||||||
735818 | 735818 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000057 | 100025 | Cyrus E Dallin | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 59 | 1 | 2 | 0 | 8 | 0 | 4 | 32 | 42 | 74 | 59 | 1 | 2 | 0 | 8 | 0 | 4 | 32 | 42 | 74 | |||||||||||||||||||||||||||||||||
735819 | 735819 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000057 | 100025 | Cyrus E Dallin | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 59 | 2 | 7 | 0 | 6 | 0 | 4 | 38 | 40 | 78 | 59 | 2 | 7 | 0 | 6 | 0 | 4 | 38 | 40 | 78 | |||||||||||||||||||||||||||||||||
735820 | 735820 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000057 | 100025 | Cyrus E Dallin | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 48 | 4 | 3 | 0 | 9 | 1 | 1 | 39 | 27 | 66 | 48 | 4 | 3 | 0 | 9 | 1 | 1 | 39 | 27 | 66 | |||||||||||||||||||||||||||||||||
735821 | 735821 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000057 | 100025 | Cyrus E Dallin | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 60 | 1 | 2 | 0 | 10 | 1 | 2 | 44 | 32 | 76 | 60 | 1 | 2 | 0 | 10 | 1 | 2 | 44 | 32 | 76 | |||||||||||||||||||||||||||||||||
735822 | 735822 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000057 | 100025 | Cyrus E Dallin | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 69 | 3 | 8 | 0 | 5 | 0 | 4 | 36 | 53 | 89 | 69 | 3 | 8 | 0 | 5 | 0 | 4 | 36 | 53 | 89 | |||||||||||||||||||||||||||||||||
735823 | 735823 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000057 | 100025 | Cyrus E Dallin | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 59 | 2 | 1 | 0 | 8 | 0 | 3 | 30 | 43 | 73 | 59 | 2 | 1 | 0 | 8 | 0 | 3 | 30 | 43 | 73 | |||||||||||||||||||||||||||||||||
735824 | 735824 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000058 | 100030 | Hardy | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 55 | 1 | 5 | 1 | 16 | 0 | 4 | 50 | 32 | 82 | 55 | 1 | 5 | 1 | 16 | 0 | 4 | 50 | 32 | 82 | |||||||||||||||||||||||||||||||||
735825 | 735825 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000058 | 100030 | Hardy | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 47 | 6 | 3 | 0 | 11 | 0 | 2 | 34 | 35 | 69 | 47 | 6 | 3 | 0 | 11 | 0 | 2 | 34 | 35 | 69 | |||||||||||||||||||||||||||||||||
735826 | 735826 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000058 | 100030 | Hardy | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 44 | 3 | 5 | 0 | 12 | 0 | 4 | 41 | 27 | 68 | 44 | 3 | 5 | 0 | 12 | 0 | 4 | 41 | 27 | 68 | |||||||||||||||||||||||||||||||||
735827 | 735827 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000058 | 100030 | Hardy | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 43 | 3 | 7 | 0 | 10 | 1 | 4 | 33 | 35 | 68 | 43 | 3 | 7 | 0 | 10 | 1 | 4 | 33 | 35 | 68 | |||||||||||||||||||||||||||||||||
735828 | 735828 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000058 | 100030 | Hardy | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 33 | 0 | 1 | 0 | 9 | 0 | 3 | 23 | 23 | 46 | 33 | 0 | 1 | 0 | 9 | 0 | 3 | 23 | 23 | 46 | |||||||||||||||||||||||||||||||||
735829 | 735829 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000058 | 100030 | Hardy | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 41 | 2 | 3 | 0 | 12 | 0 | 1 | 30 | 29 | 59 | 41 | 2 | 3 | 0 | 12 | 0 | 1 | 30 | 29 | 59 | |||||||||||||||||||||||||||||||||
735830 | 735830 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198001681 | 100038 | Menotomy Preschool | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 35 | 5 | 2 | 0 | 13 | 0 | 2 | 36 | 21 | 57 | 35 | 5 | 2 | 0 | 13 | 0 | 2 | 36 | 21 | 57 | |||||||||||||||||||||||||||||||||
735831 | 735831 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000065 | 100045 | Peirce | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 29 | 0 | 7 | 0 | 6 | 0 | 5 | 19 | 28 | 47 | 29 | 0 | 7 | 0 | 6 | 0 | 5 | 19 | 28 | 47 | |||||||||||||||||||||||||||||||||
735832 | 735832 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000065 | 100045 | Peirce | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 37 | 0 | 5 | 0 | 2 | 0 | 0 | 27 | 17 | 44 | 37 | 0 | 5 | 0 | 2 | 0 | 0 | 27 | 17 | 44 | |||||||||||||||||||||||||||||||||
735833 | 735833 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000065 | 100045 | Peirce | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 33 | 1 | 4 | 0 | 4 | 0 | 2 | 18 | 26 | 44 | 33 | 1 | 4 | 0 | 4 | 0 | 2 | 18 | 26 | 44 | |||||||||||||||||||||||||||||||||
735834 | 735834 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000065 | 100045 | Peirce | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 33 | 2 | 5 | 0 | 3 | 0 | 4 | 26 | 21 | 47 | 33 | 2 | 5 | 0 | 3 | 0 | 4 | 26 | 21 | 47 | |||||||||||||||||||||||||||||||||
735835 | 735835 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000065 | 100045 | Peirce | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 29 | 5 | 1 | 0 | 5 | 0 | 3 | 20 | 23 | 43 | 29 | 5 | 1 | 0 | 5 | 0 | 3 | 20 | 23 | 43 | |||||||||||||||||||||||||||||||||
735836 | 735836 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000065 | 100045 | Peirce | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 30 | 5 | 4 | 0 | 2 | 0 | 1 | 20 | 22 | 42 | 30 | 5 | 4 | 0 | 2 | 0 | 1 | 20 | 22 | 42 | |||||||||||||||||||||||||||||||||
735837 | 735837 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000066 | 100050 | Thompson | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 54 | 3 | 4 | 0 | 13 | 1 | 6 | 43 | 38 | 81 | 54 | 3 | 4 | 0 | 13 | 1 | 6 | 43 | 38 | 81 | |||||||||||||||||||||||||||||||||
735838 | 735838 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000066 | 100050 | Thompson | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 44 | 2 | 8 | 0 | 9 | 0 | 5 | 33 | 35 | 68 | 44 | 2 | 8 | 0 | 9 | 0 | 5 | 33 | 35 | 68 | |||||||||||||||||||||||||||||||||
735839 | 735839 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000066 | 100050 | Thompson | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 55 | 3 | 6 | 1 | 12 | 1 | 4 | 45 | 37 | 82 | 55 | 3 | 6 | 1 | 12 | 1 | 4 | 45 | 37 | 82 | |||||||||||||||||||||||||||||||||
735840 | 735840 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000066 | 100050 | Thompson | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 32 | 2 | 7 | 0 | 6 | 0 | 3 | 24 | 26 | 50 | 32 | 2 | 7 | 0 | 6 | 0 | 3 | 24 | 26 | 50 | |||||||||||||||||||||||||||||||||
735841 | 735841 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000066 | 100050 | Thompson | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 33 | 5 | 2 | 0 | 8 | 0 | 7 | 18 | 37 | 55 | 33 | 5 | 2 | 0 | 8 | 0 | 7 | 18 | 37 | 55 | |||||||||||||||||||||||||||||||||
735842 | 735842 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000066 | 100050 | Thompson | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 41 | 3 | 1 | 0 | 10 | 0 | 1 | 25 | 31 | 56 | 41 | 3 | 1 | 0 | 10 | 0 | 1 | 25 | 31 | 56 | |||||||||||||||||||||||||||||||||
735843 | 735843 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000062 | 100055 | M Norcross Stratton | Regular School | No | 1 | KG | 05 | 2015 | kindergarten | 43 | 3 | 6 | 0 | 12 | 0 | 3 | 43 | 24 | 67 | 43 | 3 | 6 | 0 | 12 | 0 | 3 | 43 | 24 | 67 | |||||||||||||||||||||||||||||||||
735844 | 735844 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000062 | 100055 | M Norcross Stratton | Regular School | No | 1 | KG | 05 | 2015 | grade_1 | 49 | 1 | 1 | 0 | 11 | 0 | 6 | 37 | 31 | 68 | 49 | 1 | 1 | 0 | 11 | 0 | 6 | 37 | 31 | 68 | |||||||||||||||||||||||||||||||||
735845 | 735845 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000062 | 100055 | M Norcross Stratton | Regular School | No | 1 | KG | 05 | 2015 | grade_2 | 47 | 0 | 6 | 0 | 11 | 0 | 5 | 32 | 37 | 69 | 47 | 0 | 6 | 0 | 11 | 0 | 5 | 32 | 37 | 69 | |||||||||||||||||||||||||||||||||
735846 | 735846 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000062 | 100055 | M Norcross Stratton | Regular School | No | 1 | KG | 05 | 2015 | grade_3 | 49 | 2 | 3 | 0 | 12 | 0 | 2 | 27 | 41 | 68 | 49 | 2 | 3 | 0 | 12 | 0 | 2 | 27 | 41 | 68 | |||||||||||||||||||||||||||||||||
735847 | 735847 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000062 | 100055 | M Norcross Stratton | Regular School | No | 1 | KG | 05 | 2015 | grade_4 | 43 | 3 | 4 | 0 | 12 | 0 | 4 | 34 | 32 | 66 | 43 | 3 | 4 | 0 | 12 | 0 | 4 | 34 | 32 | 66 | |||||||||||||||||||||||||||||||||
735848 | 735848 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000062 | 100055 | M Norcross Stratton | Regular School | No | 1 | KG | 05 | 2015 | grade_5 | 49 | 1 | 4 | 0 | 8 | 0 | 8 | 35 | 35 | 70 | 49 | 1 | 4 | 0 | 8 | 0 | 8 | 35 | 35 | 70 | |||||||||||||||||||||||||||||||||
735849 | 735849 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_6 | 308 | 16 | 28 | 0 | 31 | 0 | 14 | 193 | 204 | 397 | 308 | 16 | 28 | 0 | 31 | 0 | 14 | 193 | 204 | 397 | |||||||||||||||||||||||||||||||||
735850 | 735850 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 269 | 11 | 17 | 0 | 33 | 1 | 10 | 183 | 158 | 341 | 269 | 11 | 17 | 0 | 33 | 1 | 10 | 183 | 158 | 341 | |||||||||||||||||||||||||||||||||
735851 | 735851 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_8 | 266 | 18 | 21 | 0 | 41 | 0 | 23 | 169 | 200 | 369 | 266 | 18 | 21 | 0 | 41 | 0 | 23 | 169 | 200 | 369 | |||||||||||||||||||||||||||||||||
735852 | 735852 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | 3 | 09 | 12 | 2015 | grade_9 | 249 | 16 | 15 | 0 | 20 | 0 | 6 | 153 | 153 | 306 | 249 | 16 | 15 | 0 | 20 | 0 | 6 | 153 | 153 | 306 | |||||||||||||||||||||||||||||||||
735853 | 735853 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | 3 | 09 | 12 | 2015 | grade_10 | 228 | 10 | 8 | 0 | 32 | 0 | 11 | 139 | 150 | 289 | 228 | 10 | 8 | 0 | 32 | 0 | 11 | 139 | 150 | 289 | |||||||||||||||||||||||||||||||||
735854 | 735854 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | 3 | 09 | 12 | 2015 | grade_11 | 243 | 12 | 16 | 1 | 35 | 0 | 3 | 141 | 169 | 310 | 243 | 12 | 16 | 1 | 35 | 0 | 3 | 141 | 169 | 310 | |||||||||||||||||||||||||||||||||
735855 | 735855 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 244 | 10 | 16 | 0 | 33 | 1 | 8 | 158 | 154 | 312 | 244 | 10 | 16 | 0 | 33 | 1 | 8 | 158 | 154 | 312 | |||||||||||||||||||||||||||||||||
735856 | 735856 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210002455 | 140005 | William Pittaway Elementary | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 93 | 0 | 13 | 0 | 15 | 0 | 2 | 61 | 62 | 123 | 93 | 0 | 13 | 0 | 15 | 0 | 2 | 61 | 62 | 123 | |||||||||||||||||||||||||||||||||
735857 | 735857 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000072 | 140010 | Henry E Warren Elementary | Regular School | No | 1 | KG | 02 | 2015 | kindergarten | 153 | 5 | 3 | 4 | 23 | 0 | 5 | 86 | 107 | 193 | 153 | 5 | 3 | 4 | 23 | 0 | 5 | 86 | 107 | 193 |
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]);