Data source: Big Local News · About: Big Local

20,426 rows where state = "OR" and year = 2020 sorted by rowid descending

View and edit SQL

grade

year

  • 2020 · 20,426
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
918096 OR     school 4113650 1997   Yoncalla SD 32 411365000320 300 Yoncalla High School   Regular School No High 09 12 2020   k_12_total 91 0 16   3 2     0   14                               91 0 16   3 2     0   14                        
918095 OR     school 4113650 1997   Yoncalla SD 32 411365000319 299 Yoncalla Elementary School   Regular School No Elementary KG 08 2020   k_12_total 110 1 17   1 0     0   10                               110 1 17   1 0     0   10                        
918094 OR     school 4100016 2251   Yamhill Carlton SD 1   2251 Yamhill Carlton SD 1             2020   k_12_total 89 1 1   1 1     0   1                               89 1 1   1 1     0   1                        
918093 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 05 08 2020   k_12_total 261 3 26   0 4     0   9                               261 3 26   0 4     0   9                        
918092 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2020   k_12_total 245 1 32   0 0     1   16                               245 1 32   0 0     1   16                        
918091 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 04 2020   k_12_total 302 3 35   0 0     0   20                               302 3 35   0 0     0   20                        
918090 OR     school 4113530 2146   Woodburn SD 103 411353001715 4544 Woodburn Success   Regular School No High 07 12 2020   k_12_total 7 0 68   0 0     0   0                               7 0 68   0 0     0   0                        
918089 OR     school 4113530 2146   Woodburn SD 103   2146 Woodburn SD 103             2020   k_12_total 1 0 12   0 0     0   0                               1 0 12   0 0     0   0                        
918088 OR     school 4113530 2146   Woodburn SD 103 411353001723 4543 Woodburn Arts and Communications Academy   Regular School No High 09 12 2020   k_12_total 53 3 315   0 1     1   3                               53 3 315   0 1     1   3                        
918087 OR     school 4113530 2146   Woodburn SD 103 411353001546 4230 Woodburn Arthur Academy   Regular School Yes Elementary KG 05 2020   k_12_total 54 0 113   0 1     0   4                               54 0 113   0 1     0   4                        
918086 OR     school 4113530 2146   Woodburn SD 103 411353001713 4542 Woodburn Academy of Art, Science and Technology   Regular School No High 09 12 2020   k_12_total 74 1 349   1 3     1   5                               74 1 349   1 3     1   5                        
918085 OR     school 4113530 2146   Woodburn SD 103 411353001731 4541 Wellness, Business and Sports School   Regular School No High 09 12 2020   k_12_total 79 1 325   0 0     1   5                               79 1 325   0 0     1   5                        
918084 OR     school 4113530 2146   Woodburn SD 103 411353000842 797 Washington Elementary School   Regular School No Elementary KG 05 2020   k_12_total 2 0 540   0 0     0   1                               2 0 540   0 0     0   1                        
918083 OR     school 4113530 2146   Woodburn SD 103 411353001052 1360 Valor Middle School   Regular School No Middle 06 08 2020   k_12_total 129 1 555   1 3     0   7                               129 1 555   1 3     0   7                        
918082 OR     school 4113530 2146   Woodburn SD 103 411353000841 796 Nellie Muir Elementary School   Regular School No Elementary KG 05 2020   k_12_total 36 0 363   1 5     1   4                               36 0 363   1 5     1   4                        
918081 OR     school 4113530 2146   Woodburn SD 103 411353000843 1267 Lincoln Elementary School   Regular School No Elementary KG 05 2020   k_12_total 79 1 589   0 2     6   8                               79 1 589   0 2     6   8                        
918080 OR     school 4113530 2146   Woodburn SD 103 411353001051 1359 Heritage Elementary   Regular School No Elementary KG 05 2020   k_12_total 256 2 539   1 3     0   7                               256 2 539   1 3     0   7                        
918079 OR     school 4113530 2146   Woodburn SD 103 411353000844 1268 French Prairie Middle School   Regular School No Middle 06 08 2020   k_12_total 56 3 623   2 3     3   2                               56 3 623   2 3     3   2                        
918078 OR     school 4113530 2146   Woodburn SD 103 411353001714 4540 Academy of International Studies (at Woodburn)   Regular School No High 09 12 2020   k_12_total 13 1 294   0 1     0   4                               13 1 294   0 1     0   4                        
918077 OR     school 4113490 2002   Winston-Dillard SD 116 411349000335 315 Winston Middle School   Regular School No Middle 07 08 2020   k_12_total 193 0 16   6 0     0   14                               193 0 16   6 0     0   14                        
918076 OR     school 4113490 2002   Winston-Dillard SD 116 411349000331 311 McGovern Elementary School   Regular School No Middle 04 06 2020   k_12_total 193 1 27   7 0     0   13                               193 1 27   7 0     0   13                        
918075 OR     school 4113490 2002   Winston-Dillard SD 116 411349000333 313 Lookingglass Elementary School   Regular School No Elementary KG 06 2020   k_12_total 166 0 8   3 0     0   10                               166 0 8   3 0     0   10                        
918074 OR     school 4113490 2002   Winston-Dillard SD 116 411349000336 316 Douglas High School   Regular School No High 09 12 2020   k_12_total 316 1 28   6 1     3   23                               316 1 28   6 1     3   23                        
918073 OR     school 4113490 2002   Winston-Dillard SD 116 411349001828 5201 Dillard Alternative High School   Alternative School No High 09 12 2020   k_12_total 19 0 2   0 0     0   2                               19 0 2   0 0     0   2                        
918072 OR     school 4113490 2002   Winston-Dillard SD 116 411349001573 3624 Brockway Elementary School   Regular School No Elementary KG 03 2020   k_12_total 279 3 25   4 1     1   22                               279 3 25   4 1     1   22                        
918071 OR     school 4113350 2255   Willamina SD 30J 411335001338 1225 Willamina Middle School   Regular School No Middle 06 08 2020   k_12_total 139 0 19   58 0     1   2                               139 0 19   58 0     1   2                        
918070 OR     school 4113350 2255   Willamina SD 30J 411335001277 1226 Willamina High School   Regular School No High 09 12 2020   k_12_total 156 1 38   66 0     0   5                               156 1 38   66 0     0   5                        
918069 OR     school 4113350 2255   Willamina SD 30J 411335001276 1224 Willamina Elementary School   Regular School No Elementary KG 05 2020   k_12_total 227 0 26   86 2     4   46                               227 0 26   86 2     4   46                        
918068 OR     school   2117   Willamette ESD   2117 Willamette ESD             2020   k_12_total 19 0 2   1 0     0   6                               19 0 2   1 0     0   6                        
918067 OR     school   2117   Willamette ESD   2334 Oregon State Hospital Salem (educational program)             2020   k_12_total 8 0 3   0 0     1   2                               8 0 3   0 0     1   2                        
918066 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2020   k_12_total 818 11 224   6 54     9   85                               818 11 224   6 54     9   85                        
918065 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001377 1286 Willamette Primary School   Regular School No Elementary PK 05 2020   k_12_total 391 4 29   0 8     2   44                               391 4 29   0 8     2   44                        
918064 OR     school 4113170 1922   West Linn-Wilsonville SD 3J   1922 West Linn-Wilsonville SD 3J             2020   k_12_total 4 0 0   0 0     0   3                               4 0 0   0 0     0   3                        
918063 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2020   k_12_total 1503 22 102   4 101     5   140                               1503 22 102   4 101     5   140                        
918062 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001825 5057 Trillium Creek Primary School   Regular School No Elementary PK 05 2020   k_12_total 422 3 28   0 25     0   67                               422 3 28   0 25     0   67                        
918061 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001437 3452 Three Rivers Charter School   Regular School Yes Middle 04 08 2020   k_12_total 63 0 5   0 27     0   13                               63 0 5   0 27     0   13                        
918060 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000055 48 Sunset Primary School   Regular School No Elementary PK 05 2020   k_12_total 296 2 29   0 13     2   49                               296 2 29   0 13     2   49                        
918059 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000054 47 Stafford Primary School   Regular School No Elementary PK 05 2020   k_12_total 376 0 13   0 18     0   30                               376 0 13   0 18     0   30                        
918058 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001414 2787 Rosemont Ridge Middle School   Regular School No Middle 06 08 2020   k_12_total 578 7 49   4 37     0   68                               578 7 49   4 37     0   68                        
918057 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001851 5377 Meridian Creek Middle School   Regular School No Middle 06 08 2020   k_12_total 295 3 65   2 19     3   28                               295 3 65   2 19     3   28                        
918056 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001822 5056 Lowrie Primary School   Regular School No Elementary PK 05 2020   k_12_total 319 3 136   1 28     0   45                               319 3 136   1 28     0   45                        
918055 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001318 46 Inza R Wood Middle School   Regular School No Middle 06 08 2020   k_12_total 333 4 135   4 20     2   40                               333 4 135   4 20     2   40                        
918054 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000053 45 Cedaroak Park Primary School   Regular School No Elementary PK 05 2020   k_12_total 226 2 13   0 7     0   29                               226 2 13   0 7     0   29                        
918053 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001575 3913 Boones Ferry Primary School   Regular School No Elementary PK 05 2020   k_12_total 412 4 112   1 16     10   50                               412 4 112   1 16     10   50                        
918052 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001447 3455 Bolton Primary School   Regular School No Elementary PK 05 2020   k_12_total 284 3 14   0 11     0   22                               284 3 14   0 11     0   22                        
918051 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001356 1272 Boeckman Creek Primary School   Regular School No Elementary PK 05 2020   k_12_total 377 4 96   0 22     5   40                               377 4 96   0 22     5   40                        
918050 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000056 1287 Athey Creek Middle School   Regular School No Middle 06 08 2020   k_12_total 541 6 50   2 27     2   57                               541 6 50   2 27     2   57                        
918049 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001786 4773 Arts and Technology High School   Alternative School No High 09 12 2020   k_12_total 55 0 18   0 0     1   5                               55 0 18   0 0     1   5                        
918048 OR     school 4113080 1936   Warrenton-Hammond SD 30 411308000167 157 Warrenton High School   Regular School No High 09 12 2020   k_12_total 208 0 34   1 5     1   11                               208 0 34   1 5     1   11                        
918047 OR     school 4113080 1936   Warrenton-Hammond SD 30 411308000166 156 Warrenton Grade School   Regular School No Elementary KG 08 2020   k_12_total 594 1 106   8 4     6   49                               594 1 106   8 4     6   49                        
918046 OR     school 4112990 2220   Wallowa SD 12 411299001147 1089 Wallowa High School   Regular School No High 07 12 2020   k_12_total 92 0 7   0 0     1   4                               92 0 7   0 0     1   4                        
918045 OR     school 4112990 2220   Wallowa SD 12 411299001371 1088 Wallowa Elementary School   Regular School No Elementary PK 06 2020   k_12_total 79 0 5   1 0     0   2                               79 0 5   1 0     0   2                        
918044 OR     school 4112930 1947   Vernonia SD 47J 411293001673 4396 Vernonia Middle School   Regular School No Middle 06 08 2020   k_12_total 120 0 10   3 2     0   3                               120 0 10   3 2     0   3                        
918043 OR     school 4112930 1947   Vernonia SD 47J 411293000188 178 Vernonia High School   Regular School No High 09 12 2020   k_12_total 157 1 12   3 5     0   6                               157 1 12   3 5     0   6                        
918042 OR     school 4112930 1947   Vernonia SD 47J 411293000187 177 Vernonia Elementary School   Regular School No Elementary KG 05 2020   k_12_total 174 0 22   1 0     1   11                               174 0 22   1 0     1   11                        
918041 OR     school 4112930 1947   Vernonia SD 47J 411293000186 176 Mist Elementary School   Regular School No Elementary KG 05 2020   k_12_total 35 0 2   2 1     1   1                               35 0 2   2 1     1   1                        
918040 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2020   k_12_total 92 0 1   0 2     0   0                               92 0 1   0 2     0   0                        
918039 OR     school 4100014 2116   Vale SD 84   2116 Vale SD 84             2020   k_12_total 8 0 2   0 0     1   1                               8 0 2   0 0     1   1                        
918038 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2020   k_12_total 87 0 29   1 2     1   0                               87 0 29   1 2     1   0                        
918037 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2020   k_12_total 206 0 54   0 3     2   3                               206 0 54   0 3     2   3                        
918036 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2020   k_12_total 283 0 111   4 2     0   11                               283 0 111   4 2     0   11                        
918035 OR     school 4112690 2213   Union SD 5 411269001133 1075 Union High School   Regular School No High 07 12 2020   k_12_total 167 2 6   3 0     0   1                               167 2 6   3 0     0   1                        
918034 OR     school 4112690 2213   Union SD 5 411269001132 1074 Union Elementary School   Regular School No Elementary KG 06 2020   k_12_total 174 0 10   2 0     0   8                               174 0 10   2 0     0   8                        
918033 OR     school 4112600 2204   Umatilla SD 6R 411260001092 1033 Umatilla High School   Regular School No High 09 12 2020   k_12_total 114 4 279   3 2     0   2                               114 4 279   3 2     0   2                        
918032 OR     school 4112600 2204   Umatilla SD 6R 411260001091 1032 McNary Heights Elementary School   Regular School No Elementary KG 05 2020   k_12_total 162 0 478   5 0     0   11                               162 0 478   5 0     0   11                        
918031 OR     school 4112600 2204   Umatilla SD 6R 411260001090 1031 Clara Brownell Middle School   Regular School No Middle 06 08 2020   k_12_total 88 2 269   1 1     0   4                               88 2 269   1 1     0   4                        
918030 OR     school 4112540 2210   Ukiah SD 80R 411254001122 3432 Ukiah School   Regular School No Other KG 12 2020   k_12_total 23 0 4   0 2     0   0                               23 0 4   0 2     0   0                        
918029 OR     school 4112360 2222   Troy SD 54 411236001150 1092 Troy Elementary School   Regular School No Elementary KG 08 2020   k_12_total 1 0 0   0 0     0   2                               1 0 0   0 0     0   2                        
918028 OR     school 4112320 2197   Tillamook SD 9 411232001074 1016 Tillamook Junior High School   Regular School No Middle 07 08 2020   k_12_total 242 0 96   5 3     0   17                               242 0 96   5 3     0   17                        
918027 OR     school 4112320 2197   Tillamook SD 9 411232001075 1017 Tillamook High School   Regular School No High 09 12 2020   k_12_total 437 6 201   9 7     9   31                               437 6 201   9 7     9   31                        
918026 OR     school 4112320 2197   Tillamook SD 9 411232001072 1014 South Prairie Elementary School   Regular School No Elementary 02 03 2020   k_12_total 198 1 94   4 4     1   18                               198 1 94   4 4     1   18                        
918025 OR     school 4112320 2197   Tillamook SD 9 411232001071 1013 Liberty Elementary School   Regular School No Elementary KG 01 2020   k_12_total 224 1 95   4 0     0   13                               224 1 95   4 0     0   13                        
918024 OR     school 4112320 2197   Tillamook SD 9 411232001070 1012 East Elementary School   Regular School No Middle 04 06 2020   k_12_total 348 2 150   2 2     3   32                               348 2 150   2 2     3   32                        
918023 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001197 1145 Twality Middle School   Regular School No Middle 06 08 2020   k_12_total 583 21 274   6 77     29   89                               583 21 274   6 77     29   89                        
918022 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000440 1301 Tualatin High School   Regular School No High 09 12 2020   k_12_total 1105 25 494   10 121     43   146                               1105 25 494   10 121     43   146                        
918021 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001195 1143 Tualatin Elementary School   Regular School No Elementary KG 05 2020   k_12_total 252 2 170   2 7     15   33                               252 2 170   2 7     15   33                        
918020 OR     school 4112240 2242   Tigard-Tualatin SD 23J   2242 Tigard-Tualatin SD 23J             2020   k_12_total 45 4 22   0 4     0   8                               45 4 22   0 4     0   8                        
918019 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001198 1146 Tigard High School   Regular School No High 09 12 2020   k_12_total 1071 35 409   13 107     34   107                               1071 35 409   13 107     34   107                        
918018 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001196 1144 Thomas R Fowler Middle School   Regular School No Middle 06 08 2020   k_12_total 474 13 236   2 45     16   69                               474 13 236   2 45     16   69                        
918017 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224004176 3579 Multi-sensory Instruction Teaching Children Hands-On (MITCH)   Regular School Yes Elementary KG 08 2020   k_12_total 155 1 33   0 15     0   22                               155 1 33   0 15     0   22                        
918016 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001193 1140 Metzger Elementary School   Regular School No Elementary KG 05 2020   k_12_total 304 21 212   1 11     21   43                               304 21 212   1 11     21   43                        
918015 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001299 1137 Mary Woodward Elementary School   Regular School No Elementary KG 05 2020   k_12_total 378 8 87   1 47     0   63                               378 8 87   1 47     0   63                        
918014 OR     school 4112240 2242   Tigard-Tualatin SD 23J   2273 Janus Youth Programs--Cordero House             2020   k_12_total 8 0 2   0 0     0   0                               8 0 2   0 0     0   0                        
918013 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001192 1139 James Templeton Elementary School   Regular School No Elementary KG 05 2020   k_12_total 310 16 141   2 12     18   46                               310 16 141   2 12     18   46                        
918012 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000381 1300 Hazelbrook Middle School   Regular School No Middle 06 08 2020   k_12_total 512 13 335   4 30     29   66                               512 13 335   4 30     29   66                        
918011 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001298 1142 Edward Byrom Elementary School   Regular School No Elementary KG 05 2020   k_12_total 365 10 99   0 10     7   45                               365 10 99   0 10     7   45                        
918010 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001191 1138 Durham Elementary School   Regular School No Elementary KG 05 2020   k_12_total 311 10 142   4 19     27   46                               311 10 142   4 19     27   46                        
918009 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001261 1369 Deer Creek Elementary School   Regular School No Elementary KG 05 2020   k_12_total 268 16 175   0 34     12   67                               268 16 175   0 34     12   67                        
918008 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001722 2714 Creekside Community High School   Alternative School No High 06 12 2020   k_12_total 87 3 69   0 4     7   9                               87 3 69   0 4     7   9                        
918007 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001190 1136 Charles F Tigard Elementary School   Regular School No Elementary KG 05 2020   k_12_total 279 4 126   2 11     16   44                               279 4 126   2 11     16   44                        
918006 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001331 1135 Bridgeport Elementary School   Regular School No Elementary KG 05 2020   k_12_total 255 3 242   0 13     13   43                               255 3 242   0 13     13   43                        
918005 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001668 4364 Alberta Rider Elementary School   Regular School No Elementary KG 05 2020   k_12_total 302 22 101   1 61     1   49                               302 22 101   1 61     1   49                        
918004 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690001812 5063 Woodland Charter School   Regular School Yes Elementary 01 08 2020   k_12_total 150 1 8   1 0     0   6                               150 1 8   1 0     0   6                        
918003 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000477 453 Williams Elementary School   Regular School No Elementary KG 05 2020   k_12_total 64 0 7   2 0     0   8                               64 0 7   2 0     0   8                        
918002 OR     school 4106900 2055   Three Rivers/Josephine County SD   2055 Three Rivers/Josephine County SD             2020   k_12_total 43 0 5   1 0     0   7                               43 0 5   1 0     0   7                        
918001 OR     school 4106900 2055   Three Rivers/Josephine County SD   1877 The Inn Between Educational Program, DBA Inn Sight             2020   k_12_total - - -   - -     -   -                                                                            
918000 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690001797 4823 Sunny Wolf Charter School   Regular School Yes Elementary KG 05 2020   k_12_total 91 0 10   2 0     0   10                               91 0 10   2 0     0   10                        
917999 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000481 457 North Valley High School   Regular School No High 09 12 2020   k_12_total 370 0 45   5 1     0   45                               370 0 45   5 1     0   45                        
917998 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000473 451 Manzanita Elementary School   Regular School No Elementary KG 05 2020   k_12_total 304 1 43   3 1     0   21                               304 1 43   3 1     0   21                        
917997 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000472 450 Madrona Elementary School   Regular School No Elementary KG 05 2020   k_12_total 271 0 30   4 1     0   22                               271 0 30   4 1     0   22                        

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