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
932550 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 3                       5                         2 3                 5
1121948 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121953 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121956 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121959 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121964 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1364798 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 0 1 0   0     0   0   3 3 *                     6.0 5 0 1 0   0     0   0   3 3                 6
1672022 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 0 1 0   1     0   0   5 3 *                     8.0 6 0 1 0   1     0   0   5 3                 8
2039824 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2228755 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228758 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228762 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228767 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228772 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
1122130 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122137 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122144 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122151 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122153 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122160 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122167 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122174 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122178 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122183 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2228936 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228943 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228950 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228957 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228959 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228966 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228973 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228980 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228984 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228989 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1124959 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124963 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124970 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124977 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124984 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124991 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124998 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125005 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125012 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125019 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125023 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125027 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125031 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125036 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2231787 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Framingham: Juniper Hill School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231792 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham: King Elementary School   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231799 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham: Brophy   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231806 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham: Charlotte A Dunning   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231813 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham: Hemenway   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231820 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231827 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham: Potter Road   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231834 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham: Mary E Stapleton Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231841 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham: Miriam F McCarthy School   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231848 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham: Woodrow Wilson   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231852 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham: Cameron Middle School   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231856 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231860 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231865 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham: Framingham High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
935204 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   sped_beyond_grade_12 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
1125038 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125045 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125052 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125059 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125066 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125073 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125080 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125084 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125088 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125092 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125097 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1367442 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   sped_beyond_grade_12 4 0 1 1   0     0   1   1 6 *                     7.0 4 0 1 1   0     0   1   1 6                 7
1674676 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   sped_beyond_grade_12 3 0 1 1   0     0   1   3 3 *                     6.0 3 0 1 1   0     0   1   3 3                 6
2042513 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2231867 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231874 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231881 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin: Helen Keller Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231888 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231895 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231902 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin: Parmenter   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231909 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231913 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231917 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231921 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin: Horace Mann   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231926 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   sped_beyond_grade_12 8 0 0 0   0     0   0                             8.0 8 0 0 0   0     0   0                       8
935219 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   sped_beyond_grade_12 * * * *   *     *   *   4 1                       5                         4 1                 5
1125101 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125105 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125109 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125115 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125120 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1674691 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner - Gardner High   Regular School No High 08 12 2021   sped_beyond_grade_12 5 1 3 0   0     0   0   7 2 *                     9.0 5 1 3 0   0     0   0   7 2                 9
2042528 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   sped_beyond_grade_12 6 0 1 0   0     0   0                             7.0 6 0 1 0   0     0   0                       7
2231930 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231934 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner: Waterford Street   Regular School No Elementary PK 01 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231938 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231944 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2231949 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner: Gardner Academy for Learning and Technology   Alternative School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0