Data source: Big Local News · About: Big Local

1,641 rows where grade = "grade_9" and state = "ID" sorted by black_int descending

View and edit SQL

year

grade

  • grade_9 · 1,641
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
1276121 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 179 31 15   1 7     1   4   129 109             83         238 179 31 15   1 7     1   4   129 109         83       238
848906 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 425 28 72   3 34     2   22   299 287             157         586 425 28 72   3 34     2   22   299 287         157       586
848565 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 158 26 22   0 5     1   5   113 104             69         217 158 26 22   0 5     1   5   113 104         69       217
1725912 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 364 26 64   3 12     1   18   236 252             159         488 364 26 64   3 12     1   18   236 252         159       488
702773 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 350 25 55   5 27     5   24   245 246             127         491 350 25 55   5 27     5   24   245 246         127       491
1725573 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 162 24 15   1 8     0   6   116 100             85         216 162 24 15   1 8     0   6   116 100         85       216
1304978 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 170 23 16   2 8     0   6   116 109             69         225 170 23 16   2 8     0   6   116 109         69       225
1820585 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_9 155 21 11   4 7     3   1   107 95             72         202 155 21 11   4 7     3   1   107 95         72       202
703113 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 336 20 63   2 11     2   19   250 203             113         453 336 20 63   2 11     2   19   250 203         113       453
849115 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000802 545 MOUNTAIN VIEW HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 471 20 78   5 18     4   23   341 278             119         619 471 20 78   5 18     4   23   341 278         119       619
1280035 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000998 1237 CANYON RIDGE HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 230 20 89   3 15     2   5   189 175             187         364 230 20 89   3 15     2   5   189 175         187       364
1308904 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000998 1237 CANYON RIDGE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 249 20 97   1 13     2   4   192 194             225         386 249 20 97   1 13     2   4   192 194         225       386
1820581 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_9 160 20 69   2 15     3   6   134 141             *         275 160 20 69   2 15     3   6   134 141                 275
848573 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 164 19 31   0 7     1   7   122 107             111         229 164 19 31   0 7     1   7   122 107         111       229
1305316 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 447 19 81   6 21     2   21   310 287             160         597 447 19 81   6 21     2   21   310 287         160       597
1681550 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_9 161 19 15   0 9     1   8   115 98             85         213 161 19 15   0 9     1   8   115 98         85       213
1725590 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_9 8 19 3   0 5     0   0   19 16             *         35 8 19 3   0 5     0   0   19 16                 35
1820921 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 367 19 51   1 20     1   13   241 231             130         472 367 19 51   1 20     1   13   241 231         130       472
1304974 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 157 18 63   1 10     1   8   146 112             96         258 157 18 63   1 10     1   8   146 112         96       258
1305525 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000802 545 MOUNTAIN VIEW HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 470 18 63   1 9     2   42   320 285             112         605 470 18 63   1 9     2   42   320 285         112       605
852511 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000998 1237 CANYON RIDGE HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 229 17 114   3 14     3   9   201 188             204         389 229 17 114   3 14     3   9   201 188         204       389
703322 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000802 545 MOUNTAIN VIEW HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 456 16 73   3 10     2   39   295 304             87         599 456 16 73   3 10     2   39   295 304         87       599
1276117 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 142 16 49   2 5     3   12   107 122             *         229 142 16 49   2 5     3   12   107 122                 229
1820602 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No 3.0 09 13 2016   grade_9 2 16 3   0 1     0   0   10 12             *         22 2 16 3   0 1     0   0   10 12                 22
702769 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 125 15 47   1 6     2   10   114 92             95         206 125 15 47   1 6     2   10   114 92         95       206
706857 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000998 1237 CANYON RIDGE HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 245 14 95   2 8     3   4   204 167             143         371 245 14 95   2 8     3   4   204 167         143       371
848561 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 162 14 80   1 12     2   11   141 141             153         282 162 14 80   1 12     2   11   141 141         153       282
1681558 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_9 143 14 36   0 4     1   9   103 104             137         207 143 14 36   0 4     1   9   103 104         137       207
1726121 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000802 545 MOUNTAIN VIEW HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 429 14 62   3 11     2   16   264 273             155         537 429 14 62   3 11     2   16   264 273         155       537
1729518 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000998 1237 CANYON RIDGE HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 211 14 83   1 15     3   4   175 156             195         331 211 14 83   1 15     3   4   175 156         195       331
1276460 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 392 13 73   3 20     1   25   276 251             163         527 392 13 73   3 20     1   25   276 251         163       527
1681546 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_9 161 13 51   0 10     3   5   130 113             143         243 161 13 51   0 10     3   5   130 113         143       243
1681891 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 344 13 56   2 17     2   17   242 209             186         451 344 13 56   2 17     2   17   242 209         186       451
1682100 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000802 545 MOUNTAIN VIEW HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 537 13 73   0 6     3   26   364 294             190         658 537 13 73   0 6     3   26   364 294         190       658
1276669 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000802 545 MOUNTAIN VIEW HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 460 11 51   5 22     3   30   293 289             116         582 460 11 51   5 22     3   30   293 289         116       582
1304986 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 155 11 35   1 4     1   2   118 91             74         209 155 11 35   1 4     1   2   118 91         74       209
1307366 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000397 95 MOUNTAIN HOME SR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 183 11 70   1 6     1   11   139 144             *         283 183 11 70   1 6     1   11   139 144                 283
1683898 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000397 95 MOUNTAIN HOME SR HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 184 11 70   4 6     4   13   150 142             *         292 184 11 70   4 6     4   13   150 142                 292
1725581 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 137 11 30   3 3     0   2   97 89             *         186 137 11 30   3 3     0   2   97 89                 186
1821130 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000802 545 MOUNTAIN VIEW HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 494 11 59   5 9     4   21   328 275             124         603 494 11 59   5 9     4   21   328 275         124       603
1822946 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000397 95 MOUNTAIN HOME SR HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 201 11 65   5 2     1   7   141 151             *         292 201 11 65   5 2     1   7   141 151                 292
703108 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 362 10 74   2 8     2   22   248 232             105         480 362 10 74   2 8     2   22   248 232         105       480
1305311 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 369 10 79   4 7     3   13   260 225             131         485 369 10 79   4 7     3   13   260 225         131       485
1820593 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_9 131 10 38   4 9     1   2   105 90             *         195 131 10 38   4 9     1   2   105 90                 195
1822604 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000118 74 VALLIVUE HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 331 10 204   4 7     1   7   277 287             340         564 331 10 204   4 7     1   7   277 287         340       564
702781 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 107 9 28   1 3     0   5   80 73             76         153 107 9 28   1 3     0   5   80 73         76       153
1820884 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No 2.0 07 09 2016   grade_9 228 9 45   1 7     1   8   146 153             102         299 228 9 45   1 7     1   8   146 153         102       299
1820916 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 340 9 68   5 3     0   12   228 209             145         437 340 9 68   5 3     0   12   228 209         145       437
848590 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 09 2020   grade_9 206 8 27   0 11     2   13   139 128             64         267 206 8 27   0 11     2   13   139 128         64       267
848869 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 09 2020   grade_9 222 8 30   0 6     1   9   135 141             82         276 222 8 30   0 6     1   9   135 141         82       276
849143 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000985 898 ROCKY MOUNTAIN HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 523 8 48   2 12     1   26   328 292             59         620 523 8 48   2 12     1   26   328 292         59       620
850967 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000397 95 MOUNTAIN HOME SR HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 193 8 76   0 8     1   12   157 141             *         298 193 8 76   0 8     1   12   157 141                 298
1276455 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 429 8 77   5 9     2   16   291 255             196         546 429 8 77   5 9     2   16   291 255         196       546
1305283 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 197 8 21   2 20     1   5   132 122             47         254 197 8 21   2 20     1   5   132 122         47       254
1725569 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 191 8 68   2 11     3   5   158 130             *         288 191 8 68   2 11     3   5   158 130                 288
1820615 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_9 201 8 24   2 2     2   7   141 105             82         246 201 8 24   2 2     2   7   141 105         82       246
703409 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Other PK 12 2021   grade_9 153 7 31   3 7     1   12   90 124             36         214 153 7 31   3 7     1   12   90 124         36       214
705267 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000397 95 MOUNTAIN HOME SR HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 138 7 77   2 0     2   14   122 118             *         240 138 7 77   2 0     2   14   122 118                 240
848569 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 279 7 35   1 7     1   9   195 144             63         339 279 7 35   1 7     1   9   195 144         63       339
848873 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 209 7 15   0 23     1   8   148 115             *         263 209 7 15   0 23     1   8   148 115                 263
850404 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000514 998 NAMPA SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 247 7 183   1 3     2   17   263 197             234         460 247 7 183   1 3     2   17   263 197         234       460
1277475 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000262 54 IDAHO FALLS SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 263 7 50   2 5     1   8   179 157             119         336 263 7 50   2 5     1   8   179 157         119       336
1279973 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000555 178 TWIN FALLS HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 228 7 44   4 6     1   1   148 143             *         291 228 7 44   4 6     1   1   148 143                 291
1304995 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 0 7 0   0 0     0   0   4 3             *         7 0 7 0   0 0     0   0   4 3                 7
1305004 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2019   grade_9 180 7 21   5 9     2   9   126 107             *         233 180 7 21   5 9     2   9   126 107                 233
1305553 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000985 898 ROCKY MOUNTAIN HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 560 7 59   2 8     3   25   320 344             79         664 560 7 59   2 8     3   25   320 344         79       664
1307051 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001078 1380 RIDGEVUE HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 225 7 134   2 0     3   10   191 190             205         381 225 7 134   2 0     3   10   191 190         205       381
1681554 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_9 275 7 18   0 18     1   6   158 167             62         325 275 7 18   0 18     1   6   158 167         62       325
1725875 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Other 07 9.0 2017   grade_9 239 7 35   1 11     2   8   147 156             93         303 239 7 35   1 11     2   8   147 156         93       303
1725907 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 361 7 77   2 3     1   18   242 227             179         469 361 7 77   2 3     1   18   242 227         179       469
1729455 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000555 178 TWIN FALLS HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 267 7 45   1 3     2   7   169 163             *         332 267 7 45   1 3     2   7   169 163                 332
1820589 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_9 255 7 23   1 15     3   10   148 166             61         314 255 7 23   1 15     3   10   148 166         61       314
1821157 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000985 898 ROCKY MOUNTAIN HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 524 7 56   3 21     4   36   339 312             75         651 524 7 56   3 21     4   36   339 312         75       651
1822405 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000515 994 SKYVIEW HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 243 7 98   1 4     2   5   168 192             *         360 243 7 98   1 4     2   5   168 192                 360
1824485 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000998 1237 CANYON RIDGE HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 218 7 87   4 15     0   4   178 157             196         335 218 7 87   4 15     0   4   178 157         196       335
703078 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 09 2021   grade_9 166 6 30   0 7     1   3   109 104             43         213 166 6 30   0 7     1   3   109 104         43       213
848594 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 139 6 32   2 8     0   7   104 90             62         194 139 6 32   2 8     0   7   104 90         62       194
848901 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 411 6 92   2 6     0   14   289 242             159         531 411 6 92   2 6     0   14   289 242         159       531
851665 ID     school 1602220 281   MOSCOW DISTRICT 160222000394 130 MOSCOW HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 148 6 12   2 6     0   9   88 95             43         183 148 6 12   2 6     0   9   88 95         43       183
1276138 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2018   grade_9 1 6 1   0 2     0   0   5 5             *         10 1 6 1   0 2     0   0   5 5                 10
1276696 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000985 898 ROCKY MOUNTAIN HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 551 6 50   1 13     2   30   345 308             81         653 551 6 50   1 13     2   30   345 308         81       653
1278492 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000397 95 MOUNTAIN HOME SR HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 175 6 60   2 3     3   13   126 136             *         262 175 6 60   2 3     3   13   126 136                 262
1279120 ID     school 1602670 273   POST FALLS DISTRICT 160267000488 126 POST FALLS HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 436 6 31   6 2     1   14   266 230             *         496 436 6 31   6 2     1   14   266 230                 496
1681854 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No 2.0 07 09 2015   grade_9 243 6 30   1 6     1   4   149 142             99         291 243 6 30   1 6     1   4   149 142         99       291
1683399 ID     school 1600510 132   CALDWELL DISTRICT 160051000104 65 CALDWELL SENIOR HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 147 6 226   1 1     1   4   185 201             *         386 147 6 226   1 1     1   4   185 201                 386
1684585 ID     school 1602220 281   MOSCOW DISTRICT 160222000394 130 MOSCOW HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 163 6 9   5 2     0   8   105 88             60         193 163 6 9   5 2     0   8   105 88         60       193
1726245 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 364 6 46   2 1     0   9   197 231             *         428 364 6 46   2 1     0   9   197 231                 428
1820611 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No 2.0 06 09 2016   grade_9 202 6 13   0 9     4   8   122 120             58         242 202 6 13   0 9     4   8   122 120         58       242
1821481 ID     school 1602640 25   POCATELLO DISTRICT 160264000646 956 CENTURY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 291 6 27   7 8     2   10   182 169             155         351 291 6 27   7 8     2   10   182 169         155       351
1823872 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_9 366 6 21   3 5     2   0   192 211             137         403 366 6 21   3 5     2   0   192 211         137       403
1824421 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000555 178 TWIN FALLS HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 252 6 51   3 8     3   8   174 157             158         331 252 6 51   3 8     3   8   174 157         158       331
702777 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 194 5 17   2 6     1   6   109 122             33         231 194 5 17   2 6     1   6   109 122         33       231
703350 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000985 898 ROCKY MOUNTAIN HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 528 5 61   0 11     3   27   339 296             64         635 528 5 61   0 11     3   27   339 296         64       635
704941 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001078 1380 RIDGEVUE HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 224 5 159   1 5     2   7   211 192             122         403 224 5 159   1 5     2   7   211 192         122       403
706013 ID     school 1602220 281   MOSCOW DISTRICT 160222000394 130 MOSCOW HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 191 5 13   2 5     3   7   112 114             55         226 191 5 13   2 5     3   7   112 114         55       226
706795 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000555 178 TWIN FALLS HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 319 5 52   1 3     2   7   187 202             *         389 319 5 52   1 3     2   7   187 202                 389
848865 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2020   grade_9 49 5 9   2 0     0   6   35 36             49         71 49 5 9   2 0     0   6   35 36         49       71
848915 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000318 112 EAGLE HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 506 5 46   2 11     1   13   286 298             64         584 506 5 46   2 11     1   13   286 298         64       584
849235 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 386 5 60   1 2     4   16   260 214             150         474 386 5 60   1 2     4   16   260 214         150       474
849925 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000262 54 IDAHO FALLS SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 306 5 75   2 5     1   12   194 212             140         406 306 5 75   2 5     1   12   194 212         140       406

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