schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

Query parameters

rowidstatecountycounty_state_idadmin_leveldistrict_nces_iddistrict_state_iddistrict_state_typedistrictschool_nces_idschool_state_idschoolschool_state_typeccd_school_typeccd_charter_schoolccd_school_lvlccd_school_low_gradeccd_school_high_gradeyeartermgradewhiteblackhispanicnative_americannative_american_alaskan_nativeasiannative_hawaiianasian_pacific_islandernative_hawaiian_pacific_islanderpacific_islandermultiracialunknown_racemalefemalenon_binaryunknown_genderellell_percenthomelesshomeless_percentlow_incomefree_and_reducedfree_and_reduced_percentdisabilitysection_504totalwhite_intblack_inthispanic_intnative_american_intnative_american_alaskan_native_intasian_intnative_hawaiian_intasian_pacific_islander_intnative_hawaiian_pacific_islander_intpacific_islander_intmultiracial_intunknown_race_intmale_intfemale_intnon_binary_intunknown_gender_intell_inthomeless_intlow_income_intfree_and_reduced_intdisability_intsection_504_inttotal_int
2229287 MA Essex   school 2502640 30   Beverly 250264000173 300040 Beverly: North Beverly Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2229294 MA Essex   school 2502640 30   Beverly 250264000175 300055 Beverly: Ayers/Ryal Side School   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229298 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly: Briscoe Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229303 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly: Beverly High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2229310 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Billerica: Thomas Ditson   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229317 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica: Frederick J Dutile   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229324 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 Billerica: John F Kennedy   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229331 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Billerica: Parker   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229338 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Billerica: Hajjar Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Boston: Beethoven   Regular School No Elementary PK 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229452 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2229453 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2229454 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_10 * * * *   *     *   *   1 1                       2.0                         1 1                 2
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 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 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 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
2229488 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston: Dante Alighieri Montessori School   Regular School No Elementary PK 05 2018   grade_5 * * * *   *     *   *   2 1                       3.0                         2 1                 3
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
2229998 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
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 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 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 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 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 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 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 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