Data source: Big Local News · About: Big Local

1,470 rows where grade = "k_12_total", state = "OR" and year = 2017 sorted by school_state_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
1705319 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   k_12_total 166.0 0.0 27.0     1.0     0.0   10.0                               166 0 27     1     0   10                        
1705322 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   k_12_total 402.0 1.0 46.0     0.0     0.0   12.0                               402 1 46     0     0   12                        
1705324 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   k_12_total 135.0 0.0 10.0     1.0     0.0   7.0                               135 0 10     1     0   7                        
1705325 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   k_12_total 18.0 0.0 4.0     0.0     0.0   2.0                               18 0 4     0     0   2                        
1705326 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   k_12_total 249.0 0.0 40.0     2.0     0.0   25.0                               249 0 40     2     0   25                        
1705318 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   k_12_total 396.0 1.0 38.0     5.0     0.0   22.0                               396 1 38     5     0   22                        
1706270 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   k_12_total 174.0 1.0 20.0     0.0     0.0   12.0                               174 1 20     0     0   12                        
1705291 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Elementary KG 06 2017   k_12_total 63.0 0.0 7.0     0.0     0.0   3.0                               63 0 7     0     0   3                        
1705292 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea High School   Regular School No High 07 12 2017   k_12_total 59.0 0.0 6.0     0.0     0.0   0.0                               59 0 6     0     0   0                        
1706254 OR     school 4109600 1900   Philomath SD 17J 410960000020 18 Blodgett Elementary School   Regular School No Elementary KG 04 2017   k_12_total 28.0 1.0 1.0     0.0     0.0   2.0                               28 1 1     0     0   2                        
1706257 OR     school 4109600 1900   Philomath SD 17J 410960000022 20 Philomath Elementary School   Regular School No Elementary 02 05 2017   k_12_total 347.0 1.0 30.0     5.0     0.0   18.0                               347 1 30     5     0   18                        
1706259 OR     school 4109600 1900   Philomath SD 17J 410960000023 21 Philomath Middle School   Regular School No Middle 06 08 2017   k_12_total 289.0 0.0 22.0     2.0     0.0   21.0                               289 0 22     2     0   21                        
1706258 OR     school 4109600 1900   Philomath SD 17J 410960000024 22 Philomath High School   Regular School No High 09 12 2017   k_12_total 399.0 0.0 37.0     6.0     0.0   16.0                               399 0 37     6     0   16                        
1705532 OR     school 4103480 1901   Corvallis SD 509J 410348000032 27 Adams Elementary School   Regular School No Elementary KG 05 2017   k_12_total 327.0 9.0 13.0     23.0     2.0   29.0                               327 9 13     23     2   29                        
1705533 OR     school 4103480 1901   Corvallis SD 509J 410348000033 28 Cheldelin Middle School   Regular School No Middle 06 08 2017   k_12_total 388.0 5.0 48.0     40.0     2.0   56.0                               388 5 48     40     2   56                        
1705538 OR     school 4103480 1901   Corvallis SD 509J 410348000037 30 Garfield Elementary School   Regular School No Elementary KG 05 2017   k_12_total 191.0 6.0 195.0     13.0     0.0   24.0                               191 6 195     13     0   24                        
1705539 OR     school 4103480 1901   Corvallis SD 509J 410348000040 33 Hoover Elementary School   Regular School No Elementary KG 05 2017   k_12_total 284.0 8.0 31.0     57.0     0.0   43.0                               284 8 31     57     0   43                        
1705541 OR     school 4103480 1901   Corvallis SD 509J 410348000042 35 Jefferson Elementary School   Regular School No Elementary KG 05 2017   k_12_total 269.0 3.0 16.0     10.0     2.0   24.0                               269 3 16     10     2   24                        
1705542 OR     school 4103480 1901   Corvallis SD 509J 410348000043 36 Lincoln Elementary School   Regular School No Elementary KG 05 2017   k_12_total 212.0 6.0 120.0     2.0     0.0   19.0                               212 6 120     2     0   19                        
1705544 OR     school 4103480 1901   Corvallis SD 509J 410348000044 37 Mt View Elementary School   Regular School No Elementary KG 05 2017   k_12_total 281.0 4.0 22.0     10.0     1.0   21.0                               281 4 22     10     1   21                        
1705543 OR     school 4103480 1901   Corvallis SD 509J 410348000045 38 Linus Pauling Middle School   Regular School No Middle 06 08 2017   k_12_total 464.0 6.0 181.0     21.0     3.0   48.0                               464 6 181     21     3   48                        
1705545 OR     school 4103480 1901   Corvallis SD 509J 410348000046 39 Wilson Elementary School   Regular School No Elementary KG 05 2017   k_12_total 268.0 8.0 46.0     26.0     4.0   32.0                               268 8 46     26     4   32                        
1705534 OR     school 4103480 1901   Corvallis SD 509J 410348000047 40 Corvallis High School   Regular School No High 09 12 2017   k_12_total 784.0 22.0 216.0     59.0     10.0   105.0                               784 22 216     59     10   105                        
1705536 OR     school 4103480 1901   Corvallis SD 509J 410348000048 41 Crescent Valley High School   Regular School No High 09 12 2017   k_12_total 754.0 8.0 88.0     88.0     3.0   57.0                               754 8 88     88     3   57                        
1705984 OR     school   2098   Linn Benton Lincoln ESD   42 Childrens Farm Home             2017   k_12_total 29.0 1.0 7.0     0.0     1.0   5.0                               29 1 7     0     1   5                        
1706053 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   k_12_total 101.0 0.0 27.0     1.0     0.0   4.0                               101 0 27     1     0   4                        
1706714 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000053 45 Cedaroak Park Primary School   Regular School No Elementary PK 05 2017   k_12_total 262.0 1.0 16.0     5.0     0.0   23.0                               262 1 16     5     0   23                        
1706715 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001318 46 Inza R Wood Middle School   Regular School No Middle 06 08 2017   k_12_total 541.0 6.0 160.0     28.0     8.0   64.0                               541 6 160     28     8   64                        
1706718 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000054 47 Stafford Primary School   Regular School No Elementary KG 05 2017   k_12_total 367.0 2.0 16.0     33.0     1.0   32.0                               367 2 16     33     1   32                        
1706719 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000055 48 Sunset Primary School   Regular School No Elementary KG 05 2017   k_12_total 252.0 2.0 20.0     14.0     0.0   28.0                               252 2 20     14     0   28                        
1706722 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2017   k_12_total 1443.0 9.0 129.0     96.0     3.0   122.0                               1443 9 129     96     3   122                        
1705943 OR     school 4107230 1923   Lake Oswego SD 7J 410723000060 53 Forest Hills Elementary School   Regular School No Elementary KG 05 2017   k_12_total 361.0 4.0 16.0     30.0     0.0   29.0                               361 4 16     30     0   29                        
1705944 OR     school 4107230 1923   Lake Oswego SD 7J 410723001308 54 Hallinan Elementary School   Regular School No Elementary KG 05 2017   k_12_total 344.0 2.0 43.0     28.0     2.0   38.0                               344 2 43     28     2   38                        
1705945 OR     school 4107230 1923   Lake Oswego SD 7J 410723000061 55 Lake Grove Elementary School   Regular School No Elementary KG 05 2017   k_12_total 328.0 5.0 20.0     64.0     5.0   37.0                               328 5 20     64     5   37                        
1705952 OR     school 4107230 1923   Lake Oswego SD 7J 410723000064 56 River Grove Elementary School   Regular School No Elementary KG 05 2017   k_12_total 386.0 2.0 50.0     48.0     4.0   48.0                               386 2 50     48     4   48                        
1705953 OR     school 4107230 1923   Lake Oswego SD 7J 410723001307 58 Westridge Elementary School   Regular School No Elementary KG 05 2017   k_12_total 392.0 3.0 23.0     30.0     3.0   22.0                               392 3 23     30     3   22                        
1705946 OR     school 4107230 1923   Lake Oswego SD 7J 410723000066 59 Lake Oswego Middle School   Regular School No Middle 06 08 2017   k_12_total 665.0 10.0 70.0     113.0     1.0   51.0                               665 10 70     113     1   51                        
1705950 OR     school 4107230 1923   Lake Oswego SD 7J 410723000067 60 Lakeridge Middle School   Regular School No Middle 06 08 2017   k_12_total 662.0 4.0 54.0     47.0     3.0   69.0                               662 4 54     47     3   69                        
1705948 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2017   k_12_total 969.0 12.0 71.0     163.0     3.0   92.0                               969 12 71     163     3   92                        
1705949 OR     school 4107230 1923   Lake Oswego SD 7J 410723000069 62 Lakeridge High School   Regular School No High 09 12 2017   k_12_total 886.0 10.0 62.0     73.0     1.0   82.0                               886 10 62     73     1   82                        
1706105 OR     school 4108830 1924   North Clackamas SD 12 410883000072 65 Bilquist Elementary School   Regular School No Elementary KG 05 2017   k_12_total 291.0 5.0 101.0     15.0     1.0   34.0                               291 5 101     15     1   34                        
1706133 OR     school 4108830 1924   North Clackamas SD 12 410883000080 72 Whitcomb Elementary School   Regular School No Elementary KG 05 2017   k_12_total 195.0 8.0 204.0     11.0     2.0   26.0                               195 8 204     11     2   26                        
1706116 OR     school 4108830 1924   North Clackamas SD 12 410883000081 73 Milwaukie Elementary School   Regular School No Elementary KG 05 2017   k_12_total 123.0 3.0 19.0     1.0     0.0   21.0                               123 3 19     1     0   21                        
1706124 OR     school 4108830 1924   North Clackamas SD 12 410883000084 76 Riverside Elementary School   Regular School No Elementary KG 05 2017   k_12_total 268.0 5.0 141.0     0.0     1.0   22.0                               268 5 141     0     1   22                        
1706130 OR     school 4108830 1924   North Clackamas SD 12 410883000086 78 Sunnyside Elementary School   Regular School No Elementary KG 05 2017   k_12_total 332.0 21.0 89.0     69.0     2.0   44.0                               332 21 89     69     2   44                        
1706132 OR     school 4108830 1924   North Clackamas SD 12 410883000087 79 View Acres Elementary School   Regular School No Elementary KG 05 2017   k_12_total 325.0 2.0 47.0     14.0     3.0   39.0                               325 2 47     14     3   39                        
1706126 OR     school 4108830 1924   North Clackamas SD 12 410883000092 84 Rowe Middle School   Regular School No Middle 06 08 2017   k_12_total 468.0 13.0 239.0     12.0     8.0   62.0                               468 13 239     12     8   62                        
1706107 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2017   k_12_total 1577.0 34.0 277.0     408.0     7.0   188.0                               1577 34 277     408     7   188                        
1706117 OR     school 4108830 1924   North Clackamas SD 12 410883000094 86 Milwaukie High School   Regular School No High 09 12 2017   k_12_total 533.0 34.0 293.0     32.0     16.0   59.0                               533 34 293     32     16   59                        
1706123 OR     school 4108830 1924   North Clackamas SD 12 410883000095 87 Putnam High School   Regular School No High 09 12 2017   k_12_total 784.0 16.0 228.0     25.0     3.0   76.0                               784 16 228     25     3   76                        
1706232 OR     school 4110890 1926   Oregon Trail SD 46 411089000096 88 Welches Elementary School   Regular School No Elementary KG 05 2017   k_12_total 162.0 2.0 31.0     0.0     0.0   11.0                               162 2 31     0     0   11                        
1705773 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000098 90 Deep Creek – Damascus K-8 School   Regular School No Elementary KG 08 2017   k_12_total 369.0 1.0 26.0     12.0     1.0   19.0                               369 1 26     12     1   19                        
1705774 OR     school 4106000 2183   Gresham-Barlow SD 10J 410600000099 91 Deep Creek Elementary 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                        
1705458 OR     school 4102640 1929   Canby SD 86 410264000100 92 Carus School   Regular School No Elementary KG 06 2017   k_12_total 354.0 1.0 68.0     4.0     1.0   20.0                               354 1 68     4     1   20                        
1706043 OR     school 4108310 1925   Molalla River SD 35 410831000101 93 Clarkes Elementary School   Regular School No Elementary KG 05 2017   k_12_total 146.0 0.0 6.0     0.0     0.0   8.0                               146 0 6     0     0   8                        
1706044 OR     school 4108310 1925   Molalla River SD 35 410831001325 94 Molalla Elementary School   Regular School No Elementary KG 05 2017   k_12_total 263.0 1.0 132.0     0.0     0.0   13.0                               263 1 132     0     0   13                        
1706047 OR     school 4108310 1925   Molalla River SD 35 410831000102 95 Molalla River Middle School   Regular School No Middle 06 08 2017   k_12_total 384.0 1.0 99.0     3.0     1.0   20.0                               384 1 99     3     1   20                        
1706227 OR     school 4110890 1926   Oregon Trail SD 46 411089000103 96 Naas Elementary School   Regular School No Elementary KG 05 2017   k_12_total 274.0 2.0 65.0     3.0     3.0   20.0                               274 2 65     3     3   20                        
1706223 OR     school 4110890 1926   Oregon Trail SD 46 411089000104 97 Boring Middle School   Regular School No Middle 06 08 2017   k_12_total 316.0 2.0 51.0     9.0     2.0   17.0                               316 2 51     9     2   17                        
1706226 OR     school 4110890 1926   Oregon Trail SD 46 411089001297 99 Kelso Elementary School   Regular School No Elementary KG 05 2017   k_12_total 295.0 1.0 32.0     1.0     0.0   15.0                               295 1 32     1     0   15                        
1706230 OR     school 4110890 1926   Oregon Trail SD 46 411089000106 100 Sandy Grade School   Regular School No Elementary KG 05 2017   k_12_total 263.0 4.0 52.0     2.0     4.0   14.0                               263 4 52     2     4   14                        
1706225 OR     school 4110890 1926   Oregon Trail SD 46 411089000107 101 Firwood Elementary School   Regular School No Elementary KG 05 2017   k_12_total 364.0 1.0 65.0     8.0     4.0   13.0                               364 1 65     8     4   13                        
1706224 OR     school 4110890 1926   Oregon Trail SD 46 411089000108 102 Cedar Ridge Middle School   Regular School No Middle 06 08 2017   k_12_total 289.0 4.0 63.0     0.0     6.0   16.0                               289 4 63     0     6   16                        
1705510 OR     school 4103270 1927   Colton SD 53 410327000109 103 Colton Elementary School   Regular School No Elementary KG 05 2017   k_12_total 251.0 0.0 18.0     2.0     2.0   9.0                               251 0 18     2     2   9                        
1705511 OR     school 4103270 1927   Colton SD 53 410327000110 104 Colton High School   Regular School No High 09 12 2017   k_12_total 173.0 0.0 13.0     0.0     1.0   12.0                               173 0 13     0     1   12                        
1706201 OR     school 4109330 1928   Oregon City SD 62 410933000112 105 Beavercreek Elementary School   Regular School No Elementary KG 05 2017   k_12_total 444.0 1.0 38.0     11.0     0.0   35.0                               444 1 38     11     0   35                        
1706202 OR     school 4109330 1928   Oregon City SD 62 410933000113 106 Candy Lane Elementary School   Regular School No Elementary 02 05 2017   k_12_total 136.0 8.0 105.0     2.0     2.0   19.0                               136 8 105     2     2   19                        
1706206 OR     school 4109330 1928   Oregon City SD 62 410933000114 107 Holcomb Elementary School   Regular School No Elementary KG 05 2017   k_12_total 380.0 6.0 43.0     4.0     7.0   38.0                               380 6 43     4     7   38                        
1706204 OR     school 4109330 1928   Oregon City SD 62 410933000116 109 Gaffney Lane Elementary School   Regular School No Elementary KG 05 2017   k_12_total 448.0 3.0 67.0     7.0     1.0   31.0                               448 3 67     7     1   31                        
1706207 OR     school 4109330 1928   Oregon City SD 62 410933000117 110 Jennings Lodge Elementary School   Regular School No Elementary KG 02 2017   k_12_total 143.0 6.0 101.0     5.0     0.0   9.0                               143 6 101     5     0   9                        
1706208 OR     school 4109330 1928   Oregon City SD 62 410933000122 114 John McLoughlin Elementary School   Regular School No Elementary KG 05 2017   k_12_total 482.0 2.0 47.0     16.0     0.0   49.0                               482 2 47     16     0   49                        
1706205 OR     school 4109330 1928   Oregon City SD 62 410933000123 115 Gardiner Middle School   Regular School No Middle 06 08 2017   k_12_total 574.0 10.0 133.0     10.0     5.0   52.0                               574 10 133     10     5   52                        
1706209 OR     school 4109330 1928   Oregon City SD 62 410933000124 116 Ogden Middle School   Regular School No Middle 06 08 2017   k_12_total 656.0 7.0 84.0     14.0     5.0   65.0                               656 7 84     14     5   65                        
1706211 OR     school 4109330 1928   Oregon City SD 62 410933000126 118 Oregon City Senior High School   Regular School No High 09 12 2017   k_12_total 1613.0 24.0 261.0     36.0     9.0   107.0                               1613 24 261     36     9   107                        
1706542 OR     school 4111450 2138   Silver Falls SD 4J 411145000127 119 Butte Creek Elementary School   Regular School No Elementary KG 08 2017   k_12_total 251.0 1.0 54.0     3.0     1.0   9.0                               251 1 54     3     1   9                        
1706049 OR     school 4108310 1925   Molalla River SD 35 410831000129 121 Mulino Elementary School   Regular School No Elementary KG 05 2017   k_12_total 249.0 0.0 31.0     1.0     2.0   15.0                               249 0 31     1     2   15                        
1705463 OR     school 4102640 1929   Canby SD 86 410264000130 122 William Knight Elementary School   Regular School No Elementary KG 06 2017   k_12_total 245.0 0.0 100.0     3.0     0.0   13.0                               245 0 100     3     0   13                        
1705460 OR     school 4102640 1929   Canby SD 86 410264000132 124 Howard Eccles Elementary School   Regular School No Elementary KG 06 2017   k_12_total 359.0 7.0 100.0     5.0     2.0   20.0                               359 7 100     5     2   20                        
1705461 OR     school 4102640 1929   Canby SD 86 410264000135 127 Ninety-One School   Regular School No Elementary KG 08 2017   k_12_total 371.0 0.0 76.0     3.0     1.0   21.0                               371 0 76     3     1   21                        
1706051 OR     school 4108310 1925   Molalla River SD 35 410831000136 128 Rural Dell Elementary School   Regular School No Elementary KG 05 2017   k_12_total 176.0 0.0 35.0     1.0     2.0   8.0                               176 0 35     1     2   8                        
1705638 OR     school 4104700 1930   Estacada SD 108 410470000139 131 Clackamas River Elementary School   Regular School No Elementary KG 05 2017   k_12_total 355.0 2.0 44.0     2.0     0.0   29.0                               355 2 44     2     0   29                        
1705642 OR     school 4104700 1930   Estacada SD 108 410470000140 132 River Mill Elementary School   Regular School No Elementary KG 05 2017   k_12_total 234.0 2.0 72.0     8.0     0.0   19.0                               234 2 72     8     0   19                        
1705640 OR     school 4104700 1930   Estacada SD 108 410470000142 134 Estacada Middle School   Regular School No Middle 06 08 2017   k_12_total 285.0 0.0 51.0     4.0     0.0   12.0                               285 0 51     4     0   12                        
1705639 OR     school 4104700 1930   Estacada SD 108 410470000143 135 Estacada High School   Regular School No High 09 12 2017   k_12_total 417.0 0.0 80.0     6.0     0.0   21.0                               417 0 80     6     0   21                        
1705730 OR     school 4105610 1931   Gladstone SD 115 410561000144 136 John Wetten Elementary School   Regular School No Elementary 01 05 2017   k_12_total 559.0 5.0 110.0     8.0     10.0   57.0                               559 5 110     8     10   57                        
1705732 OR     school 4105610 1931   Gladstone SD 115 410561000145 137 Walter L Kraxberger Middle School   Regular School No Middle 06 08 2017   k_12_total 361.0 12.0 85.0     5.0     3.0   32.0                               361 12 85     5     3   32                        
1705728 OR     school 4105610 1931   Gladstone SD 115 410561000146 138 Gladstone High School   Regular School No High 09 12 2017   k_12_total 483.0 10.0 98.0     10.0     3.0   63.0                               483 10 98     10     3   63                        
1706214 OR     school 4109330 1928   Oregon City SD 62 410933000147 139 Redland Elementary School   Regular School No Elementary KG 05 2017   k_12_total 463.0 4.0 50.0     10.0     2.0   25.0                               463 4 50     10     2   25                        
1705456 OR     school 4102640 1929   Canby SD 86 410264000148 140 Canby High School   Regular School No High 09 12 2017   k_12_total 976.0 4.0 399.0     7.0     3.0   57.0                               976 4 399     7     3   57                        
1706231 OR     school 4110890 1926   Oregon Trail SD 46 411089000149 141 Sandy High School   Regular School No High 09 12 2017   k_12_total 1087.0 5.0 203.0     15.0     5.0   81.0                               1087 5 203     15     5   81                        
1706045 OR     school 4108310 1925   Molalla River SD 35 410831000151 142 Molalla High School   Regular School No High 09 12 2017   k_12_total 574.0 1.0 111.0     7.0     1.0   32.0                               574 1 111     7     1   32                        
1705309 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2017   k_12_total 308.0 1.0 79.0     2.0     5.0   13.0                               308 1 79     2     5   13                        
1705310 OR     school 4101620 1933   Astoria SD 1 410162000153 144 Astoria Middle School   Regular School No Middle 06 08 2017   k_12_total 313.0 1.0 64.0     8.0     2.0   15.0                               313 1 64     8     2   15                        
1705312 OR     school 4101620 1933   Astoria SD 1 410162000155 146 Astoria Senior High School   Regular School No High 09 12 2017   k_12_total 467.0 0.0 88.0     14.0     6.0   25.0                               467 0 88     14     6   25                        
1705313 OR     school 4101620 1933   Astoria SD 1 410162000156 147 Lewis & Clark Elementary School   Regular School No Elementary 03 05 2017   k_12_total 310.0 3.0 84.0     4.0     5.0   16.0                               310 3 84     4     5   16                        
1706521 OR     school 4111100 1935   Seaside SD 10 411110000159 150 Broadway Middle School   Regular School No Middle 06 08 2017   k_12_total 262.0 0.0 77.0     5.0     2.0   4.0                               262 0 77     5     2   4                        
1706523 OR     school 4111100 1935   Seaside SD 10 411110000161 152 Seaside Heights Elementary School   Regular School No Elementary KG 05 2017   k_12_total 248.0 8.0 154.0     10.0     1.0   9.0                               248 8 154     10     1   9                        
1706522 OR     school 4111100 1935   Seaside SD 10 411110000162 153 Gearhart Elementary School   Regular School No Elementary KG 05 2017   k_12_total 236.0 1.0 66.0     5.0     3.0   10.0                               236 1 66     5     3   10                        
1706524 OR     school 4111100 1935   Seaside SD 10 411110000163 154 Seaside High School   Regular School No High 09 12 2017   k_12_total 317.0 8.0 99.0     16.0     3.0   4.0                               317 8 99     16     3   4                        
1706707 OR     school 4113080 1936   Warrenton-Hammond SD 30 411308000166 156 Warrenton Grade School   Regular School No Elementary KG 08 2017   k_12_total 597.0 1.0 87.0     5.0     8.0   32.0                               597 1 87     5     8   32                        

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