Data source: Big Local News · About: Big Local

1,582 rows where grade = "grade_7" and state = "ID" sorted by native_hawaiian_pacific_islander_int descending

View and edit SQL

year

grade

  • grade_7 · 1,582
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
848947 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 307 0 33   0 2     6   19   161 206             37         367 307 0 33   0 2     6   19   161 206         37       367
852439 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 186 6 37   0 5     6   2   132 110             104         242 186 6 37   0 5     6   2   132 110         104       242
702771 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 320 35 60   0 25     5   26   238 233             130         471 320 35 60   0 25     5   26   238 233         130       471
849350 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 207 1 26   1 5     5   10   138 117             96         255 207 1 26   1 5     5   10   138 117         96       255
1276776 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 349 5 55   1 0     5   13   234 194             150         428 349 5 55   1 0     5   13   234 194         150       428
1683892 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000401 93 MOUNTAIN HOME JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2015   grade_7 213 8 54   2 5     5   11   151 147             135         298 213 8 54   2 5     5   11   151 147         135       298
850407 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000811 1109 EAST VALLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 151 2 120   0 1     4   10   142 146             169         288 151 2 120   0 1     4   10   142 146         169       288
1304972 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 151 17 58   6 9     4   15   140 120             110         260 151 17 58   6 9     4   15   140 120         110       260
1306688 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 120 2 121   1 1     4   14   134 129             195         263 120 2 121   1 1     4   14   134 129         195       263
1307360 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000401 93 MOUNTAIN HOME JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 156 5 81   2 4     4   17   135 134             *         269 156 5 81   2 4     4   17   135 134                 269
1308836 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 242 7 38   1 3     4   4   144 155             116         299 242 7 38   1 3     4   4   144 155         116       299
1685383 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 248 7 40   0 4     4   6   150 159             128         309 248 7 40   0 4     4   6   150 159         128       309
1729449 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 264 3 57   2 5     4   4   166 173             *         339 264 3 57   2 5     4   4   166 173                 339
1820591 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_7 152 5 38   0 11     4   7   112 105             *         217 152 5 38   0 11     4   7   112 105                 217
1822392 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000969 648 LONE STAR MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 156 1 85   1 0     4   14   126 135             139         261 156 1 85   1 0     4   14   126 135         139       261
1822519 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 272 1 37   0 2     4   8   178 146             139         324 272 1 37   0 2     4   8   178 146         139       324
703102 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 278 4 63   2 3     3   12   177 188             94         365 278 4 63   2 3     3   12   177 188         94       365
703583 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 204 0 28   2 0     3   9   116 130             *         246 204 0 28   2 0     3   9   116 130                 246
849362 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 161 1 42   6 1     3   8   114 108             120         222 161 1 42   6 1     3   8   114 108         120       222
1276115 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 164 15 81   2 10     3   7   143 139             *         282 164 15 81   2 10     3   7   143 139                 282
1276909 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 145 2 31   5 2     3   6   105 89             123         194 145 2 31   5 2     3   6   105 89         123       194
1305635 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 368 4 41   3 7     3   18   220 224             58         444 368 4 41   3 7     3   18   220 224         58       444
1305639 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 224 0 46   4 4     3   5   147 139             89         286 224 0 46   4 4     3   5   147 139         89       286
1306778 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000969 648 LONE STAR MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 159 2 101   3 2     3   10   142 138             144         280 159 2 101   3 2     3   10   142 138         144       280
1681544 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_7 207 10 69   0 10     3   6   164 141             219         305 207 10 69   0 10     3   6   164 141         219       305
1681573 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No 2.0 06 09 2015   grade_7 172 1 14   1 6     3   5   107 95             72         202 172 1 14   1 6     3   5   107 95         72       202
1682197 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 313 4 38   1 14     3   12   186 199             78         385 313 4 38   1 14     3   12   186 199         78       385
1684342 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000153 121 LAKES MAGNET SCHOOL   Regular School No 2.0 06 08 2015   grade_7 183 2 12   2 0     3   6   100 108             127         208 183 2 12   2 0     3   6   100 108         127       208
1684514 ID     school 1602670 273   POST FALLS DISTRICT 160267000489 125 POST FALLS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 195 3 16   6 1     3   5   110 119             136         229 195 3 16   6 1     3   5   110 119         136       229
1725873 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Other 07 9.0 2017   grade_7 246 4 39   3 9     3   6   163 147             95         310 246 4 39   3 9     3   6   163 147         95       310
1726236 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 352 5 46   1 8     3   12   223 204             62         427 352 5 46   1 8     3   12   223 204         62       427
1726364 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 215 3 15   3 4     3   5   137 111             *         248 215 3 15   3 4     3   5   137 111                 248
1726368 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 180 3 18   27 0     3   8   127 112             120         239 180 3 18   27 0     3   8   127 112         120       239
1726376 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 177 1 33   6 0     3   6   112 114             125         226 177 1 33   6 0     3   6   112 114         125       226
1726943 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000727 199 TAYLORVIEW MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_7 322 3 63   4 3     3   13   215 196             *         411 322 3 63   4 3     3   13   215 196                 411
1727300 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 198 2 82   1 2     3   7   149 146             *         295 198 2 82   1 2     3   7   149 146                 295
1727730 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 149 1 111   5 0     3   4   150 123             169         273 149 1 111   5 0     3   4   150 123         169       273
1820609 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No 2.0 06 09 2016   grade_7 172 1 19   0 9     3   6   108 102             36         210 172 1 19   0 9     3   6   108 102         36       210
1820882 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No 2.0 07 09 2016   grade_7 224 5 25   3 11     3   11   147 135             98         282 224 5 25   3 11     3   11   147 135         98       282
1820910 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 276 6 50   3 4     3   11   183 170             139         353 276 6 50   3 4     3   11   183 170         139       353
1820924 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 348 2 40   3 7     3   15   214 204             52         418 348 2 40   3 7     3   15   214 204         52       418
1822940 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000401 93 MOUNTAIN HOME JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_7 195 6 54   1 5     3   14   140 138             146         278 195 6 54   1 5     3   14   140 138         146       278
1823343 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000285 117 JEROME MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 163 2 140   4 0     3   0   158 154             224         312 163 2 140   4 0     3   0   158 154         224       312
702779 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 126 14 41   2 3     2   3   92 99             105         191 126 14 41   2 3     2   3   92 99         105       191
703076 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 09 2021   grade_7 197 11 29   1 5     2   8   134 119             82         253 197 11 29   1 5     2   8   134 119         82       253
703098 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 218 11 28   2 7     2   14   141 141             65         282 218 11 28   2 7     2   14   141 141         65       282
703125 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 220 16 53   3 13     2   19   159 167             77         326 220 16 53   3 13     2   19   159 167         77       326
703407 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Other PK 12 2021   grade_7 200 4 34   3 8     2   5   135 121             41         256 200 4 34   3 8     2   5   135 121         41       256
703595 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 153 2 38   3 0     2   8   111 95             94         206 153 2 38   3 0     2   8   111 95         94       206
704097 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7 211 0 8   2 6     2   16   124 121             *         245 211 0 8   2 6     2   16   124 121                 245
704350 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000168 219 ROCKY MOUNTAIN MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7 410 2 122   4 0     2   12   273 279             183         552 410 2 122   4 0     2   12   273 279         183       552
704733 ID     school 1600510 132   CALDWELL DISTRICT 160051000109 281 SYRINGA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 77 1 132   0 0     2   10   116 106             *         222 77 1 132   0 0     2   10   116 106                 222
704914 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000838 582 SAGE VALLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 251 6 154   2 3     2   10   214 214             153         428 251 6 154   2 3     2   10   214 214         153       428
706246 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_7 362 2 30   1 2     2   0   209 190             113         399 362 2 30   1 2     2   0   209 190         113       399
706789 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 227 5 31   4 5     2   7   134 147             76         281 227 5 31   4 5     2   7   134 147         76       281
707209 ID     school 1600011 457   INSPIRE ACADEMICS, INC. 160001100866 578 INSPIRE VIRTUAL CHARTER SCHOOL   Regular School Yes Other PK 12 2021   grade_7 138 1 26   3 2     2   9   92 89             55         181 138 1 26   3 2     2   9   92 89         55       181
707238 ID     school 1600014 460   THE ACADEMY, INC. 160001400891 641 CONNOR ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7 54 0 6   4 0     2   0   33 33             6         66 54 0 6   4 0     2   0   33 33         6       66
848571 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 157 16 54   0 4     2   14   125 122             167         247 157 16 54   0 4     2   14   125 122         167       247
848588 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 09 2020   grade_7 181 5 23   1 20     2   9   118 123             61         241 181 5 23   1 20     2   9   118 123         61       241
848871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 174 4 19   1 28     2   7   120 115             *         235 174 4 19   1 28     2   7   120 115                 235
848922 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 248 15 68   1 12     2   18   187 177             122         364 248 15 68   1 12     2   18   187 177         122       364
849258 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 161 2 20   2 1     2   8   84 112             67         196 161 2 20   2 1     2   8   84 112         67       196
849833 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200724 47 SANDPOINT MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7 222 1 10   2 0     2   5   134 108             88         242 222 1 10   2 0     2   5   134 108         88       242
850289 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 112 0 116   1 0     2   14   134 111             185         245 112 0 116   1 0     2   14   134 111         185       245
850379 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000969 648 LONE STAR MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 172 3 99   1 2     2   13   156 136             143         292 172 3 99   1 2     2   13   156 136         143       292
850644 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000539 985 VALLIVUE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 177 3 142   0 1     2   13   170 168             190         338 177 3 142   0 1     2   13   170 168         190       338
851586 ID     school 1602670 273   POST FALLS DISTRICT 160267000489 125 POST FALLS MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 242 1 24   4 1     2   12   157 129             132         286 242 1 24   4 1     2   12   157 129         132       286
851601 ID     school 1602670 273   POST FALLS DISTRICT 160267000844 268 RIVER CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 219 2 11   2 2     2   10   133 115             89         248 219 2 11   2 2     2   10   133 115         89       248
851897 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 357 4 29   0 3     2   1   209 187             *         396 357 4 29   0 3     2   1   209 187                 396
1276146 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2018   grade_7 200 8 28   0 14     2   11   139 124             66         263 200 8 28   0 14     2   11   139 124         66       263
1276445 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 257 12 27   3 21     2   16   163 175             96         338 257 12 27   3 21     2   16   163 175         96       338
1276472 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 210 8 52   4 9     2   10   156 139             99         295 210 8 52   4 9     2   10   156 139         99       295
1276476 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 284 14 59   1 22     2   13   194 201             118         395 284 14 59   1 22     2   13   194 201         118       395
1276901 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 214 0 15   2 7     2   9   110 139             *         249 214 0 15   2 7     2   9   110 139                 249
1277835 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 178 3 79   1 1     2   12   152 124             140         276 178 3 79   1 1     2   12   152 124         140       276
1277921 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000969 648 LONE STAR MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 184 3 104   1 4     2   16   173 141             156         314 184 3 104   1 4     2   16   173 141         156       314
1277949 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000811 1109 EAST VALLEY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 179 0 123   3 1     2   13   174 147             177         321 179 0 123   3 1     2   13   174 147         177       321
1277983 ID     school 1600510 132   CALDWELL DISTRICT 160051000109 281 SYRINGA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 65 4 186   3 0     2   5   159 106             *         265 65 4 186   3 0     2   5   159 106                 265
1279425 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 365 4 27   2 2     2   5   198 209             *         407 365 4 27   2 2     2   5   198 209                 407
1279963 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 150 14 45   1 10     2   6   112 116             *         228 150 14 45   1 10     2   6   112 116                 228
1279967 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 215 2 32   1 5     2   1   138 120             106         258 215 2 32   1 5     2   1   138 120         106       258
1305319 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 265 1 20   2 5     2   8   159 144             32         303 265 1 20   2 5     2   8   159 144         32       303
1305357 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 288 1 34   1 4     2   10   183 157             66         340 288 1 34   1 4     2   10   183 157         66       340
1305621 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001104 1406 STAR MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 140 3 20   2 1     2   5   88 85             35         173 140 3 20   2 1     2   5   88 85         35       173
1306474 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000168 219 ROCKY MOUNTAIN MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 382 1 120   3 1     2   10   273 246             225         519 382 1 120   3 1     2   10   273 246         225       519
1306806 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000811 1109 EAST VALLEY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 167 0 141   1 2     2   6   172 147             190         319 167 0 141   1 2     2   6   172 147         190       319
1308054 ID     school 1602220 281   MOSCOW DISTRICT 160222000393 129 MOSCOW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 160 3 11   1 6     2   8   98 93             53         191 160 3 11   1 6     2   8   98 93         53       191
1308832 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 168 8 41   1 3     2   3   118 108             114         226 168 8 41   1 3     2   3   118 108         114       226
1681903 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 377 8 58   1 12     2   19   242 235             142         477 377 8 58   1 12     2   19   242 235         142       477
1681932 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 263 2 32   2 6     2   10   158 159             68         317 263 2 32   2 6     2   10   158 159         68       317
1682325 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 205 1 22   4 5     2   5   130 114             *         244 205 1 22   4 5     2   5   130 114                 244
1683377 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000811 1109 EAST VALLEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 179 5 114   1 2     2   4   148 159             193         307 179 5 114   1 2     2   4   148 159         193       307
1683474 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 227 3 26   2 1     2   7   138 130             125         268 227 3 26   2 1     2   7   138 130         125       268
1683674 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000125 80 BURLEY JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2015   grade_7 156 1 115   2 0     2   0   147 129             166         276 156 1 115   2 0     2   0   147 129         166       276
1684824 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_7 371 2 24   1 4     2   2   222 184             *         406 371 2 24   1 4     2   2   222 184                 406
1685379 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 204 2 82   1 11     2   4   160 146             147         306 204 2 82   1 11     2   4   160 146         147       306
1685564 ID     school 1602310 418   MURTAUGH JOINT DISTRICT 160231001034 1344 MURTAUGH SCHOOLS   Regular School No 4.0 PK 12 2015   grade_7 5 1 11   0 0     2   0   7 12             *         19 5 1 11   0 0     2   0   7 12                 19
1725575 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 286 2 24   1 11     2   9   143 192             65         335 286 2 24   1 11     2   9   143 192         65       335
1725897 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 283 7 36   3 7     2   14   173 179             108         352 283 7 36   3 7     2   14   173 179         108       352
1726323 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 107 2 2   0 0     2   1   67 47             51         114 107 2 2   0 0     2   1   67 47         51       114

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