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
1125263 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_3 * * * *   *     *   *   * *                       *                                              
1125264 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_4 6 0 0 0   0     0   0   * *                       6 6 0 0 0   0     0   0                       6
1125265 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1125266 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125267 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125269 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1125270 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_10 * * * *   *     *   *   * *                       *                                              
1125271 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_11 * * * *   *     *   *   * *                       *                                              
1125272 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_12 * * * *   *     *   *   * *                       *                                              
1126247 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1126248 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_3 * * * *   *     *   *   1 *                       *                         1                    
1126249 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_4 * * * *   *     *   *   4 *                       *                         4                    
1126250 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_5 * * * *   *     *   *   2 *                       *                         2                    
1126251 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_6 * * * *   *     *   *   4 *                       *                         4                    
1126252 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_7 2 0 3 0   0     0   1   6 *                       6 2 0 3 0   0     0   1   6                   6
1126445 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   kindergarten * * * *   *     *   *   1 *                       *                         1                    
1126446 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_1 * * * *   *     *   *   4 *                       *                         4                    
1126447 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_2 3 0 6 0   0     0   0   9 *                       9 3 0 6 0   0     0   0   9                   9
1126448 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_3 1 1 8 0   1     0   0   9 *                       11 1 1 8 0   1     0   0   9                   11
1126449 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_4 * * * *   *     *   *   3 *                       *                         3                    
1126450 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_5 2 1 6 0   0     0   1   10 *                       10 2 1 6 0   0     0   1   10                   10
1126451 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_6 3 3 3 0   0     0   0   7 *                       9 3 3 3 0   0     0   0   7                   9
1127949 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   3 *                       *                         3                    
1127950 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_10 7 0 2 0   0     0   0   7 *                       9 7 0 2 0   0     0   0   7                   9
1127951 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_11 * * * *   *     *   *   5 *                       *                         5                    
1127952 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No Other 05 12 2017   grade_12 5 0 2 0   0     0   1   7 *                       8 5 0 2 0   0     0   1   7                   8
1128684 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_8 * * * *   *     *   *   2 *                       *                         2                    
1128685 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1128686 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_10 * * * *   *     *   *   1 *                       *                         1                    
1128687 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_11 * * * *   *     *   *   1 *                       *                         1                    
1128688 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_12 * * * *   *     *   *   3 *                       *                         3                    
1129008 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1129009 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_7 * * * *   *     *   *   3 *                       *                         3                    
1129010 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_8 2 3 6 0   0     0   0   7 *                       11 2 3 6 0   0     0   0   7                   11
1129420 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   2 *                       *                         2                    
1129421 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_10 * * * *   *     *   *   3 *                       *                         3                    
1129422 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_12 2 0 4 0   0     0   0   4 *                       6 2 0 4 0   0     0   0   4                   6
1130405 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 21st Century Skills Academy   Regular School No High 09 12 2017   grade_12 10 1 2 0   0     0   0   11 *                       13 10 1 2 0   0     0   0   11                   13
1131923 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1131924 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_7 * * * *   *     *   *   1 *                       *                         1                    
1131925 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1131926 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_10 * * * *   *     *   *   2 *                       *                         2                    
1131927 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_12 * * * *   *     *   *   1 *                       *                         1                    
1132701 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   kindergarten 6 0 0 0   0     0   0   4 *                       6 6 0 0 0   0     0   0   4                   6
1132702 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   grade_1 6 0 1 0   0     0   0   5 *                       7 6 0 1 0   0     0   0   5                   7
1367682 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_2 * * * *   *     *   *   1 * *                     1.0                         1                   1
1367683 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_3 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367684 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_4 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367685 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_5 * * * *   *     *   *   4 * *                     5.0                         4                   5
1367686 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1367687 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_7 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367688 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_8 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367689 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_9 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367690 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_10 * * * *   *     *   *   1 * *                     1.0                         1                   1
1367691 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_11 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367692 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   sped_beyond_grade_12 6 0 3 0   0     0   0   5 * *                     9.0 6 0 3 0   0     0   0   5                   9
1368366 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_3 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368367 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_5 * * * *   *     *   *   1 * *                     1.0                         1                   1
1368368 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_6 * * * *   *     *   *   5 * *                     5.0                         5                   5
1368369 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_7 4 0 5 0   0     0   0   8 * *                     9.0 4 0 5 0   0     0   0   8                   9
1368370 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_8 * * * *   *     *   *   3 * *                     3.0                         3                   3
1368456 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1368457 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1368458 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1368459 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1368460 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1368461 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1368462 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1368464 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1368466 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1368467 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1368468 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1368469 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1368470 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   * * *                     6.0 6 0 0 0   0     0   0                       6
1368553 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_1 * * * *   *     *   *   2 * *                     3.0                         2                   3
1368554 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_2 1 0 5 0   0     0   0   6 * *                     6.0 1 0 5 0   0     0   0   6                   6
1368555 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_3 0 3 5 0   0     0   0   7 * *                     8.0 0 3 5 0   0     0   0   7                   8
1368556 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_4 1 1 5 0   1     0   0   7 * *                     8.0 1 1 5 0   1     0   0   7                   8
1368557 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_5 3 0 5 0   0     0   0   7 * *                     8.0 3 0 5 0   0     0   0   7                   8
1368881 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 10 12 2020   grade_10 4 1 0 0   0     0   1   4 * *                     6.0 4 1 0 0   0     0   1   4                   6
1368882 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 10 12 2020   grade_11 * * * *   *     *   *   4 * *                     5.0                         4                   5
1368883 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 10 12 2020   grade_12 * * * *   *     *   *   2 * *                     3.0                         2                   3
1369815 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   grade_10 * * * *   *     *   *   2 * *                     2.0                         2                   2
1369816 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   grade_11 * * * *   *     *   *   1 * *                     1.0                         1                   1
1369817 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   grade_12 * * * *   *     *   *   4 * *                     4.0                         4                   4
1369818 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 * *                     1.0                         1                   1
1370435 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 09 12 2020   grade_9 * * * *   *     *   *   2 * *                     3.0                         2                   3
1370436 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 09 12 2020   grade_10 * * * *   *     *   *   4 * *                     5.0                         4                   5
1370437 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 09 12 2020   grade_11 * * * *   *     *   *   4 * *                     5.0                         4                   5
1370438 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 09 12 2020   grade_12 4 0 2 0   0     0   0   4 * *                     6.0 4 0 2 0   0     0   0   4                   6
1370705 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1370706 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_7 * * * *   *     *   *   4 * *                     4.0                         4                   4
1370707 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_8 0 2 7 0   1     0   0   8 * *                     10.0 0 2 7 0   1     0   0   8                   10
1371061 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2020   grade_9 * * * *   *     *   *   2 * *                     2.0                         2                   2
1371062 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2020   grade_10 5 0 2 0   0     0   0   7 * *                     7.0 5 0 2 0   0     0   0   7                   7
1371063 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2020   grade_11 * * * *   *     *   *   3 * *                     3.0                         3                   3
1371064 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2020   grade_12 * * * *   *     *   *   2 * *                     3.0                         2                   3
1373189 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_7 * * * *   *     *   *   1 * *                     1.0                         1                   1