Data source: Big Local News · About: Big Local

33,441 rows where state = "ID" sorted by ccd_school_high_grade descending

View and edit SQL

grade

year

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
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
1276147 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2018   grade_8 182 4 23   6 12     1   7   124 111             *         235 182 4 23   6 12     1   7   124 111                 235
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
1276149 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2018   k_12_total 569 15 70   6 38     6   24   379 349             169         728 569 15 70   6 38     6   24   379 349         169       728
1276150 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 142 7 35   2 6     0   8   106 94             81         200 142 7 35   2 6     0   8   106 94         81       200
1276151 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 148 2 17   5 5     1   4   99 83             60         182 148 2 17   5 5     1   4   99 83         60       182
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
1276153 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 464 11 75   9 15     1   16   310 281             200         591 464 11 75   9 15     1   16   310 281         200       591
1276421 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2018   grade_7 232 11 30   0 7     1   7   139 149             99         288 232 11 30   0 7     1   7   139 149         99       288
1276422 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2018   grade_8 242 3 43   4 9     3   6   166 144             95         310 242 3 43   4 9     3   6   166 144         95       310
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
1276424 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2018   k_12_total 692 17 100   6 25     8   25   452 421             271         873 692 17 100   6 25     8   25   452 421         271       873
1276425 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 203 5 15   0 24     1   7   138 117             48         255 203 5 15   0 24     1   7   138 117         48       255
1276426 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 195 8 17   2 20     1   4   133 114             41         247 195 8 17   2 20     1   4   133 114         41       247
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
1276428 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 582 16 52   2 58     3   18   394 337             134         731 582 16 52   2 58     3   18   394 337         134       731
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
1279426 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 364 3 25   1 5     1   0   205 194             *         399 364 3 25   1 5     1   0   205 194                 399
1279427 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 333 3 33   0 4     4   0   193 184             *         377 333 3 33   0 4     4   0   193 184                 377
1279428 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 1062 10 85   3 11     7   5   596 587             404         1183 1062 10 85   3 11     7   5   596 587         404       1183
1279561 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 162 3 12   3 1     1   3   102 83             *         185 162 3 12   3 1     1   3   102 83                 185
1279562 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 170 3 7   6 3     1   13   118 85             *         203 170 3 7   6 3     1   13   118 85                 203
1279563 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 152 2 10   3 0     0   7   76 98             *         174 152 2 10   3 0     0   7   76 98                 174
1279564 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 484 8 29   12 4     2   23   296 266             173         562 484 8 29   12 4     2   23   296 266         173       562
1279565 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 159 1 9   1 1     0   10   90 91             77         181 159 1 9   1 1     0   10   90 91         77       181
1279566 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 177 0 8   2 3     0   18   95 113             72         208 177 0 8   2 3     0   18   95 113         72       208
1279567 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 150 0 12   5 1     2   8   101 77             59         178 150 0 12   5 1     2   8   101 77         59       178
1279568 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 486 1 29   8 5     2   36   286 281             208         567 486 1 29   8 5     2   36   286 281         208       567
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
1304973 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 156 16 78   1 11     2   11   142 133             106         275 156 16 78   1 11     2   11   142 133         106       275
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
1304975 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 464 51 199   8 30     7   34   428 365             312         793 464 51 199   8 30     7   34   428 365         312       793
1304976 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 167 15 18   0 2     1   8   107 104             64         211 167 15 18   0 2     1   8   107 104         64       211
1304977 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 158 25 22   0 5     1   3   110 104             72         214 158 25 22   0 5     1   3   110 104         72       214
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
1304979 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 495 63 56   2 15     2   17   333 317             205         650 495 63 56   2 15     2   17   333 317         205       650
1304980 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 229 5 24   1 11     0   9   137 142             56         279 229 5 24   1 11     0   9   137 142         56       279
1304981 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 286 6 33   1 8     1   10   204 141             61         345 286 6 33   1 8     1   10   204 141         61       345
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
1304983 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 813 16 80   3 30     2   26   493 477             174         970 813 16 80   3 30     2   26   493 477         174       970
1304984 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 159 14 40   1 10     0   11   119 116             91         235 159 14 40   1 10     0   11   119 116         91       235
1304985 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 161 13 36   1 10     1   7   116 113             93         229 161 13 36   1 10     1   7   116 113         93       229
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
1304987 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 475 38 111   3 24     2   20   353 320             258         673 475 38 111   3 24     2   20   353 320         258       673
1305001 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2019   grade_6 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1305002 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2019   grade_7 210 4 28   2 17     1   5   147 120             55         267 210 4 28   2 17     1   5   147 120         55       267
1305003 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2019   grade_8 203 10 24   0 12     2   15   136 130             69         266 203 10 24   0 12     2   15   136 130         69       266
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
1305005 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2019   k_12_total 594 21 73   7 38     5   29   409 358             177         767 594 21 73   7 38     5   29   409 358         177       767
1305006 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 149 3 24   2 4     0   8   104 86             58         190 149 3 24   2 4     0   8   104 86         58       190
1305007 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 145 8 31   3 5     1   8   104 97             72         201 145 8 31   3 5     1   8   104 97         72       201
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
1305009 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000632 242 RIVERGLEN JR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 436 14 72   8 14     2   21   302 265             187         567 436 14 72   8 14     2   21   302 265         187       567
1305277 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2019   grade_7 218 9 36   1 9     1   9   146 137             89         283 218 9 36   1 9     1   9   146 137         89       283
1305278 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2019   grade_8 223 10 32   0 6     1   8   142 138             81         280 223 10 32   0 6     1   8   142 138         81       280
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
1305280 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2019   k_12_total 678 24 109   3 23     3   25   457 408             260         865 678 24 109   3 23     3   25   457 408         260       865
1305281 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 189 1 15   1 15     1   10   123 109             49         232 189 1 15   1 15     1   10   123 109         49       232
1305282 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 206 4 14   0 22     1   7   139 115             44         254 206 4 14   0 22     1   7   139 115         44       254
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
1305284 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036001002 677 EAST JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 592 13 50   3 57     3   22   394 346             140         740 592 13 50   3 57     3   22   394 346         140       740
1308294 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 377 3 25   0 3     0   2   200 210             *         410 377 3 25   0 3     0   2   200 210                 410
1308295 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 355 2 28   2 3     3   1   184 210             *         394 355 2 28   2 3     3   1   184 210                 394
1308296 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 356 3 26   1 3     1   0   206 184             *         390 356 3 26   1 3     1   0   206 184                 390
1308297 ID     school 1601920 321   MADISON DISTRICT 160192000340 145 MADISON JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 1088 8 79   3 9     4   3   590 604             385         1194 1088 8 79   3 9     4   3   590 604         385       1194
1308426 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   grade_7 179 3 3   2 0     1   1   106 83             *         189 179 3 3   2 0     1   1   106 83                 189
1308427 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 165 3 11   2 1     1   3   104 82             *         186 165 3 11   2 1     1   3   104 82                 186
1308428 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 163 3 7   3 2     1   9   108 80             *         188 163 3 7   3 2     1   9   108 80                 188
1308429 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000328 151 SACAJAWEA MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 507 9 21   7 3     3   13   318 245             149         563 507 9 21   7 3     3   13   318 245         149       563
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
1308431 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   grade_8 157 1 10   1 1     0   11   92 89             68         181 157 1 10   1 1     0   11   92 89         68       181
1308432 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   grade_9 170 0 10   1 2     0   20   96 107             59         203 170 0 10   1 2     0   20   96 107         59       203
1308433 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000322 152 JENIFER MIDDLE SCHOOL   Regular School No Middle 07 9.0 2019   k_12_total 496 3 28   9 4     0   43   282 301             208         583 496 3 28   9 4     0   43   282 301         208       583
1309354 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   grade_1 11 0 0   0 0     0   0   9 2             *         11 11 0 0   0 0     0   0   9 2                 11
1309355 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   grade_2 21 0 1   0 0     0   0   8 14             9         22 21 0 1   0 0     0   0   8 14         9       22
1309356 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   grade_3 18 0 2   1 0     1   0   9 13             8         22 18 0 2   1 0     1   0   9 13         8       22
1309357 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   grade_4 19 0 2   0 0     0   0   14 7             7         21 19 0 2   0 0     0   0   14 7         7       21
1309358 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   grade_5 26 0 5   1 1     0   0   20 13             16         33 26 0 5   1 1     0   0   20 13         16       33
1309359 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   grade_6 47 1 7   4 1     0   0   26 34             25         60 47 1 7   4 1     0   0   26 34         25       60
1309360 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   grade_7 44 0 5   3 0     0   0   29 23             16         52 44 0 5   3 0     0   0   29 23         16       52
1309361 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   grade_8 40 1 2   1 1     0   0   23 22             17         45 40 1 2   1 1     0   0   23 22         17       45
1309362 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   k_12_total 237 3 24   10 3     2   1   145 135             106         280 237 3 24   10 3     2   1   145 135         106       280
1309363 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Other KG 9.0 2019   kindergarten 11 1 0   0 0     1   1   7 7             *         14 11 1 0   0 0     1   1   7 7                 14
1309615 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   grade_1 39 1 5   0 1     0   2   19 29             18         48 39 1 5   0 1     0   2   19 29         18       48
1309616 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   grade_2 44 0 2   0 0     0   2   20 28             11         48 44 0 2   0 0     0   2   20 28         11       48
1309617 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   grade_3 44 0 3   0 0     0   1   23 25             13         48 44 0 3   0 0     0   1   23 25         13       48
1309618 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   grade_4 48 0 1   1 0     0   1   21 30             13         51 48 0 1   1 0     0   1   21 30         13       51
1309619 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   grade_5 48 0 3   0 0     0   3   36 18             16         54 48 0 3   0 0     0   3   36 18         16       54
1309620 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   grade_6 45 0 6   1 1     0   1   22 32             11         54 45 0 6   1 1     0   1   22 32         11       54
1309621 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   grade_7 47 0 1   0 0     0   2   34 16             13         50 47 0 1   0 0     0   2   34 16         13       50
1309622 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   grade_8 47 0 1   1 1     0   0   27 23             14         50 47 0 1   1 1     0   0   27 23         14       50
1309623 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   k_12_total 414 1 27   3 4     0   16   226 239             125         465 414 1 27   3 4     0   16   226 239         125       465
1309624 ID     school 1600175 495   ALTURAS INTERNATIONAL ACADEMY, INC. 160017501082 1385 ALTURAS INTERNATIONAL ACADEMY   Regular School Yes Other KG 9.0 2019   kindergarten 52 0 5   0 1     0   4   24 38             16         62 52 0 5   0 1     0   4   24 38         16       62
1309659 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 9.0 2019   grade_1 21 0 1   0 0     0   1   9 14             11         23 21 0 1   0 0     0   1   9 14         11       23
1309660 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 9.0 2019   grade_2 28 0 1   0 1     0   1   16 15             6         31 28 0 1   0 1     0   1   16 15         6       31
1309661 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 9.0 2019   grade_3 26 0 3   0 0     0   1   15 15             8         30 26 0 3   0 0     0   1   15 15         8       30
1309662 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 9.0 2019   grade_4 26 0 3   0 0     0   0   10 19             *         29 26 0 3   0 0     0   0   10 19                 29
1309663 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 9.0 2019   grade_5 28 0 5   0 0     0   0   20 13             10         33 28 0 5   0 0     0   0   20 13         10       33
1309664 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 9.0 2019   grade_6 26 0 4   0 1     0   1   23 9             8         32 26 0 4   0 1     0   1   23 9         8       32
1309665 ID     school 1600182 513   PROJECT IMPACT STEM ACADEMY, INC. 160018201102 1413 PROJECT IMPACT STEM ACADEMY   Regular School Yes Other KG 9.0 2019   grade_7 26 0 2   0 0     0   0   17 11             *         28 26 0 2   0 0     0   0   17 11                 28

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