Data source: Big Local News · About: Big Local

82,026 rows where state = "OR" sorted by native_hawaiian_pacific_islander 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
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                        
1705772 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000525 1312 Clear Creek Middle School   Regular School No Middle 06 08 2017   k_12_total 299.0 31.0 251.0     24.0     9.0   35.0                               299 31 251     24     9   35                        
1705783 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000991 935 Highland Elementary School   Regular School No Elementary KG 05 2017   k_12_total 199.0 18.0 232.0     7.0     9.0   31.0                               199 18 232     7     9   31                        
1705786 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000534 1313 Kelly Creek Elementary School   Regular School No Elementary KG 05 2017   k_12_total 340.0 14.0 115.0     17.0     9.0   36.0                               340 14 115     17     9   36                        
1705829 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2017   k_12_total 529.0 24.0 606.0     62.0     9.0   63.0                               529 24 606     62     9   63                        
1705836 OR     school 4100023 2239   Hillsboro SD 1J 410002301201 1150 Ladd Acres Elementary School   Regular School No Elementary KG 06 2017   k_12_total 256.0 9.0 126.0     69.0     9.0   56.0                               256 9 126     69     9   56                        
1706149 OR     school 4100048 4131   North Wasco County SD 21 410004801156 1098 Dry Hollow Elementary School   Regular School No Elementary KG 05 2017   k_12_total 314.0 5.0 156.0     7.0     9.0   39.0                               314 5 156     7     9   39                        
1706154 OR     school 4100048 4131   North Wasco County SD 21 410004801159 1101 The Dalles High School   Regular School No High 09 12 2017   k_12_total 503.0 2.0 276.0     10.0     9.0   30.0                               503 2 276     10     9   30                        
1706155 OR     school 4100048 4131   North Wasco County SD 21 410004801158 1100 The Dalles Middle School   Regular School No Middle 06 08 2017   k_12_total 320.0 1.0 226.0     2.0     9.0   23.0                               320 1 226     2     9   23                        
1706211 OR     school 4109330 1928   Oregon City SD 62 410933000126 118 Oregon City Senior High School   Regular School No High 09 12 2017   k_12_total 1613.0 24.0 261.0     36.0     9.0   107.0                               1613 24 261     36     9   107                        
1706239 OR     school 4109480 2181   Parkrose SD 3 410948000980 926 Russell Elementary   Regular School No Elementary KG 05 2017   k_12_total 196.0 50.0 86.0     44.0     9.0   43.0                               196 50 86     44     9   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                        
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                        
1706324 OR     school 4110040 2180   Portland SD 1J 411004000912 1243 Lane Middle School   Regular School No Middle 06 08 2017   k_12_total 163.0 35.0 121.0     70.0     9.0   39.0                               163 35 121     70     9   39                        
1706366 OR     school 4110040 2180   Portland SD 1J 411004000935 887 Scott Elementary School   Regular School No Elementary KG 08 2017   k_12_total 136.0 66.0 250.0     18.0     9.0   22.0                               136 66 250     18     9   22                        
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                        
1706381 OR     school 4110040 2180   Portland SD 1J 411004000975 922 Wilson High School   Regular School No High 09 12 2017   k_12_total 1052.0 80.0 112.0     47.0     9.0   103.0                               1052 80 112     47     9   103                        
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                        
1706439 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001819 5066 Battle Creek Elementary School   Regular School No Elementary KG 05 2017   k_12_total 447.0 10.0 61.0     8.0     9.0   41.0                               447 10 61     8     9   41                        
1706441 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000778 732 Bush Elementary School   Regular School No Elementary KG 05 2017   k_12_total 125.0 4.0 156.0     3.0     9.0   12.0                               125 4 156     3     9   12                        
1706483 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000802 756 Pringle Elementary School   Regular School No Elementary KG 05 2017   k_12_total 378.0 10.0 76.0     29.0     9.0   35.0                               378 10 76     29     9   35                        
1706505 OR     school 4108100 2104   Santiam Canyon SD 129J 410810001680 4399 Oregon Connections Academy   Regular School Yes Other KG 12 2017   k_12_total 2904.0 59.0 436.0     67.0     9.0   282.0                               2904 59 436     67     9   282                        
1706680 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001195 1143 Tualatin Elementary School   Regular School No Elementary KG 05 2017   k_12_total 310.0 9.0 195.0     12.0     9.0   21.0                               310 9 195     12     9   21                        
1190533 OR     school 4101920 2243   Beaverton SD 48J 410192000552 1319 Conestoga Middle School   Regular School No Middle 06 08 2018   k_12_total 550.0 25.0 212.0   2.0 90.0     9.0   86.0                               550 25 212   2 90     9   86                        
1190668 OR     school 4102800 2185   Centennial SD 28J 410280001019 966 Pleasant Valley Elementary School   Regular School No Elementary KG 06 2018   k_12_total 232.0 16.0 68.0   0.0 57.0     9.0   34.0                               232 16 68   0 57     9   34                        
1190961 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001040 986 Gresham High School   Regular School No High 09 12 2018   k_12_total 732.0 60.0 576.0   15.0 62.0     9.0   77.0                               732 60 576   15 62     9   77                        
1190964 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000991 935 Highland Elementary School   Regular School No Elementary KG 05 2018   k_12_total 216.0 28.0 227.0   8.0 9.0     9.0   25.0                               216 28 227   8 9     9   25                        
1191193 OR     school 4108040 2048   Medford SD 549C 410804000442 421 Hedrick Middle School   Regular School No Middle 06 08 2018   k_12_total 693.0 12.0 177.0   4.0 17.0     9.0   52.0                               693 12 177   4 17     9   52                        
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                        
1191465 OR     school 4110040 2180   Portland SD 1J 411004000877 834 Bridger Elementary School   Regular School No Elementary KG 08 2018   k_12_total 200.0 25.0 206.0   3.0 39.0     9.0   49.0                               200 25 206   3 39     9   49                        
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                        
1191784 OR     school 4111670 2083   Springfield SD 19 411167000594 560 Springfield High School   Regular School No High 09 12 2018   k_12_total 740.0 16.0 423.0   19.0 23.0     9.0   119.0                               740 16 423   19 23     9   119                        
1191888 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001575 3913 Boones Ferry Primary School   Regular School No Elementary PK 05 2018   k_12_total 374.0 2.0 120.0   2.0 19.0     9.0   34.0                               374 2 120   2 19     9   34                        
1191901 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2018   k_12_total 815.0 10.0 227.0   4.0 43.0     9.0   88.0                               815 10 227   4 43     9   88                        
916688 OR     school 4101920 2243   Beaverton SD 48J 410192001206 1155 Beaver Acres Elementary School   Regular School No Elementary KG 05 2020   k_12_total 256 37 274   9 98     9   53                               256 37 274   9 98     9   53                        
916697 OR     school 4101920 2243   Beaverton SD 48J 410192000552 1319 Conestoga Middle School   Regular School No Middle 06 08 2020   k_12_total 555 37 192   3 102     9   97                               555 37 192   3 102     9   97                        
916714 OR     school 4101920 2243   Beaverton SD 48J 410192001220 1169 McKinley Elementary School   Regular School No Elementary KG 05 2020   k_12_total 254 46 242   2 62     9   38                               254 46 242   2 62     9   38                        
916715 OR     school 4101920 2243   Beaverton SD 48J 410192001235 1182 Meadow Park Middle School   Regular School No Middle 06 08 2020   k_12_total 345 28 287   2 124     9   62                               345 28 287   2 124     9   62                        
916829 OR     school 4102800 2185   Centennial SD 28J 410280001012 959 Meadows Elementary   Regular School No Elementary KG 06 2020   k_12_total 143 14 144   2 34     9   26                               143 14 144   2 34     9   26                        
916926 OR     school 4103940 2187   David Douglas SD 40 410394001025 972 Cherry Park Elementary School   Regular School No Elementary PK 05 2020   k_12_total 176 60 125   3 48     9   51                               176 60 125   3 48     9   51                        
916929 OR     school 4103940 2187   David Douglas SD 40 410394004180 3525 Earl Boyles Elementary   Regular School No Elementary PK 05 2020   k_12_total 156 28 123   5 61     9   44                               156 28 123   5 61     9   44                        
916941 OR     school 4103940 2187   David Douglas SD 40 410394001036 979 West Powellhurst Elementary School   Regular School No Elementary KG 05 2020   k_12_total 153 46 109   1 53     9   17                               153 46 109   1 53     9   17                        
917131 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001303 937 Hollydale Elementary School   Regular School No Elementary KG 05 2020   k_12_total 233 20 127   4 8     9   37                               233 20 127   4 8     9   37                        
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                        
917353 OR     school 4108010 2256   McMinnville SD 40 410801001284 1234 McMinnville High School   Regular School No High 09 12 2020   k_12_total 1276 30 742   45 30     9   4                               1276 30 742   45 30     9   4                        
917382 OR     school 4108040 2048   Medford SD 549C 410804000441 420 Wilson Elementary School   Regular School No Elementary KG 06 2020   k_12_total 274 6 162   4 13     9   23                               274 6 162   4 13     9   23                        
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                        
917784 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000778 732 Bush Elementary School   Regular School No Elementary KG 05 2020   k_12_total 87 4 161   6 1     9   12                               87 4 161   6 1     9   12                        
917790 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000659 1329 Crossler Middle School   Regular School No Middle 06 08 2020   k_12_total 685 13 135   10 20     9   75                               685 13 135   10 20     9   75                        
917794 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000797 751 Eyre Elementary School   Regular School No Elementary KG 05 2020   k_12_total 126 5 431   4 7     9   13                               126 5 431   4 7     9   13                        
917812 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000792 746 Kennedy Elementary School   Regular School No Elementary KG 05 2020   k_12_total 117 0 253   2 1     9   16                               117 0 253   2 1     9   16                        
917822 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000800 754 Myers Elementary School   Regular School No Elementary KG 05 2020   k_12_total 288 13 120   5 5     9   33                               288 13 120   5 5     9   33                        
918027 OR     school 4112320 2197   Tillamook SD 9 411232001075 1017 Tillamook High School   Regular School No High 09 12 2020   k_12_total 437 6 201   9 7     9   31                               437 6 201   9 7     9   31                        
918066 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2020   k_12_total 818 11 224   6 54     9   85                               818 11 224   6 54     9   85                        
656814 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   k_12_total 2209 24 292   22 27     9   144                               2209 24 292   22 27     9   144                        
656832 OR     school 4101920 2243   Beaverton SD 48J 410192001206 1155 Beaver Acres Elementary School   Regular School No Elementary KG 05 2021   k_12_total 231 36 269   7 89     9   55                               231 36 269   7 89     9   55                        
656969 OR     school 4102800 2185   Centennial SD 28J 410280001574 3649 Butler Creek Elementary School   Regular School No Elementary KG 06 2021   k_12_total 297 29 92   3 76     9   43                               297 29 92   3 76     9   43                        
657076 OR     school 4103940 2187   David Douglas SD 40 410394001025 972 Cherry Park Elementary School   Regular School No Elementary PK 05 2021   k_12_total 153 50 109   2 52     9   46                               153 50 109   2 52     9   46                        
657083 OR     school 4103940 2187   David Douglas SD 40 410394001031 975 Lincoln Park Elementary School   Regular School No Elementary PK 05 2021   k_12_total 171 54 142   2 98     9   21                               171 54 142   2 98     9   21                        
657090 OR     school 4103940 2187   David Douglas SD 40 410394001036 979 West Powellhurst Elementary School   Regular School No Elementary KG 05 2021   k_12_total 137 51 105   2 54     9   18                               137 51 105   2 54     9   18                        
657273 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000990 934 Gordon Russell Middle School   Regular School No Middle 06 08 2021   k_12_total 379 33 229   8 25     9   45                               379 33 229   8 25     9   45                        
657280 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001303 937 Hollydale Elementary School   Regular School No Elementary KG 05 2021   k_12_total 239 26 164   4 13     9   54                               239 26 164   4 13     9   54                        
657502 OR     school 4108010 2256   McMinnville SD 40 410801001284 1234 McMinnville High School   Regular School No High 09 12 2021   k_12_total 1209 28 799   38 23     9   8                               1209 28 799   38 23     9   8                        
657600 OR     school 4108820 1966   North Bend SD 13 410882001751 4690 Oregon Virtual Academy   Regular School Yes Other KG 12 2021   k_12_total 2266 77 514   30 51     9   268                               2266 77 514   30 51     9   268                        
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                        
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                        
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                        
657862 OR     school 4110040 2180   Portland SD 1J 411004000935 887 Scott Elementary School   Regular School No Elementary KG 05 2021   k_12_total 155 69 171   4 19     9   34                               155 69 171   4 19     9   34                        
657898 OR     school 4110350 1977   Redmond SD 2J 411035001785 4729 Redmond Proficiency Academy   Regular School Yes High 06 12 2021   k_12_total 767 8 93   22 11     9   18                               767 8 93   22 11     9   18                        
657950 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000797 751 Eyre Elementary School   Regular School No Elementary KG 05 2021   k_12_total 120 7 417   2 8     9   10                               120 7 417   2 8     9   10                        
657967 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000793 747 Keizer Elementary School   Regular School No Elementary KG 05 2021   k_12_total 218 4 284   0 13     9   34                               218 4 284   0 13     9   34                        
657992 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001805 4859 Straub Middle School   Regular School No Middle 06 08 2021   k_12_total 401 6 130   6 19     9   50                               401 6 130   6 19     9   50                        
658175 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001195 1143 Tualatin Elementary School   Regular School No Elementary KG 05 2021   k_12_total 196 3 164   1 10     9   24                               196 3 164   1 10     9   24                        
658220 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2021   k_12_total 807 12 227   5 53     9   99                               807 12 227   5 53     9   99                        
1705348 OR     school 4101920 2243   Beaverton SD 48J 410192000552 1319 Conestoga Middle School   Regular School No Middle 06 08 2017   k_12_total 520.0 23.0 180.0     94.0     8.0   79.0                               520 23 180     94     8   79                        
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                        
1705531 OR     school 4103420 2186   Corbett SD 39 410342001729 4592 Corbett School   Regular School No Other KG 12 2017   k_12_total 1037.0 13.0 74.0     32.0     8.0   61.0                               1037 13 74     32     8   61                        
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                        
1705820 OR     school 4100023 2239   Hillsboro SD 1J 410002301199 1147 Butternut Creek Elementary School   Regular School No Elementary KG 06 2017   k_12_total 227.0 3.0 113.0     22.0     8.0   30.0                               227 3 113     22     8   30                        
1705846 OR     school 4100023 2239   Hillsboro SD 1J 410002301250 1196 R A Brown Middle School   Regular School No Middle 07 08 2017   k_12_total 334.0 23.0 197.0     96.0     8.0   51.0                               334 23 197     96     8   51                        
1705849 OR     school 4100023 2239   Hillsboro SD 1J 410002301253 1198 South Meadows Middle School   Regular School No Middle 07 08 2017   k_12_total 264.0 25.0 351.0     35.0     8.0   34.0                               264 25 351     35     8   34                        
1706113 OR     school 4108830 1924   North Clackamas SD 12 410883000085 4764 Lewelling Elementary School   Regular School No Elementary KG 05 2017   k_12_total 211.0 12.0 88.0     8.0     8.0   24.0                               211 12 88     8     8   24                        
1706118 OR     school 4108830 1924   North Clackamas SD 12 410883001354 1264 Mount Scott Elementary School   Regular School No Elementary KG 05 2017   k_12_total 238.0 4.0 42.0     51.0     8.0   23.0                               238 4 42     51     8   23                        
1706126 OR     school 4108830 1924   North Clackamas SD 12 410883000092 84 Rowe Middle School   Regular School No Middle 06 08 2017   k_12_total 468.0 13.0 239.0     12.0     8.0   62.0                               468 13 239     12     8   62                        
1706241 OR     school 4109480 2181   Parkrose SD 3 410948000982 928 Shaver Elementary School   Regular School No Elementary KG 05 2017   k_12_total 60.0 50.0 146.0     24.0     8.0   26.0                               60 50 146     24     8   26                        
1706327 OR     school 4110040 2180   Portland SD 1J 411004000914 869 Lee Elementary School   Regular School No Elementary KG 08 2017   k_12_total 125.0 80.0 75.0     97.0     8.0   54.0                               125 80 75     97     8   54                        
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                        
1706460 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000801 755 Hayesville Elementary School   Regular School No Elementary KG 05 2017   k_12_total 124.0 4.0 274.0     4.0     8.0   6.0                               124 4 274     4     8   6                        
1706461 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000789 743 Highland Elementary School   Regular School No Elementary KG 05 2017   k_12_total 129.0 12.0 240.0     2.0     8.0   15.0                               129 12 240     2     8   15                        
1706485 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001738 4596 Roberts High School   Alternative School No High 07 12 2017   k_12_total 182.0 6.0 204.0     3.0     8.0   20.0                               182 6 204     3     8   20                        
1706613 OR     school 4111670 2083   Springfield SD 19 411167000595 561 Thurston High School   Regular School No High 09 12 2017   k_12_total 1002.0 7.0 205.0     9.0     8.0   111.0                               1002 7 205     9     8   111                        
1706707 OR     school 4113080 1936   Warrenton-Hammond SD 30 411308000166 156 Warrenton Grade School   Regular School No Elementary KG 08 2017   k_12_total 597.0 1.0 87.0     5.0     8.0   32.0                               597 1 87     5     8   32                        
1706715 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001318 46 Inza R Wood Middle School   Regular School No Middle 06 08 2017   k_12_total 541.0 6.0 160.0     28.0     8.0   64.0                               541 6 160     28     8   64                        
1190506 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   k_12_total 1111.0 31.0 128.0   28.0 23.0     8.0   31.0                               1111 31 128   28 23     8   31                        
1190538 OR     school 4101920 2243   Beaverton SD 48J 410192001213 1163 Fir Grove Elementary School   Regular School No Elementary KG 05 2018   k_12_total 238.0 19.0 119.0   2.0 16.0     8.0   45.0                               238 19 119   2 16     8   45                        
1190550 OR     school 4101920 2243   Beaverton SD 48J 410192001220 1169 McKinley Elementary School   Regular School No Elementary KG 05 2018   k_12_total 226.0 48.0 238.0   1.0 57.0     8.0   42.0                               226 48 238   1 57     8   42                        
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                        
1190574 OR     school 4101920 2243   Beaverton SD 48J 410192001238 1185 Whitford Middle School   Regular School No Middle 06 08 2018   k_12_total 295.0 13.0 312.0   2.0 36.0     8.0   42.0                               295 13 312   2 36     8   42                        
1190769 OR     school 4103940 2187   David Douglas SD 40 410394001030 974 Gilbert Park Elementary School   Regular School No Elementary KG 05 2018   k_12_total 307.0 87.0 97.0   6.0 55.0     8.0   39.0                               307 87 97   6 55     8   39                        
1190913 OR     school 4105610 1931   Gladstone SD 115 410561000144 136 John Wetten Elementary School   Regular School No Elementary 01 05 2018   k_12_total 584.0 6.0 114.0   4.0 6.0     8.0   56.0                               584 6 114   4 6     8   56                        

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