Data source: Big Local News · About: Big Local

5,859 rows where grade = "k_12_total" and state = "OR" sorted by asian_int 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
916732 OR     school 4101920 2243   Beaverton SD 48J 410192001431 2782 Stoller Middle School   Regular School No Middle 06 08 2020   k_12_total 537 30 138   3 767     8   111                               537 30 138   3 767     8   111                        
656878 OR     school 4101920 2243   Beaverton SD 48J 410192001431 2782 Stoller Middle School   Regular School No Middle 06 08 2021   k_12_total 424 26 110   2 761     10   76                               424 26 110   2 761     10   76                        
1190568 OR     school 4101920 2243   Beaverton SD 48J 410192001431 2782 Stoller Middle School   Regular School No Middle 06 08 2018   k_12_total 575.0 25.0 104.0   1.0 710.0     8.0   90.0                               575 25 104   1 710     8   90                        
1705381 OR     school 4101920 2243   Beaverton SD 48J 410192001431 2782 Stoller Middle School   Regular School No Middle 06 08 2017   k_12_total 611.0 22.0 99.0     683.0     8.0   88.0                               611 22 99     683     8   88                        
1705386 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2017   k_12_total 1215.0 103.0 479.0     673.0     20.0   171.0                               1215 103 479     673     20   171                        
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                        
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                        
916737 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2020   k_12_total 1026 86 517   9 645     17   173                               1026 86 517   9 645     17   173                        
1190764 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2018   k_12_total 1140.0 361.0 794.0   19.0 596.0     44.0   187.0                               1140 361 794   19 596     44   187                        
1705580 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2017   k_12_total 1220.0 332.0 789.0     590.0     41.0   185.0                               1220 332 789     590     41   185                        
656879 OR     school 4101920 2243   Beaverton SD 48J 410192001241 1188 Sunset High School   Regular School No High 09 12 2021   k_12_total 1066 22 208   5 540     8   177                               1066 22 208   5 540     8   177                        
916733 OR     school 4101920 2243   Beaverton SD 48J 410192001241 1188 Sunset High School   Regular School No High 09 12 2020   k_12_total 1121 25 215   4 514     12   149                               1121 25 215   4 514     12   149                        
657077 OR     school 4103940 2187   David Douglas SD 40 410394001037 983 David Douglas High School   Regular School No High 09 12 2021   k_12_total 909 339 779   22 504     63   191                               909 339 779   22 504     63   191                        
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                        
1190547 OR     school 4101920 2243   Beaverton SD 48J 410192001445 3437 Jacob Wismer Elementary School   Regular School No Elementary KG 05 2018   k_12_total 209.0 8.0 19.0   0.0 483.0     2.0   32.0                               209 8 19   0 483     2   32                        
656877 OR     school 4101920 2243   Beaverton SD 48J 410192001779 4712 Springville K-8 School   Regular School No Elementary KG 08 2021   k_12_total 247 31 81   7 453     3   30                               247 31 81   7 453     3   30                        
916711 OR     school 4101920 2243   Beaverton SD 48J 410192001445 3437 Jacob Wismer Elementary School   Regular School No Elementary KG 05 2020   k_12_total 202 4 29   3 449     1   37                               202 4 29   3 449     1   37                        
657606 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2021   k_12_total 1378 46 318   6 443     9   195                               1378 46 318   6 443     9   195                        
1705380 OR     school 4101920 2243   Beaverton SD 48J 410192001779 4712 Springville K-8 School   Regular School No Elementary KG 08 2017   k_12_total 465.0 13.0 124.0     443.0     2.0   63.0                               465 13 124     443     2   63                        
1705352 OR     school 4101920 2243   Beaverton SD 48J 410192001262 1370 Findley Elementary   Regular School No Elementary KG 05 2017   k_12_total 248.0 6.0 31.0     442.0     0.0   50.0                               248 6 31     442     0   50                        
917455 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2020   k_12_total 1501 43 344   3 436     12   212                               1501 43 344   3 436     12   212                        
1190537 OR     school 4101920 2243   Beaverton SD 48J 410192001262 1370 Findley Elementary   Regular School No Elementary KG 05 2018   k_12_total 214.0 5.0 30.0   4.0 429.0     1.0   43.0                               214 5 30   4 429     1   43                        
1191283 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2018   k_12_total 1566.0 42.0 304.0   11.0 428.0     9.0   181.0                               1566 42 304   11 428     9   181                        
656856 OR     school 4101920 2243   Beaverton SD 48J 410192001445 3437 Jacob Wismer Elementary School   Regular School No Elementary KG 05 2021   k_12_total 158 3 34   6 426     0   30                               158 3 34   6 426     0   30                        
916731 OR     school 4101920 2243   Beaverton SD 48J 410192001779 4712 Springville K-8 School   Regular School No Elementary KG 08 2020   k_12_total 298 25 84   9 426     3   39                               298 25 84   9 426     3   39                        
1190569 OR     school 4101920 2243   Beaverton SD 48J 410192001241 1188 Sunset High School   Regular School No High 09 12 2018   k_12_total 1207.0 43.0 316.0   7.0 423.0     10.0   135.0                               1207 43 316   7 423     10   135                        
1705362 OR     school 4101920 2243   Beaverton SD 48J 410192001445 3437 Jacob Wismer Elementary School   Regular School No Elementary KG 05 2017   k_12_total 223.0 6.0 21.0     415.0     1.0   35.0                               223 6 21     415     1   35                        
1706107 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2017   k_12_total 1577.0 34.0 277.0     408.0     7.0   188.0                               1577 34 277     408     7   188                        
1705382 OR     school 4101920 2243   Beaverton SD 48J 410192001241 1188 Sunset High School   Regular School No High 09 12 2017   k_12_total 1258.0 49.0 423.0     387.0     21.0   152.0                               1258 49 423     387     21   152                        
916701 OR     school 4101920 2243   Beaverton SD 48J 410192001262 1370 Findley Elementary   Regular School No Elementary KG 05 2020   k_12_total 183 7 31   2 375     1   41                               183 7 31   2 375     1   41                        
656871 OR     school 4101920 2243   Beaverton SD 48J 410192001856 5382 Sato Elementary School   Regular School No Elementary KG 05 2021   k_12_total 184 25 79   6 333     5   35                               184 25 79   6 333     5   35                        
656846 OR     school 4101920 2243   Beaverton SD 48J 410192001262 1370 Findley Elementary   Regular School No Elementary KG 05 2021   k_12_total 128 10 32   2 329     0   39                               128 10 32   2 329     0   39                        
1190567 OR     school 4101920 2243   Beaverton SD 48J 410192001779 4712 Springville K-8 School   Regular School No Elementary KG 08 2018   k_12_total 323.0 13.0 82.0   3.0 327.0     4.0   39.0                               323 13 82   3 327     4   39                        
916725 OR     school 4101920 2243   Beaverton SD 48J 410192001856 5382 Sato Elementary School   Regular School No Elementary KG 05 2020   k_12_total 231 24 70   7 302     3   34                               231 24 70   7 302     3   34                        
656855 OR     school 4101920 2243   Beaverton SD 48J 410192001647 4474 International School of Beaverton   Regular School No High 06 12 2021   k_12_total 308 28 136   0 289     0   106                               308 28 136   0 289     0   106                        
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                        
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                        
916710 OR     school 4101920 2243   Beaverton SD 48J 410192001647 4474 International School of Beaverton   Regular School No High 06 12 2020   k_12_total 328 27 126   0 266     0   100                               328 27 126   0 266     0   100                        
1191595 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2018   k_12_total 896.0 201.0 1116.0   18.0 266.0     49.0   154.0                               896 201 1116   18 266     49   154                        
657804 OR     school 4110040 2180   Portland SD 1J 411004000960 911 Franklin High School   Regular School No High 09 12 2021   k_12_total 1054 88 386   10 260     19   182                               1054 88 386   10 260     19   182                        
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                        
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                        
917649 OR     school 4110040 2180   Portland SD 1J 411004000960 911 Franklin High School   Regular School No High 09 12 2020   k_12_total 1035 87 361   8 258     14   169                               1035 87 361   8 258     14   169                        
916825 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2020   k_12_total 677 105 517   13 255     38   96                               677 105 517   13 255     38   96                        
917460 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2020   k_12_total 703 14 110   4 253     7   104                               703 14 110   4 253     7   104                        
1190658 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2018   k_12_total 729.0 79.0 484.0   19.0 249.0     33.0   98.0                               729 79 484   19 249     33   98                        
656970 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2021   k_12_total 646 102 538   11 248     45   100                               646 102 538   11 248     45   100                        
657610 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2021   k_12_total 589 15 96   5 245     5   97                               589 15 96   5 245     5   97                        
1190535 OR     school 4101920 2243   Beaverton SD 48J 410192001321 1162 Elmonica Elementary School   Regular School No Elementary KG 05 2018   k_12_total 182.0 23.0 215.0   4.0 244.0     4.0   40.0                               182 23 215   4 244     4   40                        
916718 OR     school 4101920 2243   Beaverton SD 48J 410192001855 5381 Mountainside High School   Regular School No High 09 12 2020   k_12_total 1120 43 258   4 237     12   161                               1120 43 258   4 237     12   161                        
1190546 OR     school 4101920 2243   Beaverton SD 48J 410192001647 4474 International School of Beaverton   Regular School No High 06 12 2018   k_12_total 372.0 28.0 127.0   0.0 237.0     1.0   118.0                               372 28 127   0 237     1   118                        
1705361 OR     school 4101920 2243   Beaverton SD 48J 410192001647 4474 International School of Beaverton   Regular School No Other 06 12 2017   k_12_total 383.0 20.0 125.0     235.0     1.0   106.0                               383 20 125     235     1   106                        
656863 OR     school 4101920 2243   Beaverton SD 48J 410192001855 5381 Mountainside High School   Regular School No High 09 12 2021   k_12_total 1055 42 253   4 232     8   160                               1055 42 253   4 232     8   160                        
1190561 OR     school 4101920 2243   Beaverton SD 48J 410192001856 5382 Sato Elementary School   Regular School No Elementary KG 05 2018   k_12_total 203.0 7.0 51.0   3.0 225.0     0.0   29.0                               203 7 51   3 225     0   29                        
1705821 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2017   k_12_total 765.0 54.0 425.0     225.0     19.0   104.0                               765 54 425     225     19   104                        
1705350 OR     school 4101920 2243   Beaverton SD 48J 410192001321 1162 Elmonica Elementary School   Regular School No Elementary KG 05 2017   k_12_total 169.0 13.0 202.0     223.0     3.0   33.0                               169 13 202     223     3   33                        
917761 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2020   k_12_total 801 193 1153   18 219     72   136                               801 193 1153   18 219     72   136                        
657917 OR     school 4110520 2182   Reynolds SD 7 411052001009 957 Reynolds High School   Regular School No High 09 12 2021   k_12_total 779 210 1171   21 218     68   157                               779 210 1171   21 218     68   157                        
917167 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2020   k_12_total 705 46 470   9 215     19   117                               705 46 470   9 215     19   117                        
1191001 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2018   k_12_total 719.0 54.0 429.0   11.0 212.0     20.0   109.0                               719 54 429   11 212     20   109                        
916699 OR     school 4101920 2243   Beaverton SD 48J 410192001321 1162 Elmonica Elementary School   Regular School No Elementary KG 05 2020   k_12_total 108 14 175   3 204     4   41                               108 14 175   3 204     4   41                        
1191288 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2018   k_12_total 697.0 15.0 79.0   4.0 201.0     2.0   95.0                               697 15 79   4 201     2   95                        
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                        
656844 OR     school 4101920 2243   Beaverton SD 48J 410192001321 1162 Elmonica Elementary School   Regular School No Elementary KG 05 2021   k_12_total 91 15 128   5 193     1   32                               91 15 128   5 193     1   32                        
657316 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2021   k_12_total 653 46 482   11 192     23   110                               653 46 482   11 192     23   110                        
1191411 OR     school 4109480 2181   Parkrose SD 3 410948000987 931 Parkrose High School   Regular School No High 09 12 2018   k_12_total 270.0 160.0 260.0   4.0 185.0     32.0   65.0                               270 160 260   4 185     32   65                        
1706314 OR     school 4110040 2180   Portland SD 1J 411004000885 842 Harrison Park School   Regular School No Elementary KG 08 2017   k_12_total 159.0 148.0 118.0     182.0     12.0   50.0                               159 148 118     182     12   50                        
1191503 OR     school 4110040 2180   Portland SD 1J 411004000966 914 Lincoln High School   Regular School No High 09 12 2018   k_12_total 1212.0 23.0 142.0   4.0 178.0     1.0   144.0                               1212 23 142   4 178     1   144                        
1706112 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2017   k_12_total 711.0 18.0 88.0     177.0     6.0   89.0                               711 18 88     177     6   89                        
1191487 OR     school 4110040 2180   Portland SD 1J 411004000885 842 Harrison Park School   Regular School No Elementary KG 08 2018   k_12_total 150.0 137.0 110.0   6.0 172.0     13.0   50.0                               150 137 110   6 172     13   50                        
1706330 OR     school 4110040 2180   Portland SD 1J 411004000966 914 Lincoln High School   Regular School No High 09 12 2017   k_12_total 1205.0 32.0 142.0     171.0     2.0   141.0                               1205 32 142     171     2   141                        
1706235 OR     school 4109480 2181   Parkrose SD 3 410948000987 931 Parkrose High School   Regular School No High 09 12 2017   k_12_total 294.0 160.0 245.0     170.0     25.0   67.0                               294 160 245     170     25   67                        
1191126 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2018   k_12_total 923.0 17.0 74.0   1.0 167.0     2.0   89.0                               923 17 74   1 167     2   89                        
917656 OR     school 4110040 2180   Portland SD 1J 411004000885 842 Harrison Park School   Regular School No Elementary KG 08 2020   k_12_total 143 154 109   4 165     21   41                               143 154 109   4 165     21   41                        
917672 OR     school 4110040 2180   Portland SD 1J 411004000966 914 Lincoln High School   Regular School No High 09 12 2020   k_12_total 1101 19 154   4 163     4   143                               1101 19 154   4 163     4   143                        
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                        
657447 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2021   k_12_total 874 12 106   2 161     1   95                               874 12 106   2 161     1   95                        
917674 OR     school 4110040 2180   Portland SD 1J 411004000968 915 Madison High School   Regular School No High 09 12 2020   k_12_total 365 151 267   11 160     18   98                               365 151 267   11 160     18   98                        
1191505 OR     school 4110040 2180   Portland SD 1J 411004000968 915 Madison High School   Regular School No High 09 12 2018   k_12_total 385.0 196.0 279.0   8.0 160.0     14.0   99.0                               385 196 279   8 160     14   99                        
916692 OR     school 4101920 2243   Beaverton SD 48J 410192001753 4671 Bonny Slope Elementary School   Regular School No Elementary PK 05 2020   k_12_total 365 6 58   2 158     4   64                               365 6 58   2 158     4   64                        
657729 OR     school 4109480 2181   Parkrose SD 3 410948000987 931 Parkrose High School   Regular School No High 09 12 2021   k_12_total 261 159 298   6 157     36   93                               261 159 298   6 157     36   93                        
657811 OR     school 4110040 2180   Portland SD 1J 411004000885 842 Harrison Park School   Regular School No Elementary KG 08 2021   k_12_total 123 132 100   3 155     26   57                               123 132 100   3 155     26   57                        
917297 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2020   k_12_total 899 7 103   4 155     2   89                               899 7 103   4 155     2   89                        
1190527 OR     school 4101920 2243   Beaverton SD 48J 410192001207 1156 Bethany Elementary School   Regular School No Elementary KG 05 2018   k_12_total 268.0 15.0 41.0   0.0 154.0     1.0   51.0                               268 15 41   0 154     1   51                        
917639 OR     school 4110040 2180   Portland SD 1J 411004000958 909 Cleveland High School   Regular School No High 09 12 2020   k_12_total 1074 32 132   5 152     7   157                               1074 32 132   5 152     7   157                        
1706385 OR     school 4110040 2180   Portland SD 1J 411004000954 904 Woodstock Elementary School   Regular School No Elementary KG 05 2017   k_12_total 269.0 3.0 31.0     152.0     1.0   71.0                               269 3 31     152     1   71                        
656833 OR     school 4101920 2243   Beaverton SD 48J 410192001745 4638 Beaverton Academy of Science and Engineering   Regular School No High 06 12 2021   k_12_total 381 16 213   6 151     3   70                               381 16 213   6 151     3   70                        
917576 OR     school 4109480 2181   Parkrose SD 3 410948000987 931 Parkrose High School   Regular School No High 09 12 2020   k_12_total 257 150 298   10 151     35   75                               257 150 298   10 151     35   75                        
656849 OR     school 4101920 2243   Beaverton SD 48J 410192001894 5506 FLEX Online School   Regular School No Other KG 12 2021   k_12_total 737 22 156   4 150     22   122                               737 22 156   4 150     22   122                        
1191472 OR     school 4110040 2180   Portland SD 1J 411004000958 909 Cleveland High School   Regular School No High 09 12 2018   k_12_total 1102.0 45.0 137.0   6.0 150.0     5.0   141.0                               1102 45 137   6 150     5   141                        
1191559 OR     school 4110040 2180   Portland SD 1J 411004000954 904 Woodstock Elementary School   Regular School No Elementary KG 05 2018   k_12_total 292.0 2.0 38.0   0.0 150.0     3.0   67.0                               292 2 38   0 150     3   67                        
657829 OR     school 4110040 2180   Portland SD 1J 411004000968 915 Madison High School   Regular School No High 09 12 2021   k_12_total 405 168 294   10 149     24   119                               405 168 294   10 149     24   119                        
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                        
1705342 OR     school 4101920 2243   Beaverton SD 48J 410192001207 1156 Bethany Elementary School   Regular School No Elementary KG 05 2017   k_12_total 276.0 17.0 53.0     148.0     2.0   57.0                               276 17 53     148     2   57                        
656837 OR     school 4101920 2243   Beaverton SD 48J 410192001753 4671 Bonny Slope Elementary School   Regular School No Elementary PK 05 2021   k_12_total 311 7 54   1 146     1   53                               311 7 54   1 146     1   53                        
1706332 OR     school 4110040 2180   Portland SD 1J 411004000968 915 Madison High School   Regular School No High 09 12 2017   k_12_total 359.0 175.0 261.0     146.0     21.0   99.0                               359 175 261     146     21   99                        
917726 OR     school 4110040 2180   Portland SD 1J 411004000954 904 Woodstock Elementary School   Regular School No Elementary KG 05 2020   k_12_total 280 2 29   0 145     1   86                               280 2 29   0 145     1   86                        
1190566 OR     school 4101920 2243   Beaverton SD 48J 410192001432 2783 Southridge High School   Regular School No High 09 12 2018   k_12_total 828.0 49.0 324.0   8.0 144.0     23.0   114.0                               828 49 324   8 144     23   114                        
1190774 OR     school 4103940 2187   David Douglas SD 40 410394001676 4232 Ron Russell Middle School   Regular School No Middle 06 08 2018   k_12_total 303.0 114.0 230.0   14.0 144.0     14.0   43.0                               303 114 230   14 144     14   43                        
1706299 OR     school 4110040 2180   Portland SD 1J 411004000958 909 Cleveland High School   Regular School No High 09 12 2017   k_12_total 1110.0 45.0 153.0     144.0     9.0   129.0                               1110 45 153     144     9   129                        

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