Data source: Big Local News · About: Big Local

1,582 rows where grade = "grade_7" and state = "ID" sorted by white 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
1685214 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 99 0 36   0 0     0   4   86 53             60         139 99 0 36   0 0     0   4   86 53         60       139
1728034 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000625 98 SOUTH FREMONT JR HIGH   Regular School No Middle 06 8.0 2017   grade_7 99 1 32   0 0     0   2   64 70             78         134 99 1 32   0 0     0   2   64 70         78       134
1823933 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000702 226 SUGAR-SALEM JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_7 99 0 6   0 0     0   0   43 62             55         105 99 0 6   0 0     0   0   43 62         55       105
1276860 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2018   grade_7 98 4 5   1 0     0   0   60 48             42         108 98 4 5   1 0     0   0   60 48         42       108
1308807 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000544 195 TETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 98 0 45   0 0     0   3   81 65             55         146 98 0 45   0 0     0   3   81 65         55       146
1728967 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 98 0 76   1 0     0   1   92 84             *         176 98 0 76   1 0     0   1   92 84                 176
703542 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7 97 0 2   1 0     1   1   51 51             28         102 97 0 2   1 0     1   1   51 51         28       102
1309099 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 96 0 37   1 0     0   2   62 74             71         136 96 0 37   1 0     0   2   62 74         71       136
1685352 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000544 195 TETON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 96 0 39   0 1     0   1   71 66             62         137 96 0 39   0 1     0   1   71 66         62       137
849309 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7 94 1 2   1 0     0   0   52 46             37         98 94 1 2   1 0     0   0   52 46         37       98
851980 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 93 0 89   2 1     0   2   108 79             118         187 93 0 89   2 1     0   2   108 79         118       187
704561 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 92 1 81   0 2     1   6   101 82             113         183 92 1 81   0 2     1   6   101 82         113       183
1278570 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000625 98 SOUTH FREMONT JR HIGH   Regular School No Middle 06 8.0 2018   grade_7 92 1 29   0 0     0   2   60 64             71         124 92 1 29   0 0     0   2   60 64         71       124
1306627 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 92 1 7   2 0     0   5   50 57             63         107 92 1 7   2 0     0   5   50 57         63       107
1823951 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 92 0 52   1 0     0   2   78 69             *         147 92 0 52   1 0     0   2   78 69                 147
1824762 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000701074 1379 COMPASS PUBLIC CHARTER SCHOOL JR/SR HIGH   Regular School Yes 3.0 07 12 2016   grade_7 92 1 10   0 0     1   5   54 55             24         109 92 1 10   0 0     1   5   54 55         24       109
1305895 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 91 0 2   0 0     1   0   53 41             45         94 91 0 2   0 0     1   0   53 41         45       94
1309600 ID     school 1600174 493   NORTH STAR CHARTER SCHOOL, INC. 160017400803 1371 NORTH STAR CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_7 91 0 3   0 4     1   4   56 47             *         103 91 0 3   0 4     1   4   56 47                 103
1277967 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 90 1 137   2 0     0   6   120 116             *         236 90 1 137   2 0     0   6   120 116                 236
1280187 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000584 236 PAYETTE LAKES MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 90 0 11   1 0     0   2   52 52             38         104 90 0 11   1 0     0   2   52 52         38       104
1682537 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000520 31 SNAKE RIVER JR HIGH SCHOOL   Regular School No 2.0 07 08 2015   grade_7 90 0 19   0 0     1   4   68 46             52         114 90 0 19   0 0     1   4   68 46         52       114
1823022 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000625 98 SOUTH FREMONT JR HIGH   Regular School No 2.0 06 08 2016   grade_7 90 0 17   0 1     1   1   57 53             55         110 90 0 17   0 1     1   1   57 53         55       110
704328 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   grade_7 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
705130 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066001141 1441 MINI-CASSIA ONLINE LEARNING ACADEMY   Regular School No Other KG 12 2021   grade_7 9 0 7   0 0     0   0   9 7             *         16 9 0 7   0 0     0   0   9 7                 16
707096 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12 2021   grade_7 9 0 1   0 0     0   0   6 4             5         10 9 0 1   0 0     0   0   6 4         5       10
707157 ID     school 1600005 453   IDAHO VIRTUAL HIGH SCHOOL, INC. 160000501087 1387 RICHARD MCKENNA CHARTER SCHOOL - MONTESSORI   Regular School Yes Elementary KG 08 2021   grade_7 9 0 4   0 0     0   2   5 10             *         15 9 0 4   0 0     0   2   5 10                 15
1278245 ID     school 1602430 149   NORTH GEM DISTRICT 160243001099 1401 NORTH GEM MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 9 0 0   0 0     1   0   6 4             5         10 9 0 0   0 0     1   0   6 4         5       10
1278367 ID     school 1600750 161   CLARK COUNTY DISTRICT 160075000144 85 CLARK COUNTY JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_7 9 0 6   0 0     0   0   7 8             8         15 9 0 6   0 0     0   0   7 8         8       15
1279342 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2018   grade_7 9 0 0   0 0     0   0   2 7             *         9 9 0 0   0 0     0   0   2 7                 9
1279896 ID     school 1602280 392   MULLAN DISTRICT 160228000405 172 MULLAN SCHOOLS   Regular School No Other KG 12.0 2018   grade_7 9 0 2   0 0     0   0   4 7             5         11 9 0 2   0 0     0   0   4 7         5       11
1280249 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2018   grade_7 9 0 0   0 0     0   0   9 0             *         9 9 0 0   0 0     0   0   9 0                 9
1307401 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative School No High 07 12.0 2019   grade_7 9 0 1   0 0     0   0   6 4             *         10 9 0 1   0 0     0   0   6 4                 10
1307628 ID     school 1600138 243   SALMON RIVER JOINT SCHOOL DISTRICT 160013800944 1281 SALMON RIVER JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_7 9 0 1   0 0     0   0   4 6             *         10 9 0 1   0 0     0   0   4 6                 10
1308042 ID     school 1601740 274   KOOTENAI DISTRICT 160174000303 127 KOOTENAI JR/SR HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_7 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
1308289 ID     school 1602760 316   RICHFIELD DISTRICT 160276000497 144 RICHFIELD SCHOOL   Regular School No Other PK 12.0 2019   grade_7 9 0 3   0 0     0   0   5 7             *         12 9 0 3   0 0     0   0   5 7                 12
1309124 ID     school 1600570 432   CAMBRIDGE JOINT DISTRICT 160057000113 193 CAMBRIDGE MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_7 9 0 0   0 0     0   0   7 2             *         9 9 0 0   0 0     0   0   7 2                 9
1309144 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2019   grade_7 9 0 0   0 0     0   0   6 3             *         9 9 0 0   0 0     0   0   6 3                 9
1685659 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
1727291 ID     school 1600540 121   CAMAS COUNTY DISTRICT 160054000110 440 CAMAS COUNTY ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 8.0 2017   grade_7 9 0 1   0 0     0   1   4 7             5         11 9 0 1   0 0     0   1   4 7         5       11
1727650 ID     school 1600600 139   VALLIVUE SCHOOL DISTRICT 160060001016 1295 RIVERVUE MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2017   grade_7 9 0 14   0 0     0   1   18 6             *         24 9 0 14   0 0     0   1   18 6                 24
1728801 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   0 0     0   1   5 5             *         10 9 0 0   0 0     0   1   5 5                 10
1729135 ID     school 1600870 342   CULDESAC JOINT DISTRICT 160087000164 795 CULDESAC SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   2 0     0   0   9 2             *         11 9 0 0   2 0     0   0   9 2                 11
1729734 ID     school 1602160 433   MIDVALE DISTRICT 160216000857 286 MIDVALE SCHOOL   Regular School No Other PK 12.0 2017   grade_7 9 0 0   0 0     0   0   3 6             *         9 9 0 0   0 0     0   0   3 6                 9
1729954 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014801023 1303 IDAHO CONNECTS ONLINE ALTERNATIVE SCHOOL   Alternative School Yes Other 06 12.0 2017   grade_7 9 0 0   0 0     0   0   5 4             *         9 9 0 0   0 0     0   0   5 4                 9
1822063 ID     school 1603120 92   SWAN VALLEY ELEMENTARY DISTRICT 160312000541 424 SWAN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 9 1 1   0 0     0   0   4 7             *         11 9 1 1   0 0     0   0   4 7                 11
1823786 ID     school 1602400 302   NEZPERCE JOINT DISTRICT 160240000848 272 NEZPERCE SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 9 0 1   0 0     0   1   5 6             *         11 9 0 1   0 0     0   1   5 6                 11
1824895 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014800993 1221 IDAHO CONNECTS ONLINE SCHOOL   Regular School Yes 4.0 06 12 2016   grade_7 9 0 2   0 0     0   0   3 8             *         11 9 0 2   0 0     0   0   3 8                 11
1825049 ID     school 1600170 486   UPPER CARMEN PUBLIC CHARTER SCHOOL, INC. 160017000847 1366 UPPER CARMEN PUBLIC CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_7 9 0 0   0 0     0   0   4 5             *         9 9 0 0   0 0     0   0   4 5                 9
849487 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 89 0 3   0 0     0   0   47 45             49         92 89 0 3   0 0     0   0   47 45         49       92
853036 ID     school 1600156 475   THE SAGE INTERNATIONAL SCHOOL OF BOISE, A PUBLIC CHARTER SCHOOL, INC. 160015601007 1248 SAGE INTERNATIONAL SCHOOL OF BOISE   Regular School Yes Other KG 12 2020   grade_7 89 1 4   0 4     1   3   56 46             23         102 89 1 4   0 4     1   3   56 46         23       102
1306825 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 89 1 149   1 2     1   8   117 134             *         251 89 1 149   1 2     1   8   117 134                 251
1307443 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000625 98 SOUTH FREMONT JR HIGH   Regular School No Middle 06 8.0 2019   grade_7 88 1 23   0 1     0   2   66 49             73         115 88 1 23   0 1     0   2   66 49         73       115
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
1280382 ID     school 1600011 457   INSPIRE ACADEMICS, INC. 160001100866 578 INSPIRE VIRTUAL CHARTER SCHOOL   Regular School Yes Other PK 12.0 2018   grade_7 87 2 8   0 0     0   6   56 47             45         103 87 2 8   0 0     0   6   56 47         45       103
1308376 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 87 0 82   1 0     0   0   87 83             *         170 87 0 82   1 0     0   0   87 83                 170
1683393 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 87 3 138   3 3     0   2   125 111             *         236 87 3 138   3 3     0   2   125 111                 236
1730180 ID     school 1600174 493   NORTH STAR CHARTER SCHOOL, INC. 160017400803 1371 NORTH STAR CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 87 0 6   0 3     0   6   54 48             *         102 87 0 6   0 3     0   6   54 48                 102
704006 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 86 0 87   0 1     0   5   92 87             66         179 86 0 87   0 1     0   5   92 87         66       179
1279505 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 86 0 66   1 0     0   0   75 78             *         153 86 0 66   1 0     0   0   75 78                 153
1280225 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 86 0 41   3 2     0   2   63 71             67         134 86 0 41   3 2     0   2   63 71         67       134
1308677 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_7 86 0 42   2 0     0   3   75 58             58         133 86 0 42   2 0     0   3   75 58         58       133
1685615 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 86 0 39   2 0     0   1   63 65             77         128 86 0 39   2 0     0   1   63 65         77       128
1686080 ID     school 1600174 493   NORTH STAR CHARTER SCHOOL, INC. 160017400803 1371 NORTH STAR CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2015   grade_7 86 0 3   2 3     0   3   49 48             *         97 86 0 3   2 3     0   3   49 48                 97
1726809 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 86 0 3   1 0     0   1   58 33             57         91 86 0 3   1 0     0   1   58 33         57       91
1824643 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 86 0 44   0 1     0   2   58 75             77         133 86 0 44   0 1     0   2   58 75         77       133
703718 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 85 1 3   0 0     0   0   30 59             *         89 85 1 3   0 0     0   0   30 59                 89
707545 ID     school 1600174 493   NORTH STAR CHARTER SCHOOL, INC. 160017400803 1371 NORTH STAR CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_7 85 1 7   0 1     0   2   47 49             *         96 85 1 7   0 1     0   2   47 49                 96
852249 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000455 161 MCCAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 85 0 38   0 0     0   2   71 54             62         125 85 0 38   0 0     0   2   71 54         62       125
853192 ID     school 1600174 493   NORTH STAR CHARTER SCHOOL, INC. 160017400803 1371 NORTH STAR CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_7 85 1 7   0 2     0   6   48 53             *         101 85 1 7   0 2     0   6   48 53                 101
853390 ID     school 1602340 795   IDAHO ARTS CHARTER SCHOOL, INC. 160234000834 577 IDAHO ARTS CHARTER SCHOOL   Regular School Yes Other PK 12 2020   grade_7 85 2 26   0 1     0   5   41 78             51         119 85 2 26   0 1     0   5   41 78         51       119
1824258 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 85 0 37   0 1     0   3   64 62             72         126 85 0 37   0 1     0   3   64 62         72       126
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
706324 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000381 148 EAST MINICO MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 84 1 107   0 0     0   1   95 98             *         193 84 1 107   0 0     0   1   95 98                 193
706629 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 83 1 36   3 0     0   3   60 66             46         126 83 1 36   3 0     0   3   60 66         46       126
1726499 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 83 1 3   0 0     1   0   42 46             45         88 83 1 3   0 0     1   0   42 46         45       88
1727233 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 83 2 4   1 3     1   4   44 54             45         98 83 2 4   1 3     1   4   44 54         45       98
706759 ID     school 1603180 401   TETON COUNTY DISTRICT 160318000544 195 TETON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 82 0 48   0 0     0   2   72 60             43         132 82 0 48   0 0     0   2   72 60         43       132
850229 ID     school 1600420 101   BOUNDARY COUNTY DISTRICT 160042000029 201 BOUNDARY COUNTY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 82 1 4   3 0     0   3   49 44             45         93 82 1 4   3 0     0   3   49 44         45       93
1279685 ID     school 1602490 351   ONEIDA COUNTY DISTRICT 160249000629 618 MALAD MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 82 1 1   0 1     0   0   38 47             *         85 82 1 1   0 1     0   0   38 47                 85
1308741 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000292 170 KELLOGG MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 82 0 3   0 0     1   2   47 41             46         88 82 0 3   0 0     1   2   47 41         46       88
1685279 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000292 170 KELLOGG MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 82 0 4   3 1     0   1   46 45             55         91 82 0 4   3 1     0   1   46 45         55       91
1821321 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 82 0 6   0 0     1   2   53 38             42         91 82 0 6   0 0     1   2   53 38         42       91
1821572 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000520 31 SNAKE RIVER JR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_7 82 0 22   0 0     0   2   54 52             51         106 82 0 22   0 0     0   2   54 52         51       106
852833 ID     school 1600007 455   COMPASS PUBLIC CHARTER SCHOOL, INC. 160000700864 575 COMPASS PUBLIC CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_7 81 1 10   0 1     0   1   43 51             19         94 81 1 10   0 1     0   1   43 51         19       94
1279501 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000381 148 EAST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 81 0 83   0 0     0   2   95 71             *         166 81 0 83   0 0     0   2   95 71                 166
1280548 ID     school 1600156 475   THE SAGE INTERNATIONAL SCHOOL OF BOISE, A PUBLIC CHARTER SCHOOL, INC. 160015601007 1248 SAGE INTERNATIONAL SCHOOL OF BOISE   Regular School Yes Other KG 12.0 2018   grade_7 81 5 5   0 2     1   7   56 45             36         101 81 5 5   0 2     1   7   56 45         36       101
1682771 ID     school 1600001 83   WEST BONNER COUNTY DISTRICT 160000100085 44 PRIEST RIVER JR HIGH SCHOOL   Regular School No 2.0 07 08 2015   grade_7 81 0 1   1 0     1   7   54 37             60         91 81 0 1   1 0     1   7   54 37         60       91
1685859 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes 2.0 04 08 2015   grade_7 81 2 9   0 2     1   1   56 40             40         96 81 2 9   0 2     1   1   56 40         40       96
1824785 ID     school 1600011 457   INSPIRE ACADEMICS, INC. 160001100866 578 INSPIRE VIRTUAL CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2016   grade_7 81 0 7   0 0     0   5   45 48             56         93 81 0 7   0 0     0   5   45 48         56       93
1277034 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 80 0 2   0 0     0   1   36 47             37         83 80 0 2   0 0     0   1   36 47         37       83
1683409 ID     school 1600510 132   CALDWELL DISTRICT 160051000109 281 SYRINGA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 80 0 168   1 1     0   3   140 113             *         253 80 0 168   1 1     0   3   140 113                 253
1729354 ID     school 1601650 391   KELLOGG JOINT DISTRICT 160165000292 170 KELLOGG MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 80 0 3   2 2     0   0   48 39             45         87 80 0 3   2 2     0   0   48 39         45       87
1824604 ID     school 1602030 421   MCCALL-DONNELLY JOINT SCHOOL DISTRICT 160203000584 236 PAYETTE LAKES MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 80 2 7   1 0     0   1   44 47             36         91 80 2 7   1 0     0   1   44 47         36       91
705995 ID     school 1601740 274   KOOTENAI DISTRICT 160174000303 127 KOOTENAI JR/SR HIGH SCHOOL   Regular School No High 06 12 2021   grade_7 8 0 0   0 0     0   0   4 4             *         8 8 0 0   0 0     0   0   4 4                 8
706889 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Not reported M M 2021   grade_7 8 0 4   0 0     0   2   6 8             *         14 8 0 4   0 0     0   2   6 8                 14
707333 ID     school 1600148 469   IDAHO VIRTUAL EDUCATION PARTNERS, INC. 160014800993 1221 IDAHO CONNECTS ONLINE SCHOOL   Regular School Yes High 06 12 2021   grade_7 8 0 1   0 1     0   2   5 7             *         12 8 0 1   0 1     0   2   5 7                 12
707509 ID     school 1600166 488   SYRINGA MOUNTAIN SCHOOL, INC. 160016601066 1367 SYRINGA MOUNTAIN CHARTER SCHOOL   Regular School Yes Elementary KG 08 2021   grade_7 8 0 1   0 0     0   0   4 5             *         9 8 0 1   0 0     0   0   4 5                 9
707746 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12 2021   grade_7 8 0 2   0 0     0   1   3 8             *         11 8 0 2   0 0     0   1   3 8                 11
848824 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_7 8 0 1   1 4     0   0   9 5             *         14 8 0 1   1 4     0   0   9 5                 14
851003 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225001041 1317 BENNETT MOUNTAIN HIGH SCHOOL   Alternative School No High 07 12 2020   grade_7 8 1 1   0 0     0   1   4 7             6         11 8 1 1   0 0     0   1   4 7         6       11

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