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
1191018 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2018   k_12_total 783.0 40.0 507.0   11.0 99.0     16.0   78.0                               783 40 507   11 99     16   78                        
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                        
917473 OR     school 4108830 1924   North Clackamas SD 12 410883001379 4767 Rock Creek Middle School   Regular School No Middle 06 08 2020   k_12_total 546 24 174   1 99     1   64                               546 24 174   1 99     1   64                        
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                        
916835 OR     school 4102800 2185   Centennial SD 28J 410280001018 965 Powell Butte Elementary School   Regular School No Elementary KG 06 2020   k_12_total 181 55 160   5 98     14   25                               181 55 160   5 98     14   25                        
916933 OR     school 4103940 2187   David Douglas SD 40 410394001031 975 Lincoln Park Elementary School   Regular School No Elementary KG 05 2020   k_12_total 198 59 171   4 98     4   25                               198 59 171   4 98     4   25                        
917184 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2020   k_12_total 721 32 529   16 98     19   96                               721 32 529   16 98     19   96                        
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                        
1706316 OR     school 4110040 2180   Portland SD 1J 411004000902 858 Hosford Middle School   Regular School No Middle 06 08 2017   k_12_total 389.0 18.0 50.0     97.0     1.0   73.0                               389 18 50     97     1   73                        
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                        
916724 OR     school 4101920 2243   Beaverton SD 48J 410192001227 1175 Rock Creek Elementary School   Regular School No Elementary KG 05 2020   k_12_total 310 1 62   2 97     2   43                               310 1 62   2 97     2   43                        
917470 OR     school 4108830 1924   North Clackamas SD 12 410883000008 4766 Oregon Trail Elementary School   Regular School No Elementary KG 05 2020   k_12_total 309 8 59   3 97     5   48                               309 8 59   3 97     5   48                        
656842 OR     school 4101920 2243   Beaverton SD 48J 410192000552 1319 Conestoga Middle School   Regular School No Middle 06 08 2021   k_12_total 479 35 183   2 97     17   84                               479 35 183   2 97     17   84                        
657341 OR     school 4100023 2239   Hillsboro SD 1J 410002301250 1196 R A Brown Middle School   Regular School No Middle 07 08 2021   k_12_total 264 23 231   3 97     10   65                               264 23 231   3 97     10   65                        
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                        
1706722 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2017   k_12_total 1443.0 9.0 129.0     96.0     3.0   122.0                               1443 9 129     96     3   122                        
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                        
1706125 OR     school 4108830 1924   North Clackamas SD 12 410883001379 4767 Rock Creek Middle School   Regular School No Middle 06 08 2017   k_12_total 556.0 18.0 138.0     95.0     6.0   62.0                               556 18 138     95     6   62                        
1190767 OR     school 4103940 2187   David Douglas SD 40 410394001027 981 Floyd Light Middle School   Regular School No Middle 06 08 2018   k_12_total 325.0 94.0 263.0   5.0 95.0     12.0   55.0                               325 94 263   5 95     12   55                        
656980 OR     school 4102800 2185   Centennial SD 28J 410280001018 965 Powell Butte Elementary School   Regular School No Elementary KG 06 2021   k_12_total 145 56 142   9 95     17   29                               145 56 142   9 95     17   29                        
657081 OR     school 4103940 2187   David Douglas SD 40 410394001029 973 Gilbert Heights Elementary School   Regular School No Elementary KG 05 2021   k_12_total 152 71 127   2 95     20   37                               152 71 127   2 95     20   37                        
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                        
1705354 OR     school 4101920 2243   Beaverton SD 48J 410192001234 1181 Five Oaks Middle School   Regular School No Middle 06 08 2017   k_12_total 421.0 54.0 380.0     94.0     22.0   51.0                               421 54 380     94     22   51                        
1705588 OR     school 4103940 2187   David Douglas SD 40 410394001033 977 Mill Park Elementary School   Regular School No Elementary PK 05 2017   k_12_total 166.0 89.0 139.0     93.0     13.0   14.0                               166 89 139     93     13   14                        
1705843 OR     school 4100023 2239   Hillsboro SD 1J 410002301499 3160 Orenco Elementary School   Regular School No Elementary KG 06 2017   k_12_total 337.0 14.0 130.0     93.0     4.0   68.0                               337 14 130     93     4   68                        
916719 OR     school 4101920 2243   Beaverton SD 48J 410192000210 1303 Nancy Ryles Elementary School   Regular School No Elementary KG 05 2020   k_12_total 352 12 86   4 93     6   77                               352 12 86   4 93     6   77                        
916931 OR     school 4103940 2187   David Douglas SD 40 410394001029 973 Gilbert Heights Elementary School   Regular School No Elementary KG 05 2020   k_12_total 184 72 138   1 93     20   42                               184 72 138   1 93     20   42                        
656876 OR     school 4101920 2243   Beaverton SD 48J 410192001432 2783 Southridge High School   Regular School No High 09 12 2021   k_12_total 735 43 472   8 93     17   113                               735 43 472   8 93     17   113                        
1705360 OR     school 4101920 2243   Beaverton SD 48J 410192001823 4867 Hope Chinese Charter School   Regular School Yes Elementary KG 05 2017   k_12_total 53.0 2.0 13.0     92.0     0.0   32.0                               53 2 13     92     0   32                        
1190539 OR     school 4101920 2243   Beaverton SD 48J 410192001234 1181 Five Oaks Middle School   Regular School No Middle 06 08 2018   k_12_total 413.0 55.0 399.0   11.0 92.0     18.0   63.0                               413 55 399   11 92     18   63                        
917452 OR     school 4108830 1924   North Clackamas SD 12 410883001874 5451 Beatrice Morrow Cannady Elementary   Regular School No Elementary KG 05 2020   k_12_total 249 4 30   0 92     1   56                               249 4 30   0 92     1   56                        
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                        
1705838 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2017   k_12_total 779.0 46.0 517.0     91.0     16.0   80.0                               779 46 517     91     16   80                        
1190671 OR     school 4102800 2185   Centennial SD 28J 410280001018 965 Wood Elementary   Regular School No Elementary KG 06 2018   k_12_total 175.0 57.0 170.0   4.0 91.0     11.0   32.0                               175 57 170   4 91     11   32                        
657333 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2021   k_12_total 644 30 545   17 91     21   93                               644 30 545   17 91     21   93                        
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                        
1706377 OR     school 4110040 2180   Portland SD 1J 411004000947 898 West Sylvan Middle School   Regular School No Middle 06 08 2017   k_12_total 622.0 15.0 96.0     90.0     2.0   85.0                               622 15 96     90     2   85                        
1706682 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001197 1145 Twality Middle School   Regular School No Middle 06 08 2017   k_12_total 587.0 19.0 237.0     90.0     19.0   72.0                               587 19 237     90     19   72                        
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                        
1191023 OR     school 4100023 2239   Hillsboro SD 1J 410002301499 3160 Orenco Elementary School   Regular School No Elementary KG 06 2018   k_12_total 314.0 17.0 144.0   8.0 90.0     4.0   66.0                               314 17 144   8 90     4   66                        
1191857 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001197 1145 Twality Middle School   Regular School No Middle 06 08 2018   k_12_total 586.0 15.0 271.0   4.0 90.0     24.0   77.0                               586 15 271   4 90     24   77                        
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                        
1190521 OR     school 4101920 2243   Beaverton SD 48J 410192001791 4805 Arco Iris Spanish Immersion School   Regular School Yes Elementary 01 08 2018   k_12_total 144.0 5.0 121.0   2.0 9.0     3.0   32.0                               144 5 121   2 9     3   32                        
1190603 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001576 3947 Pine Ridge Elementary   Regular School No Elementary KG 05 2018   k_12_total 438.0 2.0 53.0   1.0 9.0     1.0   14.0                               438 2 53   1 9     1   14                        
1190707 OR     school 4103660 1965   Coos Bay SD 9 410366000216 201 Marshfield Senior High School   Regular School No High 08 12 2018   k_12_total 678.0 3.0 149.0   48.0 9.0     6.0   88.0                               678 3 149   48 9     6   88                        
1190726 OR     school 4103480 1901   Corvallis SD 509J 410348000042 35 Jefferson Elementary School   Regular School No Elementary KG 05 2018   k_12_total 285.0 2.0 20.0   3.0 9.0     0.0   23.0                               285 2 20   3 9     0   23                        
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                        
1190966 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001303 937 Hollydale Elementary School   Regular School No Elementary KG 05 2018   k_12_total 226.0 20.0 134.0   5.0 9.0     7.0   39.0                               226 20 134   5 9     7   39                        
1191032 OR     school 4100023 2239   Hillsboro SD 1J 410002301172 1114 W Verne McKinney Elementary School   Regular School No Elementary KG 06 2018   k_12_total 161.0 16.0 258.0   0.0 9.0     1.0   16.0                               161 16 258   0 9     1   16                        
1191106 OR     school 4107080 2056   Klamath Falls City Schools 410708000489 465 Roosevelt Elementary School   Regular School No Elementary KG 05 2018   k_12_total 287.0 2.0 63.0   12.0 9.0     0.0   21.0                               287 2 63   12 9     0   21                        
1191182 OR     school 4108010 2256   McMinnville SD 40 410801000540 1315 Duniway Middle School   Regular School No Middle 06 08 2018   k_12_total 448.0 8.0 250.0   10.0 9.0     5.0   3.0                               448 8 250   10 9     5   3                        
1191185 OR     school 4108010 2256   McMinnville SD 40 410801001281 1230 Memorial Elementary School   Regular School No Elementary KG 05 2018   k_12_total 478.0 4.0 98.0   9.0 9.0     1.0   14.0                               478 4 98   9 9     1   14                        
1191194 OR     school 4108040 2048   Medford SD 549C 410804000429 409 Hoover Elementary School   Regular School No Elementary KG 06 2018   k_12_total 577.0 2.0 91.0   4.0 9.0     4.0   38.0                               577 2 91   4 9     4   38                        
1191201 OR     school 4108040 2048   Medford SD 549C 410804001796 4821 Logos Public Charter School   Regular School Yes Other KG 12 2018   k_12_total 829.0 8.0 90.0   5.0 9.0     2.0   38.0                               829 8 90   5 9     2   38                        
1191285 OR     school 4108830 1924   North Clackamas SD 12 410883001543 4223 Clackamas Web Academy   Regular School Yes Other 01 12 2018   k_12_total 382.0 6.0 37.0   1.0 9.0     3.0   14.0                               382 6 37   1 9     3   14                        
1191313 OR     school 4108880 2141   North Marion SD 15 410888000772 726 North Marion High School   Regular School No High 09 12 2018   k_12_total 281.0 2.0 308.0   6.0 9.0     1.0   10.0                               281 2 308   6 9     1   10                        
1191330 OR     school 4100048 4131   North Wasco County SD 21 410004801158 1100 The Dalles Middle School   Regular School No Middle 06 08 2018   k_12_total 325.0 1.0 231.0   9.0 9.0     10.0   31.0                               325 1 231   9 9     10   31                        
1191376 OR     school 4109330 1928   Oregon City SD 62 410933001725 4585 Alliance Charter Academy   Regular School Yes Other KG 12 2018   k_12_total 324.0 2.0 24.0   2.0 9.0     0.0   20.0                               324 2 24   2 9     0   20                        
1191390 OR     school 4109330 1928   Oregon City SD 62 410933000147 139 Redland Elementary School   Regular School No Elementary KG 05 2018   k_12_total 470.0 2.0 42.0   4.0 9.0     2.0   20.0                               470 2 42   4 9     2   20                        
1191404 OR     school 4110890 1926   Oregon Trail SD 46 411089001799 4820 Oregon Trail Academy   Regular School Yes Other KG 11 2018   k_12_total 234.0 2.0 13.0   1.0 9.0     0.0   13.0                               234 2 13   1 9     0   13                        
1191469 OR     school 4110040 2180   Portland SD 1J 411004000884 841 Cesar Chavez K-8 School   Regular School No Elementary KG 08 2018   k_12_total 89.0 85.0 284.0   4.0 9.0     28.0   41.0                               89 85 284   4 9     28   41                        
1191475 OR     school 4110040 2180   Portland SD 1J 411004001079 1363 da Vinci Middle School   Regular School No Middle 06 08 2018   k_12_total 330.0 17.0 50.0   4.0 9.0     0.0   47.0                               330 17 50   4 9     0   47                        
1191542 OR     school 4110040 2180   Portland SD 1J 411004000936 888 Sellwood Middle School   Regular School No Middle 06 08 2018   k_12_total 463.0 6.0 46.0   1.0 9.0     0.0   64.0                               463 6 46   1 9     0   64                        
1191544 OR     school 4110040 2180   Portland SD 1J 411004000937 889 Sitton Elementary School   Regular School No Elementary KG 05 2018   k_12_total 96.0 58.0 144.0   11.0 9.0     6.0   40.0                               96 58 144   11 9     6   40                        
1191545 OR     school 4110040 2180   Portland SD 1J 411004000938 890 Skyline Elementary School   Regular School No Elementary KG 08 2018   k_12_total 211.0 6.0 32.0   2.0 9.0     1.0   32.0                               211 6 32   2 9     1   32                        
1191617 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000779 733 Candalaria Elementary School   Regular School No Elementary KG 05 2018   k_12_total 259.0 2.0 43.0   3.0 9.0     1.0   25.0                               259 2 43   3 9     1   25                        
1191653 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000799 753 Morningside Elementary School   Regular School No Elementary KG 05 2018   k_12_total 258.0 5.0 71.0   1.0 9.0     7.0   25.0                               258 5 71   1 9     7   25                        
1191678 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000783 737 Wright Elementary School   Regular School No Elementary KG 05 2018   k_12_total 298.0 10.0 44.0   6.0 9.0     11.0   26.0                               298 10 44   6 9     11   26                        

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