Data source: Big Local News · About: Big Local

4,856 rows where state = "ID" and year = 2020 sorted by school_state_id

View and edit SQL

grade

year

  • 2020 · 4,856
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
848559 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 163 10 73   1 6     1   13   132 135             147         267 163 10 73   1 6     1   13   132 135         147       267
848560 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_8 162 15 52   5 9     4   15   139 123             152         262 162 15 52   5 9     4   15   139 123         152       262
848561 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 162 14 80   1 12     2   11   141 141             153         282 162 14 80   1 12     2   11   141 141         153       282
848562 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   k_12_total 487 39 205   7 27     7   39   412 399             452         811 487 39 205   7 27     7   39   412 399         452       811
848563 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 155 25 16   0 7     1   12   101 115             76         216 155 25 16   0 7     1   12   101 115         76       216
848564 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_8 162 24 21   0 3     1   9   119 101             75         220 162 24 21   0 3     1   9   119 101         75       220
848565 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 158 26 22   0 5     1   5   113 104             69         217 158 26 22   0 5     1   5   113 104         69       217
848566 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   k_12_total 475 75 59   0 15     3   26   333 320             220         653 475 75 59   0 15     3   26   333 320         220       653
848567 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 288 5 35   4 6     0   13   158 193             64         351 288 5 35   4 6     0   13   158 193         64       351
848568 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_8 250 3 27   1 8     0   9   146 152             53         298 250 3 27   1 8     0   9   146 152         53       298
848569 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 279 7 35   1 7     1   9   195 144             63         339 279 7 35   1 7     1   9   195 144         63       339
848570 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   k_12_total 817 15 97   6 21     1   31   499 489             180         988 817 15 97   6 21     1   31   499 489         180       988
848571 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_7 157 16 54   0 4     2   14   125 122             167         247 157 16 54   0 4     2   14   125 122         167       247
848572 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_8 151 15 36   1 8     1   11   108 115             125         223 151 15 36   1 8     1   11   108 115         125       223
848573 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   grade_9 164 19 31   0 7     1   7   122 107             111         229 164 19 31   0 7     1   7   122 107         111       229
848574 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2020   k_12_total 472 50 121   1 19     4   32   355 344             403         699 472 50 121   1 19     4   32   355 344         403       699
848575 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 481 28 32   3 23     2   14   279 304             100         583 481 28 32   3 23     2   14   279 304         100       583
848576 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 441 21 35   2 19     2   12   269 263             80         532 441 21 35   2 19     2   12   269 263         80       532
848577 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 383 18 25   1 18     1   9   220 235             56         455 383 18 25   1 18     1   9   220 235         56       455
848578 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000044 7 BOISE SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 1305 67 92   6 60     5   35   768 802             236         1570 1305 67 92   6 60     5   35   768 802         236       1570
848579 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 369 27 74   3 12     3   11   283 216             188         499 369 27 74   3 12     3   11   283 216         188       499
848580 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 332 25 62   2 16     6   15   245 213             161         458 332 25 62   2 16     6   15   245 213         161       458
848581 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 336 30 56   3 22     3   9   235 224             *         459 336 30 56   3 22     3   9   235 224                 459
848582 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
848583 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000045 8 BORAH SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 1038 82 193   8 50     12   35   764 654             493         1418 1038 82 193   8 50     12   35   764 654         493       1418
848584 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 302 33 81   3 15     2   17   246 207             186         453 302 33 81   3 15     2   17   246 207         186       453
848585 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 299 25 66   3 10     3   9   212 203             132         415 299 25 66   3 10     3   9   212 203         132       415
848586 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 292 12 80   3 9     3   5   215 189             122         404 292 12 80   3 9     3   5   215 189         122       404
848587 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000047 9 CAPITAL SENIOR HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 893 70 227   9 34     8   31   673 599             440         1272 893 70 227   9 34     8   31   673 599         440       1272
848890 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 276 13 28   3 8     2   14   168 176             104         344 276 13 28   3 8     2   14   168 176         104       344
848891 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 268 17 30   0 12     0   11   179 159             109         338 268 17 30   0 12     0   11   179 159         109       338
848892 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 262 12 38   0 7     0   13   168 164             101         332 262 12 38   0 7     0   13   168 164         101       332
848893 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 806 42 96   3 27     2   38   515 499             314         1014 806 42 96   3 27     2   38   515 499         314       1014
848894 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 327 6 72   3 3     3   15   216 213             159         429 327 6 72   3 3     3   15   216 213         159       429
848895 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 282 7 87   3 8     1   10   207 191             170         398 282 7 87   3 8     1   10   207 191         170       398
848896 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 279 9 71   3 6     2   11   203 178             151         381 279 9 71   3 6     2   11   203 178         151       381
848897 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 888 22 230   9 17     6   36   626 582             480         1208 888 22 230   9 17     6   36   626 582         480       1208
848898 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 385 10 80   6 8     3   12   269 235             118         504 385 10 80   6 8     3   12   269 235         118       504
848899 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 396 8 74   3 13     2   14   262 248             128         510 396 8 74   3 13     2   14   262 248         128       510
848900 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 358 7 75   2 2     0   19   236 227             97         463 358 7 75   2 2     0   19   236 227         97       463
848901 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 411 6 92   2 6     0   14   289 242             159         531 411 6 92   2 6     0   14   289 242         159       531
848902 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000372 12 MERIDIAN HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 1550 31 321   13 29     5   59   1056 952             502         2008 1550 31 321   13 29     5   59   1056 952         502       2008
849228 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 210 3 43   4 1     1   9   140 131             99         271 210 3 43   4 1     1   9   140 131         99       271
849229 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 212 1 48   0 2     0   10   151 122             96         273 212 1 48   0 2     0   10   151 122         96       273
849230 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 189 1 40   4 4     3   6   137 110             70         247 189 1 40   4 4     3   6   137 110         70       247
849231 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 611 5 131   8 7     4   25   428 363             265         791 611 5 131   8 7     4   25   428 363         265       791
849232 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 368 3 55   4 7     2   11   230 220             137         450 368 3 55   4 7     2   11   230 220         137       450
849233 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 349 4 45   4 2     0   12   217 199             87         416 349 4 45   4 2     0   12   217 199         87       416
849234 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 302 7 51   3 2     0   6   169 202             84         371 302 7 51   3 2     0   6   169 202         84       371
849235 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 386 5 60   1 2     4   16   260 214             150         474 386 5 60   1 2     4   16   260 214         150       474
849236 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000307 14 KUNA HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 1405 19 211   12 13     6   45   876 835             458         1711 1405 19 211   12 13     6   45   876 835         458       1711
848903 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 445 24 81   4 20     2   21   306 291             148         597 445 24 81   4 20     2   21   306 291         148       597
848904 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 365 23 62   2 20     2   20   257 237             112         494 365 23 62   2 20     2   20   257 237         112       494
848905 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 338 33 45   2 13     1   17   231 218             104         449 338 33 45   2 13     1   17   231 218         104       449
848906 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 425 28 72   3 34     2   22   299 287             157         586 425 28 72   3 34     2   22   299 287         157       586
848907 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000674 15 CENTENNIAL HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 1573 108 260   11 87     7   80   1093 1033             521         2126 1573 108 260   11 87     7   80   1093 1033         521       2126
849294 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_10 13 0 0   0 0     0   1   6 8             6         14 13 0 0   0 0     0   1   6 8         6       14
849295 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_11 14 0 2   0 0     0   1   8 9             6         17 14 0 2   0 0     0   1   8 9         6       17
849296 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_12 12 0 0   0 0     0   0   7 5             5         12 12 0 0   0 0     0   0   7 5         5       12
849297 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 23 0 0   0 0     0   0   13 10             10         23 23 0 0   0 0     0   0   13 10         10       23
849298 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_8 25 0 0   0 0     0   1   15 11             14         26 25 0 0   0 0     0   1   15 11         14       26
849299 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_9 28 0 0   0 0     0   2   14 16             12         30 28 0 0   0 0     0   2   14 16         12       30
849300 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   k_12_total 115 0 2   0 0     0   5   63 59             53         122 115 0 2   0 0     0   5   63 59         53       122
849309 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_7 94 1 2   1 0     0   0   52 46             37         98 94 1 2   1 0     0   0   52 46         37       98
849310 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2020   grade_8 111 0 4   1 0     1   1   57 61             38         118 111 0 4   1 0     1   1   57 61         38       118
849311 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2020   k_12_total 205 1 6   2 0     1   1   109 107             75         216 205 1 6   2 0     1   1   109 107         75       216
849312 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12 2020   grade_10 116 2 2   1 1     0   0   71 51             40         122 116 2 2   1 1     0   0   71 51         40       122
849313 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12 2020   grade_11 77 0 4   0 1     1   0   52 31             28         83 77 0 4   0 1     1   0   52 31         28       83
849314 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12 2020   grade_12 91 0 2   1 0     0   1   42 53             21         95 91 0 2   1 0     0   1   42 53         21       95
849315 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12 2020   grade_9 109 2 5   1 0     0   1   63 55             33         118 109 2 5   1 0     0   1   63 55         33       118
849316 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000347 19 MARSH VALLEY HIGH SCHOOL   Regular School No High 07 12 2020   k_12_total 393 4 13   3 2     1   2   228 190             122         418 393 4 13   3 2     1   2   228 190         122       418
849349 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 207 0 24   2 0     3   10   122 124             87         246 207 0 24   2 0     3   10   122 124         87       246
849350 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 207 1 26   1 5     5   10   138 117             96         255 207 1 26   1 5     5   10   138 117         96       255
849351 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 235 2 29   2 3     1   13   145 140             93         285 235 2 29   2 3     1   13   145 140         93       285
849352 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 649 3 79   5 8     9   33   405 381             276         786 649 3 79   5 8     9   33   405 381         276       786
849353 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 189 0 27   33 1     1   5   114 142             131         256 189 0 27   33 1     1   5   114 142         131       256
849354 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 163 1 39   19 3     1   8   121 113             119         234 163 1 39   19 3     1   8   121 113         119       234
849355 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 184 0 25   19 1     0   10   125 114             100         239 184 0 25   19 1     0   10   125 114         100       239
849356 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 536 1 91   71 5     2   23   360 369             350         729 536 1 91   71 5     2   23   360 369         350       729
849357 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 187 0 29   7 0     1   9   119 114             125         233 187 0 29   7 0     1   9   119 114         125       233
849358 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 183 0 45   5 1     1   3   124 114             122         238 183 0 45   5 1     1   3   124 114         122       238
849359 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 155 1 30   1 0     1   13   96 105             97         201 155 1 30   1 0     1   13   96 105         97       201
849360 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 525 1 104   13 1     3   25   339 333             344         672 525 1 104   13 1     3   25   339 333         344       672
849361 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 172 2 43   4 0     2   8   121 110             107         231 172 2 43   4 0     2   8   121 110         107       231
849362 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 161 1 42   6 1     3   8   114 108             120         222 161 1 42   6 1     3   8   114 108         120       222
849363 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 170 0 28   7 1     1   8   112 103             91         215 170 0 28   7 1     1   8   112 103         91       215
849364 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 503 3 113   17 2     6   24   347 321             318         668 503 3 113   17 2     6   24   347 321         318       668
849365 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 219 5 27   8 0     2   9   124 146             102         270 219 5 27   8 0     2   9   124 146         102       270
849366 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 174 4 36   11 1     0   2   112 116             90         228 174 4 36   11 1     0   2   112 116         90       228
849367 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 188 0 33   6 1     0   4   125 107             83         232 188 0 33   6 1     0   4   125 107         83       232
849368 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 286 3 47   8 2     2   13   180 181             148         361 286 3 47   8 2     2   13   180 181         148       361
849369 ID     school 1602640 25   POCATELLO DISTRICT 160264000478 24 POCATELLO HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 867 12 143   33 4     4   28   541 550             423         1091 867 12 143   33 4     4   28   541 550         423       1091
849370 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12 2020   grade_10 302 3 37   23 3     5   10   206 177             99         383 302 3 37   23 3     5   10   206 177         99       383
849371 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12 2020   grade_11 317 1 35   21 6     5   2   194 193             110         387 317 1 35   21 6     5   2   194 193         110       387
849372 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12 2020   grade_12 318 4 23   13 10     4   3   195 180             85         375 318 4 23   13 10     4   3   195 180         85       375
849373 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12 2020   grade_9 331 1 30   25 6     2   13   201 207             127         408 331 1 30   25 6     2   13   201 207         127       408
849374 ID     school 1602640 25   POCATELLO DISTRICT 160264000472 25 HIGHLAND HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 1268 9 125   82 25     16   28   796 757             421         1553 1268 9 125   82 25     16   28   796 757         421       1553
849486 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 94 1 5   0 0     0   1   34 67             41         101 94 1 5   0 0     0   1   34 67         41       101
849487 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 89 0 3   0 0     0   0   47 45             49         92 89 0 3   0 0     0   0   47 45         49       92
849488 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 86 0 3   0 0     0   0   50 39             36         89 86 0 3   0 0     0   0   50 39         36       89

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