Data source: Big Local News · About: Big Local

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

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
1171606 OR     school 4101920 2243   Beaverton SD 48J 410192000554 1320 Westview High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171607 OR     school 4101920 2243   Beaverton SD 48J 410192001238 1185 Whitford Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171608 OR     school 4101920 2243   Beaverton SD 48J 410192001232 1179 William Walker Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   73.0                                             73
1171609 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000607 1324 Amity Creek Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   25.0                                             25
1171610 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000258 241 Bear Creek Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   90.0                                             90
1171611 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   2916 Bend COIC Dropout Re-engagement Program             2018   kindergarten                                                   0.0                                             0
1171612 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001845 5309 Bend International School   Regular School Yes Elementary KG 08 2018   kindergarten                                                   20.0                                             20
1171613 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000270 251 Bend Senior High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171614 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   1976 Bend-LaPine Administrative SD 1             2018   kindergarten                                                   2.0                                             2
1171615 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001290 250 Buckingham Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   91.0                                             91
1171616 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000259 242 Cascade Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171617 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001860 5384 Desert Sky Montessori   Regular School Yes Elementary KG 03 2018   kindergarten                                                   42.0                                             42
1171618 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000245 1308 Elk Meadow Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   84.0                                             84
1171619 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001603 4129 Ensworth Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   29.0                                             29
1171620 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000263 1309 High Desert Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171621 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001487 3218 High Lakes Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   76.0                                             76
1171622 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001438 3219 Highland School at Kenwood Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   66.0                                             66
1171623 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   4290 J Bar J Learning Centers - Boys Ranch Campus             2018   kindergarten                                                   0.0                                             0
1171624 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   1448 J Bar J Learning Centers - Sisters Academy Campus             2018   kindergarten                                                   0.0                                             0
1171625 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000265 246 Juniper Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   72.0                                             72
1171626 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   4262 La Pine COIC Dropout Re-engagement Program             2018   kindergarten                                                   0.0                                             0
1171627 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000262 245 LaPine Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   50.0                                             50
1171628 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000264 1310 LaPine Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171629 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000272 253 LaPine Senior High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171630 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000546 1317 Lava Ridge Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   95.0                                             95
1171631 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000688 1338 Marshall High School   Alternative School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171632 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000271 252 Mountain View Senior High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171633 OR     school 4101980 1976   Bend-LaPine Administrative SD 1   3662 Oregon Youth Challenge             2018   kindergarten                                                   0.0                                             0
1171634 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001839 5292 Pacific Crest Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171635 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000268 249 Pilot Butte Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171636 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001576 3947 Pine Ridge Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   74.0                                             74
1171637 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001747 4646 Ponderosa Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   93.0                                             93
1171638 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198000266 247 R E Jewell Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   73.0                                             73
1171639 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001436 3448 REALMS (Rimrock Expeditionary Alternative Learning Middle School)   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171640 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001794 4793 Rosland Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   48.0                                             48
1171641 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001844 5293 Silver Rail Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   73.0                                             73
1171642 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001488 3217 Sky View Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171643 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001451 3216 Summit High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171644 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001350 1266 Three Rivers Elementary School   Regular School No Elementary KG 08 2018   kindergarten                                                   43.0                                             43
1171645 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 2018   kindergarten                                                   27.0                                             27
1171646 OR     school 4101980 1976   Bend-LaPine Administrative SD 1 410198001758 4680 William E Miller Elementary   Regular School No Elementary KG 05 2018   kindergarten                                                   77.0                                             77
1171647 OR     school 4102040 2088   Bethel SD 52   2088 Bethel SD 52             2018   kindergarten                                                   0.0                                             0
1171648 OR     school 4102040 2088   Bethel SD 52   4717 Bridgeway House             2018   kindergarten                                                   0.0                                             0
1171649 OR     school 4102040 2088   Bethel SD 52 410204000621 581 Cascade Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171650 OR     school 4102040 2088   Bethel SD 52 410204000616 582 Clear Lake Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   36.0                                             36
1171651 OR     school 4102040 2088   Bethel SD 52 410204000617 583 Danebo Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   58.0                                             58
1171652 OR     school 4102040 2088   Bethel SD 52 410204000618 584 Fairfield Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   57.0                                             57
1171653 OR     school 4102040 2088   Bethel SD 52 410204000619 585 Irving Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   47.0                                             47
1171654 OR     school 4102040 2088   Bethel SD 52   1792 Jasper Mountain Center             2018   kindergarten                                                   0.0                                             0
1171655 OR     school 4102040 2088   Bethel SD 52 410204004178 3566 Kalapuya High School   Alternative School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171656 OR     school 4102040 2088   Bethel SD 52   3545 Looking Glass Center Point School             2018   kindergarten                                                   0.0                                             0
1171657 OR     school 4102040 2088   Bethel SD 52   1532 Looking Glass Riverfront School & Career Center             2018   kindergarten                                                   0.0                                             0
1171658 OR     school 4102040 2088   Bethel SD 52 410204000620 586 Malabon Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   66.0                                             66
1171659 OR     school 4102040 2088   Bethel SD 52 410204001391 2264 Meadow View School   Regular School No Elementary KG 08 2018   kindergarten                                                   70.0                                             70
1171660 OR     school 4102040 2088   Bethel SD 52   3760 Pathways Girls Program             2018   kindergarten                                                   0.0                                             0
1171661 OR     school 4102040 2088   Bethel SD 52 410204004179 3567 Prairie Mountain School   Regular School No Elementary KG 08 2018   kindergarten                                                   73.0                                             73
1171662 OR     school 4102040 2088   Bethel SD 52   1789 SAFE Center School             2018   kindergarten                                                   0.0                                             0
1171663 OR     school 4102040 2088   Bethel SD 52 410204000622 587 Shasta Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171664 OR     school 4102040 2088   Bethel SD 52   1545 Wellsprings Friends School             2018   kindergarten                                                   0.0                                             0
1171665 OR     school 4102040 2088   Bethel SD 52 410204000623 588 Willamette High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171666 OR     school 4102160 2095   Blachly SD 90   2095 Blachly SD 90             2018   kindergarten                                                   0.0                                             0
1171667 OR     school 4102160 2095   Blachly SD 90 410216000641 3401 Triangle Lake Charter School   Regular School Yes Other KG 12 2018   kindergarten                                                   17.0                                             17
1171668 OR     school 4102190 2052   Black Butte SD 41 410219000449 428 Black Butte Elementary School   Regular School No Elementary KG 08 2018   kindergarten                                                   2.0                                             2
1171669 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000253 235 Azalea Middle School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171670 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000255 237 Brookings-Harbor High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171671 OR     school 4102310 1974   Brookings-Harbor SD 17C 410231000254 236 Kalmiopsis Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   123.0                                             123
1171672 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   kindergarten                                                   3.0                                             3
1171673 OR     school 4102580 2046   Butte Falls SD 91 410258000426 406 Butte Falls Charter School   Regular School Yes Other KG 12 2018   kindergarten                                                   12.0                                             12
1171674 OR     school 4102610 1995   Camas Valley SD 21J 410261000315 3400 Camas Valley School   Regular School Yes Other PK 12 2018   kindergarten                                                   16.0                                             16
1171675 OR     school 4102640 1929   Canby SD 86 410264001651 4434 Baker Prairie Middle School   Regular School No Middle 07 08 2018   kindergarten                                                   0.0                                             0
1171676 OR     school 4102640 1929   Canby SD 86 410264000148 140 Canby High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171677 OR     school 4102640 1929   Canby SD 86   1929 Canby SD 86             2018   kindergarten                                                   2.0                                             2
1171678 OR     school 4102640 1929   Canby SD 86 410264000100 92 Carus School   Regular School No Elementary KG 06 2018   kindergarten                                                   62.0                                             62
1171679 OR     school 4102640 1929   Canby SD 86 410264000165 1307 Cecile Trost Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   66.0                                             66
1171680 OR     school 4102640 1929   Canby SD 86 410264000132 124 Howard Eccles Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   71.0                                             71
1171681 OR     school 4102640 1929   Canby SD 86 410264000135 127 Ninety-One School   Regular School No Elementary KG 08 2018   kindergarten                                                   61.0                                             61
1171682 OR     school 4102640 1929   Canby SD 86 410264001659 4435 Philander Lee Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   50.0                                             50
1171683 OR     school 4102640 1929   Canby SD 86 410264000130 122 William Knight Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   45.0                                             45
1171684 OR     school 4102780 2139   Cascade SD 5 410278000767 719 Aumsville Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   74.0                                             74
1171685 OR     school 4102780 2139   Cascade SD 5 410278000855 810 Cascade Junior High School   Regular School No Middle 06 08 2018   kindergarten                                                   0.0                                             0
1171686 OR     school 4102780 2139   Cascade SD 5 410278001854 5380 Cascade Opportunity Center   Alternative School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171687 OR     school 4102780 2139   Cascade SD 5 410278000856 811 Cascade Senior High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171688 OR     school 4102780 2139   Cascade SD 5 410278000851 806 Cloverdale Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   23.0                                             23
1171689 OR     school 4102780 2139   Cascade SD 5 410278000835 790 Turner Elementary School   Regular School No Elementary KG 05 2018   kindergarten                                                   53.0                                             53
1171690 OR     school 4102800 2185   Centennial SD 28J 410280001574 3649 Butler Creek Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   74.0                                             74
1171691 OR     school 4102800 2185   Centennial SD 28J 410280001020 967 Centennial High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171692 OR     school 4102800 2185   Centennial SD 28J 410280001013 960 Centennial Middle School   Regular School No Middle 07 08 2018   kindergarten                                                   0.0                                             0
1171693 OR     school 4102800 2185   Centennial SD 28J 410280001221 1367 Centennial Park School   Alternative School No High 07 12 2018   kindergarten                                                   0.0                                             0
1171694 OR     school 4102800 2185   Centennial SD 28J   2185 Centennial SD 28J             2018   kindergarten                                                   0.0                                             0
1171695 OR     school 4102800 2185   Centennial SD 28J 410280001012 959 Meadows Elementary   Regular School No Elementary KG 06 2018   kindergarten                                                   53.0                                             53
1171696 OR     school 4102800 2185   Centennial SD 28J   2504 Mt Hood Community College             2018   kindergarten                                                   0.0                                             0
1171697 OR     school 4102800 2185   Centennial SD 28J 410280001015 962 Oliver Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   43.0                                             43
1171698 OR     school 4102800 2185   Centennial SD 28J   5268 Open School East             2018   kindergarten                                                   0.0                                             0
1171699 OR     school 4102800 2185   Centennial SD 28J 410280001016 963 Parklane Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   69.0                                             69
1171700 OR     school 4102800 2185   Centennial SD 28J 410280001017 964 Patrick Lynch Elementary   Regular School No Elementary KG 06 2018   kindergarten                                                   63.0                                             63
1171701 OR     school 4102800 2185   Centennial SD 28J 410280001019 966 Pleasant Valley Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   47.0                                             47
1171702 OR     school 4102800 2185   Centennial SD 28J   1885 Portland Youth Builders             2018   kindergarten                                                   0.0                                             0
1171703 OR     school 4102800 2185   Centennial SD 28J   1671 Serendipity             2018   kindergarten                                                   0.0                                             0
1171704 OR     school 4102800 2185   Centennial SD 28J 410280001018 965 Wood Elementary   Regular School No Elementary KG 06 2018   kindergarten                                                   79.0                                             79
1171705 OR     school 4105760 1972   Central Curry SD 1 410576000257 239 Gold Beach High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0

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