enrollments

Data source: Big Local News · About: Big Local

82,026 rows where state = "OR" sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
897804 897804 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   kindergarten                                                   0                                             0
897809 897809 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   kindergarten                                                   0                                             0
899263 899263 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_1                                                   0                                             0
899268 899268 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_1                                                   0                                             0
900722 900722 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_2                                                   0                                             0
900727 900727 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_2                                                   0                                             0
902181 902181 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_3                                                   0                                             0
902186 902186 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_3                                                   0                                             0
903640 903640 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_4                                                   0                                             0
903645 903645 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_4                                                   0                                             0
905099 905099 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_5                                                   0                                             0
905104 905104 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_5                                                   0                                             0
906558 906558 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_6                                                   0                                             0
906563 906563 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_6                                                   0                                             0
908017 908017 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_7                                                   0                                             0
908022 908022 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_7                                                   0                                             0
909476 909476 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_8                                                   0                                             0
909481 909481 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_8                                                   0                                             0
910935 910935 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_9                                                   38                                             38
910940 910940 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_9                                                   37                                             37
912394 912394 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_10                                                   52                                             52
912399 912399 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_10                                                   46                                             46
913853 913853 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_11                                                   23                                             23
913858 913858 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_11                                                   34                                             34
915312 915312 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   grade_12                                                   0                                             0
915317 915317 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   grade_12                                                   0                                             0
916771 916771 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001871 5428 Realms High School   Regular School No Secondary 09 11 2020   k_12_total 100 0 11   0 0     0   2                               100 0 11   0 0     0   2                        
916776 916776 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001866 5429 Skyline High School   Regular School No Secondary 09 11 2020   k_12_total 99 1 9   3 0     0   5                               99 1 9   3 0     0   5                        
1686186 1686186 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   0.0                                             0
1686189 1686189 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   7.0                                             7
1686211 1686211 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   kindergarten                                                   60.0                                             60
1686227 1686227 OR     school 4101920 2243   Beaverton SD 48J 410192000213 1304 Arts and Communication Magnet Academy   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1686247 1686247 OR     school 4101920 2243   Beaverton SD 48J 410192001745 4638 Health & Science School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1686251 1686251 OR     school 4101920 2243   Beaverton SD 48J 410192001647 4474 International School of Beaverton   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1686337 1686337 OR     school 4102160 2095   Blachly SD 90 410216000641 3401 Triangle Lake Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   18.0                                             18
1686342 1686342 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   kindergarten                                                   3.0                                             3
1686343 1686343 OR     school 4102580 2046   Butte Falls SD 91 410258000426 406 Butte Falls Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   8.0                                             8
1686344 1686344 OR     school 4102610 1995   Camas Valley SD 21J 410261000315 3400 Camas Valley School   Regular School Yes Other PK 12 2017   kindergarten                                                   18.0                                             18
1686414 1686414 OR     school 4103660 1965   Coos Bay SD 9 410366001602 4079 Resource Link Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   0.0                                             0
1686420 1686420 OR     school 4103390 1964   Coquille SD 8 410339001804 4857 Winter Lakes School   Alternative School No Other 03 12 2017   kindergarten                                                   0.0                                             0
1686421 1686421 OR     school 4103420 2186   Corbett SD 39 410342001729 4592 Corbett School   Regular School No Other KG 12 2017   kindergarten                                                   80.0                                             80
1686437 1686437 OR     school 4103540 2216   Cove SD 15 410354001139 3434 Cove Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   17.0                                             17
1686489 1686489 OR     school 4104020 2011   Dayville SD 16J 410402000358 3353 Dayville School   Regular School No Other PK 12 2017   kindergarten                                                   3.0                                             3
1686492 1686492 OR     school 4103960 1993   Douglas County SD 15 410396000308 3348 Days Creek Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   13.0                                             13
1686509 1686509 OR     school 4104410 2229   Dufur SD 29 410441001162 3402 Dufur School   Regular School No Other KG 12 2017   kindergarten                                                   20.0                                             20
1686510 1686510 OR     school 4104500 2043   Eagle Point SD 9 410450001831 5251 Crater Lake Charter Academy   Regular School Yes Other KG 12 2017   kindergarten                                                   12.0                                             12
1686521 1686521 OR     school 4104530 2203   Echo SD 5 410453001089 3433 Echo School   Regular School No Other PK 12 2017   kindergarten                                                   23.0                                             23
1686524 1686524 OR     school 4104620 1998   Elkton SD 34 410462000322 302 Elkton Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   13.0                                             13
1686535 1686535 OR     school 4104700 1930   Estacada SD 108 410470001766 4670 Summit Learning Charter   Regular School Yes Other KG 12 2017   kindergarten                                                   39.0                                             39
1686606 1686606 OR     school 4105250 2248   Fossil SD 21J 410525001375 1205 Fossil Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   49.0                                             49
1686608 1686608 OR     school 4105310 2020   Frenchglen SD 16 410531001756 4702 Silvies River Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   21.0                                             21
1686615 1686615 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1686678 1686678 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600001787 4740 Metro East Web Academy   Regular School Yes Other 06 12 2017   kindergarten                                                   0.0                                             0
1686686 1686686 OR     school 4102490 2014   Harney County SD 3 410249001520 3740 Burns Alternative School   Alternative School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1686693 1686693 OR     school 4106120 2114   Harper SD 66 410612000758 3362 Harper Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   11.0                                             11
1686697 1686697 OR     school 4106270 2201   Helix SD 1 410627001084 3364 Helix School   Regular School No Other KG 12 2017   kindergarten                                                   6.0                                             6
1686720 1686720 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2017   kindergarten                                                   1.0                                             1
1686755 1686755 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   kindergarten                                                   4.0                                             4
1686756 1686756 OR     school 4106630 2215   Imbler SD 11 410663001137 1079 Imbler Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   23.0                                             23
1686758 1686758 OR     school 4100047 3997   Ione SD R2 410004700862 3363 Ione Community Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   10.0                                             10
1686770 1686770 OR     school 4106750 1934   Jewell SD 8 410675000158 3352 Jewell School   Regular School No Other PK 12 2017   kindergarten                                                   14.0                                             14
1686778 1686778 OR     school 4106870 2219   Joseph SD 6 410687001145 1087 Joseph Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   20.0                                             20
1686812 1686812 OR     school 4107080 2056   Klamath Falls City Schools 410708001847 5355 Klamath Learning Center   Alternative School No Other 01 12 2017   kindergarten                                                   0.0                                             0
1686856 1686856 OR     school 4107500 2097   Lincoln County SD 410750001582 3361 Eddyville Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   16.0                                             16
1686877 1686877 OR     school 4107530 2012   Long Creek SD 17 410753000360 3366 Long Creek School   Regular School No Other PK 12 2017   kindergarten                                                   1.0                                             1
1686878 1686878 OR     school 4107590 2092   Lowell SD 71 410759001846 5349 Bridge Charter Academy   Regular School Yes Other KG 10 2017   kindergarten                                                   16.0                                             16
1686913 1686913 OR     school 4108040 2048   Medford SD 549C 410804001796 4821 Logos Public Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   53.0                                             53
1686932 1686932 OR     school 4108280 2249   Mitchell SD 55 410828001259 3404 Mitchell School   Regular School No Other KG 12 2017   kindergarten                                                   5.0                                             5
1686940 1686940 OR     school 4108310 1925   Molalla River SD 35 410831001800 4818 Renaissance Public Academy   Regular School Yes Other 04 12 2017   kindergarten                                                   0.0                                             0
1686944 1686944 OR     school 4108460 2010   Monument SD 8 410846000356 3350 Monument School   Regular School No Other KG 12 2017   kindergarten                                                   5.0                                             5
1686957 1686957 OR     school 4180180 2148   Multnomah ESD 418018001510 3168 Arata Creek School   Alternative School No Other KG 12 2017   kindergarten                                                   0.0                                             0
1686959 1686959 OR     school 4180180 2148   Multnomah ESD 418018000230 1298 Helensview High School   Alternative School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1686992 1686992 OR     school 4108820 1966   North Bend SD 13 410882001751 4690 Oregon Virtual Academy   Regular School Yes Other KG 12 2017   kindergarten                                                   81.0                                             81
1686999 1686999 OR     school 4108830 1924   North Clackamas SD 12 410883001543 4223 Clackamas Web Academy   Regular School Yes Other 01 12 2017   kindergarten                                                   0.0                                             0
1687026 1687026 OR     school 4111400 2061   North Lake SD 14 411140001381 1289 North Lake School   Regular School No Other KG 12 2017   kindergarten                                                   12.0                                             12
1687031 1687031 OR     school 4108940 2214   North Powder SD 8J 410894001135 3365 North Powder Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   12.0                                             12
1687072 1687072 OR     school 4100043 3477   ODE YCEP District 410004301404 2258 Monroe School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1687073 1687073 OR     school 4100043 3477   ODE YCEP District 410004301406 2260 New Bridge High School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1687077 1687077 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1687078 1687078 OR     school 4100043 3477   ODE YCEP District 410004301476 2385 South Jetty High School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1687079 1687079 OR     school 4100043 3477   ODE YCEP District 410004301744 4609 Three Lakes High School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1687080 1687080 OR     school 4100043 3477   ODE YCEP District 410004301740 4588 Trask River High School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1687081 1687081 OR     school 4100043 3477   ODE YCEP District 410004300494 1828 William P Lord High School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1687090 1687090 OR     school 4109330 1928   Oregon City SD 62 410933001725 4585 Alliance Charter Academy   Regular School Yes Other KG 12 2017   kindergarten                                                   14.0                                             14
1687109 1687109 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 09 2017   kindergarten                                                   26.0                                             26
1687110 1687110 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   kindergarten                                                   1.0                                             1
1687118 1687118 OR     school 4110890 1926   Oregon Trail SD 46 411089001799 4820 Oregon Trail Academy   Regular School Yes Other KG 10 2017   kindergarten                                                   27.0                                             27
1687124 1687124 OR     school 4109430 2060   Paisley SD 11 410943000521 3360 Paisley School   Regular School Yes Other KG 12 2017   kindergarten                                                   18.0                                             18
1687143 1687143 OR     school 4109530 2192   Perrydale SD 21 410953001060 3378 Perrydale School   Regular School No Other KG 12 2017   kindergarten                                                   26.0                                             26
1687146 1687146 OR     school 4109600 1900   Philomath SD 17J 410960000021 3440 Kings Valley Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   14.0                                             14
1687150 1687150 OR     school 4109630 2039   Phoenix-Talent SD 4 410963001489 3247 Armadillo Technical Institute   Regular School Yes Other 06 12 2017   kindergarten                                                   0.0                                             0
1687160 1687160 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   16.0                                             16
1687164 1687164 OR     school 4109870 2081   Pleasant Hill SD 1 410987000529 502 Pleasant Hill High School   Regular School No Other 06 12 2017   kindergarten                                                   0.0                                             0
1687227 1687227 OR     school 4110040 2180   Portland SD 1J 411004000967 916 Metropolitan Learning Center   Alternative School No Other KG 12 2017   kindergarten                                                   24.0                                             24
1687264 1687264 OR     school 4110040 2180   Portland SD 1J 411004004190 3616 Trillium   Regular School Yes Other KG 12 2017   kindergarten                                                   30.0                                             30
1687279 1687279 OR     school 4110110 2009   Prairie City SD 4 411011000352 3349 Prairie City School   Regular School No Other KG 12 2017   kindergarten                                                   12.0                                             12
1687280 1687280 OR     school 4110200 2045   Prospect SD 59 411020000111 3356 Prospect Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   15.0                                             15
1687291 1687291 OR     school 4110350 1977   Redmond SD 2J 411035001785 4729 Redmond Proficiency Academy   Regular School Yes Other 06 12 2017   kindergarten                                                   0.0                                             0
1687325 1687325 OR     school 4110680 2044   Rogue River SD 35 411068001811 4856 Rivers Edge Academy Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   12.0                                             12
1687395 1687395 OR     school 4108100 2104   Santiam Canyon SD 129J 410810001680 4399 Oregon Connections Academy   Regular School Yes Other KG 12 2017   kindergarten                                                   104.0                                             104

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