enrollments
Data source: Big Local News · About: Big Local
976 rows where grade = "grade_2", state = "MA" and year = 2018 sorted by ccd_school_lvl
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2230205 | 2230205 | MA | Suffolk | school | 35 | Boston | 350652 | 2018 | grade_2 | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2228761 | 2228761 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000434 | 10020 | Abington: Beaver Brook Elementary | Regular School | No | Elementary | KG | 02 | 2018 | grade_2 | 113 | 4 | 8 | 0 | 5 | 1 | 1 | 59 | 73 | 132.0 | 113 | 4 | 8 | 0 | 5 | 1 | 1 | 59 | 73 | 132 | |||||||||||||||||||||||||||||||||
2228776 | 2228776 | MA | Bristol | school | 2501740 | 3 | Acushnet | 250174000014 | 30025 | Acushnet: Acushnet Elementary School | Regular School | No | Elementary | PK | 04 | 2018 | grade_2 | 89 | 0 | 4 | 0 | 0 | 0 | 6 | 53 | 46 | 99.0 | 89 | 0 | 4 | 0 | 0 | 0 | 6 | 53 | 46 | 99 | |||||||||||||||||||||||||||||||||
2228789 | 2228789 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000028 | 50010 | Agawam: Clifford M Granger | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 32 | 1 | 8 | 0 | 0 | 0 | 3 | 23 | 21 | 44.0 | 32 | 1 | 8 | 0 | 0 | 0 | 3 | 23 | 21 | 44 | |||||||||||||||||||||||||||||||||
2228795 | 2228795 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000027 | 50020 | Agawam: Benjamin J Phelps | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 63 | 0 | 1 | 0 | 1 | 0 | 0 | 38 | 27 | 65.0 | 63 | 0 | 1 | 0 | 1 | 0 | 0 | 38 | 27 | 65 | |||||||||||||||||||||||||||||||||
2228801 | 2228801 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000032 | 50025 | Agawam: Robinson Park | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 66 | 2 | 5 | 0 | 3 | 0 | 2 | 40 | 38 | 78.0 | 66 | 2 | 5 | 0 | 3 | 0 | 2 | 40 | 38 | 78 | |||||||||||||||||||||||||||||||||
2228807 | 2228807 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000030 | 50030 | Agawam: James Clark School | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 57 | 2 | 7 | 0 | 2 | 0 | 3 | 35 | 36 | 71.0 | 57 | 2 | 7 | 0 | 2 | 0 | 3 | 35 | 36 | 71 | |||||||||||||||||||||||||||||||||
2228825 | 2228825 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000033 | 70005 | Amesbury: Amesbury Elementary | Regular School | No | Elementary | PK | 04 | 2018 | grade_2 | 62 | 2 | 4 | 1 | 0 | 0 | 4 | 30 | 43 | 73.0 | 62 | 2 | 4 | 1 | 0 | 0 | 4 | 30 | 43 | 73 | |||||||||||||||||||||||||||||||||
2228832 | 2228832 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000036 | 70010 | Amesbury: Charles C Cashman Elementary | Regular School | No | Elementary | PK | 04 | 2018 | grade_2 | 78 | 1 | 10 | 0 | 2 | 0 | 1 | 55 | 37 | 92.0 | 78 | 1 | 10 | 0 | 2 | 0 | 1 | 55 | 37 | 92 | |||||||||||||||||||||||||||||||||
2228854 | 2228854 | MA | Hampshire | school | 2501890 | 8 | Amherst | 250189000038 | 80009 | Amherst: Crocker Farm Elementary | Regular School | No | Elementary | PK | 06 | 2018 | grade_2 | 25 | 5 | 11 | 0 | 10 | 0 | 0 | 29 | 22 | 51.0 | 25 | 5 | 11 | 0 | 10 | 0 | 0 | 29 | 22 | 51 | |||||||||||||||||||||||||||||||||
2228862 | 2228862 | MA | Hampshire | school | 2501890 | 8 | Amherst | 250189000039 | 80020 | Amherst: Fort River Elementary | Regular School | No | Elementary | KG | 06 | 2018 | grade_2 | 21 | 4 | 8 | 0 | 12 | 0 | 1 | 24 | 22 | 46.0 | 21 | 4 | 8 | 0 | 12 | 0 | 1 | 24 | 22 | 46 | |||||||||||||||||||||||||||||||||
2228870 | 2228870 | MA | Hampshire | school | 2501890 | 8 | Amherst | 250189000041 | 80050 | Amherst: Wildwood Elementary | Regular School | No | Elementary | KG | 06 | 2018 | grade_2 | 29 | 9 | 14 | 0 | 6 | 0 | 0 | 31 | 27 | 58.0 | 29 | 9 | 14 | 0 | 6 | 0 | 0 | 31 | 27 | 58 | |||||||||||||||||||||||||||||||||
2228878 | 2228878 | MA | Essex | school | 2501950 | 9 | Andover | 250195000047 | 90003 | Andover: Bancroft Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 73 | 2 | 5 | 0 | 9 | 0 | 5 | 52 | 42 | 94.0 | 73 | 2 | 5 | 0 | 9 | 0 | 5 | 52 | 42 | 94 | |||||||||||||||||||||||||||||||||
2228885 | 2228885 | MA | Essex | school | 2501950 | 9 | Andover | 250195001676 | 90004 | Andover: High Plain Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 45 | 2 | 4 | 0 | 25 | 0 | 2 | 45 | 33 | 78.0 | 45 | 2 | 4 | 0 | 25 | 0 | 2 | 45 | 33 | 78 | |||||||||||||||||||||||||||||||||
2228894 | 2228894 | MA | Essex | school | 2501950 | 9 | Andover | 250195000048 | 90010 | Andover: Henry C Sanborn Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 46 | 0 | 1 | 0 | 22 | 0 | 1 | 35 | 35 | 70.0 | 46 | 0 | 1 | 0 | 22 | 0 | 1 | 35 | 35 | 70 | |||||||||||||||||||||||||||||||||
2228901 | 2228901 | MA | Essex | school | 2501950 | 9 | Andover | 250195000050 | 90020 | Andover: South Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 67 | 2 | 6 | 1 | 15 | 0 | 2 | 41 | 52 | 93.0 | 67 | 2 | 6 | 1 | 15 | 0 | 2 | 41 | 52 | 93 | |||||||||||||||||||||||||||||||||
2228908 | 2228908 | MA | Essex | school | 2501950 | 9 | Andover | 250195000051 | 90025 | Andover: West Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 72 | 1 | 7 | 0 | 17 | 0 | 0 | 47 | 50 | 97.0 | 72 | 1 | 7 | 0 | 17 | 0 | 0 | 47 | 50 | 97 | |||||||||||||||||||||||||||||||||
2228932 | 2228932 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000059 | 100005 | Arlington: John A Bishop | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 49 | 0 | 0 | 0 | 15 | 2 | 4 | 32 | 38 | 70.0 | 49 | 0 | 0 | 0 | 15 | 2 | 4 | 32 | 38 | 70 | |||||||||||||||||||||||||||||||||
2228939 | 2228939 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000054 | 100010 | Arlington: Brackett | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 57 | 0 | 3 | 0 | 4 | 0 | 4 | 33 | 35 | 68.0 | 57 | 0 | 3 | 0 | 4 | 0 | 4 | 33 | 35 | 68 | |||||||||||||||||||||||||||||||||
2228946 | 2228946 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000057 | 100025 | Arlington: Cyrus E Dallin | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 61 | 1 | 2 | 0 | 8 | 0 | 2 | 36 | 38 | 74.0 | 61 | 1 | 2 | 0 | 8 | 0 | 2 | 36 | 38 | 74 | |||||||||||||||||||||||||||||||||
2228953 | 2228953 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000058 | 100030 | Arlington: Hardy | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 52 | 4 | 4 | 0 | 13 | 1 | 3 | 42 | 35 | 77.0 | 52 | 4 | 4 | 0 | 13 | 1 | 3 | 42 | 35 | 77 | |||||||||||||||||||||||||||||||||
2228962 | 2228962 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000065 | 100045 | Arlington: Peirce | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 35 | 2 | 2 | 0 | 6 | 0 | 1 | 19 | 27 | 46.0 | 35 | 2 | 2 | 0 | 6 | 0 | 1 | 19 | 27 | 46 | |||||||||||||||||||||||||||||||||
2228969 | 2228969 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000066 | 100050 | Arlington: Thompson | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 53 | 4 | 6 | 0 | 10 | 0 | 6 | 42 | 37 | 79.0 | 53 | 4 | 6 | 0 | 10 | 0 | 6 | 42 | 37 | 79 | |||||||||||||||||||||||||||||||||
2228976 | 2228976 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000062 | 100055 | Arlington: M Norcross Stratton | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 47 | 3 | 5 | 0 | 12 | 0 | 5 | 33 | 39 | 72.0 | 47 | 3 | 5 | 0 | 12 | 0 | 5 | 33 | 39 | 72 | |||||||||||||||||||||||||||||||||
2228994 | 2228994 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000072 | 140010 | Ashland: Henry E Warren Elementary | Regular School | No | Elementary | KG | 02 | 2018 | grade_2 | 123 | 3 | 24 | 0 | 31 | 1 | 7 | 92 | 97 | 189.0 | 123 | 3 | 24 | 0 | 31 | 1 | 7 | 92 | 97 | 189 | |||||||||||||||||||||||||||||||||
2229011 | 2229011 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000097 | 160001 | Attleboro: A. Irvin Studley Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 61 | 3 | 13 | 1 | 5 | 1 | 9 | 51 | 42 | 93.0 | 61 | 3 | 13 | 1 | 5 | 1 | 9 | 51 | 42 | 93 | |||||||||||||||||||||||||||||||||
2229019 | 2229019 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000098 | 160035 | Attleboro: Thomas Willett Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 57 | 11 | 9 | 0 | 3 | 0 | 5 | 42 | 43 | 85.0 | 57 | 11 | 9 | 0 | 3 | 0 | 5 | 42 | 43 | 85 | |||||||||||||||||||||||||||||||||
2229025 | 2229025 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000090 | 160040 | Attleboro: Hyman Fine Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 72 | 4 | 15 | 0 | 6 | 0 | 5 | 63 | 39 | 102.0 | 72 | 4 | 15 | 0 | 6 | 0 | 5 | 63 | 39 | 102 | |||||||||||||||||||||||||||||||||
2229031 | 2229031 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219000089 | 160045 | Attleboro: Hill-Roberts Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 69 | 4 | 9 | 1 | 6 | 0 | 8 | 52 | 45 | 97.0 | 69 | 4 | 9 | 1 | 6 | 0 | 8 | 52 | 45 | 97 | |||||||||||||||||||||||||||||||||
2229037 | 2229037 | MA | Bristol | school | 2502190 | 16 | Attleboro | 250219001294 | 160050 | Attleboro: Peter Thacher Elementary School | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 44 | 4 | 8 | 1 | 8 | 0 | 11 | 39 | 37 | 76.0 | 44 | 4 | 8 | 1 | 8 | 0 | 11 | 39 | 37 | 76 | |||||||||||||||||||||||||||||||||
2229066 | 2229066 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000101 | 170010 | Auburn: Bryn Mawr | Regular School | No | Elementary | KG | 02 | 2018 | grade_2 | 75 | 1 | 14 | 0 | 1 | 0 | 3 | 48 | 46 | 94.0 | 75 | 1 | 14 | 0 | 1 | 0 | 3 | 48 | 46 | 94 | |||||||||||||||||||||||||||||||||
2229071 | 2229071 | MA | Worcester | school | 2502220 | 17 | Auburn | 250222000103 | 170025 | Auburn: Pakachoag School | Regular School | No | Elementary | PK | 02 | 2018 | grade_2 | 77 | 2 | 7 | 0 | 4 | 0 | 2 | 54 | 38 | 92.0 | 77 | 2 | 7 | 0 | 4 | 0 | 2 | 54 | 38 | 92 | |||||||||||||||||||||||||||||||||
2229090 | 2229090 | MA | Norfolk | school | 2502250 | 18 | Avon | 250225000108 | 180010 | Avon: Ralph D Butler | Regular School | No | Elementary | PK | 06 | 2018 | grade_2 | 36 | 13 | 6 | 1 | 3 | 0 | 2 | 36 | 25 | 61.0 | 36 | 13 | 6 | 1 | 3 | 0 | 2 | 36 | 25 | 61 | |||||||||||||||||||||||||||||||||
2229107 | 2229107 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000125 | 200005 | Barnstable: West Barnstable Elementary | Regular School | No | Elementary | KG | 03 | 2018 | grade_2 | 57 | 2 | 5 | 0 | 1 | 0 | 1 | 41 | 25 | 66.0 | 57 | 2 | 5 | 0 | 1 | 0 | 1 | 41 | 25 | 66 | |||||||||||||||||||||||||||||||||
2229112 | 2229112 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000118 | 200010 | Barnstable: Centerville Elementary | Regular School | No | Elementary | KG | 03 | 2018 | grade_2 | 59 | 2 | 5 | 0 | 0 | 0 | 2 | 36 | 32 | 68.0 | 59 | 2 | 5 | 0 | 0 | 0 | 2 | 36 | 32 | 68 | |||||||||||||||||||||||||||||||||
2229117 | 2229117 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000121 | 200025 | Barnstable: Hyannis West Elementary | Regular School | No | Elementary | KG | 03 | 2018 | grade_2 | 29 | 17 | 36 | 1 | 3 | 0 | 4 | 50 | 40 | 90.0 | 29 | 17 | 36 | 1 | 3 | 0 | 4 | 50 | 40 | 90 | |||||||||||||||||||||||||||||||||
2229122 | 2229122 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002679 | 200045 | Barnstable: West Villages Elementary School | Regular School | No | Elementary | KG | 03 | 2018 | grade_2 | 82 | 3 | 6 | 0 | 0 | 0 | 4 | 55 | 40 | 95.0 | 82 | 3 | 6 | 0 | 0 | 0 | 4 | 55 | 40 | 95 | |||||||||||||||||||||||||||||||||
2229139 | 2229139 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000131 | 230010 | Bedford: Lt Elezer Davis | Regular School | No | Elementary | KG | 02 | 2018 | grade_2 | 123 | 12 | 14 | 0 | 36 | 0 | 16 | 98 | 103 | 201.0 | 123 | 12 | 14 | 0 | 36 | 0 | 16 | 98 | 103 | 201 | |||||||||||||||||||||||||||||||||
2229163 | 2229163 | MA | Hampshire | school | 2502430 | 24 | Belchertown | 250243000836 | 240018 | Belchertown: Swift River Elementary | Regular School | No | Elementary | 01 | 03 | 2018 | grade_2 | 138 | 4 | 4 | 2 | 3 | 0 | 5 | 82 | 74 | 156.0 | 138 | 4 | 4 | 2 | 3 | 0 | 5 | 82 | 74 | 156 | |||||||||||||||||||||||||||||||||
2229178 | 2229178 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000142 | 250020 | Bellingham: South Elementary | Regular School | No | Elementary | KG | 03 | 2018 | grade_2 | 77 | 1 | 4 | 0 | 1 | 0 | 0 | 45 | 38 | 83.0 | 77 | 1 | 4 | 0 | 1 | 0 | 0 | 45 | 38 | 83 | |||||||||||||||||||||||||||||||||
2229183 | 2229183 | MA | Norfolk | school | 2502460 | 25 | Bellingham | 250246000141 | 250025 | Bellingham: Stall Brook | Regular School | No | Elementary | KG | 03 | 2018 | grade_2 | 64 | 0 | 2 | 0 | 2 | 0 | 2 | 37 | 33 | 70.0 | 64 | 0 | 2 | 0 | 2 | 0 | 2 | 37 | 33 | 70 | |||||||||||||||||||||||||||||||||
2229205 | 2229205 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000148 | 260005 | Belmont: Winn Brook | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 57 | 4 | 4 | 0 | 23 | 0 | 8 | 49 | 47 | 96.0 | 57 | 4 | 4 | 0 | 23 | 0 | 8 | 49 | 47 | 96 | |||||||||||||||||||||||||||||||||
2229211 | 2229211 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000146 | 260010 | Belmont: Mary Lee Burbank | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 40 | 4 | 4 | 0 | 13 | 0 | 6 | 30 | 37 | 67.0 | 40 | 4 | 4 | 0 | 13 | 0 | 6 | 30 | 37 | 67 | |||||||||||||||||||||||||||||||||
2229217 | 2229217 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000144 | 260015 | Belmont: Daniel Butler | Regular School | No | Elementary | KG | 04 | 2018 | grade_2 | 36 | 3 | 3 | 2 | 21 | 0 | 6 | 36 | 35 | 71.0 | 36 | 3 | 3 | 2 | 21 | 0 | 6 | 36 | 35 | 71 | |||||||||||||||||||||||||||||||||
2229224 | 2229224 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000147 | 260035 | Belmont: Roger E Wellington | Regular School | No | Elementary | PK | 04 | 2018 | grade_2 | 80 | 2 | 3 | 0 | 13 | 0 | 16 | 62 | 52 | 114.0 | 80 | 2 | 3 | 0 | 13 | 0 | 16 | 62 | 52 | 114 | |||||||||||||||||||||||||||||||||
2229241 | 2229241 | MA | Bristol | school | 2502520 | 27 | Berkley | 250252002513 | 270010 | Berkley: Berkley Community School | Regular School | No | Elementary | PK | 04 | 2018 | grade_2 | 88 | 0 | 2 | 0 | 0 | 0 | 3 | 39 | 54 | 93.0 | 88 | 0 | 2 | 0 | 0 | 0 | 3 | 39 | 54 | 93 | |||||||||||||||||||||||||||||||||
2229253 | 2229253 | MA | Worcester | school | 2502550 | 28 | Berlin | 250255000159 | 280005 | Berlin: Berlin Memorial | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 27 | 0 | 2 | 0 | 0 | 0 | 2 | 18 | 13 | 31.0 | 27 | 0 | 2 | 0 | 0 | 0 | 2 | 18 | 13 | 31 | |||||||||||||||||||||||||||||||||
2229262 | 2229262 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000167 | 300010 | Beverly: Centerville Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 41 | 0 | 12 | 0 | 0 | 0 | 3 | 28 | 28 | 56.0 | 41 | 0 | 12 | 0 | 0 | 0 | 3 | 28 | 28 | 56 | |||||||||||||||||||||||||||||||||
2229269 | 2229269 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000168 | 300015 | Beverly: Cove Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 63 | 1 | 10 | 0 | 1 | 0 | 6 | 38 | 43 | 81.0 | 63 | 1 | 10 | 0 | 1 | 0 | 6 | 38 | 43 | 81 | |||||||||||||||||||||||||||||||||
2229276 | 2229276 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000169 | 300033 | Beverly: Hannah Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 45 | 2 | 5 | 0 | 1 | 0 | 2 | 32 | 23 | 55.0 | 45 | 2 | 5 | 0 | 1 | 0 | 2 | 32 | 23 | 55 | |||||||||||||||||||||||||||||||||
2229283 | 2229283 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000173 | 300040 | Beverly: North Beverly Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 41 | 2 | 16 | 0 | 1 | 0 | 3 | 25 | 38 | 63.0 | 41 | 2 | 16 | 0 | 1 | 0 | 3 | 25 | 38 | 63 | |||||||||||||||||||||||||||||||||
2229290 | 2229290 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000175 | 300055 | Beverly: Ayers/Ryal Side School | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 70 | 5 | 11 | 0 | 2 | 0 | 4 | 50 | 42 | 92.0 | 70 | 5 | 11 | 0 | 2 | 0 | 4 | 50 | 42 | 92 | |||||||||||||||||||||||||||||||||
2229306 | 2229306 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000186 | 310005 | Billerica: Thomas Ditson | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 53 | 8 | 8 | 0 | 11 | 0 | 2 | 41 | 41 | 82.0 | 53 | 8 | 8 | 0 | 11 | 0 | 2 | 41 | 41 | 82 | |||||||||||||||||||||||||||||||||
2229313 | 2229313 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000179 | 310007 | Billerica: Frederick J Dutile | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 35 | 2 | 6 | 0 | 1 | 0 | 1 | 22 | 23 | 45.0 | 35 | 2 | 6 | 0 | 1 | 0 | 1 | 22 | 23 | 45 | |||||||||||||||||||||||||||||||||
2229320 | 2229320 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000181 | 310012 | Billerica: John F Kennedy | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 56 | 2 | 4 | 0 | 1 | 0 | 1 | 28 | 36 | 64.0 | 56 | 2 | 4 | 0 | 1 | 0 | 1 | 28 | 36 | 64 | |||||||||||||||||||||||||||||||||
2229327 | 2229327 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000184 | 310015 | Billerica: Parker | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 67 | 4 | 7 | 1 | 11 | 0 | 5 | 49 | 46 | 95.0 | 67 | 4 | 7 | 1 | 11 | 0 | 5 | 49 | 46 | 95 | |||||||||||||||||||||||||||||||||
2229334 | 2229334 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000180 | 310026 | Billerica: Hajjar Elementary | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 56 | 4 | 5 | 0 | 12 | 0 | 1 | 40 | 38 | 78.0 | 56 | 4 | 5 | 0 | 12 | 0 | 1 | 40 | 38 | 78 | |||||||||||||||||||||||||||||||||
2229341 | 2229341 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000178 | 310030 | Billerica: Eugene C Vining | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 26 | 3 | 3 | 0 | 1 | 0 | 1 | 19 | 15 | 34.0 | 26 | 3 | 3 | 0 | 1 | 0 | 1 | 19 | 15 | 34 | |||||||||||||||||||||||||||||||||
2229363 | 2229363 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001768 | 350001 | Boston: Lee Academy | Regular School | No | Elementary | PK | 03 | 2018 | grade_2 | 2 | 30 | 15 | 0 | 4 | 1 | 0 | 27 | 25 | 52.0 | 2 | 30 | 15 | 0 | 4 | 1 | 0 | 27 | 25 | 52 | |||||||||||||||||||||||||||||||||
2229372 | 2229372 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002458 | 350004 | Boston: Lyon K-8 | Regular School | No | Elementary | KG | 08 | 2018 | grade_2 | 9 | 1 | 1 | 0 | 0 | 0 | 3 | 6 | 8 | 14.0 | 9 | 1 | 1 | 0 | 0 | 0 | 3 | 6 | 8 | 14 | |||||||||||||||||||||||||||||||||
2229387 | 2229387 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001115 | 350008 | Boston: Dr. Catherine Ellison-Rosa Parks Early Ed School | Regular School | No | Elementary | PK | 03 | 2018 | grade_2 | 0 | 18 | 20 | 0 | 0 | 0 | 0 | 17 | 21 | 38.0 | 0 | 18 | 20 | 0 | 0 | 0 | 0 | 17 | 21 | 38 | |||||||||||||||||||||||||||||||||
2229401 | 2229401 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston: Boston Teachers Union School | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 7 | 2 | 7 | 0 | 0 | 0 | 3 | 8 | 11 | 19.0 | 7 | 2 | 7 | 0 | 0 | 0 | 3 | 8 | 11 | 19 | |||||||||||||||||||||||||||||||||
2229412 | 2229412 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000251 | 350013 | Boston: Jackson Mann | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 5 | 27 | 24 | 0 | 13 | 0 | 5 | 39 | 35 | 74.0 | 5 | 27 | 24 | 0 | 13 | 0 | 5 | 39 | 35 | 74 | |||||||||||||||||||||||||||||||||
2229423 | 2229423 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002839 | 350014 | Boston: Pauline Agassiz Shaw Elementary School | Regular School | No | Elementary | PK | 03 | 2018 | grade_2 | 3 | 29 | 6 | 0 | 3 | 0 | 4 | 26 | 19 | 45.0 | 3 | 29 | 6 | 0 | 3 | 0 | 4 | 26 | 19 | 45 | |||||||||||||||||||||||||||||||||
2229429 | 2229429 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002806 | 350015 | Boston: Higginson | Regular School | No | Elementary | PK | 02 | 2018 | grade_2 | 0 | 18 | 25 | 1 | 1 | 0 | 0 | 22 | 23 | 45.0 | 0 | 18 | 25 | 1 | 1 | 0 | 0 | 22 | 23 | 45 | |||||||||||||||||||||||||||||||||
2229438 | 2229438 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002622 | 350020 | Boston: Curley K-8 School | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 14 | 18 | 36 | 0 | 3 | 1 | 7 | 34 | 45 | 79.0 | 14 | 18 | 36 | 0 | 3 | 1 | 7 | 34 | 45 | 79 | |||||||||||||||||||||||||||||||||
2229449 | 2229449 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000198 | 350021 | Boston: Beethoven | Regular School | No | Elementary | PK | 03 | 2018 | grade_2 | 40 | 32 | 16 | 0 | 3 | 0 | 2 | 44 | 49 | 93.0 | 40 | 32 | 16 | 0 | 3 | 0 | 2 | 44 | 49 | 93 | |||||||||||||||||||||||||||||||||
2229461 | 2229461 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000214 | 350052 | Boston: Charles Sumner | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 11 | 18 | 55 | 0 | 1 | 0 | 5 | 41 | 49 | 90.0 | 11 | 18 | 55 | 0 | 1 | 0 | 5 | 41 | 49 | 90 | |||||||||||||||||||||||||||||||||
2229469 | 2229469 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000213 | 350054 | Boston: Charles H Taylor | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 0 | 54 | 13 | 1 | 1 | 0 | 3 | 38 | 34 | 72.0 | 0 | 54 | 13 | 1 | 1 | 0 | 3 | 38 | 34 | 72 | |||||||||||||||||||||||||||||||||
2229477 | 2229477 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000218 | 350062 | Boston: Curtis Guild | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 9 | 1 | 31 | 0 | 0 | 0 | 0 | 20 | 21 | 41.0 | 9 | 1 | 31 | 0 | 0 | 0 | 0 | 20 | 21 | 41 | |||||||||||||||||||||||||||||||||
2229485 | 2229485 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002835 | 350066 | Boston: Dante Alighieri Montessori School | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 5 | 0 | 5 | 0 | 0 | 0 | 2 | 6 | 6 | 12.0 | 5 | 0 | 5 | 0 | 0 | 0 | 2 | 6 | 6 | 12 | |||||||||||||||||||||||||||||||||
2229493 | 2229493 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000220 | 350072 | Boston: David A Ellis | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 1 | 26 | 39 | 1 | 0 | 0 | 1 | 34 | 34 | 68.0 | 1 | 26 | 39 | 1 | 0 | 0 | 1 | 34 | 34 | 68 | |||||||||||||||||||||||||||||||||
2229509 | 2229509 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000223 | 350077 | Boston: Dennis C Haley | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 12 | 16 | 12 | 0 | 0 | 0 | 5 | 25 | 20 | 45.0 | 12 | 16 | 12 | 0 | 0 | 0 | 5 | 25 | 20 | 45 | |||||||||||||||||||||||||||||||||
2229520 | 2229520 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000224 | 350080 | Boston: Donald Mckay | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 7 | 1 | 78 | 0 | 0 | 0 | 3 | 40 | 49 | 89.0 | 7 | 1 | 78 | 0 | 0 | 0 | 3 | 40 | 49 | 89 | |||||||||||||||||||||||||||||||||
2229531 | 2229531 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000227 | 350088 | Boston: Edward Everett | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 2 | 20 | 10 | 0 | 7 | 0 | 0 | 22 | 17 | 39.0 | 2 | 20 | 10 | 0 | 7 | 0 | 0 | 22 | 17 | 39 | |||||||||||||||||||||||||||||||||
2229539 | 2229539 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Boston: Eliot Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 55 | 3 | 10 | 0 | 5 | 0 | 6 | 41 | 38 | 79.0 | 55 | 3 | 10 | 0 | 5 | 0 | 6 | 41 | 38 | 79 | |||||||||||||||||||||||||||||||||
2229550 | 2229550 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000232 | 350100 | Boston: Ellis Mendell | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 16 | 7 | 13 | 1 | 0 | 0 | 4 | 23 | 18 | 41.0 | 16 | 7 | 13 | 1 | 0 | 0 | 4 | 23 | 18 | 41 | |||||||||||||||||||||||||||||||||
2229558 | 2229558 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000239 | 350116 | Boston: Franklin D Roosevelt | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 12 | 10 | 17 | 0 | 2 | 1 | 1 | 26 | 17 | 43.0 | 12 | 10 | 17 | 0 | 2 | 1 | 1 | 26 | 17 | 43 | |||||||||||||||||||||||||||||||||
2229569 | 2229569 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000241 | 350122 | Boston: George H Conley | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 10 | 17 | 17 | 0 | 2 | 0 | 2 | 24 | 24 | 48.0 | 10 | 17 | 17 | 0 | 2 | 0 | 2 | 24 | 24 | 48 | |||||||||||||||||||||||||||||||||
2229577 | 2229577 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000247 | 350135 | Boston: Henry Grew | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 5 | 11 | 16 | 0 | 0 | 0 | 1 | 13 | 20 | 33.0 | 5 | 11 | 16 | 0 | 0 | 0 | 1 | 13 | 20 | 33 | |||||||||||||||||||||||||||||||||
2229585 | 2229585 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002569 | 350138 | Boston: O W Holmes | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 0 | 31 | 15 | 0 | 2 | 0 | 8 | 36 | 20 | 56.0 | 0 | 31 | 15 | 0 | 2 | 0 | 8 | 36 | 20 | 56 | |||||||||||||||||||||||||||||||||
2229593 | 2229593 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000249 | 350141 | Boston: Hugh Roe O'Donnell | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 1 | 2 | 35 | 0 | 0 | 0 | 0 | 18 | 20 | 38.0 | 1 | 2 | 35 | 0 | 0 | 0 | 0 | 18 | 20 | 38 | |||||||||||||||||||||||||||||||||
2229601 | 2229601 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000254 | 350146 | Boston: James Condon Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 22 | 29 | 25 | 0 | 2 | 0 | 3 | 40 | 41 | 81.0 | 22 | 29 | 25 | 0 | 2 | 0 | 3 | 40 | 41 | 81 | |||||||||||||||||||||||||||||||||
2229611 | 2229611 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000259 | 350153 | Boston: James W Hennigan | Regular School | No | Elementary | KG | 08 | 2018 | grade_2 | 1 | 19 | 36 | 0 | 1 | 0 | 0 | 25 | 32 | 57.0 | 1 | 19 | 36 | 0 | 1 | 0 | 0 | 25 | 32 | 57 | |||||||||||||||||||||||||||||||||
2229622 | 2229622 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000255 | 350154 | Boston: James J Chittick | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 3 | 30 | 9 | 0 | 1 | 0 | 0 | 25 | 18 | 43.0 | 3 | 30 | 9 | 0 | 1 | 0 | 0 | 25 | 18 | 43 | |||||||||||||||||||||||||||||||||
2229630 | 2229630 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000257 | 350156 | Boston: James Otis | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 19 | 4 | 35 | 0 | 1 | 0 | 1 | 30 | 30 | 60.0 | 19 | 4 | 35 | 0 | 1 | 0 | 1 | 30 | 30 | 60 | |||||||||||||||||||||||||||||||||
2229638 | 2229638 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000265 | 350166 | Boston: John F Kennedy | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 4 | 15 | 41 | 0 | 2 | 0 | 1 | 29 | 34 | 63.0 | 4 | 15 | 41 | 0 | 2 | 0 | 1 | 29 | 34 | 63 | |||||||||||||||||||||||||||||||||
2229646 | 2229646 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000268 | 350167 | Boston: UP Academy Holland | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 3 | 43 | 50 | 0 | 12 | 0 | 6 | 50 | 64 | 114.0 | 3 | 43 | 50 | 0 | 12 | 0 | 6 | 50 | 64 | 114 | |||||||||||||||||||||||||||||||||
2229654 | 2229654 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000264 | 350172 | Boston: John D Philbrick | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 4 | 13 | 5 | 0 | 0 | 0 | 0 | 13 | 9 | 22.0 | 4 | 13 | 5 | 0 | 0 | 0 | 0 | 13 | 9 | 22 | |||||||||||||||||||||||||||||||||
2229666 | 2229666 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000270 | 350180 | Boston: John Winthrop | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 0 | 24 | 13 | 0 | 2 | 0 | 2 | 18 | 23 | 41.0 | 0 | 24 | 13 | 0 | 2 | 0 | 2 | 18 | 23 | 41 | |||||||||||||||||||||||||||||||||
2229674 | 2229674 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000275 | 350181 | Boston: Joseph P Tynan | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 8 | 13 | 7 | 0 | 2 | 0 | 1 | 20 | 11 | 31.0 | 8 | 13 | 7 | 0 | 2 | 0 | 1 | 20 | 11 | 31 | |||||||||||||||||||||||||||||||||
2229682 | 2229682 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Boston: Joseph J Hurley | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 10 | 5 | 33 | 0 | 0 | 0 | 1 | 28 | 21 | 49.0 | 10 | 5 | 33 | 0 | 0 | 0 | 1 | 28 | 21 | 49 | |||||||||||||||||||||||||||||||||
2229693 | 2229693 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000273 | 350183 | Boston: Joseph Lee | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 5 | 34 | 13 | 0 | 0 | 0 | 1 | 32 | 21 | 53.0 | 5 | 34 | 13 | 0 | 0 | 0 | 1 | 32 | 21 | 53 | |||||||||||||||||||||||||||||||||
2229704 | 2229704 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000274 | 350184 | Boston: Joseph P Manning | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 10 | 5 | 7 | 0 | 1 | 0 | 1 | 13 | 11 | 24.0 | 10 | 5 | 7 | 0 | 1 | 0 | 1 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
2229712 | 2229712 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000278 | 350190 | Boston: Joyce Kilmer | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 22 | 8 | 8 | 0 | 1 | 0 | 5 | 27 | 17 | 44.0 | 22 | 8 | 8 | 0 | 1 | 0 | 5 | 27 | 17 | 44 | |||||||||||||||||||||||||||||||||
2229723 | 2229723 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000244 | 350200 | Boston: Harvard-Kent | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 0 | 20 | 23 | 0 | 16 | 0 | 3 | 42 | 20 | 62.0 | 0 | 20 | 23 | 0 | 16 | 0 | 3 | 42 | 20 | 62 | |||||||||||||||||||||||||||||||||
2229731 | 2229731 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000283 | 350215 | Boston: Manassah E Bradley | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 16 | 1 | 22 | 0 | 2 | 0 | 1 | 28 | 14 | 42.0 | 16 | 1 | 22 | 0 | 2 | 0 | 1 | 28 | 14 | 42 | |||||||||||||||||||||||||||||||||
2229739 | 2229739 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000289 | 350227 | Boston: Mather | Regular School | No | Elementary | PK | 05 | 2018 | grade_2 | 8 | 36 | 13 | 1 | 32 | 0 | 3 | 47 | 46 | 93.0 | 8 | 36 | 13 | 1 | 32 | 0 | 3 | 47 | 46 | 93 | |||||||||||||||||||||||||||||||||
2229747 | 2229747 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Boston: Maurice J Tobin | Regular School | No | Elementary | PK | 08 | 2018 | grade_2 | 1 | 19 | 36 | 1 | 0 | 0 | 2 | 31 | 28 | 59.0 | 1 | 19 | 36 | 1 | 0 | 0 | 2 | 31 | 28 | 59 | |||||||||||||||||||||||||||||||||
2229757 | 2229757 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000292 | 350231 | Boston: Michael J Perkins | Regular School | No | Elementary | KG | 05 | 2018 | grade_2 | 5 | 18 | 10 | 0 | 0 | 0 | 2 | 14 | 21 | 35.0 | 5 | 18 | 10 | 0 | 0 | 0 | 2 | 14 | 21 | 35 |
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]);