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
1122298 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122303 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122308 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122313 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122318 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122321 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122324 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122330 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   sped_beyond_grade_12 9 0 0 0   0     0   1                             10 9 0 0 0   0     0   1                       10
1123467 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123473 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123478 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123483 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123563 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123567 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124516 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124836 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124843 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124849 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124855 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124858 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124861 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124866 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126735 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126738 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126743 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126748 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127940 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128281 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128694 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128699 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128702 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128707 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129767 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130139 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131199 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131241 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131612 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131984 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131990 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131995 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131998 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132001 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132008 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132080 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132085 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132358 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132365 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132369 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132375 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   sped_beyond_grade_12 7 1 0 0   0     0   1                             9 7 1 0 0   0     0   1                       9
1132996 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133096 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124216 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124928 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125321 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125754 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125904 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125911 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125937 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125945 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127569 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127578 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127588 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127594 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   sped_beyond_grade_12 7 0 0 0   0     0   0                             7 7 0 0 0   0     0   0                       7
1128105 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128112 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128120 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128128 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128136 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128143 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128150 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Williams   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128158 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128162 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128166 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128171 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128176 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128557 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128754 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130542 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131148 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131749 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131756 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131764 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131854 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131859 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131864 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 9 2 0 0   0     0   0                             11 9 2 0 0   0     0   0                       11
1131949 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131957 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131965 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131969 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131974 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132094 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132382 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132700 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132703 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132712 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132719 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133046 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121971 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121976 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122208 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122210 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *