enrollments
Data source: Big Local News · About: Big Local
11,284 rows where state = "MA" and year = 2018 sorted by total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2229345 | 2229345 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000178 | 310030 | Billerica: Eugene C Vining | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229349 | 2229349 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000183 | 310305 | Billerica: Marshall Middle School | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229353 | 2229353 | MA | Middlesex | school | 2502670 | 31 | Billerica | 250267000182 | 310310 | Billerica: Locke Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229365 | 2229365 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001768 | 350001 | Boston: Lee Academy | Regular School | No | Elementary | PK | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229369 | 2229369 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000011 | 350003 | Boston: Baldwin Early Learning Center | Regular School | No | Elementary | PK | 01 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229379 | 2229379 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002458 | 350004 | Boston: Lyon K-8 | Regular School | No | Elementary | KG | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229383 | 2229383 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002514 | 350006 | Boston: ELC - West Zone | Regular School | No | Elementary | PK | 01 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229389 | 2229389 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001115 | 350008 | Boston: Dr. Catherine Ellison-Rosa Parks Early Ed School | Regular School | No | Elementary | PK | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229393 | 2229393 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001118 | 350009 | Boston: East Boston Early Childhood Center | Regular School | No | Elementary | PK | 01 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229397 | 2229397 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001126 | 350010 | Boston: Haynes Early Education Center | Regular School | No | Elementary | PK | 01 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229408 | 2229408 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston: Boston Teachers Union School | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229419 | 2229419 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000251 | 350013 | Boston: Jackson Mann | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229425 | 2229425 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002839 | 350014 | Boston: Pauline Agassiz Shaw Elementary School | Regular School | No | Elementary | PK | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229430 | 2229430 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002806 | 350015 | Boston: Higginson | Regular School | No | Elementary | PK | 02 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229434 | 2229434 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002874 | 350016 | Boston: Mattapan Early Elementary School | Regular School | No | Elementary | PK | 01 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229445 | 2229445 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002622 | 350020 | Boston: Curley K-8 School | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229451 | 2229451 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000198 | 350021 | Boston: Beethoven | Regular School | No | Elementary | PK | 03 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229457 | 2229457 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000210 | 350036 | Boston: Carter Developmental Center | Regular School | No | High | 07 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229465 | 2229465 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000214 | 350052 | Boston: Charles Sumner | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229473 | 2229473 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000213 | 350054 | Boston: Charles H Taylor | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229481 | 2229481 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000218 | 350062 | Boston: Curtis Guild | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229489 | 2229489 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002835 | 350066 | Boston: Dante Alighieri Montessori School | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229497 | 2229497 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000220 | 350072 | Boston: David A Ellis | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229505 | 2229505 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000222 | 350074 | Boston: Dearborn | Regular School | No | High | 06 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229516 | 2229516 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000223 | 350077 | Boston: Dennis C Haley | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229527 | 2229527 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000224 | 350080 | Boston: Donald Mckay | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229535 | 2229535 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000227 | 350088 | Boston: Edward Everett | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229546 | 2229546 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Boston: Eliot Elementary | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229554 | 2229554 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000232 | 350100 | Boston: Ellis Mendell | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229565 | 2229565 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000239 | 350116 | Boston: Franklin D Roosevelt | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229573 | 2229573 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000241 | 350122 | Boston: George H Conley | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229581 | 2229581 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000247 | 350135 | Boston: Henry Grew | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229589 | 2229589 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002569 | 350138 | Boston: O W Holmes | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229597 | 2229597 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000249 | 350141 | Boston: Hugh Roe O'Donnell | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229608 | 2229608 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000254 | 350146 | Boston: James Condon Elementary | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229618 | 2229618 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000259 | 350153 | Boston: James W Hennigan | Regular School | No | Elementary | KG | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229626 | 2229626 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000255 | 350154 | Boston: James J Chittick | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229634 | 2229634 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000257 | 350156 | Boston: James Otis | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229642 | 2229642 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000265 | 350166 | Boston: John F Kennedy | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229650 | 2229650 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000268 | 350167 | Boston: UP Academy Holland | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229658 | 2229658 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000264 | 350172 | Boston: John D Philbrick | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229662 | 2229662 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000269 | 350179 | Boston: John W McCormack | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229670 | 2229670 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000270 | 350180 | Boston: John Winthrop | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229678 | 2229678 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000275 | 350181 | Boston: Joseph P Tynan | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229689 | 2229689 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Boston: Joseph J Hurley | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229700 | 2229700 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000273 | 350183 | Boston: Joseph Lee | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229708 | 2229708 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000274 | 350184 | Boston: Joseph P Manning | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229719 | 2229719 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000278 | 350190 | Boston: Joyce Kilmer | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229727 | 2229727 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000244 | 350200 | Boston: Harvard-Kent | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229735 | 2229735 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000283 | 350215 | Boston: Manassah E Bradley | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229743 | 2229743 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000289 | 350227 | Boston: Mather | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229754 | 2229754 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Boston: Maurice J Tobin | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229761 | 2229761 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000292 | 350231 | Boston: Michael J Perkins | Regular School | No | Elementary | KG | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229769 | 2229769 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000294 | 350237 | Boston: Mozart | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229780 | 2229780 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000315 | 350240 | Boston: Richard J Murphy | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229788 | 2229788 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000295 | 350243 | Boston: Nathan Hale | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229798 | 2229798 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000297 | 350255 | Boston: Oliver Hazard Perry | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229809 | 2229809 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002006 | 350257 | Boston: Orchard Gardens | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229816 | 2229816 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000339 | 350258 | Boston: William H Ohrenberger | Regular School | No | Middle | 03 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229827 | 2229827 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000692 | 350262 | Boston: Lyndon | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229835 | 2229835 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000302 | 350264 | Boston: Patrick J Kennedy | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229839 | 2229839 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000303 | 350266 | Boston: Dr. William Henderson Lower | Regular School | No | Elementary | PK | 01 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229847 | 2229847 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000304 | 350268 | Boston: Paul A Dever | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229855 | 2229855 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000308 | 350278 | Boston: Phineas Bates | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229863 | 2229863 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000277 | 350286 | Boston: Josiah Quincy | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229871 | 2229871 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000319 | 350298 | Boston: Roger Clap | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229879 | 2229879 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000321 | 350302 | Boston: Samuel Adams | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229887 | 2229887 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000322 | 350304 | Boston: Samuel W Mason | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229898 | 2229898 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Boston: Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229909 | 2229909 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000331 | 350326 | Boston: Gardner Pilot Academy | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229917 | 2229917 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000332 | 350328 | Boston: Thomas J Kenny | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229928 | 2229928 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000333 | 350346 | Boston: Warren-Prescott | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229936 | 2229936 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000338 | 350360 | Boston: William Ellery Channing | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229948 | 2229948 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000342 | 350363 | Boston: William McKinley | Regular School | No | Other | 01 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229956 | 2229956 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000337 | 350366 | Boston: William E Russell | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229967 | 2229967 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | Boston: William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229975 | 2229975 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000344 | 350374 | Boston: Winship Elementary | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229986 | 2229986 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002689 | 350375 | Boston: Edison K-8 | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2229997 | 2229997 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002669 | 350376 | Boston: King K-8 | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230005 | 2230005 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Boston: Higginson/Lewis K-8 | Regular School | No | Elementary | 01 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230016 | 2230016 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002670 | 350378 | Boston: Mildred Avenue K-8 | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230027 | 2230027 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000693 | 350380 | Boston: Young Achievers | Alternative School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230038 | 2230038 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000946 | 350382 | Boston: Mission Hill School | Regular School | No | Elementary | PK | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230042 | 2230042 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002013 | 350383 | Boston: Lilla G. Frederick Middle School | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230050 | 2230050 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000201 | 350390 | Boston: Blackstone | Regular School | No | Elementary | PK | 05 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230062 | 2230062 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000952 | 350426 | Boston: Dr. William Henderson Upper | Regular School | No | Other | 02 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230066 | 2230066 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000216 | 350430 | Boston: Clarence R Edwards Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230070 | 2230070 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000334 | 350445 | Boston: Washington Irving Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230074 | 2230074 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000258 | 350485 | Boston: James P Timilty Middle | Regular School | No | Middle | 06 | 08 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230079 | 2230079 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000208 | 350505 | Boston: Brighton High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230084 | 2230084 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002015 | 350507 | Boston: Boston International High School | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230089 | 2230089 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000215 | 350515 | Boston: Charlestown High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230094 | 2230094 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001617 | 350518 | Boston: Community Academy | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230099 | 2230099 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002016 | 350522 | Boston: Excel High School | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230104 | 2230104 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000261 | 350525 | Boston: Jeremiah E Burke High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230109 | 2230109 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000226 | 350530 | Boston: East Boston High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230114 | 2230114 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000327 | 350535 | Boston: The English High | Regular School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230119 | 2230119 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000282 | 350537 | Boston: Madison Park High | Career and Technical School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230124 | 2230124 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000695 | 350540 | Boston: Fenway High School | Alternative School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
2230129 | 2230129 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000698 | 350541 | Boston: Another Course To College | Alternative School | No | High | 09 | 12 | 2018 | sped_beyond_grade_12 | * | * | * | * | * | * | * | 0.0 | 0 |
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]);