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
645422 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2021   grade_5                                                   14                                             14
905368 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2020   grade_5                                                   8                                             8
1179205 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2018   grade_5                                                   19.0                                             19
1693933 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2017   grade_5                                                   11.0                                             11
645423 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2021   grade_5                                                   0                                             0
905369 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2020   grade_5                                                   0                                             0
1179206 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
1693934 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
645946 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_5                                                   6                                             6
905889 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_5                                                   1                                             1
1179724 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_5                                                   3.0                                             3
1694460 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_5                                                   10.0                                             10
645945 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 12 2021   grade_5                                                   28                                             28
905888 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 12 2020   grade_5                                                   27                                             27
1179723 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 10 2018   grade_5                                                   27.0                                             27
1694459 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 09 2017   grade_5                                                   26.0                                             26
645947 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2021   grade_5                                                   24                                             24
905890 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2020   grade_5                                                   24                                             24
1179725 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2018   grade_5                                                   24.0                                             24
1694461 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 Southwest Charter School   Regular School Yes Elementary KG 08 2017   grade_5                                                   24.0                                             24
645948 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary KG 08 2021   grade_5                                                   41                                             41
905891 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary KG 08 2020   grade_5                                                   41                                             41
1179726 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary 01 08 2018   grade_5                                                   45.0                                             45
1694462 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary 01 08 2017   grade_5                                                   44.0                                             44
645944 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2021   grade_5                                                   25                                             25
905887 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2020   grade_5                                                   22                                             22
1179722 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2018   grade_5                                                   24.0                                             24
1694458 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2017   grade_5                                                   21.0                                             21
646422 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2021   grade_5                                                   56                                             56
906364 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2020   grade_5                                                   55                                             55
1180199 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2018   grade_5                                                   63.0                                             63
1694936 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2017   grade_5                                                   57.0                                             57
646426 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2021   grade_5                                                   7                                             7
906368 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2020   grade_5                                                   10                                             10
1180203 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2018   grade_5                                                   9.0                                             9
1694940 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2017   grade_5                                                   15.0                                             15
646423 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2021   grade_5                                                   0                                             0
906365 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2020   grade_5                                                   0                                             0
1180200 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
1694937 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
646424 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2021   grade_5                                                   0                                             0
906366 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2020   grade_5                                                   0                                             0
1180201 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2018   grade_5                                                   0.0                                             0
1694938 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2017   grade_5                                                   0.0                                             0
645453 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2021   grade_5                                                   64                                             64
905398 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2020   grade_5                                                   68                                             68
1179233 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2018   grade_5                                                   80.0                                             80
1693962 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2017   grade_5                                                   78.0                                             78
645455 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2021   grade_5                                                   0                                             0
905400 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0                                             0
1179235 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2018   grade_5                                                   0.0                                             0
1693964 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2017   grade_5                                                   0.0                                             0
645454 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2021   grade_5                                                   0                                             0
905399 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2020   grade_5                                                   0                                             0
1179234 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
1693963 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
645456 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2021   grade_5                                                   0                                             0
905401 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2020   grade_5                                                   0                                             0
1179236 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2018   grade_5                                                   0.0                                             0
1693965 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No Other 06 12 2017   grade_5                                                   0.0                                             0
645452 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Other KG 12 2021   grade_5                                                   44                                             44
905397 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Other KG 11 2020   grade_5                                                   22                                             22
1179232 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Middle 05 09 2018   grade_5                                                   27.0                                             27
646477 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 03 2021   grade_5                                                   0                                             0
906419 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2020   grade_5                                                   0                                             0
1180254 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2018   grade_5                                                   0.0                                             0
1694991 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2017   grade_5                                                   0.0                                             0
646478 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2021   grade_5                                                   0                                             0
906420 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2020   grade_5                                                   0                                             0
1180255 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
1694992 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
646479 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 04 08 2021   grade_5                                                   58                                             58
906421 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2020   grade_5                                                   58                                             58
1180256 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2018   grade_5                                                   77.0                                             77
1694993 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2017   grade_5                                                   91.0                                             91
645532 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 04 2021   grade_5                                                   0                                             0
905479 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 06 2020   grade_5                                                   43                                             43
1179313 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 05 2018   grade_5                                                   70.0                                             70
1694044 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 05 2017   grade_5                                                   67.0                                             67
645533 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2021   grade_5                                                   0                                             0
905480 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 07 12 2020   grade_5                                                   0                                             0
1179314 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
1694045 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
645534 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 05 08 2021   grade_5                                                   64                                             64
905481 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Not reported M M 2020   grade_5                                                   -                                              
1179315 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 06 08 2018   grade_5                                                   0.0                                             0
1694046 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 06 08 2017   grade_5                                                   0.0                                             0
645873 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2021   grade_5                                                   25                                             25
905818 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2020   grade_5                                                   25                                             25
1179646 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2018   grade_5                                                   27.0                                             27
1694382 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2017   grade_5                                                   16.0                                             16
645879 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2021   grade_5                                                   44                                             44
905822 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2020   grade_5                                                   42                                             42
1179650 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2018   grade_5                                                   48.0                                             48
1694386 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2017   grade_5                                                   42.0                                             42
645876 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2021   grade_5                                                   0                                             0
905819 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2020   grade_5                                                   0                                             0
1179647 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2018   grade_5                                                   0.0                                             0
1694383 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2017   grade_5                                                   0.0                                             0
645878 OR     school 4100020 2143   North Santiam SD 29J 410002000834 789 Stayton Middle School   Regular School No Middle 04 08 2021   grade_5                                                   69                                             69
905821 OR     school 4100020 2143   North Santiam SD 29J 410002000834 789 Stayton Middle School   Regular School No Middle 04 08 2020   grade_5                                                   102                                             102