Data source: Big Local News · About: Big Local

4,737 rows where state = "ID" and year = 2018 sorted by ccd_school_high_grade descending

View and edit SQL

grade

year

  • 2018 · 4,737
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
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
1276116 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 169 15 63   1 12     1   9   154 116             *         270 169 15 63   1 12     1   9   154 116                 270
1276117 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 142 16 49   2 5     3   12   107 122             *         229 142 16 49   2 5     3   12   107 122                 229
1276118 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 475 46 193   5 27     7   28   404 377             *         781 475 46 193   5 27     7   28   404 377                 781
1276119 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 156 25 20   0 8     1   4   112 102             83         214 156 25 20   0 8     1   4   112 102         83       214
1276120 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 175 23 19   1 10     0   5   110 123             79         233 175 23 19   1 10     0   5   110 123         79       233
1276121 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 179 31 15   1 7     1   4   129 109             83         238 179 31 15   1 7     1   4   129 109         83       238
1276122 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 510 79 54   2 25     2   13   351 334             245         685 510 79 54   2 25     2   13   351 334         245       685
1276123 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 277 4 34   0 8     1   11   195 140             67         335 277 4 34   0 8     1   11   195 140         67       335
1276124 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 292 6 21   1 11     1   9   155 186             59         341 292 6 21   1 11     1   9   155 186         59       341
1276125 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 268 4 17   1 11     1   9   149 162             43         311 268 4 17   1 11     1   9   149 162         43       311
1276126 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 837 14 72   2 30     3   29   499 488             169         987 837 14 72   2 30     3   29   499 488         169       987
1276127 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_7 163 11 39   1 8     1   9   118 114             *         232 163 11 39   1 8     1   9   118 114                 232
1276128 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 163 10 42   2 4     1   2   129 95             *         224 163 10 42   2 4     1   2   129 95                 224
1276129 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_9 140 5 38   2 8     3   7   110 93             *         203 140 5 38   2 8     3   7   110 93                 203
1276130 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   k_12_total 466 26 119   5 20     5   18   357 302             *         659 466 26 119   5 20     5   18   357 302                 659
1276145 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000183 206 LES BOIS JUNIOR HIGH SCHOOL   Regular School No Middle 06 9.0 2018   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
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
1276444 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 281 9 38   0 9     1   17   181 174             130         355 281 9 38   0 9     1   17   181 174         130       355
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
1276446 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 287 10 38   1 7     1   11   178 177             98         355 287 10 38   1 7     1   11   178 177         98       355
1276447 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 825 31 103   4 37     4   44   522 526             324         1048 825 31 103   4 37     4   44   522 526         324       1048
1276448 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 275 5 70   4 7     2   9   196 176             174         372 275 5 70   4 7     2   9   196 176         174       372
1276449 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 269 5 56   3 4     0   12   181 168             147         349 269 5 56   3 4     0   12   181 168         147       349
1276450 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 254 8 56   3 9     1   9   175 165             133         340 254 8 56   3 9     1   9   175 165         133       340
1276451 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 798 18 182   10 20     3   30   552 509             454         1061 798 18 182   10 20     3   30   552 509         454       1061
1276462 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 341 1 34   3 4     4   8   210 185             68         395 341 1 34   3 4     4   8   210 185         68       395
1276463 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 391 4 33   2 13     1   14   211 247             64         458 391 4 33   2 13     1   14   211 247         64       458
1276464 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 365 1 34   4 5     0   23   223 209             65         432 365 1 34   4 5     0   23   223 209         65       432
1276465 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000319 106 EAGLE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 1097 6 101   9 22     5   45   644 641             197         1285 1097 6 101   9 22     5   45   644 641         197       1285
1276471 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 262 8 44   1 6     1   22   169 175             129         344 262 8 44   1 6     1   22   169 175         129       344
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
1276473 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 233 10 43   0 9     1   25   160 161             93         321 233 10 43   0 9     1   25   160 161         93       321
1276474 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000638 207 LAKE HAZEL MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 705 26 139   5 24     4   57   485 475             321         960 705 26 139   5 24     4   57   485 475         321       960
1276475 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 243 14 51   3 15     0   22   178 170             128         348 243 14 51   3 15     0   22   178 170         128       348
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
1276477 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 264 10 55   3 14     1   17   184 180             99         364 264 10 55   3 14     1   17   184 180         99       364
1276478 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000795 235 LEWIS & CLARK MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 791 38 165   7 51     3   52   556 551             345         1107 791 38 165   7 51     3   52   556 551         345       1107
1276500 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 295 1 27   0 5     1   10   184 155             77         339 295 1 27   0 5     1   10   184 155         77       339
1276501 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 304 1 35   1 1     1   10   197 156             71         353 304 1 35   1 1     1   10   197 156         71       353
1276502 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 310 2 23   2 3     1   14   168 187             66         355 310 2 23   2 3     1   14   168 187         66       355
1276503 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000819 284 SAWTOOTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 909 4 85   3 9     3   34   549 498             214         1047 909 4 85   3 9     3   34   549 498         214       1047
1276685 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   grade_7 48 0 11   0 1     0   2   36 26             22         62 48 0 11   0 1     0   2   36 26         22       62
1276686 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   grade_8 63 1 9   3 0     0   0   47 29             36         76 63 1 9   3 0     0   0   47 29         36       76
1276687 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000931 594 PATHWAYS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   k_12_total 111 1 20   3 1     0   2   83 55             58         138 111 1 20   3 1     0   2   83 55         58       138
1276710 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   grade_6 28 0 3   0 0     0   0   17 14             15         31 28 0 3   0 0     0   0   17 14         15       31
1276711 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   grade_7 41 1 8   1 1     0   3   33 22             26         55 41 1 8   1 1     0   3   33 22         26       55
1276712 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   grade_8 58 1 6   1 1     0   1   45 23             36         68 58 1 6   1 1     0   1   45 23         36       68
1276713 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000602 1145 CROSSROADS MIDDLE SCHOOL   Alternative School No Middle 06 8.0 2018   k_12_total 127 2 17   2 2     0   4   95 59             77         154 127 2 17   2 2     0   4   95 59         77       154
1276758 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 241 3 25   4 7     0   16   149 147             *         296 241 3 25   4 7     0   16   149 147                 296
1276759 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 231 5 31   0 3     0   9   163 116             41         279 231 5 31   0 3     0   9   163 116         41       279
1276760 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 227 4 29   0 5     1   14   147 133             *         280 227 4 29   0 5     1   14   147 133                 280
1276761 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001084 1384 VICTORY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 699 12 85   4 15     1   39   459 396             116         855 699 12 85   4 15     1   39   459 396         116       855
1276762 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   grade_1 82 1 11   0 2     0   0   47 49             5         96 82 1 11   0 2     0   0   47 49         5       96
1276763 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   grade_2 81 0 6   0 1     1   6   52 43             *         95 81 0 6   0 1     1   6   52 43                 95
1276764 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   grade_3 86 0 9   0 0     0   1   58 38             8         96 86 0 9   0 0     0   1   58 38         8       96
1276765 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   grade_4 82 1 8   1 1     0   3   57 39             *         96 82 1 8   1 1     0   3   57 39                 96
1276766 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   grade_5 86 0 5   0 0     0   4   49 46             5         95 86 0 5   0 0     0   4   49 46         5       95
1276767 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   grade_6 75 0 5   1 2     0   3   47 39             10         86 75 0 5   1 2     0   3   47 39         10       86
1276768 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   grade_7 71 0 3   0 1     0   4   50 29             *         79 71 0 3   0 1     0   4   50 29                 79
1276769 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   grade_8 49 0 2   0 0     0   3   25 29             *         54 49 0 2   0 0     0   3   25 29                 54
1276770 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   k_12_total 694 2 51   2 8     3   30   425 365             54         790 694 2 51   2 8     3   30   425 365         54       790
1276771 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000945 2511 GALILEO MAGNET SCHOOL   Regular School No Elementary PK 8.0 2018   kindergarten 82 0 2   0 1     2   6   40 53             8         93 82 0 2   0 1     2   6   40 53         8       93
1276772 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 389 6 40   4 7     2   19   237 230             66         467 389 6 40   4 7     2   19   237 230         66       467
1276773 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 347 3 30   1 11     1   20   190 223             44         413 347 3 30   1 11     1   20   190 223         44       413
1276774 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 370 6 47   1 8     3   16   231 220             59         451 370 6 47   1 8     3   16   231 220         59       451
1276775 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000958 2513 HERITAGE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 1106 15 117   6 26     6   55   658 673             169         1331 1106 15 117   6 26     6   55   658 673         169       1331
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
1276777 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 347 2 49   3 4     1   12   219 199             160         418 347 2 49   3 4     1   12   219 199         160       418
1276778 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   k_12_total 696 7 104   4 4     6   25   453 393             310         846 696 7 104   4 4     6   25   453 393         310       846
1276806 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Middle 04 8.0 2018   grade_4 83 1 7   0 0     0   6   53 44             47         97 83 1 7   0 0     0   6   53 44         47       97
1276807 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Middle 04 8.0 2018   grade_5 97 0 9   1 0     2   4   63 50             48         113 97 0 9   1 0     2   4   63 50         48       113
1276808 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No Middle 04 8.0 2018   grade_6 95 0 8   0 0     0   3   60 46             43         106 95 0 8   0 0     0   3   60 46         43       106

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