Data source: Big Local News · About: Big Local

82,026 rows where state = "OR" sorted by asian 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
1191855 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001195 1143 Tualatin Elementary School   Regular School No Elementary KG 05 2018   k_12_total 290.0 8.0 189.0   0.0 9.0     17.0   22.0                               290 8 189   0 9     17   22                        
1191917 OR     school 4113530 2146   Woodburn SD 103 411353000841 796 Nellie Muir Elementary School   Regular School No Elementary KG 05 2018   k_12_total 49.0 6.0 402.0   0.0 9.0     2.0   5.0                               49 6 402   0 9     2   5                        
1705327 OR     school 4101800 1969   Bandon SD 54 410180000237 218 Bandon Senior High School   Regular School No High 09 12 2017   k_12_total 172.0 1.0 24.0     9.0     0.0   25.0                               172 1 24     9     0   25                        
1705336 OR     school 4101920 2243   Beaverton SD 48J 410192001791 4805 Arco Iris Spanish Immersion School   Regular School Yes Elementary 01 08 2017   k_12_total 133.0 5.0 115.0     9.0     3.0   32.0                               133 5 115     9     3   32                        
1705401 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001438 3219 Highland School at Kenwood Elementary School   Regular School No Elementary KG 05 2017   k_12_total 369.0 2.0 5.0     9.0     0.0   5.0                               369 2 5     9     0   5                        
1705424 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001454 3221 Westside Village Magnet School at Kingston Elementary School   Regular School No Elementary KG 08 2017   k_12_total 221.0 9.0 14.0     9.0     2.0   11.0                               221 9 14     9     2   11                        
1705450 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000255 237 Brookings-Harbor High School   Regular School No High 09 12 2017   k_12_total 315.0 7.0 68.0     9.0     0.0   98.0                               315 7 68     9     0   98                        
1705464 OR     school 4102780 2139   Cascade SD 5 410278000767 719 Aumsville Elementary School   Regular School No Elementary KG 05 2017   k_12_total 426.0 4.0 114.0     9.0     3.0   7.0                               426 4 114     9     3   7                        
1705503 OR     school 4102840 2191   Central SD 13J 410284001057 1001 Talmadge Middle School   Regular School No Middle 06 08 2017   k_12_total 402.0 3.0 319.0     9.0     3.0   39.0                               402 3 319     9     3   39                        
1705652 OR     school 4104740 2082   Eugene SD 4J 410474001781 4739 Camas Ridge Community Elementary   Regular School No Elementary KG 05 2017   k_12_total 296.0 3.0 48.0     9.0     0.0   55.0                               296 3 48     9     0   55                        
1705656 OR     school 4104740 2082   Eugene SD 4J 410474000533 507 Coburg Community Charter School   Regular School Yes Elementary KG 08 2017   k_12_total 195.0 1.0 6.0     9.0     1.0   9.0                               195 1 6     9     1   9                        
1705674 OR     school 4104740 2082   Eugene SD 4J 410474000566 524 Monroe Middle School   Regular School No Middle 06 08 2017   k_12_total 376.0 6.0 90.0     9.0     5.0   47.0                               376 6 90     9     5   47                        
1705713 OR     school 4105160 2241   Forest Grove SD 15 410516001188 1126 Neil Armstrong Middle School   Regular School No Middle 07 08 2017   k_12_total 319.0 5.0 465.0     9.0     2.0   30.0                               319 5 465     9     2   30                        
1705715 OR     school 4105160 2241   Forest Grove SD 15 410516001339 1127 Tom McCall Upper Elementary   Regular School No Middle 05 06 2017   k_12_total 326.0 5.0 414.0     9.0     0.0   21.0                               326 5 414     9     0   21                        
1705816 OR     school 4106300 2206   Hermiston SD 8 410630001094 1037 Sunset Elementary School   Regular School No Elementary KG 05 2017   k_12_total 177.0 4.0 403.0     9.0     2.0   10.0                               177 4 403     9     2   10                        
1705912 OR     school 4107020 2057   Klamath County SD 410702000513 488 Mazama High School   Regular School No High 09 12 2017   k_12_total 430.0 13.0 158.0     9.0     4.0   23.0                               430 13 158     9     4   23                        
1705923 OR     school 4107080 2056   Klamath Falls City Schools 410708000512 487 Klamath Union High School   Regular School No High 09 12 2017   k_12_total 388.0 3.0 145.0     9.0     1.0   27.0                               388 3 145     9     1   27                        
1706004 OR     school 4108010 2256   McMinnville SD 40 410801001433 2784 Grandhaven Elementary School   Regular School No Elementary KG 05 2017   k_12_total 290.0 1.0 238.0     9.0     2.0   9.0                               290 1 238     9     2   9                        
1706012 OR     school 4108040 2048   Medford SD 549C 410804000963 1350 Abraham Lincoln Elementary   Regular School No Elementary KG 06 2017   k_12_total 396.0 1.0 69.0     9.0     0.0   26.0                               396 1 69     9     0   26                        
1706090 OR     school 4108720 2254   Newberg SD 29J 410872001272 1219 Mabel Rush Elementary School   Regular School No Elementary KG 05 2017   k_12_total 364.0 5.0 108.0     9.0     0.0   30.0                               364 5 108     9     0   30                        
1706109 OR     school 4108830 1924   North Clackamas SD 12 410883001543 4223 Clackamas Web Academy   Regular School Yes Other 01 12 2017   k_12_total 384.0 8.0 36.0     9.0     2.0   22.0                               384 8 36     9     2   22                        
1706137 OR     school 4108880 2141   North Marion SD 15 410888000772 726 North Marion High School   Regular School No High 09 12 2017   k_12_total 510.0 3.0 28.0     9.0     0.0   13.0                               510 3 28     9     0   13                        
1706196 OR     school 4109270 2108   Ontario SD 8C 410927000746 699 Ontario High School   Regular School No High 09 12 2017   k_12_total 255.0 7.0 389.0     9.0     0.0   8.0                               255 7 389     9     0   8                        
1706223 OR     school 4110890 1926   Oregon Trail SD 46 411089000104 97 Boring Middle School   Regular School No Middle 06 08 2017   k_12_total 316.0 2.0 51.0     9.0     2.0   17.0                               316 2 51     9     2   17                        
1706249 OR     school 4109510 2207   Pendleton SD 16 410951001106 1048 Sherwood Heights Elementary School   Regular School No Elementary KG 05 2017   k_12_total 322.0 0.0 75.0     9.0     6.0   51.0                               322 0 75     9     6   51                        
1706329 OR     school 4110040 2180   Portland SD 1J 411004000916 871 Lewis Elementary School   Regular School No Elementary KG 05 2017   k_12_total 311.0 7.0 34.0     9.0     0.0   51.0                               311 7 34     9     0   51                        
1706331 OR     school 4110040 2180   Portland SD 1J 411004000917 872 Llewellyn Elementary School   Regular School No Elementary KG 05 2017   k_12_total 422.0 5.0 28.0     9.0     5.0   46.0                               422 5 28     9     5   46                        
1706337 OR     school 4110040 2180   Portland SD 1J 411004000967 916 Metropolitan Learning Center   Alternative School No Other KG 12 2017   k_12_total 340.0 7.0 40.0     9.0     0.0   30.0                               340 7 40     9     0   30                        
1706413 OR     school 4110520 2182   Reynolds SD 7 411052000998 945 Fairview Elementary School   Regular School No Elementary KG 05 2017   k_12_total 144.0 21.0 169.0     9.0     4.0   36.0                               144 21 169     9     4   36                        
1706446 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001440 3373 Claggett Creek Middle School   Regular School No Middle 06 08 2017   k_12_total 451.0 7.0 406.0     9.0     23.0   46.0                               451 7 406     9     23   46                        
1706447 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000780 734 Clear Lake Elementary School   Regular School No Elementary KG 05 2017   k_12_total 305.0 3.0 82.0     9.0     3.0   27.0                               305 3 82     9     3   27                        
1706488 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000806 760 Schirle Elementary School   Regular School No Elementary KG 05 2017   k_12_total 329.0 7.0 48.0     9.0     1.0   22.0                               329 7 48     9     1   22                        
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                        
1706686 OR     school 4112320 2197   Tillamook SD 9 411232001075 1017 Tillamook High School   Regular School No High 09 12 2017   k_12_total 412.0 4.0 148.0     9.0     4.0   17.0                               412 4 148     9     4   17                        
1706708 OR     school 4113080 1936   Warrenton-Hammond SD 30 411308000167 157 Warrenton High School   Regular School No High 09 12 2017   k_12_total 207.0 0.0 32.0     9.0     4.0   10.0                               207 0 32     9     4   10                        
656953 OR     school 4102640 1929   Canby SD 86 410264001651 4434 Baker Prairie Middle School   Regular School No Middle 07 08 2021   k_12_total 349 2 216   4 9     1   26                               349 2 216   4 9     1   26                        
657147 OR     school 4104740 2082   Eugene SD 4J 410474001781 4739 Camas Ridge Community Elementary   Regular School No Elementary KG 05 2021   k_12_total 242 10 38   4 9     0   21                               242 10 38   4 9     0   21                        
657160 OR     school 4104740 2082   Eugene SD 4J 410474001609 4157 Holt Elementary School   Regular School No Elementary KG 05 2021   k_12_total 317 7 90   6 9     5   52                               317 7 90   6 9     5   52                        
657209 OR     school 4105160 2241   Forest Grove SD 15 410516001186 1132 Harvey Clarke Elementary School   Regular School No Elementary KG 04 2021   k_12_total 277 3 121   1 9     1   21                               277 3 121   1 9     1   21                        
657226 OR     school 4105610 1931   Gladstone SD 115 410561000146 138 Gladstone High School   Regular School No High 09 12 2021   k_12_total 434 9 97   7 9     5   41                               434 9 97   7 9     5   41                        
657255 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000734 638 North Albany Middle School   Regular School No Middle 06 08 2021   k_12_total 335 4 122   3 9     0   37                               335 4 122   3 9     0   37                        
657264 OR     school 4101120 2100   Greater Albany Public SD 8J 410112001773 4744 Timber Ridge School   Regular School No Middle 03 08 2021   k_12_total 440 3 80   4 9     3   29                               440 3 80   4 9     3   29                        
657272 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000995 941 East Orient Elementary School   Regular School No Elementary KG 05 2021   k_12_total 287 5 43   4 9     1   34                               287 5 43   4 9     1   34                        
657326 OR     school 4100023 2239   Hillsboro SD 1J   2239 Hillsboro SD 1J             2021   k_12_total 150 9 106   0 9     0   18                               150 9 106   0 9     0   18                        
657342 OR     school 4100023 2239   Hillsboro SD 1J 410002301200 1149 Reedville Elementary School   Regular School No Elementary PK 06 2021   k_12_total 32 5 171   1 9     0   8                               32 5 171   1 9     0   8                        
657405 OR     school 4107020 2057   Klamath County SD 410702000510 485 Henley High School   Regular School No High 09 12 2021   k_12_total 497 4 83   16 9     2   51                               497 4 83   16 9     2   51                        
657512 OR     school 4108040 2048   Medford SD 549C 410804000429 409 Hoover Elementary School   Regular School No Elementary KG 06 2021   k_12_total 406 1 65   1 9     4   27                               406 1 65   1 9     4   27                        
657538 OR     school 4108280 2249   Mitchell SD 55 410828001869 5440 Cascade Virtual Academy   Regular School Yes Elementary KG 08 2021   k_12_total 424 25 131   6 9     7   71                               424 25 131   6 9     7   71                        
657572 OR     school 4180180 2148   Multnomah ESD   2148 Multnomah ESD             2021   k_12_total 29 17 19   1 9     3   8                               29 17 19   1 9     3   8                        
657591 OR     school 4108720 2254   Newberg SD 29J 410872001273 1221 Mountain View Middle School   Regular School No Middle 06 08 2021   k_12_total 275 6 138   2 9     1   14                               275 6 138   2 9     1   14                        
657614 OR     school 4108830 1924   North Clackamas SD 12 410883001584 4005 Milwaukie El Puente Elementary School   Regular School No Elementary KG 05 2021   k_12_total 164 3 195   1 9     0   26                               164 3 195   1 9     0   26                        
657630 OR     school 4108830 1924   North Clackamas SD 12 410883001777 4714 Verne A Duncan Elementary School   Regular School No Elementary KG 05 2021   k_12_total 281 5 109   0 9     3   41                               281 5 109   0 9     3   41                        
657655 OR     school 4100048 4131   North Wasco County SD 21 410004801159 1101 The Dalles High School   Regular School No High 09 12 2021   k_12_total 450 1 303   10 9     13   41                               450 1 303   10 9     13   41                        
657702 OR     school 4109330 1928   Oregon City SD 62 410933000123 115 Gardiner Middle School   Regular School No Middle 06 08 2021   k_12_total 453 4 149   6 9     4   39                               453 4 149   6 9     4   39                        
657703 OR     school 4109330 1928   Oregon City SD 62 410933000114 107 Holcomb Elementary School   Regular School No Elementary KG 05 2021   k_12_total 344 10 44   1 9     6   27                               344 10 44   1 9     6   27                        
657705 OR     school 4109330 1928   Oregon City SD 62 410933000122 114 John McLoughlin Elementary School   Regular School No Elementary KG 05 2021   k_12_total 444 2 25   0 9     0   41                               444 2 25   0 9     0   41                        
657776 OR     school 4110040 2180   Portland SD 1J 411004000867 824 Alameda Elementary School   Regular School No Elementary KG 05 2021   k_12_total 499 5 40   0 9     0   71                               499 5 40   0 9     0   71                        
657782 OR     school 4110040 2180   Portland SD 1J 411004000874 831 Beaumont Middle School   Regular School No Middle 06 08 2021   k_12_total 280 38 134   0 9     2   55                               280 38 134   0 9     2   55                        
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                        
657833 OR     school 4110040 2180   Portland SD 1J 411004000967 916 Metropolitan Learning Center   Alternative School No Other KG 12 2021   k_12_total 284 5 41   1 9     0   37                               284 5 41   1 9     0   37                        
657937 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000774 728 Auburn Elementary School   Regular School No Elementary KG 05 2021   k_12_total 100 5 402   6 9     18   14                               100 5 402   6 9     18   14                        
657944 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001440 3373 Claggett Creek Middle School   Regular School No Middle 06 08 2021   k_12_total 375 5 485   7 9     14   57                               375 5 485   7 9     14   57                        
657952 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000784 738 Four Corners Elementary School   Regular School No Elementary KG 05 2021   k_12_total 75 9 312   1 9     17   15                               75 9 312   1 9     17   15                        
657954 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000791 745 Gubser Elementary School   Regular School No Elementary KG 05 2021   k_12_total 264 9 147   2 9     1   40                               264 9 147   2 9     1   40                        
657988 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000787 741 Scott Elementary School   Regular School No Elementary KG 05 2021   k_12_total 85 6 364   1 9     54   11                               85 6 364   1 9     54   11                        
916651 OR     school 4101560 2041   Ashland SD 5 410156000400 380 Ashland Middle School   Regular School No Middle 06 08 2020   k_12_total 369 3 69   4 9     0   69                               369 3 69   4 9     0   69                        
916704 OR     school 4101920 2243   Beaverton SD 48J 410192001289 1157 Greenway Elementary School   Regular School No Elementary PK 05 2020   k_12_total 132 10 144   2 9     6   20                               132 10 144   2 9     6   20                        
916713 OR     school 4101920 2243   Beaverton SD 48J 410192001219 1168 McKay Elementary School   Regular School No Elementary PK 05 2020   k_12_total 157 10 90   0 9     3   26                               157 10 90   0 9     3   26                        
916767 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000268 249 Pilot Butte Middle School   Regular School No Middle 06 08 2020   k_12_total 515 9 103   4 9     4   32                               515 9 103   4 9     4   32                        
916817 OR     school 4102780 2139   Cascade SD 5 410278000767 719 Aumsville Elementary School   Regular School No Elementary KG 05 2020   k_12_total 436 5 112   7 9     4   21                               436 5 112   7 9     4   21                        
916823 OR     school 4102780 2139   Cascade SD 5 410278000835 790 Turner Elementary School   Regular School No Elementary KG 05 2020   k_12_total 264 4 54   0 9     0   16                               264 4 54   0 9     0   16                        
917059 OR     school 4105160 2241   Forest Grove SD 15 410516001186 1132 Harvey Clarke Elementary School   Regular School No Elementary KG 04 2020   k_12_total 323 2 127   1 9     2   26                               323 2 127   1 9     2   26                        
917104 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000733 642 Memorial Middle School   Regular School No Middle 06 08 2020   k_12_total 428 4 122   3 9     3   53                               428 4 122   3 9     3   53                        
917136 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000993 939 Powell Valley Elementary School   Regular School No Elementary KG 05 2020   k_12_total 276 13 116   2 9     4   29                               276 13 116   2 9     4   29                        
917168 OR     school 4100023 2239   Hillsboro SD 1J 410002301535 4206 City View Charter School   Regular School Yes Elementary KG 08 2020   k_12_total 183 3 21   1 9     0   11                               183 3 21   1 9     0   11                        
917172 OR     school 4100023 2239   Hillsboro SD 1J 410002301764 4641 Free Orchards Elementary School   Regular School No Elementary KG 06 2020   k_12_total 118 10 215   1 9     3   9                               118 10 215   1 9     3   9                        
917256 OR     school 4107020 2057   Klamath County SD 410702000510 485 Henley High School   Regular School No High 09 12 2020   k_12_total 523 5 76   10 9     2   46                               523 5 76   10 9     2   46                        
917273 OR     school 4107080 2056   Klamath Falls City Schools 410708000512 487 Klamath Union High School   Regular School No High 09 12 2020   k_12_total 380 5 173   59 9     2   39                               380 5 173   59 9     2   39                        
917280 OR     school 4107200 2212   La Grande SD 1 410720001125 1066 Central Elementary School   Regular School No Elementary KG 05 2020   k_12_total 375 8 23   6 9     23   30                               375 8 23   6 9     23   30                        
917352 OR     school 4108010 2256   McMinnville SD 40 410801001433 2784 Grandhaven Elementary School   Regular School No Elementary KG 05 2020   k_12_total 259 1 180   9 9     2   10                               259 1 180   9 9     2   10                        
917356 OR     school 4108010 2256   McMinnville SD 40 410801001283 1233 Patton Middle School   Regular School No Middle 06 08 2020   k_12_total 456 15 368   10 9     2   3                               456 15 368   10 9     2   3                        
917393 OR     school 4108310 1925   Molalla River SD 35 410831000151 142 Molalla High School   Regular School No High 09 12 2020   k_12_total 523 0 145   7 9     1   32                               523 0 145   7 9     1   32                        
917457 OR     school 4108830 1924   North Clackamas SD 12 410883001543 4223 Clackamas Web Academy   Regular School Yes Other KG 12 2020   k_12_total 368 5 40   2 9     4   25                               368 5 40   2 9     4   25                        
917501 OR     school 4100048 4131   North Wasco County SD 21 410004801159 1101 The Dalles High School   Regular School No High 09 12 2020   k_12_total 456 4 313   11 9     11   31                               456 4 313   11 9     11   31                        
917545 OR     school 4109330 1928   Oregon City SD 62 410933000112 105 Beavercreek Elementary School   Regular School No Elementary KG 05 2020   k_12_total 469 1 40   4 9     0   34                               469 1 40   4 9     0   34                        
917621 OR     school 4110040 2180   Portland SD 1J 411004000867 824 Alameda Elementary School   Regular School No Elementary KG 05 2020   k_12_total 567 7 42   0 9     0   79                               567 7 42   0 9     0   79                        
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                        
917765 OR     school 4110520 2182   Reynolds SD 7 411052001798 4822 Rockwood Preparatory Academy   Regular School Yes Elementary KG 07 2020   k_12_total 69 36 165   2 9     5   26                               69 36 165   2 9     5   26                        
917775 OR     school 4110560 2188   Riverdale SD 51J 411056000892 1345 Riverdale High School   Regular School No High 09 12 2020   k_12_total 189 2 13   1 9     0   19                               189 2 13   1 9     0   19                        
917796 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000784 738 Four Corners Elementary School   Regular School No Elementary KG 05 2020   k_12_total 86 5 328   4 9     17   18                               86 5 328   4 9     17   18                        
917814 OR     school 4110820 2142   Salem-Keizer SD 24J 411082004192 3526 Lee Elementary School   Regular School No Elementary KG 05 2020   k_12_total 136 2 140   1 9     4   18                               136 2 140   1 9     4   18                        
917821 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000799 753 Morningside Elementary School   Regular School No Elementary KG 05 2020   k_12_total 228 2 66   1 9     12   23                               228 2 66   1 9     12   23                        
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                        
917899 OR     school 4111490 1978   Sisters SD 6 411149000073 1294 Sisters High School   Regular School No High 09 12 2020   k_12_total 366 1 34   7 9     3   14                               366 1 34   7 9     3   14                        
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                        
1191301 OR     school 4108830 1924   North Clackamas SD 12 410883001379 4767 Rock Creek Middle School   Regular School No Middle 06 08 2018   k_12_total 543.0 21.0 153.0   1.0 89.0     8.0   63.0                               543 21 153   1 89     8   63                        
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                        
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                        
917192 OR     school 4100023 2239   Hillsboro SD 1J 410002301250 1196 R A Brown Middle School   Regular School No Middle 07 08 2020   k_12_total 337 19 214   3 89     10   65                               337 19 214   3 89     10   65                        
1191489 OR     school 4110040 2180   Portland SD 1J 411004000902 858 Hosford Middle School   Regular School No Middle 06 08 2018   k_12_total 376.0 25.0 53.0   5.0 88.0     0.0   74.0                               376 25 53   5 88     0   74                        

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