Data source: Big Local News · About: Big Local

20,580 rows where state = "OR" and year = 2017 sorted by white descending

View and edit SQL

grade

year

  • 2017 · 20,580
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
1706311 OR     school 4110040 2180   Portland SD 1J 411004000962 912 Grant High School   Regular School No High 09 12 2017   k_12_total 999.0 119.0 101.0     70.0     3.0   170.0                               999 119 101     70     3   170                        
1705388 OR     school 4101920 2243   Beaverton SD 48J 410192001232 1179 William Walker Elementary School   Regular School No Elementary KG 05 2017   k_12_total 99.0 5.0 339.0     26.0     5.0   17.0                               99 5 339     26     5   17                        
1705445 OR     school 4102040 2088   Bethel SD 52 410204000623 588 Willamette High School   Regular School No High 09 12 2017   k_12_total 988.0 34.0 254.0     41.0     9.0   89.0                               988 34 254     41     9   89                        
1705902 OR     school 4107020 2057   Klamath County SD 410702001465 472 Gilchrist Elementary School   Regular School No Elementary KG 06 2017   k_12_total 98.0 0.0 5.0     0.0     0.0   8.0                               98 0 5     0     0   8                        
1706359 OR     school 4110040 2180   Portland SD 1J 411004000931 884 Rigler Elementary School   Regular School No Elementary KG 05 2017   k_12_total 98.0 65.0 264.0     13.0     4.0   24.0                               98 65 264     13     4   24                        
1706370 OR     school 4110040 2180   Portland SD 1J 411004000937 889 Sitton Elementary School   Regular School No Elementary KG 05 2017   k_12_total 98.0 63.0 150.0     10.0     9.0   59.0                               98 63 150     10     9   59                        
1705456 OR     school 4102640 1929   Canby SD 86 410264000148 140 Canby High School   Regular School No High 09 12 2017   k_12_total 976.0 4.0 399.0     7.0     3.0   57.0                               976 4 399     7     3   57                        
1705340 OR     school 4101920 2243   Beaverton SD 48J 410192001240 1187 Beaverton High School   Regular School No High 09 12 2017   k_12_total 970.0 54.0 555.0     101.0     29.0   115.0                               970 54 555     101     29   115                        
1706340 OR     school 4110040 2180   Portland SD 1J   1803 Mt Scott Park Center for Learning             2017   k_12_total 97.0 19.0 27.0     2.0     0.0   10.0                               97 19 27     2     0   10                        
1705379 OR     school 4101920 2243   Beaverton SD 48J 410192001432 2783 Southridge High School   Regular School No High 09 12 2017   k_12_total 969.0 40.0 271.0     200.0     17.0   155.0                               969 40 271     200     17   155                        
1705948 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2017   k_12_total 969.0 12.0 71.0     163.0     3.0   92.0                               969 12 71     163     3   92                        
1706192 OR     school 4109270 2108   Ontario SD 8C 410927000741 694 Aiken Elementary School   Regular School No Elementary KG 05 2017   k_12_total 96.0 6.0 188.0     0.0     0.0   14.0                               96 6 188     0     0   14                        
1706384 OR     school 4110040 2180   Portland SD 1J 411004000953 903 Woodmere Elementary School   Regular School No Elementary KG 05 2017   k_12_total 96.0 28.0 73.0     63.0     7.0   31.0                               96 28 73     63     7   31                        
1706412 OR     school 4110520 2182   Reynolds SD 7 411052001003 949 Davis Elementary School   Regular School No Elementary KG 05 2017   k_12_total 96.0 48.0 227.0     39.0     13.0   30.0                               96 48 227     39     13   30                        
1706668 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001722 2714 Durham Center   Alternative School No Other 06 12 2017   k_12_total 96.0 2.0 32.0     3.0     0.0   10.0                               96 2 32     3     0   10                        
1706731 OR     school 4113350 2255   Willamina SD 30J 411335001338 1225 Willamina Middle School   Regular School No Middle 07 08 2017   k_12_total 96.0 1.0 13.0     1.0     1.0   3.0                               96 1 13     1     1   3                        
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                        
1705860 OR     school 4106510 2024   Hood River County SD 410651000383 363 Mid Valley Elementary School   Regular School No Elementary KG 05 2017   k_12_total 95.0 1.0 389.0     0.0     0.0   11.0                               95 1 389     0     0   11                        
1705937 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Elementary KG KG 2017   k_12_total 95.0 0.0 11.0     3.0     4.0   5.0                               95 0 11     3     4   5                        
1706582 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2017   k_12_total 95.0 0.0 19.0     0.0     0.0   8.0                               95 0 19     0     0   8                        
1706421 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2017   k_12_total 932.0 195.0 1029.0     260.0     40.0   134.0                               932 195 1029     260     40   134                        
1705306 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Elementary School   Regular School No Elementary KG 08 2017   k_12_total 93.0 3.0 10.0     3.0     0.0   16.0                               93 3 10     3     0   16                        
1705540 OR     school 4103480 1901   Corvallis SD 509J 410348001743 4637 Inavale Community Partners dba Muddy Creek Charter School   Regular School Yes Elementary KG 05 2017   k_12_total 93.0 2.0 12.0     0.0     0.0   3.0                               93 2 12     0     0   3                        
1705578 OR     school 4103940 2187   David Douglas SD 40 410394004181 3580 Arthur Academy   Regular School Yes Elementary KG 05 2017   k_12_total 92.0 8.0 16.0     19.0     3.0   17.0                               92 8 16     19     3   17                        
1706000 OR     school 4107980 2090   McKenzie SD 68 410798000628 593 McKenzie Elementary School   Regular School No Elementary KG 08 2017   k_12_total 92.0 1.0 18.0     1.0     0.0   9.0                               92 1 18     1     0   9                        
1706161 OR     school 4109000 2110   Nyssa SD 26 410900000752 704 Nyssa High School   Regular School No High 09 12 2017   k_12_total 92.0 0.0 225.0     1.0     0.0   6.0                               92 0 225     1     0   6                        
1706296 OR     school 4110040 2180   Portland SD 1J 411004000884 841 Cesar Chavez K-8 School   Regular School No Elementary KG 08 2017   k_12_total 92.0 86.0 307.0     7.0     27.0   29.0                               92 86 307     7     27   29                        
1705763 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000736 650 South Albany High School   Regular School No High 09 12 2017   k_12_total 913.0 14.0 367.0     8.0     5.0   77.0                               913 14 367     8     5   77                        
1705632 OR     school 4104590 2217   Elgin SD 23 410459001141 1083 Elgin High School   Regular School No High 09 12 2017   k_12_total 91.0 0.0 3.0     1.0     0.0   6.0                               91 0 3     1     0   6                        
1705675 OR     school 4104740 2082   Eugene SD 4J 410474001593 4041 Network Charter School   Regular School Yes High 07 12 2017   k_12_total 91.0 3.0 14.0     1.0     0.0   13.0                               91 3 14     1     0   13                        
1706379 OR     school 4110040 2180   Portland SD 1J 411004000949 900 Whitman Elementary School   Regular School No Elementary KG 05 2017   k_12_total 91.0 17.0 83.0     39.0     2.0   20.0                               91 17 83     39     2   20                        
1706571 OR     school 4111580 2087   South Lane SD 45J3 411158000612 577 Latham Elementary School   Regular School No Elementary KG 05 2017   k_12_total 91.0 1.0 4.0     1.0     0.0   2.0                               91 1 4     1     0   2                        
1706457 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001444 3377 Hallman Elementary School   Regular School No Elementary KG 05 2017   k_12_total 90.0 4.0 271.0     2.0     16.0   10.0                               90 4 271     2     16   10                        
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                        
1705551 OR     school 4103690 2086   Creswell SD 40   2086 Creswell SD 40             2017   k_12_total 9.0 0.0 2.0     0.0     0.0   0.0                               9 0 2     0     0   0                        
1705867 OR     school   2200   InterMountain ESD   4846 Lifeways Inc             2017   k_12_total 9.0 0.0 0.0     0.0     0.0   1.0                               9 0 0     0     0   1                        
1705876 OR     school 4106740 2053   Jefferson County SD 509J 410674000454 432 Warm Springs K-8 Academy   Regular School No Elementary KG 08 2017   k_12_total 9.0 0.0 40.0     0.0     1.0   14.0                               9 0 40     0     1   14                        
1705921 OR     school 4107080 2056   Klamath Falls City Schools   2056 Klamath Falls City Schools             2017   k_12_total 9.0 1.0 5.0     0.0     0.0   1.0                               9 1 5     0     0   1                        
1706198 OR     school 4109270 2108   Ontario SD 8C   2108 Ontario SD 8C             2017   k_12_total 9.0 2.0 32.0     0.0     0.0   1.0                               9 2 32     0     0   1                        
1706673 OR     school 4112240 2242   Tigard-Tualatin SD 23J   2273 Janus Youth Programs--Cordero House             2017   k_12_total 9.0 0.0 0.0     0.0     0.0   1.0                               9 0 0     0     0   1                        
1705827 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2017   k_12_total 898.0 24.0 551.0     50.0     5.0   62.0                               898 24 551     50     5   62                        
1705709 OR     school 4105160 2241   Forest Grove SD 15 410516001189 1134 Forest Grove High School   Regular School No High 09 12 2017   k_12_total 891.0 12.0 941.0     23.0     5.0   53.0                               891 12 941     23     5   53                        
1705999 OR     school 4107740 2094   Marcola SD 79J 410774000639 604 Mohawk High School   Regular School No High 07 12 2017   k_12_total 89.0 0.0 5.0     2.0     0.0   7.0                               89 0 5     2     0   7                        
1706583 OR     school 4100021 2225   South Wasco County SD 1 410002101167 1109 South Wasco County High School   Regular School No High 07 12 2017   k_12_total 89.0 0.0 12.0     0.0     1.0   1.0                               89 0 12     0     1   1                        
1706628 OR     school 4111760 2144   St Paul SD 45 411176000824 779 St Paul High School   Regular School No High 07 12 2017   k_12_total 89.0 0.0 43.0     0.0     0.0   1.0                               89 0 43     0     0   1                        
1705949 OR     school 4107230 1923   Lake Oswego SD 7J 410723000069 62 Lakeridge High School   Regular School No High 09 12 2017   k_12_total 886.0 10.0 62.0     73.0     1.0   82.0                               886 10 62     73     1   82                        
1706033 OR     school 4108040 2048   Medford SD 549C 410804001843 5304 The Valley School of Southern Oregon   Regular School Yes Middle 06 08 2017   k_12_total 88.0 0.0 6.0     3.0     0.0   3.0                               88 0 6     3     0   3                        
1706050 OR     school 4108310 1925   Molalla River SD 35 410831001800 4818 Renaissance Public Academy   Regular School Yes Other 04 12 2017   k_12_total 88.0 0.0 17.0     0.0     0.0   8.0                               88 0 17     0     0   8                        
1706229 OR     school 4110890 1926   Oregon Trail SD 46   1926 Oregon Trail SD 46             2017   k_12_total 88.0 3.0 12.0     0.0     0.0   6.0                               88 3 12     0     0   6                        
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                        
1706450 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001717 4589 Early College High School   Alternative School No High 09 12 2017   k_12_total 87.0 2.0 83.0     5.0     4.0   9.0                               87 2 83     5     4   9                        
1706552 OR     school 4111450 2138   Silver Falls SD 4J 411145001769 4746 The Community Roots School   Regular School Yes Elementary KG 06 2017   k_12_total 87.0 0.0 8.0     1.0     0.0   6.0                               87 0 8     1     0   6                        
1706487 OR     school 4110820 2142   Salem-Keizer SD 24J   2142 Salem-Keizer SD 24J             2017   k_12_total 86.0 2.0 40.0     3.0     1.0   8.0                               86 2 40     3     1   8                        
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                        
1706705 OR     school 4112990 2220   Wallowa SD 12 411299001371 1088 Wallowa Elementary School   Regular School No Elementary PK 06 2017   k_12_total 86.0 0.0 7.0     0.0     0.0   2.0                               86 0 7     0     0   2                        
1706706 OR     school 4112990 2220   Wallowa SD 12 411299001147 1089 Wallowa High School   Regular School No High 07 12 2017   k_12_total 86.0 0.0 4.0     1.0     1.0   4.0                               86 0 4     1     1   4                        
1705321 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   k_12_total 856.0 20.0 90.0     19.0     2.0   26.0                               856 20 90     19     2   26                        
1705861 OR     school 4106510 2024   Hood River County SD 410651000384 364 Parkdale Elementary School   Regular School No Elementary KG 05 2017   k_12_total 85.0 2.0 108.0     3.0     0.0   2.0                               85 2 108     3     0   2                        
1705938 OR     school 4107280 2059   Lake County SD 7 410728000689 491 Daly Middle School   Regular School No Middle 07 08 2017   k_12_total 85.0 0.0 16.0     0.0     0.0   2.0                               85 0 16     0     0   2                        
1705979 OR     school 4107500 2097   Lincoln County SD 410750001334 622 Toledo Jr. High   Regular School No Middle 07 08 2017   k_12_total 85.0 1.0 10.0     0.0     0.0   12.0                               85 1 10     0     0   12                        
1706061 OR     school 4108520 2147   Morrow SD 1 410852000863 820 Riverside Junior/Senior High School   Regular School No High 07 12 2017   k_12_total 85.0 2.0 334.0     0.0     0.0   5.0                               85 2 334     0     0   5                        
1706162 OR     school 4109000 2110   Nyssa SD 26 410900000751 703 Nyssa Middle School   Regular School No Middle 06 08 2017   k_12_total 85.0 0.0 163.0     5.0     0.0   7.0                               85 0 163     5     0   7                        
1706646 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000422 402 Applegate Elementary School   Regular School No Elementary KG 08 2017   k_12_total 85.0 0.0 10.0     0.0     0.0   5.0                               85 0 10     0     0   5                        
1706746 OR     school 4113530 2146   Woodburn SD 103 411353001713 4542 Woodburn Academy of Art, Science and Technology   Regular School No High 09 12 2017   k_12_total 85.0 2.0 312.0     0.0     1.0   3.0                               85 2 312     0     1   3                        
1705301 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2017   k_12_total 843.0 24.0 76.0     27.0     3.0   81.0                               843 24 76     27     3   81                        
1706691 OR     school 4112600 2204   Umatilla SD 6R 411260001090 1031 Clara Brownell Middle School   Regular School No Middle 06 08 2017   k_12_total 84.0 1.0 199.0     0.0     0.0   1.0                               84 1 199     0     0   1                        
1706195 OR     school 4109270 2108   Ontario SD 8C 410927000743 696 May Roberts Elementary School   Regular School No Elementary KG 06 2017   k_12_total 83.0 8.0 269.0     2.0     0.0   11.0                               83 8 269     2     0   11                        
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                        
1706598 OR     school 4111670 2083   Springfield SD 19 411167000978 1354 Gateways High School   Regular School No High 09 12 2017   k_12_total 82.0 3.0 38.0     2.0     0.0   12.0                               82 3 38     2     0   12                        
1706725 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2017   k_12_total 817.0 14.0 199.0     32.0     5.0   83.0                               817 14 199     32     5   83                        
1705733 OR     school 4105640 2000   Glendale SD 77 410564000327 307 Glendale Community Charter School   Regular School Yes High 09 12 2017   k_12_total 81.0 0.0 8.0     0.0     0.0   1.0                               81 0 8     0     0   1                        
1705803 OR     school 4106120 2114   Harper SD 66 410612000758 3362 Harper Charter School   Regular School Yes Other KG 12 2017   k_12_total 81.0 1.0 15.0     0.0     0.0   2.0                               81 1 15     0     0   2                        
1706282 OR     school 4110040 2180   Portland SD 1J 411004001652 4507 Alliance High School   Alternative School No High 09 12 2017   k_12_total 81.0 39.0 41.0     3.0     4.0   23.0                               81 39 41     3     4   23                        
1706309 OR     school 4110040 2180   Portland SD 1J 411004000893 849 George Middle School   Regular School No Middle 06 08 2017   k_12_total 81.0 88.0 136.0     17.0     9.0   27.0                               81 88 136     17     9   27                        
1706465 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001536 4210 Jane Goodall Environmental Middle Charter School   Regular School Yes Middle 06 08 2017   k_12_total 81.0 0.0 8.0     0.0     0.0   7.0                               81 0 8     0     0   7                        
1705515 OR     school 4103330 2006   Condon SD 25J 410333000345 325 Condon Elementary School   Regular School No Elementary KG 08 2017   k_12_total 80.0 0.0 7.0     0.0     0.0   2.0                               80 0 7     0     0   2                        
1705754 OR     school 4101120 2100   Greater Albany Public SD 8J   2100 Greater Albany Public SD 8J             2017   k_12_total 80.0 0.0 10.0     0.0     1.0   7.0                               80 0 10     0     1   7                        
1705959 OR     school 4107380 2101   Lebanon Community SD 9   2101 Lebanon Community SD 9             2017   k_12_total 80.0 0.0 7.0     0.0     0.0   2.0                               80 0 7     0     0   2                        
1706411 OR     school 4110520 2182   Reynolds SD 7 411052000997 943 Alder Elementary School   Regular School No Elementary KG 05 2017   k_12_total 80.0 60.0 281.0     33.0     22.0   29.0                               80 60 281     33     22   29                        
1706544 OR     school 4111450 2138   Silver Falls SD 4J 411145000766 718 Evergreen Elementary School   Regular School No Elementary KG 08 2017   k_12_total 80.0 0.0 1.0     1.0     0.0   1.0                               80 0 1     1     0   1                        
1706562 OR     school 4111580 2087   South Lane SD 45J3 411158001390 1791 Al Kennedy Alternative High School   Alternative School No High 09 12 2017   k_12_total 80.0 0.0 5.0     1.0     1.0   2.0                               80 0 5     1     1   2                        
1705288 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Elementary 04 08 2017   k_12_total 8.0 0.0 0.0     0.0     0.0   0.0                               8 0 0     0     0   0                        
1705546 OR     school 4103480 1901   Corvallis SD 509J   1874 YES House Alternative School             2017   k_12_total 8.0 0.0 5.0     0.0     0.0   3.0                               8 0 5     0     0   3                        
1705554 OR     school 4103720 1970   Crook County SD 410372001841 265 Brothers Elementary School   Regular School No Elementary KG 08 2017   k_12_total 8.0 0.0 0.0     0.0     0.0   0.0                               8 0 0     0     0   0                        
1705618 OR     school 4104380 2019   Drewsey SD 13 410438000369 350 Drewsey Elementary School   Regular School No Elementary KG 08 2017   k_12_total 8.0 0.0 1.0     0.0     0.0   0.0                               8 0 1     0     0   0                        
1706072 OR     school 4180180 2148   Multnomah ESD   1648 Morrison Center Counterpoint Program             2017   k_12_total 8.0 0.0 1.0     1.0     0.0   2.0                               8 0 1     1     0   2                        
1706177 OR     school   3476   ODE JDEP District   2846 Marion County Juvenile Detention             2017   k_12_total 8.0 0.0 11.0     0.0     0.0   0.0                               8 0 11     0     0   0                        
1706271 OR     school 4109750 2047   Pinehurst SD 94 410975000427 407 Pinehurst Elementary School   Regular School No Elementary KG 08 2017   k_12_total 8.0 0.0 0.0     0.0     0.0   1.0                               8 0 0     0     0   1                        
1706291 OR     school 4110040 2180   Portland SD 1J   907 Boys & Girls Aid Society/Johns Landing School             2017   k_12_total 8.0 0.0 1.0     0.0     1.0   2.0                               8 0 1     0     1   2                        
1706560 OR     school 4105020 2022   South Harney SD 33 410502001383 357 Fields Elementary School   Regular School No Elementary KG 08 2017   k_12_total 8.0 0.0 2.0     0.0     0.0   2.0                               8 0 2     0     0   2                        
1706738 OR     school 4113530 2146   Woodburn SD 103 411353001714 4540 Academy of International Studies (at Woodburn)   Regular School No High 09 12 2017   k_12_total 8.0 0.0 272.0     0.0     0.0   1.0                               8 0 272     0     0   1                        
1705780 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001040 986 Gresham High School   Regular School No High 09 12 2017   k_12_total 799.0 77.0 514.0     61.0     12.0   85.0                               799 77 514     61     12   85                        
1705655 OR     school 4104740 2082   Eugene SD 4J 410474000575 540 Churchill High School   Regular School No High 09 12 2017   k_12_total 798.0 38.0 178.0     28.0     10.0   96.0                               798 38 178     28     10   96                        
1705707 OR     school 4105160 2241   Forest Grove SD 15 410516001578 3986 Fern Hill Elementary School   Regular School No Elementary KG 04 2017   k_12_total 79.0 5.0 247.0     4.0     3.0   9.0                               79 5 247     4     3   9                        
1706290 OR     school 4110040 2180   Portland SD 1J 411004000876 833 Boise-Eliot Elementary School   Regular School No Elementary PK 08 2017   k_12_total 79.0 301.0 63.0     12.0     1.0   48.0                               79 301 63     12     1   48                        
1706422 OR     school 4110520 2182   Reynolds SD 7 411052001471 1343 Reynolds Learning Academy   Alternative School No High 07 12 2017   k_12_total 79.0 24.0 96.0     4.0     3.0   9.0                               79 24 96     4     3   9                        
1706720 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001437 3452 Three Rivers Charter School   Regular School Yes Elementary 04 08 2017   k_12_total 79.0 0.0 6.0     14.0     0.0   11.0                               79 0 6     14     0   11                        
1705534 OR     school 4103480 1901   Corvallis SD 509J 410348000047 40 Corvallis High School   Regular School No High 09 12 2017   k_12_total 784.0 22.0 216.0     59.0     10.0   105.0                               784 22 216     59     10   105                        
1706123 OR     school 4108830 1924   North Clackamas SD 12 410883000095 87 Putnam High School   Regular School No High 09 12 2017   k_12_total 784.0 16.0 228.0     25.0     3.0   76.0                               784 16 228     25     3   76                        
1705910 OR     school 4107020 2057   Klamath County SD 410702000511 486 Lost River High School   Regular School No High 07 12 2017   k_12_total 78.0 0.0 122.0     0.0     1.0   1.0                               78 0 122     0     1   1                        

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