Data source: Big Local News · About: Big Local

5,859 rows where grade = "k_12_total" and state = "OR" sorted by black_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
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                        
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                        
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                        
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                        
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                        
1191463 OR     school 4110040 2180   Portland SD 1J 411004000876 833 Boise-Eliot Elementary School   Regular School No Elementary PK 08 2018   k_12_total 80.0 271.0 59.0   7.0 13.0     1.0   52.0                               80 271 59   7 13     1   52                        
1191494 OR     school 4110040 2180   Portland SD 1J 411004000964 913 Jefferson High School   Regular School No High 09 12 2018   k_12_total 189.0 271.0 114.0   5.0 13.0     13.0   71.0                               189 271 114   5 13     13   71                        
1706321 OR     school 4110040 2180   Portland SD 1J 411004000964 913 Jefferson High School   Regular School No High 09 12 2017   k_12_total 150.0 264.0 89.0     8.0     15.0   58.0                               150 264 89     8     15   58                        
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                        
917699 OR     school 4110040 2180   Portland SD 1J 411004001821 918 Roosevelt High School   Regular School No High 09 12 2020   k_12_total 392 207 424   11 33     37   91                               392 207 424   11 33     37   91                        
657818 OR     school 4110040 2180   Portland SD 1J 411004000964 913 Jefferson High School   Regular School No High 09 12 2021   k_12_total 182 204 135   2 9     6   82                               182 204 135   2 9     6   82                        
917663 OR     school 4110040 2180   Portland SD 1J 411004000964 913 Jefferson High School   Regular School No High 09 12 2020   k_12_total 203 204 125   3 9     9   86                               203 204 125   3 9     9   86                        
657855 OR     school 4110040 2180   Portland SD 1J 411004001821 918 Roosevelt High School   Regular School No High 09 12 2021   k_12_total 431 203 466   15 42     35   101                               431 203 466   15 42     35   101                        
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                        
917647 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2020   k_12_total 177 200 201   14 15     8   86                               177 200 201   14 15     8   86                        
657802 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2021   k_12_total 177 198 206   13 13     10   84                               177 198 206   13 13     10   84                        
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                        
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                        
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                        
1191479 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2018   k_12_total 162.0 185.0 170.0   8.0 15.0     3.0   83.0                               162 185 170   8 15     3   83                        
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                        
1706288 OR     school 4110040 2180   Portland SD 1J 411004000956 906 Benson Polytechnic High School   Regular School No High 09 12 2017   k_12_total 354.0 170.0 244.0     115.0     6.0   96.0                               354 170 244     115     6   96                        
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                        
917630 OR     school 4110040 2180   Portland SD 1J 411004000876 833 Boise-Eliot Elementary School   Regular School No Elementary PK 05 2020   k_12_total 75 162 43   1 8     1   35                               75 162 43   1 8     1   35                        
917655 OR     school 4110040 2180   Portland SD 1J 411004001315 894 Harriet Tubman Middle School   Regular School No Middle 06 08 2020   k_12_total 129 162 67   5 3     1   62                               129 162 67   5 3     1   62                        
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                        
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                        
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                        
657810 OR     school 4110040 2180   Portland SD 1J 411004001315 894 Harriet Tubman Middle School   Regular School No Middle 06 08 2021   k_12_total 151 158 65   2 6     2   60                               151 158 65   2 6     2   60                        
1191533 OR     school 4110040 2180   Portland SD 1J 411004001821 918 Roosevelt High School   Regular School No High 09 12 2018   k_12_total 245.0 156.0 321.0   11.0 36.0     25.0   63.0                               245 156 321   11 36     25   63                        
1191461 OR     school 4110040 2180   Portland SD 1J 411004000956 906 Benson Polytechnic High School   Regular School No High 09 12 2018   k_12_total 398.0 155.0 262.0   6.0 99.0     6.0   101.0                               398 155 262   6 99     6   101                        
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                        
1706360 OR     school 4110040 2180   Portland SD 1J 411004001821 918 Roosevelt High School   Regular School No High 09 12 2017   k_12_total 245.0 153.0 337.0     46.0     22.0   55.0                               245 153 337     46     22   55                        
1706335 OR     school 4110040 2180   Portland SD 1J 411004000911 866 Martin Luther King Jr. School   Regular School No Elementary PK 08 2017   k_12_total 43.0 152.0 106.0     7.0     2.0   54.0                               43 152 106     7     2   54                        
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                        
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                        
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                        
657913 OR     school 4110520 2182   Reynolds SD 7 411052001007 954 Hauton B Lee Middle School   Regular School No Middle 06 08 2021   k_12_total 144 145 307   4 106     42   46                               144 145 307   4 106     42   46                        
1191508 OR     school 4110040 2180   Portland SD 1J 411004000911 866 Martin Luther King Jr. School   Regular School No Elementary PK 08 2018   k_12_total 48.0 145.0 107.0   1.0 10.0     2.0   56.0                               48 145 107   1 10     2   56                        
657785 OR     school 4110040 2180   Portland SD 1J 411004000876 833 Boise-Eliot Elementary School   Regular School No Elementary PK 05 2021   k_12_total 73 144 52   1 8     5   46                               73 144 52   1 8     5   46                        
917757 OR     school 4110520 2182   Reynolds SD 7 411052001007 954 Hauton B Lee Middle School   Regular School No Middle 06 08 2020   k_12_total 162 140 311   6 104     38   52                               162 140 311   6 104     38   52                        
1706361 OR     school 4110040 2180   Portland SD 1J 411004000872 829 Rosa Parks Elementary School   Regular School No Elementary PK 05 2017   k_12_total 40.0 138.0 72.0     7.0     3.0   32.0                               40 138 72     7     3   32                        
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                        
1706383 OR     school 4110040 2180   Portland SD 1J 411004000952 902 Woodlawn Elementary School   Regular School No Elementary PK 05 2017   k_12_total 78.0 137.0 71.0     3.0     9.0   24.0                               78 137 71     3     9   24                        
1191557 OR     school 4110040 2180   Portland SD 1J 411004000952 902 Woodlawn Elementary School   Regular School No Elementary PK 05 2018   k_12_total 87.0 134.0 65.0   0.0 4.0     9.0   27.0                               87 134 65   0 4     9   27                        
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                        
917628 OR     school 4110040 2180   Portland SD 1J 411004000956 906 Benson Polytechnic High School   Regular School No High 09 12 2020   k_12_total 460 131 275   4 81     11   90                               460 131 275   4 81     11   90                        
1706306 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2017   k_12_total 132.0 125.0 147.0     20.0     4.0   41.0                               132 125 147     20     4   41                        
917577 OR     school 4109480 2181   Parkrose SD 3 410948000986 930 Parkrose Middle School   Regular School No Middle 06 08 2020   k_12_total 240 124 227   2 92     23   70                               240 124 227   2 92     23   70                        
1191412 OR     school 4109480 2181   Parkrose SD 3 410948000986 930 Parkrose Middle School   Regular School No Middle 06 08 2018   k_12_total 251.0 123.0 217.0   9.0 89.0     21.0   65.0                               251 123 217   9 89     21   65                        
1191518 OR     school 4110040 2180   Portland SD 1J 411004000925 878 Ockley Green Middle School   Regular School No Middle 06 08 2018   k_12_total 187.0 123.0 124.0   9.0 18.0     18.0   52.0                               187 123 124   9 18     18   52                        
1706236 OR     school 4109480 2181   Parkrose SD 3 410948000986 930 Parkrose Middle School   Regular School No Middle 06 08 2017   k_12_total 251.0 121.0 221.0     103.0     20.0   57.0                               251 121 221     103     20   57                        
1191534 OR     school 4110040 2180   Portland SD 1J 411004000872 829 Rosa Parks Elementary School   Regular School No Elementary PK 05 2018   k_12_total 38.0 120.0 73.0   2.0 6.0     6.0   27.0                               38 120 73   2 6     6   27                        
917702 OR     school 4110040 2180   Portland SD 1J   1669 Rosemary Anderson High School             2020   k_12_total 63 119 87   3 3     1   35                               63 119 87   3 3     1   35                        
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                        
1706345 OR     school 4110040 2180   Portland SD 1J 411004000925 878 Ockley Green Middle School   Regular School No Middle 05 08 2017   k_12_total 250.0 118.0 143.0     28.0     27.0   50.0                               250 118 143     28     27   50                        
657086 OR     school 4103940 2187   David Douglas SD 40 410394001676 4232 Ron Russell Middle School   Regular School No Middle 06 08 2021   k_12_total 291 117 247   5 120     19   51                               291 117 247   5 120     19   51                        
657783 OR     school 4110040 2180   Portland SD 1J 411004000956 906 Benson Polytechnic High School   Regular School No High 09 12 2021   k_12_total 440 117 271   6 66     7   98                               440 117 271   6 66     7   98                        
657730 OR     school 4109480 2181   Parkrose SD 3 410948000986 930 Parkrose Middle School   Regular School No Middle 06 08 2021   k_12_total 227 115 207   7 91     22   72                               227 115 207   7 91     22   72                        
917715 OR     school 4110040 2180   Portland SD 1J 411004000944 895 Vernon Elementary School   Regular School No Elementary PK 08 2020   k_12_total 349 115 75   0 5     3   61                               349 115 75   0 5     3   61                        
657807 OR     school 4110040 2180   Portland SD 1J 411004000962 912 Grant High School   Regular School No High 09 12 2021   k_12_total 1374 114 147   11 54     6   260                               1374 114 147   11 54     6   260                        
657840 OR     school 4110040 2180   Portland SD 1J 411004000925 878 Ockley Green Middle School   Regular School No Middle 06 08 2021   k_12_total 186 114 111   1 13     9   52                               186 114 111   1 13     9   52                        
916937 OR     school 4103940 2187   David Douglas SD 40 410394001676 4232 Ron Russell Middle School   Regular School No Middle 06 08 2020   k_12_total 306 114 253   7 132     25   42                               306 114 253   7 132     25   42                        
917685 OR     school 4110040 2180   Portland SD 1J 411004000925 878 Ockley Green Middle School   Regular School No Middle 06 08 2020   k_12_total 173 114 119   5 17     7   52                               173 114 119   5 17     7   52                        
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                        
1706334 OR     school 4110040 2180   Portland SD 1J 411004000919 1278 Markham Elementary School   Regular School No Elementary KG 05 2017   k_12_total 221.0 114.0 33.0     6.0     8.0   35.0                               221 114 33     6     8   35                        
1191591 OR     school 4110520 2182   Reynolds SD 7 411052001007 954 Hauton B Lee Middle School   Regular School No Middle 06 08 2018   k_12_total 163.0 112.0 293.0   8.0 96.0     28.0   40.0                               163 112 293   8 96     28   40                        
1705591 OR     school 4103940 2187   David Douglas SD 40 410394001676 4232 Ron Russell Middle School   Regular School No Middle 06 08 2017   k_12_total 316.0 112.0 223.0     141.0     8.0   41.0                               316 112 223     141     8   41                        
917700 OR     school 4110040 2180   Portland SD 1J 411004000872 829 Rosa Parks Elementary School   Regular School No Elementary PK 05 2020   k_12_total 36 111 87   4 4     5   31                               36 111 87   4 4     5   31                        
658004 OR     school 4108100 2104   Santiam Canyon SD 129J 410810001680 4399 Oregon Charter Academy   Regular School Yes Other KG 12 2021   k_12_total 3451 110 655   78 138     33   246                               3451 110 655   78 138     33   246                        
1191535 OR     school 4110040 2180   Portland SD 1J   1669 Rosemary Anderson High School             2018   k_12_total 74.0 110.0 91.0   6.0 8.0     3.0   29.0                               74 110 91   6 8     3   29                        
657856 OR     school 4110040 2180   Portland SD 1J 411004000872 829 Rosa Parks Elementary School   Regular School No Elementary PK 05 2021   k_12_total 34 109 75   4 3     9   32                               34 109 75   4 3     9   32                        
917644 OR     school 4110040 2180   Portland SD 1J 411004000911 866 Dr. Martin Luther King Jr. School   Regular School No Elementary PK 05 2020   k_12_total 78 108 72   4 19     4   36                               78 108 72   4 19     4   36                        
1191549 OR     school 4110040 2180   Portland SD 1J 411004000944 895 Vernon Elementary School   Regular School No Elementary PK 08 2018   k_12_total 283.0 107.0 62.0   0.0 10.0     4.0   56.0                               283 107 62   0 10     4   56                        
657858 OR     school 4110040 2180   Portland SD 1J   1669 Rosemary Anderson High School             2021   k_12_total 55 106 82   5 1     2   37                               55 106 82   5 1     2   37                        
917652 OR     school 4110040 2180   Portland SD 1J 411004000962 912 Grant High School   Regular School No High 09 12 2020   k_12_total 1295 106 138   13 53     7   199                               1295 106 138   13 53     7   199                        
1706375 OR     school 4110040 2180   Portland SD 1J 411004000944 895 Vernon Elementary School   Regular School No Elementary PK 08 2017   k_12_total 237.0 106.0 62.0     11.0     2.0   51.0                               237 106 62     11     2   51                        
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                        
1706416 OR     school 4110520 2182   Reynolds SD 7 411052001007 954 Hauton B Lee Middle School   Regular School No Middle 06 08 2017   k_12_total 170.0 104.0 303.0     102.0     28.0   45.0                               170 104 303     102     28   45                        
1191484 OR     school 4110040 2180   Portland SD 1J 411004000962 912 Grant High School   Regular School No High 09 12 2018   k_12_total 1069.0 103.0 96.0   11.0 61.0     4.0   167.0                               1069 103 96   11 61     4   167                        
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                        
1706414 OR     school 4110520 2182   Reynolds SD 7 411052000999 946 Glenfair Elementary School   Regular School No Elementary KG 05 2017   k_12_total 122.0 103.0 204.0     41.0     15.0   53.0                               122 103 204     41     15   53                        
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                        
657819 OR     school 4110040 2180   Portland SD 1J 411004001830 5218 Kairos PDX   Regular School Yes Elementary KG 05 2021   k_12_total 55 102 20   7 1     0   38                               55 102 20   7 1     0   38                        
917724 OR     school 4110040 2180   Portland SD 1J 411004000952 902 Woodlawn Elementary School   Regular School No Elementary PK 05 2020   k_12_total 109 102 54   1 4     6   32                               109 102 54   1 4     6   32                        
1190519 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2018   k_12_total 782.0 102.0 738.0   5.0 111.0     23.0   103.0                               782 102 738   5 111     23   103                        
657914 OR     school 4110520 2182   Reynolds SD 7 411052001001 948 Margaret Scott Elementary School   Regular School No Elementary KG 05 2021   k_12_total 75 101 113   1 44     19   42                               75 101 113   1 44     19   42                        
917664 OR     school 4110040 2180   Portland SD 1J 411004001830 5218 Kairos PDX   Regular School Yes Elementary KG 05 2020   k_12_total 55 101 26   6 1     1   26                               55 101 26   6 1     1   26                        
1191589 OR     school 4110520 2182   Reynolds SD 7 411052000999 946 Glenfair Elementary School   Regular School No Elementary KG 05 2018   k_12_total 112.0 101.0 191.0   7.0 53.0     15.0   42.0                               112 101 191   7 53     15   42                        
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                        
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                        
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                        
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                        

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