Data source: Big Local News · About: Big Local

2,037 rows where grade = "grade_6" and state = "ID" sorted by white_int descending

View and edit SQL

year

grade

  • grade_6 · 2,037
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
706515 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249001094 1390 IDAHO HOME LEARNING ACADEMY   Regular School No Other PK 10 2021   grade_6 594 4 62   5 4     2   0   373 298             *         671 594 4 62   5 4     2   0   373 298                 671
851314 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001061 1358 RIGBY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 446 1 69   0 1     1   6   262 262             187         524 446 1 69   0 1     1   6   262 262         187       524
1307709 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001061 1358 RIGBY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 445 1 46   1 4     1   10   267 241             203         508 445 1 46   1 4     1   10   267 241         203       508
1278838 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001061 1358 RIGBY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 428 1 48   2 0     0   5   233 251             208         484 428 1 48   2 0     0   5   233 251         208       484
1681902 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 390 7 46   5 19     5   23   259 236             137         495 390 7 46   5 19     5   23   259 236         137       495
1276772 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 389 6 40   4 7     2   19   237 230             66         467 389 6 40   4 7     2   19   237 230         66       467
1820932 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 378 9 66   3 9     2   23   246 244             114         490 378 9 66   3 9     2   23   246 244         114       490
1728894 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Elementary 04 6.0 2017   grade_6 377 4 33   2 2     3   4   202 223             *         425 377 4 33   2 2     3   4   202 223                 425
851907 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2020   grade_6 375 2 29   1 2     2   0   214 197             *         411 375 2 29   1 2     2   0   214 197                 411
1279434 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 6.0 2018   grade_6 371 4 26   0 3     0   2   199 207             169         406 371 4 26   0 3     0   2   199 207         169       406
1725914 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 366 3 30   2 11     1   8   195 226             74         421 366 3 30   2 11     1   8   195 226         74       421
1728304 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001061 1358 RIGBY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 366 0 55   2 1     0   12   213 223             177         436 366 0 55   2 1     0   12   213 223         177       436
1823879 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No 2.0 04 06 2016   grade_6 366 2 26   3 5     2   3   208 199             176         407 366 2 26   3 5     2   3   208 199         176       407
1726235 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 361 1 34   1 13     1   20   199 232             59         431 361 1 34   1 13     1   20   199 232         59       431
1305634 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 356 2 33   1 13     1   20   234 192             52         426 356 2 33   1 13     1   20   234 192         52       426
1308304 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 6.0 2019   grade_6 351 3 26   1 3     2   2   199 189             *         388 351 3 26   1 3     2   2   199 189                 388
706256 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 06 2021   grade_6 350 2 38   1 0     3   1   209 186             143         395 350 2 38   1 0     3   1   209 186         143       395
1276462 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 341 1 34   3 4     4   8   210 185             68         395 341 1 34   3 4     4   8   210 185         68       395
1684244 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001061 1358 RIGBY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 339 3 43   3 0     1   6   200 195             179         395 339 3 43   3 0     1   6   200 195         179       395
1823297 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001061 1358 RIGBY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 339 1 51   0 0     0   6   205 192             167         397 339 1 51   0 0     0   6   205 192         167       397
1684833 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No 2.0 04 06 2015   grade_6 338 3 31   3 4     1   0   193 187             152         380 338 3 31   3 4     1   0   193 187         152       380
1682196 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 337 4 37   0 10     0   15   231 172             71         403 337 4 37   0 10     0   15   231 172         71       403
1681893 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 331 2 37   3 7     3   16   215 184             85         399 331 2 37   3 7     3   16   215 184         85       399
848894 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 327 6 72   3 3     3   15   216 213             159         429 327 6 72   3 3     3   15   216 213         159       429
1821233 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 324 6 42   1 8     3   11   211 184             44         395 324 6 42   1 8     3   11   211 184         44       395
849224 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 319 5 36   1 5     2   8   199 177             50         376 319 5 36   1 5     2   8   199 177         50       376
1820923 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 318 1 35   5 5     0   20   195 189             70         384 318 1 35   5 5     0   20   195 189         70       384
1725952 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 303 1 29   0 3     1   10   189 158             68         347 303 1 29   0 3     1   10   189 158         68       347
1820936 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 302 10 52   3 15     1   14   200 197             120         397 302 10 52   3 15     1   14   200 197         120       397
1305304 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 297 8 82   3 8     1   9   216 192             160         408 297 8 82   3 8     1   9   216 192         160       408
1305356 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 297 0 35   1 1     7   19   155 205             44         360 297 0 35   1 1     7   19   155 205         44       360
1820905 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 297 10 36   5 8     2   15   184 189             109         373 297 10 36   5 8     2   15   184 189         109       373
1276500 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 295 1 27   0 5     1   10   184 155             77         339 295 1 27   0 5     1   10   184 155         77       339
1681931 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 294 4 19   2 4     1   13   185 152             78         337 294 4 19   2 4     1   13   185 152         78       337
1820961 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 292 1 21   0 3     1   11   155 174             54         329 292 1 21   0 3     1   11   155 174         54       329
1305300 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 287 14 33   0 12     0   16   199 163             118         362 287 14 33   0 12     0   16   199 163         118       362
1276444 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 281 9 38   0 9     1   17   181 174             130         355 281 9 38   0 9     1   17   181 174         130       355
1681879 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 280 5 53   2 7     3   8   185 173             198         358 280 5 53   2 7     3   8   185 173         198       358
703452 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 279 4 20   1 9     3   14   191 139             41         330 279 4 20   1 9     3   14   191 139         41       330
1681906 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 278 10 41   1 11     0   18   206 153             119         359 278 10 41   1 11     0   18   206 153         119       359
1725927 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 278 9 60   1 21     1   11   188 193             130         381 278 9 60   1 21     1   11   188 193         130       381
1824414 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 278 3 60   3 5     5   3   181 176             170         357 278 3 60   3 5     5   3   181 176         170       357
848946 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 277 0 29   4 4     0   10   177 147             65         324 277 0 29   4 4     0   10   177 147         65       324
848890 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 276 13 28   3 8     2   14   168 176             104         344 276 13 28   3 8     2   14   168 176         104       344
1820909 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 276 6 60   3 8     1   9   188 175             159         363 276 6 60   3 8     1   9   188 175         159       363
848908 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 275 6 21   1 2     1   11   160 157             48         317 275 6 21   1 2     1   11   160 157         48       317
851431 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 275 1 23   2 1     1   16   166 153             *         319 275 1 23   2 1     1   16   166 153                 319
1276448 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 275 5 70   4 7     2   9   196 176             174         372 275 5 70   4 7     2   9   196 176         174       372
1305327 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 272 8 32   6 9     2   14   168 175             108         343 272 8 32   6 9     2   14   168 175         108       343
850625 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000838 582 SAGE VALLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 271 4 166   4 3     2   14   239 225             248         464 271 4 166   4 3     2   14   239 225         248       464
705635 ID     school 1601570 251   JEFFERSON COUNTY JOINT DISTRICT 160157001061 1358 RIGBY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 270 2 23   0 1     1   4   164 137             79         301 270 2 23   0 1     1   4   164 137         79       301
1683473 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 270 1 45   0 1     4   9   182 148             154         330 270 1 45   0 1     4   9   182 148         154       330
1681875 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 268 8 33   3 12     2   14   174 166             133         340 268 8 33   3 12     2   14   174 166         133       340
1725896 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 267 11 33   4 20     2   15   169 183             115         352 267 11 33   4 20     2   15   169 183         115       352
1276471 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 262 8 44   1 6     1   22   169 175             129         344 262 8 44   1 6     1   22   169 175         129       344
1306908 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 262 1 45   1 1     1   6   176 141             121         317 262 1 45   1 1     1   6   176 141         121       317
1307022 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000838 582 SAGE VALLEY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 261 6 153   1 1     0   8   216 214             236         430 261 6 153   1 1     0   8   216 214         236       430
1725900 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 259 5 58   3 4     0   12   178 163             154         341 259 5 58   3 4     0   12   178 163         154       341
1278050 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 258 1 36   1 0     1   6   153 150             134         303 258 1 36   1 0     1   6   153 150         134       303
850510 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 256 2 51   2 0     1   8   166 154             *         320 256 2 51   2 0     1   8   166 154                 320
852180 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249001094 1390 IDAHO HOME LEARNING ACADEMY   Regular School No Elementary KG 08 2020   grade_6 256 2 17   2 5     1   1   139 145             *         284 256 2 17   2 5     1   1   139 145                 284
851585 ID     school 1602670 273   POST FALLS DISTRICT 160267000489 125 POST FALLS MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 255 2 14   3 0     1   7   139 143             139         282 255 2 14   3 0     1   7   139 143         139       282
1727511 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 255 0 52   0 0     1   14   168 154             142         322 255 0 52   0 0     1   14   168 154         142       322
1305616 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 252 3 33   0 9     0   11   171 137             38         308 252 3 33   0 9     0   11   171 137         38       308
1729448 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 251 4 65   0 4     3   4   167 164             *         331 251 4 65   0 4     3   4   167 164                 331
1305318 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 250 6 23   0 3     0   9   147 144             42         291 250 6 23   0 3     0   9   147 144         42       291
849206 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 249 6 28   1 7     0   14   151 154             33         305 249 6 28   1 7     0   14   151 154         33       305
1305638 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 249 1 49   0 1     0   13   161 152             121         313 249 1 49   0 1     0   13   161 152         121       313
703101 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 247 5 69   4 1     1   10   173 164             98         337 247 5 69   4 1     1   10   173 164         98       337
1307802 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 247 4 16   0 2     0   10   158 121             73         279 247 4 16   0 2     0   10   158 121         73       279
848921 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 244 18 56   3 14     1   13   178 171             117         349 244 18 56   3 14     1   13   178 171         117       349
1305331 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 244 13 68   1 9     2   17   182 172             117         354 244 13 68   1 9     2   17   182 172         117       354
704799 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 243 0 35   2 1     0   7   141 147             78         288 243 0 35   2 1     0   7   141 147         78       288
1276475 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 243 14 51   3 15     0   22   178 170             128         348 243 14 51   3 15     0   22   178 170         128       348
1276758 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 241 3 25   4 7     0   16   149 147             *         296 241 3 25   4 7     0   16   149 147                 296
1824410 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 241 4 99   1 13     2   4   183 181             262         364 241 4 99   1 13     2   4   183 181         262       364
703427 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 240 4 23   0 6     0   25   158 140             23         298 240 4 23   0 6     0   25   158 140         23       298
851406 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 240 1 18   1 1     0   5   140 126             *         266 240 1 18   1 1     0   5   140 126                 266
1728398 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 239 1 13   0 1     0   5   139 120             *         259 239 1 13   0 1     0   5   139 120                 259
1278932 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000148 120 CANFIELD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 238 1 17   2 1     0   11   135 135             76         270 238 1 17   2 1     0   11   135 135         76       270
1823414 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 236 0 25   2 1     1   17   151 131             113         282 236 0 25   2 1     1   17   151 131         113       282
705771 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 235 2 24   2 2     0   12   159 118             72         277 235 2 24   2 2     0   12   159 118         72       277
1279966 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 235 9 33   1 2     3   2   139 146             120         285 235 9 33   1 2     3   2   139 146         120       285
852442 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 234 5 36   4 3     1   6   148 141             113         289 234 5 36   4 3     1   6   148 141         113       289
1684513 ID     school 1602670 273   POST FALLS DISTRICT 160267000489 125 POST FALLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 234 6 16   3 0     0   8   135 132             146         267 234 6 16   3 0     0   8   135 132         146       267
1308835 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 233 3 33   0 2     0   6   137 140             103         277 233 3 33   0 2     0   6   137 140         103       277
1822518 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 233 1 33   0 0     1   9   140 137             *         277 233 1 33   0 0     1   9   140 137                 277
1278957 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 232 1 23   1 2     1   13   152 121             99         273 232 1 23   1 2     1   13   152 121         99       273
707128 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12 2021   grade_6 231 1 44   2 0     3   16   159 138             *         297 231 1 44   2 0     3   16   159 138                 297
1307982 ID     school 1602670 273   POST FALLS DISTRICT 160267000489 125 POST FALLS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 229 1 25   4 1     1   9   147 123             121         270 229 1 25   4 1     1   9   147 123         121       270
1684362 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 228 2 21   2 2     0   12   136 131             121         267 228 2 21   2 2     0   12   136 131         121       267
1307827 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 227 1 22   0 3     0   9   146 116             96         262 227 1 22   0 3     0   9   146 116         96       262
702909 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000070 313 OWYHEE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   grade_6 226 9 52   3 17     6   20   191 142             109         333 226 9 52   3 17     6   20   191 142         109       333
1685382 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 226 4 39   3 8     1   5   151 135             135         286 226 4 39   3 8     1   5   151 135         135       286
1276900 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 225 1 30   2 3     1   12   137 137             103         274 225 1 30   2 3     1   12   137 137         103       274
703153 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 224 2 30   0 0     2   7   149 116             30         265 224 2 30   0 0     2   7   149 116         30       265
1278166 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000838 582 SAGE VALLEY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 224 3 150   1 4     0   9   202 189             239         391 224 3 150   1 4     0   9   202 189         239       391
1685378 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 224 8 88   4 9     0   4   175 162             206         337 224 8 88   4 9     0   4   175 162         206       337
1823562 ID     school 1602670 273   POST FALLS DISTRICT 160267000489 125 POST FALLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 224 1 18   3 1     1   7   136 119             131         255 224 1 18   3 1     1   7   136 119         131       255
704913 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000838 582 SAGE VALLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 222 2 156   1 0     0   14   208 187             141         395 222 2 156   1 0     0   14   208 187         141       395

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