Data source: Big Local News · About: Big Local

4,725 rows where state = "ID" and year = 2017 sorted by school_state_id

View and edit SQL

grade

year

  • 2017 · 4,725
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
1725567 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 162 15 60   3 12     1   11   150 114             *         264 162 15 60   3 12     1   11   150 114                 264
1725568 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 148 13 52   2 5     2   11   109 124             *         233 148 13 52   2 5     2   11   109 124                 233
1725569 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 191 8 68   2 11     3   5   158 130             *         288 191 8 68   2 11     3   5   158 130                 288
1725570 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 501 36 180   7 28     6   27   417 368             *         785 501 36 180   7 28     6   27   417 368                 785
1725571 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 169 26 18   0 12     1   5   107 124             90         231 169 26 18   0 12     1   5   107 124         90       231
1725572 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 168 26 16   0 9     1   3   117 106             93         223 168 26 16   0 9     1   3   117 106         93       223
1725573 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 162 24 15   1 8     0   6   116 100             85         216 162 24 15   1 8     0   6   116 100         85       216
1725574 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 499 76 49   1 29     2   14   340 330             268         670 499 76 49   1 29     2   14   340 330         268       670
1725575 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 286 2 24   1 11     2   9   143 192             65         335 286 2 24   1 11     2   9   143 192         65       335
1725576 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 261 3 19   1 12     1   10   150 157             55         307 261 3 19   1 12     1   10   150 157         55       307
1725577 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 248 3 21   0 9     1   6   130 158             41         288 248 3 21   0 9     1   6   130 158         41       288
1725578 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 795 8 64   2 32     4   25   423 507             161         930 795 8 64   2 32     4   25   423 507         161       930
1725579 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_7 163 7 43   2 2     1   3   126 95             *         221 163 7 43   2 2     1   3   126 95                 221
1725580 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 136 8 39   1 9     3   8   111 93             *         204 136 8 39   1 9     3   8   111 93                 204
1725581 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_9 137 11 30   3 3     0   2   97 89             *         186 137 11 30   3 3     0   2   97 89                 186
1725582 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   k_12_total 436 26 112   6 14     4   13   334 277             *         611 436 26 112   6 14     4   13   334 277                 611
1725583 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 406 18 28   4 18     6   13   230 263             89         493 406 18 28   4 18     6   13   230 263         89       493
1725584 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 458 19 32   0 32     1   15   282 275             92         557 458 19 32   0 32     1   15   282 275         92       557
1725585 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_12 402 11 42   0 22     2   7   230 256             86         486 402 11 42   0 22     2   7   230 256         86       486
1725586 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2017   k_12_total 1266 48 102   4 72     9   35   742 794             267         1536 1266 48 102   4 72     9   35   742 794         267       1536
1725587 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_10 364 48 83   3 17     2   10   272 255             225         527 364 48 83   3 17     2   10   272 255         225       527
1725588 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_11 356 32 56   2 17     1   10   238 236             *         474 356 32 56   2 17     1   10   238 236                 474
1725589 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_12 376 26 50   4 27     5   3   254 237             171         491 376 26 50   4 27     5   3   254 237         171       491
1725590 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_9 8 19 3   0 5     0   0   19 16             *         35 8 19 3   0 5     0   0   19 16                 35
1725591 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   k_12_total 1104 125 192   9 66     8   23   783 744             588         1527 1104 125 192   9 66     8   23   783 744         588       1527
1725592 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_10 340 30 81   4 19     5   15   261 233             187         494 340 30 81   4 19     5   15   261 233         187       494
1725593 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_11 299 18 64   2 15     6   10   209 205             158         414 299 18 64   2 15     6   10   209 205         158       414
1725594 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   grade_12 293 22 59   2 20     2   7   227 178             127         405 293 22 59   2 20     2   7   227 178         127       405
1725595 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 13.0 2017   k_12_total 932 70 204   8 54     13   32   697 616             472         1313 932 70 204   8 54     13   32   697 616         472       1313
1725896 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 267 11 33   4 20     2   15   169 183             115         352 267 11 33   4 20     2   15   169 183         115       352
1725897 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 283 7 36   3 7     2   14   173 179             108         352 283 7 36   3 7     2   14   173 179         108       352
1725898 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 260 5 37   4 12     1   12   162 169             102         331 260 5 37   4 12     1   12   162 169         102       331
1725899 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 810 23 106   11 39     5   41   504 531             325         1035 810 23 106   11 39     5   41   504 531         325       1035
1725900 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 259 5 58   3 4     0   12   178 163             154         341 259 5 58   3 4     0   12   178 163         154       341
1725901 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 245 5 57   3 9     1   8   167 161             152         328 245 5 57   3 9     1   8   167 161         152       328
1725902 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 276 5 56   3 4     2   10   194 162             176         356 276 5 56   3 4     2   10   194 162         176       356
1725903 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 780 15 171   9 17     3   30   539 486             482         1025 780 15 171   9 17     3   30   539 486         482       1025
1725904 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 298 6 54   3 3     0   11   183 192             137         375 298 6 54   3 3     0   11   183 192         137       375
1725905 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 324 4 75   3 5     2   14   217 210             124         427 324 4 75   3 5     2   14   217 210         124       427
1725906 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_12 303 5 41   4 3     1   12   203 166             104         369 303 5 41   4 3     1   12   203 166         104       369
1725907 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 361 7 77   2 3     1   18   242 227             179         469 361 7 77   2 3     1   18   242 227         179       469
1725908 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2017   k_12_total 1286 22 247   12 14     4   55   845 795             544         1640 1286 22 247   12 14     4   55   845 795         544       1640
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
1726240 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 369 3 48   5 1     1   12   233 206             160         439 369 3 48   5 1     1   12   233 206         160       439
1726241 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 714 5 99   10 3     2   24   454 403             340         857 714 5 99   10 3     2   24   454 403         340       857
1726242 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 323 3 39   3 4     0   7   197 182             147         379 323 3 39   3 4     0   7   197 182         147       379
1726243 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 318 3 24   2 4     1   4   179 177             *         356 318 3 24   2 4     1   4   179 177                 356
1726244 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_12 268 5 47   1 3     1   5   159 171             *         330 268 5 47   1 3     1   5   159 171                 330
1726245 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 364 6 46   2 1     0   9   197 231             *         428 364 6 46   2 1     0   9   197 231                 428
1726246 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2017   k_12_total 1273 17 156   8 12     2   25   732 761             537         1493 1273 17 156   8 12     2   25   732 761         537       1493
1725909 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 351 17 51   1 26     1   15   231 231             152         462 351 17 51   1 26     1   15   231 231         152       462
1725910 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 341 8 44   2 19     3   14   226 205             103         431 341 8 44   2 19     3   14   226 205         103       431
1725911 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_12 333 20 44   2 15     3   20   242 195             115         437 333 20 44   2 15     3   20   242 195         115       437
1725912 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 364 26 64   3 12     1   18   236 252             159         488 364 26 64   3 12     1   18   236 252         159       488
1725913 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2017   k_12_total 1389 71 203   8 72     8   67   935 883             529         1818 1389 71 203   8 72     8   67   935 883         529       1818
1726308 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_10 14 0 0   0 1     0   0   6 9             9         15 14 0 0   0 1     0   0   6 9         9       15
1726309 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_11 14 0 1   0 0     0   0   6 9             *         15 14 0 1   0 0     0   0   6 9                 15
1726310 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_12 14 0 0   0 0     0   0   8 6             *         14 14 0 0   0 0     0   0   8 6                 14
1726311 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 13 0 0   0 0     0   3   7 9             10         16 13 0 0   0 0     0   3   7 9         10       16
1726312 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_8 16 0 3   0 0     1   0   10 10             12         20 16 0 3   0 0     1   0   10 10         12       20
1726313 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_9 20 0 1   0 0     0   0   14 7             14         21 20 0 1   0 0     0   0   14 7         14       21
1726314 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   k_12_total 91 0 5   0 1     1   3   51 50             53         101 91 0 5   0 1     1   3   51 50         53       101
1726323 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 107 2 2   0 0     2   1   67 47             51         114 107 2 2   0 0     2   1   67 47         51       114
1726324 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_8 75 0 4   0 0     1   1   49 32             31         81 75 0 4   0 0     1   1   49 32         31       81
1726325 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   k_12_total 182 2 6   0 0     3   2   116 79             82         195 182 2 6   0 0     3   2   116 79         82       195
1726326 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_10 96 1 3   1 0     0   0   53 48             34         101 96 1 3   1 0     0   0   53 48         34       101
1726327 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_11 78 1 4   1 1     0   1   43 43             27         86 78 1 4   1 1     0   1   43 43         27       86
1726328 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_12 85 0 5   0 0     0   0   47 43             25         90 85 0 5   0 0     0   0   47 43         25       90
1726329 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_9 105 0 2   0 0     0   0   48 59             39         107 105 0 2   0 0     0   0   48 59         39       107
1726330 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2017   k_12_total 364 2 14   2 1     0   1   191 193             125         384 364 2 14   2 1     0   1   191 193         125       384
1726363 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 214 0 19   3 7     2   7   116 136             *         252 214 0 19   3 7     2   7   116 136                 252
1726364 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 215 3 15   3 4     3   5   137 111             *         248 215 3 15   3 4     3   5   137 111                 248
1726365 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 220 1 15   4 4     1   6   140 111             91         251 220 1 15   4 4     1   6   140 111         91       251
1726366 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 649 4 49   10 15     6   18   393 358             265         751 649 4 49   10 15     6   18   393 358         265       751
1726367 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 200 1 27   35 0     0   15   119 159             151         278 200 1 27   35 0     0   15   119 159         151       278
1726368 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 180 3 18   27 0     3   8   127 112             120         239 180 3 18   27 0     3   8   127 112         120       239
1726369 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 182 4 23   35 2     2   3   137 114             114         251 182 4 23   35 2     2   3   137 114         114       251
1726370 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 562 8 68   97 2     5   26   383 385             385         768 562 8 68   97 2     5   26   383 385         385       768
1726371 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 141 2 26   5 2     3   5   101 83             115         184 141 2 26   5 2     3   5   101 83         115       184
1726372 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 162 5 22   1 2     0   4   94 102             115         196 162 5 22   1 2     0   4   94 102         115       196
1726373 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 153 4 28   7 0     0   2   94 100             108         194 153 4 28   7 0     0   2   94 100         108       194
1726374 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 456 11 76   13 4     3   11   289 285             338         574 456 11 76   13 4     3   11   289 285         338       574
1726375 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 200 1 36   4 3     0   8   144 108             136         252 200 1 36   4 3     0   8   144 108         136       252
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
1726377 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 168 2 41   4 1     0   7   118 105             109         223 168 2 41   4 1     0   7   118 105         109       223
1726378 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 545 4 110   14 4     3   21   374 327             370         701 545 4 110   14 4     3   21   374 327         370       701
1726379 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 228 4 26   3 2     1   4   131 137             144         268 228 4 26   3 2     1   4   131 137         144       268
1726380 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 205 2 27   7 0     0   4   125 120             110         245 205 2 27   7 0     0   4   125 120         110       245
1726381 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_12 203 5 26   4 1     0   2   140 101             107         241 203 5 26   4 1     0   2   140 101         107       241
1726382 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 189 0 34   14 1     0   5   133 110             131         243 189 0 34   14 1     0   5   133 110         131       243
1726383 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2017   k_12_total 825 11 113   28 4     1   15   529 468             492         997 825 11 113   28 4     1   15   529 468         492       997
1726384 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_10 326 3 47   22 3     4   10   210 205             135         415 326 3 47   22 3     4   10   210 205         135       415
1726385 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_11 299 2 32   19 3     2   7   191 173             93         364 299 2 32   19 3     2   7   191 173         93       364
1726386 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_12 285 5 26   19 6     5   5   176 175             89         351 285 5 26   19 6     5   5   176 175         89       351
1726387 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2017   grade_9 349 5 35   26 9     4   4   221 211             141         432 349 5 35   26 9     4   4   221 211         141       432
1726388 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2017   k_12_total 1259 15 140   86 21     15   26   798 764             458         1562 1259 15 140   86 21     15   26   798 764         458       1562
1726498 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 76 0 3   0 0     0   1   37 43             41         80 76 0 3   0 0     0   1   37 43         41       80
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
1726500 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 73 0 3   0 0     0   1   34 43             34         77 73 0 3   0 0     0   1   34 43         34       77
1726501 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   k_12_total 232 1 9   0 0     1   2   113 132             120         245 232 1 9   0 0     1   2   113 132         120       245

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