Data source: Big Local News · About: Big Local

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

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
1190573 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2018   k_12_total 1170.0 99.0 475.0   6.0 647.0     20.0   170.0                               1170 99 475   6 647     20   170                        
1705334 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2017   k_12_total 877.0 99.0 746.0     117.0     28.0   112.0                               877 99 746     117     28   112                        
1706418 OR     school 4110520 2182   Reynolds SD 7 411052001001 948 Margaret Scott Elementary School   Regular School No Elementary KG 05 2017   k_12_total 101.0 99.0 121.0     72.0     28.0   47.0                               101 99 121     72     28   47                        
1191481 OR     school 4110040 2180   Portland SD 1J 411004000960 911 Franklin High School   Regular School No High 09 12 2018   k_12_total 854.0 98.0 357.0   10.0 286.0     11.0   129.0                               854 98 357   10 286     11   129                        
1191507 OR     school 4110040 2180   Portland SD 1J 411004000919 1278 Markham Elementary School   Regular School No Elementary KG 05 2018   k_12_total 249.0 98.0 47.0   2.0 7.0     6.0   46.0                               249 98 47   2 7     6   46                        
657799 OR     school 4110040 2180   Portland SD 1J 411004000911 866 Dr. Martin Luther King Jr. School   Regular School No Elementary PK 05 2021   k_12_total 89 98 68   2 18     7   37                               89 98 68   2 18     7   37                        
657805 OR     school 4110040 2180   Portland SD 1J 411004000893 849 George Middle School   Regular School No Middle 06 08 2021   k_12_total 80 98 178   5 13     8   49                               80 98 178   5 13     8   49                        
916935 OR     school 4103940 2187   David Douglas SD 40 410394001033 977 Mill Park Elementary School   Regular School No Elementary PK 05 2020   k_12_total 117 98 159   6 67     13   20                               117 98 159   6 67     13   20                        
917755 OR     school 4110520 2182   Reynolds SD 7 411052000999 946 Glenfair Elementary School   Regular School No Elementary KG 05 2020   k_12_total 98 98 168   8 44     8   38                               98 98 168   8 44     8   38                        
656827 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2021   k_12_total 595 97 816   7 127     24   100                               595 97 816   7 127     24   100                        
657870 OR     school 4110040 2180   Portland SD 1J 411004000944 895 Vernon Elementary School   Regular School No Elementary PK 08 2021   k_12_total 333 97 75   0 3     2   60                               333 97 75   0 3     2   60                        
916683 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2020   k_12_total 645 96 812   9 129     33   101                               645 96 812   9 129     33   101                        
1191592 OR     school 4110520 2182   Reynolds SD 7 411052001001 948 Margaret Scott Elementary School   Regular School No Elementary KG 05 2018   k_12_total 90.0 95.0 104.0   4.0 65.0     34.0   34.0                               90 95 104   4 65     34   34                        
1190767 OR     school 4103940 2187   David Douglas SD 40 410394001027 981 Floyd Light Middle School   Regular School No Middle 06 08 2018   k_12_total 325.0 94.0 263.0   5.0 95.0     12.0   55.0                               325 94 263   5 95     12   55                        
1705583 OR     school 4103940 2187   David Douglas SD 40 410394001027 981 Floyd Light Middle School   Regular School No Middle 06 08 2017   k_12_total 334.0 94.0 239.0     88.0     14.0   51.0                               334 94 239     88     14   51                        
657878 OR     school 4110040 2180   Portland SD 1J 411004000952 902 Woodlawn Elementary School   Regular School No Elementary PK 05 2021   k_12_total 117 94 54   2 5     4   42                               117 94 54   2 5     4   42                        
917650 OR     school 4110040 2180   Portland SD 1J 411004000893 849 George Middle School   Regular School No Middle 06 08 2020   k_12_total 86 93 178   7 16     8   51                               86 93 178   7 16     8   51                        
1190772 OR     school 4103940 2187   David Douglas SD 40 410394001033 977 Mill Park Elementary School   Regular School No Elementary PK 05 2018   k_12_total 157.0 92.0 146.0   7.0 86.0     14.0   20.0                               157 92 146   7 86     14   20                        
1191490 OR     school 4110040 2180   Portland SD 1J 411004000905 861 Irvington Elementary School   Regular School No Elementary KG 08 2018   k_12_total 248.0 92.0 54.0   0.0 5.0     0.0   60.0                               248 92 54   0 5     0   60                        
657085 OR     school 4103940 2187   David Douglas SD 40 410394001033 977 Mill Park Elementary School   Regular School No Elementary PK 05 2021   k_12_total 115 92 155   7 75     11   17                               115 92 155   7 75     11   17                        
1705470 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2017   k_12_total 820.0 91.0 446.0     260.0     33.0   102.0                               820 91 446     260     33   102                        
917706 OR     school 4110040 2180   Portland SD 1J 411004000935 887 Scott Elementary School   Regular School No Elementary KG 05 2020   k_12_total 162 91 181   4 15     2   30                               162 91 181   4 15     2   30                        
1706308 OR     school 4110040 2180   Portland SD 1J 411004000960 911 Franklin High School   Regular School No High 09 12 2017   k_12_total 754.0 90.0 357.0     271.0     14.0   108.0                               754 90 357     271     14   108                        
1190549 OR     school 4101920 2243   Beaverton SD 48J 410192001219 1168 McKay Elementary School   Regular School No Elementary KG 05 2018   k_12_total 149.0 9.0 97.0   2.0 14.0     4.0   27.0                               149 9 97   2 14     4   27                        
1190555 OR     school 4101920 2243   Beaverton SD 48J 410192000210 1303 Nancy Ryles Elementary School   Regular School No Elementary KG 05 2018   k_12_total 363.0 9.0 60.0   4.0 66.0     3.0   69.0                               363 9 60   4 66     3   69                        
1190558 OR     school 4101920 2243   Beaverton SD 48J 410192001225 1173 Raleigh Park Elementary School   Regular School No Elementary KG 05 2018   k_12_total 225.0 9.0 95.0   2.0 12.0     7.0   26.0                               225 9 95   2 12     7   26                        
1190612 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001454 3221 Westside Village Magnet School at Kingston Elementary School   Regular School No Elementary KG 08 2018   k_12_total 226.0 9.0 13.0   1.0 8.0     2.0   9.0                               226 9 13   1 8     2   9                        
1190717 OR     school 4103480 1901   Corvallis SD 509J 410348000032 27 Adams Elementary School   Regular School No Elementary KG 05 2018   k_12_total 318.0 9.0 38.0   5.0 30.0     1.0   41.0                               318 9 38   5 30     1   41                        
1190721 OR     school 4103480 1901   Corvallis SD 509J 410348000048 41 Crescent Valley High School   Regular School No High 09 12 2018   k_12_total 736.0 9.0 88.0   6.0 83.0     2.0   77.0                               736 9 88   6 83     2   77                        
1190730 OR     school 4103480 1901   Corvallis SD 509J 410348000046 39 Wilson Elementary School   Regular School No Elementary KG 05 2018   k_12_total 284.0 9.0 56.0   3.0 24.0     6.0   40.0                               284 9 56   3 24     6   40                        
1190859 OR     school 4104740 2082   Eugene SD 4J 410474000571 536 North Eugene High School   Regular School No High 09 12 2018   k_12_total 629.0 9.0 173.0   20.0 17.0     2.0   73.0                               629 9 173   20 17     2   73                        
1190892 OR     school 4105160 2241   Forest Grove SD 15 410516001189 1134 Forest Grove High School   Regular School No High 09 12 2018   k_12_total 817.0 9.0 995.0   5.0 24.0     4.0   54.0                               817 9 995   5 24     4   54                        
1190911 OR     school 4105610 1931   Gladstone SD 115 410561000146 138 Gladstone High School   Regular School No High 09 12 2018   k_12_total 481.0 9.0 98.0   6.0 11.0     4.0   50.0                               481 9 98   6 11     4   50                        
1191006 OR     school 4100023 2239   Hillsboro SD 1J 410002301764 4641 Free Orchards Elementary School   Regular School No Elementary KG 06 2018   k_12_total 129.0 9.0 213.0   1.0 19.0     2.0   11.0                               129 9 213   1 19     2   11                        
1191014 OR     school 4100023 2239   Hillsboro SD 1J 410002301251 1199 J W Poynter Middle School   Regular School No Middle 07 08 2018   k_12_total 373.0 9.0 263.0   8.0 47.0     8.0   56.0                               373 9 263   8 47     8   56                        
1191076 OR     school 4107020 2057   Klamath County SD 410702000505 480 Brixner Junior High School   Regular School No Middle 07 08 2018   k_12_total 262.0 9.0 80.0   22.0 4.0     2.0   28.0                               262 9 80   22 4     2   28                        
1191167 OR     school 4107590 2092   Lowell SD 71 410759001846 5349 Bridge Charter Academy   Regular School Yes Other KG 11 2018   k_12_total 387.0 9.0 31.0   2.0 0.0     0.0   19.0                               387 9 31   2 0     0   19                        
1191270 OR     school 4108720 2254   Newberg SD 29J 410872001273 1221 Mountain View Middle School   Regular School No Middle 06 08 2018   k_12_total 343.0 9.0 122.0   3.0 5.0     0.0   23.0                               343 9 122   3 5     0   23                        
1191305 OR     school 4108830 1924   North Clackamas SD 12 410883001483 3198 Spring Mountain Elementary School   Regular School No Elementary KG 05 2018   k_12_total 357.0 9.0 43.0   5.0 80.0     3.0   58.0                               357 9 43   5 80     3   58                        
1191458 OR     school 4110040 2180   Portland SD 1J 411004000871 828 Atkinson Elementary School   Regular School No Elementary KG 05 2018   k_12_total 242.0 9.0 113.0   2.0 25.0     0.0   29.0                               242 9 113   2 25     0   29                        
1191540 OR     school 4110040 2180   Portland SD 1J   4477 SE Works Youth Center             2018   k_12_total 32.0 9.0 10.0   0.0 1.0     0.0   2.0                               32 9 10   0 1     0   2                        
1191575 OR     school 4110350 1977   Redmond SD 2J 411035000282 263 Redmond High School   Regular School No High 09 12 2018   k_12_total 715.0 9.0 190.0   15.0 6.0     4.0   34.0                               715 9 190   15 6     4   34                        
1191602 OR     school 4110520 2182   Reynolds SD 7 411052001005 951 Troutdale Elementary School   Regular School No Elementary KG 05 2018   k_12_total 277.0 9.0 91.0   1.0 22.0     5.0   24.0                               277 9 91   1 22     5   24                        
1191629 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000786 740 Grant Community School   Regular School No Elementary KG 05 2018   k_12_total 172.0 9.0 226.0   2.0 1.0     11.0   12.0                               172 9 226   2 1     11   12                        
1191632 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001443 3376 Hammond Elementary School   Regular School No Elementary KG 05 2018   k_12_total 177.0 9.0 274.0   0.0 25.0     6.0   24.0                               177 9 274   0 25     6   24                        
1191637 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000664 1330 Houck Middle School   Regular School No Middle 06 08 2018   k_12_total 311.0 9.0 639.0   5.0 18.0     43.0   36.0                               311 9 639   5 18     43   36                        
1191658 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000802 756 Pringle Elementary School   Regular School No Elementary KG 05 2018   k_12_total 404.0 9.0 95.0   2.0 36.0     15.0   39.0                               404 9 95   2 36     15   39                        
1191839 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001668 4364 Alberta Rider Elementary School   Regular School No Elementary KG 05 2018   k_12_total 337.0 9.0 95.0   1.0 71.0     6.0   39.0                               337 9 95   1 71     6   39                        
1705307 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2017   k_12_total 236.0 9.0 48.0     6.0     2.0   28.0                               236 9 48     6     2   28                        
1705337 OR     school 4101920 2243   Beaverton SD 48J 410192000213 1304 Arts and Communication Magnet Academy   Regular School No Other 06 12 2017   k_12_total 478.0 9.0 112.0     34.0     2.0   73.0                               478 9 112     34     2   73                        
1705359 OR     school 4101920 2243   Beaverton SD 48J 410192001216 1165 Hiteon Elementary School   Regular School No Elementary KG 05 2017   k_12_total 454.0 9.0 97.0     55.0     7.0   51.0                               454 9 97     55     7   51                        
1705424 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001454 3221 Westside Village Magnet School at Kingston Elementary School   Regular School No Elementary KG 08 2017   k_12_total 221.0 9.0 14.0     9.0     2.0   11.0                               221 9 14     9     2   11                        
1705429 OR     school 4102040 2088   Bethel SD 52 410204000616 582 Clear Lake Elementary School   Regular School No Elementary KG 05 2017   k_12_total 195.0 9.0 44.0     3.0     0.0   11.0                               195 9 44     3     0   11                        
1705443 OR     school 4102040 2088   Bethel SD 52 410204000622 587 Shasta Middle School   Regular School No Middle 06 08 2017   k_12_total 292.0 9.0 83.0     4.0     3.0   39.0                               292 9 83     4     3   39                        
1705532 OR     school 4103480 1901   Corvallis SD 509J 410348000032 27 Adams Elementary School   Regular School No Elementary KG 05 2017   k_12_total 327.0 9.0 13.0     23.0     2.0   29.0                               327 9 13     23     2   29                        
1705609 OR     school 4110710 1991   Douglas County SD 4 411071000298 278 John C Fremont Middle School   Regular School No Middle 06 08 2017   k_12_total 529.0 9.0 68.0     7.0     2.0   55.0                               529 9 68     7     2   55                        
1705647 OR     school 4104740 2082   Eugene SD 4J 410474001737 4554 Arts and Technology Academy at Jefferson   Regular School No Middle 06 08 2017   k_12_total 207.0 9.0 77.0     11.0     2.0   38.0                               207 9 77     11     2   38                        
1705659 OR     school 4104740 2082   Eugene SD 4J 410474000538 510 Edison Elementary School   Regular School No Elementary KG 05 2017   k_12_total 282.0 9.0 40.0     28.0     0.0   20.0                               282 9 40     28     0   20                        
1705719 OR     school 4105430 2245   Gaston SD 511J 410543001247 1194 Gaston Elementary School   Regular School No Elementary KG 06 2017   k_12_total 222.0 9.0 33.0     1.0     1.0   4.0                               222 9 33     1     1   4                        
1705784 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600004182 3543 Hogan Cedars Elementary School   Regular School No Elementary KG 05 2017   k_12_total 330.0 9.0 202.0     14.0     2.0   27.0                               330 9 202     14     2   27                        
1705836 OR     school 4100023 2239   Hillsboro SD 1J 410002301201 1150 Ladd Acres Elementary School   Regular School No Elementary KG 06 2017   k_12_total 256.0 9.0 126.0     69.0     9.0   56.0                               256 9 126     69     9   56                        
1705914 OR     school 4107020 2057   Klamath County SD 410702000502 477 Peterson Elementary School   Regular School No Elementary KG 06 2017   k_12_total 380.0 9.0 125.0     8.0     2.0   62.0                               380 9 125     8     2   62                        
1706026 OR     school 4108040 2048   Medford SD 549C 410804000443 422 McLoughlin Middle School   Regular School No Middle 06 08 2017   k_12_total 471.0 9.0 285.0     3.0     7.0   29.0                               471 9 285     3     7   29                        
1706089 OR     school 4108720 2254   Newberg SD 29J 410872001674 4342 Joan Austin Elementary School   Regular School No Elementary KG 05 2017   k_12_total 264.0 9.0 67.0     2.0     2.0   8.0                               264 9 67     2     2   8                        
1706183 OR     school 4100043 3477   ODE YCEP District 410004301406 2260 New Bridge High School   Regular School No Other 06 12 2017   k_12_total 41.0 9.0 16.0     1.0     0.0   7.0                               41 9 16     1     0   7                        
1706281 OR     school 4110040 2180   Portland SD 1J 411004000867 824 Alameda Elementary School   Regular School No Elementary KG 05 2017   k_12_total 628.0 9.0 39.0     8.0     0.0   63.0                               628 9 39     8     0   63                        
1706426 OR     school 4110520 2182   Reynolds SD 7 411052001004 950 Sweetbriar Elementary School   Regular School No Elementary KG 05 2017   k_12_total 249.0 9.0 97.0     15.0     2.0   34.0                               249 9 97     15     2   34                        
1706470 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001442 3375 Lamb Elementary School   Regular School No Elementary KG 05 2017   k_12_total 126.0 9.0 328.0     5.0     16.0   11.0                               126 9 328     5     16   11                        
1706472 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000812 766 Leslie Middle School   Regular School No Middle 06 08 2017   k_12_total 465.0 9.0 220.0     11.0     12.0   51.0                               465 9 220     11     12   51                        
1706484 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000803 757 Richmond Elementary School   Regular School No Elementary KG 05 2017   k_12_total 110.0 9.0 216.0     4.0     19.0   24.0                               110 9 216     4     19   24                        
1706670 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001298 1142 Edward Byrom Elementary School   Regular School No Elementary KG 05 2017   k_12_total 393.0 9.0 96.0     14.0     5.0   32.0                               393 9 96     14     5   32                        
1706680 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001195 1143 Tualatin Elementary School   Regular School No Elementary KG 05 2017   k_12_total 310.0 9.0 195.0     12.0     9.0   21.0                               310 9 195     12     9   21                        
1706711 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001356 1272 Boeckman Creek Primary School   Regular School No Elementary PK 05 2017   k_12_total 369.0 9.0 73.0     20.0     5.0   28.0                               369 9 73     20     5   28                        
1706722 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2017   k_12_total 1443.0 9.0 129.0     96.0     3.0   122.0                               1443 9 129     96     3   122                        
656798 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2021   k_12_total 185 9 43   2 7     0   28                               185 9 43   2 7     0   28                        
656897 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000263 1309 High Desert Middle School   Regular School No Middle 06 08 2021   k_12_total 504 9 223   1 5     3   18                               504 9 223   1 5     3   18                        
656909 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000271 252 Mountain View Senior High School   Regular School No High 09 12 2021   k_12_total 997 9 144   10 27     4   35                               997 9 144   10 27     4   35                        
657031 OR     school 4103480 1901   Corvallis SD 509J 410348000047 40 Corvallis High School   Regular School No High 09 12 2021   k_12_total 660 9 254   13 46     3   74                               660 9 254   13 46     3   74                        
657042 OR     school 4103480 1901   Corvallis SD 509J 410348000046 39 Wildcat Elementary School   Regular School No Elementary KG 05 2021   k_12_total 207 9 42   2 22     7   28                               207 9 42   2 22     7   28                        
657075 OR     school 4103940 2187   David Douglas SD 40 410394004181 3580 Arthur Academy   Regular School Yes Elementary KG 05 2021   k_12_total 77 9 19   2 31     3   17                               77 9 19   2 31     3   17                        
657142 OR     school 4104740 2082   Eugene SD 4J 410474001737 4554 Arts and Technology Academy at Jefferson   Regular School No Middle 06 08 2021   k_12_total 278 9 93   6 6     4   47                               278 9 93   6 6     4   47                        
657226 OR     school 4105610 1931   Gladstone SD 115 410561000146 138 Gladstone High School   Regular School No High 09 12 2021   k_12_total 434 9 97   7 9     5   41                               434 9 97   7 9     5   41                        
657285 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000993 939 Powell Valley Elementary School   Regular School No Elementary KG 05 2021   k_12_total 221 9 107   7 6     3   42                               221 9 107   7 6     3   42                        
657326 OR     school 4100023 2239   Hillsboro SD 1J   2239 Hillsboro SD 1J             2021   k_12_total 150 9 106   0 9     0   18                               150 9 106   0 9     0   18                        
657328 OR     school 4100023 2239   Hillsboro SD 1J 410002301295 1148 Indian Hills Elementary School   Regular School No Elementary KG 06 2021   k_12_total 162 9 90   2 74     8   55                               162 9 90   2 74     8   55                        
657335 OR     school 4100023 2239   Hillsboro SD 1J 410002301305 1116 Minter Bridge Elementary School   Regular School No Elementary KG 06 2021   k_12_total 135 9 172   3 18     0   33                               135 9 172   3 18     0   33                        
657339 OR     school 4100023 2239   Hillsboro SD 1J 410002301500 3159 Paul L Patterson Elementary School   Regular School No Elementary KG 06 2021   k_12_total 219 9 85   1 19     1   42                               219 9 85   1 19     1   42                        
657347 OR     school 4100023 2239   Hillsboro SD 1J 410002301172 1114 W Verne McKinney Elementary School   Regular School No Elementary KG 06 2021   k_12_total 137 9 260   1 10     0   22                               137 9 260   1 10     0   22                        
657784 OR     school 4110040 2180   Portland SD 1J 411004000901 857 Beverly Cleary School   Regular School No Elementary KG 08 2021   k_12_total 546 9 51   3 15     1   66                               546 9 51   3 15     1   66                        
657790 OR     school 4110040 2180   Portland SD 1J 411004000881 838 Capitol Hill Elementary School   Regular School No Elementary KG 05 2021   k_12_total 265 9 33   2 10     1   26                               265 9 33   2 10     1   26                        
657836 OR     school 4110040 2180   Portland SD 1J   1803 Mt Scott Park Center for Learning             2021   k_12_total 83 9 33   0 3     0   20                               83 9 33   0 3     0   20                        
657869 OR     school 4110040 2180   Portland SD 1J 411004000941 893 Sunnyside Environmental School   Regular School No Elementary KG 08 2021   k_12_total 380 9 59   1 7     1   68                               380 9 59   1 7     1   68                        
657943 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001342 1244 Chapman Hill Elementary School   Regular School No Elementary KG 05 2021   k_12_total 247 9 59   0 14     3   24                               247 9 59   0 14     3   24                        
657952 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000784 738 Four Corners Elementary School   Regular School No Elementary KG 05 2021   k_12_total 75 9 312   1 9     17   15                               75 9 312   1 9     17   15                        
657954 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000791 745 Gubser Elementary School   Regular School No Elementary KG 05 2021   k_12_total 264 9 147   2 9     1   40                               264 9 147   2 9     1   40                        
657959 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000789 743 Highland Elementary School   Regular School No Elementary KG 05 2021   k_12_total 120 9 195   2 1     20   21                               120 9 195   2 1     20   21                        
657978 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000800 754 Myers Elementary School   Regular School No Elementary KG 05 2021   k_12_total 218 9 99   4 5     6   31                               218 9 99   4 5     6   31                        
657994 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000808 762 Swegle Elementary School   Regular School No Elementary KG 05 2021   k_12_total 118 9 371   4 15     35   15                               118 9 371   4 15     35   15                        
658040 OR     school 4111290 2244   Sherwood SD 88J 411129001245 1192 Sherwood Middle School   Regular School No Middle 06 08 2021   k_12_total 935 9 127   4 43     7   84                               935 9 127   4 43     7   84                        
658096 OR     school 4111670 2083   Springfield SD 19 411167000582 548 Guy Lee Elementary School   Regular School No Elementary KG 05 2021   k_12_total 126 9 107   3 1     10   16                               126 9 107   3 1     10   16                        

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]);