Data source: Big Local News · About: Big Local

1,470 rows where grade = "k_12_total", state = "OR" and year = 2017 sorted by school_nces_id

View and edit SQL

year

  • 2017 · 1,470

grade

  • k_12_total · 1,470
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
1705693 OR     school 4100003 2193   Falls City SD 57 410000301061 1005 Falls City Elementary School   Regular School No Elementary KG 08 2017   k_12_total 101.0 0.0 10.0     0.0     0.0   4.0                               101 0 10     0     0   4                        
1705694 OR     school 4100003 2193   Falls City SD 57 410000301062 1006 Falls City High School   Regular School No High 09 12 2017   k_12_total 57.0 0.0 3.0     0.0     0.0   0.0                               57 0 3     0     0   0                        
1706220 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   k_12_total 49.0 8.0 48.0     4.0     5.0   5.0                               49 8 48     4     5   5                        
1706219 OR     school 4100009 2336   Oregon Department of Education 410000901592 4040 Four Rivers Community School   Regular School Yes Other KG 09 2017   k_12_total 54.0 1.0 222.0     1.0     0.0   2.0                               54 1 222     1     0   2                        
1706221 OR     school 4100009 2336   Oregon Department of Education 410000901734 4604 Southwest Charter School   Regular School Yes Elementary KG 08 2017   k_12_total 153.0 0.0 16.0     7.0     0.0   14.0                               153 0 16     7     0   14                        
1706222 OR     school 4100009 2336   Oregon Department of Education 410000901784 4720 The Ivy School   Regular School Yes Elementary 01 08 2017   k_12_total 207.0 5.0 29.0     6.0     0.0   16.0                               207 5 29     6     0   16                        
1706218 OR     school 4100009 2336   Oregon Department of Education 410000901808 4850 Eagle Charter School   Regular School Yes Elementary KG 05 2017   k_12_total 107.0 2.0 15.0     0.0     0.0   15.0                               107 2 15     0     0   15                        
1706696 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2017   k_12_total 317.0 1.0 100.0     4.0     2.0   10.0                               317 1 100     4     2   10                        
1706700 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2017   k_12_total 86.0 0.0 1.0     1.0     0.0   1.0                               86 0 1     1     0   1                        
1706697 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2017   k_12_total 208.0 0.0 63.0     2.0     1.0   5.0                               208 0 63     2     1   5                        
1706698 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2017   k_12_total 90.0 0.0 31.0     3.0     1.0   4.0                               90 0 31     3     1   4                        
1705722 OR     school 4100015 2137   Gervais SD 1 410001500821 776 Gervais Elementary School   Regular School No Elementary KG 05 2017   k_12_total 126.0 1.0 286.0     2.0     0.0   7.0                               126 1 286     2     0   7                        
1705724 OR     school 4100015 2137   Gervais SD 1 410001500831 786 Gervais Middle School   Regular School No Middle 06 08 2017   k_12_total 62.0 0.0 152.0     1.0     1.0   9.0                               62 0 152     1     1   9                        
1705723 OR     school 4100015 2137   Gervais SD 1 410001500853 808 Gervais High School   Regular School No High 09 12 2017   k_12_total 95.0 0.0 181.0     2.0     3.0   5.0                               95 0 181     2     3   5                        
1705725 OR     school 4100015 2137   Gervais SD 1 410001501588 4024 Samuel Brown Academy   Alternative School No Other 06 12 2017   k_12_total 17.0 0.0 26.0     0.0     0.0   3.0                               17 0 26     0     0   3                        
1706751 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2017   k_12_total 329.0 2.0 30.0     1.0     0.0   16.0                               329 2 30     1     0   16                        
1706752 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2017   k_12_total 273.0 1.0 28.0     5.0     1.0   11.0                               273 1 28     5     1   11                        
1706753 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2017   k_12_total 278.0 2.0 35.0     4.0     0.0   10.0                               278 2 35     4     0   10                        
1705804 OR     school 4100019 2099   Harrisburg SD 7J 410001900698 659 Harrisburg Elementary School   Regular School No Elementary KG 05 2017   k_12_total 318.0 1.0 46.0     1.0     2.0   27.0                               318 1 46     1     2   27                        
1705805 OR     school 4100019 2099   Harrisburg SD 7J 410001900731 689 Harrisburg High School   Regular School No High 09 12 2017   k_12_total 246.0 0.0 34.0     2.0     2.0   13.0                               246 0 34     2     2   13                        
1705806 OR     school 4100019 2099   Harrisburg SD 7J 410001901422 2723 Harrisburg Middle School   Regular School No Middle 06 08 2017   k_12_total 160.0 0.0 27.0     1.0     0.0   7.0                               160 0 27     1     0   7                        
1706142 OR     school 4100020 2143   North Santiam SD 29J 410002000693 656 Mari-Linn Elementary School   Regular School No Elementary KG 08 2017   k_12_total 200.0 2.0 6.0     0.0     0.0   10.0                               200 2 6     0     0   10                        
1706146 OR     school 4100020 2143   North Santiam SD 29J 410002000765 717 Sublimity Elementary School   Regular School No Elementary KG 08 2017   k_12_total 335.0 5.0 24.0     2.0     1.0   18.0                               335 5 24     2     1   18                        
1706143 OR     school 4100020 2143   North Santiam SD 29J 410002000833 788 Stayton Elementary School   Regular School No Elementary KG 03 2017   k_12_total 299.0 5.0 108.0     2.0     5.0   18.0                               299 5 108     2     5   18                        
1706145 OR     school 4100020 2143   North Santiam SD 29J 410002000834 789 Stayton Middle School   Regular School No Elementary 04 08 2017   k_12_total 391.0 10.0 131.0     2.0     7.0   24.0                               391 10 131     2     7   24                        
1706144 OR     school 4100020 2143   North Santiam SD 29J 410002000854 809 Stayton High School   Regular School No High 09 12 2017   k_12_total 521.0 8.0 114.0     5.0     3.0   27.0                               521 8 114     5     3   27                        
1706582 OR     school 4100021 2225   South Wasco County SD 1 410002101166 1108 Maupin Elementary School   Regular School No Elementary KG 06 2017   k_12_total 95.0 0.0 19.0     0.0     0.0   8.0                               95 0 19     0     0   8                        
1706583 OR     school 4100021 2225   South Wasco County SD 1 410002101167 1109 South Wasco County High School   Regular School No High 07 12 2017   k_12_total 89.0 0.0 12.0     0.0     1.0   1.0                               89 0 12     0     1   1                        
1705850 OR     school 4100023 2239   Hillsboro SD 1J 410002300209 1302 Tobias Elementary School   Regular School No Elementary KG 06 2017   k_12_total 208.0 18.0 103.0     60.0     5.0   41.0                               208 18 103     60     5   41                        
1705853 OR     school 4100023 2239   Hillsboro SD 1J 410002301168 1111 West Union Elementary School   Regular School No Elementary KG 06 2017   k_12_total 220.0 12.0 95.0     31.0     6.0   26.0                               220 12 95     31     6   26                        
1705819 OR     school 4100023 2239   Hillsboro SD 1J 410002301169 1112 Brookwood Elementary School   Regular School No Elementary KG 06 2017   k_12_total 186.0 10.0 116.0     12.0     3.0   26.0                               186 10 116     12     3   26                        
1705823 OR     school 4100023 2239   Hillsboro SD 1J 410002301171 1115 Eastwood Elementary School   Regular School No Elementary KG 06 2017   k_12_total 151.0 5.0 296.0     7.0     3.0   17.0                               151 5 296     7     3   17                        
1705852 OR     school 4100023 2239   Hillsboro SD 1J 410002301172 1114 W Verne McKinney Elementary School   Regular School No Elementary KG 06 2017   k_12_total 170.0 13.0 255.0     5.0     1.0   18.0                               170 13 255     5     1   18                        
1705841 OR     school 4100023 2239   Hillsboro SD 1J 410002301173 1117 Mooberry Elementary School   Regular School No Elementary KG 06 2017   k_12_total 127.0 6.0 296.0     3.0     0.0   22.0                               127 6 296     3     0   22                        
1705851 OR     school 4100023 2239   Hillsboro SD 1J 410002301175 1119 W L Henry Elementary School   Regular School No Elementary KG 06 2017   k_12_total 43.0 0.0 289.0     2.0     0.0   3.0                               43 0 289     2     0   3                        
1705820 OR     school 4100023 2239   Hillsboro SD 1J 410002301199 1147 Butternut Creek Elementary School   Regular School No Elementary KG 06 2017   k_12_total 227.0 3.0 113.0     22.0     8.0   30.0                               227 3 113     22     8   30                        
1705847 OR     school 4100023 2239   Hillsboro SD 1J 410002301200 1149 Reedville Elementary School   Regular School No Elementary KG 06 2017   k_12_total 38.0 1.0 186.0     11.0     0.0   2.0                               38 1 186     11     0   2                        
1705836 OR     school 4100023 2239   Hillsboro SD 1J 410002301201 1150 Ladd Acres Elementary School   Regular School No Elementary KG 06 2017   k_12_total 256.0 9.0 126.0     69.0     9.0   56.0                               256 9 126     69     9   56                        
1705854 OR     school 4100023 2239   Hillsboro SD 1J 410002301202 1151 Witch Hazel Elementary School   Regular School No Elementary KG 06 2017   k_12_total 111.0 14.0 357.0     29.0     2.0   24.0                               111 14 357     29     2   24                        
1705828 OR     school 4100023 2239   Hillsboro SD 1J 410002301203 1152 Groner K-8   Regular School No Elementary KG 08 2017   k_12_total 134.0 1.0 61.0     3.0     1.0   14.0                               134 1 61     3     1   14                        
1705825 OR     school 4100023 2239   Hillsboro SD 1J 410002301242 1189 Farmington View Elementary School   Regular School No Elementary KG 06 2017   k_12_total 212.0 8.0 56.0     12.0     0.0   18.0                               212 8 56     12     0   18                        
1705842 OR     school 4100023 2239   Hillsboro SD 1J 410002301243 1190 North Plains Elementary School   Regular School No Elementary KG 06 2017   k_12_total 251.0 3.0 45.0     6.0     0.0   19.0                               251 3 45     6     0   19                        
1705821 OR     school 4100023 2239   Hillsboro SD 1J 410002301248 1368 Century High School   Regular School No High 09 12 2017   k_12_total 765.0 54.0 425.0     225.0     19.0   104.0                               765 54 425     225     19   104                        
1705846 OR     school 4100023 2239   Hillsboro SD 1J 410002301250 1196 R A Brown Middle School   Regular School No Middle 07 08 2017   k_12_total 334.0 23.0 197.0     96.0     8.0   51.0                               334 23 197     96     8   51                        
1705834 OR     school 4100023 2239   Hillsboro SD 1J 410002301251 1199 J W Poynter Middle School   Regular School No Middle 07 08 2017   k_12_total 347.0 17.0 277.0     54.0     10.0   39.0                               347 17 277     54     10   39                        
1705829 OR     school 4100023 2239   Hillsboro SD 1J 410002301252 1201 Hillsboro High School   Regular School No High 09 12 2017   k_12_total 529.0 24.0 606.0     62.0     9.0   63.0                               529 24 606     62     9   63                        
1705849 OR     school 4100023 2239   Hillsboro SD 1J 410002301253 1198 South Meadows Middle School   Regular School No Middle 07 08 2017   k_12_total 264.0 25.0 351.0     35.0     8.0   34.0                               264 25 351     35     8   34                        
1705833 OR     school 4100023 2239   Hillsboro SD 1J 410002301295 1148 Indian Hills Elementary School   Regular School No Elementary KG 06 2017   k_12_total 209.0 4.0 117.0     73.0     7.0   49.0                               209 4 117     73     7   49                        
1705837 OR     school 4100023 2239   Hillsboro SD 1J 410002301300 1110 Lenox Elementary School   Regular School No Elementary KG 06 2017   k_12_total 234.0 17.0 118.0     51.0     2.0   40.0                               234 17 118     51     2   40                        
1705840 OR     school 4100023 2239   Hillsboro SD 1J 410002301305 1116 Minter Bridge Elementary School   Regular School No Elementary KG 06 2017   k_12_total 187.0 18.0 206.0     17.0     2.0   38.0                               187 18 206     17     2   38                        
1705827 OR     school 4100023 2239   Hillsboro SD 1J 410002301306 1200 Glencoe High School   Regular School No High 09 12 2017   k_12_total 898.0 24.0 551.0     50.0     5.0   62.0                               898 24 551     50     5   62                        
1705824 OR     school 4100023 2239   Hillsboro SD 1J 410002301322 1197 Evergreen Jr High School   Regular School No Middle 07 08 2017   k_12_total 429.0 13.0 312.0     34.0     6.0   38.0                               429 13 312     34     6   38                        
1705835 OR     school 4100023 2239   Hillsboro SD 1J 410002301373 1285 Jackson Elementary School   Regular School No Elementary KG 06 2017   k_12_total 368.0 14.0 80.0     35.0     5.0   50.0                               368 14 80     35     5   50                        
1705843 OR     school 4100023 2239   Hillsboro SD 1J 410002301499 3160 Orenco Elementary School   Regular School No Elementary KG 06 2017   k_12_total 337.0 14.0 130.0     93.0     4.0   68.0                               337 14 130     93     4   68                        
1705844 OR     school 4100023 2239   Hillsboro SD 1J 410002301500 3159 Paul L Patterson Elementary School   Regular School No Elementary KG 06 2017   k_12_total 317.0 3.0 79.0     14.0     1.0   37.0                               317 3 79     14     1   37                        
1705822 OR     school 4100023 2239   Hillsboro SD 1J 410002301535 4206 City View Charter School   Regular School Yes Elementary KG 08 2017   k_12_total 138.0 4.0 31.0     5.0     0.0   11.0                               138 4 31     5     0   11                        
1705838 OR     school 4100023 2239   Hillsboro SD 1J 410002301585 4018 Liberty High School   Regular School No High 09 12 2017   k_12_total 779.0 46.0 517.0     91.0     16.0   80.0                               779 46 517     91     16   80                        
1705839 OR     school 4100023 2239   Hillsboro SD 1J 410002301749 4642 Lincoln Street Elementary School   Regular School No Elementary KG 06 2017   k_12_total 102.0 7.0 391.0     3.0     3.0   7.0                               102 7 391     3     3   7                        
1705848 OR     school 4100023 2239   Hillsboro SD 1J 410002301750 4703 Rosedale Elementary School   Regular School No Elementary KG 06 2017   k_12_total 178.0 8.0 169.0     35.0     3.0   42.0                               178 8 169     35     3   42                        
1705845 OR     school 4100023 2239   Hillsboro SD 1J 410002301759 4643 Quatama Elementary School   Regular School No Elementary KG 06 2017   k_12_total 232.0 14.0 120.0     56.0     4.0   62.0                               232 14 120     56     4   62                        
1705826 OR     school 4100023 2239   Hillsboro SD 1J 410002301764 4641 Free Orchards Elementary School   Regular School No Elementary KG 06 2017   k_12_total 133.0 7.0 223.0     13.0     1.0   9.0                               133 7 223     13     1   9                        
1705830 OR     school 4100023 2239   Hillsboro SD 1J 410002301824 4973 Hillsboro Online Academy   Regular School No Other KG 12 2017   k_12_total 116.0 3.0 25.0     2.0     1.0   13.0                               116 3 25     2     1   13                        
1705832 OR     school 4100023 2239   Hillsboro SD 1J 410002304174 3536 Imlay Elementary School   Regular School No Elementary KG 06 2017   k_12_total 331.0 21.0 97.0     66.0     5.0   20.0                               331 21 97     66     5   20                        
1705929 OR     school 4100040 2262   Knappa SD 4 410004000176 166 Hilda Lahti Elementary School   Regular School No Elementary KG 08 2017   k_12_total 285.0 1.0 40.0     2.0     1.0   6.0                               285 1 40     2     1   6                        
1705930 OR     school 4100040 2262   Knappa SD 4 410004000179 169 Knappa High School   Regular School No High 09 12 2017   k_12_total 115.0 0.0 13.0     1.0     2.0   3.0                               115 0 13     1     2   3                        
1706187 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Other 06 12 2017   k_12_total 52.0 16.0 30.0     0.0     0.0   11.0                               52 16 30     0     0   11                        
1706191 OR     school 4100043 3477   ODE YCEP District 410004300494 1828 William P Lord High School   Regular School No Other 06 12 2017   k_12_total 24.0 2.0 3.0     0.0     0.0   0.0                               24 2 3     0     0   0                        
1706182 OR     school 4100043 3477   ODE YCEP District 410004301404 2258 Monroe School   Regular School No Other 06 12 2017   k_12_total 11.0 2.0 6.0     0.0     0.0   1.0                               11 2 6     0     0   1                        
1706183 OR     school 4100043 3477   ODE YCEP District 410004301406 2260 New Bridge High School   Regular School No Other 06 12 2017   k_12_total 41.0 9.0 16.0     1.0     0.0   7.0                               41 9 16     1     0   7                        
1706184 OR     school 4100043 3477   ODE YCEP District 410004301412 2387 Ocean Dunes High School   Regular School No High 09 12 2017   k_12_total 3.0 1.0 2.0     0.0     0.0   0.0                               3 1 2     0     0   0                        
1706186 OR     school 4100043 3477   ODE YCEP District 410004301413 2388 Riverside High School   Regular School No High 10 12 2017   k_12_total 5.0 3.0 1.0     0.0     0.0   0.0                               5 3 1     0     0   0                        
1706188 OR     school 4100043 3477   ODE YCEP District 410004301476 2385 South Jetty High School   Regular School No Other 06 12 2017   k_12_total 17.0 3.0 20.0     0.0     0.0   6.0                               17 3 20     0     0   6                        
1706185 OR     school 4100043 3477   ODE YCEP District 410004301477 2386 RiverBend High School   Regular School No High 09 12 2017   k_12_total 6.0 0.0 4.0     0.0     0.0   0.0                               6 0 4     0     0   0                        
1706190 OR     school 4100043 3477   ODE YCEP District 410004301740 4588 Trask River High School   Regular School No Other 06 12 2017   k_12_total 26.0 4.0 1.0     1.0     0.0   3.0                               26 4 1     1     0   3                        
1706189 OR     school 4100043 3477   ODE YCEP District 410004301744 4609 Three Lakes High School   Regular School No Other 06 12 2017   k_12_total 30.0 4.0 6.0     0.0     0.0   4.0                               30 4 6     0     0   4                        
1705868 OR     school 4100047 3997   Ione SD R2 410004700862 3363 Ione Community Charter School   Regular School Yes Other KG 12 2017   k_12_total 131.0 0.0 55.0     1.0     0.0   9.0                               131 0 55     1     0   9                        
1706147 OR     school 4100048 4131   North Wasco County SD 21 410004801151 1093 Chenowith Elementary School   Regular School No Elementary KG 05 2017   k_12_total 191.0 0.0 217.0     1.0     13.0   21.0                               191 0 217     1     13   21                        
1706151 OR     school 4100048 4131   North Wasco County SD 21 410004801153 1095 Mosier Community School   Regular School Yes Elementary KG 08 2017   k_12_total 154.0 3.0 50.0     1.0     0.0   7.0                               154 3 50     1     0   7                        
1706148 OR     school 4100048 4131   North Wasco County SD 21 410004801155 1097 Colonel Wright Elementary School   Regular School No Elementary KG 05 2017   k_12_total 176.0 1.0 124.0     3.0     5.0   15.0                               176 1 124     3     5   15                        
1706149 OR     school 4100048 4131   North Wasco County SD 21 410004801156 1098 Dry Hollow Elementary School   Regular School No Elementary KG 05 2017   k_12_total 314.0 5.0 156.0     7.0     9.0   39.0                               314 5 156     7     9   39                        
1706155 OR     school 4100048 4131   North Wasco County SD 21 410004801158 1100 The Dalles Middle School   Regular School No Middle 06 08 2017   k_12_total 320.0 1.0 226.0     2.0     9.0   23.0                               320 1 226     2     9   23                        
1706154 OR     school 4100048 4131   North Wasco County SD 21 410004801159 1101 The Dalles High School   Regular School No High 09 12 2017   k_12_total 503.0 2.0 276.0     10.0     9.0   30.0                               503 2 276     10     9   30                        
1706152 OR     school 4100048 4131   North Wasco County SD 21 410004801806 4849 Mosier Middle School   Regular School No Not reported M M 2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706156 OR     school 4100048 4131   North Wasco County SD 21 410004801833 5250 Wahtonka Community School   Alternative School No High 09 12 2017   k_12_total 57.0 1.0 9.0     1.0     1.0   1.0                               57 1 9     1     1   1                        
1706075 OR     school 4100640 1968   Myrtle Point SD 41 410064000233 214 Myrtle Crest School   Regular School No Elementary KG 06 2017   k_12_total 215.0 1.0 20.0     0.0     1.0   63.0                               215 1 20     0     1   63                        
1706076 OR     school 4100640 1968   Myrtle Point SD 41 410064000234 215 Myrtle Point High School   Regular School No High 07 12 2017   k_12_total 163.0 3.0 24.0     1.0     2.0   49.0                               163 3 24     1     2   49                        
1705288 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Elementary 04 08 2017   k_12_total 8.0 0.0 0.0     0.0     0.0   0.0                               8 0 0     0     0   0                        
1705289 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2017   k_12_total 152.0 0.0 46.0     0.0     0.0   2.0                               152 0 46     0     0   2                        
1705290 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2017   k_12_total 61.0 0.0 19.0     1.0     0.0   3.0                               61 0 19     1     0   3                        
1705761 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000017 639 Oak Grove Elementary School   Regular School No Elementary 02 05 2017   k_12_total 229.0 1.0 13.0     2.0     1.0   15.0                               229 1 13     2     1   15                        
1705758 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000029 637 North Albany Elementary School   Regular School No Elementary KG 05 2017   k_12_total 249.0 0.0 15.0     4.0     0.0   28.0                               249 0 15     4     0   28                        
1705753 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000031 635 Fir Grove Primary School   Regular School No Elementary KG 01 2017   k_12_total 108.0 0.0 8.0     2.0     2.0   7.0                               108 0 8     2     2   7                        
1705751 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000669 631 Central Elementary School   Regular School No Elementary 03 05 2017   k_12_total 115.0 0.0 15.0     0.0     0.0   16.0                               115 0 15     0     0   16                        
1705755 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000670 640 Lafayette Elementary School   Regular School No Elementary KG 05 2017   k_12_total 206.0 2.0 87.0     0.0     1.0   17.0                               206 2 87     0     1   17                        
1705756 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000671 641 Liberty Elementary School   Regular School No Elementary KG 05 2017   k_12_total 277.0 1.0 23.0     8.0     1.0   36.0                               277 1 23     8     1   36                        
1705760 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000672 643 Oak Elementary School   Regular School No Elementary KG 05 2017   k_12_total 281.0 3.0 31.0     2.0     0.0   16.0                               281 3 31     2     0   16                        
1705765 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000673 644 Sunrise Elementary School   Regular School No Elementary KG 05 2017   k_12_total 230.0 1.0 156.0     1.0     1.0   22.0                               230 1 156     1     1   22                        
1705764 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000674 645 South Shore Elementary School   Regular School No Elementary KG 05 2017   k_12_total 115.0 1.0 279.0     1.0     2.0   14.0                               115 1 279     1     2   14                        
1705766 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000675 647 Takena Elementary School   Regular School No Elementary KG 02 2017   k_12_total 137.0 1.0 14.0     0.0     0.0   12.0                               137 1 14     0     0   12                        
1705769 OR     school 4101120 2100   Greater Albany Public SD 8J 410112000676 648 Waverly Elementary School   Regular School No Elementary KG 05 2017   k_12_total 169.0 0.0 84.0     4.0     0.0   11.0                               169 0 84     4     0   11                        

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