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
1686945 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   kindergarten                                                   59.0                                             59
1688415 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_1                                                   59.0                                             59
1689885 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_2                                                   77.0                                             77
1691355 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_3                                                   76.0                                             76
1692825 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_4                                                   0.0                                             0
1694295 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_5                                                   0.0                                             0
1695765 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_6                                                   0.0                                             0
1697235 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_7                                                   0.0                                             0
1698705 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_8                                                   0.0                                             0
1700175 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_9                                                   0.0                                             0
1701645 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_10                                                   0.0                                             0
1703115 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_11                                                   0.0                                             0
1704585 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   grade_12                                                   0.0                                             0
1706055 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2017   k_12_total 126.0 0.0 133.0     1.0     0.0   10.0                               126 0 133     1     0   10                        
1172266 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   kindergarten                                                   69.0                                             69
1173725 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_1                                                   61.0                                             61
1175184 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_2                                                   60.0                                             60
1176643 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_3                                                   82.0                                             82
1178102 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_4                                                   0.0                                             0
1179561 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_5                                                   0.0                                             0
1181020 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_6                                                   0.0                                             0
1182479 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_7                                                   0.0                                             0
1183938 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_8                                                   0.0                                             0
1185397 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_9                                                   0.0                                             0
1186856 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_10                                                   0.0                                             0
1188315 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_11                                                   0.0                                             0
1189774 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   grade_12                                                   0.0                                             0
1191233 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2018   k_12_total 119.0 0.0 139.0   2.0 3.0     0.0   9.0                               119 0 139   2 3     0   9                        
898436 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   kindergarten                                                   54                                             54
899895 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_1                                                   58                                             58
901354 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_2                                                   69                                             69
902813 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_3                                                   63                                             63
904272 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_4                                                   0                                             0
905731 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_5                                                   0                                             0
907190 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_6                                                   0                                             0
908649 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_7                                                   0                                             0
910108 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_8                                                   0                                             0
911567 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_9                                                   0                                             0
913026 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_10                                                   0                                             0
914485 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_11                                                   0                                             0
915944 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   grade_12                                                   0                                             0
917403 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2020   k_12_total 119 0 114   2 0     0   9                               119 0 114   2 0     0   9                        
638431 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   kindergarten                                                   48                                             48
639902 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_1                                                   43                                             43
641373 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_2                                                   51                                             51
642844 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_3                                                   56                                             56
644315 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_4                                                   0                                             0
645786 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_5                                                   0                                             0
647257 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_6                                                   0                                             0
648728 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_7                                                   0                                             0
650199 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_8                                                   0                                             0
651670 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_9                                                   0                                             0
653141 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_10                                                   0                                             0
654612 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_11                                                   0                                             0
656083 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   grade_12                                                   0                                             0
657554 OR     school 4108520 2147   Morrow SD 1 410852000858 813 A C Houghton Elementary School   Regular School No Elementary KG 03 2021   k_12_total 91 0 104   1 0     0   2                               91 0 104   1 0     0   2                        
1687169 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   kindergarten                                                   85.0                                             85
1688639 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_1                                                   95.0                                             95
1690109 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_2                                                   86.0                                             86
1691579 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_3                                                   99.0                                             99
1693049 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_4                                                   76.0                                             76
1694519 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_5                                                   78.0                                             78
1695989 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_6                                                   0.0                                             0
1697459 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_7                                                   0.0                                             0
1698929 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_8                                                   0.0                                             0
1700399 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_9                                                   0.0                                             0
1701869 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_10                                                   0.0                                             0
1703339 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_11                                                   0.0                                             0
1704809 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   grade_12                                                   0.0                                             0
1706279 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2017   k_12_total 430.0 2.0 28.0     13.0     1.0   45.0                               430 2 28     13     1   45                        
1172485 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   84.0                                             84
1173944 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_1                                                   87.0                                             87
1175403 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_2                                                   92.0                                             92
1176862 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_3                                                   79.0                                             79
1178321 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_4                                                   93.0                                             93
1179780 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_5                                                   81.0                                             81
1181239 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_6                                                   0.0                                             0
1182698 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_7                                                   0.0                                             0
1184157 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_8                                                   0.0                                             0
1185616 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_9                                                   0.0                                             0
1187075 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_10                                                   0.0                                             0
1188534 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_11                                                   0.0                                             0
1189993 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   grade_12                                                   0.0                                             0
1191452 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2018   k_12_total 432.0 2.0 29.0   0.0 18.0     1.0   34.0                               432 2 29   0 18     1   34                        
898652 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   kindergarten                                                   79                                             79
900111 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   87                                             87
901570 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_2                                                   80                                             80
903029 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_3                                                   83                                             83
904488 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   95                                             95
905947 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_5                                                   83                                             83
907406 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0                                             0
908865 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0                                             0
910324 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_8                                                   0                                             0
911783 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_9                                                   0                                             0
913242 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_10                                                   0                                             0
914701 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_11                                                   0                                             0
916160 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   grade_12                                                   0                                             0
917619 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2020   k_12_total 418 5 28   0 12     1   43                               418 5 28   0 12     1   43                        
638651 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2021   kindergarten                                                   45                                             45
640122 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2021   grade_1                                                   80                                             80
641593 OR     school 4110040 2180   Portland SD 1J 411004000865 822 Abernethy Elementary School   Regular School No Elementary KG 05 2021   grade_2                                                   86                                             86