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
357154 SD     school 4602070 6001   Aberdeen 06-1 460207001130 89 New Beginnings   Alternative School No High 05 12 2019   grade_8 0.0 1.0   0.0                 1.0 0.0                       1.0 0 1   0                 1 0                 1
357353 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
357374 SD     school 4639540 11001   Andes Central 11-1 463954001379 6 Pease Creek Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
357931 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
357939 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
357947 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
357955 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
357963 SD     school 4607400 4002   Bon Homme 04-2 460740001393 20 Dawson Colony School   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358219 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358238 SD     school 4600041 45004   Britton-Hecla 45-4 460004101364 6 Sunset Colony High School   Regular School No High 09 12 2019   grade_12 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358245 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Rural Elementary   Regular School No Elementary KG 08 2019   grade_2 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358249 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358269 SD     school 4600041 45004   Britton-Hecla 45-4 460004101180 5 Westwood Rural Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358555 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358587 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358591 SD     school 4611280 28001   Castlewood 28-1 461128001126 4 Claremont Colony Elementary   Regular School No Elementary KG 08 2019   grade_7 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358758 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358772 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358774 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358781 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
358788 SD     school 4612300 39001   Chester Area 39-1 461230001092 4 Rustic Acres   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358829 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
358906 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School No Elementary KG 08 2019   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359011 SD     school 4614130 59003   Colome Consolidated 461413000787 5 Wood Elementary   Regular School No Elementary KG 08 2019   grade_8 0.0     1.0                 1.0 0.0                       1.0 0     1                 1 0                 1
359342 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359343 SD     school 4678300 5006   Deubrook Area 05-6 467830001320 9 Red Willow Colony School   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359352 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359372 SD     school 4678300 5006   Deubrook Area 05-6 467830001154 7 Norfeld Colony School   Regular School No Elementary KG 08 2019   kindergarten 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359433 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359437 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359461 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_2 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359468 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359475 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359488 SD     school 4619170 56002   Doland 56-2 461917001299 6 Camrose Colony Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359500 SD     school 4619170 56002   Doland 56-2 461917001100 4 Hillside Colony Elementary   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359503 SD     school 4619170 56002   Doland 56-2 461917001101 5 Clark Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359752 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359776 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359784 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359792 SD     school 4634440 22005   Edmunds Central 22-5 463444001385 6 Boulder Colony School   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359816 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_1 0.0   1.0                   0.0 1.0                       1.0 0   1                   0 1                 1
359819 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2019   grade_10 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359821 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2019   grade_11 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359824 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_2 0.0   1.0                   1.0 0.0                       1.0 0   1                   1 0                 1
359832 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_6 0.0   1.0                   1.0 0.0                       1.0 0   1                   1 0                 1
359834 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_7 1.0   0.0                   1.0 0.0                       1.0 1   0                   1 0                 1
359836 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   grade_8 1.0   0.0                   1.0 0.0                       1.0 1   0                   1 0                 1
359839 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2019   grade_9 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359846 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2019   pre_kindergarten 1.0   0.0                   1.0 0.0                       1.0 1   0                   1 0                 1
359920 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School No Elementary KG 08 2019   grade_2 1.0                       0.0 1.0                       1.0 1                       0 1                 1
359929 SD     school 4621390 5003   Elkton 05-3 462139001078 4 Newdale Colony Elem   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359940 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
359950 SD     school 4621390 5003   Elkton 05-3 462139001168 5 Rolland Colony Elem   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360123 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360139 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School No Elementary KG 08 2019   grade_2 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360147 SD     school 4622940 46002   Faith 46-2 462294000412 4 Maurine Elem.   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360189 SD     school 4624030 24004   Faulkton Area 462403001160 10 Thunderbird Colony Elem   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360233 SD     school 4624030 24004   Faulkton Area 462403001090 5 Brentwood Colony School   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360239 SD     school 4624030 24004   Faulkton Area 462403001090 5 Brentwood Colony School   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360443 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360444 SD     school 4625500 33001   Freeman 33-1 462550000222 4 Wolf Creek Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360483 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360493 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360760 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360780 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2019   grade_3 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360788 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360800 SD     school 4630490 27001   Haakon 27-1 463049000647 8 Milesville Elem   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360876 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360918 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360924 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360936 SD     school 4602640 30001   Hanson 30-1 460264000015 4 Millbrook Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
360969 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360994 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       0.0 1.0                       1.0 1                       0 1                 1
360997 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361002 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2019   grade_4 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361004 SD     school 4609300 31001   Harding County 31-1 460930000701 8 Camp Crook Elementary   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361007 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2019   grade_5 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361037 SD     school 4609300 31001   Harding County 31-1 460930000667 6 Ludlow Elementary   Regular School No Elementary KG 08 2019   kindergarten 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361428 SD     school 4600046 56006   Hitchcock-Tulare 460004601165 3 Spink Colony Elem   Regular School No Elementary KG 08 2019   grade_6 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361599 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361629 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361664 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   grade_3 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361671 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361674 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361695 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361699 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361716 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School No Elementary KG 08 2019   kindergarten 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361741 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_1 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361771 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_3 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361772 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School No Elementary PK 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361777 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361778 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School No Elementary PK 08 2019   grade_5 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361782 SD     school 4636060 22006   Ipswich Public 22-6 463606001086 6 Pembrook Colony Elem   Regular School No Elementary PK 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361783 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361800 SD     school 4636060 22006   Ipswich Public 22-6 463606001086 6 Pembrook Colony Elem   Regular School No Elementary PK 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361801 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School No Elementary PK 08 2019   grade_8 1.0                       0.0 1.0                       1.0 1                       0 1                 1
361911 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No Middle 04 08 2019   grade_5 1.0                       1.0 0.0                       1.0 1                       1 0                 1
361923 SD     school 4636150 2003   Iroquois 02-3 463615000340 5 Pearl Creek Colony Elem   Regular School No Middle 04 08 2019   grade_8 1.0                       1.0 0.0                       1.0 1                       1 0                 1
362051 SD     school 4680437 35002   Kadoka Area 35-2 468043701257 11 Midland Elementary   Regular School No Elementary KG 08 2019   grade_7 1.0                       0.0 1.0                       1.0 1                       0 1                 1
362243 SD     school 4640860 45005   Langford Area 464086001097 4 Newport Colony Elem   Regular School No Elementary KG 08 2019   grade_4 1.0                       1.0 0.0                       1.0 1                       1 0                 1
362255 SD     school 4640860 45005   Langford Area 464086001097 4 Newport Colony Elem   Regular School No Elementary KG 08 2019   grade_7 1.0                       1.0 0.0                       1.0 1                       1 0                 1