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
2230202 MA Suffolk   school   35   Boston   350652               2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230203 MA Suffolk   school   35   Boston   350652               2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2230206 MA Suffolk   school   35   Boston   350652               2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2230207 MA Suffolk   school   35   Boston   350652               2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2230210 MA Suffolk   school   35   Boston   350652               2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2230212 MA Suffolk   school   35   Boston   350652               2018   grade_9 * * * *   *     *   *   * *                       1.0                                             1
2230213 MA Suffolk   school   35   Boston   350652               2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2230214 MA Suffolk   school   35   Boston   350652               2018   grade_11 * * * *   *     *   *   * *                       0.0                                             0
2230215 MA Suffolk   school   35   Boston   350652               2018   grade_12 * * * *   *     *   *   * *                       0.0                                             0
2231636 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2231637 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2231638 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2231639 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2231640 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2231641 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2231642 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2231643 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2231644 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2231645 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2231646 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2231647 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2231648 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_11 * * * *   *     *   *   * *                       0.0                                             0
2231649 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_12 * * * *   *     *   *   * *                       1.0                                             1
2232014 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2232015 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2232016 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2232017 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2232018 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2232019 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2232020 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2232021 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2232022 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_7 * * * *   *     *   *   * *                       1.0                                             1
2232023 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_8 * * * *   *     *   *   * *                       1.0                                             1
2232024 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2232025 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2232026 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_11 * * * *   *     *   *   * *                       0.0                                             0
2232027 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_12 * * * *   *     *   *   * *                       0.0                                             0
2233064 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   kindergarten * * * *   *     *   *   1 *                       1.0                         1                   1
2233065 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2233066 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_4 * * * *   *     *   *   2 *                       2.0                         2                   2
2233067 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_5 * * * *   *     *   *   5 *                       5.0                         5                   5
2233068 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_6 * * * *   *     *   *   4 *                       4.0                         4                   4
2233069 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_7 * * * *   *     *   *   4 *                       5.0                         4                   5
2233070 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2233662 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Medford: Curtis-Tufts   Regular School No High 09 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
2233663 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Medford: Curtis-Tufts   Regular School No High 09 12 2018   grade_10 * * * *   *     *   *   2 *                       3.0                         2                   3
2233664 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Medford: Curtis-Tufts   Regular School No High 09 12 2018   grade_11 * * * *   *     *   *   1 *                       3.0                         1                   3
2233665 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Medford: Curtis-Tufts   Regular School No High 09 12 2018   grade_12 3 2 1 0   0     0   0   4 *                       6.0 3 2 1 0   0     0   0   4                   6
2234771 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_8 * * * *   *     *   *   1 *                       1.0                         1                   1
2234772 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
2234773 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_10 7 0 1 0   0     0   0   7 *                       8.0 7 0 1 0   0     0   0   7                   8
2234774 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_11 5 0 2 0   0     0   0   7 *                       7.0 5 0 2 0   0     0   0   7                   7
2234775 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_12 8 0 2 0   0     0   0   8 *                       10.0 8 0 2 0   0     0   0   8                   10
2235828 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville: Next Wave Junior High   Alternative School No Middle 06 08 2018   grade_6 * * * *   *     *   *   2 *                       2.0                         2                   2
2235829 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville: Next Wave Junior High   Alternative School No Middle 06 08 2018   grade_7 3 0 3 0   0     0   0   5 *                       6.0 3 0 3 0   0     0   0   5                   6
2235830 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville: Next Wave Junior High   Alternative School No Middle 06 08 2018   grade_8 2 0 5 0   0     0   0   6 *                       7.0 2 0 5 0   0     0   0   6                   7
2236238 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Springfield: Liberty Preparatory Academy   Regular School No High 09 12 2018   grade_9 * * * *   *     *   *   2 *                       2.0                         2                   2
2236239 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Springfield: Liberty Preparatory Academy   Regular School No High 09 12 2018   grade_10 5 0 1 0   0     0   0   5 *                       6.0 5 0 1 0   0     0   0   5                   6
2236240 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Springfield: Liberty Preparatory Academy   Regular School No High 09 12 2018   grade_11 * * * *   *     *   *   3 *                       4.0                         3                   4
2237220 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2237221 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2237222 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2237223 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2237224 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2237225 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2237226 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2237227 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2237228 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2237229 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2237230 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2237231 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2237232 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_11 * * * *   *     *   *   * *                       0.0                                             0
2237233 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_12 6 0 2 0   0     0   0   * *                       8.0 6 0 2 0   0     0   0                       8
2228848 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   grade_11 5 1 0 0   0     0   0   5 1                       6.0 5 1 0 0   0     0   0   5 1                 6
2229450 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Boston: Beethoven   Regular School No Elementary PK 03 2018   grade_3 0 4 4 0   0     0   1   8 1                       9.0 0 4 4 0   0     0   1   8 1                 9
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
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
2229937 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_1 1 1 4 0   0     0   1   6 1                       7.0 1 1 4 0   0     0   1   6 1                 7
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
2230197 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Boston: Dorchester Academy   Regular School No High 09 12 2018   grade_9 0 7 0 0   0     0   0   6 1                       7.0 0 7 0 0   0     0   0   6 1                 7
2230198 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Boston: Dorchester Academy   Regular School No High 09 12 2018   grade_10 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230263 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_1 3 2 2 0   0     0   0   6 1                       7.0 3 2 2 0   0     0   0   6 1                 7
2230470 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230481 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_4 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2230482 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_6 2 3 0 0   0     0   1   5 1                       6.0 2 3 0 0   0     0   1   5 1                 6
2230483 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230663 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington: Burlington High   Regular School No High 09 12 2018   kindergarten 9 0 0 0   0     0   0   8 1                       9.0 9 0 0 0   0     0   0   8 1                 9
2230962 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee: Chicopee Academy   Alternative School No High 06 12 2018   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231068 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Concord: Alcott   Regular School No Elementary PK 05 2018   pre_kindergarten 5 1 1 0   0     0   1   7 1                       8.0 5 1 1 0   0     0   1   7 1                 8
2231414 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231473 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_3 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231474 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_4 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2231475 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231476 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_7 * * * *   *     *   *   3 1                       4.0                         3 1                 4