Data source: Big Local News · About: Big Local

1,582 rows where grade = "grade_7" and state = "ID" sorted by school_nces_id 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
705018 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2021   grade_7 1 0 1   0 0     0   0   0 2             *         2 1 0 1   0 0     0   0   0 2                 2
706397 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2021   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
850731 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
852047 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1278272 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2018   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1307128 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2019   grade_7 1 0 1   0 0     0   0   1 1             *         2 1 0 1   0 0     0   0   1 1                 2
1308446 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684978 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2015   grade_7 3 0 0   1 0     0   0   3 1             *         4 3 0 0   1 0     0   0   3 1                 4
1685065 ID     school   341   LAPWAI DISTRICT   1050 NORTHWEST CHILDREN'S HOME             2015   grade_7 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1727070 ID     school   92   SWAN VALLEY ELEMENTARY DISTRICT   1014 BORDER DISTRICT - STAR VALLEY ELEMENTARY SCHOOL             2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727726 ID     school   150   SODA SPRINGS JOINT DISTRICT   1026 BORDER DISTRICT FREEDOM - SECONDARY             2017   grade_7 0 0 2   0 0     0   0   2 0             *         2 0 0 2   0 0     0   0   2 0                 2
1729042 ID     school   340   LEWISTON INDEPENDENT DISTRICT   611 NORTHWEST CHILDRENS HOME             2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
707746 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12 2021   grade_7 8 0 2   0 0     0   1   3 8             *         11 8 0 2   0 0     0   1   3 8                 11
853347 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12 2020   grade_7 5 0 2   0 0     0   0   3 4             *         7 5 0 2   0 0     0   0   3 4                 7
1280792 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12.0 2018   grade_7 1 0 1   0 1     0   0   1 2             *         3 1 0 1   0 1     0   0   1 2                 3
1309704 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12.0 2019   grade_7 10 1 1   1 0     0   0   6 7             8         13 10 1 1   1 0     0   0   6 7         8       13
1686125 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2015   grade_7 2 0 0   0 0     0   0   1 1             *         2 2 0 0   0 0     0   0   1 1                 2
1730233 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No Other PK 12.0 2017   grade_7 2 0 2   0 0     0   0   2 2             *         4 2 0 2   0 0     0   0   2 2                 4
1825169 ID     school 1603511 596   IDAHO BUREAU OF EDUCATIONAL SERVICES FOR THE DEAF AND THE BLIND 160351100685 948 IDAHO SCHOOL FOR THE DEAF AND THE BLIND   Special Education School No 4.0 PK 12 2016   grade_7 2 0 1   0 0     0   0   2 1             *         3 2 0 1   0 0     0   0   2 1                 3
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
705330 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 64 0 3   1 0     0   0   37 31             26         68 64 0 3   1 0     0   0   37 31         26       68
851029 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 50 0 1   1 0     0   0   32 20             24         52 50 0 1   1 0     0   0   32 20         24       52
1278554 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 61 0 2   0 1     0   0   34 30             30         64 61 0 2   0 1     0   0   34 30         30       64
1307427 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 70 0 3   0 0     0   0   36 37             34         73 70 0 3   0 0     0   0   36 37         34       73
1683957 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 44 0 3   0 0     0   0   28 19             23         47 44 0 3   0 0     0   0   28 19         23       47
1728018 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 58 0 8   0 0     0   0   40 26             28         66 58 0 8   0 0     0   0   40 26         28       66
1823006 ID     school 1603420 202   WEST SIDE JOINT DISTRICT 160342000412 223 BEUTLER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 51 0 3   0 0     0   0   24 30             31         54 51 0 3   0 0     0   0   24 30         31       54
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
705741 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12 2021   grade_7 20 0 22   0 0     0   0   29 13             22         42 20 0 22   0 0     0   0   29 13         22       42
851401 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12 2020   grade_7 27 0 33   0 0     0   0   27 33             32         60 27 0 33   0 0     0   0   27 33         32       60
1278927 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2018   grade_7 25 0 28   0 0     0   1   29 25             40         54 25 0 28   0 0     0   1   29 25         40       54
1307797 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2019   grade_7 23 0 20   0 0     0   0   27 16             25         43 23 0 20   0 0     0   0   27 16         25       43
1684332 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No 4.0 PK 12 2015   grade_7 25 0 15   0 0     0   0   14 26             26         40 25 0 15   0 0     0   0   14 26         26       40
1728393 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No Other PK 12.0 2017   grade_7 26 0 17   0 0     0   1   20 24             27         44 26 0 17   0 0     0   1   20 24         27       44
1823384 ID     school 1603270 262   VALLEY DISTRICT 160327000558 119 VALLEY SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 36 0 22   0 0     0   0   28 30             35         58 36 0 22   0 0     0   0   28 30         35       58
706889 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Not reported M M 2021   grade_7 8 0 4   0 0     0   2   6 8             *         14 8 0 4   0 0     0   2   6 8                 14
852538 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Not reported M M 2020   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1280067 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2018   grade_7 4 0 0   0 0     0   0   1 3             *         4 4 0 0   0 0     0   0   1 3                 4
1308934 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001105 1402 TWIN FALLS VIRTUAL SCHOOLHOUSE   Regular School No Elementary PK 8.0 2019   grade_7 7 0 0   0 0     0   0   5 2             *         7 7 0 0   0 0     0   0   5 2                 7
706880 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001093 1393 SOUTH HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 126 5 72   3 2     0   0   106 102             87         208 126 5 72   3 2     0   0   106 102         87       208
852534 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001093 1393 SOUTH HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 132 8 81   1 5     1   5   115 118             106         233 132 8 81   1 5     1   5   115 118         106       233
1280058 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001093 1393 SOUTH HILLS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 107 3 76   0 8     1   3   93 105             99         198 107 3 76   0 8     1   3   93 105         99       198
1308925 ID     school 1603240 411   TWIN FALLS DISTRICT 160324001093 1393 SOUTH HILLS MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 134 6 55   0 5     0   4   106 98             *         204 134 6 55   0 5     0   4   106 98                 204
706851 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 07 08 2021   grade_7 16 0 11   0 0     0   0   20 7             14         27 16 0 11   0 0     0   0   20 7         14       27
852505 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 07 08 2020   grade_7 17 0 8   0 0     1   1   20 7             *         27 17 0 8   0 0     1   1   20 7                 27
1280029 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2018   grade_7 12 0 5   1 0     0   1   17 2             *         19 12 0 5   1 0     0   1   17 2                 19
1308898 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2019   grade_7 12 0 13   0 0     0   0   13 12             *         25 12 0 13   0 0     0   0   13 12                 25
1685447 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative Education School No 3.0 07 12 2015   grade_7 28 0 5   0 5     0   0   26 12             *         38 28 0 5   0 5     0   0   26 12                 38
1729512 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative School No Middle 06 8.0 2017   grade_7 18 3 10   1 0     0   0   24 8             *         32 18 3 10   1 0     0   0   24 8                 32
1824478 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000755 1147 BRIDGE ACADEMY   Alternative Education School No 3.0 07 12 2016   grade_7 19 5 8   1 1     0   0   22 12             *         34 19 5 8   1 1     0   0   22 12                 34
706862 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative School No Other 01 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1685458 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000739 1260 SNAKE RIVER JUVENILE DETENTION   Alternative Education School No 4.0 01 12 2015   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
706785 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 162 12 54   3 8     1   4   133 111             111         244 162 12 54   3 8     1   4   133 111         111       244
852439 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 186 6 37   0 5     6   2   132 110             104         242 186 6 37   0 5     6   2   132 110         104       242
1279963 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 150 14 45   1 10     2   6   112 116             *         228 150 14 45   1 10     2   6   112 116                 228
1308832 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 168 8 41   1 3     2   3   118 108             114         226 168 8 41   1 3     2   3   118 108         114       226
1685379 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 204 2 82   1 11     2   4   160 146             147         306 204 2 82   1 11     2   4   160 146         147       306
1729445 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 240 9 87   1 11     2   3   173 180             222         353 240 9 87   1 11     2   3   173 180         222       353
1824411 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000553 176 ROBERT STUART MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 199 9 91   4 13     0   2   160 158             196         318 199 9 91   4 13     0   2   160 158         196       318
706789 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7 227 5 31   4 5     2   7   134 147             76         281 227 5 31   4 5     2   7   134 147         76       281
852443 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7 243 3 34   0 3     0   4   137 150             101         287 243 3 34   0 3     0   4   137 150         101       287
1279967 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2018   grade_7 215 2 32   1 5     2   1   138 120             106         258 215 2 32   1 5     2   1   138 120         106       258
1308836 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2019   grade_7 242 7 38   1 3     4   4   144 155             116         299 242 7 38   1 3     4   4   144 155         116       299
1685383 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 248 7 40   0 4     4   6   150 159             128         309 248 7 40   0 4     4   6   150 159         128       309
1729449 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No Middle 06 8.0 2017   grade_7 264 3 57   2 5     4   4   166 173             *         339 264 3 57   2 5     4   4   166 173                 339
1824415 ID     school 1603240 411   TWIN FALLS DISTRICT 160324000552 177 VERA C O'LEARY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 222 5 37   3 7     1   3   144 134             *         278 222 5 37   3 7     1   3   144 134                 278
706978 ID     school 1603210 416   THREE CREEK JOINT ELEMENTARY DISTRICT 160321000546 835 THREE CREEK ELEM/JR HIGH SCHOOL   Regular School No Elementary PK 08 2021   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 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]);