Data source: Big Local News · About: Big Local

1,598 rows where grade = "grade_8" and state = "ID" sorted by school_state_id

View and edit SQL

year

grade

  • grade_8 · 1,598
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
702768 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 117 16 61   0 7     1   13   106 109             91         215 117 16 61   0 7     1   13   106 109         91       215
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
1276116 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 169 15 63   1 12     1   9   154 116             *         270 169 15 63   1 12     1   9   154 116                 270
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
1681545 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_8 161 19 65   3 15     2   6   143 128             180         271 161 19 65   3 15     2   6   143 128         180       271
1725568 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 148 13 52   2 5     2   11   109 124             *         233 148 13 52   2 5     2   11   109 124                 233
1820580 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000051 2 FAIRMONT JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_8 189 8 72   1 10     2   4   154 132             *         286 189 8 72   1 10     2   4   154 132                 286
702772 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 393 30 75   3 27     4   24   262 294             165         556 393 30 75   3 27     4   24   262 294         165       556
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
1276120 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 175 23 19   1 10     0   5   110 123             79         233 175 23 19   1 10     0   5   110 123         79       233
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
1681549 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_8 147 21 12   3 11     5   3   111 91             96         202 147 21 12   3 11     5   3   111 91         96       202
1725572 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 168 26 16   0 9     1   3   117 106             93         223 168 26 16   0 9     1   3   117 106         93       223
1820584 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000057 3 HILLSIDE JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_8 147 20 11   1 8     0   5   112 80             80         192 147 20 11   1 8     0   5   112 80         80       192
702776 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 241 6 22   3 5     0   9   131 155             39         286 241 6 22   3 5     0   9   131 155         39       286
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
1276124 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 292 6 21   1 11     1   9   155 186             59         341 292 6 21   1 11     1   9   155 186         59       341
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
1681553 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_8 228 5 24   1 14     2   7   132 149             67         281 228 5 24   1 14     2   7   132 149         67       281
1725576 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 261 3 19   1 12     1   10   150 157             55         307 261 3 19   1 12     1   10   150 157         55       307
1820588 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000069 4 NORTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_8 233 3 23   0 7     1   7   126 148             45         274 233 3 23   0 7     1   7   126 148         45       274
702780 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 09 2021   grade_8 116 8 42   0 1     2   8   98 79             91         177 116 8 42   0 1     2   8   98 79         91       177
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
1276128 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Middle 07 9.0 2018   grade_8 163 10 42   2 4     1   2   129 95             *         224 163 10 42   2 4     1   2   129 95                 224
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
1681557 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2015   grade_8 159 11 38   4 6     1   3   118 104             155         222 159 11 38   4 6     1   3   118 104         155       222
1725580 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No Other 07 9.0 2017   grade_8 136 8 39   1 9     3   8   111 93             *         204 136 8 39   1 9     3   8   111 93                 204
1820592 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000073 5 SOUTH JUNIOR HIGH SCHOOL   Regular School No 2.0 07 09 2016   grade_8 146 11 30   3 5     0   2   102 95             *         197 146 11 30   3 5     0   2   102 95                 197
703099 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 210 18 27   0 11     0   10   152 124             66         276 210 18 27   0 11     0   10   152 124         66       276
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
1276446 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 287 10 38   1 7     1   11   178 177             98         355 287 10 38   1 7     1   11   178 177         98       355
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
1681877 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 279 15 37   3 13     1   8   185 171             128         356 279 15 37   3 13     1   8   185 171         128       356
1725898 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 260 5 37   4 12     1   12   162 169             102         331 260 5 37   4 12     1   12   162 169         102       331
1820907 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000367 10 LOWELL SCOTT MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 256 16 22   1 7     0   12   159 155             79         314 256 16 22   1 7     0   12   159 155         79       314
703103 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 231 8 63   4 9     0   8   166 157             85         323 231 8 63   4 9     0   8   166 157         85       323
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
1276450 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 254 8 56   3 9     1   9   175 165             133         340 254 8 56   3 9     1   9   175 165         133       340
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
1681881 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 246 8 48   3 5     0   10   166 154             155         320 246 8 48   3 5     0   10   166 154         155       320
1725902 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 276 5 56   3 4     2   10   194 162             176         356 276 5 56   3 4     2   10   194 162         176       356
1820911 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210000370 11 MERIDIAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 253 6 58   2 6     1   13   170 169             119         339 253 6 58   2 6     1   13   170 169         119       339
703458 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 214 1 47   0 2     0   8   147 125             77         272 214 1 47   0 2     0   8   147 125         77       272
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
1276777 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 347 2 49   3 4     1   12   219 199             160         418 347 2 49   3 4     1   12   219 199         160       418
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
1682201 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 342 2 42   0 4     0   7   198 199             166         397 342 2 42   0 4     0   7   198 199         166       397
1726240 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 369 3 48   5 1     1   12   233 206             160         439 369 3 48   5 1     1   12   233 206         160       439
1821238 ID     school 1601770 3   KUNA JOINT DISTRICT 160177000306 13 KUNA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 349 6 48   1 2     0   11   205 212             145         417 349 6 48   1 2     0   11   205 212         145       417
703531 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_8 26 0 0   0 0     0   0   14 12             7         26 26 0 0   0 0     0   0   14 12         7       26
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
1276849 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2018   grade_8 13 0 0   0 0     0   3   9 7             9         16 13 0 0   0 0     0   3   9 7         9       16
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
1682273 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_8 14 0 0   0 0     0   0   6 8             8         14 14 0 0   0 0     0   0   6 8         8       14
1726312 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_8 16 0 3   0 0     1   0   10 10             12         20 16 0 3   0 0     1   0   10 10         12       20
1821310 ID     school 1600840 13   COUNCIL DISTRICT 160084000163 17 COUNCIL JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_8 21 0 0   0 0     0   0   11 10             13         21 21 0 0   0 0     0   0   11 10         13       21
703543 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_8 89 0 3   2 0     0   0   52 42             25         94 89 0 3   2 0     0   0   52 42         25       94
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
1276861 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2018   grade_8 106 2 2   1 0     2   1   72 42             47         114 106 2 2   1 0     2   1   72 42         47       114
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
1682285 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_8 99 1 4   1 0     0   0   54 51             42         105 99 1 4   1 0     0   0   54 51         42       105
1726324 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_8 75 0 4   0 0     1   1   49 32             31         81 75 0 4   0 0     1   1   49 32         31       81
1821322 ID     school 1601950 21   MARSH VALLEY JOINT DISTRICT 160195000348 18 MARSH VALLEY MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_8 106 0 3   0 0     0   0   47 62             40         109 106 0 3   0 0     0   0   47 62         40       109
703584 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 190 2 32   1 6     4   7   131 111             *         242 190 2 32   1 6     4   7   131 111                 242
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
1276902 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 214 2 11   2 3     3   8   124 119             *         243 214 2 11   2 3     3   8   124 119                 243
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
1682326 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 189 4 18   4 4     2   5   103 123             *         226 189 4 18   4 4     2   5   103 123                 226
1726365 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 220 1 15   4 4     1   6   140 111             91         251 220 1 15   4 4     1   6   140 111         91       251
1821363 ID     school 1602640 25   POCATELLO DISTRICT 160264000469 20 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 196 2 21   3 6     2   5   121 114             *         235 196 2 21   3 6     2   5   121 114                 235
703588 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 156 1 35   20 2     2   11   115 112             115         227 156 1 35   20 2     2   11   115 112         115       227
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
1276906 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 167 2 18   27 0     3   4   120 101             99         221 167 2 18   27 0     3   4   120 101         99       221
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
1682330 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 198 0 26   24 2     3   3   137 119             128         256 198 0 26   24 2     3   3   137 119         128       256
1726369 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 182 4 23   35 2     2   3   137 114             114         251 182 4 23   35 2     2   3   137 114         114       251
1821367 ID     school 1602640 25   POCATELLO DISTRICT 160264000471 21 HAWTHORNE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 184 1 26   31 2     0   2   126 120             111         246 184 1 26   31 2     0   2   126 120         111       246
703592 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 178 0 43   4 0     2   4   128 103             119         231 178 0 43   4 0     2   4   128 103         119       231
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
1276910 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 169 4 27   2 2     0   6   102 108             119         210 169 4 27   2 2     0   6   102 108         119       210
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
1682334 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 169 1 21   2 0     3   0   99 97             111         196 169 1 21   2 0     3   0   99 97         111       196
1726373 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 153 4 28   7 0     0   2   94 100             108         194 153 4 28   7 0     0   2   94 100         108       194
1821371 ID     school 1602640 25   POCATELLO DISTRICT 160264000474 22 IRVING MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 152 3 24   8 1     0   4   94 98             106         192 152 3 24   8 1     0   4   94 98         106       192
703596 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 157 2 46   5 1     2   10   113 110             117         223 157 2 46   5 1     2   10   113 110         117       223
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
1276914 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 185 2 36   7 1     3   4   124 114             127         238 185 2 36   7 1     3   4   124 114         127       238
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
1682338 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 182 3 30   3 5     0   5   121 107             135         228 182 3 30   3 5     0   5   121 107         135       228
1726377 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 168 2 41   4 1     0   7   118 105             109         223 168 2 41   4 1     0   7   118 105         109       223
1821375 ID     school 1602640 25   POCATELLO DISTRICT 160264001047 23 ALAMEDA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 164 2 23   5 1     0   6   100 101             114         201 164 2 23   5 1     0   6   100 101         114       201
703719 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 86 0 4   0 0     0   0   47 43             *         90 86 0 4   0 0     0   0   47 43                 90
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
1277035 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_8 86 1 3   0 0     1   0   42 49             44         91 86 1 3   0 0     1   0   42 49         44       91
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
1682461 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 76 0 5   1 1     0   0   42 41             39         83 76 0 5   1 1     0   0   42 41         39       83
1726500 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_8 73 0 3   0 0     0   1   34 43             34         77 73 0 3   0 0     0   1   34 43         34       77
1821496 ID     school 1600240 33   BEAR LAKE COUNTY DISTRICT 160024000017 26 BEAR LAKE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 82 0 5   0 0     1   0   53 35             34         88 82 0 5   0 0     1   0   53 35         34       88
703764 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8 64 0 2   0 0     0   3   37 32             *         69 64 0 2   0 0     0   3   37 32                 69
849522 ID     school 1603060 41   ST MARIES JOINT DISTRICT 160306000534 28 ST MARIES MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8 68 0 1   1 0     0   4   39 35             *         74 68 0 1   1 0     0   4   39 35                 74

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