Data source: Big Local News · About: Big Local

82,026 rows where state = "OR" sorted by white descending

View and edit SQL

grade

year

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                        
1191139 OR     school 4107380 2101   Lebanon Community SD 9 410738000730 688 Lebanon High School   Regular School No High 09 12 2018   k_12_total 999.0 6.0 137.0   24.0 19.0     7.0   62.0                               999 6 137   24 19     7   62                        
658051 OR     school 4111450 2138   Silver Falls SD 4J 411145000857 812 Silverton High School   Regular School No High 09 12 2021   k_12_total 998 11 195   15 13     4   30                               998 11 195   15 13     4   30                        
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                        
917310 OR     school 4107380 2101   Lebanon Community SD 9 410738000730 688 Lebanon High School   Regular School No High 09 12 2020   k_12_total 996 8 153   23 19     9   71                               996 8 153   23 19     9   71                        
658107 OR     school 4111670 2083   Springfield SD 19   2083 Springfield SD 19             2021   k_12_total 995 3 205   8 6     3   81                               995 3 205   8 6     3   81                        
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                        
1191336 OR     school 4109000 2110   Nyssa SD 26 410900000752 704 Nyssa High School   Regular School No High 09 12 2018   k_12_total 99.0 0.0 240.0   0.0 3.0     0.0   5.0                               99 0 240   0 3     0   5                        
916776 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   k_12_total 99 1 9   3 0     0   5                               99 1 9   3 0     0   5                        
916888 OR     school 4103480 1901   Corvallis SD 509J 410348001743 4637 Inavale Community Partners dba Muddy Creek Charter School   Regular School Yes Elementary KG 05 2020   k_12_total 99 3 13   0 0     0   6                               99 3 13   0 0     0   6                        
657323 OR     school 4100023 2239   Hillsboro SD 1J 410002301203 1152 Groner K-8   Regular School No Elementary KG 08 2021   k_12_total 99 1 57   2 3     1   7                               99 1 57   2 3     1   7                        
657530 OR     school 4108040 2048   Medford SD 549C 410804001843 5304 The Valley School of Southern Oregon   Regular School Yes Middle 06 08 2021   k_12_total 99 1 13   0 2     1   4                               99 1 13   0 2     1   4                        
658126 OR     school 4111760 2144   St Paul SD 45 411176000824 779 St Paul High School   Regular School No High 07 12 2021   k_12_total 99 1 50   0 0     0   2                               99 1 50   0 0     0   2                        
658155 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690001797 4823 Sunny Wolf Charter School   Regular School Yes Elementary PK 06 2021   k_12_total 99 0 8   1 0     0   9                               99 0 8   1 0     0   9                        
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                        
657827 OR     school 4110040 2180   Portland SD 1J 411004000966 914 Lincoln High School   Regular School No High 09 12 2021   k_12_total 988 26 160   3 148     2   155                               988 26 160   3 148     2   155                        
658176 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000440 1301 Tualatin High School   Regular School No High 09 12 2021   k_12_total 988 27 538   9 118     46   140                               988 27 538   9 118     46   140                        
917572 OR     school 4110890 1926   Oregon Trail SD 46 411089000149 141 Sandy High School   Regular School No High 09 12 2020   k_12_total 982 9 193   13 14     4   82                               982 9 193   13 14     4   82                        
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                        
1190747 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000624 589 Applegate Elementary School   Regular School No Elementary KG 06 2018   k_12_total 98.0 0.0 2.0   0.0 2.0     0.0   9.0                               98 0 2   0 2     0   9                        
1190844 OR     school 4104740 2082   Eugene SD 4J   2082 Eugene SD 4J             2018   k_12_total 98.0 5.0 10.0   2.0 2.0     0.0   11.0                               98 5 10   2 2     0   11                        
1191514 OR     school 4110040 2180   Portland SD 1J   1803 Mt Scott Park Center for Learning             2018   k_12_total 98.0 7.0 23.0   1.0 3.0     1.0   11.0                               98 7 23   1 3     1   11                        
1191636 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000790 744 Hoover Elementary School   Regular School No Elementary KG 05 2018   k_12_total 98.0 19.0 290.0   1.0 1.0     16.0   15.0                               98 19 290   1 1     16   15                        
917410 OR     school 4108520 2147   Morrow SD 1 410852000863 820 Riverside Junior/Senior High School   Regular School No High 07 12 2020   k_12_total 98 1 364   0 0     1   3                               98 1 364   0 0     1   3                        
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                        
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                        
917832 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000787 741 Scott Elementary School   Regular School No Elementary KG 05 2020   k_12_total 98 3 367   2 9     45   13                               98 3 367   2 9     45   13                        
917973 OR     school 4111790 2209   Stanfield SD 61 411179001119 1060 Stanfield Elementary School   Regular School No Elementary KG 05 2020   k_12_total 98 0 114   0 0     0   8                               98 0 114   0 0     0   8                        
657037 OR     school 4103480 1901   Corvallis SD 509J 410348001743 4637 Inavale Community Partners dba Muddy Creek Charter School   Regular School Yes Elementary KG 05 2021   k_12_total 98 0 14   0 0     0   7                               98 0 14   0 0     0   7                        
657356 OR     school 4106510 2024   Hood River County SD 410651000384 364 Parkdale Elementary School   Regular School No Elementary KG 05 2021   k_12_total 98 0 115   12 0     0   7                               98 0 115   12 0     0   7                        
658079 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2021   k_12_total 98 0 9   4 0     0   8                               98 0 9   4 0     0   8                        
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                        
916927 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2020   k_12_total 970 346 763   20 501     62   184                               970 346 763   20 501     62   184                        
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                        
1191040 OR     school 4106510 2024   Hood River County SD 410651000383 363 Mid Valley Elementary School   Regular School No Elementary KG 05 2018   k_12_total 97.0 0.0 398.0   2.0 1.0     0.0   13.0                               97 0 398   2 1     0   13                        
1191217 OR     school 4108160 2205   Milton-Freewater Unified SD 7 410816001837 5295 Grove Elementary School   Regular School No Elementary KG 01 2018   k_12_total 97.0 1.0 152.0   3.0 1.0     0.0   0.0                               97 1 152   3 1     0   0                        
1191236 OR     school 4108520 2147   Morrow SD 1 410852001598 4048 Irrigon Elementary School   Regular School No Middle 04 06 2018   k_12_total 97.0 0.0 117.0   0.0 0.0     0.0   3.0                               97 0 117   0 0     0   3                        
1191631 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001444 3377 Hallman Elementary School   Regular School No Elementary KG 05 2018   k_12_total 97.0 2.0 285.0   2.0 4.0     19.0   17.0                               97 2 285   2 4     19   17                        
917185 OR     school 4100023 2239   Hillsboro SD 1J 410002301749 4642 Lincoln Street Elementary School   Regular School No Elementary KG 06 2020   k_12_total 97 7 352   0 3     2   10                               97 7 352   0 3     2   10                        
917406 OR     school 4108520 2147   Morrow SD 1 410852001598 4048 Irrigon Elementary School   Regular School No Middle 04 06 2020   k_12_total 97 0 109   0 0     1   8                               97 0 109   0 0     1   8                        
917670 OR     school 4110040 2180   Portland SD 1J 411004000915 870 Lent Elementary School   Regular School No Elementary KG 08 2020   k_12_total 97 43 241   7 57     7   23                               97 43 241   7 57     7   23                        
917710 OR     school 4110040 2180   Portland SD 1J 411004000937 889 Sitton Elementary School   Regular School No Elementary KG 05 2020   k_12_total 97 39 171   7 8     6   46                               97 39 171   7 8     6   46                        
917770 OR     school 4110520 2182   Reynolds SD 7 411052001006 952 Wilkes Elementary School   Regular School No Elementary KG 05 2020   k_12_total 97 77 183   6 64     42   37                               97 77 183   6 64     42   37                        
657061 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000627 592 Crow Middle/High School   Regular School No High 07 12 2021   k_12_total 97 0 7   2 1     0   10                               97 0 7   2 1     0   10                        
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                        
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                        
657235 OR     school 4105670 1992   Glide SD 12 410567000303 284 Glide Middle School   Regular School No Middle 07 08 2021   k_12_total 97 0 9   1 0     0   7                               97 0 9   1 0     0   7                        
657246 OR     school 4101120 2100   Greater Albany Public SD 8J 410112001577 3950 Albany Options School   Alternative School No High 09 12 2021   k_12_total 97 0 27   3 0     2   8                               97 0 27   3 0     2   8                        
657732 OR     school 4109480 2181   Parkrose SD 3 410948000979 925 Prescott Elementary School   Regular School No Elementary PK 05 2021   k_12_total 97 53 92   2 19     17   28                               97 53 92   2 19     17   28                        
657866 OR     school 4110040 2180   Portland SD 1J 411004000937 889 Sitton Elementary School   Regular School No Elementary KG 05 2021   k_12_total 97 36 145   5 8     7   41                               97 36 145   5 8     7   41                        
657871 OR     school 4110040 2180   Portland SD 1J 411004000945 896 Vestal Elementary School   Regular School No Elementary KG 05 2021   k_12_total 97 37 29   0 30     5   30                               97 37 29   0 30     5   30                        
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                        
1191788 OR     school 4111670 2083   Springfield SD 19 411167000595 561 Thurston High School   Regular School No High 09 12 2018   k_12_total 969.0 5.0 184.0   16.0 10.0     7.0   125.0                               969 5 184   16 10     7   125                        
657460 OR     school 4107380 2101   Lebanon Community SD 9 410738000730 688 Lebanon High School   Regular School No High 09 12 2021   k_12_total 969 4 134   12 12     6   77                               969 4 134   12 12     6   77                        
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                        
1191544 OR     school 4110040 2180   Portland SD 1J 411004000937 889 Sitton Elementary School   Regular School No Elementary KG 05 2018   k_12_total 96.0 58.0 144.0   11.0 9.0     6.0   40.0                               96 58 144   11 9     6   40                        
917200 OR     school 4100023 2239   Hillsboro SD 1J 410002301202 1151 Witch Hazel Elementary School   Regular School No Elementary KG 06 2020   k_12_total 96 20 361   0 20     1   24                               96 20 361   0 20     1   24                        
917830 OR     school 4110820 2142   Salem-Keizer SD 24J   2142 Salem-Keizer SD 24J             2020   k_12_total 96 3 40   2 2     6   8                               96 3 40   2 2     6   8                        
917972 OR     school 4111760 2144   St Paul SD 45 411176000824 779 St Paul High School   Regular School No High 07 12 2020   k_12_total 96 0 51   0 0     0   0                               96 0 51   0 0     0   0                        
656885 OR     school 4101920 2243   Beaverton SD 48J 410192001232 1179 William Walker Elementary School   Regular School No Elementary PK 05 2021   k_12_total 96 10 320   1 18     4   25                               96 10 320   1 18     4   25                        
657064 OR     school 4103840 2050   Culver SD 4 410384000119 1295 Culver Middle School   Regular School No Middle 06 08 2021   k_12_total 96 0 58   1 0     0   10                               96 0 58   1 0     0   10                        
657846 OR     school 4110040 2180   Portland SD 1J 411004001667 4400 Portland Arthur Academy Charter School   Regular School Yes Elementary KG 05 2021   k_12_total 96 14 13   0 28     0   26                               96 14 13   0 28     0   26                        
657942 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001826 5064 Cesar E Chavez Elementary   Regular School No Elementary KG 05 2021   k_12_total 96 10 407   0 16     26   14                               96 10 407   0 16     26   14                        
657960 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000790 744 Hoover Elementary School   Regular School No Elementary KG 05 2021   k_12_total 96 6 267   1 0     18   24                               96 6 267   1 0     18   24                        
658185 OR     school 4112600 2204   Umatilla SD 6R 411260001090 1031 Clara Brownell Middle School   Regular School No Middle 06 08 2021   k_12_total 96 0 253   4 1     0   6                               96 0 253   4 1     0   6                        
916799 OR     school 4102040 2088   Bethel SD 52 410204000623 588 Willamette High School   Regular School No High 09 12 2020   k_12_total 958 33 336   19 39     11   101                               958 33 336   19 39     11   101                        
656883 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2021   k_12_total 953 84 482   12 652     18   165                               953 84 482   12 652     18   165                        
917956 OR     school 4111670 2083   Springfield SD 19 411167000595 561 Thurston High School   Regular School No High 09 12 2020   k_12_total 951 7 156   24 9     4   116                               951 7 156   24 9     4   116                        
917117 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000735 649 West Albany High School   Regular School No High 09 12 2020   k_12_total 950 9 166   8 21     3   103                               950 9 166   8 21     3   103                        
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                        
1190491 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Elementary School   Regular School No Elementary KG 08 2018   k_12_total 95.0 2.0 9.0   0.0 2.0     0.0   13.0                               95 2 9   0 2     0   13                        
1190578 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   2916 Bend COIC Dropout Re-engagement Program             2018   k_12_total 95.0 2.0 14.0   1.0 1.0     0.0   3.0                               95 2 14   1 1     0   3                        
1191604 OR     school 4110520 2182   Reynolds SD 7 411052001006 952 Wilkes Elementary School   Regular School No Elementary KG 05 2018   k_12_total 95.0 57.0 188.0   5.0 50.0     19.0   32.0                               95 57 188   5 50     19   32                        
1191662 OR     school 4110820 2142   Salem-Keizer SD 24J   2142 Salem-Keizer SD 24J             2018   k_12_total 95.0 3.0 39.0   4.0 3.0     3.0   8.0                               95 3 39   4 3     3   8                        
1191879 OR     school 4112930 1947   Vernonia SD 47J 411293001673 4396 Vernonia Middle School   Regular School No Middle 06 08 2018   k_12_total 95.0 0.0 7.0   2.0 2.0     0.0   6.0                               95 0 7   2 2     0   6                        
916911 OR     school 4103780 2089   Crow-Applegate-Lorane SD 66 410378000627 592 Crow Middle/High School   Regular School No High 07 12 2020   k_12_total 95 1 5   7 2     1   9                               95 1 5   7 2     1   9                        
917260 OR     school 4107020 2057   Klamath County SD 410702000511 486 Lost River High School   Regular School No High 07 12 2020   k_12_total 95 0 125   1 0     0   3                               95 0 125   1 0     0   3                        
917413 OR     school 4108550 2145   Mt Angel SD 91 410855000839 794 John F Kennedy High School   Regular School No High 09 12 2020   k_12_total 95 3 96   2 1     0   8                               95 3 96   2 1     0   8                        
658127 OR     school 4111790 2209   Stanfield SD 61 411179001119 1060 Stanfield Elementary School   Regular School No Elementary KG 05 2021   k_12_total 95 0 108   0 0     0   4                               95 0 108   0 0     0   4                        
916878 OR     school 4103420 2186   Corbett SD 39 410342001729 4592 Corbett School   Regular School Yes Other KG 12 2020   k_12_total 948 13 100   16 20     2   87                               948 13 100   16 20     2   87                        
656944 OR     school 4102040 2088   Bethel SD 52 410204000623 588 Willamette High School   Regular School No High 09 12 2021   k_12_total 946 35 349   22 41     13   111                               946 35 349   22 41     13   111                        
916990 OR     school 4104700 1930   Estacada SD 108 410470001766 4670 Summit Learning Charter   Regular School Yes Other KG 12 2020   k_12_total 942 44 79   3 36     6   28                               942 44 79   3 36     6   28                        
1190725 OR     school 4103480 1901   Corvallis SD 509J 410348001743 4637 Inavale Community Partners dba Muddy Creek Charter School   Regular School Yes Elementary KG 05 2018   k_12_total 94.0 1.0 12.0   0.0 0.0     0.0   3.0                               94 1 12   0 0     0   3                        
1190910 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   k_12_total 94.0 0.0 23.0   1.0 0.0     0.0   13.0                               94 0 23   1 0     0   13                        
1191759 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2018   k_12_total 94.0 0.0 16.0   5.0 0.0     0.0   9.0                               94 0 16   5 0     0   9                        
916762 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000688 1338 Marshall High School   Alternative School No High 09 12 2020   k_12_total 94 2 18   4 1     0   5                               94 2 18   4 1     0   5                        
917380 OR     school 4108040 2048   Medford SD 549C 410804001843 5304 The Valley School of Southern Oregon   Regular School Yes Middle 06 08 2020   k_12_total 94 1 14   0 2     1   6                               94 1 14   0 2     1   6                        
917926 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2020   k_12_total 94 0 10   5 0     0   11                               94 0 10   5 0     0   11                        
657248 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000669 631 Central Elementary School   Regular School No Elementary 03 05 2021   k_12_total 94 1 8   1 0     0   7                               94 1 8   1 0     0   7                        

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