Data source: Big Local News · About: Big Local

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

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
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
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
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
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
702790 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
702798 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 09 2021   grade_9 180 3 17   2 8     1   3   111 103             *         214 180 3 17   2 8     1   3   111 103                 214
702802 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 116 4 22   1 2     0   7   90 62             41         152 116 4 22   1 2     0   7   90 62         41       152
703035 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_9 10 0 0   0 0     0   1   7 4             *         11 10 0 0   0 0     0   1   7 4                 11
703074 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12 2021   grade_9 39 1 8   2 0     0   4   26 28             34         54 39 1 8   2 0     0   4   26 28         34       54
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
703082 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_9 164 1 13   1 13     0   8   107 93             *         200 164 1 13   1 13     0   8   107 93                 200
703095 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2021   grade_9 1 1 1   0 0     0   0   2 1             *         3 1 1 1   0 0     0   0   2 1                 3
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
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
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
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
848582 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
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
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
848826 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_9 7 0 1   0 2     0   0   8 2             *         10 7 0 1   0 2     0   0   8 2                 10
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
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
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
848888 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12 2020   grade_9 7 0 0   0 0     0   0   6 1             *         7 7 0 0   0 0     0   0   6 1                 7
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
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
1276125 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 268 4 17   1 11     1   9   149 162             43         311 268 4 17   1 11     1   9   149 162         43       311
1276129 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 140 5 38   2 8     3   7   110 93             *         203 140 5 38   2 8     3   7   110 93                 203
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
1276143 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2018   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1276148 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2018   grade_9 186 3 19   0 12     3   6   115 114             54         229 186 3 19   0 12     3   6   115 114         54       229
1276152 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 174 2 23   2 4     0   4   105 104             59         209 174 2 23   2 4     0   4   105 104         59       209
1276380 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2018   grade_9 9 0 1   0 2     0   1   10 3             *         13 9 0 1   0 2     0   1   10 3                 13
1276419 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12.0 2018   grade_9 68 5 15   1 1     1   4   55 40             *         95 68 5 15   1 1     1   4   55 40                 95
1276423 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2018   grade_9 218 3 27   2 9     4   12   147 128             77         275 218 3 27   2 9     4   12   147 128         77       275
1276427 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 184 3 20   0 14     1   7   123 106             45         229 184 3 20   0 14     1   7   123 106         45       229
1276442 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2018   grade_9 4 0 2   0 0     0   1   5 2             *         7 4 0 2   0 0     0   1   5 2                 7
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
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
1304982 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 298 5 23   1 11     1   7   152 194             57         346 298 5 23   1 11     1   7   152 194         57       346
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
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
1305008 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 142 3 17   3 5     1   5   94 82             57         176 142 3 17   3 5     1   5   94 82         57       176
1305236 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_9 8 1 0   0 5     0   0   10 4             *         14 8 1 0   0 5     0   0   10 4                 14
1305275 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No High 06 12.0 2019   grade_9 70 3 19   1 0     0   2   56 39             42         95 70 3 19   1 0     0   2   56 39         42       95
1305279 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2019   grade_9 237 5 41   2 8     1   8   169 133             90         302 237 5 41   2 8     1   8   169 133         90       302
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
1305298 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2019   grade_9 5 0 0   0 0     0   0   3 2             *         5 5 0 0   0 0     0   0   3 2                 5
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
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
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
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
1681567 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 9 4 1   1 7     0   0   7 15             *         22 9 4 1   1 7     0   0   7 15                 22
1681575 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No 2.0 06 09 2015   grade_9 153 2 17   1 12     1   7   94 99             62         193 153 2 17   1 12     1   7   94 99         62       193
1681579 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_9 175 5 29   1 9     2   5   117 109             81         226 175 5 29   1 9     2   5   117 109         81       226
1681811 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_9 15 0 1   0 1     0   0   14 3             *         17 15 0 1   0 1     0   0   14 3                 17
1681850 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_9 92 1 23   1 0     0   2   58 61             *         119 92 1 23   1 0     0   2   58 61                 119
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
1681858 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_9 147 0 11   1 12     2   7   93 87             24         180 147 0 11   1 12     2   7   93 87         24       180
1681873 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_9 5 0 1   0 0     0   0   3 3             *         6 5 0 1   0 0     0   0   3 3                 6
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
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
1725577 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 248 3 21   0 9     1   6   130 158             41         288 248 3 21   0 9     1   6   130 158         41       288
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
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
1725598 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Other 06 9.0 2017   grade_9 178 5 16   0 5     3   5   109 103             56         212 178 5 16   0 5     3   5   109 103         56       212
1725602 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 146 3 26   1 3     1   5   99 86             60         185 146 3 26   1 3     1   5   99 86         60       185
1725832 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_9 15 0 0   0 0     0   0   10 5             *         15 15 0 0   0 0     0   0   10 5                 15
1725871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative School No Other 06 12.0 2017   grade_9 68 5 30   0 1     1   1   66 40             *         106 68 5 30   0 1     1   1   66 40                 106
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
1725879 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 168 3 14   0 23     1   4   111 102             39         213 168 3 14   0 23     1   4   111 102         39       213
1725894 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_9 5 0 0   1 0     0   0   6 0             *         6 5 0 0   1 0     0   0   6 0                 6
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
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
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
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
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
1820607 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No 3.0 09 13 2016   grade_9 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
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
1820843 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2016   grade_9 6 0 1   0 4     0   1   7 5             *         12 6 0 1   0 4     0   1   7 5                 12
1820880 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000984 675 FRANK CHURCH HIGH SCHOOL   Alternative Education School No 3.0 09 12 2016   grade_9 78 2 22   1 0     0   3   58 48             *         106 78 2 22   1 0     0   3   58 48                 106
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
1820888 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_9 167 5 17   1 8     2   5   106 99             50         205 167 5 17   1 8     2   5   106 99         50       205
1820903 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2016   grade_9 1 0 4   1 0     0   0   4 2             *         6 1 0 4   1 0     0   0   4 2                 6
704501 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12 2021   grade_9 93 0 7   2 0     0   6   53 55             50         108 93 0 7   2 0     0   6   53 55         50       108
850226 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 110 0 5   4 2     0   6   65 62             54         127 110 0 5   4 2     0   6   65 62         54       127
1277766 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12.0 2018   grade_9 115 0 11   2 1     0   5   56 78             69         134 115 0 11   2 1     0   5   56 78         69       134
1306624 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 89 2 5   2 2     1   3   50 54             49         104 89 2 5   2 2     1   3   50 54         49       104
1683186 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 100 0 9   8 2     0   2   61 60             55         121 100 0 9   8 2     0   2   61 60         55       121
1727230 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 92 1 3   5 3     0   0   53 51             49         104 92 1 3   5 3     0   0   53 51         49       104
1822236 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000089 57 BONNERS FERRY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 97 0 8   4 0     0   2   66 45             60         111 97 0 8   4 0     0   2   66 45         60       111
703524 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2021   grade_9 13 0 0   1 0     0   0   8 6             *         14 13 0 0   1 0     0   0   8 6                 14
849291 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_9 7 0 1   0 0     0   0   7 1             *         8 7 0 1   0 0     0   0   7 1                 8
1276842 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2018   grade_9 11 0 1   0 0     0   1   8 5             8         13 11 0 1   0 0     0   1   8 5         8       13
1305701 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_9 11 0 1   1 0     0   0   8 5             7         13 11 0 1   1 0     0   0   8 5         7       13
1682266 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No 4.0 PK 12 2015   grade_9 12 0 1   0 0     0   0   6 7             8         13 12 0 1   0 0     0   0   6 7         8       13
1726305 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_9 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
1821303 ID     school 1602060 11   MEADOWS VALLEY DISTRICT 160206000826 342 MEADOWS VALLEY SCHOOL   Regular School No 4.0 PK 12 2016   grade_9 9 0 1   0 0     0   0   6 4             *         10 9 0 1   0 0     0   0   6 4                 10

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