Data source: Big Local News · About: Big Local

20,594 rows where state = "OR" and year = 2021 sorted by rowid descending

View and edit SQL

grade

year

  • 2021 · 20,594
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
658250 OR     school 4113650 1997   Yoncalla SD 32 411365000320 300 Yoncalla High School   Regular School No High 09 12 2021   k_12_total 86 1 10   3 1     0   14                               86 1 10   3 1     0   14                        
658249 OR     school 4113650 1997   Yoncalla SD 32 411365000319 299 Yoncalla Elementary School   Regular School No Elementary KG 08 2021   k_12_total 113 0 16   0 0     0   4                               113 0 16   0 0     0   4                        
658248 OR     school 4100016 2251   Yamhill Carlton SD 1   2251 Yamhill Carlton SD 1             2021   k_12_total 237 2 6   1 1     0   3                               237 2 6   1 1     0   3                        
658247 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601730 4564 Yamhill Carlton Intermediate School   Regular School No Middle 04 08 2021   k_12_total 238 2 25   0 1     0   12                               238 2 25   0 1     0   12                        
658246 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601288 1238 Yamhill Carlton High School   Regular School No High 09 12 2021   k_12_total 231 2 33   0 3     2   12                               231 2 33   0 3     2   12                        
658245 OR     school 4100016 2251   Yamhill Carlton SD 1 410001601266 1213 Yamhill Carlton Elementary School   Regular School No Elementary KG 03 2021   k_12_total 187 0 34   0 0     0   8                               187 0 34   0 0     0   8                        
658244 OR     school 4113530 2146   Woodburn SD 103 411353001715 4544 Woodburn Success   Regular School No High 07 12 2021   k_12_total 4 0 30   0 0     0   1                               4 0 30   0 0     0   1                        
658243 OR     school 4113530 2146   Woodburn SD 103   2146 Woodburn SD 103             2021   k_12_total 1 0 20   0 0     0   0                               1 0 20   0 0     0   0                        
658242 OR     school 4113530 2146   Woodburn SD 103 411353001723 4543 Woodburn Arts and Communications Academy   Regular School No High 09 12 2021   k_12_total 51 4 338   0 1     2   2                               51 4 338   0 1     2   2                        
658241 OR     school 4113530 2146   Woodburn SD 103 411353001546 4230 Woodburn Arthur Academy   Regular School Yes Elementary KG 05 2021   k_12_total 39 0 119   0 1     0   5                               39 0 119   0 1     0   5                        
658240 OR     school 4113530 2146   Woodburn SD 103 411353001713 4542 Woodburn Academy of Art, Science and Technology   Regular School No High 09 12 2021   k_12_total 63 0 382   0 4     1   5                               63 0 382   0 4     1   5                        
658239 OR     school 4113530 2146   Woodburn SD 103 411353001731 4541 Wellness, Business and Sports School   Regular School No High 09 12 2021   k_12_total 73 0 363   0 0     3   3                               73 0 363   0 0     3   3                        
658238 OR     school 4113530 2146   Woodburn SD 103 411353000842 797 Washington Elementary School   Regular School No Elementary KG 05 2021   k_12_total 1 0 490   0 0     0   1                               1 0 490   0 0     0   1                        
658237 OR     school 4113530 2146   Woodburn SD 103 411353001052 1360 Valor Middle School   Regular School No Middle 06 08 2021   k_12_total 117 1 520   1 4     1   3                               117 1 520   1 4     1   3                        
658236 OR     school 4113530 2146   Woodburn SD 103 411353000841 796 Nellie Muir Elementary School   Regular School No Elementary KG 05 2021   k_12_total 27 3 377   0 3     0   4                               27 3 377   0 3     0   4                        
658235 OR     school 4113530 2146   Woodburn SD 103 411353000843 1267 Lincoln Elementary School   Regular School No Elementary KG 05 2021   k_12_total 57 2 553   0 2     3   6                               57 2 553   0 2     3   6                        
658234 OR     school 4113530 2146   Woodburn SD 103 411353001051 1359 Heritage Elementary   Regular School No Elementary KG 05 2021   k_12_total 149 2 508   1 4     0   8                               149 2 508   1 4     0   8                        
658233 OR     school 4113530 2146   Woodburn SD 103 411353000844 1268 French Prairie Middle School   Regular School No Middle 06 08 2021   k_12_total 61 4 604   2 3     1   3                               61 4 604   2 3     1   3                        
658232 OR     school 4113530 2146   Woodburn SD 103 411353001714 4540 Academy of International Studies (at Woodburn)   Regular School No High 09 12 2021   k_12_total 15 1 300   1 0     0   5                               15 1 300   1 0     0   5                        
658231 OR     school 4113490 2002   Winston-Dillard SD 116 411349000335 315 Winston Middle School   Regular School No Middle 07 08 2021   k_12_total 177 1 22   5 0     0   17                               177 1 22   5 0     0   17                        
658230 OR     school 4113490 2002   Winston-Dillard SD 116 411349000331 311 McGovern Elementary School   Regular School No Middle 04 06 2021   k_12_total 163 1 18   6 0     0   18                               163 1 18   6 0     0   18                        
658229 OR     school 4113490 2002   Winston-Dillard SD 116 411349000333 313 Lookingglass Elementary School   Regular School No Elementary KG 06 2021   k_12_total 141 0 7   3 0     0   8                               141 0 7   3 0     0   8                        
658228 OR     school 4113490 2002   Winston-Dillard SD 116 411349000336 316 Douglas High School   Regular School No High 09 12 2021   k_12_total 311 0 37   10 1     0   27                               311 0 37   10 1     0   27                        
658227 OR     school 4113490 2002   Winston-Dillard SD 116 411349001828 5201 Dillard Alternative High School   Alternative School No High 09 12 2021   k_12_total 41 0 4   2 0     2   6                               41 0 4   2 0     2   6                        
658226 OR     school 4113490 2002   Winston-Dillard SD 116 411349001573 3624 Brockway Elementary School   Regular School No Elementary KG 03 2021   k_12_total 283 2 22   2 1     1   24                               283 2 22   2 1     1   24                        
658225 OR     school 4113350 2255   Willamina SD 30J 411335001338 1225 Willamina Middle School   Regular School No Middle 06 08 2021   k_12_total 113 2 22   58 0     0   13                               113 2 22   58 0     0   13                        
658224 OR     school 4113350 2255   Willamina SD 30J 411335001277 1226 Willamina High School   Regular School No High 09 12 2021   k_12_total 168 1 33   57 0     1   3                               168 1 33   57 0     1   3                        
658223 OR     school 4113350 2255   Willamina SD 30J 411335001276 1224 Willamina Elementary School   Regular School No Elementary KG 05 2021   k_12_total 227 0 27   69 1     4   45                               227 0 27   69 1     4   45                        
658222 OR     school   2117   Willamette ESD   2117 Willamette ESD             2021   k_12_total 20 0 1   1 0     0   7                               20 0 1   1 0     0   7                        
658221 OR     school   2117   Willamette ESD   2334 Oregon State Hospital Salem (educational program)             2021   k_12_total 1 0 1   0 0     0   1                               1 0 1   0 0     0   1                        
658220 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2021   k_12_total 807 12 227   5 53     9   99                               807 12 227   5 53     9   99                        
658219 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001377 1286 Willamette Primary School   Regular School No Elementary PK 05 2021   k_12_total 369 3 37   1 12     2   44                               369 3 37   1 12     2   44                        
658218 OR     school 4113170 1922   West Linn-Wilsonville SD 3J   1922 West Linn-Wilsonville SD 3J             2021   k_12_total - - -   - -     -   -                                                                            
658217 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2021   k_12_total 1496 17 131   6 103     6   128                               1496 17 131   6 103     6   128                        
658216 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001825 5057 Trillium Creek Primary School   Regular School No Elementary PK 05 2021   k_12_total 367 4 29   1 27     3   70                               367 4 29   1 27     3   70                        
658215 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001437 3452 Three Rivers Charter School   Regular School Yes Middle 04 08 2021   k_12_total 67 0 7   0 23     0   14                               67 0 7   0 23     0   14                        
658214 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000055 48 Sunset Primary School   Regular School No Elementary PK 05 2021   k_12_total 248 3 32   0 13     2   53                               248 3 32   0 13     2   53                        
658213 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000054 47 Stafford Primary School   Regular School No Elementary PK 05 2021   k_12_total 302 0 9   0 13     0   26                               302 0 9   0 13     0   26                        
658212 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001414 2787 Rosemont Ridge Middle School   Regular School No Middle 06 08 2021   k_12_total 538 5 52   3 34     0   77                               538 5 52   3 34     0   77                        
658211 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001851 5377 Meridian Creek Middle School   Regular School No Middle 06 08 2021   k_12_total 277 7 57   2 25     3   28                               277 7 57   2 25     3   28                        
658210 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001822 5056 Lowrie Primary School   Regular School No Elementary PK 05 2021   k_12_total 282 4 129   0 25     0   48                               282 4 129   0 25     0   48                        
658209 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001318 46 Inza R Wood Middle School   Regular School No Middle 06 08 2021   k_12_total 319 3 139   4 18     6   37                               319 3 139   4 18     6   37                        
658208 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000053 45 Cedaroak Park Primary School   Regular School No Elementary PK 05 2021   k_12_total 215 1 18   0 4     2   28                               215 1 18   0 4     2   28                        
658207 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001575 3913 Boones Ferry Primary School   Regular School No Elementary PK 05 2021   k_12_total 325 4 121   0 15     7   48                               325 4 121   0 15     7   48                        
658206 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001447 3455 Bolton Primary School   Regular School No Elementary PK 05 2021   k_12_total 239 0 19   0 10     0   26                               239 0 19   0 10     0   26                        
658205 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001356 1272 Boeckman Creek Primary School   Regular School No Elementary PK 05 2021   k_12_total 300 3 92   0 14     5   47                               300 3 92   0 14     5   47                        
658204 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000056 1287 Athey Creek Middle School   Regular School No Middle 06 08 2021   k_12_total 534 4 42   2 22     0   61                               534 4 42   2 22     0   61                        
658203 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001786 4773 Arts and Technology High School   Alternative School No High 09 12 2021   k_12_total 53 0 19   0 3     1   9                               53 0 19   0 3     1   9                        
658202 OR     school 4113080 1936   Warrenton-Hammond SD 30 411308000167 157 Warrenton High School   Regular School No High 09 12 2021   k_12_total 204 0 41   1 1     1   15                               204 0 41   1 1     1   15                        
658201 OR     school 4113080 1936   Warrenton-Hammond SD 30 411308000166 156 Warrenton Grade School   Regular School No Elementary KG 08 2021   k_12_total 503 0 114   5 4     8   48                               503 0 114   5 4     8   48                        
658200 OR     school 4112990 2220   Wallowa SD 12 411299001147 1089 Wallowa High School   Regular School No High 07 12 2021   k_12_total 91 0 9   0 0     0   5                               91 0 9   0 0     0   5                        
658199 OR     school 4112990 2220   Wallowa SD 12 411299001371 1088 Wallowa Elementary School   Regular School No Elementary PK 06 2021   k_12_total 73 0 8   1 0     0   2                               73 0 8   1 0     0   2                        
658198 OR     school 4112930 1947   Vernonia SD 47J 411293001673 4396 Vernonia Middle School   Regular School No Middle 06 08 2021   k_12_total 128 0 10   1 1     0   3                               128 0 10   1 1     0   3                        
658197 OR     school 4112930 1947   Vernonia SD 47J 411293000188 178 Vernonia High School   Regular School No High 09 12 2021   k_12_total 144 1 11   1 3     0   7                               144 1 11   1 3     0   7                        
658196 OR     school 4112930 1947   Vernonia SD 47J 411293000187 177 Vernonia Elementary School   Regular School No Elementary KG 05 2021   k_12_total 167 0 22   2 0     1   16                               167 0 22   2 0     1   16                        
658195 OR     school 4112930 1947   Vernonia SD 47J 411293000186 176 Mist Elementary School   Regular School No Elementary KG 05 2021   k_12_total 12 0 1   2 1     1   1                               12 0 1   2 1     1   1                        
658194 OR     school 4100014 2116   Vale SD 84 410001400754 706 Willowcreek Elementary School   Regular School No Elementary 01 08 2021   k_12_total 68 0 3   0 2     0   0                               68 0 3   0 2     0   0                        
658193 OR     school 4100014 2116   Vale SD 84   2116 Vale SD 84             2021   k_12_total 25 0 4   3 0     1   0                               25 0 4   3 0     1   0                        
658192 OR     school 4100014 2116   Vale SD 84 410001401026 1357 Vale Middle School   Regular School No Middle 07 08 2021   k_12_total 74 0 33   0 2     0   2                               74 0 33   0 2     0   2                        
658191 OR     school 4100014 2116   Vale SD 84 410001400761 713 Vale High School   Regular School No High 09 12 2021   k_12_total 195 0 46   0 4     1   1                               195 0 46   0 4     1   1                        
658190 OR     school 4100014 2116   Vale SD 84 410001400748 701 Vale Elementary School   Regular School No Elementary KG 06 2021   k_12_total 239 0 105   1 1     0   9                               239 0 105   1 1     0   9                        
658189 OR     school 4112690 2213   Union SD 5 411269001133 1075 Union High School   Regular School No High 07 12 2021   k_12_total 145 1 3   1 0     0   4                               145 1 3   1 0     0   4                        
658188 OR     school 4112690 2213   Union SD 5 411269001132 1074 Union Elementary School   Regular School No Elementary KG 06 2021   k_12_total 151 0 9   2 0     0   10                               151 0 9   2 0     0   10                        
658187 OR     school 4112600 2204   Umatilla SD 6R 411260001092 1033 Umatilla High School   Regular School No High 09 12 2021   k_12_total 110 1 310   2 3     0   3                               110 1 310   2 3     0   3                        
658186 OR     school 4112600 2204   Umatilla SD 6R 411260001091 1032 McNary Heights Elementary School   Regular School No Elementary KG 05 2021   k_12_total 170 0 472   2 0     1   6                               170 0 472   2 0     1   6                        
658185 OR     school 4112600 2204   Umatilla SD 6R 411260001090 1031 Clara Brownell Middle School   Regular School No Middle 06 08 2021   k_12_total 96 0 253   4 1     0   6                               96 0 253   4 1     0   6                        
658184 OR     school 4112540 2210   Ukiah SD 80R 411254001122 3432 Ukiah School   Regular School No Other KG 12 2021   k_12_total 22 0 5   0 0     1   0                               22 0 5   0 0     1   0                        
658183 OR     school 4112360 2222   Troy SD 54 411236001150 1092 Troy Elementary School   Regular School No Elementary KG 08 2021   k_12_total 1 0 0   0 0     0   2                               1 0 0   0 0     0   2                        
658182 OR     school 4112320 2197   Tillamook SD 9 411232001074 1016 Tillamook Junior High School   Regular School No Middle 07 08 2021   k_12_total 230 1 86   5 4     2   16                               230 1 86   5 4     2   16                        
658181 OR     school 4112320 2197   Tillamook SD 9 411232001075 1017 Tillamook High School   Regular School No High 09 12 2021   k_12_total 434 1 213   10 5     7   27                               434 1 213   10 5     7   27                        
658180 OR     school 4112320 2197   Tillamook SD 9 411232001072 1014 South Prairie Elementary School   Regular School No Elementary 02 03 2021   k_12_total 167 0 98   2 3     1   17                               167 0 98   2 3     1   17                        
658179 OR     school 4112320 2197   Tillamook SD 9 411232001071 1013 Liberty Elementary School   Regular School No Elementary KG 01 2021   k_12_total 186 1 81   2 1     0   4                               186 1 81   2 1     0   4                        
658178 OR     school 4112320 2197   Tillamook SD 9 411232001070 1012 East Elementary School   Regular School No Middle 04 06 2021   k_12_total 299 1 137   3 2     1   29                               299 1 137   3 2     1   29                        
658177 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001197 1145 Twality Middle School   Regular School No Middle 06 08 2021   k_12_total 558 24 259   6 63     22   85                               558 24 259   6 63     22   85                        
658176 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000440 1301 Tualatin High School   Regular School No High 09 12 2021   k_12_total 988 27 538   9 118     46   140                               988 27 538   9 118     46   140                        
658175 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001195 1143 Tualatin Elementary School   Regular School No Elementary KG 05 2021   k_12_total 196 3 164   1 10     9   24                               196 3 164   1 10     9   24                        
658174 OR     school 4112240 2242   Tigard-Tualatin SD 23J   2242 Tigard-Tualatin SD 23J             2021   k_12_total 43 5 16   0 5     0   8                               43 5 16   0 5     0   8                        
658173 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001198 1146 Tigard High School   Regular School No High 09 12 2021   k_12_total 1049 32 427   11 102     32   129                               1049 32 427   11 102     32   129                        
658172 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001196 1144 Thomas R Fowler Middle School   Regular School No Middle 06 08 2021   k_12_total 463 17 236   0 41     18   64                               463 17 236   0 41     18   64                        
658171 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224004176 3579 Multi-sensory Instruction Teaching Children Hands-On (MITCH)   Regular School Yes Elementary KG 08 2021   k_12_total 147 1 31   0 17     0   24                               147 1 31   0 17     0   24                        
658170 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001193 1140 Metzger Elementary School   Regular School No Elementary KG 05 2021   k_12_total 257 18 190   2 14     19   39                               257 18 190   2 14     19   39                        
658169 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001299 1137 Mary Woodward Elementary School   Regular School No Elementary KG 05 2021   k_12_total 330 7 87   0 47     0   53                               330 7 87   0 47     0   53                        
658168 OR     school 4112240 2242   Tigard-Tualatin SD 23J   2273 Janus Youth Programs--Cordero House             2021   k_12_total 9 0 2   0 0     0   0                               9 0 2   0 0     0   0                        
658167 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001192 1139 James Templeton Elementary School   Regular School No Elementary KG 05 2021   k_12_total 264 16 145   0 13     15   51                               264 16 145   0 13     15   51                        
658166 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224000381 1300 Hazelbrook Middle School   Regular School No Middle 06 08 2021   k_12_total 476 10 318   5 21     23   72                               476 10 318   5 21     23   72                        
658165 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001298 1142 Edward Byrom Elementary School   Regular School No Elementary KG 05 2021   k_12_total 281 11 85   0 8     8   33                               281 11 85   0 8     8   33                        
658164 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001191 1138 Durham Elementary School   Regular School No Elementary KG 05 2021   k_12_total 292 11 135   3 23     16   47                               292 11 135   3 23     16   47                        
658163 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001261 1369 Deer Creek Elementary School   Regular School No Elementary KG 05 2021   k_12_total 230 20 171   0 34     12   71                               230 20 171   0 34     12   71                        
658162 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001722 2714 Creekside Community High School   Alternative School No High 06 12 2021   k_12_total 87 1 56   1 0     10   15                               87 1 56   1 0     10   15                        
658161 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001190 1136 Charles F Tigard Elementary School   Regular School No Elementary KG 05 2021   k_12_total 246 5 136   0 18     16   40                               246 5 136   0 18     16   40                        
658160 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001331 1135 Bridgeport Elementary School   Regular School No Elementary KG 05 2021   k_12_total 218 3 232   1 15     14   42                               218 3 232   1 15     14   42                        
658159 OR     school 4112240 2242   Tigard-Tualatin SD 23J 411224001668 4364 Alberta Rider Elementary School   Regular School No Elementary KG 05 2021   k_12_total 251 23 110   0 61     5   51                               251 23 110   0 61     5   51                        
658158 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690001812 5063 Woodland Charter School   Regular School Yes Elementary 01 08 2021   k_12_total 150 2 8   0 0     0   5                               150 2 8   0 0     0   5                        
658157 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000477 453 Williams Elementary School   Regular School No Elementary KG 05 2021   k_12_total 53 0 6   3 0     0   4                               53 0 6   3 0     0   4                        
658156 OR     school 4106900 2055   Three Rivers/Josephine County SD   2055 Three Rivers/Josephine County SD             2021   k_12_total - - -   - -     -   -                                                                            
658155 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690001797 4823 Sunny Wolf Charter School   Regular School Yes Elementary PK 06 2021   k_12_total 99 0 8   1 0     0   9                               99 0 8   1 0     0   9                        
658154 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690001888 5505 Southern Oregon Success Academy   Regular School Yes High 06 12 2021   k_12_total 84 1 18   1 0     2   13                               84 1 18   1 0     2   13                        
658153 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000481 457 North Valley High School   Regular School No High 09 12 2021   k_12_total 370 0 41   5 2     0   47                               370 0 41   5 2     0   47                        
658152 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000473 451 Manzanita Elementary School   Regular School No Elementary KG 05 2021   k_12_total 276 0 42   2 1     0   19                               276 0 42   2 1     0   19                        
658151 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690000472 450 Madrona Elementary School   Regular School No Elementary KG 05 2021   k_12_total 220 0 30   3 0     1   20                               220 0 30   3 0     1   20                        

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