Data source: Big Local News · About: Big Local

4,796 rows where state = "ID" and year = 2019 sorted by school_state_id

View and edit SQL

grade

year

  • 2019 · 4,796
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
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
1304988 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 438 29 31   1 18     3   13   268 265             92         533 438 29 31   1 18     3   13   268 265         92       533
1304989 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 409 24 27   1 18     1   9   239 250             71         489 409 24 27   1 18     1   9   239 250         71       489
1304990 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 390 12 29   3 19     6   8   218 249             70         467 390 12 29   3 19     6   8   218 249         70       467
1304991 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 1237 65 87   5 55     10   30   725 764             233         1489 1237 65 87   5 55     10   30   725 764         233       1489
1304992 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 350 24 72   2 17     9   18   276 216             194         492 350 24 72   2 17     9   18   276 216         194       492
1304993 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 381 33 65   4 23     1   11   278 240             161         518 381 33 65   4 23     1   11   278 240         161       518
1304994 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 357 29 62   4 17     2   7   244 234             *         478 357 29 62   4 17     2   7   244 234                 478
1304995 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 0 7 0   0 0     0   0   4 3             *         7 0 7 0   0 0     0   0   4 3                 7
1304996 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 1088 93 199   10 57     12   36   802 693             519         1495 1088 93 199   10 57     12   36   802 693         519       1495
1304997 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 313 24 74   4 7     3   13   220 218             141         438 313 24 74   4 7     3   13   220 218         141       438
1304998 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 313 13 79   2 9     2   7   225 200             139         425 313 13 79   2 9     2   7   225 200         139       425
1304999 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 303 37 64   6 20     3   13   235 211             129         446 303 37 64   6 20     3   13   235 211         129       446
1305000 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 929 74 217   12 36     8   33   680 629             409         1309 929 74 217   12 36     8   33   680 629         409       1309
1305300 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 287 14 33   0 12     0   16   199 163             118         362 287 14 33   0 12     0   16   199 163         118       362
1305301 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 264 9 35   0 7     0   14   173 156             102         329 264 9 35   0 7     0   14   173 156         102       329
1305302 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 268 11 27   3 20     1   15   168 177             92         345 268 11 27   3 20     1   15   168 177         92       345
1305303 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 819 34 95   3 39     1   45   540 496             312         1036 819 34 95   3 39     1   45   540 496         312       1036
1305304 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 297 8 82   3 8     1   9   216 192             160         408 297 8 82   3 8     1   9   216 192         160       408
1305305 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 272 8 76   3 6     1   11   198 179             158         377 272 8 76   3 6     1   11   198 179         158       377
1305306 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 287 5 61   2 6     0   13   180 194             154         374 287 5 61   2 6     0   13   180 194         154       374
1305307 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 856 21 219   8 20     2   33   594 565             472         1159 856 21 219   8 20     2   33   594 565         472       1159
1305308 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 422 13 66   4 11     2   15   285 248             150         533 422 13 66   4 11     2   15   285 248         150       533
1305309 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 370 7 73   2 4     0   19   237 238             116         475 370 7 73   2 4     0   19   237 238         116       475
1305310 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 282 8 44   2 6     0   14   177 179             87         356 282 8 44   2 6     0   14   177 179         87       356
1305311 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 369 10 79   4 7     3   13   260 225             131         485 369 10 79   4 7     3   13   260 225         131       485
1305312 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 1443 38 262   12 28     5   61   959 890             484         1849 1443 38 262   12 28     5   61   959 890         484       1849
1305638 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 249 1 49   0 1     0   13   161 152             121         313 249 1 49   0 1     0   13   161 152         121       313
1305639 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 224 0 46   4 4     3   5   147 139             89         286 224 0 46   4 4     3   5   147 139         89       286
1305640 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 249 4 49   1 1     4   9   164 153             103         317 249 4 49   1 1     4   9   164 153         103       317
1305641 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 722 5 144   5 6     7   27   472 444             313         916 722 5 144   5 6     7   27   472 444         313       916
1305642 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 371 3 43   5 3     1   12   233 205             *         438 371 3 43   5 3     1   12   233 205                 438
1305643 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 325 6 43   3 4     0   6   175 212             97         387 325 6 43   3 4     0   6   175 212         97       387
1305644 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 277 5 43   2 3     0   6   167 169             *         336 277 5 43   2 3     0   6   167 169                 336
1305645 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 377 4 53   3 7     1   11   235 221             *         456 377 4 53   3 7     1   11   235 221                 456
1305646 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 1350 18 182   13 17     2   35   810 807             431         1617 1350 18 182   13 17     2   35   810 807         431       1617
1305313 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 399 21 83   2 18     3   30   288 268             145         556 399 21 83   2 18     3   30   288 268         145       556
1305314 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 353 39 66   2 15     1   16   245 247             122         492 353 39 66   2 15     1   16   245 247         122       492
1305315 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 336 24 43   1 27     2   13   240 206             114         446 336 24 43   1 27     2   13   240 206         114       446
1305316 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 447 19 81   6 21     2   21   310 287             160         597 447 19 81   6 21     2   21   310 287         160       597
1305317 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 1535 103 273   11 81     8   80   1083 1008             541         2091 1535 103 273   11 81     8   80   1083 1008         541       2091
1305704 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_10 15 1 4   0 0     1   0   9 12             14         21 15 1 4   0 0     1   0   9 12         14       21
1305705 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_11 17 0 0   0 0     0   0   10 7             9         17 17 0 0   0 0     0   0   10 7         9       17
1305706 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_12 10 0 0   0 0     0   0   3 7             5         10 10 0 0   0 0     0   0   3 7         5       10
1305707 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_7 28 0 0   0 0     0   1   14 15             20         29 28 0 0   0 0     0   1   14 15         20       29
1305708 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_8 28 0 2   0 0     0   3   15 18             18         33 28 0 2   0 0     0   3   15 18         18       33
1305709 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 17 0 0   0 0     0   3   10 10             11         20 17 0 0   0 0     0   3   10 10         11       20
1305710 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   k_12_total 115 1 6   0 0     1   7   61 69             77         130 115 1 6   0 0     1   7   61 69         77       130
1305719 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 111 0 5   2 0     1   1   59 61             42         120 111 0 5   2 0     1   1   59 61         42       120
1305720 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_8 102 2 5   1 0     0   0   64 46             42         110 102 2 5   1 0     0   0   64 46         42       110
1305721 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   k_12_total 213 2 10   3 0     1   1   123 107             84         230 213 2 10   3 0     1   1   123 107         84       230
1305722 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_10 76 0 6   0 0     1   1   56 28             27         84 76 0 6   0 0     1   1   56 28         27       84
1305723 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_11 94 0 2   0 1     0   0   44 53             25         97 94 0 2   0 1     0   0   44 53         25       97
1305724 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_12 93 1 3   1 0     0   0   49 49             26         98 93 1 3   1 0     0   0   49 49         26       98
1305725 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_9 112 2 2   1 0     1   1   70 49             47         119 112 2 2   1 0     1   1   70 49         47       119
1305726 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12.0 2019   k_12_total 375 3 13   2 1     2   2   219 179             125         398 375 3 13   2 1     2   2   219 179         125       398
1305759 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 202 1 30   2 4     4   7   129 121             *         250 202 1 30   2 4     4   7   129 121                 250
1305760 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 235 0 27   2 3     1   13   148 133             103         281 235 0 27   2 3     1   13   148 133         103       281
1305761 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 212 0 13   1 7     1   9   107 136             *         243 212 0 13   1 7     1   9   107 136                 243
1305762 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 649 1 70   5 14     6   29   384 390             268         774 649 1 70   5 14     6   29   384 390         268       774
1305763 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 166 1 39   24 3     1   10   130 114             126         244 166 1 39   24 3     1   10   130 114         126       244
1305764 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 198 0 27   22 1     0   10   136 122             124         258 198 0 27   22 1     0   10   136 122         124       258
1305765 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 203 1 38   32 0     0   12   119 167             147         286 203 1 38   32 0     0   12   119 167         147       286
1305766 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 567 2 104   78 4     1   32   385 403             397         788 567 2 104   78 4     1   32   385 403         397       788
1305767 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 180 0 40   5 1     1   4   118 113             140         231 180 0 40   5 1     1   4   118 113         140       231
1305768 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 149 1 28   1 0     1   15   98 97             *         195 149 1 28   1 0     1   15   98 97                 195
1305769 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 154 2 30   5 2     3   9   108 97             *         205 154 2 30   5 2     3   9   108 97                 205
1305770 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 483 3 98   11 3     5   28   324 307             352         631 483 3 98   11 3     5   28   324 307         352       631
1305771 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 169 2 47   5 1     2   8   120 114             134         234 169 2 47   5 1     2   8   120 114         134       234
1305772 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 172 0 29   8 1     1   7   112 106             103         218 172 0 29   8 1     1   7   112 106         103       218
1305773 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 212 1 33   5 3     1   7   151 111             124         262 212 1 33   5 3     1   7   151 111         124       262
1305774 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   k_12_total 553 3 109   18 5     4   22   383 331             361         714 553 3 109   18 5     4   22   383 331         361       714
1305775 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 192 5 41   10 1     0   3   133 119             119         252 192 5 41   10 1     0   3   133 119         119       252
1305776 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 188 0 36   6 1     0   4   128 107             92         235 188 0 36   6 1     0   4   128 107         92       235
1305777 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 207 4 29   2 2     1   4   119 130             99         249 207 4 29   2 2     1   4   119 130         99       249
1305778 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 226 5 36   8 1     2   8   137 149             128         286 226 5 36   8 1     2   8   137 149         128       286
1305779 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 813 14 142   26 5     3   19   517 505             438         1022 813 14 142   26 5     3   19   517 505         438       1022
1305780 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_10 315 1 36   27 7     5   5   204 192             127         396 315 1 36   27 7     5   5   204 192         127       396
1305781 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_11 324 3 29   14 10     5   3   197 191             97         388 324 3 29   14 10     5   3   197 191         97       388
1305782 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_12 299 3 38   11 3     5   10   196 173             98         369 299 3 38   11 3     5   10   196 173         98       369
1305783 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2019   grade_9 327 2 32   23 2     5   9   218 182             128         400 327 2 32   23 2     5   9   218 182         128       400
1305784 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12.0 2019   k_12_total 1265 9 135   75 22     20   27   815 738             450         1553 1265 9 135   75 22     20   27   815 738         450       1553
1305894 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 91 0 3   0 0     0   0   47 47             48         94 91 0 3   0 0     0   0   47 47         48       94
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
1305896 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_8 80 0 5   1 0     0   1   39 48             39         87 80 0 5   1 0     0   1   39 48         39       87

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