Data source: Big Local News · About: Big Local

20,426 rows where state = "OR" and year = 2018 sorted by black_int

View and edit SQL

grade

year

  • 2018 · 20,326
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
1190823 OR     school 4104700 1930   Estacada SD 108   1930 Estacada SD 108             2018   k_12_total 26.0 0.0 6.0   0.0 1.0     0.0   2.0                               26 0 6   0 1     0   2                        
1190825 OR     school 4104700 1930   Estacada SD 108   1671 Serendipity             2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1190831 OR     school 4104740 2082   Eugene SD 4J   4717 Bridgeway House             2018   k_12_total 7.0 0.0 1.0   2.0 0.0     0.0   1.0                               7 0 1   2 0     0   1                        
1190837 OR     school 4104740 2082   Eugene SD 4J 410474001858 5408 Chinese Language Immersion School   Regular School No Elementary KG 05 2018   k_12_total 27.0 0.0 2.0   0.0 5.0     0.0   8.0                               27 0 2   0 5     0   8                        
1190845 OR     school 4104740 2082   Eugene SD 4J 410474000690 1339 Family School   Alternative School No Elementary KG 05 2018   k_12_total 105.0 0.0 18.0   2.0 0.0     1.0   11.0                               105 0 18   2 0     1   11                        
1190849 OR     school 4104740 2082   Eugene SD 4J   1792 Jasper Mountain Center             2018   k_12_total 2.0 0.0 0.0   0.0 0.0     0.0   0.0                               2 0 0   0 0     0   0                        
1190852 OR     school 4104740 2082   Eugene SD 4J   3545 Looking Glass Center Point School             2018   k_12_total 3.0 0.0 0.0   0.0 0.0     0.0   1.0                               3 0 0   0 0     0   1                        
1190853 OR     school 4104740 2082   Eugene SD 4J   1532 Looking Glass Riverfront School & Career Center             2018   k_12_total 9.0 0.0 2.0   0.0 0.0     0.0   0.0                               9 0 2   0 0     0   0                        
1190858 OR     school 4104740 2082   Eugene SD 4J   1786 New Roads             2018   k_12_total 15.0 0.0 1.0   2.0 0.0     0.0   4.0                               15 0 1   2 0     0   4                        
1190860 OR     school 4104740 2082   Eugene SD 4J   5418 Professional Interventions and Tools for Coping and Healing (PITCH)             2018   k_12_total 4.0 0.0 0.0   1.0 0.0     0.0   0.0                               4 0 0   1 0     0   0                        
1190861 OR     school 4104740 2082   Eugene SD 4J 410474001491 3233 Ridgeline Montessori   Regular School Yes Elementary KG 08 2018   k_12_total 193.0 0.0 17.0   2.0 3.0     0.0   32.0                               193 0 17   2 3     0   32                        
1190865 OR     school 4104740 2082   Eugene SD 4J   1789 SAFE Center School             2018   k_12_total 1.0 0.0 1.0   2.0 0.0     0.0   1.0                               1 0 1   2 0     0   1                        
1190872 OR     school 4104740 2082   Eugene SD 4J 410474001848 1861 Twin Rivers Charter School   Regular School Yes High 08 12 2018   k_12_total 27.0 0.0 1.0   1.0 0.0     1.0   4.0                               27 0 1   1 0     1   4                        
1190874 OR     school 4104740 2082   Eugene SD 4J   1545 Wellsprings Friends School             2018   k_12_total 27.0 0.0 3.0   1.0 0.0     0.0   1.0                               27 0 3   1 0     0   1                        
1190877 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2018   k_12_total 111.0 0.0 9.0   2.0 0.0     0.0   8.0                               111 0 9   2 0     0   8                        
1190878 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2018   k_12_total 69.0 0.0 2.0   1.0 2.0     0.0   3.0                               69 0 2   1 2     0   3                        
1190879 OR     school 4104950 2084   Fern Ridge SD 28J   4717 Bridgeway House             2018   k_12_total 5.0 0.0 0.0   0.0 0.0     0.0   0.0                               5 0 0   0 0     0   0                        
1190883 OR     school 4104950 2084   Fern Ridge SD 28J   1532 Looking Glass Riverfront School & Career Center             2018   k_12_total 2.0 0.0 2.0   0.0 0.0     0.0   0.0                               2 0 2   0 0     0   0                        
1190885 OR     school 4104950 2084   Fern Ridge SD 28J   1545 Wellsprings Friends School             2018   k_12_total 2.0 0.0 0.0   0.0 0.0     0.0   0.0                               2 0 0   0 0     0   0                        
1190888 OR     school 4105160 2241   Forest Grove SD 15 410516001183 1129 Dilley Elementary School   Regular School No Elementary KG 04 2018   k_12_total 206.0 0.0 36.0   0.0 3.0     0.0   11.0                               206 0 36   0 3     0   11                        
1190900 OR     school 4105310 2020   Frenchglen SD 16 410531000370 351 Frenchglen Elementary School   Regular School No Elementary KG 08 2018   k_12_total 2.0 0.0 0.0   0.0 0.0     1.0   0.0                               2 0 0   0 0     1   0                        
1190905 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2018   k_12_total 121.0 0.0 294.0   1.0 2.0     0.0   7.0                               121 0 294   1 2     0   7                        
1190907 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2018   k_12_total 60.0 0.0 167.0   2.0 2.0     1.0   5.0                               60 0 167   2 2     1   5                        
1190908 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2018   k_12_total 10.0 0.0 25.0   0.0 0.0     0.0   1.0                               10 0 25   0 0     0   1                        
1190909 OR     school 4105610 1931   Gladstone SD 115   2407 Clackamas Community College             2018   k_12_total 1.0 0.0 0.0   0.0 0.0     0.0   0.0                               1 0 0   0 0     0   0                        
1190910 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   k_12_total 94.0 0.0 23.0   1.0 0.0     0.0   13.0                               94 0 23   1 0     0   13                        
1190912 OR     school 4105610 1931   Gladstone SD 115   1931 Gladstone SD 115             2018   k_12_total 2.0 0.0 1.0   0.0 0.0     0.0   0.0                               2 0 1   0 0     0   0                        
1190914 OR     school 4105610 1931   Gladstone SD 115   1671 Serendipity             2018   k_12_total 3.0 0.0 0.0   0.0 0.0     0.0   1.0                               3 0 0   0 0     0   1                        
1190918 OR     school 4105670 1992   Glide SD 12 410567000302 282 Glide Elementary School   Regular School No Elementary KG 06 2018   k_12_total 361.0 0.0 26.0   5.0 0.0     1.0   24.0                               361 0 26   5 0     1   24                        
1190919 OR     school 4105670 1992   Glide SD 12 410567000305 285 Glide High School   Regular School No High 09 12 2018   k_12_total 191.0 0.0 14.0   2.0 0.0     1.0   13.0                               191 0 14   2 0     1   13                        
1190920 OR     school 4105670 1992   Glide SD 12 410567000303 284 Glide Middle School   Regular School No Middle 07 08 2018   k_12_total 92.0 0.0 10.0   1.0 0.0     0.0   6.0                               92 0 10   1 0     0   6                        
1190923 OR     school 4105910 2054   Grants Pass SD 7   2054 Grants Pass SD 7             2018   k_12_total 69.0 0.0 16.0   2.0 1.0     0.0   9.0                               69 0 16   2 1     0   9                        
1190927 OR     school 4105910 2054   Grants Pass SD 7 410591000970 1351 Parkside Elementary   Regular School No Elementary KG 05 2018   k_12_total 353.0 0.0 47.0   3.0 0.0     0.0   35.0                               353 0 47   3 0     0   35                        
1190933 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000669 631 Central Elementary School   Regular School No Elementary 03 05 2018   k_12_total 132.0 0.0 19.0   1.0 0.0     0.0   14.0                               132 0 19   1 0     0   14                        
1190935 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000031 635 Fir Grove Primary School   Regular School No Elementary KG 01 2018   k_12_total 131.0 0.0 6.0   3.0 1.0     0.0   7.0                               131 0 6   3 1     0   7                        
1190936 OR     school 4101120 2100   Greater Albany Public SD 8J   2100 Greater Albany Public SD 8J             2018   k_12_total 68.0 0.0 5.0   1.0 0.0     0.0   3.0                               68 0 5   1 0     0   3                        
1190940 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000029 637 North Albany Elementary School   Regular School No Elementary KG 05 2018   k_12_total 230.0 0.0 12.0   1.0 6.0     0.0   19.0                               230 0 12   1 6     0   19                        
1190950 OR     school 4101120 2100   Greater Albany Public SD 8J 410112001773 4744 Timber Ridge School   Regular School No Middle 03 08 2018   k_12_total 596.0 0.0 84.0   5.0 3.0     0.0   57.0                               596 0 84   5 3     0   57                        
1190953 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001571 3553 Center for Advanced Learning   Regular School Yes High 11 12 2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1190977 OR     school 4102490 2014   Harney County SD 3 410249001520 3740 Burns Alternative School   Alternative School No High 06 12 2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1190978 OR     school 4102490 2014   Harney County SD 3 410249000379 359 Burns High School   Regular School No High 09 12 2018   k_12_total 204.0 0.0 19.0   8.0 1.0     0.0   20.0                               204 0 19   8 1     0   20                        
1190979 OR     school 4102490 2014   Harney County SD 3   2014 Harney County SD 3             2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1190980 OR     school 4102490 2014   Harney County SD 3 410249000361 342 Henry L Slater Elementary School   Regular School No Elementary KG 05 2018   k_12_total 340.0 0.0 35.0   17.0 0.0     0.0   25.0                               340 0 35   17 0     0   25                        
1190982 OR     school 4103600 2015   Harney County SD 4 410360000365 346 Crane Elementary School   Regular School No Elementary KG 08 2018   k_12_total 76.0 0.0 4.0   1.0 0.0     0.0   7.0                               76 0 4   1 0     0   7                        
1190983 OR     school 4103630 2023   Harney County Union High SD 1J 410363000378 358 Crane Union High School   Regular School No High 09 12 2018   k_12_total 48.0 0.0 0.0   2.0 0.0     0.0   4.0                               48 0 0   2 0     0   4                        
1190984 OR     school 4106120 2114   Harper SD 66 410612000758 3362 Harper Charter School   Regular School Yes Other KG 12 2018   k_12_total 91.0 0.0 14.0   0.0 0.0     0.0   4.0                               91 0 14   0 0     0   4                        
1190986 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2018   k_12_total 233.0 0.0 37.0   5.0 1.0     2.0   15.0                               233 0 37   5 1     2   15                        
1190987 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 06 08 2018   k_12_total 151.0 0.0 26.0   0.0 1.0     0.0   3.0                               151 0 26   0 1     0   3                        
1190988 OR     school 4106270 2201   Helix SD 1 410627001084 3364 Helix School   Regular School No Other KG 12 2018   k_12_total 155.0 0.0 6.0   2.0 3.0     1.0   17.0                               155 0 6   2 3     1   17                        
1190992 OR     school 4106300 2206   Hermiston SD 8   2206 Hermiston SD 8             2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1190998 OR     school   1975   High Desert ESD   240 Hope Academy             2018   k_12_total 5.0 0.0 1.0   0.0 0.0     0.0   0.0                               5 0 1   0 0     0   0                        
1191027 OR     school 4100023 2239   Hillsboro SD 1J 410002301200 1149 Reedville Elementary School   Regular School No Elementary KG 06 2018   k_12_total 40.0 0.0 203.0   1.0 8.0     0.0   5.0                               40 0 203   1 8     0   5                        
1191031 OR     school 4100023 2239   Hillsboro SD 1J 410002301175 1119 W L Henry Elementary School   Regular School No Elementary KG 06 2018   k_12_total 40.0 0.0 303.0   1.0 4.0     0.0   5.0                               40 0 303   1 4     0   5                        
1191035 OR     school 4106510 2024   Hood River County SD 410651000389 3372 Cascade Locks School   Regular School No Elementary KG 05 2018   k_12_total 52.0 0.0 14.0   0.0 0.0     0.0   3.0                               52 0 14   0 0     0   3                        
1191036 OR     school 4106510 2024   Hood River County SD   2024 Hood River County SD             2018   k_12_total 45.0 0.0 22.0   0.0 0.0     0.0   0.0                               45 0 22   0 0     0   0                        
1191040 OR     school 4106510 2024   Hood River County SD 410651000383 363 Mid Valley Elementary School   Regular School No Elementary KG 05 2018   k_12_total 97.0 0.0 398.0   2.0 1.0     0.0   13.0                               97 0 398   2 1     0   13                        
1191042 OR     school 4106510 2024   Hood River County SD   2300 The Next Door             2018   k_12_total 8.0 0.0 2.0   1.0 0.0     0.0   0.0                               8 0 2   1 0     0   0                        
1191045 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   k_12_total 73.0 0.0 10.0   1.0 6.0     0.0   2.0                               73 0 10   1 6     0   2                        
1191047 OR     school   2200   InterMountain ESD   4846 Lifeways Inc             2018   k_12_total 9.0 0.0 3.0   1.0 0.0     0.0   1.0                               9 0 3   1 0     0   1                        
1191048 OR     school 4100047 3997   Ione SD R2 410004700862 3363 Ione Community Charter School   Regular School Yes Other KG 12 2018   k_12_total 118.0 0.0 52.0   4.0 0.0     0.0   6.0                               118 0 52   4 0     0   6                        
1191050 OR     school 4106740 2053   Jefferson County SD 509J 410674001852 5359 Bridges Career and Technical High School   Alternative School No High 09 12 2018   k_12_total 25.0 0.0 23.0   68.0 0.0     1.0   0.0                               25 0 23   68 0     1   0                        
1191054 OR     school 4106740 2053   Jefferson County SD 509J 410674000451 430 Madras Primary School   Regular School No Elementary KG 05 2018   k_12_total 196.0 0.0 171.0   42.0 1.0     0.0   17.0                               196 0 171   42 1     0   17                        
1191056 OR     school 4106740 2053   Jefferson County SD 509J 410674000454 432 Warm Springs K-8 Academy   Regular School No Elementary KG 08 2018   k_12_total 7.0 0.0 46.0   595.0 0.0     1.0   15.0                               7 0 46   595 0     1   15                        
1191060 OR     school 4106750 1934   Jewell SD 8 410675000158 3352 Jewell School   Regular School No Other PK 12 2018   k_12_total 133.0 0.0 18.0   0.0 0.0     0.0   13.0                               133 0 18   0 0     0   13                        
1191064 OR     school 4106820 2107   Jordan Valley SD 3 410682000697 691 Jordan Valley Elementary School   Regular School No Elementary KG 06 2018   k_12_total 12.0 0.0 1.0   0.0 0.0     0.0   0.0                               12 0 1   0 0     0   0                        
1191065 OR     school 4106820 2107   Jordan Valley SD 3 410682000760 712 Jordan Valley High School   Regular School No High 07 12 2018   k_12_total 40.0 0.0 2.0   0.0 0.0     0.0   0.0                               40 0 2   0 0     0   0                        
1191066 OR     school 4106820 2107   Jordan Valley SD 3 410682001423 3132 Rockville Elementary School   Regular School No Elementary KG 08 2018   k_12_total 4.0 0.0 0.0   0.0 0.0     0.0   0.0                               4 0 0   0 0     0   0                        
1191067 OR     school 4106870 2219   Joseph SD 6 410687001142 1084 Imnaha Elementary School   Regular School No Elementary KG 08 2018   k_12_total 4.0 0.0 3.0   0.0 0.0     0.0   0.0                               4 0 3   0 0     0   0                        
1191068 OR     school 4106870 2219   Joseph SD 6 410687001145 1087 Joseph Charter School   Regular School Yes Other KG 12 2018   k_12_total 204.0 0.0 9.0   0.0 0.0     0.0   17.0                               204 0 9   0 0     0   17                        
1191073 OR     school 4106960 2109   Juntura SD 12 410696000747 700 Juntura Elementary School   Regular School No Elementary KG 08 2018   k_12_total 1.0 0.0 0.0   0.0 0.0     0.0   0.0                               1 0 0   0 0     0   0                        
1191074 OR     school 4107020 2057   Klamath County SD 410702001464 467 Bonanza Elementary School   Regular School No Elementary KG 06 2018   k_12_total 163.0 0.0 46.0   12.0 2.0     0.0   25.0                               163 0 46   12 2     0   25                        
1191075 OR     school 4107020 2057   Klamath County SD 410702001466 482 Bonanza Junior/Senior High School   Regular School No High 07 12 2018   k_12_total 145.0 0.0 45.0   8.0 0.0     0.0   22.0                               145 0 45   8 0     0   22                        
1191077 OR     school 4107020 2057   Klamath County SD 410702000492 468 Chiloquin Elementary School   Regular School No Elementary KG 06 2018   k_12_total 60.0 0.0 6.0   93.0 1.0     0.0   9.0                               60 0 6   93 1     0   9                        
1191078 OR     school 4107020 2057   Klamath County SD 410702000508 483 Chiloquin High School   Regular School No High 07 12 2018   k_12_total 54.0 0.0 7.0   68.0 1.0     0.0   16.0                               54 0 7   68 1     0   16                        
1191080 OR     school 4107020 2057   Klamath County SD 410702000495 470 Ferguson Elementary School   Regular School No Elementary KG 06 2018   k_12_total 345.0 0.0 77.0   20.0 2.0     1.0   42.0                               345 0 77   20 2     1   42                        
1191081 OR     school 4107020 2057   Klamath County SD 410702000496 471 Gearhart Elementary School   Regular School No Elementary KG 08 2018   k_12_total 6.0 0.0 2.0   0.0 1.0     0.0   4.0                               6 0 2   0 1     0   4                        
1191082 OR     school 4107020 2057   Klamath County SD 410702001465 472 Gilchrist Elementary School   Regular School No Elementary KG 06 2018   k_12_total 110.0 0.0 8.0   0.0 0.0     0.0   3.0                               110 0 8   0 0     0   3                        
1191087 OR     school 4107020 2057   Klamath County SD 410702000499 474 Keno Elementary School   Regular School No Elementary KG 06 2018   k_12_total 150.0 0.0 18.0   3.0 1.0     0.0   15.0                               150 0 18   3 1     0   15                        
1191088 OR     school 4107020 2057   Klamath County SD   2057 Klamath County SD             2018   k_12_total 137.0 0.0 21.0   5.0 1.0     0.0   15.0                               137 0 21   5 1     0   15                        
1191089 OR     school 4107020 2057   Klamath County SD 410702000511 486 Lost River High School   Regular School No High 07 12 2018   k_12_total 89.0 0.0 123.0   2.0 0.0     1.0   1.0                               89 0 123   2 0     1   1                        
1191090 OR     school 4107020 2057   Klamath County SD 410702000500 475 Malin Elementary School   Regular School No Elementary KG 06 2018   k_12_total 59.0 0.0 73.0   5.0 0.0     0.0   0.0                               59 0 73   5 0     0   0                        
1191094 OR     school 4107020 2057   Klamath County SD 410702001688 4581 Sage Community School   Regular School Yes Elementary KG 08 2018   k_12_total 52.0 0.0 4.0   6.0 0.0     0.0   1.0                               52 0 4   6 0     0   1                        
1191099 OR     school 4107080 2056   Klamath Falls City Schools   2056 Klamath Falls City Schools             2018   k_12_total 6.0 0.0 2.0   3.0 0.0     0.0   1.0                               6 0 2   3 0     0   1                        
1191100 OR     school 4107080 2056   Klamath Falls City Schools 410708001847 5355 Klamath Learning Center   Alternative School No Other 01 12 2018   k_12_total 46.0 0.0 9.0   5.0 0.0     1.0   4.0                               46 0 9   5 0     1   4                        
1191102 OR     school 4107080 2056   Klamath Falls City Schools   1257 Klamath Youth Development Center             2018   k_12_total 17.0 0.0 1.0   2.0 0.0     0.0   1.0                               17 0 1   2 0     0   1                        
1191108 OR     school 4100040 2262   Knappa SD 4 410004000179 169 Knappa High School   Regular School No High 09 12 2018   k_12_total 115.0 0.0 12.0   3.0 1.0     3.0   2.0                               115 0 12   3 1     3   2                        
1191111 OR     school 4107200 2212   La Grande SD 1 410720001128 1069 Island City Elementary School   Regular School No Elementary KG 05 2018   k_12_total 273.0 0.0 27.0   3.0 3.0     4.0   15.0                               273 0 27   3 3     4   15                        
1191114 OR     school 4107200 2212   La Grande SD 1   1067 Rising Stars Day Treatment             2018   k_12_total 10.0 0.0 0.0   0.0 0.0     0.0   0.0                               10 0 0   0 0     0   0                        
1191115 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1191116 OR     school 4107280 2059   Lake County SD 7 410728000689 491 Daly Middle School   Regular School No Middle 07 08 2018   k_12_total 82.0 0.0 18.0   4.0 0.0     0.0   4.0                               82 0 18   4 0     0   4                        
1191118 OR     school 4107280 2059   Lake County SD 7   2059 Lake County SD 7             2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1191119 OR     school 4107280 2059   Lake County SD 7 410728000519 492 Lakeview Senior High School   Regular School No High 09 12 2018   k_12_total 194.0 0.0 47.0   6.0 0.0     0.0   8.0                               194 0 47   6 0     0   8                        
1191120 OR     school 4107280 2059   Lake County SD 7 410728000514 489 Union Elementary School   Regular School No Elementary KG 06 2018   k_12_total 48.0 0.0 5.0   0.0 0.0     0.0   4.0                               48 0 5   0 0     0   4                        
1191133 OR     school   2064   Lane ESD   5299 Oregon State Hospital - Junction City Campus             2018   k_12_total 1.0 0.0 0.0   0.0 0.0     0.0   0.0                               1 0 0   0 0     0   0                        
1191134 OR     school 4107380 2101   Lebanon Community SD 9 410738000682 652 Cascades School   Regular School No Elementary KG 05 2018   k_12_total 266.0 0.0 24.0   2.0 1.0     2.0   26.0                               266 0 24   2 1     2   26                        
1191136 OR     school 4107380 2101   Lebanon Community SD 9 410738000696 658 Hamilton Creek School   Regular School No Elementary KG 08 2018   k_12_total 267.0 0.0 25.0   3.0 0.0     1.0   11.0                               267 0 25   3 0     1   11                        
1191138 OR     school 4107380 2101   Lebanon Community SD 9   2101 Lebanon Community SD 9             2018   k_12_total 57.0 0.0 3.0   0.0 0.0     1.0   3.0                               57 0 3   0 0     1   3                        
1191140 OR     school 4107380 2101   Lebanon Community SD 9 410738004185 3504 Pioneer School   Regular School No Elementary KG 06 2018   k_12_total 306.0 0.0 31.0   6.0 0.0     0.0   24.0                               306 0 31   6 0     0   24                        
1191141 OR     school 4107380 2101   Lebanon Community SD 9 410738004184 3503 Riverview School   Regular School No Elementary KG 05 2018   k_12_total 308.0 0.0 52.0   4.0 6.0     0.0   34.0                               308 0 52   4 6     0   34                        
1191145 OR     school 4107500 2097   Lincoln County SD 410750001582 3361 Eddyville Charter School   Regular School Yes Other KG 12 2018   k_12_total 158.0 0.0 15.0   8.0 0.0     0.0   14.0                               158 0 15   8 0     0   14                        

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