Data source: Big Local News · About: Big Local

1,582 rows where grade = "grade_7" and state = "ID" sorted by native_american_alaskan_native 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
1277101 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500647 128 LAKESIDE JR HIGH SCHOOL   Regular School No Middle 07 8.0 2018   grade_7 3 0 2   9 0     0   2   5 11             *         16 3 0 2   9 0     0   2   5 11                 16
1305772 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 172 0 29   8 1     1   7   112 106             103         218 172 0 29   8 1     1   7   112 106         103       218
1682333 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 149 2 24   8 0     0   3   91 95             108         186 149 2 24   8 0     0   3   91 95         108       186
1821370 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 159 4 29   8 0     0   2   95 107             109         202 159 4 29   8 0     0   2   95 107         109       202
1821561 ID     school 1600815 44   PLUMMER-WORLEY JOINT DISTRICT 160081500647 128 LAKESIDE JR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_7 6 0 4   8 0     0   0   11 7             *         18 6 0 4   8 0     0   0   11 7                 18
1823394 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000153 121 LAKES MAGNET SCHOOL   Regular School No 2.0 06 08 2016   grade_7 190 0 14   8 0     0   15   117 110             146         227 190 0 14   8 0     0   15   117 110         146       227
704178 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000257 50 EAGLE ROCK MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7 250 1 118   7 0     1   13   191 199             149         390 250 1 118   7 0     1   13   191 199         149       390
707482 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2021   grade_7 0 0 0   7 0     0   0   5 2             *         7 0 0 0   7 0     0   0   5 2                 7
848918 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 303 14 35   7 11     1   11   193 189             105         382 303 14 35   7 11     1   11   193 189         105       382
1279827 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 55 0 57   7 0     0   0   60 59             *         119 55 0 57   7 0     0   0   60 59                 119
1307807 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000153 121 LAKES MAGNET SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 171 3 23   7 4     0   12   116 104             115         220 171 3 23   7 4     0   12   116 104         115       220
1308430 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 169 2 8   7 1     0   12   94 105             81         199 169 2 8   7 1     0   12   94 105         81       199
1309451 ID     school 1600153 477   BLACKFOOT CHARTER COMMUNITY LEARNING CENTER, INC. 160015300796 1294 BLACKFOOT CHARTER COMMUNITY   Regular School Yes Elementary PK 8.0 2019   grade_7 31 0 13   7 2     0   2   27 28             *         55 31 0 13   7 2     0   2   27 28                 55
1684752 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 22 0 4   7 0     1   3   21 16             25         37 22 0 4   7 0     1   3   21 16         25       37
1728403 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000153 121 LAKES MAGNET SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 181 2 14   7 5     1   8   117 101             126         218 181 2 14   7 5     1   8   117 101         126       218
703591 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 180 0 25   6 0     1   11   114 109             121         223 180 0 25   6 0     1   11   114 109         121       223
703894 ID     school 1600270 55   BLACKFOOT DISTRICT 160027001138 1452 BLACKFOOT ONLINE SCHOOL SOLUTION   Regular School No Elementary KG 08 2021   grade_7 17 0 16   6 0     1   0   20 20             *         40 17 0 16   6 0     1   0   20 20                 40
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
849927 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000727 199 TAYLORVIEW MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7 346 3 75   6 5     1   9   214 231             182         445 346 3 75   6 5     1   9   214 231         182       445
850062 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000651 55 SANDCREEK MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7 396 2 55   6 3     0   6   222 246             139         468 396 2 55   6 3     0   6   222 246         139       468
1276913 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 206 1 38   6 3     0   10   151 113             141         264 206 1 38   6 3     0   10   151 113         141       264
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
1682337 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 157 3 20   6 1     0   5   94 98             114         192 157 3 20   6 1     0   5   94 98         114       192
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
1684961 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No 2.0 07 09 2015   grade_7 163 0 9   6 0     0   11   88 101             *         189 163 0 9   6 0     0   11   88 101                 189
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
1728814 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Elementary 04 8.0 2017   grade_7 38 0 3   6 0     1   2   32 18             *         50 38 0 3   6 0     1   2   32 18                 50
1729022 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Other 07 9.0 2017   grade_7 173 2 7   6 2     1   15   118 88             *         206 173 2 7   6 2     1   15   118 88                 206
1820933 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 403 6 49   6 21     2   21   257 251             98         508 403 6 49   6 21     2   21   257 251         98       508
707129 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other KG 12 2021   grade_7 251 1 33   5 2     0   11   145 158             *         303 251 1 33   5 2     0   11   145 158                 303
849358 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 183 0 45   5 1     1   3   124 114             122         238 183 0 45   5 1     1   3   124 114         122       238
851823 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000457 231 KAMIAH SENIOR HIGH   Regular School No High 07 12 2020   grade_7 14 0 2   5 0     0   4   13 12             *         25 14 0 2   5 0     0   4   13 12                 25
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
1277464 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000257 50 EAGLE ROCK MIDDLE SCHOOL   Regular School No Middle 07 8.0 2018   grade_7 255 1 121   5 1     0   11   198 196             *         394 255 1 121   5 1     0   11   198 196                 394
1278167 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060000838 582 SAGE VALLEY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 210 2 136   5 5     1   14   187 186             218         373 210 2 136   5 5     1   14   187 186         218       373
1279114 ID     school 1602670 273   POST FALLS DISTRICT 160267000489 125 POST FALLS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 215 3 20   5 0     0   3   148 98             113         246 215 3 20   5 0     0   3   148 98         113       246
1682902 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000727 199 TAYLORVIEW MIDDLE SCHOOL   Regular School No 2.0 07 09 2015   grade_7 331 4 69   5 5     0   11   232 193             *         425 331 4 69   5 5     0   11   232 193                 425
1683189 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 88 2 4   5 2     0   0   52 49             61         101 88 2 4   5 2     0   0   52 49         61       101
1683257 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 195 1 76   5 2     0   7   152 134             *         286 195 1 76   5 2     0   7   152 134                 286
1725600 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 145 1 23   5 5     1   4   101 83             75         184 145 1 23   5 5     1   4   101 83         75       184
1726239 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 345 2 51   5 2     1   12   221 197             180         418 345 2 51   5 2     1   12   221 197         180       418
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
1821237 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 354 2 47   5 1     0   11   225 195             163         420 354 2 47   5 1     0   11   225 195         163       420
1821362 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 212 1 16   5 2     1   4   137 104             *         241 212 1 16   5 2     1   4   137 104                 241
1824010 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No 2.0 07 09 2016   grade_7 146 0 12   5 1     2   9   99 76             75         175 146 0 12   5 1     2   9   99 76         75       175
1308517 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_7 6 0 1   43 0     0   2   23 29             20         52 6 0 1   43 0     0   2   23 29         20       52
1726597 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 148 0 79   42 2     0   8   118 161             161         279 148 0 79   42 2     0   8   118 161         161       279
703154 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 255 0 27   4 4     0   8   163 135             42         298 255 0 27   4 4     0   8   163 135         42       298
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
705161 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000440 88 OROFINO HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 66 0 1   4 0     0   1   37 35             24         72 66 0 1   4 0     0   1   37 35         24       72
706175 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_7 22 0 3   4 0     0   2   19 12             13         31 22 0 3   4 0     0   2   19 12         13       31
706516 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249001094 1390 IDAHO HOME LEARNING ACADEMY   Regular School No Other PK 10 2021   grade_7 488 1 47   4 8     1   0   287 262             *         549 488 1 47   4 8     1   0   287 262                 549
706649 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 46 1 72   4 0     0   1   63 61             *         124 46 1 72   4 0     0   1   63 61                 124
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
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
848567 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 288 5 35   4 6     0   13   158 193             64         351 288 5 35   4 6     0   13   158 193         64       351
849564 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000520 31 SNAKE RIVER JR HIGH SCHOOL   Regular School No Middle 07 08 2020   grade_7 123 1 21   4 0     0   2   81 70             49         151 123 1 21   4 0     0   2   81 70         49       151
850961 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000401 93 MOUNTAIN HOME JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2020   grade_7 191 6 63   4 3     1   15   143 140             155         283 191 6 63   4 3     1   15   143 140         155       283
851411 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000153 121 LAKES MAGNET SCHOOL   Regular School No Middle 06 08 2020   grade_7 208 2 25   4 3     0   9   128 123             133         251 208 2 25   4 3     0   9   128 123         133       251
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
853129 ID     school 1600163 483   CHIEF TAHGEE ELEMENTARY ACADEMY, INC. 160016301040 1347 CHIEF TAHGEE ELEMENTARY ACADEMY   Regular School Yes Elementary KG 07 2020   grade_7 0 0 1   4 0     0   0   3 2             *         5 0 0 1   4 0     0   0   3 2                 5
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
1278937 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000153 121 LAKES MAGNET SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 179 2 12   4 1     0   7   118 87             121         205 179 2 12   4 1     0   7   118 87         121       205
1279355 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 8.0 2018   grade_7 29 0 0   4 0     0   1   16 18             *         34 29 0 0   4 0     0   1   16 18                 34
1280573 ID     school 1600153 477   BLACKFOOT CHARTER COMMUNITY LEARNING CENTER, INC. 160015300796 1294 BLACKFOOT CHARTER COMMUNITY   Regular School Yes Elementary PK 8.0 2018   grade_7 25 1 7   4 0     0   3   21 19             28         40 25 1 7   4 0     0   3   21 19         28       40
1305617 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 265 3 33   4 8     0   19   165 167             48         332 265 3 33   4 8     0   19   165 167         48       332
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
1306318 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000257 50 EAGLE ROCK MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 285 2 108   4 2     0   11   196 216             227         412 285 2 108   4 2     0   11   196 216         227       412
1307263 ID     school 1602520 171   OROFINO JOINT DISTRICT 160252000440 88 OROFINO HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_7 49 0 2   4 0     0   0   24 31             31         55 49 0 2   4 0     0   0   24 31         31       55
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
1683041 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000168 219 ROCKY MOUNTAIN MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 335 2 83   4 3     1   11   232 207             220         439 335 2 83   4 3     1   11   232 207         220       439
1683940 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000612 291 PRESTON JR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_7 174 1 20   4 0     0   3   104 98             94         202 174 1 20   4 0     0   3   104 98         94       202
1684290 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000285 117 JEROME MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 144 0 140   4 1     0   2   143 148             197         291 144 0 140   4 1     0   2   143 148         197       291
1684965 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No 2.0 07 09 2015   grade_7 159 1 11   4 4     0   12   89 102             76         191 159 1 11   4 4     0   12   89 102         76       191
1725596 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Other 06 9.0 2017   grade_7 185 3 22   4 11     1   10   126 110             58         236 185 3 22   4 11     1   10   126 110         58       236
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
1728424 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 244 1 31   4 1     1   16   161 137             112         298 244 1 31   4 1     1   16   161 137         112       298
1729769 ID     school 1600004 452   IDAHO VIRTUAL ACADEMY, INC. 160000400859 869 IDAHO VIRTUAL ACADEMY   Regular School Yes Other PK 12.0 2017   grade_7 138 2 13   4 0     0   5   78 84             85         162 138 2 13   4 0     0   5   78 84         85       162
1820906 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 255 7 40   4 12     1   12   164 167             91         331 255 7 40   4 12     1   12   164 167         91       331
1821644 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000761 1149 SUMMIT ACADEMY ALT   Alternative Education School No 2.0 07 08 2016   grade_7 8 0 2   4 0     0   2   12 4             *         16 8 0 2   4 0     0   2   12 4                 16
1822088 ID     school 1600930 93   BONNEVILLE JOINT DISTRICT 160093000168 219 ROCKY MOUNTAIN MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 364 1 92   4 0     0   11   229 243             248         472 364 1 92   4 0     0   11   229 243         248       472
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
1823798 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 25 0 5   4 0     0   1   21 14             19         35 25 0 5   4 0     0   1   21 14         19       35
1824411 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 199 9 91   4 13     0   2   160 158             196         318 199 9 91   4 13     0   2   160 158         196       318
1821366 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 177 4 19   37 2     2   3   130 114             128         244 177 4 19   37 2     2   3   130 114         128       244
1729115 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No Other 06 12.0 2017   grade_7 4 0 0   36 0     0   3   29 14             *         43 4 0 0   36 0     0   3   29 14                 43
1279650 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_7 1 0 1   34 0     0   4   23 17             *         40 1 0 1   34 0     0   4   23 17                 40
1305992 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 188 0 67   34 0     0   7   157 139             *         296 188 0 67   34 0     0   7   157 139                 296
1277132 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 189 1 93   33 3     0   10   157 172             186         329 189 1 93   33 3     0   10   157 172         186       329
1821592 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 148 1 67   33 0     2   5   139 117             *         256 148 1 67   33 0     2   5   139 117                 256
1276905 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 197 1 32   32 0     0   9   111 160             141         271 197 1 32   32 0     0   9   111 160         141       271
1682329 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 184 1 25   32 2     0   3   132 115             114         247 184 1 25   32 2     0   3   132 115         114       247
1682556 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 164 0 62   32 1     0   8   134 133             *         267 164 0 62   32 1     0   8   134 133                 267
1685051 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 2 0 2   32 1     0   2   21 18             *         39 2 0 2   32 1     0   2   21 18                 39
706461 ID     school 1601830 341   LAPWAI DISTRICT 160183000854 583 LAPWAI MIDDLE/HIGH SCHOOL   Regular School No High 06 12 2021   grade_7 4 0 1   31 0     1   2   17 22             19         39 4 0 1   31 0     1   2   17 22         19       39
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
704504 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 84 0 4   3 0     0   4   52 43             42         95 84 0 4   3 0     0   4   52 43         42       95
705314 ID     school 1600960 201   PRESTON JOINT DISTRICT 160096000612 291 PRESTON JR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_7 166 0 19   3 1     0   3   102 90             56         192 166 0 19   3 1     0   3   102 90         56       192

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