Data source: Big Local News · About: Big Local

20,580 rows where state = "OR" and year = 2017 sorted by black descending

View and edit SQL

grade

year

  • 2017 · 20,580
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
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                        
1705583 OR     school 4103940 2187   David Douglas SD 40 410394001027 981 Floyd Light Middle School   Regular School No Middle 06 08 2017   k_12_total 334.0 94.0 239.0     88.0     14.0   51.0                               334 94 239     88     14   51                        
1705470 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2017   k_12_total 820.0 91.0 446.0     260.0     33.0   102.0                               820 91 446     260     33   102                        
1706308 OR     school 4110040 2180   Portland SD 1J 411004000960 911 Franklin High School   Regular School No High 09 12 2017   k_12_total 754.0 90.0 357.0     271.0     14.0   108.0                               754 90 357     271     14   108                        
1705307 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2017   k_12_total 236.0 9.0 48.0     6.0     2.0   28.0                               236 9 48     6     2   28                        
1705337 OR     school 4101920 2243   Beaverton SD 48J 410192000213 1304 Arts and Communication Magnet Academy   Regular School No Other 06 12 2017   k_12_total 478.0 9.0 112.0     34.0     2.0   73.0                               478 9 112     34     2   73                        
1705359 OR     school 4101920 2243   Beaverton SD 48J 410192001216 1165 Hiteon Elementary School   Regular School No Elementary KG 05 2017   k_12_total 454.0 9.0 97.0     55.0     7.0   51.0                               454 9 97     55     7   51                        
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                        
1705429 OR     school 4102040 2088   Bethel SD 52 410204000616 582 Clear Lake Elementary School   Regular School No Elementary KG 05 2017   k_12_total 195.0 9.0 44.0     3.0     0.0   11.0                               195 9 44     3     0   11                        
1705443 OR     school 4102040 2088   Bethel SD 52 410204000622 587 Shasta Middle School   Regular School No Middle 06 08 2017   k_12_total 292.0 9.0 83.0     4.0     3.0   39.0                               292 9 83     4     3   39                        
1705532 OR     school 4103480 1901   Corvallis SD 509J 410348000032 27 Adams Elementary School   Regular School No Elementary KG 05 2017   k_12_total 327.0 9.0 13.0     23.0     2.0   29.0                               327 9 13     23     2   29                        
1705609 OR     school 4110710 1991   Douglas County SD 4 411071000298 278 John C Fremont Middle School   Regular School No Middle 06 08 2017   k_12_total 529.0 9.0 68.0     7.0     2.0   55.0                               529 9 68     7     2   55                        
1705647 OR     school 4104740 2082   Eugene SD 4J 410474001737 4554 Arts and Technology Academy at Jefferson   Regular School No Middle 06 08 2017   k_12_total 207.0 9.0 77.0     11.0     2.0   38.0                               207 9 77     11     2   38                        
1705659 OR     school 4104740 2082   Eugene SD 4J 410474000538 510 Edison Elementary School   Regular School No Elementary KG 05 2017   k_12_total 282.0 9.0 40.0     28.0     0.0   20.0                               282 9 40     28     0   20                        
1705719 OR     school 4105430 2245   Gaston SD 511J 410543001247 1194 Gaston Elementary School   Regular School No Elementary KG 06 2017   k_12_total 222.0 9.0 33.0     1.0     1.0   4.0                               222 9 33     1     1   4                        
1705784 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600004182 3543 Hogan Cedars Elementary School   Regular School No Elementary KG 05 2017   k_12_total 330.0 9.0 202.0     14.0     2.0   27.0                               330 9 202     14     2   27                        
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                        
1705914 OR     school 4107020 2057   Klamath County SD 410702000502 477 Peterson Elementary School   Regular School No Elementary KG 06 2017   k_12_total 380.0 9.0 125.0     8.0     2.0   62.0                               380 9 125     8     2   62                        
1706026 OR     school 4108040 2048   Medford SD 549C 410804000443 422 McLoughlin Middle School   Regular School No Middle 06 08 2017   k_12_total 471.0 9.0 285.0     3.0     7.0   29.0                               471 9 285     3     7   29                        
1706089 OR     school 4108720 2254   Newberg SD 29J 410872001674 4342 Joan Austin Elementary School   Regular School No Elementary KG 05 2017   k_12_total 264.0 9.0 67.0     2.0     2.0   8.0                               264 9 67     2     2   8                        
1706183 OR     school 4100043 3477   ODE YCEP District 410004301406 2260 New Bridge High School   Regular School No Other 06 12 2017   k_12_total 41.0 9.0 16.0     1.0     0.0   7.0                               41 9 16     1     0   7                        
1706281 OR     school 4110040 2180   Portland SD 1J 411004000867 824 Alameda Elementary School   Regular School No Elementary KG 05 2017   k_12_total 628.0 9.0 39.0     8.0     0.0   63.0                               628 9 39     8     0   63                        
1706426 OR     school 4110520 2182   Reynolds SD 7 411052001004 950 Sweetbriar Elementary School   Regular School No Elementary KG 05 2017   k_12_total 249.0 9.0 97.0     15.0     2.0   34.0                               249 9 97     15     2   34                        
1706470 OR     school 4110820 2142   Salem-Keizer SD 24J 411082001442 3375 Lamb Elementary School   Regular School No Elementary KG 05 2017   k_12_total 126.0 9.0 328.0     5.0     16.0   11.0                               126 9 328     5     16   11                        
1706472 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000812 766 Leslie Middle School   Regular School No Middle 06 08 2017   k_12_total 465.0 9.0 220.0     11.0     12.0   51.0                               465 9 220     11     12   51                        
1706484 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000803 757 Richmond Elementary School   Regular School No Elementary KG 05 2017   k_12_total 110.0 9.0 216.0     4.0     19.0   24.0                               110 9 216     4     19   24                        
1706670 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001298 1142 Edward Byrom Elementary School   Regular School No Elementary KG 05 2017   k_12_total 393.0 9.0 96.0     14.0     5.0   32.0                               393 9 96     14     5   32                        
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                        
1706711 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001356 1272 Boeckman Creek Primary School   Regular School No Elementary PK 05 2017   k_12_total 369.0 9.0 73.0     20.0     5.0   28.0                               369 9 73     20     5   28                        
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                        
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                        
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                        
1706296 OR     school 4110040 2180   Portland SD 1J 411004000884 841 Cesar Chavez K-8 School   Regular School No Elementary KG 08 2017   k_12_total 92.0 86.0 307.0     7.0     27.0   29.0                               92 86 307     7     27   29                        
1706364 OR     school 4110040 2180   Portland SD 1J 411004000933 886 Sabin Elementary School   Regular School No Elementary PK 08 2017   k_12_total 337.0 86.0 42.0     5.0     3.0   50.0                               337 86 42     5     3   50                        
1706423 OR     school 4110520 2182   Reynolds SD 7 411052001010 1254 Reynolds Middle School   Regular School No Middle 06 08 2017   k_12_total 236.0 81.0 491.0     50.0     28.0   52.0                               236 81 491     50     28   52                        
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                        
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                        
1705404 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000265 246 Juniper Elementary School   Regular School No Elementary KG 05 2017   k_12_total 415.0 8.0 85.0     7.0     0.0   12.0                               415 8 85     7     0   12                        
1705536 OR     school 4103480 1901   Corvallis SD 509J 410348000048 41 Crescent Valley High School   Regular School No High 09 12 2017   k_12_total 754.0 8.0 88.0     88.0     3.0   57.0                               754 8 88     88     3   57                        
1705539 OR     school 4103480 1901   Corvallis SD 509J 410348000040 33 Hoover Elementary School   Regular School No Elementary KG 05 2017   k_12_total 284.0 8.0 31.0     57.0     0.0   43.0                               284 8 31     57     0   43                        
1705545 OR     school 4103480 1901   Corvallis SD 509J 410348000046 39 Wilson Elementary School   Regular School No Elementary KG 05 2017   k_12_total 268.0 8.0 46.0     26.0     4.0   32.0                               268 8 46     26     4   32                        
1705578 OR     school 4103940 2187   David Douglas SD 40 410394004181 3580 Arthur Academy   Regular School Yes Elementary KG 05 2017   k_12_total 92.0 8.0 16.0     19.0     3.0   17.0                               92 8 16     19     3   17                        
1705697 OR     school 4104950 2084   Fern Ridge SD 28J 410495000601 567 Elmira High School   Regular School No High 09 12 2017   k_12_total 363.0 8.0 26.0     3.0     2.0   11.0                               363 8 26     3     2   11                        
1705825 OR     school 4100023 2239   Hillsboro SD 1J 410002301242 1189 Farmington View Elementary School   Regular School No Elementary KG 06 2017   k_12_total 212.0 8.0 56.0     12.0     0.0   18.0                               212 8 56     12     0   18                        
1705831 OR     school 4100023 2239   Hillsboro SD 1J   2239 Hillsboro SD 1J             2017   k_12_total 166.0 8.0 125.0     14.0     1.0   13.0                               166 8 125     14     1   13                        
1705848 OR     school 4100023 2239   Hillsboro SD 1J 410002301750 4703 Rosedale Elementary School   Regular School No Elementary KG 06 2017   k_12_total 178.0 8.0 169.0     35.0     3.0   42.0                               178 8 169     35     3   42                        
1705890 OR     school 4106930 2091   Junction City SD 69 410693000630 595 Laurel Elementary School   Regular School No Elementary KG 04 2017   k_12_total 395.0 8.0 62.0     3.0     3.0   8.0                               395 8 62     3     3   8                        
1705916 OR     school 4107020 2057   Klamath County SD 410702000503 478 Shasta Elementary School   Regular School No Elementary KG 06 2017   k_12_total 373.0 8.0 80.0     14.0     2.0   36.0                               373 8 80     14     2   36                        
1705931 OR     school 4107200 2212   La Grande SD 1 410720001125 1066 Central Elementary School   Regular School No Elementary 01 05 2017   k_12_total 300.0 8.0 25.0     6.0     12.0   26.0                               300 8 25     6     12   26                        
1706041 OR     school 4108280 2249   Mitchell SD 55 410828001813 5150 Insight School of Oregon Painted Hills   Regular School Yes High 07 12 2017   k_12_total 229.0 8.0 51.0     2.0     2.0   19.0                               229 8 51     2     2   19                        
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                        
1706133 OR     school 4108830 1924   North Clackamas SD 12 410883000080 72 Whitcomb Elementary School   Regular School No Elementary KG 05 2017   k_12_total 195.0 8.0 204.0     11.0     2.0   26.0                               195 8 204     11     2   26                        
1706144 OR     school 4100020 2143   North Santiam SD 29J 410002000854 809 Stayton High School   Regular School No High 09 12 2017   k_12_total 521.0 8.0 114.0     5.0     3.0   27.0                               521 8 114     5     3   27                        
1706167 OR     school 4109150 2093   Oakridge SD 76 410915000635 600 Oakridge Elementary School   Regular School No Elementary KG 06 2017   k_12_total 266.0 8.0 24.0     3.0     3.0   1.0                               266 8 24     3     3   1                        
1706195 OR     school 4109270 2108   Ontario SD 8C 410927000743 696 May Roberts Elementary School   Regular School No Elementary KG 06 2017   k_12_total 83.0 8.0 269.0     2.0     0.0   11.0                               83 8 269     2     0   11                        
1706202 OR     school 4109330 1928   Oregon City SD 62 410933000113 106 Candy Lane Elementary School   Regular School No Elementary 02 05 2017   k_12_total 136.0 8.0 105.0     2.0     2.0   19.0                               136 8 105     2     2   19                        
1706220 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   k_12_total 49.0 8.0 48.0     4.0     5.0   5.0                               49 8 48     4     5   5                        
1706305 OR     school 4110040 2180   Portland SD 1J 411004001581 3991 Emerson School   Regular School Yes Elementary KG 05 2017   k_12_total 70.0 8.0 18.0     3.0     0.0   45.0                               70 8 18     3     0   45                        
1706373 OR     school 4110040 2180   Portland SD 1J 411004000941 893 Sunnyside Environmental School   Regular School No Elementary KG 08 2017   k_12_total 465.0 8.0 43.0     11.0     1.0   68.0                               465 8 43     11     1   68                        
1706456 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000791 745 Gubser Elementary School   Regular School No Elementary KG 05 2017   k_12_total 362.0 8.0 124.0     10.0     7.0   28.0                               362 8 124     10     7   28                        
1706462 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000790 744 Hoover Elementary School   Regular School No Elementary KG 05 2017   k_12_total 115.0 8.0 324.0     3.0     12.0   12.0                               115 8 324     3     12   12                        
1706468 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000793 747 Keizer Elementary School   Regular School No Elementary KG 05 2017   k_12_total 318.0 8.0 313.0     5.0     3.0   32.0                               318 8 313     5     3   32                        
1706494 OR     school 4110820 2142   Salem-Keizer SD 24J 411082000807 761 Sumpter Elementary School   Regular School No Elementary KG 05 2017   k_12_total 439.0 8.0 39.0     26.0     5.0   26.0                               439 8 39     26     5   26                        
1706523 OR     school 4111100 1935   Seaside SD 10 411110000161 152 Seaside Heights Elementary School   Regular School No Elementary KG 05 2017   k_12_total 248.0 8.0 154.0     10.0     1.0   9.0                               248 8 154     10     1   9                        
1706524 OR     school 4111100 1935   Seaside SD 10 411110000163 154 Seaside High School   Regular School No High 09 12 2017   k_12_total 317.0 8.0 99.0     16.0     3.0   4.0                               317 8 99     16     3   4                        
1706538 OR     school 4111290 2244   Sherwood SD 88J 411129001246 1193 Sherwood High School   Regular School No High 09 12 2017   k_12_total 1377.0 8.0 161.0     48.0     5.0   81.0                               1377 8 161     48     5   81                        
1706624 OR     school 4111720 1948   St Helens SD 502 411172000196 185 St Helens High School   Regular School No High 09 12 2017   k_12_total 764.0 8.0 93.0     16.0     4.0   48.0                               764 8 93     16     4   48                        
1706672 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001192 1139 James Templeton Elementary School   Regular School No Elementary KG 05 2017   k_12_total 365.0 8.0 143.0     12.0     15.0   41.0                               365 8 143     12     15   41                        
1705780 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001040 986 Gresham High School   Regular School No High 09 12 2017   k_12_total 799.0 77.0 514.0     61.0     12.0   85.0                               799 77 514     61     12   85                        
1706362 OR     school 4110040 2180   Portland SD 1J   1669 Rosemary Anderson High School             2017   k_12_total 49.0 77.0 62.0     5.0     0.0   22.0                               49 77 62     5     0   22                        
1706317 OR     school 4110040 2180   Portland SD 1J 411004000905 861 Irvington Elementary School   Regular School No Elementary KG 08 2017   k_12_total 252.0 74.0 54.0     5.0     0.0   60.0                               252 74 54     5     0   60                        
1705577 OR     school 4103940 2187   David Douglas SD 40 410394001028 980 Alice Ott Middle School   Regular School No Middle 06 08 2017   k_12_total 319.0 70.0 130.0     116.0     11.0   68.0                               319 70 130     116     11   68                        
1706354 OR     school 4110040 2180   Portland SD 1J   2180 Portland SD 1J             2017   k_12_total 443.0 70.0 84.0     52.0     2.0   63.0                               443 70 84     52     2   63                        
1705344 OR     school 4101920 2243   Beaverton SD 48J 410192001210 1158 Cedar Mill Elementary School   Regular School No Elementary KG 05 2017   k_12_total 248.0 7.0 43.0     61.0     3.0   46.0                               248 7 43     61     3   46                        
1705385 OR     school 4101920 2243   Beaverton SD 48J 410192001231 1178 West Tualatin View Elementary School   Regular School No Elementary KG 05 2017   k_12_total 252.0 7.0 32.0     40.0     0.0   37.0                               252 7 32     40     0   37                        
1705399 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000263 1309 High Desert Middle School   Regular School No Middle 06 08 2017   k_12_total 571.0 7.0 145.0     14.0     1.0   18.0                               571 7 145     14     1   18                        
1705413 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001839 5292 Pacific Crest Middle School   Regular School No Middle 06 08 2017   k_12_total 631.0 7.0 25.0     7.0     3.0   17.0                               631 7 25     7     3   17                        
1705420 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001844 5293 Silver Rail Elementary School   Regular School No Elementary KG 05 2017   k_12_total 331.0 7.0 78.0     3.0     0.0   10.0                               331 7 78     3     0   10                        
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                        
1705460 OR     school 4102640 1929   Canby SD 86 410264000132 124 Howard Eccles Elementary School   Regular School No Elementary KG 06 2017   k_12_total 359.0 7.0 100.0     5.0     2.0   20.0                               359 7 100     5     2   20                        
1705473 OR     school 4102800 2185   Centennial SD 28J   2185 Centennial SD 28J             2017   k_12_total 48.0 7.0 13.0     5.0     0.0   13.0                               48 7 13     5     0   13                        
1705621 OR     school 4104500 2043   Eagle Point SD 9 410450000417 397 Eagle Point High School   Regular School No High 09 12 2017   k_12_total 655.0 7.0 297.0     3.0     0.0   42.0                               655 7 297     3     0   42                        
1705646 OR     school 4104740 2082   Eugene SD 4J 410474000530 503 Adams Elementary School   Regular School No Elementary KG 05 2017   k_12_total 370.0 7.0 35.0     11.0     3.0   34.0                               370 7 35     11     3   34                        
1705650 OR     school 4104740 2082   Eugene SD 4J 410474001345 1241 Buena Vista Elementary School   Regular School No Elementary KG 05 2017   k_12_total 244.0 7.0 141.0     5.0     0.0   31.0                               244 7 141     5     0   31                        
1705651 OR     school 4104740 2082   Eugene SD 4J 410474000561 506 Cal Young Middle School   Regular School No Middle 06 08 2017   k_12_total 384.0 7.0 47.0     26.0     3.0   38.0                               384 7 47     26     3   38                        
1705676 OR     school 4104740 2082   Eugene SD 4J 410474000571 536 North Eugene High School   Regular School No High 09 12 2017   k_12_total 601.0 7.0 178.0     15.0     3.0   69.0                               601 7 178     15     3   69                        
1705788 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001787 4740 Metro East Web Academy   Regular School Yes Other 06 12 2017   k_12_total 320.0 7.0 70.0     14.0     2.0   13.0                               320 7 70     14     2   13                        
1705826 OR     school 4100023 2239   Hillsboro SD 1J 410002301764 4641 Free Orchards Elementary School   Regular School No Elementary KG 06 2017   k_12_total 133.0 7.0 223.0     13.0     1.0   9.0                               133 7 223     13     1   9                        
1705839 OR     school 4100023 2239   Hillsboro SD 1J 410002301749 4642 Lincoln Street Elementary School   Regular School No Elementary KG 06 2017   k_12_total 102.0 7.0 391.0     3.0     3.0   7.0                               102 7 391     3     3   7                        
1705859 OR     school 4106510 2024   Hood River County SD 410651000382 362 May Street Elementary School   Regular School No Elementary KG 05 2017   k_12_total 306.0 7.0 145.0     7.0     1.0   22.0                               306 7 145     7     1   22                        
1705863 OR     school 4106510 2024   Hood River County SD 410651000386 366 Westside Elementary School   Regular School No Elementary KG 05 2017   k_12_total 344.0 7.0 125.0     5.0     0.0   13.0                               344 7 125     5     0   13                        
1705872 OR     school 4106740 2053   Jefferson County SD 509J 410674000656 1773 Jefferson County Middle School   Regular School No Middle 06 08 2017   k_12_total 162.0 7.0 202.0     3.0     1.0   4.0                               162 7 202     3     1   4                        
1705873 OR     school 4106740 2053   Jefferson County SD 509J 410674000456 434 Madras High School   Regular School No High 09 12 2017   k_12_total 194.0 7.0 238.0     3.0     2.0   8.0                               194 7 238     3     2   8                        
1706002 OR     school 4108010 2256   McMinnville SD 40 410801001279 1228 Columbus Elementary School   Regular School No Elementary KG 05 2017   k_12_total 273.0 7.0 184.0     3.0     1.0   9.0                               273 7 184     3     1   9                        
1706011 OR     school 4108010 2256   McMinnville SD 40 410801001310 1232 Wascher Elementary School   Regular School No Elementary KG 05 2017   k_12_total 290.0 7.0 136.0     3.0     0.0   3.0                               290 7 136     3     0   3                        
1706018 OR     school 4108040 2048   Medford SD 549C 410804000431 411 Jackson Elementary School   Regular School No Elementary KG 06 2017   k_12_total 173.0 7.0 221.0     0.0     2.0   26.0                               173 7 221     0     2   26                        
1706066 OR     school 4108550 2145   Mt Angel SD 91 410855000838 793 St Marys Public School   Regular School No Elementary KG 05 2017   k_12_total 184.0 7.0 182.0     0.0     3.0   5.0                               184 7 182     0     3   5                        
1706067 OR     school 4180180 2148   Multnomah ESD 418018001510 3168 Arata Creek School   Alternative School No Other KG 12 2017   k_12_total 30.0 7.0 3.0     0.0     0.0   4.0                               30 7 3     0     0   4                        
1706087 OR     school 4108720 2254   Newberg SD 29J 410872001270 1217 Edwards Elementary School   Regular School No Elementary KG 05 2017   k_12_total 282.0 7.0 211.0     1.0     3.0   13.0                               282 7 211     1     3   13                        

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