Data source: Big Local News · About: Big Local

20,594 rows where state = "OR" and year = 2021 sorted by ccd_school_lvl descending

View and edit SQL

grade

year

  • 2021 · 20,594
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
637660 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   34                                             34
637664 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other 01 12 2021   kindergarten                                                   0                                             0
637667 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   5                                             5
637691 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   145                                             145
637726 OR     school 4101920 2243   Beaverton SD 48J 410192001894 5506 FLEX Online School   Regular School No Other KG 12 2021   kindergarten                                                   73                                             73
637822 OR     school 4102160 2095   Blachly SD 90 410216000641 3401 Triangle Lake Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   15                                             15
637827 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   kindergarten                                                   2                                             2
637828 OR     school 4102580 2046   Butte Falls SD 91 410258000426 406 Butte Falls Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   27                                             27
637829 OR     school 4102610 1995   Camas Valley SD 21J 410261000315 3400 Camas Valley School   Regular School Yes Other PK 12 2021   kindergarten                                                   15                                             15
637862 OR     school 4102910 2105   Central Linn SD 552 410291001890 5605 Central Linn Online Academy   Regular School No Other KG 12 2021   kindergarten                                                   6                                             6
637896 OR     school 4103660 1965   Coos Bay SD 9 410366001602 4079 Resource Link Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   1                                             1
637904 OR     school 4103420 2186   Corbett SD 39 410342001729 4592 Corbett School   Regular School Yes Other KG 12 2021   kindergarten                                                   86                                             86
637921 OR     school 4103540 2216   Cove SD 15 410354001139 3434 Cove Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   15                                             15
637971 OR     school 4104020 2011   Dayville SD 16J 410402000358 3353 Dayville School   Regular School No Other PK 12 2021   kindergarten                                                   2                                             2
637974 OR     school 4103960 1993   Douglas County SD 15 410396000308 3348 Days Creek Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   10                                             10
637992 OR     school 4104410 2229   Dufur SD 29 410441001162 3402 Dufur School   Regular School No Other KG 12 2021   kindergarten                                                   26                                             26
637993 OR     school 4104500 2043   Eagle Point SD 9 410450001831 5251 Crater Lake Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   11                                             11
638003 OR     school 4104500 2043   Eagle Point SD 9 410450001681 4378 URCEO-Upper Rogue Center for Educational Opportunities   Alternative School No Other KG 12 2021   kindergarten                                                   10                                             10
638005 OR     school 4104530 2203   Echo SD 5 410453001089 3433 Echo School   Regular School No Other PK 12 2021   kindergarten                                                   22                                             22
638008 OR     school 4104620 1998   Elkton SD 34 410462000322 302 Elkton Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   13                                             13
638017 OR     school 4104700 1930   Estacada SD 108 410470001766 4670 Summit Learning Charter   Regular School Yes Other KG 12 2021   kindergarten                                                   71                                             71
638091 OR     school 4105250 2248   Fossil SD 21J 410525001375 1205 Fossil Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   146                                             146
638097 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   34                                             34
638160 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001787 4740 Metro East Web Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   20                                             20
638173 OR     school 4103600 2015   Harney County SD 4 410360001870 5446 Oregon Family School   Regular School Yes Other KG 12 2021   kindergarten                                                   54                                             54
638175 OR     school 4103630 2023   Harney County Union High SD 1J 410363001756 4702 Silvies River Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   117                                             117
638176 OR     school 4106120 2114   Harper SD 66 410612000758 3362 Harper Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   12                                             12
638180 OR     school 4106270 2201   Helix SD 1 410627001084 3364 Helix School   Regular School No Other KG 12 2021   kindergarten                                                   14                                             14
638202 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2021   kindergarten                                                   68                                             68
638237 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   kindergarten                                                   6                                             6
638238 OR     school 4106630 2215   Imbler SD 11 410663001137 1079 Imbler Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   13                                             13
638239 OR     school 4100036 2200   InterMountain ESD 410003601892 5512 InterMountain Virtual Learning Academy   Regular School No Other KG 12 2021   kindergarten                                                   32                                             32
638241 OR     school 4100047 3997   Ione SD R2 410004700862 3363 Ione Community Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   10                                             10
638253 OR     school 4106750 1934   Jewell SD 8 410675000158 3352 Jewell School   Regular School No Other PK 12 2021   kindergarten                                                   6                                             6
638261 OR     school 4106870 2219   Joseph SD 6 410687001145 1087 Joseph Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   14                                             14
638298 OR     school 4107080 2056   Klamath Falls City Schools 410708001847 5355 Klamath Learning Center   Alternative School No Other KG 12 2021   kindergarten                                                   25                                             25
638343 OR     school 4107500 2097   Lincoln County SD 410750001582 3361 Eddyville Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   11                                             11
638350 OR     school 4107500 2097   Lincoln County SD 410750001590 4038 Siletz Valley Schools   Regular School Yes Other KG 12 2021   kindergarten                                                   12                                             12
638363 OR     school 4107530 2012   Long Creek SD 17 410753000360 3366 Long Creek School   Regular School No Other PK 12 2021   kindergarten                                                   2                                             2
638364 OR     school 4107590 2092   Lowell SD 71 410759001846 5349 Bridge Charter Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   76                                             76
638374 OR     school 4107740 2094   Marcola SD 79J 410774001872 5444 TEACH-NW   Regular School Yes Other KG 12 2021   kindergarten                                                   32                                             32
638375 OR     school 4107980 2090   McKenzie SD 68 410798000629 594 McKenzie River Community School   Regular School Yes Other KG 12 2021   kindergarten                                                   13                                             13
638396 OR     school 4108040 2048   Medford SD 549C 410804001796 4821 Logos Public Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   61                                             61
638418 OR     school 4108280 2249   Mitchell SD 55 410828001259 3404 Mitchell School   Regular School No Other KG 12 2021   kindergarten                                                   1                                             1
638426 OR     school 4108310 1925   Molalla River SD 35 410831001800 4818 Renaissance Public Academy   Regular School Yes Other 03 12 2021   kindergarten                                                   0                                             0
638430 OR     school 4108460 2010   Monument SD 8 410846000356 3350 Monument School   Regular School No Other KG 12 2021   kindergarten                                                   1                                             1
638436 OR     school 4108520 2147   Morrow SD 1 410852001865 5433 Morrow Education Center   Alternative School No Other KG 12 2021   kindergarten                                                   8                                             8
638452 OR     school 4180180 2148   Multnomah ESD 418018001510 3168 The Creeks   Alternative School No Other KG 12 2021   kindergarten                                                   0                                             0
638477 OR     school 4108820 1966   North Bend SD 13 410882001751 4690 Oregon Virtual Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   205                                             205
638485 OR     school 4108830 1924   North Clackamas SD 12 410883001543 4223 Clackamas Web Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   21                                             21
638512 OR     school 4111400 2061   North Lake SD 14 411140001381 1289 North Lake School   Regular School No Other KG 12 2021   kindergarten                                                   22                                             22
638517 OR     school 4108940 2214   North Powder SD 8J 410894001135 3365 North Powder Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   12                                             12
638519 OR     school 4100020 2143   North Santiam SD 29J 410002001891 5620 North Santiam Options Academy   Alternative School No Other KG 12 2021   kindergarten                                                   11                                             11
638574 OR     school 4109330 1928   Oregon City SD 62 410933001725 4585 Alliance Charter Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   16                                             16
638590 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 12 2021   kindergarten                                                   27                                             27
638591 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   kindergarten                                                   0                                             0
638599 OR     school 4110890 1926   Oregon Trail SD 46 411089001799 4820 Oregon Trail Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   28                                             28
638605 OR     school 4109430 2060   Paisley SD 11 410943000521 3360 Paisley School   Regular School Yes Other KG 12 2021   kindergarten                                                   14                                             14
638622 OR     school 4109530 2192   Perrydale SD 21 410953001060 3378 Perrydale School   Regular School No Other KG 12 2021   kindergarten                                                   18                                             18
638625 OR     school 4109600 1900   Philomath SD 17J 410960000021 3440 Kings Valley Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   19                                             19
638626 OR     school 4109600 1900   Philomath SD 17J 410960001880 5492 Philomath Academy   Alternative School No Other KG 12 2021   kindergarten                                                   3                                             3
638640 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   12                                             12
638710 OR     school 4110040 2180   Portland SD 1J 411004000967 916 Metropolitan Learning Center   Alternative School No Other KG 12 2021   kindergarten                                                   23                                             23
638761 OR     school 4110110 2009   Prairie City SD 4 411011000352 3349 Prairie City School   Regular School No Other KG 12 2021   kindergarten                                                   10                                             10
638762 OR     school 4110200 2045   Prospect SD 59 411020000111 3356 Prospect Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   14                                             14
638810 OR     school 4110680 2044   Rogue River SD 35 411068001811 4856 Rivers Edge Academy Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   15                                             15
638813 OR     school 4110680 2044   Rogue River SD 35 411068001863 5443 South Valley Academy   Regular School No Other 03 12 2021   kindergarten                                                   0                                             0
638881 OR     school 4108100 2104   Santiam Canyon SD 129J 410810001680 4399 Oregon Charter Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   155                                             155
638898 OR     school 4111040 2103   Scio SD 95 411104001876 5457 Willamette Connections Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   176                                             176
638906 OR     school 4111220 2257   Sheridan SD 48J 411122001803 4833 Sheridan AllPrep Academy   Regular School Yes Other KG 12 2021   kindergarten                                                   8                                             8
638908 OR     school 4111220 2257   Sheridan SD 48J 411122001450 2728 Sheridan Japanese School   Regular School Yes Other 04 12 2021   kindergarten                                                   0                                             0
638909 OR     school 4111250 2195   Sherman County SD 411125001068 1010 Sherman County School   Regular School No Other KG 12 2021   kindergarten                                                   15                                             15
638939 OR     school 4111580 2087   South Lane SD 45J3 411158001727 4555 Academy for Character Education   Regular School Yes Other KG 12 2021   kindergarten                                                   25                                             25
638964 OR     school 4111640 2247   Spray SD 1 411164001255 3403 Spray School   Regular School No Other KG 12 2021   kindergarten                                                   4                                             4
639010 OR     school 4111940 2003   Sutherlin SD 130 411194001849 5357 Sutherlin Valley Online Academy   Regular School No Other 03 12 2021   kindergarten                                                   0                                             0
639061 OR     school 4112540 2210   Ukiah SD 80R 411254001122 3432 Ukiah School   Regular School No Other KG 12 2021   kindergarten                                                   1                                             1
639131 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   36                                             36
639135 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other 01 12 2021   grade_1                                                   0                                             0
639138 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   10                                             10
639162 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   grade_1                                                   148                                             148
639197 OR     school 4101920 2243   Beaverton SD 48J 410192001894 5506 FLEX Online School   Regular School No Other KG 12 2021   grade_1                                                   104                                             104
639293 OR     school 4102160 2095   Blachly SD 90 410216000641 3401 Triangle Lake Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   15                                             15
639298 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_1                                                   2                                             2
639299 OR     school 4102580 2046   Butte Falls SD 91 410258000426 406 Butte Falls Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   13                                             13
639300 OR     school 4102610 1995   Camas Valley SD 21J 410261000315 3400 Camas Valley School   Regular School Yes Other PK 12 2021   grade_1                                                   18                                             18
639333 OR     school 4102910 2105   Central Linn SD 552 410291001890 5605 Central Linn Online Academy   Regular School No Other KG 12 2021   grade_1                                                   14                                             14
639367 OR     school 4103660 1965   Coos Bay SD 9 410366001602 4079 Resource Link Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   1                                             1
639375 OR     school 4103420 2186   Corbett SD 39 410342001729 4592 Corbett School   Regular School Yes Other KG 12 2021   grade_1                                                   63                                             63
639392 OR     school 4103540 2216   Cove SD 15 410354001139 3434 Cove Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   21                                             21
639442 OR     school 4104020 2011   Dayville SD 16J 410402000358 3353 Dayville School   Regular School No Other PK 12 2021   grade_1                                                   7                                             7
639445 OR     school 4103960 1993   Douglas County SD 15 410396000308 3348 Days Creek Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   10                                             10
639463 OR     school 4104410 2229   Dufur SD 29 410441001162 3402 Dufur School   Regular School No Other KG 12 2021   grade_1                                                   31                                             31
639464 OR     school 4104500 2043   Eagle Point SD 9 410450001831 5251 Crater Lake Academy   Regular School Yes Other KG 12 2021   grade_1                                                   13                                             13
639474 OR     school 4104500 2043   Eagle Point SD 9 410450001681 4378 URCEO-Upper Rogue Center for Educational Opportunities   Alternative School No Other KG 12 2021   grade_1                                                   10                                             10
639476 OR     school 4104530 2203   Echo SD 5 410453001089 3433 Echo School   Regular School No Other PK 12 2021   grade_1                                                   23                                             23
639479 OR     school 4104620 1998   Elkton SD 34 410462000322 302 Elkton Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   14                                             14
639488 OR     school 4104700 1930   Estacada SD 108 410470001766 4670 Summit Learning Charter   Regular School Yes Other KG 12 2021   grade_1                                                   75                                             75
639562 OR     school 4105250 2248   Fossil SD 21J 410525001375 1205 Fossil Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   142                                             142
639568 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Other KG 12 2021   grade_1                                                   41                                             41
639631 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001787 4740 Metro East Web Academy   Regular School Yes Other KG 12 2021   grade_1                                                   18                                             18

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