Data source: Big Local News · About: Big Local

1,459 rows where grade = "grade_7", state = "OR" and year = 2018 sorted by district_nces_id

View and edit SQL

year

  • 2018 · 1,459

grade

  • grade_7 · 1,459
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
1182123 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2018   grade_7                                                   12.0                                             12
1182124 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182640 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2018   grade_7                                                   0.0                                             0
1182641 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 10 2018   grade_7                                                   28.0                                             28
1182642 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_7                                                   7.0                                             7
1182643 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 The Cottonwood School of Civics and Science   Regular School Yes Elementary KG 08 2018   grade_7                                                   22.0                                             22
1182644 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary 01 08 2018   grade_7                                                   16.0                                             16
1183117 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1183118 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1183119 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2018   grade_7                                                   54.0                                             54
1183120 OR     school 4100014 2116   Vale SD 84   2116 Vale SD 84             2018   grade_7                                                   0.0                                             0
1183121 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2018   grade_7                                                   7.0                                             7
1182150 OR     school 4100015 2137   Gervais SD 1 410001501859 5392 Frontier Charter Academy   Regular School Yes Middle 05 09 2018   grade_7                                                   26.0                                             26
1182151 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2018   grade_7                                                   0.0                                             0
1182152 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182153 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2018   grade_7                                                   85.0                                             85
1182154 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No High 06 12 2018   grade_7                                                   0.0                                             0
1183172 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2018   grade_7                                                   0.0                                             0
1183173 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1183174 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2018   grade_7                                                   75.0                                             75
1183175 OR     school 4100016 2251   Yamhill Carlton SD 1   2251 Yamhill Carlton SD 1             2018   grade_7                                                   10.0                                             10
1182231 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 05 2018   grade_7                                                   0.0                                             0
1182232 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182233 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 06 08 2018   grade_7                                                   62.0                                             62
1182564 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2018   grade_7                                                   25.0                                             25
1182565 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2018   grade_7                                                   0.0                                             0
1182566 OR     school 4100020 2143   North Santiam SD 29J 410002000854 809 Stayton High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182567 OR     school 4100020 2143   North Santiam SD 29J 410002000834 789 Stayton Middle School   Regular School No Middle 04 08 2018   grade_7                                                   118.0                                             118
1182568 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2018   grade_7                                                   42.0                                             42
1183005 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1183006 OR     school 4100021 2225   South Wasco County SD 1 410002101167 1109 South Wasco County High School   Regular School No High 07 12 2018   grade_7                                                   20.0                                             20
1182245 OR     school 4100023 2239   Hillsboro SD 1J 410002301169 1112 Brookwood Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182246 OR     school 4100023 2239   Hillsboro SD 1J 410002301199 1147 Butternut Creek Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182247 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182248 OR     school 4100023 2239   Hillsboro SD 1J 410002301535 4206 City View Charter School   Regular School Yes Elementary KG 08 2018   grade_7                                                   12.0                                             12
1182249 OR     school 4100023 2239   Hillsboro SD 1J 410002301171 1115 Eastwood Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182250 OR     school 4100023 2239   Hillsboro SD 1J 410002301322 1197 Evergreen Jr High School   Regular School No Middle 07 08 2018   grade_7                                                   417.0                                             417
1182251 OR     school 4100023 2239   Hillsboro SD 1J 410002301242 1189 Farmington View Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182252 OR     school 4100023 2239   Hillsboro SD 1J 410002301764 4641 Free Orchards Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182253 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182254 OR     school 4100023 2239   Hillsboro SD 1J 410002301203 1152 Groner K-8   Regular School No Elementary KG 08 2018   grade_7                                                   24.0                                             24
1182255 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182256 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2018   grade_7                                                   18.0                                             18
1182257 OR     school 4100023 2239   Hillsboro SD 1J   2239 Hillsboro SD 1J             2018   grade_7                                                   1.0                                             1
1182258 OR     school 4100023 2239   Hillsboro SD 1J 410002304174 3536 Imlay Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182259 OR     school 4100023 2239   Hillsboro SD 1J 410002301295 1148 Indian Hills Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182260 OR     school 4100023 2239   Hillsboro SD 1J 410002301251 1199 J W Poynter Middle School   Regular School No Middle 07 08 2018   grade_7                                                   384.0                                             384
1182261 OR     school 4100023 2239   Hillsboro SD 1J 410002301373 1285 Jackson Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182262 OR     school 4100023 2239   Hillsboro SD 1J 410002301201 1150 Ladd Acres Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182263 OR     school 4100023 2239   Hillsboro SD 1J 410002301300 1110 Lenox Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182264 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182265 OR     school 4100023 2239   Hillsboro SD 1J 410002301749 4642 Lincoln Street Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182266 OR     school 4100023 2239   Hillsboro SD 1J 410002301305 1116 Minter Bridge Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182267 OR     school 4100023 2239   Hillsboro SD 1J 410002301173 1117 Mooberry Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182268 OR     school 4100023 2239   Hillsboro SD 1J 410002301243 1190 North Plains Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182269 OR     school 4100023 2239   Hillsboro SD 1J 410002301499 3160 Orenco Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182270 OR     school 4100023 2239   Hillsboro SD 1J 410002301500 3159 Paul L Patterson Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182271 OR     school 4100023 2239   Hillsboro SD 1J 410002301759 4643 Quatama Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182272 OR     school 4100023 2239   Hillsboro SD 1J 410002301250 1196 R A Brown Middle School   Regular School No Middle 07 08 2018   grade_7                                                   372.0                                             372
1182273 OR     school 4100023 2239   Hillsboro SD 1J 410002301200 1149 Reedville Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182274 OR     school 4100023 2239   Hillsboro SD 1J 410002301750 4703 Rosedale Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182275 OR     school 4100023 2239   Hillsboro SD 1J 410002301253 1198 South Meadows Middle School   Regular School No Middle 07 08 2018   grade_7                                                   356.0                                             356
1182276 OR     school 4100023 2239   Hillsboro SD 1J 410002300209 1302 Tobias Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182277 OR     school 4100023 2239   Hillsboro SD 1J 410002301175 1119 W L Henry Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182278 OR     school 4100023 2239   Hillsboro SD 1J 410002301172 1114 W Verne McKinney Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182279 OR     school 4100023 2239   Hillsboro SD 1J 410002301168 1111 West Union Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182280 OR     school 4100023 2239   Hillsboro SD 1J 410002301202 1151 Witch Hazel Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182353 OR     school 4100040 2262   Knappa SD 4 410004000176 166 Hilda Lahti Elementary School   Regular School No Elementary KG 08 2018   grade_7                                                   38.0                                             38
1182354 OR     school 4100040 2262   Knappa SD 4 410004000179 169 Knappa High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182604 OR     school 4100043 3477   ODE YCEP District 410004301404 2258 Monroe School   Regular School No High 06 12 2018   grade_7                                                   0.0                                             0
1182605 OR     school 4100043 3477   ODE YCEP District 410004301406 2260 New Bridge High School   Regular School No High 06 12 2018   grade_7                                                   0.0                                             0
1182606 OR     school 4100043 3477   ODE YCEP District 410004301412 2387 Ocean Dunes High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182607 OR     school 4100043 3477   ODE YCEP District 410004301477 2386 RiverBend High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182608 OR     school 4100043 3477   ODE YCEP District 410004301413 2388 Riverside High School   Regular School No High 10 12 2018   grade_7                                                   0.0                                             0
1182609 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_7                                                   0.0                                             0
1182610 OR     school 4100043 3477   ODE YCEP District 410004301476 2385 South Jetty High School   Regular School No High 06 12 2018   grade_7                                                   0.0                                             0
1182611 OR     school 4100043 3477   ODE YCEP District 410004301744 4609 Three Lakes High School   Regular School No High 06 12 2018   grade_7                                                   0.0                                             0
1182612 OR     school 4100043 3477   ODE YCEP District 410004301740 4588 Trask River High School   Regular School No High 06 12 2018   grade_7                                                   0.0                                             0
1182613 OR     school 4100043 3477   ODE YCEP District 410004300494 1828 William P Lord High School   Regular School No High 06 12 2018   grade_7                                                   0.0                                             0
1182294 OR     school 4100047 3997   Ione SD R2 410004700862 3363 Ione Community Charter School   Regular School Yes Other KG 12 2018   grade_7                                                   14.0                                             14
1182569 OR     school 4100048 4131   North Wasco County SD 21 410004801151 1093 Chenowith Elementary School   Regular School No Elementary KG 05 2018   grade_7                                                   0.0                                             0
1182570 OR     school 4100048 4131   North Wasco County SD 21 410004801155 1097 Colonel Wright Elementary School   Regular School No Elementary KG 05 2018   grade_7                                                   0.0                                             0
1182571 OR     school 4100048 4131   North Wasco County SD 21   1262 Crossroads             2018   grade_7                                                   0.0                                             0
1182572 OR     school 4100048 4131   North Wasco County SD 21 410004801156 1098 Dry Hollow Elementary School   Regular School No Elementary KG 05 2018   grade_7                                                   0.0                                             0
1182573 OR     school 4100048 4131   North Wasco County SD 21 410004801153 1095 Mosier Community School   Regular School Yes Elementary KG 08 2018   grade_7                                                   25.0                                             25
1182574 OR     school 4100048 4131   North Wasco County SD 21   4131 North Wasco County SD 21             2018   grade_7                                                   0.0                                             0
1182575 OR     school 4100048 4131   North Wasco County SD 21 410004801159 1101 The Dalles High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182576 OR     school 4100048 4131   North Wasco County SD 21 410004801158 1100 The Dalles Middle School   Regular School No Middle 06 08 2018   grade_7                                                   187.0                                             187
1182577 OR     school 4100048 4131   North Wasco County SD 21 410004801833 5250 Wahtonka Community School   Alternative School No High 09 12 2018   grade_7                                                   0.0                                             0
1182500 OR     school 4100640 1968   Myrtle Point SD 41 410064000233 214 Myrtle Crest School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1182501 OR     school 4100640 1968   Myrtle Point SD 41 410064000234 215 Myrtle Point High School   Regular School No High 07 12 2018   grade_7                                                   41.0                                             41
1181719 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Middle 04 08 2018   grade_7                                                   2.0                                             2
1181720 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2018   grade_7                                                   24.0                                             24
1181721 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1182177 OR     school 4101120 2100   Greater Albany Public SD 8J 410112001577 3950 Albany Options School   Alternative School No High 09 12 2018   grade_7                                                   0.0                                             0
1182178 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000732 632 Calapooia Middle School   Regular School No Middle 06 08 2018   grade_7                                                   193.0                                             193
1182179 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000669 631 Central Elementary School   Regular School No Elementary 03 05 2018   grade_7                                                   0.0                                             0
1182180 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000725 633 Clover Ridge Elementary School   Regular School No Elementary KG 02 2018   grade_7                                                   0.0                                             0
1182181 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000031 635 Fir Grove Primary School   Regular School No Elementary KG 01 2018   grade_7                                                   0.0                                             0
1182182 OR     school 4101120 2100   Greater Albany Public SD 8J   2100 Greater Albany Public SD 8J             2018   grade_7                                                   2.0                                             2

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