Data source: Big Local News · About: Big Local

2,670 rows where grade = "grade_5" and state = "ID" sorted by ccd_school_low_grade

View and edit SQL

year

grade

  • grade_5 · 2,570
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
852715 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 05 2020   grade_5 65 1 29   0 0     0   4   48 51             56         99 65 1 29   0 0     0   4   48 51         56       99
853288 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   grade_5 10 0 0   0 0     0   0   5 5             *         10 10 0 0   0 0     0   0   5 5                 10
1276803 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Middle 04 6.0 2018   grade_5 66 0 5   0 0     0   4   37 38             35         75 66 0 5   0 0     0   4   37 38         35       75
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
1278304 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000387 216 WHITE PINE ELEMENTARY   Regular School No Middle 04 6.0 2018   grade_5 168 2 142   0 1     0   4   162 155             193         317 168 2 142   0 1     0   4   162 155         193       317
1278916 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 5.0 2018   grade_5 136 1 177   1 0     0   4   155 164             *         319 136 1 177   1 0     0   4   155 164                 319
1279287 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12.0 2018   grade_5 13 0 0   0 0     0   0   11 2             7         13 13 0 0   0 0     0   0   11 2         7       13
1279353 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 8.0 2018   grade_5 22 0 2   6 0     0   4   18 16             *         34 22 0 2   6 0     0   4   18 16                 34
1279433 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 6.0 2018   grade_5 346 3 20   2 6     1   2   198 182             136         380 346 3 20   2 6     1   2   198 182         136       380
1279485 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 6.0 2018   grade_5 139 0 11   0 1     0   2   81 72             69         153 139 0 11   0 1     0   2   81 72         69       153
1279787 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2018   grade_5 77 0 43   0 0     0   2   65 57             *         122 77 0 43   0 0     0   2   65 57                 122
1279848 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2018   grade_5 53 1 56   2 0     0   0   54 58             *         112 53 1 56   2 0     0   0   54 58                 112
1279960 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2018   grade_5 108 0 51   0 0     0   0   84 75             63         159 108 0 51   0 0     0   0   84 75         63       159
1280111 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 6.0 2018   grade_5 109 1 15   0 0     0   5   61 69             *         130 109 1 15   0 0     0   5   61 69                 130
1280239 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 5.0 2018   grade_5 71 0 43   0 2     1   4   68 53             74         121 71 0 43   0 2     1   4   68 53         74       121
1305665 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000915 635 ROSS ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2019   grade_5 138 0 9   0 1     0   4   74 78             70         152 138 0 9   0 1     0   4   74 78         70       152
1307786 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 5.0 2019   grade_5 158 1 204   1 1     1   2   172 196             *         368 158 1 204   1 1     1   2   172 196                 368
1308155 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12.0 2019   grade_5 23 0 1   0 0     0   0   11 13             15         24 23 0 1   0 0     0   0   11 13         15       24
1308221 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 8.0 2019   grade_5 22 0 3   3 0     0   3   20 11             *         31 22 0 3   3 0     0   3   20 11                 31
1308303 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Middle 04 6.0 2019   grade_5 365 2 29   1 2     2   0   214 187             163         401 365 2 29   1 2     2   0   214 187         163       401
1308356 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Middle 04 6.0 2019   grade_5 96 0 12   0 2     1   0   47 64             53         111 96 0 12   0 2     1   0   47 64         53       111
1308657 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2019   grade_5 71 1 43   1 0     0   7   61 62             *         123 71 1 43   1 0     0   7   61 62                 123
1308718 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2019   grade_5 40 1 74   5 0     0   0   62 58             80         120 40 1 74   5 0     0   0   62 58         80       120
1308829 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2019   grade_5 85 0 49   1 0     0   2   69 68             57         137 85 0 49   1 0     0   2   69 68         57       137
1308980 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Middle 04 6.0 2019   grade_5 120 1 21   0 0     0   1   73 70             *         143 120 1 21   0 0     0   1   73 70                 143
1309113 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 5.0 2019   grade_5 82 0 28   0 0     0   3   50 63             61         113 82 0 28   0 0     0   3   50 63         61       113
1682231 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000805 850 FREMONT H TEED MIDDLE SCHOOL   Regular School No 2.0 04 06 2015   grade_5 82 0 6   1 0     1   4   44 50             45         94 82 0 6   1 0     1   4   44 50         45       94
1683702 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000387 216 WHITE PINE ELEMENTARY   Regular School No 2.0 04 06 2015   grade_5 152 0 114   4 0     1   4   146 129             177         275 152 0 114   4 0     1   4   146 129         177       275
1684321 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No 2.0 04 05 2015   grade_5 158 1 147   2 0     0   1   156 153             *         309 158 1 147   2 0     0   1   156 153                 309
1684681 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No 4.0 04 12 2015   grade_5 12 0 0   0 0     0   0   7 5             *         12 12 0 0   0 0     0   0   7 5                 12
1684832 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No 2.0 04 06 2015   grade_5 359 2 25   2 4     1   3   204 192             177         396 359 2 25   2 4     1   3   204 192         177       396
1684884 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No 2.0 04 06 2015   grade_5 103 1 7   0 1     0   0   57 55             53         112 103 1 7   0 1     0   0   57 55         53       112
1685187 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No 2.0 04 05 2015   grade_5 81 0 29   0 0     0   3   55 58             *         113 81 0 29   0 0     0   3   55 58                 113
1685254 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No 2.0 04 05 2015   grade_5 44 0 50   4 0     1   1   53 47             *         100 44 0 50   4 0     1   1   53 47                 100
1685376 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No 2.0 04 05 2015   grade_5 75 0 38   1 0     0   4   74 44             47         118 75 0 38   1 0     0   4   74 44         47       118
1685499 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No 2.0 04 06 2015   grade_5 95 1 15   1 0     0   0   59 53             *         112 95 1 15   1 0     0   0   59 53                 112
1685629 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No 2.0 04 05 2015   grade_5 74 1 35   1 0     0   1   59 53             75         112 74 1 35   1 0     0   1   59 53         75       112
1685857 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes 2.0 04 08 2015   grade_5 21 0 1   0 0     0   0   10 12             7         22 21 0 1   0 0     0   0   10 12         7       22
1727758 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000387 216 WHITE PINE ELEMENTARY   Regular School No Elementary 04 6.0 2017   grade_5 159 0 128   0 1     0   3   153 138             197         291 159 0 128   0 1     0   3   153 138         197       291
1728382 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No Elementary 04 5.0 2017   grade_5 167 1 161   2 0     1   2   184 150             *         334 167 1 161   2 0     1   2   184 150                 334
1728746 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12.0 2017   grade_5 17 0 0   0 0     0   0   8 9             11         17 17 0 0   0 0     0   0   8 9         11       17
1728812 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Elementary 04 8.0 2017   grade_5 34 0 5   6 0     0   1   19 27             *         46 34 0 5   6 0     0   1   19 27                 46
1728893 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No Elementary 04 6.0 2017   grade_5 373 4 26   0 3     0   3   199 210             *         409 373 4 26   0 3     0   3   199 210                 409
1728946 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No Elementary 04 6.0 2017   grade_5 95 1 9   1 0     0   0   61 45             51         106 95 1 9   1 0     0   0   61 45         51       106
1729255 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2017   grade_5 72 0 34   0 0     0   4   61 49             *         110 72 0 34   0 0     0   4   61 49                 110
1729329 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2017   grade_5 49 0 70   1 0     0   1   61 60             *         121 49 0 70   1 0     0   1   61 60                 121
1729442 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No Elementary 04 5.0 2017   grade_5 88 0 41   0 0     0   1   67 63             53         130 88 0 41   0 0     0   1   67 63         53       130
1729576 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No Elementary 04 6.0 2017   grade_5 108 1 8   0 1     0   0   52 66             *         118 108 1 8   0 1     0   0   52 66                 118
1729705 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No Elementary 04 5.0 2017   grade_5 92 0 35   2 0     0   0   57 72             73         129 92 0 35   2 0     0   0   57 72         73       129
1729937 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Elementary 04 8.0 2017   grade_5 35 0 5   1 0     0   0   22 19             20         41 35 0 5   1 0     0   0   22 19         20       41
1822748 ID     school 1600660 151   CASSIA COUNTY JOINT DISTRICT 160066000387 216 WHITE PINE ELEMENTARY   Regular School No 2.0 04 06 2016   grade_5 158 4 125   0 0     0   3   156 134             181         290 158 4 125   0 0     0   3   156 134         181       290
1823373 ID     school 1601590 261   JEROME JOINT DISTRICT 160159000972 2516 SUMMIT ELEMENTARY   Regular School No 2.0 04 05 2016   grade_5 128 0 180   2 0     1   3   154 160             *         314 128 0 180   2 0     1   3   154 160                 314
1823730 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No 4.0 04 12 2016   grade_5 20 0 0   0 0     0   0   10 10             9         20 20 0 0   0 0     0   0   10 10         9       20
1823878 ID     school 1601920 321   MADISON DISTRICT 160192000210 250 MADISON MIDDLE SCHOOL   Regular School No 2.0 04 06 2016   grade_5 380 6 29   2 2     2   3   203 221             171         424 380 6 29   2 2     2   3   203 221         171       424
1823930 ID     school 1603090 322   SUGAR-SALEM JOINT DISTRICT 160309000645 225 KERSHAW INTERMEDIATE SCHOOL   Regular School No 2.0 04 06 2016   grade_5 101 1 10   0 2     0   4   53 65             59         118 101 1 10   0 2     0   4   53 65         59       118
1824225 ID     school 1602580 371   PAYETTE JOINT DISTRICT 160258000456 805 WESTSIDE ELEMENTARY SCHOOL   Regular School No 2.0 04 05 2016   grade_5 61 1 48   0 0     0   2   61 51             *         112 61 1 48   0 0     0   2   61 51                 112
1824298 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000816 849 J.R. SIMPLOT ELEMENTARY SCHOOL   Regular School No 2.0 04 05 2016   grade_5 50 0 62   4 0     0   0   56 60             89         116 50 0 62   4 0     0   0   56 60         89       116
1824408 ID     school 1603180 401   TETON COUNTY DISTRICT 160318001022 1236 RENDEZVOUS UPPER ELEMENTARY SCHOOL   Regular School No 2.0 04 05 2016   grade_5 87 0 35   1 0     0   2   72 53             59         125 87 0 35   1 0     0   2   72 53         59       125
1824528 ID     school 1601050 413   FILER DISTRICT 160105001006 1244 FILER INTERMEDIATE SCHOOL   Regular School No 2.0 04 06 2016   grade_5 101 1 19   0 1     0   3   53 72             *         125 101 1 19   0 1     0   3   53 72                 125
1824657 ID     school 1603330 431   WEISER DISTRICT 160333000566 840 PARK INTERMEDIATE SCHOOL   Regular School No 2.0 04 05 2016   grade_5 89 0 34   4 1     0   2   63 67             74         130 89 0 34   4 1     0   2   63 67         74       130
1824886 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes 2.0 04 08 2016   grade_5 31 1 5   0 0     0   1   19 19             12         38 31 1 5   0 0     0   1   19 19         12       38
703822 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 06 2021   grade_5 121 1 13   1 0     0   2   64 74             *         138 121 1 13   1 0     0   2   64 74                 138
703926 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 75 1 8   0 1     0   0   43 42             33         85 75 1 8   0 1     0   0   43 42         33       85
703949 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 06 2021   grade_5 158 1 19   0 3     0   0   85 96             67         181 158 1 19   0 3     0   0   85 96         67       181
704869 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 48 0 21   1 0     0   3   32 41             36         73 48 0 21   1 0     0   3   32 41         36       73
704991 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 55 0 4   0 1     0   2   41 21             *         62 55 0 4   0 1     0   2   41 21                 62
705298 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000745 556 HACKER MIDDLE SCHOOL   Regular School No Middle 05 06 2021   grade_5 175 7 67   2 2     2   28   150 133             *         283 175 7 67   2 2     2   28   150 133                 283
705468 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 24 0 57   0 0     0   1   49 33             61         82 24 0 57   0 0     0   1   49 33         61       82
706574 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 61 1 26   0 0     0   0   50 38             45         88 61 1 26   0 0     0   0   50 38         45       88
706627 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5 73 0 38   1 1     0   2   62 53             41         115 73 0 38   1 1     0   2   62 53         41       115
849580 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 06 2020   grade_5 113 3 24   1 0     2   1   73 71             48         144 113 3 24   1 0     2   1   73 71         48       144
849663 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 53 1 9   1 1     0   0   27 38             27         65 53 1 9   1 1     0   0   27 38         27       65
849686 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 06 2020   grade_5 161 2 25   0 0     0   0   90 98             87         188 161 2 25   0 0     0   0   90 98         87       188
850581 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 43 0 27   0 0     0   5   36 39             41         75 43 0 27   0 0     0   5   36 39         41       75
850704 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 62 0 2   0 0     0   2   31 35             *         66 62 0 2   0 0     0   2   31 35                 66
850997 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000745 556 HACKER MIDDLE SCHOOL   Regular School No Middle 05 06 2020   grade_5 216 3 79   1 2     3   21   179 146             *         325 216 3 79   1 2     3   21   179 146                 325
851099 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 83 1 19   1 1     0   3   50 58             64         108 83 1 19   1 1     0   3   50 58         64       108
851160 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 39 0 64   1 0     0   0   59 45             77         104 39 0 64   1 0     0   0   59 45         77       104
852237 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 64 0 33   0 0     0   4   50 51             68         101 64 0 33   0 0     0   4   50 51         68       101
852281 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 89 1 41   0 4     0   4   66 73             51         139 89 1 41   0 4     0   4   66 73         51       139
1277128 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 6.0 2018   grade_5 113 0 20   4 0     0   2   73 66             53         139 113 0 20   4 0     0   2   73 66         53       139
1277211 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 53 0 10   2 0     0   0   37 28             34         65 53 0 10   2 0     0   0   37 28         34       65
1277234 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 6.0 2018   grade_5 150 0 30   2 2     0   0   95 89             92         184 150 0 30   2 2     0   0   95 89         92       184
1278122 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 64 0 30   0 1     0   2   47 50             50         97 64 0 30   0 1     0   2   47 50         50       97
1278248 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 50 0 3   0 0     0   1   23 31             *         54 50 0 3   0 0     0   1   23 31                 54
1278522 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000745 556 HACKER MIDDLE SCHOOL   Regular School No Middle 05 6.0 2018   grade_5 208 8 58   3 4     1   18   153 147             164         300 208 8 58   3 4     1   18   153 147         164       300
1278624 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 108 1 15   0 1     0   2   77 50             71         127 108 1 15   0 1     0   2   77 50         71       127
1278686 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 23 0 43   0 0     1   0   37 30             *         67 23 0 43   0 0     1   0   37 30                 67
1279761 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 57 0 39   0 0     0   0   55 41             65         96 57 0 39   0 0     0   0   55 41         65       96
1279805 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_5 104 2 33   0 2     0   0   83 58             66         141 104 2 33   0 2     0   0   83 58         66       141
1305988 ID     school 1602970 52   SNAKE RIVER DISTRICT 160297000644 380 SNAKE RIVER MIDDLE SCHOOL   Regular School No Middle 05 6.0 2019   grade_5 109 1 25   1 0     0   3   79 60             57         139 109 1 25   1 0     0   3   79 60         57       139
1306071 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 46 1 11   0 0     0   0   36 22             26         58 46 1 11   0 0     0   0   36 22         26       58
1306094 ID     school 1602910 60   SHELLEY JOINT DISTRICT 160291000511 392 HAZEL STUART ELEMENTARY SCHOOL   Regular School No Middle 05 6.0 2019   grade_5 169 0 24   0 1     0   1   115 80             75         195 169 0 24   0 1     0   1   115 80         75       195
1306978 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 59 2 23   0 0     0   2   46 40             44         86 59 2 23   0 0     0   2   46 40         44       86
1307102 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 75 0 2   0 1     0   1   38 41             *         79 75 0 2   0 1     0   1   38 41                 79
1307395 ID     school 1602250 193   MOUNTAIN HOME DISTRICT 160225000745 556 HACKER MIDDLE SCHOOL   Regular School No Middle 05 6.0 2019   grade_5 210 5 79   1 2     0   26   167 156             *         323 210 5 79   1 2     0   26   167 156                 323
1307498 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 99 0 19   1 0     0   1   64 56             *         120 99 0 19   1 0     0   1   64 56                 120
1307558 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 34 0 57   0 0     0   0   52 39             67         91 34 0 57   0 0     0   0   52 39         67       91
1308631 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 56 0 38   0 0     0   1   49 46             65         95 56 0 38   0 0     0   1   49 46         65       95
1308675 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_5 97 1 31   3 0     0   2   65 69             53         134 97 1 31   3 0     0   2   65 69         53       134

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