Data source: Big Local News · About: Big Local

2,037 rows where grade = "grade_6" and state = "ID" sorted by school_state_id

View and edit SQL

year

grade

  • grade_6 · 2,037
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
703097 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 200 5 17   1 9     0   6   112 126             58         238 200 5 17   1 9     0   6   112 126         58       238
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
1276444 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 281 9 38   0 9     1   17   181 174             130         355 281 9 38   0 9     1   17   181 174         130       355
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
1681875 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 268 8 33   3 12     2   14   174 166             133         340 268 8 33   3 12     2   14   174 166         133       340
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
1820905 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 297 10 36   5 8     2   15   184 189             109         373 297 10 36   5 8     2   15   184 189         109       373
703101 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 247 5 69   4 1     1   10   173 164             98         337 247 5 69   4 1     1   10   173 164         98       337
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
1276448 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 275 5 70   4 7     2   9   196 176             174         372 275 5 70   4 7     2   9   196 176         174       372
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
1681879 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 280 5 53   2 7     3   8   185 173             198         358 280 5 53   2 7     3   8   185 173         198       358
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
1820909 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 276 6 60   3 8     1   9   188 175             159         363 276 6 60   3 8     1   9   188 175         159       363
703456 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 177 2 62   1 1     1   8   120 132             83         252 177 2 62   1 1     1   8   120 132         83       252
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
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
703582 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 181 3 20   3 4     2   14   107 120             95         227 181 3 20   3 4     2   14   107 120         95       227
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
1276900 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 225 1 30   2 3     1   12   137 137             103         274 225 1 30   2 3     1   12   137 137         103       274
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
1682324 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 210 1 16   6 4     1   4   137 105             100         242 210 1 16   6 4     1   4   137 105         100       242
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
1821361 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 204 3 17   4 2     1   5   127 109             92         236 204 3 17   4 2     1   5   127 109         92       236
703586 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 156 1 28   27 0     1   11   109 115             110         224 156 1 28   27 0     1   11   109 115         110       224
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
1276904 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 187 0 26   20 0     0   10   124 119             116         243 187 0 26   20 0     0   10   124 119         116       243
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
1682328 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 187 3 21   35 2     1   3   132 120             145         252 187 3 21   35 2     1   3   132 120         145       252
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
1821365 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 190 2 18   27 0     3   9   133 116             135         249 190 2 18   27 0     3   9   133 116         135       249
703590 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 185 0 26   4 1     2   12   129 101             120         230 185 0 26   4 1     2   12   129 101         120       230
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
1276908 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 144 2 24   2 0     1   18   94 97             112         191 144 2 24   2 0     1   18   94 97         112       191
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
1682332 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 171 4 30   6 0     1   3   101 114             126         215 171 4 30   6 0     1   3   101 114         126       215
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
1821369 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 153 5 19   1 2     1   2   92 91             105         183 153 5 19   1 2     1   2   92 91         105       183
703594 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 148 0 28   1 1     4   12   97 97             93         194 148 0 28   1 1     4   12   97 97         93       194
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
1276912 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 190 0 28   10 0     1   6   128 107             133         235 190 0 28   10 0     1   6   128 107         133       235
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
1682336 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 175 2 36   3 1     0   6   116 107             130         223 175 2 36   3 1     0   6   116 107         130       223
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
1821373 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 196 3 31   7 0     4   7   119 129             159         248 196 3 31   7 0     4   7   119 129         159       248
703717 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 72 0 0   0 0     0   0   37 35             *         72 72 0 0   0 0     0   0   37 35                 72
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
1277033 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 87 0 2   0 0     1   0   48 42             43         90 87 0 2   0 0     1   0   48 42         43       90
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
1682459 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 78 0 6   0 0     0   2   38 48             41         86 78 0 6   0 0     0   2   38 48         41       86
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
1821494 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 78 1 3   0 0     1   0   40 43             45         83 78 1 3   0 0     1   0   40 43         45       83
703762 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 58 1 4   1 1     0   5   41 29             *         70 58 1 4   1 1     0   5   41 29                 70
849520 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 60 0 1   0 1     0   7   37 32             *         69 60 0 1   0 1     0   7   37 32                 69
1277068 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 59 0 1   2 0     1   5   37 31             *         68 59 0 1   2 0     1   5   37 31                 68
1305928 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 53 0 1   0 0     0   5   30 29             *         59 53 0 1   0 0     0   5   30 29                 59
1682493 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 59 0 2   0 0     0   0   26 35             *         61 59 0 2   0 0     0   0   26 35                 61
1726533 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 53 0 2   1 0     0   2   31 27             *         58 53 0 2   1 0     0   2   31 27                 58
1821529 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 51 0 1   2 0     0   3   32 25             *         57 51 0 1   2 0     0   3   32 25                 57
703835 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 0 0 0   1 0     0   0   0 1             *         1 0 0 0   1 0     0   0   0 1                 1
849583 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 0 0 1   1 0     0   0   2 0             *         2 0 0 1   1 0     0   0   2 0                 2
1277131 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1305991 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 0 0 0   2 0     0   0   1 1             *         2 0 0 0   2 0     0   0   1 1                 2
1726596 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 1 0 2   0 0     0   0   2 1             *         3 1 0 2   0 0     0   0   2 1                 3
1821591 ID     school 1600270 55   BLACKFOOT DISTRICT 160027000023 33 MOUNTAIN VIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
1277793 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 38 0 1   0 0     0   0   24 15             14         39 38 0 1   0 0     0   0   24 15         14       39
1683213 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 41 1 1   1 0     0   0   25 19             23         44 41 1 1   1 0     0   0   25 19         23       44
1727257 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 32 0 1   2 0     0   0   24 11             18         35 32 0 1   2 0     0   0   24 11         18       35
1822263 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000662 58 BUTTE COUNTY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 37 0 3   2 0     0   0   21 21             25         42 37 0 3   2 0     0   0   21 21         25       42
1306654 ID     school 1600490 111   BUTTE COUNTY JOINT DISTRICT 160049000008 59 BUTTE COUNTY MIDDLE/HIGH SCHOOL   Regular School No High 06 12.0 2019   grade_6 30 0 3   0 0     0   0   19 14             20         33 30 0 3   0 0     0   0   19 14         20       33
704560 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 91 0 87   0 0     1   9   103 85             118         188 91 0 87   0 0     1   9   103 85         118       188
850288 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 108 1 82   0 4     1   11   110 97             171         207 108 1 82   0 4     1   11   110 97         171       207
1277830 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 127 0 121   0 2     2   14   128 138             210         266 127 0 121   0 2     2   14   128 138         210       266
1306687 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 118 0 113   1 0     1   13   131 115             194         246 118 0 113   1 0     1   13   131 115         194       246
1683252 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 144 3 101   0 0     1   8   151 106             205         257 144 3 101   0 0     1   8   151 106         205       257
1727295 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 116 2 115   4 1     1   9   148 100             *         248 116 2 115   4 1     1   9   148 100                 248
1822301 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 134 1 108   1 0     2   5   138 113             202         251 134 1 108   1 0     2   5   138 113         202       251
704564 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 162 1 71   0 0     0   6   114 126             92         240 162 1 71   0 0     0   6   114 126         92       240
850292 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 155 2 78   1 4     0   8   120 128             130         248 155 2 78   1 4     0   8   120 128         130       248
1277834 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 180 2 75   0 3     1   7   142 126             153         268 180 2 75   0 3     1   7   142 126         153       268
1306691 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 173 1 80   1 0     0   8   143 120             138         263 173 1 80   1 0     0   8   143 120         138       263
1683256 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 158 1 80   3 3     2   10   127 130             *         257 158 1 80   3 3     2   10   127 130                 257
1727299 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 189 5 79   1 1     1   10   156 130             *         286 189 5 79   1 1     1   10   156 130                 286
1822305 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000419 62 SOUTH MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 207 1 79   1 2     3   4   149 148             169         297 207 1 79   1 2     3   4   149 148         169       297
704716 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 71 0 99   0 0     0   5   80 95             *         175 71 0 99   0 0     0   5   80 95                 175
850427 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 77 0 158   1 2     1   6   119 126             *         245 77 0 158   1 2     1   6   119 126                 245
1277966 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 89 1 157   1 2     0   7   122 135             *         257 89 1 157   1 2     0   7   122 135                 257
1306824 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 82 0 155   1 0     0   6   124 120             100         244 82 0 155   1 0     0   6   124 120         100       244
1683392 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 97 2 118   2 2     0   4   112 113             *         225 97 2 118   2 2     0   4   112 113                 225
1727429 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 80 1 149   1 0     0   8   120 119             *         239 80 1 149   1 0     0   8   120 119                 239
1822435 ID     school 1600510 132   CALDWELL DISTRICT 160051000105 64 JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 78 0 138   1 2     0   5   114 110             *         224 78 0 138   1 2     0   5   114 110                 224
704799 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6 243 0 35   2 1     0   7   141 147             78         288 243 0 35   2 1     0   7   141 147         78       288
850510 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6 256 2 51   2 0     1   8   166 154             *         320 256 2 51   2 0     1   8   166 154                 320
1278050 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_6 258 1 36   1 0     1   6   153 150             134         303 258 1 36   1 0     1   6   153 150         134       303
1306908 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_6 262 1 45   1 1     1   6   176 141             121         317 262 1 45   1 1     1   6   176 141         121       317
1683473 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 270 1 45   0 1     4   9   182 148             154         330 270 1 45   0 1     4   9   182 148         154       330
1727511 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_6 255 0 52   0 0     1   14   168 154             142         322 255 0 52   0 0     1   14   168 154         142       322
1822518 ID     school 1602130 134   MIDDLETON DISTRICT 160213000378 67 MIDDLETON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 233 1 33   0 0     1   9   140 137             *         277 233 1 33   0 0     1   9   140 137                 277
704992 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6 60 0 2   0 0     0   2   32 32             *         64 60 0 2   0 0     0   2   32 32                 64
850705 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6 72 0 1   0 1     0   1   35 40             *         75 72 0 1   0 1     0   1   35 40                 75

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