Data source: Big Local News · About: Big Local

1,582 rows where grade = "grade_7" and state = "ID" sorted by school descending

View and edit SQL

year

grade

  • grade_7 · 1,582
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
707265 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_7 49 0 7   0 3     0   1   31 29             12         60 49 0 7   0 3     0   1   31 29         12       60
852914 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_7 61 0 4   0 1     0   0   33 33             15         66 61 0 4   0 1     0   0   33 33         15       66
1280434 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other KG 12.0 2018   grade_7 53 0 5   1 3     0   1   25 38             15         63 53 0 5   1 3     0   1   25 38         15       63
1309302 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_7 53 0 4   0 0     0   1   22 36             18         58 53 0 4   0 0     0   1   22 36         18       58
1685808 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2015   grade_7 58 1 2   0 0     0   0   26 35             19         61 58 1 2   0 0     0   0   26 35         19       61
1729888 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes Other PK 12.0 2017   grade_7 53 0 10   0 2     0   2   30 37             22         67 53 0 10   0 2     0   2   30 37         22       67
1824837 ID     school 1600140 462   XAVIER CHARTER SCHOOL, INC. 160014000949 2512 XAVIER CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2016   grade_7 60 0 5   0 1     0   1   29 38             16         67 60 0 5   0 1     0   1   29 38         16       67
705772 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 267 1 23   3 1     1   12   162 146             80         308 267 1 23   3 1     1   12   162 146         80       308
851432 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 235 2 25   1 3     0   8   156 118             94         274 235 2 25   1 3     0   8   156 118         94       274
1278958 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 232 2 23   3 3     0   21   145 139             112         284 232 2 23   3 3     0   21   145 139         112       284
1307828 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 241 1 22   1 2     1   14   156 126             96         282 241 1 22   1 2     1   14   156 126         96       282
1684363 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 216 1 26   0 6     1   20   152 118             123         270 216 1 26   0 6     1   20   152 118         123       270
1728424 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 244 1 31   4 1     1   16   161 137             112         298 244 1 31   4 1     1   16   161 137         112       298
1823415 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000747 246 WOODLAND MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 251 2 23   2 2     0   14   145 149             126         294 251 2 23   2 2     0   14   145 149         126       294
704006 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 86 0 87   0 1     0   5   92 87             66         179 86 0 87   0 1     0   5   92 87         66       179
849743 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 118 1 84   1 1     0   7   106 106             57         212 118 1 84   1 1     0   7   106 106         57       212
1277289 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 156 0 113   1 3     0   6   154 125             92         279 156 0 113   1 3     0   6   154 125         92       279
1306150 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 129 0 104   0 1     0   7   133 108             75         241 129 0 104   0 1     0   7   133 108         75       241
1682715 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 139 0 118   1 5     0   4   131 136             112         267 139 0 118   1 5     0   4   131 136         112       267
1726753 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 133 0 98   1 0     0   2   128 106             96         234 133 0 98   1 0     0   2   128 106         96       234
1821752 ID     school 1600300 61   BLAINE COUNTY DISTRICT 160030000493 984 WOOD RIVER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 138 1 85   0 2     1   9   123 113             92         236 138 1 85   0 2     1   9   123 113         92       236
706649 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 46 1 72   4 0     0   1   63 61             *         124 46 1 72   4 0     0   1   63 61                 124
852303 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 55 1 55   2 0     0   0   57 56             *         113 55 1 55   2 0     0   0   57 56                 113
1279827 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 55 0 57   7 0     0   0   60 59             *         119 55 0 57   7 0     0   0   60 59                 119
1308697 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 54 1 64   1 0     0   0   60 60             *         120 54 1 64   1 0     0   0   60 60                 120
1685234 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 50 0 59   3 1     0   1   63 51             *         114 50 0 59   3 1     0   1   63 51                 114
1729308 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 41 0 52   3 0     1   1   51 47             *         98 41 0 52   3 0     1   1   51 47                 98
1824278 ID     school 1600060 381   AMERICAN FALLS JOINT DISTRICT 160006000589 167 WILLIAM THOMAS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 48 0 49   2 1     0   0   49 51             *         100 48 0 49   2 1     0   0   49 51                 100
704796 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 7 1 33   0 0     0   0   17 24             *         41 7 1 33   0 0     0   0   17 24                 41
850507 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 11 0 20   0 0     0   0   16 15             *         31 11 0 20   0 0     0   0   16 15                 31
1278047 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 10 0 39   0 0     1   1   30 21             26         51 10 0 39   0 0     1   1   30 21         26       51
1306905 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 07 8.0 2019   grade_7 14 1 34   0 0     0   0   19 30             *         49 14 1 34   0 0     0   0   19 30                 49
1727508 ID     school 1603480 133   WILDER DISTRICT 160348001091 1389 WILDER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 11 0 29   0 0     0   0   16 24             21         40 11 0 29   0 0     0   0   16 24         21       40
1683462 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 5 0 17   0 0     0   0   12 10             *         22 5 0 17   0 0     0   0   12 10                 22
1822505 ID     school 1603480 133   WILDER DISTRICT 160348000530 233 WILDER HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 5 0 28   0 0     0   0   15 18             *         33 5 0 28   0 0     0   0   15 18                 33
707291 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Other PK 10 2021   grade_7 48 0 9   0 1     0   7   41 24             27         65 48 0 9   0 1     0   7   41 24         27       65
852939 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Other PK 09 2020   grade_7 51 1 10   1 0     0   4   39 28             17         67 51 1 10   1 0     0   4   39 28         17       67
1280459 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2018   grade_7 27 0 4   0 0     0   2   17 16             9         33 27 0 4   0 0     0   2   17 16         9       33
1309327 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2019   grade_7 30 0 9   0 0     0   3   21 21             15         42 30 0 9   0 0     0   3   21 21         15       42
1685833 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_7 39 0 7   0 1     0   2   30 19             21         49 39 0 7   0 1     0   2   30 19         21       49
1729913 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes Elementary PK 8.0 2017   grade_7 24 0 2   0 1     0   3   19 11             9         30 24 0 2   0 1     0   3   19 11         9       30
1824862 ID     school 1600142 464   WHITE PINE CHARTER SCHOOL, INC. 160014200809 2514 WHITE PINE CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_7 24 1 9   0 0     0   2   19 17             13         36 24 1 9   0 0     0   2   19 17         13       36
706328 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 112 0 82   0 0     0   2   90 106             103         196 112 0 82   0 0     0   2   90 106         103       196
851980 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 93 0 89   2 1     0   2   108 79             118         187 93 0 89   2 1     0   2   108 79         118       187
1279505 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 86 0 66   1 0     0   0   75 78             *         153 86 0 66   1 0     0   0   75 78                 153
1308376 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 87 0 82   1 0     0   0   87 83             *         170 87 0 82   1 0     0   0   87 83                 170
1684904 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 65 2 57   1 1     0   1   62 65             *         127 65 2 57   1 1     0   1   62 65                 127
1728967 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 98 0 76   1 0     0   1   92 84             *         176 98 0 76   1 0     0   1   92 84                 176
1823951 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000389 149 WEST MINICO MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 92 0 52   1 0     0   2   78 69             *         147 92 0 52   1 0     0   2   78 69                 147
704561 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 92 1 81   0 2     1   6   101 82             113         183 92 1 81   0 2     1   6   101 82         113       183
850289 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 112 0 116   1 0     2   14   134 111             185         245 112 0 116   1 0     2   14   134 111         185       245
1277831 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 119 3 117   3 1     1   8   147 105             183         252 119 3 117   3 1     1   8   147 105         183       252
1306688 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 120 2 121   1 1     4   14   134 129             195         263 120 2 121   1 1     4   14   134 129         195       263
1683253 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 117 2 101   3 0     0   8   123 108             184         231 117 2 101   3 0     0   8   123 108         184       231
1727296 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 120 1 99   2 0     1   7   123 107             *         230 120 1 99   2 0     1   7   123 107                 230
1822302 ID     school 1602340 131   NAMPA SCHOOL DISTRICT 160234000422 61 WEST MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 134 4 93   0 0     1   11   136 107             185         243 134 4 93   0 0     1   11   136 107         185       243
703076 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 09 2021   grade_7 197 11 29   1 5     2   8   134 119             82         253 197 11 29   1 5     2   8   134 119         82       253
848867 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 09 2020   grade_7 225 11 50   3 7     0   10   155 151             126         306 225 11 50   3 7     0   10   155 151         126       306
1276421 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2018   grade_7 232 11 30   0 7     1   7   139 149             99         288 232 11 30   0 7     1   7   139 149         99       288
1305277 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Middle 07 9.0 2019   grade_7 218 9 36   1 9     1   9   146 137             89         283 218 9 36   1 9     1   9   146 137         89       283
1681852 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No 2.0 07 09 2015   grade_7 264 9 34   0 12     1   11   155 176             129         331 264 9 34   0 12     1   11   155 176         129       331
1725873 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No Other 07 9.0 2017   grade_7 246 4 39   3 9     3   6   163 147             95         310 246 4 39   3 9     3   6   163 147         95       310
1820882 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000987 676 WEST JUNIOR HIGH   Regular School No 2.0 07 09 2016   grade_7 224 5 25   3 11     3   11   147 135             98         282 224 5 25   3 11     3   11   147 135         98       282
705694 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 42 0 24   0 0     1   1   30 38             30         68 42 0 24   0 0     1   1   30 38         30       68
851355 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 37 0 9   0 0     0   1   22 25             25         47 37 0 9   0 0     0   1   22 25         25       47
1278880 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 25 1 9   0 0     1   1   15 22             18         37 25 1 9   0 0     1   1   15 22         18       37
1307750 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 35 0 18   0 0     0   0   28 25             35         53 35 0 18   0 0     0   0   28 25         35       53
1684286 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 07 08 2015   grade_7 33 1 20   0 0     0   1   25 30             34         55 33 1 20   0 0     0   1   25 30         34       55
1728346 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 07 8.0 2017   grade_7 37 2 8   0 0     0   1   24 24             24         48 37 2 8   0 0     0   1   24 24         24       48
1823339 ID     school 1603400 253   WEST JEFFERSON DISTRICT 160340001053 1315 WEST JEFFERSON MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 35 1 14   0 0     0   4   29 25             27         54 35 1 14   0 0     0   4   29 25         27       54
705470 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 37 0 56   0 0     0   0   51 42             66         93 37 0 56   0 0     0   0   51 42         66       93
851162 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 21 0 49   0 0     1   1   37 35             55         72 21 0 49   0 0     1   1   37 35         55       72
1278688 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_7 35 0 65   0 1     0   0   44 57             *         101 35 0 65   0 1     0   0   44 57                 101
1307560 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_7 39 1 63   1 0     0   1   63 42             77         105 39 1 63   1 0     0   1   63 42         77       105
1684091 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 35 0 49   1 0     0   0   44 41             59         85 35 0 49   1 0     0   0   44 41         59       85
1728151 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_7 27 0 54   0 0     0   0   53 28             *         81 27 0 54   0 0     0   0   53 28                 81
1823141 ID     school 1603360 232   WENDELL DISTRICT 160336000571 104 WENDELL MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 28 0 53   3 0     0   1   40 45             *         85 28 0 53   3 0     0   1   40 45                 85
707052 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 72 0 31   0 0     0   3   49 57             48         106 72 0 31   0 0     0   3   49 57         48       106
852701 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 79 0 43   0 2     1   4   69 60             85         129 79 0 43   0 2     1   4   69 60         85       129
1280225 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 86 0 41   3 2     0   2   63 71             67         134 86 0 41   3 2     0   2   63 71         67       134
1309099 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 96 0 37   1 0     0   2   62 74             71         136 96 0 37   1 0     0   2   62 74         71       136
1685615 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 86 0 39   2 0     0   1   63 65             77         128 86 0 39   2 0     0   1   63 65         77       128
1729691 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 79 0 38   1 0     0   1   54 65             70         119 79 0 38   1 0     0   1   54 65         70       119
1824643 ID     school 1603330 431   WEISER DISTRICT 160333000569 191 WEISER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 86 0 44   0 1     0   2   58 75             77         133 86 0 44   0 1     0   2   58 75         77       133
706739 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No High 07 12 2021   grade_7 32 1 0   0 0     0   0   17 16             14         33 32 1 0   0 0     0   0   17 16         14       33
852393 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No High 07 12 2020   grade_7 31 0 2   0 0     1   1   17 18             24         35 31 0 2   0 0     1   1   17 18         24       35
1279919 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2018   grade_7 38 1 3   0 0     0   2   22 22             30         44 38 1 3   0 0     0   2   22 22         30       44
1308788 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2019   grade_7 30 0 1   0 0     0   1   15 17             19         32 30 0 1   0 0     0   1   15 17         19       32
1685334 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 34 0 1   0 0     0   2   15 22             19         37 34 0 1   0 0     0   2   15 22         19       37
1729402 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No High 07 12.0 2017   grade_7 41 1 1   0 0     0   1   21 23             18         44 41 1 1   0 0     0   1   21 23         18       44
1824370 ID     school 1603300 393   WALLACE DISTRICT 160330000565 174 WALLACE JR/SR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 43 0 2   1 0     0   0   26 20             25         46 43 0 2   1 0     0   0   26 20         25       46
707279 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes Other KG 12 2021   grade_7 46 0 12   0 2     0   1   32 29             15         61 46 0 12   0 2     0   1   32 29         15       61
852928 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes Other KG 12 2020   grade_7 50 0 11   0 0     0   2   36 27             21         63 50 0 11   0 0     0   2   36 27         21       63
1280448 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes Other KG 13.0 2018   grade_7 54 0 8   1 0     0   2   33 32             20         65 54 0 8   1 0     0   2   33 32         20       65
1309316 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes Other KG 12.0 2019   grade_7 61 0 3   0 0     0   4   32 36             22         68 61 0 3   0 0     0   4   32 36         22       68
1685822 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes 4.0 KG 12 2015   grade_7 56 0 6   0 1     0   1   26 38             23         64 56 0 6   0 1     0   1   26 38         23       64
1729902 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes Other KG 13.0 2017   grade_7 46 0 11   0 0     1   1   35 24             27         59 46 0 11   0 0     1   1   35 24         27       59
1824851 ID     school 1600141 463   VISION CHARTER SCHOOL, INC. 160014100942 888 VISION CHARTER SCHOOL   Regular School Yes 4.0 KG 13 2016   grade_7 52 0 6   0 0     0   3   30 31             28         61 52 0 6   0 0     0   3   30 31         28       61
703407 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No Other PK 12 2021   grade_7 200 4 34   3 8     2   5   135 121             41         256 200 4 34   3 8     2   5   135 121         41       256
1682175 ID     school 1602100 2   JOINT SCHOOL DISTRICT NO. 2 160210001070 1374 VIRTUAL SCHOOL HOUSE   Regular School No 1.0 PK 08 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1

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