enrollments
Data source: Big Local News · About: Big Local
971 rows where grade = "kindergarten", state = "MA" and year = 2018 sorted by female
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2230202 | 2230202 | MA | Suffolk | school | 35 | Boston | 350652 | 2018 | kindergarten | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2231636 | 2231636 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002858 | 950515 | Fall River: Fall River Gateway to College @ BCC | Regular School | No | High | 12 | 12 | 2018 | kindergarten | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2232014 | 2232014 | MA | Dukes | school | 2505340 | 109 | Gosnold | 250534000725 | 1090005 | Gosnold: Cuttyhunk Elementary | Regular School | No | Middle | 07 | 08 | 2018 | kindergarten | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2233064 | 2233064 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002726 | 1600085 | Lowell: Laura Lee Therapeutic Day School | Regular School | No | Middle | KG | 08 | 2018 | kindergarten | * | * | * | * | * | * | * | 1 | * | 1.0 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||
2237220 | 2237220 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002790 | 3320515 | West Springfield: 21st Century Skills Academy | Regular School | No | High | 12 | 12 | 2018 | kindergarten | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2230663 | 2230663 | MA | Middlesex | school | 2503240 | 48 | Burlington | 250324000426 | 480505 | Burlington: Burlington High | Regular School | No | High | 09 | 12 | 2018 | kindergarten | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 1 | 9.0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 1 | 9 | |||||||||||||||||||||||||||||||||
2232128 | 2232128 | MA | Berkshire | school | 2505760 | 121 | Hancock | 250576000826 | 1210005 | Hancock: Hancock Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | * | * | * | * | * | * | * | 3 | 1 | 4.0 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||
2234716 | 2234716 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001461 | 2200025 | Norwood: Charles J Prescott | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | * | * | * | * | * | * | * | 2 | 1 | 3.0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||||
2237204 | 2237204 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002050 | 3320040 | West Springfield: Tatham | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | * | * | * | * | * | * | * | 1 | 1 | 2.0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
2229651 | 2229651 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000264 | 350172 | Boston: John D Philbrick | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 4 | 10 | 6 | 0 | 0 | 0 | 0 | 10 | 10 | 20.0 | 4 | 10 | 6 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
2230329 | 2230329 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000365 | 400015 | Braintree: Highlands | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 17 | 0 | 0 | 0 | 4 | 0 | 0 | 11 | 10 | 21.0 | 17 | 0 | 0 | 0 | 4 | 0 | 0 | 11 | 10 | 21 | |||||||||||||||||||||||||||||||||
2232175 | 2232175 | MA | Hampshire | school | 2505940 | 127 | Hatfield | 250594000843 | 1270005 | Hatfield: Hatfield Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 20.0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
2233043 | 2233043 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001051 | 1600055 | Lowell: Washington | Regular School | No | Elementary | PK | 04 | 2018 | kindergarten | 6 | 2 | 8 | 0 | 22 | 0 | 4 | 32 | 10 | 42.0 | 6 | 2 | 8 | 0 | 22 | 0 | 4 | 32 | 10 | 42 | |||||||||||||||||||||||||||||||||
2237344 | 2237344 | MA | Franklin | school | 2512870 | 337 | Whately | 251287002126 | 3370005 | Whately: Whately Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 13 | 0 | 3 | 0 | 0 | 0 | 1 | 7 | 10 | 17.0 | 13 | 0 | 3 | 0 | 0 | 0 | 1 | 7 | 10 | 17 | |||||||||||||||||||||||||||||||||
2238636 | 2238636 | MA | Worcester | school | 2502160 | 615 | Athol-Royalston | 250216000931 | 6150050 | Athol-Royalston: Royalston Community School | Regular School | No | Elementary | KG | 06 | 2018 | kindergarten | 17 | 1 | 0 | 0 | 0 | 0 | 2 | 10 | 10 | 20.0 | 17 | 1 | 0 | 0 | 0 | 0 | 2 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
2230327 | 2230327 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294002789 | 400009 | Braintree: Monatiquot Kindergarten Center | Regular School | No | Elementary | KG | KG | 2018 | kindergarten | 175 | 11 | 13 | 0 | 46 | 1 | 4 | 149 | 101 | 250.0 | 175 | 11 | 13 | 0 | 46 | 1 | 4 | 149 | 101 | 250 | |||||||||||||||||||||||||||||||||
2228992 | 2228992 | MA | Middlesex | school | 2502100 | 14 | Ashland | 250210000072 | 140010 | Ashland: Henry E Warren Elementary | Regular School | No | Elementary | KG | 02 | 2018 | kindergarten | 122 | 9 | 24 | 0 | 37 | 0 | 10 | 100 | 102 | 202.0 | 122 | 9 | 24 | 0 | 37 | 0 | 10 | 100 | 102 | 202 | |||||||||||||||||||||||||||||||||
2231931 | 2231931 | MA | Worcester | school | 2505130 | 103 | Gardner | 250513000755 | 1030020 | Gardner: Waterford Street | Regular School | No | Elementary | PK | 01 | 2018 | kindergarten | 141 | 6 | 42 | 0 | 4 | 0 | 12 | 103 | 102 | 205.0 | 141 | 6 | 42 | 0 | 4 | 0 | 12 | 103 | 102 | 205 | |||||||||||||||||||||||||||||||||
2233421 | 2233421 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001111 | 1670007 | Mansfield: Everett W Robinson | Regular School | No | Elementary | KG | 02 | 2018 | kindergarten | 176 | 5 | 8 | 0 | 21 | 0 | 13 | 121 | 102 | 223.0 | 176 | 5 | 8 | 0 | 21 | 0 | 13 | 121 | 102 | 223 | |||||||||||||||||||||||||||||||||
2236785 | 2236785 | MA | Plymouth | school | 2512060 | 310 | Wareham | 251206001988 | 3100003 | Wareham: John William Decas | Regular School | No | Elementary | KG | 02 | 2018 | kindergarten | 160 | 15 | 17 | 4 | 2 | 0 | 24 | 119 | 103 | 222.0 | 160 | 15 | 17 | 4 | 2 | 0 | 24 | 119 | 103 | 222 | |||||||||||||||||||||||||||||||||
2232464 | 2232464 | MA | Middlesex | school | 2506330 | 139 | Hopkinton | 250633000918 | 1390005 | Hopkinton: Center | Regular School | No | Elementary | KG | 01 | 2018 | kindergarten | 141 | 1 | 6 | 0 | 45 | 0 | 9 | 97 | 105 | 202.0 | 141 | 1 | 6 | 0 | 45 | 0 | 9 | 97 | 105 | 202 | |||||||||||||||||||||||||||||||||
2238729 | 2238729 | MA | Bristol | school | 2503030 | 625 | Bridgewater-Raynham | 250303002643 | 6250002 | Bridgewater-Raynham: Mitchell Elementary School | Regular School | No | Elementary | PK | 03 | 2018 | kindergarten | 230 | 4 | 0 | 0 | 2 | 1 | 2 | 134 | 105 | 239.0 | 230 | 4 | 0 | 0 | 2 | 1 | 2 | 134 | 105 | 239 | |||||||||||||||||||||||||||||||||
2229137 | 2229137 | MA | Middlesex | school | 2502400 | 23 | Bedford | 250240000131 | 230010 | Bedford: Lt Elezer Davis | Regular School | No | Elementary | KG | 02 | 2018 | kindergarten | 116 | 12 | 9 | 0 | 42 | 0 | 18 | 88 | 109 | 197.0 | 116 | 12 | 9 | 0 | 42 | 0 | 18 | 88 | 109 | 197 | |||||||||||||||||||||||||||||||||
2229848 | 2229848 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000308 | 350278 | Boston: Phineas Bates | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 11 | 10 | 14 | 0 | 2 | 0 | 0 | 26 | 11 | 37.0 | 11 | 10 | 14 | 0 | 2 | 0 | 0 | 26 | 11 | 37 | |||||||||||||||||||||||||||||||||
2230349 | 2230349 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000360 | 400033 | Braintree: Archie T Morrison | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 14 | 2 | 0 | 0 | 4 | 0 | 0 | 9 | 11 | 20.0 | 14 | 2 | 0 | 0 | 4 | 0 | 0 | 9 | 11 | 20 | |||||||||||||||||||||||||||||||||
2235125 | 2235125 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001560 | 2430040 | Quincy: Atherton Hough | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 19 | 1 | 2 | 0 | 15 | 0 | 0 | 26 | 11 | 37.0 | 19 | 1 | 2 | 0 | 15 | 0 | 0 | 26 | 11 | 37 | |||||||||||||||||||||||||||||||||
2235552 | 2235552 | MA | Essex | school | 2510500 | 262 | Saugus | 251050001677 | 2620067 | Saugus: Douglas Waybright | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 22 | 0 | 1 | 0 | 1 | 0 | 0 | 13 | 11 | 24.0 | 22 | 0 | 1 | 0 | 1 | 0 | 0 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
2236554 | 2236554 | MA | Dukes | school | 2512570 | 296 | Tisbury | 251257002054 | 2960005 | Tisbury: Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2018 | kindergarten | 18 | 0 | 4 | 1 | 0 | 0 | 1 | 13 | 11 | 24.0 | 18 | 0 | 4 | 1 | 0 | 0 | 1 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
2236575 | 2236575 | MA | Barnstable | school | 2511730 | 300 | Truro | 251173001930 | 3000005 | Truro: Truro Central | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 11 | 0 | 1 | 0 | 0 | 0 | 3 | 4 | 11 | 15.0 | 11 | 0 | 1 | 0 | 0 | 0 | 3 | 4 | 11 | 15 | |||||||||||||||||||||||||||||||||
2238095 | 2238095 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public (District): Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2018 | kindergarten | 0 | 17 | 2 | 0 | 0 | 0 | 0 | 8 | 11 | 19.0 | 0 | 17 | 2 | 0 | 0 | 0 | 0 | 8 | 11 | 19 | |||||||||||||||||||||||||||||||||
2238787 | 2238787 | MA | Berkshire | school | 2503390 | 635 | Central Berkshire | 250339000465 | 6350035 | Central Berkshire: Kittredge | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 11 | 11 | 22.0 | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 11 | 11 | 22 | |||||||||||||||||||||||||||||||||
2229701 | 2229701 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000274 | 350184 | Boston: Joseph P Manning | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 11 | 6 | 3 | 0 | 0 | 0 | 2 | 10 | 12 | 22.0 | 11 | 6 | 3 | 0 | 0 | 0 | 2 | 10 | 12 | 22 | |||||||||||||||||||||||||||||||||
2229781 | 2229781 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000295 | 350243 | Boston: Nathan Hale | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 1 | 16 | 5 | 0 | 0 | 0 | 0 | 10 | 12 | 22.0 | 1 | 16 | 5 | 0 | 0 | 0 | 0 | 10 | 12 | 22 | |||||||||||||||||||||||||||||||||
2229789 | 2229789 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000297 | 350255 | Boston: Oliver Hazard Perry | Regular School | No | Elementary | PK | 08 | 2018 | kindergarten | 20 | 2 | 3 | 0 | 0 | 0 | 1 | 14 | 12 | 26.0 | 20 | 2 | 3 | 0 | 0 | 0 | 1 | 14 | 12 | 26 | |||||||||||||||||||||||||||||||||
2230356 | 2230356 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000363 | 400050 | Braintree: Donald Ross | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 12 | 1 | 0 | 0 | 6 | 0 | 0 | 7 | 12 | 19.0 | 12 | 1 | 0 | 0 | 6 | 0 | 0 | 7 | 12 | 19 | |||||||||||||||||||||||||||||||||
2232327 | 2232327 | MA | Hampden | school | 2506210 | 135 | Holland | 250621000889 | 1350005 | Holland: Holland Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 22 | 1 | 5 | 1 | 0 | 0 | 0 | 17 | 12 | 29.0 | 22 | 1 | 5 | 1 | 0 | 0 | 0 | 17 | 12 | 29 | |||||||||||||||||||||||||||||||||
2234169 | 2234169 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001330 | 2010130 | New Bedford: Jireh Swift | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 14 | 1 | 6 | 0 | 0 | 0 | 2 | 11 | 12 | 23.0 | 14 | 1 | 6 | 0 | 0 | 0 | 2 | 11 | 12 | 23 | |||||||||||||||||||||||||||||||||
2235998 | 2235998 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001562 | 2810068 | Springfield: Glickman Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 7 | 9 | 18 | 1 | 0 | 0 | 3 | 26 | 12 | 38.0 | 7 | 9 | 18 | 1 | 0 | 0 | 3 | 26 | 12 | 38 | |||||||||||||||||||||||||||||||||
2236118 | 2236118 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001835 | 2810180 | Springfield: Warner | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 5 | 3 | 23 | 0 | 0 | 0 | 2 | 21 | 12 | 33.0 | 5 | 3 | 23 | 0 | 0 | 0 | 2 | 21 | 12 | 33 | |||||||||||||||||||||||||||||||||
2236708 | 2236708 | MA | Middlesex | school | 2512000 | 308 | Waltham | 251200002863 | 3080001 | Waltham: Waltham Public Schools Dual Language Program | Regular School | No | Elementary | KG | 01 | 2018 | kindergarten | 9 | 1 | 29 | 0 | 0 | 0 | 0 | 27 | 12 | 39.0 | 9 | 1 | 29 | 0 | 0 | 0 | 0 | 27 | 12 | 39 | |||||||||||||||||||||||||||||||||
2237300 | 2237300 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284000509 | 3360060 | Weymouth: Thomas V Nash | Regular School | No | Elementary | KG | 04 | 2018 | kindergarten | 22 | 2 | 2 | 0 | 0 | 0 | 1 | 15 | 12 | 27.0 | 22 | 2 | 2 | 0 | 0 | 0 | 1 | 15 | 12 | 27 | |||||||||||||||||||||||||||||||||
2237532 | 2237532 | MA | Middlesex | school | 2513200 | 347 | Woburn | 251320002194 | 3470060 | Woburn: Wyman | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 24 | 0 | 2 | 0 | 2 | 0 | 0 | 16 | 12 | 28.0 | 24 | 0 | 2 | 0 | 2 | 0 | 0 | 16 | 12 | 28 | |||||||||||||||||||||||||||||||||
2239462 | 2239462 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102401 | 7530020 | Quabbin: New Braintree Grade | Regular School | No | Elementary | KG | 01 | 2018 | kindergarten | 29 | 0 | 4 | 0 | 0 | 0 | 1 | 22 | 12 | 34.0 | 29 | 0 | 4 | 0 | 0 | 0 | 1 | 22 | 12 | 34 | |||||||||||||||||||||||||||||||||
2240010 | 2240010 | MA | Franklin | school | 2500551 | 3901 | Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District | 250055102808 | 39010900 | Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School | Regular School | No | Other | KG | 12 | 2018 | kindergarten | 7 | 5 | 6 | 0 | 0 | 0 | 1 | 7 | 12 | 19.0 | 7 | 5 | 6 | 0 | 0 | 0 | 1 | 7 | 12 | 19 | |||||||||||||||||||||||||||||||||
2233792 | 2233792 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777002626 | 1820011 | Middleborough: Memorial Early Childhood Center | Regular School | No | Elementary | PK | KG | 2018 | kindergarten | 202 | 6 | 11 | 2 | 1 | 0 | 10 | 108 | 124 | 232.0 | 202 | 6 | 11 | 2 | 1 | 0 | 10 | 108 | 124 | 232 | |||||||||||||||||||||||||||||||||
2235680 | 2235680 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077002496 | 2710005 | Shrewsbury: Beal School | Regular School | No | Elementary | KG | 01 | 2018 | kindergarten | 108 | 11 | 22 | 5 | 95 | 0 | 13 | 128 | 126 | 254.0 | 108 | 11 | 22 | 5 | 95 | 0 | 13 | 128 | 126 | 254 | |||||||||||||||||||||||||||||||||
2237177 | 2237177 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002504 | 3320005 | West Springfield: John Ashley | Regular School | No | Elementary | KG | KG | 2018 | kindergarten | 166 | 4 | 42 | 0 | 15 | 0 | 7 | 108 | 126 | 234.0 | 166 | 4 | 42 | 0 | 15 | 0 | 7 | 108 | 126 | 234 | |||||||||||||||||||||||||||||||||
2229339 | 2229339 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000178 | 310030 | Billerica: Eugene C Vining | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 27 | 0 | 4 | 0 | 2 | 0 | 2 | 22 | 13 | 35.0 | 27 | 0 | 4 | 0 | 2 | 0 | 2 | 22 | 13 | 35 | |||||||||||||||||||||||||||||||||
2230028 | 2230028 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000946 | 350382 | Boston: Mission Hill School | Regular School | No | Elementary | PK | 08 | 2018 | kindergarten | 10 | 5 | 3 | 0 | 1 | 0 | 2 | 8 | 13 | 21.0 | 10 | 5 | 3 | 0 | 1 | 0 | 2 | 8 | 13 | 21 | |||||||||||||||||||||||||||||||||
2230336 | 2230336 | MA | Norfolk | school | 2502940 | 40 | Braintree | 250294000367 | 400020 | Braintree: Mary E Flaherty School | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 14 | 0 | 0 | 0 | 5 | 0 | 3 | 9 | 13 | 22.0 | 14 | 0 | 0 | 0 | 5 | 0 | 3 | 9 | 13 | 22 | |||||||||||||||||||||||||||||||||
2232104 | 2232104 | MA | Hampshire | school | 2505580 | 117 | Hadley | 250558000879 | 1170015 | Hadley: Hadley Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 19 | 3 | 1 | 0 | 0 | 0 | 1 | 11 | 13 | 24.0 | 19 | 3 | 1 | 0 | 0 | 0 | 1 | 11 | 13 | 24 | |||||||||||||||||||||||||||||||||
2234108 | 2234108 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001323 | 2010075 | New Bedford: Ellen R Hathaway | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 12 | 4 | 20 | 0 | 1 | 0 | 4 | 28 | 13 | 41.0 | 12 | 4 | 20 | 0 | 1 | 0 | 4 | 28 | 13 | 41 | |||||||||||||||||||||||||||||||||
2234508 | 2234508 | MA | Bristol | school | 2508730 | 212 | North Attleborough | 250873001402 | 2120010 | North Attleborough: Falls | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 21 | 1 | 3 | 0 | 0 | 0 | 1 | 13 | 13 | 26.0 | 21 | 1 | 3 | 0 | 0 | 0 | 1 | 13 | 13 | 26 | |||||||||||||||||||||||||||||||||
2234568 | 2234568 | MA | Worcester | school | 2508880 | 213 | Northborough | 250888001208 | 2130020 | Northborough: Marion E Zeh | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 27 | 0 | 1 | 0 | 5 | 0 | 2 | 22 | 13 | 35.0 | 27 | 0 | 1 | 0 | 5 | 0 | 2 | 22 | 13 | 35 | |||||||||||||||||||||||||||||||||
2236104 | 2236104 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001795 | 2810165 | Springfield: Arthur T Talmadge | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 5 | 8 | 28 | 0 | 0 | 0 | 2 | 30 | 13 | 43.0 | 5 | 8 | 28 | 0 | 0 | 0 | 2 | 30 | 13 | 43 | |||||||||||||||||||||||||||||||||
2237318 | 2237318 | MA | Norfolk | school | 2512840 | 336 | Weymouth | 251284002116 | 3360085 | Weymouth: Ralph Talbot | Regular School | No | Elementary | KG | 04 | 2018 | kindergarten | 22 | 4 | 7 | 0 | 4 | 0 | 1 | 25 | 13 | 38.0 | 22 | 4 | 7 | 0 | 4 | 0 | 1 | 25 | 13 | 38 | |||||||||||||||||||||||||||||||||
2239062 | 2239062 | MA | Hampden | school | 2505730 | 680 | Hampden-Wilbraham | 250573000822 | 6800005 | Hampden-Wilbraham: Green Meadows Elementary | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 30 | 1 | 0 | 0 | 0 | 0 | 1 | 19 | 13 | 32.0 | 30 | 1 | 0 | 0 | 0 | 0 | 1 | 19 | 13 | 32 | |||||||||||||||||||||||||||||||||
2239334 | 2239334 | MA | Middlesex | school | 2508790 | 735 | North Middlesex | 250879001412 | 7350010 | North Middlesex: Ashby Elementary | Regular School | No | Elementary | KG | 04 | 2018 | kindergarten | 33 | 1 | 1 | 0 | 0 | 0 | 0 | 22 | 13 | 35.0 | 33 | 1 | 1 | 0 | 0 | 0 | 0 | 22 | 13 | 35 | |||||||||||||||||||||||||||||||||
2239526 | 2239526 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104000428 | 7650035 | Southern Berkshire: Undermountain | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 31 | 0 | 2 | 0 | 0 | 0 | 1 | 21 | 13 | 34.0 | 31 | 0 | 2 | 0 | 0 | 0 | 1 | 21 | 13 | 34 | |||||||||||||||||||||||||||||||||
2229380 | 2229380 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002514 | 350006 | Boston: ELC - West Zone | Regular School | No | Elementary | PK | 01 | 2018 | kindergarten | 5 | 11 | 17 | 0 | 1 | 0 | 2 | 22 | 14 | 36.0 | 5 | 11 | 17 | 0 | 1 | 0 | 2 | 22 | 14 | 36 | |||||||||||||||||||||||||||||||||
2229929 | 2229929 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000338 | 350360 | Boston: William Ellery Channing | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 4 | 20 | 13 | 0 | 0 | 0 | 0 | 23 | 14 | 37.0 | 4 | 20 | 13 | 0 | 0 | 0 | 0 | 23 | 14 | 37 | |||||||||||||||||||||||||||||||||
2231022 | 2231022 | MA | Berkshire | school | 2503720 | 63 | Clarksburg | 250372000510 | 630010 | Clarksburg: Clarksburg Elementary | Regular School | No | Elementary | KG | 08 | 2018 | kindergarten | 29 | 0 | 0 | 0 | 0 | 0 | 2 | 17 | 14 | 31.0 | 29 | 0 | 0 | 0 | 0 | 0 | 2 | 17 | 14 | 31 | |||||||||||||||||||||||||||||||||
2231118 | 2231118 | MA | Essex | school | 2503990 | 71 | Danvers | 250399000536 | 710030 | Danvers: Riverside | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 34 | 1 | 6 | 0 | 0 | 0 | 1 | 28 | 14 | 42.0 | 34 | 1 | 6 | 0 | 0 | 0 | 1 | 28 | 14 | 42 | |||||||||||||||||||||||||||||||||
2232563 | 2232563 | MA | Berkshire | school | 2506630 | 148 | Lanesborough | 250663000949 | 1480005 | Lanesborough: Lanesborough Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 23 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 14 | 25.0 | 23 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 14 | 25 | |||||||||||||||||||||||||||||||||
2233261 | 2233261 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001081 | 1630075 | Lynn: Lynn Woods | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 15 | 0 | 5 | 0 | 3 | 0 | 2 | 11 | 14 | 25.0 | 15 | 0 | 5 | 0 | 3 | 0 | 2 | 11 | 14 | 25 | |||||||||||||||||||||||||||||||||
2234326 | 2234326 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001369 | 2070120 | Newton: John Ward | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 26 | 0 | 2 | 0 | 4 | 0 | 3 | 21 | 14 | 35.0 | 26 | 0 | 2 | 0 | 4 | 0 | 3 | 21 | 14 | 35 | |||||||||||||||||||||||||||||||||
2234735 | 2234735 | MA | Dukes | school | 2504650 | 221 | Oak Bluffs | 250465000625 | 2210005 | Oak Bluffs: Oak Bluffs Elementary | Regular School | No | Elementary | PK | 08 | 2018 | kindergarten | 10 | 1 | 13 | 1 | 1 | 0 | 3 | 15 | 14 | 29.0 | 10 | 1 | 13 | 1 | 1 | 0 | 3 | 15 | 14 | 29 | |||||||||||||||||||||||||||||||||
2234810 | 2234810 | MA | Essex | school | 2509360 | 229 | Peabody | 250936001496 | 2290007 | Peabody: John E Burke | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 14 | 30.0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 14 | 30 | |||||||||||||||||||||||||||||||||
2235991 | 2235991 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001805 | 2810065 | Springfield: Glenwood | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 7 | 3 | 28 | 0 | 1 | 0 | 2 | 27 | 14 | 41.0 | 7 | 3 | 28 | 0 | 1 | 0 | 2 | 27 | 14 | 41 | |||||||||||||||||||||||||||||||||
2236307 | 2236307 | MA | Norfolk | school | 2511250 | 285 | Stoughton | 251125001863 | 2850015 | Stoughton: South Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 15 | 5 | 2 | 0 | 3 | 0 | 3 | 14 | 14 | 28.0 | 15 | 5 | 2 | 0 | 3 | 0 | 3 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||
2239559 | 2239559 | MA | Worcester | school | 2500002 | 767 | Spencer-E Brookfield | 250000201766 | 7670008 | Spencer-E Brookfield: East Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 26 | 0 | 2 | 0 | 0 | 0 | 0 | 14 | 14 | 28.0 | 26 | 0 | 2 | 0 | 0 | 0 | 0 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||
2239639 | 2239639 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | Up-Island Regional: West Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2018 | kindergarten | 23 | 0 | 5 | 0 | 0 | 0 | 4 | 18 | 14 | 32.0 | 23 | 0 | 5 | 0 | 0 | 0 | 4 | 18 | 14 | 32 | |||||||||||||||||||||||||||||||||
2239683 | 2239683 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188001492 | 7750040 | Wachusett: Paxton Center | Regular School | No | Elementary | KG | 08 | 2018 | kindergarten | 24 | 0 | 0 | 0 | 0 | 0 | 2 | 12 | 14 | 26.0 | 24 | 0 | 0 | 0 | 0 | 0 | 2 | 12 | 14 | 26 | |||||||||||||||||||||||||||||||||
2234723 | 2234723 | MA | Norfolk | school | 2509060 | 220 | Norwood | 250906001557 | 2200075 | Norwood: George F. Willett | Regular School | No | Elementary | PK | KG | 2018 | kindergarten | 168 | 24 | 35 | 0 | 42 | 5 | 6 | 140 | 140 | 280.0 | 168 | 24 | 35 | 0 | 42 | 5 | 6 | 140 | 140 | 280 | |||||||||||||||||||||||||||||||||
2229671 | 2229671 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000275 | 350181 | Boston: Joseph P Tynan | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 4 | 10 | 9 | 0 | 1 | 0 | 1 | 10 | 15 | 25.0 | 4 | 10 | 9 | 0 | 1 | 0 | 1 | 10 | 15 | 25 | |||||||||||||||||||||||||||||||||
2229828 | 2229828 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000302 | 350264 | Boston: Patrick J Kennedy | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 1 | 0 | 34 | 0 | 2 | 0 | 0 | 22 | 15 | 37.0 | 1 | 0 | 34 | 0 | 2 | 0 | 0 | 22 | 15 | 37 | |||||||||||||||||||||||||||||||||
2229968 | 2229968 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000344 | 350374 | Boston: Winship Elementary | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 12 | 6 | 8 | 0 | 4 | 0 | 4 | 19 | 15 | 34.0 | 12 | 6 | 8 | 0 | 4 | 0 | 4 | 19 | 15 | 34 | |||||||||||||||||||||||||||||||||
2230386 | 2230386 | MA | Hampden | school | 2503060 | 43 | Brimfield | 250306000381 | 430005 | Brimfield: Brimfield Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 15 | 32.0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 15 | 32 | |||||||||||||||||||||||||||||||||
2231903 | 2231903 | MA | Norfolk | school | 2505010 | 101 | Franklin | 250501000736 | 1010035 | Franklin: Davis Thayer | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 21 | 0 | 5 | 0 | 1 | 0 | 1 | 13 | 15 | 28.0 | 21 | 0 | 5 | 0 | 1 | 0 | 1 | 13 | 15 | 28 | |||||||||||||||||||||||||||||||||
2231975 | 2231975 | MA | Essex | school | 2505280 | 107 | Gloucester | 250528000771 | 1070020 | Gloucester: East Gloucester Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 25 | 0 | 3 | 0 | 0 | 0 | 0 | 13 | 15 | 28.0 | 25 | 0 | 3 | 0 | 0 | 0 | 0 | 13 | 15 | 28 | |||||||||||||||||||||||||||||||||
2232061 | 2232061 | MA | Hampshire | school | 2505400 | 111 | Granby | 250540000791 | 1110010 | Granby: West Street | Regular School | No | Elementary | PK | 03 | 2018 | kindergarten | 37 | 0 | 2 | 0 | 1 | 0 | 3 | 28 | 15 | 43.0 | 37 | 0 | 2 | 0 | 1 | 0 | 3 | 28 | 15 | 43 | |||||||||||||||||||||||||||||||||
2232482 | 2232482 | MA | Middlesex | school | 2506390 | 141 | Hudson | 250639000924 | 1410007 | Hudson: Mulready Elementary | Regular School | No | Elementary | PK | 04 | 2018 | kindergarten | 33 | 0 | 5 | 0 | 1 | 0 | 2 | 26 | 15 | 41.0 | 33 | 0 | 5 | 0 | 1 | 0 | 2 | 26 | 15 | 41 | |||||||||||||||||||||||||||||||||
2234392 | 2234392 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001389 | 2090015 | North Adams: Greylock | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 27 | 1 | 3 | 0 | 0 | 0 | 2 | 18 | 15 | 33.0 | 27 | 1 | 3 | 0 | 0 | 0 | 2 | 18 | 15 | 33 | |||||||||||||||||||||||||||||||||
2234554 | 2234554 | MA | Worcester | school | 2508880 | 213 | Northborough | 250888001438 | 2130014 | Northborough: Marguerite E Peaslee | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 30 | 0 | 0 | 0 | 0 | 0 | 3 | 18 | 15 | 33.0 | 30 | 0 | 0 | 0 | 0 | 0 | 3 | 18 | 15 | 33 | |||||||||||||||||||||||||||||||||
2234855 | 2234855 | MA | Essex | school | 2509360 | 229 | Peabody | 250936001505 | 2290045 | Peabody: West Memorial | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 16 | 15 | 31.0 | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 16 | 15 | 31 | |||||||||||||||||||||||||||||||||
2235084 | 2235084 | MA | Plymouth | school | 2509780 | 240 | Plympton | 250978001551 | 2400010 | Plympton: Dennett Elementary | Regular School | No | Elementary | KG | 06 | 2018 | kindergarten | 28 | 0 | 1 | 0 | 0 | 0 | 1 | 15 | 15 | 30.0 | 28 | 0 | 1 | 0 | 0 | 0 | 1 | 15 | 15 | 30 | |||||||||||||||||||||||||||||||||
2235584 | 2235584 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001691 | 2640010 | Scituate: Hatherly Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 36 | 0 | 1 | 0 | 0 | 0 | 1 | 23 | 15 | 38.0 | 36 | 0 | 1 | 0 | 0 | 0 | 1 | 23 | 15 | 38 | |||||||||||||||||||||||||||||||||
2235683 | 2235683 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001713 | 2710015 | Shrewsbury: Calvin Coolidge | Regular School | No | Elementary | KG | 04 | 2018 | kindergarten | 15 | 1 | 6 | 0 | 17 | 0 | 1 | 25 | 15 | 40.0 | 15 | 1 | 6 | 0 | 17 | 0 | 1 | 25 | 15 | 40 | |||||||||||||||||||||||||||||||||
2235757 | 2235757 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001732 | 2740015 | Somerville: Benjamin G Brown | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 24 | 2 | 3 | 0 | 1 | 0 | 2 | 17 | 15 | 32.0 | 24 | 2 | 3 | 0 | 1 | 0 | 2 | 17 | 15 | 32 | |||||||||||||||||||||||||||||||||
2235817 | 2235817 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001749 | 2740120 | Somerville: Winter Hill Community | Regular School | No | Elementary | PK | 08 | 2018 | kindergarten | 14 | 6 | 7 | 0 | 4 | 0 | 1 | 17 | 15 | 32.0 | 14 | 6 | 7 | 0 | 4 | 0 | 1 | 17 | 15 | 32 | |||||||||||||||||||||||||||||||||
2237453 | 2237453 | MA | Middlesex | school | 2513110 | 344 | Winchester | 251311002164 | 3440045 | Winchester: Ambrose Elementary | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 41 | 0 | 0 | 0 | 2 | 0 | 2 | 30 | 15 | 45.0 | 41 | 0 | 0 | 0 | 2 | 0 | 2 | 30 | 15 | 45 | |||||||||||||||||||||||||||||||||
2239421 | 2239421 | MA | Franklin | school | 2509600 | 750 | Pioneer Valley | 250960002614 | 7500008 | Pioneer Valley: Northfield Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 22 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 15 | 24.0 | 22 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 15 | 24 | |||||||||||||||||||||||||||||||||
2240005 | 2240005 | MA | Worcester | school | 2500587 | 3515 | Old Sturbridge Academy Charter Public School (District) | 250058702877 | 35150205 | Old Sturbridge Academy Charter Public School (District): Old Sturbridge Academy Charter Public School | Regular School | Yes | Elementary | KG | 03 | 2018 | kindergarten | 33 | 4 | 3 | 0 | 0 | 0 | 0 | 25 | 15 | 40.0 | 33 | 4 | 3 | 0 | 0 | 0 | 0 | 25 | 15 | 40 | |||||||||||||||||||||||||||||||||
2229250 | 2229250 | MA | Worcester | school | 2502550 | 28 | Berlin | 250255000159 | 280005 | Berlin: Berlin Memorial | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 25 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 16 | 27.0 | 25 | 0 | 1 | 0 | 0 | 0 | 1 | 11 | 16 | 27 | |||||||||||||||||||||||||||||||||
2229880 | 2229880 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000322 | 350304 | Boston: Samuel W Mason | Regular School | No | Elementary | PK | 05 | 2018 | kindergarten | 2 | 15 | 12 | 2 | 2 | 0 | 4 | 21 | 16 | 37.0 | 2 | 15 | 12 | 2 | 2 | 0 | 4 | 21 | 16 | 37 | |||||||||||||||||||||||||||||||||
2231413 | 2231413 | MA | Dukes | school | 2509090 | 89 | Edgartown | 250909001469 | 890005 | Edgartown: Edgartown Elementary | Regular School | No | Elementary | PK | 08 | 2018 | kindergarten | 23 | 3 | 10 | 2 | 0 | 0 | 0 | 22 | 16 | 38.0 | 23 | 3 | 10 | 2 | 0 | 0 | 0 | 22 | 16 | 38 | |||||||||||||||||||||||||||||||||
2232360 | 2232360 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000908 | 1370015 | Holyoke: Lt Elmer J McMahon Elementary | Regular School | No | Elementary | PK | 08 | 2018 | kindergarten | 16 | 1 | 21 | 0 | 0 | 1 | 1 | 24 | 16 | 40.0 | 16 | 1 | 21 | 0 | 0 | 1 | 1 | 24 | 16 | 40 | |||||||||||||||||||||||||||||||||
2233254 | 2233254 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001079 | 1630070 | Lynn: Lincoln-Thomson | Regular School | No | Elementary | KG | 05 | 2018 | kindergarten | 11 | 1 | 15 | 0 | 3 | 0 | 1 | 15 | 16 | 31.0 | 11 | 1 | 15 | 0 | 3 | 0 | 1 | 15 | 16 | 31 | |||||||||||||||||||||||||||||||||
2233382 | 2233382 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001351 | 1650027 | Malden: Forestdale | Regular School | No | Elementary | KG | 08 | 2018 | kindergarten | 25 | 8 | 6 | 0 | 5 | 0 | 3 | 31 | 16 | 47.0 | 25 | 8 | 6 | 0 | 5 | 0 | 3 | 31 | 16 | 47 | |||||||||||||||||||||||||||||||||
2234383 | 2234383 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001388 | 2090008 | North Adams: Colegrove Park Elementary | Regular School | No | Elementary | PK | 06 | 2018 | kindergarten | 30 | 0 | 2 | 1 | 0 | 0 | 4 | 21 | 16 | 37.0 | 30 | 0 | 2 | 1 | 0 | 0 | 4 | 21 | 16 | 37 |
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]);