enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 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 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 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 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 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 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 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 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 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 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 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 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
704774 704774 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO 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
706862 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
849482 849482 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12 2020   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1306882 1306882 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1683450 1683450 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative Education School No 4.0 01 12 2015   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1685458 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
1726496 1726496 ID     school 1602640 25   POCATELLO DISTRICT 160264000186 9034 POCATELLO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_7 1 0 0   0 0     0   0   0 1             *         1 1 0 0   0 0     0   0   0 1                 1
1727487 1727487 ID     school 1600510 132   CALDWELL DISTRICT 160051000043 1087 SOUTHWEST IDAHO JUVENILE DETENTION   Alternative School No Other 01 12.0 2017   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1684264 1684264 ID     school 1602790 252   RIRIE JOINT DISTRICT 160279000435 229 RIRIE ELEMENTARY SCHOOL   Regular School No 1.0 02 08 2015   grade_7 57 0 1   1 0     0   3   30 32             32         62 57 0 1   1 0     0   3   30 32         32       62
1279552 1279552 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2018   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1308423 1308423 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative School No Other 03 12.0 2019   grade_7 0 0 1   0 0     0   0   0 1             *         1 0 0 1   0 0     0   0   0 1                 1
1684950 1684950 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative Education School No 4.0 03 12 2015   grade_7 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1685044 1685044 ID     school 1601860 340   LEWISTON INDEPENDENT DISTRICT 160186000170 1266 REGION 2 JUVENILE DETENTION CENTER   Alternative Education School No 4.0 03 12 2015   grade_7 0 0 0   1 0     0   0   1 0             *         1 0 0 0   1 0     0   0   1 0                 1
1823997 1823997 ID     school 1602190 331   MINIDOKA COUNTY JOINT DISTRICT 160219000166 1100 MINI-CASSIA JUVENILE DETENTION CENTER   Alternative Education School No 4.0 03 12 2016   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
703033 703033 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2021   grade_7 19 0 0   0 1     0   0   9 11             *         20 19 0 0   0 1     0   0   9 11                 20
705846 705846 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
706111 706111 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2021   grade_7 20 0 1   0 0     0   0   8 13             9         21 20 0 1   0 0     0   0   8 13         9       21
706175 706175 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_7 22 0 3   4 0     0   2   19 12             13         31 22 0 3   4 0     0   2   19 12         13       31
707664 707664 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2021   grade_7 12 0 0   0 0     0   1   5 8             7         13 12 0 0   0 0     0   1   5 8         7       13
848824 848824 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12 2020   grade_7 8 0 1   1 4     0   0   9 5             *         14 8 0 1   1 4     0   0   9 5                 14
851506 851506 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12 2020   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
851763 851763 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12 2020   grade_7 14 0 0   0 0     0   0   11 3             8         14 14 0 0   0 0     0   0   11 3         8       14
853290 853290 ID     school 1600186 531   FERN-WATERS PUBLIC CHARTER SCHOOL, INC. 160018601114 1423 FERN-WATERS PUBLIC CHARTER SCHOOL   Regular School Yes Middle 04 08 2020   grade_7 11 0 1   0 0     0   1   5 8             *         13 11 0 1   0 0     0   1   5 8                 13
1276378 1276378 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2018   grade_7 22 0 1   0 7     0   1   23 8             *         31 22 0 1   0 7     0   1   23 8                 31
1279033 1279033 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2018   grade_7 2 0 0   0 0     0   0   2 0             *         2 2 0 0   0 0     0   0   2 0                 2
1279289 1279289 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12.0 2018   grade_7 21 0 1   0 0     0   0   10 12             8         22 21 0 1   0 0     0   0   10 12         8       22
1279355 1279355 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 8.0 2018   grade_7 29 0 0   4 0     0   1   16 18             *         34 29 0 0   4 0     0   1   16 18                 34
1305234 1305234 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2019   grade_7 18 0 1   0 2     0   2   16 7             *         23 18 0 1   0 2     0   2   16 7                 23
1307902 1307902 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative School No Other 04 12.0 2019   grade_7 1 1 0   0 0     0   0   2 0             *         2 1 1 0   0 0     0   0   2 0                 2
1308157 1308157 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12.0 2019   grade_7 20 0 0   0 0     0   0   10 10             10         20 20 0 0   0 0     0   0   10 10         10       20
1308223 1308223 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Middle 04 8.0 2019   grade_7 33 0 4   3 0     0   1   20 21             *         41 33 0 4   3 0     0   1   20 21                 41
1681809 1681809 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2015   grade_7 25 0 1   0 2     0   1   18 11             *         29 25 0 1   0 2     0   1   18 11                 29
1684440 1684440 ID     school 1600780 271   COEUR D'ALENE DISTRICT 160078000704 1038 CDA JUVENILE DETENTION CENTER   Alternative Education School No 4.0 04 12 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1684683 1684683 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No 4.0 04 12 2015   grade_7 15 0 2   1 0     0   0   9 9             8         18 15 0 2   1 0     0   0   9 9         8       18
1685859 1685859 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes 2.0 04 08 2015   grade_7 81 2 9   0 2     1   1   56 40             40         96 81 2 9   0 2     1   1   56 40         40       96
1725830 1725830 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No Other 04 12.0 2017   grade_7 18 2 2   0 6     0   0   15 13             *         28 18 2 2   0 6     0   0   15 13                 28
1728748 1728748 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No Other 04 12.0 2017   grade_7 15 0 1   0 0     0   0   12 4             11         16 15 0 1   0 0     0   0   12 4         11       16
1728814 1728814 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No Elementary 04 8.0 2017   grade_7 38 0 3   6 0     1   2   32 18             *         50 38 0 3   6 0     1   2   32 18                 50
1729939 1729939 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes Elementary 04 8.0 2017   grade_7 45 0 2   0 0     0   3   26 24             12         50 45 0 2   0 0     0   3   26 24         12       50
1820841 1820841 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000823 573 TREASURE VALLEY MATH/SCIENCE   Regular School No 4.0 04 12 2016   grade_7 19 0 1   0 4     0   2   15 11             *         26 19 0 1   0 4     0   2   15 11                 26
1823732 1823732 ID     school 1600010 288   WHITEPINE JOINT SCHOOL DISTRICT 160001000579 794 DEARY SCHOOL   Regular School No 4.0 04 12 2016   grade_7 22 0 2   0 0     0   0   11 13             10         24 22 0 2   0 0     0   0   11 13         10       24
1824888 1824888 ID     school 1600145 468   IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL, INC. 160014500996 1217 IDAHO SCIENCE AND TECHNOLOGY CHARTER SCHOOL   Regular School Yes 2.0 04 08 2016   grade_7 72 1 6   1 0     0   1   37 44             28         81 72 1 6   1 0     0   1   37 44         28       81
703928 703928 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 53 2 10   0 0     0   0   37 28             23         65 53 2 10   0 0     0   0   37 28         23       65
704871 704871 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 61 1 24   0 0     0   2   46 42             37         88 61 1 24   0 0     0   2   46 42         37       88
704993 704993 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 67 0 2   0 1     0   1   35 36             *         71 67 0 2   0 1     0   1   35 36                 71
705470 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
706576 706576 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 65 0 37   0 0     0   2   51 53             60         104 65 0 37   0 0     0   2   51 53         60       104
706629 706629 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7 83 1 36   3 0     0   3   60 66             46         126 83 1 36   3 0     0   3   60 66         46       126
849665 849665 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 62 0 9   2 0     0   0   38 35             29         73 62 0 9   2 0     0   0   38 35         29       73
850583 850583 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 63 0 31   0 1     0   1   46 50             56         96 63 0 31   0 1     0   1   46 50         56       96
850706 850706 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 56 0 3   0 0     0   1   24 36             *         60 56 0 3   0 0     0   1   24 36                 60
851101 851101 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 180 0 29   0 0     1   3   116 97             *         213 180 0 29   0 0     1   3   116 97                 213
851162 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
852239 852239 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 66 0 38   0 0     0   1   55 50             69         105 66 0 38   0 0     0   1   55 50         69       105
852283 852283 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7 100 2 32   0 2     0   1   80 57             40         137 100 2 32   0 2     0   1   80 57         40       137
1276440 1276440 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2018   grade_7 1 0 1   0 0     0   0   2 0             *         2 1 0 1   0 0     0   0   2 0                 2
1277213 1277213 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_7 57 1 16   1 0     0   1   45 31             37         76 57 1 16   1 0     0   1   45 31         37       76
1278124 1278124 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_7 59 0 21   0 0     0   1   43 38             46         81 59 0 21   0 0     0   1   43 38         46       81
1278250 1278250 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_7 69 0 3   0 0     0   2   34 40             *         74 69 0 3   0 0     0   2   34 40                 74
1278626 1278626 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_7 169 1 25   0 3     0   3   110 91             *         201 169 1 25   0 3     0   3   110 91                 201
1278688 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
1279763 1279763 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_7 54 1 29   1 1     0   2   41 47             62         88 54 1 29   1 1     0   2   41 47         62       88
1279807 1279807 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2018   grade_7 110 1 30   2 0     0   1   79 65             64         144 110 1 30   2 0     0   1   79 65         64       144
1305296 1305296 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No High 05 12.0 2019   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1306073 1306073 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_7 56 0 11   1 0     0   0   33 35             36         68 56 0 11   1 0     0   0   33 35         36       68
1306980 1306980 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_7 57 0 31   0 0     0   1   40 49             50         89 57 0 31   0 0     0   1   40 49         50       89
1307104 1307104 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_7 57 0 2   0 0     0   2   26 35             *         61 57 0 2   0 0     0   2   26 35                 61
1307490 1307490 ID     school 1601110 215   FREMONT COUNTY JOINT DISTRICT 160111000912 1271 FIVE-COUNTY DETENTION CENTER   Alternative School No High 05 12.0 2019   grade_7 0 0 0   1 0     0   0   0 1             *         1 0 0 0   1 0     0   0   0 1                 1
1307500 1307500 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_7 164 0 29   0 1     1   14   104 105             104         209 164 0 29   0 1     1   14   104 105         104       209
1307560 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
1308633 1308633 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_7 55 0 44   1 0     0   1   51 50             64         101 55 0 44   1 0     0   1   51 50         64       101
1308677 1308677 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No Middle 05 8.0 2019   grade_7 86 0 42   2 0     0   3   75 58             58         133 86 0 42   2 0     0   3   75 58         58       133
1681871 1681871 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative Education School No 4.0 05 12 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1682640 1682640 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 50 0 7   1 0     0   1   32 27             26         59 50 0 7   1 0     0   1   32 27         26       59
1682880 1682880 ID     school 1600002 84   LAKE PEND OREILLE SCHOOL DISTRICT 160000200604 997 SANDPOINT JUVENILE DETENTION   Alternative Education School No 4.0 05 12 2015   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1683009 1683009 ID     school 1601530 91   IDAHO FALLS DISTRICT 160153000605 1152 3B JUVENILE DETENTION CENTER   Alternative Education School No 4.0 05 12 2015   grade_7 0 0 1   0 0     0   0   1 0             *         1 0 0 1   0 0     0   0   1 0                 1
1683547 1683547 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 54 0 29   0 1     0   1   41 44             53         85 54 0 29   0 1     0   1   41 44         53       85
1683660 1683660 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 58 1 2   0 0     0   0   30 31             28         61 58 1 2   0 0     0   0   30 31         28       61
1684029 1684029 ID     school 1601020 221   EMMETT INDEPENDENT DISTRICT 160102000191 224 EMMETT MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 140 1 22   2 0     0   5   87 83             *         170 140 1 22   2 0     0   5   87 83                 170
1684075 1684075 ID     school 1601260 231   GOODING JOINT DISTRICT 160126000222 102 GOODING MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 62 0 34   1 0     1   0   49 49             *         98 62 0 34   1 0     1   0   49 49                 98
1684091 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
1684752 1684752 ID     school 1601620 304   KAMIAH JOINT DISTRICT 160162000458 232 KAMIAH MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 22 0 4   7 0     1   3   21 16             25         37 22 0 4   7 0     1   3   21 16         25       37
1685163 1685163 ID     school 1601470 370   HOMEDALE JOINT DISTRICT 160147000767 260 HOMEDALE MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 53 0 45   2 0     0   0   48 52             62         100 53 0 45   2 0     0   0   48 52         62       100
1685214 1685214 ID     school 1601140 373   FRUITLAND DISTRICT 160114000213 165 FRUITLAND MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 99 0 36   0 0     0   4   86 53             60         139 99 0 36   0 0     0   4   86 53         60       139
1725893 1725893 ID     school 1600360 1   BOISE INDEPENDENT DISTRICT 160036000708 9002 ADA COUNTY JUVENILE CENTER   Alternative School No Other 05 12.0 2017   grade_7 1 0 0   0 0     0   0   1 0             *         1 1 0 0   0 0     0   0   1 0                 1
1726678 1726678 ID     school 1601080 59   FIRTH DISTRICT 160108000326 155 FIRTH MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_7 43 0 10   1 0     0   1   30 25             24         55 43 0 10   1 0     0   1   30 25         24       55
1727585 1727585 ID     school 1602550 137   PARMA DISTRICT 160255000080 282 PARMA MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_7 60 0 22   0 0     0   3   43 42             55         85 60 0 22   0 0     0   3   43 42         55       85
1727704 1727704 ID     school 1603000 150   SODA SPRINGS JOINT DISTRICT 160300000527 78 TIGERT MIDDLE SCHOOL   Regular School No Middle 05 8.0 2017   grade_7 52 0 2   0 0     0   1   26 29             *         55 52 0 2   0 0     0   1   26 29                 55

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