Data source: Big Local News · About: Big Local

5,859 rows where grade = "k_12_total" and state = "OR" sorted by school_nces_id

View and edit SQL

year

grade

  • k_12_total · 5,859
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id ▼ school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
657190 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2021   k_12_total 97 0 5   1 0     0   6                               97 0 5   1 0     0   6                        
917040 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2020   k_12_total 100 0 4   2 0     0   9                               100 0 4   2 0     0   9                        
1190877 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2018   k_12_total 111.0 0.0 9.0   2.0 0.0     0.0   8.0                               111 0 9   2 0     0   8                        
1705693 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2017   k_12_total 101.0 0.0 10.0     0.0     0.0   4.0                               101 0 10     0     0   4                        
657191 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2021   k_12_total 54 0 1   1 0     0   5                               54 0 1   1 0     0   5                        
917041 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2020   k_12_total 65 0 2   2 0     1   5                               65 0 2   2 0     1   5                        
1190878 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2018   k_12_total 69.0 0.0 2.0   1.0 2.0     0.0   3.0                               69 0 2   1 2     0   3                        
1705694 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2017   k_12_total 57.0 0.0 3.0     0.0     0.0   0.0                               57 0 3     0     0   0                        
657714 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   k_12_total 38 4 34   4 3     4   8                               38 4 34   4 3     4   8                        
917561 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   k_12_total 50 5 42   4 6     4   10                               50 5 42   4 6     4   10                        
1191396 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   k_12_total 50.0 6.0 44.0   3.0 3.0     5.0   7.0                               50 6 44   3 3     5   7                        
1706220 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   k_12_total 49.0 8.0 48.0     4.0     5.0   5.0                               49 8 48     4     5   5                        
657713 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 12 2021   k_12_total 67 0 277   0 1     0   5                               67 0 277   0 1     0   5                        
917560 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 12 2020   k_12_total 60 0 275   0 2     0   7                               60 0 275   0 2     0   7                        
1191395 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 10 2018   k_12_total 46.0 0.0 255.0   1.0 1.0     0.0   2.0                               46 0 255   1 1     0   2                        
1706219 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 09 2017   k_12_total 54.0 1.0 222.0     1.0     0.0   2.0                               54 1 222     1     0   2                        
657715 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2021   k_12_total 159 5 20   0 7     0   17                               159 5 20   0 7     0   17                        
917562 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2020   k_12_total 160 4 19   0 7     0   17                               160 4 19   0 7     0   17                        
1191397 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2018   k_12_total 156.0 3.0 13.0   0.0 10.0     0.0   18.0                               156 3 13   0 10     0   18                        
1706221 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 Southwest Charter School   Regular School Yes Elementary KG 08 2017   k_12_total 153.0 0.0 16.0     7.0     0.0   14.0                               153 0 16     7     0   14                        
657716 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary KG 08 2021   k_12_total 242 24 35   4 3     0   19                               242 24 35   4 3     0   19                        
917563 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary KG 08 2020   k_12_total 221 13 32   3 5     1   21                               221 13 32   3 5     1   21                        
1191398 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary 01 08 2018   k_12_total 202.0 6.0 26.0   3.0 10.0     1.0   17.0                               202 6 26   3 10     1   17                        
1706222 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary 01 08 2017   k_12_total 207.0 5.0 29.0     6.0     0.0   16.0                               207 5 29     6     0   16                        
657712 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2021   k_12_total 89 2 30   0 2     0   16                               89 2 30   0 2     0   16                        
917559 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2020   k_12_total 98 3 27   0 2     0   14                               98 3 27   0 2     0   14                        
1191394 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2018   k_12_total 112.0 2.0 17.0   0.0 0.0     0.0   13.0                               112 2 17   0 0     0   13                        
1706218 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2017   k_12_total 107.0 2.0 15.0     0.0     0.0   15.0                               107 2 15     0     0   15                        
658190 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2021   k_12_total 239 0 105   1 1     0   9                               239 0 105   1 1     0   9                        
918036 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2020   k_12_total 283 0 111   4 2     0   11                               283 0 111   4 2     0   11                        
1191871 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2018   k_12_total 293.0 1.0 107.0   3.0 5.0     1.0   6.0                               293 1 107   3 5     1   6                        
1706696 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2017   k_12_total 317.0 1.0 100.0     4.0     2.0   10.0                               317 1 100     4     2   10                        
658194 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2021   k_12_total 68 0 3   0 2     0   0                               68 0 3   0 2     0   0                        
918040 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2020   k_12_total 92 0 1   0 2     0   0                               92 0 1   0 2     0   0                        
1191875 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2018   k_12_total 91.0 0.0 1.0   0.0 2.0     0.0   3.0                               91 0 1   0 2     0   3                        
1706700 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2017   k_12_total 86.0 0.0 1.0     1.0     0.0   1.0                               86 0 1     1     0   1                        
658191 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2021   k_12_total 195 0 46   0 4     1   1                               195 0 46   0 4     1   1                        
918037 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2020   k_12_total 206 0 54   0 3     2   3                               206 0 54   0 3     2   3                        
1191872 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2018   k_12_total 205.0 1.0 65.0   2.0 3.0     3.0   2.0                               205 1 65   2 3     3   2                        
1706697 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2017   k_12_total 208.0 0.0 63.0     2.0     1.0   5.0                               208 0 63     2     1   5                        
658192 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2021   k_12_total 74 0 33   0 2     0   2                               74 0 33   0 2     0   2                        
918038 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2020   k_12_total 87 0 29   1 2     1   0                               87 0 29   1 2     1   0                        
1191873 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2018   k_12_total 68.0 0.0 28.0   1.0 1.0     1.0   1.0                               68 0 28   1 1     1   1                        
1706698 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2017   k_12_total 90.0 0.0 31.0     3.0     1.0   4.0                               90 0 31     3     1   4                        
657221 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2021   k_12_total 85 1 261   0 2     0   7                               85 1 261   0 2     0   7                        
917070 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2020   k_12_total 102 1 298   1 1     0   9                               102 1 298   1 1     0   9                        
1190905 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2018   k_12_total 121.0 0.0 294.0   1.0 2.0     0.0   7.0                               121 0 294   1 2     0   7                        
1705722 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2017   k_12_total 126.0 1.0 286.0     2.0     0.0   7.0                               126 1 286     2     0   7                        
657223 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2021   k_12_total 52 0 156   1 1     0   2                               52 0 156   1 1     0   2                        
917072 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2020   k_12_total 74 0 168   0 1     0   2                               74 0 168   0 1     0   2                        
1190907 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2018   k_12_total 60.0 0.0 167.0   2.0 2.0     1.0   5.0                               60 0 167   2 2     1   5                        
1705724 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2017   k_12_total 62.0 0.0 152.0     1.0     1.0   9.0                               62 0 152     1     1   9                        
657222 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2021   k_12_total 97 1 219   5 2     0   7                               97 1 219   5 2     0   7                        
917071 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2020   k_12_total 90 1 213   5 6     0   8                               90 1 213   5 6     0   8                        
1190906 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2018   k_12_total 100.0 1.0 190.0   5.0 3.0     3.0   6.0                               100 1 190   5 3     3   6                        
1705723 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2017   k_12_total 95.0 0.0 181.0     2.0     3.0   5.0                               95 0 181     2     3   5                        
657224 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2021   k_12_total 3 0 13   0 0     0   0                               3 0 13   0 0     0   0                        
917073 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2020   k_12_total 6 0 15   0 0     0   0                               6 0 15   0 0     0   0                        
1190908 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2018   k_12_total 10.0 0.0 25.0   0.0 0.0     0.0   1.0                               10 0 25   0 0     0   1                        
1705725 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No Other 06 12 2017   k_12_total 17.0 0.0 26.0     0.0     0.0   3.0                               17 0 26     0     0   3                        
657220 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Other KG 12 2021   k_12_total 456 7 77   5 8     5   31                               456 7 77   5 8     5   31                        
917069 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Other KG 11 2020   k_12_total 285 9 46   2 3     0   30                               285 9 46   2 3     0   30                        
1190904 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Middle 05 09 2018   k_12_total 107.0 1.0 13.0   1.0 4.0     0.0   10.0                               107 1 13   1 4     0   10                        
658245 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 03 2021   k_12_total 187 0 34   0 0     0   8                               187 0 34   0 0     0   8                        
918091 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2020   k_12_total 302 3 35   0 0     0   20                               302 3 35   0 0     0   20                        
1191926 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2018   k_12_total 319.0 2.0 32.0   0.0 1.0     0.0   20.0                               319 2 32   0 1     0   20                        
1706751 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2017   k_12_total 329.0 2.0 30.0     1.0     0.0   16.0                               329 2 30     1     0   16                        
658246 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2021   k_12_total 231 2 33   0 3     2   12                               231 2 33   0 3     2   12                        
918092 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2020   k_12_total 245 1 32   0 0     1   16                               245 1 32   0 0     1   16                        
1191927 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2018   k_12_total 260.0 1.0 27.0   0.0 2.0     2.0   15.0                               260 1 27   0 2     2   15                        
1706752 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2017   k_12_total 273.0 1.0 28.0     5.0     1.0   11.0                               273 1 28     5     1   11                        
658247 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 04 08 2021   k_12_total 238 2 25   0 1     0   12                               238 2 25   0 1     0   12                        
918093 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2020   k_12_total 261 3 26   0 4     0   9                               261 3 26   0 4     0   9                        
1191928 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2018   k_12_total 268.0 3.0 36.0   2.0 3.0     0.0   7.0                               268 3 36   2 3     0   7                        
1706753 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2017   k_12_total 278.0 2.0 35.0     4.0     0.0   10.0                               278 2 35     4     0   10                        
657300 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 04 2021   k_12_total 194 1 39   2 1     0   12                               194 1 39   2 1     0   12                        
917151 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 06 2020   k_12_total 346 1 53   4 1     2   21                               346 1 53   4 1     2   21                        
1190985 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 05 2018   k_12_total 301.0 1.0 50.0   3.0 2.0     2.0   25.0                               301 1 50   3 2     2   25                        
1705804 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 05 2017   k_12_total 318.0 1.0 46.0     1.0     2.0   27.0                               318 1 46     1     2   27                        
657301 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2021   k_12_total 197 0 32   1 2     0   9                               197 0 32   1 2     0   9                        
917152 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 07 12 2020   k_12_total 311 0 49   5 3     2   15                               311 0 49   5 3     2   15                        
1190986 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2018   k_12_total 233.0 0.0 37.0   5.0 1.0     2.0   15.0                               233 0 37   5 1     2   15                        
1705805 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2017   k_12_total 246.0 0.0 34.0     2.0     2.0   13.0                               246 0 34     2     2   13                        
657302 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 05 08 2021   k_12_total 179 0 27   1 1     2   12                               179 0 27   1 1     2   12                        
917153 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Not reported M M 2020   k_12_total - - -   - -     -   -                                                                            
1190987 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 06 08 2018   k_12_total 151.0 0.0 26.0   0.0 1.0     0.0   3.0                               151 0 26   0 1     0   3                        
1705806 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 06 08 2017   k_12_total 160.0 0.0 27.0     1.0     0.0   7.0                               160 0 27     1     0   7                        
657641 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2021   k_12_total 151 0 1   0 0     0   11                               151 0 1   0 0     0   11                        
917490 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2020   k_12_total 196 0 6   1 0     2   8                               196 0 6   1 0     2   8                        
1191318 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2018   k_12_total 200.0 0.0 6.0   5.0 0.0     2.0   5.0                               200 0 6   5 0     2   5                        
1706142 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2017   k_12_total 200.0 2.0 6.0     0.0     0.0   10.0                               200 2 6     0     0   10                        
657647 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2021   k_12_total 271 3 30   4 7     2   30                               271 3 30   4 7     2   30                        
917494 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2020   k_12_total 301 4 31   3 7     2   34                               301 4 31   3 7     2   34                        
1191322 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2018   k_12_total 310.0 6.0 24.0   3.0 3.0     1.0   23.0                               310 6 24   3 3     1   23                        
1706146 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2017   k_12_total 335.0 5.0 24.0     2.0     1.0   18.0                               335 5 24     2     1   18                        
657644 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2021   k_12_total 208 4 72   0 2     1   22                               208 4 72   0 2     1   22                        
917491 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2020   k_12_total 267 3 82   0 1     1   23                               267 3 82   0 1     1   23                        
1191319 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2018   k_12_total 270.0 1.0 95.0   1.0 0.0     1.0   21.0                               270 1 95   1 0     1   21                        
1706143 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2017   k_12_total 299.0 5.0 108.0     2.0     5.0   18.0                               299 5 108     2     5   18                        
657646 OR     school 4100020 2143   North Santiam SD 29J 410002000834 789 Stayton Middle School   Regular School No Middle 04 08 2021   k_12_total 301 8 115   2 0     6   24                               301 8 115   2 0     6   24                        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);